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

5,952 rows where station_code = "UK00AJ" 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
9273489 9273489 20260128063141_Px5G3 UK00AJ 2026-01-29T14:29:59.877Z 2026-01-29T14:30:25.823Z
9273188 9273188 20260128050452_PH2NO UK00AJ 2026-01-29T14:28:58.855Z 2026-01-29T14:30:25.766Z
9252639 9252639 20260123045245_kP0cH UK00AJ 2026-01-24T14:16:31.789Z 2026-01-29T14:53:13.002Z
9243892 9243892 20260121053025_bMU6n UK00AJ 2026-01-22T14:23:27.778Z 2026-01-29T15:05:32.283Z
9243864 9243864 20260121052708_2le1Y UK00AJ 2026-01-22T14:23:23.189Z 2026-01-29T15:05:30.551Z
9243726 9243726 20260121051110_6xiHH UK00AJ 2026-01-22T14:22:51.146Z 2026-01-29T15:05:25.160Z
9243724 9243724 20260121051102_9W0ME UK00AJ 2026-01-22T14:22:50.691Z 2026-01-29T15:05:24.967Z
9243625 9243625 20260121045256_zIGU2 UK00AJ 2026-01-22T14:22:26.674Z 2026-01-29T15:05:20.391Z
9243545 9243545 20260121044734_RJKzb UK00AJ 2026-01-22T14:22:10.210Z 2026-01-29T15:05:17.350Z
9243527 9243527 20260121044616_OpnF1 UK00AJ 2026-01-22T14:22:09.065Z 2026-01-29T15:05:17.039Z
9243340 9243340 20260121041758_tvEY2 UK00AJ 2026-01-22T14:21:29.319Z 2026-01-29T15:04:56.397Z
9243112 9243112 20260121034323_ZR1WR UK00AJ 2026-01-22T14:20:35.567Z 2026-01-29T15:04:46.812Z
9242959 9242959 20260121032057_YX3Lb UK00AJ 2026-01-22T14:20:07.109Z 2026-01-29T15:04:32.451Z
9242682 9242682 20260121023358_AXQzO UK00AJ 2026-01-22T14:18:48.546Z 2026-01-29T15:04:16.650Z
9242490 9242490 20260121020531_kBnUt UK00AJ 2026-01-22T14:18:02.535Z 2026-01-29T15:04:01.260Z
9242438 9242438 20260121015119_5j3qq UK00AJ 2026-01-22T14:17:51.732Z 2026-01-29T15:03:58.807Z
9223217 9223217 20260117234926_xJYZf UK00AJ 2026-01-19T14:18:18.304Z 2026-01-26T15:01:58.384Z
9223164 9223164 20260117233135_h3o1Y UK00AJ 2026-01-19T14:17:59.014Z 2026-01-26T15:01:56.327Z
9223098 9223098 20260117230328_zGMuh UK00AJ 2026-01-19T14:17:43.958Z 2026-01-26T15:01:49.425Z
9223071 9223071 20260117225332_294VJ UK00AJ 2026-01-19T14:17:32.613Z 2026-01-26T15:01:34.266Z
9222879 9222879 20260117211154_rIWrz UK00AJ 2026-01-19T14:16:39.550Z 2026-01-26T15:01:24.283Z
9222876 9222876 20260117211037_O9GZx UK00AJ 2026-01-19T14:16:38.853Z 2026-01-26T15:01:24.106Z
9222831 9222831 20260117210018_0P2WB UK00AJ 2026-01-19T14:16:26.237Z 2026-01-26T15:01:22.555Z
9222719 9222719 20260117202703_5wpd0 UK00AJ 2026-01-19T14:15:55.812Z 2026-01-26T15:01:18.355Z
9222644 9222644 20260117201220_cEgqb UK00AJ 2026-01-19T14:15:40.772Z 2026-01-26T15:01:15.895Z
9222638 9222638 20260117201219_EsUg2 UK00AJ 2026-01-19T14:15:40.240Z 2026-01-26T15:01:15.817Z
9218914 9218914 20260117062905_tXGqn UK00AJ 2026-01-18T14:14:11.321Z 2026-01-25T14:58:55.491Z
9218881 9218881 20260117061752_IL8ik UK00AJ 2026-01-18T14:14:03.911Z 2026-01-25T14:58:54.481Z
9214552 9214552 20260116065329_2v3zT UK00AJ 2026-01-17T14:22:03.838Z 2026-01-24T15:13:51.294Z
9208798 9208798 20260115065305_G4oT2 UK00AJ 2026-01-16T14:14:02.195Z 2026-01-22T15:04:40.256Z
9208767 9208767 20260115064405_PJvQq UK00AJ 2026-01-16T14:13:54.114Z 2026-01-22T15:04:39.330Z
9208731 9208731 20260115063929_3Mxm4 UK00AJ 2026-01-16T14:13:47.185Z 2026-01-22T15:04:38.428Z
9208397 9208397 20260115051544_XQHDn UK00AJ 2026-01-16T14:12:31.349Z 2026-01-22T15:04:12.601Z
9208232 9208232 20260115044228_BbYnv UK00AJ 2026-01-16T14:11:48.402Z 2026-01-22T15:04:05.026Z
9208111 9208111 20260115041737_9Lk1X UK00AJ 2026-01-16T14:11:22.705Z 2026-01-22T15:04:01.692Z
9207944 9207944 20260115033847_0fPcb UK00AJ 2026-01-16T14:10:46.546Z 2026-01-22T15:03:57.131Z
9207903 9207903 20260115033036_M96cJ UK00AJ 2026-01-16T14:10:35.371Z 2026-01-22T15:03:56.164Z
9207879 9207879 20260115032618_z8L4w UK00AJ 2026-01-16T14:10:30.975Z 2026-01-22T15:03:55.589Z
9207463 9207463 20260115014357_An0LJ UK00AJ 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207429 9207429 20260115013843_UBaVo UK00AJ 2026-01-16T14:08:44.038Z 2026-01-22T15:03:21.805Z
9207417 9207417 20260115013347_O5B41 UK00AJ 2026-01-16T14:08:41.083Z 2026-01-22T15:03:21.433Z
9207397 9207397 20260115012407_EG80F UK00AJ 2026-01-16T14:08:36.469Z 2026-01-22T15:03:20.815Z
9207371 9207371 20260115011602_jC28n UK00AJ 2026-01-16T14:08:27.947Z 2026-01-22T15:03:20.155Z
9207350 9207350 20260115010717_KQOL1 UK00AJ 2026-01-16T14:08:22.044Z 2026-01-22T15:03:19.484Z
9207273 9207273 20260115003323_gorVx UK00AJ 2026-01-16T14:08:02.696Z 2026-01-22T15:03:17.058Z
9207270 9207270 20260115003200_uoJde UK00AJ 2026-01-16T14:08:02.121Z 2026-01-22T15:03:16.920Z
9203540 9203540 20260114051659_iw0yf UK00AJ 2026-01-15T14:24:45.468Z 2026-01-22T15:10:09.736Z
9203122 9203122 20260114043538_hezV1 UK00AJ 2026-01-15T14:23:22.016Z 2026-01-22T15:10:01.992Z
9203069 9203069 20260114043113_ai005 UK00AJ 2026-01-15T14:23:14.691Z 2026-01-22T15:10:01.153Z
9202797 9202797 20260114040826_l5qbF UK00AJ 2026-01-15T14:22:21.995Z 2026-01-22T15:09:41.110Z
9202675 9202675 20260114035955_DWOnW UK00AJ 2026-01-15T14:22:05.953Z 2026-01-22T15:09:24.604Z
9202165 9202165 20260114032157_ChS83 UK00AJ 2026-01-15T14:20:37.382Z 2026-01-22T15:09:14.383Z
9202162 9202162 20260114032140_QXRa8 UK00AJ 2026-01-15T14:20:36.727Z 2026-01-22T15:09:14.334Z
9202041 9202041 20260114031230_qz3FI UK00AJ 2026-01-15T14:20:16.816Z 2026-01-22T15:09:12.317Z
9201769 9201769 20260114024813_80hlf UK00AJ 2026-01-15T14:19:40.026Z 2026-01-22T15:09:09.127Z
9201746 9201746 20260114024722_XwLZQ UK00AJ 2026-01-15T14:19:38.481Z 2026-01-22T15:09:08.925Z
9201609 9201609 20260114023503_3gHxx UK00AJ 2026-01-15T14:19:10.329Z 2026-01-22T15:09:06.619Z
9201369 9201369 20260114021149_M2Jym UK00AJ 2026-01-15T14:18:22.599Z 2026-01-22T15:09:02.514Z
9201229 9201229 20260114015720_LX3t1 UK00AJ 2026-01-15T14:17:54.245Z 2026-01-22T15:08:59.982Z
9201138 9201138 20260114014829_TG0LB UK00AJ 2026-01-15T14:17:37.314Z 2026-01-22T15:08:58.236Z
9200957 9200957 20260114012554_VgaJw UK00AJ 2026-01-15T14:17:06.085Z 2026-01-22T15:08:40.649Z
9200638 9200638 20260114004246_Y5tQK UK00AJ 2026-01-15T14:15:51.946Z 2026-01-22T15:08:22.439Z
9200533 9200533 20260114002151_vkE8t UK00AJ 2026-01-15T14:15:28.654Z 2026-01-22T15:08:17.881Z
9200455 9200455 20260114001234_63k2I UK00AJ 2026-01-15T14:15:14.526Z 2026-01-22T15:08:16.216Z
9200415 9200415 20260114000623_DX36d UK00AJ 2026-01-15T14:15:10.035Z 2026-01-22T15:08:15.697Z
9200345 9200345 20260113235058_kFL9z UK00AJ 2026-01-15T14:14:47.256Z 2026-01-22T15:08:14.301Z
9200312 9200312 20260113234111_aVVhL UK00AJ 2026-01-15T14:14:42.084Z 2026-01-22T15:08:13.685Z
9200301 9200301 20260113233756_ipWWP UK00AJ 2026-01-15T14:14:39.338Z 2026-01-22T15:08:13.450Z
9200186 9200186 20260113230741_fQ0YU UK00AJ 2026-01-15T14:14:07.589Z 2026-01-22T15:08:10.936Z
9200028 9200028 20260113222608_teTHG UK00AJ 2026-01-15T14:13:34.622Z 2026-01-22T15:08:07.982Z
9199341 9199341 20260113194737_1soDa UK00AJ 2026-01-15T14:10:28.081Z 2026-01-22T15:07:22.293Z
9199272 9199272 20260113193640_jmweB UK00AJ 2026-01-15T14:10:11.942Z 2026-01-22T15:07:18.385Z
9199042 9199042 20260113185357_At23q UK00AJ 2026-01-15T14:09:00.072Z 2026-01-22T15:07:12.485Z
9198989 9198989 20260113184701_1OmjL UK00AJ 2026-01-15T14:08:42.910Z 2026-01-22T15:07:11.082Z
9198696 9198696 20260113173834_8cBsD UK00AJ 2026-01-15T14:06:30.497Z 2026-01-22T15:07:01.108Z
9188256 9188256 20260111214836_rCL5z UK00AJ 2026-01-13T14:11:17.111Z 2026-01-20T15:21:30.031Z
9180164 9180164 20260110192444_Xm7g1 UK00AJ 2026-01-12T14:06:02.094Z 2026-01-19T15:15:49.203Z
9102516 9102516 20251230030853_fUyOY UK00AJ 2025-12-31T14:14:13.726Z 2026-01-07T15:07:42.785Z
9099793 9099793 20251225185822_Oaufi UK00AJ 2025-12-30T15:36:06.480Z 2026-01-02T15:48:03.435Z
9099306 9099306 20251226201432_qWkoQ UK00AJ 2025-12-30T15:23:18.627Z 2026-01-03T15:43:39.324Z
9099171 9099171 20251226183430_mAXfP UK00AJ 2025-12-30T15:22:37.994Z 2026-01-03T15:42:53.670Z
9093274 9093274 20251227050620_aPbV2 UK00AJ 2025-12-30T15:02:51.159Z 2026-01-04T15:29:48.393Z
9093075 9093075 20251227042335_63ZAa UK00AJ 2025-12-30T15:01:51.938Z 2026-01-04T15:29:05.783Z
9092675 9092675 20251227021156_STsgA UK00AJ 2025-12-30T14:59:43.819Z 2026-01-04T15:26:49.738Z
9092124 9092124 20251226225112_0Xm2Q UK00AJ 2025-12-30T14:56:50.315Z 2026-01-04T15:23:57.090Z
9092082 9092082 20251226223707_Kc3TO UK00AJ 2025-12-30T14:56:44.032Z 2025-12-30T14:56:44.032Z
9075408 9075408 20251225213325_uBnUn UK00AJ 2025-12-29T15:02:03.578Z 2026-01-02T15:48:51.384Z
9075329 9075329 20251225212618_wQ3Gt UK00AJ 2025-12-29T15:02:00.763Z 2026-01-02T15:48:49.963Z
9075250 9075250 20251225212041_ZyL3H UK00AJ 2025-12-29T15:01:38.086Z 2026-01-02T15:48:47.165Z
9074947 9074947 20251225204852_aQNjE UK00AJ 2025-12-29T15:01:24.340Z 2026-01-02T15:48:40.954Z
9074511 9074511 20251225200952_wVc5Q UK00AJ 2025-12-29T15:00:58.046Z 2026-01-02T15:48:32.646Z
9074002 9074002 20251225185942_AD98k UK00AJ 2025-12-29T15:00:01.755Z 2026-01-02T15:48:04.848Z
9073985 9073985 20251225185822_mJ9Gb UK00AJ 2025-12-29T15:00:01.386Z 2026-01-02T15:48:03.908Z
9073856 9073856 20251225183708_TqGPr UK00AJ 2025-12-29T14:59:55.821Z 2026-01-02T15:47:59.213Z
9073666 9073666 20251225181334_zqysj UK00AJ 2025-12-29T14:59:49.346Z 2026-01-02T15:47:55.695Z
9073649 9073649 20251225181130_74XzE UK00AJ 2025-12-29T14:59:48.885Z 2025-12-29T14:59:48.885Z
9072969 9072969 20251225065858_91pdH UK00AJ 2025-12-29T14:56:59.232Z 2026-01-02T15:45:46.973Z
9072086 9072086 20251226201803_raaoi UK00AJ 2025-12-29T14:50:22.244Z 2026-01-03T15:43:41.167Z
9072068 9072068 20251226201432_49gtb UK00AJ 2025-12-29T14:50:21.534Z 2025-12-29T14:51:19.179Z
9071638 9071638 20251226190640_qErIR UK00AJ 2025-12-29T14:49:40.241Z 2026-01-03T15:43:05.320Z

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