participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,812 rows where station_code = "UK003B" 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 |
---|---|---|---|---|---|
5564309 | 5564309 | 20241120024736_r9Dr5 | UK003B | 2024-11-21T14:17:26.838Z | 2024-11-22T14:21:30.410Z |
5564288 | 5564288 | 20241120024602_Sc7Ry | UK003B | 2024-11-21T14:17:24.833Z | 2024-11-22T14:21:30.042Z |
5564173 | 5564173 | 20241120023502_B9zPh | UK003B | 2024-11-21T14:17:15.560Z | 2024-11-22T14:21:27.876Z |
5564017 | 5564017 | 20241120022444_la2qe | UK003B | 2024-11-21T14:17:05.107Z | 2024-11-22T14:21:26.504Z |
5564008 | 5564008 | 20241120022316_UftIc | UK003B | 2024-11-21T14:17:04.828Z | 2024-11-22T14:21:26.475Z |
5563392 | 5563392 | 20241120012546_NEfGZ | UK003B | 2024-11-21T14:16:02.349Z | 2024-11-22T14:21:14.891Z |
5563386 | 5563386 | 20241120012418_BX0eD | UK003B | 2024-11-21T14:16:01.911Z | 2024-11-22T14:21:14.858Z |
5563289 | 5563289 | 20241120011435_CSU9I | UK003B | 2024-11-21T14:15:51.271Z | 2024-11-22T14:21:12.331Z |
5563220 | 5563220 | 20241120010723_QtyUZ | UK003B | 2024-11-21T14:15:40.929Z | 2024-11-22T14:21:11.066Z |
5563207 | 5563207 | 20241120010500_639EG | UK003B | 2024-11-21T14:15:40.430Z | 2024-11-22T14:21:10.845Z |
5562920 | 5562920 | 20241120002908_94bJo | UK003B | 2024-11-21T14:15:27.663Z | 2024-11-22T14:21:06.127Z |
5562779 | 5562779 | 20241120001107_IYi0Z | UK003B | 2024-11-21T14:15:21.780Z | 2024-11-22T14:21:03.923Z |
5562706 | 5562706 | 20241120000441_lzEId | UK003B | 2024-11-21T14:15:17.604Z | 2024-11-22T14:21:02.746Z |
5562583 | 5562583 | 20241119235326_HFuZ8 | UK003B | 2024-11-21T14:15:11.151Z | 2024-11-22T14:21:00.753Z |
5558402 | 5558402 | 20241120060206_ojGCL | UK003B | 2024-11-21T14:03:12.169Z | 2024-11-22T14:19:21.224Z |
5558385 | 5558385 | 20241120060139_ItavS | UK003B | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5558381 | 5558381 | 20241120060136_cL2x0 | UK003B | 2024-11-21T14:03:10.330Z | 2024-11-22T14:19:21.221Z |
5441591 | 5441591 | 20241029224338_DVNNS | UK003B | 2024-11-01T12:18:46.753Z | 2024-11-07T14:26:42.701Z |
5441377 | 5441377 | 20241029215657_h2twa | UK003B | 2024-11-01T12:18:30.707Z | 2024-11-07T14:26:41.969Z |
5410681 | 5410681 | 20241027052755_rMIxt | UK003B | 2024-10-29T12:18:02.339Z | 2024-11-04T14:29:05.213Z |
5405339 | 5405339 | 20241027002907_1x3el | UK003B | 2024-10-29T12:12:50.167Z | 2024-11-04T14:28:53.294Z |
5405252 | 5405252 | 20241027002547_lNBYz | UK003B | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.177Z |
5404874 | 5404874 | 20241026235809_Hbz7b | UK003B | 2024-10-29T12:12:04.627Z | 2024-11-04T14:28:52.233Z |
5404782 | 5404782 | 20241026235232_SMQBs | UK003B | 2024-10-29T12:11:57.674Z | 2024-11-04T14:28:51.937Z |
5404261 | 5404261 | 20241026231306_OAwVo | UK003B | 2024-10-29T12:11:03.760Z | 2024-11-04T14:28:50.559Z |
5404168 | 5404168 | 20241026230351_UeIko | UK003B | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5404140 | 5404140 | 20241026230210_OO3ek | UK003B | 2024-10-29T12:10:55.886Z | 2024-11-04T14:28:50.356Z |
5403746 | 5403746 | 20241026222751_Myfx3 | UK003B | 2024-10-29T12:10:11.408Z | 2024-11-04T14:28:49.541Z |
5378108 | 5378108 | 20241024052717_qfc38 | UK003B | 2024-10-26T12:22:54.523Z | 2024-11-01T12:27:03.289Z |
5378099 | 5378099 | 20241024052715_BEwzo | UK003B | 2024-10-26T12:22:54.459Z | 2024-11-01T12:27:03.283Z |
5377355 | 5377355 | 20241024044607_1pwHx | UK003B | 2024-10-26T12:22:34.819Z | 2024-11-01T12:27:02.387Z |
5377040 | 5377040 | 20241024042950_KsDHO | UK003B | 2024-10-26T12:22:24.789Z | 2024-11-01T12:27:02.156Z |
5376735 | 5376735 | 20241024041113_miVKF | UK003B | 2024-10-26T12:22:12.245Z | 2024-11-01T12:27:01.756Z |
5375840 | 5375840 | 20241024033229_nKCCg | UK003B | 2024-10-26T12:21:41.625Z | 2024-11-01T12:27:01.219Z |
5375820 | 5375820 | 20241024033205_Du9An | UK003B | 2024-10-26T12:21:41.193Z | 2024-11-01T12:27:01.213Z |
5375195 | 5375195 | 20241024030204_1qbrG | UK003B | 2024-10-26T12:21:16.596Z | 2024-11-01T12:27:00.438Z |
5375150 | 5375150 | 20241024025952_Yzi8m | UK003B | 2024-10-26T12:21:14.524Z | 2024-11-01T12:27:00.306Z |
5374288 | 5374288 | 20241024022030_DyxCL | UK003B | 2024-10-26T12:20:43.900Z | 2024-11-01T12:26:58.827Z |
5353216 | 5353216 | 20241023011540_hnKwi | UK003B | 2024-10-24T12:19:35.978Z | 2024-10-31T12:30:04.019Z |
5353186 | 5353186 | 20241023011352_YBql8 | UK003B | 2024-10-24T12:19:34.922Z | 2024-10-31T12:30:03.985Z |
5352781 | 5352781 | 20241023004954_5bo6B | UK003B | 2024-10-24T12:19:11.945Z | 2024-10-31T12:30:03.288Z |
5352413 | 5352413 | 20241023003151_7vOYH | UK003B | 2024-10-24T12:18:46.484Z | 2024-10-31T12:30:02.615Z |
5352252 | 5352252 | 20241023002227_PfYT6 | UK003B | 2024-10-24T12:18:34.178Z | 2024-10-31T12:30:02.362Z |
5352110 | 5352110 | 20241023001222_ns2RK | UK003B | 2024-10-24T12:18:23.055Z | 2024-10-31T12:30:01.922Z |
5351377 | 5351377 | 20241022232201_Cs9rt | UK003B | 2024-10-24T12:17:28.803Z | 2024-10-31T12:30:00.266Z |
5351128 | 5351128 | 20241022230019_4RhpW | UK003B | 2024-10-24T12:17:14.821Z | 2024-10-31T12:29:59.517Z |
5351034 | 5351034 | 20241022224936_Be8Hu | UK003B | 2024-10-24T12:17:04.950Z | 2024-10-31T12:29:59.297Z |
5351029 | 5351029 | 20241022224936_Jo6Sy | UK003B | 2024-10-24T12:17:04.636Z | 2024-10-31T12:29:59.286Z |
5350366 | 5350366 | 20241022213903_QcZ53 | UK003B | 2024-10-24T12:15:39.244Z | 2024-10-31T12:29:58.058Z |
5344500 | 5344500 | 20241022042747_9JbMs | UK003B | 2024-10-23T12:18:40.004Z | 2024-10-30T12:26:51.292Z |
5344436 | 5344436 | 20241022042201_5YCb2 | UK003B | 2024-10-23T12:18:36.893Z | 2024-10-30T12:26:51.242Z |
5343986 | 5343986 | 20241022035910_c6Z0M | UK003B | 2024-10-23T12:18:17.162Z | 2024-10-30T12:26:50.837Z |
5343907 | 5343907 | 20241022035451_gqqoO | UK003B | 2024-10-23T12:18:13.469Z | 2024-10-30T12:26:50.711Z |
5343849 | 5343849 | 20241022035054_h8CBA | UK003B | 2024-10-23T12:18:11.021Z | 2024-10-30T12:26:50.650Z |
5343434 | 5343434 | 20241022032915_jzBMU | UK003B | 2024-10-23T12:17:46.421Z | 2024-10-30T12:26:50.025Z |
5342976 | 5342976 | 20241022025724_QVMit | UK003B | 2024-10-23T12:17:30.268Z | 2024-10-30T12:26:49.103Z |
5342937 | 5342937 | 20241022025432_noXaw | UK003B | 2024-10-23T12:17:29.307Z | 2024-10-30T12:26:49.064Z |
5342894 | 5342894 | 20241022025216_7mmQC | UK003B | 2024-10-23T12:17:27.865Z | 2024-10-30T12:26:49.033Z |
5341838 | 5341838 | 20241022015559_ejBwS | UK003B | 2024-10-23T12:16:17.644Z | 2024-10-30T12:26:47.567Z |
5341421 | 5341421 | 20241022013512_IJorv | UK003B | 2024-10-23T12:15:47.943Z | 2024-10-30T12:26:47.023Z |
5341188 | 5341188 | 20241022012011_FqyJS | UK003B | 2024-10-23T12:15:27.807Z | 2024-10-30T12:26:46.656Z |
5341040 | 5341040 | 20241022011038_DXQu3 | UK003B | 2024-10-23T12:15:14.895Z | 2024-10-30T12:26:46.534Z |
5340887 | 5340887 | 20241022005734_RuObS | UK003B | 2024-10-23T12:15:01.946Z | 2024-10-30T12:26:46.343Z |
5340715 | 5340715 | 20241022004432_RAI37 | UK003B | 2024-10-23T12:14:49.817Z | 2024-10-30T12:26:46.247Z |
5340150 | 5340150 | 20241021234843_annAN | UK003B | 2024-10-23T12:14:20.705Z | 2024-10-30T12:26:45.424Z |
5339279 | 5339279 | 20241021221754_Q01wI | UK003B | 2024-10-23T12:12:56.958Z | 2024-10-30T12:26:43.934Z |
5304339 | 5304339 | 20241013043838_AAowU | UK003B | 2024-10-14T12:17:48.278Z | 2024-10-21T12:24:24.840Z |
5304248 | 5304248 | 20241013043216_YteW3 | UK003B | 2024-10-14T12:17:46.034Z | 2024-10-21T12:24:24.496Z |
5301599 | 5301599 | 20241012234849_p8gKG | UK003B | 2024-10-14T12:15:32.115Z | 2024-10-21T12:23:59.548Z |
5294923 | 5294923 | 20241013050848_LNfTw | UK003B | 2024-10-14T12:00:37.674Z | 2024-10-22T12:24:06.641Z |
5294899 | 5294899 | 20241013050650_J3HhW | UK003B | 2024-10-14T12:00:36.449Z | 2024-10-22T12:24:06.510Z |
5294792 | 5294792 | 20241013044907_IGgqk | UK003B | 2024-10-14T12:00:20.943Z | 2024-10-22T12:24:05.461Z |
5294716 | 5294716 | 20241013044157_nQAAz | UK003B | 2024-10-14T12:00:12.072Z | 2024-10-22T12:24:04.683Z |
5285579 | 5285579 | 20241011040653_ig7jr | UK003B | 2024-10-12T12:18:16.464Z | 2024-10-19T12:28:03.920Z |
5285468 | 5285468 | 20241011035919_wuAPC | UK003B | 2024-10-12T12:18:10.763Z | 2024-10-19T12:28:02.767Z |
5285181 | 5285181 | 20241011033734_H3Z5C | UK003B | 2024-10-12T12:17:56.416Z | 2024-10-19T12:28:00.411Z |
5283693 | 5283693 | 20241011014505_DvZgs | UK003B | 2024-10-12T12:16:51.213Z | 2024-10-19T12:27:52.415Z |
5255631 | 5255631 | 20241008045228_JrziA | UK003B | 2024-10-09T12:01:31.662Z | 2024-10-17T12:19:53.188Z |
5255512 | 5255512 | 20241008043902_7W9OG | UK003B | 2024-10-09T12:01:19.232Z | 2024-10-17T12:19:52.530Z |
5255420 | 5255420 | 20241008042412_WLDa5 | UK003B | 2024-10-09T12:01:11.720Z | 2024-10-17T12:19:52.168Z |
5255019 | 5255019 | 20241008033028_eyfnW | UK003B | 2024-10-09T12:00:27.335Z | 2024-10-17T12:19:50.679Z |
5254974 | 5254974 | 20241008032557_BbmJ2 | UK003B | 2024-10-09T12:00:22.605Z | 2024-10-17T12:19:50.351Z |
5247359 | 5247359 | 20241005015819_lrMd5 | UK003B | 2024-10-07T12:18:53.975Z | 2024-10-13T12:26:26.141Z |
5239460 | 5239460 | 20241005040208_aPBJq | UK003B | 2024-10-07T12:06:27.509Z | 2024-10-14T12:24:19.331Z |
5239451 | 5239451 | 20241005040206_YfSQB | UK003B | 2024-10-07T12:06:27.184Z | 2024-10-14T12:24:19.311Z |
5239425 | 5239425 | 20241005040023_K3gYd | UK003B | 2024-10-07T12:06:25.809Z | 2024-10-14T12:24:19.278Z |
5239398 | 5239398 | 20241005035847_j544O | UK003B | 2024-10-07T12:06:23.412Z | 2024-10-14T12:24:19.219Z |
5227158 | 5227158 | 20241004010647_3LshR | UK003B | 2024-10-05T12:21:16.445Z | 2024-10-12T12:25:12.566Z |
5227087 | 5227087 | 20241004010054_lklrV | UK003B | 2024-10-05T12:21:12.366Z | 2024-10-12T12:25:12.421Z |
5226847 | 5226847 | 20241004004253_El6pw | UK003B | 2024-10-05T12:21:01.210Z | 2024-10-12T12:25:12.215Z |
5226743 | 5226743 | 20241004003525_RpUCP | UK003B | 2024-10-05T12:20:56.263Z | 2024-10-12T12:25:12.028Z |
5226736 | 5226736 | 20241004003525_DiIUA | UK003B | 2024-10-05T12:20:56.176Z | 2024-10-12T12:25:12.027Z |
5226711 | 5226711 | 20241004003408_vs3aj | UK003B | 2024-10-05T12:20:55.448Z | 2024-10-12T12:25:12.017Z |
5226139 | 5226139 | 20241003234742_HX6OH | UK003B | 2024-10-05T12:20:30.225Z | 2024-10-12T12:25:11.264Z |
5220084 | 5220084 | 20241003044431_AquAK | UK003B | 2024-10-05T12:10:14.096Z | 2024-10-12T12:24:56.805Z |
5220045 | 5220045 | 20241003043952_ZzvBt | UK003B | 2024-10-05T12:10:07.738Z | 2024-10-12T12:24:56.742Z |
5220010 | 5220010 | 20241003043626_hL6sZ | UK003B | 2024-10-05T12:10:04.497Z | 2024-10-12T12:24:56.685Z |
5219962 | 5219962 | 20241003043228_qI38C | UK003B | 2024-10-05T12:09:59.493Z | 2024-10-12T12:24:56.523Z |
5218946 | 5218946 | 20241004042330_f7AeM | UK003B | 2024-10-05T12:05:40.174Z | 2024-10-13T12:26:09.220Z |
5218030 | 5218030 | 20241004031108_BRMOr | UK003B | 2024-10-05T12:03:06.960Z | 2024-10-13T12:26:07.753Z |
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);