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,442 rows where station_code = "UK0049" 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
9273351 9273351 20260128054901_7VxJ9 UK0049 2026-01-29T14:29:24.777Z 2026-01-29T14:30:25.793Z
9273055 9273055 20260128043057_g9png UK0049 2026-01-29T14:28:39.966Z 2026-01-29T14:30:25.743Z
9273000 9273000 20260128041935_Wgr7Q UK0049 2026-01-29T14:28:24.603Z 2026-01-29T14:30:25.733Z
9272696 9272696 20260128030822_ixwzV UK0049 2026-01-29T14:27:35.131Z 2026-01-29T14:30:25.440Z
9272600 9272600 20260128024815_s7qkO UK0049 2026-01-29T14:27:13.641Z 2026-01-29T14:30:25.382Z
9272481 9272481 20260128021329_vLEln UK0049 2026-01-29T14:26:50.417Z 2026-01-29T14:30:25.354Z
9272176 9272176 20260128003621_7gRfb UK0049 2026-01-29T14:25:52.160Z 2026-01-29T14:30:25.294Z
9271975 9271975 20260127224305_lyPpi UK0049 2026-01-29T14:25:12.021Z 2026-01-29T14:30:25.257Z
9271898 9271898 20260127214256_dZAVh UK0049 2026-01-29T14:24:53.421Z 2026-01-29T14:30:25.227Z
9271634 9271634 20260127184736_i2TAA UK0049 2026-01-29T14:21:55.863Z 2026-01-29T14:30:24.985Z
9271599 9271599 20260127182817_W8iBN UK0049 2026-01-29T14:21:43.029Z 2026-01-29T14:30:24.962Z
9252301 9252301 20260123020804_NDv3l UK0049 2026-01-24T14:15:00.429Z 2026-01-29T14:52:44.376Z
9252276 9252276 20260123020334_3vc0Y UK0049 2026-01-24T14:14:54.337Z 2026-01-29T14:52:43.327Z
9242750 9242750 20260121023919_6MEO0 UK0049 2026-01-22T14:19:08.131Z 2026-01-29T15:04:19.543Z
9242527 9242527 20260121021013_itoN7 UK0049 2026-01-22T14:18:12.235Z 2026-01-29T15:04:03.138Z
9222188 9222188 20260117183944_bfK38 UK0049 2026-01-19T14:13:41.349Z 2026-01-26T15:00:43.403Z
9212658 9212658 20260116001117_aqc5M UK0049 2026-01-17T14:13:10.773Z 2026-01-24T15:11:09.267Z
9204529 9204529 20260114065635_ObUD3 UK0049 2026-01-15T14:27:31.309Z 2026-01-22T15:10:31.661Z
9204512 9204512 20260114065459_uTXpV UK0049 2026-01-15T14:27:29.202Z 2026-01-22T15:10:30.613Z
9204438 9204438 20260114064408_TQStq UK0049 2026-01-15T14:27:23.741Z 2026-01-22T15:10:28.489Z
9204171 9204171 20260114061351_rS9rc UK0049 2026-01-15T14:26:36.427Z 2026-01-22T15:10:21.826Z
9203778 9203778 20260114053712_X80oV UK0049 2026-01-15T14:25:23.375Z 2026-01-22T15:10:13.423Z
9203754 9203754 20260114053525_kPJoE UK0049 2026-01-15T14:25:21.609Z 2026-01-22T15:10:13.158Z
9203393 9203393 20260114045346_QKRZd UK0049 2026-01-15T14:24:18.193Z 2026-01-22T15:10:06.832Z
9203037 9203037 20260114043022_B3Wvv UK0049 2026-01-15T14:23:13.088Z 2026-01-22T15:10:01.051Z
9203002 9203002 20260114042610_4szaq UK0049 2026-01-15T14:23:01.482Z 2026-01-22T15:10:00.532Z
9202972 9202972 20260114042337_g3vtJ UK0049 2026-01-15T14:22:57.118Z 2026-01-22T15:10:00.222Z
9202849 9202849 20260114041313_TOge1 UK0049 2026-01-15T14:22:37.933Z 2026-01-22T15:09:57.869Z
9202268 9202268 20260114032506_gZd5J UK0049 2026-01-15T14:20:49.983Z 2026-01-22T15:09:15.390Z
9202174 9202174 20260114032201_e54Vx UK0049 2026-01-15T14:20:39.005Z 2026-01-22T15:09:14.449Z
9202119 9202119 20260114031742_KlUEl UK0049 2026-01-15T14:20:33.997Z 2026-01-22T15:09:13.837Z
9201977 9201977 20260114030932_cHnlD UK0049 2026-01-15T14:20:13.061Z 2026-01-22T15:09:11.939Z
9201874 9201874 20260114030441_B482B UK0049 2026-01-15T14:20:04.325Z 2026-01-22T15:09:11.047Z
9201636 9201636 20260114023739_4CGGn UK0049 2026-01-15T14:19:13.658Z 2026-01-22T15:09:06.969Z
9201597 9201597 20260114023423_SvAGS UK0049 2026-01-15T14:19:09.617Z 2026-01-22T15:09:06.578Z
9200501 9200501 20260114001412_WUk6Y UK0049 2026-01-15T14:15:21.245Z 2026-01-22T15:08:17.091Z
9200492 9200492 20260114001412_AxlDw UK0049 2026-01-15T14:15:20.328Z 2026-01-22T15:08:17.025Z
9200363 9200363 20260113235346_bQAbn UK0049 2026-01-15T14:14:51.755Z 2026-01-22T15:08:14.681Z
9200089 9200089 20260113225110_HaZho UK0049 2026-01-15T14:13:45.219Z 2026-01-22T15:08:09.491Z
9195763 9195763 20260113024436_zbIE7 UK0049 2026-01-14T14:14:48.553Z 2026-01-21T15:04:47.226Z
9195690 9195690 20260113022018_lmOCs UK0049 2026-01-14T14:14:24.130Z 2026-01-21T15:04:45.671Z
9195618 9195618 20260113020453_x4tN9 UK0049 2026-01-14T14:14:09.853Z 2026-01-21T15:04:43.073Z
9195594 9195594 20260113015816_VOSml UK0049 2026-01-14T14:13:59.030Z 2026-01-21T15:04:42.799Z
9195499 9195499 20260113013711_jJKaz UK0049 2026-01-14T14:13:37.233Z 2026-01-21T15:04:41.475Z
9195471 9195471 20260113013409_gGmb1 UK0049 2026-01-14T14:13:28.200Z 2026-01-21T15:04:41.116Z
9195286 9195286 20260113005413_e5dmP UK0049 2026-01-14T14:12:44.655Z 2026-01-21T15:04:38.545Z
9195120 9195120 20260113002417_ih23J UK0049 2026-01-14T14:12:06.234Z 2026-01-21T15:04:36.649Z
9194613 9194613 20260112213430_m5hAD UK0049 2026-01-14T14:10:01.063Z 2026-01-21T15:04:19.265Z
9194446 9194446 20260112205211_JzhPD UK0049 2026-01-14T14:09:16.473Z 2026-01-21T15:04:11.023Z
9180529 9180529 20260110204708_adFEE UK0049 2026-01-12T14:07:26.117Z 2026-01-19T15:16:21.351Z
9176144 9176144 20260110045236_pX23x UK0049 2026-01-11T14:08:18.217Z 2026-01-18T15:08:21.923Z
9176122 9176122 20260110044838_PQq31 UK0049 2026-01-11T14:08:12.782Z 2026-01-18T15:08:19.540Z
9175580 9175580 20260110030218_e6DYD UK0049 2026-01-11T14:06:49.075Z 2026-01-18T15:07:52.009Z
9175497 9175497 20260110023942_TkFhL UK0049 2026-01-11T14:06:33.859Z 2026-01-18T15:07:47.450Z
9175292 9175292 20260110015845_7Dpte UK0049 2026-01-11T14:05:58.673Z 2026-01-18T15:07:39.866Z
9175239 9175239 20260110014655_zFoT2 UK0049 2026-01-11T14:05:48.550Z 2026-01-18T15:07:38.322Z
9174968 9174968 20260110002211_jd3KT UK0049 2026-01-11T14:04:59.483Z 2026-01-18T15:07:19.580Z
9174523 9174523 20260109195825_VS0iy UK0049 2026-01-11T14:03:29.814Z 2026-01-18T15:06:49.768Z
9174516 9174516 20260109195739_BSSV1 UK0049 2026-01-11T14:03:28.332Z 2026-01-18T15:06:49.426Z
9166589 9166589 20260107192341_l8a04 UK0049 2026-01-09T14:03:58.163Z 2026-01-16T15:10:05.088Z
9158525 9158525 20260105230421_QsLOg UK0049 2026-01-07T14:06:24.863Z 2026-01-13T15:07:27.831Z
9158112 9158112 20260105200843_a1CpA UK0049 2026-01-07T14:04:55.590Z 2026-01-13T15:06:56.288Z
9158008 9158008 20260105193756_cpXyX UK0049 2026-01-07T14:04:27.218Z 2026-01-13T15:06:49.215Z
9154355 9154355 20260104045341_16rih UK0049 2026-01-06T14:35:21.883Z 2026-01-12T15:09:48.311Z
9154078 9154078 20260104043356_UZs2I UK0049 2026-01-06T14:34:43.997Z 2026-01-12T15:09:34.870Z
9151862 9151862 20260105064805_NG3u2 UK0049 2026-01-06T14:14:56.508Z 2026-01-13T15:15:09.948Z
9151699 9151699 20260105061850_mybKm UK0049 2026-01-06T14:14:25.807Z 2026-01-13T15:15:01.903Z
9151474 9151474 20260105053729_y7hEj UK0049 2026-01-06T14:13:49.831Z 2026-01-13T15:14:46.262Z
9149329 9149329 20260104201155_79VR9 UK0049 2026-01-06T14:05:02.188Z 2026-01-13T15:12:05.036Z
9149023 9149023 20260104183403_dP1kS UK0049 2026-01-06T14:03:32.451Z 2026-01-13T15:11:38.968Z
9148157 9148157 20260103173252_UM42m UK0049 2026-01-05T14:30:19.394Z 2026-01-10T15:04:18.566Z
9148036 9148036 20260103172810_TLmft UK0049 2026-01-05T14:30:15.029Z 2026-01-10T15:04:13.327Z
9147753 9147753 20260104064311_wNGd0 UK0049 2026-01-05T14:24:48.016Z 2026-01-12T15:11:37.045Z
9147714 9147714 20260104063402_3hlta UK0049 2026-01-05T14:24:45.445Z 2026-01-12T15:11:33.644Z
9147647 9147647 20260104062204_v1L9G UK0049 2026-01-05T14:24:39.482Z 2026-01-12T15:11:27.607Z
9147621 9147621 20260104061827_CKXRj UK0049 2026-01-05T14:24:37.818Z 2026-01-12T15:11:25.880Z
9147535 9147535 20260104060333_hi2IL UK0049 2026-01-05T14:24:21.239Z 2026-01-12T15:11:06.594Z
9147498 9147498 20260104055703_GRjzq UK0049 2026-01-05T14:24:14.922Z 2026-01-12T15:11:03.751Z
9147421 9147421 20260104054825_RvkQQ UK0049 2026-01-05T14:24:08.819Z 2026-01-12T15:10:55.477Z
9147334 9147334 20260104053504_2jD7B UK0049 2026-01-05T14:24:04.623Z 2026-01-12T15:10:48.719Z
9147320 9147320 20260104053144_ZoK0N UK0049 2026-01-05T14:24:02.876Z 2026-01-12T15:10:46.444Z
9147300 9147300 20260104052859_Tw2Gb UK0049 2026-01-05T14:24:01.336Z 2026-01-12T15:10:40.365Z
9147274 9147274 20260104052537_rCAZm UK0049 2026-01-05T14:23:58.772Z 2026-01-12T15:10:27.378Z
9147268 9147268 20260104052509_A4YAR UK0049 2026-01-05T14:23:58.181Z 2026-01-12T15:10:27.003Z
9147232 9147232 20260104052026_Cd3pQ UK0049 2026-01-05T14:23:53.580Z 2026-01-12T15:10:22.914Z
9147178 9147178 20260104051318_pkVxJ UK0049 2026-01-05T14:23:37.633Z 2026-01-12T15:10:19.099Z
9147168 9147168 20260104051247_Yi8ZK UK0049 2026-01-05T14:23:37.122Z 2026-01-12T15:10:18.667Z
9147137 9147137 20260104050858_CwZmr UK0049 2026-01-05T14:23:31.112Z 2026-01-12T15:10:15.290Z
9147114 9147114 20260104050431_EV5Xw UK0049 2026-01-05T14:23:28.735Z 2026-01-12T15:10:12.356Z
9147062 9147062 20260104045941_idSsb UK0049 2026-01-05T14:23:25.505Z 2026-01-12T15:10:08.218Z
9147057 9147057 20260104045912_p8E5H UK0049 2026-01-05T14:23:24.774Z 2026-01-12T15:10:02.748Z
9146951 9146951 20260104044951_xY3H2 UK0049 2026-01-05T14:23:18.874Z 2026-01-12T15:09:43.173Z
9146930 9146930 20260104044653_tnuLi UK0049 2026-01-05T14:23:17.362Z 2026-01-12T15:09:42.061Z
9146874 9146874 20260104043923_XWpEs UK0049 2026-01-05T14:23:05.369Z 2026-01-12T15:09:37.723Z
9146871 9146871 20260104043921_RQB2o UK0049 2026-01-05T14:23:03.394Z 2026-01-12T15:09:37.538Z
9146854 9146854 20260104043629_eLUyY UK0049 2026-01-05T14:22:57.982Z 2026-01-12T15:09:36.283Z
9146850 9146850 20260104043436_bOK6l UK0049 2026-01-05T14:22:57.221Z 2026-01-12T15:09:35.835Z
9146814 9146814 20260104043207_GQ26u UK0049 2026-01-05T14:22:53.801Z 2026-01-12T15:09:33.694Z
9146807 9146807 20260104043130_bvZer UK0049 2026-01-05T14:22:53.370Z 2026-01-12T15:09:32.734Z
9146742 9146742 20260104042116_lyv3Q UK0049 2026-01-05T14:22:47.118Z 2026-01-12T15:09:12.144Z

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