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

7,470 rows where station_code = "UK007Z" 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
9223294 9223294 20260118000754_NILK6 UK007Z 2026-01-19T14:18:36.151Z 2026-01-26T15:02:01.299Z
9223230 9223230 20260117235016_dOWPB UK007Z 2026-01-19T14:18:19.928Z 2026-01-26T15:01:58.814Z
9223177 9223177 20260117233350_pNOkp UK007Z 2026-01-19T14:18:01.608Z 2026-01-26T15:01:56.800Z
9217972 9217972 20260116211432_HLoeR UK007Z 2026-01-18T14:09:48.264Z 2026-01-25T14:57:53.600Z
9217781 9217781 20260116194554_B8Xpu UK007Z 2026-01-18T14:08:59.060Z 2026-01-25T14:57:47.564Z
9214468 9214468 20260116064136_wg53G UK007Z 2026-01-17T14:21:38.330Z 2026-01-24T15:13:38.776Z
9214432 9214432 20260116063354_xQvgz UK007Z 2026-01-17T14:21:31.544Z 2026-01-24T15:13:37.099Z
9214359 9214359 20260116062227_NKgFP UK007Z 2026-01-17T14:21:11.062Z 2026-01-24T15:13:31.426Z
9214358 9214358 20260116062146_jOr2e UK007Z 2026-01-17T14:21:10.531Z 2026-01-24T15:13:31.329Z
9214314 9214314 20260116061339_Eeq7c UK007Z 2026-01-17T14:21:02.597Z 2026-01-24T15:13:29.543Z
9214289 9214289 20260116060815_PS4Bq UK007Z 2026-01-17T14:20:58.865Z 2026-01-24T15:13:28.752Z
9214264 9214264 20260116060249_CbUy8 UK007Z 2026-01-17T14:20:48.425Z 2026-01-24T15:13:26.806Z
9214075 9214075 20260116053137_WKbUx UK007Z 2026-01-17T14:19:58.051Z 2026-01-24T15:13:04.132Z
9214049 9214049 20260116052708_kwQ4c UK007Z 2026-01-17T14:19:49.178Z 2026-01-24T15:13:00.550Z
9213867 9213867 20260116045630_ri96Z UK007Z 2026-01-17T14:18:52.381Z 2026-01-24T15:12:49.557Z
9213780 9213780 20260116044034_mUFdP UK007Z 2026-01-17T14:18:28.471Z 2026-01-24T15:12:46.269Z
9213573 9213573 20260116040455_N6oTM UK007Z 2026-01-17T14:17:38.524Z 2026-01-24T15:12:23.019Z
9213566 9213566 20260116040242_l1SUu UK007Z 2026-01-17T14:17:37.516Z 2026-01-24T15:12:22.794Z
9213428 9213428 20260116033004_fm3cu UK007Z 2026-01-17T14:16:51.647Z 2026-01-24T15:12:13.485Z
9213287 9213287 20260116030332_7rwUF UK007Z 2026-01-17T14:16:17.744Z 2026-01-24T15:12:07.501Z
9213252 9213252 20260116025112_eqv9m UK007Z 2026-01-17T14:16:08.533Z 2026-01-24T15:11:58.993Z
9213218 9213218 20260116023744_aT935 UK007Z 2026-01-17T14:15:57.426Z 2026-01-24T15:11:49.883Z
9213140 9213140 20260116022423_IbYxP UK007Z 2026-01-17T14:15:36.619Z 2026-01-24T15:11:44.195Z
9213116 9213116 20260116021642_fHk9k UK007Z 2026-01-17T14:15:30.688Z 2026-01-24T15:11:42.559Z
9213091 9213091 20260116020928_UcRYr UK007Z 2026-01-17T14:15:23.360Z 2026-01-24T15:11:40.218Z
9213074 9213074 20260116020756_APO4M UK007Z 2026-01-17T14:15:17.667Z 2026-01-24T15:11:39.767Z
9213058 9213058 20260116020424_yZbxx UK007Z 2026-01-17T14:15:12.140Z 2026-01-24T15:11:38.892Z
9212913 9212913 20260116013753_qXFlF UK007Z 2026-01-17T14:14:32.161Z 2026-01-24T15:11:33.914Z
9212788 9212788 20260116005934_nnfb6 UK007Z 2026-01-17T14:13:55.111Z 2026-01-24T15:11:26.683Z
9212759 9212759 20260116005246_31Quh UK007Z 2026-01-17T14:13:41.918Z 2026-01-24T15:11:25.325Z
9212755 9212755 20260116005007_gj9Ax UK007Z 2026-01-17T14:13:39.314Z 2026-01-24T15:11:25.089Z
9212492 9212492 20260115221546_L0Bf1 UK007Z 2026-01-17T14:12:13.124Z 2026-01-24T15:10:57.732Z
9212456 9212456 20260115213334_jaT3Q UK007Z 2026-01-17T14:11:57.805Z 2026-01-24T15:10:55.416Z
9212087 9212087 20260115190926_Zmyc1 UK007Z 2026-01-17T14:09:53.084Z 2026-01-24T15:10:22.893Z
9212082 9212082 20260115190516_uwhGG UK007Z 2026-01-17T14:09:51.171Z 2026-01-24T15:10:22.391Z
9211847 9211847 20260115180545_XotYX UK007Z 2026-01-17T14:08:47.039Z 2026-01-24T15:10:06.382Z
9205581 9205581 20260113202340_cLtjz UK007Z 2026-01-15T14:31:31.766Z 2026-01-22T15:07:29.633Z
9201776 9201776 20260114025057_3K2Mr UK007Z 2026-01-15T14:19:42.430Z 2026-01-22T15:09:09.428Z
9201404 9201404 20260114021430_8yR7D UK007Z 2026-01-15T14:18:34.151Z 2026-01-22T15:09:03.102Z
9201147 9201147 20260114014856_FVwHa UK007Z 2026-01-15T14:17:39.323Z 2026-01-22T15:08:58.514Z
9200722 9200722 20260114005702_N8VNO UK007Z 2026-01-15T14:16:13.442Z 2026-01-22T15:08:24.634Z
9200635 9200635 20260114004032_o73pi UK007Z 2026-01-15T14:15:51.078Z 2026-01-22T15:08:22.387Z
9200430 9200430 20260114000744_3XWQx UK007Z 2026-01-15T14:15:11.764Z 2026-01-22T15:08:15.896Z
9200397 9200397 20260113235851_KpKtW UK007Z 2026-01-15T14:15:00.452Z 2026-01-22T15:08:15.308Z
9200387 9200387 20260113235627_4jh7p UK007Z 2026-01-15T14:14:58.689Z 2026-01-22T15:08:15.183Z
9200355 9200355 20260113235135_ujo5M UK007Z 2026-01-15T14:14:49.287Z 2026-01-22T15:08:14.555Z
9200219 9200219 20260113231437_AEGHm UK007Z 2026-01-15T14:14:14.302Z 2026-01-22T15:08:11.626Z
9200213 9200213 20260113231135_7durH UK007Z 2026-01-15T14:14:12.482Z 2026-01-22T15:08:11.421Z
9200145 9200145 20260113230045_I3605 UK007Z 2026-01-15T14:14:02.771Z 2026-01-22T15:08:10.452Z
9200005 9200005 20260113221943_2WN8v UK007Z 2026-01-15T14:13:30.256Z 2026-01-22T15:08:07.493Z
9199927 9199927 20260113215823_Qbxa6 UK007Z 2026-01-15T14:13:05.745Z 2026-01-22T15:08:05.632Z
9199645 9199645 20260113204336_Al7Nz UK007Z 2026-01-15T14:11:52.560Z 2026-01-22T15:07:58.511Z
9199556 9199556 20260113202339_rZY3C UK007Z 2026-01-15T14:11:27.416Z 2026-01-22T15:07:29.041Z
9199367 9199367 20260113195208_w2AfN UK007Z 2026-01-15T14:10:36.840Z 2026-01-22T15:07:22.828Z
9199059 9199059 20260113185639_VjBlX UK007Z 2026-01-15T14:09:04.032Z 2026-01-22T15:07:12.970Z
9189987 9189987 20260112071701_snVYj UK007Z 2026-01-13T14:20:12.778Z 2026-01-20T15:24:01.141Z
9189953 9189953 20260112070629_28VMw UK007Z 2026-01-13T14:20:06.240Z 2026-01-20T15:23:49.254Z
9189899 9189899 20260112064907_GZ3p6 UK007Z 2026-01-13T14:19:49.619Z 2026-01-20T15:23:46.396Z
9189700 9189700 20260112055540_SP3Ra UK007Z 2026-01-13T14:18:55.949Z 2026-01-20T15:23:36.004Z
9189675 9189675 20260112054616_3lpXp UK007Z 2026-01-13T14:18:49.422Z 2026-01-20T15:23:34.401Z
9189630 9189630 20260112053045_tFOl7 UK007Z 2026-01-13T14:18:36.485Z 2026-01-20T15:23:32.283Z
9189514 9189514 20260112044955_aMdk7 UK007Z 2026-01-13T14:18:00.408Z 2026-01-20T15:23:15.898Z
9171313 9171313 20260108210116_tSJZ6 UK007Z 2026-01-10T14:06:40.892Z 2026-01-17T15:23:43.643Z
9171121 9171121 20260108192444_dlVsU UK007Z 2026-01-10T14:05:24.995Z 2026-01-17T15:23:24.702Z
9116900 9116900 20251231071716_S0fV1 UK007Z 2026-01-01T14:29:22.634Z 2026-01-08T15:12:16.468Z
9116889 9116889 20251231070802_Ds4h3 UK007Z 2026-01-01T14:29:19.577Z 2026-01-08T15:12:15.933Z
9116782 9116782 20251231064742_wY4Et UK007Z 2026-01-01T14:28:54.483Z 2026-01-08T15:12:10.710Z
9116670 9116670 20251231063543_jD8Gj UK007Z 2026-01-01T14:28:39.473Z 2026-01-08T15:12:06.589Z
9116546 9116546 20251231062431_qnBII UK007Z 2026-01-01T14:28:22.244Z 2026-01-08T15:11:54.740Z
9116252 9116252 20251231055835_dOGmg UK007Z 2026-01-01T14:27:35.267Z 2026-01-08T15:11:40.348Z
9116058 9116058 20251231054825_hmZY5 UK007Z 2026-01-01T14:27:14.770Z 2026-01-08T15:11:25.889Z
9115967 9115967 20251231053619_bLPt5 UK007Z 2026-01-01T14:26:52.199Z 2026-01-08T15:11:18.564Z
9115464 9115464 20251231050815_WBz32 UK007Z 2026-01-01T14:25:30.477Z 2026-01-01T14:57:54.228Z
9115368 9115368 20251231050333_jCHQ6 UK007Z 2026-01-01T14:25:15.493Z 2026-01-08T15:10:45.175Z
9115361 9115361 20251231050153_q2JBQ UK007Z 2026-01-01T14:25:13.818Z 2026-01-08T15:10:44.539Z
9115328 9115328 20251231045911_QxPWk UK007Z 2026-01-01T14:25:04.512Z 2026-01-08T15:10:42.690Z
9115323 9115323 20251231045858_zOIU1 UK007Z 2026-01-01T14:25:03.413Z 2026-01-08T15:10:42.218Z
9115046 9115046 20251231044408_yJuhe UK007Z 2026-01-01T14:24:14.537Z 2026-01-08T15:10:21.044Z
9114958 9114958 20251231043731_zxnIx UK007Z 2026-01-01T14:23:53.821Z 2026-01-08T15:10:16.381Z
9113764 9113764 20251231034810_sQOIO UK007Z 2026-01-01T14:20:22.059Z 2026-01-08T15:09:08.451Z
9113337 9113337 20251231032403_x70F8 UK007Z 2026-01-01T14:18:34.782Z 2026-01-08T15:08:39.980Z
9104110 9104110 20251230053120_bzAw2 UK007Z 2025-12-31T14:20:21.531Z 2026-01-07T15:09:30.978Z
9072870 9072870 20251225052813_ig62W UK007Z 2025-12-29T14:56:43.258Z 2026-01-02T15:45:08.947Z
9051877 9051877 20251227001750_u3eTh UK007Z 2025-12-29T14:08:12.744Z 2026-01-04T15:25:03.496Z
9044139 9044139 20251224220925_vNaL3 UK007Z 2025-12-28T14:48:24.341Z 2026-01-01T15:57:29.133Z
9044062 9044062 20251224220314_szYLf UK007Z 2025-12-28T14:48:20.850Z 2026-01-01T15:57:28.291Z
9043956 9043956 20251224214319_PjdZe UK007Z 2025-12-28T14:48:15.048Z 2026-01-01T15:57:25.193Z
9043792 9043792 20251224212059_IGnzU UK007Z 2025-12-28T14:48:07.921Z 2026-01-01T15:57:22.951Z
9043564 9043564 20251224204557_OOyla UK007Z 2025-12-28T14:47:38.398Z 2026-01-01T15:57:20.255Z
9043527 9043527 20251224203939_8wmRX UK007Z 2025-12-28T14:47:36.043Z 2026-01-01T15:57:19.775Z
9043247 9043247 20251224200059_qNSuo UK007Z 2025-12-28T14:47:03.371Z 2026-01-01T15:57:16.694Z
9043190 9043190 20251224195232_recvg UK007Z 2025-12-28T14:46:59.499Z 2026-01-01T15:57:15.675Z
9043024 9043024 20251224193155_2I5g8 UK007Z 2025-12-28T14:46:49.034Z 2026-01-01T15:57:13.652Z
9032730 9032730 20251225071628_7hjf7 UK007Z 2025-12-28T14:23:37.166Z 2026-01-02T15:45:47.792Z
9032719 9032719 20251225070752_tHOXK UK007Z 2025-12-28T14:23:34.540Z 2026-01-02T15:45:47.470Z
9032716 9032716 20251225070654_sPfiW UK007Z 2025-12-28T14:23:34.089Z 2026-01-02T15:45:47.390Z
9032701 9032701 20251225065633_BLl7X UK007Z 2025-12-28T14:23:24.952Z 2026-01-02T15:45:46.814Z
9032559 9032559 20251225063810_jbPlh UK007Z 2025-12-28T14:23:01.205Z 2026-01-02T15:45:45.502Z
9032514 9032514 20251225063055_wtjXM UK007Z 2025-12-28T14:22:57.201Z 2026-01-02T15:45:44.994Z
9032155 9032155 20251225060547_LsWEb UK007Z 2025-12-28T14:22:17.376Z 2025-12-29T14:56:52.843Z

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