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

9,214 rows where station_code = "UK004F" 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
8683020 8683020 20251203061855_Iw81H UK004F 2025-12-04T14:18:26.939Z 2025-12-05T14:23:05.067Z
8682921 8682921 20251203061601_TwH62 UK004F 2025-12-04T14:18:20.930Z 2025-12-05T14:23:02.461Z
8682794 8682794 20251203060402_1FaRd UK004F 2025-12-04T14:18:01.564Z 2025-12-05T14:22:52.304Z
8682783 8682783 20251203060249_t9iiG UK004F 2025-12-04T14:18:00.399Z 2025-12-05T14:22:51.749Z
8682709 8682709 20251203060047_YWiWS UK004F 2025-12-04T14:17:55.933Z 2025-12-05T14:22:48.114Z
8682597 8682597 20251203054821_AGwHp UK004F 2025-12-04T14:17:40.545Z 2025-12-05T14:22:44.175Z
8682504 8682504 20251203054046_y4B8l UK004F 2025-12-04T14:17:19.217Z 2025-12-05T14:22:40.808Z
8682399 8682399 20251203052444_UH943 UK004F 2025-12-04T14:17:05.632Z 2025-12-05T14:22:35.133Z
8682292 8682292 20251203051054_kh5PR UK004F 2025-12-04T14:16:44.251Z 2025-12-05T14:22:23.078Z
8682250 8682250 20251203050730_g3Cx4 UK004F 2025-12-04T14:16:41.238Z 2025-12-05T14:22:21.127Z
8682235 8682235 20251203050655_mSIUY UK004F 2025-12-04T14:16:39.965Z 2025-12-05T14:22:19.720Z
8682016 8682016 20251203044109_AOoA0 UK004F 2025-12-04T14:16:10.605Z 2025-12-05T14:22:11.585Z
8682002 8682002 20251203043637_IWl3P UK004F 2025-12-04T14:16:08.105Z 2025-12-05T14:22:10.918Z
8681981 8681981 20251203043419_M6c18 UK004F 2025-12-04T14:16:05.034Z 2025-12-05T14:22:09.904Z
8681977 8681977 20251203043416_5Keu2 UK004F 2025-12-04T14:16:04.707Z 2025-12-05T14:22:09.745Z
8681789 8681789 20251203040514_u5wJd UK004F 2025-12-04T14:15:36.305Z 2025-12-05T14:22:01.058Z
8681718 8681718 20251203034946_K9XHo UK004F 2025-12-04T14:15:20.118Z 2025-12-05T14:21:50.752Z
8681678 8681678 20251203034525_y1Zji UK004F 2025-12-04T14:15:14.249Z 2025-12-05T14:21:48.706Z
8681287 8681287 20251203025416_XwaNn UK004F 2025-12-04T14:14:16.253Z 2025-12-05T14:21:30.819Z
8681167 8681167 20251203023202_LHYky UK004F 2025-12-04T14:13:59.279Z 2025-12-05T14:21:22.097Z
8681020 8681020 20251203021400_9J8ed UK004F 2025-12-04T14:13:34.072Z 2025-12-05T14:21:11.410Z
8680980 8680980 20251203020653_K3RAh UK004F 2025-12-04T14:13:30.260Z 2025-12-05T14:21:09.856Z
8680891 8680891 20251203014256_PXI7d UK004F 2025-12-04T14:13:11.492Z 2025-12-05T14:21:05.931Z
8680821 8680821 20251203012354_Z2zsC UK004F 2025-12-04T14:13:00.045Z 2025-12-05T14:21:02.228Z
8680795 8680795 20251203012041_LjenE UK004F 2025-12-04T14:12:56.482Z 2025-12-05T14:21:01.268Z
8680485 8680485 20251203001619_iwjQ1 UK004F 2025-12-04T14:12:07.509Z 2025-12-05T14:20:40.415Z
8662746 8662746 20251130192619_zW7sa UK004F 2025-12-02T14:16:28.082Z 2025-12-05T14:33:46.353Z
8657941 8657941 20251130062133_CaprW UK004F 2025-12-01T14:34:47.224Z 2025-12-05T14:45:59.160Z
8657716 8657716 20251130060208_BG34k UK004F 2025-12-01T14:34:38.953Z 2025-12-05T14:45:36.000Z
8657637 8657637 20251130055554_4bhZm UK004F 2025-12-01T14:34:35.594Z 2025-12-05T14:45:34.442Z
8657616 8657616 20251130055451_vKoID UK004F 2025-12-01T14:34:35.152Z 2025-12-05T14:45:34.192Z
8657607 8657607 20251130055403_eR3QM UK004F 2025-12-01T14:34:34.777Z 2025-12-05T14:45:34.145Z
8657559 8657559 20251130055157_fnNnI UK004F 2025-12-01T14:34:33.166Z 2025-12-05T14:45:33.298Z
8657548 8657548 20251130055156_NnVDT UK004F 2025-12-01T14:34:32.885Z 2025-12-05T14:45:33.202Z
8657293 8657293 20251130053809_BPSQW UK004F 2025-12-01T14:34:03.327Z 2025-12-05T14:45:27.942Z
8657021 8657021 20251130052410_sFxKD UK004F 2025-12-01T14:33:51.918Z 2025-12-05T14:45:24.642Z
8656811 8656811 20251130051049_Vjlpj UK004F 2025-12-01T14:29:02.019Z 2025-12-05T14:45:21.744Z
8656756 8656756 20251130050821_qV42l UK004F 2025-12-01T14:28:59.387Z 2025-12-05T14:45:20.594Z
8656567 8656567 20251130050007_teo9z UK004F 2025-12-01T14:28:45.662Z 2025-12-05T14:45:18.041Z
8656453 8656453 20251130045632_iB93j UK004F 2025-12-01T14:28:39.579Z 2025-12-05T14:45:16.334Z
8656443 8656443 20251130045626_ij6t5 UK004F 2025-12-01T14:28:39.178Z 2025-12-05T14:45:16.238Z
8656180 8656180 20251130044207_j4SJu UK004F 2025-12-01T14:28:09.095Z 2025-12-05T14:44:47.526Z
8656173 8656173 20251130044206_mWGMD UK004F 2025-12-01T14:28:08.802Z 2025-12-05T14:44:47.455Z
8656124 8656124 20251130043901_z3H7Z UK004F 2025-12-01T14:28:05.325Z 2025-12-05T14:44:46.381Z
8656024 8656024 20251130043114_r5VOe UK004F 2025-12-01T14:27:57.263Z 2025-12-05T14:44:44.471Z
8655944 8655944 20251130042717_1byaU UK004F 2025-12-01T14:27:41.855Z 2025-12-05T14:44:41.368Z
8655485 8655485 20251130040409_L7XH8 UK004F 2025-12-01T14:26:59.617Z 2025-12-05T14:44:34.371Z
8655408 8655408 20251130040130_cvDx4 UK004F 2025-12-01T14:26:53.236Z 2025-12-05T14:44:33.310Z
8655319 8655319 20251130035443_QuHlb UK004F 2025-12-01T14:26:45.958Z 2025-12-05T14:44:31.883Z
8655204 8655204 20251130034837_qmmvx UK004F 2025-12-01T14:26:38.671Z 2025-12-05T14:44:29.771Z
8655097 8655097 20251130034435_gH3bn UK004F 2025-12-01T14:26:23.085Z 2025-12-05T14:44:27.845Z
8654994 8654994 20251130034036_yj4AN UK004F 2025-12-01T14:26:14.785Z 2025-12-05T14:44:26.674Z
8654721 8654721 20251130032833_Wdx0O UK004F 2025-12-01T14:25:47.356Z 2025-12-05T14:44:22.140Z
8654366 8654366 20251130031218_wSRxo UK004F 2025-12-01T14:25:16.338Z 2025-12-05T14:43:54.287Z
8654296 8654296 20251130030848_7djzt UK004F 2025-12-01T14:25:06.708Z 2025-12-05T14:43:52.880Z
8651332 8651332 20251129232903_s9w8Y UK004F 2025-12-01T14:18:47.360Z 2025-12-05T14:41:55.437Z
8650944 8650944 20251129221016_SYMrh UK004F 2025-12-01T14:17:35.745Z 2025-12-05T14:41:23.265Z
8650935 8650935 20251129220836_zhUy3 UK004F 2025-12-01T14:17:34.637Z 2025-12-05T14:41:23.105Z
8649935 8649935 20251129185408_gj3wn UK004F 2025-12-01T14:14:30.081Z 2025-12-05T14:40:32.640Z
8649795 8649795 20251129182708_OSvmd UK004F 2025-12-01T14:13:58.194Z 2025-12-05T14:40:20.268Z
8635012 8635012 20251128013342_4R0OK UK004F 2025-11-29T14:22:22.392Z 2025-12-05T14:58:27.622Z
8625552 8625552 20251126025508_dTSqd UK004F 2025-11-28T14:34:48.899Z 2025-12-04T15:09:35.803Z
8616736 8616736 20251126062301_mV8P4 UK004F 2025-11-27T14:31:47.075Z 2025-12-04T15:11:42.659Z
8616271 8616271 20251126054842_thJZa UK004F 2025-11-27T14:31:00.423Z 2025-12-04T15:11:37.360Z
8616161 8616161 20251126054406_N3wKI UK004F 2025-11-27T14:30:39.076Z 2025-12-04T15:11:36.499Z
8616037 8616037 20251126053349_Yax8B UK004F 2025-11-27T14:30:23.012Z 2025-12-04T15:11:34.811Z
8615964 8615964 20251126053038_lvtbg UK004F 2025-11-27T14:30:19.166Z 2025-12-04T15:11:34.105Z
8615913 8615913 20251126052839_QruDa UK004F 2025-11-27T14:30:17.078Z 2025-12-04T15:11:33.742Z
8615836 8615836 20251126052205_b4si9 UK004F 2025-11-27T14:30:13.009Z 2025-12-04T15:11:32.838Z
8615774 8615774 20251126051904_2co2n UK004F 2025-11-27T14:30:10.198Z 2025-12-04T15:11:32.279Z
8615610 8615610 20251126051137_sSgUe UK004F 2025-11-27T14:30:01.462Z 2025-12-04T15:11:30.835Z
8615459 8615459 20251126050353_lqYbk UK004F 2025-11-27T14:29:33.221Z 2025-12-04T15:11:29.090Z
8615427 8615427 20251126050300_a3hMK UK004F 2025-11-27T14:29:31.824Z 2025-12-04T15:11:28.766Z
8615141 8615141 20251126044636_xLQx6 UK004F 2025-11-27T14:29:16.408Z 2025-12-04T15:11:26.247Z
8615043 8615043 20251126044224_BQ80O UK004F 2025-11-27T14:28:55.421Z 2025-12-04T15:11:25.607Z
8614924 8614924 20251126043653_P5hyR UK004F 2025-11-27T14:28:43.021Z 2025-12-04T15:11:21.850Z
8614712 8614712 20251126042452_2Gb7Y UK004F 2025-11-27T14:28:29.325Z 2025-12-04T15:11:00.378Z
8614252 8614252 20251126040031_Egc4o UK004F 2025-11-27T14:27:42.191Z 2025-12-04T15:10:33.463Z
8613411 8613411 20251126031638_WxpHb UK004F 2025-11-27T14:25:48.696Z 2025-12-04T15:09:40.277Z
8613034 8613034 20251126025942_UG8xa UK004F 2025-11-27T14:25:19.502Z 2025-12-04T15:09:36.611Z
8612915 8612915 20251126025507_81YRR UK004F 2025-11-27T14:24:59.416Z 2025-12-04T15:09:35.751Z
8612778 8612778 20251126024535_3Zp35 UK004F 2025-11-27T14:24:38.537Z 2025-12-04T15:09:33.976Z
8612309 8612309 20251126022552_3RFrA UK004F 2025-11-27T14:23:46.147Z 2025-12-04T15:09:29.433Z
8612108 8612108 20251126021901_cWnUP UK004F 2025-11-27T14:23:31.521Z 2025-12-04T15:09:27.767Z
8611978 8611978 20251126021236_2967d UK004F 2025-11-27T14:23:10.988Z 2025-12-04T15:09:26.471Z
8611684 8611684 20251126015610_e9j3d UK004F 2025-11-27T14:22:30.276Z 2025-12-04T15:09:23.431Z
8611340 8611340 20251126013747_Z28mP UK004F 2025-11-27T14:21:53.030Z 2025-12-04T15:09:10.441Z
8610575 8610575 20251126005745_VAlCe UK004F 2025-11-27T14:20:24.774Z 2025-12-04T15:08:14.739Z
8610375 8610375 20251126004011_SgaDP UK004F 2025-11-27T14:20:01.488Z 2025-12-04T15:08:04.762Z
8609862 8609862 20251126001103_vmTiI UK004F 2025-11-27T14:19:03.062Z 2025-12-04T15:07:57.798Z
8609750 8609750 20251126000323_2lg2m UK004F 2025-11-27T14:18:55.054Z 2025-12-04T15:07:57.115Z
8609665 8609665 20251125235903_Ge2yX UK004F 2025-11-27T14:18:48.600Z 2025-12-04T15:07:56.602Z
8609414 8609414 20251125233910_5HV25 UK004F 2025-11-27T14:18:09.980Z 2025-12-04T15:07:54.045Z
8609140 8609140 20251125231515_dk6U1 UK004F 2025-11-27T14:17:36.464Z 2025-12-04T15:07:51.896Z
8608685 8608685 20251125223544_w2pAC UK004F 2025-11-27T14:16:32.493Z 2025-12-04T15:07:47.750Z
8608449 8608449 20251125221741_RQiS2 UK004F 2025-11-27T14:16:07.259Z 2025-12-04T15:07:45.084Z
8608198 8608198 20251125220143_M2Dy4 UK004F 2025-11-27T14:15:33.779Z 2025-12-04T15:07:42.697Z
8608085 8608085 20251125214819_9GJhm UK004F 2025-11-27T14:15:16.963Z 2025-12-04T15:07:41.094Z
8608078 8608078 20251125214750_qMxg7 UK004F 2025-11-27T14:15:12.661Z 2025-12-04T15:07:40.926Z
8607712 8607712 20251125211455_lEMY2 UK004F 2025-11-27T14:14:23.814Z 2025-12-04T15:07:23.056Z

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