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

>10,000 rows count all where station_code = "UK000F" 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
8691261 8691261 20251205041819_I6DyW UK000F 2025-12-06T14:17:03.775Z 2025-12-06T14:18:01.071Z
8691034 8691034 20251205025735_5UHbX UK000F 2025-12-06T14:16:19.363Z 2025-12-06T14:18:01.016Z
8690898 8690898 20251205021645_p3Elj UK000F 2025-12-06T14:15:48.059Z 2025-12-06T14:18:00.983Z
8690511 8690511 20251205000744_OA0IB UK000F 2025-12-06T14:14:35.138Z 2025-12-06T14:18:00.897Z
8690413 8690413 20251204233047_V8FO3 UK000F 2025-12-06T14:14:13.769Z 2025-12-06T14:18:00.876Z
8689897 8689897 20251204175354_SPFmw UK000F 2025-12-06T14:12:28.607Z 2025-12-06T14:18:00.750Z
8689892 8689892 20251204175301_5KjpD UK000F 2025-12-06T14:12:27.828Z 2025-12-06T14:18:00.749Z
8683015 8683015 20251203061855_Iw81H UK000F 2025-12-04T14:18:26.939Z 2025-12-06T14:29:38.829Z
8682823 8682823 20251203060704_CexYB UK000F 2025-12-04T14:18:03.946Z 2025-12-06T14:29:26.820Z
8682754 8682754 20251203060229_3c3xR UK000F 2025-12-04T14:17:58.843Z 2025-12-06T14:29:24.397Z
8680180 8680180 20251202221309_VoUQv UK000F 2025-12-04T14:11:22.260Z 2025-12-06T14:26:54.404Z
8677020 8677020 20251202064049_nW70X UK000F 2025-12-03T14:26:12.425Z 2025-12-06T14:35:33.114Z
8676782 8676782 20251202062501_mERB2 UK000F 2025-12-03T14:25:35.195Z 2025-12-06T14:35:28.748Z
8676592 8676592 20251202060440_VPjXR UK000F 2025-12-03T14:25:20.573Z 2025-12-06T14:35:24.223Z
8676519 8676519 20251202055812_CTmqz UK000F 2025-12-03T14:25:16.346Z 2025-12-06T14:35:22.911Z
8676502 8676502 20251202055733_HDZJ3 UK000F 2025-12-03T14:25:15.535Z 2025-12-06T14:35:22.644Z
8676138 8676138 20251202053846_pR7uL UK000F 2025-12-03T14:24:46.830Z 2025-12-06T14:35:17.114Z
8668064 8668064 20251130055104_Nxb3d UK000F 2025-12-02T14:41:41.284Z 2025-12-06T14:50:05.413Z
8667391 8667391 20251130005620_dNhy0 UK000F 2025-12-02T14:37:56.467Z 2025-12-06T14:47:32.064Z
8657938 8657938 20251130062133_CaprW UK000F 2025-12-01T14:34:47.223Z 2025-12-06T14:50:24.697Z
8657823 8657823 20251130061105_U9pvH UK000F 2025-12-01T14:34:42.673Z 2025-12-06T14:50:22.931Z
8657800 8657800 20251130061007_p29SZ UK000F 2025-12-01T14:34:41.892Z 2025-12-06T14:50:22.716Z
8657791 8657791 20251130060842_NGTym UK000F 2025-12-01T14:34:41.595Z 2025-12-06T14:50:22.679Z
8657766 8657766 20251130060745_eoEid UK000F 2025-12-01T14:34:40.557Z 2025-12-06T14:50:22.394Z
8657713 8657713 20251130060208_BG34k UK000F 2025-12-01T14:34:38.953Z 2025-12-06T14:50:21.927Z
8657625 8657625 20251130055509_pMmVs UK000F 2025-12-01T14:34:35.422Z 2025-12-06T14:50:16.160Z
8657517 8657517 20251130055059_E4Wha UK000F 2025-12-01T14:34:32.057Z 2025-12-06T14:50:05.226Z
8657479 8657479 20251130054850_KEH3S UK000F 2025-12-01T14:34:30.589Z 2025-12-06T14:50:04.064Z
8657349 8657349 20251130054025_IxrY5 UK000F 2025-12-01T14:34:09.420Z 2025-12-06T14:49:54.548Z
8657248 8657248 20251130053727_kpfIq UK000F 2025-12-01T14:34:02.523Z 2025-12-06T14:49:47.966Z
8657173 8657173 20251130053228_1aNV2 UK000F 2025-12-01T14:33:58.847Z 2025-12-06T14:49:45.426Z
8657078 8657078 20251130052915_wt8fP UK000F 2025-12-01T14:33:53.777Z 2025-12-06T14:49:44.593Z
8657073 8657073 20251130052838_oi2BT UK000F 2025-12-01T14:33:53.292Z 2025-12-06T14:49:44.461Z
8657043 8657043 20251130052620_TvXo6 UK000F 2025-12-01T14:33:52.497Z 2025-12-06T14:49:44.181Z
8656993 8656993 20251130052359_ST4xC UK000F 2025-12-01T14:33:51.655Z 2025-12-06T14:49:43.978Z
8656753 8656753 20251130050821_qV42l UK000F 2025-12-01T14:28:59.387Z 2025-12-06T14:49:39.691Z
8656724 8656724 20251130050728_4hmfK UK000F 2025-12-01T14:28:58.216Z 2025-12-06T14:49:39.279Z
8656645 8656645 20251130050439_oVnh2 UK000F 2025-12-01T14:28:51.585Z 2025-12-06T14:49:38.092Z
8656451 8656451 20251130045632_iB93j UK000F 2025-12-01T14:28:39.579Z 2025-12-06T14:49:34.930Z
8656440 8656440 20251130045626_ij6t5 UK000F 2025-12-01T14:28:39.178Z 2025-12-06T14:49:34.883Z
8656322 8656322 20251130044932_F24pN UK000F 2025-12-01T14:28:20.491Z 2025-12-06T14:49:33.469Z
8656256 8656256 20251130044531_8otOS UK000F 2025-12-01T14:28:14.233Z 2025-12-06T14:49:32.827Z
8656178 8656178 20251130044207_j4SJu UK000F 2025-12-01T14:28:09.095Z 2025-12-06T14:49:31.953Z
8655956 8655956 20251130042736_bscTu UK000F 2025-12-01T14:27:42.192Z 2025-12-06T14:49:29.301Z
8655941 8655941 20251130042717_1byaU UK000F 2025-12-01T14:27:41.855Z 2025-12-06T14:49:29.234Z
8655717 8655717 20251130041326_Xof9D UK000F 2025-12-01T14:27:22.634Z 2025-12-06T14:49:26.833Z
8655639 8655639 20251130041032_qzGAS UK000F 2025-12-01T14:27:19.708Z 2025-12-06T14:49:26.186Z
8655607 8655607 20251130040907_90T4I UK000F 2025-12-01T14:27:16.997Z 2025-12-06T14:49:26.012Z
8655558 8655558 20251130040715_9Rsze UK000F 2025-12-01T14:27:03.927Z 2025-12-06T14:49:25.272Z
8655514 8655514 20251130040608_OjS2S UK000F 2025-12-01T14:27:01.758Z 2025-12-06T14:49:24.665Z
8655483 8655483 20251130040409_L7XH8 UK000F 2025-12-01T14:26:59.617Z 2025-12-06T14:49:23.738Z
8655386 8655386 20251130040016_Tzqo3 UK000F 2025-12-01T14:26:52.626Z 2025-12-06T14:49:12.548Z
8655316 8655316 20251130035443_QuHlb UK000F 2025-12-01T14:26:45.958Z 2025-12-06T14:49:06.449Z
8655200 8655200 20251130034837_qmmvx UK000F 2025-12-01T14:26:38.671Z 2025-12-06T14:48:53.510Z
8655175 8655175 20251130034740_3q2Pm UK000F 2025-12-01T14:26:37.212Z 2025-12-06T14:48:52.797Z
8655107 8655107 20251130034452_fedTE UK000F 2025-12-01T14:26:23.482Z 2025-12-06T14:48:51.542Z
8655092 8655092 20251130034435_gH3bn UK000F 2025-12-01T14:26:23.084Z 2025-12-06T14:48:51.465Z
8655078 8655078 20251130034318_XEU8R UK000F 2025-12-01T14:26:22.386Z 2025-12-06T14:48:51.392Z
8654991 8654991 20251130034036_yj4AN UK000F 2025-12-01T14:26:14.785Z 2025-12-06T14:48:50.693Z
8654947 8654947 20251130033941_XW6tZ UK000F 2025-12-01T14:26:12.726Z 2025-12-06T14:48:50.439Z
8654751 8654751 20251130033127_hHEaP UK000F 2025-12-01T14:25:58.045Z 2025-12-06T14:48:47.898Z
8654717 8654717 20251130032833_Wdx0O UK000F 2025-12-01T14:25:47.355Z 2025-12-06T14:48:47.254Z
8654598 8654598 20251130032225_KFfD3 UK000F 2025-12-01T14:25:37.061Z 2025-12-06T14:48:44.687Z
8654295 8654295 20251130030848_7djzt UK000F 2025-12-01T14:25:06.708Z 2025-12-06T14:48:40.188Z
8654235 8654235 20251130030510_ZUwV9 UK000F 2025-12-01T14:25:00.832Z 2025-12-06T14:48:39.311Z
8654021 8654021 20251130025301_v2NNj UK000F 2025-12-01T14:24:44.977Z 2025-12-06T14:48:36.076Z
8653962 8653962 20251130024934_8KXez UK000F 2025-12-01T14:24:33.344Z 2025-12-06T14:48:35.130Z
8653918 8653918 20251130024816_QfCmd UK000F 2025-12-01T14:24:29.967Z 2025-12-06T14:48:34.572Z
8653759 8653759 20251130023845_T5jJd UK000F 2025-12-01T14:24:11.356Z 2025-12-06T14:48:31.557Z
8653738 8653738 20251130023829_Dv94d UK000F 2025-12-01T14:24:09.322Z 2025-12-06T14:48:31.275Z
8653732 8653732 20251130023804_3DmGC UK000F 2025-12-01T14:24:08.387Z 2025-12-06T14:48:31.142Z
8653600 8653600 20251130022900_pmPr6 UK000F 2025-12-01T14:23:46.089Z 2025-12-06T14:48:19.736Z
8653577 8653577 20251130022615_ggyJA UK000F 2025-12-01T14:23:43.296Z 2025-12-06T14:48:16.245Z
8653510 8653510 20251130022146_4NIDn UK000F 2025-12-01T14:23:37.797Z 2025-12-06T14:48:05.797Z
8653433 8653433 20251130021618_FiJmh UK000F 2025-12-01T14:23:31.280Z 2025-12-06T14:47:58.175Z
8653399 8653399 20251130021457_93gj2 UK000F 2025-12-01T14:23:21.155Z 2025-12-06T14:47:57.346Z
8653382 8653382 20251130021333_oGvAD UK000F 2025-12-01T14:23:19.714Z 2025-12-06T14:47:57.074Z
8653257 8653257 20251130020509_pZe2h UK000F 2025-12-01T14:23:08.189Z 2025-12-06T14:47:52.391Z
8653172 8653172 20251130020125_l3mxT UK000F 2025-12-01T14:23:02.223Z 2025-12-06T14:47:51.131Z
8653128 8653128 20251130015926_rTlnS UK000F 2025-12-01T14:22:52.013Z 2025-12-06T14:47:50.616Z
8653052 8653052 20251130015329_GtUyH UK000F 2025-12-01T14:22:42.775Z 2025-12-06T14:47:48.888Z
8653047 8653047 20251130015318_aE23X UK000F 2025-12-01T14:22:42.207Z 2025-12-06T14:47:48.771Z
8652936 8652936 20251130014610_MWc0v UK000F 2025-12-01T14:22:33.569Z 2025-12-06T14:47:46.502Z
8652890 8652890 20251130014419_Ln2oV UK000F 2025-12-01T14:22:29.172Z 2025-12-06T14:47:44.995Z
8652842 8652842 20251130013725_XL7gf UK000F 2025-12-01T14:22:13.499Z 2025-12-06T14:47:43.235Z
8652681 8652681 20251130012713_7hhQX UK000F 2025-12-01T14:21:58.801Z 2025-12-06T14:47:40.992Z
8652517 8652517 20251130011407_fGQY3 UK000F 2025-12-01T14:21:37.334Z 2025-12-06T14:47:38.357Z
8652394 8652394 20251130010625_nCogw UK000F 2025-12-01T14:21:20.316Z 2025-12-06T14:47:36.607Z
8652369 8652369 20251130010441_Rcr6w UK000F 2025-12-01T14:21:18.648Z 2025-12-06T14:47:36.220Z
8652197 8652197 20251130005504_Tv283 UK000F 2025-12-01T14:20:54.567Z 2025-12-06T14:47:30.541Z
8652061 8652061 20251130004421_ZnlL2 UK000F 2025-12-01T14:20:39.214Z 2025-12-06T14:47:11.230Z
8650430 8650430 20251129201354_S541v UK000F 2025-12-01T14:16:10.779Z 2025-12-06T14:45:56.190Z
8649614 8649614 20251129175719_QfrVF UK000F 2025-12-01T14:13:20.570Z 2025-12-06T14:45:34.607Z
8637570 8637570 20251128055316_PvkaH UK000F 2025-11-29T14:27:35.027Z 2025-12-06T15:04:01.248Z
8637034 8637034 20251128045258_NxzHh UK000F 2025-11-29T14:26:40.960Z 2025-12-06T15:03:55.930Z
8636984 8636984 20251128044537_mztEx UK000F 2025-11-29T14:26:30.142Z 2025-12-06T15:03:54.174Z
8636626 8636626 20251128041132_S2DGN UK000F 2025-11-29T14:25:46.601Z 2025-12-06T15:03:33.562Z
8636582 8636582 20251128040629_CyJVG UK000F 2025-11-29T14:25:43.833Z 2025-12-06T15:03:31.505Z
8635654 8635654 20251128023536_loXZN UK000F 2025-11-29T14:23:59.051Z 2025-12-06T15:02:47.898Z
8635586 8635586 20251128022835_kMbrA UK000F 2025-11-29T14:23:51.556Z 2025-12-06T15:02:46.898Z

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