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,564 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
8686963 8686963 20251203220346_fkO2L UK009F 2025-12-05T14:13:16.032Z 2025-12-05T14:14:35.531Z
8683143 8683143 20251203063307_3C3Pi UK009F 2025-12-04T14:18:38.326Z 2025-12-05T14:23:08.904Z
8682887 8682887 20251203061351_awJqU UK009F 2025-12-04T14:18:11.957Z 2025-12-05T14:22:55.599Z
8682623 8682623 20251203055235_LZlKi UK009F 2025-12-04T14:17:44.014Z 2025-12-05T14:22:45.362Z
8682444 8682444 20251203053434_1Ovow UK009F 2025-12-04T14:17:12.736Z 2025-12-05T14:22:38.503Z
8682209 8682209 20251203050235_wT50f UK009F 2025-12-04T14:16:37.637Z 2025-12-05T14:22:18.681Z
8681990 8681990 20251203043451_22v33 UK009F 2025-12-04T14:16:05.851Z 2025-12-05T14:22:10.340Z
8681930 8681930 20251203042852_fht03 UK009F 2025-12-04T14:16:02.073Z 2025-12-05T14:22:08.604Z
8681816 8681816 20251203041157_R4Ycx UK009F 2025-12-04T14:15:40.645Z 2025-12-05T14:22:02.573Z
8681712 8681712 20251203034930_ZRzHx UK009F 2025-12-04T14:15:19.410Z 2025-12-05T14:21:50.469Z
8681509 8681509 20251203031644_127Pm UK009F 2025-12-04T14:14:50.727Z 2025-12-05T14:21:39.514Z
8681507 8681507 20251203031628_uFN9B UK009F 2025-12-04T14:14:50.434Z 2025-12-05T14:21:39.354Z
8681397 8681397 20251203030330_3saXL UK009F 2025-12-04T14:14:38.045Z 2025-12-05T14:21:35.257Z
8681083 8681083 20251203021810_K22ok UK009F 2025-12-04T14:13:43.869Z 2025-12-05T14:21:15.338Z
8680977 8680977 20251203020647_D155H UK009F 2025-12-04T14:13:29.982Z 2025-12-05T14:21:09.744Z
8680975 8680975 20251203020638_oW3Eg UK009F 2025-12-04T14:13:29.474Z 2025-12-05T14:21:09.625Z
8680835 8680835 20251203012749_aELdA UK009F 2025-12-04T14:13:01.922Z 2025-12-05T14:21:02.905Z
8680583 8680583 20251203004304_qFvGx UK009F 2025-12-04T14:12:24.750Z 2025-12-05T14:20:45.568Z
8680444 8680444 20251203000102_b24SH UK009F 2025-12-04T14:12:00.829Z 2025-12-05T14:20:38.672Z
8680354 8680354 20251202233631_83yzx UK009F 2025-12-04T14:11:51.266Z 2025-12-05T14:20:35.544Z
8678792 8678792 20251202172942_vi6W9 UK009F 2025-12-04T14:08:12.185Z 2025-12-05T14:19:00.883Z
8678774 8678774 20251202172216_Z2Z0W UK009F 2025-12-04T14:08:08.384Z 2025-12-05T14:18:59.034Z
8677165 8677165 20251203065618_Zmui2 UK009F 2025-12-04T14:00:12.118Z 2025-12-05T14:14:34.746Z
8667539 8667539 20251130020618_IWYaM UK009F 2025-12-02T14:38:48.706Z 2025-12-05T14:43:22.293Z
8667423 8667423 20251130011620_zrwr8 UK009F 2025-12-02T14:38:07.401Z 2025-12-05T14:42:46.899Z
8662040 8662040 20251130174724_DIaUp UK009F 2025-12-02T14:14:04.070Z 2025-12-05T14:32:49.921Z
8656385 8656385 20251130045228_2EZBb UK009F 2025-12-01T14:28:35.053Z 2025-12-01T14:28:35.053Z
8655796 8655796 20251130041900_1aiP9 UK009F 2025-12-01T14:27:29.924Z 2025-12-05T14:44:39.155Z
8653381 8653381 20251130021323_P0Dsb UK009F 2025-12-01T14:23:19.428Z 2025-12-05T14:43:30.301Z
8653333 8653333 20251130021114_3M5tx UK009F 2025-12-01T14:23:15.436Z 2025-12-05T14:43:29.263Z
8652269 8652269 20251130010027_EwuD0 UK009F 2025-12-01T14:21:05.096Z 2025-12-05T14:42:41.001Z
8651111 8651111 20251129224406_mYRuV UK009F 2025-12-01T14:18:01.975Z 2025-12-05T14:41:49.285Z
8650992 8650992 20251129222238_n4Yoe UK009F 2025-12-01T14:17:44.005Z 2025-12-05T14:41:27.311Z
8650879 8650879 20251129214835_Lipyb UK009F 2025-12-01T14:17:25.989Z 2025-12-05T14:41:21.602Z
8650862 8650862 20251129214411_LsvsR UK009F 2025-12-01T14:17:19.555Z 2025-12-05T14:41:21.052Z
8647848 8647848 20251129054358_dYjNR UK009F 2025-11-30T14:29:15.043Z 2025-12-05T14:52:48.969Z
8647833 8647833 20251129054059_QpnNy UK009F 2025-11-30T14:29:08.554Z 2025-12-05T14:52:48.621Z
8647773 8647773 20251129052623_S0Li2 UK009F 2025-11-30T14:28:52.920Z 2025-12-05T14:52:47.239Z
8647646 8647646 20251129050023_1qPTi UK009F 2025-11-30T14:28:41.144Z 2025-12-05T14:52:44.530Z
8647408 8647408 20251129043219_eOksh UK009F 2025-11-30T14:28:06.979Z 2025-12-05T14:52:39.361Z
8647398 8647398 20251129043049_5GAOc UK009F 2025-11-30T14:28:06.175Z 2025-12-05T14:52:39.145Z
8647397 8647397 20251129043047_xfZA3 UK009F 2025-11-30T14:28:06.007Z 2025-12-05T14:52:39.086Z
8646746 8646746 20251129024802_t8Tz5 UK009F 2025-11-30T14:26:46.769Z 2025-12-05T14:51:53.119Z
8646686 8646686 20251129023822_VIIjT UK009F 2025-11-30T14:26:39.901Z 2025-12-05T14:51:47.498Z
8646658 8646658 20251129023705_saM2t UK009F 2025-11-30T14:26:37.502Z 2025-12-05T14:51:46.694Z
8645642 8645642 20251128231520_27trP UK009F 2025-11-30T14:24:19.941Z 2025-12-05T14:51:01.746Z
8645622 8645622 20251128230827_Jx3dy UK009F 2025-11-30T14:24:17.648Z 2025-12-05T14:50:58.496Z
8637680 8637680 20251128061229_xkz9l UK009F 2025-11-29T14:27:42.448Z 2025-12-05T15:00:13.876Z
8636993 8636993 20251128044621_wCO4I UK009F 2025-11-29T14:26:30.850Z 2025-12-05T14:59:35.127Z
8636837 8636837 20251128043023_D3yU7 UK009F 2025-11-29T14:26:15.672Z 2025-12-05T14:59:30.758Z
8636188 8636188 20251128032722_9e3Gg UK009F 2025-11-29T14:25:03.083Z 2025-12-05T14:59:21.048Z
8633498 8633498 20251127232630_C3saF UK009F 2025-11-29T14:19:48.436Z 2025-12-05T14:57:43.880Z
8632741 8632741 20251127214720_RvSvt UK009F 2025-11-29T14:18:10.352Z 2025-12-05T14:56:35.079Z
8632419 8632419 20251127210510_InXzU UK009F 2025-11-29T14:17:27.299Z 2025-12-05T14:56:20.911Z
8611679 8611679 20251126015608_hEFPp UK009F 2025-11-27T14:22:29.421Z 2025-12-04T15:09:23.337Z
8611366 8611366 20251126013842_VLFfx UK009F 2025-11-27T14:22:04.166Z 2025-12-04T15:09:10.636Z
8611219 8611219 20251126013140_24raT UK009F 2025-11-27T14:21:40.336Z 2025-12-04T15:08:57.278Z
8611173 8611173 20251126012553_gsxHM UK009F 2025-11-27T14:21:34.556Z 2025-12-04T15:08:55.597Z
8610483 8610483 20251126004817_2ex1I UK009F 2025-11-27T14:20:13.171Z 2025-12-04T15:08:06.332Z
8607326 8607326 20251125203902_hXA3G UK009F 2025-11-27T14:13:15.344Z 2025-12-04T15:07:00.370Z
8603807 8603807 20251125064417_p2TR7 UK009F 2025-11-26T14:28:14.176Z 2025-12-02T15:09:37.591Z
8603772 8603772 20251125063939_wEMXE UK009F 2025-11-26T14:27:53.549Z 2025-12-02T15:09:37.338Z
8603563 8603563 20251125061500_yP8jG UK009F 2025-11-26T14:27:31.494Z 2025-12-02T15:09:36.269Z
8603369 8603369 20251125060140_Zj6be UK009F 2025-11-26T14:27:23.438Z 2025-12-02T15:09:35.508Z
8603322 8603322 20251125055622_ZKwZu UK009F 2025-11-26T14:27:20.804Z 2025-12-02T15:09:35.322Z
8603217 8603217 20251125055055_P9PmU UK009F 2025-11-26T14:27:15.477Z 2025-12-02T15:09:34.893Z
8603186 8603186 20251125054840_Hdwrl UK009F 2025-11-26T14:27:13.073Z 2025-12-02T15:09:34.723Z
8603173 8603173 20251125054730_n7NdH UK009F 2025-11-26T14:27:11.503Z 2025-12-02T15:09:34.668Z
8603055 8603055 20251125054007_WDCvh UK009F 2025-11-26T14:26:43.520Z 2025-12-02T15:09:34.157Z
8603014 8603014 20251125053818_P2L83 UK009F 2025-11-26T14:26:33.415Z 2025-12-02T15:09:33.943Z
8602434 8602434 20251125045551_NIjoi UK009F 2025-11-26T14:25:47.152Z 2025-12-02T15:09:30.904Z
8602209 8602209 20251125044135_73QBD UK009F 2025-11-26T14:25:26.331Z 2025-12-02T15:09:29.979Z
8601958 8601958 20251125042738_QbAUw UK009F 2025-11-26T14:25:13.483Z 2025-12-02T15:09:28.942Z
8601614 8601614 20251125040350_3GD14 UK009F 2025-11-26T14:24:31.590Z 2025-12-02T15:09:16.724Z
8601007 8601007 20251125032904_pQWcE UK009F 2025-11-26T14:23:34.068Z 2025-12-02T15:08:56.250Z
8600850 8600850 20251125031932_NptDD UK009F 2025-11-26T14:23:02.785Z 2025-12-02T15:08:51.730Z
8600684 8600684 20251125031249_i0Q6C UK009F 2025-11-26T14:22:52.972Z 2025-12-02T15:08:49.707Z
8599942 8599942 20251125023158_XVtBG UK009F 2025-11-26T14:21:49.788Z 2025-12-02T15:08:32.877Z
8599706 8599706 20251125021930_Dzfxr UK009F 2025-11-26T14:21:25.244Z 2025-12-02T15:08:30.978Z
8599370 8599370 20251125020245_Jm397 UK009F 2025-11-26T14:20:50.014Z 2025-12-02T15:08:23.633Z
8598812 8598812 20251125012640_BtwuR UK009F 2025-11-26T14:19:54.824Z 2025-12-02T15:08:09.446Z
8598666 8598666 20251125011715_EEaP7 UK009F 2025-11-26T14:19:25.333Z 2025-12-02T15:08:01.596Z
8598349 8598349 20251125005203_wsMzw UK009F 2025-11-26T14:18:40.223Z 2025-12-02T15:07:53.136Z
8597418 8597418 20251124233438_zhDEh UK009F 2025-11-26T14:16:48.089Z 2025-12-02T15:07:32.188Z
8596145 8596145 20251124200512_xvxEw UK009F 2025-11-26T14:13:49.573Z 2025-12-02T15:06:44.681Z
8592300 8592300 20251124063328_6rEWA UK009F 2025-11-25T14:26:18.249Z 2025-12-02T15:13:03.062Z
8580680 8580680 20251123060006_hf9gd UK009F 2025-11-24T14:17:37.613Z 2025-12-01T15:22:23.099Z
8580671 8580671 20251123054316_7gc3D UK009F 2025-11-24T14:17:36.490Z 2025-12-01T15:22:22.333Z
8580457 8580457 20251123042446_V3cW2 UK009F 2025-11-24T14:17:02.260Z 2025-12-01T15:22:17.422Z
8579426 8579426 20251122233948_3DTJZ UK009F 2025-11-24T14:14:20.115Z 2025-12-01T15:20:18.895Z
8579416 8579416 20251122233300_GazXA UK009F 2025-11-24T14:14:18.955Z 2025-12-01T15:20:18.491Z
8579285 8579285 20251122230344_QahBZ UK009F 2025-11-24T14:13:55.392Z 2025-12-01T15:20:12.381Z
8579276 8579276 20251122230057_yGNwq UK009F 2025-11-24T14:13:54.236Z 2025-12-01T15:20:12.193Z
8579238 8579238 20251122225017_Dql5t UK009F 2025-11-24T14:13:50.008Z 2025-12-01T15:20:08.121Z
8579234 8579234 20251122224911_vuTrY UK009F 2025-11-24T14:13:49.640Z 2025-12-01T15:20:08.007Z
8578920 8578920 20251122215045_q2XdE UK009F 2025-11-24T14:13:06.458Z 2025-12-01T15:19:56.012Z
8578862 8578862 20251122214117_nlnrv UK009F 2025-11-24T14:12:51.942Z 2025-12-01T15:19:54.658Z
8578823 8578823 20251122213131_P6SXB UK009F 2025-11-24T14:12:47.097Z 2025-12-01T15:19:53.557Z
8578700 8578700 20251122211717_Ym3Rz UK009F 2025-11-24T14:12:22.752Z 2025-12-01T15:19:50.273Z
8578459 8578459 20251122203838_043EB UK009F 2025-11-24T14:11:47.399Z 2025-12-01T15:19:38.276Z

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