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 = "UK0031" 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
8690576 8690576 20251205003608_aVGFW UK0031 2025-12-06T14:14:46.389Z 2025-12-06T14:18:00.912Z
8683190 8683190 20251203063843_CoMyb UK0031 2025-12-04T14:18:54.275Z 2025-12-06T14:29:44.969Z
8683112 8683112 20251203062758_iS9Fv UK0031 2025-12-04T14:18:35.016Z 2025-12-06T14:29:41.743Z
8682997 8682997 20251203061840_vjAu6 UK0031 2025-12-04T14:18:26.459Z 2025-12-06T14:29:38.549Z
8682810 8682810 20251203060704_b2hwW UK0031 2025-12-04T14:18:03.449Z 2025-12-06T14:29:26.576Z
8682699 8682699 20251203060028_j3Whj UK0031 2025-12-04T14:17:55.527Z 2025-12-06T14:29:23.322Z
8682224 8682224 20251203050246_i5wEz UK0031 2025-12-04T14:16:38.652Z 2025-12-06T14:28:50.339Z
8682059 8682059 20251203044654_qW9Ws UK0031 2025-12-04T14:16:18.671Z 2025-12-06T14:28:45.455Z
8681868 8681868 20251203041757_yvF8K UK0031 2025-12-04T14:15:49.268Z 2025-12-06T14:28:34.635Z
8681755 8681755 20251203035611_23bKk UK0031 2025-12-04T14:15:30.838Z 2025-12-06T14:28:28.170Z
8681569 8681569 20251203032552_Ogp2S UK0031 2025-12-04T14:15:04.206Z 2025-12-06T14:28:18.830Z
8681482 8681482 20251203031550_T7BtP UK0031 2025-12-04T14:14:48.595Z 2025-12-06T14:28:14.060Z
8681354 8681354 20251203025828_merF7 UK0031 2025-12-04T14:14:33.211Z 2025-12-06T14:28:04.507Z
8681342 8681342 20251203025746_JAM4x UK0031 2025-12-04T14:14:32.161Z 2025-12-06T14:28:03.987Z
8681204 8681204 20251203023829_77FdY UK0031 2025-12-04T14:14:03.374Z 2025-12-06T14:27:55.176Z
8681122 8681122 20251203022606_yDy6a UK0031 2025-12-04T14:13:53.925Z 2025-12-06T14:27:50.279Z
8681036 8681036 20251203021516_7eoU3 UK0031 2025-12-04T14:13:37.621Z 2025-12-06T14:27:47.103Z
8680909 8680909 20251203014907_zVWbn UK0031 2025-12-04T14:13:20.684Z 2025-12-06T14:27:32.808Z
8680708 8680708 20251203010652_tgUSg UK0031 2025-12-04T14:12:46.285Z 2025-12-06T14:27:23.067Z
8680660 8680660 20251203005717_BrCfK UK0031 2025-12-04T14:12:36.090Z 2025-12-06T14:27:21.405Z
8680609 8680609 20251203004654_f5vxn UK0031 2025-12-04T14:12:27.764Z 2025-12-06T14:27:19.649Z
8680542 8680542 20251203002658_vtzpj UK0031 2025-12-04T14:12:18.509Z 2025-12-06T14:27:16.946Z
8680496 8680496 20251203001904_2X9nn UK0031 2025-12-04T14:12:12.016Z 2025-12-06T14:27:14.091Z
8680414 8680414 20251202235333_0LN27 UK0031 2025-12-04T14:11:56.590Z 2025-12-06T14:27:11.036Z
8680205 8680205 20251202223051_pu30j UK0031 2025-12-04T14:11:24.991Z 2025-12-06T14:26:56.234Z
8680196 8680196 20251202222350_bGv3e UK0031 2025-12-04T14:11:24.240Z 2025-12-06T14:26:55.827Z
8679997 8679997 20251202211551_0SaV3 UK0031 2025-12-04T14:10:52.898Z 2025-12-06T14:26:46.947Z
8679963 8679963 20251202211301_Pndr2 UK0031 2025-12-04T14:10:49.384Z 2025-12-06T14:26:45.530Z
8677041 8677041 20251202064220_Unh26 UK0031 2025-12-03T14:26:13.271Z 2025-12-06T14:35:33.397Z
8676976 8676976 20251202063619_F3JS8 UK0031 2025-12-03T14:25:59.174Z 2025-12-06T14:35:32.182Z
8676833 8676833 20251202062756_Dpbv2 UK0031 2025-12-03T14:25:52.369Z 2025-12-06T14:35:29.524Z
8676616 8676616 20251202060852_GTz42 UK0031 2025-12-03T14:25:22.448Z 2025-12-06T14:35:24.872Z
8676449 8676449 20251202055315_g4Ivq UK0031 2025-12-03T14:25:13.099Z 2025-12-06T14:35:21.882Z
8676435 8676435 20251202055303_rJE7O UK0031 2025-12-03T14:25:12.734Z 2025-12-06T14:35:21.800Z
8676372 8676372 20251202054950_EwSxE UK0031 2025-12-03T14:25:09.839Z 2025-12-06T14:35:20.875Z
8676186 8676186 20251202053955_Z1Qhy UK0031 2025-12-03T14:24:48.657Z 2025-12-06T14:35:18.561Z
8676164 8676164 20251202053942_XoT3u UK0031 2025-12-03T14:24:47.969Z 2025-12-06T14:35:17.997Z
8676154 8676154 20251202053907_eBwmt UK0031 2025-12-03T14:24:47.195Z 2025-12-06T14:35:17.454Z
8676046 8676046 20251202053410_JoXh5 UK0031 2025-12-03T14:24:38.311Z 2025-12-06T14:35:07.324Z
8675941 8675941 20251202052534_V539f UK0031 2025-12-03T14:24:32.299Z 2025-12-06T14:35:05.290Z
8675849 8675849 20251202051854_2wpXN UK0031 2025-12-03T14:24:26.170Z 2025-12-06T14:35:03.419Z
8675738 8675738 20251202051218_RyOBY UK0031 2025-12-03T14:24:13.603Z 2025-12-06T14:34:59.480Z
8675716 8675716 20251202051108_eMwMj UK0031 2025-12-03T14:24:12.386Z 2025-12-06T14:34:59.241Z
8675644 8675644 20251202050332_znz02 UK0031 2025-12-03T14:23:57.787Z 2025-12-06T14:34:57.483Z
8675609 8675609 20251202050215_fgICz UK0031 2025-12-03T14:23:56.044Z 2025-12-06T14:34:57.250Z
8675566 8675566 20251202045706_TVoSY UK0031 2025-12-03T14:23:51.990Z 2025-12-06T14:34:56.425Z
8675556 8675556 20251202045633_0g8Ha UK0031 2025-12-03T14:23:51.596Z 2025-12-06T14:34:56.343Z
8675459 8675459 20251202044357_Kx77Z UK0031 2025-12-03T14:23:45.214Z 2025-12-06T14:34:53.694Z
8675271 8675271 20251202042534_5tP7y UK0031 2025-12-03T14:23:28.330Z 2025-12-06T14:34:48.734Z
8675142 8675142 20251202040541_3YLgJ UK0031 2025-12-03T14:23:07.437Z 2025-12-06T14:34:35.792Z
8673872 8673872 20251202001019_7X0ts UK0031 2025-12-03T14:20:13.363Z 2025-12-06T14:33:38.659Z
8673838 8673838 20251201235812_BjBhz UK0031 2025-12-03T14:20:10.342Z 2025-12-06T14:33:37.260Z
8673810 8673810 20251201233920_oG1D2 UK0031 2025-12-03T14:20:05.580Z 2025-12-06T14:33:35.645Z
8658084 8658084 20251130063643_VAtuD UK0031 2025-12-01T14:34:54.056Z 2025-12-06T14:50:26.345Z
8657988 8657988 20251130062447_Y3ev9 UK0031 2025-12-01T14:34:48.951Z 2025-12-06T14:50:25.052Z
8657815 8657815 20251130061023_Sov5z UK0031 2025-12-01T14:34:42.406Z 2025-12-06T14:50:22.818Z
8657772 8657772 20251130060809_7vVBo UK0031 2025-12-01T14:34:40.925Z 2025-12-06T14:50:22.462Z
8657761 8657761 20251130060625_Cpcoo UK0031 2025-12-01T14:34:40.261Z 2025-12-06T14:50:22.367Z
8657738 8657738 20251130060420_J1Vss UK0031 2025-12-01T14:34:39.618Z 2025-12-06T14:50:22.121Z
8657429 8657429 20251130054522_D8Im5 UK0031 2025-12-01T14:34:26.052Z 2025-12-06T14:50:01.263Z
8657307 8657307 20251130053829_nOJs2 UK0031 2025-12-01T14:34:04.096Z 2025-12-06T14:49:51.870Z
8657191 8657191 20251130053332_Eb2AW UK0031 2025-12-01T14:34:00.336Z 2025-12-06T14:49:45.748Z
8657160 8657160 20251130053213_jVUGf UK0031 2025-12-01T14:33:57.213Z 2025-12-06T14:49:45.360Z
8657133 8657133 20251130053152_rraPH UK0031 2025-12-01T14:33:55.926Z 2025-12-06T14:49:45.168Z
8657085 8657085 20251130052936_101eh UK0031 2025-12-01T14:33:54.132Z 2025-12-06T14:49:44.771Z
8656931 8656931 20251130051838_Tiv6C UK0031 2025-12-01T14:33:49.351Z 2025-12-06T14:49:42.976Z
8656919 8656919 20251130051818_GEpgT UK0031 2025-12-01T14:33:49.194Z 2025-12-06T14:49:42.928Z
8656666 8656666 20251130050557_M6v3F UK0031 2025-12-01T14:28:53.504Z 2025-12-06T14:49:38.399Z
8656591 8656591 20251130050049_v70Ll UK0031 2025-12-01T14:28:46.613Z 2025-12-06T14:49:36.701Z
8655542 8655542 20251130040648_Wzx2z UK0031 2025-12-01T14:27:02.794Z 2025-12-06T14:49:25.115Z
8655520 8655520 20251130040628_6jytl UK0031 2025-12-01T14:27:02.138Z 2025-12-06T14:49:24.927Z
8655430 8655430 20251130040215_I95H7 UK0031 2025-12-01T14:26:53.856Z 2025-12-06T14:49:15.979Z
8655298 8655298 20251130035347_dHxxi UK0031 2025-12-01T14:26:44.532Z 2025-12-06T14:49:03.255Z
8655117 8655117 20251130034514_3lwWx UK0031 2025-12-01T14:26:24.055Z 2025-12-06T14:48:51.656Z
8655053 8655053 20251130034210_NHNlI UK0031 2025-12-01T14:26:19.485Z 2025-12-06T14:48:51.113Z
8654647 8654647 20251130032444_VbTDs UK0031 2025-12-01T14:25:40.688Z 2025-12-06T14:48:45.465Z
8654182 8654182 20251130030236_i5D2b UK0031 2025-12-01T14:24:56.912Z 2025-12-06T14:48:38.543Z
8654031 8654031 20251130025353_9u0BD UK0031 2025-12-01T14:24:45.925Z 2025-12-06T14:48:36.270Z
8653459 8653459 20251130021724_Iaxik UK0031 2025-12-01T14:23:32.809Z 2025-12-06T14:47:58.788Z
8653444 8653444 20251130021628_PTnyP UK0031 2025-12-01T14:23:32.077Z 2025-12-06T14:47:58.280Z
8653358 8653358 20251130021224_k2NR8 UK0031 2025-12-01T14:23:17.937Z 2025-12-06T14:47:56.596Z
8653190 8653190 20251130020132_hfVYU UK0031 2025-12-01T14:23:03.249Z 2025-12-06T14:47:51.274Z
8652712 8652712 20251130012839_FiUaZ UK0031 2025-12-01T14:22:01.728Z 2025-12-06T14:47:41.432Z
8652655 8652655 20251130012633_PA0ew UK0031 2025-12-01T14:21:56.191Z 2025-12-06T14:47:40.709Z
8652625 8652625 20251130012501_9mbQ1 UK0031 2025-12-01T14:21:53.072Z 2025-12-06T14:47:40.364Z
8652599 8652599 20251130012250_ulDaA UK0031 2025-12-01T14:21:51.162Z 2025-12-06T14:47:40.035Z
8652543 8652543 20251130011821_2gizD UK0031 2025-12-01T14:21:40.188Z 2025-12-06T14:47:38.835Z
8652473 8652473 20251130011218_UmldL UK0031 2025-12-01T14:21:29.034Z 2025-12-06T14:47:37.582Z
8652210 8652210 20251130005520_2a072 UK0031 2025-12-01T14:20:55.747Z 2025-12-06T14:47:31.435Z
8652023 8652023 20251130004144_igd3d UK0031 2025-12-01T14:20:29.684Z 2025-12-06T14:47:00.445Z
8651935 8651935 20251130003522_jrk2G UK0031 2025-12-01T14:20:17.796Z 2025-12-06T14:46:56.446Z
8651902 8651902 20251130003243_fcdgj UK0031 2025-12-01T14:20:14.676Z 2025-12-06T14:46:55.964Z
8651746 8651746 20251130001635_FDdU7 UK0031 2025-12-01T14:19:49.198Z 2025-12-06T14:46:53.383Z
8651723 8651723 20251130001418_N0TZa UK0031 2025-12-01T14:19:45.703Z 2025-12-06T14:46:51.482Z
8651679 8651679 20251130000937_QyqT9 UK0031 2025-12-01T14:19:40.488Z 2025-12-06T14:46:50.334Z
8651667 8651667 20251130000929_cdbxU UK0031 2025-12-01T14:19:40.010Z 2025-12-06T14:46:50.264Z
8651657 8651657 20251130000854_C6I2K UK0031 2025-12-01T14:19:39.238Z 2025-12-06T14:46:50.175Z
8651490 8651490 20251129234812_7TWlh UK0031 2025-12-01T14:19:12.689Z 2025-12-06T14:46:47.490Z
8651461 8651461 20251129234504_Ggy7R UK0031 2025-12-01T14:19:09.328Z 2025-12-06T14:46:47.040Z
8651417 8651417 20251129234055_sT2Vq UK0031 2025-12-01T14:19:01.763Z 2025-12-06T14:46:45.922Z

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