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

7,779 rows where station_code = "UK00AE" 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
8086736 8086736 20251012002047_fFmB8 UK00AE 2025-10-13T12:09:00.018Z 2025-10-20T13:03:29.203Z
8086584 8086584 20251011235357_0UKnK UK00AE 2025-10-13T12:08:46.211Z 2025-10-20T13:03:27.293Z
8086196 8086196 20251011223035_p2V0h UK00AE 2025-10-13T12:07:50.996Z 2025-10-20T13:03:22.150Z
8085904 8085904 20251011212928_Uz5n2 UK00AE 2025-10-13T12:07:01.514Z 2025-10-20T13:03:18.548Z
8075861 8075861 20251009045453_bOrEJ UK00AE 2025-10-10T12:10:35.564Z 2025-10-17T12:38:00.494Z
8075831 8075831 20251009044815_8Lyji UK00AE 2025-10-10T12:10:32.981Z 2025-10-17T12:38:00.118Z
8074607 8074607 20251009001221_9Ba8y UK00AE 2025-10-10T12:06:51.182Z 2025-10-17T12:37:35.145Z
8074547 8074547 20251009000213_rGxkU UK00AE 2025-10-10T12:06:36.893Z 2025-10-17T12:37:32.304Z
8074366 8074366 20251008232734_DbXjo UK00AE 2025-10-10T12:06:18.453Z 2025-10-17T12:37:26.751Z
8067390 8067390 20251005050020_li33m UK00AE 2025-10-07T12:34:10.674Z 2025-10-13T12:34:11.866Z
8067145 8067145 20251005043334_3KEd7 UK00AE 2025-10-07T12:34:01.427Z 2025-10-13T12:34:09.553Z
8067031 8067031 20251005042443_DdRkF UK00AE 2025-10-07T12:33:46.166Z 2025-10-13T12:34:06.404Z
8066997 8066997 20251005042107_ZP1WD UK00AE 2025-10-07T12:33:36.502Z 2025-10-13T12:34:05.153Z
8066781 8066781 20251005040634_Id3Vt UK00AE 2025-10-07T12:33:12.608Z 2025-10-13T12:34:00.270Z
8066711 8066711 20251005040153_82jOK UK00AE 2025-10-07T12:33:11.086Z 2025-10-13T12:33:59.973Z
8066269 8066269 20251005031906_gto6l UK00AE 2025-10-07T12:32:48.546Z 2025-10-13T12:33:56.937Z
8065974 8065974 20251005025121_DrIYg UK00AE 2025-10-07T12:32:07.640Z 2025-10-13T12:33:54.087Z
8065217 8065217 20251005003331_4W3lK UK00AE 2025-10-07T12:30:24.207Z 2025-10-13T12:33:46.720Z
8065051 8065051 20251004235629_NNIaB UK00AE 2025-10-07T12:30:12.943Z 2025-10-13T12:33:45.361Z
8065021 8065021 20251004234839_Iz0Ta UK00AE 2025-10-07T12:30:11.335Z 2025-10-13T12:33:45.077Z
8060946 8060946 20251005233919_GtgC6 UK00AE 2025-10-07T12:11:29.159Z 2025-10-14T12:34:16.311Z
8060432 8060432 20251005201611_3xKki UK00AE 2025-10-07T12:09:39.476Z 2025-10-14T12:33:34.930Z
8060369 8060369 20251005195611_H3eob UK00AE 2025-10-07T12:09:30.630Z 2025-10-14T12:33:34.454Z
8060315 8060315 20251005192933_NglBm UK00AE 2025-10-07T12:09:12.670Z 2025-10-14T12:33:33.769Z
8060252 8060252 20251005191938_CzeMW UK00AE 2025-10-07T12:09:02.648Z 2025-10-14T12:33:33.048Z
8056826 8056826 20251004045803_l45fZ UK00AE 2025-10-05T12:17:45.477Z 2025-10-12T12:33:06.651Z
8056643 8056643 20251004042309_vvDD2 UK00AE 2025-10-05T12:17:23.088Z 2025-10-12T12:32:59.088Z
8056430 8056430 20251004034905_H8wIp UK00AE 2025-10-05T12:16:55.505Z 2025-10-12T12:32:48.156Z
8038773 8038773 20251001215953_dsIDR UK00AE 2025-10-03T12:31:21.254Z 2025-10-10T12:39:52.850Z
8038211 8038211 20251001201337_fQqv7 UK00AE 2025-10-03T12:29:18.840Z 2025-10-10T12:39:43.636Z
8027350 8027350 20250930222341_3fp0h UK00AE 2025-10-02T12:23:34.299Z 2025-10-09T12:38:14.785Z
8027124 8027124 20250930215536_b4Tjn UK00AE 2025-10-02T12:22:44.107Z 2025-10-09T12:38:10.744Z
8027027 8027027 20250930214544_2cMnj UK00AE 2025-10-02T12:22:30.274Z 2025-10-09T12:38:09.143Z
8027017 8027017 20250930214544_PWyvB UK00AE 2025-10-02T12:22:30.057Z 2025-10-09T12:38:09.109Z
8026655 8026655 20250930210659_Rxv62 UK00AE 2025-10-02T12:21:23.341Z 2025-10-09T12:37:55.321Z
8026478 8026478 20250930204217_xHOGy UK00AE 2025-10-02T12:20:48.203Z 2025-10-09T12:37:48.954Z
8026381 8026381 20250930202900_AyDQK UK00AE 2025-10-02T12:20:24.657Z 2025-10-09T12:37:47.510Z
8026059 8026059 20250930194645_RJFsN UK00AE 2025-10-02T12:19:19.528Z 2025-10-09T12:37:19.504Z
8025826 8025826 20250930191037_enlMI UK00AE 2025-10-02T12:18:33.765Z 2025-10-09T12:37:05.012Z
8025808 8025808 20250930190817_Mq8ih UK00AE 2025-10-02T12:18:32.072Z 2025-10-09T12:37:04.796Z
8020772 8020772 20250930041443_hFRxz UK00AE 2025-10-01T12:47:41.837Z 2025-10-08T12:44:01.040Z
8020749 8020749 20250930041205_XD6VT UK00AE 2025-10-01T12:47:37.872Z 2025-10-08T12:44:00.836Z
8020706 8020706 20250930040444_7W6Hr UK00AE 2025-10-01T12:47:31.553Z 2025-10-08T12:43:59.685Z
8020589 8020589 20250930035337_nk4T5 UK00AE 2025-10-01T12:47:09.746Z 2025-10-08T12:43:58.111Z
8020455 8020455 20250930033947_2vahh UK00AE 2025-10-01T12:46:48.909Z 2025-10-08T12:43:52.228Z
8020401 8020401 20250930033510_er6hI UK00AE 2025-10-01T12:46:45.561Z 2025-10-08T12:43:51.030Z
8020232 8020232 20250930031922_NnCM2 UK00AE 2025-10-01T12:46:35.694Z 2025-10-08T12:43:46.225Z
8020139 8020139 20250930031407_wgP18 UK00AE 2025-10-01T12:46:32.952Z 2025-10-08T12:43:45.075Z
8019554 8019554 20250930021409_MUCaX UK00AE 2025-10-01T12:45:14.519Z 2025-10-08T12:43:26.833Z
8018831 8018831 20250930005303_GvYfT UK00AE 2025-10-01T12:43:30.797Z 2025-10-08T12:43:08.709Z
8018616 8018616 20250930003000_58o2q UK00AE 2025-10-01T12:43:02.075Z 2025-10-08T12:43:00.809Z
8018435 8018435 20250930001016_33XMn UK00AE 2025-10-01T12:42:27.580Z 2025-10-08T12:42:55.484Z
8017326 8017326 20250929232735_53mOq UK00AE 2025-10-01T12:25:41.128Z 2025-10-08T12:42:47.723Z
8017118 8017118 20250929230756_yHq4o UK00AE 2025-10-01T12:25:13.135Z 2025-10-08T12:42:44.606Z
8016856 8016856 20250929224708_EV3TK UK00AE 2025-10-01T12:24:47.587Z 2025-10-08T12:42:38.125Z
8016754 8016754 20250929223820_e2fJU UK00AE 2025-10-01T12:24:27.239Z 2025-10-08T12:42:36.504Z
8016636 8016636 20250929222218_ofsHB UK00AE 2025-10-01T12:24:14.413Z 2025-10-08T12:42:34.214Z
8016351 8016351 20250929214124_trE2D UK00AE 2025-10-01T12:23:20.405Z 2025-10-08T12:42:23.794Z
8016196 8016196 20250929210835_c7mZa UK00AE 2025-10-01T12:22:51.139Z 2025-10-08T12:42:20.328Z
8010067 8010067 20250929033947_9Rzre UK00AE 2025-09-30T12:32:27.077Z 2025-10-07T13:01:22.038Z
8009061 8009061 20250929030404_LyBva UK00AE 2025-09-30T12:30:51.000Z 2025-10-07T13:01:16.432Z
8008478 8008478 20250929024309_5JG2F UK00AE 2025-09-30T12:29:52.173Z 2025-10-07T13:01:13.533Z
8008268 8008268 20250929023205_SVNXO UK00AE 2025-09-30T12:29:39.366Z 2025-10-07T13:01:11.442Z
8008142 8008142 20250929022749_64E8Q UK00AE 2025-09-30T12:29:34.134Z 2025-10-07T13:01:10.319Z
8007684 8007684 20250929021308_9tJJy UK00AE 2025-09-30T12:28:49.227Z 2025-10-07T13:01:07.709Z
8006765 8006765 20250929013908_oYGBj UK00AE 2025-09-30T12:27:16.546Z 2025-10-07T13:01:01.140Z
8006728 8006728 20250929013832_AuTV7 UK00AE 2025-09-30T12:27:14.913Z 2025-10-07T13:01:00.931Z
8006689 8006689 20250929013738_IsKIy UK00AE 2025-09-30T12:27:12.840Z 2025-10-07T13:01:00.845Z
8006648 8006648 20250929013707_0H3jD UK00AE 2025-09-30T12:27:09.479Z 2025-10-07T13:01:00.341Z
8006600 8006600 20250929013614_0NR4Z UK00AE 2025-09-30T12:27:07.008Z 2025-10-07T13:01:00.188Z
8006389 8006389 20250929012338_JSLbg UK00AE 2025-09-30T12:26:51.336Z 2025-10-07T13:00:59.156Z
8006271 8006271 20250929011948_RAwog UK00AE 2025-09-30T12:26:29.517Z 2025-10-07T13:00:58.717Z
8006066 8006066 20250929010954_g2tZt UK00AE 2025-09-30T12:26:12.501Z 2025-10-07T13:00:57.812Z
8005686 8005686 20250929005217_X8xz3 UK00AE 2025-09-30T12:25:27.055Z 2025-10-07T13:00:56.437Z
8005593 8005593 20250929004821_SWavV UK00AE 2025-09-30T12:25:20.342Z 2025-10-07T13:00:55.918Z
8005394 8005394 20250929003633_dTZYT UK00AE 2025-09-30T12:24:46.222Z 2025-10-07T13:00:54.132Z
8005231 8005231 20250929002802_YRq3W UK00AE 2025-09-30T12:24:16.397Z 2025-10-07T13:00:52.384Z
8005158 8005158 20250929002506_kQ6FA UK00AE 2025-09-30T12:24:10.516Z 2025-10-07T13:00:52.110Z
8004395 8004395 20250928234956_qO0S2 UK00AE 2025-09-30T12:22:34.840Z 2025-10-07T13:00:46.980Z
8003782 8003782 20250928231303_h5bqA UK00AE 2025-09-30T12:21:09.074Z 2025-10-07T13:00:42.562Z
8003772 8003772 20250928231237_dEqJc UK00AE 2025-09-30T12:21:07.961Z 2025-10-07T13:00:42.363Z
8003572 8003572 20250928230137_ajc2S UK00AE 2025-09-30T12:20:42.740Z 2025-10-07T13:00:41.074Z
8003530 8003530 20250928225739_zcqwu UK00AE 2025-09-30T12:20:36.470Z 2025-10-07T13:00:40.973Z
8003421 8003421 20250928225123_zsheJ UK00AE 2025-09-30T12:20:26.577Z 2025-10-07T13:00:40.150Z
8003249 8003249 20250928224439_SqZui UK00AE 2025-09-30T12:19:59.027Z 2025-10-07T13:00:38.529Z
8003063 8003063 20250928223939_mwMiL UK00AE 2025-09-30T12:19:42.218Z 2025-10-07T13:00:37.942Z
8002275 8002275 20250928213257_Y1oPa UK00AE 2025-09-30T12:17:35.798Z 2025-10-07T13:00:30.706Z
8002259 8002259 20250928213211_57aNk UK00AE 2025-09-30T12:17:27.948Z 2025-10-07T13:00:30.468Z
8001242 8001242 20250928201416_p3mYe UK00AE 2025-09-30T12:14:52.107Z 2025-10-07T13:00:16.422Z
8001223 8001223 20250928201333_HShw6 UK00AE 2025-09-30T12:14:49.990Z 2025-10-07T13:00:16.344Z
8000923 8000923 20250928194601_ZQkAt UK00AE 2025-09-30T12:13:55.489Z 2025-10-07T13:00:12.196Z
8000880 8000880 20250928194048_ZytPI UK00AE 2025-09-30T12:13:46.253Z 2025-10-07T13:00:11.264Z
8000741 8000741 20250928192443_TUeEW UK00AE 2025-09-30T12:13:22.646Z 2025-10-07T13:00:07.970Z
8000638 8000638 20250928191435_Va5zX UK00AE 2025-09-30T12:13:08.922Z 2025-10-07T13:00:05.225Z
7993900 7993900 20250927213124_PCytL UK00AE 2025-09-29T12:19:47.668Z 2025-10-05T13:06:45.872Z
7993832 7993832 20250927212052_ZzNbS UK00AE 2025-09-29T12:19:29.000Z 2025-10-05T13:06:43.685Z
7993624 7993624 20250927205220_dHbYV UK00AE 2025-09-29T12:18:52.914Z 2025-10-05T13:06:33.200Z
7993455 7993455 20250927202613_4qJS1 UK00AE 2025-09-29T12:18:27.310Z 2025-10-05T13:06:27.779Z
7993226 7993226 20250927193239_CKBVj UK00AE 2025-09-29T12:17:38.678Z 2025-10-05T13:06:20.032Z
7993168 7993168 20250927192543_9K47r UK00AE 2025-09-29T12:17:28.956Z 2025-10-05T13:06:17.340Z

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