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,385 rows where station_code = "UK005V" 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
8683001 8683001 20251203061840_vjAu6 UK005V 2025-12-04T14:18:26.459Z 2025-12-06T14:29:38.549Z
8682922 8682922 20251203061601_TwH62 UK005V 2025-12-04T14:18:20.930Z 2025-12-06T14:29:31.972Z
8682828 8682828 20251203060704_CexYB UK005V 2025-12-04T14:18:03.946Z 2025-12-06T14:29:26.820Z
8682686 8682686 20251203055818_aI80l UK005V 2025-12-04T14:17:53.938Z 2025-12-06T14:29:22.756Z
8682320 8682320 20251203051538_Xe97T UK005V 2025-12-04T14:16:48.453Z 2025-12-06T14:28:54.293Z
8682227 8682227 20251203050246_i5wEz UK005V 2025-12-04T14:16:38.652Z 2025-12-06T14:28:50.339Z
8682186 8682186 20251203045737_34jmg UK005V 2025-12-04T14:16:34.879Z 2025-12-06T14:28:49.226Z
8682113 8682113 20251203045258_Aw61c UK005V 2025-12-04T14:16:28.044Z 2025-12-06T14:28:46.985Z
8682074 8682074 20251203044702_WNk7S UK005V 2025-12-04T14:16:19.895Z 2025-12-06T14:28:45.590Z
8682051 8682051 20251203044319_k087G UK005V 2025-12-04T14:16:17.124Z 2025-12-06T14:28:44.982Z
8681982 8681982 20251203043419_M6c18 UK005V 2025-12-04T14:16:05.034Z 2025-12-06T14:28:41.620Z
8681946 8681946 20251203043132_cOhPC UK005V 2025-12-04T14:16:02.850Z 2025-12-06T14:28:41.018Z
8681731 8681731 20251203035126_rkDC0 UK005V 2025-12-04T14:15:27.698Z 2025-12-06T14:28:27.581Z
8681567 8681567 20251203032552_Ml2sT UK005V 2025-12-04T14:15:03.990Z 2025-12-06T14:28:18.709Z
8681459 8681459 20251203031203_kAjMs UK005V 2025-12-04T14:14:45.361Z 2025-12-06T14:28:12.907Z
8681345 8681345 20251203025746_JAM4x UK005V 2025-12-04T14:14:32.161Z 2025-12-06T14:28:03.987Z
8681207 8681207 20251203023829_77FdY UK005V 2025-12-04T14:14:03.374Z 2025-12-06T14:27:55.176Z
8680991 8680991 20251203021010_C7WPw UK005V 2025-12-04T14:13:31.287Z 2025-12-06T14:27:43.473Z
8680911 8680911 20251203014907_zVWbn UK005V 2025-12-04T14:13:20.684Z 2025-12-06T14:27:32.808Z
8676002 8676002 20251202053053_619Iu UK005V 2025-12-03T14:24:35.700Z 2025-12-06T14:35:06.422Z
8675636 8675636 20251202050326_3Zc6C UK005V 2025-12-03T14:23:57.612Z 2025-12-06T14:34:57.439Z
8675414 8675414 20251202043700_OmoV5 UK005V 2025-12-03T14:23:41.674Z 2025-12-06T14:34:52.008Z
8675203 8675203 20251202041758_3s3pA UK005V 2025-12-03T14:23:20.656Z 2025-12-06T14:34:47.409Z
8675191 8675191 20251202041553_Wj4Uh UK005V 2025-12-03T14:23:16.919Z 2025-12-06T14:34:47.163Z
8675011 8675011 20251202035228_JBv6E UK005V 2025-12-03T14:22:50.748Z 2025-12-06T14:34:27.371Z
8674978 8674978 20251202034523_I3f7Z UK005V 2025-12-03T14:22:47.505Z 2025-12-06T14:34:26.375Z
8674804 8674804 20251202032749_WIOGH UK005V 2025-12-03T14:22:26.502Z 2025-12-06T14:34:19.595Z
8674676 8674676 20251202030653_G3pzT UK005V 2025-12-03T14:22:12.245Z 2025-12-06T14:34:15.401Z
8674613 8674613 20251202025849_l3X15 UK005V 2025-12-03T14:22:08.293Z 2025-12-06T14:34:13.989Z
8674497 8674497 20251202023659_SkhVu UK005V 2025-12-03T14:21:42.618Z 2025-12-06T14:34:10.407Z
8674460 8674460 20251202022852_8uqgC UK005V 2025-12-03T14:21:40.483Z 2025-12-06T14:34:09.691Z
8674372 8674372 20251202021337_rXUfK UK005V 2025-12-03T14:21:33.124Z 2025-12-06T14:34:07.044Z
8674343 8674343 20251202020608_eXtt3 UK005V 2025-12-03T14:21:26.997Z 2025-12-06T14:34:05.226Z
8674277 8674277 20251202015624_GPLjI UK005V 2025-12-03T14:21:21.199Z 2025-12-06T14:34:02.985Z
8673949 8673949 20251202004617_EGpAI UK005V 2025-12-03T14:20:25.826Z 2025-12-06T14:33:43.105Z
8673939 8673939 20251202004437_3UJAk UK005V 2025-12-03T14:20:25.094Z 2025-12-06T14:33:42.989Z
8656174 8656174 20251130044206_mWGMD UK005V 2025-12-01T14:28:08.802Z 2025-12-06T14:49:31.917Z
8655444 8655444 20251130040216_pg5fn UK005V 2025-12-01T14:26:54.316Z 2025-12-06T14:49:16.830Z
8654932 8654932 20251130033844_ZvoEJ UK005V 2025-12-01T14:26:11.181Z 2025-12-06T14:48:50.166Z
8653867 8653867 20251130024512_aP2Fx UK005V 2025-12-01T14:24:24.380Z 2025-12-06T14:48:33.872Z
8653191 8653191 20251130020132_hfVYU UK005V 2025-12-01T14:23:03.249Z 2025-12-06T14:47:51.274Z
8652659 8652659 20251130012633_PA0ew UK005V 2025-12-01T14:21:56.191Z 2025-12-06T14:47:40.709Z
8652213 8652213 20251130005520_2a072 UK005V 2025-12-01T14:20:55.747Z 2025-12-06T14:47:31.435Z
8651846 8651846 20251130002509_FHH3E UK005V 2025-12-01T14:20:07.660Z 2025-12-06T14:46:54.959Z
8651443 8651443 20251129234330_mF1v1 UK005V 2025-12-01T14:19:08.084Z 2025-12-06T14:46:46.241Z
8637051 8637051 20251128045551_3fJSk UK005V 2025-11-29T14:26:48.083Z 2025-12-06T15:03:56.096Z
8634216 8634216 20251128003029_XzLQu UK005V 2025-11-29T14:21:02.973Z 2025-12-06T15:01:52.997Z
8633675 8633675 20251127234527_rzeJH UK005V 2025-11-29T14:20:05.724Z 2025-12-06T15:01:47.958Z
8616547 8616547 20251126060715_34I8e UK005V 2025-11-27T14:31:16.337Z 2025-12-04T15:11:40.622Z
8616529 8616529 20251126060426_Hz6nO UK005V 2025-11-27T14:31:15.596Z 2025-12-04T15:11:40.562Z
8616462 8616462 20251126060137_jRsdU UK005V 2025-11-27T14:31:12.674Z 2025-12-04T15:11:39.731Z
8615340 8615340 20251126045704_FuHoQ UK005V 2025-11-27T14:29:28.013Z 2025-12-04T15:11:27.958Z
8615112 8615112 20251126044518_ds0rR UK005V 2025-11-27T14:29:14.109Z 2025-12-04T15:11:25.906Z
8615063 8615063 20251126044316_L1rB4 UK005V 2025-11-27T14:28:57.789Z 2025-12-04T15:11:25.767Z
8614685 8614685 20251126042336_r9uiR UK005V 2025-11-27T14:28:27.370Z 2025-12-04T15:10:57.747Z
8613765 8613765 20251126033324_vPNwd UK005V 2025-11-27T14:26:29.875Z 2025-12-04T15:09:51.547Z
8612655 8612655 20251126024137_h44Z0 UK005V 2025-11-27T14:24:26.337Z 2025-12-04T15:09:32.548Z
8611400 8611400 20251126013857_Lo2Ik UK005V 2025-11-27T14:22:05.772Z 2025-12-04T15:09:11.573Z
8611266 8611266 20251126013557_Cag29 UK005V 2025-11-27T14:21:46.306Z 2025-12-04T15:09:06.961Z
8610612 8610612 20251126005935_Z5O9t UK005V 2025-11-27T14:20:26.797Z 2025-12-04T15:08:19.967Z
8610213 8610213 20251126003051_2rVGf UK005V 2025-11-27T14:19:35.629Z 2025-12-04T15:08:03.400Z
8607569 8607569 20251125210229_qlz7X UK005V 2025-11-27T14:13:57.620Z 2025-12-04T15:07:03.773Z
8607544 8607544 20251125210103_vH3Jt UK005V 2025-11-27T14:13:55.714Z 2025-12-04T15:07:03.516Z
8606836 8606836 20251125194754_ucwbm UK005V 2025-11-27T14:11:32.548Z 2025-12-04T15:06:51.201Z
8606633 8606633 20251125191652_ydWje UK005V 2025-11-27T14:10:46.294Z 2025-12-04T15:06:47.814Z
8606530 8606530 20251125191118_3flXA UK005V 2025-11-27T14:10:29.420Z 2025-12-04T15:06:46.664Z
8605839 8605839 20251125172431_8MqOA UK005V 2025-11-27T14:08:05.536Z 2025-12-04T15:05:46.553Z
8603512 8603512 20251125061055_s810u UK005V 2025-11-26T14:27:28.963Z 2025-12-02T15:09:36.062Z
8602242 8602242 20251125044510_TRkPc UK005V 2025-11-26T14:25:28.341Z 2025-12-02T15:09:30.142Z
8601498 8601498 20251125035144_TFP5P UK005V 2025-11-26T14:24:20.364Z 2025-12-02T15:09:09.481Z
8600359 8600359 20251125025441_3E7ik UK005V 2025-11-26T14:22:17.582Z 2025-12-02T15:08:40.925Z
8600217 8600217 20251125024916_tbeai UK005V 2025-11-26T14:22:09.808Z 2025-12-02T15:08:40.074Z
8597252 8597252 20251124231639_5WZg1 UK005V 2025-11-26T14:16:26.167Z 2025-12-02T15:07:27.563Z
8597144 8597144 20251124230541_HwfIC UK005V 2025-11-26T14:16:15.931Z 2025-12-02T15:07:23.569Z
8596966 8596966 20251124223947_EATDo UK005V 2025-11-26T14:15:50.102Z 2025-12-02T15:07:20.589Z
8596801 8596801 20251124220910_geZSn UK005V 2025-11-26T14:15:21.285Z 2025-12-02T15:07:14.541Z
8596724 8596724 20251124220127_pPe11 UK005V 2025-11-26T14:15:12.802Z 2025-12-02T15:07:08.182Z
8596633 8596633 20251124214419_J2nPa UK005V 2025-11-26T14:15:01.908Z 2025-12-02T15:07:03.596Z
8596580 8596580 20251124213323_bIpsu UK005V 2025-11-26T14:14:47.414Z 2025-12-02T15:07:03.069Z
8596443 8596443 20251124210819_mR7wx UK005V 2025-11-26T14:14:34.546Z 2025-12-02T15:06:55.165Z
8580217 8580217 20251123030057_FmfrH UK005V 2025-11-24T14:16:23.323Z 2025-12-01T15:21:57.301Z
8580046 8580046 20251123022037_thjZc UK005V 2025-11-24T14:15:54.986Z 2025-12-01T15:21:35.673Z
8579874 8579874 20251123013945_Vbaal UK005V 2025-11-24T14:15:30.488Z 2025-12-01T15:21:14.554Z
8579746 8579746 20251123005912_DQaVU UK005V 2025-11-24T14:15:04.215Z 2025-12-01T15:20:59.546Z
8579430 8579430 20251122234100_Ko25w UK005V 2025-11-24T14:14:20.578Z 2025-12-01T15:20:19.062Z
8568508 8568508 20251121052220_N4GIt UK005V 2025-11-23T14:31:10.555Z 2025-11-29T14:54:46.895Z
8560256 8560256 20251121044805_zVDsU UK005V 2025-11-22T14:42:45.525Z 2025-11-29T14:54:45.422Z
8557596 8557596 20251121025315_SRHI8 UK005V 2025-11-22T14:40:23.454Z 2025-11-29T14:54:34.387Z
8557573 8557573 20251121025303_ak0qY UK005V 2025-11-22T14:40:22.690Z 2025-11-29T14:54:34.381Z
8556690 8556690 20251121020658_h1IKN UK005V 2025-11-22T14:39:40.515Z 2025-11-29T14:54:32.788Z
8555926 8555926 20251121012956_1ZsH3 UK005V 2025-11-22T14:38:55.531Z 2025-11-29T14:54:31.513Z
8555831 8555831 20251121012540_gwkJ3 UK005V 2025-11-22T14:38:52.907Z 2025-11-29T14:54:31.260Z
8551254 8551254 20251121003127_U3d7i UK005V 2025-11-22T14:22:20.143Z 2025-11-29T14:54:28.412Z
8549741 8549741 20251120225339_omXmp UK005V 2025-11-22T14:19:32.685Z 2025-11-29T14:54:25.445Z
8549402 8549402 20251120222641_K9hNC UK005V 2025-11-22T14:18:55.343Z 2025-11-29T14:54:24.695Z
8549345 8549345 20251120221850_vXzjq UK005V 2025-11-22T14:18:49.731Z 2025-11-29T14:54:24.471Z
8548138 8548138 20251120203838_whaBL UK005V 2025-11-22T14:16:21.214Z 2025-11-29T14:54:22.031Z
8536952 8536952 20251120053834_oh1on UK005V 2025-11-21T14:19:19.412Z 2025-11-28T14:58:19.879Z
8536615 8536615 20251120043946_okfm5 UK005V 2025-11-21T14:18:42.787Z 2025-11-28T14:57:46.083Z
8536500 8536500 20251120042730_25yif UK005V 2025-11-21T14:18:22.497Z 2025-11-28T14:57:38.880Z

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