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,627 rows where station_code = "UK0030" 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
9272419 9272419 20260128020533_Ei6a5 UK0030 2026-01-29T14:26:37.889Z 2026-01-29T14:30:25.344Z
9242227 9242227 20260121010649_CfoPY UK0030 2026-01-22T14:16:57.035Z 2026-01-29T15:03:37.776Z
9218372 9218372 20260117032236_GT2CT UK0030 2026-01-18T14:11:49.900Z 2026-01-25T14:58:23.607Z
9204533 9204533 20260114065804_3Pa3D UK0030 2026-01-15T14:27:31.804Z 2026-01-22T15:10:34.100Z
9204481 9204481 20260114064732_HmOTB UK0030 2026-01-15T14:27:25.941Z 2026-01-22T15:10:29.581Z
9204039 9204039 20260114060430_PGvrP UK0030 2026-01-15T14:26:18.936Z 2026-01-22T15:10:17.334Z
9203904 9203904 20260114055221_Vgrup UK0030 2026-01-15T14:25:50.313Z 2026-01-22T15:10:15.386Z
9203806 9203806 20260114053756_Wkz4u UK0030 2026-01-15T14:25:25.779Z 2026-01-22T15:10:13.710Z
9203719 9203719 20260114053054_KXRbz UK0030 2026-01-15T14:25:13.881Z 2026-01-22T15:10:12.564Z
9202445 9202445 20260114033811_gHrAD UK0030 2026-01-15T14:21:19.310Z 2026-01-22T15:09:19.389Z
9202305 9202305 20260114032713_xoe10 UK0030 2026-01-15T14:21:02.377Z 2026-01-22T15:09:16.135Z
9201941 9201941 20260114030717_F9aeY UK0030 2026-01-15T14:20:09.975Z 2026-01-22T15:09:11.652Z
9201514 9201514 20260114022410_aP2aj UK0030 2026-01-15T14:18:47.303Z 2026-01-22T15:09:04.765Z
9201121 9201121 20260114014645_U3Z0P UK0030 2026-01-15T14:17:35.612Z 2026-01-22T15:08:58.042Z
9201103 9201103 20260114014247_ydBzl UK0030 2026-01-15T14:17:33.948Z 2026-01-22T15:08:57.782Z
9200962 9200962 20260114012554_kOdIv UK0030 2026-01-15T14:17:06.598Z 2026-01-22T15:08:40.840Z
9200419 9200419 20260114000624_x1VEn UK0030 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.738Z
9200175 9200175 20260113230253_sClSF UK0030 2026-01-15T14:14:05.398Z 2026-01-22T15:08:10.759Z
9200061 9200061 20260113224721_8g23B UK0030 2026-01-15T14:13:41.943Z 2026-01-22T15:08:09.063Z
9199889 9199889 20260113214828_ZslVL UK0030 2026-01-15T14:12:59.022Z 2026-01-22T15:08:04.952Z
9176184 9176184 20260110045940_Eq1aW UK0030 2026-01-11T14:08:24.658Z 2026-01-18T15:08:23.330Z
9175359 9175359 20260110021414_qhwIk UK0030 2026-01-11T14:06:11.735Z 2026-01-18T15:07:42.617Z
9175175 9175175 20260110013119_hlgTT UK0030 2026-01-11T14:05:36.987Z 2026-01-18T15:07:35.832Z
9175073 9175073 20260110010139_XgyS9 UK0030 2026-01-11T14:05:20.031Z 2026-01-18T15:07:25.182Z
9174753 9174753 20260109222031_P0yps UK0030 2026-01-11T14:04:16.960Z 2026-01-18T15:07:09.456Z
9174736 9174736 20260109220525_tiwXi UK0030 2026-01-11T14:04:14.327Z 2026-01-18T15:07:08.713Z
9174629 9174629 20260109210935_4n4TV UK0030 2026-01-11T14:03:54.117Z 2026-01-18T15:06:56.147Z
9174524 9174524 20260109195848_hy7At UK0030 2026-01-11T14:03:30.514Z 2026-01-18T15:06:49.909Z
9163456 9163456 20260107064751_Sgmky UK0030 2026-01-08T14:09:12.724Z 2026-01-13T15:03:16.496Z
9162744 9162744 20260107042143_gC6wl UK0030 2026-01-08T14:06:39.791Z 2026-01-13T15:02:37.264Z
9162588 9162588 20260107033914_2KYMT UK0030 2026-01-08T14:05:56.866Z 2026-01-13T15:02:20.813Z
9160577 9160577 20260106062730_KVxVh UK0030 2026-01-07T14:13:04.409Z 2026-01-13T15:09:33.753Z
9160255 9160255 20260106051501_2MxQH UK0030 2026-01-07T14:12:00.930Z 2026-01-13T15:09:16.710Z
9159928 9159928 20260106041848_1qW6Y UK0030 2026-01-07T14:10:52.550Z 2026-01-13T15:08:53.339Z
9159900 9159900 20260106041704_yB9Gw UK0030 2026-01-07T14:10:47.318Z 2026-01-13T15:08:52.658Z
9159811 9159811 20260106035651_RbdNl UK0030 2026-01-07T14:10:30.365Z 2026-01-13T15:08:48.562Z
9159689 9159689 20260106032743_6381M UK0030 2026-01-07T14:10:07.254Z 2026-01-13T15:08:37.569Z
9159510 9159510 20260106025621_pU7Zo UK0030 2026-01-07T14:09:35.053Z 2026-01-13T15:08:28.537Z
9158676 9158676 20260105235855_RLX0X UK0030 2026-01-07T14:06:57.762Z 2026-01-13T15:07:42.081Z
9157682 9157682 20260105182430_aVuu7 UK0030 2026-01-07T14:03:10.984Z 2026-01-13T15:06:24.280Z
9151833 9151833 20260105063908_Owvvr UK0030 2026-01-06T14:14:52.226Z 2026-01-13T15:15:08.409Z
9151819 9151819 20260105063726_gBhv4 UK0030 2026-01-06T14:14:48.705Z 2026-01-13T15:15:07.309Z
9151748 9151748 20260105062327_gHcAH UK0030 2026-01-06T14:14:31.932Z 2026-01-13T15:15:03.769Z
9151627 9151627 20260105060516_43g6M UK0030 2026-01-06T14:14:11.979Z 2026-01-13T15:14:58.387Z
9151506 9151506 20260105054118_OXDVU UK0030 2026-01-06T14:13:52.724Z 2026-01-13T15:14:47.064Z
9151445 9151445 20260105053344_5ycLz UK0030 2026-01-06T14:13:41.697Z 2026-01-13T15:14:43.394Z
9149344 9149344 20260104201156_T50tw UK0030 2026-01-06T14:05:02.616Z 2026-01-13T15:12:05.166Z
9147639 9147639 20260104062121_mHbrS UK0030 2026-01-05T14:24:39.285Z 2026-01-12T15:11:27.460Z
9147605 9147605 20260104061628_82Zmf UK0030 2026-01-05T14:24:36.865Z 2026-01-12T15:11:24.246Z
9147575 9147575 20260104060803_sF55k UK0030 2026-01-05T14:24:28.854Z 2026-01-12T15:11:21.999Z
9147560 9147560 20260104060711_Nq7gh UK0030 2026-01-05T14:24:23.039Z 2026-01-12T15:11:20.973Z
9147518 9147518 20260104060035_y453D UK0030 2026-01-05T14:24:19.977Z 2026-01-12T15:11:05.337Z
9147476 9147476 20260104055444_HBwBC UK0030 2026-01-05T14:24:12.620Z 2026-01-12T15:11:00.049Z
9147449 9147449 20260104055122_LOl23 UK0030 2026-01-05T14:24:11.208Z 2026-01-12T15:10:57.711Z
9147409 9147409 20260104054541_grrtC UK0030 2026-01-05T14:24:08.290Z 2026-01-12T15:10:54.642Z
9147335 9147335 20260104053526_xes0G UK0030 2026-01-05T14:24:04.713Z 2026-01-12T15:10:49.169Z
9147310 9147310 20260104053130_xh4EL UK0030 2026-01-05T14:24:02.203Z 2026-01-12T15:10:45.513Z
9147066 9147066 20260104050047_wvTDk UK0030 2026-01-05T14:23:25.851Z 2026-01-12T15:10:08.719Z
9147054 9147054 20260104045912_p8E5H UK0030 2026-01-05T14:23:24.774Z 2026-01-12T15:10:02.748Z
9147020 9147020 20260104045530_IEz4q UK0030 2026-01-05T14:23:23.536Z 2026-01-12T15:09:49.920Z
9147012 9147012 20260104045453_36avG UK0030 2026-01-05T14:23:22.956Z 2026-01-12T15:09:49.415Z
9146985 9146985 20260104045254_dQYW9 UK0030 2026-01-05T14:23:21.427Z 2026-01-12T15:09:47.596Z
9146969 9146969 20260104045229_LQzC5 UK0030 2026-01-05T14:23:20.552Z 2026-01-12T15:09:46.802Z
9146822 9146822 20260104043250_5ubre UK0030 2026-01-05T14:22:54.397Z 2026-01-12T15:09:34.183Z
9146768 9146768 20260104042457_PTTXG UK0030 2026-01-05T14:22:49.351Z 2026-01-12T15:09:25.257Z
9146709 9146709 20260104041710_dQ0FR UK0030 2026-01-05T14:22:43.881Z 2026-01-12T15:09:09.166Z
9146666 9146666 20260104041434_9kTRJ UK0030 2026-01-05T14:22:40.608Z 2026-01-12T15:09:04.910Z
9146506 9146506 20260104035426_wYwUc UK0030 2026-01-05T14:22:20.343Z 2026-01-12T15:08:38.221Z
9146440 9146440 20260104035009_CDjbM UK0030 2026-01-05T14:22:14.524Z 2026-01-12T15:08:31.718Z
9145205 9145205 20260104030819_EkNQW UK0030 2026-01-05T14:20:18.177Z 2026-01-12T15:07:43.902Z
9145172 9145172 20260104030806_cuLwW UK0030 2026-01-05T14:20:17.636Z 2026-01-12T15:07:43.532Z
9144973 9144973 20260104030018_xxUGB UK0030 2026-01-05T14:19:47.006Z 2026-01-12T15:07:20.720Z
9144862 9144862 20260104025702_4ZtHw UK0030 2026-01-05T14:19:39.057Z 2026-01-12T15:07:18.766Z
9144794 9144794 20260104025408_IBxuI UK0030 2026-01-05T14:19:35.708Z 2026-01-12T15:07:17.189Z
9144776 9144776 20260104025401_7sQja UK0030 2026-01-05T14:19:35.037Z 2026-01-12T15:07:17.019Z
9144601 9144601 20260104025015_gtQ9o UK0030 2026-01-05T14:19:25.707Z 2026-01-12T15:07:11.547Z
9144231 9144231 20260104023822_ydQIY UK0030 2026-01-05T14:18:50.812Z 2026-01-12T15:07:02.273Z
9144147 9144147 20260104023455_QXC6I UK0030 2026-01-05T14:18:44.247Z 2026-01-12T15:06:59.806Z
9143777 9143777 20260104022224_AuyEF UK0030 2026-01-05T14:18:05.297Z 2026-01-12T15:06:33.289Z
9143116 9143116 20260104015649_IYX32 UK0030 2026-01-05T14:16:59.884Z 2026-01-12T15:06:14.624Z
9143097 9143097 20260104015619_V6tzk UK0030 2026-01-05T14:16:58.697Z 2026-01-12T15:06:14.249Z
9142971 9142971 20260104015214_ZeWfI UK0030 2026-01-05T14:16:46.157Z 2026-01-12T15:06:10.394Z
9142848 9142848 20260104014922_Mb96i UK0030 2026-01-05T14:16:41.579Z 2026-01-12T15:05:55.697Z
9142685 9142685 20260104014446_EAcwm UK0030 2026-01-05T14:16:18.586Z 2026-01-12T15:05:49.431Z
9142428 9142428 20260104013434_uVbYZ UK0030 2026-01-05T14:16:04.873Z 2026-01-12T15:05:43.140Z
9142183 9142183 20260104012510_Yf3rg UK0030 2026-01-05T14:15:38.640Z 2026-01-12T15:05:36.464Z
9142176 9142176 20260104012502_3U2Qf UK0030 2026-01-05T14:15:37.869Z 2026-01-12T15:05:36.300Z
9142077 9142077 20260104012204_RvB7J UK0030 2026-01-05T14:15:31.953Z 2026-01-12T15:05:19.528Z
9141630 9141630 20260104010217_uRJo3 UK0030 2026-01-05T14:14:51.967Z 2026-01-12T15:05:05.929Z
9141576 9141576 20260104005927_DQpp2 UK0030 2026-01-05T14:14:49.378Z 2026-01-12T15:05:04.615Z
9141510 9141510 20260104005721_rhzMN UK0030 2026-01-05T14:14:43.223Z 2026-01-12T15:05:02.838Z
9141405 9141405 20260104005308_TSHrG UK0030 2026-01-05T14:14:30.093Z 2026-01-12T15:05:00.528Z
9141347 9141347 20260104005148_pmUn1 UK0030 2026-01-05T14:14:28.374Z 2026-01-12T15:04:59.437Z
9141102 9141102 20260104004226_4T3Aa UK0030 2026-01-05T14:14:10.573Z 2026-01-12T15:04:40.191Z
9141008 9141008 20260104004022_uJujn UK0030 2026-01-05T14:14:05.723Z 2026-01-12T15:04:36.784Z
9140733 9140733 20260104002725_giCXr UK0030 2026-01-05T14:13:32.654Z 2026-01-12T15:04:28.595Z
9140670 9140670 20260104002607_s03Re UK0030 2026-01-05T14:13:30.501Z 2026-01-12T15:04:27.517Z
9140647 9140647 20260104002510_F73jt UK0030 2026-01-05T14:13:29.542Z 2026-01-12T15:04:26.972Z
9140591 9140591 20260104002300_vqqN3 UK0030 2026-01-05T14:13:26.980Z 2026-01-12T15:04:25.857Z
9140475 9140475 20260104001724_D8N2F UK0030 2026-01-05T14:13:12.539Z 2026-01-12T15:04:21.979Z

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