participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,685 rows where station_code = "UK00BA" 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 |
---|---|---|---|---|---|
5569893 | 5569893 | 20241120175339_c391V | UK00BA | 2024-11-22T14:14:31.322Z | 2024-11-22T14:19:21.823Z |
5569856 | 5569856 | 20241120174744_8IZwX | UK00BA | 2024-11-22T14:14:28.141Z | 2024-11-22T14:19:21.819Z |
5569816 | 5569816 | 20241120173627_6unxg | UK00BA | 2024-11-22T14:14:16.949Z | 2024-11-22T14:19:21.810Z |
5564980 | 5564980 | 20241120034321_ntdK7 | UK00BA | 2024-11-21T14:18:17.554Z | 2024-11-22T14:21:40.086Z |
5564958 | 5564958 | 20241120034200_cwBGQ | UK00BA | 2024-11-21T14:18:16.312Z | 2024-11-22T14:21:39.753Z |
5564704 | 5564704 | 20241120032124_6mw4v | UK00BA | 2024-11-21T14:17:58.786Z | 2024-11-22T14:21:35.740Z |
5564675 | 5564675 | 20241120031814_zV0ON | UK00BA | 2024-11-21T14:17:57.060Z | 2024-11-22T14:21:35.312Z |
5564408 | 5564408 | 20241120025250_gdKlR | UK00BA | 2024-11-21T14:17:33.048Z | 2024-11-22T14:21:31.220Z |
5564329 | 5564329 | 20241120024821_HgXM0 | UK00BA | 2024-11-21T14:17:27.541Z | 2024-11-22T14:21:30.498Z |
5564237 | 5564237 | 20241120024052_F3pwJ | UK00BA | 2024-11-21T14:17:21.119Z | 2024-11-22T14:21:29.276Z |
5563822 | 5563822 | 20241120020655_3NYjF | UK00BA | 2024-11-21T14:16:46.563Z | 2024-11-22T14:21:23.585Z |
5563792 | 5563792 | 20241120020425_FHfTL | UK00BA | 2024-11-21T14:16:43.969Z | 2024-11-22T14:21:22.950Z |
5563678 | 5563678 | 20241120015700_hsRmB | UK00BA | 2024-11-21T14:16:33.924Z | 2024-11-22T14:21:20.884Z |
5563645 | 5563645 | 20241120015409_NDtD6 | UK00BA | 2024-11-21T14:16:31.286Z | 2024-11-22T14:21:20.285Z |
5563486 | 5563486 | 20241120013358_SqA4s | UK00BA | 2024-11-21T14:16:10.410Z | 2024-11-22T14:21:16.718Z |
5563402 | 5563402 | 20241120012646_wTCjj | UK00BA | 2024-11-21T14:16:02.461Z | 2024-11-22T14:21:14.911Z |
5563358 | 5563358 | 20241120011935_0sJJ1 | UK00BA | 2024-11-21T14:15:58.463Z | 2024-11-22T14:21:13.509Z |
5563107 | 5563107 | 20241120005255_SpSvv | UK00BA | 2024-11-21T14:15:36.930Z | 2024-11-22T14:21:09.646Z |
5563033 | 5563033 | 20241120004428_2z2J3 | UK00BA | 2024-11-21T14:15:32.277Z | 2024-11-22T14:21:07.925Z |
5563006 | 5563006 | 20241120003931_y0m2p | UK00BA | 2024-11-21T14:15:31.480Z | 2024-11-22T14:21:07.671Z |
5562887 | 5562887 | 20241120002358_gYo9I | UK00BA | 2024-11-21T14:15:26.176Z | 2024-11-22T14:21:05.877Z |
5562805 | 5562805 | 20241120001502_OqK8O | UK00BA | 2024-11-21T14:15:22.894Z | 2024-11-22T14:21:04.582Z |
5562699 | 5562699 | 20241120000409_kYvs2 | UK00BA | 2024-11-21T14:15:17.226Z | 2024-11-22T14:21:02.584Z |
5562480 | 5562480 | 20241119234332_iw52E | UK00BA | 2024-11-21T14:14:59.171Z | 2024-11-22T14:20:59.278Z |
5562364 | 5562364 | 20241119233024_3YdW5 | UK00BA | 2024-11-21T14:14:45.123Z | 2024-11-22T14:20:56.744Z |
5562305 | 5562305 | 20241119232023_Fqa4N | UK00BA | 2024-11-21T14:14:41.402Z | 2024-11-22T14:20:55.637Z |
5562253 | 5562253 | 20241119231605_1Ydoh | UK00BA | 2024-11-21T14:14:36.362Z | 2024-11-22T14:20:54.546Z |
5562217 | 5562217 | 20241119231046_ICvUB | UK00BA | 2024-11-21T14:14:33.363Z | 2024-11-22T14:20:54.321Z |
5562181 | 5562181 | 20241119230840_X7t8Y | UK00BA | 2024-11-21T14:14:30.948Z | 2024-11-22T14:20:53.827Z |
5562090 | 5562090 | 20241119225909_FVmM9 | UK00BA | 2024-11-21T14:14:24.236Z | 2024-11-22T14:20:52.639Z |
5561943 | 5561943 | 20241119223631_eMMNm | UK00BA | 2024-11-21T14:14:16.029Z | 2024-11-22T14:20:50.054Z |
5561892 | 5561892 | 20241119222438_Tnv3d | UK00BA | 2024-11-21T14:14:12.527Z | 2024-11-22T14:20:48.989Z |
5561797 | 5561797 | 20241119221150_0MOWD | UK00BA | 2024-11-21T14:14:06.889Z | 2024-11-22T14:20:46.649Z |
5561519 | 5561519 | 20241119205123_zBptH | UK00BA | 2024-11-21T14:13:23.591Z | 2024-11-22T14:20:39.451Z |
5561383 | 5561383 | 20241119201929_hp9Eg | UK00BA | 2024-11-21T14:13:11.078Z | 2024-11-22T14:20:34.008Z |
5561339 | 5561339 | 20241119195831_mzQ2r | UK00BA | 2024-11-21T14:13:06.729Z | 2024-11-22T14:20:32.369Z |
5561284 | 5561284 | 20241119193226_pPeru | UK00BA | 2024-11-21T14:12:58.899Z | 2024-11-22T14:20:29.702Z |
5557489 | 5557489 | 20241120045025_1uRA1 | UK00BA | 2024-11-21T14:00:59.576Z | 2024-11-22T14:19:21.078Z |
5544966 | 5544966 | 20241115202200_XDDR9 | UK00BA | 2024-11-17T14:03:32.238Z | 2024-11-22T14:23:34.537Z |
5543647 | 5543647 | 20241115024147_dcgI8 | UK00BA | 2024-11-16T14:06:57.948Z | 2024-11-22T14:24:00.553Z |
5543628 | 5543628 | 20241115023831_ccU2s | UK00BA | 2024-11-16T14:06:57.041Z | 2024-11-22T14:24:00.520Z |
5543556 | 5543556 | 20241115020124_PBJHy | UK00BA | 2024-11-16T14:06:40.513Z | 2024-11-22T14:23:59.992Z |
5543514 | 5543514 | 20241115015212_Wh8vE | UK00BA | 2024-11-16T14:06:34.055Z | 2024-11-22T14:23:59.819Z |
5543502 | 5543502 | 20241115014742_feGyp | UK00BA | 2024-11-16T14:06:32.177Z | 2024-11-22T14:23:59.730Z |
5543477 | 5543477 | 20241115013806_ZxRMP | UK00BA | 2024-11-16T14:06:27.411Z | 2024-11-22T14:23:59.424Z |
5543434 | 5543434 | 20241115012149_0Odkx | UK00BA | 2024-11-16T14:06:20.119Z | 2024-11-22T14:23:59.346Z |
5543419 | 5543419 | 20241115011343_KGWjg | UK00BA | 2024-11-16T14:06:16.210Z | 2024-11-22T14:23:59.242Z |
5543364 | 5543364 | 20241115003749_VDPMs | UK00BA | 2024-11-16T14:06:08.949Z | 2024-11-22T14:23:58.389Z |
5543344 | 5543344 | 20241115002512_jVKrJ | UK00BA | 2024-11-16T14:06:07.838Z | 2024-11-22T14:23:58.331Z |
5543337 | 5543337 | 20241115001812_9T6B2 | UK00BA | 2024-11-16T14:06:07.272Z | 2024-11-22T14:23:58.309Z |
5543322 | 5543322 | 20241115001013_3w5J3 | UK00BA | 2024-11-16T14:06:05.468Z | 2024-11-22T14:23:58.171Z |
5543314 | 5543314 | 20241115000623_h2yWb | UK00BA | 2024-11-16T14:06:04.960Z | 2024-11-22T14:23:58.150Z |
5543289 | 5543289 | 20241114234951_Rx6zR | UK00BA | 2024-11-16T14:06:00.276Z | 2024-11-22T14:23:57.911Z |
5543270 | 5543270 | 20241114233508_gu9X1 | UK00BA | 2024-11-16T14:05:56.617Z | 2024-11-22T14:23:57.825Z |
5543247 | 5543247 | 20241114232047_e8L0E | UK00BA | 2024-11-16T14:05:49.518Z | 2024-11-22T14:23:57.686Z |
5543239 | 5543239 | 20241114231943_VA9xx | UK00BA | 2024-11-16T14:05:48.904Z | 2024-11-22T14:23:57.670Z |
5543226 | 5543226 | 20241114231634_fIDy4 | UK00BA | 2024-11-16T14:05:47.846Z | 2024-11-22T14:23:57.593Z |
5543177 | 5543177 | 20241114222307_3ZHKW | UK00BA | 2024-11-16T14:05:39.884Z | 2024-11-22T14:23:57.333Z |
5543171 | 5543171 | 20241114221335_Utfva | UK00BA | 2024-11-16T14:05:38.781Z | 2024-11-22T14:23:57.304Z |
5543098 | 5543098 | 20241114201252_Q3DIG | UK00BA | 2024-11-16T14:05:31.030Z | 2024-11-22T14:23:56.862Z |
5543093 | 5543093 | 20241114200356_zTzyC | UK00BA | 2024-11-16T14:05:30.459Z | 2024-11-22T14:23:56.830Z |
5543075 | 5543075 | 20241114194418_eLFlK | UK00BA | 2024-11-16T14:05:29.064Z | 2024-11-22T14:23:56.742Z |
5543066 | 5543066 | 20241114193924_FabPq | UK00BA | 2024-11-16T14:05:28.809Z | 2024-11-22T14:23:56.736Z |
5543033 | 5543033 | 20241114181349_8BQNO | UK00BA | 2024-11-16T14:05:22.784Z | 2024-11-22T14:23:56.216Z |
5543025 | 5543025 | 20241114180515_GzMJN | UK00BA | 2024-11-16T14:05:20.796Z | 2024-11-22T14:23:56.182Z |
5543012 | 5543012 | 20241114175945_p2U3D | UK00BA | 2024-11-16T14:05:15.940Z | 2024-11-22T14:23:56.080Z |
5542999 | 5542999 | 20241114173758_8ntN1 | UK00BA | 2024-11-16T14:05:14.273Z | 2024-11-22T14:23:55.900Z |
5541171 | 5541171 | 20241113183801_Hm0Rc | UK00BA | 2024-11-15T14:06:50.061Z | 2024-11-22T14:24:16.221Z |
5537137 | 5537137 | 20241112203428_FM1DZ | UK00BA | 2024-11-14T14:11:07.128Z | 2024-11-21T14:26:09.171Z |
5537109 | 5537109 | 20241112202828_71a8G | UK00BA | 2024-11-14T14:11:03.193Z | 2024-11-21T14:26:08.857Z |
5536481 | 5536481 | 20241112181134_vf2eH | UK00BA | 2024-11-14T14:10:02.632Z | 2024-11-21T14:26:01.279Z |
5536469 | 5536469 | 20241112180849_WyCnM | UK00BA | 2024-11-14T14:10:00.916Z | 2024-11-21T14:26:01.189Z |
5536403 | 5536403 | 20241112175513_QDsaD | UK00BA | 2024-11-14T14:09:50.420Z | 2024-11-21T14:26:00.756Z |
5536398 | 5536398 | 20241112175323_kbKfV | UK00BA | 2024-11-14T14:09:50.061Z | 2024-11-21T14:26:00.743Z |
5536349 | 5536349 | 20241112174008_p1zVJ | UK00BA | 2024-11-14T14:09:40.867Z | 2024-11-21T14:26:00.249Z |
5532706 | 5532706 | 20241112055354_42gIk | UK00BA | 2024-11-13T14:17:10.755Z | 2024-11-20T14:26:25.716Z |
5532578 | 5532578 | 20241112054003_CYDB2 | UK00BA | 2024-11-13T14:17:01.191Z | 2024-11-20T14:26:24.886Z |
5532427 | 5532427 | 20241112051905_X3ecm | UK00BA | 2024-11-13T14:16:43.691Z | 2024-11-20T14:26:22.794Z |
5532339 | 5532339 | 20241112050905_2DNAF | UK00BA | 2024-11-13T14:16:37.771Z | 2024-11-20T14:26:22.105Z |
5532275 | 5532275 | 20241112050121_a3oAt | UK00BA | 2024-11-13T14:16:32.601Z | 2024-11-20T14:26:21.527Z |
5532211 | 5532211 | 20241112045210_EbI3i | UK00BA | 2024-11-13T14:16:27.342Z | 2024-11-20T14:26:20.910Z |
5532056 | 5532056 | 20241112043258_UXP2k | UK00BA | 2024-11-13T14:16:13.633Z | 2024-11-20T14:26:18.302Z |
5531900 | 5531900 | 20241112041724_cVsNG | UK00BA | 2024-11-13T14:16:01.149Z | 2024-11-20T14:26:15.753Z |
5531858 | 5531858 | 20241112041322_XybJW | UK00BA | 2024-11-13T14:15:59.016Z | 2024-11-20T14:26:15.276Z |
5531831 | 5531831 | 20241112041143_R3moY | UK00BA | 2024-11-13T14:15:57.132Z | 2024-11-20T14:26:14.826Z |
5531780 | 5531780 | 20241112040839_JoyPT | UK00BA | 2024-11-13T14:15:54.537Z | 2024-11-20T14:26:14.263Z |
5531743 | 5531743 | 20241112040554_3P1R1 | UK00BA | 2024-11-13T14:15:53.353Z | 2024-11-20T14:26:13.762Z |
5531626 | 5531626 | 20241112035341_s7QvV | UK00BA | 2024-11-13T14:15:46.809Z | 2024-11-20T14:26:12.784Z |
5531522 | 5531522 | 20241112034655_Z9Z1g | UK00BA | 2024-11-13T14:15:43.716Z | 2024-11-20T14:26:11.914Z |
5531508 | 5531508 | 20241112034419_bJZx1 | UK00BA | 2024-11-13T14:15:43.042Z | 2024-11-20T14:26:11.844Z |
5531395 | 5531395 | 20241112033532_Ma1gr | UK00BA | 2024-11-13T14:15:37.357Z | 2024-11-20T14:26:11.091Z |
5531361 | 5531361 | 20241112033335_rzhbH | UK00BA | 2024-11-13T14:15:35.512Z | 2024-11-20T14:26:10.456Z |
5531316 | 5531316 | 20241112033136_R6Kik | UK00BA | 2024-11-13T14:15:34.155Z | 2024-11-20T14:26:10.346Z |
5531280 | 5531280 | 20241112032838_UxE3o | UK00BA | 2024-11-13T14:15:32.493Z | 2024-11-20T14:26:09.784Z |
5531178 | 5531178 | 20241112031935_CrCLa | UK00BA | 2024-11-13T14:15:22.131Z | 2024-11-20T14:26:08.418Z |
5530795 | 5530795 | 20241112024803_EztuA | UK00BA | 2024-11-13T14:14:39.180Z | 2024-11-20T14:26:03.655Z |
5530558 | 5530558 | 20241112022802_FuL6p | UK00BA | 2024-11-13T14:14:22.050Z | 2024-11-20T14:26:01.607Z |
5530478 | 5530478 | 20241112022232_8mADr | UK00BA | 2024-11-13T14:14:17.789Z | 2024-11-20T14:26:00.649Z |
5530432 | 5530432 | 20241112021641_yvEtG | UK00BA | 2024-11-13T14:14:15.212Z | 2024-11-20T14:25:59.728Z |
5530410 | 5530410 | 20241112021547_63DUS | UK00BA | 2024-11-13T14:14:14.340Z | 2024-11-20T14:25:58.474Z |
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);