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,740 rows where station_code = "UK0051" 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
8682766 8682766 20251203060230_hoARe UK0051 2025-12-04T14:17:59.168Z 2025-12-05T14:22:49.329Z
8682746 8682746 20251203060131_VwDNX UK0051 2025-12-04T14:17:57.855Z 2025-12-05T14:22:48.713Z
8682724 8682724 20251203060113_uGIfl UK0051 2025-12-04T14:17:56.730Z 2025-12-05T14:22:48.364Z
8682659 8682659 20251203055744_kmMiZ UK0051 2025-12-04T14:17:52.442Z 2025-12-05T14:22:46.734Z
8682647 8682647 20251203055550_t5K2B UK0051 2025-12-04T14:17:51.453Z 2025-12-05T14:22:46.494Z
8682548 8682548 20251203054357_Nrf1h UK0051 2025-12-04T14:17:25.873Z 2025-12-05T14:22:42.196Z
8682488 8682488 20251203054014_eCWCr UK0051 2025-12-04T14:17:18.709Z 2025-12-05T14:22:40.526Z
8682482 8682482 20251203053927_Hni9S UK0051 2025-12-04T14:17:18.017Z 2025-12-05T14:22:40.289Z
8682427 8682427 20251203053210_hToga UK0051 2025-12-04T14:17:09.710Z 2025-12-05T14:22:37.270Z
8682050 8682050 20251203044319_k087G UK0051 2025-12-04T14:16:17.124Z 2025-12-05T14:22:12.807Z
8682030 8682030 20251203044152_NckDt UK0051 2025-12-04T14:16:15.082Z 2025-12-05T14:22:12.231Z
8681945 8681945 20251203043132_cOhPC UK0051 2025-12-04T14:16:02.850Z 2025-12-05T14:22:09.215Z
8681806 8681806 20251203040912_8gItg UK0051 2025-12-04T14:15:38.726Z 2025-12-05T14:22:01.901Z
8681740 8681740 20251203035128_BTB3h UK0051 2025-12-04T14:15:28.935Z 2025-12-05T14:21:51.843Z
8681694 8681694 20251203034828_pZm3I UK0051 2025-12-04T14:15:17.916Z 2025-12-05T14:21:49.550Z
8681527 8681527 20251203032141_8pUPY UK0051 2025-12-04T14:14:52.230Z 2025-12-05T14:21:40.258Z
8680718 8680718 20251203010849_CDsFV UK0051 2025-12-04T14:12:47.369Z 2025-12-05T14:20:57.774Z
8680592 8680592 20251203004458_mESuj UK0051 2025-12-04T14:12:25.992Z 2025-12-05T14:20:48.202Z
8680558 8680558 20251203002734_pLFTS UK0051 2025-12-04T14:12:21.270Z 2025-12-05T14:20:44.449Z
8680507 8680507 20251203001950_R5Rsc UK0051 2025-12-04T14:12:12.994Z 2025-12-05T14:20:40.948Z
8680416 8680416 20251202235333_0LN27 UK0051 2025-12-04T14:11:56.606Z 2025-12-05T14:20:37.479Z
8680362 8680362 20251202233837_iUuvC UK0051 2025-12-04T14:11:52.170Z 2025-12-05T14:20:35.882Z
8679016 8679016 20251202183305_xxl2i UK0051 2025-12-04T14:08:46.756Z 2025-12-05T14:19:16.457Z
8676990 8676990 20251202063646_Mby5B UK0051 2025-12-03T14:25:59.481Z 2025-12-05T14:29:17.468Z
8676250 8676250 20251202054240_33N6s UK0051 2025-12-03T14:24:50.849Z 2025-12-05T14:28:51.026Z
8675950 8675950 20251202052638_S0pgo UK0051 2025-12-03T14:24:33.206Z 2025-12-05T14:28:45.047Z
8675634 8675634 20251202050326_3Zc6C UK0051 2025-12-03T14:23:57.612Z 2025-12-05T14:28:37.073Z
8675437 8675437 20251202044009_zAaMx UK0051 2025-12-03T14:23:43.420Z 2025-12-05T14:28:32.167Z
8675231 8675231 20251202042010_uTjqa UK0051 2025-12-03T14:23:22.644Z 2025-12-05T14:28:17.455Z
8674910 8674910 20251202033911_I3zY7 UK0051 2025-12-03T14:22:42.450Z 2025-12-05T14:28:06.331Z
8674828 8674828 20251202032821_Exk2D UK0051 2025-12-03T14:22:27.759Z 2025-12-05T14:28:03.995Z
8674819 8674819 20251202032820_6pifZ UK0051 2025-12-03T14:22:27.079Z 2025-12-05T14:28:03.872Z
8674789 8674789 20251202032557_KX0Mn UK0051 2025-12-03T14:22:25.768Z 2025-12-05T14:28:03.253Z
8674755 8674755 20251202032036_oWjBH UK0051 2025-12-03T14:22:18.352Z 2025-12-05T14:28:02.019Z
8674684 8674684 20251202030654_KY8Fp UK0051 2025-12-03T14:22:12.546Z 2025-12-05T14:27:59.656Z
8674483 8674483 20251202023306_d0ZQJ UK0051 2025-12-03T14:21:41.830Z 2025-12-05T14:27:42.991Z
8674342 8674342 20251202020608_eXtt3 UK0051 2025-12-03T14:21:26.997Z 2025-12-05T14:27:38.463Z
8674157 8674157 20251202013721_L6SpO UK0051 2025-12-03T14:21:02.686Z 2025-12-05T14:27:30.885Z
8674151 8674151 20251202013605_1M2uR UK0051 2025-12-03T14:21:00.989Z 2025-12-05T14:27:30.710Z
8674010 8674010 20251202010412_rYU0P UK0051 2025-12-03T14:20:43.620Z 2025-12-05T14:27:25.928Z
8673924 8673924 20251202003610_0ka91 UK0051 2025-12-03T14:20:23.600Z 2025-12-05T14:27:23.213Z
8657953 8657953 20251130062207_DRvvX UK0051 2025-12-01T14:34:47.456Z 2025-12-05T14:45:59.260Z
8657865 8657865 20251130061352_My5yj UK0051 2025-12-01T14:34:44.237Z 2025-12-05T14:45:46.718Z
8657660 8657660 20251130055628_qz2ZG UK0051 2025-12-01T14:34:36.262Z 2025-12-05T14:45:34.647Z
8656738 8656738 20251130050808_dzI2O UK0051 2025-12-01T14:28:58.814Z 2025-12-05T14:45:20.413Z
8656428 8656428 20251130045602_Nw3vd UK0051 2025-12-01T14:28:38.417Z 2025-12-05T14:45:16.041Z
8656082 8656082 20251130043551_MpkYN UK0051 2025-12-01T14:28:01.958Z 2025-12-05T14:44:45.353Z
8655018 8655018 20251130034109_FqO69 UK0051 2025-12-01T14:26:16.337Z 2025-12-05T14:44:26.922Z
8654916 8654916 20251130033835_6Hrmw UK0051 2025-12-01T14:26:10.527Z 2025-12-05T14:44:25.887Z
8654300 8654300 20251130030857_G2f9e UK0051 2025-12-01T14:25:07.117Z 2025-12-05T14:43:52.999Z
8654279 8654279 20251130030714_RJXRC UK0051 2025-12-01T14:25:04.073Z 2025-12-05T14:43:52.463Z
8654114 8654114 20251130025941_YAbUU UK0051 2025-12-01T14:24:52.876Z 2025-12-05T14:43:47.547Z
8654047 8654047 20251130025452_VIEVI UK0051 2025-12-01T14:24:46.674Z 2025-12-05T14:43:45.623Z
8653973 8653973 20251130025000_gAhit UK0051 2025-12-01T14:24:34.009Z 2025-12-05T14:43:43.812Z
8653282 8653282 20251130020559_U7Jmc UK0051 2025-12-01T14:23:09.308Z 2025-12-05T14:43:16.111Z
8653187 8653187 20251130020132_X5NUJ UK0051 2025-12-01T14:23:02.854Z 2025-12-05T14:43:05.197Z
8652416 8652416 20251130010722_MnFCp UK0051 2025-12-01T14:21:21.721Z 2025-12-05T14:42:43.991Z
8652204 8652204 20251130005516_PQ6dv UK0051 2025-12-01T14:20:54.885Z 2025-12-05T14:42:36.103Z
8651687 8651687 20251130001021_PPt3x UK0051 2025-12-01T14:19:41.303Z 2025-12-05T14:42:03.531Z
8651603 8651603 20251129235948_n0n2x UK0051 2025-12-01T14:19:26.949Z 2025-12-05T14:42:01.776Z
8651587 8651587 20251129235802_7RnYJ UK0051 2025-12-01T14:19:24.896Z 2025-12-05T14:42:01.268Z
8651046 8651046 20251129223159_WGWDm UK0051 2025-12-01T14:17:53.995Z 2025-12-05T14:41:41.682Z
8650561 8650561 20251129204119_ZnC7J UK0051 2025-12-01T14:16:28.898Z 2025-12-05T14:41:10.849Z
8650283 8650283 20251129194842_6fLvp UK0051 2025-12-01T14:15:42.856Z 2025-12-05T14:41:02.493Z
8635788 8635788 20251128024732_ZBXL2 UK0051 2025-11-29T14:24:09.654Z 2025-12-05T14:59:14.670Z
8635744 8635744 20251128024308_z2nBd UK0051 2025-11-29T14:24:06.729Z 2025-12-05T14:59:14.005Z
8635613 8635613 20251128023223_by6fS UK0051 2025-11-29T14:23:56.499Z 2025-12-05T14:59:11.635Z
8633227 8633227 20251127225457_YqqWI UK0051 2025-11-29T14:19:16.982Z 2025-12-05T14:57:22.779Z
8633140 8633140 20251127224356_EKK1e UK0051 2025-11-29T14:19:02.238Z 2025-12-05T14:57:15.890Z
8616536 8616536 20251126060426_riSUC UK0051 2025-11-27T14:31:15.844Z 2025-12-04T15:11:40.602Z
8616517 8616517 20251126060424_oAUDz UK0051 2025-11-27T14:31:15.455Z 2025-12-04T15:11:40.505Z
8616360 8616360 20251126055303_4o753 UK0051 2025-11-27T14:31:06.405Z 2025-12-04T15:11:38.267Z
8615938 8615938 20251126052850_JwF8M UK0051 2025-11-27T14:30:18.010Z 2025-12-04T15:11:33.894Z
8615688 8615688 20251126051305_9eqfH UK0051 2025-11-27T14:30:05.446Z 2025-12-04T15:11:31.279Z
8615643 8615643 20251126051211_veiAP UK0051 2025-11-27T14:30:04.017Z 2025-12-04T15:11:31.112Z
8615534 8615534 20251126050859_rn3Iz UK0051 2025-11-27T14:29:40.288Z 2025-12-04T15:11:30.122Z
8615389 8615389 20251126050139_moQK8 UK0051 2025-11-27T14:29:29.991Z 2025-12-04T15:11:28.299Z
8615269 8615269 20251126045239_sfBRF UK0051 2025-11-27T14:29:23.404Z 2025-12-04T15:11:27.237Z
8615092 8615092 20251126044510_WK7mH UK0051 2025-11-27T14:29:10.582Z 2025-12-04T15:11:25.891Z
8615078 8615078 20251126044459_559Az UK0051 2025-11-27T14:29:05.392Z 2025-12-04T15:11:25.830Z
8614889 8614889 20251126043436_7j4Es UK0051 2025-11-27T14:28:41.554Z 2025-12-04T15:11:17.759Z
8614805 8614805 20251126042937_9bIUq UK0051 2025-11-27T14:28:34.643Z 2025-12-04T15:11:11.686Z
8614744 8614744 20251126042545_0y20l UK0051 2025-11-27T14:28:31.063Z 2025-12-04T15:11:03.369Z
8614480 8614480 20251126041351_OGW6O UK0051 2025-11-27T14:27:54.442Z 2025-12-04T15:10:43.882Z
8614278 8614278 20251126040231_l9iqT UK0051 2025-11-27T14:27:43.832Z 2025-12-04T15:10:34.151Z
8612883 8612883 20251126025447_V3q3y UK0051 2025-11-27T14:24:58.034Z 2025-12-04T15:09:35.584Z
8612726 8612726 20251126024309_04kAT UK0051 2025-11-27T14:24:32.139Z 2025-12-04T15:09:33.289Z
8612638 8612638 20251126024036_Low24 UK0051 2025-11-27T14:24:25.530Z 2025-12-04T15:09:32.343Z
8612299 8612299 20251126022524_cksrV UK0051 2025-11-27T14:23:45.149Z 2025-12-04T15:09:29.371Z
8612193 8612193 20251126022128_KaUQ1 UK0051 2025-11-27T14:23:36.336Z 2025-12-04T15:09:28.206Z
8611760 8611760 20251126015805_kI7K3 UK0051 2025-11-27T14:22:37.007Z 2025-12-04T15:09:23.934Z
8611721 8611721 20251126015734_lAFBU UK0051 2025-11-27T14:22:32.697Z 2025-12-04T15:09:23.725Z
8611535 8611535 20251126015031_2D4cY UK0051 2025-11-27T14:22:17.457Z 2025-12-04T15:09:22.243Z
8611036 8611036 20251126011759_j7szt UK0051 2025-11-27T14:21:07.528Z 2025-12-04T15:08:49.913Z
8610852 8610852 20251126011114_legL0 UK0051 2025-11-27T14:20:53.545Z 2025-12-04T15:08:43.739Z
8610768 8610768 20251126010751_MyuuC UK0051 2025-11-27T14:20:49.812Z 2025-12-04T15:08:40.205Z
8610502 8610502 20251126005006_Zx0EX UK0051 2025-11-27T14:20:15.043Z 2025-12-04T15:08:06.817Z
8610426 8610426 20251126004518_5mYtx UK0051 2025-11-27T14:20:07.328Z 2025-12-04T15:08:05.549Z
8610265 8610265 20251126003513_oe2OT UK0051 2025-11-27T14:19:41.196Z 2025-12-04T15:08:03.767Z
8610119 8610119 20251126002449_XHNUX UK0051 2025-11-27T14:19:28.674Z 2025-12-04T15:08:02.604Z

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