participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,959 rows where station_code = "NL0001" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5571739 | 5571739 | 20241121003842_K4xyA | NL0001 | 2024-11-22T14:17:36.705Z | 2024-11-22T14:19:22.183Z |
5571439 | 5571439 | 20241120234703_Ivcov | NL0001 | 2024-11-22T14:17:06.852Z | 2024-11-22T14:19:22.125Z |
5565164 | 5565164 | 20241120035815_42Tfz | NL0001 | 2024-11-21T14:18:34.606Z | 2024-11-22T14:21:42.773Z |
5564801 | 5564801 | 20241120032758_BcIru | NL0001 | 2024-11-21T14:18:05.065Z | 2024-11-22T14:21:36.686Z |
5563615 | 5563615 | 20241120015308_iDU0z | NL0001 | 2024-11-21T14:16:29.586Z | 2024-11-22T14:21:20.111Z |
5563147 | 5563147 | 20241120005837_oCvLp | NL0001 | 2024-11-21T14:15:38.454Z | 2024-11-22T14:21:10.150Z |
5563011 | 5563011 | 20241120004050_BpDo1 | NL0001 | 2024-11-21T14:15:31.805Z | 2024-11-22T14:21:07.782Z |
5530366 | 5530366 | 20241112021202_T5AaC | NL0001 | 2024-11-13T14:14:11.538Z | 2024-11-20T14:25:58.003Z |
5469679 | 5469679 | 20241103040007_n9Oao | NL0001 | 2024-11-04T14:16:48.419Z | 2024-11-11T14:23:01.967Z |
5469669 | 5469669 | 20241103035924_1qc5u | NL0001 | 2024-11-04T14:16:45.843Z | 2024-11-11T14:23:01.882Z |
5469555 | 5469555 | 20241103034335_QB2Ln | NL0001 | 2024-11-04T14:16:35.855Z | 2024-11-11T14:23:01.065Z |
5469464 | 5469464 | 20241103033206_OrYD9 | NL0001 | 2024-11-04T14:16:29.864Z | 2024-11-11T14:23:00.449Z |
5469292 | 5469292 | 20241103030419_XWWyG | NL0001 | 2024-11-04T14:16:15.344Z | 2024-11-11T14:22:59.471Z |
5469050 | 5469050 | 20241103022849_aTPa6 | NL0001 | 2024-11-04T14:15:29.084Z | 2024-11-11T14:22:57.628Z |
5468498 | 5468498 | 20241103004744_taWSy | NL0001 | 2024-11-04T14:14:13.318Z | 2024-11-11T14:22:53.879Z |
5468038 | 5468038 | 20241102231912_gcqpg | NL0001 | 2024-11-04T14:13:09.624Z | 2024-11-11T14:22:51.029Z |
5467986 | 5467986 | 20241102230912_jlja9 | NL0001 | 2024-11-04T14:13:04.803Z | 2024-11-11T14:22:50.666Z |
5451269 | 5451269 | 20241031231804_8WyIT | NL0001 | 2024-11-02T12:16:47.096Z | 2024-11-09T14:24:22.805Z |
5450858 | 5450858 | 20241031212218_MUbI1 | NL0001 | 2024-11-02T12:16:05.102Z | 2024-11-09T14:24:19.428Z |
5450496 | 5450496 | 20241031193006_r2rbJ | NL0001 | 2024-11-02T12:15:31.447Z | 2024-11-09T14:24:16.184Z |
5450306 | 5450306 | 20241031183718_bSYjT | NL0001 | 2024-11-02T12:14:55.480Z | 2024-11-09T14:24:15.347Z |
5450247 | 5450247 | 20241031182500_KC3Cb | NL0001 | 2024-11-02T12:14:50.945Z | 2024-11-09T14:24:14.916Z |
5421247 | 5421247 | 20241028051606_UHQlv | NL0001 | 2024-10-30T12:19:45.536Z | 2024-11-05T14:27:17.891Z |
5421194 | 5421194 | 20241028050357_2dKZr | NL0001 | 2024-10-30T12:19:41.517Z | 2024-11-05T14:27:17.702Z |
5420841 | 5420841 | 20241028034358_XETY9 | NL0001 | 2024-10-30T12:19:21.555Z | 2024-11-05T14:27:16.485Z |
5420646 | 5420646 | 20241028031149_EAN2F | NL0001 | 2024-10-30T12:19:07.876Z | 2024-11-05T14:27:15.955Z |
5420433 | 5420433 | 20241028024158_cstY5 | NL0001 | 2024-10-30T12:18:51.290Z | 2024-11-05T14:27:15.407Z |
5419631 | 5419631 | 20241028003158_88a5b | NL0001 | 2024-10-30T12:17:40.288Z | 2024-11-05T14:27:13.591Z |
5419432 | 5419432 | 20241028000009_LKkpa | NL0001 | 2024-10-30T12:17:26.736Z | 2024-11-05T14:27:13.049Z |
5419272 | 5419272 | 20241027232651_RKZU5 | NL0001 | 2024-10-30T12:17:18.138Z | 2024-11-05T14:27:12.677Z |
5418871 | 5418871 | 20241027221712_A51G3 | NL0001 | 2024-10-30T12:16:25.225Z | 2024-11-05T14:27:11.525Z |
5418810 | 5418810 | 20241027220002_0Rc5k | NL0001 | 2024-10-30T12:16:14.780Z | 2024-11-05T14:27:11.266Z |
5418010 | 5418010 | 20241027193952_1kjDI | NL0001 | 2024-10-30T12:14:44.590Z | 2024-11-05T14:27:08.850Z |
5417983 | 5417983 | 20241027193632_8dZt1 | NL0001 | 2024-10-30T12:14:42.140Z | 2024-11-05T14:27:08.779Z |
5417669 | 5417669 | 20241027185937_5euCc | NL0001 | 2024-10-30T12:14:09.444Z | 2024-11-05T14:27:08.066Z |
5417641 | 5417641 | 20241027185629_Yrwjd | NL0001 | 2024-10-30T12:14:04.516Z | 2024-11-05T14:27:07.865Z |
5417585 | 5417585 | 20241027184905_3aaZL | NL0001 | 2024-10-30T12:13:54.253Z | 2024-11-05T14:27:07.683Z |
5417445 | 5417445 | 20241027183433_e1XcA | NL0001 | 2024-10-30T12:13:41.191Z | 2024-11-05T14:27:07.284Z |
5399892 | 5399892 | 20241026051049_7iHBL | NL0001 | 2024-10-28T12:20:15.278Z | 2024-11-03T14:27:40.684Z |
5399625 | 5399625 | 20241026044135_3G3FS | NL0001 | 2024-10-28T12:20:04.409Z | 2024-11-03T14:27:40.093Z |
5399485 | 5399485 | 20241026042701_EeRyd | NL0001 | 2024-10-28T12:20:00.534Z | 2024-11-03T14:27:39.843Z |
5395295 | 5395295 | 20241025223033_7yTKw | NL0001 | 2024-10-28T12:16:05.031Z | 2024-11-03T14:27:24.747Z |
5394794 | 5394794 | 20241025212837_uZ9pJ | NL0001 | 2024-10-28T12:15:25.891Z | 2024-11-03T14:27:22.778Z |
5394543 | 5394543 | 20241025204755_If8Vd | NL0001 | 2024-10-28T12:14:52.848Z | 2024-11-03T14:27:21.514Z |
5387137 | 5387137 | 20241025020403_1Uedy | NL0001 | 2024-10-27T12:20:55.531Z | 2024-11-02T12:28:32.153Z |
5383287 | 5383287 | 20241024180414_gzztk | NL0001 | 2024-10-27T12:15:07.897Z | 2024-11-02T12:28:24.884Z |
5383175 | 5383175 | 20241024175055_cawIp | NL0001 | 2024-10-27T12:14:52.983Z | 2024-11-02T12:28:24.762Z |
5383066 | 5383066 | 20241024173945_g6Y2P | NL0001 | 2024-10-27T12:14:43.487Z | 2024-11-02T12:28:24.659Z |
5377567 | 5377567 | 20241024045745_vXcwG | NL0001 | 2024-10-26T12:22:41.043Z | 2024-11-01T12:27:02.608Z |
5377167 | 5377167 | 20241024043638_Gj7fV | NL0001 | 2024-10-26T12:22:29.694Z | 2024-11-01T12:27:02.251Z |
5376925 | 5376925 | 20241024042317_jM382 | NL0001 | 2024-10-26T12:22:17.106Z | 2024-11-01T12:27:01.917Z |
5376703 | 5376703 | 20241024040940_dG8Bx | NL0001 | 2024-10-26T12:22:10.668Z | 2024-11-01T12:27:01.746Z |
5376486 | 5376486 | 20241024035751_W5NbA | NL0001 | 2024-10-26T12:22:03.084Z | 2024-11-01T12:27:01.569Z |
5375315 | 5375315 | 20241024030608_wrjlD | NL0001 | 2024-10-26T12:21:19.960Z | 2024-11-01T12:27:00.501Z |
5375166 | 5375166 | 20241024030029_ugGKT | NL0001 | 2024-10-26T12:21:15.492Z | 2024-11-01T12:27:00.312Z |
5375026 | 5375026 | 20241024025404_Zc9PJ | NL0001 | 2024-10-26T12:21:10.228Z | 2024-11-01T12:27:00.120Z |
5374842 | 5374842 | 20241024024555_6c7bG | NL0001 | 2024-10-26T12:21:03.409Z | 2024-11-01T12:27:00.009Z |
5374521 | 5374521 | 20241024023111_wleQ7 | NL0001 | 2024-10-26T12:20:51.899Z | 2024-11-01T12:26:59.456Z |
5374023 | 5374023 | 20241024020556_HEgyK | NL0001 | 2024-10-26T12:20:34.730Z | 2024-11-01T12:26:58.626Z |
5373085 | 5373085 | 20241024012301_HqJ3z | NL0001 | 2024-10-26T12:19:56.343Z | 2024-11-01T12:26:58.126Z |
5372516 | 5372516 | 20241024005240_bAPrq | NL0001 | 2024-10-26T12:19:28.118Z | 2024-11-01T12:26:57.500Z |
5372382 | 5372382 | 20241024004620_gaTFa | NL0001 | 2024-10-26T12:19:22.998Z | 2024-11-01T12:26:57.424Z |
5372333 | 5372333 | 20241024004441_nJvu7 | NL0001 | 2024-10-26T12:19:20.891Z | 2024-11-01T12:26:57.395Z |
5372070 | 5372070 | 20241024003024_x23jr | NL0001 | 2024-10-26T12:19:05.779Z | 2024-11-01T12:26:57.082Z |
5366564 | 5366564 | 20241023024714_JzZnq | NL0001 | 2024-10-25T12:21:16.904Z | 2024-10-31T12:30:06.351Z |
5366514 | 5366514 | 20241023022731_qOERN | NL0001 | 2024-10-25T12:21:11.759Z | 2024-10-31T12:30:05.869Z |
5366216 | 5366216 | 20241024000926_D2dTl | NL0001 | 2024-10-25T12:18:19.327Z | 2024-11-01T12:26:56.797Z |
5366134 | 5366134 | 20241024000703_XNHdn | NL0001 | 2024-10-25T12:18:17.523Z | 2024-11-01T12:26:56.766Z |
5366045 | 5366045 | 20241024000220_gzqPY | NL0001 | 2024-10-25T12:18:15.024Z | 2024-11-01T12:26:56.552Z |
5365924 | 5365924 | 20241023235721_iNgAG | NL0001 | 2024-10-25T12:18:10.509Z | 2024-11-01T12:26:56.489Z |
5365872 | 5365872 | 20241023235402_vPEGq | NL0001 | 2024-10-25T12:18:09.504Z | 2024-11-01T12:26:56.460Z |
5365550 | 5365550 | 20241023233637_HZ028 | NL0001 | 2024-10-25T12:18:00.431Z | 2024-11-01T12:26:56.199Z |
5365477 | 5365477 | 20241023233351_BIixy | NL0001 | 2024-10-25T12:17:58.787Z | 2024-11-01T12:26:56.159Z |
5365371 | 5365371 | 20241023232827_pyyIV | NL0001 | 2024-10-25T12:17:56.783Z | 2024-11-01T12:26:56.068Z |
5365229 | 5365229 | 20241023232153_WQFgt | NL0001 | 2024-10-25T12:17:51.772Z | 2024-11-01T12:26:55.987Z |
5365214 | 5365214 | 20241023232122_Kc4rp | NL0001 | 2024-10-25T12:17:51.357Z | 2024-11-01T12:26:55.977Z |
5364983 | 5364983 | 20241023230854_3yhCE | NL0001 | 2024-10-25T12:17:42.745Z | 2024-11-01T12:26:55.817Z |
5364697 | 5364697 | 20241023224800_ODygi | NL0001 | 2024-10-25T12:17:30.887Z | 2024-11-01T12:26:55.581Z |
5364326 | 5364326 | 20241023222042_ovpeO | NL0001 | 2024-10-25T12:17:16.943Z | 2024-11-01T12:26:54.676Z |
5364150 | 5364150 | 20241023220955_wzM3f | NL0001 | 2024-10-25T12:17:10.644Z | 2024-11-01T12:26:54.562Z |
5364028 | 5364028 | 20241023220311_HN7KC | NL0001 | 2024-10-25T12:17:06.229Z | 2024-11-01T12:26:54.327Z |
5364001 | 5364001 | 20241023220135_Gma4M | NL0001 | 2024-10-25T12:17:05.320Z | 2024-11-01T12:26:54.292Z |
5363899 | 5363899 | 20241023215659_j7VmR | NL0001 | 2024-10-25T12:17:01.249Z | 2024-11-01T12:26:54.196Z |
5363605 | 5363605 | 20241023212643_gtIZk | NL0001 | 2024-10-25T12:16:27.575Z | 2024-11-01T12:26:53.460Z |
5362935 | 5362935 | 20241023201238_pCl3g | NL0001 | 2024-10-25T12:15:17.844Z | 2024-11-01T12:26:52.526Z |
5362394 | 5362394 | 20241023192938_x8HAQ | NL0001 | 2024-10-25T12:14:23.294Z | 2024-11-01T12:26:51.366Z |
5362382 | 5362382 | 20241023192842_KcYoI | NL0001 | 2024-10-25T12:14:22.283Z | 2024-11-01T12:26:51.358Z |
5361729 | 5361729 | 20241023183935_FMF86 | NL0001 | 2024-10-25T12:13:16.317Z | 2024-11-01T12:26:50.493Z |
5354979 | 5354979 | 20241023030158_vQqv3 | NL0001 | 2024-10-24T12:20:59.083Z | 2024-10-31T12:30:06.828Z |
5354462 | 5354462 | 20241023022703_hcsse | NL0001 | 2024-10-24T12:20:34.553Z | 2024-10-31T12:30:05.862Z |
5354431 | 5354431 | 20241023022603_kXJ1Y | NL0001 | 2024-10-24T12:20:33.594Z | 2024-10-31T12:30:05.849Z |
5354318 | 5354318 | 20241023021941_3RA2R | NL0001 | 2024-10-24T12:20:28.109Z | 2024-10-31T12:30:05.638Z |
5353059 | 5353059 | 20241023010446_vCURe | NL0001 | 2024-10-24T12:19:30.547Z | 2024-10-31T12:30:03.747Z |
5352877 | 5352877 | 20241023005402_1HrWQ | NL0001 | 2024-10-24T12:19:20.517Z | 2024-10-31T12:30:03.452Z |
5352838 | 5352838 | 20241023005305_efv9U | NL0001 | 2024-10-24T12:19:16.628Z | 2024-10-31T12:30:03.403Z |
5352291 | 5352291 | 20241023002456_2C2Fd | NL0001 | 2024-10-24T12:18:35.930Z | 2024-10-31T12:30:02.395Z |
5351869 | 5351869 | 20241022235656_5i8lK | NL0001 | 2024-10-24T12:18:06.220Z | 2024-10-31T12:30:01.138Z |
5351835 | 5351835 | 20241022235512_QXyw3 | NL0001 | 2024-10-24T12:18:03.428Z | 2024-10-31T12:30:01.002Z |
5351832 | 5351832 | 20241022235507_3znFp | NL0001 | 2024-10-24T12:18:02.921Z | 2024-10-31T12:30:00.990Z |
5351828 | 5351828 | 20241022235504_kpTvd | NL0001 | 2024-10-24T12:18:02.828Z | 2024-10-31T12:30:00.985Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);