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,791 rows where station_code = "UK009Q" 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
9234131 9234131 20260119194458_1b2Co UK009Q 2026-01-21T14:12:30.088Z 2026-01-28T14:57:16.605Z
9233904 9233904 20260119184225_TiqNZ UK009Q 2026-01-21T14:11:17.431Z 2026-01-28T14:56:51.948Z
9231253 9231253 20260119065453_v4b9Q UK009Q 2026-01-20T14:32:01.959Z 2026-01-27T15:06:09.890Z
9231250 9231250 20260119065245_Z3SVy UK009Q 2026-01-20T14:32:01.457Z 2026-01-27T15:06:09.720Z
9231229 9231229 20260119064049_aVo7M UK009Q 2026-01-20T14:31:56.092Z 2026-01-27T15:06:08.098Z
9231225 9231225 20260119063938_tvoAX UK009Q 2026-01-20T14:31:54.992Z 2026-01-27T15:06:07.822Z
9231196 9231196 20260119062756_VdUm7 UK009Q 2026-01-20T14:31:49.596Z 2026-01-27T15:06:04.803Z
9231177 9231177 20260119062036_f7u74 UK009Q 2026-01-20T14:31:40.922Z 2026-01-27T15:06:03.612Z
9231081 9231081 20260119055852_aEAIV UK009Q 2026-01-20T14:31:09.836Z 2026-01-27T15:05:56.974Z
9230154 9230154 20260119033504_iHzhb UK009Q 2026-01-20T14:26:20.388Z 2026-01-27T15:04:30.703Z
9228193 9228193 20260118203150_iTi27 UK009Q 2026-01-20T14:16:35.821Z 2026-01-27T15:01:33.067Z
9227972 9227972 20260118190058_1EEsc UK009Q 2026-01-20T14:15:13.864Z 2026-01-27T15:01:08.698Z
9224657 9224657 20260118053053_NLT94 UK009Q 2026-01-19T14:25:23.234Z 2026-01-26T15:03:44.338Z
9224547 9224547 20260118051108_3gkn1 UK009Q 2026-01-19T14:24:51.974Z 2026-01-26T15:03:23.240Z
9224492 9224492 20260118050025_ykvjv UK009Q 2026-01-19T14:24:38.107Z 2026-01-26T15:03:21.081Z
9224457 9224457 20260118044945_xGiR3 UK009Q 2026-01-19T14:24:31.493Z 2026-01-26T15:03:19.809Z
9224205 9224205 20260118035120_7HQ3T UK009Q 2026-01-19T14:23:18.917Z 2026-01-26T15:03:08.697Z
9217973 9217973 20260116211432_HLoeR UK009Q 2026-01-18T14:09:48.264Z 2026-01-25T14:57:53.600Z
9217779 9217779 20260116194434_8gq7G UK009Q 2026-01-18T14:08:58.326Z 2026-01-25T14:57:47.413Z
9217577 9217577 20260116180441_KGMjO UK009Q 2026-01-18T14:08:00.973Z 2026-01-25T14:57:26.747Z
9217562 9217562 20260116175627_MGok2 UK009Q 2026-01-18T14:07:54.918Z 2026-01-25T14:57:26.197Z
9214469 9214469 20260116064136_wg53G UK009Q 2026-01-17T14:21:38.330Z 2026-01-24T15:13:38.776Z
9214465 9214465 20260116063910_XmhNe UK009Q 2026-01-17T14:21:37.463Z 2026-01-24T15:13:38.588Z
9214430 9214430 20260116063354_4UgUL UK009Q 2026-01-17T14:21:31.068Z 2026-01-24T15:13:36.959Z
9214360 9214360 20260116062227_NKgFP UK009Q 2026-01-17T14:21:11.062Z 2026-01-24T15:13:31.426Z
9214290 9214290 20260116060815_PS4Bq UK009Q 2026-01-17T14:20:58.865Z 2026-01-24T15:13:28.752Z
9214080 9214080 20260116053223_oPsSG UK009Q 2026-01-17T14:19:59.210Z 2026-01-24T15:13:04.473Z
9214060 9214060 20260116052936_VFRdW UK009Q 2026-01-17T14:19:51.819Z 2026-01-24T15:13:03.130Z
9214050 9214050 20260116052708_CGxVP UK009Q 2026-01-17T14:19:49.694Z 2026-01-24T15:13:00.729Z
9213940 9213940 20260116050352_lWHR3 UK009Q 2026-01-17T14:19:16.544Z 2026-01-24T15:12:52.875Z
9213781 9213781 20260116044034_mUFdP UK009Q 2026-01-17T14:18:28.471Z 2026-01-24T15:12:46.269Z
9213253 9213253 20260116025112_eqv9m UK009Q 2026-01-17T14:16:08.533Z 2026-01-24T15:11:58.993Z
9213219 9213219 20260116023744_aT935 UK009Q 2026-01-17T14:15:57.426Z 2026-01-24T15:11:49.883Z
9213118 9213118 20260116021642_i8yiq UK009Q 2026-01-17T14:15:31.259Z 2026-01-24T15:11:42.756Z
9213022 9213022 20260116015532_6TYCE UK009Q 2026-01-17T14:15:01.745Z 2026-01-24T15:11:37.668Z
9212914 9212914 20260116013753_qXFlF UK009Q 2026-01-17T14:14:32.161Z 2026-01-24T15:11:33.914Z
9212789 9212789 20260116005934_nnfb6 UK009Q 2026-01-17T14:13:55.111Z 2026-01-24T15:11:26.683Z
9212728 9212728 20260116003222_H4HHO UK009Q 2026-01-17T14:13:30.847Z 2026-01-24T15:11:22.941Z
9212705 9212705 20260116002922_IOv0y UK009Q 2026-01-17T14:13:25.291Z 2026-01-24T15:11:10.861Z
9212490 9212490 20260115221546_OaIPG UK009Q 2026-01-17T14:12:12.134Z 2026-01-24T15:10:57.605Z
9212457 9212457 20260115213334_ostw3 UK009Q 2026-01-17T14:11:58.456Z 2026-01-24T15:10:55.542Z
9211989 9211989 20260115183844_sTV2H UK009Q 2026-01-17T14:09:23.091Z 2026-01-24T15:10:17.466Z
9205582 9205582 20260113202340_cLtjz UK009Q 2026-01-15T14:31:31.766Z 2026-01-22T15:07:29.633Z
9202926 9202926 20260114041838_TSxdt UK009Q 2026-01-15T14:22:48.384Z 2026-01-22T15:09:59.434Z
9202917 9202917 20260114041837_QXLmV UK009Q 2026-01-15T14:22:47.803Z 2026-01-22T15:09:59.415Z
9200980 9200980 20260114012625_N9Ty2 UK009Q 2026-01-15T14:17:07.754Z 2026-01-22T15:08:41.138Z
9200633 9200633 20260114004032_wdqEF UK009Q 2026-01-15T14:15:50.469Z 2026-01-22T15:08:22.309Z
9200390 9200390 20260113235627_4jh7p UK009Q 2026-01-15T14:14:58.689Z 2026-01-22T15:08:15.183Z
9199795 9199795 20260113211856_hWO4C UK009Q 2026-01-15T14:12:31.344Z 2026-01-22T15:08:02.112Z
9199731 9199731 20260113210810_bjVNs UK009Q 2026-01-15T14:12:09.493Z 2026-01-22T15:08:00.660Z
9199647 9199647 20260113204336_Al7Nz UK009Q 2026-01-15T14:11:52.560Z 2026-01-22T15:07:58.511Z
9199558 9199558 20260113202339_rZY3C UK009Q 2026-01-15T14:11:27.425Z 2026-01-22T15:07:29.041Z
9199413 9199413 20260113195614_Dd2tP UK009Q 2026-01-15T14:10:45.270Z 2026-01-22T15:07:23.675Z
9199368 9199368 20260113195208_w2AfN UK009Q 2026-01-15T14:10:36.840Z 2026-01-22T15:07:22.828Z
9198747 9198747 20260113175037_BsLkm UK009Q 2026-01-15T14:06:53.204Z 2026-01-22T15:07:02.882Z
9195584 9195584 20260113015402_tn2r0 UK009Q 2026-01-14T14:13:56.283Z 2026-01-21T15:04:42.641Z
9195540 9195540 20260113014336_zhvDM UK009Q 2026-01-14T14:13:45.798Z 2026-01-21T15:04:42.057Z
9195407 9195407 20260113011951_TwPQ0 UK009Q 2026-01-14T14:13:11.784Z 2026-01-21T15:04:40.058Z
9195131 9195131 20260113002430_gVE4H UK009Q 2026-01-14T14:12:06.954Z 2026-01-21T15:04:36.714Z
9195008 9195008 20260112235831_3VMHz UK009Q 2026-01-14T14:11:41.471Z 2026-01-21T15:04:35.085Z
9194074 9194074 20260112173055_28Lt4 UK009Q 2026-01-14T14:07:06.568Z 2026-01-21T15:03:27.934Z
9189612 9189612 20260112052202_vtNdz UK009Q 2026-01-13T14:18:29.755Z 2026-01-20T15:23:31.227Z
9189555 9189555 20260112050700_Ilvdf UK009Q 2026-01-13T14:18:11.828Z 2026-01-20T15:23:18.263Z
9189516 9189516 20260112045056_t2HxX UK009Q 2026-01-13T14:18:01.195Z 2026-01-20T15:23:15.983Z
9189507 9189507 20260112044927_jbLMF UK009Q 2026-01-13T14:17:54.651Z 2026-01-20T15:23:15.454Z
9188664 9188664 20260112010901_QtA22 UK009Q 2026-01-13T14:13:33.267Z 2026-01-20T15:22:04.865Z
9188662 9188662 20260112010817_SoCS9 UK009Q 2026-01-13T14:13:32.597Z 2026-01-20T15:22:04.698Z
9176980 9176980 20260110065318_7JRJt UK009Q 2026-01-11T14:10:32.118Z 2026-01-18T15:09:09.729Z
9176934 9176934 20260110064411_DQl23 UK009Q 2026-01-11T14:10:25.690Z 2026-01-18T15:09:08.328Z
9171361 9171361 20260108211518_FR9Z3 UK009Q 2026-01-10T14:06:55.901Z 2026-01-17T15:23:45.506Z
9171314 9171314 20260108210116_tSJZ6 UK009Q 2026-01-10T14:06:40.892Z 2026-01-17T15:23:43.643Z
9171129 9171129 20260108192447_L3UcQ UK009Q 2026-01-10T14:05:26.673Z 2026-01-17T15:23:25.067Z
9171122 9171122 20260108192444_dlVsU UK009Q 2026-01-10T14:05:25.022Z 2026-01-17T15:23:24.702Z
9167881 9167881 20260108060333_vh02h UK009Q 2026-01-09T14:09:39.980Z 2026-01-16T15:11:58.351Z
9167573 9167573 20260108025959_GqSDD UK009Q 2026-01-09T14:08:15.468Z 2026-01-16T15:11:27.402Z
9167531 9167531 20260108023045_eCRph UK009Q 2026-01-09T14:08:05.607Z 2026-01-16T15:11:24.574Z
9116783 9116783 20251231064742_wY4Et UK009Q 2026-01-01T14:28:54.483Z 2026-01-08T15:12:10.710Z
9116672 9116672 20251231063543_jD8Gj UK009Q 2026-01-01T14:28:39.474Z 2026-01-08T15:12:06.589Z
9116507 9116507 20251231061727_EUGU3 UK009Q 2026-01-01T14:28:14.873Z 2026-01-08T15:11:51.063Z
9116292 9116292 20251231060110_NS3Es UK009Q 2026-01-01T14:27:43.522Z 2026-01-08T15:11:41.910Z
9116253 9116253 20251231055835_dOGmg UK009Q 2026-01-01T14:27:35.267Z 2026-01-08T15:11:40.348Z
9115761 9115761 20251231052625_8K03i UK009Q 2026-01-01T14:26:20.963Z 2026-01-08T15:11:11.089Z
9115723 9115723 20251231052418_oWiXM UK009Q 2026-01-01T14:26:15.993Z 2026-01-08T15:11:09.630Z
9115370 9115370 20251231050333_jCHQ6 UK009Q 2026-01-01T14:25:15.493Z 2026-01-08T15:10:45.175Z
9115349 9115349 20251231050111_HdQwy UK009Q 2026-01-01T14:25:07.435Z 2026-01-08T15:10:43.397Z
9115329 9115329 20251231045911_QxPWk UK009Q 2026-01-01T14:25:04.512Z 2026-01-08T15:10:42.690Z
9115324 9115324 20251231045858_zOIU1 UK009Q 2026-01-01T14:25:03.413Z 2026-01-08T15:10:42.218Z
9115052 9115052 20251231044457_Rdblm UK009Q 2026-01-01T14:24:15.161Z 2026-01-08T15:10:21.291Z
9115047 9115047 20251231044408_yJuhe UK009Q 2026-01-01T14:24:14.537Z 2026-01-08T15:10:21.044Z
9114960 9114960 20251231043731_zxnIx UK009Q 2026-01-01T14:23:53.821Z 2026-01-08T15:10:16.381Z
9113922 9113922 20251231035454_2ijt3 UK009Q 2026-01-01T14:20:52.474Z 2026-01-08T15:09:15.796Z
9113815 9113815 20251231034950_PL3SZ UK009Q 2026-01-01T14:20:28.997Z 2026-01-08T15:09:10.479Z
9113556 9113556 20251231033545_oc6oy UK009Q 2026-01-01T14:19:27.529Z 2026-01-08T15:08:48.936Z
9113338 9113338 20251231032403_x70F8 UK009Q 2026-01-01T14:18:34.842Z 2026-01-08T15:08:39.980Z
9112829 9112829 20251231025427_erhEI UK009Q 2026-01-01T14:16:27.808Z 2026-01-08T15:08:09.769Z
9104756 9104756 20251230063334_J1H3x UK009Q 2025-12-31T14:22:14.825Z 2026-01-07T15:10:04.382Z
9104699 9104699 20251230062247_LdIn5 UK009Q 2025-12-31T14:22:03.226Z 2026-01-07T15:09:53.786Z
9104695 9104695 20251230062149_C6qo6 UK009Q 2025-12-31T14:22:02.125Z 2026-01-07T15:09:53.445Z
9104682 9104682 20251230062127_zqPw9 UK009Q 2025-12-31T14:22:00.630Z 2026-01-07T15:09:53.097Z
9104517 9104517 20251230060244_Wkjn4 UK009Q 2025-12-31T14:21:30.365Z 2026-01-07T15:09:45.848Z

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