participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,062 rows where station_code = "UK0066" 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 |
---|---|---|---|---|---|
5134053 | 5134053 | 20240916043619_vYGxh | UK0066 | 2024-09-19T12:17:17.288Z | 2024-09-19T12:17:17.288Z |
5134050 | 5134050 | 20240916043543_SJXvl | UK0066 | 2024-09-19T12:17:17.135Z | 2024-09-19T12:17:17.135Z |
5133983 | 5133983 | 20240916042509_s0S2D | UK0066 | 2024-09-19T12:17:15.446Z | 2024-09-19T12:17:15.446Z |
5133871 | 5133871 | 20240916041221_wW6fR | UK0066 | 2024-09-19T12:17:11.403Z | 2024-09-19T12:17:11.403Z |
5133858 | 5133858 | 20240916041202_sk2gP | UK0066 | 2024-09-19T12:17:11.016Z | 2024-09-19T12:17:11.016Z |
5133707 | 5133707 | 20240916035213_847mi | UK0066 | 2024-09-19T12:17:05.549Z | 2024-09-19T12:17:05.549Z |
5133694 | 5133694 | 20240916035118_59DwK | UK0066 | 2024-09-19T12:17:05.382Z | 2024-09-19T12:17:05.382Z |
5133602 | 5133602 | 20240916034628_GWcSj | UK0066 | 2024-09-19T12:17:03.639Z | 2024-09-19T12:17:03.639Z |
5133455 | 5133455 | 20240916033123_BTZgP | UK0066 | 2024-09-19T12:16:57.135Z | 2024-09-19T12:16:57.135Z |
5133352 | 5133352 | 20240916032535_cgu3c | UK0066 | 2024-09-19T12:16:54.992Z | 2024-09-19T12:16:54.992Z |
5133280 | 5133280 | 20240916031803_6nkNF | UK0066 | 2024-09-19T12:16:52.664Z | 2024-09-19T12:16:52.664Z |
5133187 | 5133187 | 20240916030536_PPRja | UK0066 | 2024-09-19T12:16:47.942Z | 2024-09-19T12:16:47.942Z |
5132987 | 5132987 | 20240916024125_S4ble | UK0066 | 2024-09-19T12:16:40.187Z | 2024-09-19T12:16:40.187Z |
5132876 | 5132876 | 20240916022414_rhaB4 | UK0066 | 2024-09-19T12:16:35.132Z | 2024-09-19T12:16:35.132Z |
5132715 | 5132715 | 20240916020116_fataV | UK0066 | 2024-09-19T12:16:29.275Z | 2024-09-19T12:16:29.275Z |
5132688 | 5132688 | 20240916015749_YcIIV | UK0066 | 2024-09-19T12:16:27.839Z | 2024-09-19T12:16:27.839Z |
5132648 | 5132648 | 20240916015018_RqWaT | UK0066 | 2024-09-19T12:16:24.897Z | 2024-09-19T12:16:24.897Z |
5132620 | 5132620 | 20240916014556_9ikCq | UK0066 | 2024-09-19T12:16:23.180Z | 2024-09-19T12:16:23.180Z |
5132560 | 5132560 | 20240916012958_ZQHry | UK0066 | 2024-09-19T12:16:18.815Z | 2024-09-19T12:16:18.815Z |
5132549 | 5132549 | 20240916012921_Pbrr2 | UK0066 | 2024-09-19T12:16:18.669Z | 2024-09-19T12:16:18.669Z |
5132402 | 5132402 | 20240916010127_5yF2n | UK0066 | 2024-09-19T12:16:10.980Z | 2024-09-19T12:16:10.980Z |
5132322 | 5132322 | 20240916003336_buNF3 | UK0066 | 2024-09-19T12:16:07.274Z | 2024-09-19T12:16:07.274Z |
5132270 | 5132270 | 20240916001432_FBg0w | UK0066 | 2024-09-19T12:16:02.774Z | 2024-09-19T12:16:02.774Z |
5132173 | 5132173 | 20240915235207_uoYAO | UK0066 | 2024-09-19T12:15:54.534Z | 2024-09-19T12:15:54.534Z |
5132168 | 5132168 | 20240915235000_vhV3R | UK0066 | 2024-09-19T12:15:54.175Z | 2024-09-19T12:15:54.175Z |
5132152 | 5132152 | 20240915234306_mepEv | UK0066 | 2024-09-19T12:15:53.279Z | 2024-09-19T12:15:53.279Z |
5132108 | 5132108 | 20240915232528_rAaSd | UK0066 | 2024-09-19T12:15:50.849Z | 2024-09-19T12:15:50.849Z |
5132085 | 5132085 | 20240915231341_DYi3B | UK0066 | 2024-09-19T12:15:49.197Z | 2024-09-19T12:15:49.197Z |
5132078 | 5132078 | 20240915230453_wZ2Rj | UK0066 | 2024-09-19T12:15:48.838Z | 2024-09-19T12:15:48.838Z |
5132064 | 5132064 | 20240915225950_dtSoF | UK0066 | 2024-09-19T12:15:47.694Z | 2024-09-19T12:15:47.694Z |
5132025 | 5132025 | 20240915224932_NBigW | UK0066 | 2024-09-19T12:15:44.232Z | 2024-09-19T12:15:44.232Z |
5131977 | 5131977 | 20240915222731_VhgEv | UK0066 | 2024-09-19T12:15:39.455Z | 2024-09-19T12:15:39.455Z |
5131964 | 5131964 | 20240915222456_2jpn7 | UK0066 | 2024-09-19T12:15:37.780Z | 2024-09-19T12:15:37.780Z |
5131937 | 5131937 | 20240915222118_A0smM | UK0066 | 2024-09-19T12:15:35.188Z | 2024-09-19T12:15:35.188Z |
5131924 | 5131924 | 20240915221506_qWVVk | UK0066 | 2024-09-19T12:15:34.208Z | 2024-09-19T12:15:34.208Z |
5131639 | 5131639 | 20240915203900_KiMRx | UK0066 | 2024-09-19T12:15:12.554Z | 2024-09-19T12:15:12.554Z |
5131556 | 5131556 | 20240915201717_XZxcW | UK0066 | 2024-09-19T12:15:09.130Z | 2024-09-19T12:15:09.130Z |
5131514 | 5131514 | 20240915200842_IT5Sy | UK0066 | 2024-09-19T12:15:07.266Z | 2024-09-19T12:15:07.266Z |
5131452 | 5131452 | 20240915195639_iNvFO | UK0066 | 2024-09-19T12:15:04.287Z | 2024-09-19T12:15:04.287Z |
5129155 | 5129155 | 20240917033052_oe73K | UK0066 | 2024-09-19T12:11:17.998Z | 2024-09-19T12:11:17.998Z |
5128923 | 5128923 | 20240917025428_WBORR | UK0066 | 2024-09-19T12:11:07.496Z | 2024-09-19T12:11:07.496Z |
5128885 | 5128885 | 20240917025049_qWLJp | UK0066 | 2024-09-19T12:11:05.305Z | 2024-09-19T12:11:05.305Z |
5128877 | 5128877 | 20240917025000_Em021 | UK0066 | 2024-09-19T12:11:04.626Z | 2024-09-19T12:11:04.626Z |
5127115 | 5127115 | 20240916202819_dsDHh | UK0066 | 2024-09-19T12:08:14.146Z | 2024-09-19T12:08:14.146Z |
5126823 | 5126823 | 20240916193845_hnMQJ | UK0066 | 2024-09-19T12:07:22.318Z | 2024-09-19T12:07:22.318Z |
5125904 | 5125904 | 20240918043221_RqUYE | UK0066 | 2024-09-19T12:04:31.444Z | 2024-09-19T12:06:42.105Z |
5125892 | 5125892 | 20240918042759_FTTQu | UK0066 | 2024-09-19T12:04:29.912Z | 2024-09-19T12:06:42.103Z |
5125860 | 5125860 | 20240918041327_KQyP5 | UK0066 | 2024-09-19T12:04:20.187Z | 2024-09-19T12:06:42.097Z |
5125821 | 5125821 | 20240918040151_q8sKB | UK0066 | 2024-09-19T12:04:10.270Z | 2024-09-19T12:06:42.090Z |
5125742 | 5125742 | 20240918033501_HyNm2 | UK0066 | 2024-09-19T12:03:59.578Z | 2024-09-19T12:06:42.078Z |
5125393 | 5125393 | 20240918022633_9kF5Y | UK0066 | 2024-09-19T12:03:08.953Z | 2024-09-19T12:06:42.026Z |
5125354 | 5125354 | 20240918021755_5XYvL | UK0066 | 2024-09-19T12:03:03.168Z | 2024-09-19T12:06:42.019Z |
5125329 | 5125329 | 20240918020929_Xsavy | UK0066 | 2024-09-19T12:02:52.785Z | 2024-09-19T12:06:42.013Z |
5125195 | 5125195 | 20240918010545_oKqlm | UK0066 | 2024-09-19T12:02:28.976Z | 2024-09-19T12:06:41.990Z |
5125077 | 5125077 | 20240917235811_ooIZR | UK0066 | 2024-09-19T12:02:09.508Z | 2024-09-19T12:06:41.972Z |
5124902 | 5124902 | 20240917224318_ge9in | UK0066 | 2024-09-19T12:01:46.084Z | 2024-09-19T12:06:41.949Z |
5124691 | 5124691 | 20240917214741_XddWf | UK0066 | 2024-09-19T12:01:19.705Z | 2024-09-19T12:06:41.924Z |
5124581 | 5124581 | 20240917211847_BVuvB | UK0066 | 2024-09-19T12:01:09.986Z | 2024-09-19T12:06:41.913Z |
5124514 | 5124514 | 20240917205544_PJHTu | UK0066 | 2024-09-19T12:01:05.165Z | 2024-09-19T12:06:41.906Z |
5124455 | 5124455 | 20240917202244_bGSIN | UK0066 | 2024-09-19T12:00:57.057Z | 2024-09-19T12:06:41.897Z |
5124391 | 5124391 | 20240917195216_5Fjfm | UK0066 | 2024-09-19T12:00:43.557Z | 2024-09-19T12:06:41.886Z |
5107862 | 5107862 | 20240913041241_AfvpN | UK0066 | 2024-09-17T12:13:24.976Z | 2024-09-19T12:20:47.611Z |
5107630 | 5107630 | 20240913040544_jL7IF | UK0066 | 2024-09-17T12:13:20.061Z | 2024-09-19T12:20:47.380Z |
5107395 | 5107395 | 20240913035416_hTfQg | UK0066 | 2024-09-17T12:13:14.356Z | 2024-09-19T12:20:47.043Z |
5107281 | 5107281 | 20240913035024_owwnF | UK0066 | 2024-09-17T12:13:12.333Z | 2024-09-19T12:20:46.979Z |
5107013 | 5107013 | 20240913034209_YSbYY | UK0066 | 2024-09-17T12:13:07.943Z | 2024-09-19T12:20:46.776Z |
5106830 | 5106830 | 20240913033616_VaHVL | UK0066 | 2024-09-17T12:13:02.503Z | 2024-09-19T12:20:46.476Z |
5106664 | 5106664 | 20240913033149_ujDvu | UK0066 | 2024-09-17T12:12:59.152Z | 2024-09-19T12:20:46.246Z |
5106341 | 5106341 | 20240913032010_bN9o4 | UK0066 | 2024-09-17T12:12:50.692Z | 2024-09-19T12:20:45.962Z |
5106316 | 5106316 | 20240913031823_RqNvZ | UK0066 | 2024-09-17T12:12:49.714Z | 2024-09-19T12:20:45.821Z |
5106257 | 5106257 | 20240913031605_MTFFv | UK0066 | 2024-09-17T12:12:46.753Z | 2024-09-19T12:20:45.693Z |
5106114 | 5106114 | 20240913031146_n7YuO | UK0066 | 2024-09-17T12:12:42.511Z | 2024-09-19T12:20:45.502Z |
5106022 | 5106022 | 20240913030700_wdh3W | UK0066 | 2024-09-17T12:12:38.509Z | 2024-09-19T12:20:45.352Z |
5105979 | 5105979 | 20240913030454_c947D | UK0066 | 2024-09-17T12:12:34.701Z | 2024-09-19T12:20:45.092Z |
5105416 | 5105416 | 20240913024438_A3Icx | UK0066 | 2024-09-17T12:12:14.337Z | 2024-09-19T12:20:44.404Z |
5105238 | 5105238 | 20240913023850_B3Vms | UK0066 | 2024-09-17T12:12:05.136Z | 2024-09-19T12:20:44.161Z |
5105232 | 5105232 | 20240913023836_Jw8DT | UK0066 | 2024-09-17T12:12:03.533Z | 2024-09-19T12:20:44.155Z |
5105212 | 5105212 | 20240913023725_0G2TM | UK0066 | 2024-09-17T12:12:02.707Z | 2024-09-19T12:20:44.123Z |
5105081 | 5105081 | 20240913022951_1AB3p | UK0066 | 2024-09-17T12:11:53.069Z | 2024-09-19T12:20:43.468Z |
5104990 | 5104990 | 20240913022617_mMnU2 | UK0066 | 2024-09-17T12:11:48.674Z | 2024-09-19T12:20:43.326Z |
5104891 | 5104891 | 20240913022313_6T24D | UK0066 | 2024-09-17T12:11:45.994Z | 2024-09-19T12:20:43.084Z |
5104303 | 5104303 | 20240913020236_ZhgY2 | UK0066 | 2024-09-17T12:11:32.397Z | 2024-09-19T12:20:41.345Z |
5104298 | 5104298 | 20240913020228_Yunhp | UK0066 | 2024-09-17T12:11:32.189Z | 2024-09-19T12:20:41.337Z |
5104255 | 5104255 | 20240913020146_Hj2A3 | UK0066 | 2024-09-17T12:11:31.081Z | 2024-09-19T12:20:41.299Z |
5103880 | 5103880 | 20240913014240_nUDbd | UK0066 | 2024-09-17T12:11:15.065Z | 2024-09-19T12:20:40.641Z |
5103784 | 5103784 | 20240913013943_gybDi | UK0066 | 2024-09-17T12:11:10.433Z | 2024-09-19T12:20:40.463Z |
5103656 | 5103656 | 20240913013531_NpJ3c | UK0066 | 2024-09-17T12:11:07.526Z | 2024-09-19T12:20:40.399Z |
5103506 | 5103506 | 20240913013150_914PB | UK0066 | 2024-09-17T12:11:00.770Z | 2024-09-19T12:20:40.231Z |
5103397 | 5103397 | 20240913012935_YOFY1 | UK0066 | 2024-09-17T12:10:56.000Z | 2024-09-19T12:20:40.148Z |
5098208 | 5098208 | 20240913012229_VBFfc | UK0066 | 2024-09-16T12:17:21.644Z | 2024-09-19T12:20:39.864Z |
5098028 | 5098028 | 20240913011402_lQ9lC | UK0066 | 2024-09-16T12:17:18.669Z | 2024-09-19T12:20:39.534Z |
5097900 | 5097900 | 20240913010825_W3cdB | UK0066 | 2024-09-16T12:17:16.503Z | 2024-09-19T12:20:39.173Z |
5097595 | 5097595 | 20240913005639_uiiK0 | UK0066 | 2024-09-16T12:17:13.585Z | 2024-09-19T12:20:38.747Z |
5094857 | 5094857 | 20240912042709_2LoKO | UK0066 | 2024-09-16T12:14:59.416Z | 2024-09-19T12:21:16.450Z |
5094720 | 5094720 | 20240912041942_gATya | UK0066 | 2024-09-16T12:14:56.819Z | 2024-09-19T12:21:16.403Z |
5094366 | 5094366 | 20240912035802_hWCem | UK0066 | 2024-09-16T12:14:42.359Z | 2024-09-19T12:21:16.093Z |
5093636 | 5093636 | 20240912033047_JhVCW | UK0066 | 2024-09-16T12:14:23.130Z | 2024-09-19T12:21:15.541Z |
5093396 | 5093396 | 20240912031953_iXQec | UK0066 | 2024-09-16T12:14:16.218Z | 2024-09-19T12:21:15.302Z |
5093116 | 5093116 | 20240912031129_Dfkep | UK0066 | 2024-09-16T12:14:11.797Z | 2024-09-19T12:21:14.947Z |
5093023 | 5093023 | 20240912030753_zkRxA | UK0066 | 2024-09-16T12:14:10.042Z | 2024-09-19T12:21:14.840Z |
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);