participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,161 rows where station_code = "UK0061" 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 |
---|---|---|---|---|---|
5134049 | 5134049 | 20240916043543_SJXvl | UK0061 | 2024-09-19T12:17:17.135Z | 2024-09-19T12:17:17.135Z |
5133982 | 5133982 | 20240916042509_s0S2D | UK0061 | 2024-09-19T12:17:15.446Z | 2024-09-19T12:17:15.446Z |
5133351 | 5133351 | 20240916032535_cgu3c | UK0061 | 2024-09-19T12:16:54.992Z | 2024-09-19T12:16:54.992Z |
5132986 | 5132986 | 20240916024125_S4ble | UK0061 | 2024-09-19T12:16:40.187Z | 2024-09-19T12:16:40.187Z |
5132875 | 5132875 | 20240916022414_rhaB4 | UK0061 | 2024-09-19T12:16:35.132Z | 2024-09-19T12:16:35.132Z |
5132714 | 5132714 | 20240916020116_fataV | UK0061 | 2024-09-19T12:16:29.275Z | 2024-09-19T12:16:29.275Z |
5132401 | 5132401 | 20240916010127_5yF2n | UK0061 | 2024-09-19T12:16:10.979Z | 2024-09-19T12:16:10.979Z |
5132321 | 5132321 | 20240916003336_buNF3 | UK0061 | 2024-09-19T12:16:07.274Z | 2024-09-19T12:16:07.274Z |
5132172 | 5132172 | 20240915235207_uoYAO | UK0061 | 2024-09-19T12:15:54.534Z | 2024-09-19T12:15:54.534Z |
5132167 | 5132167 | 20240915235000_vhV3R | UK0061 | 2024-09-19T12:15:54.175Z | 2024-09-19T12:15:54.175Z |
5132084 | 5132084 | 20240915231341_DYi3B | UK0061 | 2024-09-19T12:15:49.197Z | 2024-09-19T12:15:49.197Z |
5131976 | 5131976 | 20240915222731_VhgEv | UK0061 | 2024-09-19T12:15:39.455Z | 2024-09-19T12:15:39.455Z |
5131963 | 5131963 | 20240915222456_2jpn7 | UK0061 | 2024-09-19T12:15:37.780Z | 2024-09-19T12:15:37.780Z |
5131936 | 5131936 | 20240915222118_A0smM | UK0061 | 2024-09-19T12:15:35.188Z | 2024-09-19T12:15:35.188Z |
5131638 | 5131638 | 20240915203900_KiMRx | UK0061 | 2024-09-19T12:15:12.554Z | 2024-09-19T12:15:12.554Z |
5131555 | 5131555 | 20240915201717_XZxcW | UK0061 | 2024-09-19T12:15:09.130Z | 2024-09-19T12:15:09.130Z |
5131451 | 5131451 | 20240915195639_iNvFO | UK0061 | 2024-09-19T12:15:04.287Z | 2024-09-19T12:15:04.287Z |
5129269 | 5129269 | 20240917034351_jWav4 | UK0061 | 2024-09-19T12:11:25.043Z | 2024-09-19T12:11:25.043Z |
5128811 | 5128811 | 20240917024351_kv0kn | UK0061 | 2024-09-19T12:11:02.928Z | 2024-09-19T12:11:02.928Z |
5125903 | 5125903 | 20240918043221_RqUYE | UK0061 | 2024-09-19T12:04:31.444Z | 2024-09-19T12:06:42.105Z |
5125194 | 5125194 | 20240918010545_oKqlm | UK0061 | 2024-09-19T12:02:28.976Z | 2024-09-19T12:06:41.990Z |
5124690 | 5124690 | 20240917214741_XddWf | UK0061 | 2024-09-19T12:01:19.705Z | 2024-09-19T12:06:41.924Z |
5124580 | 5124580 | 20240917211847_BVuvB | UK0061 | 2024-09-19T12:01:09.986Z | 2024-09-19T12:06:41.913Z |
5124454 | 5124454 | 20240917202244_bGSIN | UK0061 | 2024-09-19T12:00:57.052Z | 2024-09-19T12:06:41.897Z |
5107861 | 5107861 | 20240913041241_AfvpN | UK0061 | 2024-09-17T12:13:24.976Z | 2024-09-19T12:20:47.611Z |
5107629 | 5107629 | 20240913040544_jL7IF | UK0061 | 2024-09-17T12:13:20.061Z | 2024-09-19T12:20:47.380Z |
5107394 | 5107394 | 20240913035416_hTfQg | UK0061 | 2024-09-17T12:13:14.356Z | 2024-09-19T12:20:47.043Z |
5107012 | 5107012 | 20240913034209_YSbYY | UK0061 | 2024-09-17T12:13:07.943Z | 2024-09-19T12:20:46.776Z |
5106663 | 5106663 | 20240913033149_ujDvu | UK0061 | 2024-09-17T12:12:59.152Z | 2024-09-19T12:20:46.246Z |
5106340 | 5106340 | 20240913032010_bN9o4 | UK0061 | 2024-09-17T12:12:50.692Z | 2024-09-19T12:20:45.962Z |
5105978 | 5105978 | 20240913030454_c947D | UK0061 | 2024-09-17T12:12:34.701Z | 2024-09-19T12:20:45.092Z |
5105237 | 5105237 | 20240913023850_B3Vms | UK0061 | 2024-09-17T12:12:05.136Z | 2024-09-19T12:20:44.161Z |
5105211 | 5105211 | 20240913023725_0G2TM | UK0061 | 2024-09-17T12:12:02.707Z | 2024-09-19T12:20:44.123Z |
5104297 | 5104297 | 20240913020228_Yunhp | UK0061 | 2024-09-17T12:11:32.189Z | 2024-09-19T12:20:41.337Z |
5104254 | 5104254 | 20240913020146_Hj2A3 | UK0061 | 2024-09-17T12:11:31.080Z | 2024-09-19T12:20:41.299Z |
5104099 | 5104099 | 20240913015204_b4ATI | UK0061 | 2024-09-17T12:11:25.266Z | 2024-09-19T12:20:40.987Z |
5103783 | 5103783 | 20240913013943_gybDi | UK0061 | 2024-09-17T12:11:10.433Z | 2024-09-19T12:20:40.463Z |
5103505 | 5103505 | 20240913013150_914PB | UK0061 | 2024-09-17T12:11:00.755Z | 2024-09-19T12:20:40.231Z |
5098027 | 5098027 | 20240913011402_lQ9lC | UK0061 | 2024-09-16T12:17:18.669Z | 2024-09-19T12:20:39.534Z |
5093115 | 5093115 | 20240912031129_Dfkep | UK0061 | 2024-09-16T12:14:11.797Z | 2024-09-19T12:21:14.947Z |
5093022 | 5093022 | 20240912030753_zkRxA | UK0061 | 2024-09-16T12:14:10.042Z | 2024-09-19T12:21:14.840Z |
5092787 | 5092787 | 20240912025725_qdtx5 | UK0061 | 2024-09-16T12:14:04.264Z | 2024-09-19T12:21:14.551Z |
5092599 | 5092599 | 20240912025132_2Weuf | UK0061 | 2024-09-16T12:14:00.314Z | 2024-09-19T12:21:14.355Z |
5092522 | 5092522 | 20240912024845_Mp6XO | UK0061 | 2024-09-16T12:13:58.725Z | 2024-09-19T12:21:14.291Z |
5092517 | 5092517 | 20240912024836_2PB9C | UK0061 | 2024-09-16T12:13:58.589Z | 2024-09-19T12:21:14.288Z |
5091738 | 5091738 | 20240912022029_3Wam0 | UK0061 | 2024-09-16T12:13:21.516Z | 2024-09-19T12:21:13.374Z |
5091317 | 5091317 | 20240912020455_D9KIp | UK0061 | 2024-09-16T12:12:59.715Z | 2024-09-19T12:21:12.787Z |
5091100 | 5091100 | 20240912015703_IId5Y | UK0061 | 2024-09-16T12:12:48.625Z | 2024-09-19T12:21:12.540Z |
5090459 | 5090459 | 20240912012633_l39Vb | UK0061 | 2024-09-16T12:12:21.099Z | 2024-09-19T12:21:11.333Z |
5090432 | 5090432 | 20240912012512_yU93a | UK0061 | 2024-09-16T12:12:20.127Z | 2024-09-19T12:21:11.320Z |
5089986 | 5089986 | 20240912010539_bdaqx | UK0061 | 2024-09-16T12:11:53.414Z | 2024-09-19T12:21:10.895Z |
5088505 | 5088505 | 20240913001410_EO49Y | UK0061 | 2024-09-16T12:08:07.098Z | 2024-09-19T12:20:36.973Z |
5087522 | 5087522 | 20240912232949_WgfXD | UK0061 | 2024-09-16T12:07:02.059Z | 2024-09-19T12:20:35.276Z |
5087128 | 5087128 | 20240912230855_FnRw8 | UK0061 | 2024-09-16T12:06:40.487Z | 2024-09-19T12:20:34.036Z |
5087018 | 5087018 | 20240912230313_eMveL | UK0061 | 2024-09-16T12:06:24.634Z | 2024-09-19T12:20:33.466Z |
5086176 | 5086176 | 20240912221549_9B07d | UK0061 | 2024-09-16T12:05:18.852Z | 2024-09-19T12:20:30.337Z |
5080497 | 5080497 | 20240911040555_NKySX | UK0061 | 2024-09-15T12:17:05.313Z | 2024-09-19T12:21:43.321Z |
5080486 | 5080486 | 20240911040238_PEFrT | UK0061 | 2024-09-15T12:17:05.120Z | 2024-09-19T12:21:43.317Z |
5080363 | 5080363 | 20240911035141_HVajp | UK0061 | 2024-09-15T12:16:59.195Z | 2024-09-19T12:21:43.190Z |
5080277 | 5080277 | 20240911034615_ucIg0 | UK0061 | 2024-09-15T12:16:56.174Z | 2024-09-19T12:21:43.155Z |
5080264 | 5080264 | 20240911034516_tCmtw | UK0061 | 2024-09-15T12:16:55.681Z | 2024-09-19T12:21:43.142Z |
5079362 | 5079362 | 20240911025029_1A5bY | UK0061 | 2024-09-15T12:16:17.219Z | 2024-09-19T12:21:41.493Z |
5079356 | 5079356 | 20240911024946_xVama | UK0061 | 2024-09-15T12:16:16.728Z | 2024-09-19T12:21:41.489Z |
5079111 | 5079111 | 20240911023339_7CU6w | UK0061 | 2024-09-15T12:16:05.422Z | 2024-09-19T12:21:41.125Z |
5078990 | 5078990 | 20240911022827_QWDYh | UK0061 | 2024-09-15T12:16:01.824Z | 2024-09-19T12:21:40.999Z |
5078562 | 5078562 | 20240911020335_7ahoD | UK0061 | 2024-09-15T12:15:43.535Z | 2024-09-19T12:21:40.507Z |
5078521 | 5078521 | 20240911020248_terIh | UK0061 | 2024-09-15T12:15:42.132Z | 2024-09-19T12:21:40.480Z |
5078019 | 5078019 | 20240911013538_pbirs | UK0061 | 2024-09-15T12:15:16.978Z | 2024-09-19T12:21:39.906Z |
5077882 | 5077882 | 20240911012621_WS8T2 | UK0061 | 2024-09-15T12:15:09.491Z | 2024-09-19T12:21:39.760Z |
5077306 | 5077306 | 20240911004316_2WY31 | UK0061 | 2024-09-15T12:14:38.002Z | 2024-09-19T12:21:38.651Z |
5077113 | 5077113 | 20240911002412_4x3uC | UK0061 | 2024-09-15T12:14:23.830Z | 2024-09-19T12:21:38.212Z |
5076774 | 5076774 | 20240911000756_sowZB | UK0061 | 2024-09-15T12:14:02.669Z | 2024-09-19T12:21:37.566Z |
5076652 | 5076652 | 20240910235556_dfzPV | UK0061 | 2024-09-15T12:13:51.773Z | 2024-09-19T12:21:37.428Z |
5076512 | 5076512 | 20240910234221_swc39 | UK0061 | 2024-09-15T12:13:40.142Z | 2024-09-19T12:21:37.321Z |
5076458 | 5076458 | 20240910233712_JCA12 | UK0061 | 2024-09-15T12:13:35.258Z | 2024-09-19T12:21:37.231Z |
5076260 | 5076260 | 20240910231717_F4Eh8 | UK0061 | 2024-09-15T12:13:25.411Z | 2024-09-19T12:21:36.666Z |
5076132 | 5076132 | 20240910230858_numP2 | UK0061 | 2024-09-15T12:13:19.143Z | 2024-09-19T12:21:36.480Z |
5075973 | 5075973 | 20240910230248_ORDei | UK0061 | 2024-09-15T12:13:14.169Z | 2024-09-19T12:21:36.307Z |
5075960 | 5075960 | 20240910230134_Q6e22 | UK0061 | 2024-09-15T12:13:13.156Z | 2024-09-19T12:21:36.255Z |
5075922 | 5075922 | 20240910230020_0aIQx | UK0061 | 2024-09-15T12:13:12.577Z | 2024-09-19T12:21:36.243Z |
5075728 | 5075728 | 20240912000322_nSb2u | UK0061 | 2024-09-15T12:10:10.022Z | 2024-09-19T12:21:09.452Z |
5075546 | 5075546 | 20240911235446_aeb32 | UK0061 | 2024-09-15T12:10:00.668Z | 2024-09-19T12:21:09.283Z |
5075373 | 5075373 | 20240911234414_fdYjd | UK0061 | 2024-09-15T12:09:39.613Z | 2024-09-19T12:21:09.174Z |
5073992 | 5073992 | 20240911220416_x49vu | UK0061 | 2024-09-15T12:07:49.907Z | 2024-09-19T12:21:06.787Z |
5073363 | 5073363 | 20240911211644_RcHix | UK0061 | 2024-09-15T12:07:06.146Z | 2024-09-19T12:21:05.695Z |
5073168 | 5073168 | 20240911210308_O31mv | UK0061 | 2024-09-15T12:06:51.575Z | 2024-09-19T12:21:05.196Z |
5072957 | 5072957 | 20240911204858_IcBdz | UK0061 | 2024-09-15T12:06:21.656Z | 2024-09-19T12:21:04.973Z |
5072920 | 5072920 | 20240911204756_cEKiE | UK0061 | 2024-09-15T12:06:17.850Z | 2024-09-19T12:21:04.913Z |
5072660 | 5072660 | 20240911203602_uKAtI | UK0061 | 2024-09-15T12:05:58.658Z | 2024-09-19T12:21:04.582Z |
5070235 | 5070235 | 20240910224504_RqfX0 | UK0061 | 2024-09-14T12:20:17.097Z | 2024-09-19T12:21:35.918Z |
5069968 | 5069968 | 20240910221947_CmAn4 | UK0061 | 2024-09-14T12:20:10.185Z | 2024-09-19T12:21:35.541Z |
5069674 | 5069674 | 20240910215731_2YcTC | UK0061 | 2024-09-14T12:20:03.852Z | 2024-09-19T12:21:35.238Z |
5063933 | 5063933 | 20240909230057_Fqo2t | UK0061 | 2024-09-14T12:14:30.534Z | 2024-09-18T12:15:14.914Z |
5053389 | 5053389 | 20240908002705_O2YH6 | UK0061 | 2024-09-13T12:16:02.711Z | 2024-09-16T12:21:10.525Z |
5053244 | 5053244 | 20240907235605_FBEfR | UK0061 | 2024-09-13T12:15:54.874Z | 2024-09-16T12:21:10.069Z |
5010824 | 5010824 | 20240904034831_Utk13 | UK0061 | 2024-09-09T12:09:04.242Z | 2024-09-12T12:19:29.135Z |
5010794 | 5010794 | 20240904034621_kn38p | UK0061 | 2024-09-09T12:09:02.097Z | 2024-09-12T12:19:29.077Z |
5010768 | 5010768 | 20240904034217_C2Re3 | UK0061 | 2024-09-09T12:09:00.770Z | 2024-09-12T12:19:28.942Z |
5010622 | 5010622 | 20240904032555_LOLFj | UK0061 | 2024-09-09T12:08:54.455Z | 2024-09-12T12:19:28.274Z |
5010587 | 5010587 | 20240904032035_lBQtG | UK0061 | 2024-09-09T12:08:52.598Z | 2024-09-12T12:19:28.056Z |
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);