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,119 rows where station_code = "US005Z" 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
9611803 9611803 20260405032828_MkCbW US005Z 2026-04-06T12:16:07.766Z 2026-04-06T12:16:14.866Z
9610053 9610053 20260405121338_ZgnVJ US005Z 2026-04-06T12:05:26.430Z 2026-04-06T12:05:26.430Z
9609990 9609990 20260405114013_S3fIS US005Z 2026-04-06T12:05:07.363Z 2026-04-06T12:05:07.363Z
9609883 9609883 20260405104415_OUqlU US005Z 2026-04-06T12:04:28.231Z 2026-04-06T12:04:28.231Z
9609847 9609847 20260405103238_j0Y0d US005Z 2026-04-06T12:04:18.732Z 2026-04-06T12:04:18.732Z
9609837 9609837 20260405102635_i9h1M US005Z 2026-04-06T12:04:12.141Z 2026-04-06T12:04:12.141Z
9609802 9609802 20260405100952_JGvct US005Z 2026-04-06T12:03:55.966Z 2026-04-06T12:03:55.966Z
9609781 9609781 20260405095707_kEi7S US005Z 2026-04-06T12:03:51.232Z 2026-04-06T12:03:51.232Z
9609769 9609769 20260405095237_VEXU4 US005Z 2026-04-06T12:03:48.307Z 2026-04-06T12:03:48.307Z
9609686 9609686 20260405091045_WbYKW US005Z 2026-04-06T12:03:19.479Z 2026-04-06T12:03:19.479Z
9609640 9609640 20260405085231_9zpoL US005Z 2026-04-06T12:03:01.579Z 2026-04-06T12:03:01.579Z
9609547 9609547 20260405080451_mPfNE US005Z 2026-04-06T12:02:29.098Z 2026-04-06T12:02:29.098Z
9609517 9609517 20260405074437_pj3nV US005Z 2026-04-06T12:02:18.259Z 2026-04-06T12:02:18.259Z
9609515 9609515 20260405073847_llJGK US005Z 2026-04-06T12:02:17.531Z 2026-04-06T12:02:17.531Z
9609457 9609457 20260405065121_AcPhW US005Z 2026-04-06T12:01:49.559Z 2026-04-06T12:01:49.559Z
9609356 9609356 20260405050330_lvMVc US005Z 2026-04-06T12:01:22.801Z 2026-04-06T12:01:22.801Z
9609354 9609354 20260405050200_toEde US005Z 2026-04-06T12:01:21.921Z 2026-04-06T12:01:21.921Z
9607723 9607723 20260404120752_3bU3E US005Z 2026-04-05T12:03:44.986Z 2026-04-06T12:16:14.500Z
9607667 9607667 20260404113618_ASJbE US005Z 2026-04-05T12:03:23.216Z 2026-04-06T12:16:14.485Z
9607526 9607526 20260404102241_NCB8r US005Z 2026-04-05T12:02:46.369Z 2026-04-06T12:16:14.456Z
9607524 9607524 20260404101944_QREto US005Z 2026-04-05T12:02:45.789Z 2026-04-06T12:16:14.455Z
9607294 9607294 20260404070724_EQO0U US005Z 2026-04-05T12:01:27.655Z 2026-04-06T12:16:14.403Z
9605821 9605821 20260403121031_pTgul US005Z 2026-04-04T12:04:02.443Z 2026-04-06T12:18:26.122Z
9605797 9605797 20260403120648_r372f US005Z 2026-04-04T12:03:57.606Z 2026-04-06T12:18:23.438Z
9605674 9605674 20260403112553_dRGxs US005Z 2026-04-04T12:03:25.274Z 2026-04-06T12:18:11.719Z
9603214 9603214 20260402084549_9NfXI US005Z 2026-04-03T12:02:09.410Z 2026-04-06T12:21:47.120Z
9596429 9596429 20260330123534_flfuc US005Z 2026-03-31T12:04:14.109Z 2026-04-06T12:31:13.752Z
9596363 9596363 20260330122415_xWWmE US005Z 2026-03-31T12:04:06.130Z 2026-04-06T12:31:10.916Z
9596339 9596339 20260330121956_V2o16 US005Z 2026-03-31T12:04:03.694Z 2026-04-06T12:31:09.913Z
9596244 9596244 20260330115609_uc9p3 US005Z 2026-03-31T12:03:49.669Z 2026-04-06T12:31:05.297Z
9596225 9596225 20260330115037_woeL9 US005Z 2026-03-31T12:03:47.616Z 2026-04-06T12:31:04.499Z
9591011 9591011 20260328122202_WH0LY US005Z 2026-03-29T12:03:38.956Z 2026-04-06T12:38:46.470Z
9590998 9590998 20260328121804_7YsIC US005Z 2026-03-29T12:03:36.527Z 2026-04-06T12:38:45.789Z
9590947 9590947 20260328120357_zOeYt US005Z 2026-03-29T12:03:32.198Z 2026-04-06T12:38:41.786Z
9590089 9590089 20260328050447_3pocZ US005Z 2026-03-29T12:01:58.930Z 2026-04-06T12:37:50.082Z
9587153 9587153 20260327112758_127mn US005Z 2026-03-28T12:04:54.592Z 2026-04-05T12:34:04.504Z
9587028 9587028 20260327105249_l8lix US005Z 2026-03-28T12:04:36.319Z 2026-04-05T12:33:59.010Z
9586955 9586955 20260327102702_GBNnV US005Z 2026-03-28T12:04:26.199Z 2026-04-05T12:33:55.801Z
9586743 9586743 20260327092313_D3qxJ US005Z 2026-03-28T12:03:54.257Z 2026-04-05T12:33:46.242Z
9586635 9586635 20260327084949_bMkGT US005Z 2026-03-28T12:03:36.483Z 2026-04-05T12:33:33.433Z
9586455 9586455 20260327074419_JAvwp US005Z 2026-03-28T12:03:09.607Z 2026-04-05T12:33:26.434Z
9586399 9586399 20260327071009_U9k7w US005Z 2026-03-28T12:02:59.587Z 2026-04-05T12:33:23.647Z
9586195 9586195 20260327044534_NfrFU US005Z 2026-03-28T12:02:29.718Z 2026-04-05T12:33:07.574Z
9583286 9583286 20260326120855_he4e1 US005Z 2026-03-27T12:08:17.327Z 2026-04-04T12:41:00.408Z
9583275 9583275 20260326120708_KQRy3 US005Z 2026-03-27T12:08:15.397Z 2026-04-04T12:40:59.442Z
9583250 9583250 20260326115652_jB2NN US005Z 2026-03-27T12:08:11.348Z 2026-04-04T12:40:58.249Z
9583248 9583248 20260326115500_F3U9s US005Z 2026-03-27T12:08:10.786Z 2026-04-04T12:40:58.175Z
9583245 9583245 20260326115102_mGki5 US005Z 2026-03-27T12:08:10.244Z 2026-04-04T12:40:58.052Z
9583225 9583225 20260326114418_3Skp2 US005Z 2026-03-27T12:08:07.578Z 2026-04-04T12:40:57.468Z
9583021 9583021 20260326103612_pudSQ US005Z 2026-03-27T12:07:26.612Z 2026-04-04T12:40:39.791Z
9583004 9583004 20260326103355_YCP5C US005Z 2026-03-27T12:07:25.363Z 2026-04-04T12:40:39.431Z
9582813 9582813 20260326093758_3wRLB US005Z 2026-03-27T12:06:53.135Z 2026-04-04T12:40:29.919Z
9582649 9582649 20260326085444_XlW1F US005Z 2026-03-27T12:06:26.254Z 2026-04-04T12:40:17.147Z
9582546 9582546 20260326082234_Ay7u0 US005Z 2026-03-27T12:06:07.171Z 2026-04-04T12:40:08.545Z
9582486 9582486 20260326075729_gNIF2 US005Z 2026-03-27T12:05:56.869Z 2026-04-04T12:40:03.963Z
9582399 9582399 20260326071744_IVCoM US005Z 2026-03-27T12:05:39.598Z 2026-04-04T12:39:59.425Z
9581857 9581857 20260326040304_kRJx1 US005Z 2026-03-27T12:03:58.384Z 2026-04-04T12:39:22.814Z
9578614 9578614 20260325123826_3mglf US005Z 2026-03-26T12:08:05.470Z 2026-04-03T12:38:11.115Z
9578523 9578523 20260325121035_LjiHH US005Z 2026-03-26T12:07:49.334Z 2026-04-03T12:38:06.996Z
9578517 9578517 20260325121015_aMZyA US005Z 2026-03-26T12:07:48.371Z 2026-04-03T12:38:06.768Z
9578492 9578492 20260325120118_vo3tA US005Z 2026-03-26T12:07:44.755Z 2026-04-03T12:38:05.532Z
9578422 9578422 20260325114832_UXjp9 US005Z 2026-03-26T12:07:35.287Z 2026-04-03T12:38:02.952Z
9578260 9578260 20260325110117_JYTKm US005Z 2026-03-26T12:07:09.534Z 2026-04-03T12:37:45.539Z
9578254 9578254 20260325110048_sw5Ws US005Z 2026-03-26T12:07:08.582Z 2026-04-03T12:37:45.266Z
9578237 9578237 20260325105331_7Z4jd US005Z 2026-03-26T12:07:05.711Z 2026-04-03T12:37:44.328Z
9578231 9578231 20260325105127_KTNF0 US005Z 2026-03-26T12:07:04.450Z 2026-04-03T12:37:43.939Z
9578225 9578225 20260325104845_O8KUe US005Z 2026-03-26T12:07:03.115Z 2026-04-03T12:37:43.772Z
9578222 9578222 20260325104806_LVUkn US005Z 2026-03-26T12:07:01.091Z 2026-04-03T12:37:43.645Z
9578203 9578203 20260325104427_PNZpW US005Z 2026-03-26T12:06:59.341Z 2026-04-03T12:37:43.245Z
9578166 9578166 20260325103702_9SQHd US005Z 2026-03-26T12:06:53.040Z 2026-04-03T12:37:41.766Z
9578156 9578156 20260325103200_rgUy6 US005Z 2026-03-26T12:06:51.683Z 2026-04-03T12:37:41.487Z
9578108 9578108 20260325100238_Ui2ZX US005Z 2026-03-26T12:06:45.277Z 2026-04-03T12:37:37.288Z
9578088 9578088 20260325095715_LzF2D US005Z 2026-03-26T12:06:43.446Z 2026-04-03T12:37:36.642Z
9578044 9578044 20260325093857_pd9UP US005Z 2026-03-26T12:06:37.715Z 2026-04-03T12:37:34.767Z
9577997 9577997 20260325092627_1td0D US005Z 2026-03-26T12:06:31.308Z 2026-04-03T12:37:33.483Z
9577979 9577979 20260325092540_lbKTz US005Z 2026-03-26T12:06:30.139Z 2026-04-03T12:37:33.103Z
9577936 9577936 20260325091750_XqWmI US005Z 2026-03-26T12:06:22.776Z 2026-04-03T12:37:31.566Z
9577758 9577758 20260325082711_u7T2M US005Z 2026-03-26T12:06:00.481Z 2026-04-03T12:37:25.855Z
9577665 9577665 20260325080254_4Dbv2 US005Z 2026-03-26T12:05:48.021Z 2026-04-03T12:37:12.771Z
9577635 9577635 20260325075408_G2JLW US005Z 2026-03-26T12:05:41.534Z 2026-04-03T12:37:11.454Z
9577605 9577605 20260325074243_1m2VZ US005Z 2026-03-26T12:05:37.064Z 2026-04-03T12:37:10.196Z
9577555 9577555 20260325072119_YVOJj US005Z 2026-03-26T12:05:30.290Z 2026-04-03T12:37:06.354Z
9577496 9577496 20260325064601_Q3FU2 US005Z 2026-03-26T12:05:17.309Z 2026-04-03T12:37:03.832Z
9577444 9577444 20260325061414_b6eJX US005Z 2026-03-26T12:05:09.938Z 2026-04-03T12:37:01.947Z
9577118 9577118 20260325035733_xgS6Z US005Z 2026-03-26T12:04:11.943Z 2026-04-03T12:36:35.213Z
9576884 9576884 20260325032249_fEZle US005Z 2026-03-26T12:03:34.814Z 2026-04-03T12:36:24.503Z
9576851 9576851 20260325031638_giFfK US005Z 2026-03-26T12:03:29.424Z 2026-04-03T12:36:23.550Z
9573511 9573511 20260324123340_jQbli US005Z 2026-03-25T12:08:11.441Z 2026-04-02T12:36:12.147Z
9573456 9573456 20260324121151_2K5q4 US005Z 2026-03-25T12:08:02.922Z 2026-04-02T12:36:09.863Z
9573451 9573451 20260324121132_7C5YZ US005Z 2026-03-25T12:08:02.501Z 2026-04-02T12:36:09.776Z
9573353 9573353 20260324115457_jJYft US005Z 2026-03-25T12:07:47.851Z 2026-04-02T12:36:05.833Z
9572935 9572935 20260324105748_tMlZO US005Z 2026-03-25T12:06:46.377Z 2026-04-02T12:35:44.201Z
9572925 9572925 20260324105131_awhNK US005Z 2026-03-25T12:06:43.746Z 2026-04-02T12:35:43.646Z
9572883 9572883 20260324104352_H2I6H US005Z 2026-03-25T12:06:36.115Z 2026-04-02T12:35:42.264Z
9572815 9572815 20260324102841_qFu86 US005Z 2026-03-25T12:06:22.706Z 2026-04-02T12:35:39.174Z
9572743 9572743 20260324100457_jkWfo US005Z 2026-03-25T12:06:10.942Z 2026-04-02T12:35:36.847Z
9572018 9572018 20260324070312_o48MU US005Z 2026-03-25T12:03:31.195Z 2026-04-02T12:34:59.559Z
9572002 9572002 20260324065541_1j15W US005Z 2026-03-25T12:03:28.217Z 2026-04-02T12:34:58.789Z
9571982 9571982 20260324064036_KKw7C US005Z 2026-03-25T12:03:24.979Z 2026-04-02T12:34:58.056Z
9565762 9565762 20260323123937_WCJhN US005Z 2026-03-24T12:10:48.588Z 2026-03-31T12:27:40.924Z

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