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

3,353 rows where station_code = "UK008D" 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
9273176 9273176 20260128050306_eJ2MI UK008D 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9273096 9273096 20260128044352_T6A77 UK008D 2026-01-29T14:28:44.620Z 2026-01-29T14:30:25.749Z
9272943 9272943 20260128040733_DYhZy UK008D 2026-01-29T14:28:16.878Z 2026-01-29T14:30:25.710Z
9272356 9272356 20260128014354_sI3Oj UK008D 2026-01-29T14:26:31.518Z 2026-01-29T14:30:25.336Z
9272082 9272082 20260127235419_EygzZ UK008D 2026-01-29T14:25:32.142Z 2026-01-29T14:30:25.277Z
9252463 9252463 20260123031558_o6rgG UK008D 2026-01-24T14:15:42.041Z 2026-01-29T14:52:55.541Z
9252385 9252385 20260123024350_ELPhi UK008D 2026-01-24T14:15:20.726Z 2026-01-29T14:52:48.239Z
9251839 9251839 20260122232053_vsgS2 UK008D 2026-01-24T14:13:21.580Z 2026-01-29T14:52:12.524Z
9251762 9251762 20260122223043_w6Z92 UK008D 2026-01-24T14:13:09.206Z 2026-01-29T14:52:08.460Z
9251748 9251748 20260122222526_2ohqP UK008D 2026-01-24T14:13:06.695Z 2026-01-29T14:52:07.818Z
9251700 9251700 20260122220923_2qxCh UK008D 2026-01-24T14:12:58.199Z 2026-01-29T14:52:01.531Z
9214459 9214459 20260116063849_jnD2Z UK008D 2026-01-17T14:21:36.992Z 2026-01-24T15:13:38.372Z
9212600 9212600 20260115234354_KNuI7 UK008D 2026-01-17T14:12:52.273Z 2026-01-24T15:11:07.011Z
9204417 9204417 20260114063757_rjJ1e UK008D 2026-01-15T14:27:14.177Z 2026-01-22T15:10:27.521Z
9204273 9204273 20260114062325_2BOfZ UK008D 2026-01-15T14:26:58.438Z 2026-01-22T15:10:24.178Z
9204023 9204023 20260114060359_CfSBR UK008D 2026-01-15T14:26:16.984Z 2026-01-22T15:10:17.088Z
9203577 9203577 20260114051802_K33Ec UK008D 2026-01-15T14:24:56.085Z 2026-01-22T15:10:10.194Z
9203359 9203359 20260114045245_xGLxR UK008D 2026-01-15T14:24:09.495Z 2026-01-22T15:10:06.256Z
9203077 9203077 20260114043236_PKlJD UK008D 2026-01-15T14:23:16.221Z 2026-01-22T15:10:01.290Z
9202219 9202219 20260114032347_GpkHq UK008D 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202090 9202090 20260114031527_ibGf2 UK008D 2026-01-15T14:20:30.560Z 2026-01-22T15:09:13.365Z
9201576 9201576 20260114023405_LviY5 UK008D 2026-01-15T14:19:07.817Z 2026-01-22T15:09:06.351Z
9201523 9201523 20260114022538_79DyB UK008D 2026-01-15T14:18:48.821Z 2026-01-22T15:09:04.930Z
9201380 9201380 20260114021150_veJw2 UK008D 2026-01-15T14:18:23.998Z 2026-01-22T15:09:02.664Z
9176916 9176916 20260110063958_Ow2eh UK008D 2026-01-11T14:10:20.887Z 2026-01-18T15:09:07.543Z
9176720 9176720 20260110061306_6J4EN UK008D 2026-01-11T14:09:49.509Z 2026-01-18T15:08:51.940Z
9176510 9176510 20260110053809_7Ou3f UK008D 2026-01-11T14:09:12.906Z 2026-01-18T15:08:41.910Z
9176227 9176227 20260110050327_PUdWd UK008D 2026-01-11T14:08:31.271Z 2026-01-18T15:08:24.513Z
9175920 9175920 20260110041611_45U33 UK008D 2026-01-11T14:07:48.430Z 2026-01-18T15:08:13.418Z
9175648 9175648 20260110032100_32sXN UK008D 2026-01-11T14:06:59.977Z 2026-01-18T15:07:54.913Z
9175542 9175542 20260110025335_gEtzb UK008D 2026-01-11T14:06:42.288Z 2026-01-18T15:07:49.584Z
9175251 9175251 20260110015001_Vqwtx UK008D 2026-01-11T14:05:49.072Z 2026-01-18T15:07:38.472Z
9174637 9174637 20260109211336_srQ4W UK008D 2026-01-11T14:03:54.789Z 2026-01-18T15:06:56.277Z
9174623 9174623 20260109210527_8SzCA UK008D 2026-01-11T14:03:52.080Z 2026-01-18T15:06:55.670Z
9159427 9159427 20260106023928_WQ3De UK008D 2026-01-07T14:09:18.867Z 2026-01-13T15:08:25.756Z
9159376 9159376 20260106022954_UYqtE UK008D 2026-01-07T14:09:08.434Z 2026-01-13T15:08:22.694Z
9158711 9158711 20260106000813_yaVWw UK008D 2026-01-07T14:07:02.464Z 2026-01-13T15:07:43.338Z
9158555 9158555 20260105231636_6WrLn UK008D 2026-01-07T14:06:30.505Z 2026-01-13T15:07:29.409Z
9157964 9157964 20260105193445_HZyx2 UK008D 2026-01-07T14:04:21.479Z 2026-01-13T15:06:48.014Z
9157922 9157922 20260105192454_b1B3p UK008D 2026-01-07T14:04:10.206Z 2026-01-13T15:06:45.622Z
9157847 9157847 20260105190007_cuOIl UK008D 2026-01-07T14:03:50.253Z 2026-01-13T15:06:34.270Z
9156137 9156137 20260104065257_zhKGj UK008D 2026-01-06T14:38:39.246Z 2026-01-12T15:11:39.940Z
9156075 9156075 20260104064308_VZFiA UK008D 2026-01-06T14:38:30.910Z 2026-01-12T15:11:36.967Z
9156065 9156065 20260104064120_zIdNV UK008D 2026-01-06T14:38:29.766Z 2026-01-12T15:11:36.599Z
9155682 9155682 20260104061543_Sh0wU UK008D 2026-01-06T14:37:54.105Z 2026-01-12T15:11:24.096Z
9155670 9155670 20260104061304_5VE3T UK008D 2026-01-06T14:37:53.260Z 2026-01-12T15:11:23.673Z
9151763 9151763 20260105062933_nmg5t UK008D 2026-01-06T14:14:36.901Z 2026-01-13T15:15:04.717Z
9150317 9150317 20260105014909_H9clO UK008D 2026-01-06T14:09:32.534Z 2026-01-13T15:13:16.419Z
9150126 9150126 20260105010658_Kvcma UK008D 2026-01-06T14:08:42.071Z 2026-01-13T15:13:06.161Z
9150113 9150113 20260105010505_bUG5D UK008D 2026-01-06T14:08:37.478Z 2026-01-13T15:13:05.482Z
9149739 9149739 20260104231811_OtqPt UK008D 2026-01-06T14:06:56.721Z 2026-01-13T15:12:36.449Z
9147962 9147962 20260103172509_Kfiam UK008D 2026-01-05T14:30:02.371Z 2026-01-10T15:04:10.366Z
9143458 9143458 20260104021112_MfcXW UK008D 2026-01-05T14:17:32.116Z 2026-01-12T15:06:23.642Z
9143453 9143453 20260104021038_6RoKh UK008D 2026-01-05T14:17:31.550Z 2026-01-12T15:06:23.525Z
9142947 9142947 20260104015202_hiX2T UK008D 2026-01-05T14:16:45.632Z 2026-01-12T15:06:09.954Z
9140867 9140867 20260104003356_uf0kw UK008D 2026-01-05T14:13:44.590Z 2026-01-12T15:04:33.412Z
9140827 9140827 20260104003201_7f3kY UK008D 2026-01-05T14:13:40.579Z 2026-01-12T15:04:31.851Z
9140271 9140271 20260104000813_hmyg3 UK008D 2026-01-05T14:12:57.834Z 2026-01-12T15:04:03.877Z
9139878 9139878 20260103235004_FADj1 UK008D 2026-01-05T14:12:15.694Z 2026-01-12T15:03:52.773Z
9138559 9138559 20260103223248_CZRDm UK008D 2026-01-05T14:10:09.322Z 2026-01-12T15:02:52.684Z
9138551 9138551 20260103223149_FgXxY UK008D 2026-01-05T14:10:05.392Z 2026-01-12T15:02:52.252Z
9137841 9137841 20260103213700_y3W1B UK008D 2026-01-05T14:08:59.471Z 2026-01-12T15:02:21.192Z
9129618 9129618 20260102232914_5aNZJ UK008D 2026-01-04T14:05:01.574Z 2026-01-10T14:57:57.213Z
9129136 9129136 20260102184220_QIvLl UK008D 2026-01-04T14:01:39.331Z 2026-01-10T14:57:07.607Z
9126784 9126784 20260102004612_3vgYK UK008D 2026-01-03T14:06:43.793Z 2026-01-09T14:49:02.308Z
9116637 9116637 20251231062913_ACDC2 UK008D 2026-01-01T14:28:31.595Z 2026-01-08T15:11:57.352Z
9116629 9116629 20251231062832_sHWIG UK008D 2026-01-01T14:28:30.375Z 2026-01-08T15:11:56.977Z
9116523 9116523 20251231061919_dbGRK UK008D 2026-01-01T14:28:18.549Z 2026-01-08T15:11:54.045Z
9115805 9115805 20251231053000_qR9us UK008D 2026-01-01T14:26:30.653Z 2026-01-08T15:11:12.899Z
9115339 9115339 20251231045956_yTFl8 UK008D 2026-01-01T14:25:05.906Z 2026-01-08T15:10:43.010Z
9114951 9114951 20251231043658_UvVTB UK008D 2026-01-01T14:23:50.669Z 2026-01-08T15:10:15.983Z
9114894 9114894 20251231043426_4n2ua UK008D 2026-01-01T14:23:43.864Z 2026-01-08T15:10:12.906Z
9114711 9114711 20251231042712_JBtyj UK008D 2026-01-01T14:23:18.650Z 2026-01-08T15:10:06.828Z
9114506 9114506 20251231041930_5gl4Q UK008D 2026-01-01T14:22:50.910Z 2026-01-08T15:09:52.007Z
9113993 9113993 20251231035912_Dopcu UK008D 2026-01-01T14:21:10.330Z 2026-01-08T15:09:19.527Z
9113700 9113700 20251231034453_mPMXi UK008D 2026-01-01T14:20:09.352Z 2026-01-08T15:09:01.505Z
9112216 9112216 20251231021306_j1GZi UK008D 2026-01-01T14:14:26.078Z 2026-01-08T15:07:33.697Z
9112179 9112179 20251231021029_aOAT3 UK008D 2026-01-01T14:14:17.753Z 2026-01-08T15:07:24.743Z
9111097 9111097 20251231003828_GnoS9 UK008D 2026-01-01T14:10:10.960Z 2026-01-08T15:06:16.125Z
9110307 9110307 20251230224821_2ufYn UK008D 2026-01-01T14:06:47.354Z 2026-01-08T15:05:17.439Z
9103390 9103390 20251230042636_AJSDj UK008D 2025-12-31T14:17:38.992Z 2026-01-07T15:08:41.286Z
9103380 9103380 20251230042611_KC3K5 UK008D 2025-12-31T14:17:36.601Z 2026-01-07T15:08:40.828Z
9103323 9103323 20251230041814_qaCoJ UK008D 2025-12-31T14:17:20.687Z 2026-01-07T15:08:38.105Z
9102766 9102766 20251230033258_t3bnt UK008D 2025-12-31T14:15:14.549Z 2026-01-07T15:08:05.051Z
9102454 9102454 20251230030417_mluWC UK008D 2025-12-31T14:13:56.589Z 2026-01-07T15:07:39.792Z
9102440 9102440 20251230030311_QGq3N UK008D 2025-12-31T14:13:52.722Z 2026-01-07T15:07:39.322Z
9102381 9102381 20251230025618_7YVGV UK008D 2025-12-31T14:13:38.428Z 2026-01-07T15:07:36.434Z
9097934 9097934 20251227174858_dRcOf UK008D 2025-12-30T15:09:41.352Z 2026-01-04T15:34:26.018Z
9097790 9097790 20251227173417_3TGxg UK008D 2025-12-30T15:09:18.336Z 2025-12-30T15:09:18.336Z
9081320 9081320 20251229061958_8SAJM UK008D 2025-12-30T14:24:35.471Z 2026-01-06T15:18:58.251Z
9081178 9081178 20251229055648_XrOsU UK008D 2025-12-30T14:24:01.732Z 2026-01-06T15:18:53.359Z
9081102 9081102 20251229054446_Je9oN UK008D 2025-12-30T14:23:51.214Z 2025-12-31T14:37:24.780Z
9081042 9081042 20251229053513_WPdjQ UK008D 2025-12-30T14:23:34.191Z 2026-01-06T15:18:49.254Z
9080813 9080813 20251229050824_jypn1 UK008D 2025-12-30T14:22:44.269Z 2026-01-06T15:18:31.047Z
9080250 9080250 20251229042550_mVLeT UK008D 2025-12-30T14:20:26.686Z 2026-01-06T15:17:58.058Z
9079882 9079882 20251229035336_XZx3Q UK008D 2025-12-30T14:18:50.940Z 2026-01-06T15:17:43.078Z
9079742 9079742 20251229034021_JcIy3 UK008D 2025-12-30T14:18:14.834Z 2026-01-06T15:17:37.265Z
9078922 9078922 20251229023949_ifnfr UK008D 2025-12-30T14:14:59.381Z 2025-12-31T14:34:37.882Z
9078879 9078879 20251229023635_thEpm UK008D 2025-12-30T14:14:44.519Z 2026-01-06T15:16:44.141Z
9078027 9078027 20251229012457_oRiaq UK008D 2025-12-30T14:11:08.084Z 2025-12-31T14:33:31.276Z

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