participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,104 rows where station_code = "UK009M" 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 |
---|---|---|---|---|---|
5135307 | 5135307 | 20240915034452_7Om9l | UK009M | 2024-09-19T12:19:12.501Z | 2024-09-19T12:19:12.501Z |
5128805 | 5128805 | 20240917024150_rcFBd | UK009M | 2024-09-19T12:11:02.693Z | 2024-09-19T12:11:02.693Z |
5128601 | 5128601 | 20240917020913_TfuJP | UK009M | 2024-09-19T12:10:46.926Z | 2024-09-19T12:10:46.926Z |
5128159 | 5128159 | 20240917005425_JslyQ | UK009M | 2024-09-19T12:10:13.112Z | 2024-09-19T12:10:13.112Z |
5127770 | 5127770 | 20240916232436_VgJLe | UK009M | 2024-09-19T12:09:36.975Z | 2024-09-19T12:09:36.975Z |
5127416 | 5127416 | 20240916214620_NCFqq | UK009M | 2024-09-19T12:09:05.126Z | 2024-09-19T12:09:05.126Z |
5127400 | 5127400 | 20240916214417_ZEOKa | UK009M | 2024-09-19T12:09:02.980Z | 2024-09-19T12:09:02.980Z |
5127354 | 5127354 | 20240916213453_YHrjt | UK009M | 2024-09-19T12:08:56.810Z | 2024-09-19T12:08:56.810Z |
5125800 | 5125800 | 20240918035722_Sn20q | UK009M | 2024-09-19T12:04:07.880Z | 2024-09-19T12:06:42.087Z |
5121749 | 5121749 | 20240914041331_usi4A | UK009M | 2024-09-18T12:11:01.160Z | 2024-09-19T12:20:02.321Z |
5121425 | 5121425 | 20240914040049_qQLo8 | UK009M | 2024-09-18T12:10:55.272Z | 2024-09-19T12:20:01.789Z |
5120314 | 5120314 | 20240914031430_0uk27 | UK009M | 2024-09-18T12:10:36.959Z | 2024-09-19T12:19:59.864Z |
5119669 | 5119669 | 20240914024356_3tGR8 | UK009M | 2024-09-18T12:10:23.879Z | 2024-09-19T12:19:58.715Z |
5119229 | 5119229 | 20240914021831_2SKUF | UK009M | 2024-09-18T12:10:18.739Z | 2024-09-19T12:19:57.470Z |
5119175 | 5119175 | 20240914021531_hq33r | UK009M | 2024-09-18T12:10:17.913Z | 2024-09-19T12:19:57.327Z |
5119162 | 5119162 | 20240914021434_6YjzA | UK009M | 2024-09-18T12:10:17.100Z | 2024-09-19T12:19:57.302Z |
5119144 | 5119144 | 20240914021322_ENP2s | UK009M | 2024-09-18T12:10:16.623Z | 2024-09-19T12:19:57.231Z |
5116425 | 5116425 | 20240915032539_9leAG | UK009M | 2024-09-18T12:07:01.982Z | 2024-09-19T12:19:11.103Z |
5116388 | 5116388 | 20240915032441_0atvh | UK009M | 2024-09-18T12:07:00.922Z | 2024-09-19T12:19:11.065Z |
5116190 | 5116190 | 20240915031532_ci99d | UK009M | 2024-09-18T12:06:47.178Z | 2024-09-19T12:19:09.604Z |
5115701 | 5115701 | 20240915024906_jGfsX | UK009M | 2024-09-18T12:06:21.372Z | 2024-09-19T12:19:06.400Z |
5115231 | 5115231 | 20240915022806_8I23p | UK009M | 2024-09-18T12:06:07.333Z | 2024-09-19T12:19:03.149Z |
5114645 | 5114645 | 20240915015238_54fTx | UK009M | 2024-09-18T12:05:26.560Z | 2024-09-19T12:18:59.152Z |
5114214 | 5114214 | 20240915013214_8zrCb | UK009M | 2024-09-18T12:05:06.897Z | 2024-09-19T12:18:56.961Z |
5112290 | 5112290 | 20240914225106_wZgfh | UK009M | 2024-09-18T12:02:58.448Z | 2024-09-19T12:18:40.373Z |
5111786 | 5111786 | 20240914211700_pLBEl | UK009M | 2024-09-18T12:02:17.053Z | 2024-09-19T12:18:34.037Z |
5111668 | 5111668 | 20240914205845_MMRs8 | UK009M | 2024-09-18T12:02:09.928Z | 2024-09-19T12:18:32.850Z |
5108120 | 5108120 | 20240913042358_AZAj2 | UK009M | 2024-09-17T12:13:30.683Z | 2024-09-19T12:20:47.851Z |
5108111 | 5108111 | 20240913042358_TeKGC | UK009M | 2024-09-17T12:13:30.612Z | 2024-09-19T12:20:47.850Z |
5107285 | 5107285 | 20240913035032_LE6Iw | UK009M | 2024-09-17T12:13:12.469Z | 2024-09-19T12:20:46.980Z |
5107165 | 5107165 | 20240913034540_HdeRC | UK009M | 2024-09-17T12:13:10.141Z | 2024-09-19T12:20:46.870Z |
5106889 | 5106889 | 20240913033754_2M2AR | UK009M | 2024-09-17T12:13:03.697Z | 2024-09-19T12:20:46.509Z |
5106689 | 5106689 | 20240913033222_3oesm | UK009M | 2024-09-17T12:12:59.411Z | 2024-09-19T12:20:46.284Z |
5106278 | 5106278 | 20240913031648_y9XF3 | UK009M | 2024-09-17T12:12:47.768Z | 2024-09-19T12:20:45.738Z |
5105924 | 5105924 | 20240913030259_2bMnC | UK009M | 2024-09-17T12:12:32.697Z | 2024-09-19T12:20:45.049Z |
5105807 | 5105807 | 20240913025849_ag2Ct | UK009M | 2024-09-17T12:12:29.270Z | 2024-09-19T12:20:44.929Z |
5105747 | 5105747 | 20240913025619_qM1bX | UK009M | 2024-09-17T12:12:28.313Z | 2024-09-19T12:20:44.866Z |
5103977 | 5103977 | 20240913014620_G0LHT | UK009M | 2024-09-17T12:11:21.067Z | 2024-09-19T12:20:40.771Z |
5103725 | 5103725 | 20240913013731_Emviw | UK009M | 2024-09-17T12:11:09.138Z | 2024-09-19T12:20:40.435Z |
5103714 | 5103714 | 20240913013632_3Xdny | UK009M | 2024-09-17T12:11:08.193Z | 2024-09-19T12:20:40.427Z |
5103524 | 5103524 | 20240913013155_6xY3b | UK009M | 2024-09-17T12:11:01.142Z | 2024-09-19T12:20:40.239Z |
5103499 | 5103499 | 20240913013140_oIZ4q | UK009M | 2024-09-17T12:11:00.411Z | 2024-09-19T12:20:40.227Z |
5103151 | 5103151 | 20240914020250_Sndae | UK009M | 2024-09-17T12:07:53.955Z | 2024-09-19T12:19:56.688Z |
5102986 | 5102986 | 20240914015558_UuU9v | UK009M | 2024-09-17T12:07:45.942Z | 2024-09-19T12:19:56.229Z |
5102833 | 5102833 | 20240914014741_8S2Id | UK009M | 2024-09-17T12:07:39.049Z | 2024-09-19T12:19:55.844Z |
5101888 | 5101888 | 20240914005429_DD24a | UK009M | 2024-09-17T12:06:21.635Z | 2024-09-19T12:19:51.802Z |
5101638 | 5101638 | 20240914004007_6X8wy | UK009M | 2024-09-17T12:06:05.936Z | 2024-09-19T12:19:51.166Z |
5100295 | 5100295 | 20240913231738_R5pOg | UK009M | 2024-09-17T12:04:25.472Z | 2024-09-19T12:19:47.685Z |
5099946 | 5099946 | 20240913222529_BYRsN | UK009M | 2024-09-17T12:03:45.059Z | 2024-09-19T12:19:46.579Z |
5099392 | 5099392 | 20240913210737_gtxPN | UK009M | 2024-09-17T12:02:52.049Z | 2024-09-19T12:19:44.734Z |
5099341 | 5099341 | 20240913210353_bsyOr | UK009M | 2024-09-17T12:02:48.108Z | 2024-09-19T12:19:44.560Z |
5099214 | 5099214 | 20240913204055_AA9kd | UK009M | 2024-09-17T12:02:30.263Z | 2024-09-19T12:19:44.079Z |
5098282 | 5098282 | 20240913012338_lnkR5 | UK009M | 2024-09-16T12:17:22.130Z | 2024-09-19T12:20:39.986Z |
5097802 | 5097802 | 20240913010444_xlrsA | UK009M | 2024-09-16T12:17:15.039Z | 2024-09-19T12:20:38.988Z |
5097791 | 5097791 | 20240913010430_ktVxe | UK009M | 2024-09-16T12:17:14.974Z | 2024-09-19T12:20:38.982Z |
5097778 | 5097778 | 20240913010422_ONzqz | UK009M | 2024-09-16T12:17:14.893Z | 2024-09-19T12:20:38.976Z |
5094694 | 5094694 | 20240912041553_qQt2L | UK009M | 2024-09-16T12:14:54.966Z | 2024-09-19T12:21:16.379Z |
5094599 | 5094599 | 20240912041227_HdOPp | UK009M | 2024-09-16T12:14:52.461Z | 2024-09-19T12:21:16.321Z |
5094540 | 5094540 | 20240912040800_SL27D | UK009M | 2024-09-16T12:14:50.826Z | 2024-09-19T12:21:16.238Z |
5093780 | 5093780 | 20240912033503_7J23a | UK009M | 2024-09-16T12:14:25.267Z | 2024-09-19T12:21:15.648Z |
5093763 | 5093763 | 20240912033408_2Auoa | UK009M | 2024-09-16T12:14:24.988Z | 2024-09-19T12:21:15.639Z |
5092592 | 5092592 | 20240912025047_FKDtQ | UK009M | 2024-09-16T12:14:00.005Z | 2024-09-19T12:21:14.350Z |
5091897 | 5091897 | 20240912022723_BqvjT | UK009M | 2024-09-16T12:13:29.864Z | 2024-09-19T12:21:13.468Z |
5091380 | 5091380 | 20240912020714_jUwlz | UK009M | 2024-09-16T12:13:03.536Z | 2024-09-19T12:21:12.962Z |
5090774 | 5090774 | 20240912014511_C2pcu | UK009M | 2024-09-16T12:12:35.361Z | 2024-09-19T12:21:12.050Z |
5090724 | 5090724 | 20240912014147_5cIqk | UK009M | 2024-09-16T12:12:31.757Z | 2024-09-19T12:21:11.621Z |
5090394 | 5090394 | 20240912012403_4qte4 | UK009M | 2024-09-16T12:12:18.387Z | 2024-09-19T12:21:11.287Z |
5089969 | 5089969 | 20240912010443_ZlroI | UK009M | 2024-09-16T12:11:52.735Z | 2024-09-19T12:21:10.864Z |
5089831 | 5089831 | 20240912005856_qzvPx | UK009M | 2024-09-16T12:11:45.306Z | 2024-09-19T12:21:10.520Z |
5089516 | 5089516 | 20240912004736_JbN2x | UK009M | 2024-09-16T12:11:28.178Z | 2024-09-19T12:21:10.021Z |
5088723 | 5088723 | 20240913002210_EHj21 | UK009M | 2024-09-16T12:08:22.437Z | 2024-09-19T12:20:37.198Z |
5088151 | 5088151 | 20240913000029_Tz9bo | UK009M | 2024-09-16T12:07:45.733Z | 2024-09-19T12:20:36.454Z |
5087841 | 5087841 | 20240912234603_vHKK2 | UK009M | 2024-09-16T12:07:34.056Z | 2024-09-19T12:20:35.692Z |
5087743 | 5087743 | 20240912234238_cr2ew | UK009M | 2024-09-16T12:07:22.677Z | 2024-09-19T12:20:35.629Z |
5087081 | 5087081 | 20240912230749_WA7jD | UK009M | 2024-09-16T12:06:35.987Z | 2024-09-19T12:20:34.013Z |
5086261 | 5086261 | 20240912222234_aofZa | UK009M | 2024-09-16T12:05:25.882Z | 2024-09-19T12:20:30.705Z |
5085441 | 5085441 | 20240912212101_TwORg | UK009M | 2024-09-16T12:04:15.778Z | 2024-09-19T12:20:28.624Z |
5085436 | 5085436 | 20240912211957_YIQNa | UK009M | 2024-09-16T12:04:15.391Z | 2024-09-19T12:20:28.623Z |
5085152 | 5085152 | 20240912205232_dLLnT | UK009M | 2024-09-16T12:03:37.226Z | 2024-09-19T12:20:28.122Z |
5084926 | 5084926 | 20240912203250_OUYjx | UK009M | 2024-09-16T12:03:13.205Z | 2024-09-19T12:20:27.487Z |
5080412 | 5080412 | 20240911035604_3H8Xu | UK009M | 2024-09-15T12:17:02.569Z | 2024-09-19T12:21:43.232Z |
5079509 | 5079509 | 20240911025849_gpeZj | UK009M | 2024-09-15T12:16:23.395Z | 2024-09-19T12:21:42.302Z |
5078491 | 5078491 | 20240911020057_d3AyS | UK009M | 2024-09-15T12:15:40.694Z | 2024-09-19T12:21:40.448Z |
5077980 | 5077980 | 20240911013346_NDYln | UK009M | 2024-09-15T12:15:15.312Z | 2024-09-19T12:21:39.873Z |
5077604 | 5077604 | 20240911010521_fp4dn | UK009M | 2024-09-15T12:14:54.041Z | 2024-09-19T12:21:39.417Z |
5076710 | 5076710 | 20240911000408_a2F2R | UK009M | 2024-09-15T12:13:57.469Z | 2024-09-19T12:21:37.480Z |
5075747 | 5075747 | 20240912000447_QXWbU | UK009M | 2024-09-15T12:10:10.817Z | 2024-09-19T12:21:09.460Z |
5075600 | 5075600 | 20240911235639_ouvIW | UK009M | 2024-09-15T12:10:03.902Z | 2024-09-19T12:21:09.320Z |
5075407 | 5075407 | 20240911234604_aAEkl | UK009M | 2024-09-15T12:09:42.682Z | 2024-09-19T12:21:09.204Z |
5075307 | 5075307 | 20240911233945_hxaqc | UK009M | 2024-09-15T12:09:35.379Z | 2024-09-19T12:21:09.092Z |
5074218 | 5074218 | 20240911222534_Qiq1T | UK009M | 2024-09-15T12:08:10.845Z | 2024-09-19T12:21:07.012Z |
5074008 | 5074008 | 20240911220632_BgzRN | UK009M | 2024-09-15T12:07:51.131Z | 2024-09-19T12:21:06.852Z |
5073871 | 5073871 | 20240911215221_7ZDSN | UK009M | 2024-09-15T12:07:42.159Z | 2024-09-19T12:21:06.340Z |
5073693 | 5073693 | 20240911213903_E3GRn | UK009M | 2024-09-15T12:07:33.452Z | 2024-09-19T12:21:06.149Z |
5073577 | 5073577 | 20240911213048_hzGic | UK009M | 2024-09-15T12:07:19.994Z | 2024-09-19T12:21:05.864Z |
5072781 | 5072781 | 20240911204031_38Bb7 | UK009M | 2024-09-15T12:06:07.948Z | 2024-09-19T12:21:04.743Z |
5072518 | 5072518 | 20240911202016_9OuiI | UK009M | 2024-09-15T12:05:34.443Z | 2024-09-19T12:21:04.323Z |
5070247 | 5070247 | 20240910224559_G06xd | UK009M | 2024-09-14T12:20:17.220Z | 2024-09-19T12:21:35.930Z |
5069462 | 5069462 | 20240910214434_cI6KF | UK009M | 2024-09-14T12:19:57.883Z | 2024-09-19T12:21:34.934Z |
5065221 | 5065221 | 20240910032247_NrG68 | UK009M | 2024-09-14T12:16:43.297Z | 2024-09-18T12:15:18.765Z |
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);