participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,202 rows where station_code = "NL000R" 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 |
---|---|---|---|---|---|
5562015 | 5562015 | 20241119224534_SW0pH | NL000R | 2024-11-21T14:14:19.695Z | 2024-11-22T14:20:51.392Z |
5561575 | 5561575 | 20241119210931_uO0k3 | NL000R | 2024-11-21T14:13:29.372Z | 2024-11-22T14:20:41.146Z |
5561572 | 5561572 | 20241119210718_vBkv6 | NL000R | 2024-11-21T14:13:28.981Z | 2024-11-22T14:20:41.110Z |
5561345 | 5561345 | 20241119200504_cFUjz | NL000R | 2024-11-21T14:13:07.839Z | 2024-11-22T14:20:33.051Z |
5561113 | 5561113 | 20241119181920_keHgn | NL000R | 2024-11-21T14:12:24.938Z | 2024-11-22T14:20:21.296Z |
5561058 | 5561058 | 20241119173500_RQu13 | NL000R | 2024-11-21T14:12:16.090Z | 2024-11-22T14:20:17.237Z |
5558224 | 5558224 | 20241120054647_t72WH | NL000R | 2024-11-21T14:02:47.759Z | 2024-11-22T14:19:21.196Z |
5490415 | 5490415 | 20241105223750_ltizE | NL000R | 2024-11-07T14:13:59.529Z | 2024-11-14T14:23:19.514Z |
5490191 | 5490191 | 20241105213530_hwUt5 | NL000R | 2024-11-07T14:13:32.374Z | 2024-11-14T14:23:18.101Z |
5489954 | 5489954 | 20241105203316_gEvZR | NL000R | 2024-11-07T14:12:57.704Z | 2024-11-14T14:23:16.945Z |
5489857 | 5489857 | 20241105201919_slQpK | NL000R | 2024-11-07T14:12:50.208Z | 2024-11-14T14:23:15.835Z |
5489733 | 5489733 | 20241105195324_5vgyy | NL000R | 2024-11-07T14:12:41.939Z | 2024-11-14T14:23:15.427Z |
5489718 | 5489718 | 20241105194952_B8Hhp | NL000R | 2024-11-07T14:12:41.063Z | 2024-11-14T14:23:15.388Z |
5489570 | 5489570 | 20241105191804_zT828 | NL000R | 2024-11-07T14:12:13.325Z | 2024-11-14T14:23:13.834Z |
5489322 | 5489322 | 20241105183517_8w2rS | NL000R | 2024-11-07T14:11:53.042Z | 2024-11-14T14:23:12.427Z |
5489235 | 5489235 | 20241105181211_oCT8s | NL000R | 2024-11-07T14:11:34.215Z | 2024-11-14T14:23:11.102Z |
5489203 | 5489203 | 20241105180512_PtcRr | NL000R | 2024-11-07T14:11:26.693Z | 2024-11-14T14:23:10.826Z |
5489083 | 5489083 | 20241105174723_hGocf | NL000R | 2024-11-07T14:11:16.842Z | 2024-11-14T14:23:10.284Z |
5489070 | 5489070 | 20241105174554_ninQv | NL000R | 2024-11-07T14:11:15.849Z | 2024-11-14T14:23:10.243Z |
5485358 | 5485358 | 20241105050449_vpidC | NL000R | 2024-11-06T14:18:09.497Z | 2024-11-13T14:27:42.037Z |
5485345 | 5485345 | 20241105045915_CN8R1 | NL000R | 2024-11-06T14:18:08.949Z | 2024-11-13T14:27:41.815Z |
5485295 | 5485295 | 20241105044021_tTYjO | NL000R | 2024-11-06T14:18:04.077Z | 2024-11-13T14:27:41.568Z |
5485276 | 5485276 | 20241105043625_LHUk7 | NL000R | 2024-11-06T14:18:01.438Z | 2024-11-13T14:27:41.499Z |
5484806 | 5484806 | 20241105033126_rRaTM | NL000R | 2024-11-06T14:17:19.089Z | 2024-11-13T14:27:39.893Z |
5484646 | 5484646 | 20241105031637_U4M1P | NL000R | 2024-11-06T14:17:07.826Z | 2024-11-13T14:27:38.995Z |
5484634 | 5484634 | 20241105031521_fuOdN | NL000R | 2024-11-06T14:17:07.289Z | 2024-11-13T14:27:38.951Z |
5484617 | 5484617 | 20241105031143_Dn3er | NL000R | 2024-11-06T14:17:06.327Z | 2024-11-13T14:27:38.885Z |
5484594 | 5484594 | 20241105030830_XqmJn | NL000R | 2024-11-06T14:17:03.715Z | 2024-11-13T14:27:38.680Z |
5484564 | 5484564 | 20241105030501_aM5Ds | NL000R | 2024-11-06T14:17:00.967Z | 2024-11-13T14:27:38.637Z |
5484286 | 5484286 | 20241105023112_VvO5t | NL000R | 2024-11-06T14:16:45.564Z | 2024-11-13T14:27:37.634Z |
5484243 | 5484243 | 20241105022430_TUz80 | NL000R | 2024-11-06T14:16:37.647Z | 2024-11-13T14:27:37.570Z |
5484181 | 5484181 | 20241105021807_U2hBL | NL000R | 2024-11-06T14:16:27.320Z | 2024-11-13T14:27:37.474Z |
5484088 | 5484088 | 20241105020909_hIf9L | NL000R | 2024-11-06T14:16:12.685Z | 2024-11-13T14:27:37.270Z |
5484024 | 5484024 | 20241105015942_ciOEc | NL000R | 2024-11-06T14:16:04.257Z | 2024-11-13T14:27:37.171Z |
5483801 | 5483801 | 20241105013248_Q4im4 | NL000R | 2024-11-06T14:15:43.761Z | 2024-11-13T14:27:36.827Z |
5483754 | 5483754 | 20241105012653_6ktkB | NL000R | 2024-11-06T14:15:40.423Z | 2024-11-13T14:27:36.766Z |
5483751 | 5483751 | 20241105012644_UcjZG | NL000R | 2024-11-06T14:15:40.180Z | 2024-11-13T14:27:36.757Z |
5483670 | 5483670 | 20241105011717_I44Gu | NL000R | 2024-11-06T14:15:34.756Z | 2024-11-13T14:27:36.598Z |
5483665 | 5483665 | 20241105011650_CxCbg | NL000R | 2024-11-06T14:15:34.290Z | 2024-11-13T14:27:36.591Z |
5483657 | 5483657 | 20241105011605_2ZT39 | NL000R | 2024-11-06T14:15:33.962Z | 2024-11-13T14:27:36.571Z |
5483649 | 5483649 | 20241105011447_G7zpN | NL000R | 2024-11-06T14:15:33.587Z | 2024-11-13T14:27:36.546Z |
5483424 | 5483424 | 20241105003911_3hvL3 | NL000R | 2024-11-06T14:15:14.743Z | 2024-11-13T14:27:36.218Z |
5483403 | 5483403 | 20241105003638_Jxtsp | NL000R | 2024-11-06T14:15:12.431Z | 2024-11-13T14:27:36.185Z |
5483349 | 5483349 | 20241105002854_IOFnQ | NL000R | 2024-11-06T14:15:01.382Z | 2024-11-13T14:27:36.063Z |
5483315 | 5483315 | 20241105002608_jJ4ww | NL000R | 2024-11-06T14:14:58.560Z | 2024-11-13T14:27:36.026Z |
5483209 | 5483209 | 20241105001300_bJCRq | NL000R | 2024-11-06T14:14:47.624Z | 2024-11-13T14:27:35.849Z |
5483109 | 5483109 | 20241104235850_tr782 | NL000R | 2024-11-06T14:14:40.430Z | 2024-11-13T14:27:35.738Z |
5483077 | 5483077 | 20241104235502_q6ZGD | NL000R | 2024-11-06T14:14:38.641Z | 2024-11-13T14:27:35.679Z |
5483012 | 5483012 | 20241104234818_0enj2 | NL000R | 2024-11-06T14:14:34.719Z | 2024-11-13T14:27:35.581Z |
5482973 | 5482973 | 20241104234207_insr9 | NL000R | 2024-11-06T14:14:32.109Z | 2024-11-13T14:27:35.514Z |
5482847 | 5482847 | 20241104232246_Piau9 | NL000R | 2024-11-06T14:14:10.752Z | 2024-11-13T14:27:35.263Z |
5482818 | 5482818 | 20241104231752_mQi40 | NL000R | 2024-11-06T14:14:06.143Z | 2024-11-13T14:27:35.213Z |
5482653 | 5482653 | 20241104225557_7FO5W | NL000R | 2024-11-06T14:13:31.159Z | 2024-11-13T14:27:34.971Z |
5482577 | 5482577 | 20241104224352_zCUSp | NL000R | 2024-11-06T14:13:23.724Z | 2024-11-13T14:27:34.845Z |
5482560 | 5482560 | 20241104223958_rVvhf | NL000R | 2024-11-06T14:13:21.532Z | 2024-11-13T14:27:34.823Z |
5478682 | 5478682 | 20241104050632_dmAmI | NL000R | 2024-11-05T14:18:41.465Z | 2024-11-12T14:28:16.558Z |
5478678 | 5478678 | 20241104050125_xGAf0 | NL000R | 2024-11-05T14:18:41.392Z | 2024-11-12T14:28:16.557Z |
5478666 | 5478666 | 20241104045605_7sRaZ | NL000R | 2024-11-05T14:18:39.011Z | 2024-11-12T14:28:16.517Z |
5478641 | 5478641 | 20241104044939_PhRXu | NL000R | 2024-11-05T14:18:36.949Z | 2024-11-12T14:28:16.456Z |
5478603 | 5478603 | 20241104044150_pt053 | NL000R | 2024-11-05T14:18:33.328Z | 2024-11-12T14:28:16.311Z |
5478573 | 5478573 | 20241104043455_gJa4k | NL000R | 2024-11-05T14:18:32.423Z | 2024-11-12T14:28:16.135Z |
5478291 | 5478291 | 20241104034813_apbtz | NL000R | 2024-11-05T14:18:09.905Z | 2024-11-12T14:28:14.859Z |
5478093 | 5478093 | 20241104032049_R8Ddt | NL000R | 2024-11-05T14:17:54.214Z | 2024-11-12T14:28:14.173Z |
5477990 | 5477990 | 20241104030451_TiVwb | NL000R | 2024-11-05T14:17:42.980Z | 2024-11-12T14:28:13.724Z |
5477956 | 5477956 | 20241104030017_yPzeg | NL000R | 2024-11-05T14:17:40.151Z | 2024-11-12T14:28:13.646Z |
5477820 | 5477820 | 20241104024045_1X3Ov | NL000R | 2024-11-05T14:17:28.469Z | 2024-11-12T14:28:13.036Z |
5477713 | 5477713 | 20241104022417_N1RSL | NL000R | 2024-11-05T14:17:18.698Z | 2024-11-12T14:28:12.497Z |
5477648 | 5477648 | 20241104021654_eWVW3 | NL000R | 2024-11-05T14:17:12.335Z | 2024-11-12T14:28:12.227Z |
5477591 | 5477591 | 20241104021056_1CFKs | NL000R | 2024-11-05T14:17:06.536Z | 2024-11-12T14:28:12.105Z |
5477525 | 5477525 | 20241104020549_dZKIo | NL000R | 2024-11-05T14:17:01.117Z | 2024-11-12T14:28:11.936Z |
5477427 | 5477427 | 20241104015051_g530D | NL000R | 2024-11-05T14:16:52.712Z | 2024-11-12T14:28:11.562Z |
5477374 | 5477374 | 20241104014424_DT34f | NL000R | 2024-11-05T14:16:47.657Z | 2024-11-12T14:28:11.023Z |
5477211 | 5477211 | 20241104012023_pz3Bw | NL000R | 2024-11-05T14:16:31.577Z | 2024-11-12T14:28:10.132Z |
5477182 | 5477182 | 20241104011415_Ox7mg | NL000R | 2024-11-05T14:16:29.549Z | 2024-11-12T14:28:09.955Z |
5477063 | 5477063 | 20241104005557_tV3wB | NL000R | 2024-11-05T14:16:19.750Z | 2024-11-12T14:28:08.405Z |
5477050 | 5477050 | 20241104005456_hDBQP | NL000R | 2024-11-05T14:16:19.409Z | 2024-11-12T14:28:08.390Z |
5477023 | 5477023 | 20241104005331_vdt2a | NL000R | 2024-11-05T14:16:17.796Z | 2024-11-12T14:28:08.304Z |
5476973 | 5476973 | 20241104004656_IY6tG | NL000R | 2024-11-05T14:16:15.164Z | 2024-11-12T14:28:07.950Z |
5476943 | 5476943 | 20241104004431_LWQZs | NL000R | 2024-11-05T14:16:13.184Z | 2024-11-12T14:28:07.925Z |
5476939 | 5476939 | 20241104004347_N2qYT | NL000R | 2024-11-05T14:16:13.087Z | 2024-11-12T14:28:07.923Z |
5476836 | 5476836 | 20241104003041_XGh46 | NL000R | 2024-11-05T14:16:06.966Z | 2024-11-12T14:28:07.710Z |
5476813 | 5476813 | 20241104002753_E0e9h | NL000R | 2024-11-05T14:16:06.137Z | 2024-11-12T14:28:07.569Z |
5476763 | 5476763 | 20241104001814_3ISHE | NL000R | 2024-11-05T14:16:03.568Z | 2024-11-12T14:28:07.176Z |
5476722 | 5476722 | 20241104001222_1kV6I | NL000R | 2024-11-05T14:15:59.811Z | 2024-11-12T14:28:06.990Z |
5476660 | 5476660 | 20241104000337_22y6h | NL000R | 2024-11-05T14:15:49.120Z | 2024-11-12T14:28:06.751Z |
5476652 | 5476652 | 20241104000250_j8Zza | NL000R | 2024-11-05T14:15:48.881Z | 2024-11-12T14:28:06.686Z |
5476650 | 5476650 | 20241104000148_jiLUa | NL000R | 2024-11-05T14:15:48.763Z | 2024-11-12T14:28:06.683Z |
5476607 | 5476607 | 20241103235141_B0xXl | NL000R | 2024-11-05T14:15:43.572Z | 2024-11-12T14:28:06.565Z |
5476557 | 5476557 | 20241103234509_J8XUG | NL000R | 2024-11-05T14:15:39.543Z | 2024-11-12T14:28:06.507Z |
5476472 | 5476472 | 20241103233044_yH9Ta | NL000R | 2024-11-05T14:15:26.665Z | 2024-11-12T14:28:06.154Z |
5476333 | 5476333 | 20241103230932_9fq14 | NL000R | 2024-11-05T14:15:05.317Z | 2024-11-12T14:28:05.520Z |
5476250 | 5476250 | 20241103225244_7K8dt | NL000R | 2024-11-05T14:14:58.325Z | 2024-11-12T14:28:04.514Z |
5476222 | 5476222 | 20241103224830_JvfXn | NL000R | 2024-11-05T14:14:54.981Z | 2024-11-12T14:28:03.867Z |
5476113 | 5476113 | 20241103222757_hU2xS | NL000R | 2024-11-05T14:14:46.029Z | 2024-11-12T14:28:03.031Z |
5476076 | 5476076 | 20241103221554_pHe6e | NL000R | 2024-11-05T14:14:43.098Z | 2024-11-12T14:28:02.674Z |
5476053 | 5476053 | 20241103221313_m2r3o | NL000R | 2024-11-05T14:14:41.655Z | 2024-11-12T14:28:02.508Z |
5475937 | 5475937 | 20241103215707_eLnMS | NL000R | 2024-11-05T14:14:34.516Z | 2024-11-12T14:28:01.849Z |
5475873 | 5475873 | 20241103214331_pGqDl | NL000R | 2024-11-05T14:14:28.095Z | 2024-11-12T14:28:01.724Z |
5475850 | 5475850 | 20241103213727_7aCew | NL000R | 2024-11-05T14:14:22.432Z | 2024-11-12T14:28:01.369Z |
5475831 | 5475831 | 20241103213134_X9Hzm | NL000R | 2024-11-05T14:14:20.071Z | 2024-11-12T14:28:01.251Z |
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);