participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,611 rows where station_code = "UK008C" 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 |
---|---|---|---|---|---|
5129216 | 5129216 | 20240917033757_CJFTp | UK008C | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5128427 | 5128427 | 20240917014141_IQuYX | UK008C | 2024-09-19T12:10:34.431Z | 2024-09-19T12:10:34.431Z |
5125290 | 5125290 | 20240918015533_RUnYx | UK008C | 2024-09-19T12:02:41.603Z | 2024-09-19T12:06:42.006Z |
5121925 | 5121925 | 20240914042121_Ge34S | UK008C | 2024-09-18T12:11:03.077Z | 2024-09-19T12:20:02.520Z |
5121767 | 5121767 | 20240914041341_L2d8X | UK008C | 2024-09-18T12:11:01.176Z | 2024-09-19T12:20:02.365Z |
5121452 | 5121452 | 20240914040308_pK5Wv | UK008C | 2024-09-18T12:10:55.611Z | 2024-09-19T12:20:01.861Z |
5121093 | 5121093 | 20240914035202_2dLMe | UK008C | 2024-09-18T12:10:51.028Z | 2024-09-19T12:20:01.335Z |
5120871 | 5120871 | 20240914033901_qIFy3 | UK008C | 2024-09-18T12:10:48.259Z | 2024-09-19T12:20:00.980Z |
5120714 | 5120714 | 20240914033250_Y9G7v | UK008C | 2024-09-18T12:10:46.113Z | 2024-09-19T12:20:00.783Z |
5120503 | 5120503 | 20240914032537_dIVPC | UK008C | 2024-09-18T12:10:42.215Z | 2024-09-19T12:20:00.505Z |
5120219 | 5120219 | 20240914030729_KLCN2 | UK008C | 2024-09-18T12:10:35.255Z | 2024-09-19T12:19:59.706Z |
5119819 | 5119819 | 20240914025024_nQ2K2 | UK008C | 2024-09-18T12:10:27.809Z | 2024-09-19T12:19:58.985Z |
5119416 | 5119416 | 20240914023143_BcW4W | UK008C | 2024-09-18T12:10:20.841Z | 2024-09-19T12:19:58.123Z |
5116199 | 5116199 | 20240915031533_FTAl9 | UK008C | 2024-09-18T12:06:47.485Z | 2024-09-19T12:19:09.619Z |
5115893 | 5115893 | 20240915025812_Re3Hl | UK008C | 2024-09-18T12:06:31.252Z | 2024-09-19T12:19:07.791Z |
5115805 | 5115805 | 20240915025401_fOiNa | UK008C | 2024-09-18T12:06:24.114Z | 2024-09-19T12:19:07.364Z |
5115034 | 5115034 | 20240915021449_91apG | UK008C | 2024-09-18T12:05:51.494Z | 2024-09-19T12:19:01.184Z |
5114982 | 5114982 | 20240915021258_ipX7u | UK008C | 2024-09-18T12:05:49.262Z | 2024-09-19T12:19:01.037Z |
5114937 | 5114937 | 20240915020846_3fWnc | UK008C | 2024-09-18T12:05:44.198Z | 2024-09-19T12:19:00.662Z |
5114733 | 5114733 | 20240915015715_XXfVt | UK008C | 2024-09-18T12:05:32.268Z | 2024-09-19T12:18:59.675Z |
5113952 | 5113952 | 20240915012055_C0WRs | UK008C | 2024-09-18T12:04:56.236Z | 2024-09-19T12:18:54.703Z |
5113886 | 5113886 | 20240915011748_2SEr3 | UK008C | 2024-09-18T12:04:54.527Z | 2024-09-19T12:18:54.028Z |
5113229 | 5113229 | 20240915003234_5wPlB | UK008C | 2024-09-18T12:04:03.884Z | 2024-09-19T12:18:48.067Z |
5113137 | 5113137 | 20240915002418_dezUN | UK008C | 2024-09-18T12:03:58.029Z | 2024-09-19T12:18:47.402Z |
5113051 | 5113051 | 20240915001652_9jq0w | UK008C | 2024-09-18T12:03:52.940Z | 2024-09-19T12:18:46.691Z |
5112835 | 5112835 | 20240914235929_Bsfpi | UK008C | 2024-09-18T12:03:41.582Z | 2024-09-19T12:18:45.232Z |
5112325 | 5112325 | 20240914225832_7CnAn | UK008C | 2024-09-18T12:03:00.229Z | 2024-09-19T12:18:40.547Z |
5112046 | 5112046 | 20240914220221_PARso | UK008C | 2024-09-18T12:02:43.674Z | 2024-09-19T12:18:37.236Z |
5111854 | 5111854 | 20240914212409_KHtgx | UK008C | 2024-09-18T12:02:22.628Z | 2024-09-19T12:18:34.652Z |
5111166 | 5111166 | 20240914200831_cF5f0 | UK008C | 2024-09-18T12:01:41.377Z | 2024-09-19T12:18:27.189Z |
5107239 | 5107239 | 20240913034830_a3p9O | UK008C | 2024-09-17T12:13:11.458Z | 2024-09-19T12:20:46.945Z |
5107135 | 5107135 | 20240913034530_ffEBN | UK008C | 2024-09-17T12:13:09.801Z | 2024-09-19T12:20:46.857Z |
5106123 | 5106123 | 20240913031210_yCMrS | UK008C | 2024-09-17T12:12:42.615Z | 2024-09-19T12:20:45.506Z |
5105128 | 5105128 | 20240913023157_iEiTZ | UK008C | 2024-09-17T12:11:57.298Z | 2024-09-19T12:20:43.741Z |
5104424 | 5104424 | 20240913020751_1LqQv | UK008C | 2024-09-17T12:11:35.075Z | 2024-09-19T12:20:41.463Z |
5103904 | 5103904 | 20240913014324_nuV16 | UK008C | 2024-09-17T12:11:16.224Z | 2024-09-19T12:20:40.661Z |
5103564 | 5103564 | 20240913013227_p597S | UK008C | 2024-09-17T12:11:03.782Z | 2024-09-19T12:20:40.293Z |
5102476 | 5102476 | 20240914012813_hohph | UK008C | 2024-09-17T12:07:15.352Z | 2024-09-19T12:19:54.552Z |
5102401 | 5102401 | 20240914012355_rrY0Z | UK008C | 2024-09-17T12:07:07.330Z | 2024-09-19T12:19:54.057Z |
5102347 | 5102347 | 20240914012127_KELkQ | UK008C | 2024-09-17T12:07:03.940Z | 2024-09-19T12:19:53.859Z |
5102286 | 5102286 | 20240914011559_2eLth | UK008C | 2024-09-17T12:06:58.359Z | 2024-09-19T12:19:53.268Z |
5102001 | 5102001 | 20240914005907_3Ajdi | UK008C | 2024-09-17T12:06:38.358Z | 2024-09-19T12:19:52.147Z |
5101764 | 5101764 | 20240914004542_o2Ax4 | UK008C | 2024-09-17T12:06:11.843Z | 2024-09-19T12:19:51.461Z |
5101642 | 5101642 | 20240914004009_32PID | UK008C | 2024-09-17T12:06:06.311Z | 2024-09-19T12:19:51.173Z |
5101276 | 5101276 | 20240914001728_IQ32l | UK008C | 2024-09-17T12:05:31.454Z | 2024-09-19T12:19:50.144Z |
5101138 | 5101138 | 20240914000640_Hg5A7 | UK008C | 2024-09-17T12:05:21.705Z | 2024-09-19T12:19:49.851Z |
5101036 | 5101036 | 20240913235809_o16hC | UK008C | 2024-09-17T12:05:15.549Z | 2024-09-19T12:19:49.536Z |
5101006 | 5101006 | 20240913235545_Br5Rp | UK008C | 2024-09-17T12:05:13.523Z | 2024-09-19T12:19:49.478Z |
5100792 | 5100792 | 20240913234550_cwVoK | UK008C | 2024-09-17T12:04:56.025Z | 2024-09-19T12:19:48.733Z |
5098141 | 5098141 | 20240913011958_Vm6uK | UK008C | 2024-09-16T12:17:20.635Z | 2024-09-19T12:20:39.705Z |
5098050 | 5098050 | 20240913011507_x5b5l | UK008C | 2024-09-16T12:17:19.207Z | 2024-09-19T12:20:39.585Z |
5094874 | 5094874 | 20240912042812_IbpI6 | UK008C | 2024-09-16T12:15:00.199Z | 2024-09-19T12:21:16.471Z |
5094816 | 5094816 | 20240912042504_aJsKv | UK008C | 2024-09-16T12:14:58.918Z | 2024-09-19T12:21:16.441Z |
5094785 | 5094785 | 20240912042311_R4At9 | UK008C | 2024-09-16T12:14:58.563Z | 2024-09-19T12:21:16.431Z |
5094475 | 5094475 | 20240912040441_dijCV | UK008C | 2024-09-16T12:14:47.611Z | 2024-09-19T12:21:16.139Z |
5094003 | 5094003 | 20240912034410_5Q93I | UK008C | 2024-09-16T12:14:30.663Z | 2024-09-19T12:21:15.817Z |
5093930 | 5093930 | 20240912034131_PrKaW | UK008C | 2024-09-16T12:14:27.881Z | 2024-09-19T12:21:15.745Z |
5093291 | 5093291 | 20240912031719_aUVbU | UK008C | 2024-09-16T12:14:14.735Z | 2024-09-19T12:21:15.210Z |
5092802 | 5092802 | 20240912025816_SjZHQ | UK008C | 2024-09-16T12:14:04.570Z | 2024-09-19T12:21:14.586Z |
5092235 | 5092235 | 20240912024024_jvogN | UK008C | 2024-09-16T12:13:44.356Z | 2024-09-19T12:21:13.716Z |
5092163 | 5092163 | 20240912023913_i9Fxd | UK008C | 2024-09-16T12:13:42.899Z | 2024-09-19T12:21:13.679Z |
5091888 | 5091888 | 20240912022638_SMWvI | UK008C | 2024-09-16T12:13:29.381Z | 2024-09-19T12:21:13.454Z |
5091774 | 5091774 | 20240912022229_c9COT | UK008C | 2024-09-16T12:13:23.262Z | 2024-09-19T12:21:13.396Z |
5091416 | 5091416 | 20240912020815_wBVU4 | UK008C | 2024-09-16T12:13:05.375Z | 2024-09-19T12:21:13.000Z |
5090649 | 5090649 | 20240912013551_X6yoD | UK008C | 2024-09-16T12:12:27.512Z | 2024-09-19T12:21:11.533Z |
5090420 | 5090420 | 20240912012420_piDcf | UK008C | 2024-09-16T12:12:19.036Z | 2024-09-19T12:21:11.305Z |
5089748 | 5089748 | 20240912005549_Pbns7 | UK008C | 2024-09-16T12:11:40.091Z | 2024-09-19T12:21:10.443Z |
5089638 | 5089638 | 20240912005204_9pMze | UK008C | 2024-09-16T12:11:33.223Z | 2024-09-19T12:21:10.111Z |
5089549 | 5089549 | 20240912004843_yVoO3 | UK008C | 2024-09-16T12:11:28.892Z | 2024-09-19T12:21:10.038Z |
5088849 | 5088849 | 20240913002935_33NUH | UK008C | 2024-09-16T12:08:33.258Z | 2024-09-19T12:20:37.349Z |
5086512 | 5086512 | 20240912223931_s9toN | UK008C | 2024-09-16T12:05:50.520Z | 2024-09-19T12:20:31.340Z |
5086440 | 5086440 | 20240912223328_Nx2h9 | UK008C | 2024-09-16T12:05:45.229Z | 2024-09-19T12:20:31.255Z |
5086069 | 5086069 | 20240912220621_9beDJ | UK008C | 2024-09-16T12:05:11.671Z | 2024-09-19T12:20:30.095Z |
5085679 | 5085679 | 20240912214305_F4UzS | UK008C | 2024-09-16T12:04:38.814Z | 2024-09-19T12:20:29.434Z |
5085233 | 5085233 | 20240912210117_OyFyO | UK008C | 2024-09-16T12:03:46.189Z | 2024-09-19T12:20:28.260Z |
5079855 | 5079855 | 20240911031601_LpKgU | UK008C | 2024-09-15T12:16:39.010Z | 2024-09-19T12:21:42.701Z |
5077092 | 5077092 | 20240911002338_Pg3IV | UK008C | 2024-09-15T12:14:23.264Z | 2024-09-19T12:21:38.207Z |
5076929 | 5076929 | 20240911001417_ZoB0N | UK008C | 2024-09-15T12:14:10.977Z | 2024-09-19T12:21:37.781Z |
5076670 | 5076670 | 20240910235808_UAtiC | UK008C | 2024-09-15T12:13:53.513Z | 2024-09-19T12:21:37.450Z |
5076525 | 5076525 | 20240910234337_DSmKQ | UK008C | 2024-09-15T12:13:41.481Z | 2024-09-19T12:21:37.326Z |
5076439 | 5076439 | 20240910233629_1McXd | UK008C | 2024-09-15T12:13:34.498Z | 2024-09-19T12:21:37.212Z |
5075821 | 5075821 | 20240912000912_mXhlP | UK008C | 2024-09-15T12:10:16.341Z | 2024-09-19T12:21:09.575Z |
5075652 | 5075652 | 20240911235924_dG7ej | UK008C | 2024-09-15T12:10:06.768Z | 2024-09-19T12:21:09.397Z |
5075542 | 5075542 | 20240911235426_ec2hg | UK008C | 2024-09-15T12:10:00.455Z | 2024-09-19T12:21:09.282Z |
5075243 | 5075243 | 20240911233715_Qtkow | UK008C | 2024-09-15T12:09:32.924Z | 2024-09-19T12:21:09.031Z |
5075187 | 5075187 | 20240911233551_B0EhF | UK008C | 2024-09-15T12:09:30.425Z | 2024-09-19T12:21:08.848Z |
5074408 | 5074408 | 20240911223757_gfmDD | UK008C | 2024-09-15T12:08:31.284Z | 2024-09-19T12:21:07.244Z |
5074030 | 5074030 | 20240911220835_d4NIX | UK008C | 2024-09-15T12:07:51.983Z | 2024-09-19T12:21:06.860Z |
5073616 | 5073616 | 20240911213240_52UEN | UK008C | 2024-09-15T12:07:22.877Z | 2024-09-19T12:21:06.043Z |
5073342 | 5073342 | 20240911211455_QpQHr | UK008C | 2024-09-15T12:07:04.286Z | 2024-09-19T12:21:05.675Z |
5072217 | 5072217 | 20240911194909_CIerE | UK008C | 2024-09-15T12:04:55.676Z | 2024-09-19T12:21:03.701Z |
5072164 | 5072164 | 20240911194238_6Hj2u | UK008C | 2024-09-15T12:04:46.834Z | 2024-09-19T12:21:03.596Z |
5072106 | 5072106 | 20240911193437_n4Kye | UK008C | 2024-09-15T12:04:40.216Z | 2024-09-19T12:21:03.525Z |
5070344 | 5070344 | 20240910225139_xdbHM | UK008C | 2024-09-14T12:20:19.506Z | 2024-09-19T12:21:36.011Z |
5070305 | 5070305 | 20240910225021_LMV36 | UK008C | 2024-09-14T12:20:18.666Z | 2024-09-19T12:21:35.991Z |
5065316 | 5065316 | 20240910034127_3HygN | UK008C | 2024-09-14T12:16:57.750Z | 2024-09-18T12:15:19.036Z |
5065214 | 5065214 | 20240910032107_h1atg | UK008C | 2024-09-14T12:16:42.416Z | 2024-09-18T12:15:18.749Z |
5065124 | 5065124 | 20240910031000_6weCN | UK008C | 2024-09-14T12:16:27.193Z | 2024-09-18T12:15:18.445Z |
5065052 | 5065052 | 20240910025904_18iK8 | UK008C | 2024-09-14T12:16:20.042Z | 2024-09-18T12:15:18.250Z |
5064721 | 5064721 | 20240910015025_rAU0F | UK008C | 2024-09-14T12:15:57.737Z | 2024-09-18T12:15:17.071Z |
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);