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

7,644 rows where station_code = "UK0079" 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
8691499 8691499 20251205060843_HVSoU UK0079 2025-12-06T14:17:56.008Z 2025-12-06T14:18:01.129Z
8689885 8689885 20251204175301_ARHl7 UK0079 2025-12-06T14:12:27.602Z 2025-12-06T14:18:00.748Z
8689874 8689874 20251204173321_EW8C3 UK0079 2025-12-06T14:12:24.094Z 2025-12-06T14:18:00.742Z
8667347 8667347 20251130001313_ESKcQ UK0079 2025-12-02T14:37:23.246Z 2025-12-06T14:46:51.166Z
8657933 8657933 20251130062016_MvnE2 UK0079 2025-12-01T14:34:47.033Z 2025-12-06T14:50:24.524Z
8657916 8657916 20251130061815_hXHA9 UK0079 2025-12-01T14:34:45.915Z 2025-12-06T14:50:24.093Z
8657793 8657793 20251130060842_NGTym UK0079 2025-12-01T14:34:41.596Z 2025-12-06T14:50:22.679Z
8657768 8657768 20251130060745_eoEid UK0079 2025-12-01T14:34:40.557Z 2025-12-06T14:50:22.394Z
8657639 8657639 20251130055554_4bhZm UK0079 2025-12-01T14:34:35.594Z 2025-12-06T14:50:16.309Z
8657475 8657475 20251130054822_Gct7u UK0079 2025-12-01T14:34:29.976Z 2025-12-06T14:50:03.773Z
8657350 8657350 20251130054025_IxrY5 UK0079 2025-12-01T14:34:09.420Z 2025-12-06T14:49:54.548Z
8657295 8657295 20251130053809_BPSQW UK0079 2025-12-01T14:34:03.327Z 2025-12-06T14:49:51.197Z
8657048 8657048 20251130052620_TvXo6 UK0079 2025-12-01T14:33:52.497Z 2025-12-06T14:49:44.181Z
8656802 8656802 20251130051007_3Kp8i UK0079 2025-12-01T14:29:01.177Z 2025-12-06T14:49:41.495Z
8656758 8656758 20251130050821_qV42l UK0079 2025-12-01T14:28:59.387Z 2025-12-06T14:49:39.691Z
8656445 8656445 20251130045626_ij6t5 UK0079 2025-12-01T14:28:39.178Z 2025-12-06T14:49:34.883Z
8656126 8656126 20251130043901_z3H7Z UK0079 2025-12-01T14:28:05.325Z 2025-12-06T14:49:31.254Z
8655946 8655946 20251130042717_1byaU UK0079 2025-12-01T14:27:41.855Z 2025-12-06T14:49:29.234Z
8655792 8655792 20251130041831_nzoIe UK0079 2025-12-01T14:27:29.699Z 2025-12-06T14:49:27.957Z
8653175 8653175 20251130020125_l3mxT UK0079 2025-12-01T14:23:02.223Z 2025-12-06T14:47:51.131Z
8653049 8653049 20251130015318_aE23X UK0079 2025-12-01T14:22:42.207Z 2025-12-06T14:47:48.771Z
8653042 8653042 20251130015220_3w6II UK0079 2025-12-01T14:22:41.480Z 2025-12-06T14:47:48.604Z
8651918 8651918 20251130003440_GR06h UK0079 2025-12-01T14:20:16.219Z 2025-12-06T14:46:56.230Z
8651850 8651850 20251130002509_FHH3E UK0079 2025-12-01T14:20:07.682Z 2025-12-06T14:46:54.959Z
8651811 8651811 20251130002131_yShvx UK0079 2025-12-01T14:19:58.502Z 2025-12-06T14:46:54.358Z
8651709 8651709 20251130001333_Mq62O UK0079 2025-12-01T14:19:44.326Z 2025-12-06T14:46:51.271Z
8651701 8651701 20251130001313_w4yXd UK0079 2025-12-01T14:19:43.450Z 2025-12-01T14:35:21.742Z
8651639 8651639 20251130000745_cp9Iw UK0079 2025-12-01T14:19:36.783Z 2025-12-06T14:46:49.872Z
8651364 8651364 20251129233230_nZM7j UK0079 2025-12-01T14:18:53.336Z 2025-12-06T14:46:44.745Z
8651352 8651352 20251129233138_yrUr8 UK0079 2025-12-01T14:18:51.128Z 2025-12-06T14:46:44.406Z
8651318 8651318 20251129232620_e1c3T UK0079 2025-12-01T14:18:44.834Z 2025-12-06T14:46:43.812Z
8651149 8651149 20251129225121_SY4Bb UK0079 2025-12-01T14:18:08.182Z 2025-12-06T14:46:40.750Z
8650946 8650946 20251129221016_SYMrh UK0079 2025-12-01T14:17:35.745Z 2025-12-06T14:46:36.265Z
8635974 8635974 20251128030343_SN6ti UK0079 2025-11-29T14:24:43.051Z 2025-12-06T15:02:54.732Z
8635970 8635970 20251128030335_Pnw8p UK0079 2025-11-29T14:24:42.826Z 2025-12-06T15:02:54.692Z
8635306 8635306 20251128020310_or51v UK0079 2025-11-29T14:23:02.674Z 2025-12-06T15:02:43.273Z
8616790 8616790 20251126062706_8AhLV UK0079 2025-11-27T14:31:49.476Z 2025-12-04T15:11:43.303Z
8616743 8616743 20251126062301_Gua2G UK0079 2025-11-27T14:31:47.219Z 2025-12-04T15:11:42.671Z
8616697 8616697 20251126061648_5Ytq3 UK0079 2025-11-27T14:31:31.055Z 2025-12-04T15:11:41.962Z
8616513 8616513 20251126060414_xFuhx UK0079 2025-11-27T14:31:15.219Z 2025-12-04T15:11:40.426Z
8616358 8616358 20251126055247_aBG2b UK0079 2025-11-27T14:31:06.025Z 2025-12-04T15:11:38.250Z
8616173 8616173 20251126054407_UjJFF UK0079 2025-11-27T14:30:40.776Z 2025-12-04T15:11:36.527Z
8615843 8615843 20251126052206_VIU6r UK0079 2025-11-27T14:30:13.546Z 2025-12-04T15:11:32.887Z
8615780 8615780 20251126051904_VjE3p UK0079 2025-11-27T14:30:10.451Z 2025-12-04T15:11:32.304Z
8615621 8615621 20251126051137_5Fjfk UK0079 2025-11-27T14:30:02.920Z 2025-12-04T15:11:30.859Z
8615469 8615469 20251126050413_g75Dh UK0079 2025-11-27T14:29:33.905Z 2025-12-04T15:11:29.193Z
8615464 8615464 20251126050353_En32c UK0079 2025-11-27T14:29:33.448Z 2025-12-04T15:11:29.119Z
8615237 8615237 20251126045201_p8G0c UK0079 2025-11-27T14:29:22.213Z 2025-12-04T15:11:26.990Z
8615149 8615149 20251126044636_wb29J UK0079 2025-11-27T14:29:16.657Z 2025-12-04T15:11:26.285Z
8615039 8615039 20251126044224_80rMb UK0079 2025-11-27T14:28:55.173Z 2025-12-04T15:11:25.564Z
8614931 8614931 20251126043653_U24Jy UK0079 2025-11-27T14:28:43.410Z 2025-12-04T15:11:21.986Z
8614321 8614321 20251126040338_z5PhB UK0079 2025-11-27T14:27:46.157Z 2025-12-04T15:10:35.341Z
8613674 8613674 20251126032815_tdRJb UK0079 2025-11-27T14:26:22.448Z 2025-12-04T15:09:50.440Z
8613613 8613613 20251126032603_qf1R3 UK0079 2025-11-27T14:26:17.749Z 2025-12-04T15:09:49.826Z
8613572 8613572 20251126032418_3UOwc UK0079 2025-11-27T14:26:14.950Z 2025-12-04T15:09:49.351Z
8613565 8613565 20251126032400_ZzQoS UK0079 2025-11-27T14:26:14.180Z 2025-12-04T15:09:49.260Z
8612304 8612304 20251126022552_PEg2R UK0079 2025-11-27T14:23:45.796Z 2025-12-04T15:09:29.403Z
8612101 8612101 20251126021901_m7ycn UK0079 2025-11-27T14:23:31.257Z 2025-12-04T15:09:27.693Z
8611691 8611691 20251126015611_7uN9z UK0079 2025-11-27T14:22:30.767Z 2025-12-04T15:09:23.452Z
8611531 8611531 20251126015027_a8hmY UK0079 2025-11-27T14:22:17.060Z 2025-12-04T15:09:22.202Z
8611323 8611323 20251126013702_kQgws UK0079 2025-11-27T14:21:51.468Z 2025-12-04T15:09:09.948Z
8611273 8611273 20251126013558_117MJ UK0079 2025-11-27T14:21:47.981Z 2025-12-04T15:09:07.213Z
8610583 8610583 20251126005745_hd64q UK0079 2025-11-27T14:20:24.936Z 2025-12-04T15:08:14.858Z
8610366 8610366 20251126004011_NwTEa UK0079 2025-11-27T14:20:01.104Z 2025-12-04T15:08:04.734Z
8610164 8610164 20251126002716_9iskr UK0079 2025-11-27T14:19:32.162Z 2025-12-04T15:08:03.007Z
8609473 8609473 20251125234423_fICjG UK0079 2025-11-27T14:18:14.742Z 2025-12-04T15:07:54.667Z
8609240 8609240 20251125232527_hBkYj UK0079 2025-11-27T14:17:49.022Z 2025-12-04T15:07:52.856Z
8608697 8608697 20251125223545_MXcgl UK0079 2025-11-27T14:16:32.885Z 2025-12-04T15:07:47.786Z
8608567 8608567 20251125222803_kUgiA UK0079 2025-11-27T14:16:18.207Z 2025-12-04T15:07:46.439Z
8608177 8608177 20251125215742_Fh1TR UK0079 2025-11-27T14:15:31.682Z 2025-12-04T15:07:42.392Z
8607671 8607671 20251125211112_kcN1b UK0079 2025-11-27T14:14:10.866Z 2025-12-04T15:07:12.141Z
8607195 8607195 20251125202741_QQWUK UK0079 2025-11-27T14:12:44.787Z 2025-12-04T15:06:56.390Z
8607015 8607015 20251125200351_qmtXJ UK0079 2025-11-27T14:12:01.152Z 2025-12-04T15:06:53.683Z
8606222 8606222 20251125182349_o8f9s UK0079 2025-11-27T14:09:36.807Z 2025-12-04T15:06:42.646Z
8605887 8605887 20251125172811_cQTWk UK0079 2025-11-27T14:08:12.127Z 2025-12-04T15:05:48.134Z
8604443 8604443 20251124024325_eUcMV UK0079 2025-11-26T14:35:59.477Z 2025-12-02T15:12:47.760Z
8603464 8603464 20251125061031_ihZvP UK0079 2025-11-26T14:27:27.835Z 2025-12-02T15:09:35.962Z
8603272 8603272 20251125055410_IS0lT UK0079 2025-11-26T14:27:18.725Z 2025-12-02T15:09:35.157Z
8602927 8602927 20251125053250_zal5U UK0079 2025-11-26T14:26:28.097Z 2025-12-02T15:09:33.536Z
8602877 8602877 20251125052932_278A9 UK0079 2025-11-26T14:26:25.826Z 2025-12-02T15:09:33.336Z
8602487 8602487 20251125045902_HZeM8 UK0079 2025-11-26T14:26:03.738Z 2025-12-02T15:09:31.180Z
8602460 8602460 20251125045758_1FmnS UK0079 2025-11-26T14:26:01.782Z 2025-12-02T15:09:31.079Z
8602058 8602058 20251125043433_q0qel UK0079 2025-11-26T14:25:18.982Z 2025-12-02T15:09:29.299Z
8601884 8601884 20251125042223_kDIGR UK0079 2025-11-26T14:24:53.735Z 2025-12-02T15:09:26.134Z
8601830 8601830 20251125041937_AaR5m UK0079 2025-11-26T14:24:47.782Z 2025-12-02T15:09:25.886Z
8601802 8601802 20251125041751_fc5Ik UK0079 2025-11-26T14:24:45.168Z 2025-12-02T15:09:24.958Z
8601324 8601324 20251125034414_UFLhA UK0079 2025-11-26T14:23:54.655Z 2025-12-02T15:09:07.721Z
8600815 8600815 20251125031810_zIT7J UK0079 2025-11-26T14:22:59.407Z 2025-12-02T15:08:50.761Z
8600574 8600574 20251125030751_sSixf UK0079 2025-11-26T14:22:48.343Z 2025-12-02T15:08:47.009Z
8599742 8599742 20251125022240_gEUeB UK0079 2025-11-26T14:21:27.393Z 2025-12-02T15:08:31.826Z
8599313 8599313 20251125015759_gAR2x UK0079 2025-11-26T14:20:46.585Z 2025-12-02T15:08:22.226Z
8598995 8598995 20251125014104_VA4dS UK0079 2025-11-26T14:20:10.451Z 2025-12-02T15:08:15.751Z
8597927 8597927 20251125001914_gem7J UK0079 2025-11-26T14:17:53.643Z 2025-12-02T15:07:43.478Z
8597650 8597650 20251124235756_pM4fc UK0079 2025-11-26T14:17:17.097Z 2025-12-02T15:07:39.102Z
8597212 8597212 20251124231419_4Pvvg UK0079 2025-11-26T14:16:22.492Z 2025-12-02T15:07:24.337Z
8597109 8597109 20251124225739_SZd63 UK0079 2025-11-26T14:16:00.704Z 2025-12-02T15:07:23.115Z
8596481 8596481 20251124211253_334RN UK0079 2025-11-26T14:14:37.232Z 2025-12-02T15:06:55.551Z
8595796 8595796 20251124182941_p6qoy UK0079 2025-11-26T14:12:30.770Z 2025-12-02T15:06:11.381Z
8595684 8595684 20251124175737_zJ1zY UK0079 2025-11-26T14:12:12.048Z 2025-12-02T15:06:05.603Z
8592216 8592216 20251124060818_ZkTC2 UK0079 2025-11-25T14:26:03.928Z 2025-12-02T15:13:02.409Z

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