participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,204 rows where station_code = "UK008W" 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 |
---|---|---|---|---|---|
5135317 | 5135317 | 20240915040245_zGMqY | UK008W | 2024-09-19T12:19:13.340Z | 2024-09-19T12:19:13.340Z |
5133785 | 5133785 | 20240916040518_Xlwwt | UK008W | 2024-09-19T12:17:07.990Z | 2024-09-19T12:17:07.990Z |
5132971 | 5132971 | 20240916023810_2eWC2 | UK008W | 2024-09-19T12:16:39.685Z | 2024-09-19T12:16:39.685Z |
5132963 | 5132963 | 20240916023555_AybyK | UK008W | 2024-09-19T12:16:38.959Z | 2024-09-19T12:16:38.959Z |
5129772 | 5129772 | 20240917042607_3EGWz | UK008W | 2024-09-19T12:12:03.111Z | 2024-09-19T12:12:03.111Z |
5129749 | 5129749 | 20240917042512_YPcGy | UK008W | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129677 | 5129677 | 20240917042148_53vsL | UK008W | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5129409 | 5129409 | 20240917035457_VPmvh | UK008W | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5129130 | 5129130 | 20240917032432_DHV2X | UK008W | 2024-09-19T12:11:16.363Z | 2024-09-19T12:11:16.363Z |
5129105 | 5129105 | 20240917032028_UjnSk | UK008W | 2024-09-19T12:11:15.591Z | 2024-09-19T12:11:15.591Z |
5127566 | 5127566 | 20240916223002_KjcOd | UK008W | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127525 | 5127525 | 20240916221624_TycVy | UK008W | 2024-09-19T12:09:17.666Z | 2024-09-19T12:09:17.666Z |
5127503 | 5127503 | 20240916221249_AmGNp | UK008W | 2024-09-19T12:09:15.777Z | 2024-09-19T12:09:15.777Z |
5127348 | 5127348 | 20240916213453_e0EcN | UK008W | 2024-09-19T12:08:56.494Z | 2024-09-19T12:08:56.494Z |
5127281 | 5127281 | 20240916211259_3j3gG | UK008W | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5126977 | 5126977 | 20240916200135_rzLZ6 | UK008W | 2024-09-19T12:07:49.259Z | 2024-09-19T12:07:49.259Z |
5126896 | 5126896 | 20240916194827_mMq2i | UK008W | 2024-09-19T12:07:36.456Z | 2024-09-19T12:07:36.456Z |
5124886 | 5124886 | 20240917223523_WW6Ik | UK008W | 2024-09-19T12:01:44.005Z | 2024-09-19T12:06:41.946Z |
5124766 | 5124766 | 20240917215838_vwtSd | UK008W | 2024-09-19T12:01:33.138Z | 2024-09-19T12:06:41.932Z |
5124750 | 5124750 | 20240917215732_2fFnj | UK008W | 2024-09-19T12:01:32.185Z | 2024-09-19T12:06:41.931Z |
5124552 | 5124552 | 20240917210241_copaC | UK008W | 2024-09-19T12:01:07.254Z | 2024-09-19T12:06:41.909Z |
5124431 | 5124431 | 20240917201712_l3w1g | UK008W | 2024-09-19T12:00:52.109Z | 2024-09-19T12:06:41.894Z |
5124372 | 5124372 | 20240917194406_YeB2s | UK008W | 2024-09-19T12:00:40.906Z | 2024-09-19T12:06:41.884Z |
5124324 | 5124324 | 20240917193253_dDDn1 | UK008W | 2024-09-19T12:00:34.163Z | 2024-09-19T12:06:41.877Z |
5122033 | 5122033 | 20240914042820_mJEfX | UK008W | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121734 | 5121734 | 20240914041320_c1Do2 | UK008W | 2024-09-18T12:11:01.155Z | 2024-09-19T12:20:02.320Z |
5121662 | 5121662 | 20240914041155_QyLxn | UK008W | 2024-09-18T12:10:59.187Z | 2024-09-19T12:20:02.207Z |
5121542 | 5121542 | 20240914040819_3SGHu | UK008W | 2024-09-18T12:10:58.119Z | 2024-09-19T12:20:02.086Z |
5121372 | 5121372 | 20240914035907_7Yket | UK008W | 2024-09-18T12:10:54.714Z | 2024-09-19T12:20:01.706Z |
5121208 | 5121208 | 20240914035523_kP3a1 | UK008W | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.491Z |
5120820 | 5120820 | 20240914033552_fwlf5 | UK008W | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.904Z |
5120759 | 5120759 | 20240914033443_UEKyt | UK008W | 2024-09-18T12:10:46.591Z | 2024-09-19T12:20:00.853Z |
5117121 | 5117121 | 20240915040350_u04rH | UK008W | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5116958 | 5116958 | 20240915035119_yDVH0 | UK008W | 2024-09-18T12:07:26.631Z | 2024-09-19T12:19:12.813Z |
5116689 | 5116689 | 20240915033650_JsdV6 | UK008W | 2024-09-18T12:07:16.695Z | 2024-09-19T12:19:12.044Z |
5116598 | 5116598 | 20240915033247_BBCVw | UK008W | 2024-09-18T12:07:11.064Z | 2024-09-19T12:19:11.605Z |
5116402 | 5116402 | 20240915032506_4lBjC | UK008W | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5116237 | 5116237 | 20240915031713_QoefO | UK008W | 2024-09-18T12:06:50.278Z | 2024-09-19T12:19:09.929Z |
5115016 | 5115016 | 20240915021323_HVCtY | UK008W | 2024-09-18T12:05:50.974Z | 2024-09-19T12:19:01.144Z |
5114766 | 5114766 | 20240915015743_9K7A3 | UK008W | 2024-09-18T12:05:33.744Z | 2024-09-19T12:18:59.867Z |
5114511 | 5114511 | 20240915014454_RF4lc | UK008W | 2024-09-18T12:05:19.969Z | 2024-09-19T12:18:58.589Z |
5114319 | 5114319 | 20240915013637_urfjS | UK008W | 2024-09-18T12:05:10.561Z | 2024-09-19T12:18:57.540Z |
5114279 | 5114279 | 20240915013446_9wt2n | UK008W | 2024-09-18T12:05:09.195Z | 2024-09-19T12:18:57.346Z |
5114170 | 5114170 | 20240915013005_Ep2rP | UK008W | 2024-09-18T12:05:05.080Z | 2024-09-19T12:18:56.578Z |
5113814 | 5113814 | 20240915011405_FkSd0 | UK008W | 2024-09-18T12:04:51.278Z | 2024-09-19T12:18:52.849Z |
5113498 | 5113498 | 20240915005320_mrhzA | UK008W | 2024-09-18T12:04:24.896Z | 2024-09-19T12:18:49.754Z |
5111817 | 5111817 | 20240914211815_Ejih7 | UK008W | 2024-09-18T12:02:18.321Z | 2024-09-19T12:18:34.067Z |
5111652 | 5111652 | 20240914205827_EAv50 | UK008W | 2024-09-18T12:02:09.571Z | 2024-09-19T12:18:32.802Z |
5111508 | 5111508 | 20240914204302_3jFoI | UK008W | 2024-09-18T12:01:59.983Z | 2024-09-19T12:18:30.852Z |
5111244 | 5111244 | 20240914201405_GQTM7 | UK008W | 2024-09-18T12:01:44.912Z | 2024-09-19T12:18:28.007Z |
5108209 | 5108209 | 20240913043131_d3Xeq | UK008W | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5108184 | 5108184 | 20240913042938_Hctff | UK008W | 2024-09-17T12:13:32.106Z | 2024-09-19T12:20:47.910Z |
5108101 | 5108101 | 20240913042319_y99Cu | UK008W | 2024-09-17T12:13:30.489Z | 2024-09-19T12:20:47.844Z |
5108072 | 5108072 | 20240913042227_zWWmq | UK008W | 2024-09-17T12:13:30.150Z | 2024-09-19T12:20:47.834Z |
5107983 | 5107983 | 20240913041805_2A8dr | UK008W | 2024-09-17T12:13:26.713Z | 2024-09-19T12:20:47.707Z |
5107922 | 5107922 | 20240913041500_M9G1b | UK008W | 2024-09-17T12:13:25.945Z | 2024-09-19T12:20:47.637Z |
5107899 | 5107899 | 20240913041400_b8zTH | UK008W | 2024-09-17T12:13:25.508Z | 2024-09-19T12:20:47.630Z |
5107730 | 5107730 | 20240913040923_Amflw | UK008W | 2024-09-17T12:13:22.523Z | 2024-09-19T12:20:47.508Z |
5107565 | 5107565 | 20240913040104_HZK8i | UK008W | 2024-09-17T12:13:17.040Z | 2024-09-19T12:20:47.222Z |
5107367 | 5107367 | 20240913035328_kCWOY | UK008W | 2024-09-17T12:13:13.715Z | 2024-09-19T12:20:47.024Z |
5107084 | 5107084 | 20240913034428_WQOmY | UK008W | 2024-09-17T12:13:09.059Z | 2024-09-19T12:20:46.808Z |
5106710 | 5106710 | 20240913033244_xNwMk | UK008W | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5106170 | 5106170 | 20240913031346_MKCmT | UK008W | 2024-09-17T12:12:43.802Z | 2024-09-19T12:20:45.586Z |
5105955 | 5105955 | 20240913030350_8635I | UK008W | 2024-09-17T12:12:34.440Z | 2024-09-19T12:20:45.079Z |
5105679 | 5105679 | 20240913025456_vtBVi | UK008W | 2024-09-17T12:12:25.625Z | 2024-09-19T12:20:44.792Z |
5105458 | 5105458 | 20240913024659_qtqmu | UK008W | 2024-09-17T12:12:17.908Z | 2024-09-19T12:20:44.554Z |
5105441 | 5105441 | 20240913024615_M9Fb2 | UK008W | 2024-09-17T12:12:16.946Z | 2024-09-19T12:20:44.547Z |
5104973 | 5104973 | 20240913022502_GyngA | UK008W | 2024-09-17T12:11:47.864Z | 2024-09-19T12:20:43.200Z |
5104927 | 5104927 | 20240913022403_dPyMy | UK008W | 2024-09-17T12:11:46.679Z | 2024-09-19T12:20:43.117Z |
5104735 | 5104735 | 20240913021954_cot1K | UK008W | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5104626 | 5104626 | 20240913021743_J37Pr | UK008W | 2024-09-17T12:11:41.383Z | 2024-09-19T12:20:42.648Z |
5104448 | 5104448 | 20240913021014_RwRim | UK008W | 2024-09-17T12:11:35.522Z | 2024-09-19T12:20:41.482Z |
5104211 | 5104211 | 20240913015826_GtGD4 | UK008W | 2024-09-17T12:11:28.886Z | 2024-09-19T12:20:41.203Z |
5104197 | 5104197 | 20240913015826_egVkX | UK008W | 2024-09-17T12:11:28.831Z | 2024-09-19T12:20:41.199Z |
5104081 | 5104081 | 20240913015024_CbWxx | UK008W | 2024-09-17T12:11:24.196Z | 2024-09-19T12:20:40.948Z |
5103873 | 5103873 | 20240913014238_YhbsR | UK008W | 2024-09-17T12:11:14.493Z | 2024-09-19T12:20:40.639Z |
5103746 | 5103746 | 20240913013839_MgwIZ | UK008W | 2024-09-17T12:11:09.652Z | 2024-09-19T12:20:40.445Z |
5103698 | 5103698 | 20240913013553_ejHYY | UK008W | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5101120 | 5101120 | 20240914000512_hOC8P | UK008W | 2024-09-17T12:05:21.078Z | 2024-09-19T12:19:49.821Z |
5100984 | 5100984 | 20240913235534_dvXWJ | UK008W | 2024-09-17T12:05:13.182Z | 2024-09-19T12:19:49.465Z |
5100935 | 5100935 | 20240913235416_fY2kn | UK008W | 2024-09-17T12:05:11.374Z | 2024-09-19T12:19:49.338Z |
5100692 | 5100692 | 20240913234141_y3H1k | UK008W | 2024-09-17T12:04:49.115Z | 2024-09-19T12:19:48.530Z |
5100566 | 5100566 | 20240913233108_ZjsC2 | UK008W | 2024-09-17T12:04:38.941Z | 2024-09-19T12:19:48.124Z |
5100427 | 5100427 | 20240913232611_58xbS | UK008W | 2024-09-17T12:04:33.452Z | 2024-09-19T12:19:47.961Z |
5100412 | 5100412 | 20240913232608_kE3Yo | UK008W | 2024-09-17T12:04:33.087Z | 2024-09-19T12:19:47.957Z |
5100168 | 5100168 | 20240913225901_JMOgI | UK008W | 2024-09-17T12:04:05.388Z | 2024-09-19T12:19:47.061Z |
5100083 | 5100083 | 20240913224804_Kp6wh | UK008W | 2024-09-17T12:03:56.424Z | 2024-09-19T12:19:46.841Z |
5100031 | 5100031 | 20240913224217_qscD4 | UK008W | 2024-09-17T12:03:53.003Z | 2024-09-19T12:19:46.766Z |
5099958 | 5099958 | 20240913222709_wt2pr | UK008W | 2024-09-17T12:03:46.127Z | 2024-09-19T12:19:46.608Z |
5099765 | 5099765 | 20240913215446_pC8Ki | UK008W | 2024-09-17T12:03:33.101Z | 2024-09-19T12:19:45.838Z |
5099703 | 5099703 | 20240913214850_kavWR | UK008W | 2024-09-17T12:03:24.008Z | 2024-09-19T12:19:45.709Z |
5099549 | 5099549 | 20240913213618_kJYRA | UK008W | 2024-09-17T12:03:09.672Z | 2024-09-19T12:19:45.292Z |
5099294 | 5099294 | 20240913205605_cIAgm | UK008W | 2024-09-17T12:02:41.813Z | 2024-09-19T12:19:44.419Z |
5099257 | 5099257 | 20240913204713_UyM31 | UK008W | 2024-09-17T12:02:36.647Z | 2024-09-19T12:19:44.332Z |
5099207 | 5099207 | 20240913204036_z7OIc | UK008W | 2024-09-17T12:02:29.920Z | 2024-09-19T12:19:44.068Z |
5099060 | 5099060 | 20240913201627_86yyz | UK008W | 2024-09-17T12:02:15.703Z | 2024-09-19T12:19:43.245Z |
5099008 | 5099008 | 20240913200553_WCSls | UK008W | 2024-09-17T12:02:09.280Z | 2024-09-19T12:19:42.952Z |
5098927 | 5098927 | 20240913195806_juC8O | UK008W | 2024-09-17T12:02:01.027Z | 2024-09-19T12:19:42.687Z |
5098882 | 5098882 | 20240913195240_YlThI | UK008W | 2024-09-17T12:01:55.458Z | 2024-09-19T12:19:41.761Z |
5098231 | 5098231 | 20240913012243_5cvdD | UK008W | 2024-09-16T12:17:21.772Z | 2024-09-19T12:20:39.908Z |
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);