participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,181 rows where station_code = "NL000S" 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 |
---|---|---|---|---|---|
5561990 | 5561990 | 20241119224103_ZCS1n | NL000S | 2024-11-21T14:14:18.337Z | 2024-11-22T14:20:50.963Z |
5561799 | 5561799 | 20241119221159_ubG3Q | NL000S | 2024-11-21T14:14:07.065Z | 2024-11-22T14:20:46.904Z |
5561793 | 5561793 | 20241119221002_rO2OV | NL000S | 2024-11-21T14:14:06.644Z | 2024-11-22T14:20:46.394Z |
5561708 | 5561708 | 20241119214703_RphfJ | NL000S | 2024-11-21T14:13:49.318Z | 2024-11-22T14:20:43.719Z |
5561701 | 5561701 | 20241119214350_23Nbl | NL000S | 2024-11-21T14:13:48.530Z | 2024-11-22T14:20:43.613Z |
5561576 | 5561576 | 20241119210931_uO0k3 | NL000S | 2024-11-21T14:13:29.372Z | 2024-11-22T14:20:41.146Z |
5561573 | 5561573 | 20241119210718_vBkv6 | NL000S | 2024-11-21T14:13:28.981Z | 2024-11-22T14:20:41.110Z |
5561527 | 5561527 | 20241119205339_EY4dx | NL000S | 2024-11-21T14:13:24.652Z | 2024-11-22T14:20:39.797Z |
5561054 | 5561054 | 20241119172858_xS2Wr | NL000S | 2024-11-21T14:12:15.188Z | 2024-11-22T14:20:17.056Z |
5490364 | 5490364 | 20241105222434_PvIMT | NL000S | 2024-11-07T14:13:55.831Z | 2024-11-14T14:23:19.223Z |
5490209 | 5490209 | 20241105214150_kA2Ek | NL000S | 2024-11-07T14:13:34.407Z | 2024-11-14T14:23:18.258Z |
5490192 | 5490192 | 20241105213530_hwUt5 | NL000S | 2024-11-07T14:13:32.374Z | 2024-11-14T14:23:18.101Z |
5490160 | 5490160 | 20241105212532_eGX33 | NL000S | 2024-11-07T14:13:22.526Z | 2024-11-14T14:23:17.956Z |
5490096 | 5490096 | 20241105205914_5xquF | NL000S | 2024-11-07T14:13:10.979Z | 2024-11-14T14:23:17.505Z |
5490075 | 5490075 | 20241105205247_OtZKZ | NL000S | 2024-11-07T14:13:08.346Z | 2024-11-14T14:23:17.401Z |
5489807 | 5489807 | 20241105200316_u445E | NL000S | 2024-11-07T14:12:46.704Z | 2024-11-14T14:23:15.738Z |
5489654 | 5489654 | 20241105193514_Asoyr | NL000S | 2024-11-07T14:12:28.695Z | 2024-11-14T14:23:14.644Z |
5489649 | 5489649 | 20241105193444_LIGHo | NL000S | 2024-11-07T14:12:25.809Z | 2024-11-14T14:23:14.630Z |
5489571 | 5489571 | 20241105191804_zT828 | NL000S | 2024-11-07T14:12:13.325Z | 2024-11-14T14:23:13.834Z |
5489431 | 5489431 | 20241105185121_r91gu | NL000S | 2024-11-07T14:12:01.291Z | 2024-11-14T14:23:13.081Z |
5489286 | 5489286 | 20241105182726_sQ5zT | NL000S | 2024-11-07T14:11:50.355Z | 2024-11-14T14:23:11.817Z |
5489071 | 5489071 | 20241105174554_ninQv | NL000S | 2024-11-07T14:11:15.872Z | 2024-11-14T14:23:10.243Z |
5489066 | 5489066 | 20241105174333_tPpXa | NL000S | 2024-11-07T14:11:15.255Z | 2024-11-14T14:23:10.026Z |
5488940 | 5488940 | 20241105172330_Y2E5p | NL000S | 2024-11-07T14:11:03.037Z | 2024-11-14T14:23:08.746Z |
5488821 | 5488821 | 20241105170207_42Sf3 | NL000S | 2024-11-07T14:10:39.995Z | 2024-11-14T14:23:08.016Z |
5485277 | 5485277 | 20241105043625_LHUk7 | NL000S | 2024-11-06T14:18:01.438Z | 2024-11-13T14:27:41.499Z |
5485242 | 5485242 | 20241105042843_SDRbw | NL000S | 2024-11-06T14:17:58.176Z | 2024-11-13T14:27:41.254Z |
5484780 | 5484780 | 20241105032906_AEgO9 | NL000S | 2024-11-06T14:17:16.163Z | 2024-11-13T14:27:39.842Z |
5484635 | 5484635 | 20241105031521_fuOdN | NL000S | 2024-11-06T14:17:07.289Z | 2024-11-13T14:27:38.951Z |
5484609 | 5484609 | 20241105031110_q6sCh | NL000S | 2024-11-06T14:17:05.002Z | 2024-11-13T14:27:38.851Z |
5484600 | 5484600 | 20241105031013_fX2BV | NL000S | 2024-11-06T14:17:04.444Z | 2024-11-13T14:27:38.840Z |
5484595 | 5484595 | 20241105030830_XqmJn | NL000S | 2024-11-06T14:17:03.715Z | 2024-11-13T14:27:38.680Z |
5484557 | 5484557 | 20241105030403_bxu2g | NL000S | 2024-11-06T14:17:00.662Z | 2024-11-13T14:27:38.619Z |
5484528 | 5484528 | 20241105030210_1ep73 | NL000S | 2024-11-06T14:16:59.768Z | 2024-11-13T14:27:38.553Z |
5484517 | 5484517 | 20241105025952_402q6 | NL000S | 2024-11-06T14:16:59.279Z | 2024-11-13T14:27:38.501Z |
5484470 | 5484470 | 20241105025417_6omKR | NL000S | 2024-11-06T14:16:56.640Z | 2024-11-13T14:27:38.123Z |
5484467 | 5484467 | 20241105025408_dETNf | NL000S | 2024-11-06T14:16:56.413Z | 2024-11-13T14:27:38.121Z |
5484451 | 5484451 | 20241105025213_GjyE1 | NL000S | 2024-11-06T14:16:55.617Z | 2024-11-13T14:27:38.094Z |
5484442 | 5484442 | 20241105025037_2mAhY | NL000S | 2024-11-06T14:16:55.065Z | 2024-11-13T14:27:38.023Z |
5484325 | 5484325 | 20241105023431_SUhYy | NL000S | 2024-11-06T14:16:48.376Z | 2024-11-13T14:27:37.730Z |
5484244 | 5484244 | 20241105022430_TUz80 | NL000S | 2024-11-06T14:16:37.647Z | 2024-11-13T14:27:37.570Z |
5484182 | 5484182 | 20241105021807_U2hBL | NL000S | 2024-11-06T14:16:27.320Z | 2024-11-13T14:27:37.474Z |
5484093 | 5484093 | 20241105020911_3s7s7 | NL000S | 2024-11-06T14:16:12.940Z | 2024-11-13T14:27:37.271Z |
5483886 | 5483886 | 20241105014120_XZNLd | NL000S | 2024-11-06T14:15:50.630Z | 2024-11-13T14:27:36.975Z |
5483860 | 5483860 | 20241105013859_thk6H | NL000S | 2024-11-06T14:15:47.014Z | 2024-11-13T14:27:36.918Z |
5483774 | 5483774 | 20241105012926_qcRd3 | NL000S | 2024-11-06T14:15:41.850Z | 2024-11-13T14:27:36.785Z |
5483755 | 5483755 | 20241105012653_6ktkB | NL000S | 2024-11-06T14:15:40.423Z | 2024-11-13T14:27:36.766Z |
5483741 | 5483741 | 20241105012552_KVMId | NL000S | 2024-11-06T14:15:39.385Z | 2024-11-13T14:27:36.724Z |
5483661 | 5483661 | 20241105011634_vblCJ | NL000S | 2024-11-06T14:15:34.048Z | 2024-11-13T14:27:36.572Z |
5483650 | 5483650 | 20241105011447_G7zpN | NL000S | 2024-11-06T14:15:33.587Z | 2024-11-13T14:27:36.546Z |
5483554 | 5483554 | 20241105005614_t2sdW | NL000S | 2024-11-06T14:15:28.421Z | 2024-11-13T14:27:36.391Z |
5483540 | 5483540 | 20241105005509_fCvQd | NL000S | 2024-11-06T14:15:27.513Z | 2024-11-13T14:27:36.385Z |
5483530 | 5483530 | 20241105005246_cWpLG | NL000S | 2024-11-06T14:15:26.941Z | 2024-11-13T14:27:36.369Z |
5483434 | 5483434 | 20241105004045_dvnXj | NL000S | 2024-11-06T14:15:17.352Z | 2024-11-13T14:27:36.237Z |
5483425 | 5483425 | 20241105003911_3hvL3 | NL000S | 2024-11-06T14:15:14.743Z | 2024-11-13T14:27:36.218Z |
5483326 | 5483326 | 20241105002658_uD5dv | NL000S | 2024-11-06T14:14:59.746Z | 2024-11-13T14:27:36.038Z |
5483316 | 5483316 | 20241105002608_jJ4ww | NL000S | 2024-11-06T14:14:58.560Z | 2024-11-13T14:27:36.026Z |
5483301 | 5483301 | 20241105002451_FEQRt | NL000S | 2024-11-06T14:14:56.387Z | 2024-11-13T14:27:36.005Z |
5483188 | 5483188 | 20241105000903_vKSdR | NL000S | 2024-11-06T14:14:45.057Z | 2024-11-13T14:27:35.827Z |
5483161 | 5483161 | 20241105000549_27BZo | NL000S | 2024-11-06T14:14:43.397Z | 2024-11-13T14:27:35.800Z |
5483110 | 5483110 | 20241104235850_tr782 | NL000S | 2024-11-06T14:14:40.430Z | 2024-11-13T14:27:35.738Z |
5483030 | 5483030 | 20241104234853_Yhkcx | NL000S | 2024-11-06T14:14:35.512Z | 2024-11-13T14:27:35.596Z |
5482848 | 5482848 | 20241104232246_Piau9 | NL000S | 2024-11-06T14:14:10.752Z | 2024-11-13T14:27:35.263Z |
5482819 | 5482819 | 20241104231752_mQi40 | NL000S | 2024-11-06T14:14:06.143Z | 2024-11-13T14:27:35.213Z |
5482769 | 5482769 | 20241104231058_mtDdl | NL000S | 2024-11-06T14:13:53.005Z | 2024-11-13T14:27:35.084Z |
5482616 | 5482616 | 20241104224857_vfn9b | NL000S | 2024-11-06T14:13:26.831Z | 2024-11-13T14:27:34.902Z |
5482565 | 5482565 | 20241104223958_bdyu8 | NL000S | 2024-11-06T14:13:21.791Z | 2024-11-13T14:27:34.827Z |
5478709 | 5478709 | 20241104051421_0sTuk | NL000S | 2024-11-05T14:18:43.590Z | 2024-11-12T14:28:16.614Z |
5478621 | 5478621 | 20241104044357_0Sfkr | NL000S | 2024-11-05T14:18:34.810Z | 2024-11-12T14:28:16.407Z |
5478614 | 5478614 | 20241104044349_mW3Fy | NL000S | 2024-11-05T14:18:34.494Z | 2024-11-12T14:28:16.404Z |
5478610 | 5478610 | 20241104044307_2KOYd | NL000S | 2024-11-05T14:18:33.994Z | 2024-11-12T14:28:16.390Z |
5478604 | 5478604 | 20241104044150_pt053 | NL000S | 2024-11-05T14:18:33.328Z | 2024-11-12T14:28:16.311Z |
5478585 | 5478585 | 20241104043545_Jtxd6 | NL000S | 2024-11-05T14:18:32.701Z | 2024-11-12T14:28:16.277Z |
5478574 | 5478574 | 20241104043455_gJa4k | NL000S | 2024-11-05T14:18:32.424Z | 2024-11-12T14:28:16.135Z |
5478528 | 5478528 | 20241104042532_hv9k5 | NL000S | 2024-11-05T14:18:28.390Z | 2024-11-12T14:28:15.823Z |
5478349 | 5478349 | 20241104035523_DKC0t | NL000S | 2024-11-05T14:18:15.125Z | 2024-11-12T14:28:14.991Z |
5478317 | 5478317 | 20241104035120_n8eXV | NL000S | 2024-11-05T14:18:13.177Z | 2024-11-12T14:28:14.927Z |
5478239 | 5478239 | 20241104034005_G6DSq | NL000S | 2024-11-05T14:18:05.740Z | 2024-11-12T14:28:14.638Z |
5478080 | 5478080 | 20241104031808_LjZV0 | NL000S | 2024-11-05T14:17:52.921Z | 2024-11-12T14:28:14.157Z |
5478003 | 5478003 | 20241104030607_dm7hx | NL000S | 2024-11-05T14:17:44.026Z | 2024-11-12T14:28:13.828Z |
5477917 | 5477917 | 20241104025310_6TeEf | NL000S | 2024-11-05T14:17:36.563Z | 2024-11-12T14:28:13.288Z |
5477905 | 5477905 | 20241104025220_Y5Nnr | NL000S | 2024-11-05T14:17:35.668Z | 2024-11-12T14:28:13.205Z |
5477885 | 5477885 | 20241104025109_CCHmz | NL000S | 2024-11-05T14:17:34.212Z | 2024-11-12T14:28:13.145Z |
5477880 | 5477880 | 20241104025101_h333y | NL000S | 2024-11-05T14:17:33.700Z | 2024-11-12T14:28:13.141Z |
5477825 | 5477825 | 20241104024222_c5fiA | NL000S | 2024-11-05T14:17:29.065Z | 2024-11-12T14:28:13.039Z |
5477798 | 5477798 | 20241104023712_bMkrc | NL000S | 2024-11-05T14:17:26.138Z | 2024-11-12T14:28:12.965Z |
5477773 | 5477773 | 20241104023325_7H8Nz | NL000S | 2024-11-05T14:17:23.854Z | 2024-11-12T14:28:12.870Z |
5477748 | 5477748 | 20241104023143_N1tXB | NL000S | 2024-11-05T14:17:21.995Z | 2024-11-12T14:28:12.599Z |
5477714 | 5477714 | 20241104022417_N1RSL | NL000S | 2024-11-05T14:17:18.698Z | 2024-11-12T14:28:12.497Z |
5477643 | 5477643 | 20241104021634_2hWCD | NL000S | 2024-11-05T14:17:11.486Z | 2024-11-12T14:28:12.206Z |
5477592 | 5477592 | 20241104021056_1CFKs | NL000S | 2024-11-05T14:17:06.536Z | 2024-11-12T14:28:12.105Z |
5477526 | 5477526 | 20241104020549_dZKIo | NL000S | 2024-11-05T14:17:01.117Z | 2024-11-12T14:28:11.936Z |
5477488 | 5477488 | 20241104020155_YCXXa | NL000S | 2024-11-05T14:16:56.912Z | 2024-11-12T14:28:11.847Z |
5477447 | 5477447 | 20241104015450_WIr6y | NL000S | 2024-11-05T14:16:54.128Z | 2024-11-12T14:28:11.778Z |
5477431 | 5477431 | 20241104015058_4AqMg | NL000S | 2024-11-05T14:16:52.827Z | 2024-11-12T14:28:11.564Z |
5477351 | 5477351 | 20241104014115_fHfzl | NL000S | 2024-11-05T14:16:45.759Z | 2024-11-12T14:28:10.936Z |
5477130 | 5477130 | 20241104010402_9gFpX | NL000S | 2024-11-05T14:16:25.190Z | 2024-11-12T14:28:09.770Z |
5477101 | 5477101 | 20241104010056_iyX5o | NL000S | 2024-11-05T14:16:22.332Z | 2024-11-12T14:28:09.692Z |
5477051 | 5477051 | 20241104005456_hDBQP | NL000S | 2024-11-05T14:16:19.409Z | 2024-11-12T14:28:08.390Z |
5477006 | 5477006 | 20241104005200_sENBy | NL000S | 2024-11-05T14:16:17.056Z | 2024-11-12T14:28:08.067Z |
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);