participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
965 rows where station_code = "UK004U" 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 |
---|---|---|---|---|---|
5133985 | 5133985 | 20240916042709_7a9jH | UK004U | 2024-09-19T12:17:15.449Z | 2024-09-19T12:17:15.449Z |
5133926 | 5133926 | 20240916041839_WZ03I | UK004U | 2024-09-19T12:17:13.288Z | 2024-09-19T12:17:13.288Z |
5133898 | 5133898 | 20240916041656_KHzFc | UK004U | 2024-09-19T12:17:12.733Z | 2024-09-19T12:17:12.733Z |
5133870 | 5133870 | 20240916041221_wW6fR | UK004U | 2024-09-19T12:17:11.403Z | 2024-09-19T12:17:11.403Z |
5133643 | 5133643 | 20240916034941_vheXS | UK004U | 2024-09-19T12:17:04.764Z | 2024-09-19T12:17:04.764Z |
5133440 | 5133440 | 20240916033019_rEDMZ | UK004U | 2024-09-19T12:16:56.492Z | 2024-09-19T12:16:56.492Z |
5133424 | 5133424 | 20240916032951_wW9CU | UK004U | 2024-09-19T12:16:56.299Z | 2024-09-19T12:16:56.299Z |
5133382 | 5133382 | 20240916032749_bSoYG | UK004U | 2024-09-19T12:16:55.901Z | 2024-09-19T12:16:55.901Z |
5133327 | 5133327 | 20240916032335_geFny | UK004U | 2024-09-19T12:16:54.445Z | 2024-09-19T12:16:54.445Z |
5133100 | 5133100 | 20240916025621_vpekO | UK004U | 2024-09-19T12:16:44.228Z | 2024-09-19T12:16:44.228Z |
5132798 | 5132798 | 20240916021456_uowYh | UK004U | 2024-09-19T12:16:33.234Z | 2024-09-19T12:16:33.234Z |
5132757 | 5132757 | 20240916020728_JZGeH | UK004U | 2024-09-19T12:16:31.264Z | 2024-09-19T12:16:31.264Z |
5132608 | 5132608 | 20240916014255_H0zgq | UK004U | 2024-09-19T12:16:22.373Z | 2024-09-19T12:16:22.373Z |
5132520 | 5132520 | 20240916012417_VjU0M | UK004U | 2024-09-19T12:16:16.748Z | 2024-09-19T12:16:16.748Z |
5132394 | 5132394 | 20240916005650_QVrvN | UK004U | 2024-09-19T12:16:10.829Z | 2024-09-19T12:16:10.829Z |
5132339 | 5132339 | 20240916003520_MPRXp | UK004U | 2024-09-19T12:16:07.973Z | 2024-09-19T12:16:07.973Z |
5132328 | 5132328 | 20240916003406_NOwYh | UK004U | 2024-09-19T12:16:07.446Z | 2024-09-19T12:16:07.446Z |
5132190 | 5132190 | 20240915235557_a2cZ2 | UK004U | 2024-09-19T12:15:57.412Z | 2024-09-19T12:15:57.412Z |
5132150 | 5132150 | 20240915234306_mepEv | UK004U | 2024-09-19T12:15:53.279Z | 2024-09-19T12:15:53.279Z |
5132107 | 5132107 | 20240915232528_rAaSd | UK004U | 2024-09-19T12:15:50.849Z | 2024-09-19T12:15:50.849Z |
5131684 | 5131684 | 20240915204809_PtSAL | UK004U | 2024-09-19T12:15:15.038Z | 2024-09-19T12:15:15.038Z |
5131494 | 5131494 | 20240915200503_K55lN | UK004U | 2024-09-19T12:15:06.388Z | 2024-09-19T12:15:06.388Z |
5126822 | 5126822 | 20240916193845_hnMQJ | UK004U | 2024-09-19T12:07:22.318Z | 2024-09-19T12:07:22.318Z |
5125759 | 5125759 | 20240918034300_Ez0Y2 | UK004U | 2024-09-19T12:04:02.654Z | 2024-09-19T12:06:42.082Z |
5097194 | 5097194 | 20240913003528_pZ3pP | UK004U | 2024-09-16T12:17:07.463Z | 2024-09-19T12:20:37.842Z |
5094553 | 5094553 | 20240912041047_eonnu | UK004U | 2024-09-16T12:14:51.264Z | 2024-09-19T12:21:16.250Z |
5094350 | 5094350 | 20240912035747_oN3vz | UK004U | 2024-09-16T12:14:41.750Z | 2024-09-19T12:21:16.077Z |
5094079 | 5094079 | 20240912034717_5kvu9 | UK004U | 2024-09-16T12:14:33.578Z | 2024-09-19T12:21:15.873Z |
5093827 | 5093827 | 20240912033846_7WtuD | UK004U | 2024-09-16T12:14:26.598Z | 2024-09-19T12:21:15.688Z |
5093811 | 5093811 | 20240912033739_HBv2J | UK004U | 2024-09-16T12:14:26.012Z | 2024-09-19T12:21:15.668Z |
5093252 | 5093252 | 20240912031523_vZiHB | UK004U | 2024-09-16T12:14:13.633Z | 2024-09-19T12:21:15.030Z |
5092651 | 5092651 | 20240912025349_kxPAy | UK004U | 2024-09-16T12:14:01.411Z | 2024-09-19T12:21:14.388Z |
5092639 | 5092639 | 20240912025337_I2LM8 | UK004U | 2024-09-16T12:14:01.311Z | 2024-09-19T12:21:14.384Z |
5092516 | 5092516 | 20240912024836_2PB9C | UK004U | 2024-09-16T12:13:58.589Z | 2024-09-19T12:21:14.288Z |
5092504 | 5092504 | 20240912024830_JTMxq | UK004U | 2024-09-16T12:13:58.451Z | 2024-09-19T12:21:14.283Z |
5092395 | 5092395 | 20240912024424_yDNO8 | UK004U | 2024-09-16T12:13:51.555Z | 2024-09-19T12:21:13.935Z |
5092272 | 5092272 | 20240912024135_QwStU | UK004U | 2024-09-16T12:13:46.661Z | 2024-09-19T12:21:13.790Z |
5091745 | 5091745 | 20240912022041_3cknw | UK004U | 2024-09-16T12:13:21.766Z | 2024-09-19T12:21:13.379Z |
5091314 | 5091314 | 20240912020428_jzn5Z | UK004U | 2024-09-16T12:12:59.369Z | 2024-09-19T12:21:12.756Z |
5091150 | 5091150 | 20240912015847_9zVnv | UK004U | 2024-09-16T12:12:51.306Z | 2024-09-19T12:21:12.604Z |
5091045 | 5091045 | 20240912015617_72APx | UK004U | 2024-09-16T12:12:47.123Z | 2024-09-19T12:21:12.463Z |
5090116 | 5090116 | 20240912011111_h1E3l | UK004U | 2024-09-16T12:12:00.962Z | 2024-09-19T12:21:10.974Z |
5088729 | 5088729 | 20240913002212_VPAAP | UK004U | 2024-09-16T12:08:22.828Z | 2024-09-19T12:20:37.200Z |
5088560 | 5088560 | 20240913001713_HQLW2 | UK004U | 2024-09-16T12:08:12.464Z | 2024-09-19T12:20:37.018Z |
5087343 | 5087343 | 20240912232406_fvdz3 | UK004U | 2024-09-16T12:06:52.788Z | 2024-09-19T12:20:34.682Z |
5087127 | 5087127 | 20240912230855_FnRw8 | UK004U | 2024-09-16T12:06:40.487Z | 2024-09-19T12:20:34.036Z |
5087114 | 5087114 | 20240912230849_iiMFc | UK004U | 2024-09-16T12:06:40.099Z | 2024-09-19T12:20:34.036Z |
5086175 | 5086175 | 20240912221549_9B07d | UK004U | 2024-09-16T12:05:18.852Z | 2024-09-19T12:20:30.337Z |
5085926 | 5085926 | 20240912215752_9Mk2k | UK004U | 2024-09-16T12:05:03.136Z | 2024-09-19T12:20:29.794Z |
5080509 | 5080509 | 20240911040814_BfI1z | UK004U | 2024-09-15T12:17:05.663Z | 2024-09-19T12:21:43.325Z |
5080455 | 5080455 | 20240911035734_NbU9T | UK004U | 2024-09-15T12:17:03.711Z | 2024-09-19T12:21:43.289Z |
5080308 | 5080308 | 20240911034816_LgAAs | UK004U | 2024-09-15T12:16:57.139Z | 2024-09-19T12:21:43.170Z |
5080275 | 5080275 | 20240911034614_2cc8D | UK004U | 2024-09-15T12:16:56.056Z | 2024-09-19T12:21:43.144Z |
5080270 | 5080270 | 20240911034554_LjFn6 | UK004U | 2024-09-15T12:16:55.883Z | 2024-09-19T12:21:43.144Z |
5080112 | 5080112 | 20240911033249_kWyun | UK004U | 2024-09-15T12:16:50.305Z | 2024-09-19T12:21:43.093Z |
5079729 | 5079729 | 20240911030827_8spcy | UK004U | 2024-09-15T12:16:34.039Z | 2024-09-19T12:21:42.564Z |
5079687 | 5079687 | 20240911030755_0fjAJ | UK004U | 2024-09-15T12:16:33.219Z | 2024-09-19T12:21:42.558Z |
5079404 | 5079404 | 20240911025331_VdnVg | UK004U | 2024-09-15T12:16:19.719Z | 2024-09-19T12:21:41.681Z |
5079303 | 5079303 | 20240911024735_eYiSl | UK004U | 2024-09-15T12:16:14.886Z | 2024-09-19T12:21:41.412Z |
5079235 | 5079235 | 20240911024226_sQgYc | UK004U | 2024-09-15T12:16:12.029Z | 2024-09-19T12:21:41.271Z |
5079171 | 5079171 | 20240911023817_uHZz0 | UK004U | 2024-09-15T12:16:09.452Z | 2024-09-19T12:21:41.236Z |
5078996 | 5078996 | 20240911022831_KslHH | UK004U | 2024-09-15T12:16:01.954Z | 2024-09-19T12:21:41.003Z |
5078965 | 5078965 | 20240911022651_PpTGn | UK004U | 2024-09-15T12:16:00.899Z | 2024-09-19T12:21:40.935Z |
5078185 | 5078185 | 20240911014228_5VWqD | UK004U | 2024-09-15T12:15:22.801Z | 2024-09-19T12:21:40.052Z |
5078122 | 5078122 | 20240911014006_hWJHV | UK004U | 2024-09-15T12:15:20.963Z | 2024-09-19T12:21:40.009Z |
5077626 | 5077626 | 20240911010654_TrbRl | UK004U | 2024-09-15T12:14:55.162Z | 2024-09-19T12:21:39.453Z |
5077139 | 5077139 | 20240911002609_hNzOa | UK004U | 2024-09-15T12:14:25.088Z | 2024-09-19T12:21:38.283Z |
5077038 | 5077038 | 20240911002232_UOycP | UK004U | 2024-09-15T12:14:19.011Z | 2024-09-19T12:21:37.984Z |
5076995 | 5076995 | 20240911002012_uloq7 | UK004U | 2024-09-15T12:14:17.229Z | 2024-09-19T12:21:37.940Z |
5076065 | 5076065 | 20240910230629_nO2FR | UK004U | 2024-09-15T12:13:16.993Z | 2024-09-19T12:21:36.411Z |
5075834 | 5075834 | 20240912000937_HtDc4 | UK004U | 2024-09-15T12:10:17.699Z | 2024-09-19T12:21:09.589Z |
5074756 | 5074756 | 20240911230126_NoehX | UK004U | 2024-09-15T12:08:50.002Z | 2024-09-19T12:21:07.705Z |
5074010 | 5074010 | 20240911220645_MqLLh | UK004U | 2024-09-15T12:07:51.425Z | 2024-09-19T12:21:06.853Z |
5072480 | 5072480 | 20240911201300_F30xD | UK004U | 2024-09-15T12:05:28.253Z | 2024-09-19T12:21:04.260Z |
5060770 | 5060770 | 20240910210459_ccCrl | UK004U | 2024-09-14T12:09:31.480Z | 2024-09-19T12:21:33.574Z |
5060281 | 5060281 | 20240910201426_kTgxH | UK004U | 2024-09-14T12:08:35.125Z | 2024-09-19T12:21:32.063Z |
4990526 | 4990526 | 20240901002853_73u5x | UK004U | 2024-09-07T12:10:43.699Z | 2024-09-09T12:26:22.669Z |
4990216 | 4990216 | 20240831234342_0Ea6i | UK004U | 2024-09-07T12:10:14.446Z | 2024-09-09T12:26:13.842Z |
4990166 | 4990166 | 20240831233729_iTmW4 | UK004U | 2024-09-07T12:10:08.281Z | 2024-09-09T12:26:12.307Z |
4966155 | 4966155 | 20240811212441_TaKaX | UK004U | 2024-09-04T12:07:19.287Z | 2024-09-06T12:06:15.219Z |
4950298 | 4950298 | 20240811020500_QinO6 | UK004U | 2024-09-02T12:16:21.335Z | 2024-09-06T12:27:43.094Z |
4949990 | 4949990 | 20240811015917_W3b3F | UK004U | 2024-09-02T12:16:01.843Z | 2024-09-06T12:27:39.764Z |
4948051 | 4948051 | 20240811012826_lRi8G | UK004U | 2024-09-02T12:14:53.822Z | 2024-09-06T12:27:07.440Z |
4947890 | 4947890 | 20240811012617_GBxv4 | UK004U | 2024-09-02T12:14:49.644Z | 2024-09-06T12:27:03.787Z |
4947483 | 4947483 | 20240811011953_F7ZeC | UK004U | 2024-09-02T12:14:35.229Z | 2024-09-06T12:26:53.928Z |
4946628 | 4946628 | 20240811010350_HNBkv | UK004U | 2024-09-02T12:14:02.344Z | 2024-09-06T12:26:29.085Z |
4945633 | 4945633 | 20240811004857_7u9a2 | UK004U | 2024-09-02T12:13:21.564Z | 2024-09-06T12:26:00.243Z |
4945600 | 4945600 | 20240811004839_g8Aub | UK004U | 2024-09-02T12:13:20.890Z | 2024-09-06T12:25:59.696Z |
4945231 | 4945231 | 20240811004247_4AODB | UK004U | 2024-09-02T12:13:12.486Z | 2024-09-06T12:25:49.888Z |
4945092 | 4945092 | 20240811004106_ZS9Ps | UK004U | 2024-09-02T12:13:09.452Z | 2024-09-06T12:25:46.652Z |
4944394 | 4944394 | 20240811002851_wAuMa | UK004U | 2024-09-02T12:12:30.472Z | 2024-09-06T12:25:20.829Z |
4942987 | 4942987 | 20240811000314_yI2sq | UK004U | 2024-09-02T12:11:39.292Z | 2024-09-06T12:24:35.311Z |
4942766 | 4942766 | 20240810235640_MpKUW | UK004U | 2024-09-02T12:11:32.919Z | 2024-09-06T12:24:29.396Z |
4942184 | 4942184 | 20240810234730_ofiwb | UK004U | 2024-09-02T12:11:04.707Z | 2024-09-06T12:24:08.619Z |
4941934 | 4941934 | 20240810234218_hdw5H | UK004U | 2024-09-02T12:10:57.350Z | 2024-09-06T12:23:58.343Z |
4941854 | 4941854 | 20240810234032_8CX8q | UK004U | 2024-09-02T12:10:50.245Z | 2024-09-06T12:23:55.580Z |
4940596 | 4940596 | 20240810231540_XDqGv | UK004U | 2024-09-01T12:10:37.741Z | 2024-09-06T12:23:36.847Z |
4940540 | 4940540 | 20240810231404_dv8ZB | UK004U | 2024-09-01T12:10:31.138Z | 2024-09-06T12:23:36.221Z |
4926596 | 4926596 | 20240810015309_ldTmB | UK004U | 2024-08-31T12:19:45.818Z | 2024-09-02T12:27:56.840Z |
4926124 | 4926124 | 20240810014100_nKJI5 | UK004U | 2024-08-31T12:19:30.015Z | 2024-09-02T12:27:41.662Z |
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);