participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,761 rows where station_code = "UK007A" 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 |
---|---|---|---|---|---|
5135316 | 5135316 | 20240915040245_zGMqY | UK007A | 2024-09-19T12:19:13.340Z | 2024-09-19T12:19:13.340Z |
5129825 | 5129825 | 20240917043803_3TXdS | UK007A | 2024-09-19T12:12:07.586Z | 2024-09-19T12:12:07.586Z |
5129745 | 5129745 | 20240917042512_YPcGy | UK007A | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129719 | 5129719 | 20240917042446_4c0yQ | UK007A | 2024-09-19T12:12:02.430Z | 2024-09-19T12:12:02.430Z |
5129674 | 5129674 | 20240917042148_53vsL | UK007A | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5129658 | 5129658 | 20240917042119_UWnWe | UK007A | 2024-09-19T12:12:00.121Z | 2024-09-19T12:12:00.121Z |
5129544 | 5129544 | 20240917040919_MPPVs | UK007A | 2024-09-19T12:11:48.640Z | 2024-09-19T12:11:48.640Z |
5129297 | 5129297 | 20240917034630_6Zgnr | UK007A | 2024-09-19T12:11:26.313Z | 2024-09-19T12:11:26.313Z |
5129127 | 5129127 | 20240917032432_DHV2X | UK007A | 2024-09-19T12:11:16.363Z | 2024-09-19T12:11:16.363Z |
5129035 | 5129035 | 20240917031052_3eyt5 | UK007A | 2024-09-19T12:11:12.365Z | 2024-09-19T12:11:12.365Z |
5129008 | 5129008 | 20240917030739_7PbCu | UK007A | 2024-09-19T12:11:11.355Z | 2024-09-19T12:11:11.355Z |
5128929 | 5128929 | 20240917025710_dO20e | UK007A | 2024-09-19T12:11:07.994Z | 2024-09-19T12:11:07.994Z |
5128844 | 5128844 | 20240917024630_D3PSk | UK007A | 2024-09-19T12:11:03.605Z | 2024-09-19T12:11:03.605Z |
5128818 | 5128818 | 20240917024456_2qPrg | UK007A | 2024-09-19T12:11:03.169Z | 2024-09-19T12:11:03.169Z |
5128556 | 5128556 | 20240917020349_oJXd2 | UK007A | 2024-09-19T12:10:43.531Z | 2024-09-19T12:10:43.531Z |
5128509 | 5128509 | 20240917015304_yIYF4 | UK007A | 2024-09-19T12:10:40.227Z | 2024-09-19T12:10:40.227Z |
5128433 | 5128433 | 20240917014244_XuzZ7 | UK007A | 2024-09-19T12:10:34.656Z | 2024-09-19T12:10:34.656Z |
5128419 | 5128419 | 20240917014109_8t1tx | UK007A | 2024-09-19T12:10:33.760Z | 2024-09-19T12:10:33.760Z |
5128361 | 5128361 | 20240917013113_7lp2l | UK007A | 2024-09-19T12:10:29.052Z | 2024-09-19T12:10:29.052Z |
5128298 | 5128298 | 20240917012201_PHVbY | UK007A | 2024-09-19T12:10:25.679Z | 2024-09-19T12:10:25.679Z |
5128248 | 5128248 | 20240917010944_y4nji | UK007A | 2024-09-19T12:10:21.932Z | 2024-09-19T12:10:21.932Z |
5128208 | 5128208 | 20240917010746_jVw0C | UK007A | 2024-09-19T12:10:20.295Z | 2024-09-19T12:10:20.295Z |
5128188 | 5128188 | 20240917010457_029vC | UK007A | 2024-09-19T12:10:19.784Z | 2024-09-19T12:10:19.784Z |
5128093 | 5128093 | 20240917003554_INf3N | UK007A | 2024-09-19T12:10:03.475Z | 2024-09-19T12:10:03.475Z |
5127909 | 5127909 | 20240917000505_sC3Ql | UK007A | 2024-09-19T12:09:46.714Z | 2024-09-19T12:09:46.714Z |
5127875 | 5127875 | 20240916235705_EtZUI | UK007A | 2024-09-19T12:09:44.967Z | 2024-09-19T12:09:44.967Z |
5127562 | 5127562 | 20240916223002_KjcOd | UK007A | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127252 | 5127252 | 20240916210951_JbHKt | UK007A | 2024-09-19T12:08:42.565Z | 2024-09-19T12:08:42.565Z |
5127082 | 5127082 | 20240916202246_g6ZuL | UK007A | 2024-09-19T12:08:08.613Z | 2024-09-19T12:08:08.613Z |
5125920 | 5125920 | 20240918043925_rap85 | UK007A | 2024-09-19T12:04:33.537Z | 2024-09-19T12:06:42.108Z |
5125869 | 5125869 | 20240918041523_am1gg | UK007A | 2024-09-19T12:04:24.052Z | 2024-09-19T12:06:42.098Z |
5125784 | 5125784 | 20240918035341_It3F4 | UK007A | 2024-09-19T12:04:05.432Z | 2024-09-19T12:06:42.085Z |
5125189 | 5125189 | 20240918010252_vASFr | UK007A | 2024-09-19T12:02:28.600Z | 2024-09-19T12:06:41.989Z |
5125043 | 5125043 | 20240917234923_b4Xu6 | UK007A | 2024-09-19T12:02:01.460Z | 2024-09-19T12:06:41.966Z |
5124856 | 5124856 | 20240917222213_yHrjk | UK007A | 2024-09-19T12:01:41.214Z | 2024-09-19T12:06:41.943Z |
5124626 | 5124626 | 20240917213921_D2aqM | UK007A | 2024-09-19T12:01:14.480Z | 2024-09-19T12:06:41.919Z |
5124309 | 5124309 | 20240917193202_z7Uzq | UK007A | 2024-09-19T12:00:31.965Z | 2024-09-19T12:06:41.875Z |
5122136 | 5122136 | 20240914043824_gRWOa | UK007A | 2024-09-18T12:11:07.612Z | 2024-09-19T12:20:02.863Z |
5121660 | 5121660 | 20240914041155_QyLxn | UK007A | 2024-09-18T12:10:59.187Z | 2024-09-19T12:20:02.207Z |
5121629 | 5121629 | 20240914041042_HtKAC | UK007A | 2024-09-18T12:10:58.923Z | 2024-09-19T12:20:02.186Z |
5121370 | 5121370 | 20240914035907_7Yket | UK007A | 2024-09-18T12:10:54.714Z | 2024-09-19T12:20:01.706Z |
5120816 | 5120816 | 20240914033552_fwlf5 | UK007A | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.903Z |
5120755 | 5120755 | 20240914033443_UEKyt | UK007A | 2024-09-18T12:10:46.590Z | 2024-09-19T12:20:00.852Z |
5120625 | 5120625 | 20240914033018_Ulnqj | UK007A | 2024-09-18T12:10:43.874Z | 2024-09-19T12:20:00.633Z |
5120434 | 5120434 | 20240914032021_0w0mb | UK007A | 2024-09-18T12:10:39.801Z | 2024-09-19T12:20:00.207Z |
5120288 | 5120288 | 20240914031222_xXJ8R | UK007A | 2024-09-18T12:10:36.715Z | 2024-09-19T12:19:59.849Z |
5120118 | 5120118 | 20240914030045_kaNSo | UK007A | 2024-09-18T12:10:32.247Z | 2024-09-19T12:19:59.457Z |
5119988 | 5119988 | 20240914025549_LzwIX | UK007A | 2024-09-18T12:10:30.708Z | 2024-09-19T12:19:59.252Z |
5119980 | 5119980 | 20240914025549_J0nJG | UK007A | 2024-09-18T12:10:30.653Z | 2024-09-19T12:19:59.216Z |
5119851 | 5119851 | 20240914025107_tYCQn | UK007A | 2024-09-18T12:10:28.236Z | 2024-09-19T12:19:59.028Z |
5119795 | 5119795 | 20240914025011_1QKB8 | UK007A | 2024-09-18T12:10:27.160Z | 2024-09-19T12:19:58.956Z |
5119630 | 5119630 | 20240914024041_hBkgB | UK007A | 2024-09-18T12:10:22.791Z | 2024-09-19T12:19:58.602Z |
5119500 | 5119500 | 20240914023634_WcZAw | UK007A | 2024-09-18T12:10:21.785Z | 2024-09-19T12:19:58.392Z |
5119483 | 5119483 | 20240914023613_JmUeA | UK007A | 2024-09-18T12:10:21.620Z | 2024-09-19T12:19:58.335Z |
5119290 | 5119290 | 20240914022153_PDykK | UK007A | 2024-09-18T12:10:19.550Z | 2024-09-19T12:19:57.632Z |
5117118 | 5117118 | 20240915040350_u04rH | UK007A | 2024-09-18T12:07:33.119Z | 2024-09-19T12:19:13.449Z |
5116998 | 5116998 | 20240915035520_RrWza | UK007A | 2024-09-18T12:07:28.025Z | 2024-09-19T12:19:12.990Z |
5116843 | 5116843 | 20240915034432_PyZhQ | UK007A | 2024-09-18T12:07:22.646Z | 2024-09-19T12:19:12.458Z |
5116594 | 5116594 | 20240915033247_BBCVw | UK007A | 2024-09-18T12:07:11.063Z | 2024-09-19T12:19:11.605Z |
5116397 | 5116397 | 20240915032506_4lBjC | UK007A | 2024-09-18T12:07:01.120Z | 2024-09-19T12:19:11.089Z |
5114166 | 5114166 | 20240915013005_Ep2rP | UK007A | 2024-09-18T12:05:05.080Z | 2024-09-19T12:18:56.578Z |
5113810 | 5113810 | 20240915011405_FkSd0 | UK007A | 2024-09-18T12:04:51.278Z | 2024-09-19T12:18:52.849Z |
5113738 | 5113738 | 20240915011104_fXah3 | UK007A | 2024-09-18T12:04:48.698Z | 2024-09-19T12:18:51.810Z |
5113422 | 5113422 | 20240915004805_b42ud | UK007A | 2024-09-18T12:04:16.007Z | 2024-09-19T12:18:49.004Z |
5112926 | 5112926 | 20240915000653_3UA7I | UK007A | 2024-09-18T12:03:47.607Z | 2024-09-19T12:18:45.881Z |
5112571 | 5112571 | 20240914233020_Bsvf4 | UK007A | 2024-09-18T12:03:15.244Z | 2024-09-19T12:18:41.498Z |
5112351 | 5112351 | 20240914230410_KjigL | UK007A | 2024-09-18T12:03:00.974Z | 2024-09-19T12:18:40.686Z |
5112156 | 5112156 | 20240914222722_efnwZ | UK007A | 2024-09-18T12:02:50.578Z | 2024-09-19T12:18:38.786Z |
5111813 | 5111813 | 20240914211815_Ejih7 | UK007A | 2024-09-18T12:02:18.315Z | 2024-09-19T12:18:34.067Z |
5111769 | 5111769 | 20240914211540_3Jfn3 | UK007A | 2024-09-18T12:02:16.119Z | 2024-09-19T12:18:33.917Z |
5111761 | 5111761 | 20240914211445_VIcM7 | UK007A | 2024-09-18T12:02:15.842Z | 2024-09-19T12:18:33.909Z |
5111650 | 5111650 | 20240914205827_EAv50 | UK007A | 2024-09-18T12:02:09.571Z | 2024-09-19T12:18:32.802Z |
5111634 | 5111634 | 20240914205731_4w1Kg | UK007A | 2024-09-18T12:02:08.807Z | 2024-09-19T12:18:32.642Z |
5111506 | 5111506 | 20240914204302_3jFoI | UK007A | 2024-09-18T12:01:59.972Z | 2024-09-19T12:18:30.852Z |
5108274 | 5108274 | 20240913043838_875oU | UK007A | 2024-09-17T12:13:34.586Z | 2024-09-19T12:20:47.991Z |
5108237 | 5108237 | 20240913043505_Rm5vC | UK007A | 2024-09-17T12:13:33.708Z | 2024-09-19T12:20:47.964Z |
5107942 | 5107942 | 20240913041517_xTvtL | UK007A | 2024-09-17T12:13:26.077Z | 2024-09-19T12:20:47.639Z |
5107509 | 5107509 | 20240913035831_fqGqQ | UK007A | 2024-09-17T12:13:16.408Z | 2024-09-19T12:20:47.195Z |
5107365 | 5107365 | 20240913035328_kCWOY | UK007A | 2024-09-17T12:13:13.715Z | 2024-09-19T12:20:47.024Z |
5107080 | 5107080 | 20240913034428_WQOmY | UK007A | 2024-09-17T12:13:09.059Z | 2024-09-19T12:20:46.808Z |
5106935 | 5106935 | 20240913033909_P0dHA | UK007A | 2024-09-17T12:13:04.334Z | 2024-09-19T12:20:46.587Z |
5106706 | 5106706 | 20240913033244_xNwMk | UK007A | 2024-09-17T12:12:59.797Z | 2024-09-19T12:20:46.295Z |
5106640 | 5106640 | 20240913033129_1gPB2 | UK007A | 2024-09-17T12:12:58.663Z | 2024-09-19T12:20:46.219Z |
5106549 | 5106549 | 20240913032846_X30ef | UK007A | 2024-09-17T12:12:57.187Z | 2024-09-19T12:20:46.174Z |
5106216 | 5106216 | 20240913031545_H3ROi | UK007A | 2024-09-17T12:12:45.166Z | 2024-09-19T12:20:45.669Z |
5105455 | 5105455 | 20240913024659_qtqmu | UK007A | 2024-09-17T12:12:17.908Z | 2024-09-19T12:20:44.554Z |
5104970 | 5104970 | 20240913022502_GyngA | UK007A | 2024-09-17T12:11:47.864Z | 2024-09-19T12:20:43.200Z |
5104868 | 5104868 | 20240913022207_0Ph2X | UK007A | 2024-09-17T12:11:45.646Z | 2024-09-19T12:20:43.071Z |
5104656 | 5104656 | 20240913021814_1HhV8 | UK007A | 2024-09-17T12:11:41.919Z | 2024-09-19T12:20:42.659Z |
5104444 | 5104444 | 20240913021014_RwRim | UK007A | 2024-09-17T12:11:35.522Z | 2024-09-19T12:20:41.481Z |
5104343 | 5104343 | 20240913020545_oMvux | UK007A | 2024-09-17T12:11:33.793Z | 2024-09-19T12:20:41.419Z |
5103960 | 5103960 | 20240913014540_yI5mU | UK007A | 2024-09-17T12:11:20.429Z | 2024-09-19T12:20:40.687Z |
5103892 | 5103892 | 20240913014314_Wl639 | UK007A | 2024-09-17T12:11:15.929Z | 2024-09-19T12:20:40.660Z |
5103691 | 5103691 | 20240913013553_ejHYY | UK007A | 2024-09-17T12:11:07.997Z | 2024-09-19T12:20:40.422Z |
5103630 | 5103630 | 20240913013439_UNbp7 | UK007A | 2024-09-17T12:11:06.422Z | 2024-09-19T12:20:40.386Z |
5103175 | 5103175 | 20240914020340_xw8Hd | UK007A | 2024-09-17T12:07:55.401Z | 2024-09-19T12:19:56.762Z |
5103105 | 5103105 | 20240914020054_tC3Lw | UK007A | 2024-09-17T12:07:51.888Z | 2024-09-19T12:19:56.625Z |
5103004 | 5103004 | 20240914015702_iHLvl | UK007A | 2024-09-17T12:07:46.811Z | 2024-09-19T12:19:56.322Z |
5102759 | 5102759 | 20240914014252_kwAp7 | UK007A | 2024-09-17T12:07:35.328Z | 2024-09-19T12:19:55.593Z |
5102604 | 5102604 | 20240914013331_iQU2G | UK007A | 2024-09-17T12:07:27.439Z | 2024-09-19T12:19:55.207Z |
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);