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

6,786 rows where station_code = "UK001K" 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
9260141 9260141 20260125024303_23LVS UK001K 2026-01-26T14:20:24.213Z 2026-01-29T14:43:50.835Z
9252049 9252049 20260123004711_oF1cI UK001K 2026-01-24T14:14:12.439Z 2026-01-29T14:52:25.967Z
9251697 9251697 20260122220923_2qxCh UK001K 2026-01-24T14:12:58.175Z 2026-01-29T14:52:01.531Z
9242898 9242898 20260121031104_7WKP5 UK001K 2026-01-22T14:19:42.260Z 2026-01-29T15:04:28.862Z
9242880 9242880 20260121030753_24OuR UK001K 2026-01-22T14:19:38.994Z 2026-01-29T15:04:26.720Z
9242844 9242844 20260121025826_3aAAJ UK001K 2026-01-22T14:19:32.084Z 2026-01-29T15:04:24.103Z
9242825 9242825 20260121025140_k49Pw UK001K 2026-01-22T14:19:28.490Z 2026-01-29T15:04:23.119Z
9242609 9242609 20260121022407_BB54S UK001K 2026-01-22T14:18:33.479Z 2026-01-29T15:04:13.769Z
9242394 9242394 20260121014513_YiZXK UK001K 2026-01-22T14:17:37.071Z 2026-01-29T15:03:56.949Z
9242289 9242289 20260121012345_Ixlwn UK001K 2026-01-22T14:17:15.546Z 2026-01-29T15:03:42.607Z
9242269 9242269 20260121011933_DnZW5 UK001K 2026-01-22T14:17:06.650Z 2026-01-29T15:03:39.428Z
9242260 9242260 20260121011506_axhXf UK001K 2026-01-22T14:17:05.272Z 2026-01-29T15:03:39.130Z
9242196 9242196 20260121005958_CPCeo UK001K 2026-01-22T14:16:52.046Z 2026-01-29T15:03:36.412Z
9242047 9242047 20260121001412_cS6l3 UK001K 2026-01-22T14:16:00.250Z 2026-01-29T15:03:27.397Z
9241858 9241858 20260120230712_hEntX UK001K 2026-01-22T14:14:58.345Z 2026-01-29T15:03:06.585Z
9223532 9223532 20260118011327_tobf2 UK001K 2026-01-19T14:19:45.915Z 2026-01-26T15:02:13.312Z
9223010 9223010 20260117221148_Uf2tm UK001K 2026-01-19T14:17:17.461Z 2026-01-26T15:01:31.905Z
9222794 9222794 20260117205259_Ie2LU UK001K 2026-01-19T14:16:16.606Z 2026-01-26T15:01:21.295Z
9222506 9222506 20260117194853_AGkAP UK001K 2026-01-19T14:15:06.057Z 2026-01-26T15:01:11.559Z
9222114 9222114 20260117181239_Dgh2s UK001K 2026-01-19T14:13:22.190Z 2026-01-26T15:00:38.987Z
9218869 9218869 20260117061520_YWbOI UK001K 2026-01-18T14:14:02.655Z 2026-01-25T14:58:54.292Z
9218758 9218758 20260117053749_RRmmL UK001K 2026-01-18T14:13:34.750Z 2026-01-25T14:58:38.407Z
9218694 9218694 20260117051855_XN5HH UK001K 2026-01-18T14:13:14.858Z 2026-01-25T14:58:35.787Z
9218682 9218682 20260117051627_2Jaoh UK001K 2026-01-18T14:13:12.976Z 2026-01-25T14:58:35.449Z
9218641 9218641 20260117050249_LjOVR UK001K 2026-01-18T14:13:02.138Z 2026-01-25T14:58:33.977Z
9218632 9218632 20260117050108_a0eK3 UK001K 2026-01-18T14:13:00.160Z 2026-01-25T14:58:33.733Z
9214052 9214052 20260116052754_19ads UK001K 2026-01-17T14:19:50.239Z 2026-01-24T15:13:00.928Z
9213985 9213985 20260116051155_v09X6 UK001K 2026-01-17T14:19:32.000Z 2026-01-24T15:12:56.188Z
9213927 9213927 20260116050215_13JTu UK001K 2026-01-17T14:19:11.466Z 2026-01-24T15:12:51.912Z
9213922 9213922 20260116050204_aYVMH UK001K 2026-01-17T14:19:10.522Z 2026-01-24T15:12:51.696Z
9213790 9213790 20260116044109_AusBp UK001K 2026-01-17T14:18:30.331Z 2026-01-24T15:12:46.622Z
9213603 9213603 20260116040809_AOf9W UK001K 2026-01-17T14:17:44.275Z 2026-01-24T15:12:24.398Z
9213499 9213499 20260116034709_8Ma4z UK001K 2026-01-17T14:17:11.463Z 2026-01-24T15:12:18.363Z
9207225 9207225 20260115000123_B716A UK001K 2026-01-16T14:07:46.296Z 2026-01-22T15:03:15.153Z
9204459 9204459 20260114064419_6zeqz UK001K 2026-01-15T14:27:24.723Z 2026-01-22T15:10:28.616Z
9203487 9203487 20260114050521_SppHq UK001K 2026-01-15T14:24:32.971Z 2026-01-22T15:10:08.624Z
9203363 9203363 20260114045245_mIJcC UK001K 2026-01-15T14:24:09.946Z 2026-01-22T15:10:06.296Z
9203193 9203193 20260114044235_HY7Zk UK001K 2026-01-15T14:23:38.728Z 2026-01-22T15:10:03.554Z
9203079 9203079 20260114043236_ZQ7WM UK001K 2026-01-15T14:23:16.686Z 2026-01-22T15:10:01.310Z
9202214 9202214 20260114032347_GpkHq UK001K 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202067 9202067 20260114031351_QmZrw UK001K 2026-01-15T14:20:21.300Z 2026-01-22T15:09:12.796Z
9201372 9201372 20260114021150_2tZvb UK001K 2026-01-15T14:18:23.311Z 2026-01-22T15:09:02.584Z
9201365 9201365 20260114021141_Zlff8 UK001K 2026-01-15T14:18:22.054Z 2026-01-22T15:09:02.423Z
9201178 9201178 20260114015133_iv8Zx UK001K 2026-01-15T14:17:44.003Z 2026-01-22T15:08:59.074Z
9201047 9201047 20260114013751_SnET0 UK001K 2026-01-15T14:17:20.760Z 2026-01-22T15:08:55.405Z
9200684 9200684 20260114005214_G5a2f UK001K 2026-01-15T14:16:07.723Z 2026-01-22T15:08:23.556Z
9200544 9200544 20260114002242_ms33p UK001K 2026-01-15T14:15:29.961Z 2026-01-22T15:08:18.020Z
9200432 9200432 20260114000917_uh426 UK001K 2026-01-15T14:15:12.345Z 2026-01-22T15:08:15.994Z
9200315 9200315 20260113234200_ckRZO UK001K 2026-01-15T14:14:43.257Z 2026-01-22T15:08:13.760Z
9176796 9176796 20260110062258_vRtVY UK001K 2026-01-11T14:10:01.044Z 2026-01-18T15:08:54.394Z
9176560 9176560 20260110054249_02msg UK001K 2026-01-11T14:09:19.635Z 2026-01-18T15:08:43.720Z
9176504 9176504 20260110053809_O7tGK UK001K 2026-01-11T14:09:12.398Z 2026-01-18T15:08:41.733Z
9176400 9176400 20260110052622_Tw09M UK001K 2026-01-11T14:08:54.781Z 2026-01-18T15:08:37.856Z
9176372 9176372 20260110052232_XUgaO UK001K 2026-01-11T14:08:50.602Z 2026-01-18T15:08:36.574Z
9176365 9176365 20260110052231_vYJhJ UK001K 2026-01-11T14:08:49.643Z 2026-01-18T15:08:36.151Z
9176131 9176131 20260110045014_CAsfY UK001K 2026-01-11T14:08:15.488Z 2026-01-18T15:08:20.138Z
9176079 9176079 20260110044005_rIrQm UK001K 2026-01-11T14:08:09.666Z 2026-01-18T15:08:18.776Z
9176075 9176075 20260110044000_nS3ch UK001K 2026-01-11T14:08:09.140Z 2026-01-18T15:08:18.644Z
9175917 9175917 20260110041558_K224v UK001K 2026-01-11T14:07:47.866Z 2026-01-18T15:08:13.247Z
9175888 9175888 20260110040707_DhqhQ UK001K 2026-01-11T14:07:40.906Z 2026-01-18T15:08:12.248Z
9175807 9175807 20260110034918_27oUf UK001K 2026-01-11T14:07:25.278Z 2026-01-18T15:08:08.953Z
9175770 9175770 20260110034639_RlF29 UK001K 2026-01-11T14:07:20.223Z 2026-01-18T15:08:07.856Z
9175409 9175409 20260110022518_II8cp UK001K 2026-01-11T14:06:22.038Z 2026-01-18T15:07:44.657Z
9175166 9175166 20260110013058_IgQvG UK001K 2026-01-11T14:05:36.071Z 2026-01-18T15:07:35.402Z
9175136 9175136 20260110011325_oOt1f UK001K 2026-01-11T14:05:29.222Z 2026-01-18T15:07:26.935Z
9175134 9175134 20260110011254_rKJKm UK001K 2026-01-11T14:05:28.734Z 2026-01-18T15:07:26.783Z
9175082 9175082 20260110010258_8XP8v UK001K 2026-01-11T14:05:20.450Z 2026-01-18T15:07:25.323Z
9175020 9175020 20260110004643_f8OfD UK001K 2026-01-11T14:05:10.199Z 2026-01-18T15:07:23.382Z
9174889 9174889 20260109234739_18jZr UK001K 2026-01-11T14:04:45.593Z 2026-01-18T15:07:15.613Z
9174766 9174766 20260109222820_SNhjy UK001K 2026-01-11T14:04:19.361Z 2026-01-18T15:07:09.966Z
9174655 9174655 20260109212908_f54cb UK001K 2026-01-11T14:03:57.554Z 2026-01-18T15:06:56.959Z
9174587 9174587 20260109203955_eeR1A UK001K 2026-01-11T14:03:44.296Z 2026-01-18T15:06:53.906Z
9159256 9159256 20260106021358_tVQ81 UK001K 2026-01-07T14:08:51.232Z 2026-01-13T15:08:18.869Z
9158305 9158305 20260105215355_ehzMD UK001K 2026-01-07T14:05:43.828Z 2026-01-13T15:07:17.792Z
9157958 9157958 20260105193445_HZyx2 UK001K 2026-01-07T14:04:21.475Z 2026-01-13T15:06:48.013Z
9149889 9149889 20260105000310_v7Lpd UK001K 2026-01-06T14:07:40.355Z 2026-01-13T15:12:44.414Z
9149735 9149735 20260104231811_cNLOm UK001K 2026-01-06T14:06:55.850Z 2026-01-13T15:12:36.261Z
9149537 9149537 20260104214025_OevkI UK001K 2026-01-06T14:05:53.569Z 2026-01-13T15:12:16.416Z
9149524 9149524 20260104213422_r0UxZ UK001K 2026-01-06T14:05:49.755Z 2026-01-13T15:12:15.714Z
9149492 9149492 20260104213210_Id3f0 UK001K 2026-01-06T14:05:44.201Z 2026-01-13T15:12:14.456Z
9149014 9149014 20260104182903_CAw28 UK001K 2026-01-06T14:03:28.279Z 2026-01-13T15:11:38.254Z
9140144 9140144 20260104000112_gXHJu UK001K 2026-01-05T14:12:33.597Z 2026-01-12T15:03:59.807Z
9140035 9140035 20260103235530_37qAX UK001K 2026-01-05T14:12:23.480Z 2026-01-12T15:03:56.390Z
9139951 9139951 20260103235157_tUYa7 UK001K 2026-01-05T14:12:18.618Z 2026-01-12T15:03:54.353Z
9139689 9139689 20260103233948_CokaB UK001K 2026-01-05T14:11:57.311Z 2026-01-12T15:03:45.406Z
9139686 9139686 20260103233946_5CAUe UK001K 2026-01-05T14:11:57.127Z 2026-01-12T15:03:43.239Z
9139352 9139352 20260103233011_Vf627 UK001K 2026-01-05T14:11:32.149Z 2026-01-12T15:03:26.538Z
9139314 9139314 20260103232810_RE3dS UK001K 2026-01-05T14:11:28.888Z 2026-01-12T15:03:25.849Z
9139119 9139119 20260103231404_EV9Ba UK001K 2026-01-05T14:11:15.688Z 2026-01-12T15:03:21.211Z
9139098 9139098 20260103231210_6Rnea UK001K 2026-01-05T14:11:14.977Z 2026-01-12T15:03:20.786Z
9139015 9139015 20260103230706_k5eCo UK001K 2026-01-05T14:11:03.838Z 2026-01-12T15:03:18.295Z
9138895 9138895 20260103225955_UcLVV UK001K 2026-01-05T14:10:47.517Z 2026-01-12T15:03:15.260Z
9138773 9138773 20260103225305_oAW90 UK001K 2026-01-05T14:10:36.216Z 2026-01-12T15:02:59.653Z
9138601 9138601 20260103223401_2MWYW UK001K 2026-01-05T14:10:23.358Z 2026-01-12T15:02:53.879Z
9138565 9138565 20260103223321_u03BY UK001K 2026-01-05T14:10:10.041Z 2026-01-12T15:02:52.808Z
9138555 9138555 20260103223215_JP83k UK001K 2026-01-05T14:10:07.925Z 2026-01-12T15:02:52.521Z
9138435 9138435 20260103222559_CZ7ap UK001K 2026-01-05T14:09:55.622Z 2026-01-12T15:02:49.179Z
9138311 9138311 20260103221816_ryX5Z UK001K 2026-01-05T14:09:49.459Z 2026-01-12T15:02:46.370Z
9138050 9138050 20260103215536_plr24 UK001K 2026-01-05T14:09:19.887Z 2026-01-12T15:02:28.554Z
9137887 9137887 20260103214358_I8yL3 UK001K 2026-01-05T14:09:08.934Z 2026-01-12T15:02:22.427Z

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