home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,988 rows where station_code = "UK009F" sorted by created_at descending

✎ View and edit SQL

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
9234361 9234361 20260119210002_uPH2x UK009F 2026-01-21T14:13:58.514Z 2026-01-28T14:57:33.153Z
9234125 9234125 20260119194412_sVn29 UK009F 2026-01-21T14:12:29.078Z 2026-01-28T14:57:16.340Z
9234058 9234058 20260119192701_jIh59 UK009F 2026-01-21T14:12:03.835Z 2026-01-28T14:57:01.695Z
9231238 9231238 20260119064519_BEmLA UK009F 2026-01-20T14:31:58.407Z 2026-01-27T15:06:08.822Z
9231203 9231203 20260119063303_lIayY UK009F 2026-01-20T14:31:51.327Z 2026-01-27T15:06:05.793Z
9224888 9224888 20260118063647_koLU1 UK009F 2026-01-19T14:26:35.304Z 2026-01-26T15:03:53.232Z
9218249 9218249 20260117021014_Hp8j8 UK009F 2026-01-18T14:11:16.463Z 2026-01-25T14:58:18.580Z
9218230 9218230 20260117020325_OtzSc UK009F 2026-01-18T14:11:08.955Z 2026-01-25T14:58:17.734Z
9218158 9218158 20260117011518_fB3LH UK009F 2026-01-18T14:10:46.682Z 2026-01-25T14:58:02.451Z
9218128 9218128 20260117003938_jBi5q UK009F 2026-01-18T14:10:37.687Z 2026-01-25T14:58:01.161Z
9218010 9218010 20260116214919_Mmjgk UK009F 2026-01-18T14:09:57.377Z 2026-01-25T14:57:55.026Z
9217788 9217788 20260116194852_WCgeX UK009F 2026-01-18T14:09:02.054Z 2026-01-25T14:57:47.841Z
9217777 9217777 20260116194431_CDbmr UK009F 2026-01-18T14:08:57.530Z 2026-01-25T14:57:47.328Z
9214591 9214591 20260116070034_J8xvw UK009F 2026-01-17T14:22:12.505Z 2026-01-24T15:13:53.811Z
9214509 9214509 20260116064616_Kui6v UK009F 2026-01-17T14:21:49.107Z 2026-01-24T15:13:45.330Z
9214429 9214429 20260116063354_4UgUL UK009F 2026-01-17T14:21:31.068Z 2026-01-24T15:13:36.959Z
9214405 9214405 20260116062817_assDg UK009F 2026-01-17T14:21:21.980Z 2026-01-24T15:13:35.247Z
9214317 9214317 20260116061503_32c6G UK009F 2026-01-17T14:21:04.304Z 2026-01-24T15:13:29.727Z
9214210 9214210 20260116055437_ia7RP UK009F 2026-01-17T14:20:36.580Z 2026-01-24T15:13:23.059Z
9214107 9214107 20260116053505_HHtLW UK009F 2026-01-17T14:20:06.251Z 2026-01-24T15:13:06.442Z
9214064 9214064 20260116052954_nLM7s UK009F 2026-01-17T14:19:54.672Z 2026-01-24T15:13:03.498Z
9213955 9213955 20260116050520_38iGR UK009F 2026-01-17T14:19:19.455Z 2026-01-24T15:12:53.624Z
9213834 9213834 20260116045050_ijOCm UK009F 2026-01-17T14:18:44.765Z 2026-01-24T15:12:48.415Z
9213794 9213794 20260116044213_jf5Hg UK009F 2026-01-17T14:18:31.724Z 2026-01-24T15:12:46.923Z
9213504 9213504 20260116034754_n7Rgm UK009F 2026-01-17T14:17:14.197Z 2026-01-24T15:12:18.718Z
9213372 9213372 20260116031843_hYHva UK009F 2026-01-17T14:16:39.421Z 2026-01-24T15:12:11.138Z
9213284 9213284 20260116030311_fg22c UK009F 2026-01-17T14:16:17.075Z 2026-01-24T15:12:07.327Z
9213270 9213270 20260116025848_cKHnX UK009F 2026-01-17T14:16:14.087Z 2026-01-24T15:12:06.655Z
9213247 9213247 20260116024656_BO6Ac UK009F 2026-01-17T14:16:04.973Z 2026-01-24T15:11:51.368Z
9213159 9213159 20260116022849_TXosc UK009F 2026-01-17T14:15:43.421Z 2026-01-24T15:11:47.433Z
9213034 9213034 20260116015928_AVZtU UK009F 2026-01-17T14:15:04.881Z 2026-01-24T15:11:38.228Z
9212871 9212871 20260116012652_sns0O UK009F 2026-01-17T14:14:19.755Z 2026-01-24T15:11:31.727Z
9212717 9212717 20260116003059_A2k3y UK009F 2026-01-17T14:13:27.939Z 2026-01-24T15:11:14.915Z
9212580 9212580 20260115232017_P62v0 UK009F 2026-01-17T14:12:46.613Z 2026-01-24T15:11:04.251Z
9212564 9212564 20260115231346_AXNvS UK009F 2026-01-17T14:12:43.063Z 2026-01-24T15:11:03.341Z
9212364 9212364 20260115205017_kDHRR UK009F 2026-01-17T14:11:23.464Z 2026-01-24T15:10:49.333Z
9212257 9212257 20260115201058_slfOH UK009F 2026-01-17T14:10:53.964Z 2026-01-24T15:10:44.987Z
9212063 9212063 20260115190236_lfaci UK009F 2026-01-17T14:09:45.271Z 2026-01-24T15:10:21.790Z
9212040 9212040 20260115185240_ttrsG UK009F 2026-01-17T14:09:40.302Z 2026-01-24T15:10:20.685Z
9211828 9211828 20260115175813_GpsIm UK009F 2026-01-17T14:08:40.145Z 2026-01-24T15:09:57.491Z
9202916 9202916 20260114041837_QXLmV UK009F 2026-01-15T14:22:47.803Z 2026-01-22T15:09:59.415Z
9202747 9202747 20260114040650_NQAOM UK009F 2026-01-15T14:22:17.488Z 2026-01-22T15:09:34.671Z
9200994 9200994 20260114012855_ZqKyM UK009F 2026-01-15T14:17:10.727Z 2026-01-22T15:08:47.068Z
9200215 9200215 20260113231231_T55pd UK009F 2026-01-15T14:14:13.094Z 2026-01-22T15:08:11.492Z
9200208 9200208 20260113230940_3Z9TB UK009F 2026-01-15T14:14:11.069Z 2026-01-22T15:08:11.268Z
9199910 9199910 20260113215508_7heES UK009F 2026-01-15T14:13:02.053Z 2026-01-22T15:08:05.314Z
9199866 9199866 20260113213728_HuF5h UK009F 2026-01-15T14:12:53.193Z 2026-01-22T15:08:04.343Z
9199159 9199159 20260113191345_rfVk1 UK009F 2026-01-15T14:09:34.158Z 2026-01-22T15:07:15.418Z
9198735 9198735 20260113174704_glXh1 UK009F 2026-01-15T14:06:49.250Z 2026-01-22T15:07:02.526Z
9196213 9196213 20260113052754_q4oXn UK009F 2026-01-14T14:17:11.411Z 2026-01-21T15:05:29.696Z
9196165 9196165 20260113050634_aTeWR UK009F 2026-01-14T14:16:56.363Z 2026-01-21T15:05:28.987Z
9196151 9196151 20260113045715_Tqloq UK009F 2026-01-14T14:16:52.113Z 2026-01-21T15:05:28.768Z
9196148 9196148 20260113045454_g3qTG UK009F 2026-01-14T14:16:51.355Z 2026-01-21T15:05:28.742Z
9196051 9196051 20260113041808_f0XUr UK009F 2026-01-14T14:16:20.907Z 2026-01-21T15:05:15.859Z
9195950 9195950 20260113033835_fvBip UK009F 2026-01-14T14:15:42.299Z 2026-01-21T15:04:50.704Z
9194223 9194223 20260112190241_EbsTu UK009F 2026-01-14T14:08:07.403Z 2026-01-21T15:03:42.892Z
9171491 9171491 20260108221700_EQv23 UK009F 2026-01-10T14:07:41.970Z 2026-01-17T15:24:02.996Z
9171449 9171449 20260108215331_xapN3 UK009F 2026-01-10T14:07:27.888Z 2026-01-17T15:23:52.437Z
9171166 9171166 20260108194455_wB7Bu UK009F 2026-01-10T14:05:39.832Z 2026-01-17T15:23:34.892Z
9156163 9156163 20260104070409_T9Wa4 UK009F 2026-01-06T14:38:41.657Z 2026-01-12T15:11:41.956Z
9155421 9155421 20260104055459_u7kK0 UK009F 2026-01-06T14:37:21.000Z 2026-01-12T15:11:00.139Z
9153411 9153411 20260104035416_Yn4Sf UK009F 2026-01-06T14:33:20.008Z 2026-01-12T15:08:35.796Z
9148113 9148113 20260103173102_fP8p0 UK009F 2026-01-05T14:30:17.307Z 2026-01-10T15:04:15.662Z
9127923 9127923 20260102055110_matQf UK009F 2026-01-03T14:12:38.800Z 2026-01-09T14:50:17.760Z
9121748 9121748 20260101022057_0vKaz UK009F 2026-01-02T14:09:09.961Z 2026-01-09T14:52:32.737Z
9116786 9116786 20251231064920_3X2k8 UK009F 2026-01-01T14:28:55.375Z 2026-01-08T15:12:10.991Z
9104812 9104812 20251230065631_UfdJ2 UK009F 2025-12-31T14:22:30.801Z 2026-01-07T15:10:06.862Z
9104279 9104279 20251230054213_qjp7Y UK009F 2025-12-31T14:20:53.320Z 2026-01-07T15:09:37.805Z
9085561 9085561 20251228033738_5Xo71 UK009F 2025-12-30T14:38:48.570Z 2026-01-05T15:09:37.438Z
9085466 9085466 20251228032838_YDJJT UK009F 2025-12-30T14:38:37.023Z 2025-12-31T14:51:14.164Z
9085293 9085293 20251228031226_vIudx UK009F 2025-12-30T14:38:06.439Z 2026-01-05T15:09:19.434Z
9083474 9083474 20251227235938_X765b UK009F 2025-12-30T14:32:51.029Z 2026-01-05T15:07:50.634Z
9083431 9083431 20251227235526_EqbCo UK009F 2025-12-30T14:32:36.609Z 2025-12-30T14:53:54.178Z
9042553 9042553 20251224182417_8qCQq UK009F 2025-12-28T14:45:56.479Z 2026-01-01T15:57:06.283Z
9037149 9037149 20251224061111_h1HeH UK009F 2025-12-28T14:36:42.664Z 2026-01-01T15:54:44.567Z
9036941 9036941 20251224054819_t3OTx UK009F 2025-12-28T14:36:16.982Z 2026-01-01T15:54:42.414Z
9036939 9036939 20251224054809_AdvCe UK009F 2025-12-28T14:36:16.736Z 2026-01-01T15:54:42.303Z
9036893 9036893 20251224054057_KjegJ UK009F 2025-12-28T14:36:12.192Z 2026-01-01T15:54:41.695Z
9036830 9036830 20251224053035_3g1Ao UK009F 2025-12-28T14:36:02.639Z 2026-01-01T15:54:40.697Z
9036754 9036754 20251224051656_1wtm5 UK009F 2025-12-28T14:35:42.296Z 2026-01-01T15:54:39.812Z
9036537 9036537 20251224044524_gjRsp UK009F 2025-12-28T14:35:22.625Z 2025-12-28T14:48:35.044Z
9036487 9036487 20251224043308_bGnqh UK009F 2025-12-28T14:35:04.025Z 2025-12-28T14:48:35.003Z
9036435 9036435 20251224042242_YEsWz UK009F 2025-12-28T14:34:59.074Z 2026-01-01T15:54:35.137Z
9036428 9036428 20251224042207_ytqFX UK009F 2025-12-28T14:34:58.309Z 2026-01-01T15:54:35.051Z
9023389 9023389 20251220195143_y3Ths UK009F 2025-12-27T15:09:01.065Z 2025-12-29T15:26:19.534Z
9023196 9023196 20251220192850_x436S UK009F 2025-12-27T15:08:47.658Z 2025-12-29T15:26:16.975Z
9023127 9023127 20251220192104_io3mH UK009F 2025-12-27T15:08:46.264Z 2025-12-29T15:26:16.491Z
9022213 9022213 20251220171938_08WEq UK009F 2025-12-27T15:08:26.626Z 2025-12-29T15:26:08.474Z
9005256 9005256 20251221003623_TZRxj UK009F 2025-12-27T14:33:32.592Z 2025-12-27T14:33:32.592Z
8987129 8987129 20251218073601_26L7t UK009F 2025-12-26T14:39:32.713Z 2025-12-27T15:20:04.032Z
8987042 8987042 20251218071707_biaOh UK009F 2025-12-26T14:39:23.546Z 2025-12-27T15:19:59.938Z
8986891 8986891 20251218065516_FKfFW UK009F 2025-12-26T14:39:01.414Z 2025-12-26T14:39:01.414Z
8986755 8986755 20251218063356_8NV4g UK009F 2025-12-26T14:38:49.200Z 2025-12-27T15:19:37.616Z
8986546 8986546 20251218055413_S8wUp UK009F 2025-12-26T14:38:14.687Z 2025-12-27T15:19:18.742Z
8986495 8986495 20251218054227_TL2CY UK009F 2025-12-26T14:37:58.822Z 2025-12-27T15:19:17.878Z
8986387 8986387 20251218051901_2x8cN UK009F 2025-12-26T14:37:45.186Z 2025-12-27T15:19:16.027Z
8986328 8986328 20251218050454_cxfXh UK009F 2025-12-26T14:37:37.931Z 2025-12-27T15:19:15.245Z
8986325 8986325 20251218050447_Du96H UK009F 2025-12-26T14:37:37.799Z 2025-12-26T14:37:37.799Z
8986251 8986251 20251218045255_a7Bvp UK009F 2025-12-26T14:37:22.006Z 2025-12-27T15:19:14.398Z
8986239 8986239 20251218045010_0IojE UK009F 2025-12-26T14:37:20.569Z 2025-12-27T15:19:14.098Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network