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

972 rows where station_code = "UK009R" 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
8686026 8686026 20251203181409_BRE78 UK009R 2025-12-05T14:10:44.605Z 2025-12-05T14:14:35.281Z
8686021 8686021 20251203181125_JKZRw UK009R 2025-12-05T14:10:43.900Z 2025-12-05T14:14:35.280Z
8685897 8685897 20251203173250_PQDXP UK009R 2025-12-05T14:10:26.148Z 2025-12-05T14:14:35.253Z
8683036 8683036 20251203061948_emjuR UK009R 2025-12-04T14:18:27.894Z 2025-12-05T14:23:05.369Z
8683005 8683005 20251203061846_bN35k UK009R 2025-12-04T14:18:26.622Z 2025-12-05T14:23:04.871Z
8682914 8682914 20251203061601_Q7kvR UK009R 2025-12-04T14:18:20.506Z 2025-12-05T14:23:02.017Z
8682862 8682862 20251203061124_BhuKC UK009R 2025-12-04T14:18:09.690Z 2025-12-05T14:22:54.778Z
8682638 8682638 20251203055526_IHmNu UK009R 2025-12-04T14:17:50.728Z 2025-12-05T14:22:46.259Z
8682237 8682237 20251203050656_rsyY4 UK009R 2025-12-04T14:16:40.126Z 2025-12-05T14:22:19.891Z
8682190 8682190 20251203045833_EzxAo UK009R 2025-12-04T14:16:35.133Z 2025-12-05T14:22:17.839Z
8682155 8682155 20251203045510_33mE4 UK009R 2025-12-04T14:16:31.156Z 2025-12-05T14:22:16.119Z
8681995 8681995 20251203043536_zzxkY UK009R 2025-12-04T14:16:07.036Z 2025-12-05T14:22:10.665Z
8681987 8681987 20251203043420_om892 UK009R 2025-12-04T14:16:05.390Z 2025-12-05T14:22:10.117Z
8681902 8681902 20251203042638_EFCpq UK009R 2025-12-04T14:15:58.932Z 2025-12-05T14:22:06.733Z
8681840 8681840 20251203041447_TtdEg UK009R 2025-12-04T14:15:46.203Z 2025-12-05T14:22:03.749Z
8681823 8681823 20251203041223_KcaIM UK009R 2025-12-04T14:15:41.605Z 2025-12-05T14:22:02.935Z
8681781 8681781 20251203040351_t9dNz UK009R 2025-12-04T14:15:35.536Z 2025-12-05T14:22:00.779Z
8681624 8681624 20251203033315_Bmw6U UK009R 2025-12-04T14:15:09.673Z 2025-12-05T14:21:44.224Z
8681477 8681477 20251203031538_ayyrO UK009R 2025-12-04T14:14:48.374Z 2025-12-05T14:21:38.646Z
8681438 8681438 20251203030941_W8My2 UK009R 2025-12-04T14:14:43.304Z 2025-12-05T14:21:37.272Z
8681308 8681308 20251203025550_4ENvF UK009R 2025-12-04T14:14:27.211Z 2025-12-05T14:21:31.920Z
8681302 8681302 20251203025526_cbo3y UK009R 2025-12-04T14:14:26.387Z 2025-12-05T14:21:31.582Z
8681226 8681226 20251203024516_8zKPz UK009R 2025-12-04T14:14:05.830Z 2025-12-05T14:21:27.827Z
8681197 8681197 20251203023748_oHD5Z UK009R 2025-12-04T14:14:02.297Z 2025-12-05T14:21:26.280Z
8681134 8681134 20251203022749_DQQor UK009R 2025-12-04T14:13:56.093Z 2025-12-05T14:21:18.228Z
8681005 8681005 20251203021139_G2yC6 UK009R 2025-12-04T14:13:32.514Z 2025-12-05T14:21:10.754Z
8680808 8680808 20251203012339_f5Or1 UK009R 2025-12-04T14:12:58.372Z 2025-12-05T14:21:01.819Z
8680758 8680758 20251203011255_QkJOa UK009R 2025-12-04T14:12:52.022Z 2025-12-05T14:20:59.771Z
8662259 8662259 20251130182339_bsvbt UK009R 2025-12-02T14:14:51.155Z 2025-12-05T14:33:14.176Z
8657797 8657797 20251130060842_NGTym UK009R 2025-12-01T14:34:41.596Z 2025-12-05T14:45:36.968Z
8657631 8657631 20251130055509_pMmVs UK009R 2025-12-01T14:34:35.422Z 2025-12-05T14:45:34.289Z
8657554 8657554 20251130055156_NnVDT UK009R 2025-12-01T14:34:32.886Z 2025-12-05T14:45:33.202Z
8657544 8657544 20251130055153_ba6OR UK009R 2025-12-01T14:34:32.735Z 2025-12-05T14:45:33.131Z
8657104 8657104 20251130052954_GTKmd UK009R 2025-12-01T14:33:54.630Z 2025-12-05T14:45:25.582Z
8657052 8657052 20251130052620_TvXo6 UK009R 2025-12-01T14:33:52.497Z 2025-12-05T14:45:24.854Z
8656729 8656729 20251130050728_4hmfK UK009R 2025-12-01T14:28:58.216Z 2025-12-05T14:45:20.266Z
8656587 8656587 20251130050044_O3KNo UK009R 2025-12-01T14:28:46.256Z 2025-12-01T14:28:46.256Z
8656326 8656326 20251130044932_F24pN UK009R 2025-12-01T14:28:20.491Z 2025-12-05T14:45:05.021Z
8656260 8656260 20251130044531_8otOS UK009R 2025-12-01T14:28:14.233Z 2025-12-05T14:44:48.883Z
8655568 8655568 20251130040715_9Rsze UK009R 2025-12-01T14:27:04.014Z 2025-12-05T14:44:35.348Z
8655464 8655464 20251130040317_WJtXd UK009R 2025-12-01T14:26:55.778Z 2025-12-05T14:44:33.983Z
8652843 8652843 20251130013725_XL7gf UK009R 2025-12-01T14:22:13.499Z 2025-12-05T14:42:54.422Z
8652395 8652395 20251130010625_nCogw UK009R 2025-12-01T14:21:20.316Z 2025-12-05T14:42:43.759Z
8651584 8651584 20251129235755_2JcmH UK009R 2025-12-01T14:19:24.448Z 2025-12-05T14:42:01.154Z
8616745 8616745 20251126062301_Gua2G UK009R 2025-11-27T14:31:47.219Z 2025-12-04T15:11:42.672Z
8616700 8616700 20251126061648_5Ytq3 UK009R 2025-11-27T14:31:31.055Z 2025-12-04T15:11:41.962Z
8616681 8616681 20251126061603_uQHgT UK009R 2025-11-27T14:31:26.189Z 2025-12-04T15:11:41.817Z
8616662 8616662 20251126061416_l4KB2 UK009R 2025-11-27T14:31:24.946Z 2025-12-04T15:11:41.646Z
8616572 8616572 20251126060943_7n79x UK009R 2025-11-27T14:31:17.674Z 2025-12-04T15:11:40.953Z
8616233 8616233 20251126054723_1ozdI UK009R 2025-11-27T14:30:57.979Z 2025-12-04T15:11:37.107Z
8616087 8616087 20251126053734_juLRe UK009R 2025-11-27T14:30:29.371Z 2025-12-04T15:11:35.464Z
8616069 8616069 20251126053504_qH3EG UK009R 2025-11-27T14:30:27.584Z 2025-12-04T15:11:35.114Z
8615984 8615984 20251126053039_f2Wl9 UK009R 2025-11-27T14:30:19.849Z 2025-12-04T15:11:34.212Z
8615721 8615721 20251126051435_32vNK UK009R 2025-11-27T14:30:06.419Z 2025-12-04T15:11:31.520Z
8615710 8615710 20251126051310_nRyJu UK009R 2025-11-27T14:30:05.881Z 2025-12-04T15:11:31.344Z
8615240 8615240 20251126045201_p8G0c UK009R 2025-11-27T14:29:22.213Z 2025-12-04T15:11:26.990Z
8615152 8615152 20251126044636_wb29J UK009R 2025-11-27T14:29:16.657Z 2025-12-04T15:11:26.285Z
8614578 8614578 20251126041816_7fcMS UK009R 2025-11-27T14:28:03.187Z 2025-12-04T15:10:51.740Z
8614493 8614493 20251126041518_ksZHw UK009R 2025-11-27T14:27:55.460Z 2025-12-04T15:10:45.761Z
8614259 8614259 20251126040032_UFvyq UK009R 2025-11-27T14:27:42.423Z 2025-12-04T15:10:33.517Z
8613740 8613740 20251126033225_0RMMF UK009R 2025-11-27T14:26:28.840Z 2025-12-04T15:09:51.462Z
8613471 8613471 20251126031855_bWnbF UK009R 2025-11-27T14:26:07.467Z 2025-12-04T15:09:41.024Z
8613045 8613045 20251126030015_M03OO UK009R 2025-11-27T14:25:20.404Z 2025-12-04T15:09:36.692Z
8612909 8612909 20251126025507_dvq4L UK009R 2025-11-27T14:24:59.117Z 2025-12-04T15:09:35.726Z
8612587 8612587 20251126023849_3Rjx2 UK009R 2025-11-27T14:24:23.733Z 2025-12-04T15:09:32.156Z
8612320 8612320 20251126022606_53rVe UK009R 2025-11-27T14:23:47.584Z 2025-12-04T15:09:29.546Z
8611525 8611525 20251126015013_ASjZv UK009R 2025-11-27T14:22:16.363Z 2025-12-04T15:09:22.094Z
8611499 8611499 20251126014905_gEfjy UK009R 2025-11-27T14:22:14.063Z 2025-12-04T15:09:21.633Z
8611150 8611150 20251126012409_a7m6U UK009R 2025-11-27T14:21:32.524Z 2025-12-04T15:08:54.404Z
8611091 8611091 20251126012020_xjRE1 UK009R 2025-11-27T14:21:10.612Z 2025-12-04T15:08:50.488Z
8611083 8611083 20251126012020_3wDw8 UK009R 2025-11-27T14:21:10.387Z 2025-12-04T15:08:50.465Z
8610893 8610893 20251126011314_Ujpsw UK009R 2025-11-27T14:20:56.135Z 2025-12-04T15:08:44.560Z
8610698 8610698 20251126010301_fY0oj UK009R 2025-11-27T14:20:44.437Z 2025-12-04T15:08:33.308Z
8610584 8610584 20251126005745_hd64q UK009R 2025-11-27T14:20:24.936Z 2025-12-04T15:08:14.858Z
8608445 8608445 20251125221741_NM3J7 UK009R 2025-11-27T14:16:06.886Z 2025-12-04T15:07:45.028Z
8608439 8608439 20251125221606_0mnrl UK009R 2025-11-27T14:16:06.296Z 2025-12-04T15:07:44.972Z
8608180 8608180 20251125215742_Fh1TR UK009R 2025-11-27T14:15:31.682Z 2025-12-04T15:07:42.393Z
8607858 8607858 20251125212900_PyrlJ UK009R 2025-11-27T14:14:37.694Z 2025-12-04T15:07:36.181Z
8607072 8607072 20251125200929_CGTKu UK009R 2025-11-27T14:12:19.073Z 2025-12-04T15:06:54.334Z
8603591 8603591 20251125061846_ApHRY UK009R 2025-11-26T14:27:33.764Z 2025-12-02T15:09:36.448Z
8603487 8603487 20251125061038_0uCrD UK009R 2025-11-26T14:27:28.367Z 2025-12-02T15:09:36.000Z
8603479 8603479 20251125061031_iAvK1 UK009R 2025-11-26T14:27:28.021Z 2025-12-02T15:09:35.963Z
8603276 8603276 20251125055410_IS0lT UK009R 2025-11-26T14:27:18.725Z 2025-12-02T15:09:35.157Z
8603193 8603193 20251125054850_zGo2D UK009R 2025-11-26T14:27:13.320Z 2025-12-02T15:09:34.750Z
8602964 8602964 20251125053513_ZhaDo UK009R 2025-11-26T14:26:30.588Z 2025-12-02T15:09:33.737Z
8602919 8602919 20251125053243_ox7RQ UK009R 2025-11-26T14:26:27.632Z 2025-12-02T15:09:33.475Z
8602542 8602542 20251125050307_gXHye UK009R 2025-11-26T14:26:06.582Z 2025-12-02T15:09:31.436Z
8601579 8601579 20251125035741_IYqKB UK009R 2025-11-26T14:24:27.439Z 2025-12-02T15:09:15.676Z
8600039 8600039 20251125023855_akbdC UK009R 2025-11-26T14:21:59.330Z 2025-12-02T15:08:34.096Z
8599957 8599957 20251125023318_sC7Mj UK009R 2025-11-26T14:21:51.833Z 2025-12-02T15:08:32.917Z
8599257 8599257 20251125015647_Atz9S UK009R 2025-11-26T14:20:43.873Z 2025-12-02T15:08:22.066Z
8599149 8599149 20251125014844_rij5o UK009R 2025-11-26T14:20:35.457Z 2025-12-02T15:08:20.424Z
8598886 8598886 20251125013323_AqJtb UK009R 2025-11-26T14:20:02.277Z 2025-12-02T15:08:11.470Z
8598772 8598772 20251125012245_ve4Pa UK009R 2025-11-26T14:19:49.833Z 2025-12-02T15:08:08.510Z
8598621 8598621 20251125011011_MeDHJ UK009R 2025-11-26T14:19:20.323Z 2025-12-02T15:08:01.369Z
8598207 8598207 20251125004323_XUYml UK009R 2025-11-26T14:18:27.059Z 2025-12-02T15:07:48.570Z
8597062 8597062 20251124225100_dU3xM UK009R 2025-11-26T14:15:56.119Z 2025-12-02T15:07:22.744Z
8595797 8595797 20251124182941_p6qoy UK009R 2025-11-26T14:12:30.770Z 2025-12-02T15:06:11.381Z
8591986 8591986 20251124052830_S9V4j UK009R 2025-11-25T14:25:28.941Z 2025-12-02T15:13:01.332Z
8591976 8591976 20251124052638_WrN62 UK009R 2025-11-25T14:25:28.166Z 2025-12-02T15:13:01.292Z

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