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,706 rows where station_code = "UK00AP" 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
9125654 9125654 20251231182800_u3q9b UK00AP 2026-01-02T14:55:44.086Z 2026-01-08T15:15:51.259Z
9120857 9120857 20251231195006_SMm21 UK00AP 2026-01-02T14:04:35.401Z 2026-01-09T14:51:26.480Z
9115706 9115706 20251231052353_xCism UK00AP 2026-01-01T14:26:12.927Z 2026-01-08T15:11:08.787Z
9098707 9098707 20251227195716_e4s6c UK00AP 2025-12-30T15:10:47.060Z 2026-01-04T15:35:24.107Z
9098468 9098468 20251227190920_NdQjc UK00AP 2025-12-30T15:10:31.178Z 2026-01-04T15:35:04.356Z
9098354 9098354 20251227185259_R65HJ UK00AP 2025-12-30T15:10:21.897Z 2026-01-04T15:34:57.507Z
9093202 9093202 20251227044627_Ywy2f UK00AP 2025-12-30T15:02:22.676Z 2026-01-04T15:29:21.929Z
9085750 9085750 20251228035901_y3B8i UK00AP 2025-12-30T14:39:20.072Z 2026-01-05T15:09:44.245Z
9084423 9084423 20251228014035_62S0E UK00AP 2025-12-30T14:35:39.320Z 2025-12-31T14:50:17.207Z
9084219 9084219 20251228012110_Ryh1X UK00AP 2025-12-30T14:35:03.518Z 2026-01-05T15:08:35.792Z
9083830 9083830 20251228004111_oHQDx UK00AP 2025-12-30T14:33:57.199Z 2026-01-05T15:08:12.147Z
9083292 9083292 20251227233309_zMOzi UK00AP 2025-12-30T14:32:17.197Z 2026-01-05T15:07:43.710Z
9083281 9083281 20251227233012_5nlAx UK00AP 2025-12-30T14:32:15.021Z 2026-01-05T15:07:43.217Z
9083106 9083106 20251227225614_53Ql8 UK00AP 2025-12-30T14:31:36.312Z 2026-01-05T15:07:37.445Z
9082561 9082561 20251227210259_GDsGj UK00AP 2025-12-30T14:29:49.253Z 2026-01-05T15:07:10.630Z
9059932 9059932 20251225230943_a58r1 UK00AP 2025-12-29T14:28:26.440Z 2026-01-03T15:32:27.514Z
9058355 9058355 20251227054547_SvUCJ UK00AP 2025-12-29T14:24:35.815Z 2026-01-04T15:30:20.179Z
9057092 9057092 20251227044627_yFeQK UK00AP 2025-12-29T14:22:13.892Z 2025-12-29T14:51:09.092Z
9057005 9057005 20251227044222_ckJ4H UK00AP 2025-12-29T14:22:04.157Z 2026-01-04T15:29:19.066Z
9056859 9056859 20251227043710_gDtcI UK00AP 2025-12-29T14:21:42.299Z 2026-01-04T15:29:14.761Z
9056744 9056744 20251227043016_qK4Jv UK00AP 2025-12-29T14:21:28.849Z 2026-01-04T15:29:10.170Z
9056632 9056632 20251227042628_yEt3l UK00AP 2025-12-29T14:21:13.692Z 2026-01-04T15:29:07.614Z
9056317 9056317 20251227040918_pg1aK UK00AP 2025-12-29T14:20:29.803Z 2026-01-04T15:28:48.361Z
9051981 9051981 20251227002423_2l9ZT UK00AP 2025-12-29T14:08:36.389Z 2026-01-04T15:25:07.034Z
9051135 9051135 20251226232407_fdYjG UK00AP 2025-12-29T14:05:47.983Z 2026-01-04T15:24:17.635Z
9050658 9050658 20251226224435_5Zabz UK00AP 2025-12-29T14:04:05.218Z 2026-01-04T15:23:49.732Z
9050655 9050655 20251226224424_b38qm UK00AP 2025-12-29T14:04:04.276Z 2026-01-04T15:23:49.574Z
9043807 9043807 20251224212418_0y6Cq UK00AP 2025-12-28T14:48:08.510Z 2026-01-01T15:57:23.235Z
9042664 9042664 20251224184359_yUehF UK00AP 2025-12-28T14:46:04.617Z 2026-01-01T15:57:08.349Z
9042334 9042334 20251224175245_296xd UK00AP 2025-12-28T14:45:23.891Z 2026-01-01T15:56:38.745Z
9025858 9025858 20251225003359_1SRrd UK00AP 2025-12-28T14:06:02.941Z 2026-01-02T15:42:44.536Z
9025517 9025517 20251225000545_db2kC UK00AP 2025-12-28T14:04:50.479Z 2026-01-02T15:42:20.580Z
9025276 9025276 20251224234855_wfjAl UK00AP 2025-12-28T14:04:03.575Z 2026-01-02T15:42:14.301Z
9017245 9017245 20251220050453_BdVx9 UK00AP 2025-12-27T15:01:14.303Z 2025-12-29T15:23:29.600Z
8997833 8997833 20251222045438_80XuB UK00AP 2025-12-27T14:11:27.656Z 2025-12-30T15:46:40.741Z
8997675 8997675 20251222044041_aNQWL UK00AP 2025-12-27T14:10:49.442Z 2025-12-30T15:46:39.317Z
8997662 8997662 20251222044013_2vNe3 UK00AP 2025-12-27T14:10:39.838Z 2025-12-30T15:46:39.144Z
8997648 8997648 20251222043926_4tO5E UK00AP 2025-12-27T14:10:38.285Z 2025-12-30T15:46:39.048Z
8997476 8997476 20251222042158_EvMQr UK00AP 2025-12-27T14:09:54.692Z 2025-12-28T14:58:29.315Z
8997445 8997445 20251222041824_0ElVm UK00AP 2025-12-27T14:09:46.764Z 2025-12-30T15:46:36.597Z
8994402 8994402 20251217024020_WUQ5L UK00AP 2025-12-26T14:55:30.738Z 2025-12-26T14:55:30.738Z
8994386 8994386 20251217015954_tIk3N UK00AP 2025-12-26T14:55:00.036Z 2025-12-26T14:55:00.036Z
8994354 8994354 20251217014231_yhqdh UK00AP 2025-12-26T14:54:36.611Z 2025-12-26T14:54:36.611Z
8985071 8985071 20251220002204_ZW07D UK00AP 2025-12-26T14:31:45.325Z 2025-12-28T15:23:58.427Z
8985054 8985054 20251220002038_j47g3 UK00AP 2025-12-26T14:31:44.866Z 2025-12-28T15:23:58.249Z
8984233 8984233 20251219231453_KGEkF UK00AP 2025-12-26T14:30:30.801Z 2025-12-28T15:23:49.158Z
8984078 8984078 20251219225944_9NUBC UK00AP 2025-12-26T14:30:16.027Z 2025-12-28T15:23:47.607Z
8983986 8983986 20251219224722_rlDKP UK00AP 2025-12-26T14:30:04.662Z 2025-12-28T15:23:46.191Z
8982983 8982983 20251219205916_hvXEf UK00AP 2025-12-26T14:28:13.730Z 2025-12-28T15:22:49.283Z
8982948 8982948 20251219205629_32DYS UK00AP 2025-12-26T14:28:10.958Z 2025-12-28T15:22:44.148Z
8982721 8982721 20251219202210_VBA9X UK00AP 2025-12-26T14:27:36.745Z 2025-12-28T15:22:15.098Z
8981482 8981482 20251219174001_QU300 UK00AP 2025-12-26T14:24:50.583Z 2025-12-27T15:16:23.395Z
8981478 8981478 20251219174001_2QLkn UK00AP 2025-12-26T14:24:50.217Z 2025-12-27T15:16:22.912Z
8974716 8974716 20251220024416_luBRm UK00AP 2025-12-26T14:05:04.850Z 2025-12-29T15:22:43.840Z
8974576 8974576 20251220023257_XLX9u UK00AP 2025-12-26T14:04:42.957Z 2025-12-29T15:22:42.894Z
8974449 8974449 20251220022353_uF8hY UK00AP 2025-12-26T14:04:28.864Z 2025-12-29T15:22:42.042Z
8974423 8974423 20251220022309_FOclW UK00AP 2025-12-26T14:04:26.876Z 2025-12-29T15:22:41.881Z
8974361 8974361 20251220022048_JqHuz UK00AP 2025-12-26T14:04:19.938Z 2025-12-29T15:22:41.493Z
8974193 8974193 20251220020853_r4PdY UK00AP 2025-12-26T14:03:55.205Z 2025-12-29T15:22:39.352Z
8974144 8974144 20251220020717_OLtMA UK00AP 2025-12-26T14:03:52.612Z 2025-12-29T15:22:39.173Z
8973660 8973660 20251220012747_H41VW UK00AP 2025-12-26T14:02:44.384Z 2025-12-29T15:22:35.549Z
8973141 8973141 20251220005820_ZsD3Z UK00AP 2025-12-26T14:01:25.443Z 2025-12-29T15:22:32.369Z
8972823 8972823 20251220003652_NSYsn UK00AP 2025-12-26T14:00:34.761Z 2025-12-29T15:22:29.844Z
8972703 8972703 20251220002745_p1EDQ UK00AP 2025-12-26T14:00:17.376Z 2025-12-29T15:22:29.055Z
8972254 8972254 20251217010819_GXiCj UK00AP 2025-12-25T14:54:49.441Z 2025-12-25T14:54:49.441Z
8972003 8972003 20251217004717_JfSPk UK00AP 2025-12-25T14:54:39.873Z 2025-12-25T14:54:39.873Z
8971955 8971955 20251217004611_m4Hnp UK00AP 2025-12-25T14:54:38.942Z 2025-12-25T14:54:38.942Z
8971774 8971774 20251217003634_TKPS7 UK00AP 2025-12-25T14:54:34.293Z 2025-12-25T14:54:34.293Z
8971685 8971685 20251217002728_Ilqs8 UK00AP 2025-12-25T14:54:08.023Z 2025-12-25T14:54:08.023Z
8971628 8971628 20251217002449_7MWRa UK00AP 2025-12-25T14:54:02.592Z 2025-12-25T14:54:02.592Z
8971616 8971616 20251217002440_ikne8 UK00AP 2025-12-25T14:54:02.199Z 2025-12-25T14:54:02.199Z
8970802 8970802 20251216231554_EsEx7 UK00AP 2025-12-25T14:53:23.017Z 2025-12-25T14:53:23.017Z
8970634 8970634 20251216225919_rKXxR UK00AP 2025-12-25T14:52:52.222Z 2025-12-25T14:52:52.222Z
8969886 8969886 20251216211358_xPYMq UK00AP 2025-12-25T14:51:51.533Z 2025-12-25T14:51:51.533Z
8969670 8969670 20251216203104_xezXh UK00AP 2025-12-25T14:51:28.799Z 2025-12-25T14:51:28.799Z
8969626 8969626 20251216202530_N93RL UK00AP 2025-12-25T14:51:14.078Z 2025-12-25T14:51:14.078Z
8953769 8953769 20251217044737_S2Fd8 UK00AP 2025-12-25T14:07:43.744Z 2025-12-26T14:57:33.072Z
8953598 8953598 20251217042139_3q289 UK00AP 2025-12-25T14:06:59.739Z 2025-12-25T14:55:18.725Z
8953588 8953588 20251217042049_i47m8 UK00AP 2025-12-25T14:06:56.351Z 2025-12-26T14:57:06.187Z
8953574 8953574 20251217041749_11OzB UK00AP 2025-12-25T14:06:48.356Z 2025-12-26T14:57:05.027Z
8953040 8953040 20251217025605_jZOF6 UK00AP 2025-12-25T14:03:52.344Z 2025-12-26T14:55:48.982Z
8952966 8952966 20251217024620_Dujk1 UK00AP 2025-12-25T14:03:27.531Z 2025-12-26T14:55:35.373Z
8952902 8952902 20251217024020_mLcq5 UK00AP 2025-12-25T14:03:12.407Z 2025-12-25T14:55:17.167Z
8952661 8952661 20251217020742_pXh3X UK00AP 2025-12-25T14:01:51.701Z 2025-12-26T14:55:05.430Z
8952635 8952635 20251217020253_LPk47 UK00AP 2025-12-25T14:01:40.004Z 2025-12-26T14:55:03.188Z
8952601 8952601 20251217015954_CuQGy UK00AP 2025-12-25T14:01:27.671Z 2025-12-25T14:55:16.740Z
8952434 8952434 20251217014548_zX38s UK00AP 2025-12-25T14:00:35.172Z 2025-12-25T14:55:16.450Z
8952429 8952429 20251217014531_b3TW3 UK00AP 2025-12-25T14:00:33.292Z 2025-12-26T14:54:38.752Z
8952377 8952377 20251217014231_T8o2Q UK00AP 2025-12-25T14:00:19.922Z 2025-12-26T14:54:36.435Z
8946037 8946037 20251214212551_2sso9 UK00AP 2025-12-24T15:02:57.163Z 2025-12-24T15:02:57.163Z
8945817 8945817 20251214211716_4ZvLZ UK00AP 2025-12-24T15:02:51.303Z 2025-12-24T15:02:51.303Z
8944854 8944854 20251214204151_nlXIa UK00AP 2025-12-24T15:02:00.798Z 2025-12-24T15:02:00.798Z
8943682 8943682 20251214195956_GwpYp UK00AP 2025-12-24T15:00:00.103Z 2025-12-24T15:00:00.103Z
8943517 8943517 20251214195225_l4GLR UK00AP 2025-12-24T14:59:56.820Z 2025-12-24T14:59:56.820Z
8897910 8897910 20251214025359_KiBpn UK00AP 2025-12-22T14:12:31.011Z 2025-12-23T14:28:02.859Z
8897895 8897895 20251214025352_rgbLq UK00AP 2025-12-22T14:12:30.884Z 2025-12-23T14:28:02.823Z
8897726 8897726 20251214025145_xKsHp UK00AP 2025-12-22T14:12:27.846Z 2025-12-23T14:28:00.904Z
8897153 8897153 20251214024612_aA7el UK00AP 2025-12-22T14:12:21.109Z 2025-12-23T14:27:57.235Z
8897077 8897077 20251214024551_hHHU9 UK00AP 2025-12-22T14:12:20.948Z 2025-12-23T14:27:57.195Z
8897063 8897063 20251214024546_0dJKB UK00AP 2025-12-22T14:12:20.919Z 2025-12-23T14:27:57.189Z

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