participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,223 rows where station_code = "UK0035" 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 |
---|---|---|---|---|---|
5133932 | 5133932 | 20240916041901_tzT48 | UK0035 | 2024-09-19T12:17:13.754Z | 2024-09-19T12:17:13.754Z |
5133841 | 5133841 | 20240916040939_Jnajp | UK0035 | 2024-09-19T12:17:10.291Z | 2024-09-19T12:17:10.291Z |
5132970 | 5132970 | 20240916023810_2eWC2 | UK0035 | 2024-09-19T12:16:39.685Z | 2024-09-19T12:16:39.685Z |
5132910 | 5132910 | 20240916022850_E6Oav | UK0035 | 2024-09-19T12:16:35.910Z | 2024-09-19T12:16:35.910Z |
5129347 | 5129347 | 20240917035057_b0sYZ | UK0035 | 2024-09-19T12:11:30.379Z | 2024-09-19T12:11:30.379Z |
5126854 | 5126854 | 20240916194132_mW4qH | UK0035 | 2024-09-19T12:07:28.714Z | 2024-09-19T12:07:28.714Z |
5121938 | 5121938 | 20240914042145_aRjtH | UK0035 | 2024-09-18T12:11:03.196Z | 2024-09-19T12:20:02.522Z |
5121657 | 5121657 | 20240914041155_QyLxn | UK0035 | 2024-09-18T12:10:59.187Z | 2024-09-19T12:20:02.207Z |
5121621 | 5121621 | 20240914041042_HtKAC | UK0035 | 2024-09-18T12:10:58.922Z | 2024-09-19T12:20:02.186Z |
5121574 | 5121574 | 20240914040945_CnoCw | UK0035 | 2024-09-18T12:10:58.485Z | 2024-09-19T12:20:02.139Z |
5121351 | 5121351 | 20240914035905_QiNcV | UK0035 | 2024-09-18T12:10:54.685Z | 2024-09-19T12:20:01.699Z |
5121318 | 5121318 | 20240914035815_Xm2fk | UK0035 | 2024-09-18T12:10:54.567Z | 2024-09-19T12:20:01.624Z |
5121110 | 5121110 | 20240914035228_sJvYo | UK0035 | 2024-09-18T12:10:51.280Z | 2024-09-19T12:20:01.367Z |
5120957 | 5120957 | 20240914034301_pu1Yj | UK0035 | 2024-09-18T12:10:48.930Z | 2024-09-19T12:20:01.080Z |
5120926 | 5120926 | 20240914034205_Gq0aN | UK0035 | 2024-09-18T12:10:48.813Z | 2024-09-19T12:20:01.076Z |
5120751 | 5120751 | 20240914033443_UEKyt | UK0035 | 2024-09-18T12:10:46.590Z | 2024-09-19T12:20:00.852Z |
5120692 | 5120692 | 20240914033219_xnzxE | UK0035 | 2024-09-18T12:10:45.976Z | 2024-09-19T12:20:00.770Z |
5120644 | 5120644 | 20240914033037_YKJCw | UK0035 | 2024-09-18T12:10:44.189Z | 2024-09-19T12:20:00.671Z |
5120534 | 5120534 | 20240914032754_uE9bi | UK0035 | 2024-09-18T12:10:42.964Z | 2024-09-19T12:20:00.563Z |
5120456 | 5120456 | 20240914032048_RlZ3d | UK0035 | 2024-09-18T12:10:40.749Z | 2024-09-19T12:20:00.331Z |
5120112 | 5120112 | 20240914030045_kaNSo | UK0035 | 2024-09-18T12:10:32.247Z | 2024-09-19T12:19:59.457Z |
5119846 | 5119846 | 20240914025107_tYCQn | UK0035 | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119128 | 5119128 | 20240914021227_p9Q83 | UK0035 | 2024-09-18T12:10:16.493Z | 2024-09-19T12:19:57.218Z |
5117114 | 5117114 | 20240915040350_u04rH | UK0035 | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5116994 | 5116994 | 20240915035520_RrWza | UK0035 | 2024-09-18T12:07:28.025Z | 2024-09-19T12:19:12.990Z |
5116864 | 5116864 | 20240915034443_G1tt1 | UK0035 | 2024-09-18T12:07:23.700Z | 2024-09-19T12:19:12.484Z |
5116841 | 5116841 | 20240915034432_PyZhQ | UK0035 | 2024-09-18T12:07:22.646Z | 2024-09-19T12:19:12.458Z |
5116758 | 5116758 | 20240915034018_8sSmw | UK0035 | 2024-09-18T12:07:20.178Z | 2024-09-19T12:19:12.313Z |
5116574 | 5116574 | 20240915033225_MK2tZ | UK0035 | 2024-09-18T12:07:10.682Z | 2024-09-19T12:19:11.568Z |
5116435 | 5116435 | 20240915032628_CyRlB | UK0035 | 2024-09-18T12:07:02.612Z | 2024-09-19T12:19:11.165Z |
5116393 | 5116393 | 20240915032506_4lBjC | UK0035 | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5116362 | 5116362 | 20240915032348_51WgL | UK0035 | 2024-09-18T12:07:00.127Z | 2024-09-19T12:19:10.742Z |
5116032 | 5116032 | 20240915030422_BjdsF | UK0035 | 2024-09-18T12:06:35.055Z | 2024-09-19T12:19:08.234Z |
5115829 | 5115829 | 20240915025433_9ZS2s | UK0035 | 2024-09-18T12:06:26.622Z | 2024-09-19T12:19:07.441Z |
5115667 | 5115667 | 20240915024901_VW6yq | UK0035 | 2024-09-18T12:06:21.013Z | 2024-09-19T12:19:06.372Z |
5115609 | 5115609 | 20240915024619_MFu3K | UK0035 | 2024-09-18T12:06:19.199Z | 2024-09-19T12:19:05.812Z |
5115405 | 5115405 | 20240915023653_YvvWz | UK0035 | 2024-09-18T12:06:13.122Z | 2024-09-19T12:19:04.540Z |
5115233 | 5115233 | 20240915022834_oclyd | UK0035 | 2024-09-18T12:06:07.451Z | 2024-09-19T12:19:03.184Z |
5114829 | 5114829 | 20240915020037_79AML | UK0035 | 2024-09-18T12:05:36.392Z | 2024-09-19T12:19:00.134Z |
5114812 | 5114812 | 20240915020025_2J9Ay | UK0035 | 2024-09-18T12:05:35.841Z | 2024-09-19T12:19:00.092Z |
5114782 | 5114782 | 20240915015819_c3g4l | UK0035 | 2024-09-18T12:05:34.475Z | 2024-09-19T12:18:59.906Z |
5114617 | 5114617 | 20240915015225_PAl02 | UK0035 | 2024-09-18T12:05:25.858Z | 2024-09-19T12:18:59.081Z |
5114398 | 5114398 | 20240915014101_hZoLI | UK0035 | 2024-09-18T12:05:14.305Z | 2024-09-19T12:18:57.938Z |
5114146 | 5114146 | 20240915012945_XOYjJ | UK0035 | 2024-09-18T12:05:04.252Z | 2024-09-19T12:18:56.435Z |
5113926 | 5113926 | 20240915012025_uhUMW | UK0035 | 2024-09-18T12:04:55.862Z | 2024-09-19T12:18:54.473Z |
5113833 | 5113833 | 20240915011531_WRWYs | UK0035 | 2024-09-18T12:04:52.448Z | 2024-09-19T12:18:53.284Z |
5113733 | 5113733 | 20240915011104_fXah3 | UK0035 | 2024-09-18T12:04:48.698Z | 2024-09-19T12:18:51.810Z |
5113680 | 5113680 | 20240915010509_grEkf | UK0035 | 2024-09-18T12:04:39.659Z | 2024-09-19T12:18:51.253Z |
5113590 | 5113590 | 20240915010038_yynXa | UK0035 | 2024-09-18T12:04:34.530Z | 2024-09-19T12:18:50.527Z |
5113562 | 5113562 | 20240915005848_uNoZL | UK0035 | 2024-09-18T12:04:30.651Z | 2024-09-19T12:18:50.394Z |
5112973 | 5112973 | 20240915001109_JKPUo | UK0035 | 2024-09-18T12:03:49.881Z | 2024-09-19T12:18:46.235Z |
5112950 | 5112950 | 20240915001108_I3lqt | UK0035 | 2024-09-18T12:03:49.751Z | 2024-09-19T12:18:46.054Z |
5112646 | 5112646 | 20240914233857_oFHQB | UK0035 | 2024-09-18T12:03:19.363Z | 2024-09-19T12:18:42.650Z |
5112587 | 5112587 | 20240914233034_ABu4f | UK0035 | 2024-09-18T12:03:15.509Z | 2024-09-19T12:18:41.527Z |
5112469 | 5112469 | 20240914231854_40L2a | UK0035 | 2024-09-18T12:03:09.635Z | 2024-09-19T12:18:41.111Z |
5111748 | 5111748 | 20240914211331_1Nhi7 | UK0035 | 2024-09-18T12:02:15.023Z | 2024-09-19T12:18:33.790Z |
5111692 | 5111692 | 20240914210049_wBjPi | UK0035 | 2024-09-18T12:02:11.197Z | 2024-09-19T12:18:33.328Z |
5111575 | 5111575 | 20240914205051_F6LRZ | UK0035 | 2024-09-18T12:02:04.393Z | 2024-09-19T12:18:31.498Z |
5111485 | 5111485 | 20240914204238_hSIkr | UK0035 | 2024-09-18T12:01:59.530Z | 2024-09-19T12:18:30.823Z |
5111419 | 5111419 | 20240914203608_z6s2s | UK0035 | 2024-09-18T12:01:55.852Z | 2024-09-19T12:18:30.113Z |
5111295 | 5111295 | 20240914202048_RBYeT | UK0035 | 2024-09-18T12:01:48.338Z | 2024-09-19T12:18:28.847Z |
5111042 | 5111042 | 20240914194621_Ywshl | UK0035 | 2024-09-18T12:01:23.171Z | 2024-09-19T12:18:25.576Z |
5110886 | 5110886 | 20240914191958_NdXQ0 | UK0035 | 2024-09-18T12:01:08.960Z | 2024-09-19T12:18:24.552Z |
5110449 | 5110449 | 20240911010346_TXvjR | UK0035 | 2024-09-17T12:17:57.870Z | 2024-09-19T12:21:39.378Z |
5107751 | 5107751 | 20240913040937_NdYVv | UK0035 | 2024-09-17T12:13:23.553Z | 2024-09-19T12:20:47.532Z |
5107539 | 5107539 | 20240913035854_mqhvd | UK0035 | 2024-09-17T12:13:16.758Z | 2024-09-19T12:20:47.214Z |
5107454 | 5107454 | 20240913035737_r9og7 | UK0035 | 2024-09-17T12:13:15.772Z | 2024-09-19T12:20:47.164Z |
5106983 | 5106983 | 20240913034133_xmreC | UK0035 | 2024-09-17T12:13:06.308Z | 2024-09-19T12:20:46.740Z |
5106892 | 5106892 | 20240913033804_6bAi1 | UK0035 | 2024-09-17T12:13:03.762Z | 2024-09-19T12:20:46.510Z |
5106759 | 5106759 | 20240913033355_jgXwb | UK0035 | 2024-09-17T12:13:00.753Z | 2024-09-19T12:20:46.382Z |
5106700 | 5106700 | 20240913033244_xNwMk | UK0035 | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5106581 | 5106581 | 20240913032854_puZud | UK0035 | 2024-09-17T12:12:57.427Z | 2024-09-19T12:20:46.187Z |
5106263 | 5106263 | 20240913031620_PYhHL | UK0035 | 2024-09-17T12:12:47.410Z | 2024-09-19T12:20:45.727Z |
5106234 | 5106234 | 20240913031554_OvOOU | UK0035 | 2024-09-17T12:12:45.346Z | 2024-09-19T12:20:45.682Z |
5106210 | 5106210 | 20240913031545_H3ROi | UK0035 | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5105835 | 5105835 | 20240913030036_LDAt2 | UK0035 | 2024-09-17T12:12:30.530Z | 2024-09-19T12:20:44.985Z |
5105476 | 5105476 | 20240913024739_u4u5T | UK0035 | 2024-09-17T12:12:18.599Z | 2024-09-19T12:20:44.595Z |
5105045 | 5105045 | 20240913022812_VdYf6 | UK0035 | 2024-09-17T12:11:50.822Z | 2024-09-19T12:20:43.436Z |
5104862 | 5104862 | 20240913022207_0Ph2X | UK0035 | 2024-09-17T12:11:45.645Z | 2024-09-19T12:20:43.071Z |
5104647 | 5104647 | 20240913021814_1HhV8 | UK0035 | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.659Z |
5104539 | 5104539 | 20240913021459_xXwf6 | UK0035 | 2024-09-17T12:11:38.836Z | 2024-09-19T12:20:41.692Z |
5103684 | 5103684 | 20240913013553_ejHYY | UK0035 | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5103662 | 5103662 | 20240913013551_Kikf3 | UK0035 | 2024-09-17T12:11:07.705Z | 2024-09-19T12:20:40.420Z |
5103171 | 5103171 | 20240914020340_xw8Hd | UK0035 | 2024-09-17T12:07:55.401Z | 2024-09-19T12:19:56.762Z |
5103039 | 5103039 | 20240914015933_3CQ1x | UK0035 | 2024-09-17T12:07:49.006Z | 2024-09-19T12:19:56.471Z |
5102999 | 5102999 | 20240914015702_iHLvl | UK0035 | 2024-09-17T12:07:46.811Z | 2024-09-19T12:19:56.322Z |
5102938 | 5102938 | 20240914015535_82Si3 | UK0035 | 2024-09-17T12:07:44.942Z | 2024-09-19T12:19:56.210Z |
5102872 | 5102872 | 20240914015121_iTk33 | UK0035 | 2024-09-17T12:07:41.705Z | 2024-09-19T12:19:56.019Z |
5102647 | 5102647 | 20240914013532_3VO3P | UK0035 | 2024-09-17T12:07:29.307Z | 2024-09-19T12:19:55.305Z |
5102204 | 5102204 | 20240914011210_ADSRA | UK0035 | 2024-09-17T12:06:54.706Z | 2024-09-19T12:19:52.884Z |
5102113 | 5102113 | 20240914010628_RARmq | UK0035 | 2024-09-17T12:06:49.360Z | 2024-09-19T12:19:52.501Z |
5101985 | 5101985 | 20240914005818_T6cvD | UK0035 | 2024-09-17T12:06:36.662Z | 2024-09-19T12:19:52.094Z |
5101913 | 5101913 | 20240914005527_NzMrf | UK0035 | 2024-09-17T12:06:24.077Z | 2024-09-19T12:19:51.861Z |
5101724 | 5101724 | 20240914004411_A1rfk | UK0035 | 2024-09-17T12:06:10.254Z | 2024-09-19T12:19:51.321Z |
5101651 | 5101651 | 20240914004134_epWXK | UK0035 | 2024-09-17T12:06:07.004Z | 2024-09-19T12:19:51.178Z |
5101611 | 5101611 | 20240914003907_SgXcF | UK0035 | 2024-09-17T12:06:05.143Z | 2024-09-19T12:19:51.103Z |
5101521 | 5101521 | 20240914003333_Wd6Ef | UK0035 | 2024-09-17T12:05:59.112Z | 2024-09-19T12:19:50.850Z |
5101383 | 5101383 | 20240914002224_WXZng | UK0035 | 2024-09-17T12:05:40.161Z | 2024-09-19T12:19:50.411Z |
5101368 | 5101368 | 20240914002217_g2svX | UK0035 | 2024-09-17T12:05:39.556Z | 2024-09-19T12:19:50.407Z |
5100976 | 5100976 | 20240913235534_dvXWJ | UK0035 | 2024-09-17T12:05:13.182Z | 2024-09-19T12:19:49.465Z |
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);