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,674 rows where station_code = "UK00AA" 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
9611120 9611120 20260405002254_QUBOj UK00AA 2026-04-06T12:13:03.631Z 2026-04-06T12:16:14.737Z
9611048 9611048 20260404233823_AVwQL UK00AA 2026-04-06T12:12:49.259Z 2026-04-06T12:16:14.719Z
9610800 9610800 20260404215808_L3Pdr UK00AA 2026-04-06T12:11:25.670Z 2026-04-06T12:16:14.664Z
9608950 9608950 20260404024713_tBg5Q UK00AA 2026-04-05T12:12:22.858Z 2026-04-06T12:20:53.013Z
9608225 9608225 20260403205901_83O8v UK00AA 2026-04-05T12:09:35.205Z 2026-04-06T12:19:56.449Z
9608133 9608133 20260403200924_uq6G6 UK00AA 2026-04-05T12:09:00.048Z 2026-04-06T12:19:44.499Z
9604656 9604656 20260401231135_qRb0X UK00AA 2026-04-03T12:11:03.174Z 2026-04-06T12:26:09.697Z
9604589 9604589 20260401214853_1NkF1 UK00AA 2026-04-03T12:10:47.477Z 2026-04-06T12:26:05.381Z
9604554 9604554 20260401203654_GpWoq UK00AA 2026-04-03T12:10:21.567Z 2026-04-06T12:25:55.311Z
9598356 9598356 20260329232218_OSl5O UK00AA 2026-03-31T12:10:26.738Z 2026-04-06T12:36:27.029Z
9594608 9594608 20260328233205_cclW0 UK00AA 2026-03-30T12:09:57.767Z 2026-04-06T12:40:01.433Z
9594446 9594446 20260328222427_3PAlz UK00AA 2026-03-30T12:09:33.773Z 2026-04-06T12:39:52.253Z
9594375 9594375 20260328215751_JIXT0 UK00AA 2026-03-30T12:09:25.491Z 2026-04-06T12:39:49.922Z
9592000 9592000 20260327234015_tksYF UK00AA 2026-03-29T12:07:05.303Z 2026-04-05T12:35:23.684Z
9591877 9591877 20260327225422_2gqCv UK00AA 2026-03-29T12:06:53.653Z 2026-04-05T12:35:18.380Z
9591858 9591858 20260327225036_l1Hmb UK00AA 2026-03-29T12:06:52.311Z 2026-04-05T12:35:17.699Z
9591841 9591841 20260327223007_86vd3 UK00AA 2026-03-29T12:06:50.665Z 2026-04-05T12:35:16.445Z
9591778 9591778 20260327210321_l5RPg UK00AA 2026-03-29T12:06:44.128Z 2026-04-05T12:35:13.311Z
9591777 9591777 20260327205816_qA4eW UK00AA 2026-03-29T12:06:43.899Z 2026-04-05T12:35:13.205Z
9591765 9591765 20260327204906_Cmuu2 UK00AA 2026-03-29T12:06:42.687Z 2026-04-05T12:35:12.643Z
9589620 9589620 20260328035159_If0L3 UK00AA 2026-03-29T12:01:29.726Z 2026-04-06T12:37:29.229Z
9589462 9589462 20260328033128_ne6QC UK00AA 2026-03-29T12:01:17.355Z 2026-04-06T12:37:24.525Z
9589160 9589160 20260328023758_4V1br UK00AA 2026-03-29T12:00:48.207Z 2026-04-06T12:37:03.869Z
9589036 9589036 20260328021645_2XHVH UK00AA 2026-03-29T12:00:39.687Z 2026-04-06T12:37:00.180Z
9585325 9585325 20260326001535_8Mkpk UK00AA 2026-03-27T12:17:07.670Z 2026-04-03T12:39:55.047Z
9584960 9584960 20260325225442_oOgY3 UK00AA 2026-03-27T12:16:26.774Z 2026-04-03T12:39:45.264Z
9581898 9581898 20260326040858_GE2TJ UK00AA 2026-03-27T12:04:05.741Z 2026-04-04T12:39:30.189Z
9581817 9581817 20260326035940_F2gJr UK00AA 2026-03-27T12:03:53.964Z 2026-04-04T12:39:21.355Z
9581785 9581785 20260326035617_PIqPo UK00AA 2026-03-27T12:03:50.691Z 2026-04-04T12:39:20.438Z
9581753 9581753 20260326035503_8PtcB UK00AA 2026-03-27T12:03:48.201Z 2026-04-04T12:39:18.308Z
9581528 9581528 20260326032447_Ejt3U UK00AA 2026-03-27T12:03:21.580Z 2026-04-04T12:39:09.692Z
9580940 9580940 20260326015525_3uAYk UK00AA 2026-03-27T12:01:43.811Z 2026-04-04T12:38:35.005Z
9580912 9580912 20260326015235_iQv3F UK00AA 2026-03-27T12:01:40.745Z 2026-04-04T12:38:33.363Z
9580855 9580855 20260326014531_w1oZx UK00AA 2026-03-27T12:01:33.571Z 2026-04-04T12:38:31.415Z
9579655 9579655 20260324220313_QOQ3g UK00AA 2026-03-26T12:14:08.361Z 2026-04-02T12:37:19.062Z
9576222 9576222 20260325014039_t4un4 UK00AA 2026-03-26T12:01:36.828Z 2026-04-03T12:35:49.026Z
9575844 9575844 20260325002741_3wgjz UK00AA 2026-03-26T12:00:23.914Z 2026-04-03T12:35:26.253Z
9570802 9570802 20260322225102_JsWfc UK00AA 2026-03-24T12:23:50.633Z 2026-03-30T12:30:49.620Z
9570570 9570570 20260322220237_tSVGO UK00AA 2026-03-24T12:23:28.663Z 2026-03-30T12:30:45.669Z
9561086 9561086 20260321225532_iJNAV UK00AA 2026-03-23T12:12:11.405Z 2026-03-29T12:21:05.123Z
9560782 9560782 20260321221404_760j3 UK00AA 2026-03-23T12:12:03.428Z 2026-03-29T12:21:02.826Z
9560243 9560243 20260321205105_4tGlK UK00AA 2026-03-23T12:11:40.504Z 2026-03-29T12:20:58.743Z
9560154 9560154 20260321203534_YSiRT UK00AA 2026-03-23T12:11:39.076Z 2026-03-29T12:20:58.226Z
9560040 9560040 20260321202522_0sNKt UK00AA 2026-03-23T12:11:36.480Z 2026-03-29T12:20:57.499Z
9559901 9559901 20260321200812_xls3O UK00AA 2026-03-23T12:11:33.433Z 2026-03-29T12:20:56.459Z
9559809 9559809 20260321195318_t7581 UK00AA 2026-03-23T12:11:30.959Z 2026-03-29T12:20:55.769Z
9554958 9554958 20260322034719_ssZ2e UK00AA 2026-03-23T12:02:58.736Z 2026-03-30T12:28:12.097Z
9554246 9554246 20260322025321_MnikJ UK00AA 2026-03-23T12:02:22.548Z 2026-03-30T12:28:01.215Z
9554175 9554175 20260322024547_Nb4jt UK00AA 2026-03-23T12:02:18.215Z 2026-03-30T12:27:59.739Z
9554081 9554081 20260322023817_ZD5L2 UK00AA 2026-03-23T12:02:12.812Z 2026-03-30T12:27:58.015Z
9553987 9553987 20260322023008_IzhMY UK00AA 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553913 9553913 20260322022437_ckTUW UK00AA 2026-03-23T12:02:00.074Z 2026-03-30T12:27:55.147Z
9553385 9553385 20260322013551_y9QOl UK00AA 2026-03-23T12:01:26.841Z 2026-03-30T12:27:40.192Z
9553336 9553336 20260322013144_r1lAU UK00AA 2026-03-23T12:01:24.545Z 2026-03-30T12:27:39.556Z
9552951 9552951 20260322005958_OXyVW UK00AA 2026-03-23T12:01:03.382Z 2026-03-30T12:27:32.892Z
9551977 9551977 20260320222828_Corsj UK00AA 2026-03-22T12:27:20.830Z 2026-03-28T12:37:05.246Z
9543700 9543700 20260321044833_lFva8 UK00AA 2026-03-22T12:04:28.508Z 2026-03-29T12:19:10.260Z
9543683 9543683 20260321044255_NfAow UK00AA 2026-03-22T12:04:25.785Z 2026-03-29T12:19:10.095Z
9543581 9543581 20260321042444_0TDxK UK00AA 2026-03-22T12:04:11.981Z 2026-03-29T12:19:09.085Z
9543403 9543403 20260321034610_ZKPez UK00AA 2026-03-22T12:03:43.684Z 2026-03-29T12:19:07.262Z
9543227 9543227 20260321030720_2HjJL UK00AA 2026-03-22T12:03:04.406Z 2026-03-29T12:19:04.613Z
9542968 9542968 20260321020640_OU8hA UK00AA 2026-03-22T12:02:13.857Z 2026-03-29T12:19:00.863Z
9542943 9542943 20260321015856_F0lZt UK00AA 2026-03-22T12:02:08.653Z 2026-03-29T12:19:00.577Z
9542851 9542851 20260321013612_qENQn UK00AA 2026-03-22T12:01:47.473Z 2026-03-29T12:18:59.069Z
9542840 9542840 20260321013335_6Nw6r UK00AA 2026-03-22T12:01:46.011Z 2026-03-29T12:18:58.982Z
9542795 9542795 20260321012303_YLiya UK00AA 2026-03-22T12:01:39.473Z 2026-03-29T12:18:58.455Z
9542737 9542737 20260321010647_832wc UK00AA 2026-03-22T12:01:27.633Z 2026-03-29T12:18:57.727Z
9542366 9542366 20260319231557_oKZUV UK00AA 2026-03-21T12:29:59.735Z 2026-03-27T12:43:00.165Z
9542238 9542238 20260319230413_f2nIs UK00AA 2026-03-21T12:29:53.443Z 2026-03-27T12:42:50.739Z
9541872 9541872 20260319220046_e6RAs UK00AA 2026-03-21T12:29:27.596Z 2026-03-27T12:42:42.651Z
9534521 9534521 20260320035730_nv1ym UK00AA 2026-03-21T12:08:11.587Z 2026-03-28T12:34:19.021Z
9534475 9534475 20260320035141_GyyDm UK00AA 2026-03-21T12:08:04.978Z 2026-03-28T12:34:18.649Z
9534429 9534429 20260320034927_LPDFD UK00AA 2026-03-21T12:07:59.663Z 2026-03-28T12:34:18.292Z
9534426 9534426 20260320034851_p44kV UK00AA 2026-03-21T12:07:58.980Z 2026-03-28T12:34:18.209Z
9534419 9534419 20260320034845_3tU9b UK00AA 2026-03-21T12:07:58.111Z 2026-03-28T12:34:18.129Z
9533924 9533924 20260320030919_4KlJQ UK00AA 2026-03-21T12:06:39.857Z 2026-03-28T12:34:02.284Z
9533672 9533672 20260320025120_SSQj5 UK00AA 2026-03-21T12:06:00.712Z 2026-03-28T12:33:58.303Z
9533276 9533276 20260320022122_lLuYE UK00AA 2026-03-21T12:05:00.251Z 2026-03-28T12:33:51.350Z
9533120 9533120 20260320020231_rqK2V UK00AA 2026-03-21T12:04:31.167Z 2026-03-28T12:33:49.047Z
9533018 9533018 20260320014624_CeMJO UK00AA 2026-03-21T12:04:13.596Z 2026-03-28T12:33:47.607Z
9532876 9532876 20260320013529_vFzH3 UK00AA 2026-03-21T12:03:52.290Z 2026-03-28T12:33:45.732Z
9532828 9532828 20260320013210_QyoKj UK00AA 2026-03-21T12:03:46.142Z 2026-03-28T12:33:44.764Z
9532798 9532798 20260320012706_1N3DT UK00AA 2026-03-21T12:03:40.013Z 2026-03-28T12:33:44.070Z
9532762 9532762 20260320012328_iFimp UK00AA 2026-03-21T12:03:32.127Z 2026-03-28T12:33:38.876Z
9531868 9531868 20260319235801_3V71s UK00AA 2026-03-21T12:01:04.401Z 2026-03-28T12:33:22.336Z
9531813 9531813 20260319235228_ockYh UK00AA 2026-03-21T12:00:54.896Z 2026-03-28T12:33:21.767Z
9531749 9531749 20260319234348_1acDg UK00AA 2026-03-21T12:00:44.798Z 2026-03-28T12:33:21.115Z
9531410 9531410 20260318230552_59esA UK00AA 2026-03-20T12:25:09.827Z 2026-03-26T12:39:19.226Z
9531380 9531380 20260318230303_I5YUo UK00AA 2026-03-20T12:25:08.917Z 2026-03-26T12:39:19.107Z
9531251 9531251 20260318224921_YbB2r UK00AA 2026-03-20T12:25:03.160Z 2026-03-26T12:39:18.346Z
9531138 9531138 20260318223507_pG3ED UK00AA 2026-03-20T12:24:58.912Z 2026-03-26T12:39:17.682Z
9530985 9530985 20260318221136_GvKlv UK00AA 2026-03-20T12:24:53.654Z 2026-03-26T12:39:16.806Z
9530851 9530851 20260318215321_torbX UK00AA 2026-03-20T12:24:49.564Z 2026-03-26T12:39:16.199Z
9530374 9530374 20260318204410_tO8p6 UK00AA 2026-03-20T12:24:19.978Z 2026-03-26T12:39:11.582Z
9521972 9521972 20260319050159_2pGrf UK00AA 2026-03-20T12:08:47.366Z 2026-03-27T12:41:12.208Z
9521751 9521751 20260319044135_5OE1t UK00AA 2026-03-20T12:08:30.114Z 2026-03-27T12:41:10.474Z
9521721 9521721 20260319043706_nQCo6 UK00AA 2026-03-20T12:08:26.725Z 2026-03-27T12:41:05.168Z
9521451 9521451 20260319041613_qhyKa UK00AA 2026-03-20T12:08:01.423Z 2026-03-27T12:40:54.884Z
9520820 9520820 20260319033922_mGYUy UK00AA 2026-03-20T12:07:00.949Z 2026-03-27T12:40:47.673Z
9520633 9520633 20260319032917_l1QVM UK00AA 2026-03-20T12:06:43.135Z 2026-03-27T12:40:45.692Z

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