participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,588 rows where station_code = "UK0050" 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 |
---|---|---|---|---|---|
5454295 | 5454295 | 20241031040629_135U2 | UK0050 | 2024-11-02T12:22:59.134Z | 2024-11-08T14:23:22.053Z |
5454291 | 5454291 | 20241031040613_ySWkU | UK0050 | 2024-11-02T12:22:58.978Z | 2024-11-08T14:23:22.048Z |
5454199 | 5454199 | 20241031035545_lYDGS | UK0050 | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454085 | 5454085 | 20241031034058_92XpZ | UK0050 | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
5451334 | 5451334 | 20241031233548_Ycttr | UK0050 | 2024-11-02T12:16:54.685Z | 2024-11-09T14:24:23.101Z |
5451236 | 5451236 | 20241031231032_lA83G | UK0050 | 2024-11-02T12:16:44.994Z | 2024-11-09T14:24:22.529Z |
5451131 | 5451131 | 20241031224755_u4tVA | UK0050 | 2024-11-02T12:16:38.304Z | 2024-11-09T14:24:21.723Z |
5451020 | 5451020 | 20241031221943_QGEpT | UK0050 | 2024-11-02T12:16:30.748Z | 2024-11-09T14:24:20.804Z |
5450980 | 5450980 | 20241031220904_J3V2E | UK0050 | 2024-11-02T12:16:27.200Z | 2024-11-09T14:24:20.428Z |
5450830 | 5450830 | 20241031211700_9XzHK | UK0050 | 2024-11-02T12:16:01.599Z | 2024-11-09T14:24:18.560Z |
5450795 | 5450795 | 20241031210046_lh92W | UK0050 | 2024-11-02T12:15:54.164Z | 2024-11-09T14:24:18.129Z |
5450793 | 5450793 | 20241031205859_K5OlG | UK0050 | 2024-11-02T12:15:53.530Z | 2024-11-09T14:24:18.088Z |
5450686 | 5450686 | 20241031202009_3L1qa | UK0050 | 2024-11-02T12:15:44.746Z | 2024-11-09T14:24:17.569Z |
5450683 | 5450683 | 20241031201954_YpS98 | UK0050 | 2024-11-02T12:15:44.472Z | 2024-11-09T14:24:17.535Z |
5444207 | 5444207 | 20241031005937_HXc0G | UK0050 | 2024-11-01T12:21:10.098Z | 2024-11-08T14:23:14.114Z |
5444196 | 5444196 | 20241031005802_OSjz2 | UK0050 | 2024-11-01T12:21:09.644Z | 2024-11-08T14:23:14.087Z |
5444053 | 5444053 | 20241031004152_Huvtu | UK0050 | 2024-11-01T12:21:03.779Z | 2024-11-08T14:23:13.767Z |
5443998 | 5443998 | 20241031003657_h09cj | UK0050 | 2024-11-01T12:21:01.146Z | 2024-11-08T14:23:13.454Z |
5443895 | 5443895 | 20241031002636_5Mtdl | UK0050 | 2024-11-01T12:20:56.087Z | 2024-11-08T14:23:13.052Z |
5443867 | 5443867 | 20241031002233_6iFui | UK0050 | 2024-11-01T12:20:55.117Z | 2024-11-08T14:23:12.954Z |
5443717 | 5443717 | 20241031000803_OGizp | UK0050 | 2024-11-01T12:20:47.617Z | 2024-11-08T14:23:12.049Z |
5405510 | 5405510 | 20241027003956_3XpyO | UK0050 | 2024-10-29T12:12:59.591Z | 2024-11-04T14:28:53.580Z |
5405479 | 5405479 | 20241027003841_rQvnl | UK0050 | 2024-10-29T12:12:58.479Z | 2024-11-04T14:28:53.547Z |
5405466 | 5405466 | 20241027003741_xfioa | UK0050 | 2024-10-29T12:12:57.470Z | 2024-11-04T14:28:53.528Z |
5404876 | 5404876 | 20241026235809_Hbz7b | UK0050 | 2024-10-29T12:12:04.627Z | 2024-11-04T14:28:52.233Z |
5404727 | 5404727 | 20241026234925_gxOAe | UK0050 | 2024-10-29T12:11:55.131Z | 2024-11-04T14:28:51.872Z |
5403747 | 5403747 | 20241026222751_Myfx3 | UK0050 | 2024-10-29T12:10:11.428Z | 2024-11-04T14:28:49.541Z |
5403651 | 5403651 | 20241026222121_uQvh2 | UK0050 | 2024-10-29T12:10:05.186Z | 2024-11-04T14:28:49.400Z |
5403322 | 5403322 | 20241026214045_GDS6I | UK0050 | 2024-10-29T12:09:21.896Z | 2024-11-04T14:28:48.330Z |
5403276 | 5403276 | 20241026213540_6RNrh | UK0050 | 2024-10-29T12:09:18.338Z | 2024-11-04T14:28:48.259Z |
5402610 | 5402610 | 20241026200426_Gll2y | UK0050 | 2024-10-29T12:07:48.022Z | 2024-11-04T14:28:45.609Z |
5398902 | 5398902 | 20241026033659_pKDuf | UK0050 | 2024-10-28T12:19:39.733Z | 2024-11-03T14:27:38.385Z |
5395869 | 5395869 | 20241025231656_HM7e3 | UK0050 | 2024-10-28T12:17:02.129Z | 2024-11-03T14:27:27.445Z |
5395718 | 5395718 | 20241025230615_IuOX4 | UK0050 | 2024-10-28T12:16:42.683Z | 2024-11-03T14:27:26.533Z |
5395714 | 5395714 | 20241025230615_qljax | UK0050 | 2024-10-28T12:16:42.548Z | 2024-11-03T14:27:26.532Z |
5395647 | 5395647 | 20241025230135_dTi3N | UK0050 | 2024-10-28T12:16:35.750Z | 2024-11-03T14:27:26.329Z |
5395592 | 5395592 | 20241025225743_SQKAS | UK0050 | 2024-10-28T12:16:30.636Z | 2024-11-03T14:27:26.084Z |
5395496 | 5395496 | 20241025224640_o1uwN | UK0050 | 2024-10-28T12:16:20.870Z | 2024-11-03T14:27:25.634Z |
5395282 | 5395282 | 20241025222924_jrEqm | UK0050 | 2024-10-28T12:16:04.435Z | 2024-11-03T14:27:24.575Z |
5386089 | 5386089 | 20241025000243_4zIQI | UK0050 | 2024-10-27T12:19:49.772Z | 2024-11-02T12:28:30.683Z |
5385366 | 5385366 | 20241024223041_BCs17 | UK0050 | 2024-10-27T12:18:48.057Z | 2024-11-02T12:28:29.671Z |
5385357 | 5385357 | 20241024222958_sj3Bn | UK0050 | 2024-10-27T12:18:47.339Z | 2024-11-02T12:28:29.667Z |
5378102 | 5378102 | 20241024052715_BEwzo | UK0050 | 2024-10-26T12:22:54.460Z | 2024-11-01T12:27:03.283Z |
5377434 | 5377434 | 20241024045033_4Vfrz | UK0050 | 2024-10-26T12:22:37.079Z | 2024-11-01T12:27:02.429Z |
5372930 | 5372930 | 20241024011417_Gz13j | UK0050 | 2024-10-26T12:19:48.778Z | 2024-11-01T12:26:58.033Z |
5366035 | 5366035 | 20241024000215_5XyOC | UK0050 | 2024-10-25T12:18:14.957Z | 2024-11-01T12:26:56.550Z |
5365971 | 5365971 | 20241023235944_NSQuX | UK0050 | 2024-10-25T12:18:12.703Z | 2024-11-01T12:26:56.507Z |
5365813 | 5365813 | 20241023235018_4DCSI | UK0050 | 2024-10-25T12:18:07.984Z | 2024-11-01T12:26:56.439Z |
5365195 | 5365195 | 20241023232006_mBPA2 | UK0050 | 2024-10-25T12:17:50.647Z | 2024-11-01T12:26:55.964Z |
5365153 | 5365153 | 20241023231704_xp8Dq | UK0050 | 2024-10-25T12:17:47.940Z | 2024-11-01T12:26:55.899Z |
5365068 | 5365068 | 20241023231209_4HC1j | UK0050 | 2024-10-25T12:17:44.952Z | 2024-11-01T12:26:55.848Z |
5364306 | 5364306 | 20241023222008_HWaSf | UK0050 | 2024-10-25T12:17:16.238Z | 2024-11-01T12:26:54.665Z |
5364002 | 5364002 | 20241023220211_PbYxQ | UK0050 | 2024-10-25T12:17:05.393Z | 2024-11-01T12:26:54.304Z |
5361829 | 5361829 | 20241023184729_hBJn1 | UK0050 | 2024-10-25T12:13:34.979Z | 2024-11-01T12:26:50.608Z |
5361789 | 5361789 | 20241023184427_1oLVH | UK0050 | 2024-10-25T12:13:31.987Z | 2024-11-01T12:26:50.556Z |
5352683 | 5352683 | 20241023004356_79B1F | UK0050 | 2024-10-24T12:19:05.232Z | 2024-10-31T12:30:03.143Z |
5352634 | 5352634 | 20241023004215_xQqDG | UK0050 | 2024-10-24T12:19:02.154Z | 2024-10-31T12:30:03.009Z |
5352514 | 5352514 | 20241023003708_nejWy | UK0050 | 2024-10-24T12:18:54.102Z | 2024-10-31T12:30:02.849Z |
5350368 | 5350368 | 20241022213903_QcZ53 | UK0050 | 2024-10-24T12:15:39.259Z | 2024-10-31T12:29:58.058Z |
5349873 | 5349873 | 20241022204356_AL0rS | UK0050 | 2024-10-24T12:14:44.857Z | 2024-10-31T12:29:56.812Z |
5349134 | 5349134 | 20241022192734_h22oK | UK0050 | 2024-10-24T12:13:12.185Z | 2024-10-31T12:29:54.626Z |
5348844 | 5348844 | 20241022190236_a2oxR | UK0050 | 2024-10-24T12:12:25.685Z | 2024-10-31T12:29:53.860Z |
5345307 | 5345307 | 20241022053415_Kx0fZ | UK0050 | 2024-10-23T12:19:13.709Z | 2024-10-30T12:26:52.435Z |
5345282 | 5345282 | 20241022053216_61O9M | UK0050 | 2024-10-23T12:19:13.011Z | 2024-10-30T12:26:52.392Z |
5345272 | 5345272 | 20241022053136_60wsu | UK0050 | 2024-10-23T12:19:12.789Z | 2024-10-30T12:26:52.379Z |
5345109 | 5345109 | 20241022051317_PeoDu | UK0050 | 2024-10-23T12:19:05.878Z | 2024-10-30T12:26:52.192Z |
5345090 | 5345090 | 20241022051239_GED9E | UK0050 | 2024-10-23T12:19:05.517Z | 2024-10-30T12:26:52.181Z |
5344373 | 5344373 | 20241022041735_Q5HIa | UK0050 | 2024-10-23T12:18:33.885Z | 2024-10-30T12:26:51.204Z |
5344120 | 5344120 | 20241022040631_zu2n7 | UK0050 | 2024-10-23T12:18:24.754Z | 2024-10-30T12:26:50.949Z |
5344095 | 5344095 | 20241022040536_tqIdk | UK0050 | 2024-10-23T12:18:22.749Z | 2024-10-30T12:26:50.929Z |
5344034 | 5344034 | 20241022040237_IgbTU | UK0050 | 2024-10-23T12:18:19.872Z | 2024-10-30T12:26:50.895Z |
5343968 | 5343968 | 20241022035826_cUiWL | UK0050 | 2024-10-23T12:18:16.552Z | 2024-10-30T12:26:50.827Z |
5343803 | 5343803 | 20241022034620_9JvfV | UK0050 | 2024-10-23T12:18:08.304Z | 2024-10-30T12:26:50.602Z |
5343642 | 5343642 | 20241022033922_Hw0ma | UK0050 | 2024-10-23T12:17:58.361Z | 2024-10-30T12:26:50.380Z |
5343475 | 5343475 | 20241022033056_CYRB3 | UK0050 | 2024-10-23T12:17:47.716Z | 2024-10-30T12:26:50.052Z |
5343381 | 5343381 | 20241022032625_gMWqR | UK0050 | 2024-10-23T12:17:45.335Z | 2024-10-30T12:26:49.991Z |
5343106 | 5343106 | 20241022030943_07m8I | UK0050 | 2024-10-23T12:17:35.103Z | 2024-10-30T12:26:49.394Z |
5342802 | 5342802 | 20241022024639_Whluw | UK0050 | 2024-10-23T12:17:24.074Z | 2024-10-30T12:26:48.917Z |
5342779 | 5342779 | 20241022024601_uAydV | UK0050 | 2024-10-23T12:17:23.094Z | 2024-10-30T12:26:48.906Z |
5341106 | 5341106 | 20241022011508_tOwzE | UK0050 | 2024-10-23T12:15:20.819Z | 2024-10-30T12:26:46.610Z |
5340486 | 5340486 | 20241022001945_dOwmW | UK0050 | 2024-10-23T12:14:35.549Z | 2024-10-30T12:26:45.929Z |
5340152 | 5340152 | 20241021234843_annAN | UK0050 | 2024-10-23T12:14:20.705Z | 2024-10-30T12:26:45.424Z |
5340117 | 5340117 | 20241021234806_3tpE3 | UK0050 | 2024-10-23T12:14:19.771Z | 2024-10-30T12:26:45.417Z |
5338907 | 5338907 | 20241021211758_O4zRc | UK0050 | 2024-10-23T12:12:13.577Z | 2024-10-30T12:26:43.224Z |
5338111 | 5338111 | 20241021183936_QzKPZ | UK0050 | 2024-10-23T12:10:15.663Z | 2024-10-30T12:26:41.730Z |
5333944 | 5333944 | 20241021014235_ArvnL | UK0050 | 2024-10-22T12:16:13.621Z | 2024-10-29T12:26:34.719Z |
5333861 | 5333861 | 20241021013258_3dEon | UK0050 | 2024-10-22T12:16:09.269Z | 2024-10-29T12:26:34.651Z |
5333497 | 5333497 | 20241021004504_fcyaL | UK0050 | 2024-10-22T12:15:28.128Z | 2024-10-29T12:26:34.390Z |
5333298 | 5333298 | 20241021001449_FglDl | UK0050 | 2024-10-22T12:15:09.823Z | 2024-10-29T12:26:34.282Z |
5333269 | 5333269 | 20241021000827_GWtLM | UK0050 | 2024-10-22T12:15:07.235Z | 2024-10-29T12:26:34.271Z |
5332954 | 5332954 | 20241020231408_mex15 | UK0050 | 2024-10-22T12:14:30.794Z | 2024-10-29T12:26:33.984Z |
5332624 | 5332624 | 20241020212355_N1HXn | UK0050 | 2024-10-22T12:13:48.047Z | 2024-10-29T12:26:33.624Z |
5332524 | 5332524 | 20241020202850_yPnCo | UK0050 | 2024-10-22T12:13:24.331Z | 2024-10-29T12:26:33.472Z |
5326595 | 5326595 | 20241019190553_4OWOt | UK0050 | 2024-10-21T12:10:00.703Z | 2024-10-28T12:26:42.109Z |
5326534 | 5326534 | 20241019185348_AHIOG | UK0050 | 2024-10-21T12:09:46.016Z | 2024-10-28T12:26:41.984Z |
5321700 | 5321700 | 20241018021737_2fyBY | UK0050 | 2024-10-19T12:08:08.315Z | 2024-10-26T12:27:55.044Z |
5320498 | 5320498 | 20241018015701_oS1oy | UK0050 | 2024-10-19T12:05:31.332Z | 2024-10-26T12:27:54.703Z |
5320453 | 5320453 | 20241018014429_nh8pK | UK0050 | 2024-10-19T12:05:27.627Z | 2024-10-26T12:27:54.587Z |
5320166 | 5320166 | 20241018001817_1iCnn | UK0050 | 2024-10-19T12:04:45.713Z | 2024-10-26T12:27:54.114Z |
5319992 | 5319992 | 20241017223645_e2V0V | UK0050 | 2024-10-19T12:04:16.288Z | 2024-10-26T12:27:53.824Z |
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);