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,364 rows where station_code = "UK009C" 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
9585324 9585324 20260326001535_8Mkpk UK009C 2026-03-27T12:17:07.670Z 2026-04-03T12:39:55.047Z
9585153 9585153 20260325233602_T8wpK UK009C 2026-03-27T12:16:51.669Z 2026-04-03T12:39:50.667Z
9585043 9585043 20260325231116_tFvqZ UK009C 2026-03-27T12:16:35.485Z 2026-04-03T12:39:47.502Z
9584992 9584992 20260325225853_Iz8hd UK009C 2026-03-27T12:16:29.430Z 2026-04-03T12:39:45.900Z
9584991 9584991 20260325225817_5EHGm UK009C 2026-03-27T12:16:28.940Z 2026-04-03T12:39:45.804Z
9584744 9584744 20260325215326_xOxRi UK009C 2026-03-27T12:16:02.489Z 2026-04-03T12:39:35.283Z
9584612 9584612 20260325210913_KUOsc UK009C 2026-03-27T12:15:49.581Z 2026-04-03T12:39:24.097Z
9584454 9584454 20260325195533_3dO4p UK009C 2026-03-27T12:15:21.225Z 2026-04-03T12:39:14.666Z
9581915 9581915 20260326041133_sfM0J UK009C 2026-03-27T12:04:08.151Z 2026-04-04T12:39:31.231Z
9581897 9581897 20260326040858_GE2TJ UK009C 2026-03-27T12:04:05.741Z 2026-04-04T12:39:30.189Z
9581830 9581830 20260326040208_BY4uJ UK009C 2026-03-27T12:03:55.617Z 2026-04-04T12:39:21.808Z
9581752 9581752 20260326035503_8PtcB UK009C 2026-03-27T12:03:48.201Z 2026-04-04T12:39:18.307Z
9581722 9581722 20260326035258_nEWbo UK009C 2026-03-27T12:03:45.408Z 2026-04-04T12:39:16.970Z
9581632 9581632 20260326033527_3PF4l UK009C 2026-03-27T12:03:30.591Z 2026-04-04T12:39:12.465Z
9581526 9581526 20260326032447_Ejt3U UK009C 2026-03-27T12:03:21.580Z 2026-04-04T12:39:09.692Z
9581519 9581519 20260326032352_Ro27d UK009C 2026-03-27T12:03:20.588Z 2026-04-04T12:39:09.459Z
9581495 9581495 20260326031851_I2Lji UK009C 2026-03-27T12:03:17.044Z 2026-04-04T12:39:08.607Z
9581428 9581428 20260326031212_nCbjl UK009C 2026-03-27T12:03:05.465Z 2026-04-04T12:39:04.504Z
9581078 9581078 20260326022101_U6vqm UK009C 2026-03-27T12:02:04.808Z 2026-04-04T12:38:41.831Z
9581076 9581076 20260326022036_GKHuZ UK009C 2026-03-27T12:02:04.278Z 2026-04-04T12:38:41.642Z
9580911 9580911 20260326015235_iQv3F UK009C 2026-03-27T12:01:40.745Z 2026-04-04T12:38:33.363Z
9580753 9580753 20260326012712_A7K2m UK009C 2026-03-27T12:01:21.286Z 2026-04-04T12:38:27.438Z
9580610 9580610 20260326010720_stDwg UK009C 2026-03-27T12:00:56.437Z 2026-04-04T12:38:17.963Z
9580483 9580483 20260326005520_2u1aE UK009C 2026-03-27T12:00:35.906Z 2026-04-04T12:38:11.912Z
9579821 9579821 20260324230327_GfF82 UK009C 2026-03-26T12:14:32.054Z 2026-04-02T12:37:31.723Z
9579654 9579654 20260324220313_QOQ3g UK009C 2026-03-26T12:14:08.361Z 2026-04-02T12:37:19.062Z
9579597 9579597 20260324215053_dwmxD UK009C 2026-03-26T12:14:03.520Z 2026-04-02T12:37:17.375Z
9576439 9576439 20260325020652_dHroF UK009C 2026-03-26T12:02:14.333Z 2026-04-03T12:35:58.823Z
9576304 9576304 20260325015034_25bnB UK009C 2026-03-26T12:01:53.271Z 2026-04-03T12:35:52.566Z
9576235 9576235 20260325014340_W6K9o UK009C 2026-03-26T12:01:39.891Z 2026-04-03T12:35:49.587Z
9576158 9576158 20260325012656_DAsUn UK009C 2026-03-26T12:01:27.713Z 2026-04-03T12:35:46.766Z
9576139 9576139 20260325012242_kdvl7 UK009C 2026-03-26T12:01:25.431Z 2026-04-03T12:35:46.107Z
9576055 9576055 20260325010757_IdWE7 UK009C 2026-03-26T12:01:08.867Z 2026-04-03T12:35:42.704Z
9575949 9575949 20260325004756_5pDwP UK009C 2026-03-26T12:00:47.494Z 2026-04-03T12:35:30.734Z
9575893 9575893 20260325003504_M0VuV UK009C 2026-03-26T12:00:33.951Z 2026-04-03T12:35:27.965Z
9570801 9570801 20260322225102_JsWfc UK009C 2026-03-24T12:23:50.620Z 2026-03-30T12:30:49.620Z
9552187 9552187 20260320231104_r8yCD UK009C 2026-03-22T12:27:31.464Z 2026-03-28T12:37:07.670Z
9552154 9552154 20260320230500_Ws3C3 UK009C 2026-03-22T12:27:29.798Z 2026-03-28T12:37:07.366Z
9552013 9552013 20260320223750_en33m UK009C 2026-03-22T12:27:22.877Z 2026-03-28T12:37:05.572Z
9543226 9543226 20260321030720_2HjJL UK009C 2026-03-22T12:03:04.406Z 2026-03-29T12:19:04.613Z
9542980 9542980 20260321021121_Ayvj0 UK009C 2026-03-22T12:02:15.762Z 2026-03-29T12:19:00.944Z
9542736 9542736 20260321010647_832wc UK009C 2026-03-22T12:01:27.633Z 2026-03-29T12:18:57.727Z
9542691 9542691 20260321004756_5dXVf UK009C 2026-03-22T12:01:16.079Z 2026-03-29T12:18:57.089Z
9542670 9542670 20260321004436_04omm UK009C 2026-03-22T12:01:12.341Z 2026-03-29T12:18:56.860Z
9542577 9542577 20260321001435_my93V UK009C 2026-03-22T12:00:49.059Z 2026-03-29T12:18:45.817Z
9542512 9542512 20260320235654_CnKky UK009C 2026-03-22T12:00:33.309Z 2026-03-29T12:18:44.965Z
9542509 9542509 20260320235623_EmsCZ UK009C 2026-03-22T12:00:32.563Z 2026-03-29T12:18:44.942Z
9541506 9541506 20260319204838_zAgtP UK009C 2026-03-21T12:29:01.291Z 2026-03-27T12:42:38.386Z
9534474 9534474 20260320035141_GyyDm UK009C 2026-03-21T12:08:04.978Z 2026-03-28T12:34:18.649Z
9533275 9533275 20260320022122_lLuYE UK009C 2026-03-21T12:05:00.251Z 2026-03-28T12:33:51.350Z
9533119 9533119 20260320020231_rqK2V UK009C 2026-03-21T12:04:31.167Z 2026-03-28T12:33:49.047Z
9531812 9531812 20260319235228_ockYh UK009C 2026-03-21T12:00:54.896Z 2026-03-28T12:33:21.767Z
9531578 9531578 20260319232546_cgwm6 UK009C 2026-03-21T12:00:16.719Z 2026-03-28T12:33:18.786Z
9512236 9512236 20260318045650_DxbsP UK009C 2026-03-19T12:11:58.588Z 2026-03-26T12:37:43.244Z
9509669 9509669 20260318020609_F71Jc UK009C 2026-03-19T12:05:56.021Z 2026-03-26T12:37:06.930Z
9509603 9509603 20260318020031_0fh7o UK009C 2026-03-19T12:05:45.599Z 2026-03-26T12:37:06.612Z
9493483 9493483 20260315233746_3uknw UK009C 2026-03-17T12:01:02.989Z 2026-03-24T12:40:40.053Z
9483463 9483463 20260313221747_8FCQr UK009C 2026-03-15T12:26:33.197Z 2026-03-21T12:50:27.834Z
9483294 9483294 20260313213233_WqFFk UK009C 2026-03-15T12:26:13.574Z 2026-03-21T12:50:26.508Z
9483221 9483221 20260313211717_wAdR3 UK009C 2026-03-15T12:26:07.204Z 2026-03-21T12:50:24.727Z
9477615 9477615 20260314052255_Px8yl UK009C 2026-03-15T12:08:37.772Z 2026-03-22T12:42:03.966Z
9477031 9477031 20260314040746_9iLm5 UK009C 2026-03-15T12:07:29.436Z 2026-03-22T12:42:00.784Z
9476907 9476907 20260314035427_1gtwr UK009C 2026-03-15T12:07:11.742Z 2026-03-22T12:42:00.088Z
9476103 9476103 20260314023822_5PQKO UK009C 2026-03-15T12:05:05.411Z 2026-03-22T12:41:54.304Z
9475915 9475915 20260314021919_7VEBC UK009C 2026-03-15T12:04:29.638Z 2026-03-22T12:41:52.696Z
9475810 9475810 20260314020728_cr0KA UK009C 2026-03-15T12:04:12.145Z 2026-03-22T12:41:51.946Z
9475726 9475726 20260314020110_va1wY UK009C 2026-03-15T12:03:58.005Z 2026-03-22T12:41:50.606Z
9475588 9475588 20260314014348_96jyd UK009C 2026-03-15T12:03:32.383Z 2026-03-22T12:41:44.384Z
9475287 9475287 20260314011008_OB7o5 UK009C 2026-03-15T12:02:46.075Z 2026-03-22T12:41:31.326Z
9475134 9475134 20260314004540_jP8b0 UK009C 2026-03-15T12:02:20.631Z 2026-03-22T12:41:27.188Z
9474848 9474848 20260314000544_w2xcY UK009C 2026-03-15T12:01:31.785Z 2026-03-22T12:41:24.848Z
9474686 9474686 20260313233820_aXNlw UK009C 2026-03-15T12:00:58.236Z 2026-03-22T12:41:23.304Z
9474453 9474453 20260313225652_BWsof UK009C 2026-03-15T12:00:17.516Z 2026-03-22T12:41:20.609Z
9468689 9468689 20260313001848_G4dA8 UK009C 2026-03-14T12:01:23.552Z 2026-03-21T12:48:27.887Z
9456227 9456227 20260309222344_5UZTK UK009C 2026-03-11T12:15:52.238Z 2026-03-17T12:42:59.355Z
9451283 9451283 20260310013614_O3ryz UK009C 2026-03-11T12:02:20.907Z 2026-03-18T12:38:44.277Z
9451217 9451217 20260310011730_9Y3nm UK009C 2026-03-11T12:02:06.292Z 2026-03-18T12:38:43.192Z
9450721 9450721 20260309225248_9YZtJ UK009C 2026-03-11T12:00:24.471Z 2026-03-18T12:38:34.578Z
9445577 9445577 20260307204119_3IEp7 UK009C 2026-03-09T12:19:55.359Z 2026-03-15T12:42:11.417Z
9445513 9445513 20260307201158_fWoda UK009C 2026-03-09T12:19:33.262Z 2026-03-15T12:42:10.261Z
9441787 9441787 20260307234330_FKK2c UK009C 2026-03-09T12:01:13.842Z 2026-03-16T12:43:31.302Z
9441548 9441548 20260306223314_DBoHx UK009C 2026-03-08T12:22:24.136Z 2026-03-14T12:40:56.868Z
9441541 9441541 20260306222953_8Dv8x UK009C 2026-03-08T12:22:19.938Z 2026-03-14T12:40:55.569Z
9441472 9441472 20260306220843_2W8Ga UK009C 2026-03-08T12:22:03.435Z 2026-03-14T12:40:52.541Z
9441419 9441419 20260306213837_5ZQFN UK009C 2026-03-08T12:21:48.362Z 2026-03-14T12:40:51.844Z
9437601 9437601 20260307045654_fba0V UK009C 2026-03-08T12:04:40.768Z 2026-03-15T12:41:22.133Z
9437547 9437547 20260307043443_JRUER UK009C 2026-03-08T12:04:28.203Z 2026-03-15T12:41:12.449Z
9437401 9437401 20260307033259_ZKAj6 UK009C 2026-03-08T12:03:49.829Z 2026-03-15T12:41:07.241Z
9437301 9437301 20260307030237_ltvid UK009C 2026-03-08T12:03:27.971Z 2026-03-15T12:41:05.934Z
9437078 9437078 20260307014652_FdMvj UK009C 2026-03-08T12:02:32.023Z 2026-03-15T12:41:01.837Z
9437020 9437020 20260307011916_enD7C UK009C 2026-03-08T12:02:17.535Z 2026-03-15T12:41:00.955Z
9436940 9436940 20260307004653_qg2V2 UK009C 2026-03-08T12:01:56.459Z 2026-03-15T12:40:59.864Z
9436921 9436921 20260307004038_TKR3q UK009C 2026-03-08T12:01:50.122Z 2026-03-15T12:40:59.565Z
9436893 9436893 20260307003246_GlkEB UK009C 2026-03-08T12:01:40.690Z 2026-03-15T12:40:59.185Z
9436764 9436764 20260306234632_jZqAn UK009C 2026-03-08T12:01:09.096Z 2026-03-15T12:40:57.388Z
9436695 9436695 20260306232302_29pKc UK009C 2026-03-08T12:00:51.975Z 2026-03-15T12:40:56.550Z
9436691 9436691 20260306232158_2B4lf UK009C 2026-03-08T12:00:50.521Z 2026-03-15T12:40:56.486Z
9436646 9436646 20260306231057_3htgh UK009C 2026-03-08T12:00:33.873Z 2026-03-15T12:40:55.798Z
9436599 9436599 20260306224848_uinIP UK009C 2026-03-08T12:00:17.842Z 2026-03-15T12:40:55.183Z
9432388 9432388 20260306054214_k30fO UK009C 2026-03-07T14:04:33.139Z 2026-03-14T12:39:29.595Z

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