participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,313 rows where station_code = "UK007Z" 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 |
---|---|---|---|---|---|
5557212 | 5557212 | 20241119043326_DdHZ9 | UK007Z | 2024-11-20T14:12:28.304Z | 2024-11-21T14:20:50.009Z |
5557175 | 5557175 | 20241119041940_wF07Q | UK007Z | 2024-11-20T14:12:24.916Z | 2024-11-21T14:20:48.847Z |
5557162 | 5557162 | 20241119041339_pq9Dx | UK007Z | 2024-11-20T14:12:23.507Z | 2024-11-21T14:20:48.636Z |
5557058 | 5557058 | 20241119033821_KbLF3 | UK007Z | 2024-11-20T14:12:06.055Z | 2024-11-21T14:20:45.019Z |
5557030 | 5557030 | 20241119032756_G7kiW | UK007Z | 2024-11-20T14:12:02.628Z | 2024-11-21T14:20:43.967Z |
5556989 | 5556989 | 20241119031630_LsJXK | UK007Z | 2024-11-20T14:11:55.397Z | 2024-11-21T14:20:42.561Z |
5556964 | 5556964 | 20241119030940_xAReb | UK007Z | 2024-11-20T14:11:51.610Z | 2024-11-21T14:20:42.276Z |
5556830 | 5556830 | 20241119020752_X54JY | UK007Z | 2024-11-20T14:11:32.033Z | 2024-11-21T14:20:36.871Z |
5556819 | 5556819 | 20241119020404_E2TPq | UK007Z | 2024-11-20T14:11:30.991Z | 2024-11-21T14:20:36.523Z |
5556791 | 5556791 | 20241119015027_CwaIe | UK007Z | 2024-11-20T14:11:28.540Z | 2024-11-21T14:20:35.511Z |
5556752 | 5556752 | 20241119014327_HaU4P | UK007Z | 2024-11-20T14:11:25.276Z | 2024-11-21T14:20:34.208Z |
5556745 | 5556745 | 20241119013659_n6mhJ | UK007Z | 2024-11-20T14:11:24.831Z | 2024-11-21T14:20:34.061Z |
5556695 | 5556695 | 20241119011326_5eQ2h | UK007Z | 2024-11-20T14:11:19.254Z | 2024-11-21T14:20:32.777Z |
5556690 | 5556690 | 20241119010805_M27id | UK007Z | 2024-11-20T14:11:18.296Z | 2024-11-21T14:20:32.686Z |
5556542 | 5556542 | 20241118231932_rg59v | UK007Z | 2024-11-20T14:10:41.994Z | 2024-11-21T14:20:27.400Z |
5556476 | 5556476 | 20241118220934_PTXKP | UK007Z | 2024-11-20T14:10:35.118Z | 2024-11-21T14:20:25.661Z |
5556439 | 5556439 | 20241118213405_Dgd9M | UK007Z | 2024-11-20T14:10:30.844Z | 2024-11-21T14:20:24.206Z |
5556427 | 5556427 | 20241118212728_moZFl | UK007Z | 2024-11-20T14:10:28.870Z | 2024-11-21T14:20:23.991Z |
5556373 | 5556373 | 20241118200703_DiCdc | UK007Z | 2024-11-20T14:10:11.442Z | 2024-11-21T14:20:19.826Z |
5556348 | 5556348 | 20241118192156_qSSH3 | UK007Z | 2024-11-20T14:10:00.609Z | 2024-11-21T14:20:18.574Z |
5556337 | 5556337 | 20241118191141_pliuN | UK007Z | 2024-11-20T14:09:59.041Z | 2024-11-21T14:20:17.815Z |
5556293 | 5556293 | 20241118180211_8vW8d | UK007Z | 2024-11-20T14:09:48.420Z | 2024-11-21T14:20:14.466Z |
5556280 | 5556280 | 20241118173057_0lEy8 | UK007Z | 2024-11-20T14:09:45.662Z | 2024-11-21T14:20:12.634Z |
5556275 | 5556275 | 20241118172848_zGIg8 | UK007Z | 2024-11-20T14:09:44.389Z | 2024-11-21T14:20:12.066Z |
5554118 | 5554118 | 20241119061518_37nu4 | UK007Z | 2024-11-20T14:00:47.247Z | 2024-11-21T14:18:52.981Z |
5554101 | 5554101 | 20241119060824_orxUl | UK007Z | 2024-11-20T14:00:44.731Z | 2024-11-21T14:18:52.978Z |
5554062 | 5554062 | 20241119055842_ECL0m | UK007Z | 2024-11-20T14:00:37.232Z | 2024-11-21T14:18:52.968Z |
5553999 | 5553999 | 20241119052125_Ifb1i | UK007Z | 2024-11-20T14:00:21.637Z | 2024-11-21T14:18:52.953Z |
5553989 | 5553989 | 20241119051138_0uY3R | UK007Z | 2024-11-20T14:00:19.592Z | 2024-11-21T14:18:52.951Z |
5553982 | 5553982 | 20241119050716_taQ3v | UK007Z | 2024-11-20T14:00:17.880Z | 2024-11-21T14:18:52.949Z |
5553858 | 5553858 | 20241118043407_Ffo06 | UK007Z | 2024-11-19T14:11:30.297Z | 2024-11-21T14:22:22.839Z |
5553813 | 5553813 | 20241118042630_1jKFE | UK007Z | 2024-11-19T14:11:28.193Z | 2024-11-21T14:22:22.555Z |
5553423 | 5553423 | 20241118023023_1xp90 | UK007Z | 2024-11-19T14:10:33.331Z | 2024-11-21T14:22:14.132Z |
5553332 | 5553332 | 20241118020617_ujWsh | UK007Z | 2024-11-19T14:10:19.934Z | 2024-11-21T14:22:12.354Z |
5553310 | 5553310 | 20241118020147_im39n | UK007Z | 2024-11-19T14:10:16.531Z | 2024-11-21T14:22:11.427Z |
5553222 | 5553222 | 20241118014134_N6dJI | UK007Z | 2024-11-19T14:10:10.531Z | 2024-11-21T14:22:09.123Z |
5553179 | 5553179 | 20241118012144_C6KlY | UK007Z | 2024-11-19T14:10:08.301Z | 2024-11-21T14:22:08.314Z |
5553176 | 5553176 | 20241118012142_es6pB | UK007Z | 2024-11-19T14:10:08.197Z | 2024-11-21T14:22:08.305Z |
5553150 | 5553150 | 20241118010630_nRecP | UK007Z | 2024-11-19T14:10:06.387Z | 2024-11-21T14:22:08.083Z |
5553107 | 5553107 | 20241118004439_m8Jjm | UK007Z | 2024-11-19T14:10:03.798Z | 2024-11-21T14:22:07.326Z |
5553065 | 5553065 | 20241118003613_OhOSA | UK007Z | 2024-11-19T14:10:01.151Z | 2024-11-21T14:22:06.532Z |
5553037 | 5553037 | 20241118002519_k108b | UK007Z | 2024-11-19T14:09:58.299Z | 2024-11-21T14:22:06.117Z |
5552943 | 5552943 | 20241117233743_zFb20 | UK007Z | 2024-11-19T14:09:52.496Z | 2024-11-21T14:22:04.918Z |
5552938 | 5552938 | 20241117233250_AZDBB | UK007Z | 2024-11-19T14:09:52.115Z | 2024-11-21T14:22:04.819Z |
5552919 | 5552919 | 20241117232834_h5Ls6 | UK007Z | 2024-11-19T14:09:47.601Z | 2024-11-21T14:22:04.274Z |
5552800 | 5552800 | 20241117215935_F1kpD | UK007Z | 2024-11-19T14:09:15.790Z | 2024-11-21T14:22:00.781Z |
5552748 | 5552748 | 20241117210955_HoWIW | UK007Z | 2024-11-19T14:09:06.627Z | 2024-11-21T14:21:59.209Z |
5552743 | 5552743 | 20241117210722_b88JW | UK007Z | 2024-11-19T14:09:05.593Z | 2024-11-21T14:21:59.159Z |
5552733 | 5552733 | 20241117205525_0muW3 | UK007Z | 2024-11-19T14:09:03.205Z | 2024-11-21T14:21:58.438Z |
5552679 | 5552679 | 20241117200925_768AN | UK007Z | 2024-11-19T14:08:54.381Z | 2024-11-21T14:21:54.865Z |
5552564 | 5552564 | 20241117184434_Lfdja | UK007Z | 2024-11-19T14:08:39.556Z | 2024-11-21T14:21:48.265Z |
5552521 | 5552521 | 20241117181609_OlWlE | UK007Z | 2024-11-19T14:08:27.065Z | 2024-11-21T14:21:45.941Z |
5552490 | 5552490 | 20241117172926_65xr6 | UK007Z | 2024-11-19T14:08:14.292Z | 2024-11-21T14:21:43.039Z |
5548572 | 5548572 | 20241117002448_n9kSu | UK007Z | 2024-11-18T14:09:30.854Z | 2024-11-21T14:22:59.481Z |
5548549 | 5548549 | 20241117001626_s5CBs | UK007Z | 2024-11-18T14:09:26.771Z | 2024-11-21T14:22:58.674Z |
5548312 | 5548312 | 20241116222340_f0qIC | UK007Z | 2024-11-18T14:08:43.918Z | 2024-11-21T14:22:53.592Z |
5548189 | 5548189 | 20241116210112_60Nhz | UK007Z | 2024-11-18T14:08:25.515Z | 2024-11-21T14:22:50.355Z |
5548149 | 5548149 | 20241116201947_dFL32 | UK007Z | 2024-11-18T14:08:20.490Z | 2024-11-21T14:22:49.179Z |
5548145 | 5548145 | 20241116201806_SojBK | UK007Z | 2024-11-18T14:08:19.905Z | 2024-11-21T14:22:49.136Z |
5548128 | 5548128 | 20241116200205_ZsB0h | UK007Z | 2024-11-18T14:08:17.883Z | 2024-11-21T14:22:48.404Z |
5548029 | 5548029 | 20241116182845_lxolg | UK007Z | 2024-11-18T14:07:49.834Z | 2024-11-21T14:22:44.545Z |
5543935 | 5543935 | 20241115044357_bE2se | UK007Z | 2024-11-16T14:07:42.833Z | 2024-11-21T14:24:36.896Z |
5543159 | 5543159 | 20241114215433_YnblC | UK007Z | 2024-11-16T14:05:37.769Z | 2024-11-21T14:24:24.223Z |
5543144 | 5543144 | 20241114215101_b82yi | UK007Z | 2024-11-16T14:05:37.038Z | 2024-11-21T14:24:24.203Z |
5543128 | 5543128 | 20241114211931_xz3LY | UK007Z | 2024-11-16T14:05:35.117Z | 2024-11-21T14:24:23.750Z |
5543101 | 5543101 | 20241114201803_6YYvG | UK007Z | 2024-11-16T14:05:31.389Z | 2024-11-21T14:24:23.003Z |
5543035 | 5543035 | 20241114181932_c39ZV | UK007Z | 2024-11-16T14:05:23.948Z | 2024-11-21T14:24:21.749Z |
5542992 | 5542992 | 20241114173720_y7oOA | UK007Z | 2024-11-16T14:05:13.878Z | 2024-11-21T14:24:21.018Z |
5542138 | 5542138 | 20241115060132_M6tRj | UK007Z | 2024-11-16T14:00:23.345Z | 2024-11-21T14:23:21.128Z |
5541830 | 5541830 | 20241114045011_JwsKV | UK007Z | 2024-11-15T14:08:32.700Z | 2024-11-21T14:25:19.232Z |
5541778 | 5541778 | 20241114042855_u9rgN | UK007Z | 2024-11-15T14:08:28.049Z | 2024-11-21T14:25:18.723Z |
5541765 | 5541765 | 20241114042223_LIaZw | UK007Z | 2024-11-15T14:08:23.218Z | 2024-11-21T14:25:18.488Z |
5541706 | 5541706 | 20241114035926_YraoG | UK007Z | 2024-11-15T14:08:12.993Z | 2024-11-21T14:25:18.196Z |
5541242 | 5541242 | 20241113214923_rYVL9 | UK007Z | 2024-11-15T14:07:06.960Z | 2024-11-21T14:25:11.739Z |
5539247 | 5539247 | 20241114055734_tzwGl | UK007Z | 2024-11-15T14:00:28.129Z | 2024-11-21T14:23:52.627Z |
5539195 | 5539195 | 20241114054842_skl3r | UK007Z | 2024-11-15T14:00:20.981Z | 2024-11-21T14:23:51.032Z |
5539189 | 5539189 | 20241114054721_AkI6Q | UK007Z | 2024-11-15T14:00:20.145Z | 2024-11-21T14:23:50.778Z |
5539175 | 5539175 | 20241114054615_YkIzn | UK007Z | 2024-11-15T14:00:17.633Z | 2024-11-21T14:23:50.151Z |
5539145 | 5539145 | 20241114054010_cCg61 | UK007Z | 2024-11-15T14:00:11.910Z | 2024-11-21T14:23:49.693Z |
5538857 | 5538857 | 20241113050542_Tu9DE | UK007Z | 2024-11-14T14:14:00.867Z | 2024-11-21T14:26:29.221Z |
5538817 | 5538817 | 20241113050222_3NP22 | UK007Z | 2024-11-14T14:13:59.043Z | 2024-11-21T14:26:28.826Z |
5538808 | 5538808 | 20241113050116_sRXwC | UK007Z | 2024-11-14T14:13:58.525Z | 2024-11-21T14:26:28.787Z |
5538754 | 5538754 | 20241113045057_AJKZo | UK007Z | 2024-11-14T14:13:55.029Z | 2024-11-21T14:26:28.686Z |
5538651 | 5538651 | 20241113043155_DTD8k | UK007Z | 2024-11-14T14:13:47.007Z | 2024-11-21T14:26:28.386Z |
5537322 | 5537322 | 20241112220630_W03ZH | UK007Z | 2024-11-14T14:11:35.077Z | 2024-11-21T14:26:11.233Z |
5537277 | 5537277 | 20241112215244_Pbvg9 | UK007Z | 2024-11-14T14:11:30.512Z | 2024-11-21T14:26:10.791Z |
5537254 | 5537254 | 20241112213521_8AC23 | UK007Z | 2024-11-14T14:11:27.845Z | 2024-11-21T14:26:10.702Z |
5537244 | 5537244 | 20241112212120_xgAwF | UK007Z | 2024-11-14T14:11:24.983Z | 2024-11-21T14:26:10.392Z |
5537192 | 5537192 | 20241112205410_thGPz | UK007Z | 2024-11-14T14:11:16.589Z | 2024-11-21T14:26:09.580Z |
5536853 | 5536853 | 20241112192846_x9uIB | UK007Z | 2024-11-14T14:10:37.663Z | 2024-11-21T14:26:06.520Z |
5536372 | 5536372 | 20241112174711_ceZLo | UK007Z | 2024-11-14T14:09:44.764Z | 2024-11-21T14:26:00.368Z |
5532063 | 5532063 | 20241112043353_oKPOV | UK007Z | 2024-11-13T14:16:13.947Z | 2024-11-20T14:26:18.316Z |
5531971 | 5531971 | 20241112042418_1fkpA | UK007Z | 2024-11-13T14:16:05.042Z | 2024-11-20T14:26:16.675Z |
5531876 | 5531876 | 20241112041641_OIo8l | UK007Z | 2024-11-13T14:16:00.347Z | 2024-11-20T14:26:15.549Z |
5531728 | 5531728 | 20241112040530_1hIwk | UK007Z | 2024-11-13T14:15:53.068Z | 2024-11-20T14:26:13.717Z |
5531564 | 5531564 | 20241112034855_MaKln | UK007Z | 2024-11-13T14:15:44.942Z | 2024-11-20T14:26:12.360Z |
5531440 | 5531440 | 20241112033955_6MJfM | UK007Z | 2024-11-13T14:15:39.744Z | 2024-11-20T14:26:11.289Z |
5531348 | 5531348 | 20241112033254_jgswI | UK007Z | 2024-11-13T14:15:35.421Z | 2024-11-20T14:26:10.443Z |
5531150 | 5531150 | 20241112031821_06llP | UK007Z | 2024-11-13T14:15:20.501Z | 2024-11-20T14:26:08.323Z |
5531124 | 5531124 | 20241112031611_YC8hB | UK007Z | 2024-11-13T14:15:16.733Z | 2024-11-20T14:26:08.100Z |
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);