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

4,557 rows where station_code = "US0023" 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
9242821 9242821 20260121025125_FfOaL US0023 2026-01-22T14:19:27.824Z 2026-01-29T15:04:22.966Z
9239798 9239798 20260121123538_dKQ5M US0023 2026-01-22T14:03:11.837Z 2026-01-29T14:54:42.917Z
9239773 9239773 20260121122029_0g7jA US0023 2026-01-22T14:03:05.185Z 2026-01-29T14:54:40.976Z
9239634 9239634 20260121112609_ONFlu US0023 2026-01-22T14:02:20.521Z 2026-01-29T14:54:33.003Z
9239596 9239596 20260121111454_dnUBI US0023 2026-01-22T14:02:07.792Z 2026-01-29T14:54:31.310Z
9239173 9239173 20260121095539_6Mip9 US0023 2026-01-22T14:00:15.608Z 2026-01-29T14:53:52.575Z
9238405 9238405 20260120083515_GQ4GW US0023 2026-01-21T14:29:30.824Z 2026-01-28T15:02:32.408Z
9238270 9238270 20260120081253_JKPNT US0023 2026-01-21T14:29:04.510Z 2026-01-28T15:02:17.319Z
9238228 9238228 20260120080452_Bs92W US0023 2026-01-21T14:28:58.092Z 2026-01-28T15:02:15.017Z
9238135 9238135 20260120073437_Jzb8l US0023 2026-01-21T14:28:46.594Z 2026-01-28T15:02:09.451Z
9238087 9238087 20260120071736_hd4nJ US0023 2026-01-21T14:28:29.693Z 2026-01-28T15:02:06.811Z
9236665 9236665 20260120034455_r6i2S US0023 2026-01-21T14:23:38.795Z 2026-01-28T15:00:28.322Z
9236038 9236038 20260120023002_bFRnc US0023 2026-01-21T14:21:18.502Z 2026-01-28T14:59:42.227Z
9235786 9235786 20260120015915_WZRta US0023 2026-01-21T14:20:14.942Z 2026-01-28T14:59:20.887Z
9233174 9233174 20260120133243_4ahdM US0023 2026-01-21T14:04:48.028Z 2026-01-29T15:00:48.401Z
9232691 9232691 20260120121113_D3To1 US0023 2026-01-21T14:02:53.942Z 2026-01-29T14:59:57.557Z
9232292 9232292 20260120105919_xualT US0023 2026-01-21T14:01:09.637Z 2026-01-29T14:59:23.987Z
9231736 9231736 20260119094332_vXCPT US0023 2026-01-20T14:34:08.441Z 2026-01-27T15:06:57.617Z
9225418 9225418 20260118094213_3w2HN US0023 2026-01-19T14:28:54.971Z 2026-01-26T15:04:33.809Z
9225230 9225230 20260118084536_9QyOX US0023 2026-01-19T14:28:05.995Z 2026-01-26T15:04:09.101Z
9225122 9225122 20260118080055_W89q6 US0023 2026-01-19T14:27:44.976Z 2026-01-26T15:04:05.472Z
9225069 9225069 20260118072736_8kEkX US0023 2026-01-19T14:27:25.947Z 2026-01-26T15:04:00.710Z
9225058 9225058 20260118072358_ufcb4 US0023 2026-01-19T14:27:23.951Z 2026-01-26T15:04:00.231Z
9224796 9224796 20260118060504_pdM37 US0023 2026-01-19T14:26:04.721Z 2026-01-26T15:03:49.361Z
9224777 9224777 20260118060226_A7n8I US0023 2026-01-19T14:26:00.186Z 2026-01-26T15:03:48.864Z
9220559 9220559 20260118130932_0oHZD US0023 2026-01-19T14:04:47.560Z 2026-01-27T14:59:20.730Z
9220496 9220496 20260118130005_VYX3Q US0023 2026-01-19T14:04:26.981Z 2026-01-27T14:59:17.583Z
9220118 9220118 20260118120811_UBlLM US0023 2026-01-19T14:02:49.135Z 2026-01-27T14:58:50.589Z
9219780 9219780 20260118111744_IJvvT US0023 2026-01-19T14:00:45.271Z 2026-01-27T14:58:30.829Z
9219774 9219774 20260118111636_qFZGO US0023 2026-01-19T14:00:43.062Z 2026-01-27T14:58:30.472Z
9219762 9219762 20260118111517_FVJAK US0023 2026-01-19T14:00:37.306Z 2026-01-27T14:58:29.746Z
9219453 9219453 20260117103440_phwhr US0023 2026-01-18T14:16:29.722Z 2026-01-25T14:59:28.041Z
9219451 9219451 20260117103439_tBREg US0023 2026-01-18T14:16:29.220Z 2026-01-25T14:59:27.989Z
9219370 9219370 20260117101108_LDLyn US0023 2026-01-18T14:16:10.535Z 2026-01-25T14:59:11.990Z
9218892 9218892 20260117062157_g2pw3 US0023 2026-01-18T14:14:06.446Z 2026-01-25T14:58:54.750Z
9218604 9218604 20260117045603_v2vm3 US0023 2026-01-18T14:12:52.450Z 2026-01-25T14:58:31.886Z
9215826 9215826 20260116110826_TM0SC US0023 2026-01-17T14:27:01.006Z 2026-01-24T15:15:14.468Z
9215678 9215678 20260116104527_iknKd US0023 2026-01-17T14:26:33.782Z 2026-01-24T15:15:09.113Z
9215636 9215636 20260116103857_PlOoP US0023 2026-01-17T14:26:25.840Z 2026-01-24T15:15:06.301Z
9215464 9215464 20260116101808_L0IlH US0023 2026-01-17T14:25:41.019Z 2026-01-24T15:14:58.828Z
9215304 9215304 20260116095322_cCBPU US0023 2026-01-17T14:25:08.002Z 2026-01-24T15:14:40.623Z
9214936 9214936 20260116084829_84Uxv US0023 2026-01-17T14:23:53.298Z 2026-01-24T15:14:23.782Z
9214543 9214543 20260116065158_Z7ziw US0023 2026-01-17T14:22:02.110Z 2026-01-24T15:13:50.877Z
9214474 9214474 20260116064239_kFBgD US0023 2026-01-17T14:21:39.946Z 2026-01-24T15:13:39.221Z
9213452 9213452 20260116033952_sW5o9 US0023 2026-01-17T14:16:59.837Z 2026-01-24T15:12:15.097Z
9209953 9209953 20260115113525_4xyC5 US0023 2026-01-16T14:18:09.782Z 2026-01-22T15:05:41.062Z
9209926 9209926 20260115112440_yEuyg US0023 2026-01-16T14:18:03.370Z 2026-01-22T15:05:40.002Z
9208959 9208959 20260115074840_2PwfW US0023 2026-01-16T14:14:36.898Z 2026-01-22T15:04:44.972Z
9208924 9208924 20260115073148_Ki2dG US0023 2026-01-16T14:14:28.677Z 2026-01-22T15:04:43.692Z
9208772 9208772 20260115064458_sa4v4 US0023 2026-01-16T14:13:54.738Z 2026-01-22T15:04:39.395Z
9208471 9208471 20260115053529_czREW US0023 2026-01-16T14:12:49.069Z 2026-01-22T15:04:20.037Z
9208350 9208350 20260115051101_RFDzo US0023 2026-01-16T14:12:16.486Z 2026-01-22T15:04:10.916Z
9208224 9208224 20260115043927_kQYY6 US0023 2026-01-16T14:11:46.605Z 2026-01-22T15:04:04.825Z
9208134 9208134 20260115041854_Vp143 US0023 2026-01-16T14:11:25.535Z 2026-01-22T15:04:02.067Z
9207901 9207901 20260115033029_C2wuU US0023 2026-01-16T14:10:34.815Z 2026-01-22T15:03:56.071Z
9205869 9205869 20260115123516_asBbQ US0023 2026-01-16T14:00:30.699Z 2026-01-24T15:08:34.805Z
9205543 9205543 20260114123413_vTEPt US0023 2026-01-15T14:31:22.779Z 2026-01-22T15:11:17.197Z
9205485 9205485 20260114121836_5EWBj US0023 2026-01-15T14:31:06.786Z 2026-01-22T15:11:15.885Z
9205456 9205456 20260114120938_YITy2 US0023 2026-01-15T14:31:02.396Z 2026-01-22T15:11:15.289Z
9205445 9205445 20260114120717_zmqrH US0023 2026-01-15T14:30:53.670Z 2026-01-22T15:11:14.997Z
9205426 9205426 20260114120534_5YEfk US0023 2026-01-15T14:30:51.780Z 2026-01-22T15:11:14.734Z
9205338 9205338 20260114113851_lLC2Z US0023 2026-01-15T14:30:36.248Z 2026-01-22T15:11:13.113Z
9205239 9205239 20260114110835_3Uri0 US0023 2026-01-15T14:30:10.643Z 2026-01-22T15:11:11.132Z
9205209 9205209 20260114105707_NpF2g US0023 2026-01-15T14:30:06.232Z 2026-01-22T15:11:10.510Z
9205136 9205136 20260114104455_R9qKl US0023 2026-01-15T14:29:57.566Z 2026-01-22T15:11:09.462Z
9205110 9205110 20260114103620_euLFg US0023 2026-01-15T14:29:53.387Z 2026-01-22T15:11:08.975Z
9205016 9205016 20260114100515_7DC8V US0023 2026-01-15T14:29:30.628Z 2026-01-22T15:11:07.173Z
9204923 9204923 20260114094154_71OxP US0023 2026-01-15T14:29:12.395Z 2026-01-22T15:11:05.820Z
9204824 9204824 20260114091003_yufBw US0023 2026-01-15T14:28:46.634Z 2026-01-22T15:11:03.765Z
9204696 9204696 20260114081818_XZuFg US0023 2026-01-15T14:28:10.621Z 2026-01-22T15:11:01.346Z
9203602 9203602 20260114052135_M1vr6 US0023 2026-01-15T14:25:00.009Z 2026-01-22T15:10:10.733Z
9201713 9201713 20260114024254_KPUez US0023 2026-01-15T14:19:24.464Z 2026-01-22T15:09:07.952Z
9197785 9197785 20260113123411_epSE6 US0023 2026-01-14T14:24:23.682Z 2026-01-21T15:06:24.502Z
9197182 9197182 20260113102453_dNJWr US0023 2026-01-14T14:21:48.217Z 2026-01-21T15:06:14.949Z
9196900 9196900 20260113093314_OkH3u US0023 2026-01-14T14:20:36.377Z 2026-01-21T15:06:04.064Z
9196309 9196309 20260113060446_EAiFi US0023 2026-01-14T14:17:42.993Z 2026-01-21T15:05:31.079Z
9191305 9191305 20260112105728_DQudN US0023 2026-01-13T14:25:02.116Z 2026-01-20T15:25:18.799Z
9191044 9191044 20260112102846_txBu7 US0023 2026-01-13T14:24:14.848Z 2026-01-20T15:25:07.955Z
9190599 9190599 20260112092625_LsCwn US0023 2026-01-13T14:22:50.165Z 2026-01-20T15:24:40.178Z
9190377 9190377 20260112085702_R23nX US0023 2026-01-13T14:22:01.963Z 2026-01-20T15:24:20.492Z
9190038 9190038 20260112073750_hsvT2 US0023 2026-01-13T14:20:29.273Z 2026-01-20T15:24:04.150Z
9189766 9189766 20260112062102_iq4iQ US0023 2026-01-13T14:19:16.250Z 2026-01-20T15:23:39.275Z
9185186 9185186 20260111132039_nvC6N US0023 2026-01-12T14:22:40.093Z 2026-01-19T15:21:55.505Z
9185049 9185049 20260111130043_y683O US0023 2026-01-12T14:22:18.134Z 2026-01-19T15:21:46.841Z
9184484 9184484 20260111114116_kARpz US0023 2026-01-12T14:20:43.450Z 2026-01-19T15:21:00.591Z
9184230 9184230 20260111105858_cKHc3 US0023 2026-01-12T14:20:04.091Z 2026-01-19T15:20:28.376Z
9183402 9183402 20260111092627_Rnpb2 US0023 2026-01-12T14:17:43.201Z 2026-01-19T15:19:38.184Z
9183383 9183383 20260111092353_wU03u US0023 2026-01-12T14:17:37.754Z 2026-01-19T15:19:37.701Z
9182860 9182860 20260111070330_vGn2R US0023 2026-01-12T14:15:58.153Z 2026-01-19T15:19:02.347Z
9182733 9182733 20260111062257_EnRPk US0023 2026-01-12T14:15:34.735Z 2026-01-19T15:18:57.547Z
9182461 9182461 20260111052641_cMq0L US0023 2026-01-12T14:14:39.264Z 2026-01-19T15:18:33.296Z
9181895 9181895 20260111033724_mxygB US0023 2026-01-12T14:12:31.660Z 2026-01-19T15:17:52.987Z
8994481 8994481 20251217065206_M2rMU US0023 2025-12-26T14:58:41.172Z 2025-12-26T14:58:41.172Z
8989895 8989895 20251218123347_0on2S US0023 2025-12-26T14:45:10.443Z 2025-12-27T15:23:17.166Z
8989774 8989774 20251218122223_qKyTI US0023 2025-12-26T14:44:54.126Z 2025-12-27T15:23:10.063Z
8989493 8989493 20251218115529_1MBM1 US0023 2025-12-26T14:44:20.579Z 2025-12-27T15:22:55.841Z
8988690 8988690 20251218104453_hLRtF US0023 2025-12-26T14:42:55.853Z 2025-12-27T15:22:00.200Z
8988565 8988565 20251218103021_bFIOw US0023 2025-12-26T14:42:33.437Z 2025-12-27T15:21:49.915Z
8988440 8988440 20251218102134_3CZG0 US0023 2025-12-26T14:42:24.227Z 2025-12-27T15:21:44.161Z
8987810 8987810 20251218092230_BQZJS US0023 2025-12-26T14:41:10.591Z 2025-12-27T15:21:01.609Z

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