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,311 rows where station_code = "UK0086" 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
9272562 9272562 20260128023651_kyrCs UK0086 2026-01-29T14:27:10.560Z 2026-01-29T14:30:25.378Z
9271901 9271901 20260127214256_dZAVh UK0086 2026-01-29T14:24:53.434Z 2026-01-29T14:30:25.227Z
9271601 9271601 20260127182817_W8iBN UK0086 2026-01-29T14:21:43.053Z 2026-01-29T14:30:24.962Z
9255556 9255556 20260124041149_9pjK2 UK0086 2026-01-25T14:13:57.351Z 2026-01-29T14:47:40.120Z
9255281 9255281 20260124023032_PYBWT UK0086 2026-01-25T14:12:39.584Z 2026-01-29T14:47:17.815Z
9252589 9252589 20260123043111_jr5D4 UK0086 2026-01-24T14:16:19.377Z 2026-01-29T14:53:10.278Z
9252559 9252559 20260123041140_3Aule UK0086 2026-01-24T14:16:11.901Z 2026-01-29T14:53:08.558Z
9252538 9252538 20260123035752_h0eaJ UK0086 2026-01-24T14:16:05.045Z 2026-01-29T14:53:07.063Z
9252500 9252500 20260123034057_9NHyi UK0086 2026-01-24T14:15:53.880Z 2026-01-29T14:53:04.599Z
9243749 9243749 20260121051231_9qaXR UK0086 2026-01-22T14:22:54.959Z 2026-01-29T15:05:26.057Z
9243729 9243729 20260121051126_WpNVv UK0086 2026-01-22T14:22:51.781Z 2026-01-29T15:05:25.253Z
9243395 9243395 20260121042758_dhGNg UK0086 2026-01-22T14:21:37.931Z 2026-01-29T15:05:00.590Z
9243154 9243154 20260121034937_swgHw UK0086 2026-01-22T14:20:48.189Z 2026-01-29T15:04:48.695Z
9243078 9243078 20260121034111_YliDK UK0086 2026-01-22T14:20:32.042Z 2026-01-29T15:04:46.042Z
9242751 9242751 20260121023919_6MEO0 UK0086 2026-01-22T14:19:08.131Z 2026-01-29T15:04:19.543Z
9237267 9237267 20260120045618_3ocAa UK0086 2026-01-21T14:25:48.536Z 2026-01-28T15:01:06.724Z
9222190 9222190 20260117183944_bfK38 UK0086 2026-01-19T14:13:41.365Z 2026-01-26T15:00:43.403Z
9217895 9217895 20260116202356_T8wgu UK0086 2026-01-18T14:09:30.622Z 2026-01-25T14:57:51.135Z
9217614 9217614 20260116183129_n7LDf UK0086 2026-01-18T14:08:12.198Z 2026-01-25T14:57:28.159Z
9208358 9208358 20260115051134_6pTgb UK0086 2026-01-16T14:12:19.857Z 2026-01-22T15:04:11.197Z
9208189 9208189 20260115043207_3jquF UK0086 2026-01-16T14:11:39.362Z 2026-01-22T15:04:03.705Z
9208063 9208063 20260115040824_16PP1 UK0086 2026-01-16T14:11:11.890Z 2026-01-22T15:04:00.424Z
9207707 9207707 20260115024922_Pn93C UK0086 2026-01-16T14:09:44.782Z 2026-01-22T15:03:30.423Z
9207663 9207663 20260115024024_3C3fJ UK0086 2026-01-16T14:09:36.082Z 2026-01-22T15:03:29.450Z
9207658 9207658 20260115024024_xeJ76 UK0086 2026-01-16T14:09:35.472Z 2026-01-22T15:03:29.371Z
9207581 9207581 20260115022118_zHocR UK0086 2026-01-16T14:09:18.541Z 2026-01-22T15:03:26.894Z
9207562 9207562 20260115021616_yEwt6 UK0086 2026-01-16T14:09:14.444Z 2026-01-22T15:03:24.946Z
9207229 9207229 20260115000234_nDRMF UK0086 2026-01-16T14:07:48.458Z 2026-01-22T15:03:15.221Z
9207219 9207219 20260114235932_33Nde UK0086 2026-01-16T14:07:44.201Z 2026-01-22T15:03:14.940Z
9204375 9204375 20260114063432_jOntL UK0086 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204173 9204173 20260114061351_rS9rc UK0086 2026-01-15T14:26:36.428Z 2026-01-22T15:10:21.826Z
9204093 9204093 20260114060620_3xRAY UK0086 2026-01-15T14:26:23.073Z 2026-01-22T15:10:17.812Z
9203796 9203796 20260114053755_0mbQ3 UK0086 2026-01-15T14:25:24.539Z 2026-01-22T15:10:13.617Z
9203759 9203759 20260114053525_kPJoE UK0086 2026-01-15T14:25:21.609Z 2026-01-22T15:10:13.158Z
9203469 9203469 20260114050007_PrHJA UK0086 2026-01-15T14:24:30.205Z 2026-01-22T15:10:08.401Z
9202861 9202861 20260114041403_ZHM2q UK0086 2026-01-15T14:22:39.958Z 2026-01-22T15:09:58.206Z
9202436 9202436 20260114033811_yhIke UK0086 2026-01-15T14:21:18.712Z 2026-01-22T15:09:18.607Z
9202416 9202416 20260114033619_uZ0Io UK0086 2026-01-15T14:21:14.289Z 2026-01-22T15:09:17.411Z
9202179 9202179 20260114032201_e54Vx UK0086 2026-01-15T14:20:39.005Z 2026-01-22T15:09:14.449Z
9202131 9202131 20260114032010_z39Qj UK0086 2026-01-15T14:20:34.559Z 2026-01-22T15:09:13.968Z
9202073 9202073 20260114031524_UphhA UK0086 2026-01-15T14:20:23.261Z 2026-01-22T15:09:13.053Z
9201455 9201455 20260114021828_qKoF4 UK0086 2026-01-15T14:18:41.266Z 2026-01-22T15:09:04.098Z
9201346 9201346 20260114021131_Ba0W3 UK0086 2026-01-15T14:18:17.804Z 2026-01-22T15:09:02.140Z
9201318 9201318 20260114021016_iG6uC UK0086 2026-01-15T14:18:15.004Z 2026-01-22T15:09:01.796Z
9201268 9201268 20260114020217_rJ3I6 UK0086 2026-01-15T14:18:06.588Z 2026-01-22T15:09:00.738Z
9200778 9200778 20260114010248_YJOf5 UK0086 2026-01-15T14:16:23.426Z 2026-01-22T15:08:25.470Z
9200336 9200336 20260113234619_l56KF UK0086 2026-01-15T14:14:45.793Z 2026-01-22T15:08:14.064Z
9200237 9200237 20260113232529_7ppjc UK0086 2026-01-15T14:14:18.932Z 2026-01-22T15:08:12.007Z
9200090 9200090 20260113225110_HaZho UK0086 2026-01-15T14:13:45.229Z 2026-01-22T15:08:09.491Z
9199957 9199957 20260113220438_us4N1 UK0086 2026-01-15T14:13:11.828Z 2026-01-22T15:08:06.517Z
9199897 9199897 20260113214828_JK1bP UK0086 2026-01-15T14:12:59.720Z 2026-01-22T15:08:05.028Z
9199564 9199564 20260113202632_sW9tK UK0086 2026-01-15T14:11:29.424Z 2026-01-22T15:07:30.651Z
9198896 9198896 20260113182653_TDCek UK0086 2026-01-15T14:08:01.279Z 2026-01-22T15:07:08.349Z
9194643 9194643 20260112213729_XNEM3 UK0086 2026-01-14T14:10:05.959Z 2026-01-21T15:04:19.516Z
9194094 9194094 20260112174645_eioky UK0086 2026-01-14T14:07:14.631Z 2026-01-21T15:03:29.506Z
9163462 9163462 20260107064751_Sgmky UK0086 2026-01-08T14:09:12.724Z 2026-01-13T15:03:16.496Z
9163443 9163443 20260107064024_uWf7u UK0086 2026-01-08T14:09:10.481Z 2026-01-13T15:03:15.746Z
9157895 9157895 20260105191351_TeRo3 UK0086 2026-01-07T14:04:04.627Z 2026-01-13T15:06:43.904Z
9157800 9157800 20260105184832_PQM9w UK0086 2026-01-07T14:03:36.506Z 2026-01-13T15:06:29.849Z
9151827 9151827 20260105063839_1VLch UK0086 2026-01-06T14:14:50.522Z 2026-01-13T15:15:07.944Z
9151679 9151679 20260105061655_k5htu UK0086 2026-01-06T14:14:22.583Z 2026-01-13T15:15:00.897Z
9151612 9151612 20260105060322_h54WX UK0086 2026-01-06T14:14:09.700Z 2026-01-13T15:14:57.710Z
9151409 9151409 20260105052851_HCS3Q UK0086 2026-01-06T14:13:35.927Z 2026-01-13T15:14:41.501Z
9151400 9151400 20260105052849_s8usL UK0086 2026-01-06T14:13:35.336Z 2026-01-13T15:14:41.372Z
9151264 9151264 20260105050549_799vt UK0086 2026-01-06T14:13:08.260Z 2026-01-13T15:14:34.108Z
9151156 9151156 20260105044818_3xdph UK0086 2026-01-06T14:12:48.877Z 2026-01-13T15:14:29.354Z
9132374 9132374 20260103063650_x0Lwf UK0086 2026-01-04T14:16:27.274Z 2026-01-10T15:01:25.046Z
9131514 9131514 20260103053001_bw7BE UK0086 2026-01-04T14:14:11.957Z 2026-01-10T15:00:31.547Z
9131495 9131495 20260103052824_yoZtI UK0086 2026-01-04T14:14:10.075Z 2026-01-10T15:00:31.103Z
9131474 9131474 20260103052743_TP4eo UK0086 2026-01-04T14:14:05.748Z 2026-01-10T15:00:30.743Z
9131318 9131318 20260103051119_8ZjYX UK0086 2026-01-04T14:13:27.591Z 2026-01-10T15:00:21.793Z
9131170 9131170 20260103045740_j6d2P UK0086 2026-01-04T14:12:53.793Z 2026-01-10T15:00:08.105Z
9128060 9128060 20260102060658_FWX2P UK0086 2026-01-03T14:13:04.548Z 2026-01-09T14:50:21.908Z
9127869 9127869 20260102054016_WKzam UK0086 2026-01-03T14:12:22.483Z 2026-01-09T14:50:15.711Z
9116577 9116577 20251231062520_LTalo UK0086 2026-01-01T14:28:25.294Z 2026-01-08T15:11:55.489Z
9116403 9116403 20251231060748_Ybe4X UK0086 2026-01-01T14:27:55.258Z 2026-01-08T15:11:46.411Z
9115599 9115599 20251231051715_o3745 UK0086 2026-01-01T14:25:53.436Z 2026-01-08T15:10:56.503Z
9114868 9114868 20251231043346_navTp UK0086 2026-01-01T14:23:42.383Z 2026-01-08T15:10:11.990Z
9114838 9114838 20251231043303_U2ue3 UK0086 2026-01-01T14:23:40.957Z 2026-01-08T15:10:11.418Z
9114154 9114154 20251231040343_PRlHw UK0086 2026-01-01T14:21:35.597Z 2026-01-08T15:09:26.184Z
9112751 9112751 20251231025044_RULp6 UK0086 2026-01-01T14:16:16.090Z 2026-01-08T15:08:06.383Z
9111201 9111201 20251231004806_BWXA8 UK0086 2026-01-01T14:10:27.210Z 2026-01-08T15:06:20.470Z
9103057 9103057 20251230035318_RtRE8 UK0086 2025-12-31T14:16:18.650Z 2026-01-07T15:08:15.881Z
9092540 9092540 20251227014114_tGjJN UK0086 2025-12-30T14:59:10.037Z 2026-01-04T15:26:17.321Z
9072188 9072188 20251226203431_Skzr8 UK0086 2025-12-29T14:50:28.100Z 2026-01-03T15:43:44.642Z
9066785 9066785 20251226065010_fX5rC UK0086 2025-12-29T14:40:31.401Z 2026-01-03T15:38:03.678Z
9066722 9066722 20251226064154_egspk UK0086 2025-12-29T14:40:27.850Z 2026-01-03T15:38:00.187Z
9066644 9066644 20251226063336_sgcpZ UK0086 2025-12-29T14:40:24.480Z 2026-01-03T15:37:57.393Z
9066637 9066637 20251226063335_CVnUd UK0086 2025-12-29T14:40:24.189Z 2026-01-03T15:37:57.106Z
9066453 9066453 20251226061729_CknvN UK0086 2025-12-29T14:40:01.369Z 2026-01-03T15:37:50.447Z
9066284 9066284 20251226060434_31BVj UK0086 2025-12-29T14:39:49.011Z 2026-01-03T15:37:36.346Z
9066011 9066011 20251226054409_3nsee UK0086 2025-12-29T14:39:17.942Z 2026-01-03T15:37:28.939Z
9065990 9065990 20251226054344_Gj2Um UK0086 2025-12-29T14:39:16.395Z 2025-12-30T15:19:23.564Z
9065929 9065929 20251226054052_1yyWD UK0086 2025-12-29T14:39:12.558Z 2025-12-30T15:19:22.546Z
9065782 9065782 20251226053107_ykIh3 UK0086 2025-12-29T14:39:04.127Z 2026-01-03T15:37:19.409Z
9065645 9065645 20251226052235_YQHch UK0086 2025-12-29T14:38:55.693Z 2026-01-03T15:37:03.051Z
9065516 9065516 20251226051627_s9GLK UK0086 2025-12-29T14:38:38.153Z 2026-01-03T15:36:59.376Z
9065296 9065296 20251226050445_xGJRz UK0086 2025-12-29T14:38:24.748Z 2026-01-03T15:36:50.866Z
9065172 9065172 20251226045722_7lSEF UK0086 2025-12-29T14:38:04.538Z 2026-01-03T15:36:46.943Z
9064352 9064352 20251226040419_2cEPd UK0086 2025-12-29T14:36:46.489Z 2026-01-03T15:36:05.138Z

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