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 = "UK0024" 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
9272821 9272821 20260128034222_0pT02 UK0024 2026-01-29T14:27:54.499Z 2026-01-29T14:30:25.577Z
9259978 9259978 20260125014214_R0EQ7 UK0024 2026-01-26T14:19:39.190Z 2026-01-29T14:43:38.916Z
9242826 9242826 20260121025140_k49Pw UK0024 2026-01-22T14:19:28.490Z 2026-01-29T15:04:23.133Z
9242420 9242420 20260121014828_locte UK0024 2026-01-22T14:17:48.888Z 2026-01-29T15:03:58.052Z
9242395 9242395 20260121014513_YiZXK UK0024 2026-01-22T14:17:37.071Z 2026-01-29T15:03:56.949Z
9242331 9242331 20260121013240_CP3wp UK0024 2026-01-22T14:17:22.718Z 2026-01-29T15:03:44.738Z
9242305 9242305 20260121012518_TGpzJ UK0024 2026-01-22T14:17:18.259Z 2026-01-29T15:03:43.568Z
9242261 9242261 20260121011506_axhXf UK0024 2026-01-22T14:17:05.272Z 2026-01-29T15:03:39.130Z
9242197 9242197 20260121005958_CPCeo UK0024 2026-01-22T14:16:52.046Z 2026-01-29T15:03:36.412Z
9242152 9242152 20260121004311_M3jGI UK0024 2026-01-22T14:16:33.701Z 2026-01-29T15:03:33.846Z
9222076 9222076 20260117180225_KEMhI UK0024 2026-01-19T14:13:08.476Z 2026-01-26T15:00:37.247Z
9218642 9218642 20260117050249_LjOVR UK0024 2026-01-18T14:13:02.138Z 2026-01-25T14:58:33.977Z
9218633 9218633 20260117050108_a0eK3 UK0024 2026-01-18T14:13:00.165Z 2026-01-25T14:58:33.733Z
9218569 9218569 20260117044230_UpW7N UK0024 2026-01-18T14:12:42.352Z 2026-01-25T14:58:30.588Z
9218110 9218110 20260117001234_g0cr2 UK0024 2026-01-18T14:10:31.152Z 2026-01-25T14:58:00.512Z
9214528 9214528 20260116064935_w61OW UK0024 2026-01-17T14:21:56.543Z 2026-01-24T15:13:49.455Z
9214053 9214053 20260116052754_19ads UK0024 2026-01-17T14:19:50.239Z 2026-01-24T15:13:00.928Z
9213995 9213995 20260116051227_hZfhx UK0024 2026-01-17T14:19:33.672Z 2026-01-24T15:12:56.626Z
9213986 9213986 20260116051155_v09X6 UK0024 2026-01-17T14:19:32.000Z 2026-01-24T15:12:56.188Z
9213604 9213604 20260116040809_AOf9W UK0024 2026-01-17T14:17:44.275Z 2026-01-24T15:12:24.398Z
9213517 9213517 20260116035152_nBpON UK0024 2026-01-17T14:17:19.492Z 2026-01-24T15:12:19.363Z
9213397 9213397 20260116032140_RW3CU UK0024 2026-01-17T14:16:44.386Z 2026-01-24T15:12:11.910Z
9213328 9213328 20260116030819_8hOlo UK0024 2026-01-17T14:16:25.614Z 2026-01-24T15:12:09.483Z
9213278 9213278 20260116030237_sy2Qo UK0024 2026-01-17T14:16:15.567Z 2026-01-24T15:12:07.053Z
9204464 9204464 20260114064527_CLbPm UK0024 2026-01-15T14:27:25.109Z 2026-01-22T15:10:28.716Z
9204409 9204409 20260114063757_rjJ1e UK0024 2026-01-15T14:27:14.177Z 2026-01-22T15:10:27.521Z
9204398 9204398 20260114063623_BQOcw UK0024 2026-01-15T14:27:13.349Z 2026-01-22T15:10:27.320Z
9204269 9204269 20260114062237_Y06Eq UK0024 2026-01-15T14:26:57.031Z 2026-01-22T15:10:24.075Z
9204209 9204209 20260114061609_n3FMy UK0024 2026-01-15T14:26:50.296Z 2026-01-22T15:10:22.430Z
9204198 9204198 20260114061454_Yg3vd UK0024 2026-01-15T14:26:39.290Z 2026-01-22T15:10:22.194Z
9203413 9203413 20260114045437_KBnRL UK0024 2026-01-15T14:24:21.850Z 2026-01-22T15:10:07.213Z
9203355 9203355 20260114045245_xGLxR UK0024 2026-01-15T14:24:09.495Z 2026-01-22T15:10:06.256Z
9203195 9203195 20260114044235_O3TW4 UK0024 2026-01-15T14:23:39.060Z 2026-01-22T15:10:03.589Z
9203074 9203074 20260114043236_PKlJD UK0024 2026-01-15T14:23:16.221Z 2026-01-22T15:10:01.290Z
9202332 9202332 20260114033053_MXxyf UK0024 2026-01-15T14:21:05.721Z 2026-01-22T15:09:16.437Z
9201374 9201374 20260114021150_2tZvb UK0024 2026-01-15T14:18:23.311Z 2026-01-22T15:09:02.584Z
9201276 9201276 20260114020359_3sdfi UK0024 2026-01-15T14:18:08.524Z 2026-01-22T15:09:00.936Z
9201274 9201274 20260114020339_CZdmF UK0024 2026-01-15T14:18:07.991Z 2026-01-22T15:09:00.896Z
9201044 9201044 20260114013751_pur1v UK0024 2026-01-15T14:17:20.151Z 2026-01-22T15:08:54.333Z
9200901 9200901 20260114011909_t39ON UK0024 2026-01-15T14:16:49.925Z 2026-01-22T15:08:34.002Z
9200578 9200578 20260114002902_gxiLE UK0024 2026-01-15T14:15:40.745Z 2026-01-22T15:08:19.367Z
9200547 9200547 20260114002243_AIer3 UK0024 2026-01-15T14:15:30.467Z 2026-01-22T15:08:18.070Z
9194294 9194294 20260112193811_kd2HM UK0024 2026-01-14T14:08:32.597Z 2026-01-21T15:03:47.378Z
9194290 9194290 20260112193810_9dU15 UK0024 2026-01-14T14:08:31.872Z 2026-01-21T15:03:47.376Z
9180642 9180642 20260110212040_Nnhzh UK0024 2026-01-12T14:07:50.908Z 2026-01-19T15:16:25.977Z
9180607 9180607 20260110210752_IXH2o UK0024 2026-01-12T14:07:41.285Z 2026-01-19T15:16:24.414Z
9176797 9176797 20260110062258_vRtVY UK0024 2026-01-11T14:10:01.044Z 2026-01-18T15:08:54.394Z
9176561 9176561 20260110054249_02msg UK0024 2026-01-11T14:09:19.635Z 2026-01-18T15:08:43.720Z
9176430 9176430 20260110052921_tFHri UK0024 2026-01-11T14:08:59.881Z 2026-01-18T15:08:38.893Z
9176401 9176401 20260110052622_Tw09M UK0024 2026-01-11T14:08:54.781Z 2026-01-18T15:08:37.862Z
9176373 9176373 20260110052232_XUgaO UK0024 2026-01-11T14:08:50.602Z 2026-01-18T15:08:36.574Z
9176366 9176366 20260110052231_vYJhJ UK0024 2026-01-11T14:08:49.643Z 2026-01-18T15:08:36.151Z
9176316 9176316 20260110051443_OUiuZ UK0024 2026-01-11T14:08:43.205Z 2026-01-18T15:08:34.408Z
9175951 9175951 20260110042714_hsmCh UK0024 2026-01-11T14:07:52.398Z 2026-01-18T15:08:14.499Z
9175918 9175918 20260110041558_K224v UK0024 2026-01-11T14:07:47.866Z 2026-01-18T15:08:13.247Z
9175808 9175808 20260110034918_27oUf UK0024 2026-01-11T14:07:25.278Z 2026-01-18T15:08:08.953Z
9175771 9175771 20260110034639_RlF29 UK0024 2026-01-11T14:07:20.223Z 2026-01-18T15:08:07.856Z
9175167 9175167 20260110013058_IgQvG UK0024 2026-01-11T14:05:36.071Z 2026-01-18T15:07:35.402Z
9175083 9175083 20260110010258_8XP8v UK0024 2026-01-11T14:05:20.450Z 2026-01-18T15:07:25.323Z
9175021 9175021 20260110004643_f8OfD UK0024 2026-01-11T14:05:10.199Z 2026-01-18T15:07:23.382Z
9174891 9174891 20260109234739_18jZr UK0024 2026-01-11T14:04:45.642Z 2026-01-18T15:07:15.613Z
9174789 9174789 20260109225938_Gczpy UK0024 2026-01-11T14:04:24.550Z 2026-01-18T15:07:11.071Z
9174769 9174769 20260109223151_Es9Mb UK0024 2026-01-11T14:04:20.173Z 2026-01-18T15:07:10.130Z
9174673 9174673 20260109213829_B9Vs8 UK0024 2026-01-11T14:04:00.591Z 2026-01-18T15:06:57.561Z
9174656 9174656 20260109212908_f54cb UK0024 2026-01-11T14:03:57.554Z 2026-01-18T15:06:56.959Z
9174409 9174409 20260109180836_4I4aK UK0024 2026-01-11T14:03:04.191Z 2026-01-18T15:06:44.372Z
9174407 9174407 20260109180750_s7trx UK0024 2026-01-11T14:03:03.404Z 2026-01-18T15:06:44.218Z
9163208 9163208 20260107060751_CrZ2G UK0024 2026-01-08T14:08:26.735Z 2026-01-13T15:03:05.798Z
9162663 9162663 20260107035800_qHW7l UK0024 2026-01-08T14:06:17.553Z 2026-01-13T15:02:32.633Z
9162636 9162636 20260107035044_bgggc UK0024 2026-01-08T14:06:05.685Z 2026-01-13T15:02:30.221Z
9162561 9162561 20260107032835_bQk6H UK0024 2026-01-08T14:05:45.309Z 2026-01-13T15:02:18.989Z
9162467 9162467 20260107030044_nZ6Vl UK0024 2026-01-08T14:05:22.706Z 2026-01-13T15:02:11.904Z
9162399 9162399 20260107024024_DyAvm UK0024 2026-01-08T14:04:58.936Z 2026-01-13T15:02:07.010Z
9162192 9162192 20260107001048_K1BY4 UK0024 2026-01-08T14:03:27.287Z 2026-01-13T15:01:44.238Z
9159920 9159920 20260106041824_CFgFd UK0024 2026-01-07T14:10:49.465Z 2026-01-13T15:08:53.147Z
9159173 9159173 20260106020115_XBigY UK0024 2026-01-07T14:08:35.068Z 2026-01-13T15:08:11.510Z
9158911 9158911 20260106005103_vCJAG UK0024 2026-01-07T14:07:37.796Z 2026-01-13T15:07:50.304Z
9158878 9158878 20260106004513_V1wp0 UK0024 2026-01-07T14:07:32.813Z 2026-01-13T15:07:49.523Z
9158870 9158870 20260106004512_jIUFP UK0024 2026-01-07T14:07:31.916Z 2026-01-13T15:07:49.295Z
9158623 9158623 20260105235053_doVq2 UK0024 2026-01-07T14:06:46.910Z 2026-01-13T15:07:39.216Z
9158476 9158476 20260105224036_gJtpd UK0024 2026-01-07T14:06:15.153Z 2026-01-13T15:07:24.333Z
9158307 9158307 20260105215355_ehzMD UK0024 2026-01-07T14:05:43.828Z 2026-01-13T15:07:17.792Z
9158106 9158106 20260105200757_UEe1l UK0024 2026-01-07T14:04:54.023Z 2026-01-13T15:06:55.675Z
9158040 9158040 20260105194329_wq5xi UK0024 2026-01-07T14:04:35.191Z 2026-01-13T15:06:50.800Z
9157959 9157959 20260105193445_HZyx2 UK0024 2026-01-07T14:04:21.475Z 2026-01-13T15:06:48.013Z
9157578 9157578 20260105175924_REOxs UK0024 2026-01-07T14:02:42.649Z 2026-01-13T15:06:18.369Z
9153135 9153135 20260103205220_UQ2Ju UK0024 2026-01-06T14:23:12.136Z 2026-01-12T15:01:53.429Z
9150121 9150121 20260105010634_Y1yje UK0024 2026-01-06T14:08:38.879Z 2026-01-13T15:13:05.928Z
9149890 9149890 20260105000310_v7Lpd UK0024 2026-01-06T14:07:40.355Z 2026-01-13T15:12:44.414Z
9149883 9149883 20260105000310_zrSak UK0024 2026-01-06T14:07:39.697Z 2026-01-13T15:12:44.256Z
9149538 9149538 20260104214025_OevkI UK0024 2026-01-06T14:05:53.569Z 2026-01-13T15:12:16.417Z
9149525 9149525 20260104213422_r0UxZ UK0024 2026-01-06T14:05:49.755Z 2026-01-13T15:12:15.714Z
9148332 9148332 20260103173935_E9Yr8 UK0024 2026-01-05T14:30:25.066Z 2026-01-10T15:04:26.116Z
9144339 9144339 20260104024046_aIQTV UK0024 2026-01-05T14:18:57.572Z 2026-01-12T15:07:04.562Z
9143040 9143040 20260104015453_xtZVx UK0024 2026-01-05T14:16:52.573Z 2026-01-12T15:06:12.528Z
9142755 9142755 20260104014654_Zh7AD UK0024 2026-01-05T14:16:35.661Z 2026-01-12T15:05:53.693Z
9142608 9142608 20260104014120_DBuoG UK0024 2026-01-05T14:16:14.207Z 2026-01-12T15:05:47.645Z
9142362 9142362 20260104013224_Q28WF UK0024 2026-01-05T14:16:01.757Z 2026-01-12T15:05:41.654Z
9142342 9142342 20260104013144_ElQ3j UK0024 2026-01-05T14:15:59.702Z 2026-01-12T15:05:40.679Z
9142231 9142231 20260104012651_Aqjgs UK0024 2026-01-05T14:15:42.018Z 2026-01-12T15:05:37.488Z

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