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,175 rows where station_code = "UK009L" 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
9609025 9609025 20260404030628_yeLCt UK009L 2026-04-05T12:12:37.943Z 2026-04-06T12:20:57.623Z
9608844 9608844 20260404015751_FOkp0 UK009L 2026-04-05T12:11:56.047Z 2026-04-06T12:20:42.803Z
9608750 9608750 20260404011053_zdOf7 UK009L 2026-04-05T12:11:30.502Z 2026-04-06T12:20:35.162Z
9608743 9608743 20260404011048_alQUb UK009L 2026-04-05T12:11:29.886Z 2026-04-06T12:20:34.938Z
9608479 9608479 20260403231754_S4u6q UK009L 2026-04-05T12:10:32.764Z 2026-04-06T12:20:14.801Z
9602389 9602389 20260331204501_AQVa9 UK009L 2026-04-02T12:08:39.048Z 2026-04-06T12:29:04.752Z
9598504 9598504 20260330005215_u6MVu UK009L 2026-03-31T12:10:46.514Z 2026-04-06T12:36:35.779Z
9598470 9598470 20260330003546_Uct91 UK009L 2026-03-31T12:10:40.568Z 2026-04-06T12:36:33.922Z
9598460 9598460 20260330003253_ELpEi UK009L 2026-03-31T12:10:39.438Z 2026-04-06T12:36:33.506Z
9598457 9598457 20260330003139_K5PRq UK009L 2026-03-31T12:10:39.034Z 2026-04-06T12:36:33.335Z
9595456 9595456 20260330040905_auOEB UK009L 2026-03-31T12:01:28.547Z 2026-04-06T12:30:04.732Z
9595383 9595383 20260330034728_fN3qj UK009L 2026-03-31T12:01:14.807Z 2026-04-06T12:30:00.178Z
9595288 9595288 20260330031457_ZsCQj UK009L 2026-03-31T12:00:58.759Z 2026-04-06T12:29:51.444Z
9595268 9595268 20260330031448_kn2wV UK009L 2026-03-31T12:00:57.057Z 2026-04-06T12:29:50.960Z
9595226 9595226 20260330030729_qdQ5w UK009L 2026-03-31T12:00:50.433Z 2026-04-06T12:29:48.960Z
9595160 9595160 20260330024054_uM9Vp UK009L 2026-03-31T12:00:39.019Z 2026-04-06T12:29:43.660Z
9595117 9595117 20260330023034_yL3jW UK009L 2026-03-31T12:00:31.581Z 2026-04-06T12:29:41.340Z
9595085 9595085 20260330021601_pkI8G UK009L 2026-03-31T12:00:25.857Z 2026-04-06T12:29:39.812Z
9595081 9595081 20260330021451_UcdnQ UK009L 2026-03-31T12:00:24.474Z 2026-04-06T12:29:39.508Z
9594957 9594957 20260329010828_pqvlY UK009L 2026-03-30T12:10:41.118Z 2026-04-06T12:40:21.580Z
9594803 9594803 20260329003224_gg5TW UK009L 2026-03-30T12:10:20.414Z 2026-04-06T12:40:16.279Z
9594771 9594771 20260329003149_DA93G UK009L 2026-03-30T12:10:18.049Z 2026-04-06T12:40:15.464Z
9594686 9594686 20260328235525_18efH UK009L 2026-03-30T12:10:09.862Z 2026-04-06T12:40:03.859Z
9594671 9594671 20260328235038_252Tu UK009L 2026-03-30T12:10:08.498Z 2026-04-06T12:40:03.419Z
9594498 9594498 20260328223859_OKeyF UK009L 2026-03-30T12:09:41.385Z 2026-04-06T12:39:54.493Z
9594461 9594461 20260328223154_erGWv UK009L 2026-03-30T12:09:38.256Z 2026-04-06T12:39:53.322Z
9594389 9594389 20260328220610_Ya9PO UK009L 2026-03-30T12:09:27.659Z 2026-04-06T12:39:50.536Z
9594351 9594351 20260328214059_NTcNB UK009L 2026-03-30T12:09:21.783Z 2026-04-06T12:39:48.920Z
9594240 9594240 20260328203141_hsdx5 UK009L 2026-03-30T12:09:03.585Z 2026-04-06T12:39:44.390Z
9594227 9594227 20260328202750_mZ563 UK009L 2026-03-30T12:09:02.269Z 2026-04-06T12:39:43.893Z
9592991 9592991 20260329041145_a1NMe UK009L 2026-03-30T12:02:32.064Z 2026-04-06T12:34:44.061Z
9592984 9592984 20260329040916_CJbRT UK009L 2026-03-30T12:02:30.987Z 2026-04-06T12:34:43.759Z
9592780 9592780 20260329032234_gL40V UK009L 2026-03-30T12:01:55.798Z 2026-04-06T12:34:28.210Z
9592694 9592694 20260329030410_sXqtD UK009L 2026-03-30T12:01:38.599Z 2026-04-06T12:34:21.518Z
9592625 9592625 20260329024807_ieG6s UK009L 2026-03-30T12:01:27.201Z 2026-04-06T12:34:18.091Z
9592231 9592231 20260329012634_mkQgA UK009L 2026-03-30T12:00:25.936Z 2026-04-06T12:33:54.514Z
9592205 9592205 20260329012231_NrNAD UK009L 2026-03-30T12:00:22.998Z 2026-04-06T12:33:53.734Z
9589791 9589791 20260328040857_pKiwb UK009L 2026-03-29T12:01:38.466Z 2026-04-06T12:37:33.626Z
9589769 9589769 20260328040624_IH222 UK009L 2026-03-29T12:01:37.295Z 2026-04-06T12:37:33.006Z
9589520 9589520 20260328033840_e0f02 UK009L 2026-03-29T12:01:23.307Z 2026-04-06T12:37:26.627Z
9589452 9589452 20260328033025_xN2RJ UK009L 2026-03-29T12:01:16.433Z 2026-04-06T12:37:24.140Z
9589366 9589366 20260328032120_9KP7W UK009L 2026-03-29T12:01:09.432Z 2026-04-06T12:37:21.223Z
9589321 9589321 20260328031734_e35Hx UK009L 2026-03-29T12:01:06.728Z 2026-04-06T12:37:20.228Z
9589096 9589096 20260328022610_cycWf UK009L 2026-03-29T12:00:42.973Z 2026-04-06T12:37:01.710Z
9589079 9589079 20260328022230_FXJJZ UK009L 2026-03-29T12:00:42.141Z 2026-04-06T12:37:01.276Z
9589013 9589013 20260328021248_jcZ1E UK009L 2026-03-29T12:00:37.466Z 2026-04-06T12:36:59.192Z
9585310 9585310 20260326001209_AW4C8 UK009L 2026-03-27T12:17:06.256Z 2026-04-03T12:39:54.515Z
9584845 9584845 20260325222714_fFuAH UK009L 2026-03-27T12:16:15.334Z 2026-04-03T12:39:42.250Z
9584731 9584731 20260325215038_ep3bt UK009L 2026-03-27T12:16:01.188Z 2026-04-03T12:39:30.982Z
9584488 9584488 20260325200656_heOVP UK009L 2026-03-27T12:15:27.796Z 2026-04-03T12:39:16.443Z
9581770 9581770 20260326035611_3U2Hi UK009L 2026-03-27T12:03:50.184Z 2026-04-04T12:39:20.353Z
9581639 9581639 20260326033629_MNio6 UK009L 2026-03-27T12:03:31.581Z 2026-04-04T12:39:12.770Z
9581333 9581333 20260326025417_ajLMT UK009L 2026-03-27T12:02:44.801Z 2026-04-04T12:38:52.973Z
9581295 9581295 20260326024702_2Cqdr UK009L 2026-03-27T12:02:39.678Z 2026-04-04T12:38:51.919Z
9581012 9581012 20260326020818_zPVnZ UK009L 2026-03-27T12:01:54.025Z 2026-04-04T12:38:39.512Z
9580936 9580936 20260326015506_ZOL3Z UK009L 2026-03-27T12:01:43.233Z 2026-04-04T12:38:34.699Z
9580920 9580920 20260326015241_cEP5Z UK009L 2026-03-27T12:01:41.388Z 2026-04-04T12:38:33.694Z
9580632 9580632 20260326011104_xTsLH UK009L 2026-03-27T12:00:59.779Z 2026-04-04T12:38:18.823Z
9580534 9580534 20260326005742_FMLj3 UK009L 2026-03-27T12:00:42.327Z 2026-04-04T12:38:13.082Z
9580363 9580363 20260326003912_93qzV UK009L 2026-03-27T12:00:16.589Z 2026-04-04T12:38:07.346Z
9580331 9580331 20260326003059_3ZxO2 UK009L 2026-03-27T12:00:11.783Z 2026-04-04T12:38:06.084Z
9580074 9580074 20260325000038_rIi2A UK009L 2026-03-26T12:15:02.527Z 2026-04-02T12:37:41.187Z
9579778 9579778 20260324224824_zFO3a UK009L 2026-03-26T12:14:23.579Z 2026-04-02T12:37:29.752Z
9579750 9579750 20260324224147_A5v4N UK009L 2026-03-26T12:14:20.052Z 2026-04-02T12:37:28.619Z
9576419 9576419 20260325020417_cVgyr UK009L 2026-03-26T12:02:09.105Z 2026-04-03T12:35:57.859Z
9576409 9576409 20260325020202_CBPH9 UK009L 2026-03-26T12:02:07.753Z 2026-04-03T12:35:57.530Z
9576270 9576270 20260325014552_z5HKQ UK009L 2026-03-26T12:01:46.335Z 2026-04-03T12:35:51.108Z
9576087 9576087 20260325011100_ACLo9 UK009L 2026-03-26T12:01:13.381Z 2026-04-03T12:35:43.527Z
9576079 9576079 20260325010947_EnWq5 UK009L 2026-03-26T12:01:12.699Z 2026-04-03T12:35:43.426Z
9575886 9575886 20260325003416_wjPRU UK009L 2026-03-26T12:00:32.509Z 2026-04-03T12:35:27.671Z
9575815 9575815 20260325002103_k2NyJ UK009L 2026-03-26T12:00:17.754Z 2026-04-03T12:35:23.230Z
9517253 9517253 20260317225853_PoOU4 UK009L 2026-03-19T12:27:22.298Z 2026-03-25T12:43:09.636Z
9517016 9517016 20260317222701_oZrwZ UK009L 2026-03-19T12:27:05.153Z 2026-03-25T12:43:08.070Z
9516927 9516927 20260317221534_98YwW UK009L 2026-03-19T12:26:54.825Z 2026-03-25T12:43:07.563Z
9516909 9516909 20260317221223_vEvKW UK009L 2026-03-19T12:26:53.751Z 2026-03-25T12:43:07.474Z
9516895 9516895 20260317221222_DN0JX UK009L 2026-03-19T12:26:53.527Z 2026-03-25T12:43:07.466Z
9516803 9516803 20260317220003_NbO6T UK009L 2026-03-19T12:26:48.262Z 2026-03-25T12:43:07.071Z
9516758 9516758 20260317215345_AN1t2 UK009L 2026-03-19T12:26:45.045Z 2026-03-25T12:43:06.730Z
9516141 9516141 20260317200603_2uCaZ UK009L 2026-03-19T12:25:42.950Z 2026-03-25T12:42:49.310Z
9516011 9516011 20260317194144_LD7kT UK009L 2026-03-19T12:25:31.256Z 2026-03-25T12:42:45.861Z
9510118 9510118 20260318023225_307aY UK009L 2026-03-19T12:06:54.313Z 2026-03-26T12:37:09.939Z
9510101 9510101 20260318023225_LStiz UK009L 2026-03-19T12:06:53.872Z 2026-03-26T12:37:09.930Z
9509911 9509911 20260318022028_hed4h UK009L 2026-03-19T12:06:25.945Z 2026-03-26T12:37:08.462Z
9509896 9509896 20260318022028_9WNl8 UK009L 2026-03-19T12:06:25.568Z 2026-03-26T12:37:08.441Z
9509219 9509219 20260318013359_4tQt2 UK009L 2026-03-19T12:04:48.527Z 2026-03-26T12:37:04.013Z
9508084 9508084 20260318001142_yYHCn UK009L 2026-03-19T12:02:07.889Z 2026-03-26T12:36:55.568Z
9508061 9508061 20260318001034_ZaurM UK009L 2026-03-19T12:02:04.660Z 2026-03-26T12:36:55.408Z
9508030 9508030 20260318000757_8Ohyw UK009L 2026-03-19T12:01:57.446Z 2026-03-26T12:36:55.094Z
9507982 9507982 20260317235859_UxuyC UK009L 2026-03-19T12:01:50.464Z 2026-03-26T12:36:54.816Z
9507831 9507831 20260317234555_CtvwB UK009L 2026-03-19T12:01:24.372Z 2026-03-26T12:36:53.802Z
9507780 9507780 20260317234238_cIQs1 UK009L 2026-03-19T12:01:15.672Z 2026-03-26T12:36:53.499Z
9507722 9507722 20260317233721_W192o UK009L 2026-03-19T12:01:04.397Z 2026-03-26T12:36:52.847Z
9507692 9507692 20260317233523_PmY7E UK009L 2026-03-19T12:01:00.830Z 2026-03-26T12:36:52.653Z
9500973 9500973 20260315203131_2nauO UK009L 2026-03-17T12:24:15.325Z 2026-03-23T12:22:42.622Z
9494894 9494894 20260316032452_YPNo3 UK009L 2026-03-17T12:05:23.195Z 2026-03-24T12:40:50.988Z
9494642 9494642 20260316024033_Hgnhi UK009L 2026-03-17T12:04:29.394Z 2026-03-24T12:40:49.017Z
9494403 9494403 20260316021046_789Ly UK009L 2026-03-17T12:03:54.097Z 2026-03-24T12:40:47.447Z
9494316 9494316 20260316015452_pb3Q3 UK009L 2026-03-17T12:03:35.799Z 2026-03-24T12:40:46.878Z
9494020 9494020 20260316011200_qiD22 UK009L 2026-03-17T12:02:47.090Z 2026-03-24T12:40:43.977Z
9493878 9493878 20260316005101_XEFJT UK009L 2026-03-17T12:02:19.185Z 2026-03-24T12:40:42.812Z

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