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

892 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
8687243 8687243 20251204060617_hA6OS US006A 2025-12-05T14:14:29.140Z 2025-12-05T14:14:35.663Z
8683937 8683937 20251204093510_GOD4d US006A 2025-12-05T14:01:10.010Z 2025-12-05T14:01:10.010Z
8683823 8683823 20251204084554_cEzgt US006A 2025-12-05T14:00:47.940Z 2025-12-05T14:00:47.940Z
8683780 8683780 20251204080403_OGjp3 US006A 2025-12-05T14:00:33.214Z 2025-12-05T14:00:33.214Z
8683757 8683757 20251204074155_SOXgx US006A 2025-12-05T14:00:28.029Z 2025-12-05T14:00:28.029Z
8683722 8683722 20251204072008_WOQpz US006A 2025-12-05T14:00:21.258Z 2025-12-05T14:00:21.258Z
8677606 8677606 20251203110028_jXqEd US006A 2025-12-04T14:01:56.801Z 2025-12-05T14:14:34.895Z
8677580 8677580 20251203105320_CY8LV US006A 2025-12-04T14:01:50.130Z 2025-12-05T14:14:34.886Z
8677576 8677576 20251203105106_4bruG US006A 2025-12-04T14:01:49.003Z 2025-12-05T14:14:34.885Z
8677519 8677519 20251203103304_3Ph14 US006A 2025-12-04T14:01:31.714Z 2025-12-05T14:14:34.866Z
8677515 8677515 20251203103015_nor0e US006A 2025-12-04T14:01:30.394Z 2025-12-05T14:14:34.865Z
8677510 8677510 20251203102837_huf0D US006A 2025-12-04T14:01:28.715Z 2025-12-05T14:14:34.863Z
8677491 8677491 20251203102118_2XYiI US006A 2025-12-04T14:01:24.703Z 2025-12-05T14:14:34.858Z
8677476 8677476 20251203101630_B1MK4 US006A 2025-12-04T14:01:21.619Z 2025-12-05T14:14:34.853Z
8677421 8677421 20251203094826_lO0Jl US006A 2025-12-04T14:01:09.191Z 2025-12-05T14:14:34.835Z
8677401 8677401 20251203093736_QoYqY US006A 2025-12-04T14:01:02.955Z 2025-12-05T14:14:34.828Z
8677392 8677392 20251203093344_cdnOP US006A 2025-12-04T14:01:01.189Z 2025-12-05T14:14:34.825Z
8677378 8677378 20251203092710_rMDaM US006A 2025-12-04T14:00:58.296Z 2025-12-05T14:14:34.819Z
8677376 8677376 20251203092624_2aCRU US006A 2025-12-04T14:00:57.881Z 2025-12-05T14:14:34.819Z
8677346 8677346 20251203090255_COpPM US006A 2025-12-04T14:00:51.459Z 2025-12-05T14:14:34.808Z
8674410 8674410 20251202021954_pvQIN US006A 2025-12-03T14:21:36.536Z 2025-12-05T14:27:40.768Z
8674396 8674396 20251202021620_66blT US006A 2025-12-03T14:21:35.060Z 2025-12-05T14:27:40.296Z
8674336 8674336 20251202020355_y4WB6 US006A 2025-12-03T14:21:25.747Z 2025-12-05T14:27:37.782Z
8674224 8674224 20251202014815_uZV7g US006A 2025-12-03T14:21:11.258Z 2025-12-05T14:27:33.039Z
8670916 8670916 20251201104604_WUX18 US006A 2025-12-03T14:10:42.914Z 2025-12-05T14:23:55.637Z
8670821 8670821 20251201102046_zM5JX US006A 2025-12-03T14:10:16.901Z 2025-12-05T14:23:51.285Z
8670773 8670773 20251201101024_3NSlg US006A 2025-12-03T14:10:03.632Z 2025-12-05T14:23:48.870Z
8670681 8670681 20251201095644_Ie7pu US006A 2025-12-03T14:09:48.747Z 2025-12-05T14:23:44.861Z
8670625 8670625 20251201094841_H2Gt5 US006A 2025-12-03T14:09:35.459Z 2025-12-05T14:23:42.453Z
8670576 8670576 20251201093038_Bu5Eg US006A 2025-12-03T14:09:18.174Z 2025-12-05T14:23:38.302Z
8670516 8670516 20251201091324_l0a3H US006A 2025-12-03T14:09:04.496Z 2025-12-05T14:23:27.674Z
8670500 8670500 20251201091128_R3R4l US006A 2025-12-03T14:09:02.318Z 2025-12-05T14:23:27.122Z
8670482 8670482 20251201090440_6dpoa US006A 2025-12-03T14:08:58.411Z 2025-12-05T14:23:26.073Z
8670477 8670477 20251201090358_WSrRA US006A 2025-12-03T14:08:57.409Z 2025-12-05T14:23:25.808Z
8670468 8670468 20251201090057_MHSMP US006A 2025-12-03T14:08:54.986Z 2025-12-05T14:23:25.120Z
8670430 8670430 20251201085131_wF2fn US006A 2025-12-03T14:08:41.591Z 2025-12-05T14:23:21.518Z
8670414 8670414 20251201084740_mC0R6 US006A 2025-12-03T14:08:39.188Z 2025-12-05T14:23:20.904Z
8666926 8666926 20251201072734_5iqO6 US006A 2025-12-02T14:30:46.940Z 2025-12-05T14:37:05.214Z
8666923 8666923 20251201072641_183n0 US006A 2025-12-02T14:30:46.637Z 2025-12-05T14:37:05.161Z
8666911 8666911 20251201070919_YqaGE US006A 2025-12-02T14:30:44.014Z 2025-12-05T14:37:04.298Z
8666883 8666883 20251201063442_6Sc64 US006A 2025-12-02T14:30:39.218Z 2025-12-05T14:37:02.996Z
8666859 8666859 20251201053122_NREOk US006A 2025-12-02T14:30:22.161Z 2025-12-05T14:36:56.862Z
8648456 8648456 20251129080016_O0JJm US006A 2025-11-30T14:30:11.291Z 2025-12-05T14:53:28.782Z
8648360 8648360 20251129073458_6UH6z US006A 2025-11-30T14:30:05.794Z 2025-12-05T14:53:17.086Z
8648303 8648303 20251129072212_CAAXF US006A 2025-11-30T14:30:02.394Z 2025-12-05T14:53:08.132Z
8648259 8648259 20251129071544_6UOEB US006A 2025-11-30T14:29:59.984Z 2025-12-05T14:53:03.811Z
8648246 8648246 20251129071235_XUjn9 US006A 2025-11-30T14:29:59.224Z 2025-12-05T14:53:03.576Z
8648201 8648201 20251129065617_aY23o US006A 2025-11-30T14:29:57.101Z 2025-12-05T14:52:59.308Z
8648067 8648067 20251129063404_M6XLw US006A 2025-11-30T14:29:32.420Z 2025-12-05T14:52:56.376Z
8648025 8648025 20251129062540_lJWIC US006A 2025-11-30T14:29:29.548Z 2025-12-05T14:52:55.493Z
8648018 8648018 20251129062405_w373P US006A 2025-11-30T14:29:29.150Z 2025-12-05T14:52:55.268Z
8647982 8647982 20251129061544_UOjqp US006A 2025-11-30T14:29:27.086Z 2025-12-05T14:52:53.012Z
8647945 8647945 20251129060709_Zt7nV US006A 2025-11-30T14:29:25.148Z 2025-12-05T14:52:51.358Z
8647823 8647823 20251129053814_EbIp5 US006A 2025-11-30T14:29:03.035Z 2025-12-05T14:52:48.440Z
8647782 8647782 20251129052819_n2XOs US006A 2025-11-30T14:28:53.449Z 2025-12-05T14:52:47.527Z
8647645 8647645 20251129050014_9y1Zd US006A 2025-11-30T14:28:40.868Z 2025-12-05T14:52:44.487Z
8647530 8647530 20251129044752_aUQ9b US006A 2025-11-30T14:28:33.109Z 2025-12-05T14:52:42.140Z
8647528 8647528 20251129044733_QNiPv US006A 2025-11-30T14:28:32.830Z 2025-12-05T14:52:42.083Z
8647367 8647367 20251129042738_3vdWg US006A 2025-11-30T14:28:03.483Z 2025-12-05T14:52:38.550Z
8646522 8646522 20251129021559_nJkEW US006A 2025-11-30T14:26:06.902Z 2025-12-05T14:51:43.789Z
8645985 8645985 20251129004119_SG0u3 US006A 2025-11-30T14:25:01.847Z 2025-12-05T14:51:30.537Z
8639309 8639309 20251129105330_01Obu US006A 2025-11-30T14:04:27.919Z 2025-12-05T14:38:16.116Z
8639188 8639188 20251129103811_K7D4K US006A 2025-11-30T14:04:05.349Z 2025-11-30T14:04:05.349Z
8639142 8639142 20251129103247_e4c3M US006A 2025-11-30T14:03:51.180Z 2025-12-05T14:37:56.728Z
8639056 8639056 20251129102059_tNaFt US006A 2025-11-30T14:03:36.422Z 2025-12-05T14:37:52.355Z
8638953 8638953 20251129100901_qem8a US006A 2025-11-30T14:03:06.004Z 2025-11-30T14:03:06.004Z
8638850 8638850 20251129095320_67MUm US006A 2025-11-30T14:02:35.607Z 2025-12-05T14:37:45.408Z
8638808 8638808 20251129094425_yE9p2 US006A 2025-11-30T14:02:28.896Z 2025-12-05T14:37:43.709Z
8638801 8638801 20251129094421_pj6EN US006A 2025-11-30T14:02:27.887Z 2025-12-05T14:37:43.504Z
8638573 8638573 20251129090833_eBNdU US006A 2025-11-30T14:01:28.669Z 2025-12-05T14:37:36.198Z
8638532 8638532 20251129090323_7Y32D US006A 2025-11-30T14:01:19.985Z 2025-12-05T14:37:34.278Z
8638477 8638477 20251129085528_SvHU3 US006A 2025-11-30T14:01:04.212Z 2025-12-05T14:37:18.728Z
8638435 8638435 20251129084611_wPLR8 US006A 2025-11-30T14:00:54.208Z 2025-12-05T14:37:16.285Z
8638389 8638389 20251129083635_zY4Pe US006A 2025-11-30T14:00:46.526Z 2025-12-05T14:37:14.662Z
8638314 8638314 20251129082356_jzbCN US006A 2025-11-30T14:00:28.823Z 2025-12-05T14:37:09.677Z
8638293 8638293 20251129082008_DddiJ US006A 2025-11-30T14:00:24.178Z 2025-12-05T14:37:08.881Z
8626784 8626784 20251128093403_ZryOb US006A 2025-11-29T14:01:29.979Z 2025-12-05T14:46:18.846Z
8626763 8626763 20251128093305_017Jj US006A 2025-11-29T14:01:26.729Z 2025-12-05T14:46:18.306Z
8626706 8626706 20251128092204_4JKqX US006A 2025-11-29T14:01:16.381Z 2025-12-05T14:46:16.978Z
8626659 8626659 20251128091644_dv23U US006A 2025-11-29T14:01:07.567Z 2025-12-05T14:46:15.573Z
8626657 8626657 20251128091533_V9n9L US006A 2025-11-29T14:01:07.083Z 2025-12-05T14:46:15.534Z
8626589 8626589 20251128090821_FJddI US006A 2025-11-29T14:00:57.974Z 2025-12-05T14:46:14.362Z
8626394 8626394 20251128082956_diV2M US006A 2025-11-29T14:00:12.688Z 2025-12-05T14:46:09.909Z
8624483 8624483 20251127050420_eN6Op US006A 2025-11-28T14:24:47.558Z 2025-12-05T15:05:06.631Z
8624237 8624237 20251127034536_ALJBe US006A 2025-11-28T14:24:19.679Z 2025-12-05T15:04:55.709Z
8624199 8624199 20251127033904_Ylhnv US006A 2025-11-28T14:23:58.821Z 2025-12-05T15:04:54.671Z
8624138 8624138 20251127031602_JoHhQ US006A 2025-11-28T14:23:51.464Z 2025-12-05T15:04:48.058Z
8624106 8624106 20251127030926_IgLBN US006A 2025-11-28T14:23:47.365Z 2025-12-05T15:04:44.314Z
8624081 8624081 20251127030203_D2vG6 US006A 2025-11-28T14:23:44.467Z 2025-12-05T15:04:43.846Z
8623910 8623910 20251127022406_UoVjc US006A 2025-11-28T14:23:05.392Z 2025-12-05T15:04:25.796Z
8623804 8623804 20251127020516_b0Kga US006A 2025-11-28T14:22:54.942Z 2025-12-05T15:04:17.825Z
8623765 8623765 20251127015616_L8g3C US006A 2025-11-28T14:22:50.124Z 2025-12-05T15:04:15.249Z
8623700 8623700 20251127014818_Qp2eI US006A 2025-11-28T14:22:26.761Z 2025-12-05T15:04:10.234Z
8602932 8602932 20251125053406_jYSa2 US006A 2025-11-26T14:26:28.659Z 2025-12-02T15:09:33.594Z
8592839 8592839 20251124093257_MKyNa US006A 2025-11-25T14:28:06.656Z 2025-12-02T15:13:07.965Z
8592817 8592817 20251124092841_69LAa US006A 2025-11-25T14:28:02.974Z 2025-12-02T15:13:07.728Z
8592807 8592807 20251124092805_SgyuM US006A 2025-11-25T14:27:52.875Z 2025-12-02T15:13:07.685Z
8592777 8592777 20251124092342_523T8 US006A 2025-11-25T14:27:46.226Z 2025-12-02T15:13:07.394Z
8592733 8592733 20251124091401_JpHil US006A 2025-11-25T14:27:32.922Z 2025-12-02T15:13:06.911Z
8592724 8592724 20251124091221_IKv24 US006A 2025-11-25T14:27:32.170Z 2025-12-02T15:13:06.798Z

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