participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,628 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 |
---|---|---|---|---|---|
5579416 | 5579416 | 20241121224136_noacB | UK006D | 2024-11-23T14:18:22.457Z | 2024-11-25T14:20:25.245Z |
5577864 | 5577864 | 20241121180624_2GbIr | UK006D | 2024-11-23T14:16:11.566Z | 2024-11-25T14:20:11.807Z |
5577611 | 5577611 | 20241121172354_y86pz | UK006D | 2024-11-23T14:15:31.071Z | 2024-11-25T14:20:08.031Z |
5574599 | 5574599 | 20241122060308_GNAg8 | UK006D | 2024-11-23T14:03:46.885Z | 2024-11-25T14:18:04.315Z |
5574538 | 5574538 | 20241122055811_pyqS1 | UK006D | 2024-11-23T14:03:39.287Z | 2024-11-25T14:18:03.600Z |
5569968 | 5569968 | 20241120181410_o3L1o | UK006D | 2024-11-22T14:14:42.078Z | 2024-11-25T14:21:11.939Z |
5569836 | 5569836 | 20241120174329_62M2F | UK006D | 2024-11-22T14:14:23.331Z | 2024-11-25T14:21:10.625Z |
5569757 | 5569757 | 20241120171800_ve49r | UK006D | 2024-11-22T14:14:04.660Z | 2024-11-25T14:21:09.614Z |
5564822 | 5564822 | 20241120032930_uefJG | UK006D | 2024-11-21T14:18:05.782Z | 2024-11-25T14:22:02.458Z |
5564578 | 5564578 | 20241120031110_Yv1xy | UK006D | 2024-11-21T14:17:51.206Z | 2024-11-25T14:22:01.680Z |
5564344 | 5564344 | 20241120024857_wVpgf | UK006D | 2024-11-21T14:17:28.232Z | 2024-11-25T14:22:00.647Z |
5564334 | 5564334 | 20241120024857_Cm9Kb | UK006D | 2024-11-21T14:17:27.701Z | 2024-11-25T14:22:00.628Z |
5543391 | 5543391 | 20241115005617_Ps2AB | UK006D | 2024-11-16T14:06:13.506Z | 2024-11-23T14:26:18.798Z |
5531405 | 5531405 | 20241112033816_BmM3Q | UK006D | 2024-11-13T14:15:37.913Z | 2024-11-20T14:26:11.157Z |
5530938 | 5530938 | 20241112030112_UmMcE | UK006D | 2024-11-13T14:14:52.423Z | 2024-11-20T14:26:05.382Z |
5530871 | 5530871 | 20241112025649_bhCAO | UK006D | 2024-11-13T14:14:46.563Z | 2024-11-20T14:26:04.296Z |
5530492 | 5530492 | 20241112022351_Itng3 | UK006D | 2024-11-13T14:14:18.754Z | 2024-11-20T14:26:00.822Z |
5530388 | 5530388 | 20241112021458_DZp1I | UK006D | 2024-11-13T14:14:13.196Z | 2024-11-20T14:25:58.414Z |
5530185 | 5530185 | 20241112015441_Xsa7U | UK006D | 2024-11-13T14:14:01.032Z | 2024-11-20T14:25:55.370Z |
5530167 | 5530167 | 20241112015313_GLukE | UK006D | 2024-11-13T14:13:59.695Z | 2024-11-20T14:25:55.076Z |
5530084 | 5530084 | 20241112014216_E4mSr | UK006D | 2024-11-13T14:13:50.362Z | 2024-11-20T14:25:54.272Z |
5530008 | 5530008 | 20241112013613_7O8C4 | UK006D | 2024-11-13T14:13:38.142Z | 2024-11-20T14:25:52.453Z |
5529996 | 5529996 | 20241112013325_4GuW8 | UK006D | 2024-11-13T14:13:35.669Z | 2024-11-20T14:25:52.348Z |
5529833 | 5529833 | 20241112010725_HZqjI | UK006D | 2024-11-13T14:13:13.923Z | 2024-11-20T14:25:48.896Z |
5529743 | 5529743 | 20241112010120_YqAhD | UK006D | 2024-11-13T14:13:08.719Z | 2024-11-20T14:25:47.889Z |
5529734 | 5529734 | 20241112010052_l63wZ | UK006D | 2024-11-13T14:13:08.343Z | 2024-11-20T14:25:47.839Z |
5529666 | 5529666 | 20241112005116_YhDOy | UK006D | 2024-11-13T14:13:05.338Z | 2024-11-20T14:25:47.334Z |
5529156 | 5529156 | 20241111233849_FWfE7 | UK006D | 2024-11-13T14:12:09.554Z | 2024-11-20T14:25:40.840Z |
5529087 | 5529087 | 20241111232743_i632N | UK006D | 2024-11-13T14:12:03.876Z | 2024-11-20T14:25:39.641Z |
5529034 | 5529034 | 20241111232117_C4C2i | UK006D | 2024-11-13T14:11:59.377Z | 2024-11-20T14:25:38.866Z |
5528874 | 5528874 | 20241111230010_d29qF | UK006D | 2024-11-13T14:11:34.207Z | 2024-11-20T14:25:36.867Z |
5528554 | 5528554 | 20241111213211_H4Q3o | UK006D | 2024-11-13T14:11:05.855Z | 2024-11-20T14:25:32.130Z |
5528063 | 5528063 | 20241111192537_TyYAl | UK006D | 2024-11-13T14:09:46.449Z | 2024-11-20T14:25:24.748Z |
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 |
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);