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 = "UK0099" 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
8683195 8683195 20251203063843_LHuJd UK0099 2025-12-04T14:18:54.659Z 2025-12-05T14:23:10.986Z
8683052 8683052 20251203062220_pC3qx UK0099 2025-12-04T14:18:30.112Z 2025-12-05T14:23:06.140Z
8682867 8682867 20251203061134_2jYU8 UK0099 2025-12-04T14:18:10.224Z 2025-12-05T14:22:54.985Z
8682438 8682438 20251203053329_KhDVH UK0099 2025-12-04T14:17:11.861Z 2025-12-05T14:22:38.016Z
8682325 8682325 20251203051614_p2XKk UK0099 2025-12-04T14:16:48.709Z 2025-12-05T14:22:24.405Z
8682274 8682274 20251203050752_0Wo2H UK0099 2025-12-04T14:16:43.190Z 2025-12-05T14:22:22.632Z
8682240 8682240 20251203050714_b3AGy UK0099 2025-12-04T14:16:40.519Z 2025-12-05T14:22:20.412Z
8682172 8682172 20251203045635_icbRU UK0099 2025-12-04T14:16:32.791Z 2025-12-05T14:22:16.970Z
8682160 8682160 20251203045515_1ePVg UK0099 2025-12-04T14:16:31.821Z 2025-12-05T14:22:16.486Z
8682131 8682131 20251203045320_WsvPL UK0099 2025-12-04T14:16:29.342Z 2025-12-05T14:22:15.463Z
8682115 8682115 20251203045258_2MyOP UK0099 2025-12-04T14:16:28.347Z 2025-12-05T14:22:15.082Z
8682067 8682067 20251203044655_Fcjpy UK0099 2025-12-04T14:16:19.124Z 2025-12-05T14:22:13.404Z
8680763 8680763 20251203011317_u399P UK0099 2025-12-04T14:12:52.499Z 2025-12-05T14:20:59.922Z
8680734 8680734 20251203011133_qdCkw UK0099 2025-12-04T14:12:49.634Z 2025-12-05T14:20:58.627Z
8680570 8680570 20251203003045_aLtii UK0099 2025-12-04T14:12:22.393Z 2025-12-05T14:20:44.869Z
8680554 8680554 20251203002727_fqzs3 UK0099 2025-12-04T14:12:20.960Z 2025-12-05T14:20:44.359Z
8680459 8680459 20251203000421_rhkuc UK0099 2025-12-04T14:12:04.548Z 2025-12-05T14:20:39.410Z
8680452 8680452 20251203000318_aPx4w UK0099 2025-12-04T14:12:03.838Z 2025-12-05T14:20:39.102Z
8680439 8680439 20251202235926_sSsXW UK0099 2025-12-04T14:12:00.420Z 2025-12-05T14:20:38.519Z
8680381 8680381 20251202234155_43FIX UK0099 2025-12-04T14:11:54.240Z 2025-12-05T14:20:36.619Z
8680350 8680350 20251202233333_0YeSd UK0099 2025-12-04T14:11:50.109Z 2025-12-05T14:20:35.185Z
8680325 8680325 20251202232004_3kH6Q UK0099 2025-12-04T14:11:46.863Z 2025-12-05T14:20:34.013Z
8680317 8680317 20251202231914_AWSg0 UK0099 2025-12-04T14:11:41.644Z 2025-12-05T14:20:33.719Z
8680306 8680306 20251202230956_oXOkU UK0099 2025-12-04T14:11:39.674Z 2025-12-05T14:20:33.002Z
8680290 8680290 20251202230042_gdfH5 UK0099 2025-12-04T14:11:37.015Z 2025-12-05T14:20:31.961Z
8680275 8680275 20251202225601_htE7y UK0099 2025-12-04T14:11:33.248Z 2025-12-05T14:20:31.490Z
8680273 8680273 20251202225458_Rwe25 UK0099 2025-12-04T14:11:32.851Z 2025-12-05T14:20:31.312Z
8680235 8680235 20251202223909_H0Fvk UK0099 2025-12-04T14:11:28.218Z 2025-12-05T14:20:25.284Z
8680232 8680232 20251202223855_iuJkg UK0099 2025-12-04T14:11:27.833Z 2025-12-05T14:20:25.140Z
8680165 8680165 20251202215617_g3ZA0 UK0099 2025-12-04T14:11:19.618Z 2025-12-05T14:20:21.953Z
8679400 8679400 20251202200001_kErBJ UK0099 2025-12-04T14:09:44.406Z 2025-12-05T14:19:41.553Z
8676927 8676927 20251202063108_mb3Ug UK0099 2025-12-03T14:25:56.392Z 2025-12-05T14:29:16.273Z
8676898 8676898 20251202063049_mlP9C UK0099 2025-12-03T14:25:55.509Z 2025-12-05T14:29:15.874Z
8676839 8676839 20251202062756_Dpbv2 UK0099 2025-12-03T14:25:52.370Z 2025-12-05T14:29:14.581Z
8676732 8676732 20251202061911_JVPJx UK0099 2025-12-03T14:25:31.324Z 2025-12-05T14:29:11.993Z
8676586 8676586 20251202060414_X52Ag UK0099 2025-12-03T14:25:20.320Z 2025-12-05T14:29:08.330Z
8676458 8676458 20251202055315_g4Ivq UK0099 2025-12-03T14:25:13.099Z 2025-12-05T14:28:56.569Z
8676433 8676433 20251202055207_MmdIZ UK0099 2025-12-03T14:25:12.459Z 2025-12-05T14:28:56.341Z
8676158 8676158 20251202053907_eBwmt UK0099 2025-12-03T14:24:47.195Z 2025-12-05T14:28:49.702Z
8676133 8676133 20251202053845_NKTYF UK0099 2025-12-03T14:24:44.835Z 2025-12-05T14:28:49.378Z
8676113 8676113 20251202053707_eUJbc UK0099 2025-12-03T14:24:43.169Z 2025-12-05T14:28:48.961Z
8676099 8676099 20251202053701_ezluA UK0099 2025-12-03T14:24:42.234Z 2025-12-05T14:28:48.593Z
8675961 8675961 20251202052706_x3khz UK0099 2025-12-03T14:24:34.096Z 2025-12-05T14:28:45.316Z
8674329 8674329 20251202020238_WLTzp UK0099 2025-12-03T14:21:25.223Z 2025-12-05T14:27:36.633Z
8668018 8668018 20251130054054_VuUr7 UK0099 2025-12-02T14:41:30.503Z 2025-12-05T14:45:28.938Z
8667524 8667524 20251130020449_ROMOU UK0099 2025-12-02T14:38:47.327Z 2025-12-05T14:43:06.532Z
8662629 8662629 20251130191541_IoJBC UK0099 2025-12-02T14:16:02.903Z 2025-12-05T14:33:41.484Z
8658317 8658317 20251128051116_C3yZA UK0099 2025-12-01T14:53:12.502Z 2025-12-05T14:59:38.108Z
8658303 8658303 20251127205641_bRYge UK0099 2025-12-01T14:50:10.399Z 2025-12-05T14:56:20.267Z
8657778 8657778 20251130060809_7vVBo UK0099 2025-12-01T14:34:40.925Z 2025-12-05T14:45:36.703Z
8657763 8657763 20251130060625_Cpcoo UK0099 2025-12-01T14:34:40.261Z 2025-12-05T14:45:36.557Z
8657526 8657526 20251130055059_E4Wha UK0099 2025-12-01T14:34:32.057Z 2025-12-05T14:45:32.895Z
8657496 8657496 20251130054905_TpoYP UK0099 2025-12-01T14:34:30.936Z 2025-12-05T14:45:32.563Z
8657140 8657140 20251130053152_rraPH UK0099 2025-12-01T14:33:55.926Z 2025-12-05T14:45:25.906Z
8656912 8656912 20251130051728_2a1FR UK0099 2025-12-01T14:33:49.011Z 2025-12-05T14:45:23.242Z
8656881 8656881 20251130051512_5gFhx UK0099 2025-12-01T14:33:48.032Z 2025-12-05T14:45:22.925Z
8656775 8656775 20251130050920_oDi0z UK0099 2025-12-01T14:28:59.866Z 2025-12-05T14:45:21.023Z
8656678 8656678 20251130050601_MNGtd UK0099 2025-12-01T14:28:53.811Z 2025-12-05T14:45:19.930Z
8656555 8656555 20251130045901_ZCWIc UK0099 2025-12-01T14:28:44.629Z 2025-12-05T14:45:17.630Z
8656476 8656476 20251130045657_WEu37 UK0099 2025-12-01T14:28:40.091Z 2025-12-05T14:45:16.547Z
8656267 8656267 20251130044551_bJ6Hi UK0099 2025-12-01T14:28:14.787Z 2025-12-05T14:44:49.489Z
8656133 8656133 20251130043928_fnf9t UK0099 2025-12-01T14:28:05.579Z 2025-12-05T14:44:46.435Z
8655904 8655904 20251130042408_RUocl UK0099 2025-12-01T14:27:39.506Z 2025-12-05T14:44:40.968Z
8655849 8655849 20251130042046_TKwdn UK0099 2025-12-01T14:27:32.709Z 2025-12-05T14:44:39.932Z
8655833 8655833 20251130042032_6po1V UK0099 2025-12-01T14:27:31.976Z 2025-12-05T14:44:39.710Z
8655772 8655772 20251130041716_FBBEC UK0099 2025-12-01T14:27:27.599Z 2025-12-05T14:44:38.667Z
8655762 8655762 20251130041702_3hIt4 UK0099 2025-12-01T14:27:27.320Z 2025-12-05T14:44:38.480Z
8655667 8655667 20251130041056_A22B0 UK0099 2025-12-01T14:27:20.554Z 2025-12-05T14:44:36.780Z
8655548 8655548 20251130040648_Wzx2z UK0099 2025-12-01T14:27:02.794Z 2025-12-05T14:44:35.174Z
8655265 8655265 20251130035130_ooMXG UK0099 2025-12-01T14:26:42.378Z 2025-12-05T14:44:30.769Z
8655170 8655170 20251130034658_X93Rf UK0099 2025-12-01T14:26:37.001Z 2025-12-05T14:44:29.364Z
8655141 8655141 20251130034542_Sav5u UK0099 2025-12-01T14:26:27.106Z 2025-12-05T14:44:28.781Z
8654800 8654800 20251130033318_7YSAb UK0099 2025-12-01T14:26:03.066Z 2025-12-05T14:44:24.022Z
8654770 8654770 20251130033222_o6RNp UK0099 2025-12-01T14:25:59.666Z 2025-12-05T14:44:23.337Z
8654514 8654514 20251130031904_hLvpE UK0099 2025-12-01T14:25:32.341Z 2025-12-05T14:44:08.054Z
8654386 8654386 20251130031358_qnYxp UK0099 2025-12-01T14:25:21.570Z 2025-12-05T14:43:54.815Z
8654342 8654342 20251130031127_IA0Ix UK0099 2025-12-01T14:25:10.006Z 2025-12-05T14:43:53.999Z
8653960 8653960 20251130024919_q6qbZ UK0099 2025-12-01T14:24:32.938Z 2025-12-05T14:43:43.518Z
8653872 8653872 20251130024512_aP2Fx UK0099 2025-12-01T14:24:24.380Z 2025-12-05T14:43:41.801Z
8653726 8653726 20251130023759_RtHpr UK0099 2025-12-01T14:24:07.737Z 2025-12-05T14:43:38.523Z
8653587 8653587 20251130022733_6F331 UK0099 2025-12-01T14:23:44.398Z 2025-12-05T14:43:35.673Z
8653475 8653475 20251130021800_YOCk4 UK0099 2025-12-01T14:23:33.453Z 2025-12-05T14:43:32.302Z
8653379 8653379 20251130021317_HXdn0 UK0099 2025-12-01T14:23:18.998Z 2025-12-05T14:43:30.205Z
8653363 8653363 20251130021224_k2NR8 UK0099 2025-12-01T14:23:17.938Z 2025-12-05T14:43:29.992Z
8653274 8653274 20251130020509_Ufqfg UK0099 2025-12-01T14:23:08.572Z 2025-12-05T14:43:06.958Z
8653243 8653243 20251130020447_2B8Ps UK0099 2025-12-01T14:23:07.362Z 2025-12-05T14:43:06.444Z
8653126 8653126 20251130015922_l3bSW UK0099 2025-12-01T14:22:51.679Z 2025-12-05T14:43:04.283Z
8653091 8653091 20251130015540_3dMTR UK0099 2025-12-01T14:22:46.007Z 2025-12-05T14:43:03.177Z
8653076 8653076 20251130015456_v1ang UK0099 2025-12-01T14:22:45.254Z 2025-12-05T14:43:02.791Z
8653011 8653011 20251130015056_uzveL UK0099 2025-12-01T14:22:38.430Z 2025-12-05T14:42:59.070Z
8652983 8652983 20251130014859_jkAJM UK0099 2025-12-01T14:22:36.502Z 2025-12-05T14:42:58.659Z
8652911 8652911 20251130014512_xoj6p UK0099 2025-12-01T14:22:30.451Z 2025-12-05T14:42:57.345Z
8652821 8652821 20251130013640_gvUad UK0099 2025-12-01T14:22:10.334Z 2025-12-05T14:42:53.590Z
8652781 8652781 20251130013433_387aK UK0099 2025-12-01T14:22:07.102Z 2025-12-05T14:42:52.410Z
8652730 8652730 20251130012853_kP2d2 UK0099 2025-12-01T14:22:02.119Z 2025-12-05T14:42:50.873Z
8652636 8652636 20251130012534_3vcfP UK0099 2025-12-01T14:21:53.890Z 2025-12-05T14:42:49.127Z
8652565 8652565 20251130012106_yu2iw UK0099 2025-12-01T14:21:41.541Z 2025-12-05T14:42:47.935Z
8649659 8649659 20251129180343_G79as UK0099 2025-12-01T14:13:26.312Z 2025-12-05T14:40:15.742Z
8649558 8649558 20251129174721_KgWxx UK0099 2025-12-01T14:13:03.217Z 2025-12-05T14:40:13.009Z
8649415 8649415 20251129172229_a82I3 UK0099 2025-12-01T14:12:28.430Z 2025-12-05T14:40:07.582Z

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