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

5,199 rows where station_code = "UK0021" 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
8683069 8683069 20251203062422_TyjnK UK0021 2025-12-04T14:18:32.149Z 2025-12-05T14:23:07.042Z
8682571 8682571 20251203054617_ALsU3 UK0021 2025-12-04T14:17:27.724Z 2025-12-05T14:22:42.849Z
8682455 8682455 20251203053724_dzk51 UK0021 2025-12-04T14:17:14.759Z 2025-12-05T14:22:39.149Z
8682408 8682408 20251203052612_MuolV UK0021 2025-12-04T14:17:07.090Z 2025-12-05T14:22:35.873Z
8682398 8682398 20251203052444_UH943 UK0021 2025-12-04T14:17:05.632Z 2025-12-05T14:22:35.133Z
8682025 8682025 20251203044149_TO0We UK0021 2025-12-04T14:16:14.184Z 2025-12-05T14:22:12.006Z
8681710 8681710 20251203034929_eTajr UK0021 2025-12-04T14:15:19.069Z 2025-12-05T14:21:50.300Z
8680947 8680947 20251203015742_G0dTy UK0021 2025-12-04T14:13:25.825Z 2025-12-05T14:21:08.442Z
8677082 8677082 20251202064547_rebKo UK0021 2025-12-03T14:26:16.765Z 2025-12-05T14:29:20.543Z
8677064 8677064 20251202064407_icCFz UK0021 2025-12-03T14:26:15.761Z 2025-12-05T14:29:20.155Z
8676788 8676788 20251202062616_G0bKO UK0021 2025-12-03T14:25:39.363Z 2025-12-05T14:29:13.620Z
8676234 8676234 20251202054220_EZ2a5 UK0021 2025-12-03T14:24:50.182Z 2025-12-05T14:28:50.801Z
8676123 8676123 20251202053752_0cari UK0021 2025-12-03T14:24:43.979Z 2025-12-05T14:28:49.255Z
8676078 8676078 20251202053511_glTZX UK0021 2025-12-03T14:24:40.778Z 2025-12-05T14:28:48.130Z
8675897 8675897 20251202052233_PUN1M UK0021 2025-12-03T14:24:29.346Z 2025-12-05T14:28:43.718Z
8675517 8675517 20251202045244_qS45E UK0021 2025-12-03T14:23:49.221Z 2025-12-05T14:28:34.550Z
8675445 8675445 20251202044021_Ee8tH UK0021 2025-12-03T14:23:43.798Z 2025-12-05T14:28:32.258Z
8675427 8675427 20251202043834_1459X UK0021 2025-12-03T14:23:42.595Z 2025-12-05T14:28:31.963Z
8675318 8675318 20251202042822_zF1OH UK0021 2025-12-03T14:23:30.962Z 2025-12-05T14:28:19.701Z
8675267 8675267 20251202042529_Fh9Zp UK0021 2025-12-03T14:23:27.901Z 2025-12-05T14:28:18.590Z
8674951 8674951 20251202034309_80f7M UK0021 2025-12-03T14:22:45.770Z 2025-12-05T14:28:07.580Z
8674862 8674862 20251202033516_HGIc5 UK0021 2025-12-03T14:22:31.703Z 2025-12-05T14:28:05.045Z
8658428 8658428 20251125222907_rWC6A UK0021 2025-12-01T15:02:03.954Z 2025-12-04T15:07:46.564Z
8657729 8657729 20251130060405_xb680 UK0021 2025-12-01T14:34:39.371Z 2025-12-05T14:45:36.181Z
8657644 8657644 20251130055615_3kgiH UK0021 2025-12-01T14:34:35.827Z 2025-12-05T14:45:34.484Z
8656705 8656705 20251130050636_j2cB2 UK0021 2025-12-01T14:28:56.757Z 2025-12-01T14:28:56.757Z
8656701 8656701 20251130050636_M0zao UK0021 2025-12-01T14:28:56.202Z 2025-12-01T14:28:56.202Z
8656495 8656495 20251130045726_3b8p7 UK0021 2025-12-01T14:28:41.968Z 2025-12-05T14:45:16.893Z
8656387 8656387 20251130045234_OZs2r UK0021 2025-12-01T14:28:35.281Z 2025-12-05T14:45:14.648Z
8656071 8656071 20251130043513_TO49J UK0021 2025-12-01T14:28:00.961Z 2025-12-01T14:28:00.961Z
8655990 8655990 20251130042849_WDxqF UK0021 2025-12-01T14:27:44.223Z 2025-12-01T14:27:44.223Z
8655742 8655742 20251130041436_OaBgM UK0021 2025-12-01T14:27:24.821Z 2025-12-01T14:27:24.821Z
8655423 8655423 20251130040154_uXuER UK0021 2025-12-01T14:26:53.664Z 2025-12-05T14:44:33.502Z
8655148 8655148 20251130034624_vlJCt UK0021 2025-12-01T14:26:35.965Z 2025-12-05T14:44:29.199Z
8655112 8655112 20251130034454_cpouv UK0021 2025-12-01T14:26:23.731Z 2025-12-01T14:26:23.731Z
8653288 8653288 20251130020727_Lj3Ft UK0021 2025-12-01T14:23:10.257Z 2025-12-05T14:43:25.753Z
8653034 8653034 20251130015211_KpeWV UK0021 2025-12-01T14:22:41.013Z 2025-12-05T14:42:59.774Z
8652361 8652361 20251130010408_5KLjK UK0021 2025-12-01T14:21:18.301Z 2025-12-05T14:42:43.234Z
8652283 8652283 20251130010142_3pnvq UK0021 2025-12-01T14:21:06.507Z 2025-12-05T14:42:41.678Z
8634322 8634322 20251128003836_QzUu4 UK0021 2025-11-29T14:21:12.775Z 2025-12-05T14:58:19.266Z
8634158 8634158 20251128002839_2Pvgy UK0021 2025-11-29T14:20:50.453Z 2025-12-05T14:58:17.020Z
8633992 8633992 20251128001243_FSzMJ UK0021 2025-11-29T14:20:36.403Z 2025-12-05T14:58:15.193Z
8633632 8633632 20251127234145_aE0XD UK0021 2025-11-29T14:20:00.069Z 2025-12-05T14:57:51.293Z
8616613 8616613 20251126061401_Z3JNX UK0021 2025-11-27T14:31:23.044Z 2025-12-04T15:11:41.376Z
8615455 8615455 20251126050353_lqYbk UK0021 2025-11-27T14:29:33.220Z 2025-12-04T15:11:29.090Z
8615303 8615303 20251126045500_AfXAi UK0021 2025-11-27T14:29:25.674Z 2025-12-04T15:11:27.580Z
8614907 8614907 20251126043631_zpnTJ UK0021 2025-11-27T14:28:42.297Z 2025-12-04T15:11:20.740Z
8614875 8614875 20251126043343_K9M25 UK0021 2025-11-27T14:28:40.380Z 2025-12-04T15:11:17.459Z
8613819 8613819 20251126033512_cKLXT UK0021 2025-11-27T14:26:49.188Z 2025-12-04T15:09:52.118Z
8613567 8613567 20251126032403_60cvn UK0021 2025-11-27T14:26:14.627Z 2025-12-04T15:09:49.326Z
8613439 8613439 20251126031753_4nkTf UK0021 2025-11-27T14:26:05.045Z 2025-12-04T15:09:40.555Z
8613360 8613360 20251126031505_Lpqs1 UK0021 2025-11-27T14:25:44.063Z 2025-12-04T15:09:39.934Z
8612785 8612785 20251126024636_V3MzF UK0021 2025-11-27T14:24:39.223Z 2025-12-04T15:09:34.121Z
8612329 8612329 20251126022649_12yrY UK0021 2025-11-27T14:23:50.048Z 2025-12-04T15:09:29.754Z
8612026 8612026 20251126021436_qefFb UK0021 2025-11-27T14:23:15.062Z 2025-12-04T15:09:26.935Z
8611970 8611970 20251126021121_F2Jaq UK0021 2025-11-27T14:23:10.759Z 2025-12-04T15:09:26.416Z
8611882 8611882 20251126020604_zot1I UK0021 2025-11-27T14:23:01.369Z 2025-12-04T15:09:25.196Z
8611369 8611369 20251126013851_6nrYx UK0021 2025-11-27T14:22:04.729Z 2025-12-04T15:09:11.208Z
8611190 8611190 20251126013036_0z75P UK0021 2025-11-27T14:21:37.748Z 2025-12-04T15:08:56.860Z
8611154 8611154 20251126012429_3wCAP UK0021 2025-11-27T14:21:32.913Z 2025-12-04T15:08:54.686Z
8611096 8611096 20251126012212_E6YrU UK0021 2025-11-27T14:21:11.322Z 2025-12-04T15:08:51.114Z
8611053 8611053 20251126012004_uKZ7P UK0021 2025-11-27T14:21:09.595Z 2025-12-04T15:08:50.405Z
8610109 8610109 20251126002412_TNkJK UK0021 2025-11-27T14:19:27.360Z 2025-12-04T15:08:02.364Z
8608361 8608361 20251125221001_BhXqj UK0021 2025-11-27T14:15:45.731Z 2025-12-04T15:07:44.120Z
8608016 8608016 20251125214443_tKD9s UK0021 2025-11-27T14:15:06.339Z 2025-12-04T15:07:40.307Z
8607841 8607841 20251125212712_sNZQV UK0021 2025-11-27T14:14:35.829Z 2025-12-04T15:07:35.204Z
8607767 8607767 20251125211851_RGcrn UK0021 2025-11-27T14:14:27.820Z 2025-12-04T15:07:29.577Z
8607504 8607504 20251125205832_pY3HC UK0021 2025-11-27T14:13:53.299Z 2025-12-04T15:07:03.220Z
8607122 8607122 20251125201618_M6VRo UK0021 2025-11-27T14:12:29.033Z 2025-12-04T15:06:55.000Z
8603351 8603351 20251125055839_Uua2p UK0021 2025-11-26T14:27:22.434Z 2025-12-02T15:09:35.431Z
8602871 8602871 20251125052930_Ma5oL UK0021 2025-11-26T14:26:25.602Z 2025-12-02T15:09:33.322Z
8602834 8602834 20251125052440_7UN5n UK0021 2025-11-26T14:26:23.145Z 2025-12-02T15:09:33.065Z
8602018 8602018 20251125043227_yZEYK UK0021 2025-11-26T14:25:17.377Z 2025-12-02T15:09:29.155Z
8601774 8601774 20251125041521_hSVx3 UK0021 2025-11-26T14:24:41.946Z 2025-12-02T15:09:24.449Z
8601147 8601147 20251125033626_AP2cX UK0021 2025-11-26T14:23:44.630Z 2025-12-02T15:09:00.525Z
8600748 8600748 20251125031617_XVL72 UK0021 2025-11-26T14:22:56.806Z 2025-12-02T15:08:50.046Z
8600017 8600017 20251125023730_S2U3e UK0021 2025-11-26T14:21:57.854Z 2025-12-02T15:08:33.486Z
8599989 8599989 20251125023520_cuWo5 UK0021 2025-11-26T14:21:55.028Z 2025-12-02T15:08:33.334Z
8599614 8599614 20251125021231_aMFOx UK0021 2025-11-26T14:21:19.352Z 2025-12-02T15:08:30.560Z
8599310 8599310 20251125015740_ISm64 UK0021 2025-11-26T14:20:46.321Z 2025-12-02T15:08:22.206Z
8598822 8598822 20251125012901_eZTAF UK0021 2025-11-26T14:19:56.105Z 2025-12-02T15:08:09.502Z
8598773 8598773 20251125012340_obtJz UK0021 2025-11-26T14:19:50.953Z 2025-12-02T15:08:08.534Z
8598181 8598181 20251125004031_dvAtl UK0021 2025-11-26T14:18:25.225Z 2025-12-02T15:07:47.953Z
8597505 8597505 20251124233828_zoCC0 UK0021 2025-11-26T14:16:53.538Z 2025-12-02T15:07:36.289Z
8597376 8597376 20251124233030_o9o4A UK0021 2025-11-26T14:16:44.410Z 2025-12-02T15:07:31.004Z
8596539 8596539 20251124212911_H081v UK0021 2025-11-26T14:14:43.482Z 2025-12-02T15:07:02.282Z
8596534 8596534 20251124212911_IpdJ3 UK0021 2025-11-26T14:14:42.502Z 2025-12-02T15:07:02.230Z
8596342 8596342 20251124204950_UMcWl UK0021 2025-11-26T14:14:24.179Z 2025-12-02T15:06:53.584Z
8596222 8596222 20251124202624_u2749 UK0021 2025-11-26T14:14:00.686Z 2025-12-02T15:06:49.979Z
8591990 8591990 20251124053011_9fQ30 UK0021 2025-11-25T14:25:30.369Z 2025-12-02T15:13:01.357Z
8590297 8590297 20251124023314_kEEbB UK0021 2025-11-25T14:21:38.248Z 2025-12-02T15:12:46.159Z
8590085 8590085 20251124022045_0yt69 UK0021 2025-11-25T14:21:22.272Z 2025-12-02T15:12:42.235Z
8589897 8589897 20251124020333_CVdBS UK0021 2025-11-25T14:20:53.757Z 2025-12-02T15:12:39.517Z
8589141 8589141 20251124010746_VQLjy UK0021 2025-11-25T14:19:08.863Z 2025-12-02T15:12:09.708Z
8586125 8586125 20251123184922_3Wjko UK0021 2025-11-25T14:12:07.044Z 2025-12-02T15:10:44.175Z
8569232 8569232 20251121054950_dZvPr UK0021 2025-11-23T14:32:06.352Z 2025-11-29T14:54:47.940Z
8568656 8568656 20251121052900_0taYt UK0021 2025-11-23T14:31:17.989Z 2025-11-29T14:54:47.162Z
8568466 8568466 20251121052043_9MXh8 UK0021 2025-11-23T14:31:09.372Z 2025-11-29T14:54:46.830Z
8568425 8568425 20251121051831_R3jkm UK0021 2025-11-23T14:31:07.123Z 2025-11-29T14:54:46.720Z
8568243 8568243 20251121050819_cyF2Z UK0021 2025-11-23T14:31:00.136Z 2025-11-29T14:54:46.434Z

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