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

2,795 rows where station_code = "UK005U" 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
8682087 8682087 20251203044713_0BkxP UK005U 2025-12-04T14:16:24.634Z 2025-12-06T14:28:45.833Z
8681306 8681306 20251203025549_ilb3X UK005U 2025-12-04T14:14:26.837Z 2025-12-06T14:28:00.518Z
8681022 8681022 20251203021400_9J8ed UK005U 2025-12-04T14:13:34.072Z 2025-12-06T14:27:46.705Z
8681002 8681002 20251203021139_bKW1C UK005U 2025-12-04T14:13:32.202Z 2025-12-06T14:27:44.832Z
8680753 8680753 20251203011254_Giu3q UK005U 2025-12-04T14:12:51.729Z 2025-12-06T14:27:25.010Z
8680712 8680712 20251203010754_YEhEh UK005U 2025-12-04T14:12:46.711Z 2025-12-06T14:27:23.245Z
8657942 8657942 20251130062133_CaprW UK005U 2025-12-01T14:34:47.224Z 2025-12-06T14:50:24.697Z
8657549 8657549 20251130055156_NnVDT UK005U 2025-12-01T14:34:32.885Z 2025-12-06T14:50:08.339Z
8656890 8656890 20251130051533_Nlcsd UK005U 2025-12-01T14:33:48.357Z 2025-12-06T14:49:42.736Z
8656455 8656455 20251130045632_iB93j UK005U 2025-12-01T14:28:39.579Z 2025-12-06T14:49:34.930Z
8655643 8655643 20251130041032_qzGAS UK005U 2025-12-01T14:27:19.708Z 2025-12-06T14:49:26.186Z
8654240 8654240 20251130030510_ZUwV9 UK005U 2025-12-01T14:25:00.832Z 2025-12-06T14:48:39.311Z
8653964 8653964 20251130024934_8KXez UK005U 2025-12-01T14:24:33.344Z 2025-12-06T14:48:35.130Z
8653383 8653383 20251130021333_oGvAD UK005U 2025-12-01T14:23:19.714Z 2025-12-06T14:47:57.074Z
8635170 8635170 20251128014733_XdyRt UK005U 2025-11-29T14:22:46.380Z 2025-12-06T15:02:41.401Z
8634420 8634420 20251128004836_Hdbnf UK005U 2025-11-29T14:21:20.831Z 2025-12-06T15:02:03.609Z
8634287 8634287 20251128003424_DmZK9 UK005U 2025-11-29T14:21:10.096Z 2025-12-06T15:01:58.038Z
8634013 8634013 20251128001505_8MGlm UK005U 2025-11-29T14:20:37.795Z 2025-12-06T15:01:50.588Z
8616737 8616737 20251126062301_mV8P4 UK005U 2025-11-27T14:31:47.075Z 2025-12-04T15:11:42.659Z
8616720 8616720 20251126061924_CfOO4 UK005U 2025-11-27T14:31:45.390Z 2025-12-04T15:11:42.305Z
8616656 8616656 20251126061415_xZb1W UK005U 2025-11-27T14:31:24.639Z 2025-12-04T15:11:41.581Z
8616584 8616584 20251126061327_c9luV UK005U 2025-11-27T14:31:20.099Z 2025-12-04T15:11:41.128Z
8616162 8616162 20251126054406_N3wKI UK005U 2025-11-27T14:30:39.076Z 2025-12-04T15:11:36.499Z
8615611 8615611 20251126051137_sSgUe UK005U 2025-11-27T14:30:01.462Z 2025-12-04T15:11:30.835Z
8615142 8615142 20251126044636_xLQx6 UK005U 2025-11-27T14:29:16.408Z 2025-12-04T15:11:26.247Z
8614568 8614568 20251126041815_tAkzL UK005U 2025-11-27T14:28:03.009Z 2025-12-04T15:10:51.078Z
8614486 8614486 20251126041518_nYntk UK005U 2025-11-27T14:27:55.095Z 2025-12-04T15:10:45.129Z
8614253 8614253 20251126040031_Egc4o UK005U 2025-11-27T14:27:42.191Z 2025-12-04T15:10:33.463Z
8613732 8613732 20251126033224_qd9Pk UK005U 2025-11-27T14:26:28.607Z 2025-12-04T15:09:51.401Z
8613049 8613049 20251126030015_3lHS7 UK005U 2025-11-27T14:25:20.611Z 2025-12-04T15:09:36.712Z
8612916 8612916 20251126025507_81YRR UK005U 2025-11-27T14:24:59.416Z 2025-12-04T15:09:35.751Z
8612559 8612559 20251126023804_aTEXv UK005U 2025-11-27T14:24:22.346Z 2025-12-04T15:09:32.042Z
8611078 8611078 20251126012020_3wDw8 UK005U 2025-11-27T14:21:10.387Z 2025-12-04T15:08:50.465Z
8610938 8610938 20251126011414_J2ge1 UK005U 2025-11-27T14:20:58.007Z 2025-12-04T15:08:45.267Z
8610576 8610576 20251126005745_VAlCe UK005U 2025-11-27T14:20:24.774Z 2025-12-04T15:08:14.739Z
8609521 8609521 20251125234644_krEAo UK005U 2025-11-27T14:18:18.854Z 2025-12-04T15:07:54.959Z
8609142 8609142 20251125231515_dk6U1 UK005U 2025-11-27T14:17:36.464Z 2025-12-04T15:07:51.896Z
8608450 8608450 20251125221741_RQiS2 UK005U 2025-11-27T14:16:07.259Z 2025-12-04T15:07:45.084Z
8604338 8604338 20251123185838_k35Xu UK005U 2025-11-26T14:33:09.821Z 2025-12-02T15:10:44.912Z
8603639 8603639 20251125062040_clNwQ UK005U 2025-11-26T14:27:38.036Z 2025-12-02T15:09:36.541Z
8603511 8603511 20251125061055_s810u UK005U 2025-11-26T14:27:28.963Z 2025-12-02T15:09:36.062Z
8603473 8603473 20251125061031_iAvK1 UK005U 2025-11-26T14:27:28.020Z 2025-12-02T15:09:35.963Z
8603463 8603463 20251125061031_ihZvP UK005U 2025-11-26T14:27:27.835Z 2025-12-02T15:09:35.962Z
8603259 8603259 20251125055256_RH17M UK005U 2025-11-26T14:27:17.913Z 2025-12-02T15:09:35.113Z
8602926 8602926 20251125053250_zal5U UK005U 2025-11-26T14:26:28.097Z 2025-12-02T15:09:33.536Z
8601575 8601575 20251125035741_IYqKB UK005U 2025-11-26T14:24:27.438Z 2025-12-02T15:09:15.676Z
8601323 8601323 20251125034414_UFLhA UK005U 2025-11-26T14:23:54.655Z 2025-12-02T15:09:07.721Z
8601274 8601274 20251125034250_3rWKN UK005U 2025-11-26T14:23:51.406Z 2025-12-02T15:09:06.455Z
8600400 8600400 20251125025832_tWHDx UK005U 2025-11-26T14:22:37.605Z 2025-12-02T15:08:43.438Z
8600070 8600070 20251125024003_zKEmm UK005U 2025-11-26T14:22:01.045Z 2025-12-02T15:08:34.473Z
8600054 8600054 20251125023931_i3iLi UK005U 2025-11-26T14:22:00.536Z 2025-12-02T15:08:34.253Z
8599996 8599996 20251125023538_s8eNP UK005U 2025-11-26T14:21:55.701Z 2025-12-02T15:08:33.339Z
8599955 8599955 20251125023318_sC7Mj UK005U 2025-11-26T14:21:51.833Z 2025-12-02T15:08:32.917Z
8599891 8599891 20251125022941_4D0q7 UK005U 2025-11-26T14:21:35.031Z 2025-12-02T15:08:32.569Z
8599536 8599536 20251125021006_3Uh0s UK005U 2025-11-26T14:21:14.644Z 2025-12-02T15:08:29.150Z
8599324 8599324 20251125015831_g1y7H UK005U 2025-11-26T14:20:47.112Z 2025-12-02T15:08:22.288Z
8599133 8599133 20251125014831_ikIrV UK005U 2025-11-26T14:20:33.915Z 2025-12-02T15:08:20.204Z
8598618 8598618 20251125011011_MeDHJ UK005U 2025-11-26T14:19:20.323Z 2025-12-02T15:08:01.369Z
8598263 8598263 20251125004747_dyLx2 UK005U 2025-11-26T14:18:32.874Z 2025-12-02T15:07:51.091Z
8598204 8598204 20251125004323_XUYml UK005U 2025-11-26T14:18:27.059Z 2025-12-02T15:07:48.570Z
8597001 8597001 20251124224335_2Q9cd UK005U 2025-11-26T14:15:52.875Z 2025-12-02T15:07:22.323Z
8590463 8590463 20251124024325_SZ4it UK005U 2025-11-25T14:22:04.858Z 2025-12-02T15:12:47.750Z
8590350 8590350 20251124023629_F4UlR UK005U 2025-11-25T14:21:44.717Z 2025-12-02T15:12:47.135Z
8588553 8588553 20251124000725_sJFpI UK005U 2025-11-25T14:17:45.189Z 2025-12-02T15:11:49.234Z
8588532 8588532 20251124000537_dcZzK UK005U 2025-11-25T14:17:43.324Z 2025-12-02T15:11:48.845Z
8586366 8586366 20251123193229_tWUC5 UK005U 2025-11-25T14:12:43.833Z 2025-12-02T15:10:46.603Z
8586198 8586198 20251123185837_5owwh UK005U 2025-11-25T14:12:17.446Z 2025-12-02T15:10:44.905Z
8586013 8586013 20251123183011_7f7Dk UK005U 2025-11-25T14:11:37.168Z 2025-12-02T15:10:39.445Z
8580153 8580153 20251123024214_ndx8A UK005U 2025-11-24T14:16:15.544Z 2025-12-01T15:21:43.376Z
8580148 8580148 20251123024101_1uVnM UK005U 2025-11-24T14:16:14.998Z 2025-12-01T15:21:43.273Z
8568249 8568249 20251121050914_m13yC UK005U 2025-11-23T14:31:00.410Z 2025-11-29T14:54:46.439Z
8555370 8555370 20251121010441_Z3XSy UK005U 2025-11-22T14:38:29.662Z 2025-11-29T14:54:30.427Z
8551391 8551391 20251119201659_CWGnP UK005U 2025-11-22T14:26:08.169Z 2025-11-28T14:55:06.265Z
8550752 8550752 20251121000316_0zIMD UK005U 2025-11-22T14:21:26.307Z 2025-11-29T14:54:27.485Z
8539248 8539248 20251119231919_iKdVv UK005U 2025-11-21T14:34:51.943Z 2025-11-28T14:55:46.507Z
8537160 8537160 20251120061749_AihwX UK005U 2025-11-21T14:19:36.178Z 2025-11-28T14:58:37.893Z
8537135 8537135 20251120061122_6kOyN UK005U 2025-11-21T14:19:33.818Z 2025-11-28T14:58:35.723Z
8537125 8537125 20251120060959_FlsIJ UK005U 2025-11-21T14:19:33.237Z 2025-11-28T14:58:35.295Z
8536956 8536956 20251120053910_zyjQO UK005U 2025-11-21T14:19:19.655Z 2025-11-28T14:58:19.955Z
8536939 8536939 20251120053700_v3lZH UK005U 2025-11-21T14:19:18.748Z 2025-11-28T14:58:19.210Z
8536656 8536656 20251120044923_sE9EH UK005U 2025-11-21T14:18:47.016Z 2025-11-28T14:57:48.165Z
8536499 8536499 20251120042730_25yif UK005U 2025-11-21T14:18:22.497Z 2025-11-28T14:57:38.880Z
8536272 8536272 20251120040007_8vvCW UK005U 2025-11-21T14:18:02.186Z 2025-11-28T14:57:30.403Z
8536131 8536131 20251120033922_u2a21 UK005U 2025-11-21T14:17:38.387Z 2025-11-28T14:57:25.764Z
8535971 8535971 20251120031720_EzSBO UK005U 2025-11-21T14:17:20.505Z 2025-11-28T14:57:14.611Z
8535539 8535539 20251120021500_J630R UK005U 2025-11-21T14:16:21.555Z 2025-11-28T14:56:46.433Z
8535518 8535518 20251120021422_W4rRB UK005U 2025-11-21T14:16:19.885Z 2025-11-28T14:56:45.907Z
8535211 8535211 20251120013422_LHV8U UK005U 2025-11-21T14:15:31.074Z 2025-11-28T14:56:23.286Z
8535197 8535197 20251120012944_aj2kS UK005U 2025-11-21T14:15:29.496Z 2025-11-28T14:56:21.749Z
8535029 8535029 20251120010118_aAoKx UK005U 2025-11-21T14:15:10.095Z 2025-11-28T14:56:11.923Z
8534561 8534561 20251119234252_JIQ3g UK005U 2025-11-21T14:14:11.376Z 2025-11-28T14:55:50.255Z
8534442 8534442 20251119231919_3FWPz UK005U 2025-11-21T14:13:51.631Z 2025-11-21T14:13:51.631Z
8533782 8533782 20251119201659_PH2nt UK005U 2025-11-21T14:12:00.312Z 2025-11-21T14:33:20.260Z
8533524 8533524 20251119191156_F10xU UK005U 2025-11-21T14:11:02.346Z 2025-11-28T14:54:50.656Z
8527690 8527690 20251119024011_trgXs UK005U 2025-11-20T14:41:54.447Z 2025-11-27T15:12:26.991Z
8527395 8527395 20251119015324_AKysg UK005U 2025-11-20T14:41:34.735Z 2025-11-27T15:12:11.896Z
8527337 8527337 20251119014714_Xeot3 UK005U 2025-11-20T14:41:24.777Z 2025-11-27T15:12:11.015Z
8527081 8527081 20251119005726_oGlxX UK005U 2025-11-20T14:40:43.733Z 2025-11-27T15:12:06.797Z
8525603 8525603 20251118180133_kPFxc UK005U 2025-11-20T14:37:10.863Z 2025-11-27T15:11:28.717Z
8510126 8510126 20251118040625_3oCQG UK005U 2025-11-19T14:21:09.483Z 2025-11-26T15:07:59.929Z

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