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

6,444 rows where station_code = "UK0081" 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
8682405 8682405 20251203052549_vroNo UK0081 2025-12-04T14:17:06.416Z 2025-12-05T14:22:35.527Z
8682402 8682402 20251203052456_dRBy2 UK0081 2025-12-04T14:17:06.167Z 2025-12-05T14:22:35.438Z
8682388 8682388 20251203052443_iyeNg UK0081 2025-12-04T14:17:05.036Z 2025-12-05T14:22:34.709Z
8658157 8658157 20251130065613_ZtvOC UK0081 2025-12-01T14:35:01.964Z 2025-12-05T14:46:04.934Z
8658149 8658149 20251130065248_zDLYs UK0081 2025-12-01T14:34:59.311Z 2025-12-05T14:46:04.218Z
8658146 8658146 20251130065245_GngyR UK0081 2025-12-01T14:34:58.488Z 2025-12-05T14:46:04.091Z
8658109 8658109 20251130064115_2fJyQ UK0081 2025-12-01T14:34:55.229Z 2025-12-05T14:46:02.703Z
8658048 8658048 20251130063228_zBnQA UK0081 2025-12-01T14:34:52.742Z 2025-12-05T14:46:01.507Z
8658022 8658022 20251130062936_YEDRV UK0081 2025-12-01T14:34:50.707Z 2025-12-05T14:46:00.737Z
8657861 8657861 20251130061329_shETK UK0081 2025-12-01T14:34:44.128Z 2025-12-05T14:45:46.443Z
8657472 8657472 20251130054756_sk7Xg UK0081 2025-12-01T14:34:29.662Z 2025-12-05T14:45:32.191Z
8657125 8657125 20251130053138_6AU3y UK0081 2025-12-01T14:33:55.436Z 2025-12-05T14:45:25.785Z
8656017 8656017 20251130043027_2K0eq UK0081 2025-12-01T14:27:56.600Z 2025-12-05T14:44:43.260Z
8655745 8655745 20251130041451_Z39zq UK0081 2025-12-01T14:27:25.163Z 2025-12-05T14:44:38.000Z
8655722 8655722 20251130041342_6GEWW UK0081 2025-12-01T14:27:23.026Z 2025-12-05T14:44:37.555Z
8655335 8655335 20251130035459_f3lsz UK0081 2025-12-01T14:26:47.261Z 2025-12-05T14:44:32.130Z
8655191 8655191 20251130034819_cizwL UK0081 2025-12-01T14:26:37.843Z 2025-12-05T14:44:29.545Z
8654814 8654814 20251130033345_qHWk8 UK0081 2025-12-01T14:26:03.766Z 2025-12-05T14:44:24.414Z
8654786 8654786 20251130033304_jQmkc UK0081 2025-12-01T14:26:01.643Z 2025-12-05T14:44:23.789Z
8654506 8654506 20251130031900_wQYMp UK0081 2025-12-01T14:25:31.444Z 2025-12-05T14:44:07.590Z
8654306 8654306 20251130030933_cyPCc UK0081 2025-12-01T14:25:07.920Z 2025-12-05T14:43:53.382Z
8653969 8653969 20251130024959_HFrOs UK0081 2025-12-01T14:24:33.754Z 2025-12-05T14:43:43.756Z
8653836 8653836 20251130024425_0VIaC UK0081 2025-12-01T14:24:21.539Z 2025-12-05T14:43:41.089Z
8653804 8653804 20251130024139_BqKWy UK0081 2025-12-01T14:24:16.643Z 2025-12-05T14:43:40.135Z
8653380 8653380 20251130021323_P0Dsb UK0081 2025-12-01T14:23:19.428Z 2025-12-05T14:43:30.301Z
8653240 8653240 20251130020404_h39aJ UK0081 2025-12-01T14:23:07.041Z 2025-12-05T14:43:06.193Z
8652259 8652259 20251130005944_Fu3k1 UK0081 2025-12-01T14:21:03.916Z 2025-12-05T14:42:40.772Z
8652180 8652180 20251130005320_zuTBQ UK0081 2025-12-01T14:20:52.508Z 2025-12-05T14:42:29.164Z
8651886 8651886 20251130003040_GxNBD UK0081 2025-12-01T14:20:11.645Z 2025-12-05T14:42:10.489Z
8651629 8651629 20251130000355_yWN1C UK0081 2025-12-01T14:19:35.347Z 2025-12-05T14:42:02.317Z
8651360 8651360 20251129233218_ZY2qT UK0081 2025-12-01T14:18:52.052Z 2025-12-05T14:41:56.117Z
8651211 8651211 20251129230612_mt3zJ UK0081 2025-12-01T14:18:24.398Z 2025-12-05T14:41:52.050Z
8651138 8651138 20251129224747_fthtI UK0081 2025-12-01T14:18:05.261Z 2025-12-05T14:41:49.955Z
8650585 8650585 20251129204410_VqFJl UK0081 2025-12-01T14:16:32.814Z 2025-12-05T14:41:11.412Z
8649390 8649390 20251129171911_XE8Pp UK0081 2025-12-01T14:12:23.224Z 2025-12-05T14:40:06.730Z
8649346 8649346 20251129171302_KPyVT UK0081 2025-12-01T14:12:08.778Z 2025-12-05T14:40:05.383Z
8648079 8648079 20251129063608_QrpeP UK0081 2025-11-30T14:29:33.893Z 2025-12-05T14:52:56.669Z
8648031 8648031 20251129062705_COmxZ UK0081 2025-11-30T14:29:29.947Z 2025-12-05T14:52:55.588Z
8648026 8648026 20251129062616_3dvLJ UK0081 2025-11-30T14:29:29.637Z 2025-12-05T14:52:55.520Z
8647997 8647997 20251129061809_ztFBL UK0081 2025-11-30T14:29:28.139Z 2025-12-05T14:52:54.779Z
8647992 8647992 20251129061657_pnk3k UK0081 2025-11-30T14:29:27.749Z 2025-12-05T14:52:53.316Z
8647827 8647827 20251129053945_9FOeT UK0081 2025-11-30T14:29:07.211Z 2025-12-05T14:52:48.521Z
8647815 8647815 20251129053713_9u0Dq UK0081 2025-11-30T14:29:01.354Z 2025-12-05T14:52:48.310Z
8647772 8647772 20251129052623_S0Li2 UK0081 2025-11-30T14:28:52.920Z 2025-12-05T14:52:47.239Z
8647763 8647763 20251129052122_y3GcL UK0081 2025-11-30T14:28:52.255Z 2025-12-05T14:52:47.099Z
8647745 8647745 20251129051829_Y8n2C UK0081 2025-11-30T14:28:50.465Z 2025-12-05T14:52:46.674Z
8647701 8647701 20251129051017_3BEgu UK0081 2025-11-30T14:28:45.861Z 2025-12-05T14:52:45.842Z
8647621 8647621 20251129045838_Q8Okj UK0081 2025-11-30T14:28:39.800Z 2025-12-05T14:52:44.188Z
8647583 8647583 20251129045306_rQGmM UK0081 2025-11-30T14:28:37.020Z 2025-12-05T14:52:43.389Z
8647567 8647567 20251129045200_HGa8P UK0081 2025-11-30T14:28:36.033Z 2025-12-05T14:52:43.057Z
8647505 8647505 20251129044553_Je9j6 UK0081 2025-11-30T14:28:30.981Z 2025-12-05T14:52:41.542Z
8647451 8647451 20251129043758_Pe9oD UK0081 2025-11-30T14:28:26.761Z 2025-12-05T14:52:40.621Z
8647403 8647403 20251129043154_KkaXI UK0081 2025-11-30T14:28:06.500Z 2025-12-05T14:52:39.267Z
8647377 8647377 20251129042846_sEz0i UK0081 2025-11-30T14:28:04.246Z 2025-12-05T14:52:38.771Z
8647341 8647341 20251129042415_PiPgi UK0081 2025-11-30T14:28:00.767Z 2025-12-05T14:52:37.852Z
8646982 8646982 20251129032223_sw53w UK0081 2025-11-30T14:27:13.497Z 2025-12-05T14:52:10.998Z
8646967 8646967 20251129032106_mmPgT UK0081 2025-11-30T14:27:11.974Z 2025-12-05T14:52:08.185Z
8646921 8646921 20251129031215_sOE6y UK0081 2025-11-30T14:27:08.131Z 2025-12-05T14:51:59.993Z
8646420 8646420 20251129020405_mt5Cd UK0081 2025-11-30T14:25:58.130Z 2025-12-05T14:51:41.638Z
8625372 8625372 20251125204533_yXQIo UK0081 2025-11-28T14:31:47.382Z 2025-12-04T15:07:01.405Z
8613203 8613203 20251126030929_gjsUM UK0081 2025-11-27T14:25:30.623Z 2025-12-04T15:09:38.537Z
8610629 8610629 20251126010014_6PkIK UK0081 2025-11-27T14:20:27.847Z 2025-12-04T15:08:21.433Z
8610482 8610482 20251126004817_2ex1I UK0081 2025-11-27T14:20:13.171Z 2025-12-04T15:08:06.332Z
8609179 8609179 20251125231951_ssOJ7 UK0081 2025-11-27T14:17:44.030Z 2025-12-04T15:07:52.415Z
8608796 8608796 20251125224549_sRZa2 UK0081 2025-11-27T14:16:51.998Z 2025-12-04T15:07:48.704Z
8608657 8608657 20251125223440_OWYW2 UK0081 2025-11-27T14:16:29.166Z 2025-12-04T15:07:47.620Z
8608053 8608053 20251125214608_3zHw0 UK0081 2025-11-27T14:15:09.130Z 2025-12-04T15:07:40.507Z
8607365 8607365 20251125204533_33nMf UK0081 2025-11-27T14:13:29.061Z 2025-12-04T15:07:01.301Z
8607274 8607274 20251125203511_5ZKn2 UK0081 2025-11-27T14:13:03.921Z 2025-12-04T15:06:59.609Z
8607191 8607191 20251125202616_SNKPC UK0081 2025-11-27T14:12:42.929Z 2025-12-04T15:06:56.312Z
8607178 8607178 20251125202428_qSKVu UK0081 2025-11-27T14:12:39.410Z 2025-12-04T15:06:56.058Z
8606877 8606877 20251125195034_ZN7p7 UK0081 2025-11-27T14:11:41.268Z 2025-12-04T15:06:51.675Z
8606434 8606434 20251125185534_s8J5a UK0081 2025-11-27T14:10:16.181Z 2025-12-04T15:06:45.487Z
8605880 8605880 20251125172723_9i1HC UK0081 2025-11-27T14:08:08.541Z 2025-12-04T15:05:47.964Z
8603806 8603806 20251125064417_p2TR7 UK0081 2025-11-26T14:28:14.176Z 2025-12-02T15:09:37.591Z
8603771 8603771 20251125063939_wEMXE UK0081 2025-11-26T14:27:53.549Z 2025-12-02T15:09:37.337Z
8603368 8603368 20251125060140_Zj6be UK0081 2025-11-26T14:27:23.438Z 2025-12-02T15:09:35.508Z
8603321 8603321 20251125055622_ZKwZu UK0081 2025-11-26T14:27:20.804Z 2025-12-02T15:09:35.322Z
8603172 8603172 20251125054730_n7NdH UK0081 2025-11-26T14:27:11.503Z 2025-12-02T15:09:34.668Z
8602864 8602864 20251125052902_ZXFVE UK0081 2025-11-26T14:26:25.085Z 2025-12-02T15:09:33.261Z
8602765 8602765 20251125052053_nsUrV UK0081 2025-11-26T14:26:19.258Z 2025-12-02T15:09:32.758Z
8602714 8602714 20251125051854_dOpHp UK0081 2025-11-26T14:26:16.723Z 2025-12-02T15:09:32.386Z
8602703 8602703 20251125051718_1URRm UK0081 2025-11-26T14:26:16.011Z 2025-12-02T15:09:32.262Z
8602622 8602622 20251125050920_HjncH UK0081 2025-11-26T14:26:11.407Z 2025-12-02T15:09:31.812Z
8602431 8602431 20251125045547_IeT04 UK0081 2025-11-26T14:25:45.814Z 2025-12-02T15:09:30.897Z
8602354 8602354 20251125044944_JuTzu UK0081 2025-11-26T14:25:34.955Z 2025-12-02T15:09:30.596Z
8602208 8602208 20251125044135_73QBD UK0081 2025-11-26T14:25:26.331Z 2025-12-02T15:09:29.979Z
8601767 8601767 20251125041338_M52oG UK0081 2025-11-26T14:24:41.396Z 2025-12-02T15:09:24.180Z
8601613 8601613 20251125040350_3GD14 UK0081 2025-11-26T14:24:31.590Z 2025-12-02T15:09:16.724Z
8601203 8601203 20251125033813_SbQpG UK0081 2025-11-26T14:23:47.594Z 2025-12-02T15:09:05.584Z
8601087 8601087 20251125033303_sXjXr UK0081 2025-11-26T14:23:39.978Z 2025-12-02T15:08:56.890Z
8600787 8600787 20251125031719_tVsgw UK0081 2025-11-26T14:22:58.315Z 2025-12-02T15:08:50.708Z
8600379 8600379 20251125025620_bi3kU UK0081 2025-11-26T14:22:24.635Z 2025-12-02T15:08:41.719Z
8599941 8599941 20251125023158_XVtBG UK0081 2025-11-26T14:21:49.788Z 2025-12-02T15:08:32.877Z
8599926 8599926 20251125023028_s0jjW UK0081 2025-11-26T14:21:40.431Z 2025-12-02T15:08:32.734Z
8599920 8599920 20251125023005_eRihS UK0081 2025-11-26T14:21:36.660Z 2025-12-02T15:08:32.700Z
8599715 8599715 20251125022046_pV3RP UK0081 2025-11-26T14:21:26.058Z 2025-12-02T15:08:31.696Z
8599668 8599668 20251125021646_q1Vqj UK0081 2025-11-26T14:21:23.052Z 2025-12-02T15:08:30.848Z
8599369 8599369 20251125020245_Jm397 UK0081 2025-11-26T14:20:50.014Z 2025-12-02T15:08:23.633Z
8598960 8598960 20251125013742_62ad2 UK0081 2025-11-26T14:20:07.039Z 2025-12-02T15:08:15.083Z

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