participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,776 rows where station_code = "UK0034" 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 |
---|---|---|---|---|---|
5135670 | 5135670 | 20240914033304_x0Z2J | UK0034 | 2024-09-19T12:20:00.833Z | 2024-09-19T12:20:00.833Z |
5133824 | 5133824 | 20240916040759_zX1NI | UK0034 | 2024-09-19T12:17:10.039Z | 2024-09-19T12:17:10.039Z |
5132935 | 5132935 | 20240916023025_7bUPG | UK0034 | 2024-09-19T12:16:38.033Z | 2024-09-19T12:16:38.033Z |
5121476 | 5121476 | 20240914040446_Ed2AU | UK0034 | 2024-09-18T12:10:57.122Z | 2024-09-19T12:20:01.957Z |
5121382 | 5121382 | 20240914035911_Tv6J3 | UK0034 | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5121298 | 5121298 | 20240914035805_aEwVT | UK0034 | 2024-09-18T12:10:54.131Z | 2024-09-19T12:20:01.619Z |
5121168 | 5121168 | 20240914035440_zfJJC | UK0034 | 2024-09-18T12:10:52.106Z | 2024-09-19T12:20:01.464Z |
5120787 | 5120787 | 20240914033528_eFpzL | UK0034 | 2024-09-18T12:10:46.694Z | 2024-09-19T12:20:00.858Z |
5120775 | 5120775 | 20240914033522_Iae8b | UK0034 | 2024-09-18T12:10:46.656Z | 2024-09-19T12:20:00.856Z |
5120718 | 5120718 | 20240914033304_2dWFf | UK0034 | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120560 | 5120560 | 20240914032801_Gq8pV | UK0034 | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120253 | 5120253 | 20240914031049_39oaf | UK0034 | 2024-09-18T12:10:36.415Z | 2024-09-19T12:19:59.844Z |
5120160 | 5120160 | 20240914030300_Dv3Ux | UK0034 | 2024-09-18T12:10:33.149Z | 2024-09-19T12:19:59.505Z |
5120062 | 5120062 | 20240914025821_3O2iZ | UK0034 | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5120037 | 5120037 | 20240914025743_bg8z7 | UK0034 | 2024-09-18T12:10:31.178Z | 2024-09-19T12:19:59.342Z |
5120024 | 5120024 | 20240914025731_FrGwA | UK0034 | 2024-09-18T12:10:31.113Z | 2024-09-19T12:19:59.305Z |
5120006 | 5120006 | 20240914025625_lO87G | UK0034 | 2024-09-18T12:10:31.070Z | 2024-09-19T12:19:59.301Z |
5119949 | 5119949 | 20240914025435_342zJ | UK0034 | 2024-09-18T12:10:29.911Z | 2024-09-19T12:19:59.188Z |
5119704 | 5119704 | 20240914024413_3Swqf | UK0034 | 2024-09-18T12:10:24.382Z | 2024-09-19T12:19:58.781Z |
5119591 | 5119591 | 20240914023959_ZZWNM | UK0034 | 2024-09-18T12:10:22.568Z | 2024-09-19T12:19:58.559Z |
5119557 | 5119557 | 20240914023920_ytJ2I | UK0034 | 2024-09-18T12:10:22.337Z | 2024-09-19T12:19:58.536Z |
5119539 | 5119539 | 20240914023837_UfZw2 | UK0034 | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119398 | 5119398 | 20240914023117_zHIDQ | UK0034 | 2024-09-18T12:10:20.763Z | 2024-09-19T12:19:58.115Z |
5119372 | 5119372 | 20240914022955_aPR5h | UK0034 | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.099Z |
5119241 | 5119241 | 20240914021832_IPZrP | UK0034 | 2024-09-18T12:10:18.774Z | 2024-09-19T12:19:57.474Z |
5117340 | 5117340 | 20240915041928_38V2e | UK0034 | 2024-09-18T12:07:38.064Z | 2024-09-19T12:19:14.339Z |
5117278 | 5117278 | 20240915041611_3DJeO | UK0034 | 2024-09-18T12:07:36.714Z | 2024-09-19T12:19:14.077Z |
5117050 | 5117050 | 20240915035814_CY30F | UK0034 | 2024-09-18T12:07:30.917Z | 2024-09-19T12:19:13.192Z |
5116659 | 5116659 | 20240915033422_KaH04 | UK0034 | 2024-09-18T12:07:14.905Z | 2024-09-19T12:19:11.859Z |
5116512 | 5116512 | 20240915033030_5Zu31 | UK0034 | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5115794 | 5115794 | 20240915025401_fOiNa | UK0034 | 2024-09-18T12:06:24.113Z | 2024-09-19T12:19:07.364Z |
5115558 | 5115558 | 20240915024434_7N2Sy | UK0034 | 2024-09-18T12:06:17.830Z | 2024-09-19T12:19:05.367Z |
5115478 | 5115478 | 20240915024134_YdZw3 | UK0034 | 2024-09-18T12:06:15.888Z | 2024-09-19T12:19:04.990Z |
5115312 | 5115312 | 20240915023131_Iwwwa | UK0034 | 2024-09-18T12:06:10.554Z | 2024-09-19T12:19:03.871Z |
5115136 | 5115136 | 20240915022149_vJkX6 | UK0034 | 2024-09-18T12:06:02.790Z | 2024-09-19T12:19:02.495Z |
5115056 | 5115056 | 20240915021611_mquuu | UK0034 | 2024-09-18T12:05:54.953Z | 2024-09-19T12:19:01.285Z |
5114892 | 5114892 | 20240915020640_d37AY | UK0034 | 2024-09-18T12:05:40.363Z | 2024-09-19T12:19:00.503Z |
5114486 | 5114486 | 20240915014441_aDP0R | UK0034 | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.558Z |
5114376 | 5114376 | 20240915014044_iD3CJ | UK0034 | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5114251 | 5114251 | 20240915013349_gnE23 | UK0034 | 2024-09-18T12:05:08.913Z | 2024-09-19T12:18:57.327Z |
5113949 | 5113949 | 20240915012055_C0WRs | UK0034 | 2024-09-18T12:04:56.236Z | 2024-09-19T12:18:54.703Z |
5113755 | 5113755 | 20240915011105_IiwPt | UK0034 | 2024-09-18T12:04:49.297Z | 2024-09-19T12:18:51.854Z |
5113715 | 5113715 | 20240915010850_9SAIe | UK0034 | 2024-09-18T12:04:46.143Z | 2024-09-19T12:18:51.778Z |
5113610 | 5113610 | 20240915010050_dCSql | UK0034 | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5113442 | 5113442 | 20240915004949_mcy3v | UK0034 | 2024-09-18T12:04:17.704Z | 2024-09-19T12:18:49.142Z |
5113359 | 5113359 | 20240915003928_6K3G8 | UK0034 | 2024-09-18T12:04:09.826Z | 2024-09-19T12:18:48.598Z |
5113261 | 5113261 | 20240915003432_6n1N7 | UK0034 | 2024-09-18T12:04:05.017Z | 2024-09-19T12:18:48.290Z |
5113242 | 5113242 | 20240915003259_1dwE3 | UK0034 | 2024-09-18T12:04:04.682Z | 2024-09-19T12:18:48.268Z |
5113210 | 5113210 | 20240915003210_PtWdE | UK0034 | 2024-09-18T12:04:03.183Z | 2024-09-19T12:18:48.003Z |
5113176 | 5113176 | 20240915002938_qXRQf | UK0034 | 2024-09-18T12:04:01.170Z | 2024-09-19T12:18:47.819Z |
5113036 | 5113036 | 20240915001640_zqpDA | UK0034 | 2024-09-18T12:03:52.446Z | 2024-09-19T12:18:46.674Z |
5112972 | 5112972 | 20240915001109_JKPUo | UK0034 | 2024-09-18T12:03:49.881Z | 2024-09-19T12:18:46.235Z |
5112769 | 5112769 | 20240914235234_rzWgt | UK0034 | 2024-09-18T12:03:29.895Z | 2024-09-19T12:18:44.449Z |
5112435 | 5112435 | 20240914231447_tdCWJ | UK0034 | 2024-09-18T12:03:06.394Z | 2024-09-19T12:18:41.023Z |
5111927 | 5111927 | 20240914214238_Ps1ut | UK0034 | 2024-09-18T12:02:31.113Z | 2024-09-19T12:18:35.291Z |
5111831 | 5111831 | 20240914212020_ys9E5 | UK0034 | 2024-09-18T12:02:19.078Z | 2024-09-19T12:18:34.222Z |
5111163 | 5111163 | 20240914200831_cF5f0 | UK0034 | 2024-09-18T12:01:41.377Z | 2024-09-19T12:18:27.189Z |
5111154 | 5111154 | 20240914200831_aR3Zk | UK0034 | 2024-09-18T12:01:41.204Z | 2024-09-19T12:18:27.165Z |
5110935 | 5110935 | 20240914193007_bLy1e | UK0034 | 2024-09-18T12:01:13.359Z | 2024-09-19T12:18:24.881Z |
5108080 | 5108080 | 20240913042229_1fef9 | UK0034 | 2024-09-17T12:13:30.314Z | 2024-09-19T12:20:47.836Z |
5107819 | 5107819 | 20240913041144_1s6ON | UK0034 | 2024-09-17T12:13:24.220Z | 2024-09-19T12:20:47.577Z |
5107750 | 5107750 | 20240913040937_NdYVv | UK0034 | 2024-09-17T12:13:23.553Z | 2024-09-19T12:20:47.532Z |
5107596 | 5107596 | 20240913040418_nyTHn | UK0034 | 2024-09-17T12:13:17.709Z | 2024-09-19T12:20:47.295Z |
5107321 | 5107321 | 20240913035244_r9TG4 | UK0034 | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107223 | 5107223 | 20240913034718_Uop2i | UK0034 | 2024-09-17T12:13:10.883Z | 2024-09-19T12:20:46.917Z |
5106809 | 5106809 | 20240913033538_U5EMJ | UK0034 | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106758 | 5106758 | 20240913033355_jgXwb | UK0034 | 2024-09-17T12:13:00.753Z | 2024-09-19T12:20:46.382Z |
5106453 | 5106453 | 20240913032453_dmndV | UK0034 | 2024-09-17T12:12:54.558Z | 2024-09-19T12:20:46.087Z |
5105627 | 5105627 | 20240913025352_cZDk8 | UK0034 | 2024-09-17T12:12:24.023Z | 2024-09-19T12:20:44.761Z |
5105589 | 5105589 | 20240913025302_VJiq5 | UK0034 | 2024-09-17T12:12:23.019Z | 2024-09-19T12:20:44.712Z |
5105379 | 5105379 | 20240913024341_ZdaEM | UK0034 | 2024-09-17T12:12:12.327Z | 2024-09-19T12:20:44.388Z |
5105192 | 5105192 | 20240913023720_AH0tJ | UK0034 | 2024-09-17T12:12:02.316Z | 2024-09-19T12:20:44.109Z |
5104946 | 5104946 | 20240913022446_Dmclr | UK0034 | 2024-09-17T12:11:47.351Z | 2024-09-19T12:20:43.130Z |
5104907 | 5104907 | 20240913022346_wH8wQ | UK0034 | 2024-09-17T12:11:46.470Z | 2024-09-19T12:20:43.109Z |
5103661 | 5103661 | 20240913013551_Kikf3 | UK0034 | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.420Z |
5103554 | 5103554 | 20240913013227_p597S | UK0034 | 2024-09-17T12:11:03.777Z | 2024-09-19T12:20:40.293Z |
5102957 | 5102957 | 20240914015535_a14ii | UK0034 | 2024-09-17T12:07:45.127Z | 2024-09-19T12:19:56.216Z |
5102786 | 5102786 | 20240914014439_R2HqQ | UK0034 | 2024-09-17T12:07:36.608Z | 2024-09-19T12:19:55.644Z |
5102729 | 5102729 | 20240914014006_3jfFa | UK0034 | 2024-09-17T12:07:33.221Z | 2024-09-19T12:19:55.448Z |
5102615 | 5102615 | 20240914013339_39vsE | UK0034 | 2024-09-17T12:07:27.594Z | 2024-09-19T12:19:55.244Z |
5101869 | 5101869 | 20240914005300_qjs2H | UK0034 | 2024-09-17T12:06:18.950Z | 2024-09-19T12:19:51.735Z |
5101862 | 5101862 | 20240914005258_VOnjM | UK0034 | 2024-09-17T12:06:18.703Z | 2024-09-19T12:19:51.721Z |
5101825 | 5101825 | 20240914004935_3FFAa | UK0034 | 2024-09-17T12:06:15.372Z | 2024-09-19T12:19:51.627Z |
5101807 | 5101807 | 20240914004743_Hc965 | UK0034 | 2024-09-17T12:06:13.296Z | 2024-09-19T12:19:51.528Z |
5101707 | 5101707 | 20240914004340_8M1TP | UK0034 | 2024-09-17T12:06:09.652Z | 2024-09-19T12:19:51.305Z |
5101610 | 5101610 | 20240914003907_SgXcF | UK0034 | 2024-09-17T12:06:05.143Z | 2024-09-19T12:19:51.103Z |
5101367 | 5101367 | 20240914002217_g2svX | UK0034 | 2024-09-17T12:05:39.556Z | 2024-09-19T12:19:50.407Z |
5100612 | 5100612 | 20240913233503_8Xd6R | UK0034 | 2024-09-17T12:04:42.072Z | 2024-09-19T12:19:48.205Z |
5100600 | 5100600 | 20240913233427_ai43h | UK0034 | 2024-09-17T12:04:41.257Z | 2024-09-19T12:19:48.188Z |
5100521 | 5100521 | 20240913232936_gqCs2 | UK0034 | 2024-09-17T12:04:37.933Z | 2024-09-19T12:19:48.092Z |
5100488 | 5100488 | 20240913232838_Zt08a | UK0034 | 2024-09-17T12:04:36.606Z | 2024-09-19T12:19:48.057Z |
5100223 | 5100223 | 20240913230702_TG3Ey | UK0034 | 2024-09-17T12:04:19.512Z | 2024-09-19T12:19:47.330Z |
5100071 | 5100071 | 20240913224611_5xHJx | UK0034 | 2024-09-17T12:03:56.028Z | 2024-09-19T12:19:46.824Z |
5099943 | 5099943 | 20240913222529_BYRsN | UK0034 | 2024-09-17T12:03:45.059Z | 2024-09-19T12:19:46.579Z |
5099893 | 5099893 | 20240913222044_FYxaB | UK0034 | 2024-09-17T12:03:42.452Z | 2024-09-19T12:19:46.312Z |
5099877 | 5099877 | 20240913222014_2nIJI | UK0034 | 2024-09-17T12:03:42.160Z | 2024-09-19T12:19:46.310Z |
5099675 | 5099675 | 20240913214750_lu2LC | UK0034 | 2024-09-17T12:03:22.672Z | 2024-09-19T12:19:45.667Z |
5099552 | 5099552 | 20240913213643_njUJA | UK0034 | 2024-09-17T12:03:09.950Z | 2024-09-19T12:19:45.304Z |
5099348 | 5099348 | 20240913210539_NZJ4w | UK0034 | 2024-09-17T12:02:48.810Z | 2024-09-19T12:19:44.582Z |
5099161 | 5099161 | 20240913203235_ylaZt | UK0034 | 2024-09-17T12:02:24.403Z | 2024-09-19T12:19:43.666Z |
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);