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

7,349 rows where station_code = "UK0092" 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
9273480 9273480 20260128062843_xx3tM UK0092 2026-01-29T14:29:55.253Z 2026-01-29T14:30:25.821Z
9273377 9273377 20260128055633_ht5ax UK0092 2026-01-29T14:29:29.845Z 2026-01-29T14:30:25.797Z
9273333 9273333 20260128054155_kRwkH UK0092 2026-01-29T14:29:21.600Z 2026-01-29T14:30:25.789Z
9273308 9273308 20260128053654_Z7VXr UK0092 2026-01-29T14:29:18.628Z 2026-01-29T14:30:25.785Z
9273272 9273272 20260128052118_LZOzb UK0092 2026-01-29T14:29:15.189Z 2026-01-29T14:30:25.780Z
9273223 9273223 20260128051033_lXpw9 UK0092 2026-01-29T14:29:02.430Z 2026-01-29T14:30:25.771Z
9273177 9273177 20260128050306_eJ2MI UK0092 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9273169 9273169 20260128050254_212R0 UK0092 2026-01-29T14:28:54.160Z 2026-01-29T14:30:25.763Z
9273147 9273147 20260128045206_syodL UK0092 2026-01-29T14:28:51.251Z 2026-01-29T14:30:25.759Z
9273083 9273083 20260128043246_DQmhn UK0092 2026-01-29T14:28:42.749Z 2026-01-29T14:30:25.746Z
9273068 9273068 20260128043109_sYCQ2 UK0092 2026-01-29T14:28:41.085Z 2026-01-29T14:30:25.744Z
9273059 9273059 20260128043057_g9png UK0092 2026-01-29T14:28:39.966Z 2026-01-29T14:30:25.743Z
9273033 9273033 20260128042708_CMtUt UK0092 2026-01-29T14:28:31.559Z 2026-01-29T14:30:25.739Z
9273003 9273003 20260128041935_Wgr7Q UK0092 2026-01-29T14:28:24.603Z 2026-01-29T14:30:25.733Z
9272892 9272892 20260128035839_Ntba5 UK0092 2026-01-29T14:28:12.984Z 2026-01-29T14:30:25.704Z
9272815 9272815 20260128034033_SIxrx UK0092 2026-01-29T14:27:53.122Z 2026-01-29T14:30:25.566Z
9272701 9272701 20260128030822_ixwzV UK0092 2026-01-29T14:27:35.131Z 2026-01-29T14:30:25.440Z
9272603 9272603 20260128024815_s7qkO UK0092 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.382Z
9272442 9272442 20260128020653_lxFJ3 UK0092 2026-01-29T14:26:39.584Z 2026-01-29T14:30:25.346Z
9272342 9272342 20260128014119_CQ1NT UK0092 2026-01-29T14:26:28.788Z 2026-01-29T14:30:25.333Z
9272158 9272158 20260128002724_0v5np UK0092 2026-01-29T14:25:49.139Z 2026-01-29T14:30:25.291Z
9272083 9272083 20260127235419_EygzZ UK0092 2026-01-29T14:25:32.158Z 2026-01-29T14:30:25.277Z
9256267 9256267 20260124063312_ypWlb UK0092 2026-01-25T14:16:23.152Z 2026-01-29T14:48:33.506Z
9256065 9256065 20260124054826_r82EU UK0092 2026-01-25T14:15:41.022Z 2026-01-29T14:48:20.910Z
9256056 9256056 20260124054810_GMJJ1 UK0092 2026-01-25T14:15:40.424Z 2026-01-29T14:48:20.736Z
9255923 9255923 20260124052111_248V7 UK0092 2026-01-25T14:15:09.732Z 2026-01-29T14:48:08.186Z
9255084 9255084 20260124004504_pQKwC UK0092 2026-01-25T14:11:50.605Z 2026-01-29T14:47:01.661Z
9255042 9255042 20260124003226_ZgOma UK0092 2026-01-25T14:11:43.401Z 2026-01-29T14:47:00.453Z
9254977 9254977 20260123234545_n23pp UK0092 2026-01-25T14:11:31.029Z 2026-01-29T14:46:58.129Z
9254967 9254967 20260123233746_wjmkR UK0092 2026-01-25T14:11:29.240Z 2026-01-29T14:46:57.699Z
9254890 9254890 20260123221846_8i862 UK0092 2026-01-25T14:11:03.524Z 2026-01-29T14:46:53.788Z
9254878 9254878 20260123221215_nqI3U UK0092 2026-01-25T14:11:01.223Z 2026-01-29T14:46:53.213Z
9252246 9252246 20260123015714_Ov0k4 UK0092 2026-01-24T14:14:50.638Z 2026-01-29T14:52:41.578Z
9244077 9244077 20260121060734_JFiYO UK0092 2026-01-22T14:24:05.365Z 2026-01-29T15:05:50.709Z
9244071 9244071 20260121060734_bMF2f UK0092 2026-01-22T14:24:05.015Z 2026-01-29T15:05:50.629Z
9229558 9229558 20260119020131_O4gnG UK0092 2026-01-20T14:23:09.244Z 2026-01-27T15:03:42.338Z
9218929 9218929 20260117063725_qDaYI UK0092 2026-01-18T14:14:16.646Z 2026-01-25T14:58:55.891Z
9218707 9218707 20260117052324_8aPR1 UK0092 2026-01-18T14:13:19.037Z 2026-01-25T14:58:36.161Z
9214030 9214030 20260116052318_lvFr9 UK0092 2026-01-17T14:19:43.312Z 2026-01-24T15:12:58.692Z
9213617 9213617 20260116040840_BHrUo UK0092 2026-01-17T14:17:47.186Z 2026-01-24T15:12:25.235Z
9213162 9213162 20260116022912_YcLsb UK0092 2026-01-17T14:15:43.823Z 2026-01-24T15:11:47.565Z
9213144 9213144 20260116022505_bmBhN UK0092 2026-01-17T14:15:38.395Z 2026-01-24T15:11:46.649Z
9213053 9213053 20260116020211_Zqa2e UK0092 2026-01-17T14:15:11.525Z 2026-01-24T15:11:38.828Z
9212977 9212977 20260116014530_IcYfr UK0092 2026-01-17T14:14:48.577Z 2026-01-24T15:11:36.147Z
9212967 9212967 20260116014331_HGkL3 UK0092 2026-01-17T14:14:45.451Z 2026-01-24T15:11:35.812Z
9212897 9212897 20260116013607_3WcFe UK0092 2026-01-17T14:14:29.835Z 2026-01-24T15:11:33.239Z
9207664 9207664 20260115024024_3C3fJ UK0092 2026-01-16T14:09:36.082Z 2026-01-22T15:03:29.450Z
9207659 9207659 20260115024024_xeJ76 UK0092 2026-01-16T14:09:35.472Z 2026-01-22T15:03:29.371Z
9204174 9204174 20260114061351_rS9rc UK0092 2026-01-15T14:26:36.428Z 2026-01-22T15:10:21.826Z
9204094 9204094 20260114060620_3xRAY UK0092 2026-01-15T14:26:23.073Z 2026-01-22T15:10:17.812Z
9203798 9203798 20260114053755_0mbQ3 UK0092 2026-01-15T14:25:24.539Z 2026-01-22T15:10:13.617Z
9203783 9203783 20260114053712_X80oV UK0092 2026-01-15T14:25:23.375Z 2026-01-22T15:10:13.423Z
9203738 9203738 20260114053336_O90hl UK0092 2026-01-15T14:25:17.569Z 2026-01-22T15:10:12.821Z
9202855 9202855 20260114041313_TOge1 UK0092 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202753 9202753 20260114040731_o82KS UK0092 2026-01-15T14:22:18.057Z 2026-01-22T15:09:39.158Z
9202180 9202180 20260114032201_e54Vx UK0092 2026-01-15T14:20:39.005Z 2026-01-22T15:09:14.449Z
9202134 9202134 20260114032010_z39Qj UK0092 2026-01-15T14:20:34.559Z 2026-01-22T15:09:13.968Z
9202013 9202013 20260114031002_0HwCL UK0092 2026-01-15T14:20:14.499Z 2026-01-22T15:09:12.097Z
9201879 9201879 20260114030441_B482B UK0092 2026-01-15T14:20:04.325Z 2026-01-22T15:09:11.047Z
9201601 9201601 20260114023423_SvAGS UK0092 2026-01-15T14:19:09.646Z 2026-01-22T15:09:06.578Z
9195501 9195501 20260113013711_jJKaz UK0092 2026-01-14T14:13:37.233Z 2026-01-21T15:04:41.475Z
9195481 9195481 20260113013410_VRFio UK0092 2026-01-14T14:13:31.347Z 2026-01-21T15:04:41.198Z
9195200 9195200 20260113003545_CU43u UK0092 2026-01-14T14:12:22.152Z 2026-01-21T15:04:37.472Z
9194948 9194948 20260112234038_n0Si9 UK0092 2026-01-14T14:11:25.571Z 2026-01-21T15:04:34.306Z
9194748 9194748 20260112223006_c5PcY UK0092 2026-01-14T14:10:30.404Z 2026-01-21T15:04:20.532Z
9166592 9166592 20260107192343_uL2Nc UK0092 2026-01-09T14:03:58.777Z 2026-01-16T15:10:05.229Z
9166509 9166509 20260107185624_OWlgc UK0092 2026-01-09T14:03:34.804Z 2026-01-16T15:09:59.111Z
9166306 9166306 20260107174408_ZUEX6 UK0092 2026-01-09T14:02:37.205Z 2026-01-16T15:09:39.488Z
9159139 9159139 20260106015249_p9fJ3 UK0092 2026-01-07T14:08:27.240Z 2026-01-13T15:08:09.834Z
9159104 9159104 20260106014311_qTCK6 UK0092 2026-01-07T14:08:17.766Z 2026-01-13T15:08:07.082Z
9159020 9159020 20260106012226_WDOcJ UK0092 2026-01-07T14:08:01.176Z 2026-01-13T15:07:57.204Z
9158997 9158997 20260106012001_7E2xE UK0092 2026-01-07T14:07:56.577Z 2026-01-13T15:07:56.467Z
9158726 9158726 20260106001024_PaoBj UK0092 2026-01-07T14:07:05.622Z 2026-01-13T15:07:44.151Z
9158464 9158464 20260105223305_JxoRI UK0092 2026-01-07T14:06:10.486Z 2026-01-13T15:07:23.487Z
9158441 9158441 20260105222853_E10r3 UK0092 2026-01-07T14:06:06.838Z 2026-01-13T15:07:22.334Z
9158404 9158404 20260105221443_68yLj UK0092 2026-01-07T14:05:56.470Z 2026-01-13T15:07:20.469Z
9150136 9150136 20260105010919_4HI25 UK0092 2026-01-06T14:08:44.321Z 2026-01-13T15:13:06.726Z
9150050 9150050 20260105004038_qEqi6 UK0092 2026-01-06T14:08:21.322Z 2026-01-13T15:12:53.704Z
9149936 9149936 20260105001523_X1QUP UK0092 2026-01-06T14:07:53.119Z 2026-01-13T15:12:46.305Z
9149800 9149800 20260104233829_hp8MO UK0092 2026-01-06T14:07:13.955Z 2026-01-13T15:12:40.088Z
9149585 9149585 20260104220810_u3NbS UK0092 2026-01-06T14:06:11.850Z 2026-01-13T15:12:19.526Z
9148315 9148315 20260103173927_7TJGN UK0092 2026-01-05T14:30:24.316Z 2026-01-10T15:04:25.567Z
9148162 9148162 20260103173252_QGOtM UK0092 2026-01-05T14:30:19.473Z 2026-01-10T15:04:18.753Z
9148006 9148006 20260103172720_GKqW3 UK0092 2026-01-05T14:30:05.258Z 2026-01-10T15:04:12.144Z
9141987 9141987 20260104011650_M0oCu UK0092 2026-01-05T14:15:25.518Z 2026-01-12T15:05:16.856Z
9141159 9141159 20260104004459_noU9T UK0092 2026-01-05T14:14:16.049Z 2026-01-12T15:04:42.284Z
9140835 9140835 20260104003207_0Bi9I UK0092 2026-01-05T14:13:41.715Z 2026-01-12T15:04:32.328Z
9140495 9140495 20260104001810_wWZRR UK0092 2026-01-05T14:13:13.759Z 2026-01-12T15:04:22.729Z
9140414 9140414 20260104001507_ajJo1 UK0092 2026-01-05T14:13:07.544Z 2026-01-12T15:04:09.617Z
9140382 9140382 20260104001342_PoCOF UK0092 2026-01-05T14:13:04.974Z 2026-01-12T15:04:08.347Z
9140278 9140278 20260104000834_SP01r UK0092 2026-01-05T14:12:58.409Z 2026-01-12T15:04:04.169Z
9140197 9140197 20260104000259_izPKo UK0092 2026-01-05T14:12:41.102Z 2026-01-12T15:04:01.478Z
9139961 9139961 20260103235228_OzxzO UK0092 2026-01-05T14:12:19.142Z 2026-01-12T15:03:54.489Z
9139806 9139806 20260103234753_OkkS2 UK0092 2026-01-05T14:12:13.345Z 2026-01-12T15:03:51.619Z
9139399 9139399 20260103233105_hOy40 UK0092 2026-01-05T14:11:36.868Z 2026-01-12T15:03:27.355Z
9139272 9139272 20260103232635_laevq UK0092 2026-01-05T14:11:27.045Z 2026-01-12T15:03:25.087Z
9139246 9139246 20260103232355_EdZNH UK0092 2026-01-05T14:11:25.168Z 2026-01-12T15:03:24.677Z
9139236 9139236 20260103232320_fe2mJ UK0092 2026-01-05T14:11:22.573Z 2026-01-12T15:03:24.385Z
9139139 9139139 20260103231511_1eBwd UK0092 2026-01-05T14:11:17.373Z 2026-01-12T15:03:21.727Z
9138383 9138383 20260103222448_J7QAb UK0092 2026-01-05T14:09:54.179Z 2026-01-12T15:02:48.179Z

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