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,370 rows where station_code = "US0037" 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
9593321 9593321 20260329091432_1oaog US0037 2026-03-30T12:03:36.533Z 2026-04-06T12:35:11.658Z
9593147 9593147 20260329065435_xVZGG US0037 2026-03-30T12:03:06.996Z 2026-04-06T12:34:53.262Z
9593138 9593138 20260329065114_VXS4q US0037 2026-03-30T12:03:04.479Z 2026-04-06T12:34:52.678Z
9593116 9593116 20260329063726_gjH1j US0037 2026-03-30T12:02:59.806Z 2026-04-06T12:34:51.324Z
9593082 9593082 20260329052621_U9MsE US0037 2026-03-30T12:02:53.082Z 2026-04-06T12:34:49.364Z
9593050 9593050 20260329044021_5FODN US0037 2026-03-30T12:02:45.334Z 2026-04-06T12:34:47.576Z
9592908 9592908 20260329035408_gDCeH US0037 2026-03-30T12:02:17.963Z 2026-04-06T12:34:40.135Z
9590484 9590484 20260328093156_4jut3 US0037 2026-03-29T12:02:45.002Z 2026-04-06T12:38:12.013Z
9590453 9590453 20260328091447_KMiKK US0037 2026-03-29T12:02:41.569Z 2026-04-06T12:38:10.376Z
9590158 9590158 20260328071657_9mMyf US0037 2026-03-29T12:02:08.089Z 2026-04-06T12:37:54.201Z
9590078 9590078 20260328045308_jtZAQ US0037 2026-03-29T12:01:57.916Z 2026-04-06T12:37:49.760Z
9589864 9589864 20260328041256_gHEGG US0037 2026-03-29T12:01:41.145Z 2026-04-06T12:37:36.604Z
9572687 9572687 20260324094859_pmAUc US0037 2026-03-25T12:05:58.616Z 2026-04-02T12:35:34.177Z
9572305 9572305 20260324083124_b9Z3c US0037 2026-03-25T12:04:37.754Z 2026-04-02T12:35:13.462Z
9572252 9572252 20260324082127_3LKHm US0037 2026-03-25T12:04:26.130Z 2026-04-02T12:35:10.997Z
9572076 9572076 20260324072340_2Kp71 US0037 2026-03-25T12:03:41.096Z 2026-04-02T12:35:01.960Z
9571852 9571852 20260324051500_34b5Z US0037 2026-03-25T12:02:59.375Z 2026-04-02T12:34:52.345Z
9561482 9561482 20260320084041_uYdaS US0037 2026-03-23T12:13:48.203Z 2026-03-28T12:34:52.989Z
9556340 9556340 20260322100751_I9xlc US0037 2026-03-23T12:04:41.202Z 2026-03-30T12:28:58.075Z
9556065 9556065 20260322091107_s4ErF US0037 2026-03-23T12:04:18.704Z 2026-03-30T12:28:43.795Z
9555954 9555954 20260322084939_i1wgd US0037 2026-03-23T12:04:11.882Z 2026-03-30T12:28:40.227Z
9555640 9555640 20260322071409_Mtp1j US0037 2026-03-23T12:03:43.862Z 2026-03-30T12:28:31.172Z
9555609 9555609 20260322070326_fUdmz US0037 2026-03-23T12:03:41.549Z 2026-03-30T12:28:30.552Z
9536357 9536357 20260320093852_VREmX US0037 2026-03-21T12:13:11.890Z 2026-03-28T12:35:00.772Z
9536343 9536343 20260320093624_pXAKL US0037 2026-03-21T12:13:10.243Z 2026-03-28T12:35:00.577Z
9536316 9536316 20260320093359_qrJiy US0037 2026-03-21T12:13:06.023Z 2026-03-28T12:34:59.713Z
9535710 9535710 20260320082423_BPIPB US0037 2026-03-21T12:11:39.624Z 2026-03-28T12:34:49.538Z
9535489 9535489 20260320074558_2spoT US0037 2026-03-21T12:10:57.578Z 2026-03-28T12:34:45.031Z
9535243 9535243 20260320063215_QcWpx US0037 2026-03-21T12:10:10.880Z 2026-03-28T12:34:30.972Z
9535183 9535183 20260320060148_PSYPY US0037 2026-03-21T12:09:58.621Z 2026-03-28T12:34:28.994Z
9535140 9535140 20260320054930_FuL4O US0037 2026-03-21T12:09:53.133Z 2026-03-28T12:34:28.280Z
9535022 9535022 20260320051331_H3dV9 US0037 2026-03-21T12:09:31.394Z 2026-03-28T12:34:25.893Z
9512821 9512821 20260318075223_keNRs US0037 2026-03-19T12:13:38.927Z 2026-03-26T12:37:49.218Z
9512349 9512349 20260318052557_WHWNe US0037 2026-03-19T12:12:15.738Z 2026-03-26T12:37:44.340Z
9508738 9508738 20260318010843_fWObN US0037 2026-03-19T12:03:43.543Z 2026-03-26T12:37:00.511Z
9503047 9503047 20260317075022_SOJ4L US0037 2026-03-18T12:04:45.804Z 2026-03-25T12:42:11.245Z
9502977 9502977 20260317073449_BtwkM US0037 2026-03-18T12:04:34.378Z 2026-03-25T12:42:08.508Z
9502784 9502784 20260317062224_ihk6h US0037 2026-03-18T12:04:03.182Z 2026-03-25T12:41:59.400Z
9478942 9478942 20260314102525_E5MYa US0037 2026-03-15T12:12:21.603Z 2026-03-22T12:42:12.523Z
9478325 9478325 20260314090643_55dJK US0037 2026-03-15T12:10:48.673Z 2026-03-22T12:42:09.649Z
9478249 9478249 20260314085448_ED6W5 US0037 2026-03-15T12:10:37.509Z 2026-03-22T12:42:09.250Z
9478021 9478021 20260314080456_5EdPE US0037 2026-03-15T12:09:59.532Z 2026-03-22T12:42:07.756Z
9477922 9477922 20260314073900_n3Vq2 US0037 2026-03-15T12:09:41.042Z 2026-03-22T12:42:06.479Z
9477855 9477855 20260314070742_sGydd US0037 2026-03-15T12:09:24.875Z 2026-03-22T12:42:05.962Z
9477836 9477836 20260314065918_kHssC US0037 2026-03-15T12:09:21.578Z 2026-03-22T12:42:05.796Z
9477800 9477800 20260314064600_wGF64 US0037 2026-03-15T12:09:11.434Z 2026-03-22T12:42:05.408Z
9477695 9477695 20260314060158_zHH33 US0037 2026-03-15T12:08:52.302Z 2026-03-22T12:42:04.631Z
9477652 9477652 20260314054905_zzd2Y US0037 2026-03-15T12:08:44.135Z 2026-03-22T12:42:04.266Z
9471413 9471413 20260313101128_10qZC US0037 2026-03-14T12:10:21.869Z 2026-03-21T12:49:21.409Z
9470899 9470899 20260313081534_2Uk1r US0037 2026-03-14T12:08:48.042Z 2026-03-21T12:49:15.256Z
9470593 9470593 20260313064243_eIXyw US0037 2026-03-14T12:07:51.189Z 2026-03-21T12:49:11.112Z
9470464 9470464 20260313055902_d0bvj US0037 2026-03-14T12:07:29.701Z 2026-03-21T12:49:09.976Z
9470275 9470275 20260313050214_2NXfC US0037 2026-03-14T12:06:51.736Z 2026-03-21T12:49:07.062Z
9469528 9469528 20260313030216_HWbxq US0037 2026-03-14T12:04:37.105Z 2026-03-21T12:48:41.171Z
9458626 9458626 20260311102148_S4IDN US0037 2026-03-12T12:06:35.050Z 2026-03-19T12:45:00.277Z
9458272 9458272 20260311091213_yaVZw US0037 2026-03-12T12:05:46.783Z 2026-03-19T12:44:57.214Z
9457134 9457134 20260311024207_pEDm6 US0037 2026-03-12T12:02:58.721Z 2026-03-19T12:44:28.918Z
9452381 9452381 20260310094900_24UOZ US0037 2026-03-11T12:05:20.138Z 2026-03-18T12:39:12.400Z
9452020 9452020 20260310061244_F8DQH US0037 2026-03-11T12:04:29.741Z 2026-03-18T12:39:08.438Z
9452006 9452006 20260310054612_fl07x US0037 2026-03-11T12:04:25.371Z 2026-03-18T12:39:08.280Z
9451807 9451807 20260310035718_F91f5 US0037 2026-03-11T12:03:53.218Z 2026-03-18T12:39:04.858Z
9451800 9451800 20260310035538_Vk4Ub US0037 2026-03-11T12:03:52.200Z 2026-03-18T12:39:04.773Z
9451728 9451728 20260310033153_FsZ0g US0037 2026-03-11T12:03:40.964Z 2026-03-18T12:39:03.492Z
9451624 9451624 20260310030902_LdZRQ US0037 2026-03-11T12:03:22.420Z 2026-03-18T12:39:01.698Z
9451437 9451437 20260310021128_3bbtU US0037 2026-03-11T12:02:47.556Z 2026-03-18T12:38:46.351Z
9451314 9451314 20260310014313_PJObj US0037 2026-03-11T12:02:25.642Z 2026-03-18T12:38:44.739Z
9448035 9448035 20260309094338_Mg2Ix US0037 2026-03-10T12:08:41.759Z 2026-03-17T12:41:59.576Z
9447821 9447821 20260309090137_XGw20 US0037 2026-03-10T12:07:57.214Z 2026-03-17T12:41:57.093Z
9447429 9447429 20260309072458_KeKr2 US0037 2026-03-10T12:06:30.134Z 2026-03-17T12:41:51.695Z
9447421 9447421 20260309072302_G91VT US0037 2026-03-10T12:06:28.801Z 2026-03-17T12:41:51.579Z
9447347 9447347 20260309064926_wDqPv US0037 2026-03-10T12:06:10.508Z 2026-03-17T12:41:50.506Z
9447257 9447257 20260309061506_U9elq US0037 2026-03-10T12:05:47.705Z 2026-03-17T12:41:49.659Z
9447170 9447170 20260309053523_BmpdK US0037 2026-03-10T12:05:25.943Z 2026-03-17T12:41:48.458Z
9447075 9447075 20260309043721_DjfNf US0037 2026-03-10T12:05:06.317Z 2026-03-17T12:41:47.347Z
9415980 9415980 20260302070322_3nmXA US0037 2026-03-03T14:02:20.456Z 2026-03-10T12:35:55.075Z
9412869 9412869 20260301071703_1rg3V US0037 2026-03-02T14:02:17.654Z 2026-03-09T12:39:54.072Z
9412858 9412858 20260301070727_UP6uy US0037 2026-03-02T14:02:16.294Z 2026-03-09T12:39:53.650Z
9412809 9412809 20260301060519_66NS1 US0037 2026-03-02T14:02:10.027Z 2026-03-09T12:39:51.591Z
9410176 9410176 20260228094224_AKQxg US0037 2026-03-01T14:03:06.076Z 2026-03-08T12:41:53.497Z
9409882 9409882 20260228062717_P8SFs US0037 2026-03-01T14:02:27.217Z 2026-03-08T12:41:36.719Z
9409875 9409875 20260228062145_LU7Gk US0037 2026-03-01T14:02:26.132Z 2026-03-08T12:41:36.427Z
9403794 9403794 20260227104517_zztbi US0037 2026-02-28T14:09:12.469Z 2026-03-07T14:48:13.818Z
9403494 9403494 20260227095741_y9CtL US0037 2026-02-28T14:08:26.868Z 2026-03-07T14:47:55.104Z
9403359 9403359 20260227092111_eZGw8 US0037 2026-02-28T14:08:01.781Z 2026-03-07T14:47:48.417Z
9403269 9403269 20260227085636_2Uubk US0037 2026-02-28T14:07:44.623Z 2026-03-07T14:47:44.307Z
9402981 9402981 20260227061048_Vq36A US0037 2026-02-28T14:06:46.296Z 2026-03-07T14:47:19.677Z
9402929 9402929 20260227052100_iqWdp US0037 2026-02-28T14:06:34.277Z 2026-03-07T14:47:16.337Z
9399368 9399368 20260226062210_XVeDG US0037 2026-02-27T14:07:38.184Z 2026-03-06T14:44:17.240Z
9390887 9390887 20260225013540_8q3g3 US0037 2026-02-26T14:02:49.769Z 2026-03-05T14:35:58.896Z
9384199 9384199 20260224102956_SIYSk US0037 2026-02-25T14:04:55.857Z 2026-03-04T14:18:02.977Z
9372261 9372261 20260221235219_k3oTT US0037 2026-02-23T14:26:26.043Z 2026-03-02T14:22:33.113Z
9360095 9360095 20260221104618_o4Myd US0037 2026-02-22T14:06:47.793Z 2026-03-02T14:21:23.387Z
9359762 9359762 20260221094829_O0n6f US0037 2026-02-22T14:05:44.650Z 2026-03-02T14:21:18.846Z
9359592 9359592 20260221092259_8t882 US0037 2026-02-22T14:05:18.122Z 2026-03-02T14:21:16.920Z
9359348 9359348 20260221083641_OipzO US0037 2026-02-22T14:04:32.036Z 2026-03-02T14:21:14.319Z
9359072 9359072 20260221071233_ZYDq9 US0037 2026-02-22T14:03:40.134Z 2026-03-02T14:21:10.818Z
9359053 9359053 20260221070307_XzAhC US0037 2026-02-22T14:03:35.134Z 2026-03-02T14:21:10.675Z
9358900 9358900 20260221054056_hT830 US0037 2026-02-22T14:02:54.211Z 2026-03-02T14:21:00.990Z
9358840 9358840 20260221051625_FNroN US0037 2026-02-22T14:02:37.025Z 2026-03-02T14:20:55.011Z
9358760 9358760 20260221043820_N6hCT US0037 2026-02-22T14:02:16.660Z 2026-03-02T14:20:53.590Z

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