participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,156 rows where station_code = "UK00AG" 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 |
---|---|---|---|---|---|
5129829 | 5129829 | 20240917043803_3TXdS | UK00AG | 2024-09-19T12:12:07.586Z | 2024-09-19T12:12:07.586Z |
5129814 | 5129814 | 20240917043704_S2MGD | UK00AG | 2024-09-19T12:12:06.555Z | 2024-09-19T12:12:06.555Z |
5129731 | 5129731 | 20240917042446_4c0yQ | UK00AG | 2024-09-19T12:12:02.431Z | 2024-09-19T12:12:02.431Z |
5129514 | 5129514 | 20240917040616_2GWNz | UK00AG | 2024-09-19T12:11:45.980Z | 2024-09-19T12:11:45.980Z |
5129354 | 5129354 | 20240917035057_b0sYZ | UK00AG | 2024-09-19T12:11:30.380Z | 2024-09-19T12:11:30.380Z |
5129112 | 5129112 | 20240917032028_UjnSk | UK00AG | 2024-09-19T12:11:15.591Z | 2024-09-19T12:11:15.591Z |
5128825 | 5128825 | 20240917024456_2qPrg | UK00AG | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128569 | 5128569 | 20240917020353_0EwfC | UK00AG | 2024-09-19T12:10:43.908Z | 2024-09-19T12:10:43.908Z |
5128519 | 5128519 | 20240917015304_yIYF4 | UK00AG | 2024-09-19T12:10:40.227Z | 2024-09-19T12:10:40.227Z |
5128399 | 5128399 | 20240917013434_kZdUd | UK00AG | 2024-09-19T12:10:30.605Z | 2024-09-19T12:10:30.605Z |
5128237 | 5128237 | 20240917010822_61oNf | UK00AG | 2024-09-19T12:10:21.192Z | 2024-09-19T12:10:21.192Z |
5128218 | 5128218 | 20240917010746_jVw0C | UK00AG | 2024-09-19T12:10:20.295Z | 2024-09-19T12:10:20.295Z |
5128070 | 5128070 | 20240917003218_Yjok5 | UK00AG | 2024-09-19T12:10:00.073Z | 2024-09-19T12:10:00.073Z |
5128053 | 5128053 | 20240917002958_DCV0a | UK00AG | 2024-09-19T12:09:56.963Z | 2024-09-19T12:09:56.963Z |
5128002 | 5128002 | 20240917002002_Xs5Vp | UK00AG | 2024-09-19T12:09:54.073Z | 2024-09-19T12:09:54.073Z |
5127639 | 5127639 | 20240916223824_kxTy6 | UK00AG | 2024-09-19T12:09:27.862Z | 2024-09-19T12:09:27.862Z |
5127615 | 5127615 | 20240916223556_JAi7W | UK00AG | 2024-09-19T12:09:26.054Z | 2024-09-19T12:09:26.054Z |
5127418 | 5127418 | 20240916214620_NCFqq | UK00AG | 2024-09-19T12:09:05.127Z | 2024-09-19T12:09:05.127Z |
5127334 | 5127334 | 20240916213052_3OyFE | UK00AG | 2024-09-19T12:08:53.504Z | 2024-09-19T12:08:53.504Z |
5127153 | 5127153 | 20240916203420_7rUnL | UK00AG | 2024-09-19T12:08:19.545Z | 2024-09-19T12:08:19.545Z |
5127109 | 5127109 | 20240916202354_hctKj | UK00AG | 2024-09-19T12:08:12.563Z | 2024-09-19T12:08:12.563Z |
5126924 | 5126924 | 20240916195352_LkSm4 | UK00AG | 2024-09-19T12:07:41.508Z | 2024-09-19T12:07:41.508Z |
5126864 | 5126864 | 20240916194132_mW4qH | UK00AG | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5126817 | 5126817 | 20240916193654_zRgQO | UK00AG | 2024-09-19T12:07:19.823Z | 2024-09-19T12:07:19.823Z |
5125770 | 5125770 | 20240918034841_65Fh3 | UK00AG | 2024-09-19T12:04:03.467Z | 2024-09-19T12:06:42.083Z |
5125739 | 5125739 | 20240918033402_tJDuW | UK00AG | 2024-09-19T12:03:59.171Z | 2024-09-19T12:06:42.077Z |
5125679 | 5125679 | 20240918031802_Dfwot | UK00AG | 2024-09-19T12:03:51.355Z | 2024-09-19T12:06:42.067Z |
5125563 | 5125563 | 20240918030035_9bzAU | UK00AG | 2024-09-19T12:03:32.397Z | 2024-09-19T12:06:42.051Z |
5125551 | 5125551 | 20240918025645_Nsy9g | UK00AG | 2024-09-19T12:03:29.949Z | 2024-09-19T12:06:42.049Z |
5125204 | 5125204 | 20240918011045_7mqz2 | UK00AG | 2024-09-19T12:02:30.086Z | 2024-09-19T12:06:41.991Z |
5124507 | 5124507 | 20240917205352_VHVXe | UK00AG | 2024-09-19T12:01:03.842Z | 2024-09-19T12:06:41.905Z |
5121787 | 5121787 | 20240914041403_ASe5X | UK00AG | 2024-09-18T12:11:01.307Z | 2024-09-19T12:20:02.367Z |
5121104 | 5121104 | 20240914035213_piLCa | UK00AG | 2024-09-18T12:10:51.213Z | 2024-09-19T12:20:01.362Z |
5120825 | 5120825 | 20240914033552_fwlf5 | UK00AG | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5120765 | 5120765 | 20240914033443_UEKyt | UK00AG | 2024-09-18T12:10:46.591Z | 2024-09-19T12:20:00.853Z |
5120583 | 5120583 | 20240914032825_SiR6n | UK00AG | 2024-09-18T12:10:43.433Z | 2024-09-19T12:20:00.612Z |
5120547 | 5120547 | 20240914032754_uE9bi | UK00AG | 2024-09-18T12:10:42.964Z | 2024-09-19T12:20:00.564Z |
5120467 | 5120467 | 20240914032201_e6H2p | UK00AG | 2024-09-18T12:10:41.043Z | 2024-09-19T12:20:00.387Z |
5120409 | 5120409 | 20240914031959_1YP8A | UK00AG | 2024-09-18T12:10:39.292Z | 2024-09-19T12:20:00.109Z |
5119624 | 5119624 | 20240914024024_5JL2w | UK00AG | 2024-09-18T12:10:22.717Z | 2024-09-19T12:19:58.600Z |
5117469 | 5117469 | 20240915043603_zgEHc | UK00AG | 2024-09-18T12:07:42.150Z | 2024-09-19T12:19:15.157Z |
5117446 | 5117446 | 20240915043339_hFYBo | UK00AG | 2024-09-18T12:07:41.651Z | 2024-09-19T12:19:15.101Z |
5117243 | 5117243 | 20240915041438_lwds4 | UK00AG | 2024-09-18T12:07:35.964Z | 2024-09-19T12:19:13.959Z |
5117196 | 5117196 | 20240915041112_lgb8N | UK00AG | 2024-09-18T12:07:35.130Z | 2024-09-19T12:19:13.784Z |
5117094 | 5117094 | 20240915040200_ac18K | UK00AG | 2024-09-18T12:07:32.511Z | 2024-09-19T12:19:13.307Z |
5116817 | 5116817 | 20240915034322_raSAp | UK00AG | 2024-09-18T12:07:21.765Z | 2024-09-19T12:19:12.427Z |
5116583 | 5116583 | 20240915033225_MK2tZ | UK00AG | 2024-09-18T12:07:10.682Z | 2024-09-19T12:19:11.568Z |
5116228 | 5116228 | 20240915031635_croLP | UK00AG | 2024-09-18T12:06:49.708Z | 2024-09-19T12:19:09.918Z |
5116100 | 5116100 | 20240915030821_4vJ8v | UK00AG | 2024-09-18T12:06:39.791Z | 2024-09-19T12:19:08.717Z |
5115094 | 5115094 | 20240915021959_n3SVm | UK00AG | 2024-09-18T12:05:58.462Z | 2024-09-19T12:19:01.589Z |
5114840 | 5114840 | 20240915020037_79AML | UK00AG | 2024-09-18T12:05:36.393Z | 2024-09-19T12:19:00.134Z |
5114773 | 5114773 | 20240915015743_9K7A3 | UK00AG | 2024-09-18T12:05:33.745Z | 2024-09-19T12:18:59.867Z |
5114542 | 5114542 | 20240915014713_41uEl | UK00AG | 2024-09-18T12:05:21.328Z | 2024-09-19T12:18:58.811Z |
5114205 | 5114205 | 20240915013034_k8F25 | UK00AG | 2024-09-18T12:05:06.105Z | 2024-09-19T12:18:56.698Z |
5114191 | 5114191 | 20240915013027_ED8xF | UK00AG | 2024-09-18T12:05:05.873Z | 2024-09-19T12:18:56.665Z |
5113936 | 5113936 | 20240915012025_uhUMW | UK00AG | 2024-09-18T12:04:55.862Z | 2024-09-19T12:18:54.474Z |
5113908 | 5113908 | 20240915011813_4rPkM | UK00AG | 2024-09-18T12:04:55.120Z | 2024-09-19T12:18:54.250Z |
5113571 | 5113571 | 20240915005848_uNoZL | UK00AG | 2024-09-18T12:04:30.652Z | 2024-09-19T12:18:50.395Z |
5113551 | 5113551 | 20240915005801_fLugr | UK00AG | 2024-09-18T12:04:29.229Z | 2024-09-19T12:18:50.311Z |
5113095 | 5113095 | 20240915002224_ZeX8b | UK00AG | 2024-09-18T12:03:56.282Z | 2024-09-19T12:18:46.993Z |
5113032 | 5113032 | 20240915001631_Ul52A | UK00AG | 2024-09-18T12:03:51.992Z | 2024-09-19T12:18:46.575Z |
5112776 | 5112776 | 20240914235301_W2V2i | UK00AG | 2024-09-18T12:03:31.852Z | 2024-09-19T12:18:44.609Z |
5112656 | 5112656 | 20240914233857_oFHQB | UK00AG | 2024-09-18T12:03:19.364Z | 2024-09-19T12:18:42.650Z |
5112101 | 5112101 | 20240914221423_sct88 | UK00AG | 2024-09-18T12:02:47.713Z | 2024-09-19T12:18:38.285Z |
5111744 | 5111744 | 20240914211135_QpvFq | UK00AG | 2024-09-18T12:02:14.754Z | 2024-09-19T12:18:33.764Z |
5111701 | 5111701 | 20240914210049_wBjPi | UK00AG | 2024-09-18T12:02:11.198Z | 2024-09-19T12:18:33.328Z |
5111620 | 5111620 | 20240914205333_QU30U | UK00AG | 2024-09-18T12:02:07.598Z | 2024-09-19T12:18:32.533Z |
5111432 | 5111432 | 20240914203608_z6s2s | UK00AG | 2024-09-18T12:01:55.887Z | 2024-09-19T12:18:30.113Z |
5111409 | 5111409 | 20240914203244_ruBHL | UK00AG | 2024-09-18T12:01:55.176Z | 2024-09-19T12:18:30.041Z |
5111302 | 5111302 | 20240914202048_RBYeT | UK00AG | 2024-09-18T12:01:48.338Z | 2024-09-19T12:18:28.847Z |
5111054 | 5111054 | 20240914194621_Ywshl | UK00AG | 2024-09-18T12:01:23.304Z | 2024-09-19T12:18:25.576Z |
5111008 | 5111008 | 20240914193941_xDZd2 | UK00AG | 2024-09-18T12:01:19.167Z | 2024-09-19T12:18:25.275Z |
5110891 | 5110891 | 20240914191958_NdXQ0 | UK00AG | 2024-09-18T12:01:08.999Z | 2024-09-19T12:18:24.552Z |
5108180 | 5108180 | 20240913042923_2WrGD | UK00AG | 2024-09-17T12:13:31.956Z | 2024-09-19T12:20:47.896Z |
5108026 | 5108026 | 20240913042031_D9G3s | UK00AG | 2024-09-17T12:13:28.326Z | 2024-09-19T12:20:47.751Z |
5107838 | 5107838 | 20240913041158_IXYqC | UK00AG | 2024-09-17T12:13:24.420Z | 2024-09-19T12:20:47.585Z |
5107650 | 5107650 | 20240913040744_ph42q | UK00AG | 2024-09-17T12:13:20.694Z | 2024-09-19T12:20:47.439Z |
5107487 | 5107487 | 20240913035754_qRrr2 | UK00AG | 2024-09-17T12:13:16.116Z | 2024-09-19T12:20:47.186Z |
5106134 | 5106134 | 20240913031225_NtuIQ | UK00AG | 2024-09-17T12:12:42.738Z | 2024-09-19T12:20:45.508Z |
5106095 | 5106095 | 20240913031041_Kn2zk | UK00AG | 2024-09-17T12:12:41.991Z | 2024-09-19T12:20:45.481Z |
5105621 | 5105621 | 20240913025313_zgP1k | UK00AG | 2024-09-17T12:12:23.719Z | 2024-09-19T12:20:44.754Z |
5105183 | 5105183 | 20240913023629_Vr2h5 | UK00AG | 2024-09-17T12:12:01.678Z | 2024-09-19T12:20:44.092Z |
5105038 | 5105038 | 20240913022811_3jGUA | UK00AG | 2024-09-17T12:11:50.580Z | 2024-09-19T12:20:43.425Z |
5104671 | 5104671 | 20240913021814_1HhV8 | UK00AG | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.660Z |
5104023 | 5104023 | 20240913014743_HNaIF | UK00AG | 2024-09-17T12:11:22.354Z | 2024-09-19T12:20:40.896Z |
5103707 | 5103707 | 20240913013553_ejHYY | UK00AG | 2024-09-17T12:11:07.998Z | 2024-09-19T12:20:40.423Z |
5103456 | 5103456 | 20240913013054_BCgK8 | UK00AG | 2024-09-17T12:10:57.980Z | 2024-09-19T12:20:40.183Z |
5103376 | 5103376 | 20240913012914_waADd | UK00AG | 2024-09-17T12:10:55.282Z | 2024-09-19T12:20:40.116Z |
5103179 | 5103179 | 20240914020340_xw8Hd | UK00AG | 2024-09-17T12:07:55.401Z | 2024-09-19T12:19:56.762Z |
5103155 | 5103155 | 20240914020250_Sndae | UK00AG | 2024-09-17T12:07:53.955Z | 2024-09-19T12:19:56.689Z |
5102948 | 5102948 | 20240914015535_82Si3 | UK00AG | 2024-09-17T12:07:44.942Z | 2024-09-19T12:19:56.211Z |
5102864 | 5102864 | 20240914014954_wVKS6 | UK00AG | 2024-09-17T12:07:40.854Z | 2024-09-19T12:19:55.981Z |
5102646 | 5102646 | 20240914013445_qjXSN | UK00AG | 2024-09-17T12:07:29.098Z | 2024-09-19T12:19:55.290Z |
5102369 | 5102369 | 20240914012212_obuj0 | UK00AG | 2024-09-17T12:07:05.274Z | 2024-09-19T12:19:53.902Z |
5102212 | 5102212 | 20240914011210_ADSRA | UK00AG | 2024-09-17T12:06:54.706Z | 2024-09-19T12:19:52.884Z |
5102125 | 5102125 | 20240914010628_RARmq | UK00AG | 2024-09-17T12:06:49.361Z | 2024-09-19T12:19:52.501Z |
5102050 | 5102050 | 20240914010315_dJS7Q | UK00AG | 2024-09-17T12:06:44.693Z | 2024-09-19T12:19:52.319Z |
5101988 | 5101988 | 20240914005818_T6cvD | UK00AG | 2024-09-17T12:06:36.662Z | 2024-09-19T12:19:52.094Z |
5101900 | 5101900 | 20240914005456_wpz23 | UK00AG | 2024-09-17T12:06:22.454Z | 2024-09-19T12:19:51.845Z |
5101564 | 5101564 | 20240914003536_xa1zA | UK00AG | 2024-09-17T12:06:02.029Z | 2024-09-19T12:19:50.930Z |
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);