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

1,372 rows where station_code = "US004A" 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
9622705 9622705 20260407020429_6r5OM US004A 2026-04-08T12:21:38.949Z 2026-04-09T12:34:41.550Z
9617146 9617146 20260407111313_R0nle US004A 2026-04-08T12:02:09.443Z 2026-04-09T12:28:33.555Z
9616908 9616908 20260407073211_gQ5YP US004A 2026-04-08T12:00:57.343Z 2026-04-09T12:28:33.464Z
9612389 9612389 20260406104311_c6H09 US004A 2026-04-07T12:01:39.451Z 2026-04-09T12:29:52.621Z
9593431 9593431 20260329103835_W2eQD US004A 2026-03-30T12:03:56.478Z 2026-04-07T12:27:09.925Z
9593090 9593090 20260329054644_Bb2GT US004A 2026-03-30T12:02:54.550Z 2026-04-07T12:27:01.392Z
9556331 9556331 20260322100509_b7HEC US004A 2026-03-23T12:04:40.103Z 2026-03-30T12:28:57.657Z
9553906 9553906 20260322022422_HSw2h US004A 2026-03-23T12:01:59.205Z 2026-03-30T12:27:54.767Z
9537248 9537248 20260320111938_kbzT9 US004A 2026-03-21T12:15:23.892Z 2026-03-28T12:35:23.855Z
9536568 9536568 20260320100428_9zqM3 US004A 2026-03-21T12:13:45.618Z 2026-03-28T12:35:03.777Z
9536472 9536472 20260320095449_dYxs7 US004A 2026-03-21T12:13:34.594Z 2026-03-28T12:35:02.444Z
9535674 9535674 20260320081501_FsjKp US004A 2026-03-21T12:11:31.165Z 2026-03-28T12:34:48.697Z
9535625 9535625 20260320081041_u2Uvj US004A 2026-03-21T12:11:22.534Z 2026-03-28T12:34:47.823Z
9523217 9523217 20260319093816_lz3RF US004A 2026-03-20T12:11:05.749Z 2026-03-27T12:41:26.730Z
9522878 9522878 20260319090335_OKsfa US004A 2026-03-20T12:10:28.747Z 2026-03-27T12:41:22.453Z
9522171 9522171 20260319063438_nkZ2U US004A 2026-03-20T12:09:13.314Z 2026-03-27T12:41:14.645Z
9514129 9514129 20260318104909_sqiDI US004A 2026-03-19T12:16:50.961Z 2026-03-26T12:38:14.138Z
9513444 9513444 20260318091551_dvn3v US004A 2026-03-19T12:15:20.465Z 2026-03-26T12:37:55.363Z
9513081 9513081 20260318083206_VFgmC US004A 2026-03-19T12:14:21.108Z 2026-03-26T12:37:51.467Z
9513009 9513009 20260318081902_vOtW8 US004A 2026-03-19T12:14:08.289Z 2026-03-26T12:37:50.843Z
9504201 9504201 20260317105544_2GzN6 US004A 2026-03-18T12:07:26.091Z 2026-03-25T12:42:20.222Z
9503196 9503196 20260317081448_bsl6d US004A 2026-03-18T12:05:06.359Z 2026-03-25T12:42:14.559Z
9477723 9477723 20260314061014_wNBl7 US004A 2026-03-15T12:08:55.154Z 2026-03-22T12:42:04.699Z
9477324 9477324 20260314044206_t80pi US004A 2026-03-15T12:08:04.344Z 2026-03-22T12:42:02.226Z
9470977 9470977 20260313083236_NFTgs US004A 2026-03-14T12:09:03.117Z 2026-03-21T12:49:15.984Z
9465813 9465813 20260312105909_7jauv US004A 2026-03-13T12:10:46.000Z 2026-03-20T12:37:05.992Z
9465465 9465465 20260312100259_0pNQ4 US004A 2026-03-13T12:09:59.404Z 2026-03-20T12:37:04.494Z
9464931 9464931 20260312081525_gRFQx US004A 2026-03-13T12:08:39.633Z 2026-03-20T12:36:58.309Z
9464617 9464617 20260312064007_Cd501 US004A 2026-03-13T12:07:51.615Z 2026-03-20T12:36:48.987Z
9464533 9464533 20260312055544_2BTlI US004A 2026-03-13T12:07:35.790Z 2026-03-20T12:36:45.360Z
9411710 9411710 20260227093710_p7GzO US004A 2026-03-01T14:06:37.036Z 2026-03-07T14:47:50.431Z
9409782 9409782 20260228050250_DGL67 US004A 2026-03-01T14:02:13.365Z 2026-03-08T12:41:30.982Z
9409362 9409362 20260228025333_6qXgG US004A 2026-03-01T14:01:17.534Z 2026-03-08T12:41:08.066Z
9404304 9404304 20260227115624_yUgKV US004A 2026-02-28T14:10:30.684Z 2026-03-07T14:48:44.002Z
9403235 9403235 20260227084123_lSkaH US004A 2026-02-28T14:07:37.441Z 2026-03-07T14:47:42.069Z
9399976 9399976 20260226113059_g4YeL US004A 2026-02-27T14:09:11.756Z 2026-03-06T14:44:40.016Z
9399905 9399905 20260226110556_2939H US004A 2026-02-27T14:09:02.312Z 2026-03-06T14:44:38.348Z
9399772 9399772 20260226102421_zXIyj US004A 2026-02-27T14:08:38.794Z 2026-03-06T14:44:34.570Z
9384634 9384634 20260224120133_crXdS US004A 2026-02-25T14:06:26.322Z 2026-03-04T14:18:12.655Z
9384251 9384251 20260224104640_aIx7j US004A 2026-02-25T14:05:08.569Z 2026-03-04T14:18:04.216Z
9383908 9383908 20260224092513_jzI8c US004A 2026-02-25T14:03:46.049Z 2026-03-04T14:17:57.478Z
9383734 9383734 20260224082038_vKdO3 US004A 2026-02-25T14:02:58.302Z 2026-03-04T14:17:53.921Z
9374813 9374813 20260223095132_h7IRC US004A 2026-02-24T14:07:07.293Z 2026-03-03T14:31:36.430Z
9374533 9374533 20260223084732_B3xKW US004A 2026-02-24T14:06:17.071Z 2026-03-03T14:31:31.691Z
9374487 9374487 20260223083601_yD3s6 US004A 2026-02-24T14:06:08.733Z 2026-03-03T14:31:30.979Z
9373940 9373940 20260223045615_nWuu8 US004A 2026-02-24T14:04:22.440Z 2026-03-03T14:31:11.841Z
9367325 9367325 20260222115700_Azldo US004A 2026-02-23T14:10:11.623Z 2026-02-24T14:17:19.195Z
9367189 9367189 20260222113830_MU1s4 US004A 2026-02-23T14:09:42.470Z 2026-02-24T14:17:02.535Z
9367016 9367016 20260222111244_Meojs US004A 2026-02-23T14:09:10.026Z 2026-02-24T14:16:53.819Z
9366761 9366761 20260222102845_MdjRh US004A 2026-02-23T14:08:30.611Z 2026-02-24T14:16:36.650Z
9366609 9366609 20260222100802_aB5Up US004A 2026-02-23T14:08:06.135Z 2026-02-24T14:16:28.888Z
9366048 9366048 20260222082622_1nbXM US004A 2026-02-23T14:06:11.180Z 2026-02-24T14:15:57.627Z
9365962 9365962 20260222074343_xhu1u US004A 2026-02-23T14:05:46.981Z 2026-02-24T14:15:49.415Z
9365890 9365890 20260222070436_X23yq US004A 2026-02-23T14:05:27.671Z 2026-02-24T14:15:44.559Z
9365800 9365800 20260222061714_jfuW4 US004A 2026-02-23T14:05:10.405Z 2026-02-24T14:15:39.481Z
9335494 9335494 20260217015733_tPsxm US004A 2026-02-18T14:01:16.854Z 2026-02-26T14:38:55.264Z
9331893 9331893 20260216091221_5iLjg US004A 2026-02-17T14:08:54.605Z 2026-02-25T14:42:03.490Z
9331859 9331859 20260216085037_hMr3C US004A 2026-02-17T14:08:44.370Z 2026-02-25T14:42:02.938Z
9327516 9327516 20260215062500_qpcIR US004A 2026-02-16T14:04:47.784Z 2026-02-24T14:41:56.186Z
9318005 9318005 20260212120235_fmfLs US004A 2026-02-13T14:08:39.714Z 2026-02-21T14:37:11.307Z
9317814 9317814 20260212110112_b2Mdo US004A 2026-02-13T14:07:27.950Z 2026-02-21T14:37:03.898Z
9317695 9317695 20260212103651_Wh39m US004A 2026-02-13T14:06:43.106Z 2026-02-21T14:37:02.524Z
9317033 9317033 20260212061923_FcwCw US004A 2026-02-13T14:02:18.756Z 2026-02-21T14:36:49.126Z
9317016 9317016 20260212061538_yJT8B US004A 2026-02-13T14:02:15.078Z 2026-02-21T14:36:48.870Z
9316997 9316997 20260212060835_VivVB US004A 2026-02-13T14:02:07.290Z 2026-02-21T14:36:48.440Z
9308160 9308160 20260209092502_Zy6Gq US004A 2026-02-10T14:06:12.775Z 2026-02-18T14:59:35.527Z
9307356 9307356 20260209050809_GN2lZ US004A 2026-02-10T14:01:48.228Z 2026-02-18T14:58:23.169Z
9307318 9307318 20260209045213_dKhyR US004A 2026-02-10T14:01:34.042Z 2026-02-18T14:58:20.315Z
9303590 9303590 20260208070414_hEsKM US004A 2026-02-09T14:03:56.757Z 2026-02-16T14:49:28.783Z
9299604 9299604 20260207104201_1oe58 US004A 2026-02-08T14:05:59.835Z 2026-02-16T14:56:45.334Z
9299278 9299278 20260207092001_xgYZE US004A 2026-02-08T14:04:30.148Z 2026-02-16T14:56:18.763Z
9299046 9299046 20260207074611_owgaO US004A 2026-02-08T14:03:13.601Z 2026-02-16T14:55:58.152Z
9299007 9299007 20260207070817_GMFKh US004A 2026-02-08T14:02:58.203Z 2026-02-16T14:55:54.988Z
9298848 9298848 20260207052650_MKIWJ US004A 2026-02-08T14:02:00.511Z 2026-02-16T14:55:41.997Z
9298634 9298634 20260207040444_mHUl4 US004A 2026-02-08T14:00:38.632Z 2026-02-16T14:55:23.095Z
9298447 9298447 20260206024852_iJOQO US004A 2026-02-07T14:23:25.742Z 2026-02-14T15:06:35.882Z
9296274 9296274 20260206114810_IcJdB US004A 2026-02-07T14:07:48.570Z 2026-02-15T14:57:32.182Z
9295913 9295913 20260206105237_D8Trz US004A 2026-02-07T14:06:20.392Z 2026-02-15T14:57:04.881Z
9295750 9295750 20260206102934_QUJ8p US004A 2026-02-07T14:05:36.028Z 2026-02-15T14:56:51.351Z
9295195 9295195 20260206084211_mvOHD US004A 2026-02-07T14:02:56.088Z 2026-02-15T14:56:11.783Z
9294811 9294811 20260206040906_kQHO0 US004A 2026-02-07T14:00:18.633Z 2026-02-15T14:55:38.794Z
9294809 9294809 20260206040905_aSeyD US004A 2026-02-07T14:00:17.447Z 2026-02-15T14:55:38.555Z
9292665 9292665 20260205104055_Z3j10 US004A 2026-02-06T14:06:09.809Z 2026-02-14T15:03:21.507Z
9292425 9292425 20260205094903_VGDtE US004A 2026-02-06T14:04:52.703Z 2026-02-14T15:02:55.898Z
9292385 9292385 20260205093827_NIywE US004A 2026-02-06T14:04:42.248Z 2026-02-14T15:02:52.343Z
9292021 9292021 20260205083855_Lsg6M US004A 2026-02-06T14:02:54.110Z 2026-02-14T15:02:21.762Z
9289546 9289546 20260204103242_WtAl9 US004A 2026-02-05T14:05:34.066Z 2026-02-13T14:54:13.644Z
9285464 9285464 20260201120951_IdwPG US004A 2026-02-02T14:03:09.427Z 2026-02-10T14:52:35.604Z
9285350 9285350 20260201104036_ZUhTh US004A 2026-02-02T14:02:27.700Z 2026-02-10T14:52:27.529Z
9282761 9282761 20260131115429_CagDr US004A 2026-02-01T14:05:08.929Z 2026-02-09T14:50:32.779Z
9282601 9282601 20260131112602_j04Rg US004A 2026-02-01T14:04:26.393Z 2026-02-09T14:50:19.796Z
9282214 9282214 20260131095700_WHpGN US004A 2026-02-01T14:02:42.791Z 2026-02-09T14:49:48.968Z
9282114 9282114 20260131092917_Xjsem US004A 2026-02-01T14:02:12.690Z 2026-02-09T14:49:36.988Z
9281960 9281960 20260131080828_rWc9W US004A 2026-02-01T14:01:20.053Z 2026-02-09T14:49:20.659Z
9276945 9276945 20260128082722_3vRiJ US004A 2026-01-30T14:14:22.893Z 2026-02-06T14:42:50.846Z
9274465 9274465 20260129115435_6sSMh US004A 2026-01-30T14:04:23.380Z 2026-02-07T14:50:06.809Z
9273597 9273597 20260127042946_qhka4 US004A 2026-01-29T14:35:32.689Z 2026-02-04T14:49:48.200Z
9273550 9273550 20260127093233_PiuT5 US004A 2026-01-29T14:30:17.109Z 2026-02-05T14:44:38.105Z
9267551 9267551 20260127030254_60GIc US004A 2026-01-28T14:22:12.377Z 2026-02-04T14:49:27.668Z
9263919 9263919 20260127104220_gU99d US004A 2026-01-28T14:03:31.759Z 2026-02-05T14:45:01.994Z

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