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

5,840 rows where station_code = "UK009M" 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
9272680 9272680 20260128030051_2Ey2F UK009M 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.438Z
9272630 9272630 20260128025020_wgSPd UK009M 2026-01-29T14:27:16.009Z 2026-01-29T14:30:25.403Z
9272564 9272564 20260128023651_kyrCs UK009M 2026-01-29T14:27:10.560Z 2026-01-29T14:30:25.378Z
9272050 9272050 20260127232832_bVFPm UK009M 2026-01-29T14:25:24.857Z 2026-01-29T14:30:25.270Z
9271871 9271871 20260127211707_DsgGa UK009M 2026-01-29T14:24:41.219Z 2026-01-29T14:30:25.216Z
9256242 9256242 20260124062548_4uJNM UK009M 2026-01-25T14:16:17.329Z 2026-01-29T14:48:30.494Z
9256189 9256189 20260124061150_zuscB UK009M 2026-01-25T14:16:08.517Z 2026-01-29T14:48:27.523Z
9256038 9256038 20260124054633_Pijqm UK009M 2026-01-25T14:15:36.894Z 2026-01-29T14:48:19.265Z
9256013 9256013 20260124054236_xhwhE UK009M 2026-01-25T14:15:33.931Z 2026-01-29T14:48:18.402Z
9255349 9255349 20260124030057_MNqD3 UK009M 2026-01-25T14:13:01.073Z 2026-01-29T14:47:25.432Z
9255274 9255274 20260124022324_hUjBi UK009M 2026-01-25T14:12:38.461Z 2026-01-29T14:47:14.372Z
9255114 9255114 20260124005853_W3PyP UK009M 2026-01-25T14:11:56.195Z 2026-01-29T14:47:03.092Z
9255006 9255006 20260124001258_E9L3N UK009M 2026-01-25T14:11:37.092Z 2026-01-29T14:46:59.442Z
9254909 9254909 20260123223355_Fe0en UK009M 2026-01-25T14:11:13.478Z 2026-01-29T14:46:54.686Z
9252432 9252432 20260123030640_F4QL1 UK009M 2026-01-24T14:15:34.336Z 2026-01-29T14:52:53.369Z
9252162 9252162 20260123012037_8Hq6f UK009M 2026-01-24T14:14:35.766Z 2026-01-29T14:52:36.994Z
9244039 9244039 20260121055726_6Y4Zo UK009M 2026-01-22T14:23:59.428Z 2026-01-29T15:05:49.374Z
9214253 9214253 20260116055941_FDscH UK009M 2026-01-17T14:20:45.260Z 2026-01-24T15:13:26.081Z
9214245 9214245 20260116055823_p2BRG UK009M 2026-01-17T14:20:43.088Z 2026-01-24T15:13:25.542Z
9213779 9213779 20260116043836_kJtKC UK009M 2026-01-17T14:18:27.669Z 2026-01-24T15:12:46.168Z
9213493 9213493 20260116034704_YhsxW UK009M 2026-01-17T14:17:10.542Z 2026-01-24T15:12:18.110Z
9212878 9212878 20260116012948_vO4QH UK009M 2026-01-17T14:14:22.442Z 2026-01-24T15:11:32.061Z
9207895 9207895 20260115032904_3zKu0 UK009M 2026-01-16T14:10:33.680Z 2026-01-22T15:03:55.976Z
9207846 9207846 20260115031832_x0vRr UK009M 2026-01-16T14:10:23.811Z 2026-01-22T15:03:54.655Z
9207832 9207832 20260115031459_TDW3s UK009M 2026-01-16T14:10:17.501Z 2026-01-22T15:03:54.123Z
9207824 9207824 20260115031416_g2PJy UK009M 2026-01-16T14:10:16.324Z 2026-01-22T15:03:54.009Z
9202290 9202290 20260114032626_3IpLs UK009M 2026-01-15T14:20:53.844Z 2026-01-22T15:09:16.017Z
9201438 9201438 20260114021750_kF4PX UK009M 2026-01-15T14:18:40.155Z 2026-01-16T14:25:54.079Z
9201434 9201434 20260114021750_Z4DLx UK009M 2026-01-15T14:18:39.651Z 2026-01-22T15:09:03.904Z
9195118 9195118 20260113002339_ZubIX UK009M 2026-01-14T14:12:05.496Z 2026-01-21T15:04:36.609Z
9163419 9163419 20260107063424_0EvIS UK009M 2026-01-08T14:09:06.002Z 2026-01-08T14:16:36.137Z
9163340 9163340 20260107062334_f37U2 UK009M 2026-01-08T14:08:49.106Z 2026-01-13T15:03:09.997Z
9163098 9163098 20260107054351_8XrNE UK009M 2026-01-08T14:08:07.824Z 2026-01-13T15:03:01.332Z
9162822 9162822 20260107044035_xMsBL UK009M 2026-01-08T14:07:00.887Z 2026-01-13T15:02:41.187Z
9160190 9160190 20260106050026_SFeWS UK009M 2026-01-07T14:11:41.142Z 2026-01-13T15:09:06.619Z
9160185 9160185 20260106050000_z2Jjj UK009M 2026-01-07T14:11:39.913Z 2026-01-13T15:09:06.310Z
9160105 9160105 20260106044712_iwAi1 UK009M 2026-01-07T14:11:24.927Z 2026-01-13T15:09:00.830Z
9159838 9159838 20260106040620_D4LU3 UK009M 2026-01-07T14:10:36.507Z 2026-01-13T15:08:49.981Z
9159736 9159736 20260106033534_Yn5KI UK009M 2026-01-07T14:10:17.643Z 2026-01-13T15:08:39.326Z
9159604 9159604 20260106031230_ysv3a UK009M 2026-01-07T14:09:53.185Z 2026-01-13T15:08:32.737Z
9159325 9159325 20260106022153_Jzbm2 UK009M 2026-01-07T14:08:58.747Z 2026-01-13T15:08:20.796Z
9158652 9158652 20260105235533_4NCSU UK009M 2026-01-07T14:06:54.034Z 2026-01-13T15:07:40.849Z
9157853 9157853 20260105190305_niIFI UK009M 2026-01-07T14:03:51.219Z 2026-01-13T15:06:34.495Z
9157637 9157637 20260105181005_F33Ng UK009M 2026-01-07T14:02:57.035Z 2026-01-13T15:06:21.225Z
9157598 9157598 20260105180542_9YNCw UK009M 2026-01-07T14:02:49.087Z 2026-01-13T15:06:19.581Z
9157585 9157585 20260105175929_NUHs0 UK009M 2026-01-07T14:02:43.723Z 2026-01-13T15:06:18.529Z
9156004 9156004 20260104063605_HYeOx UK009M 2026-01-06T14:38:25.085Z 2026-01-12T15:11:34.456Z
9155849 9155849 20260104062647_uB5hy UK009M 2026-01-06T14:38:06.395Z 2026-01-12T15:11:30.189Z
9155767 9155767 20260104062028_v30Bz UK009M 2026-01-06T14:37:59.883Z 2026-01-12T15:11:27.021Z
9155753 9155753 20260104061943_1P4T6 UK009M 2026-01-06T14:37:58.732Z 2026-01-12T15:11:26.292Z
9155478 9155478 20260104055713_JSRpG UK009M 2026-01-06T14:37:24.927Z 2026-01-12T15:11:03.807Z
9155282 9155282 20260104054910_D6KJl UK009M 2026-01-06T14:37:11.804Z 2026-01-12T15:10:55.676Z
9154912 9154912 20260104052409_2I322 UK009M 2026-01-06T14:36:22.139Z 2026-01-12T15:10:26.364Z
9154552 9154552 20260104050218_qrJCo UK009M 2026-01-06T14:35:43.268Z 2026-01-12T15:10:10.407Z
9153915 9153915 20260104042256_L5mqp UK009M 2026-01-06T14:34:21.837Z 2026-01-12T15:09:13.147Z
9153599 9153599 20260104040326_7UAoG UK009M 2026-01-06T14:33:42.037Z 2026-01-12T15:08:57.470Z
9153582 9153582 20260104040312_9xvgM UK009M 2026-01-06T14:33:41.428Z 2026-01-12T15:08:57.211Z
9153575 9153575 20260104040312_jVwdn UK009M 2026-01-06T14:33:41.199Z 2026-01-12T15:08:57.115Z
9153233 9153233 20260104024621_rxYrl UK009M 2026-01-06T14:29:24.190Z 2026-01-12T15:07:08.875Z
9153225 9153225 20260104022046_Vy8Tc UK009M 2026-01-06T14:28:30.438Z 2026-01-12T15:06:31.032Z
9146296 9146296 20260104034358_Mh4iU UK009M 2026-01-05T14:22:04.728Z 2026-01-12T15:08:25.039Z
9146201 9146201 20260104033919_xX111 UK009M 2026-01-05T14:21:52.028Z 2026-01-12T15:08:22.348Z
9145711 9145711 20260104032611_gG29l UK009M 2026-01-05T14:21:05.699Z 2026-01-12T15:07:58.999Z
9145021 9145021 20260104030148_fXLEt UK009M 2026-01-05T14:20:04.202Z 2026-01-12T15:07:35.681Z
9143495 9143495 20260104021410_wTlyd UK009M 2026-01-05T14:17:37.127Z 2026-01-12T15:06:25.110Z
9142734 9142734 20260104014602_bbvS5 UK009M 2026-01-05T14:16:22.777Z 2026-01-12T15:05:52.730Z
9142102 9142102 20260104012231_YiYmt UK009M 2026-01-05T14:15:33.667Z 2026-01-12T15:05:31.622Z
9141829 9141829 20260104010958_RWZ3s UK009M 2026-01-05T14:15:05.953Z 2026-01-12T15:05:10.648Z
9141772 9141772 20260104010808_Myjcf UK009M 2026-01-05T14:15:04.316Z 2026-01-12T15:05:09.982Z
9141475 9141475 20260104005646_3bWOK UK009M 2026-01-05T14:14:42.119Z 2026-01-12T15:05:02.242Z
9141085 9141085 20260104004224_9o1AL UK009M 2026-01-05T14:14:09.417Z 2026-01-12T15:04:39.931Z
9140513 9140513 20260104001844_HcSxx UK009M 2026-01-05T14:13:14.983Z 2026-01-12T15:04:23.384Z
9140512 9140512 20260104001844_n2jf4 UK009M 2026-01-05T14:13:14.865Z 2026-01-12T15:04:23.324Z
9140239 9140239 20260104000634_dLGd3 UK009M 2026-01-05T14:12:51.709Z 2026-01-12T15:04:02.834Z
9138924 9138924 20260103230106_1ux3B UK009M 2026-01-05T14:10:48.230Z 2026-01-12T15:03:15.717Z
9138255 9138255 20260103221337_M0vBu UK009M 2026-01-05T14:09:44.643Z 2026-01-12T15:02:44.580Z
9131718 9131718 20260103054729_hpf2E UK009M 2026-01-04T14:14:45.085Z 2026-01-10T15:00:48.444Z
9131362 9131362 20260103051848_2QnwR UK009M 2026-01-04T14:13:35.652Z 2026-01-10T15:00:24.552Z
9131329 9131329 20260103051146_uc2S1 UK009M 2026-01-04T14:13:28.088Z 2026-01-10T15:00:22.160Z
9131088 9131088 20260103044929_cnaRN UK009M 2026-01-04T14:12:36.307Z 2026-01-10T14:59:58.630Z
9130833 9130833 20260103042207_3XQ51 UK009M 2026-01-04T14:11:47.098Z 2026-01-10T14:59:44.707Z
9129825 9129825 20260103010129_5ph0x UK009M 2026-01-04T14:06:39.270Z 2026-01-10T14:58:18.574Z
9129512 9129512 20260102225423_JKv84 UK009M 2026-01-04T14:04:32.946Z 2026-01-10T14:57:47.022Z
9129361 9129361 20260102213751_pcP3e UK009M 2026-01-04T14:03:33.080Z 2026-01-10T14:57:34.639Z
9128036 9128036 20260102060450_3cRn4 UK009M 2026-01-03T14:12:58.179Z 2026-01-09T14:50:21.059Z
9126891 9126891 20260102012846_4jR34 UK009M 2026-01-03T14:07:15.889Z 2026-01-09T14:49:08.991Z
9126764 9126764 20260102004134_8Qxky UK009M 2026-01-03T14:06:36.284Z 2026-01-09T14:49:01.247Z
9126524 9126524 20260101221839_QujoG UK009M 2026-01-03T14:05:04.915Z 2026-01-09T14:48:48.555Z
9123764 9123764 20251231031331_rICd2 UK009M 2026-01-02T14:34:54.124Z 2026-01-08T15:08:33.223Z
9121430 9121430 20251231222400_DQLrk UK009M 2026-01-02T14:07:15.990Z 2026-01-09T14:52:00.720Z
9113171 9113171 20251231031331_3w4XJ UK009M 2026-01-01T14:17:47.791Z 2026-01-01T14:57:52.783Z
9111843 9111843 20251231014818_CUyYQ UK009M 2026-01-01T14:13:01.004Z 2026-01-01T14:57:51.412Z
9103486 9103486 20251230043248_7Gyw5 UK009M 2025-12-31T14:17:58.519Z 2026-01-07T15:08:46.268Z
9103417 9103417 20251230042812_GMSaL UK009M 2025-12-31T14:17:43.445Z 2026-01-07T15:08:42.475Z
9102444 9102444 20251230030313_v4VCX UK009M 2025-12-31T14:13:53.221Z 2026-01-07T15:07:39.481Z
9102007 9102007 20251230021659_Tj1PF UK009M 2025-12-31T14:11:43.819Z 2026-01-07T15:07:07.856Z
9101215 9101215 20251229232449_PhKDP UK009M 2025-12-31T14:07:11.729Z 2026-01-07T15:06:07.271Z
9092407 9092407 20251227005101_85pQ9 UK009M 2025-12-30T14:58:28.280Z 2026-01-04T15:25:31.892Z
9078356 9078356 20251229015157_Yu1Kg UK009M 2025-12-30T14:12:39.357Z 2026-01-06T15:16:14.303Z
9078352 9078352 20251229015156_VhzIG UK009M 2025-12-30T14:12:38.584Z 2025-12-31T14:33:54.330Z

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