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,263 rows where station_code = "UK00AF" 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
8682864 8682864 20251203061124_BhuKC UK00AF 2025-12-04T14:18:09.690Z 2025-12-05T14:22:54.778Z
8681516 8681516 20251203031950_aKgrg UK00AF 2025-12-04T14:14:51.707Z 2025-12-05T14:21:39.942Z
8681478 8681478 20251203031538_ayyrO UK00AF 2025-12-04T14:14:48.374Z 2025-12-05T14:21:38.646Z
8681310 8681310 20251203025550_4ENvF UK00AF 2025-12-04T14:14:27.211Z 2025-12-05T14:21:31.920Z
8681228 8681228 20251203024516_8zKPz UK00AF 2025-12-04T14:14:05.830Z 2025-12-05T14:21:27.827Z
8681136 8681136 20251203022749_DQQor UK00AF 2025-12-04T14:13:56.093Z 2025-12-05T14:21:18.228Z
8680810 8680810 20251203012339_f5Or1 UK00AF 2025-12-04T14:12:58.372Z 2025-12-05T14:21:01.819Z
8680761 8680761 20251203011255_QkJOa UK00AF 2025-12-04T14:12:52.022Z 2025-12-05T14:20:59.771Z
8663498 8663498 20251130205019_0TFZK UK00AF 2025-12-02T14:18:22.413Z 2025-12-05T14:34:21.742Z
8657947 8657947 20251130062133_CaprW UK00AF 2025-12-01T14:34:47.224Z 2025-12-05T14:45:59.161Z
8657936 8657936 20251130062016_MvnE2 UK00AF 2025-12-01T14:34:47.033Z 2025-12-05T14:45:58.843Z
8657848 8657848 20251130061206_RsFc6 UK00AF 2025-12-01T14:34:43.165Z 2025-12-05T14:45:42.342Z
8657833 8657833 20251130061105_U9pvH UK00AF 2025-12-01T14:34:42.674Z 2025-12-05T14:45:42.170Z
8657805 8657805 20251130061007_p29SZ UK00AF 2025-12-01T14:34:41.892Z 2025-12-05T14:45:37.676Z
8657728 8657728 20251130060341_wMa93 UK00AF 2025-12-01T14:34:39.222Z 2025-12-05T14:45:36.145Z
8657633 8657633 20251130055509_pMmVs UK00AF 2025-12-01T14:34:35.422Z 2025-12-05T14:45:34.289Z
8657503 8657503 20251130054926_1pwxA UK00AF 2025-12-01T14:34:31.173Z 2025-12-05T14:45:32.654Z
8657354 8657354 20251130054025_IxrY5 UK00AF 2025-12-01T14:34:09.420Z 2025-12-05T14:45:28.667Z
8657299 8657299 20251130053809_BPSQW UK00AF 2025-12-01T14:34:03.327Z 2025-12-05T14:45:27.942Z
8657256 8657256 20251130053727_kpfIq UK00AF 2025-12-01T14:34:02.523Z 2025-12-05T14:45:27.597Z
8657054 8657054 20251130052620_TvXo6 UK00AF 2025-12-01T14:33:52.497Z 2025-12-05T14:45:24.854Z
8657001 8657001 20251130052359_ST4xC UK00AF 2025-12-01T14:33:51.656Z 2025-12-05T14:45:24.503Z
8656805 8656805 20251130051007_3Kp8i UK00AF 2025-12-01T14:29:01.177Z 2025-12-05T14:45:21.514Z
8656589 8656589 20251130050044_O3KNo UK00AF 2025-12-01T14:28:46.256Z 2025-12-01T14:28:46.256Z
8656460 8656460 20251130045632_iB93j UK00AF 2025-12-01T14:28:39.579Z 2025-12-05T14:45:16.334Z
8656449 8656449 20251130045626_ij6t5 UK00AF 2025-12-01T14:28:39.178Z 2025-12-05T14:45:16.238Z
8656328 8656328 20251130044932_F24pN UK00AF 2025-12-01T14:28:20.491Z 2025-12-05T14:45:05.021Z
8655794 8655794 20251130041831_nzoIe UK00AF 2025-12-01T14:27:29.700Z 2025-12-05T14:44:39.125Z
8655487 8655487 20251130040409_L7XH8 UK00AF 2025-12-01T14:26:59.617Z 2025-12-05T14:44:34.371Z
8655466 8655466 20251130040317_WJtXd UK00AF 2025-12-01T14:26:55.779Z 2025-12-05T14:44:33.984Z
8655180 8655180 20251130034740_3q2Pm UK00AF 2025-12-01T14:26:37.212Z 2025-12-05T14:44:29.405Z
8654607 8654607 20251130032225_KFfD3 UK00AF 2025-12-01T14:25:37.061Z 2025-12-05T14:44:15.330Z
8654292 8654292 20251130030741_ozC7Y UK00AF 2025-12-01T14:25:05.992Z 2025-12-05T14:43:52.680Z
8651393 8651393 20251129233616_Lk10g UK00AF 2025-12-01T14:18:58.328Z 2025-12-05T14:41:56.933Z
8651199 8651199 20251129230337_xHcrk UK00AF 2025-12-01T14:18:21.877Z 2025-12-05T14:41:51.679Z
8644959 8644959 20251128201839_lFuts UK00AF 2025-11-30T14:22:54.469Z 2025-12-05T14:50:29.900Z
8635014 8635014 20251128013342_4R0OK UK00AF 2025-11-29T14:22:22.400Z 2025-12-05T14:58:27.622Z
8634425 8634425 20251128004836_Hdbnf UK00AF 2025-11-29T14:21:20.831Z 2025-12-05T14:58:20.488Z
8634314 8634314 20251128003613_DvHXu UK00AF 2025-11-29T14:21:11.609Z 2025-12-05T14:58:19.002Z
8616573 8616573 20251126060943_7n79x UK00AF 2025-11-27T14:31:17.674Z 2025-12-04T15:11:40.953Z
8615712 8615712 20251126051310_nRyJu UK00AF 2025-11-27T14:30:05.881Z 2025-12-04T15:11:31.344Z
8615478 8615478 20251126050434_paoy0 UK00AF 2025-11-27T14:29:35.187Z 2025-12-04T15:11:29.304Z
8615243 8615243 20251126045201_p8G0c UK00AF 2025-11-27T14:29:22.213Z 2025-12-04T15:11:26.990Z
8614935 8614935 20251126043653_U24Jy UK00AF 2025-11-27T14:28:43.410Z 2025-12-04T15:11:21.986Z
8614792 8614792 20251126042731_5lh4k UK00AF 2025-11-27T14:28:33.339Z 2025-12-04T15:11:08.987Z
8614497 8614497 20251126041518_ksZHw UK00AF 2025-11-27T14:27:55.460Z 2025-12-04T15:10:45.761Z
8614322 8614322 20251126040338_z5PhB UK00AF 2025-11-27T14:27:46.157Z 2025-12-04T15:10:35.341Z
8614261 8614261 20251126040032_UFvyq UK00AF 2025-11-27T14:27:42.423Z 2025-12-04T15:10:33.517Z
8613919 8613919 20251126034125_sZntY UK00AF 2025-11-27T14:26:57.806Z 2025-12-04T15:09:53.715Z
8613742 8613742 20251126033225_0RMMF UK00AF 2025-11-27T14:26:28.840Z 2025-12-04T15:09:51.462Z
8613678 8613678 20251126032815_tdRJb UK00AF 2025-11-27T14:26:22.448Z 2025-12-04T15:09:50.440Z
8613669 8613669 20251126032757_eivLl UK00AF 2025-11-27T14:26:21.758Z 2025-12-04T15:09:50.355Z
8613576 8613576 20251126032418_3UOwc UK00AF 2025-11-27T14:26:14.950Z 2025-12-04T15:09:49.351Z
8612927 8612927 20251126025520_tJeaK UK00AF 2025-11-27T14:25:00.048Z 2025-12-04T15:09:35.840Z
8612911 8612911 20251126025507_dvq4L UK00AF 2025-11-27T14:24:59.117Z 2025-12-04T15:09:35.726Z
8611692 8611692 20251126015611_7uN9z UK00AF 2025-11-27T14:22:30.767Z 2025-12-04T15:09:23.452Z
8611678 8611678 20251126015544_Vulld UK00AF 2025-11-27T14:22:28.981Z 2025-12-04T15:09:23.294Z
8611534 8611534 20251126015027_a8hmY UK00AF 2025-11-27T14:22:17.060Z 2025-12-04T15:09:22.202Z
8611153 8611153 20251126012409_a7m6U UK00AF 2025-11-27T14:21:32.524Z 2025-12-04T15:08:54.404Z
8611093 8611093 20251126012020_xjRE1 UK00AF 2025-11-27T14:21:10.612Z 2025-12-04T15:08:50.488Z
8610587 8610587 20251126005745_hd64q UK00AF 2025-11-27T14:20:24.936Z 2025-12-04T15:08:14.858Z
8610477 8610477 20251126004816_craAm UK00AF 2025-11-27T14:20:12.790Z 2025-12-04T15:08:06.256Z
8609759 8609759 20251126000323_i2cHk UK00AF 2025-11-27T14:18:55.456Z 2025-12-04T15:07:57.162Z
8609280 8609280 20251125232956_ICP4I UK00AF 2025-11-27T14:18:01.325Z 2025-12-04T15:07:53.151Z
8609244 8609244 20251125232527_hBkYj UK00AF 2025-11-27T14:17:49.023Z 2025-12-04T15:07:52.856Z
8609156 8609156 20251125231515_3WlI2 UK00AF 2025-11-27T14:17:36.794Z 2025-12-04T15:07:51.922Z
8606616 8606616 20251125191638_SqqBQ UK00AF 2025-11-27T14:10:45.240Z 2025-12-04T15:06:47.659Z
8602767 8602767 20251125052057_9M2ZF UK00AF 2025-11-26T14:26:19.589Z 2025-12-02T15:09:32.781Z
8601931 8601931 20251125042643_DyRlr UK00AF 2025-11-26T14:25:11.996Z 2025-12-02T15:09:28.786Z
8601602 8601602 20251125040303_1xmD4 UK00AF 2025-11-26T14:24:30.695Z 2025-12-02T15:09:16.564Z
8601565 8601565 20251125035741_VmKhl UK00AF 2025-11-26T14:24:27.258Z 2025-12-02T15:09:14.547Z
8601410 8601410 20251125034643_bVoiT UK00AF 2025-11-26T14:23:58.476Z 2025-12-02T15:09:09.023Z
8601327 8601327 20251125034415_zbLRQ UK00AF 2025-11-26T14:23:54.912Z 2025-12-02T15:09:07.739Z
8601282 8601282 20251125034250_1Fo52 UK00AF 2025-11-26T14:23:51.654Z 2025-12-02T15:09:07.136Z
8600823 8600823 20251125031855_cWOY5 UK00AF 2025-11-26T14:23:00.461Z 2025-12-02T15:08:50.864Z
8600405 8600405 20251125025833_DUKhX UK00AF 2025-11-26T14:22:38.510Z 2025-12-02T15:08:43.484Z
8600257 8600257 20251125024949_K99SF UK00AF 2025-11-26T14:22:12.825Z 2025-12-02T15:08:40.347Z
8600079 8600079 20251125024003_KxE37 UK00AF 2025-11-26T14:22:01.330Z 2025-12-02T15:08:34.489Z
8599991 8599991 20251125023537_iV8X5 UK00AF 2025-11-26T14:21:55.330Z 2025-12-02T15:08:33.335Z
8599962 8599962 20251125023319_1233C UK00AF 2025-11-26T14:21:52.458Z 2025-12-02T15:08:33.015Z
8599748 8599748 20251125022241_gm7r1 UK00AF 2025-11-26T14:21:27.774Z 2025-12-02T15:08:31.865Z
8599746 8599746 20251125022240_evTu7 UK00AF 2025-11-26T14:21:27.566Z 2025-12-02T15:08:31.858Z
8591960 8591960 20251124052151_UNo7X UK00AF 2025-11-25T14:25:26.687Z 2025-12-02T15:13:01.197Z
8591919 8591919 20251124051520_TbpdW UK00AF 2025-11-25T14:25:20.257Z 2025-12-02T15:13:00.978Z
8591911 8591911 20251124051424_2lys0 UK00AF 2025-11-25T14:25:19.958Z 2025-12-02T15:13:00.941Z
8591880 8591880 20251124051127_gRBb3 UK00AF 2025-11-25T14:25:17.034Z 2025-12-02T15:13:00.844Z
8591856 8591856 20251124050754_2Ih9Q UK00AF 2025-11-25T14:25:15.013Z 2025-12-02T15:13:00.778Z
8591830 8591830 20251124050501_8EbRn UK00AF 2025-11-25T14:25:12.663Z 2025-12-02T15:13:00.691Z
8591793 8591793 20251124045734_r7zdn UK00AF 2025-11-25T14:25:08.936Z 2025-12-02T15:13:00.540Z
8591715 8591715 20251124044645_OjF61 UK00AF 2025-11-25T14:24:53.105Z 2025-12-02T15:13:00.041Z
8591665 8591665 20251124044251_tz2Ss UK00AF 2025-11-25T14:24:43.304Z 2025-12-02T15:12:59.844Z
8591621 8591621 20251124043558_kV2Sx UK00AF 2025-11-25T14:24:39.629Z 2025-12-02T15:12:59.677Z
8591580 8591580 20251124042630_S1K5D UK00AF 2025-11-25T14:24:33.830Z 2025-12-02T15:12:59.447Z
8591571 8591571 20251124042540_a75za UK00AF 2025-11-25T14:24:32.856Z 2025-12-02T15:12:59.355Z
8591481 8591481 20251124041918_1vCv2 UK00AF 2025-11-25T14:24:25.412Z 2025-12-02T15:12:58.904Z
8591233 8591233 20251124035357_45ifr UK00AF 2025-11-25T14:23:45.934Z 2025-12-02T15:12:57.475Z
8591218 8591218 20251124035348_nwPVe UK00AF 2025-11-25T14:23:45.469Z 2025-12-02T15:12:57.474Z
8591191 8591191 20251124035236_nMoHh UK00AF 2025-11-25T14:23:43.659Z 2025-12-02T15:12:57.340Z
8591134 8591134 20251124034925_2hxHE UK00AF 2025-11-25T14:23:39.825Z 2025-12-02T15:12:57.223Z
8591054 8591054 20251124034013_cP16s UK00AF 2025-11-25T14:23:29.510Z 2025-12-02T15:12:56.810Z

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