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,729 rows where station_code = "UK0089" 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
9608111 9608111 20260403200004_d5yJ0 UK0089 2026-04-05T12:08:44.812Z 2026-04-06T12:19:42.219Z
9598520 9598520 20260330005639_VGsUG UK0089 2026-03-31T12:10:47.966Z 2026-04-06T12:36:44.047Z
9598422 9598422 20260330000527_Kv5c4 UK0089 2026-03-31T12:10:34.668Z 2026-04-06T12:36:31.908Z
9598419 9598419 20260329235706_evp3s UK0089 2026-03-31T12:10:34.285Z 2026-04-06T12:36:31.708Z
9595147 9595147 20260330023454_EXbUB UK0089 2026-03-31T12:00:36.567Z 2026-04-06T12:29:42.621Z
9595066 9595066 20260330021234_ZN6fr UK0089 2026-03-31T12:00:22.556Z 2026-04-06T12:29:38.797Z
9592443 9592443 20260329020859_o9dFQ UK0089 2026-03-30T12:00:59.260Z 2026-04-06T12:34:10.580Z
9592095 9592095 20260328003256_8dQXq UK0089 2026-03-29T12:07:10.199Z 2026-04-05T12:35:35.277Z
9591984 9591984 20260327233857_xZEZV UK0089 2026-03-29T12:07:04.118Z 2026-04-05T12:35:23.257Z
9591930 9591930 20260327231421_dpKI7 UK0089 2026-03-29T12:06:59.956Z 2026-04-05T12:35:21.353Z
9589086 9589086 20260328022531_m3itC UK0089 2026-03-29T12:00:42.409Z 2026-04-06T12:37:01.382Z
9588961 9588961 20260328020019_fCseD UK0089 2026-03-29T12:00:33.637Z 2026-04-06T12:36:57.765Z
9561647 9561647 20260323001912_v749v UK0089 2026-03-24T12:00:49.867Z 2026-03-31T12:25:49.658Z
9561448 9561448 20260321233425_3grRy UK0089 2026-03-23T12:12:19.291Z 2026-03-29T12:21:07.386Z
9560973 9560973 20260321223925_H0Ls7 UK0089 2026-03-23T12:12:08.625Z 2026-03-29T12:21:04.311Z
9560841 9560841 20260321222614_lzjh9 UK0089 2026-03-23T12:12:05.063Z 2026-03-29T12:21:03.292Z
9560385 9560385 20260321210738_7ftQb UK0089 2026-03-23T12:11:44.917Z 2026-03-29T12:20:59.805Z
9559772 9559772 20260321194430_votiG UK0089 2026-03-23T12:11:29.724Z 2026-03-29T12:20:51.684Z
9559767 9559767 20260321194405_qI3aH UK0089 2026-03-23T12:11:29.534Z 2026-03-29T12:20:51.463Z
9559754 9559754 20260321193936_mjK18 UK0089 2026-03-23T12:11:29.104Z 2026-03-29T12:20:50.826Z
9555465 9555465 20260322050025_19KMy UK0089 2026-03-23T12:03:26.751Z 2026-03-30T12:28:26.830Z
9555445 9555445 20260322045624_1jO2C UK0089 2026-03-23T12:03:26.165Z 2026-03-30T12:28:26.623Z
9555376 9555376 20260322044706_WGEn4 UK0089 2026-03-23T12:03:23.132Z 2026-03-30T12:28:25.747Z
9555204 9555204 20260322041929_EZvp2 UK0089 2026-03-23T12:03:15.104Z 2026-03-30T12:28:22.918Z
9554876 9554876 20260322034012_284C6 UK0089 2026-03-23T12:02:54.226Z 2026-03-30T12:28:10.695Z
9554276 9554276 20260322025436_fI5js UK0089 2026-03-23T12:02:24.123Z 2026-03-30T12:28:01.562Z
9553800 9553800 20260322021514_CrcFW UK0089 2026-03-23T12:01:52.653Z 2026-03-30T12:27:52.801Z
9553761 9553761 20260322021227_CDB9I UK0089 2026-03-23T12:01:50.417Z 2026-03-30T12:27:52.158Z
9553730 9553730 20260322020928_2Ch0u UK0089 2026-03-23T12:01:48.567Z 2026-03-30T12:27:51.733Z
9553660 9553660 20260322020524_egWsG UK0089 2026-03-23T12:01:45.246Z 2026-03-30T12:27:50.811Z
9553509 9553509 20260322014650_bkTkH UK0089 2026-03-23T12:01:35.036Z 2026-03-30T12:27:42.382Z
9553443 9553443 20260322014255_g1Jnl UK0089 2026-03-23T12:01:30.462Z 2026-03-30T12:27:41.195Z
9552979 9552979 20260322010055_k1Kr8 UK0089 2026-03-23T12:01:06.650Z 2026-03-30T12:27:33.291Z
9552563 9552563 20260322002048_OOC2V UK0089 2026-03-23T12:00:32.908Z 2026-03-30T12:27:26.128Z
9549132 9549132 20260319234912_zGaBY UK0089 2026-03-22T12:16:49.342Z 2026-03-28T12:33:21.534Z
9549127 9549127 20260319232509_YHOd1 UK0089 2026-03-22T12:16:38.805Z 2026-03-28T12:33:18.467Z
9543739 9543739 20260321050409_hvM02 UK0089 2026-03-22T12:04:36.112Z 2026-03-29T12:19:10.735Z
9543656 9543656 20260321043807_gOAY5 UK0089 2026-03-22T12:04:21.889Z 2026-03-29T12:19:09.832Z
9543536 9543536 20260321041851_caUve UK0089 2026-03-22T12:04:07.135Z 2026-03-29T12:19:08.787Z
9543490 9543490 20260321040442_yWsgU UK0089 2026-03-22T12:03:58.929Z 2026-03-29T12:19:08.297Z
9543454 9543454 20260321035857_5hzu6 UK0089 2026-03-22T12:03:52.745Z 2026-03-29T12:19:07.848Z
9543415 9543415 20260321034830_annKe UK0089 2026-03-22T12:03:45.166Z 2026-03-29T12:19:07.299Z
9543118 9543118 20260321024146_2gkQz UK0089 2026-03-22T12:02:43.472Z 2026-03-29T12:19:03.308Z
9542896 9542896 20260321014710_TorOK UK0089 2026-03-22T12:01:56.603Z 2026-03-29T12:18:59.653Z
9542799 9542799 20260321012321_ELDEj UK0089 2026-03-22T12:01:40.023Z 2026-03-29T12:18:58.491Z
9542340 9542340 20260319231330_DECVW UK0089 2026-03-21T12:29:58.466Z 2026-03-27T12:42:57.486Z
9542227 9542227 20260319230302_rm353 UK0089 2026-03-21T12:29:52.861Z 2026-03-27T12:42:50.419Z
9542028 9542028 20260319223448_D8Cv3 UK0089 2026-03-21T12:29:36.734Z 2026-03-27T12:42:44.395Z
9541752 9541752 20260319213602_RrwxM UK0089 2026-03-21T12:29:19.716Z 2026-03-27T12:42:41.318Z
9541693 9541693 20260319212747_ohBii UK0089 2026-03-21T12:29:16.874Z 2026-03-27T12:42:40.881Z
9534898 9534898 20260320043859_E6ipb UK0089 2026-03-21T12:09:08.470Z 2026-03-28T12:34:23.401Z
9534257 9534257 20260320033853_bnSjm UK0089 2026-03-21T12:07:35.038Z 2026-03-28T12:34:16.733Z
9534020 9534020 20260320031730_WqnKb UK0089 2026-03-21T12:06:55.371Z 2026-03-28T12:34:03.769Z
9533739 9533739 20260320025357_3ecKh UK0089 2026-03-21T12:06:08.881Z 2026-03-28T12:33:59.956Z
9533614 9533614 20260320024603_H79z2 UK0089 2026-03-21T12:05:53.147Z 2026-03-28T12:33:56.969Z
9533486 9533486 20260320023226_yuqcX UK0089 2026-03-21T12:05:30.400Z 2026-03-28T12:33:53.454Z
9533460 9533460 20260320023057_8ME9K UK0089 2026-03-21T12:05:27.622Z 2026-03-28T12:33:53.131Z
9533437 9533437 20260320023052_zWKQQ UK0089 2026-03-21T12:05:26.633Z 2026-03-28T12:33:53.070Z
9533146 9533146 20260320020416_NB2Pq UK0089 2026-03-21T12:04:35.317Z 2026-03-28T12:33:49.218Z
9532653 9532653 20260320011637_h4fSE UK0089 2026-03-21T12:03:20.908Z 2026-03-28T12:33:35.018Z
9532529 9532529 20260320010511_uVJRK UK0089 2026-03-21T12:03:00.741Z 2026-03-28T12:33:33.613Z
9532343 9532343 20260320004809_LuODk UK0089 2026-03-21T12:02:26.495Z 2026-03-28T12:33:28.067Z
9532242 9532242 20260320004028_frwf3 UK0089 2026-03-21T12:02:09.580Z 2026-03-28T12:33:26.129Z
9532195 9532195 20260320003513_dluaI UK0089 2026-03-21T12:02:01.035Z 2026-03-28T12:33:25.757Z
9532137 9532137 20260320002127_KWe9U UK0089 2026-03-21T12:01:47.962Z 2026-03-28T12:33:24.832Z
9531764 9531764 20260319234654_K9ZEF UK0089 2026-03-21T12:00:49.934Z 2026-03-28T12:33:21.352Z
9531640 9531640 20260319233223_F8oTO UK0089 2026-03-21T12:00:25.056Z 2026-03-28T12:33:19.785Z
9531603 9531603 20260319232805_650yr UK0089 2026-03-21T12:00:21.254Z 2026-03-28T12:33:19.153Z
9531579 9531579 20260319232547_XfnGV UK0089 2026-03-21T12:00:17.355Z 2026-03-28T12:33:18.879Z
9531569 9531569 20260319232509_ApZ86 UK0089 2026-03-21T12:00:14.279Z 2026-03-28T12:33:18.486Z
9531075 9531075 20260318222349_rGXuG UK0089 2026-03-20T12:24:56.581Z 2026-03-26T12:39:17.332Z
9530218 9530218 20260318202636_oaSaP UK0089 2026-03-20T12:24:13.185Z 2026-03-26T12:39:10.520Z
9522000 9522000 20260319050832_4sTjD UK0089 2026-03-20T12:08:50.044Z 2026-03-27T12:41:12.564Z
9521946 9521946 20260319045814_vkpcX UK0089 2026-03-20T12:08:45.770Z 2026-03-27T12:41:11.926Z
9521782 9521782 20260319044355_puB7X UK0089 2026-03-20T12:08:31.847Z 2026-03-27T12:41:10.653Z
9520690 9520690 20260319033158_JwEQ1 UK0089 2026-03-20T12:06:48.662Z 2026-03-27T12:40:46.330Z
9520406 9520406 20260319031359_vBXPT UK0089 2026-03-20T12:06:20.289Z 2026-03-27T12:40:42.651Z
9520353 9520353 20260319031202_tRjwR UK0089 2026-03-20T12:06:16.091Z 2026-03-27T12:40:42.263Z
9520254 9520254 20260319030639_asNLI UK0089 2026-03-20T12:06:03.876Z 2026-03-27T12:40:41.040Z
9519959 9519959 20260319024528_6Ogo6 UK0089 2026-03-20T12:05:25.360Z 2026-03-27T12:40:37.258Z
9519923 9519923 20260319024326_ScdVs UK0089 2026-03-20T12:05:23.119Z 2026-03-27T12:40:37.041Z
9519423 9519423 20260319020937_Qn4Gd UK0089 2026-03-20T12:04:27.145Z 2026-03-27T12:40:30.993Z
9518766 9518766 20260319012322_XSHuQ UK0089 2026-03-20T12:03:16.430Z 2026-03-27T12:40:13.495Z
9518674 9518674 20260319011702_W3qkZ UK0089 2026-03-20T12:03:05.478Z 2026-03-27T12:40:12.552Z
9518312 9518312 20260319004820_Ovtl5 UK0089 2026-03-20T12:02:17.265Z 2026-03-27T12:40:08.299Z
9518109 9518109 20260319003027_uW5Zc UK0089 2026-03-20T12:01:53.901Z 2026-03-27T12:40:06.394Z
9517862 9517862 20260319000708_fxWhz UK0089 2026-03-20T12:01:25.729Z 2026-03-27T12:40:04.246Z
9517761 9517761 20260319000054_bmLcu UK0089 2026-03-20T12:01:13.295Z 2026-03-27T12:40:03.069Z
9517587 9517587 20260318234324_TqXEw UK0089 2026-03-20T12:00:46.902Z 2026-03-27T12:40:01.167Z
9517498 9517498 20260318233426_yNtlz UK0089 2026-03-20T12:00:33.461Z 2026-03-27T12:40:00.354Z
9516448 9516448 20260317205427_HVF6C UK0089 2026-03-19T12:26:13.454Z 2026-03-25T12:42:59.243Z
9516320 9516320 20260317203222_Wbszp UK0089 2026-03-19T12:26:01.249Z 2026-03-25T12:42:54.063Z
9516170 9516170 20260317200815_eqvNW UK0089 2026-03-19T12:25:43.748Z 2026-03-25T12:42:50.399Z
9516155 9516155 20260317200740_oClH3 UK0089 2026-03-19T12:25:43.493Z 2026-03-25T12:42:50.327Z
9512220 9512220 20260318045616_1jYdH UK0089 2026-03-19T12:11:57.174Z 2026-03-26T12:37:43.076Z
9512063 9512063 20260318043941_tae0u UK0089 2026-03-19T12:11:38.207Z 2026-03-26T12:37:42.062Z
9511092 9511092 20260318033554_ARjKK UK0089 2026-03-19T12:09:27.373Z 2026-03-26T12:37:20.218Z
9492787 9492787 20260314215528_8AUK5 UK0089 2026-03-16T12:29:03.184Z 2026-03-22T12:42:54.377Z
9477599 9477599 20260314052201_uvUz5 UK0089 2026-03-15T12:08:36.395Z 2026-03-22T12:42:03.902Z
9477522 9477522 20260314050503_oFjNJ UK0089 2026-03-15T12:08:27.711Z 2026-03-22T12:42:03.318Z

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