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 = "US000C" 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
9609619 9609619 20260405084100_lXHwI US000C 2026-04-06T12:02:56.443Z 2026-04-06T12:02:56.443Z
9609527 9609527 20260405075116_HmBEW US000C 2026-04-06T12:02:21.585Z 2026-04-06T12:02:21.585Z
9609482 9609482 20260405072708_QS8Eu US000C 2026-04-06T12:01:57.779Z 2026-04-06T12:01:57.779Z
9609359 9609359 20260405050709_dlNGh US000C 2026-04-06T12:01:23.615Z 2026-04-06T12:01:23.615Z
9607676 9607676 20260404114318_FUsW2 US000C 2026-04-05T12:03:25.370Z 2026-04-06T12:16:14.487Z
9607652 9607652 20260404113219_nhxhA US000C 2026-04-05T12:03:21.127Z 2026-04-06T12:16:14.484Z
9607628 9607628 20260404112425_pkJ32 US000C 2026-04-05T12:03:15.841Z 2026-04-06T12:16:14.478Z
9607615 9607615 20260404111551_DNUMy US000C 2026-04-05T12:03:13.069Z 2026-04-06T12:16:14.475Z
9607573 9607573 20260404110003_NBeHS US000C 2026-04-05T12:02:58.292Z 2026-04-06T12:16:14.466Z
9607556 9607556 20260404105734_F61Jl US000C 2026-04-05T12:02:55.617Z 2026-04-06T12:16:14.463Z
9607530 9607530 20260404102840_F64KQ US000C 2026-04-05T12:02:47.380Z 2026-04-06T12:16:14.457Z
9607510 9607510 20260404101128_tPEuK US000C 2026-04-05T12:02:43.012Z 2026-04-06T12:16:14.453Z
9607495 9607495 20260404095538_3IM1r US000C 2026-04-05T12:02:35.959Z 2026-04-06T12:16:14.450Z
9607477 9607477 20260404094540_VKvs0 US000C 2026-04-05T12:02:28.099Z 2026-04-06T12:16:14.446Z
9607410 9607410 20260404085543_TmV1k US000C 2026-04-05T12:02:03.662Z 2026-04-06T12:16:14.430Z
9607285 9607285 20260404070611_j4iFs US000C 2026-04-05T12:01:25.812Z 2026-04-06T12:16:14.402Z
9607276 9607276 20260404065513_hNIDW US000C 2026-04-05T12:01:23.872Z 2026-04-06T12:16:14.400Z
9605655 9605655 20260403111845_dKjax US000C 2026-04-04T12:03:19.876Z 2026-04-06T12:18:10.430Z
9605597 9605597 20260403105428_As1pM US000C 2026-04-04T12:02:59.946Z 2026-04-06T12:18:06.974Z
9605508 9605508 20260403102847_NMZ4z US000C 2026-04-04T12:02:39.469Z 2026-04-06T12:18:00.160Z
9605495 9605495 20260403102308_XuS4J US000C 2026-04-04T12:02:36.069Z 2026-04-06T12:17:56.189Z
9605475 9605475 20260403101133_dFzaU US000C 2026-04-04T12:02:29.882Z 2026-04-06T12:17:54.956Z
9605426 9605426 20260403095629_6fFEF US000C 2026-04-04T12:02:17.706Z 2026-04-06T12:17:49.576Z
9605419 9605419 20260403095554_DPXMI US000C 2026-04-04T12:02:12.292Z 2026-04-06T12:17:49.078Z
9605309 9605309 20260403083506_UFtic US000C 2026-04-04T12:01:44.983Z 2026-04-06T12:17:41.383Z
9605273 9605273 20260403081831_B6lgc US000C 2026-04-04T12:01:30.433Z 2026-04-06T12:17:38.674Z
9605254 9605254 20260403081526_QZhJJ US000C 2026-04-04T12:01:27.043Z 2026-04-06T12:17:37.613Z
9605251 9605251 20260403081453_tjYt5 US000C 2026-04-04T12:01:26.271Z 2026-04-06T12:17:37.435Z
9605237 9605237 20260403080927_Q6Aua US000C 2026-04-04T12:01:22.173Z 2026-04-06T12:17:35.957Z
9605108 9605108 20260403064543_KK3k5 US000C 2026-04-04T12:00:46.310Z 2026-04-06T12:16:39.804Z
9605103 9605103 20260403064348_z42ZZ US000C 2026-04-04T12:00:45.762Z 2026-04-06T12:16:38.708Z
9605015 9605015 20260403033524_jq52u US000C 2026-04-04T12:00:18.825Z 2026-04-06T12:16:18.469Z
9603648 9603648 20260402113351_lgL24 US000C 2026-04-03T12:03:58.628Z 2026-04-06T12:22:19.482Z
9603581 9603581 20260402110912_zDc3B US000C 2026-04-03T12:03:42.848Z 2026-04-06T12:22:14.646Z
9603458 9603458 20260402102824_cWd5a US000C 2026-04-03T12:03:08.817Z 2026-04-06T12:22:03.793Z
9603392 9603392 20260402095447_Ow2VC US000C 2026-04-03T12:02:48.444Z 2026-04-06T12:21:57.685Z
9603342 9603342 20260402093714_e7o7v US000C 2026-04-03T12:02:40.010Z 2026-04-06T12:21:54.925Z
9603304 9603304 20260402092642_SEbph US000C 2026-04-03T12:02:33.452Z 2026-04-06T12:21:52.118Z
9603250 9603250 20260402090427_2sc2v US000C 2026-04-03T12:02:18.972Z 2026-04-06T12:21:49.300Z
9603232 9603232 20260402085829_Xe3Om US000C 2026-04-03T12:02:14.894Z 2026-04-06T12:21:48.418Z
9603220 9603220 20260402085051_9yg0C US000C 2026-04-03T12:02:11.150Z 2026-04-06T12:21:47.717Z
9603166 9603166 20260402082030_at2qA US000C 2026-04-03T12:02:01.808Z 2026-04-06T12:21:40.863Z
9603159 9603159 20260402081852_MqZgg US000C 2026-04-03T12:02:00.371Z 2026-04-06T12:21:40.549Z
9603152 9603152 20260402081433_J2W1N US000C 2026-04-03T12:01:59.626Z 2026-04-06T12:21:40.368Z
9603112 9603112 20260402075726_EsVMf US000C 2026-04-03T12:01:52.430Z 2026-04-06T12:21:37.879Z
9603022 9603022 20260402062721_sU033 US000C 2026-04-03T12:01:31.013Z 2026-04-06T12:21:28.652Z
9603018 9603018 20260402062721_YSTlq US000C 2026-04-03T12:01:30.669Z 2026-04-06T12:21:28.368Z
9603013 9603013 20260402061718_3WbYn US000C 2026-04-03T12:01:30.136Z 2026-04-06T12:21:26.731Z
9599022 9599022 20260331104716_apMx4 US000C 2026-04-01T12:02:04.743Z 2026-04-06T12:27:20.653Z
9598916 9598916 20260331090019_8LIHn US000C 2026-04-01T12:01:34.107Z 2026-04-06T12:27:06.557Z
9598862 9598862 20260331080756_XpVvn US000C 2026-04-01T12:01:20.767Z 2026-04-06T12:27:02.998Z
9598843 9598843 20260331074816_TwpIm US000C 2026-04-01T12:01:17.053Z 2026-04-06T12:27:02.007Z
9596236 9596236 20260330115313_Ssnzf US000C 2026-03-31T12:03:48.916Z 2026-04-06T12:31:05.008Z
9593602 9593602 20260329120746_SmbZD US000C 2026-03-30T12:04:29.245Z 2026-04-06T12:35:29.720Z
9593545 9593545 20260329114741_wdnYK US000C 2026-03-30T12:04:20.738Z 2026-04-06T12:35:25.451Z
9593526 9593526 20260329114355_WQbwX US000C 2026-03-30T12:04:16.790Z 2026-04-06T12:35:24.177Z
9593522 9593522 20260329114236_rz7zJ US000C 2026-03-30T12:04:15.617Z 2026-04-06T12:35:23.895Z
9593509 9593509 20260329113449_7X2OF US000C 2026-03-30T12:04:13.386Z 2026-04-06T12:35:23.169Z
9593474 9593474 20260329111108_WDOYj US000C 2026-03-30T12:04:06.058Z 2026-04-06T12:35:20.913Z
9593455 9593455 20260329105541_cCKr0 US000C 2026-03-30T12:04:00.572Z 2026-04-06T12:35:19.795Z
9593409 9593409 20260329102313_2YNTW US000C 2026-03-30T12:03:52.686Z 2026-04-06T12:35:17.092Z
9593371 9593371 20260329095319_kHjcx US000C 2026-03-30T12:03:46.007Z 2026-04-06T12:35:15.088Z
9593363 9593363 20260329095128_vmAu3 US000C 2026-03-30T12:03:44.447Z 2026-04-06T12:35:14.600Z
9593342 9593342 20260329093725_MbE1l US000C 2026-03-30T12:03:41.349Z 2026-04-06T12:35:13.595Z
9593310 9593310 20260329090806_jvyfg US000C 2026-03-30T12:03:33.044Z 2026-04-06T12:35:02.780Z
9593300 9593300 20260329085609_fCJM4 US000C 2026-03-30T12:03:31.523Z 2026-04-06T12:35:02.382Z
9593256 9593256 20260329083551_GNMgM US000C 2026-03-30T12:03:24.561Z 2026-04-06T12:35:00.427Z
9593232 9593232 20260329081846_KdqrL US000C 2026-03-30T12:03:20.248Z 2026-04-06T12:34:58.711Z
9593000 9593000 20260329041454_LzhPp US000C 2026-03-30T12:02:34.291Z 2026-04-06T12:34:44.592Z
9590961 9590961 20260328120614_CLMvL US000C 2026-03-29T12:03:33.156Z 2026-04-06T12:38:42.298Z
9590950 9590950 20260328120529_SyiGV US000C 2026-03-29T12:03:32.619Z 2026-04-06T12:38:42.074Z
9590904 9590904 20260328115108_ToSip US000C 2026-03-29T12:03:28.755Z 2026-04-06T12:38:40.035Z
9590863 9590863 20260328113516_jnEbT US000C 2026-03-29T12:03:24.339Z 2026-04-06T12:38:37.717Z
9590840 9590840 20260328113134_wYKmt US000C 2026-03-29T12:03:22.426Z 2026-04-06T12:38:36.789Z
9590807 9590807 20260328112240_bloO3 US000C 2026-03-29T12:03:19.060Z 2026-04-06T12:38:35.352Z
9590790 9590790 20260328111612_Dqj2N US000C 2026-03-29T12:03:17.981Z 2026-04-06T12:38:34.851Z
9590780 9590780 20260328111442_JcQsD US000C 2026-03-29T12:03:17.258Z 2026-04-06T12:38:34.362Z
9590733 9590733 20260328105858_MfBpc US000C 2026-03-29T12:03:11.534Z 2026-04-06T12:38:32.104Z
9590690 9590690 20260328104326_0EJIO US000C 2026-03-29T12:03:07.166Z 2026-04-06T12:38:30.492Z
9590662 9590662 20260328103632_9dd8e US000C 2026-03-29T12:03:05.481Z 2026-04-06T12:38:29.617Z
9590598 9590598 20260328102052_XME82 US000C 2026-03-29T12:02:58.894Z 2026-04-06T12:38:26.386Z
9590593 9590593 20260328101800_E45oj US000C 2026-03-29T12:02:58.682Z 2026-04-06T12:38:26.234Z
9590517 9590517 20260328094831_Qtx04 US000C 2026-03-29T12:02:50.538Z 2026-04-06T12:38:13.867Z
9590360 9590360 20260328083117_JnGab US000C 2026-03-29T12:02:28.982Z 2026-04-06T12:38:03.063Z
9590337 9590337 20260328081957_BYZc4 US000C 2026-03-29T12:02:26.586Z 2026-04-06T12:38:01.991Z
9590293 9590293 20260328080654_GzQV3 US000C 2026-03-29T12:02:22.997Z 2026-04-06T12:38:00.144Z
9590288 9590288 20260328080619_hZVFw US000C 2026-03-29T12:02:22.466Z 2026-04-06T12:37:59.917Z
9590272 9590272 20260328080005_Bx2Ue US000C 2026-03-29T12:02:21.258Z 2026-04-06T12:37:59.213Z
9590181 9590181 20260328072109_vYYXj US000C 2026-03-29T12:02:09.843Z 2026-04-06T12:37:54.926Z
9590111 9590111 20260328062052_lPvBW US000C 2026-03-29T12:02:01.396Z 2026-04-06T12:37:51.145Z
9589587 9589587 20260328034751_2q2hy US000C 2026-03-29T12:01:26.651Z 2026-04-06T12:37:28.000Z
9589200 9589200 20260328024713_11yu3 US000C 2026-03-29T12:00:51.228Z 2026-04-06T12:37:06.952Z
9587278 9587278 20260327115856_1yNoQ US000C 2026-03-28T12:05:10.940Z 2026-04-05T12:34:11.148Z
9587204 9587204 20260327114034_sbh6R US000C 2026-03-28T12:04:59.520Z 2026-04-05T12:34:06.604Z
9587183 9587183 20260327113801_wIALI US000C 2026-03-28T12:04:57.367Z 2026-04-05T12:34:05.568Z
9586891 9586891 20260327100549_G8TP6 US000C 2026-03-28T12:04:18.000Z 2026-04-05T12:33:53.136Z
9586817 9586817 20260327094522_O6N6V US000C 2026-03-28T12:04:06.934Z 2026-04-05T12:33:50.269Z
9586787 9586787 20260327093606_B2IL8 US000C 2026-03-28T12:04:00.743Z 2026-04-05T12:33:48.543Z
9586723 9586723 20260327091954_yVnNk US000C 2026-03-28T12:03:50.866Z 2026-04-05T12:33:39.200Z
9586541 9586541 20260327081337_Afc1G US000C 2026-03-28T12:03:22.401Z 2026-04-05T12:33:29.836Z

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