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

6,288 rows where station_code = "UK007G" 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
9608967 9608967 20260404025202_pMJwZ UK007G 2026-04-05T12:12:25.434Z 2026-04-06T12:20:54.058Z
9607179 9607179 20260404041858_sWWtq UK007G 2026-04-05T12:00:45.932Z 2026-04-06T12:16:14.379Z
9607146 9607146 20260404035341_2Fak6 UK007G 2026-04-05T12:00:36.145Z 2026-04-06T12:16:14.372Z
9607032 9607032 20260404031629_3259a UK007G 2026-04-05T12:00:11.440Z 2026-04-06T12:16:14.347Z
9607030 9607030 20260404031629_U53In UK007G 2026-04-05T12:00:11.241Z 2026-04-06T12:16:14.346Z
9598584 9598584 20260330012503_PKqs5 UK007G 2026-03-31T12:10:58.599Z 2026-04-06T12:36:47.201Z
9598409 9598409 20260329235413_ovg5I UK007G 2026-03-31T12:10:33.593Z 2026-04-06T12:36:31.506Z
9595141 9595141 20260330023356_8wM9P UK007G 2026-03-31T12:00:35.535Z 2026-04-06T12:29:42.328Z
9595111 9595111 20260330022728_S0CeF UK007G 2026-03-31T12:00:30.603Z 2026-04-06T12:29:41.029Z
9594656 9594656 20260328234900_HUsQT UK007G 2026-03-30T12:10:07.220Z 2026-04-06T12:40:03.001Z
9594417 9594417 20260328221807_GrN3z UK007G 2026-03-30T12:09:32.188Z 2026-04-06T12:39:51.829Z
9591963 9591963 20260327232318_oqKD4 UK007G 2026-03-29T12:07:02.566Z 2026-04-05T12:35:22.659Z
9591928 9591928 20260327231252_Bowz2 UK007G 2026-03-29T12:06:59.724Z 2026-04-05T12:35:21.196Z
9589041 9589041 20260328021728_2jwyu UK007G 2026-03-29T12:00:40.335Z 2026-04-06T12:37:00.445Z
9588785 9588785 20260328011256_DAaJV UK007G 2026-03-29T12:00:15.261Z 2026-04-06T12:36:51.255Z
9581973 9581973 20260326041754_wjn3r UK007G 2026-03-27T12:04:17.863Z 2026-04-04T12:39:33.364Z
9581093 9581093 20260326022218_JgpwO UK007G 2026-03-27T12:02:07.438Z 2026-04-04T12:38:42.518Z
9576830 9576830 20260325031422_2D76S UK007G 2026-03-26T12:03:25.705Z 2026-04-03T12:36:22.718Z
9576657 9576657 20260325024826_wz0p0 UK007G 2026-03-26T12:02:55.809Z 2026-04-03T12:36:16.247Z
9576500 9576500 20260325022126_9Czup UK007G 2026-03-26T12:02:27.691Z 2026-04-03T12:36:10.025Z
9575827 9575827 20260325002148_0Rirr UK007G 2026-03-26T12:00:20.034Z 2026-04-03T12:35:23.662Z
9575457 9575457 20260323222846_yZWm7 UK007G 2026-03-25T12:21:11.370Z 2026-03-31T12:28:58.097Z
9571818 9571818 20260324043807_6E2PE UK007G 2026-03-25T12:02:49.731Z 2026-04-02T12:34:50.421Z
9551680 9551680 20260320205312_EV7yM UK007G 2026-03-22T12:26:55.837Z 2026-03-28T12:37:00.074Z
9543422 9543422 20260321035028_tla5U UK007G 2026-03-22T12:03:46.806Z 2026-03-29T12:19:07.373Z
9543247 9543247 20260321031306_4hg6J UK007G 2026-03-22T12:03:08.799Z 2026-03-29T12:19:04.939Z
9542739 9542739 20260321010744_KcDW3 UK007G 2026-03-22T12:01:28.499Z 2026-03-29T12:18:57.766Z
9542711 9542711 20260321005648_X0lvL UK007G 2026-03-22T12:01:20.843Z 2026-03-29T12:18:57.308Z
9542545 9542545 20260321001019_8ZVUl UK007G 2026-03-22T12:00:43.242Z 2026-03-29T12:18:45.473Z
9542304 9542304 20260319230914_Ac1zf UK007G 2026-03-21T12:29:56.701Z 2026-03-27T12:42:54.794Z
9533396 9533396 20260320022743_raRfK UK007G 2026-03-21T12:05:21.078Z 2026-03-28T12:33:52.753Z
9533141 9533141 20260320020415_Fay42 UK007G 2026-03-21T12:04:33.545Z 2026-03-28T12:33:49.211Z
9512033 9512033 20260318043539_29awc UK007G 2026-03-19T12:11:31.546Z 2026-03-26T12:37:41.716Z
9511873 9511873 20260318042634_osoWp UK007G 2026-03-19T12:11:13.873Z 2026-03-26T12:37:40.475Z
9511834 9511834 20260318042215_ZgkrQ UK007G 2026-03-19T12:11:07.302Z 2026-03-26T12:37:40.037Z
9509001 9509001 20260318012114_X76t3 UK007G 2026-03-19T12:04:17.167Z 2026-03-26T12:37:02.471Z
9508999 9508999 20260318012114_FvBT2 UK007G 2026-03-19T12:04:16.614Z 2026-03-26T12:37:02.439Z
9501408 9501408 20260315221155_b2enj UK007G 2026-03-17T12:24:57.596Z 2026-03-23T12:22:44.313Z
9501399 9501399 20260315220955_3WwZO UK007G 2026-03-17T12:24:56.865Z 2026-03-23T12:22:44.267Z
9501107 9501107 20260315210331_pd0HG UK007G 2026-03-17T12:24:26.146Z 2026-03-23T12:22:43.102Z
9500958 9500958 20260315202254_Rp5vH UK007G 2026-03-17T12:24:13.904Z 2026-03-23T12:22:42.520Z
9495242 9495242 20260316050700_6nhfu UK007G 2026-03-17T12:06:33.449Z 2026-03-24T12:41:07.182Z
9495229 9495229 20260316050022_nGSD3 UK007G 2026-03-17T12:06:30.211Z 2026-03-24T12:41:05.588Z
9495163 9495163 20260316042533_oVOOT UK007G 2026-03-17T12:06:15.946Z 2026-03-24T12:41:00.295Z
9494842 9494842 20260316031121_nql4Z UK007G 2026-03-17T12:05:12.141Z 2026-03-24T12:40:50.569Z
9494690 9494690 20260316024630_Ziu8M UK007G 2026-03-17T12:04:40.487Z 2026-03-24T12:40:49.367Z
9493762 9493762 20260316003324_92An2 UK007G 2026-03-17T12:01:59.214Z 2026-03-24T12:40:41.829Z
9493538 9493538 20260315234800_j3iFj UK007G 2026-03-17T12:01:12.535Z 2026-03-24T12:40:40.493Z
9493515 9493515 20260315234023_aqbPq UK007G 2026-03-17T12:01:06.923Z 2026-03-24T12:40:40.323Z
9492505 9492505 20260314210809_jzShN UK007G 2026-03-16T12:28:39.317Z 2026-03-22T12:42:52.759Z
9492300 9492300 20260314200923_RIM1F UK007G 2026-03-16T12:28:16.643Z 2026-03-22T12:42:51.543Z
9483083 9483083 20260313204315_yNJ82 UK007G 2026-03-15T12:25:51.841Z 2026-03-21T12:50:20.042Z
9477014 9477014 20260314040644_QyEAB UK007G 2026-03-15T12:07:27.068Z 2026-03-22T12:42:00.683Z
9476827 9476827 20260314034339_uZqXx UK007G 2026-03-15T12:06:58.193Z 2026-03-22T12:41:59.504Z
9476491 9476491 20260314031154_4ZWQZ UK007G 2026-03-15T12:06:08.388Z 2026-03-22T12:41:57.152Z
9469268 9469268 20260313022339_iz6gu UK007G 2026-03-14T12:03:39.907Z 2026-03-21T12:48:36.313Z
9469199 9469199 20260313021158_G5Q3g UK007G 2026-03-14T12:03:22.912Z 2026-03-21T12:48:34.926Z
9469091 9469091 20260313014801_mq5Uc UK007G 2026-03-14T12:02:57.607Z 2026-03-21T12:48:33.476Z
9469066 9469066 20260313013852_IF29A UK007G 2026-03-14T12:02:50.329Z 2026-03-21T12:48:33.086Z
9468967 9468967 20260313012542_L9wXd UK007G 2026-03-14T12:02:30.021Z 2026-03-21T12:48:31.970Z
9468890 9468890 20260313010729_9rcaq UK007G 2026-03-14T12:02:11.986Z 2026-03-21T12:48:30.964Z
9468604 9468604 20260312235308_zuPTU UK007G 2026-03-14T12:00:57.373Z 2026-03-21T12:48:26.888Z
9457758 9457758 20260311051250_MfhNu UK007G 2026-03-12T12:04:30.199Z 2026-03-19T12:44:51.721Z
9457461 9457461 20260311040101_oAdvr UK007G 2026-03-12T12:03:52.967Z 2026-03-19T12:44:44.449Z
9457353 9457353 20260311033948_CI1C3 UK007G 2026-03-12T12:03:38.060Z 2026-03-19T12:44:39.876Z
9457063 9457063 20260311022519_ukcFX UK007G 2026-03-12T12:02:43.634Z 2026-03-19T12:44:25.235Z
9456925 9456925 20260311014409_dRDul UK007G 2026-03-12T12:02:13.219Z 2026-03-19T12:44:23.695Z
9451899 9451899 20260310044708_OzSJ9 UK007G 2026-03-11T12:04:10.882Z 2026-03-18T12:39:06.639Z
9450335 9450335 20260308202426_CtqNI UK007G 2026-03-10T12:19:17.915Z 2026-03-16T12:44:40.654Z
9450229 9450229 20260308191647_de6dV UK007G 2026-03-10T12:18:56.839Z 2026-03-16T12:44:38.078Z
9447156 9447156 20260309052336_5o9R6 UK007G 2026-03-10T12:05:24.121Z 2026-03-17T12:41:48.348Z
9447053 9447053 20260309042015_B15ZX UK007G 2026-03-10T12:05:00.502Z 2026-03-17T12:41:46.947Z
9445834 9445834 20260307221318_e3xJA UK007G 2026-03-09T12:20:58.049Z 2026-03-15T12:42:14.776Z
9445524 9445524 20260307201624_8F2LV UK007G 2026-03-09T12:19:35.557Z 2026-03-15T12:42:10.455Z
9445492 9445492 20260307195533_hkCc8 UK007G 2026-03-09T12:19:26.514Z 2026-03-15T12:42:09.840Z
9445461 9445461 20260307194129_3cx5Y UK007G 2026-03-09T12:19:14.318Z 2026-03-15T12:42:09.127Z
9445434 9445434 20260307192636_Riaaz UK007G 2026-03-09T12:19:06.803Z 2026-03-15T12:42:08.600Z
9442624 9442624 20260308043433_wYEUH UK007G 2026-03-09T12:04:46.522Z 2026-03-16T12:43:54.227Z
9442504 9442504 20260308040037_QNUOh UK007G 2026-03-09T12:04:18.848Z 2026-03-16T12:43:52.488Z
9442428 9442428 20260308033120_S9BzL UK007G 2026-03-09T12:03:58.842Z 2026-03-16T12:43:51.342Z
9442293 9442293 20260308025810_ym005 UK007G 2026-03-09T12:03:26.467Z 2026-03-16T12:43:49.341Z
9442283 9442283 20260308025331_JFmpP UK007G 2026-03-09T12:03:23.618Z 2026-03-16T12:43:48.981Z
9442075 9442075 20260308012133_95bJN UK007G 2026-03-09T12:02:31.092Z 2026-03-16T12:43:36.398Z
9441963 9441963 20260308003623_FgB3O UK007G 2026-03-09T12:02:01.083Z 2026-03-16T12:43:34.628Z
9441915 9441915 20260308002130_E2Kwp UK007G 2026-03-09T12:01:47.922Z 2026-03-16T12:43:33.918Z
9441857 9441857 20260308000137_OP1dw UK007G 2026-03-09T12:01:32.054Z 2026-03-16T12:43:32.371Z
9441801 9441801 20260307234829_CbL9s UK007G 2026-03-09T12:01:19.020Z 2026-03-16T12:43:31.601Z
9441776 9441776 20260307233913_DCsxl UK007G 2026-03-09T12:01:09.521Z 2026-03-16T12:43:31.042Z
9441647 9441647 20260307230300_nSXKA UK007G 2026-03-09T12:00:33.126Z 2026-03-16T12:43:28.979Z
9441601 9441601 20260307225016_nksif UK007G 2026-03-09T12:00:23.005Z 2026-03-16T12:43:28.231Z
9441568 9441568 20260307223915_K3szU UK007G 2026-03-09T12:00:11.174Z 2026-03-16T12:43:27.511Z
9441196 9441196 20260306202458_2KPNP UK007G 2026-03-08T12:20:49.087Z 2026-03-14T12:40:46.765Z
9441112 9441112 20260306195030_bVtlh UK007G 2026-03-08T12:20:27.102Z 2026-03-14T12:40:44.496Z
9437477 9437477 20260307035324_Tvz1T UK007G 2026-03-08T12:04:07.852Z 2026-03-15T12:41:07.985Z
9437186 9437186 20260307022722_OMaZl UK007G 2026-03-08T12:02:56.886Z 2026-03-15T12:41:03.953Z
9437179 9437179 20260307022617_9UhZe UK007G 2026-03-08T12:02:55.135Z 2026-03-15T12:41:03.269Z
9436843 9436843 20260307001515_y4IwV UK007G 2026-03-08T12:01:27.169Z 2026-03-15T12:40:58.419Z
9436631 9436631 20260306230237_cgmcW UK007G 2026-03-08T12:00:28.180Z 2026-03-15T12:40:55.612Z
9436596 9436596 20260306224809_b2B28 UK007G 2026-03-08T12:00:16.238Z 2026-03-15T12:40:55.137Z
9430573 9430573 20260304195507_kp2fN UK007G 2026-03-06T14:23:32.398Z 2026-03-12T12:33:38.291Z

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