participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,599 rows where station_code = "UK00AA" 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 |
---|---|---|---|---|---|
5570507 | 5570507 | 20241120195049_8DHTy | UK00AA | 2024-11-22T14:15:37.939Z | 2024-11-22T14:19:21.928Z |
5570489 | 5570489 | 20241120194714_prux6 | UK00AA | 2024-11-22T14:15:36.490Z | 2024-11-22T14:19:21.926Z |
5570198 | 5570198 | 20241120190142_unrGr | UK00AA | 2024-11-22T14:15:00.377Z | 2024-11-22T14:19:21.879Z |
5569872 | 5569872 | 20241120175241_GGHGV | UK00AA | 2024-11-22T14:14:29.002Z | 2024-11-22T14:19:21.820Z |
5565169 | 5565169 | 20241120035928_kwaNd | UK00AA | 2024-11-21T14:18:34.815Z | 2024-11-22T14:21:42.827Z |
5565153 | 5565153 | 20241120035721_5YBr7 | UK00AA | 2024-11-21T14:18:33.979Z | 2024-11-22T14:21:42.610Z |
5565065 | 5565065 | 20241120034902_PDRBG | UK00AA | 2024-11-21T14:18:26.234Z | 2024-11-22T14:21:40.734Z |
5562389 | 5562389 | 20241119233339_OtG0Y | UK00AA | 2024-11-21T14:14:46.319Z | 2024-11-22T14:20:57.025Z |
5562106 | 5562106 | 20241119230023_7Ldkr | UK00AA | 2024-11-21T14:14:25.429Z | 2024-11-22T14:20:52.945Z |
5562051 | 5562051 | 20241119225110_zMS4V | UK00AA | 2024-11-21T14:14:22.054Z | 2024-11-22T14:20:52.027Z |
5562041 | 5562041 | 20241119224959_2TBbn | UK00AA | 2024-11-21T14:14:21.557Z | 2024-11-22T14:20:51.875Z |
5561680 | 5561680 | 20241119213051_bIf85 | UK00AA | 2024-11-21T14:13:43.249Z | 2024-11-22T14:20:42.781Z |
5561622 | 5561622 | 20241119211607_cKtxU | UK00AA | 2024-11-21T14:13:35.393Z | 2024-11-22T14:20:42.176Z |
5561187 | 5561187 | 20241119185407_Fff9H | UK00AA | 2024-11-21T14:12:34.323Z | 2024-11-22T14:20:24.899Z |
5561146 | 5561146 | 20241119183511_cDd2I | UK00AA | 2024-11-21T14:12:28.441Z | 2024-11-22T14:20:22.839Z |
5561111 | 5561111 | 20241119181911_ITLxl | UK00AA | 2024-11-21T14:12:24.348Z | 2024-11-22T14:20:21.142Z |
5561080 | 5561080 | 20241119180057_87fUf | UK00AA | 2024-11-21T14:12:20.876Z | 2024-11-22T14:20:19.300Z |
5561073 | 5561073 | 20241119175323_sksKR | UK00AA | 2024-11-21T14:12:19.941Z | 2024-11-22T14:20:19.103Z |
5558391 | 5558391 | 20241120060139_ItavS | UK00AA | 2024-11-21T14:03:10.710Z | 2024-11-22T14:19:21.222Z |
5558379 | 5558379 | 20241120060132_nm3SC | UK00AA | 2024-11-21T14:03:09.773Z | 2024-11-22T14:19:21.221Z |
5553753 | 5553753 | 20241118041028_xfN3L | UK00AA | 2024-11-19T14:11:24.785Z | 2024-11-22T14:22:56.011Z |
5553576 | 5553576 | 20241118032152_LbeaL | UK00AA | 2024-11-19T14:10:56.832Z | 2024-11-22T14:22:54.368Z |
5553553 | 5553553 | 20241118031857_aFpLA | UK00AA | 2024-11-19T14:10:50.453Z | 2024-11-22T14:22:54.154Z |
5553547 | 5553547 | 20241118031524_cHSF3 | UK00AA | 2024-11-19T14:10:49.388Z | 2024-11-22T14:22:54.121Z |
5553449 | 5553449 | 20241118024451_V1A0l | UK00AA | 2024-11-19T14:10:35.686Z | 2024-11-22T14:22:53.279Z |
5553430 | 5553430 | 20241118023203_TS0t4 | UK00AA | 2024-11-19T14:10:33.735Z | 2024-11-22T14:22:53.177Z |
5553354 | 5553354 | 20241118020900_J2Ftq | UK00AA | 2024-11-19T14:10:20.922Z | 2024-11-22T14:22:52.390Z |
5553198 | 5553198 | 20241118013017_PfBFA | UK00AA | 2024-11-19T14:10:08.899Z | 2024-11-22T14:22:51.012Z |
5543938 | 5543938 | 20241115044357_bE2se | UK00AA | 2024-11-16T14:07:42.833Z | 2024-11-22T14:24:02.641Z |
5543402 | 5543402 | 20241115010900_gh1An | UK00AA | 2024-11-16T14:06:14.359Z | 2024-11-22T14:23:58.822Z |
5539302 | 5539302 | 20241114060910_5HoUL | UK00AA | 2024-11-15T14:00:37.909Z | 2024-11-22T14:23:42.935Z |
5539287 | 5539287 | 20241114060528_DAWFu | UK00AA | 2024-11-15T14:00:35.571Z | 2024-11-22T14:23:42.857Z |
5539260 | 5539260 | 20241114060146_kjs0C | UK00AA | 2024-11-15T14:00:30.958Z | 2024-11-22T14:23:42.775Z |
5539236 | 5539236 | 20241114055427_IykuT | UK00AA | 2024-11-15T14:00:26.682Z | 2024-11-22T14:23:42.613Z |
5539086 | 5539086 | 20241113054130_DJc5z | UK00AA | 2024-11-14T14:14:12.861Z | 2024-11-21T14:26:31.592Z |
5538896 | 5538896 | 20241113051124_vpql3 | UK00AA | 2024-11-14T14:14:02.371Z | 2024-11-21T14:26:29.586Z |
5538878 | 5538878 | 20241113050727_LpapR | UK00AA | 2024-11-14T14:14:01.609Z | 2024-11-21T14:26:29.352Z |
5538858 | 5538858 | 20241113050542_Tu9DE | UK00AA | 2024-11-14T14:14:00.867Z | 2024-11-21T14:26:29.221Z |
5538834 | 5538834 | 20241113050401_Eta2K | UK00AA | 2024-11-14T14:13:59.501Z | 2024-11-21T14:26:28.887Z |
5538692 | 5538692 | 20241113043713_PUQid | UK00AA | 2024-11-14T14:13:49.488Z | 2024-11-21T14:26:28.532Z |
5538599 | 5538599 | 20241113041944_Ee73k | UK00AA | 2024-11-14T14:13:42.745Z | 2024-11-21T14:26:27.538Z |
5538472 | 5538472 | 20241113035159_Abn6O | UK00AA | 2024-11-14T14:13:30.693Z | 2024-11-21T14:26:26.419Z |
5538443 | 5538443 | 20241113034532_VSQct | UK00AA | 2024-11-14T14:13:27.517Z | 2024-11-21T14:26:25.799Z |
5538413 | 5538413 | 20241113033452_oR2lm | UK00AA | 2024-11-14T14:13:24.637Z | 2024-11-21T14:26:25.328Z |
5538404 | 5538404 | 20241113033326_IM7zr | UK00AA | 2024-11-14T14:13:23.999Z | 2024-11-21T14:26:25.315Z |
5538374 | 5538374 | 20241113032255_70My4 | UK00AA | 2024-11-14T14:13:21.185Z | 2024-11-21T14:26:25.045Z |
5538305 | 5538305 | 20241113030255_HB3iZ | UK00AA | 2024-11-14T14:13:12.608Z | 2024-11-21T14:26:22.944Z |
5538293 | 5538293 | 20241113030008_XM86Y | UK00AA | 2024-11-14T14:13:11.500Z | 2024-11-21T14:26:22.937Z |
5538290 | 5538290 | 20241113025950_8fcG0 | UK00AA | 2024-11-14T14:13:11.410Z | 2024-11-21T14:26:22.934Z |
5538248 | 5538248 | 20241113024705_fLAGF | UK00AA | 2024-11-14T14:13:08.574Z | 2024-11-21T14:26:22.650Z |
5538109 | 5538109 | 20241113021337_7mcqI | UK00AA | 2024-11-14T14:12:51.488Z | 2024-11-21T14:26:20.749Z |
5538085 | 5538085 | 20241113020732_i633r | UK00AA | 2024-11-14T14:12:49.964Z | 2024-11-21T14:26:20.617Z |
5538025 | 5538025 | 20241113015631_ADKjY | UK00AA | 2024-11-14T14:12:44.151Z | 2024-11-21T14:26:18.952Z |
5538012 | 5538012 | 20241113015329_3WC07 | UK00AA | 2024-11-14T14:12:42.857Z | 2024-11-21T14:26:18.701Z |
5537955 | 5537955 | 20241113013949_H3wRs | UK00AA | 2024-11-14T14:12:39.642Z | 2024-11-21T14:26:17.473Z |
5537896 | 5537896 | 20241113012407_uWvwx | UK00AA | 2024-11-14T14:12:36.037Z | 2024-11-21T14:26:16.683Z |
5537855 | 5537855 | 20241113010729_aO6Qh | UK00AA | 2024-11-14T14:12:33.825Z | 2024-11-21T14:26:16.489Z |
5537749 | 5537749 | 20241113002645_dTNYO | UK00AA | 2024-11-14T14:12:27.891Z | 2024-11-21T14:26:15.636Z |
5537744 | 5537744 | 20241113002640_zoxQw | UK00AA | 2024-11-14T14:12:27.635Z | 2024-11-21T14:26:15.621Z |
5537691 | 5537691 | 20241113000745_VdCac | UK00AA | 2024-11-14T14:12:24.658Z | 2024-11-21T14:26:15.327Z |
5537675 | 5537675 | 20241113000236_MKVOI | UK00AA | 2024-11-14T14:12:23.829Z | 2024-11-21T14:26:15.185Z |
5537657 | 5537657 | 20241112235923_Zevg3 | UK00AA | 2024-11-14T14:12:22.817Z | 2024-11-21T14:26:15.086Z |
5537633 | 5537633 | 20241112235604_ShkYw | UK00AA | 2024-11-14T14:12:19.876Z | 2024-11-21T14:26:15.012Z |
5537600 | 5537600 | 20241112235151_4134Z | UK00AA | 2024-11-14T14:12:16.014Z | 2024-11-21T14:26:14.925Z |
5537567 | 5537567 | 20241112234026_Eqvh1 | UK00AA | 2024-11-14T14:12:10.691Z | 2024-11-21T14:26:14.246Z |
5537525 | 5537525 | 20241112233033_UzBH3 | UK00AA | 2024-11-14T14:12:03.084Z | 2024-11-21T14:26:14.007Z |
5537507 | 5537507 | 20241112232800_3a4Pm | UK00AA | 2024-11-14T14:12:01.018Z | 2024-11-21T14:26:13.983Z |
5537505 | 5537505 | 20241112232630_md9Am | UK00AA | 2024-11-14T14:12:00.782Z | 2024-11-21T14:26:13.964Z |
5537474 | 5537474 | 20241112231647_vH0Ij | UK00AA | 2024-11-14T14:11:54.520Z | 2024-11-21T14:26:13.285Z |
5537412 | 5537412 | 20241112224431_2OAw7 | UK00AA | 2024-11-14T14:11:45.733Z | 2024-11-21T14:26:12.738Z |
5537357 | 5537357 | 20241112221911_YAsVa | UK00AA | 2024-11-14T14:11:39.989Z | 2024-11-21T14:26:11.366Z |
5537348 | 5537348 | 20241112221404_b22TI | UK00AA | 2024-11-14T14:11:39.556Z | 2024-11-21T14:26:11.361Z |
5537302 | 5537302 | 20241112215747_NtRyR | UK00AA | 2024-11-14T14:11:32.828Z | 2024-11-21T14:26:11.050Z |
5537290 | 5537290 | 20241112215518_GtoU4 | UK00AA | 2024-11-14T14:11:31.159Z | 2024-11-21T14:26:10.825Z |
5537237 | 5537237 | 20241112211627_0C2RN | UK00AA | 2024-11-14T14:11:23.590Z | 2024-11-21T14:26:10.241Z |
5537207 | 5537207 | 20241112210024_ESgWx | UK00AA | 2024-11-14T14:11:18.492Z | 2024-11-21T14:26:09.719Z |
5536923 | 5536923 | 20241112194116_sNzfX | UK00AA | 2024-11-14T14:10:42.691Z | 2024-11-21T14:26:07.188Z |
5536704 | 5536704 | 20241112185549_DGuC7 | UK00AA | 2024-11-14T14:10:28.950Z | 2024-11-21T14:26:05.041Z |
5532916 | 5532916 | 20241113061632_z4wI8 | UK00AA | 2024-11-14T14:00:31.481Z | 2024-11-22T14:24:06.032Z |
5532876 | 5532876 | 20241113061059_UAHHs | UK00AA | 2024-11-14T14:00:26.816Z | 2024-11-22T14:24:05.803Z |
5532823 | 5532823 | 20241113055841_BpaVu | UK00AA | 2024-11-14T14:00:19.415Z | 2024-11-22T14:24:05.504Z |
5532694 | 5532694 | 20241112055313_QUoU9 | UK00AA | 2024-11-13T14:17:09.827Z | 2024-11-20T14:26:25.684Z |
5532661 | 5532661 | 20241112054849_AsD3P | UK00AA | 2024-11-13T14:17:07.448Z | 2024-11-20T14:26:25.511Z |
5532498 | 5532498 | 20241112053058_yq7Y4 | UK00AA | 2024-11-13T14:16:53.581Z | 2024-11-20T14:26:23.970Z |
5532425 | 5532425 | 20241112051905_X3ecm | UK00AA | 2024-11-13T14:16:43.690Z | 2024-11-20T14:26:22.794Z |
5532379 | 5532379 | 20241112051525_phoF9 | UK00AA | 2024-11-13T14:16:40.833Z | 2024-11-20T14:26:22.580Z |
5532064 | 5532064 | 20241112043353_oKPOV | UK00AA | 2024-11-13T14:16:13.947Z | 2024-11-20T14:26:18.316Z |
5531965 | 5531965 | 20241112042230_TYv1a | UK00AA | 2024-11-13T14:16:04.127Z | 2024-11-20T14:26:16.610Z |
5531720 | 5531720 | 20241112040338_cI8Mw | UK00AA | 2024-11-13T14:15:52.129Z | 2024-11-20T14:26:13.649Z |
5531612 | 5531612 | 20241112035218_z6aT8 | UK00AA | 2024-11-13T14:15:46.570Z | 2024-11-20T14:26:12.711Z |
5531321 | 5531321 | 20241112033156_0t4kw | UK00AA | 2024-11-13T14:15:34.345Z | 2024-11-20T14:26:10.348Z |
5531197 | 5531197 | 20241112032055_uNFXm | UK00AA | 2024-11-13T14:15:23.531Z | 2024-11-20T14:26:08.517Z |
5531002 | 5531002 | 20241112030513_0mqWT | UK00AA | 2024-11-13T14:14:58.973Z | 2024-11-20T14:26:05.863Z |
5530436 | 5530436 | 20241112021723_Qr3BQ | UK00AA | 2024-11-13T14:14:15.306Z | 2024-11-20T14:25:59.777Z |
5530428 | 5530428 | 20241112021620_3ziRH | UK00AA | 2024-11-13T14:14:14.989Z | 2024-11-20T14:25:58.913Z |
5530301 | 5530301 | 20241112020639_UDDIo | UK00AA | 2024-11-13T14:14:07.654Z | 2024-11-20T14:25:56.757Z |
5530243 | 5530243 | 20241112020146_L4M70 | UK00AA | 2024-11-13T14:14:04.221Z | 2024-11-20T14:25:55.920Z |
5530100 | 5530100 | 20241112014309_oKyEJ | UK00AA | 2024-11-13T14:13:51.736Z | 2024-11-20T14:25:54.296Z |
5530091 | 5530091 | 20241112014224_kW3VR | UK00AA | 2024-11-13T14:13:50.987Z | 2024-11-20T14:25:54.275Z |
5529930 | 5529930 | 20241112012444_EhUIF | UK00AA | 2024-11-13T14:13:24.940Z | 2024-11-20T14:25:51.075Z |
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);