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

4,768 rows where station_code = "UK00C2" 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
9611481 9611481 20260405021252_3oJvs UK00C2 2026-04-06T12:14:43.202Z 2026-04-06T12:16:14.808Z
9611449 9611449 20260405020318_7Er4J UK00C2 2026-04-06T12:14:36.813Z 2026-04-06T12:16:14.801Z
9610681 9610681 20260404211141_QoRVT UK00C2 2026-04-06T12:10:41.745Z 2026-04-06T12:16:14.634Z
9609227 9609227 20260405040134_bLRav UK00C2 2026-04-06T12:00:45.945Z 2026-04-06T12:00:45.945Z
9609201 9609201 20260405035806_OFdo5 UK00C2 2026-04-06T12:00:41.430Z 2026-04-06T12:00:41.430Z
9608608 9608608 20260403235606_bjq1s UK00C2 2026-04-05T12:10:54.535Z 2026-04-06T12:20:25.157Z
9608537 9608537 20260403233233_JZNxx UK00C2 2026-04-05T12:10:45.878Z 2026-04-06T12:20:19.075Z
9608450 9608450 20260403230641_MWiiM UK00C2 2026-04-05T12:10:28.368Z 2026-04-06T12:20:13.400Z
9608426 9608426 20260403230257_cm72s UK00C2 2026-04-05T12:10:24.416Z 2026-04-06T12:20:12.030Z
9608288 9608288 20260403212957_Enk12 UK00C2 2026-04-05T12:09:54.161Z 2026-04-06T12:20:03.502Z
9607047 9607047 20260404031925_eGRRQ UK00C2 2026-04-05T12:00:14.790Z 2026-04-06T12:16:14.350Z
9604661 9604661 20260401231417_td18u UK00C2 2026-04-03T12:11:03.857Z 2026-04-06T12:26:09.942Z
9595478 9595478 20260330041509_x6h57 UK00C2 2026-03-31T12:01:30.883Z 2026-04-06T12:30:05.527Z
9594225 9594225 20260328202128_EoQ1K UK00C2 2026-03-30T12:09:00.903Z 2026-04-06T12:39:43.742Z
9592601 9592601 20260329024537_rRudT UK00C2 2026-03-30T12:01:25.322Z 2026-04-06T12:34:17.441Z
9592590 9592590 20260329024139_nS1d7 UK00C2 2026-03-30T12:01:23.272Z 2026-04-06T12:34:16.567Z
9591913 9591913 20260327230231_T25zD UK00C2 2026-03-29T12:06:58.073Z 2026-04-05T12:35:19.365Z
9591779 9591779 20260327210321_l5RPg UK00C2 2026-03-29T12:06:44.128Z 2026-04-05T12:35:13.311Z
9589738 9589738 20260328040443_HxqKX UK00C2 2026-03-29T12:01:36.464Z 2026-04-06T12:37:32.587Z
9589327 9589327 20260328031734_e35Hx UK00C2 2026-03-29T12:01:06.728Z 2026-04-06T12:37:20.229Z
9588917 9588917 20260328015404_wp632 UK00C2 2026-03-29T12:00:28.890Z 2026-04-06T12:36:56.230Z
9585294 9585294 20260326000823_fsed8 UK00C2 2026-03-27T12:17:04.985Z 2026-04-03T12:39:54.147Z
9585248 9585248 20260325235539_UhGxc UK00C2 2026-03-27T12:16:59.352Z 2026-04-03T12:39:52.727Z
9585091 9585091 20260325232342_3gVlt UK00C2 2026-03-27T12:16:42.538Z 2026-04-03T12:39:49.098Z
9584826 9584826 20260325222203_v2UEK UK00C2 2026-03-27T12:16:10.765Z 2026-04-03T12:39:41.715Z
9584768 9584768 20260325220134_2tM2j UK00C2 2026-03-27T12:16:05.102Z 2026-04-03T12:39:40.331Z
9584719 9584719 20260325214919_A2AO2 UK00C2 2026-03-27T12:16:00.426Z 2026-04-03T12:39:29.676Z
9581921 9581921 20260326041151_AbPBX UK00C2 2026-03-27T12:04:09.198Z 2026-04-04T12:39:31.346Z
9581777 9581777 20260326035611_3U2Hi UK00C2 2026-03-27T12:03:50.185Z 2026-04-04T12:39:20.353Z
9581575 9581575 20260326033136_H7QUJ UK00C2 2026-03-27T12:03:25.762Z 2026-04-04T12:39:11.002Z
9581420 9581420 20260326030924_HRzXo UK00C2 2026-03-27T12:03:02.883Z 2026-04-04T12:39:03.994Z
9581283 9581283 20260326024618_UmUBn UK00C2 2026-03-27T12:02:37.979Z 2026-04-04T12:38:51.558Z
9581181 9581181 20260326023233_WB5bk UK00C2 2026-03-27T12:02:17.972Z 2026-04-04T12:38:44.736Z
9581129 9581129 20260326022731_oZw9m UK00C2 2026-03-27T12:02:11.596Z 2026-04-04T12:38:43.403Z
9580971 9580971 20260326020015_KxAx3 UK00C2 2026-03-27T12:01:46.973Z 2026-04-04T12:38:36.692Z
9580804 9580804 20260326013431_XdW6Y UK00C2 2026-03-27T12:01:26.881Z 2026-04-04T12:38:29.831Z
9580780 9580780 20260326012859_SdjcB UK00C2 2026-03-27T12:01:22.858Z 2026-04-04T12:38:28.910Z
9580607 9580607 20260326010644_U2LNJ UK00C2 2026-03-27T12:00:55.536Z 2026-04-04T12:38:17.776Z
9580401 9580401 20260326004322_hQwqd UK00C2 2026-03-27T12:00:21.363Z 2026-04-04T12:38:08.338Z
9570554 9570554 20260322220052_FIpdg UK00C2 2026-03-24T12:23:27.263Z 2026-03-30T12:30:45.321Z
9561222 9561222 20260321230937_fqZYa UK00C2 2026-03-23T12:12:14.156Z 2026-03-29T12:21:05.793Z
9560193 9560193 20260321204556_Ng6di UK00C2 2026-03-23T12:11:40.039Z 2026-03-29T12:20:58.473Z
9559922 9559922 20260321200942_9U3mw UK00C2 2026-03-23T12:11:33.696Z 2026-03-29T12:20:56.587Z
9559765 9559765 20260321194130_xFS2j UK00C2 2026-03-23T12:11:29.386Z 2026-03-29T12:20:51.078Z
9555003 9555003 20260322035240_lo4yM UK00C2 2026-03-23T12:03:01.417Z 2026-03-30T12:28:12.942Z
9554865 9554865 20260322033956_YfreP UK00C2 2026-03-23T12:02:53.726Z 2026-03-30T12:28:10.569Z
9554772 9554772 20260322033435_a1WLt UK00C2 2026-03-23T12:02:50.467Z 2026-03-30T12:28:08.746Z
9554545 9554545 20260322031623_6z7va UK00C2 2026-03-23T12:02:39.289Z 2026-03-30T12:28:05.254Z
9554464 9554464 20260322031138_iF1r9 UK00C2 2026-03-23T12:02:33.750Z 2026-03-30T12:28:04.278Z
9554038 9554038 20260322023431_HUBr2 UK00C2 2026-03-23T12:02:10.627Z 2026-03-30T12:27:57.296Z
9553977 9553977 20260322022942_A36vo UK00C2 2026-03-23T12:02:04.465Z 2026-03-30T12:27:56.298Z
9553901 9553901 20260322022403_bt36V UK00C2 2026-03-23T12:01:58.948Z 2026-03-30T12:27:54.629Z
9553169 9553169 20260322012243_183id UK00C2 2026-03-23T12:01:17.968Z 2026-03-30T12:27:36.022Z
9552433 9552433 20260322000602_uRgGb UK00C2 2026-03-23T12:00:23.838Z 2026-03-30T12:27:23.926Z
9552291 9552291 20260321234836_2Nujk UK00C2 2026-03-23T12:00:11.737Z 2026-03-30T12:27:21.820Z
9552181 9552181 20260320231011_oPuMl UK00C2 2026-03-22T12:27:30.971Z 2026-03-28T12:37:07.615Z
9543605 9543605 20260321042605_qXm6F UK00C2 2026-03-22T12:04:14.867Z 2026-03-29T12:19:09.296Z
9542842 9542842 20260321013335_6Nw6r UK00C2 2026-03-22T12:01:46.011Z 2026-03-29T12:18:58.982Z
9542751 9542751 20260321011542_KrSp1 UK00C2 2026-03-22T12:01:30.174Z 2026-03-29T12:18:57.910Z
9542650 9542650 20260321003131_22ARl UK00C2 2026-03-22T12:01:04.393Z 2026-03-29T12:18:56.218Z
9542605 9542605 20260321002254_ecQQK UK00C2 2026-03-22T12:00:55.932Z 2026-03-29T12:18:46.346Z
9542522 9542522 20260320235731_9KJe2 UK00C2 2026-03-22T12:00:35.984Z 2026-03-29T12:18:45.062Z
9542462 9542462 20260320234108_7B4oP UK00C2 2026-03-22T12:00:19.445Z 2026-03-29T12:18:44.230Z
9542398 9542398 20260319232118_ywD88 UK00C2 2026-03-21T12:30:01.615Z 2026-03-27T12:43:01.963Z
9542296 9542296 20260319230822_fcXcD UK00C2 2026-03-21T12:29:56.509Z 2026-03-27T12:42:54.722Z
9541986 9541986 20260319222149_PVs7T UK00C2 2026-03-21T12:29:33.456Z 2026-03-27T12:42:43.718Z
9541911 9541911 20260319220512_r7Nm8 UK00C2 2026-03-21T12:29:29.298Z 2026-03-27T12:42:42.947Z
9541540 9541540 20260319205747_X03Kb UK00C2 2026-03-21T12:29:03.737Z 2026-03-27T12:42:38.600Z
9533914 9533914 20260320030910_ihCzc UK00C2 2026-03-21T12:06:36.771Z 2026-03-28T12:34:02.207Z
9533280 9533280 20260320022147_nnPXZ UK00C2 2026-03-21T12:05:01.529Z 2026-03-28T12:33:51.432Z
9532982 9532982 20260320014329_R6Ac3 UK00C2 2026-03-21T12:04:08.344Z 2026-03-28T12:33:47.165Z
9532838 9532838 20260320013210_nUGNT UK00C2 2026-03-21T12:03:46.610Z 2026-03-28T12:33:44.765Z
9532100 9532100 20260320001816_RQnGj UK00C2 2026-03-21T12:01:43.118Z 2026-03-28T12:33:24.606Z
9531712 9531712 20260319233710_ncvjE UK00C2 2026-03-21T12:00:35.865Z 2026-03-28T12:33:20.642Z
9531710 9531710 20260319233708_K5Dzq UK00C2 2026-03-21T12:00:35.254Z 2026-03-28T12:33:20.563Z
9530819 9530819 20260318214542_39iZA UK00C2 2026-03-20T12:24:47.946Z 2026-03-26T12:39:15.735Z
9530246 9530246 20260318203103_mIQqR UK00C2 2026-03-20T12:24:14.713Z 2026-03-26T12:39:10.701Z
9530110 9530110 20260318200728_ALIXi UK00C2 2026-03-20T12:24:00.612Z 2026-03-26T12:39:09.290Z
9530010 9530010 20260318195441_xsmP3 UK00C2 2026-03-20T12:23:54.310Z 2026-03-26T12:39:08.252Z
9521533 9521533 20260319042533_Mivkb UK00C2 2026-03-20T12:08:11.401Z 2026-03-27T12:40:55.614Z
9521179 9521179 20260319035553_w9m1D UK00C2 2026-03-20T12:07:39.389Z 2026-03-27T12:40:52.322Z
9521170 9521170 20260319035545_sFD3v UK00C2 2026-03-20T12:07:38.684Z 2026-03-27T12:40:52.264Z
9520865 9520865 20260319034209_lidCm UK00C2 2026-03-20T12:07:06.278Z 2026-03-27T12:40:48.238Z
9520726 9520726 20260319033350_ulh05 UK00C2 2026-03-20T12:06:52.359Z 2026-03-27T12:40:46.689Z
9520675 9520675 20260319033108_1XUzl UK00C2 2026-03-20T12:06:46.992Z 2026-03-27T12:40:46.226Z
9520516 9520516 20260319032026_6v53H UK00C2 2026-03-20T12:06:28.896Z 2026-03-27T12:40:44.191Z
9520449 9520449 20260319031615_yKvlS UK00C2 2026-03-20T12:06:23.389Z 2026-03-27T12:40:43.340Z
9520237 9520237 20260319030559_DvG0r UK00C2 2026-03-20T12:06:01.403Z 2026-03-27T12:40:40.821Z
9520073 9520073 20260319025045_35qVn UK00C2 2026-03-20T12:05:38.155Z 2026-03-27T12:40:38.453Z
9520042 9520042 20260319024914_U76iQ UK00C2 2026-03-20T12:05:35.048Z 2026-03-27T12:40:38.176Z
9519947 9519947 20260319024506_FlOJJ UK00C2 2026-03-20T12:05:24.627Z 2026-03-27T12:40:37.189Z
9519222 9519222 20260319015432_3gs1n UK00C2 2026-03-20T12:04:06.587Z 2026-03-27T12:40:19.057Z
9518548 9518548 20260319010744_PmXM9 UK00C2 2026-03-20T12:02:47.012Z 2026-03-27T12:40:11.184Z
9518504 9518504 20260319010442_jvy3N UK00C2 2026-03-20T12:02:43.138Z 2026-03-27T12:40:10.713Z
9518048 9518048 20260319002516_PxVsS UK00C2 2026-03-20T12:01:49.345Z 2026-03-27T12:40:05.997Z
9517822 9517822 20260319000540_voHUO UK00C2 2026-03-20T12:01:21.756Z 2026-03-27T12:40:03.743Z
9517171 9517171 20260317224915_Hh0ix UK00C2 2026-03-19T12:27:16.276Z 2026-03-25T12:43:09.075Z
9516723 9516723 20260317214243_KIsoU UK00C2 2026-03-19T12:26:41.459Z 2026-03-25T12:43:06.300Z
9516671 9516671 20260317212636_nvy8y UK00C2 2026-03-19T12:26:37.751Z 2026-03-25T12:43:05.299Z
9516654 9516654 20260317212527_A7D99 UK00C2 2026-03-19T12:26:36.745Z 2026-03-25T12:43:04.957Z

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