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,330 rows where station_code = "UK0060" 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
9272574 9272574 20260128024006_2WYj3 UK0060 2026-01-29T14:27:11.410Z 2026-01-29T14:30:25.379Z
9272328 9272328 20260128013712_gT4Rf UK0060 2026-01-29T14:26:26.482Z 2026-01-29T14:30:25.330Z
9272254 9272254 20260128010248_KV51j UK0060 2026-01-29T14:26:07.864Z 2026-01-29T14:30:25.317Z
9243337 9243337 20260121041651_tnzpB UK0060 2026-01-22T14:21:28.765Z 2026-01-29T15:04:56.239Z
9243269 9243269 20260121040703_Q48z5 UK0060 2026-01-22T14:21:09.568Z 2026-01-29T15:04:53.114Z
9243062 9243062 20260121034002_fUHM0 UK0060 2026-01-22T14:20:27.002Z 2026-01-29T15:04:45.544Z
9242905 9242905 20260121031311_y2qfB UK0060 2026-01-22T14:19:43.382Z 2026-01-29T15:04:29.088Z
9242899 9242899 20260121031104_7WKP5 UK0060 2026-01-22T14:19:42.260Z 2026-01-29T15:04:28.862Z
9242882 9242882 20260121030753_24OuR UK0060 2026-01-22T14:19:38.994Z 2026-01-29T15:04:26.720Z
9242845 9242845 20260121025826_3aAAJ UK0060 2026-01-22T14:19:32.084Z 2026-01-29T15:04:24.103Z
9242827 9242827 20260121025140_k49Pw UK0060 2026-01-22T14:19:28.490Z 2026-01-29T15:04:23.133Z
9242596 9242596 20260121022336_Evb5a UK0060 2026-01-22T14:18:31.078Z 2026-01-29T15:04:13.148Z
9242544 9242544 20260121021227_yC73t UK0060 2026-01-22T14:18:22.616Z 2026-01-29T15:04:06.844Z
9242396 9242396 20260121014513_YiZXK UK0060 2026-01-22T14:17:37.071Z 2026-01-29T15:03:56.949Z
9242307 9242307 20260121012518_TGpzJ UK0060 2026-01-22T14:17:18.260Z 2026-01-29T15:03:43.568Z
9242290 9242290 20260121012345_Ixlwn UK0060 2026-01-22T14:17:15.546Z 2026-01-29T15:03:42.607Z
9242153 9242153 20260121004311_M3jGI UK0060 2026-01-22T14:16:33.728Z 2026-01-29T15:03:33.846Z
9234429 9234429 20260119212708_tbACC UK0060 2026-01-21T14:14:26.402Z 2026-01-28T14:57:45.685Z
9234400 9234400 20260119211343_5UYaD UK0060 2026-01-21T14:14:11.255Z 2026-01-28T14:57:36.718Z
9222115 9222115 20260117181239_Dgh2s UK0060 2026-01-19T14:13:22.208Z 2026-01-26T15:00:38.987Z
9217569 9217569 20260116175957_ZkMwY UK0060 2026-01-18T14:07:59.787Z 2026-01-25T14:57:26.459Z
9214457 9214457 20260116063849_jnD2Z UK0060 2026-01-17T14:21:36.992Z 2026-01-24T15:13:38.372Z
9212685 9212685 20260116002158_aBu5k UK0060 2026-01-17T14:13:16.253Z 2026-01-24T15:11:09.978Z
8767954 8767954 20251211033934_1F45Y UK0060 2025-12-14T15:36:33.929Z 2025-12-19T15:16:42.997Z
8767952 8767952 20251211025635_Xz089 UK0060 2025-12-14T15:35:53.433Z 2025-12-19T15:16:23.966Z
8767950 8767950 20251211022804_YIE73 UK0060 2025-12-14T15:35:32.548Z 2025-12-19T15:15:58.361Z
8767948 8767948 20251211022649_33DCK UK0060 2025-12-14T15:35:31.900Z 2025-12-19T15:15:57.887Z
8767945 8767945 20251211021723_yWQqY UK0060 2025-12-14T15:35:09.228Z 2025-12-19T15:15:55.053Z
8767940 8767940 20251211012251_RGnu2 UK0060 2025-12-14T15:34:30.544Z 2025-12-19T15:15:15.727Z
8767938 8767938 20251211012029_Nj3Ws UK0060 2025-12-14T15:34:29.474Z 2025-12-19T15:15:14.630Z
8767935 8767935 20251211010905_qCqeq UK0060 2025-12-14T15:34:11.580Z 2025-12-19T15:15:11.039Z
8767934 8767934 20251211004032_MXJjG UK0060 2025-12-14T15:33:49.827Z 2025-12-19T15:14:33.682Z
8767932 8767932 20251211003740_M51Jv UK0060 2025-12-14T15:33:48.716Z 2025-12-19T15:14:32.879Z
8767929 8767929 20251211001524_TnxCo UK0060 2025-12-14T15:33:40.895Z 2025-12-19T15:14:23.059Z
8767927 8767927 20251211001444_Aca1U UK0060 2025-12-14T15:33:40.511Z 2025-12-19T15:14:22.752Z
8767924 8767924 20251211001253_zxzYK UK0060 2025-12-14T15:33:39.772Z 2025-12-19T15:14:22.378Z
8767919 8767919 20251211000355_UOhbD UK0060 2025-12-14T15:33:38.113Z 2025-12-19T15:14:21.093Z
8767901 8767901 20251210211600_mQ26V UK0060 2025-12-14T15:30:47.634Z 2025-12-19T15:12:30.272Z
8767899 8767899 20251210202955_MoFwi UK0060 2025-12-14T15:30:13.455Z 2025-12-19T15:11:58.648Z
8767890 8767890 20251210184742_haBKc UK0060 2025-12-14T15:29:20.429Z 2025-12-19T15:11:17.144Z
8767250 8767250 20251211062106_oKOg4 UK0060 2025-12-14T14:59:39.674Z 2025-12-20T14:22:13.692Z
8706750 8706750 20251207232522_2S05x UK0060 2025-12-09T14:24:59.548Z 2025-12-16T15:12:35.873Z
8706647 8706647 20251207225824_xUJYq UK0060 2025-12-09T14:24:49.320Z 2025-12-16T15:12:34.217Z
8706636 8706636 20251207225552_3yRT7 UK0060 2025-12-09T14:24:48.545Z 2025-12-16T15:12:34.078Z
8706530 8706530 20251207222148_xq0rP UK0060 2025-12-09T14:24:26.388Z 2025-12-16T15:12:32.946Z
8706348 8706348 20251207211727_gPwq3 UK0060 2025-12-09T14:24:05.829Z 2025-12-16T15:12:29.992Z
8706100 8706100 20251207192156_LtUhO UK0060 2025-12-09T14:23:09.451Z 2025-12-16T15:11:55.066Z
8706093 8706093 20251207192155_SdlJQ UK0060 2025-12-09T14:23:08.929Z 2025-12-16T15:11:54.913Z
8706088 8706088 20251207191907_4hQaY UK0060 2025-12-09T14:23:07.790Z 2025-12-16T15:11:54.790Z
8698990 8698990 20251206192853_2Rdkf UK0060 2025-12-08T14:19:54.489Z 2025-12-15T15:30:03.321Z
8682969 8682969 20251203061701_diBO9 UK0060 2025-12-04T14:18:24.053Z 2025-12-11T14:47:29.160Z
8682951 8682951 20251203061700_TDsgd UK0060 2025-12-04T14:18:23.830Z 2025-12-11T14:47:29.112Z
8682767 8682767 20251203060230_hoARe UK0060 2025-12-04T14:17:59.168Z 2025-12-11T14:47:25.596Z
8682747 8682747 20251203060131_VwDNX UK0060 2025-12-04T14:17:57.855Z 2025-12-11T14:47:25.301Z
8682725 8682725 20251203060113_uGIfl UK0060 2025-12-04T14:17:56.730Z 2025-12-11T14:47:25.109Z
8682251 8682251 20251203050730_g3Cx4 UK0060 2025-12-04T14:16:41.238Z 2025-12-11T14:47:14.467Z
8681952 8681952 20251203043346_kVFxN UK0060 2025-12-04T14:16:03.102Z 2025-12-11T14:46:56.465Z
8676487 8676487 20251202055527_gyFsG UK0060 2025-12-03T14:25:14.529Z 2025-12-10T14:39:47.692Z
8676465 8676465 20251202055341_ruDut UK0060 2025-12-03T14:25:13.512Z 2025-12-10T14:39:47.516Z
8676208 8676208 20251202054114_sAnZN UK0060 2025-12-03T14:24:49.216Z 2025-12-10T14:39:45.388Z
8676080 8676080 20251202053511_glTZX UK0060 2025-12-03T14:24:40.778Z 2025-12-10T14:39:43.104Z
8675776 8675776 20251202051410_c0ChF UK0060 2025-12-03T14:24:14.919Z 2025-12-10T14:39:39.661Z
8675637 8675637 20251202050326_3Zc6C UK0060 2025-12-03T14:23:57.612Z 2025-12-10T14:39:37.325Z
8675320 8675320 20251202042822_zF1OH UK0060 2025-12-03T14:23:30.980Z 2025-12-10T14:39:33.712Z
8675227 8675227 20251202042009_EPGT9 UK0060 2025-12-03T14:23:22.208Z 2025-12-10T14:39:32.552Z
8675204 8675204 20251202041758_3s3pA UK0060 2025-12-03T14:23:20.656Z 2025-12-10T14:39:32.362Z
8674757 8674757 20251202032036_oWjBH UK0060 2025-12-03T14:22:18.352Z 2025-12-10T14:39:11.138Z
8674732 8674732 20251202031721_gO5YE UK0060 2025-12-03T14:22:16.489Z 2025-12-10T14:39:10.812Z
8674685 8674685 20251202030654_KY8Fp UK0060 2025-12-03T14:22:12.546Z 2025-12-10T14:39:09.296Z
8674238 8674238 20251202015312_pHR02 UK0060 2025-12-03T14:21:16.929Z 2025-12-10T14:39:00.524Z
8673989 8673989 20251202005816_muRzN UK0060 2025-12-03T14:20:41.232Z 2025-12-10T14:38:56.276Z
8673950 8673950 20251202004617_EGpAI UK0060 2025-12-03T14:20:25.826Z 2025-12-10T14:38:55.737Z
8667996 8667996 20251130053800_akTXj UK0060 2025-12-02T14:41:27.817Z 2025-12-08T14:56:38.263Z
8658075 8658075 20251130063634_aJkZv UK0060 2025-12-01T14:34:53.856Z 2025-12-08T14:56:46.632Z
8658053 8658053 20251130063254_ISE9l UK0060 2025-12-01T14:34:53.076Z 2025-12-08T14:56:46.382Z
8658002 8658002 20251130062708_h11XA UK0060 2025-12-01T14:34:49.194Z 2025-12-08T14:56:45.619Z
8657954 8657954 20251130062207_DRvvX UK0060 2025-12-01T14:34:47.456Z 2025-12-08T14:56:45.027Z
8657866 8657866 20251130061352_My5yj UK0060 2025-12-01T14:34:44.237Z 2025-12-08T14:56:43.846Z
8657841 8657841 20251130061122_kvhIi UK0060 2025-12-01T14:34:42.881Z 2025-12-08T14:56:43.456Z
8657732 8657732 20251130060405_xb680 UK0060 2025-12-01T14:34:39.371Z 2025-12-08T14:56:42.545Z
8657661 8657661 20251130055628_qz2ZG UK0060 2025-12-01T14:34:36.262Z 2025-12-08T14:56:41.538Z
8657508 8657508 20251130055001_KdbNj UK0060 2025-12-01T14:34:31.517Z 2025-12-08T14:56:40.403Z
8657455 8657455 20251130054649_ikd9Q UK0060 2025-12-01T14:34:28.252Z 2025-12-08T14:56:39.916Z
8657424 8657424 20251130054411_UR0Md UK0060 2025-12-01T14:34:25.421Z 2025-12-08T14:56:39.581Z
8657382 8657382 20251130054055_bfzkO UK0060 2025-12-01T14:34:19.151Z 2025-12-08T14:56:38.979Z
8657360 8657360 20251130054029_6HNo4 UK0060 2025-12-01T14:34:12.307Z 2025-12-08T14:56:38.810Z
8657331 8657331 20251130053851_Ce1V5 UK0060 2025-12-01T14:34:04.490Z 2025-12-08T14:56:38.524Z
8657282 8657282 20251130053805_KOaXS UK0060 2025-12-01T14:34:03.156Z 2025-12-08T14:56:38.268Z
8657208 8657208 20251130053337_llOfq UK0060 2025-12-01T14:34:00.691Z 2025-12-08T14:56:37.446Z
8657202 8657202 20251130053337_v3GbX UK0060 2025-12-01T14:34:00.497Z 2025-12-08T14:56:37.395Z
8656792 8656792 20251130050941_lgR34 UK0060 2025-12-01T14:29:00.829Z 2025-12-08T14:56:33.727Z
8656580 8656580 20251130050014_Z3ysx UK0060 2025-12-01T14:28:45.952Z 2025-12-08T14:56:22.454Z
8656429 8656429 20251130045602_Nw3vd UK0060 2025-12-01T14:28:38.417Z 2025-12-08T14:56:11.913Z
8656308 8656308 20251130044904_2thUo UK0060 2025-12-01T14:28:19.681Z 2025-12-08T14:56:10.656Z
8656237 8656237 20251130044514_ngvLX UK0060 2025-12-01T14:28:13.087Z 2025-12-01T14:28:13.087Z
8656025 8656025 20251130043114_r5VOe UK0060 2025-12-01T14:27:57.263Z 2025-12-08T14:56:05.338Z
8655728 8655728 20251130041351_VOOUA UK0060 2025-12-01T14:27:23.734Z 2025-12-08T14:56:02.027Z
8655409 8655409 20251130040130_cvDx4 UK0060 2025-12-01T14:26:53.236Z 2025-12-08T14:55:58.604Z
8655151 8655151 20251130034624_vlJCt UK0060 2025-12-01T14:26:35.965Z 2025-12-08T14:55:54.318Z
8655043 8655043 20251130034144_dBgfQ UK0060 2025-12-01T14:26:17.893Z 2025-12-08T14:55:45.071Z

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