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

3,096 rows where station_code = "US005W" 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
8682375 8682375 20251203052230_QMEzm US005W 2025-12-04T14:17:02.748Z 2025-12-05T14:22:26.642Z
8681652 8681652 20251203033842_CZhkO US005W 2025-12-04T14:15:11.980Z 2025-12-05T14:21:45.231Z
8681446 8681446 20251203031106_0G5Jo US005W 2025-12-04T14:14:44.108Z 2025-12-05T14:21:37.574Z
8677784 8677784 20251203123041_TgP7h US005W 2025-12-04T14:02:36.186Z 2025-12-05T14:14:34.967Z
8677053 8677053 20251202064224_DdJ0Y US005W 2025-12-03T14:26:13.741Z 2025-12-05T14:29:19.347Z
8676769 8676769 20251202062307_fSu1L US005W 2025-12-03T14:25:33.770Z 2025-12-05T14:29:12.943Z
8676561 8676561 20251202060207_XW98R US005W 2025-12-03T14:25:18.645Z 2025-12-05T14:29:07.506Z
8675499 8675499 20251202045015_ANhTR US005W 2025-12-03T14:23:47.601Z 2025-12-05T14:28:33.950Z
8675379 8675379 20251202043336_b7tHY US005W 2025-12-03T14:23:39.063Z 2025-12-05T14:28:29.186Z
8675290 8675290 20251202042555_vln27 US005W 2025-12-03T14:23:29.664Z 2025-12-05T14:28:19.157Z
8675102 8675102 20251202040026_7rgCR US005W 2025-12-03T14:23:02.063Z 2025-12-05T14:28:11.007Z
8674936 8674936 20251202034104_RCBDo US005W 2025-12-03T14:22:44.264Z 2025-12-05T14:28:07.013Z
8674844 8674844 20251202033036_amutr US005W 2025-12-03T14:22:29.000Z 2025-12-05T14:28:04.553Z
8674842 8674842 20251202032947_eSjao US005W 2025-12-03T14:22:28.478Z 2025-12-05T14:28:04.404Z
8673959 8673959 20251202004850_5PgNh US005W 2025-12-03T14:20:26.138Z 2025-12-05T14:27:23.972Z
8669990 8669990 20251202124144_P8if3 US005W 2025-12-03T14:06:26.004Z 2025-12-05T14:18:04.475Z
8669783 8669783 20251202121029_NML6u US005W 2025-12-03T14:05:26.066Z 2025-12-05T14:17:47.729Z
8669555 8669555 20251202113058_mCpFq US005W 2025-12-03T14:04:31.191Z 2025-12-05T14:17:30.619Z
8669419 8669419 20251202111003_8ICMq US005W 2025-12-03T14:03:40.938Z 2025-12-05T14:17:20.150Z
8669358 8669358 20251202105918_S4VF2 US005W 2025-12-03T14:03:27.289Z 2025-12-05T14:17:12.985Z
8669337 8669337 20251202105548_KQMlr US005W 2025-12-03T14:03:24.428Z 2025-12-05T14:17:09.382Z
8669301 8669301 20251202104852_7CB7F US005W 2025-12-03T14:03:18.843Z 2025-12-05T14:17:06.495Z
8668831 8668831 20251202090917_tHjpC US005W 2025-12-03T14:01:24.797Z 2025-12-05T14:15:35.611Z
8668776 8668776 20251202085829_Hxe4y US005W 2025-12-03T14:01:12.754Z 2025-12-05T14:15:21.651Z
8668761 8668761 20251202085245_gwy4Z US005W 2025-12-03T14:01:09.712Z 2025-12-05T14:15:16.429Z
8668748 8668748 20251202085047_SXlgP US005W 2025-12-03T14:01:01.341Z 2025-12-05T14:15:11.373Z
8668728 8668728 20251202084154_TE2r3 US005W 2025-12-03T14:00:57.907Z 2025-12-05T14:15:07.768Z
8668695 8668695 20251202082512_d2ZSC US005W 2025-12-03T14:00:52.130Z 2025-12-05T14:15:02.254Z
8668681 8668681 20251202081905_GxQRN US005W 2025-12-03T14:00:49.035Z 2025-12-05T14:14:58.012Z
8668628 8668628 20251202080225_SUWVV US005W 2025-12-03T14:00:36.454Z 2025-12-05T14:14:47.518Z
8668590 8668590 20251202074958_uUcAx US005W 2025-12-03T14:00:30.174Z 2025-12-05T14:14:45.546Z
8668517 8668517 20251202072257_ptcEt US005W 2025-12-03T14:00:12.156Z 2025-12-05T14:14:37.983Z
8668502 8668502 20251129074850_YIi4b US005W 2025-12-02T14:49:21.255Z 2025-12-05T14:53:22.367Z
8668495 8668495 20251129065151_5ZBPV US005W 2025-12-02T14:49:16.879Z 2025-12-05T14:52:58.921Z
8668481 8668481 20251129063248_trJ3t US005W 2025-12-02T14:49:13.273Z 2025-12-05T14:52:56.048Z
8668447 8668447 20251129050751_omV53 US005W 2025-12-02T14:48:26.969Z 2025-12-05T14:52:45.533Z
8667382 8667382 20251130004057_0bcrs US005W 2025-12-02T14:37:35.368Z 2025-12-05T14:42:13.677Z
8660596 8660596 20251130131050_m2Meg US005W 2025-12-02T14:08:23.699Z 2025-12-05T14:31:15.831Z
8660515 8660515 20251130130102_zR9As US005W 2025-12-02T14:08:11.651Z 2025-12-05T14:31:13.461Z
8660446 8660446 20251130125216_8Rqxp US005W 2025-12-02T14:07:51.279Z 2025-12-05T14:31:10.244Z
8660407 8660407 20251130124928_V1YkH US005W 2025-12-02T14:07:47.542Z 2025-12-05T14:31:09.039Z
8660269 8660269 20251130121642_6yN8A US005W 2025-12-02T14:07:09.185Z 2025-12-05T14:31:01.665Z
8659898 8659898 20251130112736_7Tk4B US005W 2025-12-02T14:05:45.304Z 2025-12-05T14:30:35.857Z
8659891 8659891 20251130112632_73A8Z US005W 2025-12-02T14:05:44.293Z 2025-12-05T14:30:35.564Z
8659855 8659855 20251130112315_59fWO US005W 2025-12-02T14:05:37.321Z 2025-12-05T14:30:33.859Z
8659776 8659776 20251130111443_AjF56 US005W 2025-12-02T14:05:16.504Z 2025-12-05T14:30:30.858Z
8659764 8659764 20251130111330_RADC7 US005W 2025-12-02T14:05:15.288Z 2025-12-05T14:30:30.678Z
8659695 8659695 20251130110629_IVqVq US005W 2025-12-02T14:05:03.268Z 2025-12-05T14:30:28.537Z
8659691 8659691 20251130110516_HcHX2 US005W 2025-12-02T14:04:57.487Z 2025-12-05T14:30:28.272Z
8659101 8659101 20251130093226_F3mbs US005W 2025-12-02T14:02:33.502Z 2025-12-05T14:29:52.839Z
8658246 8658246 20251129031427_JZCST US005W 2025-12-01T14:45:04.081Z 2025-12-05T14:52:01.214Z
8648694 8648694 20251129085243_SHplQ US005W 2025-12-01T14:00:36.113Z 2025-12-05T14:37:17.912Z
8648390 8648390 20251129074209_BUJqu US005W 2025-11-30T14:30:07.639Z 2025-12-05T14:53:20.306Z
8648296 8648296 20251129072109_z3nbu US005W 2025-11-30T14:30:02.246Z 2025-12-05T14:53:05.304Z
8648290 8648290 20251129072017_3U3ql US005W 2025-11-30T14:30:02.075Z 2025-12-05T14:53:04.996Z
8648253 8648253 20251129071317_w2fqE US005W 2025-11-30T14:29:59.728Z 2025-12-05T14:53:03.741Z
8648189 8648189 20251129065302_huuLS US005W 2025-11-30T14:29:55.357Z 2025-12-05T14:52:59.073Z
8648183 8648183 20251129065208_XIv7X US005W 2025-11-30T14:29:51.538Z 2025-12-05T14:52:58.963Z
8648136 8648136 20251129064406_tqm8M US005W 2025-11-30T14:29:39.643Z 2025-12-05T14:52:57.897Z
8648129 8648129 20251129064259_1GO1k US005W 2025-11-30T14:29:38.952Z 2025-12-05T14:52:57.631Z
8648116 8648116 20251129063942_BmTr3 US005W 2025-11-30T14:29:38.319Z 2025-12-05T14:52:57.355Z
8648103 8648103 20251129063806_Un9bk US005W 2025-11-30T14:29:37.564Z 2025-12-05T14:52:57.132Z
8648095 8648095 20251129063713_RMc1D US005W 2025-11-30T14:29:35.861Z 2025-12-05T14:52:56.893Z
8648022 8648022 20251129062535_mNJ6e US005W 2025-11-30T14:29:29.386Z 2025-12-05T14:52:55.424Z
8648006 8648006 20251129061823_ed0ii US005W 2025-11-30T14:29:28.441Z 2025-12-05T14:52:54.946Z
8647957 8647957 20251129061127_p3SHX US005W 2025-11-30T14:29:25.630Z 2025-12-05T14:52:51.794Z
8647651 8647651 20251129050127_vlZ7K US005W 2025-11-30T14:28:41.550Z 2025-12-05T14:52:44.624Z
8647334 8647334 20251129042345_UIsL0 US005W 2025-11-30T14:28:00.303Z 2025-12-05T14:52:37.738Z
8647311 8647311 20251129041955_nIB5l US005W 2025-11-30T14:27:58.936Z 2025-12-05T14:52:37.405Z
8647263 8647263 20251129041321_Yt4pQ US005W 2025-11-30T14:27:54.171Z 2025-12-05T14:52:36.411Z
8640131 8640131 20251129125621_ZBpHS US005W 2025-11-30T14:07:20.662Z 2025-12-05T14:38:44.889Z
8640084 8640084 20251129124624_P5aem US005W 2025-11-30T14:07:02.795Z 2025-12-05T14:38:43.185Z
8639801 8639801 20251129120536_ZyqLZ US005W 2025-11-30T14:06:09.238Z 2025-12-05T14:38:32.011Z
8639780 8639780 20251129115939_uQgd0 US005W 2025-11-30T14:06:05.606Z 2025-12-05T14:38:31.325Z
8639685 8639685 20251129114138_JZzSQ US005W 2025-11-30T14:05:45.648Z 2025-12-05T14:38:28.727Z
8639641 8639641 20251129113426_ia9Sv US005W 2025-11-30T14:05:40.069Z 2025-12-05T14:38:27.465Z
8639569 8639569 20251129112338_lQBnf US005W 2025-11-30T14:05:21.534Z 2025-12-05T14:38:25.437Z
8639471 8639471 20251129110928_Rx9Gd US005W 2025-11-30T14:05:05.994Z 2025-11-30T14:05:05.994Z
8639311 8639311 20251129105353_G33D9 US005W 2025-11-30T14:04:29.594Z 2025-11-30T14:04:29.594Z
8638378 8638378 20251129083500_pE1Gf US005W 2025-11-30T14:00:43.914Z 2025-12-05T14:37:13.989Z
8638265 8638265 20251129081321_eVn3e US005W 2025-11-30T14:00:17.536Z 2025-12-05T14:37:07.885Z
8637842 8637842 20251128065021_TY0vn US005W 2025-11-29T14:27:55.108Z 2025-12-05T15:00:31.670Z
8637779 8637779 20251128063759_5kKqN US005W 2025-11-29T14:27:50.763Z 2025-12-05T15:00:26.782Z
8637774 8637774 20251128063549_xhSfF US005W 2025-11-29T14:27:50.127Z 2025-12-05T15:00:26.474Z
8637635 8637635 20251128060127_t7UkJ US005W 2025-11-29T14:27:38.369Z 2025-12-05T15:00:11.259Z
8637448 8637448 20251128054038_mCYeJ US005W 2025-11-29T14:27:15.993Z 2025-12-05T14:59:53.500Z
8637395 8637395 20251128053607_AtRmu US005W 2025-11-29T14:27:12.034Z 2025-12-05T14:59:50.668Z
8637031 8637031 20251128045235_poltv US005W 2025-11-29T14:26:39.284Z 2025-12-05T14:59:36.313Z
8636880 8636880 20251128043156_SXz25 US005W 2025-11-29T14:26:17.538Z 2025-12-05T14:59:31.111Z
8636565 8636565 20251128040443_RN34V US005W 2025-11-29T14:25:42.611Z 2025-12-05T14:59:26.224Z
8635856 8635856 20251128025404_48BH8 US005W 2025-11-29T14:24:14.977Z 2025-12-05T14:59:15.562Z
8628048 8628048 20251128121115_GOL2d US005W 2025-11-29T14:05:10.628Z 2025-12-05T14:47:12.906Z
8627629 8627629 20251128112027_Jk06j US005W 2025-11-29T14:04:05.395Z 2025-12-05T14:47:03.449Z
8626149 8626149 20251126075533_9Uy0L US005W 2025-11-28T14:37:53.907Z 2025-12-04T15:11:53.777Z
8626044 8626044 20251126071146_TFQHb US005W 2025-11-28T14:37:33.128Z 2025-12-04T15:11:50.887Z
8625656 8625656 20251126040231_rBF3R US005W 2025-11-28T14:35:35.281Z 2025-12-04T15:10:33.901Z
8625239 8625239 20251127084311_qQ1tW US005W 2025-11-28T14:26:42.038Z 2025-12-05T15:05:48.368Z
8625186 8625186 20251127082856_pllx3 US005W 2025-11-28T14:26:24.013Z 2025-12-05T15:05:46.986Z
8625129 8625129 20251127080937_Qykj2 US005W 2025-11-28T14:26:17.130Z 2025-12-05T15:05:42.738Z
8625116 8625116 20251127080603_8w3DZ US005W 2025-11-28T14:26:15.798Z 2025-12-05T15:05:42.413Z

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