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

3,559 rows where station_code = "UK0085" 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
9231176 9231176 20260119062036_f7u74 UK0085 2026-01-20T14:31:40.922Z 2026-01-27T15:06:03.612Z
9231171 9231171 20260119061702_nP3d6 UK0085 2026-01-20T14:31:39.992Z 2026-01-27T15:06:03.332Z
9230948 9230948 20260119053234_KoNE2 UK0085 2026-01-20T14:30:34.003Z 2026-01-27T15:05:46.310Z
9230827 9230827 20260119051447_26xAY UK0085 2026-01-20T14:29:58.841Z 2026-01-27T15:05:29.101Z
9230649 9230649 20260119044328_eF385 UK0085 2026-01-20T14:29:06.261Z 2026-01-27T15:05:18.668Z
9230401 9230401 20260119041406_Nbf7Q UK0085 2026-01-20T14:27:38.931Z 2026-01-27T15:04:52.694Z
9230247 9230247 20260119034543_sccJa UK0085 2026-01-20T14:26:49.026Z 2026-01-27T15:04:44.394Z
9223515 9223515 20260118010907_n8v9q UK0085 2026-01-19T14:19:42.367Z 2026-01-26T15:02:12.739Z
9223486 9223486 20260118005420_ImvqJ UK0085 2026-01-19T14:19:32.149Z 2026-01-26T15:02:10.464Z
9223391 9223391 20260118002947_d30c4 UK0085 2026-01-19T14:19:00.884Z 2026-01-26T15:02:04.898Z
9223327 9223327 20260118001509_C8kS8 UK0085 2026-01-19T14:18:47.198Z 2026-01-26T15:02:02.443Z
9214516 9214516 20260116064727_Ot2i6 UK0085 2026-01-17T14:21:50.439Z 2026-01-24T15:13:46.540Z
9214424 9214424 20260116063238_41OeR UK0085 2026-01-17T14:21:29.247Z 2026-01-24T15:13:36.495Z
9214419 9214419 20260116063006_FX3WI UK0085 2026-01-17T14:21:28.091Z 2026-01-24T15:13:35.994Z
9214387 9214387 20260116062737_JeBOl UK0085 2026-01-17T14:21:19.287Z 2026-01-24T15:13:33.337Z
9213954 9213954 20260116050457_6EN83 UK0085 2026-01-17T14:19:18.865Z 2026-01-24T15:12:53.324Z
9213898 9213898 20260116045719_G2vY5 UK0085 2026-01-17T14:19:01.462Z 2026-01-24T15:12:50.600Z
9213774 9213774 20260116043807_8Pc28 UK0085 2026-01-17T14:18:25.435Z 2026-01-24T15:12:45.894Z
9213722 9213722 20260116043043_GtwY3 UK0085 2026-01-17T14:18:15.082Z 2026-01-24T15:12:32.203Z
9213556 9213556 20260116040130_ZJj5G UK0085 2026-01-17T14:17:32.845Z 2026-01-24T15:12:22.139Z
9213447 9213447 20260116033328_3RwRH UK0085 2026-01-17T14:16:56.616Z 2026-01-24T15:12:14.605Z
9213409 9213409 20260116032322_1RXTv UK0085 2026-01-17T14:16:47.805Z 2026-01-24T15:12:12.294Z
9213276 9213276 20260116030020_k3sW3 UK0085 2026-01-17T14:16:15.067Z 2026-01-24T15:12:06.940Z
9213233 9213233 20260116024052_YQKS2 UK0085 2026-01-17T14:16:00.433Z 2026-01-24T15:11:50.535Z
9213172 9213172 20260116022925_MM8FV UK0085 2026-01-17T14:15:44.434Z 2026-01-24T15:11:47.657Z
9213125 9213125 20260116021839_702xA UK0085 2026-01-17T14:15:32.298Z 2026-01-24T15:11:43.092Z
9213082 9213082 20260116020809_92bmi UK0085 2026-01-17T14:15:18.178Z 2026-01-24T15:11:39.875Z
9213026 9213026 20260116015533_lLpT0 UK0085 2026-01-17T14:15:02.219Z 2026-01-24T15:11:37.779Z
9212939 9212939 20260116014122_pacZs UK0085 2026-01-17T14:14:40.837Z 2026-01-24T15:11:34.947Z
9212725 9212725 20260116003221_iAnm9 UK0085 2026-01-17T14:13:30.255Z 2026-01-24T15:11:22.359Z
9212704 9212704 20260116002922_fCMBE UK0085 2026-01-17T14:13:24.694Z 2026-01-24T15:11:10.729Z
9212648 9212648 20260116000333_gxxhz UK0085 2026-01-17T14:13:07.038Z 2026-01-24T15:11:08.781Z
9212572 9212572 20260115231430_rBvzg UK0085 2026-01-17T14:12:44.297Z 2026-01-24T15:11:03.760Z
9212545 9212545 20260115225828_zyo9V UK0085 2026-01-17T14:12:38.074Z 2026-01-24T15:11:02.227Z
9212476 9212476 20260115215950_raINr UK0085 2026-01-17T14:12:07.077Z 2026-01-24T15:10:56.702Z
9212408 9212408 20260115210800_ajvoe UK0085 2026-01-17T14:11:39.603Z 2026-01-24T15:10:51.457Z
9212225 9212225 20260115200157_YA6ZS UK0085 2026-01-17T14:10:43.278Z 2026-01-24T15:10:38.552Z
9212030 9212030 20260115185019_1VgN8 UK0085 2026-01-17T14:09:34.697Z 2026-01-24T15:10:19.737Z
9211986 9211986 20260115183843_iMHLR UK0085 2026-01-17T14:09:22.422Z 2026-01-24T15:10:17.315Z
9196330 9196330 20260113061243_20JGS UK0085 2026-01-14T14:17:47.929Z 2026-01-21T15:05:31.314Z
9104766 9104766 20251230063626_FrK3I UK0085 2025-12-31T14:22:21.929Z 2026-01-07T15:10:04.735Z
9104755 9104755 20251230063334_J1H3x UK0085 2025-12-31T14:22:14.806Z 2026-01-07T15:10:04.382Z
9072814 9072814 20251225042823_bIZoH UK0085 2025-12-29T14:56:06.613Z 2026-01-02T15:44:49.823Z
9053037 9053037 20251227012407_v9o2R UK0085 2025-12-29T14:11:36.822Z 2026-01-04T15:25:54.445Z
9043981 9043981 20251224214649_y270U UK0085 2025-12-28T14:48:16.729Z 2026-01-01T15:57:25.578Z
9043912 9043912 20251224213658_D23qS UK0085 2025-12-28T14:48:13.107Z 2026-01-01T15:57:24.637Z
9043548 9043548 20251224204305_ZmXoG UK0085 2025-12-28T14:47:37.531Z 2025-12-29T15:07:59.176Z
9043537 9043537 20251224204147_tJjqc UK0085 2025-12-28T14:47:36.734Z 2026-01-01T15:57:19.962Z
9043172 9043172 20251224195055_UPw5s UK0085 2025-12-28T14:46:57.830Z 2025-12-29T15:07:54.968Z
9042795 9042795 20251224190509_JsUtA UK0085 2025-12-28T14:46:19.046Z 2026-01-01T15:57:10.428Z
9030987 9030987 20251225051056_iWOoU UK0085 2025-12-28T14:19:59.677Z 2026-01-02T15:45:02.103Z
9030798 9030798 20251225050029_Hf5eN UK0085 2025-12-28T14:19:25.469Z 2026-01-02T15:44:59.187Z
9030047 9030047 20251225042959_3t5mm UK0085 2025-12-28T14:18:00.677Z 2026-01-02T15:44:50.475Z
9030040 9030040 20251225042909_xSTDS UK0085 2025-12-28T14:17:59.384Z 2025-12-29T14:56:06.898Z
9030024 9030024 20251225042823_N3eQQ UK0085 2025-12-28T14:17:55.783Z 2025-12-28T14:48:30.705Z
9030015 9030015 20251225042728_Fpdo2 UK0085 2025-12-28T14:17:54.192Z 2026-01-02T15:44:49.583Z
9029830 9029830 20251225041750_PNMQv UK0085 2025-12-28T14:17:22.962Z 2026-01-02T15:44:36.475Z
9027515 9027515 20251225022102_i1Qyo UK0085 2025-12-28T14:11:25.055Z 2025-12-29T14:55:05.920Z
9027046 9027046 20251225015104_IpC4K UK0085 2025-12-28T14:09:50.819Z 2026-01-02T15:43:08.807Z
9026885 9026885 20251225014047_VdKEB UK0085 2025-12-28T14:09:20.097Z 2026-01-02T15:43:05.782Z
9026362 9026362 20251225010301_BSq0S UK0085 2025-12-28T14:07:34.817Z 2026-01-02T15:42:54.401Z
9026313 9026313 20251225010122_v0uQ7 UK0085 2025-12-28T14:07:27.685Z 2026-01-02T15:42:53.659Z
9026205 9026205 20251225005350_ODoQU UK0085 2025-12-28T14:07:08.016Z 2026-01-02T15:42:51.516Z
9026167 9026167 20251225005006_XgDIB UK0085 2025-12-28T14:06:59.535Z 2026-01-02T15:42:50.634Z
9025809 9025809 20251225002814_2vGUz UK0085 2025-12-28T14:05:46.425Z 2026-01-02T15:42:36.856Z
9025735 9025735 20251225002246_pwgk7 UK0085 2025-12-28T14:05:30.804Z 2026-01-02T15:42:24.320Z
9025256 9025256 20251224234806_usV6g UK0085 2025-12-28T14:03:58.078Z 2026-01-02T15:42:13.750Z
9025248 9025248 20251224234644_8FOM1 UK0085 2025-12-28T14:03:55.748Z 2026-01-02T15:42:13.484Z
9025099 9025099 20251224233055_Vh3ly UK0085 2025-12-28T14:03:22.481Z 2026-01-02T15:42:10.777Z
9024943 9024943 20251224231909_ZVN3y UK0085 2025-12-28T14:02:50.967Z 2025-12-29T14:52:34.260Z
9024448 9024448 20251224222114_IIBLH UK0085 2025-12-28T14:00:34.199Z 2026-01-02T15:41:58.592Z
9017338 9017338 20251220051208_OhVe4 UK0085 2025-12-27T15:01:17.328Z 2025-12-29T15:23:30.145Z
9017235 9017235 20251220050432_lyaN2 UK0085 2025-12-27T15:01:14.039Z 2025-12-29T15:23:29.527Z
9017225 9017225 20251220050353_3yN5E UK0085 2025-12-27T15:01:13.750Z 2025-12-29T15:23:29.435Z
9017040 9017040 20251220045011_pYpwO UK0085 2025-12-27T15:01:06.030Z 2025-12-29T15:23:28.044Z
9017014 9017014 20251220044658_iXHYB UK0085 2025-12-27T15:01:05.154Z 2025-12-29T15:23:27.750Z
9016971 9016971 20251220044357_eg86R UK0085 2025-12-27T15:01:03.459Z 2025-12-29T15:23:27.473Z
9016909 9016909 20251220044035_kOqNg UK0085 2025-12-27T15:00:52.023Z 2025-12-29T15:23:26.955Z
9016629 9016629 20251220042014_FmuFZ UK0085 2025-12-27T14:59:50.746Z 2025-12-29T15:23:24.715Z
9016527 9016527 20251220041033_eYoIX UK0085 2025-12-27T14:59:47.457Z 2025-12-29T15:23:23.776Z
9016417 9016417 20251220040412_0WULW UK0085 2025-12-27T14:59:43.824Z 2025-12-29T15:23:23.112Z
9016051 9016051 20251220033647_b47vi UK0085 2025-12-27T14:59:31.585Z 2025-12-29T15:23:20.698Z
9015866 9015866 20251220032625_3F1b3 UK0085 2025-12-27T14:58:59.544Z 2025-12-29T15:23:19.663Z
8994314 8994314 20251219004503_pv24Q UK0085 2025-12-26T14:54:30.286Z 2025-12-27T15:29:00.348Z
8994155 8994155 20251219002718_Jk2xd UK0085 2025-12-26T14:54:21.608Z 2025-12-26T14:54:21.608Z
8984996 8984996 20251220001732_UI2Ah UK0085 2025-12-26T14:31:40.803Z 2025-12-28T15:23:57.662Z
8984983 8984983 20251220001715_FIaww UK0085 2025-12-26T14:31:38.375Z 2025-12-28T15:23:57.469Z
8984843 8984843 20251220000537_zAX6m UK0085 2025-12-26T14:31:25.826Z 2025-12-27T15:18:48.004Z
8984707 8984707 20251219235639_WDs3f UK0085 2025-12-26T14:31:17.036Z 2025-12-28T15:23:53.930Z
8984626 8984626 20251219234621_GkjmY UK0085 2025-12-26T14:31:04.135Z 2025-12-28T15:23:53.266Z
8984375 8984375 20251219232531_tRJXQ UK0085 2025-12-26T14:30:41.821Z 2025-12-28T15:23:50.382Z
8982704 8982704 20251219201730_FXE2T UK0085 2025-12-26T14:27:35.039Z 2025-12-27T15:17:23.277Z
8982292 8982292 20251219192204_ZdJAg UK0085 2025-12-26T14:26:43.541Z 2025-12-28T15:22:07.455Z
8982210 8982210 20251219191156_AWxOG UK0085 2025-12-26T14:26:32.210Z 2025-12-28T15:22:06.278Z
8981527 8981527 20251219174433_SSQFy UK0085 2025-12-26T14:24:56.010Z 2025-12-27T15:16:24.956Z
8981231 8981231 20251219170718_fKxOB UK0085 2025-12-26T14:24:10.430Z 2025-12-27T15:16:12.620Z
8976020 8976020 20251219022139_fwZaW UK0085 2025-12-26T14:08:39.526Z 2025-12-28T15:17:22.376Z
8975979 8975979 20251219021753_5zCE9 UK0085 2025-12-26T14:08:31.784Z 2025-12-28T15:17:22.018Z
8975956 8975956 20251219021554_GLZYf UK0085 2025-12-26T14:08:28.808Z 2025-12-28T15:17:21.759Z
8975907 8975907 20251219020825_RlQg2 UK0085 2025-12-26T14:08:17.425Z 2025-12-28T15:17:21.199Z

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