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

4,936 rows where station_code = "UK009Q" 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
9616603 9616603 20260406032955_WoJEa UK009Q 2026-04-07T12:13:07.405Z 2026-04-07T12:13:20.015Z
9615282 9615282 20260406005547_0KHD9 UK009Q 2026-04-07T12:10:29.068Z 2026-04-07T12:13:19.773Z
9615023 9615023 20260406002328_JRtze UK009Q 2026-04-07T12:09:54.376Z 2026-04-07T12:13:19.718Z
9614471 9614471 20260405231153_7wjII UK009Q 2026-04-07T12:08:47.618Z 2026-04-07T12:13:19.610Z
9613771 9613771 20260405212024_y9ym5 UK009Q 2026-04-07T12:07:17.427Z 2026-04-07T12:13:19.452Z
9613581 9613581 20260405204432_M2KyO UK009Q 2026-04-07T12:06:53.931Z 2026-04-07T12:13:19.411Z
9608416 9608416 20260403230111_uoxQ2 UK009Q 2026-04-05T12:10:23.270Z 2026-04-07T12:18:10.597Z
9608224 9608224 20260403205901_83O8v UK009Q 2026-04-05T12:09:35.205Z 2026-04-07T12:18:04.689Z
9607100 9607100 20260404033157_ChdnX UK009Q 2026-04-05T12:00:25.125Z 2026-04-07T12:13:36.518Z
9595037 9595037 20260330015253_BQhK6 UK009Q 2026-03-31T12:00:16.279Z 2026-04-07T12:23:43.277Z
9591929 9591929 20260327231252_Bowz2 UK009Q 2026-03-29T12:06:59.724Z 2026-04-05T12:35:21.196Z
9581527 9581527 20260326032447_Ejt3U UK009Q 2026-03-27T12:03:21.580Z 2026-04-04T12:39:09.692Z
9580831 9580831 20260326014118_3ei9j UK009Q 2026-03-27T12:01:31.101Z 2026-04-04T12:38:30.848Z
9580748 9580748 20260326012615_sLKiI UK009Q 2026-03-27T12:01:20.024Z 2026-04-04T12:38:24.095Z
9580649 9580649 20260326011249_OlNIV UK009Q 2026-03-27T12:01:03.691Z 2026-04-04T12:38:19.466Z
9580584 9580584 20260326010451_Ioc66 UK009Q 2026-03-27T12:00:50.941Z 2026-04-04T12:38:14.776Z
9579676 9579676 20260324220948_pjEMd UK009Q 2026-03-26T12:14:11.075Z 2026-04-02T12:37:24.673Z
9579598 9579598 20260324215053_dwmxD UK009Q 2026-03-26T12:14:03.520Z 2026-04-02T12:37:17.375Z
9571448 9571448 20260324021410_9evCK UK009Q 2026-03-25T12:01:30.751Z 2026-04-02T12:34:27.030Z
9521664 9521664 20260319043215_z2oYQ UK009Q 2026-03-20T12:08:21.950Z 2026-03-27T12:40:57.333Z
9521391 9521391 20260319041103_FaRKo UK009Q 2026-03-20T12:07:55.842Z 2026-03-27T12:40:54.382Z
9520889 9520889 20260319034405_JU118 UK009Q 2026-03-20T12:07:12.169Z 2026-03-27T12:40:48.817Z
9520828 9520828 20260319033943_yD33w UK009Q 2026-03-20T12:07:01.630Z 2026-03-27T12:40:47.779Z
9520732 9520732 20260319033411_KMUBH UK009Q 2026-03-20T12:06:53.134Z 2026-03-27T12:40:46.738Z
9520104 9520104 20260319025349_0Oypa UK009Q 2026-03-20T12:05:44.309Z 2026-03-27T12:40:38.998Z
9519893 9519893 20260319024244_6CssB UK009Q 2026-03-20T12:05:21.927Z 2026-03-27T12:40:36.932Z
9519136 9519136 20260319015236_PJyZP UK009Q 2026-03-20T12:03:59.547Z 2026-03-27T12:40:18.544Z
9518702 9518702 20260319011947_WNmXm UK009Q 2026-03-20T12:03:08.614Z 2026-03-27T12:40:12.772Z
9518595 9518595 20260319011215_Oeiju UK009Q 2026-03-20T12:02:56.476Z 2026-03-27T12:40:11.705Z
9512034 9512034 20260318043539_29awc UK009Q 2026-03-19T12:11:31.546Z 2026-03-26T12:37:41.716Z
9510671 9510671 20260318030738_t1PNA UK009Q 2026-03-19T12:08:16.865Z 2026-03-26T12:37:15.411Z
9509387 9509387 20260318014735_E3ScC UK009Q 2026-03-19T12:05:14.895Z 2026-03-26T12:37:05.279Z
9509007 9509007 20260318012159_Hk6yp UK009Q 2026-03-19T12:04:18.857Z 2026-03-26T12:37:02.569Z
9508971 9508971 20260318011827_Vkw99 UK009Q 2026-03-19T12:04:12.016Z 2026-03-26T12:37:02.256Z
9508968 9508968 20260318011827_8RKpa UK009Q 2026-03-19T12:04:11.902Z 2026-03-26T12:37:02.225Z
9508962 9508962 20260318011751_V383Y UK009Q 2026-03-19T12:04:10.807Z 2026-03-26T12:37:02.135Z
9508534 9508534 20260318010232_dEhu2 UK009Q 2026-03-19T12:03:17.650Z 2026-03-26T12:36:59.187Z
9508155 9508155 20260318002548_hwhp7 UK009Q 2026-03-19T12:02:25.517Z 2026-03-26T12:36:56.305Z
9501392 9501392 20260315220936_KPAy5 UK009Q 2026-03-17T12:24:56.302Z 2026-03-23T12:22:44.232Z
9500990 9500990 20260315203430_Vs2mJ UK009Q 2026-03-17T12:24:16.412Z 2026-03-23T12:22:42.656Z
9500897 9500897 20260315195633_fPai1 UK009Q 2026-03-17T12:24:08.796Z 2026-03-23T12:22:42.229Z
9494855 9494855 20260316031443_y0uvF UK009Q 2026-03-17T12:05:15.472Z 2026-03-24T12:40:50.686Z
9494496 9494496 20260316022451_cK0j3 UK009Q 2026-03-17T12:04:07.714Z 2026-03-24T12:40:47.878Z
9493806 9493806 20260316004015_KHtSk UK009Q 2026-03-17T12:02:05.707Z 2026-03-24T12:40:42.130Z
9493755 9493755 20260316002957_I1mMX UK009Q 2026-03-17T12:01:56.261Z 2026-03-24T12:40:41.778Z
9493715 9493715 20260316002500_2PmCE UK009Q 2026-03-17T12:01:48.089Z 2026-03-24T12:40:41.423Z
9493542 9493542 20260315234807_QAF1g UK009Q 2026-03-17T12:01:14.796Z 2026-03-24T12:40:40.509Z
9493517 9493517 20260315234023_aqbPq UK009Q 2026-03-17T12:01:06.956Z 2026-03-24T12:40:40.323Z
9493447 9493447 20260315233111_CGTD8 UK009Q 2026-03-17T12:00:55.160Z 2026-03-24T12:40:39.776Z
9492301 9492301 20260314200923_RIM1F UK009Q 2026-03-16T12:28:16.657Z 2026-03-22T12:42:51.543Z
9483475 9483475 20260313222007_8uHhJ UK009Q 2026-03-15T12:26:34.282Z 2026-03-21T12:50:27.926Z
9477276 9477276 20260314043717_9x5sB UK009Q 2026-03-15T12:07:59.336Z 2026-03-22T12:42:02.061Z
9477063 9477063 20260314041025_REV68 UK009Q 2026-03-15T12:07:31.522Z 2026-03-22T12:42:00.889Z
9477015 9477015 20260314040644_QyEAB UK009Q 2026-03-15T12:07:27.068Z 2026-03-22T12:42:00.683Z
9476596 9476596 20260314031820_vC9Al UK009Q 2026-03-15T12:06:26.101Z 2026-03-22T12:41:58.010Z
9476397 9476397 20260314030233_2UG1Q UK009Q 2026-03-15T12:05:51.553Z 2026-03-22T12:41:56.475Z
9476251 9476251 20260314024702_9meiM UK009Q 2026-03-15T12:05:24.092Z 2026-03-22T12:41:55.289Z
9476143 9476143 20260314024024_zl6HJ UK009Q 2026-03-15T12:05:09.538Z 2026-03-22T12:41:54.430Z
9475971 9475971 20260314022617_kfPhC UK009Q 2026-03-15T12:04:44.328Z 2026-03-22T12:41:53.415Z
9475618 9475618 20260314014617_U2GvY UK009Q 2026-03-15T12:03:36.414Z 2026-03-22T12:41:45.243Z
9475589 9475589 20260314014348_96jyd UK009Q 2026-03-15T12:03:32.383Z 2026-03-22T12:41:44.384Z
9475093 9475093 20260314003632_yWyJL UK009Q 2026-03-15T12:02:12.879Z 2026-03-22T12:41:26.921Z
9474793 9474793 20260313235941_kyrXP UK009Q 2026-03-15T12:01:23.228Z 2026-03-22T12:41:24.327Z
9474750 9474750 20260313234930_uuSil UK009Q 2026-03-15T12:01:14.220Z 2026-03-22T12:41:23.873Z
9474498 9474498 20260313230131_FvTjs UK009Q 2026-03-15T12:00:21.903Z 2026-03-22T12:41:20.868Z
9474255 9474255 20260312220127_ZaCjI UK009Q 2026-03-14T12:22:24.178Z 2026-03-20T12:37:17.017Z
9469093 9469093 20260313014801_mq5Uc UK009Q 2026-03-14T12:02:57.607Z 2026-03-21T12:48:33.476Z
9468893 9468893 20260313010729_9rcaq UK009Q 2026-03-14T12:02:12.006Z 2026-03-21T12:48:30.964Z
9468831 9468831 20260313004958_S4xxu UK009Q 2026-03-14T12:01:56.783Z 2026-03-21T12:48:29.802Z
9457736 9457736 20260311050602_krwpL UK009Q 2026-03-12T12:04:27.313Z 2026-03-19T12:44:51.433Z
9457611 9457611 20260311043713_4FgXd UK009Q 2026-03-12T12:04:10.346Z 2026-03-19T12:44:48.275Z
9457463 9457463 20260311040101_oAdvr UK009Q 2026-03-12T12:03:52.967Z 2026-03-19T12:44:44.449Z
9457450 9457450 20260311040027_3Y2iB UK009Q 2026-03-12T12:03:52.179Z 2026-03-19T12:44:44.055Z
9457326 9457326 20260311033129_1GkjZ UK009Q 2026-03-12T12:03:34.270Z 2026-03-19T12:44:38.247Z
9457091 9457091 20260311023407_MALGW UK009Q 2026-03-12T12:02:50.121Z 2026-03-19T12:44:26.012Z
9457065 9457065 20260311022519_ukcFX UK009Q 2026-03-12T12:02:43.634Z 2026-03-19T12:44:25.235Z
9456892 9456892 20260311013452_blinQ UK009Q 2026-03-12T12:02:07.006Z 2026-03-19T12:44:23.207Z
9456845 9456845 20260311011821_9pw9e UK009Q 2026-03-12T12:01:58.212Z 2026-03-19T12:44:22.759Z
9456835 9456835 20260311011331_KE7PZ UK009Q 2026-03-12T12:01:54.972Z 2026-03-19T12:44:22.586Z
9456477 9456477 20260310233849_u6Hol UK009Q 2026-03-12T12:00:50.746Z 2026-03-19T12:44:17.487Z
9455944 9455944 20260309210527_2igeN UK009Q 2026-03-11T12:15:17.979Z 2026-03-17T12:42:40.898Z
9451992 9451992 20260310052505_D0aOB UK009Q 2026-03-11T12:04:21.404Z 2026-03-18T12:39:08.009Z
9451985 9451985 20260310052112_Ajf7f UK009Q 2026-03-11T12:04:20.431Z 2026-03-18T12:39:07.871Z
9451901 9451901 20260310044708_OzSJ9 UK009Q 2026-03-11T12:04:10.897Z 2026-03-18T12:39:06.639Z
9451883 9451883 20260310043400_yNobi UK009Q 2026-03-11T12:04:07.728Z 2026-03-18T12:39:06.246Z
9445863 9445863 20260307221903_y3t33 UK009Q 2026-03-09T12:21:02.352Z 2026-03-15T12:42:15.089Z
9445836 9445836 20260307221318_e3xJA UK009Q 2026-03-09T12:20:58.049Z 2026-03-15T12:42:14.776Z
9445628 9445628 20260307205126_ieP8N UK009Q 2026-03-09T12:20:06.138Z 2026-03-15T12:42:12.194Z
9445525 9445525 20260307201624_8F2LV UK009Q 2026-03-09T12:19:35.557Z 2026-03-15T12:42:10.455Z
9442718 9442718 20260308052133_C4KY1 UK009Q 2026-03-09T12:05:13.984Z 2026-03-16T12:43:55.620Z
9442625 9442625 20260308043433_wYEUH UK009Q 2026-03-09T12:04:46.522Z 2026-03-16T12:43:54.227Z
9442543 9442543 20260308041606_ZTwMW UK009Q 2026-03-09T12:04:27.083Z 2026-03-16T12:43:53.071Z
9441965 9441965 20260308003623_FgB3O UK009Q 2026-03-09T12:02:01.083Z 2026-03-16T12:43:34.628Z
9441916 9441916 20260308002130_E2Kwp UK009Q 2026-03-09T12:01:47.922Z 2026-03-16T12:43:33.918Z
9441851 9441851 20260308000059_muz4W UK009Q 2026-03-09T12:01:30.709Z 2026-03-16T12:43:32.310Z
9441777 9441777 20260307233913_DCsxl UK009Q 2026-03-09T12:01:09.521Z 2026-03-16T12:43:31.042Z
9441604 9441604 20260307225016_nksif UK009Q 2026-03-09T12:00:23.023Z 2026-03-16T12:43:28.231Z
9441199 9441199 20260306202458_2KPNP UK009Q 2026-03-08T12:20:49.087Z 2026-03-14T12:40:46.765Z
9437572 9437572 20260307043946_r83GN UK009Q 2026-03-08T12:04:34.036Z 2026-03-15T12:41:19.656Z
9436970 9436970 20260307005555_buGcX UK009Q 2026-03-08T12:02:03.878Z 2026-03-15T12:41:00.248Z

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