participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,123 rows where station_code = "UK008J" 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 |
---|---|---|---|---|---|
5129748 | 5129748 | 20240917042512_YPcGy | UK008J | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129724 | 5129724 | 20240917042446_4c0yQ | UK008J | 2024-09-19T12:12:02.431Z | 2024-09-19T12:12:02.431Z |
5129103 | 5129103 | 20240917032028_UjnSk | UK008J | 2024-09-19T12:11:15.591Z | 2024-09-19T12:11:15.591Z |
5128846 | 5128846 | 20240917024630_D3PSk | UK008J | 2024-09-19T12:11:03.605Z | 2024-09-19T12:11:03.605Z |
5128821 | 5128821 | 20240917024456_2qPrg | UK008J | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128758 | 5128758 | 20240917023136_SKu3T | UK008J | 2024-09-19T12:10:59.997Z | 2024-09-19T12:10:59.997Z |
5128590 | 5128590 | 20240917020759_7vm3g | UK008J | 2024-09-19T12:10:46.472Z | 2024-09-19T12:10:46.472Z |
5128513 | 5128513 | 20240917015304_yIYF4 | UK008J | 2024-09-19T12:10:40.227Z | 2024-09-19T12:10:40.227Z |
5128440 | 5128440 | 20240917014244_XuzZ7 | UK008J | 2024-09-19T12:10:34.656Z | 2024-09-19T12:10:34.656Z |
5128365 | 5128365 | 20240917013113_7lp2l | UK008J | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128300 | 5128300 | 20240917012201_PHVbY | UK008J | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128250 | 5128250 | 20240917010944_y4nji | UK008J | 2024-09-19T12:10:21.932Z | 2024-09-19T12:10:21.932Z |
5128232 | 5128232 | 20240917010822_61oNf | UK008J | 2024-09-19T12:10:21.192Z | 2024-09-19T12:10:21.192Z |
5128192 | 5128192 | 20240917010457_029vC | UK008J | 2024-09-19T12:10:19.785Z | 2024-09-19T12:10:19.785Z |
5127912 | 5127912 | 20240917000505_sC3Ql | UK008J | 2024-09-19T12:09:46.714Z | 2024-09-19T12:09:46.714Z |
5127685 | 5127685 | 20240916225232_XdM57 | UK008J | 2024-09-19T12:09:31.439Z | 2024-09-19T12:09:31.439Z |
5127502 | 5127502 | 20240916221249_AmGNp | UK008J | 2024-09-19T12:09:15.777Z | 2024-09-19T12:09:15.777Z |
5125633 | 5125633 | 20240918031242_lFFev | UK008J | 2024-09-19T12:03:46.420Z | 2024-09-19T12:06:42.061Z |
5125464 | 5125464 | 20240918024027_x3XCZ | UK008J | 2024-09-19T12:03:18.448Z | 2024-09-19T12:06:42.037Z |
5125340 | 5125340 | 20240918021338_MzHj5 | UK008J | 2024-09-19T12:02:59.546Z | 2024-09-19T12:06:42.016Z |
5125235 | 5125235 | 20240918012721_LhazK | UK008J | 2024-09-19T12:02:33.580Z | 2024-09-19T12:06:41.996Z |
5125216 | 5125216 | 20240918011535_xwnAg | UK008J | 2024-09-19T12:02:31.210Z | 2024-09-19T12:06:41.993Z |
5125171 | 5125171 | 20240918005116_Skt9y | UK008J | 2024-09-19T12:02:26.608Z | 2024-09-19T12:06:41.986Z |
5125124 | 5125124 | 20240918002232_8WU0i | UK008J | 2024-09-19T12:02:21.505Z | 2024-09-19T12:06:41.979Z |
5125111 | 5125111 | 20240918001712_ZD7Qx | UK008J | 2024-09-19T12:02:20.596Z | 2024-09-19T12:06:41.978Z |
5125062 | 5125062 | 20240917235147_XTPoM | UK008J | 2024-09-19T12:02:05.071Z | 2024-09-19T12:06:41.970Z |
5124972 | 5124972 | 20240917231412_pYDgY | UK008J | 2024-09-19T12:01:53.475Z | 2024-09-19T12:06:41.958Z |
5124927 | 5124927 | 20240917225248_MAb5G | UK008J | 2024-09-19T12:01:48.892Z | 2024-09-19T12:06:41.953Z |
5124858 | 5124858 | 20240917222213_yHrjk | UK008J | 2024-09-19T12:01:41.214Z | 2024-09-19T12:06:41.943Z |
5124785 | 5124785 | 20240917220112_DZ7h4 | UK008J | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124760 | 5124760 | 20240917215748_Yi0FR | UK008J | 2024-09-19T12:01:32.616Z | 2024-09-19T12:06:41.932Z |
5124734 | 5124734 | 20240917215625_mMP25 | UK008J | 2024-09-19T12:01:27.849Z | 2024-09-19T12:06:41.929Z |
5124697 | 5124697 | 20240917214747_xWK7N | UK008J | 2024-09-19T12:01:20.145Z | 2024-09-19T12:06:41.925Z |
5124551 | 5124551 | 20240917210241_copaC | UK008J | 2024-09-19T12:01:07.254Z | 2024-09-19T12:06:41.909Z |
5124371 | 5124371 | 20240917194406_YeB2s | UK008J | 2024-09-19T12:00:40.906Z | 2024-09-19T12:06:41.884Z |
5121733 | 5121733 | 20240914041320_c1Do2 | UK008J | 2024-09-18T12:11:01.155Z | 2024-09-19T12:20:02.320Z |
5121706 | 5121706 | 20240914041223_Y2S4F | UK008J | 2024-09-18T12:10:59.820Z | 2024-09-19T12:20:02.264Z |
5121632 | 5121632 | 20240914041042_HtKAC | UK008J | 2024-09-18T12:10:58.923Z | 2024-09-19T12:20:02.186Z |
5121541 | 5121541 | 20240914040819_3SGHu | UK008J | 2024-09-18T12:10:58.119Z | 2024-09-19T12:20:02.086Z |
5120121 | 5120121 | 20240914030045_kaNSo | UK008J | 2024-09-18T12:10:32.247Z | 2024-09-19T12:19:59.457Z |
5119853 | 5119853 | 20240914025107_tYCQn | UK008J | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119798 | 5119798 | 20240914025011_1QKB8 | UK008J | 2024-09-18T12:10:27.160Z | 2024-09-19T12:19:58.956Z |
5119682 | 5119682 | 20240914024404_FwclT | UK008J | 2024-09-18T12:10:24.054Z | 2024-09-19T12:19:58.732Z |
5119515 | 5119515 | 20240914023649_p2M5o | UK008J | 2024-09-18T12:10:21.866Z | 2024-09-19T12:19:58.428Z |
5119502 | 5119502 | 20240914023634_WcZAw | UK008J | 2024-09-18T12:10:21.785Z | 2024-09-19T12:19:58.392Z |
5115542 | 5115542 | 20240915024428_CUS2m | UK008J | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5114788 | 5114788 | 20240915015819_c3g4l | UK008J | 2024-09-18T12:05:34.476Z | 2024-09-19T12:18:59.906Z |
5114765 | 5114765 | 20240915015743_9K7A3 | UK008J | 2024-09-18T12:05:33.744Z | 2024-09-19T12:18:59.867Z |
5114473 | 5114473 | 20240915014409_HzMIi | UK008J | 2024-09-18T12:05:19.344Z | 2024-09-19T12:18:58.465Z |
5114169 | 5114169 | 20240915013005_Ep2rP | UK008J | 2024-09-18T12:05:05.080Z | 2024-09-19T12:18:56.578Z |
5113973 | 5113973 | 20240915012116_1VSgb | UK008J | 2024-09-18T12:04:56.776Z | 2024-09-19T12:18:54.884Z |
5113496 | 5113496 | 20240915005320_mrhzA | UK008J | 2024-09-18T12:04:24.896Z | 2024-09-19T12:18:49.754Z |
5113478 | 5113478 | 20240915005215_qlXTD | UK008J | 2024-09-18T12:04:22.737Z | 2024-09-19T12:18:49.587Z |
5113426 | 5113426 | 20240915004805_b42ud | UK008J | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5113333 | 5113333 | 20240915003831_bsYr4 | UK008J | 2024-09-18T12:04:09.202Z | 2024-09-19T12:18:48.542Z |
5113140 | 5113140 | 20240915002437_TaEq6 | UK008J | 2024-09-18T12:03:58.261Z | 2024-09-19T12:18:47.421Z |
5112574 | 5112574 | 20240914233020_Bsvf4 | UK008J | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5107982 | 5107982 | 20240913041805_2A8dr | UK008J | 2024-09-17T12:13:26.713Z | 2024-09-19T12:20:47.707Z |
5107944 | 5107944 | 20240913041517_xTvtL | UK008J | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.639Z |
5107805 | 5107805 | 20240913041100_Q8u26 | UK008J | 2024-09-17T12:13:23.960Z | 2024-09-19T12:20:47.560Z |
5107511 | 5107511 | 20240913035831_fqGqQ | UK008J | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107443 | 5107443 | 20240913035735_Ydtcg | UK008J | 2024-09-17T12:13:15.622Z | 2024-09-19T12:20:47.156Z |
5107142 | 5107142 | 20240913034535_Nfjnq | UK008J | 2024-09-17T12:13:09.977Z | 2024-09-19T12:20:46.862Z |
5107051 | 5107051 | 20240913034223_r2lZE | UK008J | 2024-09-17T12:13:08.371Z | 2024-09-19T12:20:46.793Z |
5107031 | 5107031 | 20240913034216_uUJpJ | UK008J | 2024-09-17T12:13:08.238Z | 2024-09-19T12:20:46.785Z |
5106877 | 5106877 | 20240913033731_OnzFn | UK008J | 2024-09-17T12:13:03.430Z | 2024-09-19T12:20:46.502Z |
5106709 | 5106709 | 20240913033244_xNwMk | UK008J | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5106220 | 5106220 | 20240913031545_H3ROi | UK008J | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5105440 | 5105440 | 20240913024615_M9Fb2 | UK008J | 2024-09-17T12:12:16.946Z | 2024-09-19T12:20:44.547Z |
5105335 | 5105335 | 20240913024200_xuBve | UK008J | 2024-09-17T12:12:10.041Z | 2024-09-19T12:20:44.295Z |
5104819 | 5104819 | 20240913022148_1xM2P | UK008J | 2024-09-17T12:11:45.170Z | 2024-09-19T12:20:42.918Z |
5104465 | 5104465 | 20240913021031_fWqnC | UK008J | 2024-09-17T12:11:35.878Z | 2024-09-19T12:20:41.501Z |
5104360 | 5104360 | 20240913020602_8rNYg | UK008J | 2024-09-17T12:11:33.884Z | 2024-09-19T12:20:41.425Z |
5103963 | 5103963 | 20240913014540_yI5mU | UK008J | 2024-09-17T12:11:20.429Z | 2024-09-19T12:20:40.687Z |
5103764 | 5103764 | 20240913013928_yELQC | UK008J | 2024-09-17T12:11:10.032Z | 2024-09-19T12:20:40.456Z |
5103696 | 5103696 | 20240913013553_ejHYY | UK008J | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5103132 | 5103132 | 20240914020248_2qOqR | UK008J | 2024-09-17T12:07:53.250Z | 2024-09-19T12:19:56.674Z |
5103053 | 5103053 | 20240914015933_bjV97 | UK008J | 2024-09-17T12:07:49.212Z | 2024-09-19T12:19:56.472Z |
5101295 | 5101295 | 20240914001747_2NwtR | UK008J | 2024-09-17T12:05:32.463Z | 2024-09-19T12:19:50.212Z |
5101240 | 5101240 | 20240914001528_ZXffw | UK008J | 2024-09-17T12:05:29.036Z | 2024-09-19T12:19:50.090Z |
5101213 | 5101213 | 20240914001349_Agbl2 | UK008J | 2024-09-17T12:05:26.830Z | 2024-09-19T12:19:50.061Z |
5101193 | 5101193 | 20240914001230_N9Vcg | UK008J | 2024-09-17T12:05:25.663Z | 2024-09-19T12:19:50.020Z |
5100954 | 5100954 | 20240913235449_v0Fcf | UK008J | 2024-09-17T12:05:11.924Z | 2024-09-19T12:19:49.372Z |
5100132 | 5100132 | 20240913225456_v02wd | UK008J | 2024-09-17T12:04:00.857Z | 2024-09-19T12:19:46.966Z |
5100082 | 5100082 | 20240913224804_Kp6wh | UK008J | 2024-09-17T12:03:56.424Z | 2024-09-19T12:19:46.841Z |
5098926 | 5098926 | 20240913195806_juC8O | UK008J | 2024-09-17T12:02:01.026Z | 2024-09-19T12:19:42.687Z |
5098271 | 5098271 | 20240913012337_vixWd | UK008J | 2024-09-16T12:17:22.125Z | 2024-09-19T12:20:39.985Z |
5098230 | 5098230 | 20240913012243_5cvdD | UK008J | 2024-09-16T12:17:21.772Z | 2024-09-19T12:20:39.908Z |
5097932 | 5097932 | 20240913010955_pmOEy | UK008J | 2024-09-16T12:17:16.923Z | 2024-09-19T12:20:39.200Z |
5097895 | 5097895 | 20240913010822_qc0wi | UK008J | 2024-09-16T12:17:16.398Z | 2024-09-19T12:20:39.168Z |
5097720 | 5097720 | 20240913005821_fCMMH | UK008J | 2024-09-16T12:17:14.225Z | 2024-09-19T12:20:38.916Z |
5097696 | 5097696 | 20240913005803_2vgkq | UK008J | 2024-09-16T12:17:14.086Z | 2024-09-19T12:20:38.905Z |
5097661 | 5097661 | 20240913005751_S5ImR | UK008J | 2024-09-16T12:17:13.916Z | 2024-09-19T12:20:38.877Z |
5097284 | 5097284 | 20240913003832_Ye3ds | UK008J | 2024-09-16T12:17:09.388Z | 2024-09-19T12:20:38.026Z |
5097250 | 5097250 | 20240913003830_3xJ2D | UK008J | 2024-09-16T12:17:09.371Z | 2024-09-19T12:20:38.022Z |
5094206 | 5094206 | 20240912035304_nxhkd | UK008J | 2024-09-16T12:14:39.215Z | 2024-09-19T12:21:16.020Z |
5094021 | 5094021 | 20240912034429_eTpJ6 | UK008J | 2024-09-16T12:14:30.884Z | 2024-09-19T12:21:15.820Z |
5093893 | 5093893 | 20240912034021_Z334R | UK008J | 2024-09-16T12:14:27.026Z | 2024-09-19T12:21:15.707Z |
5093279 | 5093279 | 20240912031633_TgYaj | UK008J | 2024-09-16T12:14:14.246Z | 2024-09-19T12:21:15.083Z |
5093075 | 5093075 | 20240912031040_pKDvH | UK008J | 2024-09-16T12:14:11.296Z | 2024-09-19T12:21:14.927Z |
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);