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 = "UK002Z" 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
8686095 8686095 20251203183345_iExE3 UK002Z 2025-12-05T14:11:02.007Z 2025-12-05T14:14:35.296Z
8686067 8686067 20251203182605_cnAPU UK002Z 2025-12-05T14:10:58.985Z 2025-12-05T14:14:35.291Z
8685942 8685942 20251203174920_YoNHk UK002Z 2025-12-05T14:10:33.639Z 2025-12-05T14:14:35.265Z
8685859 8685859 20251203171751_upQbD UK002Z 2025-12-05T14:10:18.019Z 2025-12-05T14:14:35.240Z
8680140 8680140 20251202215353_3tw93 UK002Z 2025-12-04T14:11:10.820Z 2025-12-05T14:20:19.186Z
8680129 8680129 20251202215158_cv5YE UK002Z 2025-12-04T14:11:09.520Z 2025-12-05T14:20:18.695Z
8679961 8679961 20251202211301_Pndr2 UK002Z 2025-12-04T14:10:49.384Z 2025-12-05T14:20:11.558Z
8679946 8679946 20251202211200_633E5 UK002Z 2025-12-04T14:10:47.945Z 2025-12-05T14:20:11.103Z
8678976 8678976 20251202182519_KJvI6 UK002Z 2025-12-04T14:08:42.563Z 2025-12-05T14:19:14.854Z
8678960 8678960 20251202182031_Fxtis UK002Z 2025-12-04T14:08:40.868Z 2025-12-05T14:19:12.100Z
8678881 8678881 20251202175940_qrI2h UK002Z 2025-12-04T14:08:24.633Z 2025-12-05T14:19:06.853Z
8678768 8678768 20251202172022_lFufo UK002Z 2025-12-04T14:08:07.991Z 2025-12-05T14:18:58.847Z
8678720 8678720 20251202170724_vjKGx UK002Z 2025-12-04T14:07:58.243Z 2025-12-05T14:18:49.128Z
8676913 8676913 20251202063105_e249x UK002Z 2025-12-03T14:25:56.183Z 2025-12-05T14:29:16.160Z
8676799 8676799 20251202062646_6ELPl UK002Z 2025-12-03T14:25:47.323Z 2025-12-05T14:29:14.159Z
8676699 8676699 20251202061449_vy0bw UK002Z 2025-12-03T14:25:26.767Z 2025-12-05T14:29:10.969Z
8676473 8676473 20251202055421_zsOoJ UK002Z 2025-12-03T14:25:13.811Z 2025-12-05T14:28:56.949Z
8676302 8676302 20251202054523_MYtSy UK002Z 2025-12-03T14:25:01.699Z 2025-12-05T14:28:54.131Z
8676273 8676273 20251202054412_uOxod UK002Z 2025-12-03T14:24:55.390Z 2025-12-05T14:28:53.746Z
8675907 8675907 20251202052257_DArRJ UK002Z 2025-12-03T14:24:29.974Z 2025-12-05T14:28:44.007Z
8675872 8675872 20251202051953_YS4Pt UK002Z 2025-12-03T14:24:27.985Z 2025-12-05T14:28:43.134Z
8675794 8675794 20251202051517_lHN9U UK002Z 2025-12-03T14:24:15.855Z 2025-12-05T14:28:40.861Z
8675624 8675624 20251202050216_B6IWq UK002Z 2025-12-03T14:23:56.710Z 2025-12-05T14:28:36.992Z
8675382 8675382 20251202043404_4Fhv9 UK002Z 2025-12-03T14:23:39.461Z 2025-12-05T14:28:29.343Z
8675107 8675107 20251202040145_3N9aL UK002Z 2025-12-03T14:23:03.404Z 2025-12-05T14:28:11.460Z
8675056 8675056 20251202035716_lGUm7 UK002Z 2025-12-03T14:22:55.231Z 2025-12-05T14:28:10.294Z
8674921 8674921 20251202033952_JxcoJ UK002Z 2025-12-03T14:22:43.588Z 2025-12-05T14:28:06.770Z
8674880 8674880 20251202033648_zjiO4 UK002Z 2025-12-03T14:22:40.441Z 2025-12-05T14:28:05.865Z
8674846 8674846 20251202033137_wgy1J UK002Z 2025-12-03T14:22:29.334Z 2025-12-05T14:28:04.681Z
8674746 8674746 20251202031922_N2aBj UK002Z 2025-12-03T14:22:17.693Z 2025-12-05T14:28:01.881Z
8674665 8674665 20251202030531_8HzeW UK002Z 2025-12-03T14:22:11.992Z 2025-12-05T14:27:59.444Z
8674132 8674132 20251202013226_PMQ9b UK002Z 2025-12-03T14:20:58.945Z 2025-12-05T14:27:29.994Z
8658621 8658621 20251126062556_JjsMq UK002Z 2025-12-01T15:05:38.729Z 2025-12-04T15:11:43.253Z
8658610 8658610 20251126054644_hwbJO UK002Z 2025-12-01T15:05:06.338Z 2025-12-04T15:11:36.951Z
8658597 8658597 20251126052010_IZ4pq UK002Z 2025-12-01T15:04:52.741Z 2025-12-04T15:11:32.722Z
8658587 8658587 20251126050323_rzaFA UK002Z 2025-12-01T15:04:49.782Z 2025-12-04T15:11:28.929Z
8658579 8658579 20251126043927_3QN2m UK002Z 2025-12-01T15:04:42.936Z 2025-12-04T15:11:23.705Z
8658547 8658547 20251126040030_xX6JU UK002Z 2025-12-01T15:04:35.919Z 2025-12-04T15:10:33.420Z
8658543 8658543 20251126034740_jfAnG UK002Z 2025-12-01T15:04:33.155Z 2025-12-04T15:10:11.206Z
8658540 8658540 20251126033759_IHrDt UK002Z 2025-12-01T15:04:30.783Z 2025-12-04T15:09:53.033Z
8658486 8658486 20251126003828_heCKS UK002Z 2025-12-01T15:02:23.134Z 2025-12-04T15:08:04.115Z
8658466 8658466 20251125235029_72mMh UK002Z 2025-12-01T15:02:14.769Z 2025-12-04T15:07:55.702Z
8658456 8658456 20251125231434_39aH2 UK002Z 2025-12-01T15:02:10.445Z 2025-12-04T15:07:51.584Z
8658447 8658447 20251125225858_vwujr UK002Z 2025-12-01T15:02:08.530Z 2025-12-04T15:07:49.987Z
8658434 8658434 20251125223151_2JSnE UK002Z 2025-12-01T15:02:04.739Z 2025-12-04T15:07:47.086Z
8658413 8658413 20251125215633_jkUTw UK002Z 2025-12-01T15:01:59.497Z 2025-12-04T15:07:42.201Z
8658409 8658409 20251125213120_m3NPf UK002Z 2025-12-01T15:01:56.470Z 2025-12-04T15:07:38.807Z
8658399 8658399 20251125204305_KxtYy UK002Z 2025-12-01T15:01:14.219Z 2025-12-04T15:07:00.983Z
8658387 8658387 20251125193841_nju7t UK002Z 2025-12-01T15:01:02.515Z 2025-12-04T15:06:50.025Z
8658377 8658377 20251125180833_RxlD2 UK002Z 2025-12-01T15:00:52.425Z 2025-12-04T15:06:28.496Z
8603246 8603246 20251125055244_tMScX UK002Z 2025-11-26T14:27:16.886Z 2025-12-02T15:09:35.031Z
8602357 8602357 20251125045031_iV3vY UK002Z 2025-11-26T14:25:35.164Z 2025-12-02T15:09:30.597Z
8601745 8601745 20251125041218_aXHwv UK002Z 2025-11-26T14:24:39.638Z 2025-12-02T15:09:23.433Z
8601380 8601380 20251125034510_RGMBw UK002Z 2025-11-26T14:23:57.107Z 2025-12-02T15:09:08.655Z
8601157 8601157 20251125033653_t9eN2 UK002Z 2025-11-26T14:23:45.340Z 2025-12-02T15:09:05.285Z
8601104 8601104 20251125033425_i1OBg UK002Z 2025-11-26T14:23:41.972Z 2025-11-26T14:29:07.532Z
8600693 8600693 20251125031256_RoCI5 UK002Z 2025-11-26T14:22:53.421Z 2025-12-02T15:08:49.753Z
8600599 8600599 20251125030931_WUGe2 UK002Z 2025-11-26T14:22:49.734Z 2025-12-02T15:08:47.382Z
8600408 8600408 20251125025840_Cfidn UK002Z 2025-11-26T14:22:39.407Z 2025-12-02T15:08:43.517Z
8599983 8599983 20251125023501_vk0Fy UK002Z 2025-11-26T14:21:54.738Z 2025-12-02T15:08:33.287Z
8599947 8599947 20251125023318_TcTty UK002Z 2025-11-26T14:21:51.484Z 2025-12-02T15:08:32.895Z
8599930 8599930 20251125023122_nIIno UK002Z 2025-11-26T14:21:43.576Z 2025-12-02T15:08:32.825Z
8599903 8599903 20251125022946_N3SJQ UK002Z 2025-11-26T14:21:35.583Z 2025-12-02T15:08:32.624Z
8599868 8599868 20251125022916_bIUGt UK002Z 2025-11-26T14:21:34.149Z 2025-12-02T15:08:32.537Z
8599849 8599849 20251125022740_pgE3E UK002Z 2025-11-26T14:21:32.793Z 2025-12-02T15:08:32.399Z
8599583 8599583 20251125021103_NXxKl UK002Z 2025-11-26T14:21:17.124Z 2025-12-02T15:08:29.962Z
8599541 8599541 20251125021029_XJmhp UK002Z 2025-11-26T14:21:14.992Z 2025-12-02T15:08:29.326Z
8599284 8599284 20251125015718_DnSl3 UK002Z 2025-11-26T14:20:45.053Z 2025-12-02T15:08:22.124Z
8599269 8599269 20251125015703_5XvTF UK002Z 2025-11-26T14:20:44.341Z 2025-12-02T15:08:22.072Z
8599259 8599259 20251125015701_dqki3 UK002Z 2025-11-26T14:20:44.056Z 2025-12-02T15:08:22.068Z
8599174 8599174 20251125015147_sDoUt UK002Z 2025-11-26T14:20:37.708Z 2025-12-02T15:08:20.537Z
8599112 8599112 20251125014800_UR2GW UK002Z 2025-11-26T14:20:33.129Z 2025-12-02T15:08:20.077Z
8598964 8598964 20251125013919_ioydO UK002Z 2025-11-26T14:20:08.095Z 2025-12-02T15:08:15.095Z
8598313 8598313 20251125004922_LIkhV UK002Z 2025-11-26T14:18:36.495Z 2025-12-02T15:07:51.823Z
8598236 8598236 20251125004422_d0rmp UK002Z 2025-11-26T14:18:29.829Z 2025-12-02T15:07:49.029Z
8598216 8598216 20251125004340_Q7i7e UK002Z 2025-11-26T14:18:28.025Z 2025-12-02T15:07:48.765Z
8597892 8597892 20251125001650_f3wDQ UK002Z 2025-11-26T14:17:50.757Z 2025-12-02T15:07:43.191Z
8597738 8597738 20251125000555_EAF2H UK002Z 2025-11-26T14:17:37.125Z 2025-12-02T15:07:40.381Z
8597718 8597718 20251125000338_k8MIo UK002Z 2025-11-26T14:17:26.164Z 2025-12-02T15:07:40.136Z
8597690 8597690 20251125000109_eitNy UK002Z 2025-11-26T14:17:22.817Z 2025-12-02T15:07:39.763Z
8597637 8597637 20251124235449_GeInB UK002Z 2025-11-26T14:17:14.811Z 2025-12-02T15:07:38.531Z
8597034 8597034 20251124224705_fv3X0 UK002Z 2025-11-26T14:15:54.389Z 2025-12-02T15:07:22.491Z
8596783 8596783 20251124220550_SP6gw UK002Z 2025-11-26T14:15:19.276Z 2025-12-02T15:07:13.735Z
8596720 8596720 20251124220127_pPe11 UK002Z 2025-11-26T14:15:12.802Z 2025-12-02T15:07:08.182Z
8596658 8596658 20251124214827_7ArHb UK002Z 2025-11-26T14:15:04.221Z 2025-12-02T15:07:04.449Z
8596551 8596551 20251124213054_ShePO UK002Z 2025-11-26T14:14:44.556Z 2025-12-02T15:07:02.505Z
8596165 8596165 20251124200850_UXCTr UK002Z 2025-11-26T14:13:52.260Z 2025-12-02T15:06:47.496Z
8595957 8595957 20251124191333_W6nkd UK002Z 2025-11-26T14:13:11.350Z 2025-12-02T15:06:23.262Z
8595594 8595594 20251124170726_0eQEs UK002Z 2025-11-26T14:11:43.255Z 2025-12-02T15:06:02.135Z
8592113 8592113 20251124055008_hxgfr UK002Z 2025-11-25T14:25:53.888Z 2025-12-02T15:13:01.916Z
8591313 8591313 20251124040342_tOo0c UK002Z 2025-11-25T14:23:52.750Z 2025-12-02T15:12:57.889Z
8585685 8585685 20251123173244_2NAOX UK002Z 2025-11-25T14:10:35.867Z 2025-12-02T15:10:09.050Z
8582124 8582124 20251123041814_2IoFs UK002Z 2025-11-24T14:33:18.322Z 2025-12-01T15:22:16.841Z
8582072 8582072 20251123040118_ZVfAX UK002Z 2025-11-24T14:33:15.234Z 2025-12-01T15:22:15.553Z
8569915 8569915 20251121063008_Z0o6t UK002Z 2025-11-23T14:32:49.793Z 2025-11-29T14:54:49.849Z
8569752 8569752 20251121061235_bjhdB UK002Z 2025-11-23T14:32:27.710Z 2025-11-29T14:54:48.946Z
8569723 8569723 20251121061107_AqgWE UK002Z 2025-11-23T14:32:26.097Z 2025-11-29T14:54:48.916Z
8569599 8569599 20251121060308_AiwVC UK002Z 2025-11-23T14:32:21.027Z 2025-11-29T14:54:48.509Z
8569359 8569359 20251121055440_0FPev UK002Z 2025-11-23T14:32:12.442Z 2025-11-29T14:54:48.208Z
8569178 8569178 20251121054809_5qUt3 UK002Z 2025-11-23T14:31:57.293Z 2025-11-29T14:54:47.893Z

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