participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,195 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 |
---|---|---|---|---|---|
5490415 | 5490415 | 20241105223750_ltizE | NL000R | 2024-11-07T14:13:59.529Z | 2024-11-12T14:26:48.272Z |
5490191 | 5490191 | 20241105213530_hwUt5 | NL000R | 2024-11-07T14:13:32.374Z | 2024-11-12T14:26:47.149Z |
5489954 | 5489954 | 20241105203316_gEvZR | NL000R | 2024-11-07T14:12:57.704Z | 2024-11-12T14:26:45.523Z |
5489857 | 5489857 | 20241105201919_slQpK | NL000R | 2024-11-07T14:12:50.208Z | 2024-11-12T14:26:45.167Z |
5489733 | 5489733 | 20241105195324_5vgyy | NL000R | 2024-11-07T14:12:41.939Z | 2024-11-12T14:26:44.828Z |
5489718 | 5489718 | 20241105194952_B8Hhp | NL000R | 2024-11-07T14:12:41.063Z | 2024-11-12T14:26:44.799Z |
5489570 | 5489570 | 20241105191804_zT828 | NL000R | 2024-11-07T14:12:13.325Z | 2024-11-12T14:26:43.807Z |
5489322 | 5489322 | 20241105183517_8w2rS | NL000R | 2024-11-07T14:11:53.042Z | 2024-11-12T14:26:42.187Z |
5489235 | 5489235 | 20241105181211_oCT8s | NL000R | 2024-11-07T14:11:34.215Z | 2024-11-12T14:26:40.563Z |
5489203 | 5489203 | 20241105180512_PtcRr | NL000R | 2024-11-07T14:11:26.693Z | 2024-11-12T14:26:40.289Z |
5489083 | 5489083 | 20241105174723_hGocf | NL000R | 2024-11-07T14:11:16.842Z | 2024-11-12T14:26:38.903Z |
5489070 | 5489070 | 20241105174554_ninQv | NL000R | 2024-11-07T14:11:15.849Z | 2024-11-12T14:26:38.636Z |
5485358 | 5485358 | 20241105050449_vpidC | NL000R | 2024-11-06T14:18:09.497Z | 2024-11-12T14:27:38.415Z |
5485345 | 5485345 | 20241105045915_CN8R1 | NL000R | 2024-11-06T14:18:08.949Z | 2024-11-12T14:27:38.392Z |
5485295 | 5485295 | 20241105044021_tTYjO | NL000R | 2024-11-06T14:18:04.077Z | 2024-11-12T14:27:38.106Z |
5485276 | 5485276 | 20241105043625_LHUk7 | NL000R | 2024-11-06T14:18:01.438Z | 2024-11-12T14:27:38.023Z |
5484806 | 5484806 | 20241105033126_rRaTM | NL000R | 2024-11-06T14:17:19.089Z | 2024-11-12T14:27:35.553Z |
5484646 | 5484646 | 20241105031637_U4M1P | NL000R | 2024-11-06T14:17:07.826Z | 2024-11-12T14:27:35.080Z |
5484634 | 5484634 | 20241105031521_fuOdN | NL000R | 2024-11-06T14:17:07.289Z | 2024-11-12T14:27:34.995Z |
5484617 | 5484617 | 20241105031143_Dn3er | NL000R | 2024-11-06T14:17:06.327Z | 2024-11-12T14:27:34.977Z |
5484594 | 5484594 | 20241105030830_XqmJn | NL000R | 2024-11-06T14:17:03.715Z | 2024-11-12T14:27:34.863Z |
5484564 | 5484564 | 20241105030501_aM5Ds | NL000R | 2024-11-06T14:17:00.967Z | 2024-11-12T14:27:34.673Z |
5484286 | 5484286 | 20241105023112_VvO5t | NL000R | 2024-11-06T14:16:45.564Z | 2024-11-12T14:27:33.245Z |
5484243 | 5484243 | 20241105022430_TUz80 | NL000R | 2024-11-06T14:16:37.647Z | 2024-11-12T14:27:32.872Z |
5484181 | 5484181 | 20241105021807_U2hBL | NL000R | 2024-11-06T14:16:27.320Z | 2024-11-12T14:27:32.496Z |
5484088 | 5484088 | 20241105020909_hIf9L | NL000R | 2024-11-06T14:16:12.685Z | 2024-11-12T14:27:31.693Z |
5484024 | 5484024 | 20241105015942_ciOEc | NL000R | 2024-11-06T14:16:04.257Z | 2024-11-12T14:27:31.209Z |
5483801 | 5483801 | 20241105013248_Q4im4 | NL000R | 2024-11-06T14:15:43.761Z | 2024-11-12T14:27:30.314Z |
5483754 | 5483754 | 20241105012653_6ktkB | NL000R | 2024-11-06T14:15:40.423Z | 2024-11-12T14:27:30.101Z |
5483751 | 5483751 | 20241105012644_UcjZG | NL000R | 2024-11-06T14:15:40.180Z | 2024-11-12T14:27:29.922Z |
5483670 | 5483670 | 20241105011717_I44Gu | NL000R | 2024-11-06T14:15:34.756Z | 2024-11-12T14:27:29.701Z |
5483665 | 5483665 | 20241105011650_CxCbg | NL000R | 2024-11-06T14:15:34.290Z | 2024-11-12T14:27:29.665Z |
5483657 | 5483657 | 20241105011605_2ZT39 | NL000R | 2024-11-06T14:15:33.962Z | 2024-11-12T14:27:29.654Z |
5483649 | 5483649 | 20241105011447_G7zpN | NL000R | 2024-11-06T14:15:33.587Z | 2024-11-12T14:27:29.518Z |
5483424 | 5483424 | 20241105003911_3hvL3 | NL000R | 2024-11-06T14:15:14.743Z | 2024-11-12T14:27:28.095Z |
5483403 | 5483403 | 20241105003638_Jxtsp | NL000R | 2024-11-06T14:15:12.431Z | 2024-11-12T14:27:27.999Z |
5483349 | 5483349 | 20241105002854_IOFnQ | NL000R | 2024-11-06T14:15:01.382Z | 2024-11-12T14:27:27.749Z |
5483315 | 5483315 | 20241105002608_jJ4ww | NL000R | 2024-11-06T14:14:58.560Z | 2024-11-12T14:27:27.618Z |
5483209 | 5483209 | 20241105001300_bJCRq | NL000R | 2024-11-06T14:14:47.624Z | 2024-11-12T14:27:27.177Z |
5483109 | 5483109 | 20241104235850_tr782 | NL000R | 2024-11-06T14:14:40.430Z | 2024-11-12T14:27:25.777Z |
5483077 | 5483077 | 20241104235502_q6ZGD | NL000R | 2024-11-06T14:14:38.641Z | 2024-11-12T14:27:25.705Z |
5483012 | 5483012 | 20241104234818_0enj2 | NL000R | 2024-11-06T14:14:34.719Z | 2024-11-12T14:27:25.243Z |
5482973 | 5482973 | 20241104234207_insr9 | NL000R | 2024-11-06T14:14:32.109Z | 2024-11-12T14:27:25.060Z |
5482847 | 5482847 | 20241104232246_Piau9 | NL000R | 2024-11-06T14:14:10.752Z | 2024-11-12T14:27:24.338Z |
5482818 | 5482818 | 20241104231752_mQi40 | NL000R | 2024-11-06T14:14:06.143Z | 2024-11-12T14:27:24.202Z |
5482653 | 5482653 | 20241104225557_7FO5W | NL000R | 2024-11-06T14:13:31.159Z | 2024-11-12T14:27:23.549Z |
5482577 | 5482577 | 20241104224352_zCUSp | NL000R | 2024-11-06T14:13:23.724Z | 2024-11-12T14:27:23.037Z |
5482560 | 5482560 | 20241104223958_rVvhf | NL000R | 2024-11-06T14:13:21.532Z | 2024-11-12T14:27:22.968Z |
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 |
5475784 | 5475784 | 20241103212332_WLOHf | NL000R | 2024-11-05T14:14:12.071Z | 2024-11-12T14:28:00.971Z |
5475744 | 5475744 | 20241103211405_fTa6n | NL000R | 2024-11-05T14:14:05.707Z | 2024-11-12T14:28:00.794Z |
5475668 | 5475668 | 20241103205823_LWMA2 | NL000R | 2024-11-05T14:13:58.832Z | 2024-11-12T14:28:00.243Z |
5475627 | 5475627 | 20241103205159_C4g11 | NL000R | 2024-11-05T14:13:54.486Z | 2024-11-12T14:28:00.102Z |
5475584 | 5475584 | 20241103204208_lniNx | NL000R | 2024-11-05T14:13:51.133Z | 2024-11-12T14:27:59.982Z |
5475343 | 5475343 | 20241103195129_gonKO | NL000R | 2024-11-05T14:13:13.960Z | 2024-11-12T14:27:57.979Z |
5475158 | 5475158 | 20241103192053_5vW2c | NL000R | 2024-11-05T14:12:37.711Z | 2024-11-12T14:27:57.388Z |
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);