participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,596 rows where station_code = "UK00AK" 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 |
---|---|---|---|---|---|
5129848 | 5129848 | 20240917043859_nFGTo | UK00AK | 2024-09-19T12:12:09.412Z | 2024-09-19T12:12:09.412Z |
5129799 | 5129799 | 20240917043123_m7HA3 | UK00AK | 2024-09-19T12:12:05.535Z | 2024-09-19T12:12:05.535Z |
5129775 | 5129775 | 20240917042607_3EGWz | UK00AK | 2024-09-19T12:12:03.111Z | 2024-09-19T12:12:03.111Z |
5129564 | 5129564 | 20240917040937_mQ4zf | UK00AK | 2024-09-19T12:11:49.202Z | 2024-09-19T12:11:49.202Z |
5129477 | 5129477 | 20240917040048_Yoxo3 | UK00AK | 2024-09-19T12:11:41.539Z | 2024-09-19T12:11:41.539Z |
5129456 | 5129456 | 20240917035834_JawYz | UK00AK | 2024-09-19T12:11:39.733Z | 2024-09-19T12:11:39.733Z |
5129290 | 5129290 | 20240917034459_KC7K8 | UK00AK | 2024-09-19T12:11:25.884Z | 2024-09-19T12:11:25.884Z |
5129222 | 5129222 | 20240917033757_CJFTp | UK00AK | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5129081 | 5129081 | 20240917031448_geWKH | UK00AK | 2024-09-19T12:11:14.268Z | 2024-09-19T12:11:14.268Z |
5128753 | 5128753 | 20240917023112_gpYjQ | UK00AK | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5128685 | 5128685 | 20240917022354_sIN33 | UK00AK | 2024-09-19T12:10:55.879Z | 2024-09-19T12:10:55.879Z |
5128178 | 5128178 | 20240917010447_X1GiO | UK00AK | 2024-09-19T12:10:19.485Z | 2024-09-19T12:10:19.485Z |
5128171 | 5128171 | 20240917010049_93tfg | UK00AK | 2024-09-19T12:10:16.282Z | 2024-09-19T12:10:16.282Z |
5122119 | 5122119 | 20240914043657_mTNlm | UK00AK | 2024-09-18T12:11:07.575Z | 2024-09-19T12:20:02.860Z |
5119392 | 5119392 | 20240914023010_2gAO0 | UK00AK | 2024-09-18T12:10:20.700Z | 2024-09-19T12:19:58.110Z |
5119302 | 5119302 | 20240914022156_OW3Uc | UK00AK | 2024-09-18T12:10:19.594Z | 2024-09-19T12:19:57.637Z |
5119284 | 5119284 | 20240914022113_VaKGg | UK00AK | 2024-09-18T12:10:19.393Z | 2024-09-19T12:19:57.573Z |
5119206 | 5119206 | 20240914021729_JiNMy | UK00AK | 2024-09-18T12:10:18.502Z | 2024-09-19T12:19:57.387Z |
5119060 | 5119060 | 20240914020701_BM4BI | UK00AK | 2024-09-18T12:10:15.477Z | 2024-09-19T12:19:56.996Z |
5117480 | 5117480 | 20240915044025_CUwv8 | UK00AK | 2024-09-18T12:07:42.511Z | 2024-09-19T12:19:15.234Z |
5117454 | 5117454 | 20240915043434_oi86x | UK00AK | 2024-09-18T12:07:41.743Z | 2024-09-19T12:19:15.112Z |
5117392 | 5117392 | 20240915042439_vmSJs | UK00AK | 2024-09-18T12:07:39.872Z | 2024-09-19T12:19:14.747Z |
5117371 | 5117371 | 20240915042118_HJm5b | UK00AK | 2024-09-18T12:07:38.816Z | 2024-09-19T12:19:14.503Z |
5117265 | 5117265 | 20240915041543_32kqX | UK00AK | 2024-09-18T12:07:36.388Z | 2024-09-19T12:19:14.056Z |
5117226 | 5117226 | 20240915041401_n0PlA | UK00AK | 2024-09-18T12:07:35.893Z | 2024-09-19T12:19:13.935Z |
5117182 | 5117182 | 20240915041003_QlPFM | UK00AK | 2024-09-18T12:07:34.521Z | 2024-09-19T12:19:13.725Z |
5117134 | 5117134 | 20240915040416_w2Q9V | UK00AK | 2024-09-18T12:07:33.399Z | 2024-09-19T12:19:13.472Z |
5116942 | 5116942 | 20240915035106_fqa3m | UK00AK | 2024-09-18T12:07:26.453Z | 2024-09-19T12:19:12.803Z |
5116777 | 5116777 | 20240915034143_L2wKJ | UK00AK | 2024-09-18T12:07:20.731Z | 2024-09-19T12:19:12.351Z |
5116560 | 5116560 | 20240915033128_ritA0 | UK00AK | 2024-09-18T12:07:09.643Z | 2024-09-19T12:19:11.512Z |
5116545 | 5116545 | 20240915033128_j9tT2 | UK00AK | 2024-09-18T12:07:09.412Z | 2024-09-19T12:19:11.508Z |
5116095 | 5116095 | 20240915030817_fn6LA | UK00AK | 2024-09-18T12:06:39.428Z | 2024-09-19T12:19:08.692Z |
5115897 | 5115897 | 20240915025812_Re3Hl | UK00AK | 2024-09-18T12:06:31.253Z | 2024-09-19T12:19:07.791Z |
5115887 | 5115887 | 20240915025807_UCeaq | UK00AK | 2024-09-18T12:06:31.052Z | 2024-09-19T12:19:07.764Z |
5115819 | 5115819 | 20240915025422_gs7RP | UK00AK | 2024-09-18T12:06:25.400Z | 2024-09-19T12:19:07.415Z |
5115320 | 5115320 | 20240915023131_Iwwwa | UK00AK | 2024-09-18T12:06:10.554Z | 2024-09-19T12:19:03.871Z |
5114681 | 5114681 | 20240915015324_Xb4qe | UK00AK | 2024-09-18T12:05:28.076Z | 2024-09-19T12:18:59.202Z |
5114433 | 5114433 | 20240915014157_Vwngi | UK00AK | 2024-09-18T12:05:16.357Z | 2024-09-19T12:18:58.158Z |
5114410 | 5114410 | 20240915014101_hZoLI | UK00AK | 2024-09-18T12:05:14.305Z | 2024-09-19T12:18:57.938Z |
5114309 | 5114309 | 20240915013626_9fees | UK00AK | 2024-09-18T12:05:10.086Z | 2024-09-19T12:18:57.490Z |
5113956 | 5113956 | 20240915012055_C0WRs | UK00AK | 2024-09-18T12:04:56.236Z | 2024-09-19T12:18:54.703Z |
5113849 | 5113849 | 20240915011543_gYMsi | UK00AK | 2024-09-18T12:04:52.719Z | 2024-09-19T12:18:53.295Z |
5113620 | 5113620 | 20240915010050_dCSql | UK00AK | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5113514 | 5113514 | 20240915005442_XzKEY | UK00AK | 2024-09-18T12:04:25.117Z | 2024-09-19T12:18:49.796Z |
5113237 | 5113237 | 20240915003258_BqV32 | UK00AK | 2024-09-18T12:04:04.506Z | 2024-09-19T12:18:48.265Z |
5112897 | 5112897 | 20240915000407_OizCB | UK00AK | 2024-09-18T12:03:45.403Z | 2024-09-19T12:18:45.519Z |
5112718 | 5112718 | 20240914234456_Vc7bV | UK00AK | 2024-09-18T12:03:24.556Z | 2024-09-19T12:18:43.589Z |
5111908 | 5111908 | 20240914213717_nhOJV | UK00AK | 2024-09-18T12:02:30.317Z | 2024-09-19T12:18:35.152Z |
5111520 | 5111520 | 20240914204419_WMvFS | UK00AK | 2024-09-18T12:02:00.479Z | 2024-09-19T12:18:30.998Z |
5111326 | 5111326 | 20240914202231_dMjnJ | UK00AK | 2024-09-18T12:01:49.290Z | 2024-09-19T12:18:29.071Z |
5111079 | 5111079 | 20240914195040_I3a2V | UK00AK | 2024-09-18T12:01:27.171Z | 2024-09-19T12:18:25.834Z |
5108221 | 5108221 | 20240913043231_V9W8g | UK00AK | 2024-09-17T12:13:32.803Z | 2024-09-19T12:20:47.923Z |
5108074 | 5108074 | 20240913042227_zWWmq | UK00AK | 2024-09-17T12:13:30.150Z | 2024-09-19T12:20:47.834Z |
5108056 | 5108056 | 20240913042113_BuZZr | UK00AK | 2024-09-17T12:13:29.900Z | 2024-09-19T12:20:47.825Z |
5105356 | 5105356 | 20240913024217_lH8wJ | UK00AK | 2024-09-17T12:12:10.508Z | 2024-09-19T12:20:44.309Z |
5105223 | 5105223 | 20240913023759_rrs1U | UK00AK | 2024-09-17T12:12:02.849Z | 2024-09-19T12:20:44.137Z |
5104837 | 5104837 | 20240913022150_GxWTn | UK00AK | 2024-09-17T12:11:45.238Z | 2024-09-19T12:20:42.920Z |
5104795 | 5104795 | 20240913022125_loj0D | UK00AK | 2024-09-17T12:11:44.865Z | 2024-09-19T12:20:42.895Z |
5104787 | 5104787 | 20240913022109_NoJDj | UK00AK | 2024-09-17T12:11:44.558Z | 2024-09-19T12:20:42.881Z |
5104719 | 5104719 | 20240913021943_xZbN3 | UK00AK | 2024-09-17T12:11:43.535Z | 2024-09-19T12:20:42.809Z |
5104501 | 5104501 | 20240913021222_idy9t | UK00AK | 2024-09-17T12:11:37.380Z | 2024-09-19T12:20:41.557Z |
5104115 | 5104115 | 20240913015313_KPWBy | UK00AK | 2024-09-17T12:11:25.694Z | 2024-09-19T12:20:41.034Z |
5104031 | 5104031 | 20240913014932_cVIkz | UK00AK | 2024-09-17T12:11:23.053Z | 2024-09-19T12:20:40.902Z |
5103910 | 5103910 | 20240913014324_nuV16 | UK00AK | 2024-09-17T12:11:16.224Z | 2024-09-19T12:20:40.661Z |
5103780 | 5103780 | 20240913013937_raz6Z | UK00AK | 2024-09-17T12:11:10.341Z | 2024-09-19T12:20:40.457Z |
5103586 | 5103586 | 20240913013310_rYaEc | UK00AK | 2024-09-17T12:11:04.592Z | 2024-09-19T12:20:40.300Z |
5103571 | 5103571 | 20240913013227_p597S | UK00AK | 2024-09-17T12:11:03.782Z | 2024-09-19T12:20:40.293Z |
5103185 | 5103185 | 20240914020350_qfFdZ | UK00AK | 2024-09-17T12:07:55.802Z | 2024-09-19T12:19:56.781Z |
5103027 | 5103027 | 20240914015801_GD2W7 | UK00AK | 2024-09-17T12:07:47.899Z | 2024-09-19T12:19:56.441Z |
5102975 | 5102975 | 20240914015551_ZQths | UK00AK | 2024-09-17T12:07:45.569Z | 2024-09-19T12:19:56.228Z |
5102902 | 5102902 | 20240914015229_kmyL9 | UK00AK | 2024-09-17T12:07:42.639Z | 2024-09-19T12:19:56.083Z |
5102570 | 5102570 | 20240914013205_aVAkd | UK00AK | 2024-09-17T12:07:25.778Z | 2024-09-19T12:19:55.145Z |
5102481 | 5102481 | 20240914012813_hohph | UK00AK | 2024-09-17T12:07:15.353Z | 2024-09-19T12:19:54.552Z |
5102446 | 5102446 | 20240914012602_pu82B | UK00AK | 2024-09-17T12:07:12.058Z | 2024-09-19T12:19:54.440Z |
5102414 | 5102414 | 20240914012438_IN3sP | UK00AK | 2024-09-17T12:07:07.707Z | 2024-09-19T12:19:54.077Z |
5102407 | 5102407 | 20240914012355_rrY0Z | UK00AK | 2024-09-17T12:07:07.330Z | 2024-09-19T12:19:54.057Z |
5102382 | 5102382 | 20240914012318_R4SVA | UK00AK | 2024-09-17T12:07:05.965Z | 2024-09-19T12:19:53.915Z |
5102259 | 5102259 | 20240914011313_P9wSX | UK00AK | 2024-09-17T12:06:56.085Z | 2024-09-19T12:19:53.106Z |
5101931 | 5101931 | 20240914005527_NzMrf | UK00AK | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101876 | 5101876 | 20240914005341_vYEKH | UK00AK | 2024-09-17T12:06:19.860Z | 2024-09-19T12:19:51.783Z |
5101749 | 5101749 | 20240914004422_UBJy3 | UK00AK | 2024-09-17T12:06:10.744Z | 2024-09-19T12:19:51.351Z |
5101679 | 5101679 | 20240914004312_iA2V9 | UK00AK | 2024-09-17T12:06:08.521Z | 2024-09-19T12:19:51.233Z |
5101599 | 5101599 | 20240914003843_7qJwV | UK00AK | 2024-09-17T12:06:04.435Z | 2024-09-19T12:19:51.082Z |
5101411 | 5101411 | 20240914002426_FjZvl | UK00AK | 2024-09-17T12:05:43.651Z | 2024-09-19T12:19:50.441Z |
5101282 | 5101282 | 20240914001728_IQ32l | UK00AK | 2024-09-17T12:05:31.454Z | 2024-09-19T12:19:50.144Z |
5101145 | 5101145 | 20240914000640_Hg5A7 | UK00AK | 2024-09-17T12:05:21.705Z | 2024-09-19T12:19:49.851Z |
5101125 | 5101125 | 20240914000512_hOC8P | UK00AK | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.822Z |
5101067 | 5101067 | 20240914000009_rWKv7 | UK00AK | 2024-09-17T12:05:17.601Z | 2024-09-19T12:19:49.638Z |
5101057 | 5101057 | 20240913235911_soX3X | UK00AK | 2024-09-17T12:05:16.797Z | 2024-09-19T12:19:49.591Z |
5101040 | 5101040 | 20240913235809_o16hC | UK00AK | 2024-09-17T12:05:15.549Z | 2024-09-19T12:19:49.536Z |
5101013 | 5101013 | 20240913235545_Br5Rp | UK00AK | 2024-09-17T12:05:13.523Z | 2024-09-19T12:19:49.478Z |
5100853 | 5100853 | 20240913234651_234U3 | UK00AK | 2024-09-17T12:05:00.254Z | 2024-09-19T12:19:48.821Z |
5100828 | 5100828 | 20240913234635_px7iK | UK00AK | 2024-09-17T12:04:58.035Z | 2024-09-19T12:19:48.798Z |
5100683 | 5100683 | 20240913234140_ATMyu | UK00AK | 2024-09-17T12:04:48.901Z | 2024-09-19T12:19:48.527Z |
5100556 | 5100556 | 20240913233050_q1lzK | UK00AK | 2024-09-17T12:04:38.672Z | 2024-09-19T12:19:48.123Z |
5100518 | 5100518 | 20240913232920_EB8La | UK00AK | 2024-09-17T12:04:37.620Z | 2024-09-19T12:19:48.089Z |
5100303 | 5100303 | 20240913231833_GQkLQ | UK00AK | 2024-09-17T12:04:26.520Z | 2024-09-19T12:19:47.732Z |
5100194 | 5100194 | 20240913230241_iHWuY | UK00AK | 2024-09-17T12:04:10.049Z | 2024-09-19T12:19:47.182Z |
5100171 | 5100171 | 20240913225901_JMOgI | UK00AK | 2024-09-17T12:04:05.388Z | 2024-09-19T12:19:47.061Z |
5100143 | 5100143 | 20240913225602_9cGtt | UK00AK | 2024-09-17T12:04:01.720Z | 2024-09-19T12:19:46.982Z |
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);