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

4,224 rows where station_code = "UK00A3" 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
8683254 8683254 20251203064635_uWLTh UK00A3 2025-12-04T14:19:00.415Z 2025-12-05T14:23:12.971Z
8683196 8683196 20251203063843_LHuJd UK00A3 2025-12-04T14:18:54.659Z 2025-12-05T14:23:10.986Z
8683172 8683172 20251203063433_K4JFD UK00A3 2025-12-04T14:18:43.645Z 2025-12-05T14:23:09.823Z
8683041 8683041 20251203062043_JU6sX UK00A3 2025-12-04T14:18:28.823Z 2025-12-05T14:23:05.661Z
8682878 8682878 20251203061135_yNjsy UK00A3 2025-12-04T14:18:10.904Z 2025-12-05T14:22:55.261Z
8682619 8682619 20251203055127_dXsny UK00A3 2025-12-04T14:17:43.587Z 2025-12-05T14:22:45.201Z
8682549 8682549 20251203054454_ZWE2G UK00A3 2025-12-04T14:17:26.224Z 2025-12-05T14:22:42.309Z
8682327 8682327 20251203051614_p2XKk UK00A3 2025-12-04T14:16:48.709Z 2025-12-05T14:22:24.405Z
8682031 8682031 20251203044242_ZXv2u UK00A3 2025-12-04T14:16:15.314Z 2025-12-05T14:22:12.312Z
8681586 8681586 20251203032620_WhmNa UK00A3 2025-12-04T14:15:05.048Z 2025-12-05T14:21:41.957Z
8681578 8681578 20251203032606_siL0u UK00A3 2025-12-04T14:15:04.687Z 2025-12-05T14:21:41.844Z
8681491 8681491 20251203031551_ZB9Pb UK00A3 2025-12-04T14:14:48.761Z 2025-12-05T14:21:38.837Z
8681466 8681466 20251203031359_JRl1s UK00A3 2025-12-04T14:14:45.941Z 2025-12-05T14:21:38.319Z
8681276 8681276 20251203025135_gcaTl UK00A3 2025-12-04T14:14:14.575Z 2025-12-05T14:21:30.123Z
8680898 8680898 20251203014334_oBTyS UK00A3 2025-12-04T14:13:17.332Z 2025-12-05T14:21:06.196Z
8680786 8680786 20251203012022_OGZCw UK00A3 2025-12-04T14:12:55.834Z 2025-12-05T14:21:01.106Z
8680440 8680440 20251202235926_sSsXW UK00A3 2025-12-04T14:12:00.420Z 2025-12-05T14:20:38.519Z
8680318 8680318 20251202231914_AWSg0 UK00A3 2025-12-04T14:11:41.644Z 2025-12-05T14:20:33.719Z
8680303 8680303 20251202230859_xvjRn UK00A3 2025-12-04T14:11:39.252Z 2025-12-05T14:20:32.881Z
8680286 8680286 20251202225647_cVYr4 UK00A3 2025-12-04T14:11:34.184Z 2025-12-05T14:20:31.810Z
8680166 8680166 20251202215617_g3ZA0 UK00A3 2025-12-04T14:11:19.618Z 2025-12-05T14:20:21.953Z
8677107 8677107 20251202065224_q12ZO UK00A3 2025-12-03T14:26:18.711Z 2025-12-05T14:29:21.443Z
8677088 8677088 20251202064733_2R3G8 UK00A3 2025-12-03T14:26:16.893Z 2025-12-05T14:29:20.601Z
8676928 8676928 20251202063108_mb3Ug UK00A3 2025-12-03T14:25:56.392Z 2025-12-05T14:29:16.273Z
8676899 8676899 20251202063049_mlP9C UK00A3 2025-12-03T14:25:55.509Z 2025-12-05T14:29:15.874Z
8676803 8676803 20251202062646_6ELPl UK00A3 2025-12-03T14:25:47.323Z 2025-12-05T14:29:14.159Z
8676587 8676587 20251202060414_X52Ag UK00A3 2025-12-03T14:25:20.321Z 2025-12-05T14:29:08.330Z
8676181 8676181 20251202053945_3TiuY UK00A3 2025-12-03T14:24:48.378Z 2025-12-05T14:28:49.972Z
8676100 8676100 20251202053701_ezluA UK00A3 2025-12-03T14:24:42.235Z 2025-12-05T14:28:48.593Z
8675924 8675924 20251202052301_Wb9sl UK00A3 2025-12-03T14:24:30.663Z 2025-12-05T14:28:44.217Z
8675875 8675875 20251202051953_YS4Pt UK00A3 2025-12-03T14:24:27.986Z 2025-12-05T14:28:43.134Z
8675722 8675722 20251202051108_eMwMj UK00A3 2025-12-03T14:24:12.387Z 2025-12-05T14:28:39.510Z
8675627 8675627 20251202050216_B6IWq UK00A3 2025-12-03T14:23:56.710Z 2025-12-05T14:28:36.992Z
8675511 8675511 20251202045107_vcp34 UK00A3 2025-12-03T14:23:48.675Z 2025-12-05T14:28:34.303Z
8675315 8675315 20251202042751_aHcbA UK00A3 2025-12-03T14:23:30.645Z 2025-12-05T14:28:19.624Z
8675177 8675177 20251202041236_ld8kV UK00A3 2025-12-03T14:23:15.109Z 2025-12-05T14:28:14.271Z
8674923 8674923 20251202033952_JxcoJ UK00A3 2025-12-03T14:22:43.588Z 2025-12-05T14:28:06.770Z
8674851 8674851 20251202033137_wgy1J UK00A3 2025-12-03T14:22:29.334Z 2025-12-05T14:28:04.681Z
8674813 8674813 20251202032750_7WWZc UK00A3 2025-12-03T14:22:26.767Z 2025-12-05T14:28:03.731Z
8674738 8674738 20251202031855_2oxQh UK00A3 2025-12-03T14:22:16.799Z 2025-12-05T14:28:01.611Z
8674670 8674670 20251202030531_8HzeW UK00A3 2025-12-03T14:22:11.992Z 2025-12-05T14:27:59.444Z
8674641 8674641 20251202030208_ehnZs UK00A3 2025-12-03T14:22:10.311Z 2025-12-05T14:27:58.665Z
8674447 8674447 20251202022457_m79hg UK00A3 2025-12-03T14:21:39.005Z 2025-12-05T14:27:41.855Z
8674415 8674415 20251202022244_JlDnS UK00A3 2025-12-03T14:21:36.827Z 2025-12-05T14:27:41.176Z
8674390 8674390 20251202021454_jNyiE UK00A3 2025-12-03T14:21:34.599Z 2025-12-05T14:27:40.184Z
8674330 8674330 20251202020238_WLTzp UK00A3 2025-12-03T14:21:25.233Z 2025-12-05T14:27:36.633Z
8674261 8674261 20251202015509_tper3 UK00A3 2025-12-03T14:21:18.177Z 2025-12-05T14:27:34.154Z
8674184 8674184 20251202014411_jBvNF UK00A3 2025-12-03T14:21:08.063Z 2025-12-05T14:27:31.648Z
8674136 8674136 20251202013226_PMQ9b UK00A3 2025-12-03T14:20:58.980Z 2025-12-05T14:27:29.994Z
8674101 8674101 20251202012838_GGdn9 UK00A3 2025-12-03T14:20:56.067Z 2025-12-05T14:27:28.713Z
8673993 8673993 20251202005823_83HWb UK00A3 2025-12-03T14:20:41.735Z 2025-12-05T14:27:25.158Z
8673964 8673964 20251202004859_H5sJb UK00A3 2025-12-03T14:20:26.569Z 2025-12-05T14:27:24.124Z
8658651 8658651 20251125014135_2irP9 UK00A3 2025-12-01T15:09:33.858Z 2025-12-02T15:08:17.136Z
8658312 8658312 20251128024039_Dpwg0 UK00A3 2025-12-01T14:52:04.648Z 2025-12-05T14:59:13.745Z
8658137 8658137 20251130064740_Q2zhg UK00A3 2025-12-01T14:34:57.674Z 2025-12-05T14:46:03.527Z
8657979 8657979 20251130062416_HXXzu UK00A3 2025-12-01T14:34:48.656Z 2025-12-05T14:45:59.878Z
8657416 8657416 20251130054345_urVeJ UK00A3 2025-12-01T14:34:23.514Z 2025-12-05T14:45:29.514Z
8657141 8657141 20251130053152_rraPH UK00A3 2025-12-01T14:33:55.926Z 2025-12-05T14:45:25.906Z
8656904 8656904 20251130051726_7cFnR UK00A3 2025-12-01T14:33:48.887Z 2025-12-05T14:45:23.196Z
8656882 8656882 20251130051512_5gFhx UK00A3 2025-12-01T14:33:48.032Z 2025-12-05T14:45:22.925Z
8656869 8656869 20251130051456_2dZjt UK00A3 2025-12-01T14:33:47.453Z 2025-12-05T14:45:22.692Z
8656830 8656830 20251130051311_P3KRn UK00A3 2025-12-01T14:29:04.933Z 2025-12-05T14:45:22.158Z
8656776 8656776 20251130050920_oDi0z UK00A3 2025-12-01T14:28:59.866Z 2025-12-05T14:45:21.023Z
8656745 8656745 20251130050820_tcZTv UK00A3 2025-12-01T14:28:59.153Z 2025-12-05T14:45:20.527Z
8656690 8656690 20251130050602_PkhPV UK00A3 2025-12-01T14:28:54.117Z 2025-12-05T14:45:19.994Z
8655773 8655773 20251130041716_FBBEC UK00A3 2025-12-01T14:27:27.599Z 2025-12-05T14:44:38.667Z
8655654 8655654 20251130041050_2J30U UK00A3 2025-12-01T14:27:20.142Z 2025-12-05T14:44:36.726Z
8655584 8655584 20251130040801_k1Ebi UK00A3 2025-12-01T14:27:11.633Z 2025-12-05T14:44:35.800Z
8655501 8655501 20251130040451_EoCsa UK00A3 2025-12-01T14:27:01.097Z 2025-12-05T14:44:34.541Z
8655490 8655490 20251130040424_VPfZ5 UK00A3 2025-12-01T14:27:00.024Z 2025-12-05T14:44:34.441Z
8655186 8655186 20251130034811_k6b52 UK00A3 2025-12-01T14:26:37.496Z 2025-12-05T14:44:29.460Z
8654968 8654968 20251130033957_fpa8l UK00A3 2025-12-01T14:26:13.537Z 2025-12-05T14:44:26.484Z
8654560 8654560 20251130032023_5iayK UK00A3 2025-12-01T14:25:34.895Z 2025-12-05T14:44:12.225Z
8654101 8654101 20251130025908_awgCb UK00A3 2025-12-01T14:24:51.824Z 2025-12-05T14:43:47.050Z
8654018 8654018 20251130025159_Lgilc UK00A3 2025-12-01T14:24:44.629Z 2025-12-05T14:43:44.967Z
8653211 8653211 20251130020315_WSCSy UK00A3 2025-12-01T14:23:04.836Z 2025-12-05T14:43:05.631Z
8653077 8653077 20251130015456_v1ang UK00A3 2025-12-01T14:22:45.254Z 2025-12-05T14:43:02.791Z
8652782 8652782 20251130013433_387aK UK00A3 2025-12-01T14:22:07.102Z 2025-12-05T14:42:52.410Z
8652731 8652731 20251130012853_kP2d2 UK00A3 2025-12-01T14:22:02.119Z 2025-12-05T14:42:50.873Z
8652539 8652539 20251130011820_e2r4s UK00A3 2025-12-01T14:21:39.758Z 2025-12-05T14:42:47.138Z
8652312 8652312 20251130010242_mOG3N UK00A3 2025-12-01T14:21:15.217Z 2025-12-05T14:42:42.423Z
8651989 8651989 20251130003955_uiEkR UK00A3 2025-12-01T14:20:23.710Z 2025-12-05T14:42:12.869Z
8651881 8651881 20251130003027_TYuQR UK00A3 2025-12-01T14:20:11.143Z 2025-12-05T14:42:10.360Z
8651659 8651659 20251130000854_C6I2K UK00A3 2025-12-01T14:19:39.238Z 2025-12-05T14:42:02.975Z
8651517 8651517 20251129235305_hKO2W UK00A3 2025-12-01T14:19:15.608Z 2025-12-05T14:41:59.641Z
8651468 8651468 20251129234523_3u5dg UK00A3 2025-12-01T14:19:09.868Z 2025-12-05T14:41:58.636Z
8648605 8648605 20251127184428_IWLdO UK00A3 2025-11-30T14:34:23.032Z 2025-12-05T14:56:04.871Z
8644897 8644897 20251128201213_NrzDY UK00A3 2025-11-30T14:22:50.847Z 2025-12-05T14:50:28.929Z
8644554 8644554 20251128193230_uKIZE UK00A3 2025-11-30T14:22:06.163Z 2025-12-05T14:50:23.633Z
8643552 8643552 20251128180612_lIx2p UK00A3 2025-11-30T14:20:12.788Z 2025-12-05T14:49:26.804Z
8643502 8643502 20251128180159_w5uzk UK00A3 2025-11-30T14:20:06.173Z 2025-12-05T14:49:22.330Z
8643476 8643476 20251128180033_iJVgo UK00A3 2025-11-30T14:20:04.578Z 2025-12-05T14:49:19.832Z
8637755 8637755 20251128063129_q8Stf UK00A3 2025-11-29T14:27:48.085Z 2025-12-05T15:00:25.393Z
8637260 8637260 20251128052115_wwYzW UK00A3 2025-11-29T14:27:01.682Z 2025-12-05T14:59:39.458Z
8636663 8636663 20251128041543_W3Iq5 UK00A3 2025-11-29T14:26:02.575Z 2025-12-05T14:59:27.857Z
8636560 8636560 20251128040408_wb90N UK00A3 2025-11-29T14:25:41.145Z 2025-12-05T14:59:26.132Z
8636511 8636511 20251128035445_0uOmv UK00A3 2025-11-29T14:25:36.038Z 2025-12-05T14:59:25.263Z
8636419 8636419 20251128034401_9yKpW UK00A3 2025-11-29T14:25:28.625Z 2025-12-05T14:59:23.859Z
8635731 8635731 20251128024039_1WceO UK00A3 2025-11-29T14:24:04.896Z 2025-11-30T14:36:53.948Z
8635547 8635547 20251128022452_YaVHj UK00A3 2025-11-29T14:23:39.920Z 2025-12-05T14:59:01.564Z

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