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,575 rows where station_code = "UK00A0" 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
9273112 9273112 20260128044518_PeI8V UK00A0 2026-01-29T14:28:46.080Z 2026-01-29T14:30:25.752Z
9272926 9272926 20260128040221_isBvr UK00A0 2026-01-29T14:28:15.245Z 2026-01-29T14:30:25.708Z
9272904 9272904 20260128035850_h0dbG UK00A0 2026-01-29T14:28:13.326Z 2026-01-29T14:30:25.705Z
9272867 9272867 20260128035401_sM26T UK00A0 2026-01-29T14:28:04.592Z 2026-01-29T14:30:25.700Z
9272842 9272842 20260128034328_sEWv2 UK00A0 2026-01-29T14:28:01.089Z 2026-01-29T14:30:25.580Z
9272809 9272809 20260128034004_NVITh UK00A0 2026-01-29T14:27:52.152Z 2026-01-29T14:30:25.565Z
9272800 9272800 20260128033924_0OGcK UK00A0 2026-01-29T14:27:51.380Z 2026-01-29T14:30:25.563Z
9272681 9272681 20260128030051_2Ey2F UK00A0 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.438Z
9272648 9272648 20260128025302_3xqDm UK00A0 2026-01-29T14:27:18.937Z 2026-01-29T14:30:25.432Z
9272631 9272631 20260128025020_wgSPd UK00A0 2026-01-29T14:27:16.009Z 2026-01-29T14:30:25.403Z
9272620 9272620 20260128024909_Af6ae UK00A0 2026-01-29T14:27:14.824Z 2026-01-29T14:30:25.383Z
9272463 9272463 20260128021100_Df6GL UK00A0 2026-01-29T14:26:47.746Z 2026-01-29T14:30:25.350Z
9272414 9272414 20260128015909_T1k56 UK00A0 2026-01-29T14:26:36.971Z 2026-01-29T14:30:25.343Z
9272374 9272374 20260128014920_nQsCb UK00A0 2026-01-29T14:26:32.854Z 2026-01-29T14:30:25.338Z
9272247 9272247 20260128005902_RN2kb UK00A0 2026-01-29T14:26:02.700Z 2026-01-29T14:30:25.315Z
9272226 9272226 20260128004834_wVpQ2 UK00A0 2026-01-29T14:25:57.876Z 2026-01-29T14:30:25.309Z
9272207 9272207 20260128004524_32ukM UK00A0 2026-01-29T14:25:56.299Z 2026-01-29T14:30:25.307Z
9272110 9272110 20260128000222_DvUjc UK00A0 2026-01-29T14:25:35.406Z 2026-01-29T14:30:25.281Z
9259614 9259614 20260124220656_3pYQb UK00A0 2026-01-26T14:17:38.000Z 2026-01-29T14:43:09.110Z
9259609 9259609 20260124220318_wFsZj UK00A0 2026-01-26T14:17:36.674Z 2026-01-29T14:43:08.791Z
9259235 9259235 20260124195127_b3tE1 UK00A0 2026-01-26T14:16:18.227Z 2026-01-29T14:42:43.834Z
9259231 9259231 20260124194532_nh3Fz UK00A0 2026-01-26T14:16:13.078Z 2026-01-29T14:42:43.526Z
9256213 9256213 20260124062143_VKHr3 UK00A0 2026-01-25T14:16:13.868Z 2026-01-29T14:48:29.174Z
9255465 9255465 20260124034238_exuot UK00A0 2026-01-25T14:13:32.766Z 2026-01-29T14:47:32.363Z
9252675 9252675 20260123051145_Blvb8 UK00A0 2026-01-24T14:16:39.218Z 2026-01-29T14:53:15.293Z
9252571 9252571 20260123041810_JL6Me UK00A0 2026-01-24T14:16:13.724Z 2026-01-29T14:53:09.072Z
9244195 9244195 20260121064237_eUqdU UK00A0 2026-01-22T14:24:34.750Z 2026-01-29T15:05:55.541Z
9244132 9244132 20260121061824_8tA4U UK00A0 2026-01-22T14:24:14.236Z 2026-01-29T15:05:52.604Z
9244110 9244110 20260121061337_sFBil UK00A0 2026-01-22T14:24:10.341Z 2026-01-29T15:05:52.057Z
9244033 9244033 20260121055647_hNzwS UK00A0 2026-01-22T14:23:58.259Z 2026-01-29T15:05:49.027Z
9218046 9218046 20260116225710_JUNvy UK00A0 2026-01-18T14:10:10.249Z 2026-01-25T14:57:56.584Z
9217618 9217618 20260116183129_n7LDf UK00A0 2026-01-18T14:08:12.280Z 2026-01-25T14:57:28.159Z
9214428 9214428 20260116063354_P1lb2 UK00A0 2026-01-17T14:21:30.625Z 2026-01-24T15:13:36.780Z
9214254 9214254 20260116055941_FDscH UK00A0 2026-01-17T14:20:45.260Z 2026-01-24T15:13:26.081Z
9214246 9214246 20260116055823_p2BRG UK00A0 2026-01-17T14:20:43.088Z 2026-01-24T15:13:25.542Z
9214085 9214085 20260116053224_vFbVh UK00A0 2026-01-17T14:19:59.636Z 2026-01-24T15:13:04.835Z
9213494 9213494 20260116034704_YhsxW UK00A0 2026-01-17T14:17:10.542Z 2026-01-24T15:12:18.110Z
9213420 9213420 20260116032739_28FHN UK00A0 2026-01-17T14:16:50.722Z 2026-01-24T15:12:13.224Z
9213281 9213281 20260116030249_o073e UK00A0 2026-01-17T14:16:16.507Z 2026-01-24T15:12:07.242Z
9208452 9208452 20260115052734_bhDDQ UK00A0 2026-01-16T14:12:44.407Z 2026-01-22T15:04:14.312Z
9208324 9208324 20260115050350_xUfnh UK00A0 2026-01-16T14:12:09.826Z 2026-01-22T15:04:07.479Z
9208262 9208262 20260115044954_Lbu9Z UK00A0 2026-01-16T14:11:57.099Z 2026-01-22T15:04:05.839Z
9208193 9208193 20260115043207_3jquF UK00A0 2026-01-16T14:11:39.362Z 2026-01-22T15:04:03.705Z
9208120 9208120 20260115041800_seD6y UK00A0 2026-01-16T14:11:24.189Z 2026-01-22T15:04:01.935Z
9208109 9208109 20260115041721_jYOqd UK00A0 2026-01-16T14:11:22.143Z 2026-01-22T15:04:01.595Z
9207981 9207981 20260115034142_DJvq8 UK00A0 2026-01-16T14:10:53.157Z 2026-01-22T15:03:57.871Z
9207896 9207896 20260115032904_3zKu0 UK00A0 2026-01-16T14:10:33.680Z 2026-01-22T15:03:55.977Z
9207724 9207724 20260115025418_9jRgQ UK00A0 2026-01-16T14:09:48.795Z 2026-01-22T15:03:30.917Z
9207514 9207514 20260115015959_gOvzy UK00A0 2026-01-16T14:09:02.692Z 2026-01-22T15:03:23.813Z
9204379 9204379 20260114063432_jOntL UK00A0 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204363 9204363 20260114063012_sQYhw UK00A0 2026-01-15T14:27:08.175Z 2026-01-22T15:10:25.378Z
9204333 9204333 20260114062801_oL1H9 UK00A0 2026-01-15T14:27:04.336Z 2026-01-22T15:10:24.983Z
9204315 9204315 20260114062557_0wd6j UK00A0 2026-01-15T14:27:02.378Z 2026-01-22T15:10:24.698Z
9204286 9204286 20260114062514_nVxvP UK00A0 2026-01-15T14:27:00.691Z 2026-01-22T15:10:24.499Z
9204222 9204222 20260114061616_qhG6f UK00A0 2026-01-15T14:26:50.702Z 2026-01-22T15:10:22.516Z
9204116 9204116 20260114060824_PUpaF UK00A0 2026-01-15T14:26:26.612Z 2026-01-22T15:10:18.323Z
9203698 9203698 20260114053051_jYNp7 UK00A0 2026-01-15T14:25:13.099Z 2026-01-22T15:10:12.404Z
9203597 9203597 20260114052118_JZLHU UK00A0 2026-01-15T14:24:58.820Z 2026-01-22T15:10:10.599Z
9203567 9203567 20260114051759_AsHcX UK00A0 2026-01-15T14:24:48.010Z 2026-01-22T15:10:09.975Z
9203532 9203532 20260114051537_JA22l UK00A0 2026-01-15T14:24:44.485Z 2026-01-22T15:10:09.564Z
9203296 9203296 20260114044922_zW6oV UK00A0 2026-01-15T14:24:00.263Z 2026-01-22T15:10:05.292Z
9203137 9203137 20260114043642_Q6rA1 UK00A0 2026-01-15T14:23:24.178Z 2026-01-22T15:10:02.350Z
9202941 9202941 20260114041910_4BBw2 UK00A0 2026-01-15T14:22:50.581Z 2026-01-22T15:09:59.600Z
9201929 9201929 20260114030716_huTcI UK00A0 2026-01-15T14:20:08.985Z 2026-01-22T15:09:11.562Z
9201742 9201742 20260114024704_wU5GY UK00A0 2026-01-15T14:19:37.351Z 2026-01-22T15:09:08.768Z
9201565 9201565 20260114023143_E2gE4 UK00A0 2026-01-15T14:18:58.355Z 2026-01-22T15:09:06.125Z
9201519 9201519 20260114022426_3qJ3B UK00A0 2026-01-15T14:18:47.869Z 2026-01-22T15:09:04.832Z
9201503 9201503 20260114022158_gxu6j UK00A0 2026-01-15T14:18:45.061Z 2026-01-22T15:09:04.512Z
9201458 9201458 20260114021828_qKoF4 UK00A0 2026-01-15T14:18:41.266Z 2026-01-22T15:09:04.098Z
9201037 9201037 20260114013512_Qk6EE UK00A0 2026-01-15T14:17:16.423Z 2026-01-22T15:08:51.712Z
9200926 9200926 20260114012223_3Z2NP UK00A0 2026-01-15T14:17:01.599Z 2026-01-22T15:08:39.282Z
9200781 9200781 20260114010248_YJOf5 UK00A0 2026-01-15T14:16:23.426Z 2026-01-22T15:08:25.470Z
9200620 9200620 20260114003633_7CCmT UK00A0 2026-01-15T14:15:47.654Z 2026-01-22T15:08:22.015Z
9200241 9200241 20260113232609_kvBVE UK00A0 2026-01-15T14:14:20.070Z 2026-01-22T15:08:12.041Z
9200196 9200196 20260113230856_Fh4R7 UK00A0 2026-01-15T14:14:09.851Z 2026-01-22T15:08:11.078Z
9200171 9200171 20260113230150_o5myt UK00A0 2026-01-15T14:14:04.858Z 2026-01-22T15:08:10.712Z
9200135 9200135 20260113225522_6FF3Z UK00A0 2026-01-15T14:13:53.974Z 2026-01-22T15:08:10.167Z
9199858 9199858 20260113213405_J2oUe UK00A0 2026-01-15T14:12:46.778Z 2026-01-22T15:08:04.189Z
9199708 9199708 20260113210608_aUGNh UK00A0 2026-01-15T14:12:06.401Z 2026-01-22T15:08:00.317Z
9195748 9195748 20260113023913_WuavR UK00A0 2026-01-14T14:14:43.674Z 2026-01-21T15:04:46.831Z
9195565 9195565 20260113014628_3XSiZ UK00A0 2026-01-14T14:13:48.551Z 2026-01-21T15:04:42.285Z
9195219 9195219 20260113004200_mGD8Q UK00A0 2026-01-14T14:12:24.664Z 2026-01-21T15:04:37.606Z
9195189 9195189 20260113003407_79nWI UK00A0 2026-01-14T14:12:20.906Z 2026-01-21T15:04:37.388Z
9194492 9194492 20260112210111_4KsHq UK00A0 2026-01-14T14:09:27.325Z 2026-01-21T15:04:17.542Z
9179877 9179877 20260110180047_zjK4R UK00A0 2026-01-12T14:04:43.090Z 2026-01-19T15:15:21.170Z
9167808 9167808 20260108051936_uW3fU UK00A0 2026-01-09T14:09:20.201Z 2026-01-16T15:11:52.596Z
9167277 9167277 20260108000507_0vVSI UK00A0 2026-01-09T14:06:59.434Z 2026-01-16T15:10:59.959Z
9167090 9167090 20260107223958_hkAhX UK00A0 2026-01-09T14:06:13.711Z 2026-01-16T15:10:49.278Z
9166988 9166988 20260107212348_ZdbrL UK00A0 2026-01-09T14:05:44.636Z 2026-01-16T15:10:34.504Z
9166931 9166931 20260107210401_iD4Dd UK00A0 2026-01-09T14:05:31.596Z 2026-01-16T15:10:31.057Z
9166853 9166853 20260107204510_fQJgH UK00A0 2026-01-09T14:05:12.352Z 2026-01-16T15:10:26.886Z
9162952 9162952 20260107050503_TjiZM UK00A0 2026-01-08T14:07:29.989Z 2026-01-13T15:02:48.497Z
9162916 9162916 20260107050248_KzJde UK00A0 2026-01-08T14:07:18.487Z 2026-01-13T15:02:46.904Z
9162910 9162910 20260107050155_NBBu0 UK00A0 2026-01-08T14:07:17.644Z 2026-01-13T15:02:46.654Z
9160656 9160656 20260106064413_24Xss UK00A0 2026-01-07T14:13:19.486Z 2026-01-13T15:09:44.507Z
9160632 9160632 20260106063541_wbkui UK00A0 2026-01-07T14:13:14.921Z 2026-01-13T15:09:43.168Z
9158218 9158218 20260105210032_ztTM8 UK00A0 2026-01-07T14:05:20.931Z 2026-01-13T15:07:04.774Z
9158179 9158179 20260105205140_Jsko5 UK00A0 2026-01-07T14:05:13.414Z 2026-01-13T15:07:02.583Z
9157628 9157628 20260105181005_XFWQR UK00A0 2026-01-07T14:02:55.518Z 2026-01-13T15:06:20.839Z
9157586 9157586 20260105175929_NUHs0 UK00A0 2026-01-07T14:02:43.737Z 2026-01-13T15:06:18.529Z

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