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 = "UK0006" 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
8690362 8690362 20251204231406_WLbki UK0006 2025-12-06T14:14:05.092Z 2025-12-06T14:18:00.865Z
8690277 8690277 20251204223617_Usc47 UK0006 2025-12-06T14:13:57.086Z 2025-12-06T14:18:00.854Z
8690271 8690271 20251204223138_iGH38 UK0006 2025-12-06T14:13:56.602Z 2025-12-06T14:18:00.854Z
8690211 8690211 20251204220736_UgmY3 UK0006 2025-12-06T14:13:48.224Z 2025-12-06T14:18:00.841Z
8690149 8690149 20251204212206_eD7Cy UK0006 2025-12-06T14:13:30.200Z 2025-12-06T14:18:00.826Z
8690050 8690050 20251204200445_Ns6V5 UK0006 2025-12-06T14:13:06.770Z 2025-12-06T14:18:00.797Z
8690034 8690034 20251204200238_3A5uG UK0006 2025-12-06T14:13:04.812Z 2025-12-06T14:18:00.795Z
8689940 8689940 20251204184924_2MyFd UK0006 2025-12-06T14:12:37.555Z 2025-12-06T14:18:00.765Z
8689911 8689911 20251204181631_27Mx3 UK0006 2025-12-06T14:12:32.301Z 2025-12-06T14:18:00.756Z
8682993 8682993 20251203061840_vjAu6 UK0006 2025-12-04T14:18:26.442Z 2025-12-06T14:29:38.549Z
8682961 8682961 20251203061701_diBO9 UK0006 2025-12-04T14:18:24.053Z 2025-12-06T14:29:33.870Z
8682929 8682929 20251203061626_codru UK0006 2025-12-04T14:18:22.101Z 2025-12-06T14:29:32.539Z
8682741 8682741 20251203060131_VwDNX UK0006 2025-12-04T14:17:57.840Z 2025-12-06T14:29:24.002Z
8679605 8679605 20251202202726_2boLK UK0006 2025-12-04T14:10:05.266Z 2025-12-06T14:26:28.249Z
8679577 8679577 20251202202436_wJWik UK0006 2025-12-04T14:10:01.866Z 2025-12-06T14:26:27.425Z
8679343 8679343 20251202194751_yGilc UK0006 2025-12-04T14:09:30.177Z 2025-12-06T14:26:13.365Z
8679295 8679295 20251202193836_jlkFS UK0006 2025-12-04T14:09:22.233Z 2025-12-06T14:26:10.890Z
8679233 8679233 20251202192830_YBKFV UK0006 2025-12-04T14:09:16.394Z 2025-12-06T14:26:08.290Z
8679154 8679154 20251202190634_xADt4 UK0006 2025-12-04T14:09:07.545Z 2025-12-06T14:25:57.917Z
8679151 8679151 20251202190557_X2nJN UK0006 2025-12-04T14:09:06.904Z 2025-12-06T14:25:57.772Z
8677037 8677037 20251202064220_Unh26 UK0006 2025-12-03T14:26:13.270Z 2025-12-06T14:35:33.397Z
8676986 8676986 20251202063646_Mby5B UK0006 2025-12-03T14:25:59.481Z 2025-12-06T14:35:32.264Z
8676973 8676973 20251202063619_F3JS8 UK0006 2025-12-03T14:25:59.174Z 2025-12-06T14:35:32.182Z
8676820 8676820 20251202062730_Nd7Jd UK0006 2025-12-03T14:25:52.021Z 2025-12-06T14:35:29.469Z
8676532 8676532 20251202060101_SXPEA UK0006 2025-12-03T14:25:17.423Z 2025-12-06T14:35:23.241Z
8676462 8676462 20251202055341_ruDut UK0006 2025-12-03T14:25:13.512Z 2025-12-06T14:35:22.043Z
8676334 8676334 20251202054738_sxLcn UK0006 2025-12-03T14:25:07.001Z 2025-12-06T14:35:20.339Z
8676257 8676257 20251202054246_u2aGA UK0006 2025-12-03T14:24:52.128Z 2025-12-06T14:35:19.374Z
8676015 8676015 20251202053251_hEamB UK0006 2025-12-03T14:24:36.265Z 2025-12-06T14:35:06.646Z
8675891 8675891 20251202052233_PUN1M UK0006 2025-12-03T14:24:29.346Z 2025-12-06T14:35:04.374Z
8674273 8674273 20251202015624_GPLjI UK0006 2025-12-03T14:21:21.199Z 2025-12-06T14:34:02.985Z
8674234 8674234 20251202015312_pHR02 UK0006 2025-12-03T14:21:16.878Z 2025-12-06T14:34:02.366Z
8667569 8667569 20251130021722_W78H7 UK0006 2025-12-02T14:38:55.150Z 2025-12-06T14:47:58.546Z
8661930 8661930 20251130173403_UNMtq UK0006 2025-12-02T14:13:39.319Z 2025-12-06T14:38:42.435Z
8661880 8661880 20251130172842_oepc6 UK0006 2025-12-02T14:13:30.576Z 2025-12-06T14:38:40.646Z
8657998 8657998 20251130062708_h11XA UK0006 2025-12-01T14:34:49.194Z 2025-12-06T14:50:25.166Z
8657950 8657950 20251130062207_DRvvX UK0006 2025-12-01T14:34:47.455Z 2025-12-06T14:50:24.724Z
8657862 8657862 20251130061352_My5yj UK0006 2025-12-01T14:34:44.237Z 2025-12-06T14:50:23.363Z
8657837 8657837 20251130061122_kvhIi UK0006 2025-12-01T14:34:42.881Z 2025-12-06T14:50:22.961Z
8657391 8657391 20251130054122_ygds5 UK0006 2025-12-01T14:34:22.022Z 2025-12-06T14:49:56.426Z
8657376 8657376 20251130054055_bfzkO UK0006 2025-12-01T14:34:19.151Z 2025-12-06T14:49:55.407Z
8657355 8657355 20251130054029_6HNo4 UK0006 2025-12-01T14:34:12.307Z 2025-12-06T14:49:54.916Z
8657312 8657312 20251130053841_iaHjT UK0006 2025-12-01T14:34:04.315Z 2025-12-06T14:49:52.316Z
8657304 8657304 20251130053829_nOJs2 UK0006 2025-12-01T14:34:04.096Z 2025-12-06T14:49:51.870Z
8657275 8657275 20251130053805_KOaXS UK0006 2025-12-01T14:34:03.156Z 2025-12-06T14:49:50.937Z
8657220 8657220 20251130053540_Itax2 UK0006 2025-12-01T14:34:01.830Z 2025-12-06T14:49:46.081Z
8657107 8657107 20251130053042_lhFBN UK0006 2025-12-01T14:33:54.828Z 2025-12-06T14:49:44.898Z
8657004 8657004 20251130052408_RUpO5 UK0006 2025-12-01T14:33:51.846Z 2025-12-06T14:49:43.993Z
8656916 8656916 20251130051818_GEpgT UK0006 2025-12-01T14:33:49.194Z 2025-12-06T14:49:42.928Z
8656854 8656854 20251130051453_AeqmQ UK0006 2025-12-01T14:33:47.123Z 2025-12-06T14:49:42.463Z
8656536 8656536 20251130045851_ON0Gc UK0006 2025-12-01T14:28:44.074Z 2025-12-06T14:49:35.787Z
8656235 8656235 20251130044514_ngvLX UK0006 2025-12-01T14:28:13.087Z 2025-12-01T14:28:13.087Z
8656095 8656095 20251130043649_9rZbv UK0006 2025-12-01T14:28:03.027Z 2025-12-06T14:49:30.665Z
8655531 8655531 20251130040641_WGfTZ UK0006 2025-12-01T14:27:02.468Z 2025-12-06T14:49:24.975Z
8655427 8655427 20251130040215_I95H7 UK0006 2025-12-01T14:26:53.856Z 2025-12-06T14:49:15.979Z
8655216 8655216 20251130034916_Tx8xv UK0006 2025-12-01T14:26:39.797Z 2025-12-06T14:48:53.784Z
8655114 8655114 20251130034514_3lwWx UK0006 2025-12-01T14:26:24.054Z 2025-12-06T14:48:51.656Z
8655005 8655005 20251130034107_Lz1dP UK0006 2025-12-01T14:26:15.887Z 2025-12-06T14:48:50.803Z
8654896 8654896 20251130033833_ekNHY UK0006 2025-12-01T14:26:10.200Z 2025-12-06T14:48:49.979Z
8654826 8654826 20251130033532_tyI5U UK0006 2025-12-01T14:26:05.248Z 2025-12-06T14:48:48.979Z
8654740 8654740 20251130033016_kD0nF UK0006 2025-12-01T14:25:57.362Z 2025-12-06T14:48:47.697Z
8654544 8654544 20251130031954_ZDXcZ UK0006 2025-12-01T14:25:34.444Z 2025-12-06T14:48:43.983Z
8654486 8654486 20251130031817_S5Epf UK0006 2025-12-01T14:25:28.931Z 2025-12-06T14:48:43.200Z
8654404 8654404 20251130031446_JA7Ta UK0006 2025-12-01T14:25:23.200Z 2025-12-06T14:48:42.067Z
8654349 8654349 20251130031218_pGtiW UK0006 2025-12-01T14:25:11.337Z 2025-12-06T14:48:41.155Z
8654264 8654264 20251130030706_bvFzu UK0006 2025-12-01T14:25:03.706Z 2025-12-06T14:48:39.721Z
8654062 8654062 20251130025552_L2iKl UK0006 2025-12-01T14:24:48.351Z 2025-12-06T14:48:36.739Z
8654044 8654044 20251130025452_VIEVI UK0006 2025-12-01T14:24:46.674Z 2025-12-06T14:48:36.432Z
8653999 8653999 20251130025159_qoEtY UK0006 2025-12-01T14:24:44.379Z 2025-12-06T14:48:35.955Z
8653971 8653971 20251130025000_gAhit UK0006 2025-12-01T14:24:34.009Z 2025-12-06T14:48:35.318Z
8653900 8653900 20251130024805_vUJ1S UK0006 2025-12-01T14:24:28.615Z 2025-12-06T14:48:34.453Z
8653655 8653655 20251130023320_fb83X UK0006 2025-12-01T14:23:54.246Z 2025-12-06T14:48:24.706Z
8653309 8653309 20251130020935_LgAuF UK0006 2025-12-01T14:23:12.532Z 2025-12-06T14:47:55.086Z
8653248 8653248 20251130020508_ZVmWw UK0006 2025-12-01T14:23:07.832Z 2025-12-06T14:47:52.290Z
8653152 8653152 20251130020050_Gemqm UK0006 2025-12-01T14:23:00.736Z 2025-12-06T14:47:50.902Z
8652895 8652895 20251130014428_Mv12R UK0006 2025-12-01T14:22:29.521Z 2025-12-06T14:47:45.239Z
8652710 8652710 20251130012839_FiUaZ UK0006 2025-12-01T14:22:01.728Z 2025-12-06T14:47:41.432Z
8652597 8652597 20251130012250_ulDaA UK0006 2025-12-01T14:21:51.162Z 2025-12-06T14:47:40.035Z
8652472 8652472 20251130011218_UmldL UK0006 2025-12-01T14:21:29.034Z 2025-12-06T14:47:37.582Z
8652434 8652434 20251130010916_A8Fgs UK0006 2025-12-01T14:21:23.366Z 2025-12-06T14:47:37.059Z
8652298 8652298 20251130010234_6pcDW UK0006 2025-12-01T14:21:14.861Z 2025-12-06T14:47:34.797Z
8652277 8652277 20251130010139_lN2sk UK0006 2025-12-01T14:21:06.192Z 2025-12-06T14:47:33.864Z
8652200 8652200 20251130005516_PQ6dv UK0006 2025-12-01T14:20:54.885Z 2025-12-06T14:47:30.649Z
8652080 8652080 20251130004508_Mpllh UK0006 2025-12-01T14:20:41.078Z 2025-12-06T14:47:13.296Z
8650608 8650608 20251129205122_Ry1Ok UK0006 2025-12-01T14:16:43.423Z 2025-12-06T14:46:27.971Z
8650458 8650458 20251129202513_942aj UK0006 2025-12-01T14:16:16.242Z 2025-12-06T14:45:57.055Z
8650338 8650338 20251129195746_0niLL UK0006 2025-12-01T14:15:51.825Z 2025-12-06T14:45:54.623Z
8650137 8650137 20251129192858_F0TFJ UK0006 2025-12-01T14:15:13.783Z 2025-12-06T14:45:48.879Z
8650121 8650121 20251129192835_3abtN UK0006 2025-12-01T14:15:08.605Z 2025-12-06T14:45:48.683Z
8649856 8649856 20251129184038_7PAM6 UK0006 2025-12-01T14:14:09.286Z 2025-12-06T14:45:41.544Z
8649844 8649844 20251129183838_YK4Zz UK0006 2025-12-01T14:14:07.725Z 2025-12-06T14:45:41.282Z
8649487 8649487 20251129173302_v2wzq UK0006 2025-12-01T14:12:49.776Z 2025-12-06T14:45:30.732Z
8646058 8646058 20251129005655_qNARo UK0006 2025-11-30T14:25:07.217Z 2025-12-06T14:55:28.062Z
8643883 8643883 20251128183543_HIFuH UK0006 2025-11-30T14:20:46.908Z 2025-12-06T14:54:30.284Z
8643516 8643516 20251128180220_qUsM6 UK0006 2025-11-30T14:20:07.091Z 2025-12-06T14:53:50.670Z
8643430 8643430 20251128175527_TyO7q UK0006 2025-11-30T14:20:01.428Z 2025-12-06T14:53:49.539Z
8637691 8637691 20251128061517_U8iOf UK0006 2025-11-29T14:27:43.131Z 2025-12-06T15:04:03.003Z
8637609 8637609 20251128055952_3q2Ed UK0006 2025-11-29T14:27:37.701Z 2025-12-06T15:04:01.764Z
8637582 8637582 20251128055558_H61gU UK0006 2025-11-29T14:27:36.175Z 2025-12-06T15:04:01.499Z
8637569 8637569 20251128055316_PvkaH UK0006 2025-11-29T14:27:35.027Z 2025-12-06T15:04:01.248Z

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