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

6,591 rows where station_code = "UK003T" 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
8677085 8677085 20251202064733_2R3G8 UK003T 2025-12-03T14:26:16.893Z 2025-12-05T14:29:20.601Z
8676922 8676922 20251202063108_mb3Ug UK003T 2025-12-03T14:25:56.392Z 2025-12-05T14:29:16.273Z
8676895 8676895 20251202063049_mlP9C UK003T 2025-12-03T14:25:55.509Z 2025-12-05T14:29:15.874Z
8676809 8676809 20251202062700_m0xOy UK003T 2025-12-03T14:25:51.470Z 2025-12-05T14:29:14.290Z
8676800 8676800 20251202062646_6ELPl UK003T 2025-12-03T14:25:47.323Z 2025-12-05T14:29:14.159Z
8676689 8676689 20251202061234_WxcvR UK003T 2025-12-03T14:25:26.240Z 2025-12-05T14:29:10.760Z
8676662 8676662 20251202061107_Y3jbD UK003T 2025-12-03T14:25:25.242Z 2025-12-05T14:29:10.315Z
8676584 8676584 20251202060414_X52Ag UK003T 2025-12-03T14:25:20.320Z 2025-12-05T14:29:08.330Z
8676474 8676474 20251202055421_zsOoJ UK003T 2025-12-03T14:25:13.811Z 2025-12-05T14:28:56.949Z
8676398 8676398 20251202055134_uPzBy UK003T 2025-12-03T14:25:11.277Z 2025-12-05T14:28:55.980Z
8676358 8676358 20251202054909_5B104 UK003T 2025-12-03T14:25:09.286Z 2025-12-05T14:28:55.188Z
8676175 8676175 20251202053945_3TiuY UK003T 2025-12-03T14:24:48.378Z 2025-12-05T14:28:49.972Z
8676107 8676107 20251202053704_Fr3AE UK003T 2025-12-03T14:24:42.485Z 2025-12-05T14:28:48.740Z
8676095 8676095 20251202053701_ezluA UK003T 2025-12-03T14:24:42.234Z 2025-12-05T14:28:48.593Z
8675990 8675990 20251202052922_VBv5q UK003T 2025-12-03T14:24:35.072Z 2025-12-05T14:28:45.707Z
8675795 8675795 20251202051517_lHN9U UK003T 2025-12-03T14:24:15.856Z 2025-12-05T14:28:40.861Z
8675383 8675383 20251202043404_4Fhv9 UK003T 2025-12-03T14:23:39.461Z 2025-12-05T14:28:29.343Z
8675311 8675311 20251202042751_aHcbA UK003T 2025-12-03T14:23:30.645Z 2025-12-05T14:28:19.624Z
8675043 8675043 20251202035519_DVknV UK003T 2025-12-03T14:22:52.634Z 2025-12-05T14:28:09.948Z
8674881 8674881 20251202033648_zjiO4 UK003T 2025-12-03T14:22:40.441Z 2025-12-05T14:28:05.865Z
8674847 8674847 20251202033137_wgy1J UK003T 2025-12-03T14:22:29.334Z 2025-12-05T14:28:04.681Z
8674812 8674812 20251202032750_7WWZc UK003T 2025-12-03T14:22:26.767Z 2025-12-05T14:28:03.731Z
8674713 8674713 20251202031046_Uo44H UK003T 2025-12-03T14:22:14.360Z 2025-12-05T14:28:00.330Z
8674666 8674666 20251202030531_8HzeW UK003T 2025-12-03T14:22:11.992Z 2025-12-05T14:27:59.444Z
8674411 8674411 20251202022244_JlDnS UK003T 2025-12-03T14:21:36.827Z 2025-12-05T14:27:41.176Z
8674386 8674386 20251202021454_jNyiE UK003T 2025-12-03T14:21:34.598Z 2025-12-05T14:27:40.184Z
8674326 8674326 20251202020238_WLTzp UK003T 2025-12-03T14:21:25.222Z 2025-12-05T14:27:36.633Z
8674303 8674303 20251202015802_YzfDl UK003T 2025-12-03T14:21:22.545Z 2025-12-05T14:27:35.370Z
8674248 8674248 20251202015430_FBiZ3 UK003T 2025-12-03T14:21:17.149Z 2025-12-05T14:27:33.680Z
8674190 8674190 20251202014528_ak0oi UK003T 2025-12-03T14:21:08.256Z 2025-12-05T14:27:31.779Z
8674183 8674183 20251202014411_jBvNF UK003T 2025-12-03T14:21:08.063Z 2025-12-05T14:27:31.648Z
8674133 8674133 20251202013226_PMQ9b UK003T 2025-12-03T14:20:58.973Z 2025-12-05T14:27:29.994Z
8674099 8674099 20251202012838_GGdn9 UK003T 2025-12-03T14:20:56.048Z 2025-12-05T14:27:28.713Z
8674074 8674074 20251202012433_yq36s UK003T 2025-12-03T14:20:54.823Z 2025-12-05T14:27:28.361Z
8673873 8673873 20251202001019_7X0ts UK003T 2025-12-03T14:20:13.363Z 2025-12-05T14:27:20.970Z
8667908 8667908 20251130050823_Y2WUb UK003T 2025-12-02T14:41:17.306Z 2025-12-05T14:45:20.690Z
8667824 8667824 20251130042004_Pen4T UK003T 2025-12-02T14:40:31.038Z 2025-12-05T14:44:39.508Z
8662084 8662084 20251130175313_pLo9j UK003T 2025-12-02T14:14:16.454Z 2025-12-05T14:32:51.976Z
8661945 8661945 20251130173515_ojcuB UK003T 2025-12-02T14:13:40.670Z 2025-12-05T14:32:43.116Z
8661896 8661896 20251130173013_3GTHD UK003T 2025-12-02T14:13:34.136Z 2025-12-05T14:32:40.971Z
8661852 8661852 20251130172421_2DQaz UK003T 2025-12-02T14:13:15.547Z 2025-12-05T14:32:38.165Z
8658311 8658311 20251128024039_Dpwg0 UK003T 2025-12-01T14:52:04.648Z 2025-12-05T14:59:13.745Z
8658036 8658036 20251130063135_XXwRt UK003T 2025-12-01T14:34:52.393Z 2025-12-05T14:46:01.231Z
8657975 8657975 20251130062416_HXXzu UK003T 2025-12-01T14:34:48.656Z 2025-12-05T14:45:59.878Z
8657751 8657751 20251130060510_bE9Q2 UK003T 2025-12-01T14:34:40.195Z 2025-12-05T14:45:36.412Z
8657442 8657442 20251130054637_g7tM2 UK003T 2025-12-01T14:34:26.928Z 2025-12-05T14:45:30.267Z
8657387 8657387 20251130054116_3rEpI UK003T 2025-12-01T14:34:19.397Z 2025-12-05T14:45:29.173Z
8657263 8657263 20251130053750_du4EE UK003T 2025-12-01T14:34:02.932Z 2025-12-05T14:45:27.696Z
8656877 8656877 20251130051512_5gFhx UK003T 2025-12-01T14:33:48.032Z 2025-12-05T14:45:22.925Z
8656866 8656866 20251130051456_2dZjt UK003T 2025-12-01T14:33:47.453Z 2025-12-05T14:45:22.692Z
8656828 8656828 20251130051311_P3KRn UK003T 2025-12-01T14:29:04.933Z 2025-12-05T14:45:22.158Z
8656742 8656742 20251130050820_tcZTv UK003T 2025-12-01T14:28:59.153Z 2025-12-05T14:45:20.527Z
8656693 8656693 20251130050602_cbvQJ UK003T 2025-12-01T14:28:54.469Z 2025-12-05T14:45:20.058Z
8656686 8656686 20251130050602_PkhPV UK003T 2025-12-01T14:28:54.117Z 2025-12-05T14:45:19.994Z
8655925 8655925 20251130042516_4hwPl UK003T 2025-12-01T14:27:41.191Z 2025-12-05T14:44:41.222Z
8655815 8655815 20251130042004_Umphe UK003T 2025-12-01T14:27:31.479Z 2025-12-01T14:35:23.019Z
8655651 8655651 20251130041050_2J30U UK003T 2025-12-01T14:27:20.142Z 2025-12-05T14:44:36.725Z
8655579 8655579 20251130040801_k1Ebi UK003T 2025-12-01T14:27:11.633Z 2025-12-05T14:44:35.800Z
8655544 8655544 20251130040648_Wzx2z UK003T 2025-12-01T14:27:02.794Z 2025-12-05T14:44:35.174Z
8655499 8655499 20251130040451_EoCsa UK003T 2025-12-01T14:27:01.097Z 2025-12-05T14:44:34.541Z
8655364 8655364 20251130035808_7MkkO UK003T 2025-12-01T14:26:51.193Z 2025-12-05T14:44:32.953Z
8655274 8655274 20251130035215_3jaMh UK003T 2025-12-01T14:26:42.925Z 2025-12-05T14:44:31.000Z
8655182 8655182 20251130034811_k6b52 UK003T 2025-12-01T14:26:37.496Z 2025-12-05T14:44:29.460Z
8654789 8654789 20251130033313_wYMry UK003T 2025-12-01T14:26:02.165Z 2025-12-01T14:26:02.165Z
8654557 8654557 20251130032023_5iayK UK003T 2025-12-01T14:25:34.894Z 2025-12-05T14:44:12.225Z
8654014 8654014 20251130025159_Lgilc UK003T 2025-12-01T14:24:44.628Z 2025-12-05T14:43:44.967Z
8653983 8653983 20251130025036_Jz3bE UK003T 2025-12-01T14:24:34.352Z 2025-12-05T14:43:44.243Z
8653844 8653844 20251130024432_i7wT7 UK003T 2025-12-01T14:24:22.619Z 2025-12-05T14:43:41.373Z
8653700 8653700 20251130023558_Lf337 UK003T 2025-12-01T14:23:57.874Z 2025-12-05T14:43:38.128Z
8653483 8653483 20251130021820_jBt65 UK003T 2025-12-01T14:23:34.420Z 2025-12-05T14:43:32.557Z
8653209 8653209 20251130020315_WSCSy UK003T 2025-12-01T14:23:04.836Z 2025-12-05T14:43:05.631Z
8652775 8652775 20251130013433_387aK UK003T 2025-12-01T14:22:07.102Z 2025-12-05T14:42:52.410Z
8652533 8652533 20251130011820_e2r4s UK003T 2025-12-01T14:21:39.758Z 2025-12-05T14:42:47.138Z
8652308 8652308 20251130010242_mOG3N UK003T 2025-12-01T14:21:15.169Z 2025-12-05T14:42:42.423Z
8652007 8652007 20251130004042_08Qt7 UK003T 2025-12-01T14:20:28.057Z 2025-12-05T14:42:13.463Z
8651985 8651985 20251130003955_uiEkR UK003T 2025-12-01T14:20:23.694Z 2025-12-05T14:42:12.869Z
8651947 8651947 20251130003702_ouY2F UK003T 2025-12-01T14:20:19.313Z 2025-12-05T14:42:12.194Z
8651878 8651878 20251130003027_TYuQR UK003T 2025-12-01T14:20:11.143Z 2025-12-05T14:42:10.360Z
8651815 8651815 20251130002228_R9PA4 UK003T 2025-12-01T14:19:59.603Z 2025-12-05T14:42:07.049Z
8651800 8651800 20251130002015_CO0ZN UK003T 2025-12-01T14:19:57.228Z 2025-12-05T14:42:06.545Z
8651658 8651658 20251130000854_C6I2K UK003T 2025-12-01T14:19:39.238Z 2025-12-05T14:42:02.975Z
8651644 8651644 20251130000751_bO7jS UK003T 2025-12-01T14:19:37.576Z 2025-12-05T14:42:02.649Z
8651515 8651515 20251129235305_hKO2W UK003T 2025-12-01T14:19:15.576Z 2025-12-05T14:41:59.641Z
8651506 8651506 20251129235113_JX9FE UK003T 2025-12-01T14:19:14.511Z 2025-12-05T14:41:59.436Z
8651466 8651466 20251129234523_3u5dg UK003T 2025-12-01T14:19:09.847Z 2025-12-05T14:41:58.636Z
8644551 8644551 20251128193230_uKIZE UK003T 2025-11-30T14:22:06.163Z 2025-12-05T14:50:23.633Z
8644377 8644377 20251128192412_AbcyG UK003T 2025-11-30T14:21:55.948Z 2025-12-05T14:50:21.257Z
8643996 8643996 20251128184815_xE9oG UK003T 2025-11-30T14:20:59.353Z 2025-12-05T14:50:13.740Z
8643549 8643549 20251128180612_lIx2p UK003T 2025-11-30T14:20:12.788Z 2025-12-05T14:49:26.803Z
8643497 8643497 20251128180159_w5uzk UK003T 2025-11-30T14:20:06.156Z 2025-12-05T14:49:22.330Z
8643341 8643341 20251128174425_V94Sx UK003T 2025-11-30T14:19:55.010Z 2025-12-05T14:49:16.046Z
8642945 8642945 20251128170555_ZjrFX UK003T 2025-11-30T14:19:02.255Z 2025-12-05T14:49:07.505Z
8637757 8637757 20251128063137_vwgcA UK003T 2025-11-29T14:27:48.428Z 2025-12-05T15:00:25.451Z
8637595 8637595 20251128055854_3zkpn UK003T 2025-11-29T14:27:36.779Z 2025-12-05T15:00:08.199Z
8637371 8637371 20251128053345_RE4sZ UK003T 2025-11-29T14:27:07.257Z 2025-12-05T14:59:48.037Z
8637289 8637289 20251128052539_TJ4JR UK003T 2025-11-29T14:27:03.163Z 2025-12-05T14:59:39.861Z
8636958 8636958 20251128044128_d7OZb UK003T 2025-11-29T14:26:23.797Z 2025-12-05T14:59:33.295Z
8636948 8636948 20251128044028_ZyvFy UK003T 2025-11-29T14:26:23.051Z 2025-12-05T14:59:33.024Z
8636771 8636771 20251128042640_duDDi UK003T 2025-11-29T14:26:11.258Z 2025-12-05T14:59:29.599Z
8636683 8636683 20251128041712_xOKII UK003T 2025-11-29T14:26:05.126Z 2025-12-05T14:59:28.182Z

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