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 = "AU001S" 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
9851771 9851771 20260504195351_5ncey AU001S 2026-05-06T12:16:48.747Z 2026-05-06T12:17:26.570Z
9851762 9851762 20260504195258_A1gLw AU001S 2026-05-06T12:16:46.868Z 2026-05-06T12:17:26.567Z
9851756 9851756 20260504195059_Yhi3X AU001S 2026-05-06T12:16:46.037Z 2026-05-06T12:17:26.562Z
9851752 9851752 20260504194936_Amt2h AU001S 2026-05-06T12:16:45.750Z 2026-05-06T12:17:26.562Z
9851746 9851746 20260504194708_3hrCd AU001S 2026-05-06T12:16:45.264Z 2026-05-06T12:17:26.559Z
9851742 9851742 20260504194654_kqlW8 AU001S 2026-05-06T12:16:45.232Z 2026-05-06T12:17:26.557Z
9851732 9851732 20260504194213_9GC3t AU001S 2026-05-06T12:16:44.768Z 2026-05-06T12:17:26.554Z
9851717 9851717 20260504193903_ykhIP AU001S 2026-05-06T12:16:43.858Z 2026-05-06T12:17:26.547Z
9851710 9851710 20260504193515_cLhup AU001S 2026-05-06T12:16:43.625Z 2026-05-06T12:17:26.544Z
9851697 9851697 20260504192838_a36ad AU001S 2026-05-06T12:16:42.786Z 2026-05-06T12:17:26.537Z
9851658 9851658 20260504192047_YWE8L AU001S 2026-05-06T12:16:38.574Z 2026-05-06T12:17:26.519Z
9851646 9851646 20260504191924_BnI0F AU001S 2026-05-06T12:16:37.001Z 2026-05-06T12:17:26.512Z
9851642 9851642 20260504191854_5YPzd AU001S 2026-05-06T12:16:36.793Z 2026-05-06T12:17:26.510Z
9851612 9851612 20260504190645_3lxtM AU001S 2026-05-06T12:16:31.201Z 2026-05-06T12:17:26.464Z
9851580 9851580 20260504184648_JoQHN AU001S 2026-05-06T12:16:26.364Z 2026-05-06T12:17:26.423Z
9851571 9851571 20260504184306_Iyswp AU001S 2026-05-06T12:16:25.084Z 2026-05-06T12:17:26.412Z
9851557 9851557 20260504184004_Gg59B AU001S 2026-05-06T12:16:23.022Z 2026-05-06T12:17:26.398Z
9851549 9851549 20260504183601_955wO AU001S 2026-05-06T12:16:18.704Z 2026-05-06T12:17:26.389Z
9851532 9851532 20260504182924_Amwat AU001S 2026-05-06T12:15:49.784Z 2026-05-06T12:17:26.365Z
9851529 9851529 20260504182902_S2x70 AU001S 2026-05-06T12:15:49.497Z 2026-05-06T12:17:26.363Z
9851524 9851524 20260504182900_bO4CA AU001S 2026-05-06T12:15:49.391Z 2026-05-06T12:17:26.362Z
9851501 9851501 20260504181743_oMi4Q AU001S 2026-05-06T12:15:46.318Z 2026-05-06T12:17:26.335Z
9851473 9851473 20260504175544_g7kGR AU001S 2026-05-06T12:15:34.358Z 2026-05-06T12:17:26.190Z
9851454 9851454 20260504174557_RLylH AU001S 2026-05-06T12:15:26.534Z 2026-05-06T12:17:26.149Z
9851451 9851451 20260504174406_wUPK7 AU001S 2026-05-06T12:15:14.551Z 2026-05-06T12:17:26.146Z
9851448 9851448 20260504174109_o8062 AU001S 2026-05-06T12:15:05.335Z 2026-05-06T12:17:26.138Z
9851443 9851443 20260504172933_IsvnM AU001S 2026-05-06T12:15:00.872Z 2026-05-06T12:17:25.737Z
9851435 9851435 20260504171941_mVUk6 AU001S 2026-05-06T12:14:53.491Z 2026-05-06T12:17:25.697Z
9851433 9851433 20260504171447_E8QR8 AU001S 2026-05-06T12:14:51.692Z 2026-05-06T12:17:25.675Z
9851429 9851429 20260504171247_3Mffm AU001S 2026-05-06T12:14:51.187Z 2026-05-06T12:17:25.670Z
9851405 9851405 20260504164206_w5Xjv AU001S 2026-05-06T12:14:35.512Z 2026-05-06T12:17:25.590Z
9851392 9851392 20260504162848_Ekwxf AU001S 2026-05-06T12:14:13.219Z 2026-05-06T12:17:25.547Z
9851374 9851374 20260504160818_qbRuA AU001S 2026-05-06T12:14:03.998Z 2026-05-06T12:17:25.480Z
9851366 9851366 20260504160608_3IDvk AU001S 2026-05-06T12:14:02.076Z 2026-05-06T12:17:25.469Z
9851340 9851340 20260504153811_eBqGh AU001S 2026-05-06T12:13:33.306Z 2026-05-06T12:17:25.386Z
9851322 9851322 20260504150326_2a29u AU001S 2026-05-06T12:13:17.504Z 2026-05-06T12:17:25.294Z
9851315 9851315 20260504145029_moPdV AU001S 2026-05-06T12:12:58.536Z 2026-05-06T12:17:25.248Z
9851310 9851310 20260504144937_oTzUM AU001S 2026-05-06T12:12:57.165Z 2026-05-06T12:17:25.247Z
9851291 9851291 20260504141644_M7vS2 AU001S 2026-05-06T12:12:38.981Z 2026-05-06T12:17:24.984Z
9851288 9851288 20260504140648_K9yFW AU001S 2026-05-06T12:12:36.603Z 2026-05-06T12:17:24.965Z
9851282 9851282 20260504140009_H3bIC AU001S 2026-05-06T12:12:34.635Z 2026-05-06T12:17:24.953Z
9851253 9851253 20260504133613_VOYk5 AU001S 2026-05-06T12:12:28.432Z 2026-05-06T12:17:24.908Z
9851244 9851244 20260504132418_Yg1n2 AU001S 2026-05-06T12:12:07.050Z 2026-05-06T12:17:24.881Z
9851240 9851240 20260504132137_o0ogY AU001S 2026-05-06T12:12:06.227Z 2026-05-06T12:17:24.876Z
9851223 9851223 20260504130240_lrJfm AU001S 2026-05-06T12:11:57.356Z 2026-05-06T12:17:24.829Z
9851210 9851210 20260504125906_nVbj9 AU001S 2026-05-06T12:11:55.738Z 2026-05-06T12:17:24.817Z
9851203 9851203 20260504124817_No3eh AU001S 2026-05-06T12:11:54.327Z 2026-05-06T12:17:24.799Z
9851191 9851191 20260504123409_AmMfu AU001S 2026-05-06T12:11:52.349Z 2026-05-06T12:17:24.781Z
9851187 9851187 20260504121606_3386T AU001S 2026-05-06T12:11:50.661Z 2026-05-06T12:17:24.753Z
9851181 9851181 20260504120816_1vYiS AU001S 2026-05-06T12:11:49.675Z 2026-05-06T12:17:24.743Z
9851167 9851167 20260504115738_bHyRr AU001S 2026-05-06T12:11:47.945Z 2026-05-06T12:17:24.728Z
9851162 9851162 20260504114706_npZXe AU001S 2026-05-06T12:11:46.107Z 2026-05-06T12:17:24.712Z
9851157 9851157 20260504112807_8KU4F AU001S 2026-05-06T12:11:43.234Z 2026-05-06T12:17:24.699Z
9851154 9851154 20260504112355_2FK9f AU001S 2026-05-06T12:11:34.125Z 2026-05-06T12:17:24.685Z
9851152 9851152 20260504111117_KErLq AU001S 2026-05-06T12:11:33.549Z 2026-05-06T12:17:24.675Z
9851145 9851145 20260504110555_Ibgfc AU001S 2026-05-06T12:11:32.717Z 2026-05-06T12:17:24.665Z
9846923 9846923 20260504211133_3ZvN4 AU001S 2026-05-06T12:00:53.857Z 2026-05-06T12:17:20.937Z
9846917 9846917 20260504211029_E3Hv2 AU001S 2026-05-06T12:00:53.043Z 2026-05-06T12:17:20.933Z
9846904 9846904 20260504210704_3wbjX AU001S 2026-05-06T12:00:51.464Z 2026-05-06T12:17:20.927Z
9846893 9846893 20260504210516_eGao3 AU001S 2026-05-06T12:00:50.216Z 2026-05-06T12:17:20.922Z
9846889 9846889 20260504210234_cQHVz AU001S 2026-05-06T12:00:49.713Z 2026-05-06T12:17:20.920Z
9846874 9846874 20260504205934_4MWds AU001S 2026-05-06T12:00:47.934Z 2026-05-06T12:17:20.912Z
9846846 9846846 20260504204853_zjocw AU001S 2026-05-06T12:00:39.638Z 2026-05-06T12:17:20.899Z
9846838 9846838 20260504204528_e37cQ AU001S 2026-05-06T12:00:38.364Z 2026-05-06T12:17:20.896Z
9846829 9846829 20260504204150_Sym7z AU001S 2026-05-06T12:00:35.153Z 2026-05-06T12:17:20.893Z
9846797 9846797 20260504203451_1RIJI AU001S 2026-05-06T12:00:29.954Z 2026-05-06T12:17:20.880Z
9846788 9846788 20260504203350_Y22D0 AU001S 2026-05-06T12:00:29.042Z 2026-05-06T12:17:20.879Z
9846775 9846775 20260504203024_sTtXM AU001S 2026-05-06T12:00:26.923Z 2026-05-06T12:17:20.875Z
9846772 9846772 20260504202956_3v8y8 AU001S 2026-05-06T12:00:26.652Z 2026-05-06T12:17:20.874Z
9846718 9846718 20260504201923_2IyRd AU001S 2026-05-06T12:00:16.959Z 2026-05-06T12:17:20.856Z
9846717 9846717 20260504201854_H37L8 AU001S 2026-05-06T12:00:16.288Z 2026-05-06T12:17:20.856Z
9846701 9846701 20260504201017_gjCWf AU001S 2026-05-06T12:00:12.749Z 2026-05-06T12:17:20.849Z
9846697 9846697 20260504201017_WiCMj AU001S 2026-05-06T12:00:12.378Z 2026-05-06T12:17:20.848Z
9846693 9846693 20260504200959_fh2i3 AU001S 2026-05-06T12:00:12.027Z 2026-05-06T12:17:20.847Z
9846651 9846651 20260503191232_ZZNwn AU001S 2026-05-05T12:17:08.519Z 2026-05-06T12:21:26.555Z
9846596 9846596 20260503184445_iXBka AU001S 2026-05-05T12:16:59.516Z 2026-05-06T12:21:24.716Z
9846594 9846594 20260503184150_n59T2 AU001S 2026-05-05T12:16:58.822Z 2026-05-06T12:21:24.357Z
9846579 9846579 20260503183919_quQN2 AU001S 2026-05-05T12:16:57.662Z 2026-05-06T12:21:22.570Z
9846565 9846565 20260503183230_6h2Pp AU001S 2026-05-05T12:16:56.108Z 2026-05-06T12:21:22.151Z
9846561 9846561 20260503182208_WGjHc AU001S 2026-05-05T12:16:55.484Z 2026-05-06T12:21:21.939Z
9846550 9846550 20260503181439_d3JkJ AU001S 2026-05-05T12:16:54.188Z 2026-05-06T12:21:21.565Z
9846530 9846530 20260503180259_rpdRI AU001S 2026-05-05T12:16:49.953Z 2026-05-06T12:21:20.722Z
9846519 9846519 20260503175524_Zax38 AU001S 2026-05-05T12:16:47.266Z 2026-05-06T12:21:20.186Z
9846508 9846508 20260503175223_BgFJB AU001S 2026-05-05T12:16:31.338Z 2026-05-06T12:21:19.774Z
9846499 9846499 20260503174956_q8u1p AU001S 2026-05-05T12:16:30.374Z 2026-05-06T12:21:19.533Z
9846491 9846491 20260503174140_AD0PK AU001S 2026-05-05T12:16:23.645Z 2026-05-06T12:21:18.433Z
9846486 9846486 20260503174133_U3Dc9 AU001S 2026-05-05T12:16:23.132Z 2026-05-06T12:21:18.313Z
9846483 9846483 20260503173442_ycd02 AU001S 2026-05-05T12:16:20.969Z 2026-05-06T12:21:17.846Z
9846472 9846472 20260503173028_9O744 AU001S 2026-05-05T12:16:19.295Z 2026-05-06T12:21:17.426Z
9846469 9846469 20260503172827_TP0iJ AU001S 2026-05-05T12:16:18.008Z 2026-05-06T12:21:17.141Z
9846464 9846464 20260503171745_RCicu AU001S 2026-05-05T12:16:14.896Z 2026-05-06T12:21:16.329Z
9846454 9846454 20260503171306_sKr6N AU001S 2026-05-05T12:16:12.229Z 2026-05-06T12:21:15.607Z
9846443 9846443 20260503170605_DX2HT AU001S 2026-05-05T12:16:09.647Z 2026-05-06T12:21:14.893Z
9846432 9846432 20260503165529_tI6eA AU001S 2026-05-05T12:16:06.671Z 2026-05-06T12:21:14.149Z
9846430 9846430 20260503164655_cFYMH AU001S 2026-05-05T12:16:04.882Z 2026-05-06T12:21:13.842Z
9846427 9846427 20260503164315_Jq12p AU001S 2026-05-05T12:15:54.221Z 2026-05-06T12:21:13.623Z
9846403 9846403 20260503162501_YzOZw AU001S 2026-05-05T12:15:43.216Z 2026-05-06T12:21:11.828Z
9846381 9846381 20260503155949_mFa6t AU001S 2026-05-05T12:15:35.183Z 2026-05-06T12:21:10.065Z
9846378 9846378 20260503155100_VAmPA AU001S 2026-05-05T12:15:34.021Z 2026-05-06T12:21:09.648Z
9846376 9846376 20260503154854_R1LZL AU001S 2026-05-05T12:15:33.329Z 2026-05-06T12:21:09.513Z

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