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,341 rows where station_code = "UK0057" 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
8683186 8683186 20251203063833_m7KQH UK0057 2025-12-04T14:18:53.700Z 2025-12-06T14:29:44.703Z
8682977 8682977 20251203061806_9MYXY UK0057 2025-12-04T14:18:25.488Z 2025-12-06T14:29:34.667Z
8682928 8682928 20251203061622_hJe4J UK0057 2025-12-04T14:18:21.750Z 2025-12-06T14:29:32.304Z
8682886 8682886 20251203061351_awJqU UK0057 2025-12-04T14:18:11.957Z 2025-12-06T14:29:30.596Z
8682856 8682856 20251203061007_YAH2o UK0057 2025-12-04T14:18:08.649Z 2025-12-06T14:29:27.712Z
8682671 8682671 20251203055817_5FKuV UK0057 2025-12-04T14:17:53.449Z 2025-12-06T14:29:22.490Z
8682440 8682440 20251203053348_PNejy UK0057 2025-12-04T14:17:12.164Z 2025-12-06T14:29:02.925Z
8682404 8682404 20251203052549_vroNo UK0057 2025-12-04T14:17:06.416Z 2025-12-06T14:28:59.999Z
8682401 8682401 20251203052455_DZQmI UK0057 2025-12-04T14:17:05.900Z 2025-12-06T14:28:58.734Z
8682208 8682208 20251203050235_wT50f UK0057 2025-12-04T14:16:37.637Z 2025-12-06T14:28:50.121Z
8682093 8682093 20251203044805_WJ8Np UK0057 2025-12-04T14:16:25.332Z 2025-12-06T14:28:46.076Z
8681888 8681888 20251203042208_z1Rkh UK0057 2025-12-04T14:15:56.215Z 2025-12-06T14:28:38.778Z
8681845 8681845 20251203041543_9a2Rw UK0057 2025-12-04T14:15:47.202Z 2025-12-06T14:28:33.866Z
8681683 8681683 20251203034749_AzSvB UK0057 2025-12-04T14:15:15.064Z 2025-12-06T14:28:25.114Z
8681682 8681682 20251203034749_IBmGJ UK0057 2025-12-04T14:15:14.675Z 2025-12-06T14:28:24.778Z
8681672 8681672 20251203034341_y3kf1 UK0057 2025-12-04T14:15:13.531Z 2025-12-06T14:28:24.038Z
8681656 8681656 20251203034245_WhKO1 UK0057 2025-12-04T14:15:12.566Z 2025-12-06T14:28:23.188Z
8681561 8681561 20251203032543_ip5VE UK0057 2025-12-04T14:15:03.542Z 2025-12-06T14:28:18.506Z
8681327 8681327 20251203025718_jZXwD UK0057 2025-12-04T14:14:30.626Z 2025-12-06T14:28:03.575Z
8681282 8681282 20251203025306_yWXUL UK0057 2025-12-04T14:14:15.504Z 2025-12-06T14:27:59.243Z
8681246 8681246 20251203024945_39ABv UK0057 2025-12-04T14:14:08.045Z 2025-12-06T14:27:57.801Z
8681105 8681105 20251203022454_DUsoy UK0057 2025-12-04T14:13:51.893Z 2025-12-06T14:27:49.636Z
8681089 8681089 20251203022125_5T8qG UK0057 2025-12-04T14:13:49.113Z 2025-12-06T14:27:48.858Z
8680974 8680974 20251203020638_5oLDO UK0057 2025-12-04T14:13:29.253Z 2025-12-06T14:27:36.139Z
8680874 8680874 20251203013923_7feFP UK0057 2025-12-04T14:13:10.019Z 2025-12-06T14:27:31.575Z
8680870 8680870 20251203013743_agxaA UK0057 2025-12-04T14:13:09.186Z 2025-12-06T14:27:31.313Z
8680847 8680847 20251203013007_uJ1Mj UK0057 2025-12-04T14:13:04.516Z 2025-12-06T14:27:29.120Z
8680744 8680744 20251203011142_5sg0L UK0057 2025-12-04T14:12:50.275Z 2025-12-06T14:27:24.203Z
8680655 8680655 20251203005642_fYRdO UK0057 2025-12-04T14:12:35.626Z 2025-12-06T14:27:21.307Z
8680582 8680582 20251203004304_qFvGx UK0057 2025-12-04T14:12:24.750Z 2025-12-06T14:27:18.570Z
8680469 8680469 20251203000813_UqBBH UK0057 2025-12-04T14:12:05.819Z 2025-12-06T14:27:13.098Z
8680247 8680247 20251202224544_vkf3r UK0057 2025-12-04T14:11:29.301Z 2025-12-06T14:26:59.034Z
8680224 8680224 20251202223745_zVe9O UK0057 2025-12-04T14:11:26.667Z 2025-12-06T14:26:56.975Z
8678803 8678803 20251202173508_D92Xa UK0057 2025-12-04T14:08:14.052Z 2025-12-06T14:25:28.652Z
8677189 8677189 20251203070316_woNPx UK0057 2025-12-04T14:00:18.289Z 2025-12-06T14:18:10.304Z
8677167 8677167 20251203065628_1dAvY UK0057 2025-12-04T14:00:12.764Z 2025-12-06T14:18:04.594Z
8662062 8662062 20251130174945_XGjGp UK0057 2025-12-02T14:14:11.974Z 2025-12-06T14:38:49.001Z
8658531 8658531 20251126033120_3zABb UK0057 2025-12-01T15:04:28.581Z 2025-12-04T15:09:51.148Z
8658156 8658156 20251130065613_ZtvOC UK0057 2025-12-01T14:35:01.964Z 2025-12-06T14:50:28.608Z
8658107 8658107 20251130064115_2fJyQ UK0057 2025-12-01T14:34:55.229Z 2025-12-06T14:50:26.711Z
8658046 8658046 20251130063228_zBnQA UK0057 2025-12-01T14:34:52.742Z 2025-12-06T14:50:25.923Z
8658021 8658021 20251130062936_YEDRV UK0057 2025-12-01T14:34:50.707Z 2025-12-06T14:50:25.329Z
8657471 8657471 20251130054756_sk7Xg UK0057 2025-12-01T14:34:29.662Z 2025-12-06T14:50:03.627Z
8657388 8657388 20251130054116_3rEpI UK0057 2025-12-01T14:34:19.397Z 2025-12-06T14:49:55.596Z
8657124 8657124 20251130053138_6AU3y UK0057 2025-12-01T14:33:55.436Z 2025-12-06T14:49:44.988Z
8656482 8656482 20251130045659_20YM5 UK0057 2025-12-01T14:28:40.523Z 2025-12-06T14:49:35.128Z
8656078 8656078 20251130043542_PWjpb UK0057 2025-12-01T14:28:01.800Z 2025-12-06T14:49:30.466Z
8656049 8656049 20251130043210_JsyCE UK0057 2025-12-01T14:27:58.985Z 2025-12-06T14:49:30.105Z
8656016 8656016 20251130043027_2K0eq UK0057 2025-12-01T14:27:56.599Z 2025-12-06T14:49:29.749Z
8655744 8655744 20251130041451_Z39zq UK0057 2025-12-01T14:27:25.163Z 2025-12-06T14:49:27.091Z
8655334 8655334 20251130035459_f3lsz UK0057 2025-12-01T14:26:47.261Z 2025-12-06T14:49:08.256Z
8655190 8655190 20251130034819_cizwL UK0057 2025-12-01T14:26:37.842Z 2025-12-06T14:48:53.193Z
8654813 8654813 20251130033345_qHWk8 UK0057 2025-12-01T14:26:03.766Z 2025-12-06T14:48:48.744Z
8654785 8654785 20251130033304_jQmkc UK0057 2025-12-01T14:26:01.643Z 2025-12-06T14:48:48.403Z
8654505 8654505 20251130031900_wQYMp UK0057 2025-12-01T14:25:31.444Z 2025-12-06T14:48:43.420Z
8654305 8654305 20251130030933_cyPCc UK0057 2025-12-01T14:25:07.920Z 2025-12-06T14:48:40.466Z
8654015 8654015 20251130025159_Lgilc UK0057 2025-12-01T14:24:44.628Z 2025-12-06T14:48:35.969Z
8653968 8653968 20251130024959_HFrOs UK0057 2025-12-01T14:24:33.754Z 2025-12-06T14:48:35.266Z
8653845 8653845 20251130024432_i7wT7 UK0057 2025-12-01T14:24:22.619Z 2025-12-06T14:48:33.547Z
8653835 8653835 20251130024425_0VIaC UK0057 2025-12-01T14:24:21.539Z 2025-12-06T14:48:33.363Z
8653802 8653802 20251130024139_BqKWy UK0057 2025-12-01T14:24:16.643Z 2025-12-06T14:48:32.417Z
8653706 8653706 20251130023717_prTPi UK0057 2025-12-01T14:23:58.446Z 2025-12-06T14:48:30.178Z
8653594 8653594 20251130022848_1X24L UK0057 2025-12-01T14:23:45.331Z 2025-12-06T14:48:19.536Z
8653239 8653239 20251130020404_h39aJ UK0057 2025-12-01T14:23:07.041Z 2025-12-06T14:47:52.040Z
8652179 8652179 20251130005320_zuTBQ UK0057 2025-12-01T14:20:52.508Z 2025-12-06T14:47:27.932Z
8651628 8651628 20251130000355_yWN1C UK0057 2025-12-01T14:19:35.323Z 2025-12-06T14:46:49.693Z
8648676 8648676 20251128065821_hRe6x UK0057 2025-11-30T14:38:18.751Z 2025-12-06T15:04:05.101Z
8648673 8648673 20251128051611_V6e2y UK0057 2025-11-30T14:38:05.430Z 2025-12-06T15:03:57.750Z
8648142 8648142 20251129064600_jrc1J UK0057 2025-11-30T14:29:40.431Z 2025-12-06T14:57:15.696Z
8647990 8647990 20251129061657_pnk3k UK0057 2025-11-30T14:29:27.749Z 2025-12-06T14:57:05.785Z
8646981 8646981 20251129032223_sw53w UK0057 2025-11-30T14:27:13.496Z 2025-12-06T14:56:29.230Z
8646966 8646966 20251129032106_mmPgT UK0057 2025-11-30T14:27:11.951Z 2025-12-06T14:56:28.936Z
8637744 8637744 20251128063003_Lozci UK0057 2025-11-29T14:27:47.541Z 2025-12-06T15:04:03.776Z
8637424 8637424 20251128053922_pOuit UK0057 2025-11-29T14:27:14.105Z 2025-12-06T15:04:00.041Z
8637290 8637290 20251128052539_TJ4JR UK0057 2025-11-29T14:27:03.163Z 2025-12-06T15:03:58.723Z
8637176 8637176 20251128051131_vVLqE UK0057 2025-11-29T14:26:56.008Z 2025-12-06T15:03:57.255Z
8637165 8637165 20251128051117_lNhIl UK0057 2025-11-29T14:26:55.485Z 2025-12-06T15:03:57.200Z
8637126 8637126 20251128050418_wdQkI UK0057 2025-11-29T14:26:52.235Z 2025-12-06T15:03:56.768Z
8637006 8637006 20251128044743_k62YZ UK0057 2025-11-29T14:26:31.817Z 2025-12-06T15:03:55.441Z
8636952 8636952 20251128044044_j3k4A UK0057 2025-11-29T14:26:23.252Z 2025-12-06T15:03:52.148Z
8636943 8636943 20251128044017_BHzpj UK0057 2025-11-29T14:26:22.674Z 2025-12-06T15:03:51.473Z
8636917 8636917 20251128043741_FOHMI UK0057 2025-11-29T14:26:20.500Z 2025-12-06T15:03:50.484Z
8636772 8636772 20251128042640_duDDi UK0057 2025-11-29T14:26:11.258Z 2025-12-06T15:03:41.910Z
8636755 8636755 20251128042251_0PyD8 UK0057 2025-11-29T14:26:09.414Z 2025-12-06T15:03:40.268Z
8636684 8636684 20251128041712_xOKII UK0057 2025-11-29T14:26:05.126Z 2025-12-06T15:03:36.984Z
8635931 8635931 20251128025926_FU3ra UK0057 2025-11-29T14:24:39.193Z 2025-12-06T15:02:54.242Z
8635900 8635900 20251128025757_a6XJo UK0057 2025-11-29T14:24:21.884Z 2025-12-06T15:02:53.822Z
8635896 8635896 20251128025658_aj6yA UK0057 2025-11-29T14:24:20.744Z 2025-12-06T15:02:53.744Z
8635876 8635876 20251128025521_1c2zK UK0057 2025-11-29T14:24:18.425Z 2025-12-06T15:02:53.493Z
8635509 8635509 20251128022036_vtBF0 UK0057 2025-11-29T14:23:32.060Z 2025-12-06T15:02:45.723Z
8635501 8635501 20251128021924_EbcVt UK0057 2025-11-29T14:23:30.450Z 2025-12-06T15:02:45.494Z
8635291 8635291 20251128020045_dbkt6 UK0057 2025-11-29T14:23:01.308Z 2025-12-06T15:02:43.074Z
8635274 8635274 20251128015934_QVNWF UK0057 2025-11-29T14:22:58.957Z 2025-12-06T15:02:42.899Z
8635244 8635244 20251128015633_zP3FP UK0057 2025-11-29T14:22:53.560Z 2025-12-06T15:02:42.295Z
8635087 8635087 20251128014014_2clJh UK0057 2025-11-29T14:22:39.707Z 2025-12-06T15:02:40.555Z
8634956 8634956 20251128012912_vM2wc UK0057 2025-11-29T14:22:16.841Z 2025-12-06T15:02:38.312Z
8634779 8634779 20251128011726_eCdTn UK0057 2025-11-29T14:22:03.035Z 2025-12-06T15:02:35.869Z
8634583 8634583 20251128010110_i9UBD UK0057 2025-11-29T14:21:35.241Z 2025-12-06T15:02:22.738Z
8634496 8634496 20251128005425_ZNG9z UK0057 2025-11-29T14:21:25.097Z 2025-12-06T15:02:07.028Z
8634306 8634306 20251128003608_b4EYt UK0057 2025-11-29T14:21:11.330Z 2025-12-06T15:01:59.546Z

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