participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,074 rows where station_code = "UK004E" 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 |
---|---|---|---|---|---|
5128494 | 5128494 | 20240917015117_7DWlR | UK004E | 2024-09-19T12:10:38.984Z | 2024-09-19T12:10:38.984Z |
5128318 | 5128318 | 20240917012548_PybtW | UK004E | 2024-09-19T12:10:26.565Z | 2024-09-19T12:10:26.565Z |
5128058 | 5128058 | 20240917003007_U2t2E | UK004E | 2024-09-19T12:09:57.471Z | 2024-09-19T12:09:57.471Z |
5127754 | 5127754 | 20240916232311_8V4um | UK004E | 2024-09-19T12:09:36.433Z | 2024-09-19T12:09:36.433Z |
5127726 | 5127726 | 20240916231123_Yg20l | UK004E | 2024-09-19T12:09:34.590Z | 2024-09-19T12:09:34.590Z |
5121795 | 5121795 | 20240914041439_BclDK | UK004E | 2024-09-18T12:11:01.417Z | 2024-09-19T12:20:02.369Z |
5121554 | 5121554 | 20240914040827_9O551 | UK004E | 2024-09-18T12:10:58.283Z | 2024-09-19T12:20:02.088Z |
5121466 | 5121466 | 20240914040354_STmA2 | UK004E | 2024-09-18T12:10:56.855Z | 2024-09-19T12:20:01.907Z |
5121347 | 5121347 | 20240914035837_amhuE | UK004E | 2024-09-18T12:10:54.639Z | 2024-09-19T12:20:01.667Z |
5121266 | 5121266 | 20240914035652_K3ooE | UK004E | 2024-09-18T12:10:53.624Z | 2024-09-19T12:20:01.542Z |
5121252 | 5121252 | 20240914035636_uiFn9 | UK004E | 2024-09-18T12:10:52.992Z | 2024-09-19T12:20:01.531Z |
5120917 | 5120917 | 20240914034153_8i7I9 | UK004E | 2024-09-18T12:10:48.759Z | 2024-09-19T12:20:01.073Z |
5120603 | 5120603 | 20240914032953_cRQIp | UK004E | 2024-09-18T12:10:43.633Z | 2024-09-19T12:20:00.629Z |
5120561 | 5120561 | 20240914032801_Gq8pV | UK004E | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120329 | 5120329 | 20240914031506_13YCP | UK004E | 2024-09-18T12:10:37.407Z | 2024-09-19T12:19:59.892Z |
5120305 | 5120305 | 20240914031359_Sm2g3 | UK004E | 2024-09-18T12:10:36.863Z | 2024-09-19T12:19:59.852Z |
5120238 | 5120238 | 20240914030924_gndWX | UK004E | 2024-09-18T12:10:35.835Z | 2024-09-19T12:19:59.779Z |
5120199 | 5120199 | 20240914030432_ofW5X | UK004E | 2024-09-18T12:10:34.351Z | 2024-09-19T12:19:59.640Z |
5120159 | 5120159 | 20240914030254_uI01w | UK004E | 2024-09-18T12:10:33.128Z | 2024-09-19T12:19:59.503Z |
5120131 | 5120131 | 20240914030053_txjgF | UK004E | 2024-09-18T12:10:32.522Z | 2024-09-19T12:19:59.458Z |
5119951 | 5119951 | 20240914025435_342zJ | UK004E | 2024-09-18T12:10:29.912Z | 2024-09-19T12:19:59.188Z |
5119787 | 5119787 | 20240914025006_o75sB | UK004E | 2024-09-18T12:10:27.131Z | 2024-09-19T12:19:58.950Z |
5119612 | 5119612 | 20240914024004_DBTib | UK004E | 2024-09-18T12:10:22.636Z | 2024-09-19T12:19:58.593Z |
5119527 | 5119527 | 20240914023724_tH8Ya | UK004E | 2024-09-18T12:10:22.046Z | 2024-09-19T12:19:58.465Z |
5119219 | 5119219 | 20240914021827_rmW7L | UK004E | 2024-09-18T12:10:18.707Z | 2024-09-19T12:19:57.468Z |
5117396 | 5117396 | 20240915042632_rWIzu | UK004E | 2024-09-18T12:07:40.039Z | 2024-09-19T12:19:14.819Z |
5117343 | 5117343 | 20240915041928_38V2e | UK004E | 2024-09-18T12:07:38.065Z | 2024-09-19T12:19:14.339Z |
5117147 | 5117147 | 20240915040610_DrDlY | UK004E | 2024-09-18T12:07:33.973Z | 2024-09-19T12:19:13.612Z |
5117077 | 5117077 | 20240915040040_gIaQ3 | UK004E | 2024-09-18T12:07:31.485Z | 2024-09-19T12:19:13.239Z |
5116828 | 5116828 | 20240915034352_Eszy2 | UK004E | 2024-09-18T12:07:22.203Z | 2024-09-19T12:19:12.445Z |
5116793 | 5116793 | 20240915034250_fike3 | UK004E | 2024-09-18T12:07:21.242Z | 2024-09-19T12:19:12.403Z |
5116783 | 5116783 | 20240915034156_u1zxM | UK004E | 2024-09-18T12:07:20.899Z | 2024-09-19T12:19:12.365Z |
5116636 | 5116636 | 20240915033351_xECED | UK004E | 2024-09-18T12:07:13.848Z | 2024-09-19T12:19:11.749Z |
5116480 | 5116480 | 20240915032911_OYkw0 | UK004E | 2024-09-18T12:07:06.035Z | 2024-09-19T12:19:11.309Z |
5116333 | 5116333 | 20240915032146_3CYTa | UK004E | 2024-09-18T12:06:57.723Z | 2024-09-19T12:19:10.497Z |
5116086 | 5116086 | 20240915030738_rJaJZ | UK004E | 2024-09-18T12:06:38.289Z | 2024-09-19T12:19:08.624Z |
5116010 | 5116010 | 20240915030337_ftoHZ | UK004E | 2024-09-18T12:06:34.136Z | 2024-09-19T12:19:08.170Z |
5115976 | 5115976 | 20240915030154_KPBsL | UK004E | 2024-09-18T12:06:32.964Z | 2024-09-19T12:19:08.025Z |
5115773 | 5115773 | 20240915025324_p4Xgj | UK004E | 2024-09-18T12:06:23.629Z | 2024-09-19T12:19:07.304Z |
5115637 | 5115637 | 20240915024646_wH3WO | UK004E | 2024-09-18T12:06:19.919Z | 2024-09-19T12:19:05.849Z |
5115624 | 5115624 | 20240915024635_UxMXq | UK004E | 2024-09-18T12:06:19.612Z | 2024-09-19T12:19:05.827Z |
5115619 | 5115619 | 20240915024635_3lD3O | UK004E | 2024-09-18T12:06:19.526Z | 2024-09-19T12:19:05.826Z |
5115601 | 5115601 | 20240915024537_rYGdT | UK004E | 2024-09-18T12:06:18.701Z | 2024-09-19T12:19:05.603Z |
5115593 | 5115593 | 20240915024524_ksTq3 | UK004E | 2024-09-18T12:06:18.341Z | 2024-09-19T12:19:05.498Z |
5115488 | 5115488 | 20240915024141_HqUoh | UK004E | 2024-09-18T12:06:16.017Z | 2024-09-19T12:19:05.057Z |
5115379 | 5115379 | 20240915023517_7iuMm | UK004E | 2024-09-18T12:06:11.990Z | 2024-09-19T12:19:04.112Z |
5115355 | 5115355 | 20240915023445_i6H0A | UK004E | 2024-09-18T12:06:11.730Z | 2024-09-19T12:19:04.065Z |
5115216 | 5115216 | 20240915022744_5kcYd | UK004E | 2024-09-18T12:06:06.852Z | 2024-09-19T12:19:03.113Z |
5115129 | 5115129 | 20240915022140_iczEr | UK004E | 2024-09-18T12:06:01.894Z | 2024-09-19T12:19:02.438Z |
5115084 | 5115084 | 20240915021849_x1EnV | UK004E | 2024-09-18T12:05:57.135Z | 2024-09-19T12:19:01.519Z |
5115072 | 5115072 | 20240915021703_UVT0U | UK004E | 2024-09-18T12:05:55.990Z | 2024-09-19T12:19:01.447Z |
5115058 | 5115058 | 20240915021611_mquuu | UK004E | 2024-09-18T12:05:54.953Z | 2024-09-19T12:19:01.285Z |
5114977 | 5114977 | 20240915021249_oqYtA | UK004E | 2024-09-18T12:05:48.451Z | 2024-09-19T12:19:00.938Z |
5114932 | 5114932 | 20240915020804_FUcTV | UK004E | 2024-09-18T12:05:43.083Z | 2024-09-19T12:19:00.599Z |
5114872 | 5114872 | 20240915020208_wRoJF | UK004E | 2024-09-18T12:05:38.781Z | 2024-09-19T12:19:00.424Z |
5114851 | 5114851 | 20240915020128_Pfuda | UK004E | 2024-09-18T12:05:37.341Z | 2024-09-19T12:19:00.272Z |
5114705 | 5114705 | 20240915015604_2WNHb | UK004E | 2024-09-18T12:05:30.217Z | 2024-09-19T12:18:59.433Z |
5114062 | 5114062 | 20240915012355_aWv0t | UK004E | 2024-09-18T12:05:00.226Z | 2024-09-19T12:18:55.509Z |
5113803 | 5113803 | 20240915011402_F5GAM | UK004E | 2024-09-18T12:04:50.896Z | 2024-09-19T12:18:52.842Z |
5113777 | 5113777 | 20240915011319_AJ4HP | UK004E | 2024-09-18T12:04:50.032Z | 2024-09-19T12:18:52.480Z |
5113653 | 5113653 | 20240915010258_5vMGz | UK004E | 2024-09-18T12:04:36.643Z | 2024-09-19T12:18:50.876Z |
5113632 | 5113632 | 20240915010131_ao2gb | UK004E | 2024-09-18T12:04:35.807Z | 2024-09-19T12:18:50.699Z |
5113405 | 5113405 | 20240915004727_ftDCV | UK004E | 2024-09-18T12:04:15.424Z | 2024-09-19T12:18:48.960Z |
5113178 | 5113178 | 20240915002938_qXRQf | UK004E | 2024-09-18T12:04:01.170Z | 2024-09-19T12:18:47.819Z |
5112770 | 5112770 | 20240914235234_rzWgt | UK004E | 2024-09-18T12:03:29.895Z | 2024-09-19T12:18:44.449Z |
5112755 | 5112755 | 20240914234852_s4xwq | UK004E | 2024-09-18T12:03:27.692Z | 2024-09-19T12:18:44.268Z |
5112482 | 5112482 | 20240914232005_tS8Dk | UK004E | 2024-09-18T12:03:09.989Z | 2024-09-19T12:18:41.137Z |
5112384 | 5112384 | 20240914230625_i34Qd | UK004E | 2024-09-18T12:03:01.835Z | 2024-09-19T12:18:40.775Z |
5112268 | 5112268 | 20240914224821_HPFlQ | UK004E | 2024-09-18T12:02:57.375Z | 2024-09-19T12:18:40.263Z |
5112255 | 5112255 | 20240914224729_gFtIX | UK004E | 2024-09-18T12:02:56.972Z | 2024-09-19T12:18:40.213Z |
5111930 | 5111930 | 20240914214238_Ps1ut | UK004E | 2024-09-18T12:02:31.113Z | 2024-09-19T12:18:35.291Z |
5111852 | 5111852 | 20240914212409_KHtgx | UK004E | 2024-09-18T12:02:22.628Z | 2024-09-19T12:18:34.652Z |
5111681 | 5111681 | 20240914210048_MwtEp | UK004E | 2024-09-18T12:02:10.979Z | 2024-09-19T12:18:33.105Z |
5111607 | 5111607 | 20240914205252_YwN9S | UK004E | 2024-09-18T12:02:06.101Z | 2024-09-19T12:18:32.351Z |
5111273 | 5111273 | 20240914201516_jTMNy | UK004E | 2024-09-18T12:01:46.664Z | 2024-09-19T12:18:28.335Z |
5111164 | 5111164 | 20240914200831_cF5f0 | UK004E | 2024-09-18T12:01:41.377Z | 2024-09-19T12:18:27.189Z |
5111155 | 5111155 | 20240914200831_aR3Zk | UK004E | 2024-09-18T12:01:41.204Z | 2024-09-19T12:18:27.165Z |
5107880 | 5107880 | 20240913041341_Jj022 | UK004E | 2024-09-17T12:13:25.461Z | 2024-09-19T12:20:47.624Z |
5107598 | 5107598 | 20240913040418_nyTHn | UK004E | 2024-09-17T12:13:17.709Z | 2024-09-19T12:20:47.295Z |
5107225 | 5107225 | 20240913034718_Uop2i | UK004E | 2024-09-17T12:13:10.883Z | 2024-09-19T12:20:46.917Z |
5107128 | 5107128 | 20240913034510_dBYnT | UK004E | 2024-09-17T12:13:09.519Z | 2024-09-19T12:20:46.844Z |
5107070 | 5107070 | 20240913034345_Uzh11 | UK004E | 2024-09-17T12:13:08.935Z | 2024-09-19T12:20:46.804Z |
5106423 | 5106423 | 20240913032413_Tw3rV | UK004E | 2024-09-17T12:12:53.539Z | 2024-09-19T12:20:46.063Z |
5106106 | 5106106 | 20240913031144_GR0PG | UK004E | 2024-09-17T12:12:42.401Z | 2024-09-19T12:20:45.496Z |
5105777 | 5105777 | 20240913025820_kNv3a | UK004E | 2024-09-17T12:12:28.806Z | 2024-09-19T12:20:44.875Z |
5105628 | 5105628 | 20240913025352_cZDk8 | UK004E | 2024-09-17T12:12:24.023Z | 2024-09-19T12:20:44.761Z |
5105555 | 5105555 | 20240913025139_2mBaD | UK004E | 2024-09-17T12:12:21.459Z | 2024-09-19T12:20:44.663Z |
5105508 | 5105508 | 20240913024943_BTqKC | UK004E | 2024-09-17T12:12:19.616Z | 2024-09-19T12:20:44.610Z |
5105262 | 5105262 | 20240913024007_rRyxQ | UK004E | 2024-09-17T12:12:07.112Z | 2024-09-19T12:20:44.211Z |
5104988 | 5104988 | 20240913022551_0oR4P | UK004E | 2024-09-17T12:11:48.546Z | 2024-09-19T12:20:43.312Z |
5104948 | 5104948 | 20240913022446_Dmclr | UK004E | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104939 | 5104939 | 20240913022446_t7vw5 | UK004E | 2024-09-17T12:11:47.230Z | 2024-09-19T12:20:43.128Z |
5104909 | 5104909 | 20240913022346_wH8wQ | UK004E | 2024-09-17T12:11:46.470Z | 2024-09-19T12:20:43.110Z |
5104846 | 5104846 | 20240913022156_n3Bko | UK004E | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104780 | 5104780 | 20240913022109_NoJDj | UK004E | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104608 | 5104608 | 20240913021743_Ctcvz | UK004E | 2024-09-17T12:11:41.209Z | 2024-09-19T12:20:42.636Z |
5104486 | 5104486 | 20240913021141_amQg3 | UK004E | 2024-09-17T12:11:36.815Z | 2024-09-19T12:20:41.535Z |
5104322 | 5104322 | 20240913020440_RxTrX | UK004E | 2024-09-17T12:11:33.003Z | 2024-09-19T12:20:41.359Z |
5104277 | 5104277 | 20240913020159_43ImQ | UK004E | 2024-09-17T12:11:31.539Z | 2024-09-19T12:20:41.307Z |
5104242 | 5104242 | 20240913020010_BWYVH | UK004E | 2024-09-17T12:11:30.382Z | 2024-09-19T12:20:41.275Z |
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);