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,429 rows where station_code = "UK000Y" 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
8674993 8674993 20251202035043_n0KM4 UK000Y 2025-12-03T14:22:49.061Z 2025-12-05T14:28:08.687Z
8674736 8674736 20251202031855_2oxQh UK000Y 2025-12-03T14:22:16.799Z 2025-12-05T14:28:01.611Z
8674518 8674518 20251202024058_7TYTd UK000Y 2025-12-03T14:21:43.942Z 2025-12-05T14:27:52.212Z
8674427 8674427 20251202022413_ZcjRh UK000Y 2025-12-03T14:21:37.697Z 2025-12-05T14:27:41.440Z
8674359 8674359 20251202021100_4yO6i UK000Y 2025-12-03T14:21:32.191Z 2025-12-05T14:27:39.281Z
8674325 8674325 20251202020238_WLTzp UK000Y 2025-12-03T14:21:25.222Z 2025-12-05T14:27:36.633Z
8674258 8674258 20251202015509_tper3 UK000Y 2025-12-03T14:21:18.177Z 2025-12-05T14:27:34.154Z
8674205 8674205 20251202014542_VnPly UK000Y 2025-12-03T14:21:09.469Z 2025-12-05T14:27:32.313Z
8674182 8674182 20251202014411_jBvNF UK000Y 2025-12-03T14:21:08.063Z 2025-12-05T14:27:31.648Z
8674164 8674164 20251202014106_MvtLc UK000Y 2025-12-03T14:21:06.695Z 2025-12-05T14:27:31.231Z
8674131 8674131 20251202013226_PMQ9b UK000Y 2025-12-03T14:20:58.945Z 2025-12-05T14:27:29.994Z
8674097 8674097 20251202012838_GGdn9 UK000Y 2025-12-03T14:20:56.033Z 2025-12-05T14:27:28.713Z
8674016 8674016 20251202010905_4GH5q UK000Y 2025-12-03T14:20:45.073Z 2025-12-05T14:27:26.310Z
8673960 8673960 20251202004859_H5sJb UK000Y 2025-12-03T14:20:26.550Z 2025-12-05T14:27:24.124Z
8673907 8673907 20251202002450_JdMxV UK000Y 2025-12-03T14:20:17.309Z 2025-12-05T14:27:22.556Z
8673871 8673871 20251202001019_7X0ts UK000Y 2025-12-03T14:20:13.334Z 2025-12-05T14:27:20.970Z
8658619 8658619 20251126060915_LTkal UK000Y 2025-12-01T15:05:29.908Z 2025-12-04T15:11:40.893Z
8658609 8658609 20251126054644_hwbJO UK000Y 2025-12-01T15:05:06.338Z 2025-12-04T15:11:36.951Z
8658602 8658602 20251126052848_rxgVR UK000Y 2025-12-01T15:04:56.884Z 2025-12-04T15:11:33.807Z
8658593 8658593 20251126051628_Yosa3 UK000Y 2025-12-01T15:04:52.039Z 2025-12-04T15:11:31.792Z
8658591 8658591 20251126051131_KdMWJ UK000Y 2025-12-01T15:04:51.139Z 2025-12-04T15:11:30.773Z
8658589 8658589 20251126050539_ZuaT3 UK000Y 2025-12-01T15:04:50.191Z 2025-12-04T15:11:29.550Z
8658581 8658581 20251126045129_60GOi UK000Y 2025-12-01T15:04:45.394Z 2025-12-04T15:11:26.877Z
8658564 8658564 20251126042020_Jes8s UK000Y 2025-12-01T15:04:39.160Z 2025-12-04T15:10:56.445Z
8658552 8658552 20251126040332_vwZ2w UK000Y 2025-12-01T15:04:36.615Z 2025-12-04T15:10:34.972Z
8658545 8658545 20251126034922_5322q UK000Y 2025-12-01T15:04:33.674Z 2025-12-04T15:10:16.343Z
8658539 8658539 20251126033759_IHrDt UK000Y 2025-12-01T15:04:30.783Z 2025-12-04T15:09:53.033Z
8658535 8658535 20251126033330_8N9Sv UK000Y 2025-12-01T15:04:29.286Z 2025-12-04T15:09:51.667Z
8658527 8658527 20251126032749_EDWN0 UK000Y 2025-12-01T15:04:27.730Z 2025-12-04T15:09:50.193Z
8658514 8658514 20251126030648_8o2nS UK000Y 2025-12-01T15:03:57.178Z 2025-12-04T15:09:38.054Z
8658512 8658512 20251126030537_HynPB UK000Y 2025-12-01T15:03:52.790Z 2025-12-04T15:09:37.833Z
8658510 8658510 20251126025634_4eZA3 UK000Y 2025-12-01T15:03:41.140Z 2025-12-04T15:09:35.955Z
8658507 8658507 20251126025010_QQmYd UK000Y 2025-12-01T15:03:39.957Z 2025-12-04T15:09:34.801Z
8658497 8658497 20251126022833_jZ6fr UK000Y 2025-12-01T15:03:34.924Z 2025-12-04T15:09:30.158Z
8658490 8658490 20251126004717_vaU1s UK000Y 2025-12-01T15:02:26.327Z 2025-12-04T15:08:05.955Z
8658488 8658488 20251126003955_w6SDP UK000Y 2025-12-01T15:02:23.361Z 2025-12-04T15:08:04.583Z
8658485 8658485 20251126003828_heCKS UK000Y 2025-12-01T15:02:23.133Z 2025-12-04T15:08:04.115Z
8658483 8658483 20251126002713_Gjqdn UK000Y 2025-12-01T15:02:21.884Z 2025-12-04T15:08:02.939Z
8658479 8658479 20251126001804_8EzDx UK000Y 2025-12-01T15:02:20.383Z 2025-12-04T15:07:59.010Z
8658474 8658474 20251126001428_hJzrZ UK000Y 2025-12-01T15:02:19.635Z 2025-12-04T15:07:58.448Z
8658470 8658470 20251126000814_3hoVr UK000Y 2025-12-01T15:02:16.488Z 2025-12-04T15:07:57.526Z
8658467 8658467 20251126000515_PDd8W UK000Y 2025-12-01T15:02:16.273Z 2025-12-04T15:07:57.339Z
8658465 8658465 20251125235029_72mMh UK000Y 2025-12-01T15:02:14.769Z 2025-12-04T15:07:55.702Z
8658463 8658463 20251125234811_P8cp9 UK000Y 2025-12-01T15:02:14.496Z 2025-12-04T15:07:55.383Z
8658461 8658461 20251125234303_738dD UK000Y 2025-12-01T15:02:13.569Z 2025-12-04T15:07:54.525Z
8658452 8658452 20251125231110_NU3lk UK000Y 2025-12-01T15:02:09.991Z 2025-12-04T15:07:51.180Z
8658446 8658446 20251125225858_vwujr UK000Y 2025-12-01T15:02:08.514Z 2025-12-04T15:07:49.987Z
8658433 8658433 20251125223151_2JSnE UK000Y 2025-12-01T15:02:04.739Z 2025-12-04T15:07:47.086Z
8658421 8658421 20251125221316_T3Ayy UK000Y 2025-12-01T15:02:02.072Z 2025-12-04T15:07:44.640Z
8658417 8658417 20251125220841_NteYZ UK000Y 2025-12-01T15:02:01.209Z 2025-12-04T15:07:43.738Z
8658415 8658415 20251125220043_s23Oc UK000Y 2025-12-01T15:02:00.013Z 2025-12-04T15:07:42.543Z
8658411 8658411 20251125214402_Ea96M UK000Y 2025-12-01T15:01:57.633Z 2025-12-04T15:07:40.174Z
8658407 8658407 20251125211322_ysAKA UK000Y 2025-12-01T15:01:43.782Z 2025-12-04T15:07:16.291Z
8658398 8658398 20251125204305_KxtYy UK000Y 2025-12-01T15:01:14.219Z 2025-12-04T15:07:00.983Z
8658396 8658396 20251125203406_WU4Cu UK000Y 2025-12-01T15:01:11.752Z 2025-12-04T15:06:59.482Z
8658394 8658394 20251125201828_QHVvu UK000Y 2025-12-01T15:01:09.937Z 2025-12-04T15:06:55.381Z
8658392 8658392 20251125200156_SJXz5 UK000Y 2025-12-01T15:01:08.074Z 2025-12-04T15:06:53.446Z
8658386 8658386 20251125193841_nju7t UK000Y 2025-12-01T15:01:02.515Z 2025-12-04T15:06:50.025Z
8658384 8658384 20251125193206_lxcT6 UK000Y 2025-12-01T15:01:01.362Z 2025-12-04T15:06:49.163Z
8658370 8658370 20251125174751_5UXl8 UK000Y 2025-12-01T15:00:48.946Z 2025-12-04T15:06:02.272Z
8658321 8658321 20251128062547_NXtg0 UK000Y 2025-12-01T14:53:40.497Z 2025-12-05T15:00:21.782Z
8658316 8658316 20251128051116_C3yZA UK000Y 2025-12-01T14:53:12.502Z 2025-12-05T14:59:38.108Z
8658314 8658314 20251128042948_823tU UK000Y 2025-12-01T14:52:51.039Z 2025-12-05T14:59:30.297Z
8658310 8658310 20251128024039_Dpwg0 UK000Y 2025-12-01T14:52:04.648Z 2025-12-05T14:59:13.745Z
8658214 8658214 20251128180114_i1Oiy UK000Y 2025-12-01T14:42:35.837Z 2025-12-05T14:49:20.326Z
8644550 8644550 20251128193230_uKIZE UK000Y 2025-11-30T14:22:06.162Z 2025-12-05T14:50:23.633Z
8644376 8644376 20251128192412_AbcyG UK000Y 2025-11-30T14:21:55.948Z 2025-12-05T14:50:21.257Z
8644264 8644264 20251128191241_iPARK UK000Y 2025-11-30T14:21:32.442Z 2025-12-05T14:50:19.087Z
8643703 8643703 20251128181730_c55FN UK000Y 2025-11-30T14:20:34.929Z 2025-12-05T14:49:38.320Z
8642943 8642943 20251128170555_ZjrFX UK000Y 2025-11-30T14:19:02.229Z 2025-12-05T14:49:07.505Z
8637426 8637426 20251128053934_ghsPr UK000Y 2025-11-29T14:27:14.464Z 2025-12-05T14:59:52.127Z
8637258 8637258 20251128052115_wwYzW UK000Y 2025-11-29T14:27:01.682Z 2025-12-05T14:59:39.458Z
8637243 8637243 20251128051925_IsUr3 UK000Y 2025-11-29T14:27:00.378Z 2025-12-05T14:59:39.122Z
8637160 8637160 20251128051116_KGAS2 UK000Y 2025-11-29T14:26:55.261Z 2025-11-30T14:38:03.944Z
8637139 8637139 20251128050704_3ReWx UK000Y 2025-11-29T14:26:53.015Z 2025-12-05T14:59:37.743Z
8637016 8637016 20251128045019_jXGYC UK000Y 2025-11-29T14:26:33.493Z 2025-12-05T14:59:36.090Z
8636805 8636805 20251128042904_1x33C UK000Y 2025-11-29T14:26:13.161Z 2025-12-05T14:59:30.061Z
8636657 8636657 20251128041543_W3Iq5 UK000Y 2025-11-29T14:26:02.574Z 2025-12-05T14:59:27.857Z
8636566 8636566 20251128040518_7TSNP UK000Y 2025-11-29T14:25:42.962Z 2025-12-05T14:59:26.298Z
8636509 8636509 20251128035445_0uOmv UK000Y 2025-11-29T14:25:36.038Z 2025-12-05T14:59:25.263Z
8635728 8635728 20251128024039_1WceO UK000Y 2025-11-29T14:24:04.896Z 2025-11-30T14:36:53.948Z
8635130 8635130 20251128014443_NWU4z UK000Y 2025-11-29T14:22:42.575Z 2025-12-05T14:58:30.929Z
8635025 8635025 20251128013433_zPgvf UK000Y 2025-11-29T14:22:23.534Z 2025-12-05T14:58:27.882Z
8634554 8634554 20251128005630_QSr4k UK000Y 2025-11-29T14:21:32.929Z 2025-12-05T14:58:21.843Z
8634541 8634541 20251128005557_XTLpj UK000Y 2025-11-29T14:21:31.264Z 2025-12-05T14:58:21.659Z
8634104 8634104 20251128002113_R4Db4 UK000Y 2025-11-29T14:20:45.375Z 2025-12-05T14:58:16.379Z
8633738 8633738 20251127235110_hco3n UK000Y 2025-11-29T14:20:10.662Z 2025-12-05T14:57:56.183Z
8633557 8633557 20251127233200_uzmhg UK000Y 2025-11-29T14:19:53.966Z 2025-12-05T14:57:45.874Z
8633430 8633430 20251127231710_xRFYW UK000Y 2025-11-29T14:19:43.047Z 2025-12-05T14:57:38.085Z
8633367 8633367 20251127230730_8T2MO UK000Y 2025-11-29T14:19:29.734Z 2025-12-05T14:57:33.637Z
8633294 8633294 20251127225959_mwPkj UK000Y 2025-11-29T14:19:22.498Z 2025-12-05T14:57:26.059Z
8633224 8633224 20251127225340_apMiw UK000Y 2025-11-29T14:19:16.684Z 2025-12-05T14:57:22.612Z
8633037 8633037 20251127223245_j4HxJ UK000Y 2025-11-29T14:18:53.398Z 2025-12-05T14:57:01.736Z
8633004 8633004 20251127222847_cHwlo UK000Y 2025-11-29T14:18:48.800Z 2025-12-05T14:56:55.514Z
8632941 8632941 20251127222013_wFReb UK000Y 2025-11-29T14:18:35.565Z 2025-12-05T14:56:49.612Z
8632927 8632927 20251127222013_MIFk2 UK000Y 2025-11-29T14:18:35.348Z 2025-12-05T14:56:49.574Z
8632825 8632825 20251127220244_2Fm7s UK000Y 2025-11-29T14:18:26.913Z 2025-12-05T14:56:44.694Z
8632655 8632655 20251127213108_dc6LI UK000Y 2025-11-29T14:17:57.316Z 2025-12-05T14:56:29.166Z
8632386 8632386 20251127205940_wt0KU UK000Y 2025-11-29T14:17:24.536Z 2025-12-05T14:56:20.424Z
8632243 8632243 20251127204423_LCtwC UK000Y 2025-11-29T14:17:11.064Z 2025-12-05T14:56:18.983Z

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