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

4,241 rows where station_code = "UK009Q" 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
8683244 8683244 20251203064422_1m2iZ UK009Q 2025-12-04T14:18:59.270Z 2025-12-06T14:29:47.373Z
8683187 8683187 20251203063833_m7KQH UK009Q 2025-12-04T14:18:53.700Z 2025-12-06T14:29:44.703Z
8682511 8682511 20251203054155_t7uJe UK009Q 2025-12-04T14:17:19.710Z 2025-12-06T14:29:12.509Z
8682403 8682403 20251203052456_dRBy2 UK009Q 2025-12-04T14:17:06.167Z 2025-12-06T14:28:58.798Z
8682341 8682341 20251203051801_rnFSs UK009Q 2025-12-04T14:16:50.066Z 2025-12-06T14:28:55.277Z
8682203 8682203 20251203050103_4e3ym UK009Q 2025-12-04T14:16:36.491Z 2025-12-06T14:28:49.754Z
8681838 8681838 20251203041425_5xryK UK009Q 2025-12-04T14:15:45.799Z 2025-12-06T14:28:33.344Z
8681684 8681684 20251203034749_AzSvB UK009Q 2025-12-04T14:15:15.064Z 2025-12-06T14:28:25.114Z
8681619 8681619 20251203033229_ZJrzu UK009Q 2025-12-04T14:15:09.454Z 2025-12-06T14:28:21.175Z
8681553 8681553 20251203032542_IhDcd UK009Q 2025-12-04T14:15:03.217Z 2025-12-06T14:28:18.393Z
8681539 8681539 20251203032352_kqzeZ UK009Q 2025-12-04T14:15:01.311Z 2025-12-06T14:28:17.627Z
8681399 8681399 20251203030403_15GoZ UK009Q 2025-12-04T14:14:38.478Z 2025-12-06T14:28:05.779Z
8681324 8681324 20251203025717_IdU9c UK009Q 2025-12-04T14:14:30.192Z 2025-12-06T14:28:03.282Z
8681283 8681283 20251203025306_yWXUL UK009Q 2025-12-04T14:14:15.504Z 2025-12-06T14:27:59.243Z
8681118 8681118 20251203022601_EYqPl UK009Q 2025-12-04T14:13:53.581Z 2025-12-06T14:27:50.176Z
8680470 8680470 20251203000813_UqBBH UK009Q 2025-12-04T14:12:05.819Z 2025-12-06T14:27:13.098Z
8676941 8676941 20251202063145_URdnY UK009Q 2025-12-03T14:25:57.105Z 2025-12-06T14:35:31.297Z
8676893 8676893 20251202063043_UNkW2 UK009Q 2025-12-03T14:25:55.324Z 2025-12-06T14:35:30.280Z
8676643 8676643 20251202060936_YuXV3 UK009Q 2025-12-03T14:25:23.751Z 2025-12-06T14:35:25.764Z
8676637 8676637 20251202060936_lqRjN UK009Q 2025-12-03T14:25:23.303Z 2025-12-06T14:35:25.483Z
8676569 8676569 20251202060239_hUhRU UK009Q 2025-12-03T14:25:19.597Z 2025-12-06T14:35:23.952Z
8658165 8658165 20251130070514_pw6xh UK009Q 2025-12-01T14:35:05.519Z 2025-12-06T14:50:29.268Z
8658147 8658147 20251130065245_GngyR UK009Q 2025-12-01T14:34:58.489Z 2025-12-06T14:50:27.882Z
8657448 8657448 20251130054637_g7tM2 UK009Q 2025-12-01T14:34:26.928Z 2025-12-06T14:50:01.607Z
8648677 8648677 20251128065821_hRe6x UK009Q 2025-11-30T14:38:18.752Z 2025-12-06T15:04:05.101Z
8648137 8648137 20251129064521_B0eET UK009Q 2025-11-30T14:29:39.907Z 2025-12-06T14:57:15.083Z
8648027 8648027 20251129062616_3dvLJ UK009Q 2025-11-30T14:29:29.637Z 2025-12-06T14:57:07.085Z
8647816 8647816 20251129053713_9u0Dq UK009Q 2025-11-30T14:29:01.354Z 2025-12-06T14:56:48.479Z
8647769 8647769 20251129052252_Kc2g0 UK009Q 2025-11-30T14:28:52.644Z 2025-12-06T14:56:46.846Z
8647764 8647764 20251129052122_y3GcL UK009Q 2025-11-30T14:28:52.255Z 2025-12-06T14:56:46.779Z
8647757 8647757 20251129052030_v4uAE UK009Q 2025-11-30T14:28:51.850Z 2025-12-06T14:56:46.544Z
8647710 8647710 20251129051331_uTGQ5 UK009Q 2025-11-30T14:28:47.366Z 2025-12-06T14:56:44.793Z
8647708 8647708 20251129051225_T82z7 UK009Q 2025-11-30T14:28:46.777Z 2025-12-06T14:56:44.773Z
8647660 8647660 20251129050254_iCuEH UK009Q 2025-11-30T14:28:42.525Z 2025-12-06T14:56:42.656Z
8647622 8647622 20251129045838_Q8Okj UK009Q 2025-11-30T14:28:39.800Z 2025-12-06T14:56:42.151Z
8647584 8647584 20251129045306_rQGmM UK009Q 2025-11-30T14:28:37.020Z 2025-12-06T14:56:41.629Z
8647568 8647568 20251129045200_HGa8P UK009Q 2025-11-30T14:28:36.033Z 2025-12-06T14:56:41.353Z
8647452 8647452 20251129043758_Pe9oD UK009Q 2025-11-30T14:28:26.761Z 2025-12-06T14:56:39.322Z
8647293 8647293 20251129041610_z0klX UK009Q 2025-11-30T14:27:56.956Z 2025-12-06T14:56:36.033Z
8645470 8645470 20251128222013_9x2Y9 UK009Q 2025-11-30T14:23:46.951Z 2025-12-06T14:54:58.716Z
8645409 8645409 20251128220045_rf20g UK009Q 2025-11-30T14:23:41.114Z 2025-12-06T14:54:56.179Z
8637471 8637471 20251128054311_zJzHv UK009Q 2025-11-29T14:27:28.903Z 2025-12-06T15:04:00.367Z
8637389 8637389 20251128053524_AxYB6 UK009Q 2025-11-29T14:27:11.665Z 2025-12-06T15:03:59.552Z
8636270 8636270 20251128033016_Hcjfm UK009Q 2025-11-29T14:25:19.478Z 2025-12-06T15:03:02.184Z
8635601 8635601 20251128023101_zFIQ2 UK009Q 2025-11-29T14:23:55.493Z 2025-12-06T15:02:47.119Z
8635576 8635576 20251128022743_nug90 UK009Q 2025-11-29T14:23:43.864Z 2025-12-06T15:02:46.811Z
8635511 8635511 20251128022036_vtBF0 UK009Q 2025-11-29T14:23:32.060Z 2025-12-06T15:02:45.723Z
8635506 8635506 20251128021954_bJGE8 UK009Q 2025-11-29T14:23:31.037Z 2025-12-06T15:02:45.563Z
8634961 8634961 20251128012912_vM2wc UK009Q 2025-11-29T14:22:16.841Z 2025-12-06T15:02:38.312Z
8634857 8634857 20251128012405_ik2KT UK009Q 2025-11-29T14:22:07.738Z 2025-12-06T15:02:36.697Z
8634793 8634793 20251128011923_6Mm61 UK009Q 2025-11-29T14:22:03.941Z 2025-12-06T15:02:36.024Z
8632159 8632159 20251127203656_d3t4v UK009Q 2025-11-29T14:17:04.185Z 2025-12-06T15:00:56.239Z
8631871 8631871 20251127200917_kDT8c UK009Q 2025-11-29T14:16:30.186Z 2025-12-06T15:00:45.147Z
8631744 8631744 20251127195638_El3Qv UK009Q 2025-11-29T14:16:20.914Z 2025-12-06T15:00:40.519Z
8631484 8631484 20251127191342_9t0hA UK009Q 2025-11-29T14:15:35.602Z 2025-12-06T15:00:14.266Z
8630882 8630882 20251127174056_Hlnnt UK009Q 2025-11-29T14:13:55.564Z 2025-12-06T14:59:40.467Z
8613308 8613308 20251126031348_zeYqd UK009Q 2025-11-27T14:25:37.424Z 2025-12-04T15:09:39.665Z
8611927 8611927 20251126020807_YnJaz UK009Q 2025-11-27T14:23:04.273Z 2025-12-04T15:09:25.547Z
8611626 8611626 20251126015343_flc72 UK009Q 2025-11-27T14:22:22.784Z 2025-12-04T15:09:22.961Z
8611421 8611421 20251126014229_crotZ UK009Q 2025-11-27T14:22:07.569Z 2025-12-04T15:09:12.623Z
8611336 8611336 20251126013739_bCwaQ UK009Q 2025-11-27T14:21:52.580Z 2025-12-04T15:09:10.146Z
8611238 8611238 20251126013249_73s22 UK009Q 2025-11-27T14:21:42.724Z 2025-12-04T15:08:59.648Z
8610630 8610630 20251126010014_6PkIK UK009Q 2025-11-27T14:20:27.847Z 2025-12-04T15:08:21.433Z
8610320 8610320 20251126003828_57H6b UK009Q 2025-11-27T14:19:45.054Z 2025-12-04T15:08:04.133Z
8609824 8609824 20251126000834_7Fka4 UK009Q 2025-11-27T14:18:58.417Z 2025-12-04T15:07:57.598Z
8609514 8609514 20251125234632_76s6I UK009Q 2025-11-27T14:18:17.743Z 2025-12-04T15:07:54.899Z
8606878 8606878 20251125195034_ZN7p7 UK009Q 2025-11-27T14:11:41.268Z 2025-12-04T15:06:51.675Z
8603851 8603851 20251125065514_V3dI2 UK009Q 2025-11-26T14:28:18.976Z 2025-12-02T15:09:37.879Z
8603849 8603849 20251125065501_NzXKX UK009Q 2025-11-26T14:28:18.832Z 2025-12-02T15:09:37.860Z
8603734 8603734 20251125063148_ZuV3q UK009Q 2025-11-26T14:27:45.249Z 2025-12-02T15:09:37.009Z
8603564 8603564 20251125061500_yP8jG UK009Q 2025-11-26T14:27:31.494Z 2025-12-02T15:09:36.269Z
8603530 8603530 20251125061228_eiX2t UK009Q 2025-11-26T14:27:29.815Z 2025-12-02T15:09:36.136Z
8603175 8603175 20251125054801_Hwjmj UK009Q 2025-11-26T14:27:12.008Z 2025-12-02T15:09:34.670Z
8602735 8602735 20251125051935_xSaw3 UK009Q 2025-11-26T14:26:17.265Z 2025-12-02T15:09:32.526Z
8602660 8602660 20251125051151_QXkkY UK009Q 2025-11-26T14:26:13.094Z 2025-12-02T15:09:31.996Z
8602481 8602481 20251125045902_EqrNL UK009Q 2025-11-26T14:26:03.146Z 2025-12-02T15:09:31.153Z
8602432 8602432 20251125045547_IeT04 UK009Q 2025-11-26T14:25:45.814Z 2025-12-02T15:09:30.897Z
8602376 8602376 20251125045054_e96d6 UK009Q 2025-11-26T14:25:35.990Z 2025-12-02T15:09:30.715Z
8602355 8602355 20251125044944_JuTzu UK009Q 2025-11-26T14:25:34.955Z 2025-12-02T15:09:30.596Z
8602289 8602289 20251125044613_Su93n UK009Q 2025-11-26T14:25:29.831Z 2025-12-02T15:09:30.259Z
8602285 8602285 20251125044603_w2csR UK009Q 2025-11-26T14:25:29.450Z 2025-12-02T15:09:30.219Z
8601974 8601974 20251125042935_BBvdL UK009Q 2025-11-26T14:25:14.830Z 2025-12-02T15:09:29.030Z
8601822 8601822 20251125041932_3HkkO UK009Q 2025-11-26T14:24:47.472Z 2025-12-02T15:09:25.881Z
8601780 8601780 20251125041533_p3siR UK009Q 2025-11-26T14:24:42.438Z 2025-12-02T15:09:24.454Z
8600841 8600841 20251125031920_8dG2v UK009Q 2025-11-26T14:23:02.344Z 2025-12-02T15:08:51.713Z
8599927 8599927 20251125023028_s0jjW UK009Q 2025-11-26T14:21:40.431Z 2025-12-02T15:08:32.734Z
8599716 8599716 20251125022046_pV3RP UK009Q 2025-11-26T14:21:26.058Z 2025-12-02T15:08:31.696Z
8599624 8599624 20251125021245_hiYdu UK009Q 2025-11-26T14:21:20.020Z 2025-12-02T15:08:30.608Z
8599622 8599622 20251125021245_WJOfd UK009Q 2025-11-26T14:21:19.841Z 2025-12-02T15:08:30.606Z
8599235 8599235 20251125015526_8FnkI UK009Q 2025-11-26T14:20:41.741Z 2025-12-02T15:08:21.760Z
8599172 8599172 20251125015116_DIuFH UK009Q 2025-11-26T14:20:37.454Z 2025-12-02T15:08:20.525Z
8599081 8599081 20251125014354_hrg4l UK009Q 2025-11-26T14:20:17.360Z 2025-12-02T15:08:19.726Z
8598662 8598662 20251125011530_92YN3 UK009Q 2025-11-26T14:19:24.618Z 2025-12-02T15:08:01.508Z
8598452 8598452 20251125005748_wusBr UK009Q 2025-11-26T14:19:08.018Z 2025-12-02T15:07:54.668Z
8598392 8598392 20251125005402_w39dM UK009Q 2025-11-26T14:18:44.492Z 2025-12-02T15:07:53.526Z
8598224 8598224 20251125004355_KKVTT UK009Q 2025-11-26T14:18:28.434Z 2025-12-02T15:07:48.785Z
8597786 8597786 20251125001155_RXrdm UK009Q 2025-11-26T14:17:41.937Z 2025-12-02T15:07:40.697Z
8597286 8597286 20251124232210_ZO5Db UK009Q 2025-11-26T14:16:29.255Z 2025-12-02T15:07:27.929Z
8597260 8597260 20251124231820_AgM4j UK009Q 2025-11-26T14:16:27.432Z 2025-12-02T15:07:27.750Z
8596819 8596819 20251124221252_w2JkK UK009Q 2025-11-26T14:15:23.168Z 2025-12-02T15:07:15.091Z

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