participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,656 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 |
---|---|---|---|---|---|
5592727 | 5592727 | 20241119230624_IfroU | UK0050 | 2024-11-24T14:24:31.185Z | 2024-11-26T14:27:35.149Z |
5583609 | 5583609 | 20241120034054_WOD0d | UK0050 | 2024-11-23T14:24:44.924Z | 2024-11-26T14:27:52.538Z |
5582886 | 5582886 | 20241120045557_642Up | UK0050 | 2024-11-23T14:21:35.905Z | 2024-11-26T14:25:36.735Z |
5582450 | 5582450 | 20241122033404_tfnPn | UK0050 | 2024-11-23T14:21:05.290Z | 2024-11-26T14:25:26.797Z |
5582259 | 5582259 | 20241122031515_Rg43z | UK0050 | 2024-11-23T14:21:00.672Z | 2024-11-26T14:25:25.160Z |
5582141 | 5582141 | 20241122030650_lPPwD | UK0050 | 2024-11-23T14:20:57.747Z | 2024-11-26T14:25:24.330Z |
5581912 | 5581912 | 20241122024737_V5ztF | UK0050 | 2024-11-23T14:20:49.930Z | 2024-11-26T14:25:19.702Z |
5581316 | 5581316 | 20241122015350_G2ngV | UK0050 | 2024-11-23T14:20:14.987Z | 2024-11-26T14:25:15.526Z |
5581299 | 5581299 | 20241122015315_QCZ2m | UK0050 | 2024-11-23T14:20:14.138Z | 2024-11-26T14:25:15.215Z |
5581271 | 5581271 | 20241122015143_prE52 | UK0050 | 2024-11-23T14:20:12.658Z | 2024-11-26T14:25:15.122Z |
5580249 | 5580249 | 20241122002246_sBl8Z | UK0050 | 2024-11-23T14:19:13.339Z | 2024-11-26T14:25:04.574Z |
5580189 | 5580189 | 20241122001522_Kle5J | UK0050 | 2024-11-23T14:19:10.419Z | 2024-11-26T14:25:04.026Z |
5579578 | 5579578 | 20241121225946_6Iqvb | UK0050 | 2024-11-23T14:18:37.136Z | 2024-11-26T14:24:59.681Z |
5579337 | 5579337 | 20241121222852_2yah0 | UK0050 | 2024-11-23T14:18:12.843Z | 2024-11-26T14:24:57.671Z |
5579162 | 5579162 | 20241121215444_ES8Vs | UK0050 | 2024-11-23T14:17:56.711Z | 2024-11-26T14:24:55.363Z |
5579072 | 5579072 | 20241121214225_1I3uh | UK0050 | 2024-11-23T14:17:48.351Z | 2024-11-26T14:24:54.705Z |
5579015 | 5579015 | 20241121213717_Y3qLl | UK0050 | 2024-11-23T14:17:43.910Z | 2024-11-26T14:24:54.320Z |
5578796 | 5578796 | 20241121210227_yh010 | UK0050 | 2024-11-23T14:17:34.084Z | 2024-11-26T14:24:52.628Z |
5578610 | 5578610 | 20241121203113_DSO5T | UK0050 | 2024-11-23T14:17:24.891Z | 2024-11-26T14:24:50.203Z |
5571408 | 5571408 | 20241120234015_QA76F | UK0050 | 2024-11-22T14:17:03.253Z | 2024-11-26T14:26:34.310Z |
5570773 | 5570773 | 20241120205456_KjXTC | UK0050 | 2024-11-22T14:16:05.049Z | 2024-11-26T14:26:28.343Z |
5570668 | 5570668 | 20241120203956_wVDt7 | UK0050 | 2024-11-22T14:15:59.988Z | 2024-11-26T14:26:27.026Z |
5570448 | 5570448 | 20241120194114_LHdNB | UK0050 | 2024-11-22T14:15:26.915Z | 2024-11-26T14:26:21.037Z |
5570209 | 5570209 | 20241120190318_MpLAb | UK0050 | 2024-11-22T14:15:00.809Z | 2024-11-26T14:26:15.215Z |
5570108 | 5570108 | 20241120184222_c9yM4 | UK0050 | 2024-11-22T14:14:52.792Z | 2024-11-26T14:26:13.991Z |
5569888 | 5569888 | 20241120175339_zx8Ag | UK0050 | 2024-11-22T14:14:29.934Z | 2024-11-26T14:26:11.522Z |
5569884 | 5569884 | 20241120175338_khRPy | UK0050 | 2024-11-22T14:14:29.587Z | 2024-11-26T14:26:11.479Z |
5569805 | 5569805 | 20241120173541_mNOkx | UK0050 | 2024-11-22T14:14:14.698Z | 2024-11-26T14:26:10.852Z |
5565404 | 5565404 | 20241120042321_CbdS2 | UK0050 | 2024-11-21T14:18:48.147Z | 2024-11-26T14:27:54.864Z |
5565377 | 5565377 | 20241120042149_x4jjK | UK0050 | 2024-11-21T14:18:47.561Z | 2024-11-26T14:27:54.386Z |
5565142 | 5565142 | 20241120035640_BCjQl | UK0050 | 2024-11-21T14:18:33.820Z | 2024-11-26T14:27:53.455Z |
5564985 | 5564985 | 20241120034328_ALSKA | UK0050 | 2024-11-21T14:18:17.670Z | 2024-11-26T14:27:52.761Z |
5564925 | 5564925 | 20241120033942_SXlR2 | UK0050 | 2024-11-21T14:18:15.432Z | 2024-11-26T14:27:52.356Z |
5564774 | 5564774 | 20241120032537_O9I35 | UK0050 | 2024-11-21T14:18:02.738Z | 2024-11-26T14:27:51.432Z |
5564655 | 5564655 | 20241120031615_kBSKe | UK0050 | 2024-11-21T14:17:55.348Z | 2024-11-26T14:27:50.302Z |
5564175 | 5564175 | 20241120023502_B9zPh | UK0050 | 2024-11-21T14:17:15.560Z | 2024-11-26T14:27:48.572Z |
5563492 | 5563492 | 20241120013405_rGSAU | UK0050 | 2024-11-21T14:16:10.760Z | 2024-11-26T14:27:44.960Z |
5563002 | 5563002 | 20241120003931_y0m2p | UK0050 | 2024-11-21T14:15:31.480Z | 2024-11-26T14:27:42.387Z |
5562249 | 5562249 | 20241119231605_1Ydoh | UK0050 | 2024-11-21T14:14:36.362Z | 2024-11-26T14:27:36.178Z |
5562123 | 5562123 | 20241119230234_b6Dtf | UK0050 | 2024-11-21T14:14:27.012Z | 2024-11-26T14:27:34.940Z |
5562113 | 5562113 | 20241119230157_2wlaD | UK0050 | 2024-11-21T14:14:26.129Z | 2024-11-26T14:27:34.929Z |
5557898 | 5557898 | 20241120052225_wRKvI | UK0050 | 2024-11-21T14:02:01.533Z | 2024-11-26T14:25:39.630Z |
5557724 | 5557724 | 20241120050805_JZoqY | UK0050 | 2024-11-21T14:01:35.820Z | 2024-11-26T14:25:38.297Z |
5543416 | 5543416 | 20241115011343_KGWjg | UK0050 | 2024-11-16T14:06:16.210Z | 2024-11-23T14:26:18.867Z |
5543360 | 5543360 | 20241115003749_VDPMs | UK0050 | 2024-11-16T14:06:08.948Z | 2024-11-23T14:26:18.582Z |
5543293 | 5543293 | 20241114235256_f8K3k | UK0050 | 2024-11-16T14:06:01.708Z | 2024-11-23T14:26:18.390Z |
5543167 | 5543167 | 20241114221335_Utfva | UK0050 | 2024-11-16T14:05:38.781Z | 2024-11-23T14:26:18.070Z |
5543118 | 5543118 | 20241114210121_IYEN3 | UK0050 | 2024-11-16T14:05:33.192Z | 2024-11-23T14:26:17.766Z |
5532051 | 5532051 | 20241112043258_UXP2k | UK0050 | 2024-11-13T14:16:13.633Z | 2024-11-20T14:26:18.302Z |
5531682 | 5531682 | 20241112040002_LgjzV | UK0050 | 2024-11-13T14:15:50.552Z | 2024-11-20T14:26:13.433Z |
5531553 | 5531553 | 20241112034810_CaEeh | UK0050 | 2024-11-13T14:15:44.421Z | 2024-11-20T14:26:12.149Z |
5531371 | 5531371 | 20241112033408_muBiX | UK0050 | 2024-11-13T14:15:36.064Z | 2024-11-20T14:26:10.650Z |
5531296 | 5531296 | 20241112032916_Uq4oI | UK0050 | 2024-11-13T14:15:33.101Z | 2024-11-20T14:26:09.986Z |
5530750 | 5530750 | 20241112024334_4C15K | UK0050 | 2024-11-13T14:14:34.256Z | 2024-11-20T14:26:02.992Z |
5530380 | 5530380 | 20241112021443_qBBBz | UK0050 | 2024-11-13T14:14:12.837Z | 2024-11-20T14:25:58.312Z |
5530212 | 5530212 | 20241112015638_erhNb | UK0050 | 2024-11-13T14:14:01.796Z | 2024-11-20T14:25:55.435Z |
5530135 | 5530135 | 20241112014932_1CaAt | UK0050 | 2024-11-13T14:13:58.282Z | 2024-11-20T14:25:54.833Z |
5529979 | 5529979 | 20241112013231_2fAAn | UK0050 | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5529358 | 5529358 | 20241112000642_0QOAy | UK0050 | 2024-11-13T14:12:26.902Z | 2024-11-20T14:25:43.329Z |
5529238 | 5529238 | 20241111235359_tFAp4 | UK0050 | 2024-11-13T14:12:15.403Z | 2024-11-20T14:25:42.167Z |
5529222 | 5529222 | 20241111234838_3Mu6I | UK0050 | 2024-11-13T14:12:14.263Z | 2024-11-20T14:25:41.926Z |
5528878 | 5528878 | 20241111230026_5gBub | UK0050 | 2024-11-13T14:11:34.775Z | 2024-11-20T14:25:36.916Z |
5528792 | 5528792 | 20241111223955_eiMuP | UK0050 | 2024-11-13T14:11:26.827Z | 2024-11-20T14:25:35.852Z |
5528611 | 5528611 | 20241111215050_jQBdk | UK0050 | 2024-11-13T14:11:09.412Z | 2024-11-20T14:25:32.600Z |
5528588 | 5528588 | 20241111214601_46jti | UK0050 | 2024-11-13T14:11:08.612Z | 2024-11-20T14:25:32.488Z |
5528219 | 5528219 | 20241111195532_uWUAh | UK0050 | 2024-11-13T14:10:16.499Z | 2024-11-20T14:25:26.746Z |
5527932 | 5527932 | 20241111190139_aftt9 | UK0050 | 2024-11-13T14:09:35.407Z | 2024-11-20T14:25:23.201Z |
5524800 | 5524800 | 20241111054914_YdrUU | UK0050 | 2024-11-12T14:18:02.035Z | 2024-11-19T14:22:24.144Z |
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 |
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);