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

>10,000 rows count all where station_code = "UK0009" 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
9273350 9273350 20260128054901_7VxJ9 UK0009 2026-01-29T14:29:24.777Z 2026-01-29T14:30:25.793Z
9273171 9273171 20260128050306_eJ2MI UK0009 2026-01-29T14:28:54.630Z 2026-01-29T14:30:25.764Z
9273064 9273064 20260128043109_sYCQ2 UK0009 2026-01-29T14:28:41.085Z 2026-01-29T14:30:25.744Z
9272834 9272834 20260128034327_bTGwu UK0009 2026-01-29T14:27:58.180Z 2026-01-29T14:30:25.579Z
9272196 9272196 20260128004249_zibmT UK0009 2026-01-29T14:25:54.941Z 2026-01-29T14:30:25.297Z
9272154 9272154 20260128002724_0v5np UK0009 2026-01-29T14:25:49.139Z 2026-01-29T14:30:25.291Z
9271651 9271651 20260127185719_ufUbA UK0009 2026-01-29T14:22:07.256Z 2026-01-29T14:30:24.998Z
9260606 9260606 20260125055122_QPtNe UK0009 2026-01-26T14:22:33.688Z 2026-01-29T14:44:30.422Z
9260547 9260547 20260125051844_IAXdF UK0009 2026-01-26T14:22:09.889Z 2026-01-29T14:44:25.432Z
9260095 9260095 20260125023308_MPn2B UK0009 2026-01-26T14:20:15.914Z 2026-01-29T14:43:46.405Z
9256006 9256006 20260124054127_0H3nK UK0009 2026-01-25T14:15:32.725Z 2026-01-29T14:48:18.135Z
9255225 9255225 20260124015404_4nf16 UK0009 2026-01-25T14:12:27.111Z 2026-01-29T14:47:11.209Z
9252157 9252157 20260123012005_QrYlT UK0009 2026-01-24T14:14:34.682Z 2026-01-29T14:52:36.842Z
9252003 9252003 20260123002709_wC2su UK0009 2026-01-24T14:13:59.152Z 2026-01-29T14:52:23.721Z
9251987 9251987 20260123002129_UAfz6 UK0009 2026-01-24T14:13:53.276Z 2026-01-29T14:52:20.267Z
9251956 9251956 20260123000706_2ix2C UK0009 2026-01-24T14:13:49.242Z 2026-01-29T14:52:18.820Z
9251882 9251882 20260122234545_UWUuv UK0009 2026-01-24T14:13:29.803Z 2026-01-29T14:52:15.207Z
9251811 9251811 20260122231543_2tngU UK0009 2026-01-24T14:13:19.562Z 2026-01-29T14:52:11.618Z
9251784 9251784 20260122225621_1TX3N UK0009 2026-01-24T14:13:14.039Z 2026-01-29T14:52:10.156Z
9251734 9251734 20260122222033_Ed660 UK0009 2026-01-24T14:13:03.532Z 2026-01-29T14:52:06.983Z
9251724 9251724 20260122221346_uZCAP UK0009 2026-01-24T14:13:00.990Z 2026-01-29T14:52:06.461Z
9251693 9251693 20260122220923_2qxCh UK0009 2026-01-24T14:12:58.163Z 2026-01-29T14:52:01.531Z
9251658 9251658 20260122214812_3gjzQ UK0009 2026-01-24T14:12:43.826Z 2026-01-29T14:51:57.557Z
9251652 9251652 20260122214532_VKg9n UK0009 2026-01-24T14:12:43.288Z 2026-01-29T14:51:57.354Z
9243826 9243826 20260121052426_DprU3 UK0009 2026-01-22T14:23:19.088Z 2026-01-29T15:05:29.238Z
9243678 9243678 20260121050503_rp2aj UK0009 2026-01-22T14:22:44.341Z 2026-01-29T15:05:23.234Z
9243629 9243629 20260121045401_X4rSX UK0009 2026-01-22T14:22:27.548Z 2026-01-29T15:05:20.627Z
9243609 9243609 20260121045156_3Xz4H UK0009 2026-01-22T14:22:24.277Z 2026-01-29T15:05:19.899Z
9243386 9243386 20260121042656_Daxpz UK0009 2026-01-22T14:21:36.876Z 2026-01-29T15:05:00.380Z
9243381 9243381 20260121042539_HIGo3 UK0009 2026-01-22T14:21:35.714Z 2026-01-29T15:04:59.796Z
9242824 9242824 20260121025140_k49Pw UK0009 2026-01-22T14:19:28.490Z 2026-01-29T15:04:23.119Z
9242707 9242707 20260121023641_KEdSz UK0009 2026-01-22T14:19:02.217Z 2026-01-29T15:04:18.112Z
9242647 9242647 20260121023001_Qc07M UK0009 2026-01-22T14:18:40.935Z 2026-01-29T15:04:15.678Z
9242525 9242525 20260121021013_itoN7 UK0009 2026-01-22T14:18:12.235Z 2026-01-29T15:04:03.138Z
9242333 9242333 20260121013241_eb1QW UK0009 2026-01-22T14:17:23.185Z 2026-01-29T15:03:44.890Z
9242281 9242281 20260121012246_1nTMy UK0009 2026-01-22T14:17:11.354Z 2026-01-29T15:03:42.438Z
9235720 9235720 20260120015140_WY9o0 UK0009 2026-01-21T14:20:03.713Z 2026-01-28T14:59:17.388Z
9235503 9235503 20260120012420_AFYnG UK0009 2026-01-21T14:19:15.548Z 2026-01-28T14:58:59.770Z
9235323 9235323 20260120005618_TBll2 UK0009 2026-01-21T14:18:29.019Z 2026-01-28T14:58:49.352Z
9234864 9234864 20260119234406_Z1lMo UK0009 2026-01-21T14:16:30.974Z 2026-01-28T14:58:17.796Z
9229010 9229010 20260119003441_0F0P6 UK0009 2026-01-20T14:20:36.935Z 2026-01-27T15:02:47.833Z
9228609 9228609 20260118230912_xL0A0 UK0009 2026-01-20T14:18:37.666Z 2026-01-27T15:02:10.856Z
9228579 9228579 20260118225930_CLKM2 UK0009 2026-01-20T14:18:29.039Z 2026-01-27T15:02:09.017Z
9228568 9228568 20260118225513_7lWRI UK0009 2026-01-20T14:18:25.715Z 2026-01-27T15:02:08.108Z
9214534 9214534 20260116065037_3EDmZ UK0009 2026-01-17T14:21:57.694Z 2026-01-24T15:13:49.983Z
9214367 9214367 20260116062325_Mw7r4 UK0009 2026-01-17T14:21:13.736Z 2026-01-24T15:13:31.763Z
9214328 9214328 20260116061853_IDrmO UK0009 2026-01-17T14:21:07.206Z 2026-01-24T15:13:30.479Z
9213359 9213359 20260116031827_CMTDU UK0009 2026-01-17T14:16:37.146Z 2026-01-24T15:12:10.781Z
9212762 9212762 20260116005258_gVDe5 UK0009 2026-01-17T14:13:43.304Z 2026-01-24T15:11:25.502Z
9212729 9212729 20260116003227_k1B52 UK0009 2026-01-17T14:13:31.574Z 2026-01-24T15:11:23.998Z
9212693 9212693 20260116002452_Ek6Su UK0009 2026-01-17T14:13:20.274Z 2026-01-24T15:11:10.324Z
9212683 9212683 20260116002158_aBu5k UK0009 2026-01-17T14:13:16.253Z 2026-01-24T15:11:09.978Z
9212675 9212675 20260116001649_HPoVs UK0009 2026-01-17T14:13:13.838Z 2026-01-24T15:11:09.662Z
9212628 9212628 20260115234726_rdZtr UK0009 2026-01-17T14:13:01.337Z 2026-01-24T15:11:07.813Z
9212608 9212608 20260115234354_nT5NG UK0009 2026-01-17T14:12:54.462Z 2026-01-24T15:11:07.166Z
9207704 9207704 20260115024922_Pn93C UK0009 2026-01-16T14:09:44.781Z 2026-01-22T15:03:30.422Z
9207692 9207692 20260115024705_IYSFS UK0009 2026-01-16T14:09:42.244Z 2026-01-22T15:03:30.149Z
9207496 9207496 20260115015630_hKhus UK0009 2026-01-16T14:08:59.239Z 2026-01-22T15:03:23.362Z
9207319 9207319 20260115005422_DGApl UK0009 2026-01-16T14:08:16.611Z 2026-01-22T15:03:18.661Z
9207307 9207307 20260115004657_uMrPA UK0009 2026-01-16T14:08:13.789Z 2026-01-22T15:03:18.264Z
9207304 9207304 20260115004627_0VrVi UK0009 2026-01-16T14:08:11.775Z 2026-01-22T15:03:18.172Z
9203731 9203731 20260114053245_rgL1r UK0009 2026-01-15T14:25:15.684Z 2026-01-22T15:10:12.698Z
9203616 9203616 20260114052158_03dwz UK0009 2026-01-15T14:25:01.157Z 2026-01-22T15:10:10.771Z
9203361 9203361 20260114045245_mIJcC UK0009 2026-01-15T14:24:09.946Z 2026-01-22T15:10:06.296Z
9203183 9203183 20260114044138_3awGK UK0009 2026-01-15T14:23:34.109Z 2026-01-22T15:10:03.331Z
9203155 9203155 20260114043802_jZapu UK0009 2026-01-15T14:23:26.938Z 2026-01-22T15:10:02.737Z
9203012 9203012 20260114042612_kQhkc UK0009 2026-01-15T14:23:02.312Z 2026-01-22T15:10:00.572Z
9202911 9202911 20260114041736_9yjII UK0009 2026-01-15T14:22:46.622Z 2026-01-22T15:09:59.300Z
9202703 9202703 20260114040412_8Qgul UK0009 2026-01-15T14:22:11.425Z 2026-01-22T15:09:30.071Z
9202561 9202561 20260114034928_Dm3pi UK0009 2026-01-15T14:21:41.022Z 2026-01-22T15:09:22.994Z
9202468 9202468 20260114034208_3JK6j UK0009 2026-01-15T14:21:27.788Z 2026-01-22T15:09:20.876Z
9202211 9202211 20260114032347_GpkHq UK0009 2026-01-15T14:20:43.008Z 2026-01-22T15:09:15.001Z
9202185 9202185 20260114032202_YpevM UK0009 2026-01-15T14:20:39.512Z 2026-01-22T15:09:14.488Z
9202108 9202108 20260114031742_13ncE UK0009 2026-01-15T14:20:33.474Z 2026-01-22T15:09:13.789Z
9202094 9202094 20260114031554_CdIOa UK0009 2026-01-15T14:20:31.192Z 2026-01-22T15:09:13.433Z
9202082 9202082 20260114031525_Ig0Nc UK0009 2026-01-15T14:20:24.372Z 2026-01-22T15:09:13.273Z
9201988 9201988 20260114030932_9LW35 UK0009 2026-01-15T14:20:13.559Z 2026-01-22T15:09:11.989Z
9201953 9201953 20260114030722_xDmcx UK0009 2026-01-15T14:20:10.780Z 2026-01-22T15:09:11.692Z
9201719 9201719 20260114024439_keoil UK0009 2026-01-15T14:19:25.921Z 2026-01-22T15:09:08.135Z
9201579 9201579 20260114023406_o63f8 UK0009 2026-01-15T14:19:08.424Z 2026-01-22T15:09:06.395Z
9201169 9201169 20260114015048_TVtjh UK0009 2026-01-15T14:17:42.426Z 2026-01-22T15:08:58.942Z
9194951 9194951 20260112234053_DUL1C UK0009 2026-01-14T14:11:28.925Z 2026-01-21T15:04:34.335Z
9194798 9194798 20260112224545_C8g23 UK0009 2026-01-14T14:10:43.883Z 2026-01-21T15:04:21.194Z
9194776 9194776 20260112223856_pzIvZ UK0009 2026-01-14T14:10:40.018Z 2026-01-21T15:04:20.965Z
9194610 9194610 20260112213430_m5hAD UK0009 2026-01-14T14:10:01.063Z 2026-01-21T15:04:19.265Z
9194427 9194427 20260112204300_Oj1Ws UK0009 2026-01-14T14:09:11.529Z 2026-01-21T15:04:01.235Z
9194416 9194416 20260112203704_pzrxk UK0009 2026-01-14T14:09:07.588Z 2026-01-21T15:03:57.617Z
9194240 9194240 20260112191220_VjVak UK0009 2026-01-14T14:08:15.679Z 2026-01-21T15:03:43.851Z
9181593 9181593 20260111022227_XfeRY UK0009 2026-01-12T14:11:23.557Z 2026-01-19T15:17:39.211Z
9181470 9181470 20260111015416_8Pur8 UK0009 2026-01-12T14:10:54.431Z 2026-01-19T15:17:20.835Z
9180860 9180860 20260110230236_2i4V2 UK0009 2026-01-12T14:08:39.868Z 2026-01-19T15:16:35.876Z
9180449 9180449 20260110202755_Z9I6s UK0009 2026-01-12T14:07:08.579Z 2026-01-19T15:16:03.339Z
9176731 9176731 20260110061306_gx2Lw UK0009 2026-01-11T14:09:49.814Z 2026-01-18T15:08:52.107Z
9176581 9176581 20260110054902_0xOB4 UK0009 2026-01-11T14:09:23.018Z 2026-01-18T15:08:44.770Z
9176499 9176499 20260110053743_cX5wW UK0009 2026-01-11T14:09:11.219Z 2026-01-18T15:08:41.478Z
9176349 9176349 20260110051754_usL1n UK0009 2026-01-11T14:08:46.716Z 2026-01-18T15:08:35.465Z
9176337 9176337 20260110051754_KAEbU UK0009 2026-01-11T14:08:46.193Z 2026-01-18T15:08:35.278Z
9176262 9176262 20260110051015_5IJXz UK0009 2026-01-11T14:08:37.158Z 2026-01-18T15:08:25.665Z
9176235 9176235 20260110050327_cJXjq UK0009 2026-01-11T14:08:31.737Z 2026-01-18T15:08:24.687Z
9176161 9176161 20260110045618_I8oUM UK0009 2026-01-11T14:08:20.231Z 2026-01-18T15:08:22.441Z

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