participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,333 rows where station_code = "UK00B0" 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 |
---|---|---|---|---|---|
5129756 | 5129756 | 20240917042512_YPcGy | UK00B0 | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129360 | 5129360 | 20240917035147_2hg6T | UK00B0 | 2024-09-19T12:11:32.359Z | 2024-09-19T12:11:32.359Z |
5129028 | 5129028 | 20240917030907_ZYVJx | UK00B0 | 2024-09-19T12:11:11.875Z | 2024-09-19T12:11:11.875Z |
5128826 | 5128826 | 20240917024456_2qPrg | UK00B0 | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128773 | 5128773 | 20240917023446_0sTAC | UK00B0 | 2024-09-19T12:11:00.860Z | 2024-09-19T12:11:00.860Z |
5128520 | 5128520 | 20240917015304_yIYF4 | UK00B0 | 2024-09-19T12:10:40.227Z | 2024-09-19T12:10:40.227Z |
5128422 | 5128422 | 20240917014109_8t1tx | UK00B0 | 2024-09-19T12:10:33.760Z | 2024-09-19T12:10:33.760Z |
5128370 | 5128370 | 20240917013113_7lp2l | UK00B0 | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128305 | 5128305 | 20240917012201_PHVbY | UK00B0 | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128256 | 5128256 | 20240917010944_y4nji | UK00B0 | 2024-09-19T12:10:21.933Z | 2024-09-19T12:10:21.933Z |
5128198 | 5128198 | 20240917010457_029vC | UK00B0 | 2024-09-19T12:10:19.785Z | 2024-09-19T12:10:19.785Z |
5127979 | 5127979 | 20240917001543_z3xIM | UK00B0 | 2024-09-19T12:09:51.875Z | 2024-09-19T12:09:51.875Z |
5127918 | 5127918 | 20240917000505_sC3Ql | UK00B0 | 2024-09-19T12:09:46.715Z | 2024-09-19T12:09:46.715Z |
5127736 | 5127736 | 20240916231523_C4vek | UK00B0 | 2024-09-19T12:09:34.971Z | 2024-09-19T12:09:34.971Z |
5127691 | 5127691 | 20240916225232_XdM57 | UK00B0 | 2024-09-19T12:09:31.439Z | 2024-09-19T12:09:31.439Z |
5127640 | 5127640 | 20240916223824_kxTy6 | UK00B0 | 2024-09-19T12:09:27.862Z | 2024-09-19T12:09:27.862Z |
5127594 | 5127594 | 20240916223019_rW72I | UK00B0 | 2024-09-19T12:09:24.602Z | 2024-09-19T12:09:24.602Z |
5127571 | 5127571 | 20240916223002_KjcOd | UK00B0 | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127532 | 5127532 | 20240916221624_TycVy | UK00B0 | 2024-09-19T12:09:17.666Z | 2024-09-19T12:09:17.666Z |
5127508 | 5127508 | 20240916221249_AmGNp | UK00B0 | 2024-09-19T12:09:15.777Z | 2024-09-19T12:09:15.777Z |
5127454 | 5127454 | 20240916215228_fyYNu | UK00B0 | 2024-09-19T12:09:07.598Z | 2024-09-19T12:09:07.598Z |
5127351 | 5127351 | 20240916213453_e0EcN | UK00B0 | 2024-09-19T12:08:56.494Z | 2024-09-19T12:08:56.494Z |
5127321 | 5127321 | 20240916212227_uLOLN | UK00B0 | 2024-09-19T12:08:50.881Z | 2024-09-19T12:08:50.881Z |
5127085 | 5127085 | 20240916202246_g6ZuL | UK00B0 | 2024-09-19T12:08:08.613Z | 2024-09-19T12:08:08.613Z |
5127065 | 5127065 | 20240916201912_XNx2r | UK00B0 | 2024-09-19T12:07:59.966Z | 2024-09-19T12:07:59.966Z |
5126867 | 5126867 | 20240916194132_mW4qH | UK00B0 | 2024-09-19T12:07:28.727Z | 2024-09-19T12:07:28.727Z |
5125866 | 5125866 | 20240918041447_lL2bT | UK00B0 | 2024-09-19T12:04:21.876Z | 2024-09-19T12:06:42.097Z |
5125852 | 5125852 | 20240918041140_n0Kz9 | UK00B0 | 2024-09-19T12:04:18.279Z | 2024-09-19T12:06:42.096Z |
5125219 | 5125219 | 20240918011535_xwnAg | UK00B0 | 2024-09-19T12:02:31.210Z | 2024-09-19T12:06:41.993Z |
5125205 | 5125205 | 20240918011045_7mqz2 | UK00B0 | 2024-09-19T12:02:30.086Z | 2024-09-19T12:06:41.991Z |
5125115 | 5125115 | 20240918001712_ZD7Qx | UK00B0 | 2024-09-19T12:02:20.596Z | 2024-09-19T12:06:41.978Z |
5124984 | 5124984 | 20240917231620_u9bFZ | UK00B0 | 2024-09-19T12:01:54.553Z | 2024-09-19T12:06:41.959Z |
5124976 | 5124976 | 20240917231412_pYDgY | UK00B0 | 2024-09-19T12:01:53.475Z | 2024-09-19T12:06:41.958Z |
5124932 | 5124932 | 20240917225248_MAb5G | UK00B0 | 2024-09-19T12:01:48.892Z | 2024-09-19T12:06:41.953Z |
5124863 | 5124863 | 20240917222213_yHrjk | UK00B0 | 2024-09-19T12:01:41.214Z | 2024-09-19T12:06:41.943Z |
5124790 | 5124790 | 20240917220112_DZ7h4 | UK00B0 | 2024-09-19T12:01:35.012Z | 2024-09-19T12:06:41.935Z |
5124636 | 5124636 | 20240917213921_D2aqM | UK00B0 | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124556 | 5124556 | 20240917210241_copaC | UK00B0 | 2024-09-19T12:01:07.254Z | 2024-09-19T12:06:41.909Z |
5124378 | 5124378 | 20240917194406_YeB2s | UK00B0 | 2024-09-19T12:00:40.914Z | 2024-09-19T12:06:41.884Z |
5122154 | 5122154 | 20240914043912_O2Sf6 | UK00B0 | 2024-09-18T12:11:07.668Z | 2024-09-19T12:20:02.876Z |
5122139 | 5122139 | 20240914043824_gRWOa | UK00B0 | 2024-09-18T12:11:07.613Z | 2024-09-19T12:20:02.863Z |
5121969 | 5121969 | 20240914042254_2opSb | UK00B0 | 2024-09-18T12:11:03.474Z | 2024-09-19T12:20:02.535Z |
5121821 | 5121821 | 20240914041445_8V42i | UK00B0 | 2024-09-18T12:11:01.619Z | 2024-09-19T12:20:02.386Z |
5121740 | 5121740 | 20240914041320_c1Do2 | UK00B0 | 2024-09-18T12:11:01.155Z | 2024-09-19T12:20:02.320Z |
5121709 | 5121709 | 20240914041223_Y2S4F | UK00B0 | 2024-09-18T12:10:59.821Z | 2024-09-19T12:20:02.264Z |
5121640 | 5121640 | 20240914041042_HtKAC | UK00B0 | 2024-09-18T12:10:58.923Z | 2024-09-19T12:20:02.186Z |
5120941 | 5120941 | 20240914034205_Gq0aN | UK00B0 | 2024-09-18T12:10:48.814Z | 2024-09-19T12:20:01.076Z |
5120897 | 5120897 | 20240914034036_Sks8h | UK00B0 | 2024-09-18T12:10:48.453Z | 2024-09-19T12:20:00.998Z |
5120704 | 5120704 | 20240914033219_xnzxE | UK00B0 | 2024-09-18T12:10:45.976Z | 2024-09-19T12:20:00.770Z |
5120633 | 5120633 | 20240914033018_Ulnqj | UK00B0 | 2024-09-18T12:10:43.874Z | 2024-09-19T12:20:00.633Z |
5120598 | 5120598 | 20240914032938_hNX3n | UK00B0 | 2024-09-18T12:10:43.600Z | 2024-09-19T12:20:00.627Z |
5120440 | 5120440 | 20240914032021_0w0mb | UK00B0 | 2024-09-18T12:10:39.801Z | 2024-09-19T12:20:00.207Z |
5120397 | 5120397 | 20240914031909_PWt2f | UK00B0 | 2024-09-18T12:10:39.140Z | 2024-09-19T12:20:00.089Z |
5120323 | 5120323 | 20240914031445_34EY9 | UK00B0 | 2024-09-18T12:10:37.181Z | 2024-09-19T12:19:59.869Z |
5120297 | 5120297 | 20240914031222_xXJ8R | UK00B0 | 2024-09-18T12:10:36.715Z | 2024-09-19T12:19:59.849Z |
5120127 | 5120127 | 20240914030045_kaNSo | UK00B0 | 2024-09-18T12:10:32.249Z | 2024-09-19T12:19:59.457Z |
5120035 | 5120035 | 20240914025740_w5sTV | UK00B0 | 2024-09-18T12:10:31.118Z | 2024-09-19T12:19:59.306Z |
5120002 | 5120002 | 20240914025624_srnLG | UK00B0 | 2024-09-18T12:10:31.030Z | 2024-09-19T12:19:59.299Z |
5119939 | 5119939 | 20240914025404_Vh24d | UK00B0 | 2024-09-18T12:10:29.736Z | 2024-09-19T12:19:59.180Z |
5119858 | 5119858 | 20240914025107_tYCQn | UK00B0 | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119808 | 5119808 | 20240914025012_cKCvm | UK00B0 | 2024-09-18T12:10:27.213Z | 2024-09-19T12:19:58.959Z |
5119802 | 5119802 | 20240914025011_1QKB8 | UK00B0 | 2024-09-18T12:10:27.160Z | 2024-09-19T12:19:58.956Z |
5119774 | 5119774 | 20240914024845_eXMdp | UK00B0 | 2024-09-18T12:10:26.757Z | 2024-09-19T12:19:58.939Z |
5119685 | 5119685 | 20240914024404_FwclT | UK00B0 | 2024-09-18T12:10:24.054Z | 2024-09-19T12:19:58.732Z |
5119124 | 5119124 | 20240914021212_g33OE | UK00B0 | 2024-09-18T12:10:16.408Z | 2024-09-19T12:19:57.196Z |
5116858 | 5116858 | 20240915034432_PyZhQ | UK00B0 | 2024-09-18T12:07:22.647Z | 2024-09-19T12:19:12.458Z |
5116602 | 5116602 | 20240915033247_BBCVw | UK00B0 | 2024-09-18T12:07:11.064Z | 2024-09-19T12:19:11.605Z |
5116281 | 5116281 | 20240915031959_WrKJe | UK00B0 | 2024-09-18T12:06:54.173Z | 2024-09-19T12:19:10.237Z |
5116124 | 5116124 | 20240915030942_XkIi7 | UK00B0 | 2024-09-18T12:06:41.629Z | 2024-09-19T12:19:08.794Z |
5116077 | 5116077 | 20240915030714_6Cyyw | UK00B0 | 2024-09-18T12:06:37.765Z | 2024-09-19T12:19:08.416Z |
5115994 | 5115994 | 20240915030242_kxnSo | UK00B0 | 2024-09-18T12:06:33.544Z | 2024-09-19T12:19:08.090Z |
5115862 | 5115862 | 20240915025624_ZUmTm | UK00B0 | 2024-09-18T12:06:29.365Z | 2024-09-19T12:19:07.574Z |
5115547 | 5115547 | 20240915024428_CUS2m | UK00B0 | 2024-09-18T12:06:17.728Z | 2024-09-19T12:19:05.352Z |
5115303 | 5115303 | 20240915023127_M3S08 | UK00B0 | 2024-09-18T12:06:10.387Z | 2024-09-19T12:19:03.788Z |
5113978 | 5113978 | 20240915012116_1VSgb | UK00B0 | 2024-09-18T12:04:56.777Z | 2024-09-19T12:18:54.884Z |
5113572 | 5113572 | 20240915005848_uNoZL | UK00B0 | 2024-09-18T12:04:30.652Z | 2024-09-19T12:18:50.395Z |
5113502 | 5113502 | 20240915005320_mrhzA | UK00B0 | 2024-09-18T12:04:24.896Z | 2024-09-19T12:18:49.754Z |
5113480 | 5113480 | 20240915005215_qlXTD | UK00B0 | 2024-09-18T12:04:22.737Z | 2024-09-19T12:18:49.588Z |
5113431 | 5113431 | 20240915004805_b42ud | UK00B0 | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5113350 | 5113350 | 20240915003918_W4xS4 | UK00B0 | 2024-09-18T12:04:09.556Z | 2024-09-19T12:18:48.581Z |
5113143 | 5113143 | 20240915002437_TaEq6 | UK00B0 | 2024-09-18T12:03:58.261Z | 2024-09-19T12:18:47.421Z |
5112578 | 5112578 | 20240914233020_Bsvf4 | UK00B0 | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5112503 | 5112503 | 20240914232157_EP6sA | UK00B0 | 2024-09-18T12:03:10.950Z | 2024-09-19T12:18:41.190Z |
5112359 | 5112359 | 20240914230410_KjigL | UK00B0 | 2024-09-18T12:03:00.974Z | 2024-09-19T12:18:40.686Z |
5112121 | 5112121 | 20240914221653_IlpIA | UK00B0 | 2024-09-18T12:02:48.816Z | 2024-09-19T12:18:38.503Z |
5112040 | 5112040 | 20240914220150_fcwLb | UK00B0 | 2024-09-18T12:02:43.205Z | 2024-09-19T12:18:37.122Z |
5111984 | 5111984 | 20240914214910_80rid | UK00B0 | 2024-09-18T12:02:34.800Z | 2024-09-19T12:18:35.985Z |
5111792 | 5111792 | 20240914211708_tO7K3 | UK00B0 | 2024-09-18T12:02:17.667Z | 2024-09-19T12:18:34.050Z |
5111657 | 5111657 | 20240914205827_EAv50 | UK00B0 | 2024-09-18T12:02:09.571Z | 2024-09-19T12:18:32.802Z |
5111601 | 5111601 | 20240914205236_oBoDU | UK00B0 | 2024-09-18T12:02:05.845Z | 2024-09-19T12:18:31.670Z |
5111569 | 5111569 | 20240914204925_jNPIh | UK00B0 | 2024-09-18T12:02:03.714Z | 2024-09-19T12:18:31.430Z |
5111513 | 5111513 | 20240914204302_3jFoI | UK00B0 | 2024-09-18T12:01:59.983Z | 2024-09-19T12:18:30.852Z |
5111464 | 5111464 | 20240914203952_gx6rh | UK00B0 | 2024-09-18T12:01:57.836Z | 2024-09-19T12:18:30.436Z |
5111373 | 5111373 | 20240914202837_OlHm7 | UK00B0 | 2024-09-18T12:01:52.739Z | 2024-09-19T12:18:29.612Z |
5111250 | 5111250 | 20240914201405_GQTM7 | UK00B0 | 2024-09-18T12:01:44.912Z | 2024-09-19T12:18:28.008Z |
5111239 | 5111239 | 20240914201314_Fgem2 | UK00B0 | 2024-09-18T12:01:44.638Z | 2024-09-19T12:18:27.914Z |
5111193 | 5111193 | 20240914201007_8Xvja | UK00B0 | 2024-09-18T12:01:42.471Z | 2024-09-19T12:18:27.298Z |
5111027 | 5111027 | 20240914194235_3DP03 | UK00B0 | 2024-09-18T12:01:20.868Z | 2024-09-19T12:18:25.431Z |
5111009 | 5111009 | 20240914193941_xDZd2 | UK00B0 | 2024-09-18T12:01:19.167Z | 2024-09-19T12:18:25.275Z |
5108280 | 5108280 | 20240913043838_875oU | UK00B0 | 2024-09-17T12:13:34.587Z | 2024-09-19T12:20:47.991Z |
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);