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

9,994 rows where station_code = "UK00AL" 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
9273344 9273344 20260128054530_w2FAj UK00AL 2026-01-29T14:29:23.332Z 2026-01-29T14:30:25.791Z
9273337 9273337 20260128054208_WH2tk UK00AL 2026-01-29T14:29:22.152Z 2026-01-29T14:30:25.790Z
9273331 9273331 20260128054121_thYof UK00AL 2026-01-29T14:29:21.217Z 2026-01-29T14:30:25.788Z
9273301 9273301 20260128053615_4Ds1z UK00AL 2026-01-29T14:29:18.170Z 2026-01-29T14:30:25.784Z
9273239 9273239 20260128051236_354oN UK00AL 2026-01-29T14:29:10.762Z 2026-01-29T14:30:25.774Z
9273114 9273114 20260128044518_PeI8V UK00AL 2026-01-29T14:28:46.080Z 2026-01-29T14:30:25.752Z
9272982 9272982 20260128041347_0ey87 UK00AL 2026-01-29T14:28:21.899Z 2026-01-29T14:30:25.728Z
9272927 9272927 20260128040221_isBvr UK00AL 2026-01-29T14:28:15.245Z 2026-01-29T14:30:25.708Z
9272736 9272736 20260128031328_n2F6y UK00AL 2026-01-29T14:27:39.348Z 2026-01-29T14:30:25.444Z
9272682 9272682 20260128030051_2Ey2F UK00AL 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.438Z
9272640 9272640 20260128025154_22RYK UK00AL 2026-01-29T14:27:17.586Z 2026-01-29T14:30:25.405Z
9272626 9272626 20260128024926_Y2F2u UK00AL 2026-01-29T14:27:15.436Z 2026-01-29T14:30:25.403Z
9272567 9272567 20260128023651_kyrCs UK00AL 2026-01-29T14:27:10.560Z 2026-01-29T14:30:25.378Z
9272534 9272534 20260128022907_X3CKg UK00AL 2026-01-29T14:27:05.798Z 2026-01-29T14:30:25.372Z
9272464 9272464 20260128021100_Df6GL UK00AL 2026-01-29T14:26:47.746Z 2026-01-29T14:30:25.350Z
9272375 9272375 20260128014920_nQsCb UK00AL 2026-01-29T14:26:32.854Z 2026-01-29T14:30:25.338Z
9272227 9272227 20260128004834_wVpQ2 UK00AL 2026-01-29T14:25:57.876Z 2026-01-29T14:30:25.309Z
9272111 9272111 20260128000222_DvUjc UK00AL 2026-01-29T14:25:35.427Z 2026-01-29T14:30:25.281Z
9271933 9271933 20260127220413_aSkFF UK00AL 2026-01-29T14:24:59.645Z 2026-01-29T14:30:25.232Z
9271838 9271838 20260127203419_unHB4 UK00AL 2026-01-29T14:24:09.981Z 2026-01-29T14:30:25.170Z
9271748 9271748 20260127194933_slUeQ UK00AL 2026-01-29T14:23:15.933Z 2026-01-29T14:30:25.097Z
9271563 9271563 20260127180042_Kt2Sx UK00AL 2026-01-29T14:21:26.286Z 2026-01-29T14:30:24.920Z
9242914 9242914 20260121031431_xnxOe UK00AL 2026-01-22T14:19:45.264Z 2026-01-29T15:04:29.500Z
9242591 9242591 20260121022235_fThI5 UK00AL 2026-01-22T14:18:30.212Z 2026-01-29T15:04:12.792Z
9236101 9236101 20260120023547_2g4KA UK00AL 2026-01-21T14:21:26.514Z 2026-01-28T14:59:44.879Z
9235038 9235038 20260120001646_FQIMM UK00AL 2026-01-21T14:17:14.842Z 2026-01-28T14:58:26.097Z
9207343 9207343 20260115010534_5o2GA UK00AL 2026-01-16T14:08:20.851Z 2026-01-22T15:03:19.340Z
9207250 9207250 20260115001751_4aS5P UK00AL 2026-01-16T14:07:56.349Z 2026-01-22T15:03:16.029Z
9204508 9204508 20260114065345_ZtbSr UK00AL 2026-01-15T14:27:28.780Z 2026-01-22T15:10:30.259Z
9204380 9204380 20260114063432_jOntL UK00AL 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204334 9204334 20260114062801_oL1H9 UK00AL 2026-01-15T14:27:04.336Z 2026-01-22T15:10:24.983Z
9204320 9204320 20260114062746_HxwMD UK00AL 2026-01-15T14:27:02.846Z 2026-01-22T15:10:24.754Z
9204316 9204316 20260114062557_0wd6j UK00AL 2026-01-15T14:27:02.379Z 2026-01-22T15:10:24.698Z
9204063 9204063 20260114060516_17ggT UK00AL 2026-01-15T14:26:20.392Z 2026-01-22T15:10:17.512Z
9204015 9204015 20260114060333_IejRG UK00AL 2026-01-15T14:26:15.985Z 2026-01-22T15:10:16.988Z
9203950 9203950 20260114055833_mA3JM UK00AL 2026-01-15T14:25:57.263Z 2026-01-22T15:10:16.087Z
9203699 9203699 20260114053051_jYNp7 UK00AL 2026-01-15T14:25:13.099Z 2026-01-22T15:10:12.404Z
9203681 9203681 20260114052833_ZmUYL UK00AL 2026-01-15T14:25:10.487Z 2026-01-22T15:10:12.014Z
9203661 9203661 20260114052726_LybBy UK00AL 2026-01-15T14:25:07.816Z 2026-01-22T15:10:11.721Z
9203642 9203642 20260114052435_U6rp1 UK00AL 2026-01-15T14:25:03.897Z 2026-01-22T15:10:11.287Z
9203519 9203519 20260114051459_rFzBZ UK00AL 2026-01-15T14:24:39.053Z 2026-01-22T15:10:09.248Z
9203463 9203463 20260114045901_ZXYMY UK00AL 2026-01-15T14:24:29.730Z 2026-01-22T15:10:08.359Z
9203443 9203443 20260114045740_d5Aeq UK00AL 2026-01-15T14:24:26.444Z 2026-01-22T15:10:07.841Z
9203429 9203429 20260114045622_G2HJf UK00AL 2026-01-15T14:24:23.601Z 2026-01-22T15:10:07.414Z
9203283 9203283 20260114044755_sjvGQ UK00AL 2026-01-15T14:23:57.293Z 2026-01-22T15:10:04.973Z
9203162 9203162 20260114043820_NvJD3 UK00AL 2026-01-15T14:23:27.421Z 2026-01-22T15:10:02.779Z
9203032 9203032 20260114043015_Fk9FU UK00AL 2026-01-15T14:23:11.903Z 2026-01-22T15:10:00.930Z
9202819 9202819 20260114041025_mdhK9 UK00AL 2026-01-15T14:22:27.935Z 2026-01-22T15:09:52.392Z
9202775 9202775 20260114040800_3zk0J UK00AL 2026-01-15T14:22:20.331Z 2026-01-22T15:09:40.834Z
9202516 9202516 20260114034411_JyVtx UK00AL 2026-01-15T14:21:33.842Z 2026-01-22T15:09:21.603Z
9202369 9202369 20260114033321_zy7ae UK00AL 2026-01-15T14:21:08.758Z 2026-01-22T15:09:16.792Z
9202208 9202208 20260114032340_dQMSU UK00AL 2026-01-15T14:20:42.436Z 2026-01-22T15:09:14.880Z
9202150 9202150 20260114032044_lVlCm UK00AL 2026-01-15T14:20:35.616Z 2026-01-22T15:09:14.140Z
9202058 9202058 20260114031242_OUbY3 UK00AL 2026-01-15T14:20:17.919Z 2026-01-22T15:09:12.508Z
9201711 9201711 20260114024213_tuuSy UK00AL 2026-01-15T14:19:22.834Z 2026-01-22T15:09:07.817Z
9201612 9201612 20260114023530_mgvai UK00AL 2026-01-15T14:19:10.799Z 2026-01-22T15:09:06.673Z
9201566 9201566 20260114023143_E2gE4 UK00AL 2026-01-15T14:18:58.355Z 2026-01-22T15:09:06.125Z
9201544 9201544 20260114022849_XKCqq UK00AL 2026-01-15T14:18:54.879Z 2026-01-22T15:09:05.683Z
9201460 9201460 20260114021828_qKoF4 UK00AL 2026-01-15T14:18:41.266Z 2026-01-22T15:09:04.098Z
9201351 9201351 20260114021131_Ba0W3 UK00AL 2026-01-15T14:18:17.820Z 2026-01-22T15:09:02.140Z
9201308 9201308 20260114020641_sO0so UK00AL 2026-01-15T14:18:12.694Z 2026-01-22T15:09:01.388Z
9201270 9201270 20260114020217_rJ3I6 UK00AL 2026-01-15T14:18:06.588Z 2026-01-22T15:09:00.738Z
9201206 9201206 20260114015350_y4ivK UK00AL 2026-01-15T14:17:46.660Z 2026-01-22T15:08:59.447Z
9201142 9201142 20260114014844_2KlaO UK00AL 2026-01-15T14:17:38.034Z 2026-01-22T15:08:58.402Z
9201135 9201135 20260114014709_3bbko UK00AL 2026-01-15T14:17:36.671Z 2026-01-22T15:08:58.146Z
9200993 9200993 20260114012854_EteLX UK00AL 2026-01-15T14:17:10.182Z 2026-01-22T15:08:45.410Z
9200887 9200887 20260114011738_QIviF UK00AL 2026-01-15T14:16:46.011Z 2026-01-22T15:08:32.893Z
9200813 9200813 20260114010624_HKXGk UK00AL 2026-01-15T14:16:33.773Z 2026-01-22T15:08:29.043Z
9200659 9200659 20260114004554_IFLBd UK00AL 2026-01-15T14:15:57.323Z 2026-01-22T15:08:22.852Z
9200621 9200621 20260114003633_7CCmT UK00AL 2026-01-15T14:15:47.654Z 2026-01-22T15:08:22.015Z
9200487 9200487 20260114001354_93N2z UK00AL 2026-01-15T14:15:19.041Z 2026-01-22T15:08:16.849Z
9200349 9200349 20260113235103_GCXuN UK00AL 2026-01-15T14:14:48.043Z 2026-01-22T15:08:14.397Z
9200343 9200343 20260113234750_6JymE UK00AL 2026-01-15T14:14:46.392Z 2026-01-22T15:08:14.162Z
9200339 9200339 20260113234619_l56KF UK00AL 2026-01-15T14:14:45.793Z 2026-01-22T15:08:14.064Z
9200327 9200327 20260113234618_qvvM3 UK00AL 2026-01-15T14:14:45.318Z 2026-01-22T15:08:13.994Z
9200308 9200308 20260113234053_0oj2y UK00AL 2026-01-15T14:14:41.521Z 2026-01-22T15:08:13.670Z
9200242 9200242 20260113232609_kvBVE UK00AL 2026-01-15T14:14:20.070Z 2026-01-22T15:08:12.041Z
9200205 9200205 20260113230915_CsT8b UK00AL 2026-01-15T14:14:10.439Z 2026-01-22T15:08:11.211Z
9200197 9200197 20260113230856_Fh4R7 UK00AL 2026-01-15T14:14:09.851Z 2026-01-22T15:08:11.078Z
9200182 9200182 20260113230612_VjjdQ UK00AL 2026-01-15T14:14:06.434Z 2026-01-22T15:08:10.816Z
9200167 9200167 20260113230146_l2I6V UK00AL 2026-01-15T14:14:03.993Z 2026-01-22T15:08:10.642Z
9200124 9200124 20260113225412_oIiNw UK00AL 2026-01-15T14:13:50.850Z 2026-01-22T15:08:09.856Z
9199970 9199970 20260113220716_H9iCn UK00AL 2026-01-15T14:13:16.827Z 2026-01-22T15:08:06.689Z
9199959 9199959 20260113220438_us4N1 UK00AL 2026-01-15T14:13:11.828Z 2026-01-22T15:08:06.517Z
9199944 9199944 20260113220237_dWQq3 UK00AL 2026-01-15T14:13:09.705Z 2026-01-22T15:08:06.198Z
9199898 9199898 20260113214828_JK1bP UK00AL 2026-01-15T14:12:59.720Z 2026-01-22T15:08:05.028Z
9199892 9199892 20260113214828_ZslVL UK00AL 2026-01-15T14:12:59.022Z 2026-01-22T15:08:04.952Z
9195911 9195911 20260113032438_EZx6z UK00AL 2026-01-14T14:15:33.259Z 2026-01-21T15:04:49.588Z
9195901 9195901 20260113032155_LBrJ0 UK00AL 2026-01-14T14:15:31.445Z 2026-01-21T15:04:49.411Z
9195845 9195845 20260113030541_ePv2s UK00AL 2026-01-14T14:15:12.048Z 2026-01-21T15:04:48.580Z
9195797 9195797 20260113025042_JqfCK UK00AL 2026-01-14T14:14:59.182Z 2026-01-21T15:04:47.710Z
9195566 9195566 20260113014628_3XSiZ UK00AL 2026-01-14T14:13:48.551Z 2026-01-21T15:04:42.285Z
9195551 9195551 20260113014414_13T79 UK00AL 2026-01-14T14:13:46.486Z 2026-01-21T15:04:42.091Z
9195403 9195403 20260113011927_B87Dd UK00AL 2026-01-14T14:13:11.187Z 2026-01-21T15:04:40.042Z
9195235 9195235 20260113004550_3yRw8 UK00AL 2026-01-14T14:12:33.154Z 2026-01-21T15:04:37.856Z
9195190 9195190 20260113003407_79nWI UK00AL 2026-01-14T14:12:20.906Z 2026-01-21T15:04:37.388Z
9195093 9195093 20260113001705_d5XsW UK00AL 2026-01-14T14:11:59.817Z 2026-01-21T15:04:36.017Z
9195071 9195071 20260113001043_naqAd UK00AL 2026-01-14T14:11:52.532Z 2026-01-21T15:04:35.734Z
9194991 9194991 20260112235527_eKdty UK00AL 2026-01-14T14:11:37.132Z 2026-01-21T15:04:34.794Z
9194937 9194937 20260112233534_xCVVf UK00AL 2026-01-14T14:11:22.240Z 2026-01-21T15:04:34.162Z

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