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

8,116 rows where station_code = "UK008B" 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
9273354 9273354 20260128054901_7VxJ9 UK008B 2026-01-29T14:29:24.777Z 2026-01-29T14:30:25.793Z
9273307 9273307 20260128053654_Z7VXr UK008B 2026-01-29T14:29:18.628Z 2026-01-29T14:30:25.785Z
9273175 9273175 20260128050306_eJ2MI UK008B 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9273082 9273082 20260128043246_DQmhn UK008B 2026-01-29T14:28:42.749Z 2026-01-29T14:30:25.746Z
9273067 9273067 20260128043109_sYCQ2 UK008B 2026-01-29T14:28:41.085Z 2026-01-29T14:30:25.744Z
9273032 9273032 20260128042708_CMtUt UK008B 2026-01-29T14:28:31.559Z 2026-01-29T14:30:25.739Z
9272700 9272700 20260128030822_ixwzV UK008B 2026-01-29T14:27:35.131Z 2026-01-29T14:30:25.440Z
9272601 9272601 20260128024815_s7qkO UK008B 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.382Z
9272577 9272577 20260128024006_2WYj3 UK008B 2026-01-29T14:27:11.422Z 2026-01-29T14:30:25.379Z
9271719 9271719 20260127193234_RCutz UK008B 2026-01-29T14:22:50.888Z 2026-01-29T14:30:25.050Z
9271635 9271635 20260127184736_i2TAA UK008B 2026-01-29T14:21:55.863Z 2026-01-29T14:30:24.985Z
9271628 9271628 20260127184451_iaQUN UK008B 2026-01-29T14:21:54.075Z 2026-01-29T14:30:24.977Z
9256266 9256266 20260124063312_ypWlb UK008B 2026-01-25T14:16:23.152Z 2026-01-29T14:48:33.506Z
9256055 9256055 20260124054810_GMJJ1 UK008B 2026-01-25T14:15:40.424Z 2026-01-29T14:48:20.736Z
9255922 9255922 20260124052111_248V7 UK008B 2026-01-25T14:15:09.732Z 2026-01-29T14:48:08.186Z
9254914 9254914 20260123224039_xxufZ UK008B 2026-01-25T14:11:14.521Z 2026-01-29T14:46:54.801Z
9254855 9254855 20260123220127_Tvdgg UK008B 2026-01-25T14:10:56.816Z 2026-01-29T14:46:51.742Z
9252035 9252035 20260123004322_585ec UK008B 2026-01-24T14:14:09.341Z 2026-01-29T14:52:25.451Z
9251499 9251499 20260122202900_As9Mz UK008B 2026-01-24T14:11:55.533Z 2026-01-29T14:51:44.661Z
9243415 9243415 20260121043001_azrqI UK008B 2026-01-22T14:21:42.754Z 2026-01-29T15:05:01.457Z
9228382 9228382 20260118220438_kYDxZ UK008B 2026-01-20T14:17:31.829Z 2026-01-27T15:01:57.894Z
9213267 9213267 20260116025755_ipbpR UK008B 2026-01-17T14:16:13.501Z 2026-01-24T15:12:06.505Z
9213251 9213251 20260116024918_pLGHI UK008B 2026-01-17T14:16:07.033Z 2026-01-24T15:11:53.994Z
9213249 9213249 20260116024657_lAcVo UK008B 2026-01-17T14:16:05.719Z 2026-01-24T15:11:51.449Z
9213052 9213052 20260116020211_Zqa2e UK008B 2026-01-17T14:15:11.525Z 2026-01-24T15:11:38.828Z
9213046 9213046 20260116020150_ixpcv UK008B 2026-01-17T14:15:08.436Z 2026-01-24T15:11:38.464Z
9212975 9212975 20260116014530_IcYfr UK008B 2026-01-17T14:14:48.577Z 2026-01-24T15:11:36.147Z
9212776 9212776 20260116005811_ASl2Y UK008B 2026-01-17T14:13:49.987Z 2026-01-24T15:11:26.161Z
9212671 9212671 20260116001649_U3O4v UK008B 2026-01-17T14:13:12.950Z 2026-01-24T15:11:09.606Z
9212659 9212659 20260116001117_aqc5M UK008B 2026-01-17T14:13:10.773Z 2026-01-24T15:11:09.267Z
9212622 9212622 20260115234726_FUISg UK008B 2026-01-17T14:12:58.353Z 2026-01-24T15:11:07.714Z
9212599 9212599 20260115234354_KNuI7 UK008B 2026-01-17T14:12:52.273Z 2026-01-24T15:11:07.011Z
9212597 9212597 20260115234054_HgnEu UK008B 2026-01-17T14:12:51.579Z 2026-01-24T15:11:06.913Z
9204443 9204443 20260114064408_TQStq UK008B 2026-01-15T14:27:23.741Z 2026-01-22T15:10:28.489Z
9204416 9204416 20260114063757_rjJ1e UK008B 2026-01-15T14:27:14.177Z 2026-01-22T15:10:27.521Z
9204075 9204075 20260114060533_iWEAJ UK008B 2026-01-15T14:26:21.393Z 2026-01-22T15:10:17.649Z
9204050 9204050 20260114060430_kBXtr UK008B 2026-01-15T14:26:19.421Z 2026-01-22T15:10:17.372Z
9203797 9203797 20260114053755_0mbQ3 UK008B 2026-01-15T14:25:24.539Z 2026-01-22T15:10:13.617Z
9203746 9203746 20260114053438_4DmQV UK008B 2026-01-15T14:25:20.628Z 2026-01-22T15:10:13.044Z
9203708 9203708 20260114053054_LRhQ6 UK008B 2026-01-15T14:25:13.461Z 2026-01-22T15:10:12.549Z
9203666 9203666 20260114052749_WXTjM UK008B 2026-01-15T14:25:08.295Z 2026-01-22T15:10:11.767Z
9203580 9203580 20260114051831_Qxfpr UK008B 2026-01-15T14:24:56.791Z 2026-01-22T15:10:10.308Z
9203076 9203076 20260114043236_PKlJD UK008B 2026-01-15T14:23:16.221Z 2026-01-22T15:10:01.290Z
9203005 9203005 20260114042610_4szaq UK008B 2026-01-15T14:23:01.482Z 2026-01-22T15:10:00.532Z
9202907 9202907 20260114041735_CN1BB UK008B 2026-01-15T14:22:45.513Z 2026-01-22T15:09:59.064Z
9202610 9202610 20260114035447_QpcLR UK008B 2026-01-15T14:21:46.656Z 2026-01-22T15:09:23.663Z
9202437 9202437 20260114033811_yhIke UK008B 2026-01-15T14:21:18.712Z 2026-01-22T15:09:18.607Z
9202337 9202337 20260114033053_MXxyf UK008B 2026-01-15T14:21:05.721Z 2026-01-22T15:09:16.437Z
9202228 9202228 20260114032429_hg2mX UK008B 2026-01-15T14:20:43.577Z 2026-01-22T15:09:15.078Z
9202132 9202132 20260114032010_z39Qj UK008B 2026-01-15T14:20:34.559Z 2026-01-22T15:09:13.968Z
9202123 9202123 20260114031742_KlUEl UK008B 2026-01-15T14:20:33.997Z 2026-01-22T15:09:13.837Z
9201981 9201981 20260114030932_cHnlD UK008B 2026-01-15T14:20:13.062Z 2026-01-22T15:09:11.939Z
9201958 9201958 20260114030722_BkT8y UK008B 2026-01-15T14:20:11.357Z 2026-01-22T15:09:11.758Z
9201878 9201878 20260114030441_B482B UK008B 2026-01-15T14:20:04.325Z 2026-01-22T15:09:11.047Z
9201680 9201680 20260114024103_opGwK UK008B 2026-01-15T14:19:16.775Z 2026-01-22T15:09:07.294Z
9201641 9201641 20260114023739_4CGGn UK008B 2026-01-15T14:19:13.658Z 2026-01-22T15:09:06.969Z
9201289 9201289 20260114020526_1tBs5 UK008B 2026-01-15T14:18:11.061Z 2026-01-22T15:09:01.246Z
9180453 9180453 20260110202755_Z9I6s UK008B 2026-01-12T14:07:08.639Z 2026-01-19T15:16:03.339Z
9180096 9180096 20260110190913_E4jme UK008B 2026-01-12T14:05:46.465Z 2026-01-19T15:15:46.345Z
9176784 9176784 20260110062238_MWiLV UK008B 2026-01-11T14:09:58.794Z 2026-01-18T15:08:54.142Z
9176719 9176719 20260110061306_6J4EN UK008B 2026-01-11T14:09:49.509Z 2026-01-18T15:08:51.940Z
9176455 9176455 20260110053154_7cA0W UK008B 2026-01-11T14:09:05.042Z 2026-01-18T15:08:39.839Z
9176339 9176339 20260110051754_KAEbU UK008B 2026-01-11T14:08:46.193Z 2026-01-18T15:08:35.278Z
9176323 9176323 20260110051503_v2gHy UK008B 2026-01-11T14:08:44.623Z 2026-01-18T15:08:34.817Z
9176264 9176264 20260110051015_5IJXz UK008B 2026-01-11T14:08:37.158Z 2026-01-18T15:08:25.665Z
9176212 9176212 20260110050238_JL8SD UK008B 2026-01-11T14:08:27.901Z 2026-01-18T15:08:24.082Z
9176105 9176105 20260110044838_b8mAD UK008B 2026-01-11T14:08:12.266Z 2026-01-18T15:08:19.407Z
9175995 9175995 20260110043403_E96d3 UK008B 2026-01-11T14:07:58.878Z 2026-01-18T15:08:16.073Z
9175936 9175936 20260110042700_efkMK UK008B 2026-01-11T14:07:51.236Z 2026-01-18T15:08:14.193Z
9175849 9175849 20260110035711_FVtb6 UK008B 2026-01-11T14:07:30.743Z 2026-01-18T15:08:10.460Z
9175813 9175813 20260110035151_GwCxS UK008B 2026-01-11T14:07:26.538Z 2026-01-18T15:08:09.340Z
9175779 9175779 20260110034721_7jVOD UK008B 2026-01-11T14:07:21.519Z 2026-01-18T15:08:08.079Z
9175277 9175277 20260110015351_ajI8W UK008B 2026-01-11T14:05:56.241Z 2026-01-18T15:07:39.451Z
9174813 9174813 20260109231318_wANVx UK008B 2026-01-11T14:04:29.439Z 2026-01-18T15:07:12.082Z
9166445 9166445 20260107183355_FdXli UK008B 2026-01-09T14:03:17.044Z 2026-01-16T15:09:55.394Z
9163395 9163395 20260107062958_fUlz8 UK008B 2026-01-08T14:09:01.691Z 2026-01-13T15:03:12.341Z
9163211 9163211 20260107060751_CrZ2G UK008B 2026-01-08T14:08:26.745Z 2026-01-13T15:03:05.798Z
9163184 9163184 20260107060206_DYIR2 UK008B 2026-01-08T14:08:18.833Z 2026-01-13T15:03:04.462Z
9163158 9163158 20260107055939_3BUQp UK008B 2026-01-08T14:08:16.767Z 2026-01-13T15:03:03.621Z
9163118 9163118 20260107054553_LMI2R UK008B 2026-01-08T14:08:10.718Z 2026-01-13T15:03:02.125Z
9163105 9163105 20260107054445_Jf4wR UK008B 2026-01-08T14:08:08.540Z 2026-01-13T15:03:01.542Z
9163074 9163074 20260107053944_fgQp3 UK008B 2026-01-08T14:08:05.941Z 2026-01-13T15:03:00.777Z
9163057 9163057 20260107053720_G2I9N UK008B 2026-01-08T14:08:03.520Z 2026-01-13T15:03:00.228Z
9162987 9162987 20260107052049_fQUJj UK008B 2026-01-08T14:07:39.502Z 2026-01-13T15:02:50.710Z
9162974 9162974 20260107051546_S5b9J UK008B 2026-01-08T14:07:36.518Z 2026-01-13T15:02:50.075Z
9159994 9159994 20260106042648_zhCoB UK008B 2026-01-07T14:11:02.154Z 2026-01-13T15:08:55.726Z
9159874 9159874 20260106041223_Ile5y UK008B 2026-01-07T14:10:43.340Z 2026-01-13T15:08:51.579Z
9159774 9159774 20260106034314_2KzXM UK008B 2026-01-07T14:10:21.524Z 2026-01-13T15:08:42.774Z
9159659 9159659 20260106032309_LrNaB UK008B 2026-01-07T14:10:03.631Z 2026-01-13T15:08:36.497Z
9159651 9159651 20260106032135_zoOk8 UK008B 2026-01-07T14:10:02.023Z 2026-01-13T15:08:36.206Z
9159621 9159621 20260106031459_JENTn UK008B 2026-01-07T14:09:58.189Z 2026-01-13T15:08:33.607Z
9159270 9159270 20260106021410_hq2gL UK008B 2026-01-07T14:08:52.439Z 2026-01-13T15:08:19.126Z
9159103 9159103 20260106014311_qTCK6 UK008B 2026-01-07T14:08:17.766Z 2026-01-13T15:08:07.082Z
9159084 9159084 20260106014117_HlXdI UK008B 2026-01-07T14:08:15.687Z 2026-01-13T15:08:01.362Z
9159019 9159019 20260106012226_WDOcJ UK008B 2026-01-07T14:08:01.176Z 2026-01-13T15:07:57.204Z
9158900 9158900 20260106004544_Y2oHd UK008B 2026-01-07T14:07:35.187Z 2026-01-13T15:07:49.968Z
9158838 9158838 20260106003648_MhJjV UK008B 2026-01-07T14:07:24.363Z 2026-01-13T15:07:47.910Z
9158559 9158559 20260105231636_p9C9B UK008B 2026-01-07T14:06:31.209Z 2026-01-13T15:07:29.587Z
9158481 9158481 20260105224036_gJtpd UK008B 2026-01-07T14:06:15.153Z 2026-01-13T15:07:24.333Z
9158440 9158440 20260105222853_E10r3 UK008B 2026-01-07T14:06:06.838Z 2026-01-13T15:07:22.334Z

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