participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
839 rows where station_code = "UK0003" 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 |
---|---|---|---|---|---|
2689561 | 2689561 | 20230803023455_6WDV7 | UK0003 | 2024-01-06T00:00:11.818Z | 2024-01-06T00:00:11.818Z |
2689535 | 2689535 | 20230803020751_tTDcc | UK0003 | 2024-01-06T00:00:11.814Z | 2024-01-06T00:00:11.814Z |
2689533 | 2689533 | 20230803020538_n3G9a | UK0003 | 2024-01-06T00:00:11.813Z | 2024-01-06T00:00:11.813Z |
2677642 | 2677642 | 20230730024708_Qusys | UK0003 | 2024-01-06T00:00:05.586Z | 2024-01-06T00:00:05.586Z |
2677189 | 2677189 | 20230730014913_ubjWc | UK0003 | 2024-01-06T00:00:05.536Z | 2024-01-06T00:00:05.536Z |
2677109 | 2677109 | 20230730013740_tAg9t | UK0003 | 2024-01-06T00:00:05.525Z | 2024-01-06T00:00:05.525Z |
2677027 | 2677027 | 20230730012457_UDbnb | UK0003 | 2024-01-06T00:00:05.515Z | 2024-01-06T00:00:05.515Z |
2676335 | 2676335 | 20230729234809_V8q2n | UK0003 | 2024-01-06T00:00:05.431Z | 2024-01-06T00:00:05.431Z |
2666541 | 2666541 | 20230728011038_hme2J | UK0003 | 2024-01-06T00:00:00.972Z | 2024-01-06T00:00:00.972Z |
2665851 | 2665851 | 20230727233056_VA1fy | UK0003 | 2024-01-06T00:00:00.711Z | 2024-01-06T00:00:00.711Z |
2665327 | 2665327 | 20230727221246_k0mtY | UK0003 | 2024-01-06T00:00:00.515Z | 2024-01-06T00:00:00.515Z |
2656271 | 2656271 | 20230725231024_b3Nb1 | UK0003 | 2024-01-05T23:59:54.193Z | 2024-01-05T23:59:54.193Z |
2637603 | 2637603 | 20230721015541_vrBM2 | UK0003 | 2024-01-05T23:59:41.591Z | 2024-01-05T23:59:41.591Z |
2637587 | 2637587 | 20230721015403_6dzp7 | UK0003 | 2024-01-05T23:59:41.590Z | 2024-01-05T23:59:41.590Z |
2637548 | 2637548 | 20230721014909_ZZW3E | UK0003 | 2024-01-05T23:59:41.587Z | 2024-01-05T23:59:41.587Z |
2632181 | 2632181 | 20230719223323_zZ1bl | UK0003 | 2024-01-05T23:59:39.794Z | 2024-01-05T23:59:39.794Z |
2595231 | 2595231 | 20230709231507_HAxyV | UK0003 | 2024-01-05T23:59:24.011Z | 2024-01-05T23:59:24.011Z |
2595161 | 2595161 | 20230709230500_00Ube | UK0003 | 2024-01-05T23:59:24.005Z | 2024-01-05T23:59:24.005Z |
2591286 | 2591286 | 20230708014212_P05m2 | UK0003 | 2024-01-05T23:59:21.184Z | 2024-01-05T23:59:21.184Z |
2589751 | 2589751 | 20230707224957_hMRTp | UK0003 | 2024-01-05T23:59:21.054Z | 2024-01-05T23:59:21.054Z |
2587052 | 2587052 | 20230706232530_oFWCf | UK0003 | 2024-01-05T23:59:19.618Z | 2024-01-05T23:59:19.618Z |
2586663 | 2586663 | 20230706223317_98aFa | UK0003 | 2024-01-05T23:59:19.586Z | 2024-01-05T23:59:19.586Z |
2585099 | 2585099 | 20230706013219_23Smo | UK0003 | 2024-01-05T23:59:18.153Z | 2024-01-05T23:59:18.153Z |
2582031 | 2582031 | 20230704005852_bxGTU | UK0003 | 2024-01-05T23:59:15.527Z | 2024-01-05T23:59:15.527Z |
2581232 | 2581232 | 20230703012643_rxzhW | UK0003 | 2024-01-05T23:59:14.305Z | 2024-01-05T23:59:14.305Z |
2565702 | 2565702 | 20230626013017_Z5je4 | UK0003 | 2024-01-05T23:59:01.348Z | 2024-01-05T23:59:01.348Z |
2564680 | 2564680 | 20230626000958_EynTP | UK0003 | 2024-01-05T23:59:00.926Z | 2024-01-05T23:59:00.926Z |
2528574 | 2528574 | 20230614000406_1oH3N | UK0003 | 2024-01-05T23:58:35.634Z | 2024-01-05T23:58:35.634Z |
2500557 | 2500557 | 20230530001207_bEVy7 | UK0003 | 2024-01-05T23:58:10.546Z | 2024-01-05T23:58:10.546Z |
2500539 | 2500539 | 20230530001207_kI392 | UK0003 | 2024-01-05T23:58:10.541Z | 2024-01-05T23:58:10.541Z |
2498373 | 2498373 | 20230529000301_j1zo0 | UK0003 | 2024-01-05T23:58:08.649Z | 2024-01-05T23:58:08.649Z |
2492606 | 2492606 | 20230526223141_9gMwy | UK0003 | 2024-01-05T23:58:05.741Z | 2024-01-05T23:58:05.741Z |
2473662 | 2473662 | 20230521015202_8486w | UK0003 | 2024-01-05T23:57:53.998Z | 2024-01-05T23:57:53.998Z |
2470912 | 2470912 | 20230520011119_EtLiA | UK0003 | 2024-01-05T23:57:52.584Z | 2024-01-05T23:57:52.584Z |
2461385 | 2461385 | 20230516022538_XkB4V | UK0003 | 2024-01-05T23:57:44.732Z | 2024-01-05T23:57:44.732Z |
2461321 | 2461321 | 20230516020927_3rsvp | UK0003 | 2024-01-05T23:57:44.726Z | 2024-01-05T23:57:44.726Z |
2422973 | 2422973 | 20230427012734_U3sZR | UK0003 | 2024-01-05T23:57:15.970Z | 2024-01-05T23:57:15.970Z |
2414946 | 2414946 | 20230424032835_QtO3z | UK0003 | 2024-01-05T23:57:11.568Z | 2024-01-05T23:57:11.568Z |
2375281 | 2375281 | 20230411034040_sQyJH | UK0003 | 2024-01-05T23:56:48.391Z | 2024-01-05T23:56:48.391Z |
2369863 | 2369863 | 20230408020407_P4QY4 | UK0003 | 2024-01-05T23:56:41.805Z | 2024-01-05T23:56:41.805Z |
2369808 | 2369808 | 20230408015011_08HMa | UK0003 | 2024-01-05T23:56:41.801Z | 2024-01-05T23:56:41.801Z |
2368042 | 2368042 | 20230407022030_2Htqs | UK0003 | 2024-01-05T23:56:40.474Z | 2024-01-05T23:56:40.474Z |
2364606 | 2364606 | 20230404021310_PAFEl | UK0003 | 2024-01-05T23:56:36.789Z | 2024-01-05T23:56:36.789Z |
2364119 | 2364119 | 20230403224412_QIzeA | UK0003 | 2024-01-05T23:56:36.741Z | 2024-01-05T23:56:36.741Z |
2361999 | 2361999 | 20230402225556_T6HoP | UK0003 | 2024-01-05T23:56:35.369Z | 2024-01-05T23:56:35.369Z |
2345012 | 2345012 | 20230324045016_6eOaA | UK0003 | 2024-01-05T23:56:21.065Z | 2024-01-05T23:56:21.065Z |
2318742 | 2318742 | 20230307201629_f2UEG | UK0003 | 2024-01-05T23:55:55.060Z | 2024-01-05T23:55:55.060Z |
2267461 | 2267461 | 20230209214101_VZAKa | UK0003 | 2024-01-05T23:55:10.315Z | 2024-01-05T23:55:10.315Z |
2264367 | 2264367 | 20230208051921_Vq22H | UK0003 | 2024-01-05T23:55:05.385Z | 2024-01-05T23:55:05.385Z |
2263234 | 2263234 | 20230207221351_X1aGA | UK0003 | 2024-01-05T23:55:05.255Z | 2024-01-05T23:55:05.255Z |
2262191 | 2262191 | 20230207051058_vjRwR | UK0003 | 2024-01-05T23:55:03.936Z | 2024-01-05T23:55:03.936Z |
2261528 | 2261528 | 20230206232500_TCJVy | UK0003 | 2024-01-05T23:55:03.851Z | 2024-01-05T23:55:03.851Z |
2261471 | 2261471 | 20230206223324_M9AC3 | UK0003 | 2024-01-05T23:55:03.844Z | 2024-01-05T23:55:03.844Z |
2252805 | 2252805 | 20230131233849_jwaY9 | UK0003 | 2024-01-05T23:54:54.111Z | 2024-01-05T23:54:54.111Z |
2251104 | 2251104 | 20230131023126_kGLc8 | UK0003 | 2024-01-05T23:54:51.909Z | 2024-01-05T23:54:51.909Z |
2228916 | 2228916 | 20230124062759_RwFTK | UK0003 | 2024-01-05T23:54:39.212Z | 2024-01-05T23:54:39.212Z |
2211961 | 2211961 | 20230120013205_2CAWf | UK0003 | 2024-01-05T23:54:28.027Z | 2024-01-05T23:54:28.027Z |
2208707 | 2208707 | 20230119060659_WXQNr | UK0003 | 2024-01-05T23:54:25.028Z | 2024-01-05T23:54:25.028Z |
2195745 | 2195745 | 20230114234148_XWY6H | UK0003 | 2024-01-05T23:54:17.669Z | 2024-01-05T23:54:17.669Z |
2187307 | 2187307 | 20230110010608_R9Wr8 | UK0003 | 2024-01-05T23:54:11.072Z | 2024-01-05T23:54:11.072Z |
2184771 | 2184771 | 20230108025300_2kw3U | UK0003 | 2024-01-05T23:54:08.543Z | 2024-01-05T23:54:08.543Z |
2180113 | 2180113 | 20230104062951_L392P | UK0003 | 2024-01-05T23:54:03.375Z | 2024-01-05T23:54:03.375Z |
2168991 | 2168991 | 20221229034959_8P3lk | UK0003 | 2024-01-05T23:53:56.351Z | 2024-01-05T23:53:56.351Z |
2163521 | 2163521 | 20221227022438_cd2Go | UK0003 | 2024-01-05T23:53:52.205Z | 2024-01-05T23:53:52.205Z |
2154777 | 2154777 | 20221225190830_Kt8SF | UK0003 | 2024-01-05T23:53:50.135Z | 2024-01-05T23:53:50.135Z |
2145723 | 2145723 | 20221224001728_Vzoka | UK0003 | 2024-01-05T23:53:46.784Z | 2024-01-05T23:53:46.784Z |
2136465 | 2136465 | 20221221065339_3tAVB | UK0003 | 2024-01-05T23:53:42.973Z | 2024-01-05T23:53:42.973Z |
2136283 | 2136283 | 20221221055154_4kXpR | UK0003 | 2024-01-05T23:53:42.952Z | 2024-01-05T23:53:42.952Z |
2060667 | 2060667 | 20221214052046_54ILb | UK0003 | 2024-01-05T23:53:23.408Z | 2024-01-05T23:53:23.408Z |
2036637 | 2036637 | 20221211231018_hd9xE | UK0003 | 2024-01-05T23:53:17.353Z | 2024-01-05T23:53:17.353Z |
2028400 | 2028400 | 20221210022109_P9A8d | UK0003 | 2024-01-05T23:53:14.012Z | 2024-01-05T23:53:14.012Z |
2026275 | 2026275 | 20221209044133_M2Wqi | UK0003 | 2024-01-05T23:53:12.593Z | 2024-01-05T23:53:12.593Z |
2026236 | 2026236 | 20221209042800_1x5Jx | UK0003 | 2024-01-05T23:53:12.588Z | 2024-01-05T23:53:12.588Z |
2026093 | 2026093 | 20221209035223_3YViA | UK0003 | 2024-01-05T23:53:12.576Z | 2024-01-05T23:53:12.576Z |
2025727 | 2025727 | 20221209015853_vJ3u2 | UK0003 | 2024-01-05T23:53:12.537Z | 2024-01-05T23:53:12.537Z |
2025713 | 2025713 | 20221209015315_O6DU9 | UK0003 | 2024-01-05T23:53:12.536Z | 2024-01-05T23:53:12.536Z |
2025576 | 2025576 | 20221209004349_AVON5 | UK0003 | 2024-01-05T23:53:12.521Z | 2024-01-05T23:53:12.521Z |
2025214 | 2025214 | 20221208203056_waWME | UK0003 | 2024-01-05T23:53:12.487Z | 2024-01-05T23:53:12.487Z |
2023563 | 2023563 | 20221208015336_WvWzP | UK0003 | 2024-01-05T23:53:11.173Z | 2024-01-05T23:53:11.173Z |
2021769 | 2021769 | 20221207025141_wInvB | UK0003 | 2024-01-05T23:53:09.861Z | 2024-01-05T23:53:09.861Z |
2021732 | 2021732 | 20221207023404_uPmC3 | UK0003 | 2024-01-05T23:53:09.858Z | 2024-01-05T23:53:09.858Z |
2021716 | 2021716 | 20221207022237_uFzwW | UK0003 | 2024-01-05T23:53:09.856Z | 2024-01-05T23:53:09.856Z |
2021297 | 2021297 | 20221206203611_TBzbK | UK0003 | 2024-01-05T23:53:09.812Z | 2024-01-05T23:53:09.812Z |
2020335 | 2020335 | 20221206040227_ycMiO | UK0003 | 2024-01-05T23:53:08.482Z | 2024-01-05T23:53:08.482Z |
2020221 | 2020221 | 20221206030510_fafk0 | UK0003 | 2024-01-05T23:53:08.466Z | 2024-01-05T23:53:08.466Z |
1982045 | 1982045 | 20221125031402_mozaE | UK0003 | 2024-01-05T23:52:45.528Z | 2024-01-05T23:52:45.528Z |
1979612 | 1979612 | 20221124180422_9fJqy | UK0003 | 2024-01-05T23:52:45.271Z | 2024-01-05T23:52:45.271Z |
1976142 | 1976142 | 20221124052705_Eb70L | UK0003 | 2024-01-05T23:52:43.534Z | 2024-01-05T23:52:43.534Z |
1975778 | 1975778 | 20221124045330_saYRW | UK0003 | 2024-01-05T23:52:43.496Z | 2024-01-05T23:52:43.496Z |
1974588 | 1974588 | 20221124031330_z4yDY | UK0003 | 2024-01-05T23:52:43.382Z | 2024-01-05T23:52:43.382Z |
1958396 | 1958396 | 20221121002729_3D41D | UK0003 | 2024-01-05T23:52:36.497Z | 2024-01-05T23:52:36.497Z |
1958299 | 1958299 | 20221121001558_RJOVI | UK0003 | 2024-01-05T23:52:36.476Z | 2024-01-05T23:52:36.476Z |
1948810 | 1948810 | 20221119014244_BhCem | UK0003 | 2024-01-05T23:52:30.189Z | 2024-01-05T23:52:30.189Z |
1947605 | 1947605 | 20221118192334_umyOZ | UK0003 | 2024-01-05T23:52:29.756Z | 2024-01-05T23:52:29.756Z |
1947366 | 1947366 | 20221118181734_slXON | UK0003 | 2024-01-05T23:52:29.655Z | 2024-01-05T23:52:29.655Z |
1945438 | 1945438 | 20221118053358_dePL1 | UK0003 | 2024-01-05T23:52:27.900Z | 2024-01-05T23:52:27.900Z |
1936651 | 1936651 | 20221116054641_NNFCQ | UK0003 | 2024-01-05T23:52:21.790Z | 2024-01-05T23:52:21.790Z |
1924867 | 1924867 | 20221113022544_vLI9l | UK0003 | 2024-01-05T23:52:13.247Z | 2024-01-05T23:52:13.247Z |
1771976 | 1771976 | 20221015214541_gw03N | UK0003 | 2024-01-05T23:51:06.981Z | 2024-01-05T23:51:06.981Z |
1771551 | 1771551 | 20221015184136_1aZIt | UK0003 | 2024-01-05T23:51:06.921Z | 2024-01-05T23:51:06.921Z |
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);