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

9,210 rows where station_code = "US001P" 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
8691114 8691114 20251205033645_Opud2 US001P 2025-12-06T14:16:31.826Z 2025-12-06T14:18:01.035Z
8688846 8688846 20251205130020_EyBWJ US001P 2025-12-06T14:06:05.664Z 2025-12-06T14:06:05.664Z
8671604 8671604 20251201124026_D83aw US001P 2025-12-03T14:13:09.447Z 2025-12-06T14:31:13.489Z
8671517 8671517 20251201122959_hMaTl US001P 2025-12-03T14:12:54.123Z 2025-12-06T14:31:09.693Z
8671415 8671415 20251201121403_04Ke2 US001P 2025-12-03T14:12:25.616Z 2025-12-06T14:31:02.958Z
8671304 8671304 20251201115508_EsZYu US001P 2025-12-03T14:12:06.199Z 2025-12-06T14:30:53.038Z
8669632 8669632 20251202114629_2HkLk US001P 2025-12-03T14:04:46.081Z 2025-12-06T14:24:10.882Z
8667582 8667582 20251130022526_ArEbH US001P 2025-12-02T14:38:58.671Z 2025-12-06T14:48:14.786Z
8637687 8637687 20251128061315_5ghfY US001P 2025-11-29T14:27:42.797Z 2025-12-06T15:04:02.877Z
8637669 8637669 20251128060828_lrjbJ US001P 2025-11-29T14:27:41.683Z 2025-12-06T15:04:02.423Z
8636915 8636915 20251128043701_3iZyR US001P 2025-11-29T14:26:20.096Z 2025-12-06T15:03:50.422Z
8636883 8636883 20251128043238_HN2RV US001P 2025-11-29T14:26:18.096Z 2025-12-06T15:03:47.821Z
8636692 8636692 20251128041720_VrTMU US001P 2025-11-29T14:26:05.730Z 2025-12-06T15:03:38.003Z
8625563 8625563 20251126030433_IA275 US001P 2025-11-28T14:35:08.160Z 2025-12-04T15:09:37.655Z
8625489 8625489 20251126020817_mBoOM US001P 2025-11-28T14:34:19.035Z 2025-12-04T15:09:25.706Z
8625164 8625164 20251127081750_Ucx4H US001P 2025-11-28T14:26:19.687Z 2025-12-05T15:05:45.875Z
8620094 8620094 20251126114504_XGTMU US001P 2025-11-28T14:11:36.198Z 2025-12-05T15:01:28.458Z
8619387 8619387 20251126100100_AkF9F US001P 2025-11-28T14:08:40.226Z 2025-12-05T15:00:57.461Z
8617743 8617743 20251127102800_sd0y0 US001P 2025-11-28T14:02:11.410Z 2025-12-06T14:58:21.881Z
8593695 8593695 20251125122759_ypH8Z US001P 2025-11-26T14:03:10.835Z 2025-12-04T15:05:22.674Z
8582361 8582361 20251123055236_fi4wm US001P 2025-11-24T14:33:31.589Z 2025-12-01T15:22:22.664Z
8582195 8582195 20251123043849_ADCoq US001P 2025-11-24T14:33:22.129Z 2025-12-01T15:22:18.491Z
8582182 8582182 20251123043045_SNyV3 US001P 2025-11-24T14:33:21.417Z 2025-12-01T15:22:17.978Z
8581725 8581725 20251123015437_DLP2P US001P 2025-11-24T14:32:34.382Z 2025-12-01T15:21:20.396Z
8580908 8580908 20251122084544_wjivL US001P 2025-11-24T14:29:05.261Z 2025-11-30T15:07:16.206Z
8575126 8575126 20251122114427_3owaB US001P 2025-11-24T14:02:14.158Z 2025-12-01T15:17:54.534Z
8574998 8574998 20251122112049_5n1GW US001P 2025-11-24T14:01:43.895Z 2025-12-01T15:17:45.269Z
8574954 8574954 20251122111258_CPoeP US001P 2025-11-24T14:01:34.815Z 2025-12-01T15:17:42.383Z
8573470 8573470 20251122031906_iMVPP US001P 2025-11-23T14:41:12.898Z 2025-11-23T14:41:12.898Z
8573164 8573164 20251122023740_ZW3W8 US001P 2025-11-23T14:40:57.506Z 2025-11-30T15:06:11.580Z
8572863 8572863 20251122015230_JuE6v US001P 2025-11-23T14:39:49.831Z 2025-11-23T14:39:49.831Z
8529572 8529572 20251119095213_vLuwT US001P 2025-11-20T14:45:04.207Z 2025-11-27T15:13:33.416Z
8515185 8515185 20251118035656_ARQza US001P 2025-11-19T14:39:01.103Z 2025-11-26T15:07:59.527Z
8487219 8487219 20251116123120_vCnPD US001P 2025-11-18T14:02:32.836Z 2025-11-25T15:06:08.966Z
8470903 8470903 20251115060535_tEqXM US001P 2025-11-16T14:23:47.155Z 2025-11-23T15:18:20.237Z
8470884 8470884 20251115060431_3ovkI US001P 2025-11-16T14:23:46.454Z 2025-11-23T15:18:20.143Z
8469872 8469872 20251115034402_boEhJ US001P 2025-11-16T14:21:25.333Z 2025-11-23T15:17:58.333Z
8469122 8469122 20251115020232_m1tkX US001P 2025-11-16T14:19:22.440Z 2025-11-23T15:17:34.704Z
8450117 8450117 20251113034831_uNMfh US001P 2025-11-14T14:22:32.934Z 2025-11-21T15:12:28.726Z
8449869 8449869 20251113031301_P69gS US001P 2025-11-14T14:21:48.152Z 2025-11-21T15:12:21.669Z
8429490 8429490 20251111100628_VTr2L US001P 2025-11-12T14:44:32.088Z 2025-11-19T15:18:43.316Z
8427992 8427992 20251111053529_PsuLx US001P 2025-11-12T14:29:47.086Z 2025-11-12T14:29:47.086Z
8427082 8427082 20251111040505_WW3c2 US001P 2025-11-12T14:27:13.372Z 2025-11-12T14:27:13.372Z
8427004 8427004 20251111035956_G82Nq US001P 2025-11-12T14:27:02.406Z 2025-11-19T15:17:40.251Z
8426888 8426888 20251111035204_Hwtg0 US001P 2025-11-12T14:26:32.953Z 2025-11-19T15:17:29.503Z
8424999 8424999 20251111010744_PsYNe US001P 2025-11-12T14:21:40.950Z 2025-11-19T15:16:32.036Z
8414203 8414203 20251110015517_BQ1le US001P 2025-11-11T14:19:56.889Z 2025-11-18T15:20:47.915Z
8406293 8406293 20251109055059_8bwbU US001P 2025-11-10T14:16:23.173Z 2025-11-17T14:59:11.389Z
8405464 8405464 20251109033100_QhsNq US001P 2025-11-10T14:14:24.020Z 2025-11-17T14:58:57.062Z
8404898 8404898 20251109023419_R5TDS US001P 2025-11-10T14:13:03.883Z 2025-11-17T14:58:53.089Z
8404892 8404892 20251109023323_TaAc3 US001P 2025-11-10T14:12:55.365Z 2025-11-17T14:58:53.061Z
8398464 8398464 20251108043556_f3ktq US001P 2025-11-09T14:15:35.198Z 2025-11-16T15:04:48.382Z
8398291 8398291 20251108040502_vp2Xd US001P 2025-11-09T14:14:57.685Z 2025-11-16T15:04:42.258Z
8391772 8391772 20251107034713_SrzDM US001P 2025-11-08T14:15:57.438Z 2025-11-15T15:00:37.298Z
8391699 8391699 20251107033637_w0iVS US001P 2025-11-08T14:15:45.889Z 2025-11-15T15:00:36.383Z
8391697 8391697 20251107033635_I8CPz US001P 2025-11-08T14:15:45.542Z 2025-11-15T15:00:36.271Z
8390706 8390706 20251107011226_VFWnY US001P 2025-11-08T14:12:01.185Z 2025-11-15T15:00:09.123Z
8390633 8390633 20251107010035_jqX3r US001P 2025-11-08T14:11:49.941Z 2025-11-15T15:00:08.138Z
8388005 8388005 20251106122756_TYXBA US001P 2025-11-07T14:16:33.575Z 2025-11-14T15:08:57.294Z
8374218 8374218 20251103031309_hPR38 US001P 2025-11-05T14:31:26.126Z 2025-11-11T15:07:19.916Z
8371806 8371806 20251104055108_4R8HR US001P 2025-11-05T14:16:14.203Z 2025-11-12T15:11:07.092Z
8371613 8371613 20251104044453_yo79g US001P 2025-11-05T14:15:31.983Z 2025-11-12T15:11:03.995Z
8340604 8340604 20251031121044_Fj80C US001P 2025-11-02T14:35:30.790Z 2025-11-08T15:18:14.205Z
8336243 8336243 20251031042701_BuuYe US001P 2025-11-02T14:29:09.842Z 2025-11-08T15:15:42.901Z
8336087 8336087 20251031041510_JXiBZ US001P 2025-11-02T14:28:52.856Z 2025-11-08T15:15:37.129Z
8335919 8335919 20251031035827_DRbtI US001P 2025-11-02T14:28:17.689Z 2025-11-08T15:15:15.985Z
8327226 8327226 20251030105340_8CSG0 US001P 2025-11-01T12:37:14.195Z 2025-11-07T15:18:50.952Z
8327223 8327223 20251030105329_TSnC8 US001P 2025-11-01T12:37:13.173Z 2025-11-07T15:18:50.426Z
8308725 8308725 20251029112454_GHhmR US001P 2025-10-31T12:30:12.330Z 2025-11-06T15:16:20.327Z
8308406 8308406 20251029110147_tXAyr US001P 2025-10-31T12:29:26.713Z 2025-11-06T15:16:03.867Z
8308263 8308263 20251029104915_pl6d9 US001P 2025-10-31T12:29:17.248Z 2025-11-06T15:15:59.805Z
8308090 8308090 20251029103304_jNRGK US001P 2025-10-31T12:29:07.505Z 2025-11-06T15:15:56.079Z
8305379 8305379 20251029051945_W431m US001P 2025-10-31T12:22:11.490Z 2025-11-06T15:14:32.275Z
8295075 8295075 20251028111825_Myhty US001P 2025-10-30T12:42:11.889Z 2025-11-05T15:24:56.090Z
8294530 8294530 20251028104218_82WMv US001P 2025-10-30T12:41:06.603Z 2025-11-05T15:24:35.079Z
8284570 8284570 20251028045522_BBEND US001P 2025-10-29T12:45:59.992Z 2025-11-05T15:22:51.585Z
8284413 8284413 20251028044153_gjwgD US001P 2025-10-29T12:45:32.640Z 2025-11-05T15:22:46.692Z
8284328 8284328 20251028043526_v4D2H US001P 2025-10-29T12:45:29.661Z 2025-11-05T15:22:44.572Z
8284282 8284282 20251028043121_KC0gU US001P 2025-10-29T12:45:28.122Z 2025-11-05T15:22:43.991Z
8282885 8282885 20251028025515_dXVVr US001P 2025-10-29T12:43:32.070Z 2025-11-05T15:21:52.683Z
8278389 8278389 20251027120446_xVr0L US001P 2025-10-29T12:33:30.295Z 2025-11-04T15:48:31.868Z
8274945 8274945 20251027054501_34f7q US001P 2025-10-29T12:26:45.731Z 2025-11-04T15:45:52.395Z
8273962 8273962 20251027045225_ATaGM US001P 2025-10-29T12:25:06.695Z 2025-11-04T15:45:05.947Z
8266876 8266876 20251026103350_0rqvo US001P 2025-10-28T12:40:24.351Z 2025-11-03T15:17:11.083Z
8262012 8262012 20251026040947_1UKNZ US001P 2025-10-28T12:35:06.377Z 2025-11-03T15:16:45.384Z
8244106 8244106 20251025072849_DpHFR US001P 2025-10-27T12:37:38.231Z 2025-11-02T15:05:42.508Z
8243619 8243619 20251025064135_lGiqJ US001P 2025-10-27T12:36:51.037Z 2025-11-02T15:05:40.943Z
8243598 8243598 20251025063951_yzwfr US001P 2025-10-27T12:36:49.427Z 2025-11-02T15:05:40.789Z
8243396 8243396 20251025061253_2AkYO US001P 2025-10-27T12:36:23.445Z 2025-11-02T15:05:40.331Z
8243141 8243141 20251025053254_i3bH5 US001P 2025-10-27T12:36:04.351Z 2025-11-02T15:05:39.487Z
8243139 8243139 20251025053252_RjHzG US001P 2025-10-27T12:36:04.139Z 2025-11-02T15:05:39.462Z
8242616 8242616 20251025044318_SQQ5J US001P 2025-10-27T12:35:20.806Z 2025-11-02T15:05:38.270Z
8242607 8242607 20251025044227_bTrRU US001P 2025-10-27T12:35:20.237Z 2025-11-02T15:05:38.263Z
8242583 8242583 20251025044053_hR0wl US001P 2025-10-27T12:35:19.416Z 2025-11-02T15:05:38.251Z
8241510 8241510 20251025024838_pR9D3 US001P 2025-10-27T12:33:25.242Z 2025-11-02T15:05:33.582Z
8222804 8222804 20251024050102_4wCcu US001P 2025-10-26T12:39:57.630Z 2025-11-01T13:11:15.047Z
8204403 8204403 20251023104129_q6fEn US001P 2025-10-25T12:27:20.773Z 2025-10-31T13:09:06.707Z
8203823 8203823 20251023094538_raIRn US001P 2025-10-25T12:25:43.379Z 2025-10-31T13:09:02.942Z
8203797 8203797 20251023094411_2ziCE US001P 2025-10-25T12:25:40.289Z 2025-10-31T13:09:02.821Z
8203432 8203432 20251023090413_Rml1r US001P 2025-10-25T12:24:32.530Z 2025-10-25T12:24:32.530Z

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