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

1,694 rows where station_code = "US006A" 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
9598942 9598942 20260331091933_2XIE5 US006A 2026-04-01T12:01:40.358Z 2026-04-06T12:27:10.403Z
9593122 9593122 20260329064213_tGGkh US006A 2026-03-30T12:03:01.304Z 2026-04-06T12:34:51.534Z
9593079 9593079 20260329051738_w33Oj US006A 2026-03-30T12:02:52.106Z 2026-04-06T12:34:49.097Z
9592752 9592752 20260329031423_INnvb US006A 2026-03-30T12:01:50.973Z 2026-04-06T12:34:26.608Z
9592531 9592531 20260329022331_Q2eFV US006A 2026-03-30T12:01:12.856Z 2026-04-06T12:34:14.168Z
9590487 9590487 20260328093156_4jut3 US006A 2026-03-29T12:02:45.002Z 2026-04-06T12:38:12.013Z
9590399 9590399 20260328085234_jNyaH US006A 2026-03-29T12:02:33.879Z 2026-04-06T12:38:05.642Z
9590318 9590318 20260328081313_VA3fg US006A 2026-03-29T12:02:24.742Z 2026-04-06T12:38:01.053Z
9590304 9590304 20260328080714_m1XU1 US006A 2026-03-29T12:02:23.825Z 2026-04-06T12:38:00.521Z
9590188 9590188 20260328072612_Tar3e US006A 2026-03-29T12:02:10.833Z 2026-04-06T12:37:55.434Z
9590091 9590091 20260328050844_2WaNJ US006A 2026-03-29T12:01:59.187Z 2026-04-06T12:37:50.208Z
9590080 9590080 20260328045308_jtZAQ US006A 2026-03-29T12:01:57.916Z 2026-04-06T12:37:49.760Z
9590076 9590076 20260328045054_lNoTc US006A 2026-03-29T12:01:57.632Z 2026-04-06T12:37:49.653Z
9590039 9590039 20260328043044_Rf85Y US006A 2026-03-29T12:01:54.102Z 2026-04-06T12:37:47.842Z
9589422 9589422 20260328032816_sBi28 US006A 2026-03-29T12:01:12.889Z 2026-04-06T12:37:22.805Z
9561489 9561489 20260320094429_cHrcg US006A 2026-03-23T12:13:55.997Z 2026-03-28T12:35:01.168Z
9561487 9561487 20260320092457_UMyA3 US006A 2026-03-23T12:13:53.787Z 2026-03-28T12:34:58.696Z
9561483 9561483 20260320084041_uYdaS US006A 2026-03-23T12:13:48.203Z 2026-03-28T12:34:52.989Z
9561481 9561481 20260320075418_uGFTE US006A 2026-03-23T12:13:43.699Z 2026-03-28T12:34:46.286Z
9513148 9513148 20260318083936_86tyl US006A 2026-03-19T12:14:31.527Z 2026-03-26T12:37:52.883Z
9512865 9512865 20260318075729_gyKFZ US006A 2026-03-19T12:13:44.522Z 2026-03-26T12:37:49.508Z
9512774 9512774 20260318074644_O5Kka US006A 2026-03-19T12:13:33.004Z 2026-03-26T12:37:48.847Z
9512563 9512563 20260318070451_Ke5o3 US006A 2026-03-19T12:12:56.390Z 2026-03-26T12:37:46.736Z
9512532 9512532 20260318065231_WhfvH US006A 2026-03-19T12:12:50.351Z 2026-03-26T12:37:46.392Z
9512485 9512485 20260318063310_32i1b US006A 2026-03-19T12:12:42.028Z 2026-03-26T12:37:45.910Z
9512477 9512477 20260318062857_TFDc5 US006A 2026-03-19T12:12:40.230Z 2026-03-26T12:37:45.890Z
9512407 9512407 20260318055033_42TTZ US006A 2026-03-19T12:12:25.732Z 2026-03-26T12:37:44.911Z
9512372 9512372 20260318054051_MlpEM US006A 2026-03-19T12:12:20.272Z 2026-03-26T12:37:44.464Z
9512352 9512352 20260318052631_h1HHX US006A 2026-03-19T12:12:16.202Z 2026-03-26T12:37:44.342Z
9512348 9512348 20260318052509_uO4ba US006A 2026-03-19T12:12:15.303Z 2026-03-26T12:37:44.328Z
9512339 9512339 20260318052112_UhLPo US006A 2026-03-19T12:12:14.108Z 2026-03-26T12:37:44.198Z
9512267 9512267 20260318050129_2v5r2 US006A 2026-03-19T12:12:03.122Z 2026-03-26T12:37:43.395Z
9512117 9512117 20260318044443_olsOL US006A 2026-03-19T12:11:44.814Z 2026-03-26T12:37:42.497Z
9511837 9511837 20260318042239_S8fYg US006A 2026-03-19T12:11:08.057Z 2026-03-26T12:37:40.080Z
9511358 9511358 20260318034736_o7w0K US006A 2026-03-19T12:10:00.905Z 2026-03-26T12:37:36.233Z
9510758 9510758 20260318031243_x022s US006A 2026-03-19T12:08:35.713Z 2026-03-26T12:37:16.478Z
9509992 9509992 20260318022627_z2NsR US006A 2026-03-19T12:06:39.341Z 2026-03-26T12:37:09.092Z
9508164 9508164 20260318002737_5aYit US006A 2026-03-19T12:02:28.083Z 2026-03-26T12:36:56.457Z
9484691 9484691 20260315012829_k0PE3 US006A 2026-03-16T12:03:47.185Z 2026-03-23T12:21:47.934Z
9478722 9478722 20260314095641_kru7Y US006A 2026-03-15T12:11:50.592Z 2026-03-22T12:42:11.428Z
9478266 9478266 20260314085628_mo37W US006A 2026-03-15T12:10:39.949Z 2026-03-22T12:42:09.340Z
9478238 9478238 20260314085220_l7BjH US006A 2026-03-15T12:10:35.900Z 2026-03-22T12:42:09.198Z
9478210 9478210 20260314084552_2RG0v US006A 2026-03-15T12:10:32.100Z 2026-03-22T12:42:09.093Z
9478158 9478158 20260314083720_PeJW0 US006A 2026-03-15T12:10:21.886Z 2026-03-22T12:42:08.758Z
9478087 9478087 20260314082110_qFQY3 US006A 2026-03-15T12:10:12.261Z 2026-03-22T12:42:08.456Z
9477894 9477894 20260314072330_EQ0dC US006A 2026-03-15T12:09:34.501Z 2026-03-22T12:42:06.284Z
9477848 9477848 20260314070230_qjdRV US006A 2026-03-15T12:09:23.558Z 2026-03-22T12:42:05.920Z
9477802 9477802 20260314064600_wGF64 US006A 2026-03-15T12:09:11.434Z 2026-03-22T12:42:05.408Z
9477771 9477771 20260314063224_1tyqG US006A 2026-03-15T12:09:05.000Z 2026-03-22T12:42:05.146Z
9477739 9477739 20260314061834_wcyb1 US006A 2026-03-15T12:08:57.959Z 2026-03-22T12:42:04.820Z
9477697 9477697 20260314060158_zHH33 US006A 2026-03-15T12:08:52.302Z 2026-03-22T12:42:04.631Z
9477679 9477679 20260314055152_1Kvtf US006A 2026-03-15T12:08:49.570Z 2026-03-22T12:42:04.514Z
9477662 9477662 20260314055024_z9rgy US006A 2026-03-15T12:08:45.200Z 2026-03-22T12:42:04.369Z
9477168 9477168 20260314042403_qNijl US006A 2026-03-15T12:07:44.910Z 2026-03-22T12:42:01.584Z
9477098 9477098 20260314041613_5gS1d US006A 2026-03-15T12:07:36.264Z 2026-03-22T12:42:01.220Z
9476704 9476704 20260314033310_cIFSi US006A 2026-03-15T12:06:40.215Z 2026-03-22T12:41:58.657Z
9476451 9476451 20260314030925_P2Fka US006A 2026-03-15T12:06:01.291Z 2026-03-22T12:41:56.733Z
9471468 9471468 20260313102430_3Ry6i US006A 2026-03-14T12:10:31.218Z 2026-03-21T12:49:24.346Z
9471370 9471370 20260313100305_oCtG0 US006A 2026-03-14T12:10:10.062Z 2026-03-21T12:49:20.779Z
9471091 9471091 20260313090052_2DA0i US006A 2026-03-14T12:09:25.153Z 2026-03-21T12:49:17.688Z
9470941 9470941 20260313082156_XSksB US006A 2026-03-14T12:08:57.413Z 2026-03-21T12:49:15.692Z
9470902 9470902 20260313081534_2Uk1r US006A 2026-03-14T12:08:48.042Z 2026-03-21T12:49:15.256Z
9470784 9470784 20260313074058_YOxjQ US006A 2026-03-14T12:08:24.895Z 2026-03-21T12:49:13.620Z
9470774 9470774 20260313073823_efqTS US006A 2026-03-14T12:08:21.032Z 2026-03-21T12:49:13.419Z
9470699 9470699 20260313072354_Jm92F US006A 2026-03-14T12:08:08.581Z 2026-03-21T12:49:12.078Z
9470658 9470658 20260313070920_pRnFj US006A 2026-03-14T12:08:02.477Z 2026-03-21T12:49:11.610Z
9470595 9470595 20260313064243_eIXyw US006A 2026-03-14T12:07:51.189Z 2026-03-21T12:49:11.112Z
9470528 9470528 20260313061359_d9YEi US006A 2026-03-14T12:07:38.748Z 2026-03-21T12:49:10.650Z
9470469 9470469 20260313060153_ZN7K7 US006A 2026-03-14T12:07:30.741Z 2026-03-21T12:49:10.076Z
9470465 9470465 20260313055902_d0bvj US006A 2026-03-14T12:07:29.701Z 2026-03-21T12:49:09.976Z
9470088 9470088 20260313043010_k2xbz US006A 2026-03-14T12:06:25.090Z 2026-03-21T12:49:05.741Z
9469972 9469972 20260313041244_JMstI US006A 2026-03-14T12:06:08.134Z 2026-03-21T12:49:04.679Z
9469679 9469679 20260313032641_QfAJv US006A 2026-03-14T12:05:11.824Z 2026-03-21T12:48:59.204Z
9469545 9469545 20260313030654_cyCO9 US006A 2026-03-14T12:04:40.152Z 2026-03-21T12:48:41.484Z
9469532 9469532 20260313030216_HWbxq US006A 2026-03-14T12:04:37.130Z 2026-03-21T12:48:41.171Z
9458202 9458202 20260311085849_rljag US006A 2026-03-12T12:05:36.605Z 2026-03-19T12:44:56.472Z
9458150 9458150 20260311084550_OAKTR US006A 2026-03-12T12:05:29.729Z 2026-03-19T12:44:56.128Z
9452562 9452562 20260310103010_wjtwZ US006A 2026-03-11T12:05:40.528Z 2026-03-18T12:39:13.909Z
9452408 9452408 20260310095527_0yPMm US006A 2026-03-11T12:05:23.654Z 2026-03-18T12:39:12.719Z
9452394 9452394 20260310095234_bP8PD US006A 2026-03-11T12:05:21.330Z 2026-03-18T12:39:12.508Z
9452209 9452209 20260310084805_0D6EX US006A 2026-03-11T12:04:59.037Z 2026-03-18T12:39:10.774Z
9452122 9452122 20260310080249_YCjQ3 US006A 2026-03-11T12:04:45.118Z 2026-03-18T12:39:09.702Z
9452086 9452086 20260310074437_ajWJT US006A 2026-03-11T12:04:41.127Z 2026-03-18T12:39:09.408Z
9452058 9452058 20260310065531_colHV US006A 2026-03-11T12:04:36.489Z 2026-03-18T12:39:09.046Z
9452024 9452024 20260310061722_piCbT US006A 2026-03-11T12:04:30.026Z 2026-03-18T12:39:08.457Z
9452008 9452008 20260310054612_fl07x US006A 2026-03-11T12:04:25.371Z 2026-03-18T12:39:08.280Z
9451956 9451956 20260310050804_LmtP1 US006A 2026-03-11T12:04:17.225Z 2026-03-18T12:39:07.524Z
9451826 9451826 20260310041349_aYYQD US006A 2026-03-11T12:03:56.503Z 2026-03-18T12:39:05.209Z
9451802 9451802 20260310035538_Vk4Ub US006A 2026-03-11T12:03:52.200Z 2026-03-18T12:39:04.773Z
9451627 9451627 20260310030902_LdZRQ US006A 2026-03-11T12:03:22.420Z 2026-03-18T12:39:01.699Z
9451330 9451330 20260310014802_jNLXL US006A 2026-03-11T12:02:28.127Z 2026-03-18T12:38:44.902Z
9451316 9451316 20260310014313_PJObj US006A 2026-03-11T12:02:25.660Z 2026-03-18T12:38:44.740Z
9448325 9448325 20260309102646_Kh2i1 US006A 2026-03-10T12:09:32.156Z 2026-03-17T12:42:13.569Z
9447997 9447997 20260309093341_KEyPE US006A 2026-03-10T12:08:34.374Z 2026-03-17T12:41:59.025Z
9447824 9447824 20260309090137_XGw20 US006A 2026-03-10T12:07:57.214Z 2026-03-17T12:41:57.093Z
9447556 9447556 20260309075837_Alzuk US006A 2026-03-10T12:06:59.367Z 2026-03-17T12:41:53.087Z
9447516 9447516 20260309075055_GRKyu US006A 2026-03-10T12:06:49.417Z 2026-03-17T12:41:52.619Z
9447514 9447514 20260309075033_iEv2v US006A 2026-03-10T12:06:47.885Z 2026-03-17T12:41:52.592Z
9447448 9447448 20260309073018_NO9E3 US006A 2026-03-10T12:06:32.506Z 2026-03-17T12:41:51.858Z
9447350 9447350 20260309064926_wDqPv US006A 2026-03-10T12:06:10.509Z 2026-03-17T12:41:50.506Z

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