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

3,679 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
8683267 8683267 20251203064758_WMOCj UK00C2 2025-12-04T14:19:01.857Z 2025-12-05T14:23:13.479Z
8683197 8683197 20251203063843_LHuJd UK00C2 2025-12-04T14:18:54.659Z 2025-12-05T14:23:10.986Z
8683173 8683173 20251203063433_K4JFD UK00C2 2025-12-04T14:18:43.646Z 2025-12-05T14:23:09.823Z
8682880 8682880 20251203061135_yNjsy UK00C2 2025-12-04T14:18:10.904Z 2025-12-05T14:22:55.261Z
8682869 8682869 20251203061134_2jYU8 UK00C2 2025-12-04T14:18:10.224Z 2025-12-05T14:22:54.985Z
8682834 8682834 20251203060844_VWBTJ UK00C2 2025-12-04T14:18:04.295Z 2025-12-05T14:22:53.457Z
8682620 8682620 20251203055127_dXsny UK00C2 2025-12-04T14:17:43.587Z 2025-12-05T14:22:45.201Z
8682550 8682550 20251203054454_ZWE2G UK00C2 2025-12-04T14:17:26.224Z 2025-12-05T14:22:42.309Z
8682173 8682173 20251203045635_icbRU UK00C2 2025-12-04T14:16:32.791Z 2025-12-05T14:22:16.970Z
8682117 8682117 20251203045258_2MyOP UK00C2 2025-12-04T14:16:28.347Z 2025-12-05T14:22:15.082Z
8682032 8682032 20251203044242_ZXv2u UK00C2 2025-12-04T14:16:15.314Z 2025-12-05T14:22:12.312Z
8681836 8681836 20251203041407_Trz6K UK00C2 2025-12-04T14:15:43.446Z 2025-12-05T14:22:03.447Z
8681735 8681735 20251203035126_Cx93r UK00C2 2025-12-04T14:15:28.669Z 2025-12-05T14:21:51.731Z
8681594 8681594 20251203032739_dBTzS UK00C2 2025-12-04T14:15:05.741Z 2025-12-05T14:21:42.402Z
8681587 8681587 20251203032620_WhmNa UK00C2 2025-12-04T14:15:05.048Z 2025-12-05T14:21:41.957Z
8681582 8681582 20251203032606_siL0u UK00C2 2025-12-04T14:15:04.687Z 2025-12-05T14:21:41.844Z
8681493 8681493 20251203031551_ZB9Pb UK00C2 2025-12-04T14:14:48.761Z 2025-12-05T14:21:38.837Z
8681374 8681374 20251203030130_J7D53 UK00C2 2025-12-04T14:14:35.418Z 2025-12-05T14:21:34.376Z
8681277 8681277 20251203025135_gcaTl UK00C2 2025-12-04T14:14:14.575Z 2025-12-05T14:21:30.123Z
8681269 8681269 20251203025131_ClqEi UK00C2 2025-12-04T14:14:13.931Z 2025-12-05T14:21:29.884Z
8681169 8681169 20251203023411_um3M0 UK00C2 2025-12-04T14:13:59.581Z 2025-12-05T14:21:23.671Z
8680900 8680900 20251203014334_oBTyS UK00C2 2025-12-04T14:13:17.332Z 2025-12-05T14:21:06.196Z
8680787 8680787 20251203012022_OGZCw UK00C2 2025-12-04T14:12:55.834Z 2025-12-05T14:21:01.106Z
8680778 8680778 20251203011945_h6EuC UK00C2 2025-12-04T14:12:54.325Z 2025-12-05T14:21:00.589Z
8680736 8680736 20251203011133_qdCkw UK00C2 2025-12-04T14:12:49.634Z 2025-12-05T14:20:58.627Z
8680572 8680572 20251203003045_aLtii UK00C2 2025-12-04T14:12:22.393Z 2025-12-05T14:20:44.869Z
8680462 8680462 20251203000421_rhkuc UK00C2 2025-12-04T14:12:04.548Z 2025-12-05T14:20:39.410Z
8680443 8680443 20251202235926_sSsXW UK00C2 2025-12-04T14:12:00.435Z 2025-12-05T14:20:38.519Z
8680327 8680327 20251202232004_3kH6Q UK00C2 2025-12-04T14:11:46.863Z 2025-12-05T14:20:34.013Z
8680321 8680321 20251202231914_AWSg0 UK00C2 2025-12-04T14:11:41.644Z 2025-12-05T14:20:33.719Z
8680308 8680308 20251202230956_oXOkU UK00C2 2025-12-04T14:11:39.675Z 2025-12-05T14:20:33.002Z
8680288 8680288 20251202225647_cVYr4 UK00C2 2025-12-04T14:11:34.184Z 2025-12-05T14:20:31.810Z
8680279 8680279 20251202225601_htE7y UK00C2 2025-12-04T14:11:33.264Z 2025-12-05T14:20:31.490Z
8680236 8680236 20251202223909_H0Fvk UK00C2 2025-12-04T14:11:28.218Z 2025-12-05T14:20:25.284Z
8680167 8680167 20251202215617_g3ZA0 UK00C2 2025-12-04T14:11:19.618Z 2025-12-05T14:20:21.953Z
8676932 8676932 20251202063108_mb3Ug UK00C2 2025-12-03T14:25:56.392Z 2025-12-05T14:29:16.273Z
8676903 8676903 20251202063049_mlP9C UK00C2 2025-12-03T14:25:55.509Z 2025-12-05T14:29:15.874Z
8676842 8676842 20251202062756_Dpbv2 UK00C2 2025-12-03T14:25:52.370Z 2025-12-05T14:29:14.581Z
8676603 8676603 20251202060704_2I4GT UK00C2 2025-12-03T14:25:21.153Z 2025-12-05T14:29:08.694Z
8676590 8676590 20251202060414_X52Ag UK00C2 2025-12-03T14:25:20.321Z 2025-12-05T14:29:08.330Z
8675963 8675963 20251202052706_x3khz UK00C2 2025-12-03T14:24:34.096Z 2025-12-05T14:28:45.316Z
8675938 8675938 20251202052435_m8kMj UK00C2 2025-12-03T14:24:31.909Z 2025-12-05T14:28:44.646Z
8675926 8675926 20251202052301_Wb9sl UK00C2 2025-12-03T14:24:30.663Z 2025-12-05T14:28:44.217Z
8675919 8675919 20251202052257_DArRJ UK00C2 2025-12-03T14:24:29.975Z 2025-12-05T14:28:44.007Z
8675814 8675814 20251202051530_NIBeK UK00C2 2025-12-03T14:24:16.364Z 2025-12-05T14:28:41.160Z
8675749 8675749 20251202051218_RyOBY UK00C2 2025-12-03T14:24:13.604Z 2025-12-05T14:28:40.018Z
8675630 8675630 20251202050216_B6IWq UK00C2 2025-12-03T14:23:56.710Z 2025-12-05T14:28:36.992Z
8675513 8675513 20251202045107_vcp34 UK00C2 2025-12-03T14:23:48.675Z 2025-12-05T14:28:34.303Z
8675286 8675286 20251202042551_jyIyC UK00C2 2025-12-03T14:23:29.301Z 2025-12-05T14:28:19.004Z
8675279 8675279 20251202042534_5tP7y UK00C2 2025-12-03T14:23:28.342Z 2025-12-05T14:28:18.751Z
8674982 8674982 20251202034523_I3f7Z UK00C2 2025-12-03T14:22:47.505Z 2025-12-05T14:28:08.135Z
8674924 8674924 20251202033952_JxcoJ UK00C2 2025-12-03T14:22:43.588Z 2025-12-05T14:28:06.770Z
8674801 8674801 20251202032748_B3lMQ UK00C2 2025-12-03T14:22:26.282Z 2025-12-05T14:28:03.487Z
8674739 8674739 20251202031855_2oxQh UK00C2 2025-12-03T14:22:16.799Z 2025-12-05T14:28:01.611Z
8674450 8674450 20251202022457_m79hg UK00C2 2025-12-03T14:21:39.005Z 2025-12-05T14:27:41.855Z
8674439 8674439 20251202022429_jtmem UK00C2 2025-12-03T14:21:38.128Z 2025-12-05T14:27:41.574Z
8674363 8674363 20251202021100_4yO6i UK00C2 2025-12-03T14:21:32.191Z 2025-12-05T14:27:39.282Z
8674333 8674333 20251202020238_WLTzp UK00C2 2025-12-03T14:21:25.233Z 2025-12-05T14:27:36.633Z
8674264 8674264 20251202015509_tper3 UK00C2 2025-12-03T14:21:18.177Z 2025-12-05T14:27:34.154Z
8674208 8674208 20251202014542_VnPly UK00C2 2025-12-03T14:21:09.469Z 2025-12-05T14:27:32.313Z
8674187 8674187 20251202014411_jBvNF UK00C2 2025-12-03T14:21:08.063Z 2025-12-05T14:27:31.648Z
8674138 8674138 20251202013226_PMQ9b UK00C2 2025-12-03T14:20:58.980Z 2025-12-05T14:27:29.994Z
8674104 8674104 20251202012838_GGdn9 UK00C2 2025-12-03T14:20:56.067Z 2025-12-05T14:27:28.713Z
8673967 8673967 20251202004859_H5sJb UK00C2 2025-12-03T14:20:26.595Z 2025-12-05T14:27:24.124Z
8673908 8673908 20251202002450_JdMxV UK00C2 2025-12-03T14:20:17.309Z 2025-12-05T14:27:22.556Z
8668020 8668020 20251130054054_VuUr7 UK00C2 2025-12-02T14:41:30.504Z 2025-12-05T14:45:28.938Z
8667909 8667909 20251130050823_Y2WUb UK00C2 2025-12-02T14:41:17.306Z 2025-12-05T14:45:20.690Z
8667456 8667456 20251130013641_Da63a UK00C2 2025-12-02T14:38:18.136Z 2025-12-05T14:42:53.710Z
8667448 8667448 20251130012853_N1oQ3 UK00C2 2025-12-02T14:38:13.520Z 2025-12-05T14:42:50.988Z
8667439 8667439 20251130012104_fPjHX UK00C2 2025-12-02T14:38:09.194Z 2025-12-05T14:42:47.751Z
8667420 8667420 20251130011101_L8Gal UK00C2 2025-12-02T14:38:05.025Z 2025-12-05T14:42:45.179Z
8667417 8667417 20251130010242_mDUXA UK00C2 2025-12-02T14:38:01.468Z 2025-12-05T14:42:42.543Z
8667396 8667396 20251130005841_o813C UK00C2 2025-12-02T14:37:57.661Z 2025-12-05T14:42:40.467Z
8667379 8667379 20251130003955_mOU3F UK00C2 2025-12-02T14:37:34.462Z 2025-12-05T14:42:12.979Z
8667377 8667377 20251130003522_JgSbE UK00C2 2025-12-02T14:37:31.190Z 2025-12-05T14:42:11.919Z
8667365 8667365 20251130002015_0AYD8 UK00C2 2025-12-02T14:37:26.626Z 2025-12-05T14:42:06.554Z
8661788 8661788 20251130171132_gSbPV UK00C2 2025-12-02T14:13:01.960Z 2025-12-05T14:32:35.487Z
8658664 8658664 20251125044111_pGd1l UK00C2 2025-12-01T15:11:44.442Z 2025-12-02T15:09:29.928Z
8658657 8658657 20251125021222_eQqsU UK00C2 2025-12-01T15:09:37.441Z 2025-12-02T15:08:30.402Z
8658653 8658653 20251125014135_2irP9 UK00C2 2025-12-01T15:09:33.858Z 2025-12-02T15:08:17.136Z
8658620 8658620 20251126060915_LTkal UK00C2 2025-12-01T15:05:29.908Z 2025-12-04T15:11:40.893Z
8658616 8658616 20251126055957_jadbj UK00C2 2025-12-01T15:05:21.764Z 2025-12-04T15:11:39.446Z
8658612 8658612 20251126054644_hwbJO UK00C2 2025-12-01T15:05:06.338Z 2025-12-04T15:11:36.951Z
8658605 8658605 20251126053426_fNJ38 UK00C2 2025-12-01T15:04:59.960Z 2025-12-04T15:11:34.931Z
8658603 8658603 20251126052848_rxgVR UK00C2 2025-12-01T15:04:56.884Z 2025-12-04T15:11:33.807Z
8658599 8658599 20251126052010_IZ4pq UK00C2 2025-12-01T15:04:52.741Z 2025-12-04T15:11:32.722Z
8658594 8658594 20251126051628_Yosa3 UK00C2 2025-12-01T15:04:52.040Z 2025-12-04T15:11:31.792Z
8658592 8658592 20251126051131_KdMWJ UK00C2 2025-12-01T15:04:51.139Z 2025-12-04T15:11:30.773Z
8658586 8658586 20251126045631_HQARs UK00C2 2025-12-01T15:04:48.680Z 2025-12-04T15:11:27.809Z
8658584 8658584 20251126045446_Rg9Mq UK00C2 2025-12-01T15:04:47.455Z 2025-12-04T15:11:27.543Z
8658582 8658582 20251126045129_60GOi UK00C2 2025-12-01T15:04:45.394Z 2025-12-04T15:11:26.877Z
8658572 8658572 20251126042548_niEUx UK00C2 2025-12-01T15:04:40.414Z 2025-12-04T15:11:07.673Z
8658570 8658570 20251126042546_tNDlQ UK00C2 2025-12-01T15:04:40.324Z 2025-12-04T15:11:05.836Z
8658557 8658557 20251126040810_v4f7y UK00C2 2025-12-01T15:04:37.288Z 2025-12-04T15:10:39.746Z
8658546 8658546 20251126034922_5322q UK00C2 2025-12-01T15:04:33.674Z 2025-12-04T15:10:16.343Z
8658542 8658542 20251126034501_Sa6pk UK00C2 2025-12-01T15:04:32.654Z 2025-12-04T15:10:03.365Z
8658534 8658534 20251126033324_llPkh UK00C2 2025-12-01T15:04:29.170Z 2025-12-04T15:09:51.604Z
8658516 8658516 20251126030648_8o2nS UK00C2 2025-12-01T15:03:57.178Z 2025-12-04T15:09:38.054Z
8658513 8658513 20251126030537_HynPB UK00C2 2025-12-01T15:03:52.790Z 2025-12-04T15:09:37.833Z
8658511 8658511 20251126025634_4eZA3 UK00C2 2025-12-01T15:03:41.141Z 2025-12-04T15:09:35.955Z

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