participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,004 rows where station_code = "UK00A4" 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 |
---|---|---|---|---|---|
5131464 | 5131464 | 20240915195905_Fx0rq | UK00A4 | 2024-09-19T12:15:04.867Z | 2024-09-19T12:15:04.867Z |
5129729 | 5129729 | 20240917042446_4c0yQ | UK00A4 | 2024-09-19T12:12:02.431Z | 2024-09-19T12:12:02.431Z |
5129624 | 5129624 | 20240917041401_gYrnO | UK00A4 | 2024-09-19T12:11:54.268Z | 2024-09-19T12:11:54.268Z |
5129383 | 5129383 | 20240917035455_GRAvj | UK00A4 | 2024-09-19T12:11:34.191Z | 2024-09-19T12:11:34.191Z |
5129248 | 5129248 | 20240917033929_mjEu9 | UK00A4 | 2024-09-19T12:11:24.081Z | 2024-09-19T12:11:24.081Z |
5129192 | 5129192 | 20240917033545_hH0PQ | UK00A4 | 2024-09-19T12:11:22.818Z | 2024-09-19T12:11:22.818Z |
5129146 | 5129146 | 20240917032626_2sNQT | UK00A4 | 2024-09-19T12:11:17.324Z | 2024-09-19T12:11:17.324Z |
5129002 | 5129002 | 20240917030656_QCvd2 | UK00A4 | 2024-09-19T12:11:11.184Z | 2024-09-19T12:11:11.184Z |
5127935 | 5127935 | 20240917000518_ymau4 | UK00A4 | 2024-09-19T12:09:47.057Z | 2024-09-19T12:09:47.057Z |
5127777 | 5127777 | 20240916232654_JYTWN | UK00A4 | 2024-09-19T12:09:37.668Z | 2024-09-19T12:09:37.668Z |
5127613 | 5127613 | 20240916223556_JAi7W | UK00A4 | 2024-09-19T12:09:26.054Z | 2024-09-19T12:09:26.054Z |
5127546 | 5127546 | 20240916222203_0x3Sy | UK00A4 | 2024-09-19T12:09:20.526Z | 2024-09-19T12:09:20.526Z |
5127470 | 5127470 | 20240916215942_ajU55 | UK00A4 | 2024-09-19T12:09:12.270Z | 2024-09-19T12:09:12.270Z |
5127464 | 5127464 | 20240916215806_SdF3p | UK00A4 | 2024-09-19T12:09:11.154Z | 2024-09-19T12:09:11.154Z |
5127417 | 5127417 | 20240916214620_NCFqq | UK00A4 | 2024-09-19T12:09:05.126Z | 2024-09-19T12:09:05.126Z |
5127401 | 5127401 | 20240916214417_ZEOKa | UK00A4 | 2024-09-19T12:09:02.980Z | 2024-09-19T12:09:02.980Z |
5127360 | 5127360 | 20240916213514_Z43AA | UK00A4 | 2024-09-19T12:08:58.807Z | 2024-09-19T12:08:58.807Z |
5127044 | 5127044 | 20240916201358_bg3qD | UK00A4 | 2024-09-19T12:07:56.083Z | 2024-09-19T12:07:56.083Z |
5126905 | 5126905 | 20240916194848_vd6lL | UK00A4 | 2024-09-19T12:07:37.803Z | 2024-09-19T12:07:37.803Z |
5126862 | 5126862 | 20240916194132_mW4qH | UK00A4 | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5126842 | 5126842 | 20240916194111_2ToJM | UK00A4 | 2024-09-19T12:07:25.431Z | 2024-09-19T12:07:25.431Z |
5121535 | 5121535 | 20240914040812_UuGYS | UK00A4 | 2024-09-18T12:10:58.031Z | 2024-09-19T12:20:02.085Z |
5121483 | 5121483 | 20240914040446_Ed2AU | UK00A4 | 2024-09-18T12:10:57.122Z | 2024-09-19T12:20:01.957Z |
5121463 | 5121463 | 20240914040346_2033Q | UK00A4 | 2024-09-18T12:10:56.757Z | 2024-09-19T12:20:01.880Z |
5121307 | 5121307 | 20240914035805_aEwVT | UK00A4 | 2024-09-18T12:10:54.131Z | 2024-09-19T12:20:01.619Z |
5120937 | 5120937 | 20240914034205_Gq0aN | UK00A4 | 2024-09-18T12:10:48.814Z | 2024-09-19T12:20:01.076Z |
5120793 | 5120793 | 20240914033528_eFpzL | UK00A4 | 2024-09-18T12:10:46.694Z | 2024-09-19T12:20:00.858Z |
5120734 | 5120734 | 20240914033304_2dWFf | UK00A4 | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120161 | 5120161 | 20240914030300_Dv3Ux | UK00A4 | 2024-09-18T12:10:33.149Z | 2024-09-19T12:19:59.505Z |
5120028 | 5120028 | 20240914025731_FrGwA | UK00A4 | 2024-09-18T12:10:31.113Z | 2024-09-19T12:19:59.305Z |
5119753 | 5119753 | 20240914024800_g2wv1 | UK00A4 | 2024-09-18T12:10:25.652Z | 2024-09-19T12:19:58.875Z |
5119713 | 5119713 | 20240914024413_3Swqf | UK00A4 | 2024-09-18T12:10:24.382Z | 2024-09-19T12:19:58.781Z |
5119563 | 5119563 | 20240914023920_ytJ2I | UK00A4 | 2024-09-18T12:10:22.337Z | 2024-09-19T12:19:58.537Z |
5119530 | 5119530 | 20240914023818_PpSda | UK00A4 | 2024-09-18T12:10:22.095Z | 2024-09-19T12:19:58.467Z |
5119381 | 5119381 | 20240914022955_aPR5h | UK00A4 | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.099Z |
5119151 | 5119151 | 20240914021347_8OpnT | UK00A4 | 2024-09-18T12:10:16.762Z | 2024-09-19T12:19:57.242Z |
5119135 | 5119135 | 20240914021227_p9Q83 | UK00A4 | 2024-09-18T12:10:16.493Z | 2024-09-19T12:19:57.218Z |
5117309 | 5117309 | 20240915041720_ffZA5 | UK00A4 | 2024-09-18T12:07:37.503Z | 2024-09-19T12:19:14.228Z |
5116976 | 5116976 | 20240915035227_DJXqH | UK00A4 | 2024-09-18T12:07:26.999Z | 2024-09-19T12:19:12.881Z |
5116836 | 5116836 | 20240915034413_IWUco | UK00A4 | 2024-09-18T12:07:22.497Z | 2024-09-19T12:19:12.456Z |
5116765 | 5116765 | 20240915034018_8sSmw | UK00A4 | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116581 | 5116581 | 20240915033225_MK2tZ | UK00A4 | 2024-09-18T12:07:10.682Z | 2024-09-19T12:19:11.568Z |
5116520 | 5116520 | 20240915033030_5Zu31 | UK00A4 | 2024-09-18T12:07:08.342Z | 2024-09-19T12:19:11.432Z |
5116169 | 5116169 | 20240915031254_FwXDE | UK00A4 | 2024-09-18T12:06:45.632Z | 2024-09-19T12:19:09.097Z |
5116132 | 5116132 | 20240915031015_glnIT | UK00A4 | 2024-09-18T12:06:42.036Z | 2024-09-19T12:19:08.799Z |
5116045 | 5116045 | 20240915030422_BjdsF | UK00A4 | 2024-09-18T12:06:35.056Z | 2024-09-19T12:19:08.235Z |
5116015 | 5116015 | 20240915030349_gXZnN | UK00A4 | 2024-09-18T12:06:34.351Z | 2024-09-19T12:19:08.198Z |
5115780 | 5115780 | 20240915025326_CVwGf | UK00A4 | 2024-09-18T12:06:23.758Z | 2024-09-19T12:19:07.328Z |
5115745 | 5115745 | 20240915025118_ZVC3C | UK00A4 | 2024-09-18T12:06:22.630Z | 2024-09-19T12:19:06.714Z |
5115674 | 5115674 | 20240915024901_VW6yq | UK00A4 | 2024-09-18T12:06:21.014Z | 2024-09-19T12:19:06.373Z |
5115139 | 5115139 | 20240915022149_vJkX6 | UK00A4 | 2024-09-18T12:06:02.791Z | 2024-09-19T12:19:02.495Z |
5114914 | 5114914 | 20240915020738_kkDeq | UK00A4 | 2024-09-18T12:05:42.106Z | 2024-09-19T12:19:00.558Z |
5114897 | 5114897 | 20240915020640_d37AY | UK00A4 | 2024-09-18T12:05:40.363Z | 2024-09-19T12:19:00.503Z |
5114753 | 5114753 | 20240915015725_ZneBD | UK00A4 | 2024-09-18T12:05:33.097Z | 2024-09-19T12:18:59.796Z |
5114633 | 5114633 | 20240915015225_PAl02 | UK00A4 | 2024-09-18T12:05:25.859Z | 2024-09-19T12:18:59.082Z |
5114438 | 5114438 | 20240915014207_RUeb3 | UK00A4 | 2024-09-18T12:05:16.718Z | 2024-09-19T12:18:58.176Z |
5114388 | 5114388 | 20240915014044_iD3CJ | UK00A4 | 2024-09-18T12:05:14.128Z | 2024-09-19T12:18:57.925Z |
5114097 | 5114097 | 20240915012638_dss2q | UK00A4 | 2024-09-18T12:05:01.790Z | 2024-09-19T12:18:55.915Z |
5113935 | 5113935 | 20240915012025_uhUMW | UK00A4 | 2024-09-18T12:04:55.862Z | 2024-09-19T12:18:54.474Z |
5113857 | 5113857 | 20240915011547_TCzq1 | UK00A4 | 2024-09-18T12:04:53.119Z | 2024-09-19T12:18:53.403Z |
5113447 | 5113447 | 20240915004949_mcy3v | UK00A4 | 2024-09-18T12:04:17.704Z | 2024-09-19T12:18:49.142Z |
5113217 | 5113217 | 20240915003210_PtWdE | UK00A4 | 2024-09-18T12:04:03.183Z | 2024-09-19T12:18:48.003Z |
5113063 | 5113063 | 20240915001744_aeo2B | UK00A4 | 2024-09-18T12:03:53.863Z | 2024-09-19T12:18:46.795Z |
5112816 | 5112816 | 20240914235734_Buy07 | UK00A4 | 2024-09-18T12:03:39.562Z | 2024-09-19T12:18:45.033Z |
5112734 | 5112734 | 20240914234642_5yMMA | UK00A4 | 2024-09-18T12:03:25.778Z | 2024-09-19T12:18:43.749Z |
5112726 | 5112726 | 20240914234539_WRlla | UK00A4 | 2024-09-18T12:03:25.453Z | 2024-09-19T12:18:43.736Z |
5112654 | 5112654 | 20240914233857_oFHQB | UK00A4 | 2024-09-18T12:03:19.363Z | 2024-09-19T12:18:42.650Z |
5112605 | 5112605 | 20240914233243_yjvoL | UK00A4 | 2024-09-18T12:03:16.308Z | 2024-09-19T12:18:41.614Z |
5112476 | 5112476 | 20240914231854_40L2a | UK00A4 | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.112Z |
5112440 | 5112440 | 20240914231447_tdCWJ | UK00A4 | 2024-09-18T12:03:06.394Z | 2024-09-19T12:18:41.023Z |
5112427 | 5112427 | 20240914230944_ybmw3 | UK00A4 | 2024-09-18T12:03:03.963Z | 2024-09-19T12:18:40.947Z |
5112342 | 5112342 | 20240914230112_vUTa1 | UK00A4 | 2024-09-18T12:03:00.504Z | 2024-09-19T12:18:40.621Z |
5112146 | 5112146 | 20240914222537_yN6EK | UK00A4 | 2024-09-18T12:02:49.873Z | 2024-09-19T12:18:38.649Z |
5112100 | 5112100 | 20240914221423_sct88 | UK00A4 | 2024-09-18T12:02:47.713Z | 2024-09-19T12:18:38.285Z |
5111994 | 5111994 | 20240914215035_R3HCY | UK00A4 | 2024-09-18T12:02:36.119Z | 2024-09-19T12:18:36.262Z |
5111950 | 5111950 | 20240914214554_0Ehjz | UK00A4 | 2024-09-18T12:02:31.944Z | 2024-09-19T12:18:35.473Z |
5111913 | 5111913 | 20240914213755_kAAwm | UK00A4 | 2024-09-18T12:02:30.579Z | 2024-09-19T12:18:35.197Z |
5111868 | 5111868 | 20240914212804_u1UDt | UK00A4 | 2024-09-18T12:02:26.455Z | 2024-09-19T12:18:34.791Z |
5111595 | 5111595 | 20240914205233_M3WKP | UK00A4 | 2024-09-18T12:02:05.206Z | 2024-09-19T12:18:31.575Z |
5111584 | 5111584 | 20240914205051_F6LRZ | UK00A4 | 2024-09-18T12:02:04.393Z | 2024-09-19T12:18:31.498Z |
5111545 | 5111545 | 20240914204532_v8oV2 | UK00A4 | 2024-09-18T12:02:01.991Z | 2024-09-19T12:18:31.166Z |
5111131 | 5111131 | 20240914200340_bGQCV | UK00A4 | 2024-09-18T12:01:38.051Z | 2024-09-19T12:18:26.908Z |
5111098 | 5111098 | 20240914195529_AQxfA | UK00A4 | 2024-09-18T12:01:32.256Z | 2024-09-19T12:18:26.562Z |
5111052 | 5111052 | 20240914194621_Ywshl | UK00A4 | 2024-09-18T12:01:23.304Z | 2024-09-19T12:18:25.576Z |
5110943 | 5110943 | 20240914193007_bLy1e | UK00A4 | 2024-09-18T12:01:13.370Z | 2024-09-19T12:18:24.881Z |
5110927 | 5110927 | 20240914192850_63oxz | UK00A4 | 2024-09-18T12:01:12.829Z | 2024-09-19T12:18:24.875Z |
5108122 | 5108122 | 20240913042358_AZAj2 | UK00A4 | 2024-09-17T12:13:30.683Z | 2024-09-19T12:20:47.851Z |
5108112 | 5108112 | 20240913042358_TeKGC | UK00A4 | 2024-09-17T12:13:30.612Z | 2024-09-19T12:20:47.850Z |
5107968 | 5107968 | 20240913041547_Xi4hO | UK00A4 | 2024-09-17T12:13:26.285Z | 2024-09-19T12:20:47.651Z |
5107672 | 5107672 | 20240913040748_x4tvX | UK00A4 | 2024-09-17T12:13:20.791Z | 2024-09-19T12:20:47.447Z |
5107640 | 5107640 | 20240913040638_G4KXf | UK00A4 | 2024-09-17T12:13:20.340Z | 2024-09-19T12:20:47.394Z |
5107327 | 5107327 | 20240913035244_r9TG4 | UK00A4 | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107289 | 5107289 | 20240913035130_kt4f0 | UK00A4 | 2024-09-17T12:13:12.670Z | 2024-09-19T12:20:46.986Z |
5107167 | 5107167 | 20240913034540_HdeRC | UK00A4 | 2024-09-17T12:13:10.141Z | 2024-09-19T12:20:46.870Z |
5107116 | 5107116 | 20240913034502_w3gxO | UK00A4 | 2024-09-17T12:13:09.360Z | 2024-09-19T12:20:46.842Z |
5106768 | 5106768 | 20240913033355_jgXwb | UK00A4 | 2024-09-17T12:13:00.753Z | 2024-09-19T12:20:46.382Z |
5106458 | 5106458 | 20240913032453_dmndV | UK00A4 | 2024-09-17T12:12:54.558Z | 2024-09-19T12:20:46.087Z |
5106248 | 5106248 | 20240913031554_OvOOU | UK00A4 | 2024-09-17T12:12:45.347Z | 2024-09-19T12:20:45.682Z |
5106225 | 5106225 | 20240913031545_H3ROi | UK00A4 | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5106133 | 5106133 | 20240913031225_NtuIQ | UK00A4 | 2024-09-17T12:12:42.738Z | 2024-09-19T12:20:45.508Z |
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);