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

9,507 rows where station_code = "UK000T" 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
9260468 9260468 20260125043820_0mgt4 UK000T 2026-01-26T14:21:54.969Z 2026-01-29T14:44:16.781Z
9260441 9260441 20260125042736_xvOCx UK000T 2026-01-26T14:21:50.144Z 2026-01-29T14:44:13.308Z
9260384 9260384 20260125041059_HPCIJ UK000T 2026-01-26T14:21:29.163Z 2026-01-29T14:44:09.698Z
9260379 9260379 20260125040728_Hr9oq UK000T 2026-01-26T14:21:28.202Z 2026-01-29T14:44:09.310Z
9260348 9260348 20260125035406_6A9NO UK000T 2026-01-26T14:21:21.859Z 2026-01-29T14:44:07.263Z
9260140 9260140 20260125024303_23LVS UK000T 2026-01-26T14:20:24.177Z 2026-01-29T14:43:50.835Z
9252430 9252430 20260123030447_Si3rM UK000T 2026-01-24T14:15:33.811Z 2026-01-29T14:52:53.201Z
9252383 9252383 20260123024350_ELPhi UK000T 2026-01-24T14:15:20.726Z 2026-01-29T14:52:48.239Z
9252071 9252071 20260123005151_bIOzL UK000T 2026-01-24T14:14:17.516Z 2026-01-29T14:52:27.290Z
9252006 9252006 20260123002709_wC2su UK000T 2026-01-24T14:13:59.152Z 2026-01-29T14:52:23.721Z
9251965 9251965 20260123000805_h3WUd UK000T 2026-01-24T14:13:50.291Z 2026-01-29T14:52:19.141Z
9251889 9251889 20260122234637_rScD4 UK000T 2026-01-24T14:13:31.357Z 2026-01-29T14:52:15.657Z
9251887 9251887 20260122234606_pSEJC UK000T 2026-01-24T14:13:30.564Z 2026-01-29T14:52:15.342Z
9251746 9251746 20260122222526_2ohqP UK000T 2026-01-24T14:13:06.686Z 2026-01-29T14:52:07.818Z
9251696 9251696 20260122220923_2qxCh UK000T 2026-01-24T14:12:58.175Z 2026-01-29T14:52:01.531Z
9242903 9242903 20260121031311_y2qfB UK000T 2026-01-22T14:19:43.382Z 2026-01-29T15:04:29.088Z
9242879 9242879 20260121030753_24OuR UK000T 2026-01-22T14:19:38.994Z 2026-01-29T15:04:26.720Z
9242843 9242843 20260121025826_3aAAJ UK000T 2026-01-22T14:19:32.084Z 2026-01-29T15:04:24.103Z
9242419 9242419 20260121014828_locte UK000T 2026-01-22T14:17:48.888Z 2026-01-29T15:03:58.052Z
9242359 9242359 20260121013817_QFyKL UK000T 2026-01-22T14:17:28.128Z 2026-01-29T15:03:46.002Z
9242288 9242288 20260121012345_Ixlwn UK000T 2026-01-22T14:17:15.546Z 2026-01-29T15:03:42.607Z
9242215 9242215 20260121010309_PXuMu UK000T 2026-01-22T14:16:55.023Z 2026-01-29T15:03:37.239Z
9242087 9242087 20260121002302_9g57n UK000T 2026-01-22T14:16:18.888Z 2026-01-29T15:03:29.530Z
9242080 9242080 20260121002051_DGmwf UK000T 2026-01-22T14:16:09.864Z 2026-01-29T15:03:28.919Z
9242045 9242045 20260121001255_ZUadN UK000T 2026-01-22T14:15:59.478Z 2026-01-29T15:03:27.300Z
9241883 9241883 20260120231602_2le5n UK000T 2026-01-22T14:15:06.688Z 2026-01-29T15:03:08.112Z
9241839 9241839 20260120230402_IO5u2 UK000T 2026-01-22T14:14:54.105Z 2026-01-29T15:03:05.474Z
9241799 9241799 20260120223942_Rv2EP UK000T 2026-01-22T14:14:44.529Z 2026-01-29T15:03:03.003Z
9237736 9237736 20260120055759_XvnUj UK000T 2026-01-21T14:27:32.273Z 2026-01-28T15:01:38.534Z
9237596 9237596 20260120054155_ZFecp UK000T 2026-01-21T14:27:06.073Z 2026-01-28T15:01:32.570Z
9237162 9237162 20260120044516_09qwo UK000T 2026-01-21T14:25:25.372Z 2026-01-28T15:01:00.825Z
9236945 9236945 20260120042114_N1FvC UK000T 2026-01-21T14:24:34.441Z 2026-01-28T15:00:50.014Z
9236480 9236480 20260120032503_ZejGg UK000T 2026-01-21T14:22:57.180Z 2026-01-28T15:00:04.026Z
9235752 9235752 20260120015638_VFboD UK000T 2026-01-21T14:20:08.910Z 2026-01-28T14:59:19.023Z
9223265 9223265 20260118000253_UO2fz UK000T 2026-01-19T14:18:27.095Z 2026-01-26T15:02:00.351Z
9222816 9222816 20260117205814_22s9s UK000T 2026-01-19T14:16:21.622Z 2026-01-26T15:01:22.215Z
9218886 9218886 20260117062154_j6OE9 UK000T 2026-01-18T14:14:05.723Z 2026-01-25T14:58:54.660Z
9218868 9218868 20260117061520_YWbOI UK000T 2026-01-18T14:14:02.655Z 2026-01-25T14:58:54.292Z
9218844 9218844 20260117060633_J0lvY UK000T 2026-01-18T14:13:55.763Z 2026-01-25T14:58:53.064Z
9218813 9218813 20260117055921_i6QRs UK000T 2026-01-18T14:13:47.826Z 2026-01-25T14:58:52.185Z
9218732 9218732 20260117053156_uNg2s UK000T 2026-01-18T14:13:27.906Z 2026-01-25T14:58:37.244Z
9218541 9218541 20260117042835_jZxZ9 UK000T 2026-01-18T14:12:34.893Z 2026-01-25T14:58:29.477Z
9218181 9218181 20260117013321_Pl446 UK000T 2026-01-18T14:10:53.466Z 2026-01-25T14:58:03.487Z
9214161 9214161 20260116054827_mQW5k UK000T 2026-01-17T14:20:24.988Z 2026-01-24T15:13:19.048Z
9214117 9214117 20260116053731_Zftrr UK000T 2026-01-17T14:20:08.839Z 2026-01-24T15:13:07.701Z
9213906 9213906 20260116045812_kkvwW UK000T 2026-01-17T14:19:07.396Z 2026-01-24T15:12:51.021Z
9213877 9213877 20260116045654_mWcik UK000T 2026-01-17T14:18:56.949Z 2026-01-24T15:12:50.237Z
9213650 9213650 20260116041804_8R23h UK000T 2026-01-17T14:17:58.591Z 2026-01-24T15:12:29.999Z
9213486 9213486 20260116034701_Z0lji UK000T 2026-01-17T14:17:09.311Z 2026-01-24T15:12:17.667Z
9204296 9204296 20260114062546_9s9xM UK000T 2026-01-15T14:27:01.496Z 2026-01-22T15:10:24.569Z
9204257 9204257 20260114062101_BcVJE UK000T 2026-01-15T14:26:54.970Z 2026-01-22T15:10:23.317Z
9204091 9204091 20260114060555_E22Gi UK000T 2026-01-15T14:26:22.496Z 2026-01-22T15:10:17.792Z
9203571 9203571 20260114051802_0TMnt UK000T 2026-01-15T14:24:53.110Z 2026-01-22T15:10:10.062Z
9202902 9202902 20260114041728_PLNbK UK000T 2026-01-15T14:22:44.941Z 2026-01-22T15:09:59.018Z
9202777 9202777 20260114040815_MORpK UK000T 2026-01-15T14:22:20.918Z 2026-01-22T15:09:41.005Z
9202213 9202213 20260114032347_GpkHq UK000T 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202084 9202084 20260114031525_Ig0Nc UK000T 2026-01-15T14:20:24.372Z 2026-01-22T15:09:13.273Z
9201528 9201528 20260114022538_uR55u UK000T 2026-01-15T14:18:49.340Z 2026-01-22T15:09:05.019Z
9200623 9200623 20260114003642_26peb UK000T 2026-01-15T14:15:48.340Z 2026-01-22T15:08:22.102Z
9194869 9194869 20260112230931_0eHTr UK000T 2026-01-14T14:11:05.546Z 2026-01-21T15:04:33.479Z
9194793 9194793 20260112224157_p7gFC UK000T 2026-01-14T14:10:42.226Z 2026-01-21T15:04:21.111Z
9194624 9194624 20260112213615_fLelV UK000T 2026-01-14T14:10:03.942Z 2026-01-21T15:04:19.373Z
9194260 9194260 20260112192157_WU3La UK000T 2026-01-14T14:08:18.979Z 2026-01-21T15:03:44.645Z
9189694 9189694 20260112055214_0VbF2 UK000T 2026-01-13T14:18:54.349Z 2026-01-20T15:23:35.637Z
9176908 9176908 20260110063909_ND3Up UK000T 2026-01-11T14:10:19.633Z 2026-01-18T15:09:07.191Z
9176840 9176840 20260110063025_drqut UK000T 2026-01-11T14:10:09.529Z 2026-01-18T15:09:04.464Z
9176732 9176732 20260110061306_gx2Lw UK000T 2026-01-11T14:09:49.814Z 2026-01-18T15:08:52.107Z
9176503 9176503 20260110053809_O7tGK UK000T 2026-01-11T14:09:12.398Z 2026-01-18T15:08:41.733Z
9176382 9176382 20260110052400_oh7DY UK000T 2026-01-11T14:08:51.891Z 2026-01-18T15:08:37.078Z
9176321 9176321 20260110051503_dsMpz UK000T 2026-01-11T14:08:44.204Z 2026-01-18T15:08:34.701Z
9176117 9176117 20260110044838_PQq31 UK000T 2026-01-11T14:08:12.782Z 2026-01-18T15:08:19.540Z
9175916 9175916 20260110041558_K224v UK000T 2026-01-11T14:07:47.866Z 2026-01-18T15:08:13.247Z
9175632 9175632 20260110031345_3jhLY UK000T 2026-01-11T14:06:57.316Z 2026-01-18T15:07:53.980Z
9175547 9175547 20260110025335_nCb3p UK000T 2026-01-11T14:06:42.583Z 2026-01-18T15:07:49.832Z
9175165 9175165 20260110013058_IgQvG UK000T 2026-01-11T14:05:36.071Z 2026-01-18T15:07:35.402Z
9175098 9175098 20260110010559_schvV UK000T 2026-01-11T14:05:22.760Z 2026-01-18T15:07:25.729Z
9175081 9175081 20260110010258_8XP8v UK000T 2026-01-11T14:05:20.450Z 2026-01-18T15:07:25.323Z
9175019 9175019 20260110004643_f8OfD UK000T 2026-01-11T14:05:10.199Z 2026-01-18T15:07:23.382Z
9174726 9174726 20260109220134_VjjCL UK000T 2026-01-11T14:04:12.528Z 2026-01-18T15:07:07.938Z
9174722 9174722 20260109215803_9pPCF UK000T 2026-01-11T14:04:09.810Z 2026-01-18T15:07:07.636Z
9174707 9174707 20260109215424_bg0X2 UK000T 2026-01-11T14:04:07.080Z 2026-01-18T15:07:06.923Z
9163485 9163485 20260107065350_MflB2 UK000T 2026-01-08T14:09:15.679Z 2026-01-13T15:03:17.261Z
9163380 9163380 20260107062817_febf2 UK000T 2026-01-08T14:08:58.892Z 2026-01-13T15:03:11.537Z
9163239 9163239 20260107061111_JZRvc UK000T 2026-01-08T14:08:36.104Z 2026-01-13T15:03:06.992Z
9160328 9160328 20260106053227_0yFy0 UK000T 2026-01-07T14:12:17.852Z 2026-01-13T15:09:20.517Z
9158279 9158279 20260105214055_tHlvL UK000T 2026-01-07T14:05:39.954Z 2026-01-13T15:07:16.966Z
9158194 9158194 20260105205812_E3Anb UK000T 2026-01-07T14:05:16.645Z 2026-01-13T15:07:03.448Z
9157918 9157918 20260105192454_b1B3p UK000T 2026-01-07T14:04:10.206Z 2026-01-13T15:06:45.622Z
9157566 9157566 20260105175639_LvEqN UK000T 2026-01-07T14:02:40.158Z 2026-01-13T15:06:17.947Z
9151834 9151834 20260105064026_lLTLS UK000T 2026-01-06T14:14:52.725Z 2026-01-13T15:15:08.552Z
9151768 9151768 20260105062933_S9KTL UK000T 2026-01-06T14:14:37.457Z 2026-01-13T15:15:04.830Z
9151753 9151753 20260105062559_fLOqQ UK000T 2026-01-06T14:14:34.152Z 2026-01-13T15:15:04.261Z
9151619 9151619 20260105060350_VQgB3 UK000T 2026-01-06T14:14:10.791Z 2026-01-13T15:14:58.106Z
9149658 9149658 20260104224737_OyZ9Y UK000T 2026-01-06T14:06:32.731Z 2026-01-13T15:12:25.216Z
9149491 9149491 20260104213210_Id3f0 UK000T 2026-01-06T14:05:44.201Z 2026-01-13T15:12:14.456Z
9149185 9149185 20260104191618_SnzSS UK000T 2026-01-06T14:04:13.654Z 2026-01-13T15:11:47.420Z
9149013 9149013 20260104182903_CAw28 UK000T 2026-01-06T14:03:28.263Z 2026-01-13T15:11:38.254Z
9147774 9147774 20260104065257_imJXF UK000T 2026-01-05T14:24:50.791Z 2026-01-12T15:11:40.008Z
9147764 9147764 20260104064931_3RpSu UK000T 2026-01-05T14:24:49.840Z 2026-01-12T15:11:38.905Z
9147759 9147759 20260104064530_ISbYC UK000T 2026-01-05T14:24:48.863Z 2026-01-12T15:11:37.687Z

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