participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,681 rows where station_code = "UK000F" 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 |
---|---|---|---|---|---|
5135292 | 5135292 | 20240915020041_7PesS | UK000F | 2024-09-19T12:19:00.228Z | 2024-09-19T12:19:00.228Z |
5134060 | 5134060 | 20240916043818_grZ1z | UK000F | 2024-09-19T12:17:17.542Z | 2024-09-19T12:17:17.542Z |
5134020 | 5134020 | 20240916043241_NJB1J | UK000F | 2024-09-19T12:17:16.535Z | 2024-09-19T12:17:16.535Z |
5133996 | 5133996 | 20240916042843_lX3HC | UK000F | 2024-09-19T12:17:15.621Z | 2024-09-19T12:17:15.621Z |
5133882 | 5133882 | 20240916041354_76suw | UK000F | 2024-09-19T12:17:11.911Z | 2024-09-19T12:17:11.911Z |
5133710 | 5133710 | 20240916035225_gJ1M7 | UK000F | 2024-09-19T12:17:05.732Z | 2024-09-19T12:17:05.732Z |
5133497 | 5133497 | 20240916033352_DmaLk | UK000F | 2024-09-19T12:17:00.003Z | 2024-09-19T12:17:00.003Z |
5133415 | 5133415 | 20240916032947_7LIC4 | UK000F | 2024-09-19T12:16:56.221Z | 2024-09-19T12:16:56.221Z |
5133354 | 5133354 | 20240916032537_pPKM3 | UK000F | 2024-09-19T12:16:55.146Z | 2024-09-19T12:16:55.146Z |
5133236 | 5133236 | 20240916031216_Py6bX | UK000F | 2024-09-19T12:16:51.137Z | 2024-09-19T12:16:51.137Z |
5133139 | 5133139 | 20240916030148_31ILJ | UK000F | 2024-09-19T12:16:45.577Z | 2024-09-19T12:16:45.577Z |
5133083 | 5133083 | 20240916025101_HAzlq | UK000F | 2024-09-19T12:16:43.739Z | 2024-09-19T12:16:43.739Z |
5129558 | 5129558 | 20240917040937_mQ4zf | UK000F | 2024-09-19T12:11:49.201Z | 2024-09-19T12:11:49.201Z |
5129521 | 5129521 | 20240917040642_BTzLE | UK000F | 2024-09-19T12:11:46.966Z | 2024-09-19T12:11:46.966Z |
5129391 | 5129391 | 20240917035457_VPmvh | UK000F | 2024-09-19T12:11:34.640Z | 2024-09-19T12:11:34.640Z |
5129369 | 5129369 | 20240917035455_GRAvj | UK000F | 2024-09-19T12:11:34.191Z | 2024-09-19T12:11:34.191Z |
5129239 | 5129239 | 20240917033929_mjEu9 | UK000F | 2024-09-19T12:11:24.080Z | 2024-09-19T12:11:24.080Z |
5129210 | 5129210 | 20240917033757_CJFTp | UK000F | 2024-09-19T12:11:23.450Z | 2024-09-19T12:11:23.450Z |
5129057 | 5129057 | 20240917031357_oPadb | UK000F | 2024-09-19T12:11:13.301Z | 2024-09-19T12:11:13.301Z |
5129030 | 5129030 | 20240917030907_pfsp0 | UK000F | 2024-09-19T12:11:12.180Z | 2024-09-19T12:11:12.180Z |
5128991 | 5128991 | 20240917030403_9ogEu | UK000F | 2024-09-19T12:11:10.636Z | 2024-09-19T12:11:10.636Z |
5128853 | 5128853 | 20240917024843_8lfcr | UK000F | 2024-09-19T12:11:04.080Z | 2024-09-19T12:11:04.080Z |
5128762 | 5128762 | 20240917023353_Q01e3 | UK000F | 2024-09-19T12:11:00.559Z | 2024-09-19T12:11:00.559Z |
5128738 | 5128738 | 20240917023112_gpYjQ | UK000F | 2024-09-19T12:10:59.755Z | 2024-09-19T12:10:59.755Z |
5128694 | 5128694 | 20240917022511_pyqVJ | UK000F | 2024-09-19T12:10:57.561Z | 2024-09-19T12:10:57.561Z |
5128274 | 5128274 | 20240917011908_2z3iT | UK000F | 2024-09-19T12:10:24.218Z | 2024-09-19T12:10:24.218Z |
5128263 | 5128263 | 20240917011136_6GJGM | UK000F | 2024-09-19T12:10:22.338Z | 2024-09-19T12:10:22.338Z |
5128128 | 5128128 | 20240917004738_p3zvx | UK000F | 2024-09-19T12:10:08.468Z | 2024-09-19T12:10:08.468Z |
5128111 | 5128111 | 20240917004107_TUncZ | UK000F | 2024-09-19T12:10:04.804Z | 2024-09-19T12:10:04.804Z |
5128067 | 5128067 | 20240917003218_Yjok5 | UK000F | 2024-09-19T12:10:00.073Z | 2024-09-19T12:10:00.073Z |
5126836 | 5126836 | 20240916194111_2ToJM | UK000F | 2024-09-19T12:07:25.430Z | 2024-09-19T12:07:25.430Z |
5122060 | 5122060 | 20240914043057_QqBh3 | UK000F | 2024-09-18T12:11:05.320Z | 2024-09-19T12:20:02.721Z |
5121972 | 5121972 | 20240914042323_4l1UM | UK000F | 2024-09-18T12:11:03.681Z | 2024-09-19T12:20:02.557Z |
5121754 | 5121754 | 20240914041341_L2d8X | UK000F | 2024-09-18T12:11:01.176Z | 2024-09-19T12:20:02.364Z |
5121379 | 5121379 | 20240914035911_Tv6J3 | UK000F | 2024-09-18T12:10:54.723Z | 2024-09-19T12:20:01.708Z |
5121218 | 5121218 | 20240914035546_z4tKw | UK000F | 2024-09-18T12:10:52.471Z | 2024-09-19T12:20:01.494Z |
5121139 | 5121139 | 20240914035416_WO0B7 | UK000F | 2024-09-18T12:10:52.061Z | 2024-09-19T12:20:01.457Z |
5121033 | 5121033 | 20240914034858_xgy2e | UK000F | 2024-09-18T12:10:50.204Z | 2024-09-19T12:20:01.249Z |
5120951 | 5120951 | 20240914034301_pu1Yj | UK000F | 2024-09-18T12:10:48.930Z | 2024-09-19T12:20:01.080Z |
5120915 | 5120915 | 20240914034153_8i7I9 | UK000F | 2024-09-18T12:10:48.759Z | 2024-09-19T12:20:01.073Z |
5120868 | 5120868 | 20240914033901_qIFy3 | UK000F | 2024-09-18T12:10:48.259Z | 2024-09-19T12:20:00.980Z |
5120856 | 5120856 | 20240914033748_e0jyq | UK000F | 2024-09-18T12:10:47.980Z | 2024-09-19T12:20:00.942Z |
5120717 | 5120717 | 20240914033304_2dWFf | UK000F | 2024-09-18T12:10:46.215Z | 2024-09-19T12:20:00.801Z |
5120602 | 5120602 | 20240914032953_cRQIp | UK000F | 2024-09-18T12:10:43.633Z | 2024-09-19T12:20:00.629Z |
5120508 | 5120508 | 20240914032557_QEKEm | UK000F | 2024-09-18T12:10:42.495Z | 2024-09-19T12:20:00.512Z |
5120420 | 5120420 | 20240914032020_biyKl | UK000F | 2024-09-18T12:10:39.710Z | 2024-09-19T12:20:00.207Z |
5120272 | 5120272 | 20240914031126_YwtO2 | UK000F | 2024-09-18T12:10:36.601Z | 2024-09-19T12:19:59.847Z |
5120250 | 5120250 | 20240914031049_39oaf | UK000F | 2024-09-18T12:10:36.415Z | 2024-09-19T12:19:59.844Z |
5120245 | 5120245 | 20240914031028_LyZ62 | UK000F | 2024-09-18T12:10:36.364Z | 2024-09-19T12:19:59.816Z |
5119948 | 5119948 | 20240914025435_342zJ | UK000F | 2024-09-18T12:10:29.911Z | 2024-09-19T12:19:59.188Z |
5119917 | 5119917 | 20240914025341_z3AvP | UK000F | 2024-09-18T12:10:29.522Z | 2024-09-19T12:19:59.165Z |
5117048 | 5117048 | 20240915035814_CY30F | UK000F | 2024-09-18T12:07:30.917Z | 2024-09-19T12:19:13.191Z |
5116881 | 5116881 | 20240915034630_Wu231 | UK000F | 2024-09-18T12:07:24.414Z | 2024-09-19T12:19:12.587Z |
5116351 | 5116351 | 20240915032341_RXHs5 | UK000F | 2024-09-18T12:06:59.896Z | 2024-09-19T12:19:10.635Z |
5115964 | 5115964 | 20240915030149_3haUb | UK000F | 2024-09-18T12:06:32.859Z | 2024-09-19T12:19:08.005Z |
5115889 | 5115889 | 20240915025812_Re3Hl | UK000F | 2024-09-18T12:06:31.252Z | 2024-09-19T12:19:07.791Z |
5115882 | 5115882 | 20240915025807_UCeaq | UK000F | 2024-09-18T12:06:31.052Z | 2024-09-19T12:19:07.764Z |
5115791 | 5115791 | 20240915025401_fOiNa | UK000F | 2024-09-18T12:06:24.113Z | 2024-09-19T12:19:07.364Z |
5115599 | 5115599 | 20240915024537_rYGdT | UK000F | 2024-09-18T12:06:18.701Z | 2024-09-19T12:19:05.603Z |
5115555 | 5115555 | 20240915024434_7N2Sy | UK000F | 2024-09-18T12:06:17.830Z | 2024-09-19T12:19:05.366Z |
5115349 | 5115349 | 20240915023445_i6H0A | UK000F | 2024-09-18T12:06:11.730Z | 2024-09-19T12:19:04.065Z |
5115310 | 5115310 | 20240915023131_Iwwwa | UK000F | 2024-09-18T12:06:10.554Z | 2024-09-19T12:19:03.871Z |
5115055 | 5115055 | 20240915021611_mquuu | UK000F | 2024-09-18T12:05:54.952Z | 2024-09-19T12:19:01.285Z |
5115032 | 5115032 | 20240915021449_91apG | UK000F | 2024-09-18T12:05:51.494Z | 2024-09-19T12:19:01.184Z |
5114903 | 5114903 | 20240915020728_oTTLb | UK000F | 2024-09-18T12:05:40.724Z | 2024-09-19T12:19:00.556Z |
5114870 | 5114870 | 20240915020208_wRoJF | UK000F | 2024-09-18T12:05:38.781Z | 2024-09-19T12:19:00.424Z |
5114738 | 5114738 | 20240915015716_MKkOP | UK000F | 2024-09-18T12:05:32.359Z | 2024-09-19T12:18:59.682Z |
5114665 | 5114665 | 20240915015324_Xb4qe | UK000F | 2024-09-18T12:05:28.076Z | 2024-09-19T12:18:59.202Z |
5114615 | 5114615 | 20240915015225_PAl02 | UK000F | 2024-09-18T12:05:25.858Z | 2024-09-19T12:18:59.081Z |
5114484 | 5114484 | 20240915014441_aDP0R | UK000F | 2024-09-18T12:05:19.775Z | 2024-09-19T12:18:58.558Z |
5114476 | 5114476 | 20240915014416_24AY3 | UK000F | 2024-09-18T12:05:19.499Z | 2024-09-19T12:18:58.488Z |
5114394 | 5114394 | 20240915014101_hZoLI | UK000F | 2024-09-18T12:05:14.305Z | 2024-09-19T12:18:57.938Z |
5114195 | 5114195 | 20240915013034_k8F25 | UK000F | 2024-09-18T12:05:06.105Z | 2024-09-19T12:18:56.697Z |
5114119 | 5114119 | 20240915012759_VBJvG | UK000F | 2024-09-18T12:05:03.190Z | 2024-09-19T12:18:56.189Z |
5113947 | 5113947 | 20240915012055_C0WRs | UK000F | 2024-09-18T12:04:56.236Z | 2024-09-19T12:18:54.703Z |
5113752 | 5113752 | 20240915011105_IiwPt | UK000F | 2024-09-18T12:04:49.297Z | 2024-09-19T12:18:51.854Z |
5113713 | 5113713 | 20240915010850_9SAIe | UK000F | 2024-09-18T12:04:46.143Z | 2024-09-19T12:18:51.778Z |
5113658 | 5113658 | 20240915010325_7Z2ze | UK000F | 2024-09-18T12:04:37.703Z | 2024-09-19T12:18:50.909Z |
5113629 | 5113629 | 20240915010131_ao2gb | UK000F | 2024-09-18T12:04:35.807Z | 2024-09-19T12:18:50.699Z |
5113609 | 5113609 | 20240915010050_dCSql | UK000F | 2024-09-18T12:04:35.194Z | 2024-09-19T12:18:50.617Z |
5113240 | 5113240 | 20240915003259_1dwE3 | UK000F | 2024-09-18T12:04:04.682Z | 2024-09-19T12:18:48.268Z |
5113175 | 5113175 | 20240915002938_qXRQf | UK000F | 2024-09-18T12:04:01.170Z | 2024-09-19T12:18:47.819Z |
5113061 | 5113061 | 20240915001744_aeo2B | UK000F | 2024-09-18T12:03:53.863Z | 2024-09-19T12:18:46.795Z |
5112969 | 5112969 | 20240915001109_JKPUo | UK000F | 2024-09-18T12:03:49.881Z | 2024-09-19T12:18:46.235Z |
5112948 | 5112948 | 20240915001108_I3lqt | UK000F | 2024-09-18T12:03:49.751Z | 2024-09-19T12:18:46.054Z |
5112881 | 5112881 | 20240915000407_OizCB | UK000F | 2024-09-18T12:03:45.403Z | 2024-09-19T12:18:45.518Z |
5112701 | 5112701 | 20240914234322_MWFvM | UK000F | 2024-09-18T12:03:23.319Z | 2024-09-19T12:18:43.541Z |
5112523 | 5112523 | 20240914232550_H2UbD | UK000F | 2024-09-18T12:03:12.196Z | 2024-09-19T12:18:41.275Z |
5112489 | 5112489 | 20240914232111_dupQg | UK000F | 2024-09-18T12:03:10.669Z | 2024-09-19T12:18:41.164Z |
5112329 | 5112329 | 20240914225935_jTITy | UK000F | 2024-09-18T12:03:00.363Z | 2024-09-19T12:18:40.597Z |
5112197 | 5112197 | 20240914223551_aQkt1 | UK000F | 2024-09-18T12:02:53.061Z | 2024-09-19T12:18:39.214Z |
5112096 | 5112096 | 20240914221423_sct88 | UK000F | 2024-09-18T12:02:47.713Z | 2024-09-19T12:18:38.285Z |
5111856 | 5111856 | 20240914212428_4dPyF | UK000F | 2024-09-18T12:02:23.058Z | 2024-09-19T12:18:34.673Z |
5111796 | 5111796 | 20240914211716_PHIJa | UK000F | 2024-09-18T12:02:18.042Z | 2024-09-19T12:18:34.062Z |
5111735 | 5111735 | 20240914211135_QpvFq | UK000F | 2024-09-18T12:02:14.754Z | 2024-09-19T12:18:33.764Z |
5111677 | 5111677 | 20240914210048_MwtEp | UK000F | 2024-09-18T12:02:10.979Z | 2024-09-19T12:18:33.105Z |
5110390 | 5110390 | 20240912005432_biXB9 | UK000F | 2024-09-17T12:16:34.400Z | 2024-09-19T12:21:10.217Z |
5108228 | 5108228 | 20240913043451_k8AFK | UK000F | 2024-09-17T12:13:33.609Z | 2024-09-19T12:20:47.959Z |
5108143 | 5108143 | 20240913042645_M2B6h | UK000F | 2024-09-17T12:13:31.473Z | 2024-09-19T12:20:47.868Z |
5108008 | 5108008 | 20240913042031_D9G3s | UK000F | 2024-09-17T12:13:28.326Z | 2024-09-19T12:20:47.751Z |
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);