participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,808 rows where station_code = "UK0051" 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 |
---|---|---|---|---|---|
5129741 | 5129741 | 20240917042512_YPcGy | UK0051 | 2024-09-19T12:12:02.895Z | 2024-09-19T12:12:02.895Z |
5129670 | 5129670 | 20240917042148_53vsL | UK0051 | 2024-09-19T12:12:00.538Z | 2024-09-19T12:12:00.538Z |
5129656 | 5129656 | 20240917042119_UWnWe | UK0051 | 2024-09-19T12:12:00.121Z | 2024-09-19T12:12:00.121Z |
5129089 | 5129089 | 20240917031639_QyoyQ | UK0051 | 2024-09-19T12:11:14.863Z | 2024-09-19T12:11:14.863Z |
5128714 | 5128714 | 20240917022549_evHQW | UK0051 | 2024-09-19T12:10:58.659Z | 2024-09-19T12:10:58.659Z |
5128629 | 5128629 | 20240917021354_A0UF5 | UK0051 | 2024-09-19T12:10:48.622Z | 2024-09-19T12:10:48.622Z |
5128555 | 5128555 | 20240917020349_oJXd2 | UK0051 | 2024-09-19T12:10:43.531Z | 2024-09-19T12:10:43.531Z |
5128543 | 5128543 | 20240917020203_RMJQx | UK0051 | 2024-09-19T12:10:42.939Z | 2024-09-19T12:10:42.939Z |
5128526 | 5128526 | 20240917015702_3nlrT | UK0051 | 2024-09-19T12:10:40.879Z | 2024-09-19T12:10:40.879Z |
5128326 | 5128326 | 20240917012654_Qx01F | UK0051 | 2024-09-19T12:10:27.199Z | 2024-09-19T12:10:27.199Z |
5128246 | 5128246 | 20240917010944_y4nji | UK0051 | 2024-09-19T12:10:21.932Z | 2024-09-19T12:10:21.932Z |
5128104 | 5128104 | 20240917003928_qdP9l | UK0051 | 2024-09-19T12:10:04.093Z | 2024-09-19T12:10:04.093Z |
5128092 | 5128092 | 20240917003554_INf3N | UK0051 | 2024-09-19T12:10:03.475Z | 2024-09-19T12:10:03.475Z |
5127874 | 5127874 | 20240916235705_EtZUI | UK0051 | 2024-09-19T12:09:44.967Z | 2024-09-19T12:09:44.967Z |
5127560 | 5127560 | 20240916223002_KjcOd | UK0051 | 2024-09-19T12:09:23.927Z | 2024-09-19T12:09:23.927Z |
5127346 | 5127346 | 20240916213354_3yP4j | UK0051 | 2024-09-19T12:08:55.743Z | 2024-09-19T12:08:55.743Z |
5127277 | 5127277 | 20240916211259_3j3gG | UK0051 | 2024-09-19T12:08:47.030Z | 2024-09-19T12:08:47.030Z |
5125212 | 5125212 | 20240918011448_OnRyF | UK0051 | 2024-09-19T12:02:30.768Z | 2024-09-19T12:06:41.992Z |
5125200 | 5125200 | 20240918010720_l2P9y | UK0051 | 2024-09-19T12:02:29.651Z | 2024-09-19T12:06:41.991Z |
5125188 | 5125188 | 20240918010252_vASFr | UK0051 | 2024-09-19T12:02:28.600Z | 2024-09-19T12:06:41.989Z |
5125169 | 5125169 | 20240918004938_2YsqP | UK0051 | 2024-09-19T12:02:26.251Z | 2024-09-19T12:06:41.986Z |
5125037 | 5125037 | 20240917234219_BSIKX | UK0051 | 2024-09-19T12:01:59.611Z | 2024-09-19T12:06:41.965Z |
5124997 | 5124997 | 20240917232107_yIlo3 | UK0051 | 2024-09-19T12:01:55.280Z | 2024-09-19T12:06:41.960Z |
5122175 | 5122175 | 20240914044427_G92Nh | UK0051 | 2024-09-18T12:11:08.491Z | 2024-09-19T12:20:02.923Z |
5122134 | 5122134 | 20240914043824_gRWOa | UK0051 | 2024-09-18T12:11:07.612Z | 2024-09-19T12:20:02.863Z |
5122055 | 5122055 | 20240914043056_0sCUs | UK0051 | 2024-09-18T12:11:05.224Z | 2024-09-19T12:20:02.721Z |
5122026 | 5122026 | 20240914042820_mJEfX | UK0051 | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121905 | 5121905 | 20240914042049_SgPXm | UK0051 | 2024-09-18T12:11:02.850Z | 2024-09-19T12:20:02.484Z |
5121495 | 5121495 | 20240914040540_G0D6K | UK0051 | 2024-09-18T12:10:57.449Z | 2024-09-19T12:20:01.994Z |
5121056 | 5121056 | 20240914034954_3WsOm | UK0051 | 2024-09-18T12:10:50.328Z | 2024-09-19T12:20:01.269Z |
5120813 | 5120813 | 20240914033552_fwlf5 | UK0051 | 2024-09-18T12:10:47.149Z | 2024-09-19T12:20:00.903Z |
5119987 | 5119987 | 20240914025549_LzwIX | UK0051 | 2024-09-18T12:10:30.708Z | 2024-09-19T12:19:59.252Z |
5119979 | 5119979 | 20240914025549_J0nJG | UK0051 | 2024-09-18T12:10:30.653Z | 2024-09-19T12:19:59.216Z |
5119867 | 5119867 | 20240914025122_ie63A | UK0051 | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5119628 | 5119628 | 20240914024041_hBkgB | UK0051 | 2024-09-18T12:10:22.791Z | 2024-09-19T12:19:58.602Z |
5119316 | 5119316 | 20240914022258_gF0ug | UK0051 | 2024-09-18T12:10:19.875Z | 2024-09-19T12:19:57.916Z |
5116711 | 5116711 | 20240915033724_p3md7 | UK0051 | 2024-09-18T12:07:17.601Z | 2024-09-19T12:19:12.115Z |
5115948 | 5115948 | 20240915030121_uw3zb | UK0051 | 2024-09-18T12:06:32.482Z | 2024-09-19T12:19:07.960Z |
5115717 | 5115717 | 20240915025047_8SkHQ | UK0051 | 2024-09-18T12:06:22.018Z | 2024-09-19T12:19:06.513Z |
5115581 | 5115581 | 20240915024448_01C53 | UK0051 | 2024-09-18T12:06:17.979Z | 2024-09-19T12:19:05.370Z |
5115009 | 5115009 | 20240915021323_HVCtY | UK0051 | 2024-09-18T12:05:50.974Z | 2024-09-19T12:19:01.144Z |
5114997 | 5114997 | 20240915021309_nvDxB | UK0051 | 2024-09-18T12:05:50.408Z | 2024-09-19T12:19:01.113Z |
5114315 | 5114315 | 20240915013637_urfjS | UK0051 | 2024-09-18T12:05:10.561Z | 2024-09-19T12:18:57.540Z |
5112509 | 5112509 | 20240914232405_qfREx | UK0051 | 2024-09-18T12:03:11.117Z | 2024-09-19T12:18:41.212Z |
5112224 | 5112224 | 20240914223819_rd33g | UK0051 | 2024-09-18T12:02:54.246Z | 2024-09-19T12:18:39.837Z |
5111878 | 5111878 | 20240914213012_Wk3ui | UK0051 | 2024-09-18T12:02:28.267Z | 2024-09-19T12:18:34.845Z |
5111811 | 5111811 | 20240914211815_Ejih7 | UK0051 | 2024-09-18T12:02:18.313Z | 2024-09-19T12:18:34.067Z |
5111768 | 5111768 | 20240914211540_3Jfn3 | UK0051 | 2024-09-18T12:02:16.119Z | 2024-09-19T12:18:33.917Z |
5111633 | 5111633 | 20240914205731_4w1Kg | UK0051 | 2024-09-18T12:02:08.795Z | 2024-09-19T12:18:32.642Z |
5108272 | 5108272 | 20240913043838_875oU | UK0051 | 2024-09-17T12:13:34.586Z | 2024-09-19T12:20:47.991Z |
5108206 | 5108206 | 20240913043131_d3Xeq | UK0051 | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5107890 | 5107890 | 20240913041400_b8zTH | UK0051 | 2024-09-17T12:13:25.507Z | 2024-09-19T12:20:47.630Z |
5107726 | 5107726 | 20240913040923_Amflw | UK0051 | 2024-09-17T12:13:22.523Z | 2024-09-19T12:20:47.508Z |
5107607 | 5107607 | 20240913040428_u8c5x | UK0051 | 2024-09-17T12:13:18.887Z | 2024-09-19T12:20:47.330Z |
5107076 | 5107076 | 20240913034428_WQOmY | UK0051 | 2024-09-17T12:13:09.059Z | 2024-09-19T12:20:46.808Z |
5106522 | 5106522 | 20240913032845_3pQuD | UK0051 | 2024-09-17T12:12:57.084Z | 2024-09-19T12:20:46.172Z |
5103358 | 5103358 | 20240913012913_Dd5no | UK0051 | 2024-09-17T12:10:55.186Z | 2024-09-19T12:20:40.114Z |
5103325 | 5103325 | 20240913012623_wUh5U | UK0051 | 2024-09-17T12:10:50.949Z | 2024-09-19T12:20:40.028Z |
5103207 | 5103207 | 20240914020443_Pypv7 | UK0051 | 2024-09-17T12:07:58.362Z | 2024-09-19T12:19:56.888Z |
5102598 | 5102598 | 20240914013253_UzSYf | UK0051 | 2024-09-17T12:07:27.172Z | 2024-09-19T12:19:55.188Z |
5102192 | 5102192 | 20240914011203_25q6r | UK0051 | 2024-09-17T12:06:54.139Z | 2024-09-19T12:19:52.730Z |
5102146 | 5102146 | 20240914010716_DiQCX | UK0051 | 2024-09-17T12:06:50.484Z | 2024-09-19T12:19:52.532Z |
5100977 | 5100977 | 20240913235534_dvXWJ | UK0051 | 2024-09-17T12:05:13.182Z | 2024-09-19T12:19:49.465Z |
5100661 | 5100661 | 20240913234010_uXGd9 | UK0051 | 2024-09-17T12:04:47.988Z | 2024-09-19T12:19:48.440Z |
5100594 | 5100594 | 20240913233326_ipYGh | UK0051 | 2024-09-17T12:04:40.362Z | 2024-09-19T12:19:48.168Z |
5099762 | 5099762 | 20240913215446_pC8Ki | UK0051 | 2024-09-17T12:03:33.072Z | 2024-09-19T12:19:45.838Z |
5098117 | 5098117 | 20240913011906_oVg3e | UK0051 | 2024-09-16T12:17:19.616Z | 2024-09-19T12:20:39.691Z |
5097989 | 5097989 | 20240913011136_PNAJB | UK0051 | 2024-09-16T12:17:17.819Z | 2024-09-19T12:20:39.312Z |
5097819 | 5097819 | 20240913010511_PskUa | UK0051 | 2024-09-16T12:17:15.284Z | 2024-09-19T12:20:39.040Z |
5097276 | 5097276 | 20240913003832_Ye3ds | UK0051 | 2024-09-16T12:17:09.387Z | 2024-09-19T12:20:38.026Z |
5093491 | 5093491 | 20240912032419_f002U | UK0051 | 2024-09-16T12:14:18.903Z | 2024-09-19T12:21:15.382Z |
5092024 | 5092024 | 20240912023519_8Kpq9 | UK0051 | 2024-09-16T12:13:38.402Z | 2024-09-19T12:21:13.602Z |
5090891 | 5090891 | 20240912015005_RDmc0 | UK0051 | 2024-09-16T12:12:40.781Z | 2024-09-19T12:21:12.279Z |
5090628 | 5090628 | 20240912013525_1DZfb | UK0051 | 2024-09-16T12:12:27.009Z | 2024-09-19T12:21:11.487Z |
5088777 | 5088777 | 20240913002655_rOw3A | UK0051 | 2024-09-16T12:08:30.066Z | 2024-09-19T12:20:37.289Z |
5088763 | 5088763 | 20240913002554_92QQg | UK0051 | 2024-09-16T12:08:29.614Z | 2024-09-19T12:20:37.274Z |
5088688 | 5088688 | 20240913002128_494pi | UK0051 | 2024-09-16T12:08:20.947Z | 2024-09-19T12:20:37.182Z |
5088091 | 5088091 | 20240912235536_32M8L | UK0051 | 2024-09-16T12:07:43.468Z | 2024-09-19T12:20:36.366Z |
5087801 | 5087801 | 20240912234445_WPLRd | UK0051 | 2024-09-16T12:07:28.300Z | 2024-09-19T12:20:35.679Z |
5087369 | 5087369 | 20240912232611_BtRRj | UK0051 | 2024-09-16T12:06:54.406Z | 2024-09-19T12:20:34.777Z |
5087270 | 5087270 | 20240912232030_wWlZ2 | UK0051 | 2024-09-16T12:06:50.336Z | 2024-09-19T12:20:34.547Z |
5086872 | 5086872 | 20240912225324_GIaug | UK0051 | 2024-09-16T12:06:10.744Z | 2024-09-19T12:20:32.790Z |
5086328 | 5086328 | 20240912222839_pIQMS | UK0051 | 2024-09-16T12:05:35.311Z | 2024-09-19T12:20:30.904Z |
5085789 | 5085789 | 20240912215137_JP7UV | UK0051 | 2024-09-16T12:04:55.957Z | 2024-09-19T12:20:29.623Z |
5078222 | 5078222 | 20240911014323_2yxg5 | UK0051 | 2024-09-15T12:15:24.036Z | 2024-09-19T12:21:40.060Z |
5078162 | 5078162 | 20240911014137_9qWyW | UK0051 | 2024-09-15T12:15:22.302Z | 2024-09-19T12:21:40.039Z |
5078080 | 5078080 | 20240911013849_Zm3OG | UK0051 | 2024-09-15T12:15:19.422Z | 2024-09-19T12:21:39.948Z |
5078030 | 5078030 | 20240911013622_8oEIU | UK0051 | 2024-09-15T12:15:17.307Z | 2024-09-19T12:21:39.922Z |
5077701 | 5077701 | 20240911011216_GiiND | UK0051 | 2024-09-15T12:15:01.061Z | 2024-09-19T12:21:39.537Z |
5077070 | 5077070 | 20240911002254_hh8xr | UK0051 | 2024-09-15T12:14:21.445Z | 2024-09-19T12:21:38.190Z |
5077018 | 5077018 | 20240911002117_MK1NT | UK0051 | 2024-09-15T12:14:17.714Z | 2024-09-19T12:21:37.965Z |
5075050 | 5075050 | 20240911232424_JkFTP | UK0051 | 2024-09-15T12:09:20.883Z | 2024-09-19T12:21:08.054Z |
5073878 | 5073878 | 20240911215231_3Nqc1 | UK0051 | 2024-09-15T12:07:42.414Z | 2024-09-19T12:21:06.342Z |
5073409 | 5073409 | 20240911212015_gfhrh | UK0051 | 2024-09-15T12:07:08.444Z | 2024-09-19T12:21:05.725Z |
5072571 | 5072571 | 20240911202356_vnuC7 | UK0051 | 2024-09-15T12:05:39.227Z | 2024-09-19T12:21:04.434Z |
5072223 | 5072223 | 20240911194915_OwRP3 | UK0051 | 2024-09-15T12:04:56.161Z | 2024-09-19T12:21:03.713Z |
5063131 | 5063131 | 20240909200047_Jbvpq | UK0051 | 2024-09-14T12:13:33.498Z | 2024-09-18T12:15:13.081Z |
5020006 | 5020006 | 20240905003635_mlF9e | UK0051 | 2024-09-10T12:13:49.468Z | 2024-09-13T12:19:54.802Z |
5019926 | 5019926 | 20240905001937_TwS7H | UK0051 | 2024-09-10T12:13:43.729Z | 2024-09-13T12:19:54.428Z |
5019584 | 5019584 | 20240904231502_ZVye1 | UK0051 | 2024-09-10T12:12:57.086Z | 2024-09-13T12:19:52.774Z |
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);