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

2,726 rows where station_code = "US0054" 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
9273414 9273414 20260128060746_RIqMs US0054 2026-01-29T14:29:42.274Z 2026-01-29T14:30:25.805Z
9273347 9273347 20260128054811_SP3mB US0054 2026-01-29T14:29:23.686Z 2026-01-29T14:30:25.792Z
9252851 9252851 20260123070140_Q822v US0054 2026-01-24T14:17:29.691Z 2026-01-29T14:53:37.446Z
9252830 9252830 20260123064531_dLaqe US0054 2026-01-24T14:17:26.007Z 2026-01-29T14:53:36.097Z
9250110 9250110 20260123102004_2PaUE US0054 2026-01-24T14:01:11.874Z 2026-01-29T14:44:59.218Z
9245190 9245190 20260122110539_a3dj2 US0054 2026-01-23T14:00:57.427Z 2026-01-29T14:49:13.103Z
9210104 9210104 20260115120709_p1GQ0 US0054 2026-01-16T14:18:43.008Z 2026-01-22T15:05:48.047Z
9210084 9210084 20260115120125_oaxSQ US0054 2026-01-16T14:18:38.229Z 2026-01-22T15:05:45.722Z
9209694 9209694 20260115103508_dDySL US0054 2026-01-16T14:17:14.115Z 2026-01-22T15:05:34.196Z
9104842 9104842 20251230072049_jogJp US0054 2025-12-31T14:22:37.190Z 2026-01-07T15:10:08.656Z
9104796 9104796 20251230065148_KAWGh US0054 2025-12-31T14:22:28.232Z 2026-01-07T15:10:05.767Z
9046017 9046017 20251223120725_yy3gW US0054 2025-12-28T14:54:35.566Z 2025-12-31T15:42:57.996Z
9045993 9045993 20251223120125_1vWrE US0054 2025-12-28T14:54:28.322Z 2025-12-31T15:42:57.668Z
9045958 9045958 20251223115624_4ElbT US0054 2025-12-28T14:54:10.541Z 2025-12-31T15:42:57.113Z
9045836 9045836 20251223113125_eoScK US0054 2025-12-28T14:54:04.546Z 2025-12-31T15:42:55.759Z
9045793 9045793 20251223112600_QkWl4 US0054 2025-12-28T14:54:02.637Z 2025-12-31T15:42:55.352Z
9009066 9009066 20251221120554_yl96W US0054 2025-12-27T14:44:02.841Z 2025-12-27T14:44:02.841Z
9007155 9007155 20251221090807_vcaLB US0054 2025-12-27T14:39:39.808Z 2025-12-27T14:39:39.808Z
9006178 9006178 20251221045714_298HL US0054 2025-12-27T14:36:58.902Z 2025-12-27T14:36:58.902Z
9005894 9005894 20251221034534_Yvop7 US0054 2025-12-27T14:36:08.758Z 2025-12-27T14:36:08.758Z
8965290 8965290 20251216101628_630Er US0054 2025-12-25T14:43:34.236Z 2025-12-25T14:43:34.236Z
8964346 8964346 20251216081813_aEgUR US0054 2025-12-25T14:41:19.073Z 2025-12-25T14:41:19.073Z
8964006 8964006 20251216071716_pBw0E US0054 2025-12-25T14:40:37.048Z 2025-12-25T14:40:37.048Z
8963633 8963633 20251216060421_0YLuN US0054 2025-12-25T14:39:45.024Z 2025-12-25T14:39:45.024Z
8963418 8963418 20251216052840_s3AcT US0054 2025-12-25T14:39:05.789Z 2025-12-25T14:39:05.789Z
8962926 8962926 20251216041154_dDIOj US0054 2025-12-25T14:37:33.214Z 2025-12-25T14:37:33.214Z
8962902 8962902 20251216040827_zVVWP US0054 2025-12-25T14:37:18.929Z 2025-12-25T14:37:18.929Z
8926976 8926976 20251215033636_dQL9H US0054 2025-12-24T14:06:04.867Z 2025-12-24T15:09:29.755Z
8922876 8922876 20251214115918_bbAaB US0054 2025-12-23T14:14:35.226Z 2025-12-24T14:40:07.745Z
8922567 8922567 20251214115353_hJel3 US0054 2025-12-23T14:14:31.147Z 2025-12-24T14:39:53.834Z
8922469 8922469 20251214115244_wSlmL US0054 2025-12-23T14:14:27.943Z 2025-12-24T14:39:16.944Z
8922417 8922417 20251214115140_n9Zhd US0054 2025-12-23T14:14:25.486Z 2025-12-24T14:39:04.147Z
8922248 8922248 20251214114835_yyRFH US0054 2025-12-23T14:14:20.731Z 2025-12-24T14:38:58.661Z
8921295 8921295 20251214113013_J52NJ US0054 2025-12-23T14:13:33.890Z 2025-12-24T14:38:01.561Z
8921252 8921252 20251214112843_QrYCc US0054 2025-12-23T14:13:31.932Z 2025-12-24T14:37:46.365Z
8920992 8920992 20251214112405_G98Bz US0054 2025-12-23T14:13:27.836Z 2025-12-24T14:37:32.249Z
8920638 8920638 20251214111831_eAqeA US0054 2025-12-23T14:13:16.504Z 2025-12-24T14:37:21.993Z
8920125 8920125 20251214111028_Ypd1I US0054 2025-12-23T14:13:06.864Z 2025-12-24T14:36:48.973Z
8918968 8918968 20251214104723_hZxcp US0054 2025-12-23T14:12:46.526Z 2025-12-24T14:35:08.650Z
8918907 8918907 20251214104601_KKxMK US0054 2025-12-23T14:12:46.205Z 2025-12-24T14:34:59.204Z
8918830 8918830 20251214104433_pGKUQ US0054 2025-12-23T14:12:45.975Z 2025-12-24T14:34:58.654Z
8918611 8918611 20251214103901_zNtPN US0054 2025-12-23T14:12:44.511Z 2025-12-23T14:28:37.678Z
8918311 8918311 20251214103345_wKfK3 US0054 2025-12-23T14:12:42.485Z 2025-12-24T14:34:36.943Z
8917718 8917718 20251214102219_7inea US0054 2025-12-23T14:12:37.816Z 2025-12-23T14:28:37.078Z
8917398 8917398 20251214101526_UK0T8 US0054 2025-12-23T14:12:35.881Z 2025-12-24T14:33:33.461Z
8917094 8917094 20251214100953_ZAhcw US0054 2025-12-23T14:12:33.649Z 2025-12-24T14:33:24.076Z
8916948 8916948 20251214100451_pEFpq US0054 2025-12-23T14:12:32.597Z 2025-12-24T14:33:08.914Z
8916426 8916426 20251214095406_tzpOw US0054 2025-12-23T14:12:11.543Z 2025-12-24T14:32:14.537Z
8915905 8915905 20251214094338_kEgmv US0054 2025-12-23T14:11:45.798Z 2025-12-24T14:31:57.643Z
8915804 8915804 20251214094013_k3G3Q US0054 2025-12-23T14:11:39.625Z 2025-12-24T14:31:53.597Z
8915654 8915654 20251214093651_lD8hq US0054 2025-12-23T14:11:36.907Z 2025-12-24T14:31:49.546Z
8915315 8915315 20251214092718_mlpPd US0054 2025-12-23T14:11:29.931Z 2025-12-24T14:31:11.010Z
8915102 8915102 20251214092132_qpfo7 US0054 2025-12-23T14:11:24.507Z 2025-12-24T14:30:35.570Z
8914717 8914717 20251214091003_rSAR8 US0054 2025-12-23T14:11:17.076Z 2025-12-23T14:28:35.047Z
8914713 8914713 20251214090933_QK5M2 US0054 2025-12-23T14:11:16.916Z 2025-12-24T14:30:23.673Z
8914217 8914217 20251214085313_Irq5i US0054 2025-12-23T14:11:06.068Z 2025-12-23T14:28:34.767Z
8913855 8913855 20251214084142_Am48b US0054 2025-12-23T14:10:59.612Z 2025-12-24T14:29:10.382Z
8913841 8913841 20251214084100_zWN0s US0054 2025-12-23T14:10:59.577Z 2025-12-23T14:28:34.556Z
8913626 8913626 20251214083436_NL35k US0054 2025-12-23T14:10:57.567Z 2025-12-23T14:28:34.418Z
8913251 8913251 20251214082326_uds9b US0054 2025-12-23T14:10:55.866Z 2025-12-24T14:28:49.511Z
8913167 8913167 20251214082117_lhThl US0054 2025-12-23T14:10:54.524Z 2025-12-24T14:28:47.477Z
8913109 8913109 20251214081936_tm0Is US0054 2025-12-23T14:10:52.764Z 2025-12-23T14:28:33.992Z
8912802 8912802 20251214080941_l8gKz US0054 2025-12-23T14:10:50.637Z 2025-12-24T14:27:48.186Z
8912578 8912578 20251214080225_BgDNT US0054 2025-12-23T14:10:48.906Z 2025-12-24T14:27:39.631Z
8912454 8912454 20251214075840_zfek5 US0054 2025-12-23T14:10:48.551Z 2025-12-24T14:27:36.943Z
8912336 8912336 20251214075531_ay1JO US0054 2025-12-23T14:10:48.133Z 2025-12-24T14:27:32.907Z
8912134 8912134 20251214074739_Oy2jW US0054 2025-12-23T14:10:47.135Z 2025-12-24T14:27:15.208Z
8912120 8912120 20251214074719_R7Yoq US0054 2025-12-23T14:10:47.003Z 2025-12-24T14:27:11.327Z
8912049 8912049 20251214074608_ovvK2 US0054 2025-12-23T14:10:46.721Z 2025-12-23T14:28:33.027Z
8911721 8911721 20251214073755_G4CC5 US0054 2025-12-23T14:10:45.056Z 2025-12-23T14:28:32.818Z
8911549 8911549 20251214073313_SjBtK US0054 2025-12-23T14:10:43.517Z 2025-12-24T14:26:09.199Z
8911079 8911079 20251214071835_33Ril US0054 2025-12-23T14:10:40.476Z 2025-12-24T14:25:52.903Z
8911068 8911068 20251214071820_dGjv2 US0054 2025-12-23T14:10:40.390Z 2025-12-24T14:25:51.879Z
8910869 8910869 20251214071226_U8GMi US0054 2025-12-23T14:10:38.498Z 2025-12-24T14:25:25.001Z
8910759 8910759 20251214070939_nMRz2 US0054 2025-12-23T14:10:36.516Z 2025-12-24T14:25:04.813Z
8910556 8910556 20251214070440_OcNO1 US0054 2025-12-23T14:10:17.948Z 2025-12-24T14:24:59.183Z
8910423 8910423 20251214065956_OwzA5 US0054 2025-12-23T14:10:15.719Z 2025-12-24T14:24:49.775Z
8910418 8910418 20251214065951_x4XTz US0054 2025-12-23T14:10:15.073Z 2025-12-24T14:24:47.782Z
8910357 8910357 20251214065841_D2oqH US0054 2025-12-23T14:10:12.146Z 2025-12-24T14:24:29.932Z
8910085 8910085 20251214065032_JyaEO US0054 2025-12-23T14:09:53.505Z 2025-12-24T14:23:49.435Z
8909977 8909977 20251214064806_CM0Ig US0054 2025-12-23T14:09:47.592Z 2025-12-24T14:23:33.438Z
8909720 8909720 20251214064300_58PYn US0054 2025-12-23T14:09:34.403Z 2025-12-23T14:28:31.126Z
8909551 8909551 20251214064018_z5hpL US0054 2025-12-23T14:09:28.600Z 2025-12-24T14:22:54.562Z
8909010 8909010 20251214062925_UFDrt US0054 2025-12-23T14:09:01.464Z 2025-12-24T14:22:46.124Z
8908936 8908936 20251214062750_VDx7g US0054 2025-12-23T14:08:58.849Z 2025-12-24T14:22:45.526Z
8908792 8908792 20251214062502_m3zWv US0054 2025-12-23T14:08:43.777Z 2025-12-24T14:22:42.031Z
8908525 8908525 20251214062019_w2ndb US0054 2025-12-23T14:08:41.009Z 2025-12-24T14:22:39.116Z
8908322 8908322 20251214061652_mj2R9 US0054 2025-12-23T14:08:31.922Z 2025-12-24T14:22:29.804Z
8907958 8907958 20251214060935_KBL0l US0054 2025-12-23T14:08:19.475Z 2025-12-24T14:21:53.609Z
8907945 8907945 20251214060915_B6GZ8 US0054 2025-12-23T14:08:19.044Z 2025-12-24T14:21:53.253Z
8905706 8905706 20251214053400_NFjYL US0054 2025-12-23T14:08:01.002Z 2025-12-24T14:20:44.924Z
8904916 8904916 20251214052347_ibxzH US0054 2025-12-23T14:07:35.790Z 2025-12-24T14:20:33.221Z
8904912 8904912 20251214052344_8bvty US0054 2025-12-23T14:07:35.741Z 2025-12-24T14:20:33.145Z
8904536 8904536 20251214051918_3jElV US0054 2025-12-23T14:07:24.482Z 2025-12-24T14:20:28.467Z
8903135 8903135 20251214050121_6RLwV US0054 2025-12-23T14:06:00.090Z 2025-12-24T14:19:35.518Z
8902511 8902511 20251214045532_V8iy3 US0054 2025-12-23T14:05:53.509Z 2025-12-24T14:19:28.037Z
8901717 8901717 20251214044757_kbhbK US0054 2025-12-23T14:05:48.023Z 2025-12-24T14:18:50.339Z
8901394 8901394 20251214044457_H1g2h US0054 2025-12-23T14:05:45.585Z 2025-12-24T14:18:46.101Z
8900876 8900876 20251214043940_dskQQ US0054 2025-12-23T14:05:28.582Z 2025-12-24T14:18:36.772Z
8897354 8897354 20251214024804_LCRI4 US0054 2025-12-22T14:12:23.195Z 2025-12-23T14:27:58.498Z

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