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

9,407 rows where station_code = "UK002Q" 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
9260188 9260188 20260125025946_Bdvg3 UK002Q 2026-01-26T14:20:35.882Z 2026-01-29T14:43:56.892Z
9251936 9251936 20260123000248_tJk9D UK002Q 2026-01-24T14:13:45.958Z 2026-01-29T14:52:17.822Z
9251814 9251814 20260122231543_2tngU UK002Q 2026-01-24T14:13:19.562Z 2026-01-29T14:52:11.618Z
9251736 9251736 20260122222033_Ed660 UK002Q 2026-01-24T14:13:03.532Z 2026-01-29T14:52:06.983Z
9251661 9251661 20260122214812_3gjzQ UK002Q 2026-01-24T14:12:43.846Z 2026-01-29T14:51:57.557Z
9251285 9251285 20260122193348_b8ipS UK002Q 2026-01-24T14:11:07.579Z 2026-01-29T14:51:26.866Z
9242849 9242849 20260121025900_1CLpm UK002Q 2026-01-22T14:19:32.645Z 2026-01-29T15:04:24.196Z
9242799 9242799 20260121024653_rokKi UK002Q 2026-01-22T14:19:17.416Z 2026-01-29T15:04:21.455Z
9242424 9242424 20260121014850_nwZcW UK002Q 2026-01-22T14:17:49.507Z 2026-01-29T15:03:58.161Z
9242025 9242025 20260121000408_arHXS UK002Q 2026-01-22T14:15:53.554Z 2026-01-29T15:03:25.848Z
9237933 9237933 20260120063024_xqJmd UK002Q 2026-01-21T14:28:06.445Z 2026-01-28T15:01:59.931Z
9237831 9237831 20260120060954_djfcV UK002Q 2026-01-21T14:27:44.372Z 2026-01-28T15:01:43.897Z
9237265 9237265 20260120045618_3ocAa UK002Q 2026-01-21T14:25:48.536Z 2026-01-28T15:01:06.724Z
9236711 9236711 20260120035056_SmM8B UK002Q 2026-01-21T14:23:44.939Z 2026-01-28T15:00:31.719Z
9222750 9222750 20260117204043_tctqx UK002Q 2026-01-19T14:16:07.145Z 2026-01-26T15:01:19.678Z
9218924 9218924 20260117063725_izRb1 UK002Q 2026-01-18T14:14:15.294Z 2026-01-25T14:58:55.851Z
9218320 9218320 20260117025437_XDZWf UK002Q 2026-01-18T14:11:37.920Z 2026-01-25T14:58:21.598Z
9214371 9214371 20260116062325_Mw7r4 UK002Q 2026-01-17T14:21:13.736Z 2026-01-24T15:13:31.763Z
9213743 9213743 20260116043340_5SvQO UK002Q 2026-01-17T14:18:19.540Z 2026-01-24T15:12:33.120Z
9213651 9213651 20260116041804_8R23h UK002Q 2026-01-17T14:17:58.592Z 2026-01-24T15:12:29.999Z
9213613 9213613 20260116040839_F37jR UK002Q 2026-01-17T14:17:46.363Z 2026-01-24T15:12:24.941Z
9213487 9213487 20260116034701_Z0lji UK002Q 2026-01-17T14:17:09.311Z 2026-01-24T15:12:17.667Z
9212900 9212900 20260116013607_eam1P UK002Q 2026-01-17T14:14:30.230Z 2026-01-24T15:11:33.343Z
9212696 9212696 20260116002452_Ek6Su UK002Q 2026-01-17T14:13:20.275Z 2026-01-24T15:11:10.324Z
9212676 9212676 20260116001649_HPoVs UK002Q 2026-01-17T14:13:13.838Z 2026-01-24T15:11:09.662Z
9212630 9212630 20260115234726_rdZtr UK002Q 2026-01-17T14:13:01.337Z 2026-01-24T15:11:07.813Z
9212610 9212610 20260115234354_nT5NG UK002Q 2026-01-17T14:12:54.462Z 2026-01-24T15:11:07.166Z
9212594 9212594 20260115234051_ZHSPD UK002Q 2026-01-17T14:12:51.121Z 2026-01-24T15:11:06.778Z
9212531 9212531 20260115224818_KIlxu UK002Q 2026-01-17T14:12:32.557Z 2026-01-24T15:11:01.432Z
9212520 9212520 20260115224125_wELtG UK002Q 2026-01-17T14:12:25.808Z 2026-01-24T15:11:00.246Z
9204368 9204368 20260114063334_FgJlE UK002Q 2026-01-15T14:27:09.129Z 2026-01-22T15:10:25.517Z
9204254 9204254 20260114062011_DSQD2 UK002Q 2026-01-15T14:26:54.468Z 2026-01-22T15:10:23.168Z
9204181 9204181 20260114061351_E85dN UK002Q 2026-01-15T14:26:37.254Z 2026-01-22T15:10:21.894Z
9203789 9203789 20260114053747_5K3J8 UK002Q 2026-01-15T14:25:23.885Z 2026-01-22T15:10:13.528Z
9203766 9203766 20260114053525_16qZy UK002Q 2026-01-15T14:25:21.969Z 2026-01-22T15:10:13.203Z
9203618 9203618 20260114052158_03dwz UK002Q 2026-01-15T14:25:01.157Z 2026-01-22T15:10:10.771Z
9203015 9203015 20260114042612_kQhkc UK002Q 2026-01-15T14:23:02.312Z 2026-01-22T15:10:00.572Z
9202984 9202984 20260114042338_eK16E UK002Q 2026-01-15T14:22:58.964Z 2026-01-22T15:10:00.286Z
9202842 9202842 20260114041313_d6xK7 UK002Q 2026-01-15T14:22:32.124Z 2026-01-22T15:09:57.820Z
9202405 9202405 20260114033618_r5jbg UK002Q 2026-01-15T14:21:13.894Z 2026-01-22T15:09:17.310Z
9202169 9202169 20260114032201_3oRHQ UK002Q 2026-01-15T14:20:38.070Z 2026-01-22T15:09:14.407Z
9201903 9201903 20260114030549_kb5Vf UK002Q 2026-01-15T14:20:06.287Z 2026-01-22T15:09:11.214Z
9201589 9201589 20260114023422_cP9Yb UK002Q 2026-01-15T14:19:09.058Z 2026-01-22T15:09:06.485Z
9201582 9201582 20260114023406_o63f8 UK002Q 2026-01-15T14:19:08.424Z 2026-01-22T15:09:06.395Z
9201285 9201285 20260114020526_NC9uQ UK002Q 2026-01-15T14:18:10.469Z 2026-01-22T15:09:01.180Z
9201156 9201156 20260114014945_T61hH UK002Q 2026-01-15T14:17:40.647Z 2026-01-22T15:08:58.674Z
9200908 9200908 20260114012006_ATXUq UK002Q 2026-01-15T14:16:51.198Z 2026-01-22T15:08:36.360Z
9194887 9194887 20260112231541_94RNR UK002Q 2026-01-14T14:11:10.158Z 2026-01-21T15:04:33.696Z
9194800 9194800 20260112224545_C8g23 UK002Q 2026-01-14T14:10:43.883Z 2026-01-21T15:04:21.194Z
9194742 9194742 20260112223006_c5PcY UK002Q 2026-01-14T14:10:30.404Z 2026-01-21T15:04:20.532Z
9194242 9194242 20260112191220_VjVak UK002Q 2026-01-14T14:08:15.708Z 2026-01-21T15:03:43.851Z
9194213 9194213 20260112185652_TiHo1 UK002Q 2026-01-14T14:08:04.354Z 2026-01-21T15:03:40.976Z
9180451 9180451 20260110202755_Z9I6s UK002Q 2026-01-12T14:07:08.605Z 2026-01-19T15:16:03.339Z
9176761 9176761 20260110061901_TcV2f UK002Q 2026-01-11T14:09:53.477Z 2026-01-18T15:08:53.079Z
9176736 9176736 20260110061306_gx2Lw UK002Q 2026-01-11T14:09:49.814Z 2026-01-18T15:08:52.107Z
9176529 9176529 20260110054042_3tsX6 UK002Q 2026-01-11T14:09:15.240Z 2026-01-18T15:08:42.554Z
9176480 9176480 20260110053612_tmk9r UK002Q 2026-01-11T14:09:08.763Z 2026-01-18T15:08:40.879Z
9176351 9176351 20260110051754_usL1n UK002Q 2026-01-11T14:08:46.716Z 2026-01-18T15:08:35.465Z
9176025 9176025 20260110043509_GUV1D UK002Q 2026-01-11T14:08:03.244Z 2026-01-18T15:08:16.973Z
9175579 9175579 20260110030218_e6DYD UK002Q 2026-01-11T14:06:49.075Z 2026-01-18T15:07:52.009Z
9174811 9174811 20260109231317_ts3eO UK002Q 2026-01-11T14:04:28.974Z 2026-01-18T15:07:11.894Z
9174452 9174452 20260109191547_vi7em UK002Q 2026-01-11T14:03:16.216Z 2026-01-18T15:06:46.611Z
9163427 9163427 20260107063522_WClHK UK002Q 2026-01-08T14:09:07.869Z 2026-01-13T15:03:15.126Z
9163258 9163258 20260107061409_UAGso UK002Q 2026-01-08T14:08:37.514Z 2026-01-13T15:03:07.347Z
9162903 9162903 20260107050100_8mnin UK002Q 2026-01-08T14:07:16.858Z 2026-01-13T15:02:46.357Z
9162700 9162700 20260107041223_iAidK UK002Q 2026-01-08T14:06:30.682Z 2026-01-13T15:02:35.042Z
9162604 9162604 20260107034211_F319S UK002Q 2026-01-08T14:05:58.328Z 2026-01-13T15:02:21.150Z
9160588 9160588 20260106062840_FLcP9 UK002Q 2026-01-07T14:13:05.723Z 2026-01-13T15:09:34.218Z
9160334 9160334 20260106053340_tiAZI UK002Q 2026-01-07T14:12:18.353Z 2026-01-13T15:09:20.710Z
9160088 9160088 20260106044656_BQn9Z UK002Q 2026-01-07T14:11:21.758Z 2026-01-13T15:09:00.084Z
9160081 9160081 20260106044644_U0h3b UK002Q 2026-01-07T14:11:20.899Z 2026-01-13T15:08:59.949Z
9159770 9159770 20260106034314_2KzXM UK002Q 2026-01-07T14:10:21.524Z 2026-01-13T15:08:42.774Z
9159439 9159439 20260106024321_a2v0J UK002Q 2026-01-07T14:09:20.107Z 2026-01-13T15:08:26.166Z
9159396 9159396 20260106023311_kPjxg UK002Q 2026-01-07T14:09:14.063Z 2026-01-13T15:08:24.057Z
9158232 9158232 20260105210525_nuS5r UK002Q 2026-01-07T14:05:25.933Z 2026-01-13T15:07:12.372Z
9151691 9151691 20260105061727_fmV9W UK002Q 2026-01-06T14:14:23.186Z 2026-01-13T15:15:01.151Z
9148957 9148957 20260104181828_sOU3u UK002Q 2026-01-06T14:03:14.703Z 2026-01-13T15:11:28.975Z
9147711 9147711 20260104063402_3hlta UK002Q 2026-01-05T14:24:45.445Z 2026-01-12T15:11:33.644Z
9147697 9147697 20260104063129_diaUG UK002Q 2026-01-05T14:24:43.663Z 2026-01-12T15:11:32.357Z
9147440 9147440 20260104054948_yVDC4 UK002Q 2026-01-05T14:24:10.686Z 2026-01-12T15:10:56.873Z
9147316 9147316 20260104053144_ZoK0N UK002Q 2026-01-05T14:24:02.876Z 2026-01-12T15:10:46.444Z
9146906 9146906 20260104044214_RKTcs UK002Q 2026-01-05T14:23:14.736Z 2026-01-12T15:09:40.042Z
9146893 9146893 20260104044123_EPp8B UK002Q 2026-01-05T14:23:14.199Z 2026-01-12T15:09:39.117Z
9146869 9146869 20260104043921_RQB2o UK002Q 2026-01-05T14:23:03.394Z 2026-01-12T15:09:37.538Z
9146705 9146705 20260104041705_Ptz3h UK002Q 2026-01-05T14:22:43.700Z 2026-01-12T15:09:08.898Z
9146687 9146687 20260104041513_7Fybu UK002Q 2026-01-05T14:22:41.896Z 2026-01-12T15:09:06.445Z
9146658 9146658 20260104041239_xCcF3 UK002Q 2026-01-05T14:22:40.222Z 2026-01-12T15:09:04.490Z
9146473 9146473 20260104035304_Qi5e3 UK002Q 2026-01-05T14:22:17.908Z 2026-01-12T15:08:33.946Z
9146342 9146342 20260104034551_6c0kz UK002Q 2026-01-05T14:22:07.758Z 2026-01-12T15:08:26.255Z
9146331 9146331 20260104034533_pcp5F UK002Q 2026-01-05T14:22:07.141Z 2026-01-12T15:08:25.966Z
9146272 9146272 20260104034259_SXDWk UK002Q 2026-01-05T14:22:03.146Z 2026-01-12T15:08:24.194Z
9146167 9146167 20260104033738_vKJYP UK002Q 2026-01-05T14:21:49.669Z 2026-01-12T15:08:21.157Z
9146156 9146156 20260104033726_R2bGZ UK002Q 2026-01-05T14:21:49.401Z 2026-01-12T15:08:21.037Z
9146133 9146133 20260104033707_gzmI6 UK002Q 2026-01-05T14:21:48.423Z 2026-01-12T15:08:20.658Z
9145988 9145988 20260104033255_SmaVG UK002Q 2026-01-05T14:21:29.946Z 2026-01-12T15:08:17.611Z
9145909 9145909 20260104033050_yGB6K UK002Q 2026-01-05T14:21:25.611Z 2026-01-12T15:08:15.757Z
9145582 9145582 20260104032102_15V6o UK002Q 2026-01-05T14:20:52.946Z 2026-01-12T15:07:53.318Z
9145307 9145307 20260104031331_qUQJv UK002Q 2026-01-05T14:20:26.590Z 2026-01-12T15:07:46.274Z
9144966 9144966 20260104030012_MFI7e UK002Q 2026-01-05T14:19:46.495Z 2026-01-12T15:07:20.541Z
9144714 9144714 20260104025220_T1OgJ UK002Q 2026-01-05T14:19:30.658Z 2026-01-12T15:07:13.653Z

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