participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,227 rows where station_code = "CZ000L" 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 |
---|---|---|---|---|---|
5572310 | 5572310 | 20241121020835_TmBFr | CZ000L | 2024-11-22T14:18:14.869Z | 2024-11-23T14:23:42.829Z |
5572245 | 5572245 | 20241121015843_5Y064 | CZ000L | 2024-11-22T14:18:07.306Z | 2024-11-23T14:23:42.026Z |
5572228 | 5572228 | 20241121015444_3EODi | CZ000L | 2024-11-22T14:18:05.915Z | 2024-11-23T14:23:41.815Z |
5572030 | 5572030 | 20241121012204_LNIch | CZ000L | 2024-11-22T14:17:53.335Z | 2024-11-23T14:23:38.997Z |
5571972 | 5571972 | 20241121011556_rUwwk | CZ000L | 2024-11-22T14:17:50.494Z | 2024-11-23T14:23:38.454Z |
5571937 | 5571937 | 20241121010934_d1HNQ | CZ000L | 2024-11-22T14:17:48.129Z | 2024-11-23T14:23:37.950Z |
5571638 | 5571638 | 20241121002615_i63sY | CZ000L | 2024-11-22T14:17:30.054Z | 2024-11-23T14:23:32.386Z |
5571352 | 5571352 | 20241120232734_4NdOH | CZ000L | 2024-11-22T14:16:55.963Z | 2024-11-23T14:23:28.237Z |
5571333 | 5571333 | 20241120232416_CyWka | CZ000L | 2024-11-22T14:16:51.593Z | 2024-11-23T14:23:28.050Z |
5570926 | 5570926 | 20241120213217_dEIqG | CZ000L | 2024-11-22T14:16:12.369Z | 2024-11-23T14:23:20.189Z |
5570788 | 5570788 | 20241120205619_gMMsT | CZ000L | 2024-11-22T14:16:05.604Z | 2024-11-23T14:23:17.537Z |
5570771 | 5570771 | 20241120205349_ELE9Q | CZ000L | 2024-11-22T14:16:04.720Z | 2024-11-23T14:23:17.216Z |
5570646 | 5570646 | 20241120203452_Ftpf8 | CZ000L | 2024-11-22T14:15:58.367Z | 2024-11-23T14:23:14.516Z |
5570606 | 5570606 | 20241120202350_39GRj | CZ000L | 2024-11-22T14:15:53.389Z | 2024-11-23T14:23:13.530Z |
5570544 | 5570544 | 20241120200126_EVP6V | CZ000L | 2024-11-22T14:15:44.162Z | 2024-11-23T14:23:12.079Z |
5570174 | 5570174 | 20241120185608_3BAli | CZ000L | 2024-11-22T14:14:57.433Z | 2024-11-23T14:23:04.895Z |
5570138 | 5570138 | 20241120185026_WaG2e | CZ000L | 2024-11-22T14:14:54.621Z | 2024-11-23T14:23:03.670Z |
5570128 | 5570128 | 20241120184741_iZS7C | CZ000L | 2024-11-22T14:14:54.188Z | 2024-11-23T14:23:03.556Z |
5570115 | 5570115 | 20241120184354_pZXTO | CZ000L | 2024-11-22T14:14:53.075Z | 2024-11-23T14:23:03.423Z |
5570097 | 5570097 | 20241120184125_cyEQl | CZ000L | 2024-11-22T14:14:51.398Z | 2024-11-23T14:23:02.106Z |
5553548 | 5553548 | 20241118031546_mOtDK | CZ000L | 2024-11-19T14:10:49.885Z | 2024-11-23T14:25:30.011Z |
5517553 | 5517553 | 20241110040154_Y9V2Z | CZ000L | 2024-11-11T14:14:34.778Z | 2024-11-18T14:26:37.127Z |
5517487 | 5517487 | 20241110035346_naUQn | CZ000L | 2024-11-11T14:14:29.550Z | 2024-11-18T14:26:36.760Z |
5517300 | 5517300 | 20241110032033_QPUPg | CZ000L | 2024-11-11T14:14:12.774Z | 2024-11-18T14:26:35.816Z |
5517253 | 5517253 | 20241110031447_zZqOR | CZ000L | 2024-11-11T14:14:09.951Z | 2024-11-18T14:26:35.651Z |
5516728 | 5516728 | 20241110015021_ueEr2 | CZ000L | 2024-11-11T14:13:17.244Z | 2024-11-18T14:26:33.013Z |
5516426 | 5516426 | 20241110005826_oj2M1 | CZ000L | 2024-11-11T14:13:00.538Z | 2024-11-18T14:26:31.177Z |
5516424 | 5516424 | 20241110005714_bwf4I | CZ000L | 2024-11-11T14:13:00.286Z | 2024-11-18T14:26:31.148Z |
5516356 | 5516356 | 20241110004522_h9PD6 | CZ000L | 2024-11-11T14:12:51.656Z | 2024-11-18T14:26:30.819Z |
5516272 | 5516272 | 20241110002626_cKF8J | CZ000L | 2024-11-11T14:12:38.649Z | 2024-11-18T14:26:30.388Z |
5516255 | 5516255 | 20241110002236_tZ3Db | CZ000L | 2024-11-11T14:12:35.635Z | 2024-11-18T14:26:30.329Z |
5516068 | 5516068 | 20241109234507_bNXEm | CZ000L | 2024-11-11T14:12:07.057Z | 2024-11-18T14:26:29.242Z |
5515976 | 5515976 | 20241109232302_RxGpj | CZ000L | 2024-11-11T14:11:52.183Z | 2024-11-18T14:26:28.764Z |
5515939 | 5515939 | 20241109231539_ajdpk | CZ000L | 2024-11-11T14:11:48.603Z | 2024-11-18T14:26:28.563Z |
5515633 | 5515633 | 20241109221208_QF0TD | CZ000L | 2024-11-11T14:11:18.453Z | 2024-11-18T14:26:27.162Z |
5515604 | 5515604 | 20241109220754_p2Nfm | CZ000L | 2024-11-11T14:11:16.777Z | 2024-11-18T14:26:27.020Z |
5515519 | 5515519 | 20241109214629_AQWqa | CZ000L | 2024-11-11T14:11:10.470Z | 2024-11-18T14:26:26.531Z |
5515403 | 5515403 | 20241109211017_Hkeq7 | CZ000L | 2024-11-11T14:10:57.488Z | 2024-11-18T14:26:25.854Z |
5515386 | 5515386 | 20241109210608_wvGf1 | CZ000L | 2024-11-11T14:10:53.044Z | 2024-11-18T14:26:25.789Z |
5515361 | 5515361 | 20241109205632_DeAJz | CZ000L | 2024-11-11T14:10:50.315Z | 2024-11-18T14:26:25.698Z |
5515254 | 5515254 | 20241109200652_4hjYS | CZ000L | 2024-11-11T14:10:28.069Z | 2024-11-18T14:26:25.130Z |
5515237 | 5515237 | 20241109195956_4QotY | CZ000L | 2024-11-11T14:10:25.215Z | 2024-11-18T14:26:25.057Z |
5515151 | 5515151 | 20241109194115_Lv0TR | CZ000L | 2024-11-11T14:10:11.491Z | 2024-11-18T14:26:24.556Z |
5515149 | 5515149 | 20241109194107_Bh4R3 | CZ000L | 2024-11-11T14:10:11.054Z | 2024-11-18T14:26:24.547Z |
5515029 | 5515029 | 20241109190451_stjMH | CZ000L | 2024-11-11T14:09:55.394Z | 2024-11-18T14:26:23.925Z |
5514898 | 5514898 | 20241109182525_FJSrh | CZ000L | 2024-11-11T14:09:42.092Z | 2024-11-18T14:26:23.178Z |
5514782 | 5514782 | 20241109173036_vdne2 | CZ000L | 2024-11-11T14:09:13.277Z | 2024-11-18T14:26:22.441Z |
5514720 | 5514720 | 20241109170628_3OkIX | CZ000L | 2024-11-11T14:09:04.119Z | 2024-11-18T14:26:22.112Z |
5510998 | 5510998 | 20241109040524_lpML5 | CZ000L | 2024-11-10T14:16:02.456Z | 2024-11-17T14:24:03.254Z |
5510850 | 5510850 | 20241109034429_8xDE9 | CZ000L | 2024-11-10T14:15:46.260Z | 2024-11-17T14:24:01.766Z |
5510774 | 5510774 | 20241109033533_FhHUN | CZ000L | 2024-11-10T14:15:41.347Z | 2024-11-17T14:24:01.244Z |
5510737 | 5510737 | 20241109033107_tEqmi | CZ000L | 2024-11-10T14:15:36.995Z | 2024-11-17T14:24:00.795Z |
5510729 | 5510729 | 20241109033008_DNuv0 | CZ000L | 2024-11-10T14:15:36.376Z | 2024-11-17T14:24:00.682Z |
5510327 | 5510327 | 20241109022137_iRT5y | CZ000L | 2024-11-10T14:15:01.603Z | 2024-11-17T14:23:56.265Z |
5505125 | 5505125 | 20241108035612_tmRrr | CZ000L | 2024-11-09T14:15:46.351Z | 2024-11-16T14:28:27.915Z |
5503987 | 5503987 | 20241108003354_GUH9T | CZ000L | 2024-11-09T14:13:56.893Z | 2024-11-16T14:28:14.645Z |
5503734 | 5503734 | 20241107234106_TTgvD | CZ000L | 2024-11-09T14:13:41.515Z | 2024-11-16T14:28:11.842Z |
5502578 | 5502578 | 20241107191022_7DY6k | CZ000L | 2024-11-09T14:11:45.770Z | 2024-11-16T14:27:57.630Z |
5502364 | 5502364 | 20241107181331_56ula | CZ000L | 2024-11-09T14:11:13.578Z | 2024-11-16T14:27:54.621Z |
5502028 | 5502028 | 20241107165609_TZuzc | CZ000L | 2024-11-09T14:10:50.848Z | 2024-11-16T14:27:49.508Z |
5501937 | 5501937 | 20241107164249_yQcOm | CZ000L | 2024-11-09T14:10:46.587Z | 2024-11-16T14:27:49.160Z |
5497438 | 5497438 | 20241107034050_3z2e6 | CZ000L | 2024-11-08T14:13:46.651Z | 2024-11-15T14:25:03.895Z |
5497346 | 5497346 | 20241107032615_I7ygw | CZ000L | 2024-11-08T14:13:36.199Z | 2024-11-15T14:25:03.036Z |
5497152 | 5497152 | 20241107025005_T6Kii | CZ000L | 2024-11-08T14:13:16.432Z | 2024-11-15T14:25:01.967Z |
5497027 | 5497027 | 20241107023035_4Cmc8 | CZ000L | 2024-11-08T14:13:06.303Z | 2024-11-15T14:25:01.397Z |
5485064 | 5485064 | 20241105040024_w0SZr | CZ000L | 2024-11-06T14:17:43.130Z | 2024-11-13T14:27:40.594Z |
5484399 | 5484399 | 20241105024506_gEfBX | CZ000L | 2024-11-06T14:16:52.690Z | 2024-11-13T14:27:37.839Z |
5483934 | 5483934 | 20241105014634_Rttq2 | CZ000L | 2024-11-06T14:15:56.092Z | 2024-11-13T14:27:37.033Z |
5483391 | 5483391 | 20241105003523_j04x3 | CZ000L | 2024-11-06T14:15:10.545Z | 2024-11-13T14:27:36.176Z |
5482478 | 5482478 | 20241104222625_rm4U1 | CZ000L | 2024-11-06T14:13:15.135Z | 2024-11-13T14:27:34.675Z |
5482369 | 5482369 | 20241104215839_EWOy5 | CZ000L | 2024-11-06T14:13:05.283Z | 2024-11-13T14:27:34.425Z |
5482220 | 5482220 | 20241104212808_nDsMf | CZ000L | 2024-11-06T14:12:37.286Z | 2024-11-13T14:27:34.143Z |
5481402 | 5481402 | 20241104173036_GpdvK | CZ000L | 2024-11-06T14:10:29.362Z | 2024-11-13T14:27:28.375Z |
5481332 | 5481332 | 20241104170614_X5hWM | CZ000L | 2024-11-06T14:10:02.443Z | 2024-11-13T14:27:27.682Z |
5481326 | 5481326 | 20241104170322_tdUUE | CZ000L | 2024-11-06T14:10:00.612Z | 2024-11-13T14:27:27.524Z |
5478439 | 5478439 | 20241104041149_MrcNr | CZ000L | 2024-11-05T14:18:22.817Z | 2024-11-12T14:28:15.406Z |
5478176 | 5478176 | 20241104033221_476LK | CZ000L | 2024-11-05T14:18:02.163Z | 2024-11-12T14:28:14.517Z |
5477613 | 5477613 | 20241104021322_oDgg4 | CZ000L | 2024-11-05T14:17:09.363Z | 2024-11-12T14:28:12.144Z |
5477534 | 5477534 | 20241104020606_w4mO0 | CZ000L | 2024-11-05T14:17:01.834Z | 2024-11-12T14:28:11.958Z |
5477422 | 5477422 | 20241104015024_3iqdW | CZ000L | 2024-11-05T14:16:52.307Z | 2024-11-12T14:28:11.533Z |
5477334 | 5477334 | 20241104013922_cgED9 | CZ000L | 2024-11-05T14:16:44.574Z | 2024-11-12T14:28:10.708Z |
5477312 | 5477312 | 20241104013545_z21sB | CZ000L | 2024-11-05T14:16:42.733Z | 2024-11-12T14:28:10.685Z |
5477309 | 5477309 | 20241104013521_LB2Mb | CZ000L | 2024-11-05T14:16:42.244Z | 2024-11-12T14:28:10.550Z |
5477170 | 5477170 | 20241104011133_22M17 | CZ000L | 2024-11-05T14:16:28.792Z | 2024-11-12T14:28:09.942Z |
5476931 | 5476931 | 20241104004324_vyn2S | CZ000L | 2024-11-05T14:16:12.856Z | 2024-11-12T14:28:07.916Z |
5476906 | 5476906 | 20241104004018_AarGc | CZ000L | 2024-11-05T14:16:11.558Z | 2024-11-12T14:28:07.875Z |
5476846 | 5476846 | 20241104003318_y20rJ | CZ000L | 2024-11-05T14:16:07.519Z | 2024-11-12T14:28:07.726Z |
5476383 | 5476383 | 20241103231837_LE5se | CZ000L | 2024-11-05T14:15:14.269Z | 2024-11-12T14:28:05.926Z |
5476315 | 5476315 | 20241103230700_cmMn7 | CZ000L | 2024-11-05T14:15:03.254Z | 2024-11-12T14:28:05.380Z |
5476041 | 5476041 | 20241103221114_borrz | CZ000L | 2024-11-05T14:14:41.238Z | 2024-11-12T14:28:02.487Z |
5475976 | 5475976 | 20241103220300_1D3m2 | CZ000L | 2024-11-05T14:14:36.889Z | 2024-11-12T14:28:01.992Z |
5475948 | 5475948 | 20241103215931_GBrUu | CZ000L | 2024-11-05T14:14:35.313Z | 2024-11-12T14:28:01.880Z |
5475857 | 5475857 | 20241103214150_hiSlK | CZ000L | 2024-11-05T14:14:23.348Z | 2024-11-12T14:28:01.603Z |
5475714 | 5475714 | 20241103210913_qqRbC | CZ000L | 2024-11-05T14:14:03.126Z | 2024-11-12T14:28:00.725Z |
5475695 | 5475695 | 20241103210411_Ruzi0 | CZ000L | 2024-11-05T14:14:01.653Z | 2024-11-12T14:28:00.542Z |
5475650 | 5475650 | 20241103205502_IErKJ | CZ000L | 2024-11-05T14:13:55.646Z | 2024-11-12T14:28:00.148Z |
5475517 | 5475517 | 20241103202210_TH6W6 | CZ000L | 2024-11-05T14:13:45.523Z | 2024-11-12T14:27:59.557Z |
5475257 | 5475257 | 20241103193801_R7GY2 | CZ000L | 2024-11-05T14:12:55.124Z | 2024-11-12T14:27:57.857Z |
5475065 | 5475065 | 20241103190052_Ibl0A | CZ000L | 2024-11-05T14:12:28.838Z | 2024-11-12T14:27:56.932Z |
5475024 | 5475024 | 20241103185212_uclmg | CZ000L | 2024-11-05T14:12:25.505Z | 2024-11-12T14:27:56.475Z |
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);