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

3,096 rows where station_code = "UK00AQ" 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
9273320 9273320 20260128053848_EudKS UK00AQ 2026-01-29T14:29:19.766Z 2026-01-29T14:30:25.786Z
9271674 9271674 20260127190917_H75gI UK00AQ 2026-01-29T14:22:17.192Z 2026-01-29T14:30:25.017Z
9252685 9252685 20260123051717_zP8Ia UK00AQ 2026-01-24T14:16:42.986Z 2026-01-29T14:53:15.965Z
9243773 9243773 20260121051450_qPCSD UK00AQ 2026-01-22T14:22:57.291Z 2026-01-29T15:05:26.874Z
9243475 9243475 20260121043635_Wq22v UK00AQ 2026-01-22T14:22:02.913Z 2026-01-29T15:05:03.927Z
9243450 9243450 20260121043317_T4EKQ UK00AQ 2026-01-22T14:21:58.743Z 2026-01-29T15:05:03.070Z
9242952 9242952 20260121032055_dxOFv UK00AQ 2026-01-22T14:20:00.718Z 2026-01-29T15:04:32.316Z
9237785 9237785 20260120060452_JHh3V UK00AQ 2026-01-21T14:27:38.060Z 2026-01-28T15:01:42.020Z
9223191 9223191 20260117234055_aDRr4 UK00AQ 2026-01-19T14:18:06.955Z 2026-01-26T15:01:57.351Z
9223099 9223099 20260117230328_zGMuh UK00AQ 2026-01-19T14:17:43.958Z 2026-01-26T15:01:49.425Z
9222979 9222979 20260117215814_VheD6 UK00AQ 2026-01-19T14:17:10.807Z 2026-01-26T15:01:30.858Z
9222880 9222880 20260117211154_rIWrz UK00AQ 2026-01-19T14:16:39.550Z 2026-01-26T15:01:24.283Z
9222807 9222807 20260117205459_6HjjG UK00AQ 2026-01-19T14:16:19.256Z 2026-01-26T15:01:21.802Z
9212509 9212509 20260115222424_oVBU0 UK00AQ 2026-01-17T14:12:20.158Z 2026-01-24T15:10:59.194Z
9212494 9212494 20260115221714_gLlIT UK00AQ 2026-01-17T14:12:14.435Z 2026-01-24T15:10:57.888Z
9211991 9211991 20260115183844_sTV2H UK00AQ 2026-01-17T14:09:23.101Z 2026-01-24T15:10:17.466Z
9208541 9208541 20260115055625_4raTw UK00AQ 2026-01-16T14:13:07.485Z 2026-01-22T15:04:33.497Z
9208442 9208442 20260115052558_ZYEqu UK00AQ 2026-01-16T14:12:42.684Z 2026-01-22T15:04:14.041Z
9208406 9208406 20260115051650_QIbHI UK00AQ 2026-01-16T14:12:33.443Z 2026-01-22T15:04:12.884Z
9207348 9207348 20260115010535_vcmQ0 UK00AQ 2026-01-16T14:08:21.497Z 2026-01-22T15:03:19.391Z
9203108 9203108 20260114043254_Fk44t UK00AQ 2026-01-15T14:23:19.170Z 2026-01-22T15:10:01.615Z
9202928 9202928 20260114041838_TSxdt UK00AQ 2026-01-15T14:22:48.384Z 2026-01-22T15:09:59.434Z
9202698 9202698 20260114040342_0Tkk1 UK00AQ 2026-01-15T14:22:10.244Z 2026-01-22T15:09:28.233Z
9201796 9201796 20260114025316_wiYvW UK00AQ 2026-01-15T14:19:45.305Z 2026-01-22T15:09:09.820Z
9201548 9201548 20260114022930_sEduo UK00AQ 2026-01-15T14:18:55.404Z 2026-01-22T15:09:05.780Z
9200770 9200770 20260114010205_5eWaq UK00AQ 2026-01-15T14:16:22.740Z 2026-01-22T15:08:25.437Z
9200218 9200218 20260113231422_oaQlf UK00AQ 2026-01-15T14:14:13.699Z 2026-01-22T15:08:11.575Z
9200110 9200110 20260113225241_V3Mru UK00AQ 2026-01-15T14:13:46.804Z 2026-01-22T15:08:09.709Z
9199997 9199997 20260113221546_O8FtI UK00AQ 2026-01-15T14:13:28.384Z 2026-01-22T15:08:07.290Z
9199915 9199915 20260113215531_pU9TU UK00AQ 2026-01-15T14:13:02.665Z 2026-01-22T15:08:05.338Z
9199865 9199865 20260113213518_pjtZv UK00AQ 2026-01-15T14:12:52.648Z 2026-01-22T15:08:04.275Z
9198697 9198697 20260113173834_8cBsD UK00AQ 2026-01-15T14:06:30.497Z 2026-01-22T15:07:01.108Z
9195468 9195468 20260113013121_RsneU UK00AQ 2026-01-14T14:13:26.881Z 2026-01-21T15:04:41.014Z
9194113 9194113 20260112180217_ma2TX UK00AQ 2026-01-14T14:07:26.823Z 2026-01-21T15:03:31.550Z
9188253 9188253 20260111214615_Z1Iww UK00AQ 2026-01-13T14:11:16.187Z 2026-01-20T15:21:29.841Z
9188250 9188250 20260111214548_u90wI UK00AQ 2026-01-13T14:11:15.373Z 2026-01-20T15:21:29.689Z
9188244 9188244 20260111214327_m61SU UK00AQ 2026-01-13T14:11:11.468Z 2026-01-20T15:21:29.344Z
9188235 9188235 20260111213541_neysQ UK00AQ 2026-01-13T14:11:08.600Z 2026-01-20T15:21:28.725Z
9162140 9162140 20260106224724_fStxH UK00AQ 2026-01-08T14:03:09.558Z 2026-01-13T15:01:39.519Z
9159123 9159123 20260106014647_BNUg2 UK00AQ 2026-01-07T14:08:21.934Z 2026-01-13T15:08:09.007Z
9158242 9158242 20260105211524_h07Ge UK00AQ 2026-01-07T14:05:28.597Z 2026-01-13T15:07:13.657Z
9157742 9157742 20260105183952_8bUwI UK00AQ 2026-01-07T14:03:22.173Z 2026-01-13T15:06:26.842Z
9157503 9157503 20260105173240_sRUOm UK00AQ 2026-01-07T14:02:21.477Z 2026-01-13T15:06:07.240Z
9151573 9151573 20260105055555_2Ow37 UK00AQ 2026-01-06T14:14:04.809Z 2026-01-13T15:14:56.527Z
9150777 9150777 20260105032735_0lUW1 UK00AQ 2026-01-06T14:11:20.121Z 2026-01-13T15:14:00.305Z
9150735 9150735 20260105032156_wlt0o UK00AQ 2026-01-06T14:11:13.496Z 2026-01-13T15:13:51.900Z
9150673 9150673 20260105030512_39B27 UK00AQ 2026-01-06T14:10:56.235Z 2026-01-13T15:13:48.254Z
9150188 9150188 20260105012325_rnxLf UK00AQ 2026-01-06T14:09:00.350Z 2026-01-13T15:13:09.981Z
9150102 9150102 20260105010126_iFrnn UK00AQ 2026-01-06T14:08:32.722Z 2026-01-13T15:13:04.442Z
9145268 9145268 20260104031141_SrL05 UK00AQ 2026-01-05T14:20:23.686Z 2026-01-05T14:30:34.074Z
9143796 9143796 20260104022344_tKJXA UK00AQ 2026-01-05T14:18:06.425Z 2026-01-12T15:06:33.730Z
9143740 9143740 20260104022129_922sz UK00AQ 2026-01-05T14:18:02.317Z 2026-01-12T15:06:32.237Z
9141973 9141973 20260104011648_3gJjn UK00AQ 2026-01-05T14:15:25.174Z 2026-01-12T15:05:16.661Z
9141914 9141914 20260104011432_BFYHr UK00AQ 2026-01-05T14:15:20.942Z 2026-01-12T15:05:12.724Z
9141717 9141717 20260104010506_5Ewcf UK00AQ 2026-01-05T14:14:56.565Z 2026-01-12T15:05:07.994Z
9141592 9141592 20260104010056_LTszr UK00AQ 2026-01-05T14:14:50.294Z 2026-01-12T15:05:05.001Z
9141453 9141453 20260104005459_ildcY UK00AQ 2026-01-05T14:14:37.047Z 2026-01-12T15:05:01.357Z
9140458 9140458 20260104001702_zpLI1 UK00AQ 2026-01-05T14:13:11.003Z 2026-01-12T15:04:10.763Z
9137373 9137373 20260103210703_tTkUB UK00AQ 2026-01-05T14:08:23.151Z 2026-01-12T15:02:08.565Z
9137275 9137275 20260103205815_Y3Nfv UK00AQ 2026-01-05T14:08:15.660Z 2026-01-12T15:01:55.079Z
9136741 9136741 20260103201346_heEYn UK00AQ 2026-01-05T14:07:12.305Z 2026-01-12T15:01:37.685Z
9136638 9136638 20260103200903_5Sq7c UK00AQ 2026-01-05T14:07:06.185Z 2026-01-12T15:01:35.074Z
9136612 9136612 20260103200748_yssLS UK00AQ 2026-01-05T14:07:03.545Z 2026-01-12T15:01:24.629Z
9135980 9135980 20260103192834_evHb6 UK00AQ 2026-01-05T14:05:48.972Z 2026-01-12T15:01:03.453Z
9135881 9135881 20260103191813_ieWeW UK00AQ 2026-01-05T14:05:33.310Z 2026-01-12T15:00:49.730Z
9135859 9135859 20260103191654_cPRZh UK00AQ 2026-01-05T14:05:30.514Z 2026-01-12T15:00:49.197Z
9135836 9135836 20260103191628_vSdUQ UK00AQ 2026-01-05T14:05:25.055Z 2026-01-12T15:00:48.637Z
9135620 9135620 20260103190434_xhOxg UK00AQ 2026-01-05T14:04:53.715Z 2026-01-12T15:00:42.144Z
9135594 9135594 20260103190230_AtlbK UK00AQ 2026-01-05T14:04:51.556Z 2026-01-12T15:00:41.469Z
9135463 9135463 20260103185555_vmoOI UK00AQ 2026-01-05T14:04:39.396Z 2026-01-12T15:00:37.492Z
9131028 9131028 20260103044231_g3gBG UK00AQ 2026-01-04T14:12:25.070Z 2026-01-10T14:59:55.473Z
9130207 9130207 20260103023036_eASyX UK00AQ 2026-01-04T14:08:53.121Z 2026-01-10T14:58:52.022Z
9130161 9130161 20260103022244_3Wfyd UK00AQ 2026-01-04T14:08:42.880Z 2026-01-10T14:58:48.129Z
9129596 9129596 20260102232248_IEW8h UK00AQ 2026-01-04T14:04:54.988Z 2026-01-10T14:57:55.106Z
9129585 9129585 20260102232106_9A78O UK00AQ 2026-01-04T14:04:54.270Z 2026-01-10T14:57:54.884Z
9129421 9129421 20260102220353_41oeM UK00AQ 2026-01-04T14:03:50.651Z 2026-01-10T14:57:38.560Z
9128191 9128191 20260102063418_Pr8L3 UK00AQ 2026-01-03T14:13:51.662Z 2026-01-09T14:50:31.303Z
9127767 9127767 20260102051213_zybZO UK00AQ 2026-01-03T14:11:50.583Z 2026-01-09T14:50:11.305Z
9126422 9126422 20260101200831_Ae7pX UK00AQ 2026-01-03T14:03:58.075Z 2026-01-09T14:48:26.326Z
9126397 9126397 20260101195442_BqFDk UK00AQ 2026-01-03T14:03:36.034Z 2026-01-09T14:48:23.819Z
9113940 9113940 20251231035602_RJtbE UK00AQ 2026-01-01T14:20:55.634Z 2026-01-08T15:09:17.009Z
9113221 9113221 20251231031700_P5YUa UK00AQ 2026-01-01T14:18:00.165Z 2026-01-08T15:08:35.229Z
9112086 9112086 20251231020433_NCi2x UK00AQ 2026-01-01T14:13:56.663Z 2026-01-08T15:07:18.487Z
9111058 9111058 20251231003343_3TuUo UK00AQ 2026-01-01T14:09:56.920Z 2026-01-08T15:06:13.624Z
9110903 9110903 20251231001652_Yobzb UK00AQ 2026-01-01T14:09:19.688Z 2026-01-08T15:06:00.254Z
9110791 9110791 20251231000153_v5EJN UK00AQ 2026-01-01T14:08:45.469Z 2026-01-08T15:05:50.794Z
9110471 9110471 20251230231435_jwvw9 UK00AQ 2026-01-01T14:07:24.289Z 2026-01-08T15:05:24.574Z
9110426 9110426 20251230230645_Nb9bJ UK00AQ 2026-01-01T14:07:07.792Z 2026-01-08T15:05:23.004Z
9104293 9104293 20251230054230_RZ4eU UK00AQ 2025-12-31T14:20:55.350Z 2026-01-07T15:09:38.378Z
9104271 9104271 20251230054102_5Aue9 UK00AQ 2025-12-31T14:20:52.330Z 2026-01-07T15:09:37.623Z
9103760 9103760 20251230050035_A9JSL UK00AQ 2025-12-31T14:19:06.966Z 2026-01-07T15:09:07.855Z
9103448 9103448 20251230042948_EIWzU UK00AQ 2025-12-31T14:17:50.749Z 2026-01-07T15:08:44.085Z
9103153 9103153 20251230040128_5DihL UK00AQ 2025-12-31T14:16:44.026Z 2026-01-07T15:08:21.447Z
9102477 9102477 20251230030543_2AGLA UK00AQ 2025-12-31T14:14:02.514Z 2026-01-07T15:07:41.309Z
9102255 9102255 20251230024139_Pu2e7 UK00AQ 2025-12-31T14:12:58.041Z 2026-01-07T15:07:24.392Z
9099172 9099172 20251226183430_mAXfP UK00AQ 2025-12-30T15:22:37.994Z 2026-01-03T15:42:53.670Z
9093420 9093420 20251227063204_dmEpj UK00AQ 2025-12-30T15:03:36.988Z 2026-01-04T15:30:38.463Z
9093300 9093300 20251227052528_v7JjU UK00AQ 2025-12-30T15:02:58.786Z 2026-01-04T15:29:58.409Z
9093176 9093176 20251227044132_26cMC UK00AQ 2025-12-30T15:02:19.153Z 2026-01-04T15:29:18.433Z
9092851 9092851 20251227031631_o3f6n UK00AQ 2025-12-30T15:01:00.713Z 2026-01-04T15:28:01.440Z

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