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

1,489 rows where station_code = "UK008M" 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
9160568 9160568 20260106062438_H2ZoQ UK008M 2026-01-07T14:13:01.851Z 2026-01-13T15:09:33.051Z
9160471 9160471 20260106060055_IXgVJ UK008M 2026-01-07T14:12:44.416Z 2026-01-13T15:09:27.646Z
9160402 9160402 20260106054620_FTwiC UK008M 2026-01-07T14:12:29.945Z 2026-01-13T15:09:24.748Z
9160184 9160184 20260106050000_z2Jjj UK008M 2026-01-07T14:11:39.913Z 2026-01-13T15:09:06.310Z
9160132 9160132 20260106045302_KjP4k UK008M 2026-01-07T14:11:30.801Z 2026-01-13T15:09:03.904Z
9160089 9160089 20260106044656_BQn9Z UK008M 2026-01-07T14:11:21.758Z 2026-01-13T15:09:00.084Z
9160047 9160047 20260106043514_vYPL9 UK008M 2026-01-07T14:11:11.051Z 2026-01-13T15:08:57.931Z
9160004 9160004 20260106042847_fvdii UK008M 2026-01-07T14:11:03.378Z 2026-01-13T15:08:56.060Z
9159856 9159856 20260106040920_PQEqi UK008M 2026-01-07T14:10:39.173Z 2026-01-13T15:08:50.751Z
9159784 9159784 20260106034345_C3bBI UK008M 2026-01-07T14:10:23.275Z 2026-01-13T15:08:46.656Z
9159741 9159741 20260106033546_wTCA5 UK008M 2026-01-07T14:10:18.214Z 2026-01-13T15:08:39.487Z
9159676 9159676 20260106032643_nsk2q UK008M 2026-01-07T14:10:05.393Z 2026-01-13T15:08:37.036Z
9159523 9159523 20260106025631_9Q1cQ UK008M 2026-01-07T14:09:36.479Z 2026-01-13T15:08:28.823Z
9159465 9159465 20260106024440_16BaM UK008M 2026-01-07T14:09:22.166Z 2026-01-13T15:08:26.661Z
9159382 9159382 20260106023120_F3QSw UK008M 2026-01-07T14:09:11.029Z 2026-01-13T15:08:23.246Z
9159156 9159156 20260106015509_QVCr5 UK008M 2026-01-07T14:08:30.561Z 2026-01-13T15:08:10.591Z
9156062 9156062 20260104064111_aZcts UK008M 2026-01-06T14:38:29.478Z 2026-01-12T15:11:36.399Z
9156028 9156028 20260104063848_AsMyH UK008M 2026-01-06T14:38:25.879Z 2026-01-12T15:11:34.991Z
9155795 9155795 20260104062318_vhJ7U UK008M 2026-01-06T14:38:01.639Z 2026-01-12T15:11:28.049Z
9155707 9155707 20260104061729_Ki2AI UK008M 2026-01-06T14:37:56.256Z 2026-01-12T15:11:25.005Z
9155595 9155595 20260104060709_gGkuR UK008M 2026-01-06T14:37:43.764Z 2026-01-12T15:11:20.840Z
9155533 9155533 20260104060152_VY6GS UK008M 2026-01-06T14:37:30.304Z 2026-01-12T15:11:06.253Z
9155477 9155477 20260104055713_JSRpG UK008M 2026-01-06T14:37:24.927Z 2026-01-12T15:11:03.807Z
9155329 9155329 20260104055045_vT363 UK008M 2026-01-06T14:37:14.989Z 2026-01-12T15:10:57.334Z
9155281 9155281 20260104054910_D6KJl UK008M 2026-01-06T14:37:11.804Z 2026-01-12T15:10:55.676Z
9154753 9154753 20260104051254_BOSdY UK008M 2026-01-06T14:36:09.268Z 2026-01-12T15:10:18.978Z
9154695 9154695 20260104050955_6ErCe UK008M 2026-01-06T14:35:58.259Z 2026-01-12T15:10:16.325Z
9154414 9154414 20260104045613_EfXvf UK008M 2026-01-06T14:35:33.690Z 2026-01-12T15:09:50.342Z
9154390 9154390 20260104045458_f2tnd UK008M 2026-01-06T14:35:24.591Z 2026-01-12T15:09:49.483Z
9154317 9154317 20260104045238_L5FN3 UK008M 2026-01-06T14:35:19.491Z 2026-01-12T15:09:47.052Z
9154293 9154293 20260104045159_3G06r UK008M 2026-01-06T14:35:18.177Z 2026-01-12T15:09:46.432Z
9154247 9154247 20260104044923_G52hH UK008M 2026-01-06T14:35:12.629Z 2026-01-12T15:09:42.830Z
9154142 9154142 20260104044044_8Ol27 UK008M 2026-01-06T14:34:57.095Z 2026-01-12T15:09:38.564Z
9153894 9153894 20260104042108_YsOTi UK008M 2026-01-06T14:34:19.007Z 2026-01-12T15:09:12.059Z
9153633 9153633 20260104040514_ZCwib UK008M 2026-01-06T14:33:44.574Z 2026-01-12T15:08:58.732Z
9153556 9153556 20260104040105_Ej7of UK008M 2026-01-06T14:33:36.388Z 2026-01-12T15:08:56.079Z
9153429 9153429 20260104035442_NEOnO UK008M 2026-01-06T14:33:21.053Z 2026-01-12T15:08:45.266Z
9153365 9153365 20260104035323_R4D73 UK008M 2026-01-06T14:33:17.659Z 2026-01-12T15:08:34.485Z
9153265 9153265 20260104034832_muPAe UK008M 2026-01-06T14:32:56.760Z 2026-01-12T15:08:28.008Z
9146363 9146363 20260104034652_qcAet UK008M 2026-01-05T14:22:09.127Z 2026-01-12T15:08:26.517Z
9146112 9146112 20260104033632_gHvvd UK008M 2026-01-05T14:21:46.172Z 2026-01-12T15:08:19.860Z
9145977 9145977 20260104033243_cT2Yx UK008M 2026-01-05T14:21:29.331Z 2026-01-12T15:08:17.269Z
9145791 9145791 20260104032821_diblE UK008M 2026-01-05T14:21:18.735Z 2026-01-12T15:08:00.765Z
9145732 9145732 20260104032724_C7j0m UK008M 2026-01-05T14:21:07.114Z 2026-01-12T15:07:59.655Z
9145648 9145648 20260104032344_83emJ UK008M 2026-01-05T14:20:57.592Z 2026-01-12T15:07:56.740Z
9145623 9145623 20260104032241_dc7of UK008M 2026-01-05T14:20:55.703Z 2026-01-12T15:07:54.851Z
9145466 9145466 20260104031733_Et5Kx UK008M 2026-01-05T14:20:46.029Z 2026-01-12T15:07:50.007Z
9145383 9145383 20260104031514_ocPAD UK008M 2026-01-05T14:20:30.426Z 2026-01-12T15:07:48.032Z
9145346 9145346 20260104031441_gc2Yu UK008M 2026-01-05T14:20:27.910Z 2026-01-12T15:07:46.914Z
9145104 9145104 20260104030501_324xi UK008M 2026-01-05T14:20:11.909Z 2026-01-12T15:07:41.640Z
9144672 9144672 20260104025138_bRnEs UK008M 2026-01-05T14:19:29.237Z 2026-01-12T15:07:12.832Z
9144550 9144550 20260104024843_qOsn4 UK008M 2026-01-05T14:19:22.748Z 2026-01-12T15:07:10.204Z
9144499 9144499 20260104024620_0hDRS UK008M 2026-01-05T14:19:11.986Z 2026-01-12T15:07:08.664Z
9132416 9132416 20260103064050_oVYNH UK008M 2026-01-04T14:16:34.086Z 2026-01-10T15:01:27.430Z
9132251 9132251 20260103062548_TsBce UK008M 2026-01-04T14:16:10.834Z 2026-01-10T15:01:18.774Z
9132118 9132118 20260103061935_j1IZL UK008M 2026-01-04T14:15:54.088Z 2026-01-10T15:01:13.063Z
9132023 9132023 20260103061411_wnecv UK008M 2026-01-04T14:15:37.536Z 2026-01-10T15:01:10.287Z
9131987 9131987 20260103061326_2Caaq UK008M 2026-01-04T14:15:32.680Z 2026-01-10T15:01:03.390Z
9131912 9131912 20260103060538_eaPsH UK008M 2026-01-04T14:15:15.692Z 2026-01-10T15:01:01.137Z
9131838 9131838 20260103055955_fatlF UK008M 2026-01-04T14:15:01.008Z 2026-01-10T15:00:56.257Z
9131821 9131821 20260103055840_10xn1 UK008M 2026-01-04T14:14:59.557Z 2026-01-10T15:00:55.291Z
9131742 9131742 20260103055108_NtnJE UK008M 2026-01-04T14:14:48.780Z 2026-01-10T15:00:49.914Z
9131646 9131646 20260103054114_BuRKV UK008M 2026-01-04T14:14:34.573Z 2026-01-10T15:00:45.197Z
9131360 9131360 20260103051848_2QnwR UK008M 2026-01-04T14:13:35.652Z 2026-01-10T15:00:24.552Z
9131346 9131346 20260103051531_OjlnS UK008M 2026-01-04T14:13:31.569Z 2026-01-10T15:00:23.909Z
9131320 9131320 20260103051119_8ZjYX UK008M 2026-01-04T14:13:27.591Z 2026-01-10T15:00:21.793Z
9131308 9131308 20260103051057_yYMOU UK008M 2026-01-04T14:13:25.525Z 2026-01-10T15:00:20.462Z
9131207 9131207 20260103050020_5d6eA UK008M 2026-01-04T14:12:58.902Z 2026-01-10T15:00:14.501Z
9131086 9131086 20260103044929_cnaRN UK008M 2026-01-04T14:12:36.307Z 2026-01-10T14:59:58.630Z
9131015 9131015 20260103044139_Srga5 UK008M 2026-01-04T14:12:23.140Z 2026-01-10T14:59:54.721Z
9130962 9130962 20260103043700_bINQA UK008M 2026-01-04T14:12:11.294Z 2026-01-10T14:59:52.525Z
9130916 9130916 20260103043022_MkcqG UK008M 2026-01-04T14:12:03.787Z 2026-01-10T14:59:51.110Z
8553891 8553891 20251120061347_C3kQz UK008M 2025-11-22T14:34:31.928Z 2025-11-28T14:58:36.311Z
8553774 8553774 20251120060557_wIQQl UK008M 2025-11-22T14:34:27.649Z 2025-11-28T14:58:34.421Z
8553464 8553464 20251120053700_eUvwU UK008M 2025-11-22T14:33:59.143Z 2025-11-28T14:58:19.379Z
8552950 8552950 20251120044538_q29K9 UK008M 2025-11-22T14:33:14.104Z 2025-11-28T14:57:47.120Z
8552794 8552794 20251120043117_sfoKo UK008M 2025-11-22T14:33:05.280Z 2025-11-28T14:57:41.236Z
8552233 8552233 20251120035210_2kLeL UK008M 2025-11-22T14:32:01.044Z 2025-11-28T14:57:28.100Z
8552151 8552151 20251120034256_1RKNI UK008M 2025-11-22T14:31:53.586Z 2025-11-28T14:57:26.000Z
8551895 8551895 20251120032233_IZthr UK008M 2025-11-22T14:31:31.667Z 2025-11-28T14:57:17.760Z
8551435 8551435 20251120023746_yMEpL UK008M 2025-11-22T14:30:46.100Z 2025-11-28T14:56:57.414Z
8541523 8541523 20251120022921_rTZjl UK008M 2025-11-21T14:37:20.795Z 2025-11-28T14:56:51.778Z
8541443 8541443 20251120021932_NCzuH UK008M 2025-11-21T14:37:16.830Z 2025-11-28T14:56:47.386Z
8541170 8541170 20251120020212_6ocDU UK008M 2025-11-21T14:37:09.612Z 2025-11-28T14:56:39.469Z
8541118 8541118 20251120015606_ehAAZ UK008M 2025-11-21T14:37:07.412Z 2025-11-28T14:56:36.360Z
8540803 8540803 20251120013422_UZPnI UK008M 2025-11-21T14:36:58.415Z 2025-11-28T14:56:23.284Z
8540642 8540642 20251120011614_50u8n UK008M 2025-11-21T14:36:22.850Z 2025-11-28T14:56:17.859Z
8540105 8540105 20251120003609_GVb7K UK008M 2025-11-21T14:35:51.583Z 2025-11-28T14:56:04.238Z
8540070 8540070 20251120003411_w2Ab7 UK008M 2025-11-21T14:35:50.520Z 2025-11-28T14:56:03.991Z
8539662 8539662 20251119235548_ptC19 UK008M 2025-11-21T14:35:38.082Z 2025-11-28T14:55:52.552Z
8539348 8539348 20251119232615_IgbMW UK008M 2025-11-21T14:34:53.823Z 2025-11-28T14:55:47.334Z
8538997 8538997 20251119225334_e6Khx UK008M 2025-11-21T14:34:42.214Z 2025-11-28T14:55:40.632Z
8538560 8538560 20251119213953_hS6fa UK008M 2025-11-21T14:34:16.375Z 2025-11-28T14:55:32.225Z
8516074 8516074 20251118054333_i6FJb UK008M 2025-11-19T14:40:17.807Z 2025-11-19T14:40:17.807Z
8515873 8515873 20251118051714_zTQ3m UK008M 2025-11-19T14:40:01.269Z 2025-11-26T15:08:04.620Z
8515593 8515593 20251118044218_Y2gJk UK008M 2025-11-19T14:39:50.738Z 2025-11-26T15:08:01.807Z
8515428 8515428 20251118042555_R37yQ UK008M 2025-11-19T14:39:45.557Z 2025-11-26T15:08:00.965Z
8515282 8515282 20251118040841_gkTzi UK008M 2025-11-19T14:39:26.340Z 2025-11-26T15:08:00.023Z
8515232 8515232 20251118040216_YGlis UK008M 2025-11-19T14:39:14.370Z 2025-11-26T15:07:59.817Z
8514686 8514686 20251118025300_MDIyz UK008M 2025-11-19T14:38:24.365Z 2025-11-26T15:07:56.186Z

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