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

2,774 rows where station_code = "UK0096" 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
9608415 9608415 20260403230111_uoxQ2 UK0096 2026-04-05T12:10:23.270Z 2026-04-06T12:20:11.618Z
9608400 9608400 20260403225743_HrJ42 UK0096 2026-04-05T12:10:21.122Z 2026-04-06T12:20:10.804Z
9608351 9608351 20260403222133_y72cU UK0096 2026-04-05T12:10:09.603Z 2026-04-06T12:20:07.269Z
9608337 9608337 20260403220803_HauoT UK0096 2026-04-05T12:10:03.819Z 2026-04-06T12:20:06.492Z
9604949 9604949 20260402021450_EX7Xx UK0096 2026-04-03T12:12:24.146Z 2026-04-06T12:26:34.225Z
9604903 9604903 20260402014853_s1gtb UK0096 2026-04-03T12:12:08.127Z 2026-04-06T12:26:30.766Z
9604854 9604854 20260402012203_BlzJp UK0096 2026-04-03T12:11:56.040Z 2026-04-06T12:26:27.813Z
9604808 9604808 20260402005158_dKZyL UK0096 2026-04-03T12:11:37.760Z 2026-04-06T12:26:20.309Z
9604695 9604695 20260401234649_zk6W4 UK0096 2026-04-03T12:11:15.653Z 2026-04-06T12:26:11.979Z
9604680 9604680 20260401234126_bnO2t UK0096 2026-04-03T12:11:07.579Z 2026-04-06T12:26:11.253Z
9604650 9604650 20260401230638_LXae8 UK0096 2026-04-03T12:10:59.651Z 2026-04-06T12:26:09.396Z
9602916 9602916 20260402035855_22XQP UK0096 2026-04-03T12:01:10.683Z 2026-04-06T12:21:20.459Z
9595358 9595358 20260330034712_5O3cF UK0096 2026-03-31T12:01:13.391Z 2026-04-06T12:29:59.519Z
9591831 9591831 20260327222244_8MkW4 UK0096 2026-03-29T12:06:50.049Z 2026-04-05T12:35:16.114Z
9591826 9591826 20260327221901_aH7nY UK0096 2026-03-29T12:06:49.665Z 2026-04-05T12:35:15.935Z
9585347 9585347 20260326002258_kYp2u UK0096 2026-03-27T12:17:10.026Z 2026-04-03T12:39:57.511Z
9585266 9585266 20260326000506_CbN0W UK0096 2026-03-27T12:17:02.515Z 2026-04-03T12:39:53.501Z
9585041 9585041 20260325231008_5WGyt UK0096 2026-03-27T12:16:35.090Z 2026-04-03T12:39:47.400Z
9584829 9584829 20260325222353_lrJ8K UK0096 2026-03-27T12:16:11.298Z 2026-04-03T12:39:41.817Z
9584610 9584610 20260325210855_5aHqw UK0096 2026-03-27T12:15:49.165Z 2026-04-03T12:39:23.977Z
9584539 9584539 20260325203044_xndr5 UK0096 2026-03-27T12:15:36.058Z 2026-04-03T12:39:19.040Z
9581699 9581699 20260326034504_YseDp UK0096 2026-03-27T12:03:41.263Z 2026-04-04T12:39:15.310Z
9581652 9581652 20260326033855_MQMIg UK0096 2026-03-27T12:03:33.662Z 2026-04-04T12:39:13.255Z
9581643 9581643 20260326033739_sNiWZ UK0096 2026-03-27T12:03:32.121Z 2026-04-04T12:39:12.908Z
9581498 9581498 20260326031930_w6WTD UK0096 2026-03-27T12:03:17.590Z 2026-04-04T12:39:08.784Z
9581437 9581437 20260326031319_903G6 UK0096 2026-03-27T12:03:07.742Z 2026-04-04T12:39:05.446Z
9581320 9581320 20260326025251_levOD UK0096 2026-03-27T12:02:42.575Z 2026-04-04T12:38:52.491Z
9580872 9580872 20260326014833_tD4Dz UK0096 2026-03-27T12:01:36.932Z 2026-04-04T12:38:31.999Z
9580787 9580787 20260326013144_KcZSM UK0096 2026-03-27T12:01:24.542Z 2026-04-04T12:38:29.247Z
9580644 9580644 20260326011201_7rQj5 UK0096 2026-03-27T12:01:02.553Z 2026-04-04T12:38:19.130Z
9575829 9575829 20260325002148_0Rirr UK0096 2026-03-26T12:00:20.035Z 2026-04-03T12:35:23.662Z
9570619 9570619 20260322221805_BZDCf UK0096 2026-03-24T12:23:32.970Z 2026-03-30T12:30:46.692Z
9552153 9552153 20260320230500_Ws3C3 UK0096 2026-03-22T12:27:29.798Z 2026-03-28T12:37:07.366Z
9552042 9552042 20260320224110_Cnn57 UK0096 2026-03-22T12:27:23.881Z 2026-03-28T12:37:05.787Z
9551816 9551816 20260320214915_EGd58 UK0096 2026-03-22T12:27:04.682Z 2026-03-28T12:37:02.510Z
9543089 9543089 20260321023547_gO1aQ UK0096 2026-03-22T12:02:38.656Z 2026-03-29T12:19:02.791Z
9542552 9542552 20260321001314_Krl49 UK0096 2026-03-22T12:00:45.380Z 2026-03-29T12:18:45.563Z
9542272 9542272 20260319230651_csaRn UK0096 2026-03-21T12:29:54.975Z 2026-03-27T12:42:53.060Z
9541505 9541505 20260319204838_zAgtP UK0096 2026-03-21T12:29:01.291Z 2026-03-27T12:42:38.386Z
9541210 9541210 20260319200312_JQCu4 UK0096 2026-03-21T12:28:44.484Z 2026-03-27T12:42:35.540Z
9534870 9534870 20260320043321_dfz2p UK0096 2026-03-21T12:09:05.326Z 2026-03-28T12:34:23.085Z
9534687 9534687 20260320041251_Ug2P7 UK0096 2026-03-21T12:08:38.077Z 2026-03-28T12:34:20.912Z
9534222 9534222 20260320033712_pCxmu UK0096 2026-03-21T12:07:29.060Z 2026-03-28T12:34:16.253Z
9534027 9534027 20260320031746_u2e5E UK0096 2026-03-21T12:06:56.535Z 2026-03-28T12:34:04.000Z
9533167 9533167 20260320020542_3PMlo UK0096 2026-03-21T12:04:38.322Z 2026-03-28T12:33:49.487Z
9532278 9532278 20260320004400_5x0cA UK0096 2026-03-21T12:02:17.418Z 2026-03-28T12:33:27.193Z
9531867 9531867 20260319235801_3V71s UK0096 2026-03-21T12:01:04.401Z 2026-03-28T12:33:22.336Z
9531577 9531577 20260319232546_cgwm6 UK0096 2026-03-21T12:00:16.703Z 2026-03-28T12:33:18.786Z
9531343 9531343 20260318225854_ynr7W UK0096 2026-03-20T12:25:07.266Z 2026-03-26T12:39:18.907Z
9522018 9522018 20260319051128_2mvyU UK0096 2026-03-20T12:08:51.609Z 2026-03-27T12:41:12.713Z
9521593 9521593 20260319042803_nAHOK UK0096 2026-03-20T12:08:15.759Z 2026-03-27T12:40:55.999Z
9521551 9521551 20260319042623_y3hTh UK0096 2026-03-20T12:08:13.327Z 2026-03-27T12:40:55.763Z
9521244 9521244 20260319035931_d8VdI UK0096 2026-03-20T12:07:44.834Z 2026-03-27T12:40:52.966Z
9521239 9521239 20260319035859_ksSd9 UK0096 2026-03-20T12:07:44.312Z 2026-03-27T12:40:52.888Z
9521079 9521079 20260319035317_z5d2U UK0096 2026-03-20T12:07:29.707Z 2026-03-27T12:40:50.944Z
9520888 9520888 20260319034405_JU118 UK0096 2026-03-20T12:07:12.169Z 2026-03-27T12:40:48.817Z
9520742 9520742 20260319033429_bASCC UK0096 2026-03-20T12:06:54.119Z 2026-03-27T12:40:46.799Z
9519816 9519816 20260319023920_UeLlO UK0096 2026-03-20T12:05:11.586Z 2026-03-27T12:40:35.926Z
9518701 9518701 20260319011947_WNmXm UK0096 2026-03-20T12:03:08.614Z 2026-03-27T12:40:12.772Z
9518594 9518594 20260319011215_Oeiju UK0096 2026-03-20T12:02:56.476Z 2026-03-27T12:40:11.705Z
9517494 9517494 20260318233339_EXk55 UK0096 2026-03-20T12:00:31.841Z 2026-03-27T12:40:00.272Z
9508602 9508602 20260318010442_Ot38h UK0096 2026-03-19T12:03:29.023Z 2026-03-26T12:36:59.741Z
9501627 9501627 20260315225510_Cqvd2 UK0096 2026-03-17T12:25:20.134Z 2026-03-23T12:22:45.252Z
9500989 9500989 20260315203430_Vs2mJ UK0096 2026-03-17T12:24:16.412Z 2026-03-23T12:22:42.656Z
9500896 9500896 20260315195633_fPai1 UK0096 2026-03-17T12:24:08.796Z 2026-03-23T12:22:42.229Z
9494967 9494967 20260316034200_0oE5M UK0096 2026-03-17T12:05:40.397Z 2026-03-24T12:40:51.475Z
9494869 9494869 20260316031550_eHy6A UK0096 2026-03-17T12:05:19.499Z 2026-03-24T12:40:50.775Z
9494857 9494857 20260316031444_hx08H UK0096 2026-03-17T12:05:15.976Z 2026-03-24T12:40:50.691Z
9494854 9494854 20260316031443_y0uvF UK0096 2026-03-17T12:05:15.472Z 2026-03-24T12:40:50.686Z
9494824 9494824 20260316030926_Sw0PY UK0096 2026-03-17T12:05:08.475Z 2026-03-24T12:40:50.433Z
9494657 9494657 20260316024336_qhcgx UK0096 2026-03-17T12:04:31.856Z 2026-03-24T12:40:49.113Z
9494626 9494626 20260316023740_mXo3j UK0096 2026-03-17T12:04:25.395Z 2026-03-24T12:40:48.798Z
9494594 9494594 20260316023149_feq5L UK0096 2026-03-17T12:04:18.671Z 2026-03-24T12:40:48.499Z
9494495 9494495 20260316022451_cK0j3 UK0096 2026-03-17T12:04:07.714Z 2026-03-24T12:40:47.878Z
9494268 9494268 20260316014736_B4p25 UK0096 2026-03-17T12:03:28.943Z 2026-03-24T12:40:46.422Z
9493898 9493898 20260316005247_A7uDt UK0096 2026-03-17T12:02:21.708Z 2026-03-24T12:40:42.985Z
9493754 9493754 20260316002957_I1mMX UK0096 2026-03-17T12:01:56.261Z 2026-03-24T12:40:41.778Z
9493541 9493541 20260315234807_QAF1g UK0096 2026-03-17T12:01:14.796Z 2026-03-24T12:40:40.509Z
9493455 9493455 20260315233211_TN9Dl UK0096 2026-03-17T12:00:57.197Z 2026-03-24T12:40:39.887Z
9493446 9493446 20260315233111_CGTD8 UK0096 2026-03-17T12:00:55.160Z 2026-03-24T12:40:39.776Z
9493319 9493319 20260315230845_pHIMH UK0096 2026-03-17T12:00:24.157Z 2026-03-24T12:40:38.630Z
9482962 9482962 20260313200239_JhXWI UK0096 2026-03-15T12:25:39.286Z 2026-03-21T12:50:12.671Z
9477490 9477490 20260314050118_InaN3 UK0096 2026-03-15T12:08:24.234Z 2026-03-22T12:42:03.117Z
9476121 9476121 20260314023833_arzqG UK0096 2026-03-15T12:05:06.380Z 2026-03-22T12:41:54.341Z
9474497 9474497 20260313230131_FvTjs UK0096 2026-03-15T12:00:21.880Z 2026-03-22T12:41:20.868Z
9474121 9474121 20260312205035_EsR6I UK0096 2026-03-14T12:22:06.750Z 2026-03-20T12:37:16.096Z
9474066 9474066 20260312200339_22hsg UK0096 2026-03-14T12:21:53.395Z 2026-03-20T12:37:15.333Z
9468762 9468762 20260313003401_jaJ9f UK0096 2026-03-14T12:01:40.470Z 2026-03-21T12:48:28.791Z
9468672 9468672 20260313001330_2mNww UK0096 2026-03-14T12:01:18.379Z 2026-03-21T12:48:27.719Z
9468531 9468531 20260312231919_R9d25 UK0096 2026-03-14T12:00:33.929Z 2026-03-21T12:48:25.868Z
9457057 9457057 20260311022208_1gEZO UK0096 2026-03-12T12:02:42.398Z 2026-03-19T12:44:25.198Z
9456996 9456996 20260311020321_9gWH2 UK0096 2026-03-12T12:02:31.065Z 2026-03-19T12:44:24.585Z
9456940 9456940 20260311014928_0AJL9 UK0096 2026-03-12T12:02:17.329Z 2026-03-19T12:44:23.880Z
9456834 9456834 20260311011331_KE7PZ UK0096 2026-03-12T12:01:54.948Z 2026-03-19T12:44:22.586Z
9456226 9456226 20260309222344_5UZTK UK0096 2026-03-11T12:15:52.238Z 2026-03-17T12:42:59.355Z
9450728 9450728 20260309225650_bS8Av UK0096 2026-03-11T12:00:26.297Z 2026-03-18T12:38:34.737Z
9450688 9450688 20260309224345_3s3Bm UK0096 2026-03-11T12:00:14.895Z 2026-03-18T12:38:33.878Z
9445881 9445881 20260307222212_28ai3 UK0096 2026-03-09T12:21:04.747Z 2026-03-15T12:42:15.194Z
9445627 9445627 20260307205126_ieP8N UK0096 2026-03-09T12:20:06.138Z 2026-03-15T12:42:12.194Z
9441897 9441897 20260308000947_uC5hB UK0096 2026-03-09T12:01:40.296Z 2026-03-16T12:43:32.887Z

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