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

2,682 rows where station_code = "UK00C1" 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
8683228 8683228 20251203064326_Uh2Qq UK00C1 2025-12-04T14:18:58.110Z 2025-12-05T14:23:12.166Z
8683093 8683093 20251203062616_3I3KG UK00C1 2025-12-04T14:18:34.318Z 2025-12-05T14:23:07.685Z
8682990 8682990 20251203061840_2n14J UK00C1 2025-12-04T14:18:26.216Z 2025-12-05T14:23:04.695Z
8682740 8682740 20251203060131_9N2KJ UK00C1 2025-12-04T14:17:57.530Z 2025-12-05T14:22:48.593Z
8682217 8682217 20251203050246_iIocV UK00C1 2025-12-04T14:16:38.383Z 2025-12-05T14:22:18.933Z
8682116 8682116 20251203045258_2MyOP UK00C1 2025-12-04T14:16:28.347Z 2025-12-05T14:22:15.082Z
8682084 8682084 20251203044702_c94mT UK00C1 2025-12-04T14:16:22.115Z 2025-12-05T14:22:13.699Z
8681877 8681877 20251203041836_arPv5 UK00C1 2025-12-04T14:15:49.944Z 2025-12-05T14:22:04.953Z
8681709 8681709 20251203034919_4cZjz UK00C1 2025-12-04T14:15:18.761Z 2025-12-05T14:21:50.156Z
8681522 8681522 20251203032141_7g0RN UK00C1 2025-12-04T14:14:51.958Z 2025-12-05T14:21:40.114Z
8681379 8681379 20251203030138_keE2i UK00C1 2025-12-04T14:14:35.817Z 2025-12-05T14:21:34.557Z
8681338 8681338 20251203025745_olBOe UK00C1 2025-12-04T14:14:31.870Z 2025-12-05T14:21:33.349Z
8680703 8680703 20251203010652_cFYcd UK00C1 2025-12-04T14:12:45.977Z 2025-12-05T14:20:52.901Z
8676939 8676939 20251202063126_hh3Xs UK00C1 2025-12-03T14:25:56.698Z 2025-12-05T14:29:16.357Z
8676682 8676682 20251202061146_hjmEM UK00C1 2025-12-03T14:25:25.849Z 2025-12-05T14:29:10.563Z
8676632 8676632 20251202060933_T3bUR UK00C1 2025-12-03T14:25:22.800Z 2025-12-05T14:29:09.245Z
8676425 8676425 20251202055148_BwZvy UK00C1 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676008 8676008 20251202053053_619Iu UK00C1 2025-12-03T14:24:35.700Z 2025-12-05T14:28:45.949Z
8675585 8675585 20251202045844_j6jBp UK00C1 2025-12-03T14:23:52.887Z 2025-12-05T14:28:36.159Z
8675538 8675538 20251202045507_Lbzry UK00C1 2025-12-03T14:23:50.385Z 2025-12-05T14:28:35.042Z
8675468 8675468 20251202044357_Kx77Z UK00C1 2025-12-03T14:23:45.215Z 2025-12-05T14:28:32.752Z
8675421 8675421 20251202043700_OmoV5 UK00C1 2025-12-03T14:23:41.715Z 2025-12-05T14:28:31.479Z
8675359 8675359 20251202043132_w7ZIK UK00C1 2025-12-03T14:23:33.657Z 2025-12-05T14:28:20.907Z
8675264 8675264 20251202042435_Ih9Ow UK00C1 2025-12-03T14:23:25.078Z 2025-12-05T14:28:18.341Z
8674968 8674968 20251202034514_bEb57 UK00C1 2025-12-03T14:22:46.932Z 2025-12-05T14:28:07.984Z
8674896 8674896 20251202033652_pT7HE UK00C1 2025-12-03T14:22:40.649Z 2025-12-05T14:28:05.953Z
8674770 8674770 20251202032048_nj9aN UK00C1 2025-12-03T14:22:19.479Z 2025-12-05T14:28:02.441Z
8674620 8674620 20251202025849_l3X15 UK00C1 2025-12-03T14:22:08.293Z 2025-12-05T14:27:57.899Z
8674500 8674500 20251202023659_SkhVu UK00C1 2025-12-03T14:21:42.619Z 2025-12-05T14:27:44.988Z
8674489 8674489 20251202023306_d0ZQJ UK00C1 2025-12-03T14:21:41.831Z 2025-12-05T14:27:42.991Z
8674442 8674442 20251202022442_X5q0L UK00C1 2025-12-03T14:21:38.698Z 2025-12-05T14:27:41.791Z
8674377 8674377 20251202021337_rXUfK UK00C1 2025-12-03T14:21:33.166Z 2025-12-05T14:27:39.562Z
8674348 8674348 20251202020608_eXtt3 UK00C1 2025-12-03T14:21:26.997Z 2025-12-05T14:27:38.463Z
8674299 8674299 20251202015717_ESaE0 UK00C1 2025-12-03T14:21:22.344Z 2025-12-05T14:27:35.325Z
8674215 8674215 20251202014715_kzt7R UK00C1 2025-12-03T14:21:10.572Z 2025-12-05T14:27:32.805Z
8674041 8674041 20251202011559_aZDtO UK00C1 2025-12-03T14:20:47.138Z 2025-12-05T14:27:27.115Z
8667787 8667787 20251130040216_4lDhN UK00C1 2025-12-02T14:40:22.745Z 2025-12-05T14:44:33.768Z
8661787 8661787 20251130171132_gSbPV UK00C1 2025-12-02T14:13:01.941Z 2025-12-05T14:32:35.487Z
8657347 8657347 20251130053946_Tq5TP UK00C1 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8656215 8656215 20251130044349_m3AK8 UK00C1 2025-12-01T14:28:10.949Z 2025-12-01T14:28:10.949Z
8656210 8656210 20251130044349_H96M9 UK00C1 2025-12-01T14:28:10.677Z 2025-12-05T14:44:47.962Z
8656157 8656157 20251130044007_nc34g UK00C1 2025-12-01T14:28:06.758Z 2025-12-05T14:44:46.798Z
8655870 8655870 20251130042122_4iK7M UK00C1 2025-12-01T14:27:33.669Z 2025-12-05T14:44:40.185Z
8655851 8655851 20251130042046_TKwdn UK00C1 2025-12-01T14:27:32.710Z 2025-12-05T14:44:39.932Z
8655600 8655600 20251130040815_GqLlJ UK00C1 2025-12-01T14:27:15.360Z 2025-12-05T14:44:36.044Z
8654936 8654936 20251130033844_ZvoEJ UK00C1 2025-12-01T14:26:11.181Z 2025-12-05T14:44:25.990Z
8654668 8654668 20251130032455_hrwcX UK00C1 2025-12-01T14:25:42.517Z 2025-12-05T14:44:19.991Z
8654578 8654578 20251130032031_09TIJ UK00C1 2025-12-01T14:25:35.074Z 2025-12-05T14:44:12.321Z
8653936 8653936 20251130024833_7iCgP UK00C1 2025-12-01T14:24:30.501Z 2025-12-05T14:43:42.914Z
8653235 8653235 20251130020355_yr6i0 UK00C1 2025-12-01T14:23:06.388Z 2025-12-05T14:43:05.977Z
8653108 8653108 20251130015616_m3yDB UK00C1 2025-12-01T14:22:49.354Z 2025-12-05T14:43:03.684Z
8652467 8652467 20251130011101_L8Gal UK00C1 2025-12-01T14:21:27.852Z 2025-12-05T14:42:45.179Z
8652099 8652099 20251130004730_XrnWE UK00C1 2025-12-01T14:20:42.804Z 2025-12-05T14:42:19.829Z
8651940 8651940 20251130003522_jrk2G UK00C1 2025-12-01T14:20:17.860Z 2025-12-05T14:42:11.833Z
8651528 8651528 20251129235339_WXO5c UK00C1 2025-12-01T14:19:15.976Z 2025-12-05T14:41:59.716Z
8644834 8644834 20251128200248_Zmcc2 UK00C1 2025-11-30T14:22:46.157Z 2025-12-05T14:50:27.775Z
8637740 8637740 20251128062841_P3ig0 UK00C1 2025-11-29T14:27:47.122Z 2025-12-05T15:00:21.961Z
8637657 8637657 20251128060634_RIkq1 UK00C1 2025-11-29T14:27:40.124Z 2025-12-05T15:00:12.020Z
8637631 8637631 20251128060124_s2Is2 UK00C1 2025-11-29T14:27:38.104Z 2025-12-05T15:00:11.061Z
8637617 8637617 20251128055952_3q2Ed UK00C1 2025-11-29T14:27:37.702Z 2025-12-05T15:00:10.428Z
8637510 8637510 20251128054606_PYuwC UK00C1 2025-11-29T14:27:31.433Z 2025-12-05T14:59:56.779Z
8637054 8637054 20251128045551_3fJSk UK00C1 2025-11-29T14:26:48.083Z 2025-12-05T14:59:36.585Z
8636909 8636909 20251128043644_e923a UK00C1 2025-11-29T14:26:19.745Z 2025-12-05T14:59:31.663Z
8636819 8636819 20251128042928_VG2Gt UK00C1 2025-11-29T14:26:14.139Z 2025-12-05T14:59:30.256Z
8636802 8636802 20251128042830_la2h8 UK00C1 2025-11-29T14:26:12.972Z 2025-12-05T14:59:29.990Z
8636637 8636637 20251128041132_S2DGN UK00C1 2025-11-29T14:25:46.601Z 2025-12-05T14:59:27.072Z
8636333 8636333 20251128033722_TWEYv UK00C1 2025-11-29T14:25:23.249Z 2025-12-05T14:59:22.909Z
8635917 8635917 20251128025857_JfMH4 UK00C1 2025-11-29T14:24:23.599Z 2025-12-05T14:59:16.476Z
8635840 8635840 20251128025326_Zf6UR UK00C1 2025-11-29T14:24:13.696Z 2025-12-05T14:59:15.359Z
8635698 8635698 20251128023825_W3JoR UK00C1 2025-11-29T14:24:01.877Z 2025-12-05T14:59:13.270Z
8635595 8635595 20251128022856_Y33Yx UK00C1 2025-11-29T14:23:53.619Z 2025-12-05T14:59:08.403Z
8634931 8634931 20251128012634_3C2wQ UK00C1 2025-11-29T14:22:12.433Z 2025-12-05T14:58:26.460Z
8634686 8634686 20251128011028_uMBE2 UK00C1 2025-11-29T14:21:55.759Z 2025-12-05T14:58:23.654Z
8634095 8634095 20251128002107_s4t9h UK00C1 2025-11-29T14:20:42.313Z 2025-12-05T14:58:16.282Z
8634078 8634078 20251128002023_j1ThN UK00C1 2025-11-29T14:20:41.943Z 2025-12-05T14:58:16.209Z
8633682 8633682 20251127234527_rzeJH UK00C1 2025-11-29T14:20:05.733Z 2025-12-05T14:57:54.434Z
8633474 8633474 20251127232056_jCpSJ UK00C1 2025-11-29T14:19:45.994Z 2025-12-05T14:57:41.525Z
8633451 8633451 20251127231833_lM7A0 UK00C1 2025-11-29T14:19:43.766Z 2025-12-05T14:57:40.096Z
8633208 8633208 20251127225145_0jHRR UK00C1 2025-11-29T14:19:14.023Z 2025-12-05T14:57:18.374Z
8633095 8633095 20251127223832_FPE0s UK00C1 2025-11-29T14:18:58.823Z 2025-12-05T14:57:07.192Z
8632413 8632413 20251127210425_ECCz2 UK00C1 2025-11-29T14:17:26.636Z 2025-12-05T14:56:20.772Z
8632284 8632284 20251127204738_0i3F9 UK00C1 2025-11-29T14:17:12.738Z 2025-12-05T14:56:19.307Z
8632021 8632021 20251127202340_Qda5V UK00C1 2025-11-29T14:16:40.991Z 2025-12-05T14:56:14.493Z
8631931 8631931 20251127201530_7cXFk UK00C1 2025-11-29T14:16:35.027Z 2025-12-05T14:56:13.562Z
8631888 8631888 20251127201233_klj21 UK00C1 2025-11-29T14:16:31.492Z 2025-12-05T14:56:12.992Z
8631883 8631883 20251127201011_hsvVa UK00C1 2025-11-29T14:16:31.001Z 2025-12-05T14:56:12.895Z
8631791 8631791 20251127200105_bsO7k UK00C1 2025-11-29T14:16:23.813Z 2025-12-05T14:56:11.742Z
8631575 8631575 20251127192732_7SxYD UK00C1 2025-11-29T14:15:46.789Z 2025-12-05T14:56:08.839Z
8616467 8616467 20251126060137_jRsdU UK00C1 2025-11-27T14:31:12.674Z 2025-12-04T15:11:39.731Z
8616354 8616354 20251126055221_REXhR UK00C1 2025-11-27T14:31:05.520Z 2025-12-04T15:11:38.101Z
8615730 8615730 20251126051447_2xkq9 UK00C1 2025-11-27T14:30:06.613Z 2025-12-04T15:11:31.562Z
8615067 8615067 20251126044316_L1rB4 UK00C1 2025-11-27T14:28:57.789Z 2025-12-04T15:11:25.767Z
8614211 8614211 20251126035810_Q0RlQ UK00C1 2025-11-27T14:27:39.614Z 2025-12-04T15:10:32.034Z
8614147 8614147 20251126035351_pVWmn UK00C1 2025-11-27T14:27:23.273Z 2025-12-04T15:10:25.320Z
8614106 8614106 20251126035138_5Zzoa UK00C1 2025-11-27T14:27:13.491Z 2025-12-04T15:10:21.461Z
8613926 8613926 20251126034149_2QqsJ UK00C1 2025-11-27T14:26:58.224Z 2025-12-04T15:09:53.769Z
8613798 8613798 20251126033401_rvA6b UK00C1 2025-11-27T14:26:38.142Z 2025-12-04T15:09:51.827Z
8613519 8613519 20251126032007_0pjPm UK00C1 2025-11-27T14:26:10.127Z 2025-12-04T15:09:41.431Z
8613284 8613284 20251126031303_KWTui UK00C1 2025-11-27T14:25:36.336Z 2025-12-04T15:09:39.521Z
8612659 8612659 20251126024137_h44Z0 UK00C1 2025-11-27T14:24:26.337Z 2025-12-04T15:09:32.548Z

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