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

>10,000 rows count all where station_code = "UK008F" 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
9610950 9610950 20260404230048_raJNI UK008F 2026-04-06T12:12:12.511Z 2026-04-06T12:16:14.697Z
9610943 9610943 20260404230026_cJ6kC UK008F 2026-04-06T12:12:10.947Z 2026-04-06T12:16:14.695Z
9609210 9609210 20260405035933_L1KrQ UK008F 2026-04-06T12:00:43.457Z 2026-04-06T12:00:43.457Z
9608642 9608642 20260404001404_ZurSW UK008F 2026-04-05T12:11:04.955Z 2026-04-06T12:20:27.966Z
9608206 9608206 20260403205438_xzqBw UK008F 2026-04-05T12:09:33.523Z 2026-04-06T12:19:56.007Z
9607155 9607155 20260404040548_eq9Ak UK008F 2026-04-05T12:00:37.708Z 2026-04-06T12:16:14.373Z
9602398 9602398 20260331204824_8qTQg UK008F 2026-04-02T12:08:42.628Z 2026-04-06T12:29:05.352Z
9602355 9602355 20260331201856_EKGvf UK008F 2026-04-02T12:08:32.793Z 2026-04-06T12:29:01.863Z
9598373 9598373 20260329233753_Px365 UK008F 2026-03-31T12:10:29.252Z 2026-04-06T12:36:27.990Z
9595465 9595465 20260330040906_4bcEw UK008F 2026-03-31T12:01:29.265Z 2026-04-06T12:30:05.054Z
9595446 9595446 20260330040711_r4ygq UK008F 2026-03-31T12:01:26.490Z 2026-04-06T12:30:03.996Z
9595387 9595387 20260330034806_LvIeQ UK008F 2026-03-31T12:01:15.325Z 2026-04-06T12:30:00.301Z
9595375 9595375 20260330034728_sUD9A UK008F 2026-03-31T12:01:14.174Z 2026-04-06T12:29:59.850Z
9594954 9594954 20260329010828_pqvlY UK008F 2026-03-30T12:10:41.118Z 2026-04-06T12:40:21.580Z
9594941 9594941 20260329010620_ZQSXq UK008F 2026-03-30T12:10:39.800Z 2026-04-06T12:40:21.149Z
9594881 9594881 20260329005422_33g5K UK008F 2026-03-30T12:10:31.366Z 2026-04-06T12:40:19.427Z
9594669 9594669 20260328235038_252Tu UK008F 2026-03-30T12:10:08.498Z 2026-04-06T12:40:03.419Z
9594654 9594654 20260328234719_UtVYi UK008F 2026-03-30T12:10:06.799Z 2026-04-06T12:40:02.902Z
9594511 9594511 20260328224601_20gsz UK008F 2026-03-30T12:09:43.315Z 2026-04-06T12:39:55.160Z
9594369 9594369 20260328215356_0TpVH UK008F 2026-03-30T12:09:24.402Z 2026-04-06T12:39:49.741Z
9592883 9592883 20260329034517_WiV3c UK008F 2026-03-30T12:02:13.187Z 2026-04-06T12:34:38.934Z
9592693 9592693 20260329030410_sXqtD UK008F 2026-03-30T12:01:38.599Z 2026-04-06T12:34:21.518Z
9592510 9592510 20260329021944_iLH7U UK008F 2026-03-30T12:01:09.434Z 2026-04-06T12:34:13.241Z
9592237 9592237 20260329012928_23dfk UK008F 2026-03-30T12:00:26.492Z 2026-04-06T12:33:54.712Z
9592228 9592228 20260329012634_mkQgA UK008F 2026-03-30T12:00:25.893Z 2026-04-06T12:33:54.514Z
9592116 9592116 20260328003839_InZcL UK008F 2026-03-29T12:07:11.464Z 2026-04-05T12:35:37.394Z
9592035 9592035 20260328000116_zr4KI UK008F 2026-03-29T12:07:07.331Z 2026-04-05T12:35:24.905Z
9592023 9592023 20260327235929_6v0iH UK008F 2026-03-29T12:07:06.653Z 2026-04-05T12:35:24.531Z
9589978 9589978 20260328042335_3jiPt UK008F 2026-03-29T12:01:48.027Z 2026-04-06T12:37:39.581Z
9589766 9589766 20260328040624_IH222 UK008F 2026-03-29T12:01:37.295Z 2026-04-06T12:37:33.006Z
9589475 9589475 20260328033426_6hZpI UK008F 2026-03-29T12:01:19.321Z 2026-04-06T12:37:25.348Z
9589318 9589318 20260328031734_e35Hx UK008F 2026-03-29T12:01:06.728Z 2026-04-06T12:37:20.228Z
9589110 9589110 20260328022741_aoKw3 UK008F 2026-03-29T12:00:43.777Z 2026-04-06T12:37:01.986Z
9589075 9589075 20260328022230_FXJJZ UK008F 2026-03-29T12:00:42.141Z 2026-04-06T12:37:01.276Z
9589018 9589018 20260328021319_LITn3 UK008F 2026-03-29T12:00:37.835Z 2026-04-06T12:36:59.327Z
9588773 9588773 20260328011211_w1j2L UK008F 2026-03-29T12:00:13.619Z 2026-04-06T12:36:50.775Z
9588751 9588751 20260328005824_nGO3A UK008F 2026-03-29T12:00:09.547Z 2026-04-06T12:36:49.667Z
9585026 9585026 20260325230656_Ha3wx UK008F 2026-03-27T12:16:33.034Z 2026-04-03T12:39:46.844Z
9584942 9584942 20260325225153_baO6V UK008F 2026-03-27T12:16:25.162Z 2026-04-03T12:39:44.883Z
9584843 9584843 20260325222714_fFuAH UK008F 2026-03-27T12:16:15.334Z 2026-04-03T12:39:42.250Z
9584818 9584818 20260325222152_Kj3J5 UK008F 2026-03-27T12:16:10.442Z 2026-04-03T12:39:41.628Z
9584730 9584730 20260325215038_ep3bt UK008F 2026-03-27T12:16:01.188Z 2026-04-03T12:39:30.982Z
9584685 9584685 20260325213555_z2TiH UK008F 2026-03-27T12:15:57.699Z 2026-04-03T12:39:26.382Z
9584604 9584604 20260325210619_oQmwj UK008F 2026-03-27T12:15:48.313Z 2026-04-03T12:39:23.704Z
9582159 9582159 20260326044244_kSlFq UK008F 2026-03-27T12:04:44.617Z 2026-04-04T12:39:39.069Z
9582156 9582156 20260326044233_3wgLX UK008F 2026-03-27T12:04:44.049Z 2026-04-04T12:39:38.874Z
9582134 9582134 20260326044055_FeCwM UK008F 2026-03-27T12:04:42.839Z 2026-04-04T12:39:38.587Z
9581792 9581792 20260326035630_FVNaQ UK008F 2026-03-27T12:03:51.173Z 2026-04-04T12:39:20.543Z
9581768 9581768 20260326035611_3U2Hi UK008F 2026-03-27T12:03:50.184Z 2026-04-04T12:39:20.353Z
9581745 9581745 20260326035448_ETQQI UK008F 2026-03-27T12:03:47.778Z 2026-04-04T12:39:18.009Z
9581587 9581587 20260326033246_5tDNt UK008F 2026-03-27T12:03:26.862Z 2026-04-04T12:39:11.295Z
9581572 9581572 20260326033136_H7QUJ UK008F 2026-03-27T12:03:25.762Z 2026-04-04T12:39:11.002Z
9581293 9581293 20260326024702_2Cqdr UK008F 2026-03-27T12:02:39.678Z 2026-04-04T12:38:51.919Z
9581248 9581248 20260326024327_7p2ms UK008F 2026-03-27T12:02:31.645Z 2026-04-04T12:38:48.635Z
9581193 9581193 20260326023416_zUB2z UK008F 2026-03-27T12:02:20.569Z 2026-04-04T12:38:45.264Z
9581140 9581140 20260326022937_tgf3C UK008F 2026-03-27T12:02:14.532Z 2026-04-04T12:38:43.961Z
9580946 9580946 20260326015715_T79vB UK008F 2026-03-27T12:01:44.895Z 2026-04-04T12:38:35.527Z
9580918 9580918 20260326015241_cEP5Z UK008F 2026-03-27T12:01:41.388Z 2026-04-04T12:38:33.694Z
9580760 9580760 20260326012729_Yrky3 UK008F 2026-03-27T12:01:21.828Z 2026-04-04T12:38:27.956Z
9580723 9580723 20260326012234_fGn3C UK008F 2026-03-27T12:01:14.937Z 2026-04-04T12:38:21.530Z
9580630 9580630 20260326011104_xTsLH UK008F 2026-03-27T12:00:59.779Z 2026-04-04T12:38:18.823Z
9580420 9580420 20260326004652_yRJWL UK008F 2026-03-27T12:00:26.135Z 2026-04-04T12:38:09.521Z
9580362 9580362 20260326003912_93qzV UK008F 2026-03-27T12:00:16.589Z 2026-04-04T12:38:07.346Z
9580354 9580354 20260326003906_bYRGT UK008F 2026-03-27T12:00:15.627Z 2026-04-04T12:38:07.135Z
9580314 9580314 20260326002905_cEIhe UK008F 2026-03-27T12:00:09.681Z 2026-04-04T12:38:05.366Z
9577314 9577314 20260325045134_ffJ4A UK008F 2026-03-26T12:04:45.539Z 2026-04-03T12:36:56.329Z
9577019 9577019 20260325033857_3SdGT UK008F 2026-03-26T12:03:54.643Z 2026-04-03T12:36:29.528Z
9576843 9576843 20260325031535_fyv8C UK008F 2026-03-26T12:03:27.870Z 2026-04-03T12:36:23.224Z
9576692 9576692 20260325025511_PICa2 UK008F 2026-03-26T12:03:01.072Z 2026-04-03T12:36:17.683Z
9576675 9576675 20260325025123_vu9uj UK008F 2026-03-26T12:02:58.883Z 2026-04-03T12:36:17.058Z
9576623 9576623 20260325024440_Sx0Q9 UK008F 2026-03-26T12:02:49.711Z 2026-04-03T12:36:15.028Z
9576597 9576597 20260325023730_qlGZN UK008F 2026-03-26T12:02:43.501Z 2026-04-03T12:36:13.895Z
9561008 9561008 20260321224508_Gnmmi UK008F 2026-03-23T12:12:09.332Z 2026-03-29T12:21:04.587Z
9560869 9560869 20260321223002_4QiV3 UK008F 2026-03-23T12:12:05.990Z 2026-03-29T12:21:03.502Z
9560457 9560457 20260321212723_saCUi UK008F 2026-03-23T12:11:47.879Z 2026-03-29T12:21:00.488Z
9560403 9560403 20260321211309_C68na UK008F 2026-03-23T12:11:45.339Z 2026-03-29T12:20:59.911Z
9560305 9560305 20260321210007_LcNga UK008F 2026-03-23T12:11:41.889Z 2026-03-29T12:20:59.152Z
9559747 9559747 20260321193854_2DfxA UK008F 2026-03-23T12:11:28.755Z 2026-03-29T12:20:50.293Z
9559721 9559721 20260321193404_ivPyn UK008F 2026-03-23T12:11:28.127Z 2026-03-29T12:20:47.166Z
9559697 9559697 20260321193309_CDvCN UK008F 2026-03-23T12:11:27.449Z 2026-03-29T12:20:46.497Z
9555402 9555402 20260322044813_My0gm UK008F 2026-03-23T12:03:23.795Z 2026-03-30T12:28:25.991Z
9555222 9555222 20260322042621_fhWTF UK008F 2026-03-23T12:03:16.029Z 2026-03-30T12:28:23.070Z
9555030 9555030 20260322035608_fAV9w UK008F 2026-03-23T12:03:03.431Z 2026-03-30T12:28:13.448Z
9554998 9554998 20260322035240_lo4yM UK008F 2026-03-23T12:03:01.417Z 2026-03-30T12:28:12.942Z
9554714 9554714 20260322032926_TMyJk UK008F 2026-03-23T12:02:47.861Z 2026-03-30T12:28:07.863Z
9554134 9554134 20260322024247_4tP3P UK008F 2026-03-23T12:02:15.818Z 2026-03-30T12:27:58.893Z
9554086 9554086 20260322023820_ysWoV UK008F 2026-03-23T12:02:13.230Z 2026-03-30T12:27:58.133Z
9554052 9554052 20260322023455_3R8JN UK008F 2026-03-23T12:02:11.364Z 2026-03-30T12:27:57.513Z
9553964 9553964 20260322022919_w7VZ8 UK008F 2026-03-23T12:02:03.911Z 2026-03-30T12:27:56.067Z
9553923 9553923 20260322022449_K6i2w UK008F 2026-03-23T12:02:00.305Z 2026-03-30T12:27:55.206Z
9553826 9553826 20260322021815_ArMBL UK008F 2026-03-23T12:01:53.784Z 2026-03-30T12:27:53.153Z
9553573 9553573 20260322015456_lo73F UK008F 2026-03-23T12:01:40.827Z 2026-03-30T12:27:49.442Z
9553212 9553212 20260322012507_TZvhq UK008F 2026-03-23T12:01:19.512Z 2026-03-30T12:27:38.030Z
9552986 9552986 20260322010103_qvhYV UK008F 2026-03-23T12:01:07.228Z 2026-03-30T12:27:33.319Z
9552713 9552713 20260322003420_z1GgA UK008F 2026-03-23T12:00:45.227Z 2026-03-30T12:27:28.764Z
9552667 9552667 20260322002921_D0kwZ UK008F 2026-03-23T12:00:41.670Z 2026-03-30T12:27:27.860Z
9552577 9552577 20260322002138_W3Ppx UK008F 2026-03-23T12:00:35.027Z 2026-03-30T12:27:26.259Z
9552427 9552427 20260322000602_uRgGb UK008F 2026-03-23T12:00:23.838Z 2026-03-30T12:27:23.926Z
9552372 9552372 20260321235721_0hSjj UK008F 2026-03-23T12:00:18.294Z 2026-03-30T12:27:22.962Z
9552190 9552190 20260320231133_rov93 UK008F 2026-03-22T12:27:31.615Z 2026-03-28T12:37:07.719Z

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