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 = "US000G" 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
9609813 9609813 20260405101624_gYhvK US000G 2026-04-06T12:04:00.814Z 2026-04-06T12:04:00.814Z
9609798 9609798 20260405100922_tcBt3 US000G 2026-04-06T12:03:55.405Z 2026-04-06T12:03:55.405Z
9609627 9609627 20260405084202_9PDae US000G 2026-04-06T12:02:58.049Z 2026-04-06T12:02:58.049Z
9609579 9609579 20260405082643_kEgWZ US000G 2026-04-06T12:02:42.037Z 2026-04-06T12:02:42.037Z
9609557 9609557 20260405081047_e2u0T US000G 2026-04-06T12:02:33.070Z 2026-04-06T12:02:33.070Z
9609553 9609553 20260405080916_MxRJu US000G 2026-04-06T12:02:31.624Z 2026-04-06T12:02:31.624Z
9609406 9609406 20260405060428_YfNCz US000G 2026-04-06T12:01:39.980Z 2026-04-06T12:01:39.980Z
9607346 9607346 20260404075758_3jtGN US000G 2026-04-05T12:01:45.108Z 2026-04-06T12:16:14.416Z
9607271 9607271 20260404065027_nkD2p US000G 2026-04-05T12:01:22.397Z 2026-04-06T12:16:14.399Z
9607252 9607252 20260404061817_P7m4a US000G 2026-04-05T12:01:13.381Z 2026-04-06T12:16:14.395Z
9607239 9607239 20260404060348_V0Q3i US000G 2026-04-05T12:01:08.551Z 2026-04-06T12:16:14.391Z
9607194 9607194 20260404043411_p35Go US000G 2026-04-05T12:00:50.373Z 2026-04-06T12:16:14.381Z
9605725 9605725 20260403114122_78f7b US000G 2026-04-04T12:03:35.910Z 2026-04-06T12:18:15.078Z
9605569 9605569 20260403105004_2M4tk US000G 2026-04-04T12:02:56.088Z 2026-04-06T12:18:05.489Z
9605023 9605023 20260403034301_2kSba US000G 2026-04-04T12:00:20.925Z 2026-04-06T12:16:19.934Z
9603650 9603650 20260402113351_lgL24 US000G 2026-04-03T12:03:58.628Z 2026-04-06T12:22:19.482Z
9596222 9596222 20260330115032_Va93H US000G 2026-03-31T12:03:47.249Z 2026-04-06T12:31:04.376Z
9596155 9596155 20260330112947_D76c3 US000G 2026-03-31T12:03:37.163Z 2026-04-06T12:31:00.786Z
9596053 9596053 20260330105424_RWHrB US000G 2026-03-31T12:03:15.329Z 2026-04-06T12:30:49.369Z
9593606 9593606 20260329120756_WQVQb US000G 2026-03-30T12:04:31.275Z 2026-04-06T12:35:29.985Z
9593585 9593585 20260329120158_GpVpl US000G 2026-03-30T12:04:26.680Z 2026-04-06T12:35:27.156Z
9593516 9593516 20260329113608_P2dsT US000G 2026-03-30T12:04:14.212Z 2026-04-06T12:35:23.466Z
9593464 9593464 20260329110527_ted2Q US000G 2026-03-30T12:04:04.021Z 2026-04-06T12:35:20.348Z
9593416 9593416 20260329103517_ZWd7x US000G 2026-03-30T12:03:53.650Z 2026-04-06T12:35:17.523Z
9593338 9593338 20260329093346_yLl3W US000G 2026-03-30T12:03:40.246Z 2026-04-06T12:35:13.280Z
9593333 9593333 20260329093158_xKFXp US000G 2026-03-30T12:03:39.670Z 2026-04-06T12:35:13.110Z
9593241 9593241 20260329082230_WD7RU US000G 2026-03-30T12:03:21.707Z 2026-04-06T12:34:59.306Z
9593192 9593192 20260329075206_JVI5Y US000G 2026-03-30T12:03:14.984Z 2026-04-06T12:34:55.701Z
9593179 9593179 20260329074035_YCEoz US000G 2026-03-30T12:03:13.010Z 2026-04-06T12:34:55.066Z
9590967 9590967 20260328120720_HVgHm US000G 2026-03-29T12:03:33.717Z 2026-04-06T12:38:42.600Z
9590693 9590693 20260328104418_Em5bT US000G 2026-03-29T12:03:07.465Z 2026-04-06T12:38:30.622Z
9590262 9590262 20260328075614_LVC2d US000G 2026-03-29T12:02:20.638Z 2026-04-06T12:37:58.956Z
9590190 9590190 20260328072639_m0Ot3 US000G 2026-03-29T12:02:11.089Z 2026-04-06T12:37:55.534Z
9589639 9589639 20260328035238_TegGo US000G 2026-03-29T12:01:30.982Z 2026-04-06T12:37:29.871Z
9589143 9589143 20260328023304_dd2tO US000G 2026-03-29T12:00:46.362Z 2026-04-06T12:37:03.183Z
9587177 9587177 20260327113719_xnd2U US000G 2026-03-28T12:04:57.061Z 2026-04-05T12:34:05.487Z
9587138 9587138 20260327112344_byWRd US000G 2026-03-28T12:04:52.231Z 2026-04-05T12:34:03.769Z
9587125 9587125 20260327111850_MYUYV US000G 2026-03-28T12:04:50.127Z 2026-04-05T12:34:02.997Z
9587100 9587100 20260327111208_LdroS US000G 2026-03-28T12:04:46.212Z 2026-04-05T12:34:01.692Z
9586960 9586960 20260327103043_kQwYV US000G 2026-03-28T12:04:27.422Z 2026-04-05T12:33:56.163Z
9586958 9586958 20260327102800_fumN4 US000G 2026-03-28T12:04:27.089Z 2026-04-05T12:33:56.061Z
9586872 9586872 20260327100249_Df3rK US000G 2026-03-28T12:04:16.119Z 2026-04-05T12:33:52.691Z
9586831 9586831 20260327095124_NSS3G US000G 2026-03-28T12:04:10.563Z 2026-04-05T12:33:50.889Z
9586811 9586811 20260327094418_pWKtR US000G 2026-03-28T12:04:06.057Z 2026-04-05T12:33:49.988Z
9586801 9586801 20260327093943_MrMqK US000G 2026-03-28T12:04:03.685Z 2026-04-05T12:33:49.228Z
9586772 9586772 20260327093224_KnCWJ US000G 2026-03-28T12:03:58.919Z 2026-04-05T12:33:47.882Z
9586760 9586760 20260327092807_YEbra US000G 2026-03-28T12:03:56.617Z 2026-04-05T12:33:47.117Z
9586754 9586754 20260327092717_r2g3z US000G 2026-03-28T12:03:56.230Z 2026-04-05T12:33:46.917Z
9586619 9586619 20260327084316_Q4jt2 US000G 2026-03-28T12:03:33.872Z 2026-04-05T12:33:32.928Z
9586553 9586553 20260327081725_wRFi5 US000G 2026-03-28T12:03:24.141Z 2026-04-05T12:33:30.251Z
9586512 9586512 20260327080731_422b6 US000G 2026-03-28T12:03:18.563Z 2026-04-05T12:33:28.645Z
9586500 9586500 20260327080318_hSa39 US000G 2026-03-28T12:03:17.701Z 2026-04-05T12:33:28.382Z
9586494 9586494 20260327080149_kWCaA US000G 2026-03-28T12:03:16.405Z 2026-04-05T12:33:27.980Z
9586427 9586427 20260327072702_3noKo US000G 2026-03-28T12:03:03.238Z 2026-04-05T12:33:24.854Z
9586270 9586270 20260327053439_KGYQ4 US000G 2026-03-28T12:02:41.350Z 2026-04-05T12:33:18.414Z
9586225 9586225 20260327050122_kEm6R US000G 2026-03-28T12:02:33.667Z 2026-04-05T12:33:08.944Z
9583183 9583183 20260326113243_32qaT US000G 2026-03-27T12:07:58.139Z 2026-04-04T12:40:55.495Z
9583113 9583113 20260326110439_RzIhF US000G 2026-03-27T12:07:46.307Z 2026-04-04T12:40:52.581Z
9583067 9583067 20260326104909_PW5Z6 US000G 2026-03-27T12:07:35.299Z 2026-04-04T12:40:44.179Z
9583046 9583046 20260326104135_FS08T US000G 2026-03-27T12:07:30.510Z 2026-04-04T12:40:43.139Z
9582980 9582980 20260326103213_J5EUc US000G 2026-03-27T12:07:23.189Z 2026-04-04T12:40:38.894Z
9582949 9582949 20260326100746_szLZL US000G 2026-03-27T12:07:18.711Z 2026-04-04T12:40:37.552Z
9582925 9582925 20260326100158_TSEg7 US000G 2026-03-27T12:07:15.201Z 2026-04-04T12:40:36.693Z
9582915 9582915 20260326095957_lK9it US000G 2026-03-27T12:07:12.947Z 2026-04-04T12:40:36.599Z
9582887 9582887 20260326095616_iD8ur US000G 2026-03-27T12:07:06.621Z 2026-04-04T12:40:34.642Z
9582759 9582759 20260326092007_k7yl6 US000G 2026-03-27T12:06:43.117Z 2026-04-04T12:40:27.389Z
9582727 9582727 20260326091458_okqYB US000G 2026-03-27T12:06:37.031Z 2026-04-04T12:40:25.833Z
9582718 9582718 20260326091207_1IXD7 US000G 2026-03-27T12:06:35.817Z 2026-04-04T12:40:25.291Z
9582693 9582693 20260326090806_CQf79 US000G 2026-03-27T12:06:33.735Z 2026-04-04T12:40:20.523Z
9582652 9582652 20260326085602_puGdQ US000G 2026-03-27T12:06:27.099Z 2026-04-04T12:40:17.426Z
9582526 9582526 20260326081632_jkbVa US000G 2026-03-27T12:06:03.754Z 2026-04-04T12:40:07.037Z
9582479 9582479 20260326075608_DoPiK US000G 2026-03-27T12:05:55.345Z 2026-04-04T12:40:03.753Z
9582362 9582362 20260326070533_B8wYF US000G 2026-03-27T12:05:33.385Z 2026-04-04T12:39:58.050Z
9582290 9582290 20260326062151_4UKVQ US000G 2026-03-27T12:05:16.391Z 2026-04-04T12:39:48.718Z
9582260 9582260 20260326055334_3IWpH US000G 2026-03-27T12:05:09.098Z 2026-04-04T12:39:47.231Z
9582222 9582222 20260326052807_FmZ1A US000G 2026-03-27T12:05:00.857Z 2026-04-04T12:39:43.090Z
9581925 9581925 20260326041211_lpPbj US000G 2026-03-27T12:04:11.506Z 2026-04-04T12:39:31.513Z
9581204 9581204 20260326023626_itetl US000G 2026-03-27T12:02:22.590Z 2026-04-04T12:38:45.791Z
9578534 9578534 20260325121205_QFBxT US000G 2026-03-26T12:07:50.675Z 2026-04-03T12:38:07.321Z
9578509 9578509 20260325120929_0LTKO US000G 2026-03-26T12:07:47.554Z 2026-04-03T12:38:06.358Z
9578345 9578345 20260325112424_XU4sq US000G 2026-03-26T12:07:22.484Z 2026-04-03T12:37:59.466Z
9578334 9578334 20260325112414_dGS6C US000G 2026-03-26T12:07:21.478Z 2026-04-03T12:37:59.235Z
9578318 9578318 20260325111839_hgrbm US000G 2026-03-26T12:07:18.181Z 2026-04-03T12:37:58.202Z
9578306 9578306 20260325111717_CmLNk US000G 2026-03-26T12:07:17.024Z 2026-04-03T12:37:57.899Z
9578180 9578180 20260325104050_W0LtD US000G 2026-03-26T12:06:56.604Z 2026-04-03T12:37:42.525Z
9578083 9578083 20260325095428_3Gpos US000G 2026-03-26T12:06:42.486Z 2026-04-03T12:37:36.349Z
9578049 9578049 20260325094402_gaFag US000G 2026-03-26T12:06:38.897Z 2026-04-03T12:37:35.143Z
9577877 9577877 20260325090846_JeCp6 US000G 2026-03-26T12:06:16.929Z 2026-04-03T12:37:29.913Z
9577842 9577842 20260325085628_QMvQW US000G 2026-03-26T12:06:12.835Z 2026-04-03T12:37:28.942Z
9577717 9577717 20260325081314_BQgBq US000G 2026-03-26T12:05:55.606Z 2026-04-03T12:37:24.552Z
9577556 9577556 20260325072345_TkW3r US000G 2026-03-26T12:05:30.700Z 2026-04-03T12:37:06.507Z
9577385 9577385 20260325053810_jOWZi US000G 2026-03-26T12:04:59.504Z 2026-04-03T12:36:59.759Z
9577248 9577248 20260325042729_UiU5P US000G 2026-03-26T12:04:32.314Z 2026-04-03T12:36:53.212Z
9577129 9577129 20260325040042_gHP7J US000G 2026-03-26T12:04:13.699Z 2026-04-03T12:36:35.899Z
9577086 9577086 20260325035405_CtqB3 US000G 2026-03-26T12:04:06.237Z 2026-04-03T12:36:34.106Z
9576813 9576813 20260325031324_ETsye US000G 2026-03-26T12:03:22.901Z 2026-04-03T12:36:22.085Z
9576616 9576616 20260325024255_Ye8rn US000G 2026-03-26T12:02:48.607Z 2026-04-03T12:36:14.804Z
9573386 9573386 20260324120041_u1bad US000G 2026-03-25T12:07:51.877Z 2026-04-02T12:36:06.918Z
9573302 9573302 20260324114727_bVeBQ US000G 2026-03-25T12:07:40.699Z 2026-04-02T12:36:03.604Z
9573276 9573276 20260324114403_dSwoF US000G 2026-03-25T12:07:37.489Z 2026-04-02T12:36:02.390Z

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