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

9,247 rows where station_code = "UK0067" 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
9589949 9589949 20260328042259_1Wwp8 UK0067 2026-03-29T12:01:46.597Z 2026-04-06T12:37:39.011Z
9589875 9589875 20260328041300_KYcF1 UK0067 2026-03-29T12:01:41.694Z 2026-04-06T12:37:36.914Z
9589810 9589810 20260328040906_KIy3m UK0067 2026-03-29T12:01:39.059Z 2026-04-06T12:37:35.507Z
9589682 9589682 20260328035906_SO7di UK0067 2026-03-29T12:01:33.595Z 2026-04-06T12:37:31.405Z
9589254 9589254 20260328030153_eJ2st UK0067 2026-03-29T12:00:59.464Z 2026-04-06T12:37:10.022Z
9588946 9588946 20260328015616_D723Q UK0067 2026-03-29T12:00:31.526Z 2026-04-06T12:36:57.044Z
9585199 9585199 20260325234015_C2FUG UK0067 2026-03-27T12:16:54.275Z 2026-04-03T12:39:51.378Z
9585140 9585140 20260325233302_zGkxv UK0067 2026-03-27T12:16:50.374Z 2026-04-03T12:39:50.346Z
9585123 9585123 20260325233255_S5b7r UK0067 2026-03-27T12:16:47.359Z 2026-04-03T12:39:50.215Z
9580682 9580682 20260326011457_YJiWc UK0067 2026-03-27T12:01:08.432Z 2026-04-04T12:38:20.404Z
9576758 9576758 20260325030454_3Cjhl UK0067 2026-03-26T12:03:13.206Z 2026-04-03T12:36:20.066Z
9576528 9576528 20260325022825_lKbYb UK0067 2026-03-26T12:02:32.158Z 2026-04-03T12:36:11.527Z
9576218 9576218 20260325013844_CJ0pH UK0067 2026-03-26T12:01:36.252Z 2026-04-03T12:35:48.895Z
9559948 9559948 20260321201411_0cmkt UK0067 2026-03-23T12:11:34.464Z 2026-03-29T12:20:56.782Z
9555454 9555454 20260322045718_cSClq UK0067 2026-03-23T12:03:26.402Z 2026-03-30T12:28:26.664Z
9554845 9554845 20260322033930_3lIQz UK0067 2026-03-23T12:02:53.373Z 2026-03-30T12:28:10.408Z
9554619 9554619 20260322032107_k3z3X UK0067 2026-03-23T12:02:43.717Z 2026-03-30T12:28:06.586Z
9554319 9554319 20260322025837_EmDXY UK0067 2026-03-23T12:02:26.634Z 2026-03-30T12:28:02.422Z
9553579 9553579 20260322015554_trEAD UK0067 2026-03-23T12:01:41.184Z 2026-03-30T12:27:49.632Z
9553441 9553441 20260322014255_g1Jnl UK0067 2026-03-23T12:01:30.462Z 2026-03-30T12:27:41.195Z
9553292 9553292 20260322012958_oa3PH UK0067 2026-03-23T12:01:23.428Z 2026-03-30T12:27:39.182Z
9552335 9552335 20260321235305_C5x3B UK0067 2026-03-23T12:00:15.703Z 2026-03-30T12:27:22.531Z
9552138 9552138 20260320230404_OGs4w UK0067 2026-03-22T12:27:29.503Z 2026-03-28T12:37:07.247Z
9552113 9552113 20260320230115_Tbc32 UK0067 2026-03-22T12:27:28.167Z 2026-03-28T12:37:07.062Z
9551921 9551921 20260320221347_zheMm UK0067 2026-03-22T12:27:17.896Z 2026-03-28T12:37:04.310Z
9542331 9542331 20260319231329_vclrg UK0067 2026-03-21T12:29:58.353Z 2026-03-27T12:42:57.451Z
9542105 9542105 20260319224755_J3Kzt UK0067 2026-03-21T12:29:39.930Z 2026-03-27T12:42:45.158Z
9542022 9542022 20260319223315_nPa8j UK0067 2026-03-21T12:29:36.418Z 2026-03-27T12:42:44.341Z
9541933 9541933 20260319220725_tkzQR UK0067 2026-03-21T12:29:30.035Z 2026-03-27T12:42:43.041Z
9541636 9541636 20260319211236_pEN6e UK0067 2026-03-21T12:29:13.710Z 2026-03-27T12:42:40.365Z
9534443 9534443 20260320034938_bhyQS UK0067 2026-03-21T12:08:00.908Z 2026-03-28T12:34:18.367Z
9533732 9533732 20260320025356_fWoUf UK0067 2026-03-21T12:06:08.420Z 2026-03-28T12:33:59.931Z
9533206 9533206 20260320021308_lamdX UK0067 2026-03-21T12:04:48.015Z 2026-03-28T12:33:50.486Z
9532737 9532737 20260320012046_k3HVD UK0067 2026-03-21T12:03:29.259Z 2026-03-28T12:33:35.658Z
9532670 9532670 20260320011743_mDIYH UK0067 2026-03-21T12:03:22.667Z 2026-03-28T12:33:35.124Z
9532284 9532284 20260320004424_l2EgV UK0067 2026-03-21T12:02:18.013Z 2026-03-28T12:33:27.215Z
9531896 9531896 20260319235918_Renop UK0067 2026-03-21T12:01:09.191Z 2026-03-28T12:33:22.597Z
9531791 9531791 20260319234939_e5gQL UK0067 2026-03-21T12:00:52.839Z 2026-03-28T12:33:21.624Z
9529861 9529861 20260318193839_WwLjq UK0067 2026-03-20T12:23:46.631Z 2026-03-26T12:39:07.062Z
9521084 9521084 20260319035319_YSu44 UK0067 2026-03-20T12:07:30.776Z 2026-03-27T12:40:51.531Z
9520791 9520791 20260319033812_ww0ww UK0067 2026-03-20T12:06:59.269Z 2026-03-27T12:40:47.433Z
9520329 9520329 20260319031029_SmG3T UK0067 2026-03-20T12:06:14.504Z 2026-03-27T12:40:42.094Z
9519774 9519774 20260319023540_49dk7 UK0067 2026-03-20T12:05:06.093Z 2026-03-27T12:40:35.531Z
9519510 9519510 20260319021452_2GP3d UK0067 2026-03-20T12:04:34.463Z 2026-03-27T12:40:31.938Z
9519163 9519163 20260319015352_CmsTF UK0067 2026-03-20T12:04:02.542Z 2026-03-27T12:40:18.771Z
9517707 9517707 20260318235627_FNwcz UK0067 2026-03-20T12:01:04.341Z 2026-03-27T12:40:02.536Z
9512061 9512061 20260318043941_tae0u UK0067 2026-03-19T12:11:38.207Z 2026-03-26T12:37:42.062Z
9511619 9511619 20260318040548_P3TJ4 UK0067 2026-03-19T12:10:38.661Z 2026-03-26T12:37:38.353Z
9511567 9511567 20260318040228_WOygA UK0067 2026-03-19T12:10:29.960Z 2026-03-26T12:37:37.959Z
9509717 9509717 20260318020942_7UeYc UK0067 2026-03-19T12:06:01.842Z 2026-03-26T12:37:07.340Z
9509638 9509638 20260318020323_RxUyW UK0067 2026-03-19T12:05:51.176Z 2026-03-26T12:37:06.779Z
9508679 9508679 20260318010801_YsaIz UK0067 2026-03-19T12:03:38.731Z 2026-03-26T12:37:00.197Z
9507592 9507592 20260317232417_lL24d UK0067 2026-03-19T12:00:42.463Z 2026-03-26T12:36:45.738Z
9495050 9495050 20260316040251_5CQ3R UK0067 2026-03-17T12:05:56.799Z 2026-03-24T12:40:54.049Z
9494434 9494434 20260316021825_JGImV UK0067 2026-03-17T12:03:57.661Z 2026-03-24T12:40:47.568Z
9492514 9492514 20260314210920_HXPqV UK0067 2026-03-16T12:28:39.943Z 2026-03-22T12:42:52.807Z
9484941 9484941 20260315020302_16VB2 UK0067 2026-03-16T12:04:42.132Z 2026-03-23T12:21:49.091Z
9483975 9483975 20260314233320_I0OzR UK0067 2026-03-16T12:01:07.924Z 2026-03-23T12:21:44.699Z
9475743 9475743 20260314020129_gDPtp UK0067 2026-03-15T12:03:59.281Z 2026-03-22T12:41:50.616Z
9470384 9470384 20260313052707_3mHdn UK0067 2026-03-14T12:07:13.020Z 2026-03-21T12:49:08.302Z
9470381 9470381 20260313052707_bQJI0 UK0067 2026-03-14T12:07:12.512Z 2026-03-21T12:49:08.229Z
9470264 9470264 20260313050129_xN4Xq UK0067 2026-03-14T12:06:49.221Z 2026-03-21T12:49:07.037Z
9470251 9470251 20260313050035_da7Jn UK0067 2026-03-14T12:06:48.355Z 2026-03-21T12:49:06.991Z
9470196 9470196 20260313045358_jeOQw UK0067 2026-03-14T12:06:42.076Z 2026-03-21T12:49:06.684Z
9470093 9470093 20260313043406_nAwWN UK0067 2026-03-14T12:06:26.808Z 2026-03-21T12:49:05.880Z
9469825 9469825 20260313034818_YuWEE UK0067 2026-03-14T12:05:39.922Z 2026-03-21T12:49:02.735Z
9457778 9457778 20260311053211_2Vqx7 UK0067 2026-03-12T12:04:34.433Z 2026-03-19T12:44:52.044Z
9451239 9451239 20260310012753_kpM0C UK0067 2026-03-11T12:02:13.098Z 2026-03-18T12:38:43.583Z
9430652 9430652 20260304202557_tjepi UK0067 2026-03-06T14:23:51.095Z 2026-03-12T12:33:39.441Z
9415097 9415097 20260228200158_Kq65P UK0067 2026-03-02T14:07:23.580Z 2026-03-08T12:43:01.541Z
9395213 9395213 20260224231221_O3yN7 UK0067 2026-02-26T14:21:11.961Z 2026-03-04T14:19:31.539Z
9381606 9381606 20260222234122_TUF41 UK0067 2026-02-24T14:24:58.935Z 2026-02-24T14:24:58.935Z
9381331 9381331 20260222215339_feVFj UK0067 2026-02-24T14:24:32.792Z 2026-02-24T14:24:32.792Z
9380997 9380997 20260222204244_OJG7s UK0067 2026-02-24T14:24:00.897Z 2026-02-24T14:24:00.897Z
9372882 9372882 20260223012344_Svu2t UK0067 2026-02-24T14:01:37.441Z 2026-03-03T14:30:48.158Z
9372508 9372508 20260223002856_TiiOJ UK0067 2026-02-24T14:00:47.348Z 2026-03-03T14:30:41.660Z
9352078 9352078 20260220014110_IG435 UK0067 2026-02-21T14:00:29.868Z 2026-03-01T14:21:31.969Z
9340125 9340125 20260216225815_Ntof4 UK0067 2026-02-18T14:24:06.835Z 2026-02-25T14:42:51.222Z
9340096 9340096 20260216225349_GTTxw UK0067 2026-02-18T14:24:00.728Z 2026-02-25T14:42:51.042Z
9340056 9340056 20260216224243_AAoX9 UK0067 2026-02-18T14:23:53.059Z 2026-02-25T14:42:50.061Z
9339911 9339911 20260216220137_cRwwk UK0067 2026-02-18T14:23:29.563Z 2026-02-25T14:42:48.288Z
9339800 9339800 20260216211104_6B34w UK0067 2026-02-18T14:23:04.433Z 2026-02-25T14:42:46.625Z
9339700 9339700 20260216202836_yTdcl UK0067 2026-02-18T14:22:27.109Z 2026-02-25T14:42:44.599Z
9339604 9339604 20260216195022_kqPbv UK0067 2026-02-18T14:21:47.949Z 2026-02-25T14:42:42.907Z
9337688 9337688 20260217061052_6E4V3 UK0067 2026-02-18T14:07:50.637Z 2026-02-26T14:39:28.582Z
9337526 9337526 20260217054912_0sINA UK0067 2026-02-18T14:07:28.010Z 2026-02-26T14:39:27.506Z
9337377 9337377 20260217052920_0DbPu UK0067 2026-02-18T14:07:04.361Z 2026-02-26T14:39:26.242Z
9336885 9336885 20260217044150_gQPYA UK0067 2026-02-18T14:05:47.226Z 2026-02-26T14:39:22.524Z
9336488 9336488 20260217035446_qYV0i UK0067 2026-02-18T14:04:31.138Z 2026-02-26T14:39:18.865Z
9336448 9336448 20260217035251_gTpO8 UK0067 2026-02-18T14:04:26.187Z 2026-02-26T14:39:18.671Z
9335902 9335902 20260217025002_4e0EU UK0067 2026-02-18T14:02:40.869Z 2026-02-26T14:38:59.461Z
9335124 9335124 20260216004745_4j2k0 UK0067 2026-02-17T14:26:27.009Z 2026-02-24T14:43:36.343Z
9335003 9335003 20260216001318_EOcfj UK0067 2026-02-17T14:26:02.934Z 2026-02-24T14:43:22.341Z
9334895 9334895 20260215232703_kQgmL UK0067 2026-02-17T14:25:38.997Z 2026-02-24T14:43:19.768Z
9334885 9334885 20260215232625_dxagB UK0067 2026-02-17T14:25:36.971Z 2026-02-24T14:43:19.467Z
9334219 9334219 20260215205541_YuKHJ UK0067 2026-02-17T14:23:34.356Z 2026-02-24T14:43:05.084Z
9331549 9331549 20260216055711_ujgFb UK0067 2026-02-17T14:07:03.652Z 2026-02-25T14:41:58.105Z
9331457 9331457 20260216052738_Rq8Xz UK0067 2026-02-17T14:06:39.238Z 2026-02-25T14:41:57.000Z
9331445 9331445 20260216052727_8f4Qj UK0067 2026-02-17T14:06:38.544Z 2026-02-25T14:41:56.933Z
9331263 9331263 20260216043732_EE7bw UK0067 2026-02-17T14:05:42.625Z 2026-02-25T14:41:51.661Z

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