participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,283 rows where station_code = "UK004D" 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 |
---|---|---|---|---|---|
5135660 | 5135660 | 20240914032803_Z9V0y | UK004D | 2024-09-19T12:20:00.601Z | 2024-09-19T12:20:00.601Z |
5132036 | 5132036 | 20240915225218_b8X6y | UK004D | 2024-09-19T12:15:44.768Z | 2024-09-19T12:15:44.768Z |
5128841 | 5128841 | 20240917024630_D3PSk | UK004D | 2024-09-19T12:11:03.604Z | 2024-09-19T12:11:03.604Z |
5128499 | 5128499 | 20240917015222_IBDPu | UK004D | 2024-09-19T12:10:39.312Z | 2024-09-19T12:10:39.312Z |
5128458 | 5128458 | 20240917014556_EpX3t | UK004D | 2024-09-19T12:10:36.539Z | 2024-09-19T12:10:36.539Z |
5128376 | 5128376 | 20240917013230_Aq7D3 | UK004D | 2024-09-19T12:10:29.740Z | 2024-09-19T12:10:29.740Z |
5128358 | 5128358 | 20240917013113_7lp2l | UK004D | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128335 | 5128335 | 20240917012738_7wLoW | UK004D | 2024-09-19T12:10:27.439Z | 2024-09-19T12:10:27.439Z |
5128295 | 5128295 | 20240917012201_PHVbY | UK004D | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128283 | 5128283 | 20240917012138_w2DDR | UK004D | 2024-09-19T12:10:24.995Z | 2024-09-19T12:10:24.995Z |
5128229 | 5128229 | 20240917010822_61oNf | UK004D | 2024-09-19T12:10:21.192Z | 2024-09-19T12:10:21.192Z |
5128185 | 5128185 | 20240917010457_029vC | UK004D | 2024-09-19T12:10:19.784Z | 2024-09-19T12:10:19.784Z |
5128165 | 5128165 | 20240917005832_K7SCG | UK004D | 2024-09-19T12:10:14.883Z | 2024-09-19T12:10:14.883Z |
5127999 | 5127999 | 20240917001919_iSM1L | UK004D | 2024-09-19T12:09:53.630Z | 2024-09-19T12:09:53.630Z |
5127804 | 5127804 | 20240916233717_9IYIS | UK004D | 2024-09-19T12:09:40.301Z | 2024-09-19T12:09:40.301Z |
5127780 | 5127780 | 20240916232731_VaeRR | UK004D | 2024-09-19T12:09:37.933Z | 2024-09-19T12:09:37.933Z |
5127750 | 5127750 | 20240916232251_Caf3r | UK004D | 2024-09-19T12:09:36.129Z | 2024-09-19T12:09:36.129Z |
5127584 | 5127584 | 20240916223019_rW72I | UK004D | 2024-09-19T12:09:24.602Z | 2024-09-19T12:09:24.602Z |
5127438 | 5127438 | 20240916215228_fyYNu | UK004D | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5127324 | 5127324 | 20240916212352_NFCZz | UK004D | 2024-09-19T12:08:51.564Z | 2024-09-19T12:08:51.564Z |
5127297 | 5127297 | 20240916211807_In4Lp | UK004D | 2024-09-19T12:08:48.607Z | 2024-09-19T12:08:48.607Z |
5127234 | 5127234 | 20240916210049_LI3n9 | UK004D | 2024-09-19T12:08:36.188Z | 2024-09-19T12:08:36.188Z |
5127131 | 5127131 | 20240916203043_QBYvG | UK004D | 2024-09-19T12:08:16.791Z | 2024-09-19T12:08:16.791Z |
5126960 | 5126960 | 20240916200134_DfSMC | UK004D | 2024-09-19T12:07:48.716Z | 2024-09-19T12:07:48.716Z |
5126856 | 5126856 | 20240916194132_mW4qH | UK004D | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5121812 | 5121812 | 20240914041445_8V42i | UK004D | 2024-09-18T12:11:01.619Z | 2024-09-19T12:20:02.386Z |
5121624 | 5121624 | 20240914041042_HtKAC | UK004D | 2024-09-18T12:10:58.922Z | 2024-09-19T12:20:02.186Z |
5121576 | 5121576 | 20240914040945_CnoCw | UK004D | 2024-09-18T12:10:58.485Z | 2024-09-19T12:20:02.139Z |
5121562 | 5121562 | 20240914040945_CarjX | UK004D | 2024-09-18T12:10:58.428Z | 2024-09-19T12:20:02.137Z |
5121112 | 5121112 | 20240914035228_sJvYo | UK004D | 2024-09-18T12:10:51.280Z | 2024-09-19T12:20:01.367Z |
5120929 | 5120929 | 20240914034205_Gq0aN | UK004D | 2024-09-18T12:10:48.813Z | 2024-09-19T12:20:01.076Z |
5120887 | 5120887 | 20240914034036_Sks8h | UK004D | 2024-09-18T12:10:48.453Z | 2024-09-19T12:20:00.998Z |
5120694 | 5120694 | 20240914033219_xnzxE | UK004D | 2024-09-18T12:10:45.976Z | 2024-09-19T12:20:00.770Z |
5120645 | 5120645 | 20240914033037_YKJCw | UK004D | 2024-09-18T12:10:44.189Z | 2024-09-19T12:20:00.671Z |
5120595 | 5120595 | 20240914032938_hNX3n | UK004D | 2024-09-18T12:10:43.600Z | 2024-09-19T12:20:00.627Z |
5119931 | 5119931 | 20240914025404_Vh24d | UK004D | 2024-09-18T12:10:29.736Z | 2024-09-19T12:19:59.180Z |
5119903 | 5119903 | 20240914025217_o03Gv | UK004D | 2024-09-18T12:10:28.792Z | 2024-09-19T12:19:59.102Z |
5119847 | 5119847 | 20240914025107_tYCQn | UK004D | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119804 | 5119804 | 20240914025012_cKCvm | UK004D | 2024-09-18T12:10:27.213Z | 2024-09-19T12:19:58.959Z |
5119793 | 5119793 | 20240914025011_1QKB8 | UK004D | 2024-09-18T12:10:27.160Z | 2024-09-19T12:19:58.956Z |
5119509 | 5119509 | 20240914023649_c77Dl | UK004D | 2024-09-18T12:10:21.809Z | 2024-09-19T12:19:58.397Z |
5119118 | 5119118 | 20240914021212_g33OE | UK004D | 2024-09-18T12:10:16.408Z | 2024-09-19T12:19:57.196Z |
5116865 | 5116865 | 20240915034443_G1tt1 | UK004D | 2024-09-18T12:07:23.700Z | 2024-09-19T12:19:12.484Z |
5116617 | 5116617 | 20240915033346_gv04B | UK004D | 2024-09-18T12:07:12.505Z | 2024-09-19T12:19:11.695Z |
5116610 | 5116610 | 20240915033336_THTa7 | UK004D | 2024-09-18T12:07:12.321Z | 2024-09-19T12:19:11.682Z |
5116487 | 5116487 | 20240915032947_I4vie | UK004D | 2024-09-18T12:07:06.721Z | 2024-09-19T12:19:11.340Z |
5116436 | 5116436 | 20240915032628_CyRlB | UK004D | 2024-09-18T12:07:02.612Z | 2024-09-19T12:19:11.165Z |
5116363 | 5116363 | 20240915032348_51WgL | UK004D | 2024-09-18T12:07:00.127Z | 2024-09-19T12:19:10.742Z |
5116322 | 5116322 | 20240915032139_auUX1 | UK004D | 2024-09-18T12:06:57.244Z | 2024-09-19T12:19:10.364Z |
5115922 | 5115922 | 20240915025921_Xj6EX | UK004D | 2024-09-18T12:06:31.911Z | 2024-09-19T12:19:07.870Z |
5115610 | 5115610 | 20240915024619_MFu3K | UK004D | 2024-09-18T12:06:19.199Z | 2024-09-19T12:19:05.812Z |
5115540 | 5115540 | 20240915024428_CUS2m | UK004D | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5115299 | 5115299 | 20240915023127_M3S08 | UK004D | 2024-09-18T12:06:10.387Z | 2024-09-19T12:19:03.788Z |
5115234 | 5115234 | 20240915022834_oclyd | UK004D | 2024-09-18T12:06:07.451Z | 2024-09-19T12:19:03.184Z |
5114919 | 5114919 | 20240915020738_X45uT | UK004D | 2024-09-18T12:05:42.432Z | 2024-09-19T12:19:00.562Z |
5114884 | 5114884 | 20240915020421_aZAfD | UK004D | 2024-09-18T12:05:39.394Z | 2024-09-19T12:19:00.456Z |
5114814 | 5114814 | 20240915020025_2J9Ay | UK004D | 2024-09-18T12:05:35.841Z | 2024-09-19T12:19:00.092Z |
5114784 | 5114784 | 20240915015819_c3g4l | UK004D | 2024-09-18T12:05:34.475Z | 2024-09-19T12:18:59.906Z |
5114596 | 5114596 | 20240915015216_erlcH | UK004D | 2024-09-18T12:05:24.331Z | 2024-09-19T12:18:59.071Z |
5114540 | 5114540 | 20240915014713_41uEl | UK004D | 2024-09-18T12:05:21.327Z | 2024-09-19T12:18:58.811Z |
5114419 | 5114419 | 20240915014110_JrNif | UK004D | 2024-09-18T12:05:14.433Z | 2024-09-19T12:18:57.943Z |
5114303 | 5114303 | 20240915013545_Wv4zf | UK004D | 2024-09-18T12:05:09.792Z | 2024-09-19T12:18:57.460Z |
5114147 | 5114147 | 20240915012945_XOYjJ | UK004D | 2024-09-18T12:05:04.252Z | 2024-09-19T12:18:56.435Z |
5113834 | 5113834 | 20240915011531_WRWYs | UK004D | 2024-09-18T12:04:52.448Z | 2024-09-19T12:18:53.284Z |
5113681 | 5113681 | 20240915010509_grEkf | UK004D | 2024-09-18T12:04:39.659Z | 2024-09-19T12:18:51.253Z |
5113592 | 5113592 | 20240915010038_yynXa | UK004D | 2024-09-18T12:04:34.570Z | 2024-09-19T12:18:50.527Z |
5113417 | 5113417 | 20240915004805_b42ud | UK004D | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5113342 | 5113342 | 20240915003918_W4xS4 | UK004D | 2024-09-18T12:04:09.556Z | 2024-09-19T12:18:48.580Z |
5113093 | 5113093 | 20240915002224_ZeX8b | UK004D | 2024-09-18T12:03:56.282Z | 2024-09-19T12:18:46.993Z |
5112446 | 5112446 | 20240914231511_iXbq7 | UK004D | 2024-09-18T12:03:06.815Z | 2024-09-19T12:18:41.036Z |
5112373 | 5112373 | 20240914230622_sluI3 | UK004D | 2024-09-18T12:03:01.687Z | 2024-09-19T12:18:40.750Z |
5111980 | 5111980 | 20240914214910_80rid | UK004D | 2024-09-18T12:02:34.800Z | 2024-09-19T12:18:35.985Z |
5111891 | 5111891 | 20240914213134_Iov9u | UK004D | 2024-09-18T12:02:28.898Z | 2024-09-19T12:18:34.928Z |
5111694 | 5111694 | 20240914210049_wBjPi | UK004D | 2024-09-18T12:02:11.197Z | 2024-09-19T12:18:33.328Z |
5111563 | 5111563 | 20240914204925_jNPIh | UK004D | 2024-09-18T12:02:03.714Z | 2024-09-19T12:18:31.430Z |
5111487 | 5111487 | 20240914204238_hSIkr | UK004D | 2024-09-18T12:01:59.530Z | 2024-09-19T12:18:30.823Z |
5111365 | 5111365 | 20240914202837_OlHm7 | UK004D | 2024-09-18T12:01:52.739Z | 2024-09-19T12:18:29.612Z |
5111233 | 5111233 | 20240914201314_Fgem2 | UK004D | 2024-09-18T12:01:44.635Z | 2024-09-19T12:18:27.914Z |
5111216 | 5111216 | 20240914201129_yVy1M | UK004D | 2024-09-18T12:01:43.746Z | 2024-09-19T12:18:27.622Z |
5111186 | 5111186 | 20240914201007_8Xvja | UK004D | 2024-09-18T12:01:42.468Z | 2024-09-19T12:18:27.298Z |
5111173 | 5111173 | 20240914200837_zjWMY | UK004D | 2024-09-18T12:01:41.650Z | 2024-09-19T12:18:27.193Z |
5111101 | 5111101 | 20240914195655_5LGop | UK004D | 2024-09-18T12:01:32.484Z | 2024-09-19T12:18:26.578Z |
5110976 | 5110976 | 20240914193728_DJtmL | UK004D | 2024-09-18T12:01:17.348Z | 2024-09-19T12:18:25.203Z |
5110450 | 5110450 | 20240911010346_TXvjR | UK004D | 2024-09-17T12:17:57.870Z | 2024-09-19T12:21:39.378Z |
5110438 | 5110438 | 20240911002255_xn4qn | UK004D | 2024-09-17T12:17:56.485Z | 2024-09-19T12:21:38.193Z |
5107829 | 5107829 | 20240913041158_IXYqC | UK004D | 2024-09-17T12:13:24.420Z | 2024-09-19T12:20:47.584Z |
5107800 | 5107800 | 20240913041100_Q8u26 | UK004D | 2024-09-17T12:13:23.960Z | 2024-09-19T12:20:47.560Z |
5107706 | 5107706 | 20240913040843_C1k02 | UK004D | 2024-09-17T12:13:22.109Z | 2024-09-19T12:20:47.477Z |
5107541 | 5107541 | 20240913035854_mqhvd | UK004D | 2024-09-17T12:13:16.758Z | 2024-09-19T12:20:47.214Z |
5107439 | 5107439 | 20240913035735_Ydtcg | UK004D | 2024-09-17T12:13:15.622Z | 2024-09-19T12:20:47.156Z |
5107256 | 5107256 | 20240913034944_bhuPa | UK004D | 2024-09-17T12:13:11.937Z | 2024-09-19T12:20:46.967Z |
5107045 | 5107045 | 20240913034223_r2lZE | UK004D | 2024-09-17T12:13:08.371Z | 2024-09-19T12:20:46.793Z |
5106930 | 5106930 | 20240913033909_P0dHA | UK004D | 2024-09-17T12:13:04.334Z | 2024-09-19T12:20:46.587Z |
5106873 | 5106873 | 20240913033731_OnzFn | UK004D | 2024-09-17T12:13:03.430Z | 2024-09-19T12:20:46.502Z |
5106854 | 5106854 | 20240913033726_7td3P | UK004D | 2024-09-17T12:13:03.267Z | 2024-09-19T12:20:46.495Z |
5106637 | 5106637 | 20240913033129_1gPB2 | UK004D | 2024-09-17T12:12:58.663Z | 2024-09-19T12:20:46.219Z |
5106212 | 5106212 | 20240913031545_H3ROi | UK004D | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5106113 | 5106113 | 20240913031146_n7YuO | UK004D | 2024-09-17T12:12:42.511Z | 2024-09-19T12:20:45.502Z |
5105478 | 5105478 | 20240913024739_u4u5T | UK004D | 2024-09-17T12:12:18.599Z | 2024-09-19T12:20:44.595Z |
5105374 | 5105374 | 20240913024244_fTyVj | UK004D | 2024-09-17T12:12:12.140Z | 2024-09-19T12:20:44.384Z |
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);