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

5,839 rows where station_code = "UK0080" 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
9611396 9611396 20260405014700_0M8DE UK0080 2026-04-06T12:14:20.912Z 2026-04-06T12:16:14.793Z
9608964 9608964 20260404025113_kEvv3 UK0080 2026-04-05T12:12:24.864Z 2026-04-06T12:20:53.880Z
9608943 9608943 20260404024427_d7EYk UK0080 2026-04-05T12:12:21.395Z 2026-04-06T12:20:52.343Z
9608546 9608546 20260403233455_nyn2X UK0080 2026-04-05T12:10:47.588Z 2026-04-06T12:20:19.706Z
9608350 9608350 20260403222133_y72cU UK0080 2026-04-05T12:10:09.603Z 2026-04-06T12:20:07.269Z
9608336 9608336 20260403220803_HauoT UK0080 2026-04-05T12:10:03.781Z 2026-04-06T12:20:06.492Z
9604948 9604948 20260402021450_EX7Xx UK0080 2026-04-03T12:12:24.146Z 2026-04-06T12:26:34.225Z
9604902 9604902 20260402014853_s1gtb UK0080 2026-04-03T12:12:08.127Z 2026-04-06T12:26:30.766Z
9604679 9604679 20260401234126_bnO2t UK0080 2026-04-03T12:11:07.579Z 2026-04-06T12:26:11.253Z
9604649 9604649 20260401230638_LXae8 UK0080 2026-04-03T12:10:59.651Z 2026-04-06T12:26:09.396Z
9602915 9602915 20260402035855_22XQP UK0080 2026-04-03T12:01:10.666Z 2026-04-06T12:21:20.459Z
9585346 9585346 20260326002258_kYp2u UK0080 2026-03-27T12:17:10.026Z 2026-04-03T12:39:57.511Z
9585265 9585265 20260326000506_CbN0W UK0080 2026-03-27T12:17:02.515Z 2026-04-03T12:39:53.501Z
9585040 9585040 20260325231008_5WGyt UK0080 2026-03-27T12:16:35.090Z 2026-04-03T12:39:47.400Z
9584828 9584828 20260325222353_lrJ8K UK0080 2026-03-27T12:16:11.298Z 2026-04-03T12:39:41.817Z
9584743 9584743 20260325215326_xOxRi UK0080 2026-03-27T12:16:02.489Z 2026-04-03T12:39:35.283Z
9581698 9581698 20260326034504_YseDp UK0080 2026-03-27T12:03:41.263Z 2026-04-04T12:39:15.310Z
9581651 9581651 20260326033855_MQMIg UK0080 2026-03-27T12:03:33.662Z 2026-04-04T12:39:13.255Z
9581642 9581642 20260326033739_sNiWZ UK0080 2026-03-27T12:03:32.121Z 2026-04-04T12:39:12.908Z
9581497 9581497 20260326031930_w6WTD UK0080 2026-03-27T12:03:17.590Z 2026-04-04T12:39:08.784Z
9581436 9581436 20260326031319_903G6 UK0080 2026-03-27T12:03:07.742Z 2026-04-04T12:39:05.446Z
9581427 9581427 20260326031212_nCbjl UK0080 2026-03-27T12:03:05.465Z 2026-04-04T12:39:04.504Z
9581319 9581319 20260326025251_levOD UK0080 2026-03-27T12:02:42.574Z 2026-04-04T12:38:52.491Z
9580786 9580786 20260326013144_KcZSM UK0080 2026-03-27T12:01:24.542Z 2026-04-04T12:38:29.247Z
9580643 9580643 20260326011201_7rQj5 UK0080 2026-03-27T12:01:02.541Z 2026-04-04T12:38:19.130Z
9579675 9579675 20260324220948_pjEMd UK0080 2026-03-26T12:14:11.075Z 2026-04-02T12:37:24.673Z
9575899 9575899 20260325003735_hnav6 UK0080 2026-03-26T12:00:35.326Z 2026-04-03T12:35:28.268Z
9570618 9570618 20260322221805_BZDCf UK0080 2026-03-24T12:23:32.920Z 2026-03-30T12:30:46.692Z
9552199 9552199 20260320231743_CEL0y UK0080 2026-03-22T12:27:32.305Z 2026-03-28T12:37:07.844Z
9552152 9552152 20260320230500_Ws3C3 UK0080 2026-03-22T12:27:29.798Z 2026-03-28T12:37:07.366Z
9552041 9552041 20260320224110_Cnn57 UK0080 2026-03-22T12:27:23.881Z 2026-03-28T12:37:05.787Z
9542551 9542551 20260321001314_Krl49 UK0080 2026-03-22T12:00:45.356Z 2026-03-29T12:18:45.563Z
9542271 9542271 20260319230651_csaRn UK0080 2026-03-21T12:29:54.975Z 2026-03-27T12:42:53.060Z
9541504 9541504 20260319204838_zAgtP UK0080 2026-03-21T12:29:01.291Z 2026-03-27T12:42:38.386Z
9541209 9541209 20260319200312_JQCu4 UK0080 2026-03-21T12:28:44.484Z 2026-03-27T12:42:35.540Z
9534686 9534686 20260320041251_Ug2P7 UK0080 2026-03-21T12:08:38.077Z 2026-03-28T12:34:20.912Z
9534221 9534221 20260320033712_pCxmu UK0080 2026-03-21T12:07:29.060Z 2026-03-28T12:34:16.253Z
9533166 9533166 20260320020542_3PMlo UK0080 2026-03-21T12:04:38.273Z 2026-03-28T12:33:49.487Z
9511943 9511943 20260318042943_1njGR UK0080 2026-03-19T12:11:21.869Z 2026-03-26T12:37:40.872Z
9511775 9511775 20260318041644_mDwxn UK0080 2026-03-19T12:11:00.197Z 2026-03-26T12:37:39.652Z
9511581 9511581 20260318040243_LO463 UK0080 2026-03-19T12:10:32.258Z 2026-03-26T12:37:38.030Z
9511073 9511073 20260318033521_eyOdl UK0080 2026-03-19T12:09:24.492Z 2026-03-26T12:37:19.224Z
9510971 9510971 20260318032725_VUKj3 UK0080 2026-03-19T12:09:07.209Z 2026-03-26T12:37:18.376Z
9510737 9510737 20260318031109_dFUn5 UK0080 2026-03-19T12:08:30.604Z 2026-03-26T12:37:16.110Z
9509686 9509686 20260318020727_xf57o UK0080 2026-03-19T12:05:58.175Z 2026-03-26T12:37:07.027Z
9509598 9509598 20260318020002_4RmST UK0080 2026-03-19T12:05:44.777Z 2026-03-26T12:37:06.587Z
9493454 9493454 20260315233211_TN9Dl UK0080 2026-03-17T12:00:57.187Z 2026-03-24T12:40:39.887Z
9483462 9483462 20260313221747_8FCQr UK0080 2026-03-15T12:26:33.197Z 2026-03-21T12:50:27.834Z
9477564 9477564 20260314051546_lQmMI UK0080 2026-03-15T12:08:31.589Z 2026-03-22T12:42:03.580Z
9477489 9477489 20260314050118_InaN3 UK0080 2026-03-15T12:08:24.234Z 2026-03-22T12:42:03.117Z
9476119 9476119 20260314023833_arzqG UK0080 2026-03-15T12:05:06.380Z 2026-03-22T12:41:54.341Z
9475092 9475092 20260314003632_yWyJL UK0080 2026-03-15T12:02:12.879Z 2026-03-22T12:41:26.921Z
9474592 9474592 20260313232038_nMAZa UK0080 2026-03-15T12:00:39.066Z 2026-03-22T12:41:21.657Z
9474496 9474496 20260313230131_FvTjs UK0080 2026-03-15T12:00:21.867Z 2026-03-22T12:41:20.868Z
9474065 9474065 20260312200339_22hsg UK0080 2026-03-14T12:21:53.373Z 2026-03-20T12:37:15.333Z
9441896 9441896 20260308000947_uC5hB UK0080 2026-03-09T12:01:40.279Z 2026-03-16T12:43:32.887Z
9441462 9441462 20260306220233_psSnu UK0080 2026-03-08T12:22:01.447Z 2026-03-14T12:40:52.462Z
9441459 9441459 20260306220027_nzr3p UK0080 2026-03-08T12:22:00.668Z 2026-03-14T12:40:52.404Z
9441402 9441402 20260306212825_XFtZH UK0080 2026-03-08T12:21:42.840Z 2026-03-14T12:40:51.644Z
9437091 9437091 20260307015045_lD4LM UK0080 2026-03-08T12:02:34.196Z 2026-03-15T12:41:02.047Z
9437085 9437085 20260307014731_tb7ph UK0080 2026-03-08T12:02:33.053Z 2026-03-15T12:41:01.929Z
9437062 9437062 20260307014139_Gw2Bc UK0080 2026-03-08T12:02:28.576Z 2026-03-15T12:41:01.593Z
9437057 9437057 20260307013858_kHWwT UK0080 2026-03-08T12:02:27.552Z 2026-03-15T12:41:01.467Z
9436770 9436770 20260306234707_pZo7i UK0080 2026-03-08T12:01:10.810Z 2026-03-15T12:40:57.499Z
9436753 9436753 20260306234100_aNMyk UK0080 2026-03-08T12:01:04.964Z 2026-03-15T12:40:57.239Z
9436649 9436649 20260306231223_7UIsC UK0080 2026-03-08T12:00:34.745Z 2026-03-15T12:40:55.831Z
9436643 9436643 20260306230809_P3Ki4 UK0080 2026-03-08T12:00:32.967Z 2026-03-15T12:40:55.726Z
9432382 9432382 20260306053717_X6fC0 UK0080 2026-03-07T14:04:31.408Z 2026-03-14T12:39:29.408Z
9432363 9432363 20260306051943_HYStg UK0080 2026-03-07T14:04:26.866Z 2026-03-14T12:39:29.090Z
9432262 9432262 20260306041155_sOVr4 UK0080 2026-03-07T14:04:04.336Z 2026-03-14T12:39:27.729Z
9425501 9425501 20260303221431_IW5WU UK0080 2026-03-05T14:15:14.075Z 2026-03-11T12:29:05.389Z
9425466 9425466 20260303215708_44Cs3 UK0080 2026-03-05T14:15:08.146Z 2026-03-11T12:29:04.982Z
9425388 9425388 20260303204907_TXxpP UK0080 2026-03-05T14:14:52.514Z 2026-03-11T12:29:03.430Z
9422314 9422314 20260304001630_YJmdT UK0080 2026-03-05T14:00:51.961Z 2026-03-12T12:32:25.863Z
9422192 9422192 20260303225721_pHoEu UK0080 2026-03-05T14:00:18.437Z 2026-03-12T12:32:23.615Z
9422180 9422180 20260303225201_ZEDpK UK0080 2026-03-05T14:00:13.612Z 2026-03-12T12:32:23.265Z
9422174 9422174 20260303224642_mpp7x UK0080 2026-03-05T14:00:10.876Z 2026-03-12T12:32:23.086Z
9419698 9419698 20260303052631_ie2TW UK0080 2026-03-04T14:01:56.173Z 2026-03-11T12:28:05.064Z
9411816 9411816 20260227210816_lgEze UK0080 2026-03-01T14:09:06.302Z 2026-03-07T14:51:11.468Z
9411777 9411777 20260227195221_VTrgQ UK0080 2026-03-01T14:08:48.703Z 2026-03-07T14:51:00.327Z
9409648 9409648 20260228040831_EoNC0 UK0080 2026-03-01T14:01:57.106Z 2026-03-08T12:41:26.065Z
9409569 9409569 20260228034826_OBwWK UK0080 2026-03-01T14:01:45.459Z 2026-03-08T12:41:22.546Z
9364756 9364756 20260222002112_3yFsr UK0080 2026-02-23T14:00:31.565Z 2026-02-24T14:14:29.861Z
9340586 9340586 20260217004132_FDTUz UK0080 2026-02-18T14:25:22.355Z 2026-02-25T14:42:56.160Z
9340524 9340524 20260217003114_ESN6d UK0080 2026-02-18T14:25:10.456Z 2026-02-25T14:42:55.509Z
9340436 9340436 20260217001021_jcUt1 UK0080 2026-02-18T14:24:53.926Z 2026-02-25T14:42:54.341Z
9340082 9340082 20260216225248_B86SH UK0080 2026-02-18T14:23:59.049Z 2026-02-25T14:42:50.507Z
9339757 9339757 20260216210027_kjZSb UK0080 2026-02-18T14:22:54.474Z 2026-02-25T14:42:45.845Z
9339685 9339685 20260216202751_YY5pe UK0080 2026-02-18T14:22:24.867Z 2026-02-25T14:42:44.489Z
9337611 9337611 20260217055814_TncqA UK0080 2026-02-18T14:07:39.138Z 2026-02-26T14:39:28.034Z
9337498 9337498 20260217054645_Emsn9 UK0080 2026-02-18T14:07:24.124Z 2026-02-26T14:39:27.340Z
9337416 9337416 20260217053602_1Vs5D UK0080 2026-02-18T14:07:10.343Z 2026-02-26T14:39:26.590Z
9337012 9337012 20260217045525_GVfyp UK0080 2026-02-18T14:06:08.736Z 2026-02-26T14:39:23.401Z
9336991 9336991 20260217045038_Mqc1Z UK0080 2026-02-18T14:06:03.949Z 2026-02-26T14:39:23.145Z
9336896 9336896 20260217044229_wOQSx UK0080 2026-02-18T14:05:48.388Z 2026-02-26T14:39:22.607Z
9336355 9336355 20260217034219_9wqXO UK0080 2026-02-18T14:04:10.576Z 2026-02-26T14:39:18.014Z
9336062 9336062 20260217030459_y4I6R UK0080 2026-02-18T14:03:14.667Z 2026-02-26T14:39:14.717Z
9335951 9335951 20260217025518_akuFN UK0080 2026-02-18T14:02:51.563Z 2026-02-26T14:38:59.881Z
9335936 9335936 20260217025341_NbAgb UK0080 2026-02-18T14:02:46.795Z 2026-02-26T14:38:59.695Z
9335727 9335727 20260217023500_Rpxk3 UK0080 2026-02-18T14:02:10.392Z 2026-02-26T14:38:58.209Z

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