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,850 rows where station_code = "UK00A2" 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
9602906 9602906 20260402035652_paXKO UK00A2 2026-04-03T12:01:06.762Z 2026-04-06T12:21:20.060Z
9595539 9595539 20260330043910_b0Qxp UK00A2 2026-03-31T12:01:40.661Z 2026-04-06T12:30:08.344Z
9595259 9595259 20260330031159_Kv4Lv UK00A2 2026-03-31T12:00:54.955Z 2026-04-06T12:29:50.354Z
9595236 9595236 20260330030810_nhXXz UK00A2 2026-03-31T12:00:51.118Z 2026-04-06T12:29:49.243Z
9595029 9595029 20260330014219_1x7IJ UK00A2 2026-03-31T12:00:14.707Z 2026-04-06T12:29:35.976Z
9594985 9594985 20260329011237_xl1aA UK00A2 2026-03-30T12:10:43.126Z 2026-04-06T12:40:22.188Z
9594833 9594833 20260329004013_4jjvv UK00A2 2026-03-30T12:10:24.332Z 2026-04-06T12:40:17.497Z
9592558 9592558 20260329023006_6jQhS UK00A2 2026-03-30T12:01:18.063Z 2026-04-06T12:34:15.289Z
9592414 9592414 20260329020411_1uRNI UK00A2 2026-03-30T12:00:55.108Z 2026-04-06T12:34:09.594Z
9592097 9592097 20260328003256_8dQXq UK00A2 2026-03-29T12:07:10.199Z 2026-04-05T12:35:35.277Z
9591976 9591976 20260327233855_76XFC UK00A2 2026-03-29T12:07:03.850Z 2026-04-05T12:35:23.155Z
9590064 9590064 20260328044241_zMUht UK00A2 2026-03-29T12:01:56.222Z 2026-04-06T12:37:48.852Z
9590059 9590059 20260328044240_zhGKi UK00A2 2026-03-29T12:01:56.006Z 2026-04-06T12:37:48.710Z
9590021 9590021 20260328042847_wUM0T UK00A2 2026-03-29T12:01:52.527Z 2026-04-06T12:37:47.324Z
9589428 9589428 20260328032850_c1neJ UK00A2 2026-03-29T12:01:13.744Z 2026-04-06T12:37:23.275Z
9588976 9588976 20260328020912_LvPVH UK00A2 2026-03-29T12:00:36.244Z 2026-04-06T12:36:58.638Z
9588867 9588867 20260328013919_v3B2J UK00A2 2026-03-29T12:00:24.089Z 2026-04-06T12:36:54.768Z
9588749 9588749 20260325205426_wrsKj UK00A2 2026-03-28T12:15:41.443Z 2026-04-03T12:39:23.231Z
9588747 9588747 20260325202505_gIQMD UK00A2 2026-03-28T12:15:38.085Z 2026-04-03T12:39:18.107Z
9585235 9585235 20260325234937_PIZhQ UK00A2 2026-03-27T12:16:57.131Z 2026-04-03T12:39:52.141Z
9585167 9585167 20260325233750_ai2lA UK00A2 2026-03-27T12:16:52.858Z 2026-04-03T12:39:50.946Z
9584796 9584796 20260325221604_zLrA2 UK00A2 2026-03-27T12:16:08.912Z 2026-04-03T12:39:41.289Z
9584651 9584651 20260325212810_SuSmQ UK00A2 2026-03-27T12:15:54.637Z 2026-04-03T12:39:25.511Z
9582193 9582193 20260326045307_VRsT1 UK00A2 2026-03-27T12:04:52.373Z 2026-04-04T12:39:41.015Z
9581966 9581966 20260326041617_B5tBl UK00A2 2026-03-27T12:04:16.607Z 2026-04-04T12:39:33.011Z
9581273 9581273 20260326024528_SocHO UK00A2 2026-03-27T12:02:36.395Z 2026-04-04T12:38:51.307Z
9581116 9581116 20260326022650_hXDVE UK00A2 2026-03-27T12:02:10.938Z 2026-04-04T12:38:43.282Z
9581087 9581087 20260326022108_Mip6C UK00A2 2026-03-27T12:02:05.833Z 2026-04-04T12:38:42.231Z
9580506 9580506 20260326005712_yqcNF UK00A2 2026-03-27T12:00:40.053Z 2026-04-04T12:38:12.553Z
9580416 9580416 20260326004631_tUsRv UK00A2 2026-03-27T12:00:25.540Z 2026-04-04T12:38:09.407Z
9580107 9580107 20260325000458_9ClUt UK00A2 2026-03-26T12:15:05.890Z 2026-04-02T12:37:42.336Z
9561190 9561190 20260321230640_o7qIM UK00A2 2026-03-23T12:12:13.274Z 2026-03-29T12:21:05.566Z
9561019 9561019 20260321224658_dqYwF UK00A2 2026-03-23T12:12:09.639Z 2026-03-29T12:21:04.654Z
9560965 9560965 20260321223923_U30yk UK00A2 2026-03-23T12:12:08.525Z 2026-03-29T12:21:04.250Z
9560893 9560893 20260321223243_aPUbb UK00A2 2026-03-23T12:12:06.713Z 2026-03-29T12:21:03.754Z
9560821 9560821 20260321222056_jRgpS UK00A2 2026-03-23T12:12:04.799Z 2026-03-29T12:21:03.189Z
9560535 9560535 20260321213731_L6Ylh UK00A2 2026-03-23T12:11:51.037Z 2026-03-29T12:21:01.092Z
9560264 9560264 20260321205504_o8ZeS UK00A2 2026-03-23T12:11:40.790Z 2026-03-29T12:20:58.859Z
9560147 9560147 20260321203526_yU7o7 UK00A2 2026-03-23T12:11:39.011Z 2026-03-29T12:20:58.204Z
9555432 9555432 20260322045620_55Q4l UK00A2 2026-03-23T12:03:25.793Z 2026-03-30T12:28:26.543Z
9555424 9555424 20260322045615_3bfFA UK00A2 2026-03-23T12:03:25.539Z 2026-03-30T12:28:26.470Z
9555365 9555365 20260322044625_Rn3me UK00A2 2026-03-23T12:03:22.780Z 2026-03-30T12:28:25.613Z
9555308 9555308 20260322043915_EWkl0 UK00A2 2026-03-23T12:03:20.005Z 2026-03-30T12:28:24.626Z
9555289 9555289 20260322043712_tiXTu UK00A2 2026-03-23T12:03:19.442Z 2026-03-30T12:28:24.409Z
9555279 9555279 20260322043629_hOzkU UK00A2 2026-03-23T12:03:18.987Z 2026-03-30T12:28:24.206Z
9555152 9555152 20260322041013_CqVEV UK00A2 2026-03-23T12:03:11.790Z 2026-03-30T12:28:15.003Z
9555140 9555140 20260322041001_DRLrz UK00A2 2026-03-23T12:03:11.636Z 2026-03-30T12:28:14.966Z
9555035 9555035 20260322035730_oz84h UK00A2 2026-03-23T12:03:05.880Z 2026-03-30T12:28:13.502Z
9554656 9554656 20260322032353_ydj8E UK00A2 2026-03-23T12:02:44.659Z 2026-03-30T12:28:06.845Z
9554644 9554644 20260322032237_P3tv5 UK00A2 2026-03-23T12:02:44.175Z 2026-03-30T12:28:06.727Z
9554517 9554517 20260322031521_M5Oec UK00A2 2026-03-23T12:02:38.663Z 2026-03-30T12:28:05.033Z
9553690 9553690 20260322020602_qLaT6 UK00A2 2026-03-23T12:01:46.116Z 2026-03-30T12:27:50.996Z
9552924 9552924 20260322005617_aTSgu UK00A2 2026-03-23T12:01:00.725Z 2026-03-30T12:27:32.290Z
9552594 9552594 20260322002310_vBtOJ UK00A2 2026-03-23T12:00:36.345Z 2026-03-30T12:27:26.756Z
9552381 9552381 20260321235806_OqLBC UK00A2 2026-03-23T12:00:19.150Z 2026-03-30T12:27:23.106Z
9533758 9533758 20260320025526_ngt6P UK00A2 2026-03-21T12:06:12.494Z 2026-03-28T12:34:00.167Z
9533329 9533329 20260320022427_19dRJ UK00A2 2026-03-21T12:05:10.686Z 2026-03-28T12:33:52.019Z
9522020 9522020 20260319051308_429Qm UK00A2 2026-03-20T12:08:51.986Z 2026-03-27T12:41:12.729Z
9521764 9521764 20260319044236_RQJ3N UK00A2 2026-03-20T12:08:30.704Z 2026-03-27T12:41:10.573Z
9521577 9521577 20260319042719_cRp5W UK00A2 2026-03-20T12:08:14.411Z 2026-03-27T12:40:55.899Z
9521403 9521403 20260319041123_YjX0R UK00A2 2026-03-20T12:07:56.939Z 2026-03-27T12:40:54.456Z
9521396 9521396 20260319041123_7462E UK00A2 2026-03-20T12:07:56.494Z 2026-03-27T12:40:54.423Z
9521044 9521044 20260319035118_DY9PV UK00A2 2026-03-20T12:07:26.152Z 2026-03-27T12:40:50.495Z
9520964 9520964 20260319034605_ujrGJ UK00A2 2026-03-20T12:07:17.673Z 2026-03-27T12:40:49.404Z
9520923 9520923 20260319034432_YJVr3 UK00A2 2026-03-20T12:07:14.967Z 2026-03-27T12:40:49.133Z
9520221 9520221 20260319030443_dEMcJ UK00A2 2026-03-20T12:05:59.813Z 2026-03-27T12:40:40.652Z
9520163 9520163 20260319025740_bJ0oC UK00A2 2026-03-20T12:05:51.932Z 2026-03-27T12:40:39.784Z
9520147 9520147 20260319025628_U4srn UK00A2 2026-03-20T12:05:50.121Z 2026-03-27T12:40:39.633Z
9519897 9519897 20260319024308_tLrHx UK00A2 2026-03-20T12:05:22.293Z 2026-03-27T12:40:36.969Z
9516459 9516459 20260317205513_FB509 UK00A2 2026-03-19T12:26:14.089Z 2026-03-25T12:42:59.337Z
9512243 9512243 20260318045919_CqQCj UK00A2 2026-03-19T12:11:59.533Z 2026-03-26T12:37:43.301Z
9511870 9511870 20260318042622_eHDkL UK00A2 2026-03-19T12:11:13.356Z 2026-03-26T12:37:40.439Z
9511526 9511526 20260318035839_Z7b6H UK00A2 2026-03-19T12:10:23.948Z 2026-03-26T12:37:37.689Z
9511511 9511511 20260318035739_li0fv UK00A2 2026-03-19T12:10:22.447Z 2026-03-26T12:37:37.553Z
9501078 9501078 20260315205120_xN0qg UK00A2 2026-03-17T12:24:22.775Z 2026-03-23T12:22:42.921Z
9492372 9492372 20260314203617_ahxFv UK00A2 2026-03-16T12:28:29.691Z 2026-03-22T12:42:52.026Z
9467646 9467646 20260311222834_Bvq2c UK00A2 2026-03-13T12:19:38.511Z 2026-03-19T12:45:53.973Z
9467079 9467079 20260311200025_k9WM7 UK00A2 2026-03-13T12:18:17.457Z 2026-03-19T12:45:47.967Z
9462664 9462664 20260311235632_2AtTf UK00A2 2026-03-13T12:01:47.094Z 2026-03-20T12:36:17.400Z
9462658 9462658 20260311235551_bQyWj UK00A2 2026-03-13T12:01:45.454Z 2026-03-20T12:36:17.372Z
9457250 9457250 20260311031454_DATV7 UK00A2 2026-03-12T12:03:19.606Z 2026-03-19T12:44:34.842Z
9456156 9456156 20260309220057_2CoCh UK00A2 2026-03-11T12:15:45.462Z 2026-03-17T12:42:56.002Z
9455751 9455751 20260309200407_sTKv3 UK00A2 2026-03-11T12:14:54.260Z 2026-03-17T12:42:38.582Z
9455708 9455708 20260309194836_2D6ko UK00A2 2026-03-11T12:14:49.487Z 2026-03-17T12:42:37.913Z
9451630 9451630 20260310030909_T1QMO UK00A2 2026-03-11T12:03:22.949Z 2026-03-18T12:39:01.773Z
9395047 9395047 20260224224500_zJ3op UK00A2 2026-02-26T14:21:01.904Z 2026-03-04T14:19:29.398Z
9394997 9394997 20260224223405_PzrgZ UK00A2 2026-02-26T14:20:58.797Z 2026-03-04T14:19:29.081Z
9394173 9394173 20260224190320_omJpa UK00A2 2026-02-26T14:19:03.550Z 2026-03-04T14:19:17.709Z
9390682 9390682 20260225010348_e3T1d UK00A2 2026-02-26T14:02:09.097Z 2026-03-05T14:35:52.908Z
9381287 9381287 20260222214015_g9h3C UK00A2 2026-02-24T14:24:29.803Z 2026-02-24T14:24:29.803Z
9380688 9380688 20260222200849_qSdvp UK00A2 2026-02-24T14:23:34.736Z 2026-02-24T14:23:34.736Z
9380149 9380149 20260222190055_akjzg UK00A2 2026-02-24T14:22:43.329Z 2026-02-24T14:22:43.329Z
9373582 9373582 20260223033412_29LiE UK00A2 2026-02-24T14:03:23.160Z 2026-03-03T14:31:05.896Z
9373468 9373468 20260223031119_lXaP3 UK00A2 2026-02-24T14:03:03.809Z 2026-03-03T14:31:03.829Z
9373261 9373261 20260223023500_2jimJ UK00A2 2026-02-24T14:02:33.064Z 2026-03-03T14:31:00.478Z
9373205 9373205 20260223022749_jIBbv UK00A2 2026-02-24T14:02:27.949Z 2026-03-03T14:30:59.799Z
9373122 9373122 20260223021329_Sy22b UK00A2 2026-02-24T14:02:14.806Z 2026-03-03T14:30:52.321Z
9372627 9372627 20260223004618_C9Wqe UK00A2 2026-02-24T14:01:02.566Z 2026-03-03T14:30:43.370Z
9358713 9358713 20260221041438_sDPxL UK00A2 2026-02-22T14:02:04.943Z 2026-03-02T14:20:52.734Z
9358151 9358151 20260220000150_xd1VF UK00A2 2026-02-21T14:17:50.080Z 2026-02-28T14:44:49.624Z

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