participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,397 rows where station_code = "UK0098" 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 |
---|---|---|---|---|---|
5573015 | 5573015 | 20241121033947_W8Jkj | UK0098 | 2024-11-22T14:19:04.101Z | 2024-11-22T14:19:22.433Z |
5572958 | 5572958 | 20241121033112_bMJeh | UK0098 | 2024-11-22T14:19:01.016Z | 2024-11-22T14:19:22.422Z |
5572879 | 5572879 | 20241121031943_qIVEX | UK0098 | 2024-11-22T14:18:55.684Z | 2024-11-22T14:19:22.406Z |
5572871 | 5572871 | 20241121031826_VVY21 | UK0098 | 2024-11-22T14:18:55.224Z | 2024-11-22T14:19:22.405Z |
5572864 | 5572864 | 20241121031756_LYYPu | UK0098 | 2024-11-22T14:18:53.931Z | 2024-11-22T14:19:22.404Z |
5572775 | 5572775 | 20241121030818_7CZav | UK0098 | 2024-11-22T14:18:48.926Z | 2024-11-22T14:19:22.389Z |
5572756 | 5572756 | 20241121030553_xkmT2 | UK0098 | 2024-11-22T14:18:48.169Z | 2024-11-22T14:19:22.385Z |
5572642 | 5572642 | 20241121025248_80YBB | UK0098 | 2024-11-22T14:18:41.087Z | 2024-11-22T14:19:22.367Z |
5572610 | 5572610 | 20241121025016_vUe22 | UK0098 | 2024-11-22T14:18:39.528Z | 2024-11-22T14:19:22.362Z |
5572555 | 5572555 | 20241121023624_V7bdI | UK0098 | 2024-11-22T14:18:35.543Z | 2024-11-22T14:19:22.350Z |
5572435 | 5572435 | 20241121022113_tXAie | UK0098 | 2024-11-22T14:18:26.671Z | 2024-11-22T14:19:22.329Z |
5572356 | 5572356 | 20241121021306_6NIly | UK0098 | 2024-11-22T14:18:19.049Z | 2024-11-22T14:19:22.314Z |
5572349 | 5572349 | 20241121021252_WAQHR | UK0098 | 2024-11-22T14:18:18.279Z | 2024-11-22T14:19:22.313Z |
5572320 | 5572320 | 20241121020915_XLVVo | UK0098 | 2024-11-22T14:18:15.979Z | 2024-11-22T14:19:22.305Z |
5572291 | 5572291 | 20241121020412_hhQQp | UK0098 | 2024-11-22T14:18:12.747Z | 2024-11-22T14:19:22.299Z |
5572256 | 5572256 | 20241121015947_awWJq | UK0098 | 2024-11-22T14:18:07.865Z | 2024-11-22T14:19:22.290Z |
5572251 | 5572251 | 20241121015847_baMnP | UK0098 | 2024-11-22T14:18:07.750Z | 2024-11-22T14:19:22.290Z |
5572220 | 5572220 | 20241121015154_SIeUT | UK0098 | 2024-11-22T14:18:05.508Z | 2024-11-22T14:19:22.282Z |
5572204 | 5572204 | 20241121014654_x2ne8 | UK0098 | 2024-11-22T14:18:04.710Z | 2024-11-22T14:19:22.279Z |
5572093 | 5572093 | 20241121013211_RN01c | UK0098 | 2024-11-22T14:17:57.006Z | 2024-11-22T14:19:22.257Z |
5572080 | 5572080 | 20241121013007_3T5pO | UK0098 | 2024-11-22T14:17:56.492Z | 2024-11-22T14:19:22.255Z |
5572055 | 5572055 | 20241121012633_mt3wg | UK0098 | 2024-11-22T14:17:54.955Z | 2024-11-22T14:19:22.250Z |
5572047 | 5572047 | 20241121012531_HnRN3 | UK0098 | 2024-11-22T14:17:54.583Z | 2024-11-22T14:19:22.249Z |
5572020 | 5572020 | 20241121012102_n2T8O | UK0098 | 2024-11-22T14:17:52.967Z | 2024-11-22T14:19:22.243Z |
5571976 | 5571976 | 20241121011616_nH53Z | UK0098 | 2024-11-22T14:17:50.592Z | 2024-11-22T14:19:22.235Z |
5571896 | 5571896 | 20241121010316_dT23m | UK0098 | 2024-11-22T14:17:45.836Z | 2024-11-22T14:19:22.218Z |
5571863 | 5571863 | 20241121005800_rRCZ4 | UK0098 | 2024-11-22T14:17:43.337Z | 2024-11-22T14:19:22.210Z |
5571854 | 5571854 | 20241121005622_RO2bZ | UK0098 | 2024-11-22T14:17:42.901Z | 2024-11-22T14:19:22.208Z |
5571789 | 5571789 | 20241121004734_YHskt | UK0098 | 2024-11-22T14:17:39.927Z | 2024-11-22T14:19:22.196Z |
5571714 | 5571714 | 20241121003604_AMwed | UK0098 | 2024-11-22T14:17:35.817Z | 2024-11-22T14:19:22.180Z |
5571615 | 5571615 | 20241121001723_Kp3b8 | UK0098 | 2024-11-22T14:17:25.351Z | 2024-11-22T14:19:22.159Z |
5571553 | 5571553 | 20241121000603_Q4WR8 | UK0098 | 2024-11-22T14:17:16.623Z | 2024-11-22T14:19:22.147Z |
5571410 | 5571410 | 20241120234015_QA76F | UK0098 | 2024-11-22T14:17:03.253Z | 2024-11-22T14:19:22.119Z |
5571406 | 5571406 | 20241120233933_paW72 | UK0098 | 2024-11-22T14:17:02.964Z | 2024-11-22T14:19:22.118Z |
5571383 | 5571383 | 20241120233514_mpndf | UK0098 | 2024-11-22T14:16:59.832Z | 2024-11-22T14:19:22.114Z |
5571237 | 5571237 | 20241120230728_NedRs | UK0098 | 2024-11-22T14:16:41.562Z | 2024-11-22T14:19:22.076Z |
5571226 | 5571226 | 20241120230316_Htitr | UK0098 | 2024-11-22T14:16:39.894Z | 2024-11-22T14:19:22.072Z |
5571172 | 5571172 | 20241120224057_F2q6X | UK0098 | 2024-11-22T14:16:33.862Z | 2024-11-22T14:19:22.056Z |
5571168 | 5571168 | 20241120224043_zOGfI | UK0098 | 2024-11-22T14:16:33.705Z | 2024-11-22T14:19:22.055Z |
5571156 | 5571156 | 20241120223759_8SdDI | UK0098 | 2024-11-22T14:16:31.533Z | 2024-11-22T14:19:22.053Z |
5571139 | 5571139 | 20241120223332_qLfll | UK0098 | 2024-11-22T14:16:30.104Z | 2024-11-22T14:19:22.050Z |
5571126 | 5571126 | 20241120223128_M3Mgk | UK0098 | 2024-11-22T14:16:28.464Z | 2024-11-22T14:19:22.047Z |
5571018 | 5571018 | 20241120215856_27mo3 | UK0098 | 2024-11-22T14:16:18.991Z | 2024-11-22T14:19:22.024Z |
5570903 | 5570903 | 20241120212632_JUKPN | UK0098 | 2024-11-22T14:16:11.547Z | 2024-11-22T14:19:22.003Z |
5570862 | 5570862 | 20241120211906_xO23o | UK0098 | 2024-11-22T14:16:09.669Z | 2024-11-22T14:19:21.995Z |
5570808 | 5570808 | 20241120210549_y3FL3 | UK0098 | 2024-11-22T14:16:06.635Z | 2024-11-22T14:19:21.985Z |
5570698 | 5570698 | 20241120204417_XU2A3 | UK0098 | 2024-11-22T14:16:01.398Z | 2024-11-22T14:19:21.965Z |
5570444 | 5570444 | 20241120194114_p6uiR | UK0098 | 2024-11-22T14:15:26.390Z | 2024-11-22T14:19:21.918Z |
5570396 | 5570396 | 20241120193141_UzvGr | UK0098 | 2024-11-22T14:15:19.603Z | 2024-11-22T14:19:21.910Z |
5570280 | 5570280 | 20241120191243_3Vaop | UK0098 | 2024-11-22T14:15:05.925Z | 2024-11-22T14:19:21.891Z |
5570272 | 5570272 | 20241120191234_jGkV2 | UK0098 | 2024-11-22T14:15:05.617Z | 2024-11-22T14:19:21.891Z |
5570256 | 5570256 | 20241120190837_dzG2c | UK0098 | 2024-11-22T14:15:04.649Z | 2024-11-22T14:19:21.888Z |
5570213 | 5570213 | 20241120190327_KO9VU | UK0098 | 2024-11-22T14:15:01.966Z | 2024-11-22T14:19:21.881Z |
5570166 | 5570166 | 20241120185527_qH825 | UK0098 | 2024-11-22T14:14:56.685Z | 2024-11-22T14:19:21.874Z |
5570122 | 5570122 | 20241120184529_qiOFO | UK0098 | 2024-11-22T14:14:53.802Z | 2024-11-22T14:19:21.866Z |
5569989 | 5569989 | 20241120182051_SfFxu | UK0098 | 2024-11-22T14:14:43.440Z | 2024-11-22T14:19:21.843Z |
5569981 | 5569981 | 20241120181954_9HX3x | UK0098 | 2024-11-22T14:14:43.000Z | 2024-11-22T14:19:21.842Z |
5569861 | 5569861 | 20241120175028_wVzoV | UK0098 | 2024-11-22T14:14:28.696Z | 2024-11-22T14:19:21.820Z |
5569851 | 5569851 | 20241120174744_8IZwX | UK0098 | 2024-11-22T14:14:28.141Z | 2024-11-22T14:19:21.819Z |
5566304 | 5566304 | 20241121055822_IJY1Q | UK0098 | 2024-11-22T14:02:24.310Z | 2024-11-22T14:02:24.310Z |
5566277 | 5566277 | 20241121055503_LoeMr | UK0098 | 2024-11-22T14:02:21.146Z | 2024-11-22T14:02:21.146Z |
5566252 | 5566252 | 20241121055325_2gpeV | UK0098 | 2024-11-22T14:02:18.682Z | 2024-11-22T14:02:18.682Z |
5566229 | 5566229 | 20241121055001_rbgRH | UK0098 | 2024-11-22T14:02:16.174Z | 2024-11-22T14:02:16.174Z |
5566119 | 5566119 | 20241121053452_2xQvH | UK0098 | 2024-11-22T14:01:52.992Z | 2024-11-22T14:01:52.992Z |
5566052 | 5566052 | 20241121052042_AO8co | UK0098 | 2024-11-22T14:01:37.454Z | 2024-11-22T14:01:37.454Z |
5566037 | 5566037 | 20241121052004_gAZiF | UK0098 | 2024-11-22T14:01:35.870Z | 2024-11-22T14:01:35.870Z |
5565965 | 5565965 | 20241121051140_OiM9E | UK0098 | 2024-11-22T14:01:29.451Z | 2024-11-22T14:01:29.451Z |
5565929 | 5565929 | 20241121050741_iFvz3 | UK0098 | 2024-11-22T14:01:25.600Z | 2024-11-22T14:01:25.600Z |
5565899 | 5565899 | 20241121050229_W50yc | UK0098 | 2024-11-22T14:01:21.269Z | 2024-11-22T14:01:21.269Z |
5565860 | 5565860 | 20241121045524_CUhXT | UK0098 | 2024-11-22T14:01:12.981Z | 2024-11-22T14:01:12.981Z |
5565854 | 5565854 | 20241121045501_NXKIa | UK0098 | 2024-11-22T14:01:12.598Z | 2024-11-22T14:01:12.598Z |
5565819 | 5565819 | 20241121045055_1zecH | UK0098 | 2024-11-22T14:01:01.325Z | 2024-11-22T14:01:01.325Z |
5565786 | 5565786 | 20241121044616_2EVD2 | UK0098 | 2024-11-22T14:00:56.644Z | 2024-11-22T14:00:56.644Z |
5565782 | 5565782 | 20241121044523_cfhYO | UK0098 | 2024-11-22T14:00:56.108Z | 2024-11-22T14:00:56.108Z |
5565615 | 5565615 | 20241121042620_vq38K | UK0098 | 2024-11-22T14:00:24.821Z | 2024-11-22T14:00:24.821Z |
5565576 | 5565576 | 20241121042334_yav2c | UK0098 | 2024-11-22T14:00:19.616Z | 2024-11-22T14:00:19.616Z |
5565358 | 5565358 | 20241120042104_qtf2g | UK0098 | 2024-11-21T14:18:47.168Z | 2024-11-22T14:21:46.164Z |
5565333 | 5565333 | 20241120041932_spJFM | UK0098 | 2024-11-21T14:18:46.656Z | 2024-11-22T14:21:46.007Z |
5565267 | 5565267 | 20241120040847_2Crxx | UK0098 | 2024-11-21T14:18:44.082Z | 2024-11-22T14:21:44.802Z |
5565145 | 5565145 | 20241120035640_BCjQl | UK0098 | 2024-11-21T14:18:33.821Z | 2024-11-22T14:21:42.569Z |
5565131 | 5565131 | 20241120035432_PW6Ms | UK0098 | 2024-11-21T14:18:32.947Z | 2024-11-22T14:21:42.222Z |
5565036 | 5565036 | 20241120034528_4ZYP8 | UK0098 | 2024-11-21T14:18:23.160Z | 2024-11-22T14:21:40.494Z |
5565000 | 5565000 | 20241120034414_un24h | UK0098 | 2024-11-21T14:18:18.614Z | 2024-11-22T14:21:40.203Z |
5564928 | 5564928 | 20241120033942_SXlR2 | UK0098 | 2024-11-21T14:18:15.432Z | 2024-11-22T14:21:39.654Z |
5564630 | 5564630 | 20241120031501_QmlVv | UK0098 | 2024-11-21T14:17:54.384Z | 2024-11-22T14:21:34.517Z |
5564493 | 5564493 | 20241120030300_tdre2 | UK0098 | 2024-11-21T14:17:42.057Z | 2024-11-22T14:21:32.807Z |
5564405 | 5564405 | 20241120025250_gdKlR | UK0098 | 2024-11-21T14:17:33.048Z | 2024-11-22T14:21:31.220Z |
5563784 | 5563784 | 20241120020425_Uj2Jb | UK0098 | 2024-11-21T14:16:43.808Z | 2024-11-22T14:21:22.932Z |
5563757 | 5563757 | 20241120020151_ALaNa | UK0098 | 2024-11-21T14:16:40.741Z | 2024-11-22T14:21:22.109Z |
5563417 | 5563417 | 20241120012856_i9X6e | UK0098 | 2024-11-21T14:16:05.053Z | 2024-11-22T14:21:15.438Z |
5563396 | 5563396 | 20241120012546_NEfGZ | UK0098 | 2024-11-21T14:16:02.349Z | 2024-11-22T14:21:14.891Z |
5563054 | 5563054 | 20241120004613_27TD5 | UK0098 | 2024-11-21T14:15:33.879Z | 2024-11-22T14:21:08.952Z |
5563005 | 5563005 | 20241120003931_y0m2p | UK0098 | 2024-11-21T14:15:31.480Z | 2024-11-22T14:21:07.671Z |
5562922 | 5562922 | 20241120002908_94bJo | UK0098 | 2024-11-21T14:15:27.663Z | 2024-11-22T14:21:06.127Z |
5562819 | 5562819 | 20241120001528_Kpr3c | UK0098 | 2024-11-21T14:15:23.704Z | 2024-11-22T14:21:05.094Z |
5562782 | 5562782 | 20241120001107_IYi0Z | UK0098 | 2024-11-21T14:15:21.780Z | 2024-11-22T14:21:03.923Z |
5562757 | 5562757 | 20241120000815_TS6KQ | UK0098 | 2024-11-21T14:15:20.175Z | 2024-11-22T14:21:03.443Z |
5562493 | 5562493 | 20241119234356_QWnVi | UK0098 | 2024-11-21T14:15:01.604Z | 2024-11-22T14:20:59.423Z |
5562465 | 5562465 | 20241119234035_rTPwP | UK0098 | 2024-11-21T14:14:54.453Z | 2024-11-22T14:20:58.834Z |
5562440 | 5562440 | 20241119233823_8dw7a | UK0098 | 2024-11-21T14:14:50.522Z | 2024-11-22T14:20:57.761Z |
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);