participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,595 rows where station_code = "UK006D" 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 |
---|---|---|---|---|---|
5405975 | 5405975 | 20241027011126_7gWv5 | UK006D | 2024-10-29T12:13:42.790Z | 2024-11-04T14:28:54.803Z |
5405728 | 5405728 | 20241027005443_3f52Q | UK006D | 2024-10-29T12:13:10.863Z | 2024-11-04T14:28:54.119Z |
5405694 | 5405694 | 20241027005351_oqV7D | UK006D | 2024-10-29T12:13:09.984Z | 2024-11-04T14:28:53.917Z |
5404769 | 5404769 | 20241026235130_gciNi | UK006D | 2024-10-29T12:11:56.832Z | 2024-11-04T14:28:51.925Z |
5404477 | 5404477 | 20241026233029_LcZ2Z | UK006D | 2024-10-29T12:11:32.332Z | 2024-11-04T14:28:51.102Z |
5404392 | 5404392 | 20241026232245_d3wlO | UK006D | 2024-10-29T12:11:18.023Z | 2024-11-04T14:28:50.845Z |
5404005 | 5404005 | 20241026225241_yB9gz | UK006D | 2024-10-29T12:10:47.261Z | 2024-11-04T14:28:50.210Z |
5403959 | 5403959 | 20241026224822_NUqTY | UK006D | 2024-10-29T12:10:38.410Z | 2024-11-04T14:28:50.109Z |
5403621 | 5403621 | 20241026221633_TxrGX | UK006D | 2024-10-29T12:10:02.407Z | 2024-11-04T14:28:49.339Z |
5403446 | 5403446 | 20241026215708_dbU80 | UK006D | 2024-10-29T12:09:31.581Z | 2024-11-04T14:28:48.876Z |
5403007 | 5403007 | 20241026210152_4Davd | UK006D | 2024-10-29T12:08:44.168Z | 2024-11-04T14:28:47.346Z |
5402032 | 5402032 | 20241026183026_SVYtD | UK006D | 2024-10-29T12:06:06.924Z | 2024-11-04T14:28:41.722Z |
5395349 | 5395349 | 20241025223503_s22qS | UK006D | 2024-10-28T12:16:10.464Z | 2024-11-03T14:27:25.190Z |
5395154 | 5395154 | 20241025221542_vngbm | UK006D | 2024-10-28T12:15:59.058Z | 2024-11-03T14:27:24.112Z |
5395118 | 5395118 | 20241025221215_l061P | UK006D | 2024-10-28T12:15:57.501Z | 2024-11-03T14:27:24.052Z |
5395098 | 5395098 | 20241025221044_BxXsE | UK006D | 2024-10-28T12:15:56.679Z | 2024-11-03T14:27:23.992Z |
5386752 | 5386752 | 20241025012144_v71pW | UK006D | 2024-10-27T12:20:25.125Z | 2024-11-02T12:28:31.546Z |
5386738 | 5386738 | 20241025012006_p0gIr | UK006D | 2024-10-27T12:20:23.738Z | 2024-11-02T12:28:31.540Z |
5385395 | 5385395 | 20241024223618_2Fmt2 | UK006D | 2024-10-27T12:18:50.324Z | 2024-11-02T12:28:29.705Z |
5384507 | 5384507 | 20241024201525_K0Ycc | UK006D | 2024-10-27T12:17:08.740Z | 2024-11-02T12:28:27.259Z |
5378140 | 5378140 | 20241024052948_vV2Ig | UK006D | 2024-10-26T12:22:55.486Z | 2024-11-01T12:27:03.300Z |
5378020 | 5378020 | 20241024052400_4aHkL | UK006D | 2024-10-26T12:22:52.883Z | 2024-11-01T12:27:03.228Z |
5377925 | 5377925 | 20241024051758_VhjYU | UK006D | 2024-10-26T12:22:49.812Z | 2024-11-01T12:27:03.165Z |
5377145 | 5377145 | 20241024043510_fhLPe | UK006D | 2024-10-26T12:22:28.509Z | 2024-11-01T12:27:02.209Z |
5376250 | 5376250 | 20241024034727_LY5cB | UK006D | 2024-10-26T12:21:54.953Z | 2024-11-01T12:27:01.473Z |
5375598 | 5375598 | 20241024032123_5YXeA | UK006D | 2024-10-26T12:21:33.015Z | 2024-11-01T12:27:01.105Z |
5372040 | 5372040 | 20241024002931_UXr03 | UK006D | 2024-10-26T12:19:04.937Z | 2024-11-01T12:26:57.072Z |
5365445 | 5365445 | 20241023233317_7MCd3 | UK006D | 2024-10-25T12:17:58.112Z | 2024-11-01T12:26:56.132Z |
5364710 | 5364710 | 20241023224856_rwT2V | UK006D | 2024-10-25T12:17:31.409Z | 2024-11-01T12:26:55.597Z |
5364367 | 5364367 | 20241023222339_Sua7D | UK006D | 2024-10-25T12:17:18.533Z | 2024-11-01T12:26:55.020Z |
5364228 | 5364228 | 20241023221432_RUfUc | UK006D | 2024-10-25T12:17:12.862Z | 2024-11-01T12:26:54.613Z |
5364198 | 5364198 | 20241023221319_MHeJw | UK006D | 2024-10-25T12:17:12.010Z | 2024-11-01T12:26:54.602Z |
5363988 | 5363988 | 20241023220114_6SC0b | UK006D | 2024-10-25T12:17:04.830Z | 2024-11-01T12:26:54.266Z |
5363975 | 5363975 | 20241023220040_Iwjoz | UK006D | 2024-10-25T12:17:04.290Z | 2024-11-01T12:26:54.234Z |
5363710 | 5363710 | 20241023213657_4n2vH | UK006D | 2024-10-25T12:16:37.063Z | 2024-11-01T12:26:53.542Z |
5363688 | 5363688 | 20241023213550_FYR1W | UK006D | 2024-10-25T12:16:34.958Z | 2024-11-01T12:26:53.500Z |
5363680 | 5363680 | 20241023213456_X3Zxh | UK006D | 2024-10-25T12:16:34.538Z | 2024-11-01T12:26:53.491Z |
5363454 | 5363454 | 20241023210416_2VDtZ | UK006D | 2024-10-25T12:16:12.936Z | 2024-11-01T12:26:53.307Z |
5363441 | 5363441 | 20241023210336_op2ez | UK006D | 2024-10-25T12:16:11.614Z | 2024-11-01T12:26:53.288Z |
5362855 | 5362855 | 20241023200554_KgJYB | UK006D | 2024-10-25T12:15:13.464Z | 2024-11-01T12:26:52.480Z |
5362212 | 5362212 | 20241023191627_Q7fGY | UK006D | 2024-10-25T12:14:01.510Z | 2024-11-01T12:26:51.105Z |
5350332 | 5350332 | 20241022213603_QsJ2P | UK006D | 2024-10-24T12:15:36.972Z | 2024-10-31T12:29:57.944Z |
5321543 | 5321543 | 20241018051001_Bph0Y | UK006D | 2024-10-19T12:07:47.670Z | 2024-10-26T12:27:56.964Z |
5321474 | 5321474 | 20241018045602_XxYMO | UK006D | 2024-10-19T12:07:35.371Z | 2024-10-26T12:27:56.882Z |
5321429 | 5321429 | 20241018045032_KRosb | UK006D | 2024-10-19T12:07:27.278Z | 2024-10-26T12:27:56.827Z |
5321373 | 5321373 | 20241018044351_SY92o | UK006D | 2024-10-19T12:07:16.263Z | 2024-10-26T12:27:56.576Z |
5321301 | 5321301 | 20241018042710_RMtEn | UK006D | 2024-10-19T12:07:10.177Z | 2024-10-26T12:27:56.454Z |
5321234 | 5321234 | 20241018041400_NEl9N | UK006D | 2024-10-19T12:07:03.055Z | 2024-10-26T12:27:56.361Z |
5321110 | 5321110 | 20241018035001_OPAc0 | UK006D | 2024-10-19T12:06:47.300Z | 2024-10-26T12:27:56.192Z |
5303934 | 5303934 | 20241013035055_ocV2O | UK006D | 2024-10-14T12:17:38.688Z | 2024-10-21T12:24:22.104Z |
5301443 | 5301443 | 20241012232740_2XX45 | UK006D | 2024-10-14T12:15:25.307Z | 2024-10-21T12:23:58.191Z |
5301136 | 5301136 | 20241012224546_PWasc | UK006D | 2024-10-14T12:14:54.603Z | 2024-10-21T12:23:55.489Z |
5301063 | 5301063 | 20241012223456_r2x52 | UK006D | 2024-10-14T12:14:48.505Z | 2024-10-21T12:23:55.139Z |
5301031 | 5301031 | 20241012223045_nk2qW | UK006D | 2024-10-14T12:14:45.945Z | 2024-10-21T12:23:54.988Z |
5300936 | 5300936 | 20241012221146_9tW2E | UK006D | 2024-10-14T12:14:38.191Z | 2024-10-21T12:23:54.056Z |
5300765 | 5300765 | 20241012213943_zJvxH | UK006D | 2024-10-14T12:14:26.370Z | 2024-10-21T12:23:52.439Z |
5300578 | 5300578 | 20241012205628_RPNWB | UK006D | 2024-10-14T12:14:16.822Z | 2024-10-21T12:23:50.008Z |
5300466 | 5300466 | 20241012204106_GlXsL | UK006D | 2024-10-14T12:14:07.434Z | 2024-10-21T12:23:49.272Z |
5300458 | 5300458 | 20241012204106_YvF5V | UK006D | 2024-10-14T12:14:06.868Z | 2024-10-21T12:23:49.257Z |
5300433 | 5300433 | 20241012203924_YaHR6 | UK006D | 2024-10-14T12:14:04.573Z | 2024-10-21T12:23:49.077Z |
5300332 | 5300332 | 20241012202643_EqR72 | UK006D | 2024-10-14T12:13:50.164Z | 2024-10-21T12:23:48.462Z |
5300291 | 5300291 | 20241012202112_RCdMo | UK006D | 2024-10-14T12:13:46.319Z | 2024-10-21T12:23:47.994Z |
5300139 | 5300139 | 20241012200613_6l1bh | UK006D | 2024-10-14T12:13:30.478Z | 2024-10-21T12:23:46.674Z |
5299987 | 5299987 | 20241012195323_n0LwF | UK006D | 2024-10-14T12:13:22.484Z | 2024-10-21T12:23:45.442Z |
5299584 | 5299584 | 20241012190813_2ysi9 | UK006D | 2024-10-14T12:12:34.434Z | 2024-10-21T12:23:41.926Z |
5299573 | 5299573 | 20241012190806_amweG | UK006D | 2024-10-14T12:12:32.771Z | 2024-10-21T12:23:41.831Z |
5299554 | 5299554 | 20241012190541_pjGP0 | UK006D | 2024-10-14T12:12:30.382Z | 2024-10-21T12:23:41.569Z |
5299485 | 5299485 | 20241012185519_cxQzw | UK006D | 2024-10-14T12:12:20.289Z | 2024-10-21T12:23:39.602Z |
5299406 | 5299406 | 20241012184516_ojbk2 | UK006D | 2024-10-14T12:12:14.789Z | 2024-10-21T12:23:38.646Z |
5299362 | 5299362 | 20241012183737_Fxwad | UK006D | 2024-10-14T12:12:12.297Z | 2024-10-21T12:23:37.835Z |
5299358 | 5299358 | 20241012183736_DNXST | UK006D | 2024-10-14T12:12:11.965Z | 2024-10-21T12:23:37.726Z |
5299222 | 5299222 | 20241012182034_in0g4 | UK006D | 2024-10-14T12:12:02.580Z | 2024-10-21T12:23:35.687Z |
5263533 | 5263533 | 20241009045213_UHPSl | UK006D | 2024-10-10T12:01:14.733Z | 2024-10-18T12:21:35.291Z |
5263511 | 5263511 | 20241009044628_O1e6P | UK006D | 2024-10-10T12:01:10.055Z | 2024-10-18T12:21:35.119Z |
5263502 | 5263502 | 20241009044457_VzlSh | UK006D | 2024-10-10T12:01:09.154Z | 2024-10-18T12:21:35.075Z |
5263330 | 5263330 | 20241009041029_Lhyja | UK006D | 2024-10-10T12:00:34.367Z | 2024-10-18T12:21:32.668Z |
5263326 | 5263326 | 20241009040949_2Js66 | UK006D | 2024-10-10T12:00:33.283Z | 2024-10-18T12:21:32.484Z |
5263267 | 5263267 | 20241009035617_mmijg | UK006D | 2024-10-10T12:00:23.267Z | 2024-10-18T12:21:31.754Z |
5263234 | 5263234 | 20241009034553_mhHpB | UK006D | 2024-10-10T12:00:17.668Z | 2024-10-18T12:21:31.274Z |
5262645 | 5262645 | 20241008020208_f0ET6 | UK006D | 2024-10-09T12:16:02.518Z | 2024-10-16T12:21:19.434Z |
5262611 | 5262611 | 20241008015824_8v8CM | UK006D | 2024-10-09T12:16:00.296Z | 2024-10-16T12:21:19.318Z |
5262582 | 5262582 | 20241008015521_qpx2r | UK006D | 2024-10-09T12:15:59.033Z | 2024-10-16T12:21:19.269Z |
5262437 | 5262437 | 20241008012707_Qec1d | UK006D | 2024-10-09T12:15:44.897Z | 2024-10-16T12:21:18.676Z |
5262411 | 5262411 | 20241008012212_VJI61 | UK006D | 2024-10-09T12:15:41.728Z | 2024-10-16T12:21:18.622Z |
5262383 | 5262383 | 20241008011721_qthUC | UK006D | 2024-10-09T12:15:40.136Z | 2024-10-16T12:21:18.491Z |
5262351 | 5262351 | 20241008010938_IJe3S | UK006D | 2024-10-09T12:15:36.649Z | 2024-10-16T12:21:18.390Z |
5262344 | 5262344 | 20241008010904_8WmHD | UK006D | 2024-10-09T12:15:36.114Z | 2024-10-16T12:21:18.323Z |
5262288 | 5262288 | 20241008005744_X2V0i | UK006D | 2024-10-09T12:15:29.530Z | 2024-10-16T12:21:18.075Z |
5262269 | 5262269 | 20241008005426_QPZaz | UK006D | 2024-10-09T12:15:27.696Z | 2024-10-16T12:21:17.982Z |
5255145 | 5255145 | 20241008034440_ZuKtO | UK006D | 2024-10-09T12:00:42.326Z | 2024-10-17T12:19:51.124Z |
5254525 | 5254525 | 20241007022602_kms7D | UK006D | 2024-10-08T12:14:30.255Z | 2024-10-15T12:29:16.088Z |
5254425 | 5254425 | 20241007021013_nGrGk | UK006D | 2024-10-08T12:14:25.010Z | 2024-10-15T12:29:15.355Z |
5253463 | 5253463 | 20241007000110_xj0Oq | UK006D | 2024-10-08T12:13:16.091Z | 2024-10-15T12:29:09.426Z |
5253449 | 5253449 | 20241006235711_bKl9R | UK006D | 2024-10-08T12:13:15.653Z | 2024-10-15T12:29:09.403Z |
5253428 | 5253428 | 20241006235357_m8MXD | UK006D | 2024-10-08T12:13:14.856Z | 2024-10-15T12:29:09.214Z |
5253387 | 5253387 | 20241006234613_ypBEC | UK006D | 2024-10-08T12:13:11.949Z | 2024-10-15T12:29:09.075Z |
5253340 | 5253340 | 20241006233800_ZF0iP | UK006D | 2024-10-08T12:13:08.850Z | 2024-10-15T12:29:08.924Z |
5253300 | 5253300 | 20241006233052_ACtHa | UK006D | 2024-10-08T12:13:06.620Z | 2024-10-15T12:29:08.663Z |
5253265 | 5253265 | 20241006232145_3Wfel | UK006D | 2024-10-08T12:13:04.840Z | 2024-10-15T12:29:08.285Z |
5253261 | 5253261 | 20241006232144_DW9pC | UK006D | 2024-10-08T12:13:04.789Z | 2024-10-15T12:29:08.258Z |
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);