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

8,192 rows where station_code = "US0038" 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
8686971 8686971 20251203231527_6B2xN US0038 2025-12-05T14:13:17.711Z 2025-12-05T14:14:35.535Z
8686969 8686969 20251203230248_2z3Tv US0038 2025-12-05T14:13:17.331Z 2025-12-05T14:14:35.534Z
8677635 8677635 20251203111528_cn0IG US0038 2025-12-04T14:02:06.345Z 2025-12-05T14:14:34.904Z
8677605 8677605 20251203110028_jXqEd US0038 2025-12-04T14:01:56.801Z 2025-12-05T14:14:34.895Z
8677514 8677514 20251203103015_nor0e US0038 2025-12-04T14:01:30.383Z 2025-12-05T14:14:34.865Z
8670512 8670512 20251201091256_7Wjzj US0038 2025-12-03T14:09:03.914Z 2025-12-05T14:23:27.550Z
8670466 8670466 20251201090057_MHSMP US0038 2025-12-03T14:08:54.943Z 2025-12-05T14:23:25.120Z
8658690 8658690 20251201075343_kpbrh US0038 2025-12-02T14:00:17.562Z 2025-12-05T14:23:18.091Z
8648487 8648487 20251129080621_Avmgp US0038 2025-11-30T14:30:15.295Z 2025-12-05T14:53:30.439Z
8648301 8648301 20251129072212_CAAXF US0038 2025-11-30T14:30:02.394Z 2025-12-05T14:53:08.132Z
8648243 8648243 20251129071215_1i7f2 US0038 2025-11-30T14:29:59.160Z 2025-12-05T14:53:03.303Z
8647318 8647318 20251129042106_oTwPE US0038 2025-11-30T14:27:59.412Z 2025-12-05T14:52:37.493Z
8647300 8647300 20251129041743_qod3S US0038 2025-11-30T14:27:57.470Z 2025-12-05T14:52:37.145Z
8647114 8647114 20251129034456_1EPJL US0038 2025-11-30T14:27:42.206Z 2025-12-05T14:52:33.414Z
8646830 8646830 20251129030011_UcSNc US0038 2025-11-30T14:27:00.900Z 2025-12-05T14:51:55.099Z
8646718 8646718 20251129024157_z26KY US0038 2025-11-30T14:26:42.381Z 2025-12-05T14:51:52.379Z
8646673 8646673 20251129023816_bFE95 US0038 2025-11-30T14:26:39.059Z 2025-12-05T14:51:47.220Z
8646490 8646490 20251129021117_BuDe5 US0038 2025-11-30T14:26:04.280Z 2025-12-05T14:51:43.184Z
8646304 8646304 20251129014319_slLF7 US0038 2025-11-30T14:25:48.932Z 2025-12-05T14:51:38.969Z
8646107 8646107 20251129010631_79A3D US0038 2025-11-30T14:25:12.603Z 2025-12-05T14:51:33.243Z
8639510 8639510 20251129111409_mJSHU US0038 2025-11-30T14:05:10.813Z 2025-12-05T14:38:23.882Z
8639249 8639249 20251129104925_lz7ne US0038 2025-11-30T14:04:15.510Z 2025-12-05T14:38:04.859Z
8639174 8639174 20251129103702_XbhWM US0038 2025-11-30T14:04:03.075Z 2025-12-05T14:37:58.076Z
8639091 8639091 20251129102636_CcCiO US0038 2025-11-30T14:03:40.945Z 2025-12-05T14:37:54.908Z
8639055 8639055 20251129102059_tNaFt US0038 2025-11-30T14:03:36.422Z 2025-12-05T14:37:52.355Z
8638757 8638757 20251129093715_kp6G3 US0038 2025-11-30T14:02:07.949Z 2025-12-05T14:37:42.020Z
8638632 8638632 20251129091634_1t7UR US0038 2025-11-30T14:01:45.407Z 2025-12-05T14:37:38.003Z
8638530 8638530 20251129090323_7Y32D US0038 2025-11-30T14:01:19.984Z 2025-12-05T14:37:34.278Z
8638504 8638504 20251129085842_oQjzb US0038 2025-11-30T14:01:14.333Z 2025-12-05T14:37:33.111Z
8638254 8638254 20251129081132_yE2rm US0038 2025-11-30T14:00:13.320Z 2025-12-05T14:37:07.359Z
8638105 8638105 20251128082705_873xZ US0038 2025-11-29T14:28:30.290Z 2025-12-05T15:00:46.190Z
8638045 8638045 20251128081217_WlxUn US0038 2025-11-29T14:28:26.292Z 2025-12-05T15:00:45.130Z
8638039 8638039 20251128081159_Tluft US0038 2025-11-29T14:28:26.089Z 2025-12-05T15:00:44.968Z
8638032 8638032 20251128080856_dQWzB US0038 2025-11-29T14:28:25.687Z 2025-12-05T15:00:44.513Z
8637965 8637965 20251128074049_TcaLL US0038 2025-11-29T14:28:20.896Z 2025-12-05T15:00:38.596Z
8637182 8637182 20251128051208_QiN2I US0038 2025-11-29T14:26:56.820Z 2025-12-05T14:59:38.391Z
8626881 8626881 20251128095259_2aJ23 US0038 2025-11-29T14:01:50.630Z 2025-12-05T14:46:23.136Z
8626876 8626876 20251128095202_iGkqs US0038 2025-11-29T14:01:49.880Z 2025-12-05T14:46:22.945Z
8626767 8626767 20251128093311_gqtpQ US0038 2025-11-29T14:01:28.110Z 2025-12-05T14:46:18.541Z
8626655 8626655 20251128091533_V9n9L US0038 2025-11-29T14:01:07.083Z 2025-12-05T14:46:15.534Z
8626612 8626612 20251128091204_BZtQV US0038 2025-11-29T14:01:02.576Z 2025-12-05T14:46:14.895Z
8626507 8626507 20251128085109_5jvjg US0038 2025-11-29T14:00:35.062Z 2025-12-05T14:46:11.940Z
8626425 8626425 20251128083530_5Of2g US0038 2025-11-29T14:00:17.433Z 2025-12-05T14:46:10.496Z
8626384 8626384 20251128082844_LsBeH US0038 2025-11-29T14:00:11.087Z 2025-12-05T14:46:09.619Z
8624378 8624378 20251127043234_ao14F US0038 2025-11-28T14:24:34.312Z 2025-12-05T15:05:01.218Z
8624334 8624334 20251127041800_QUTzz US0038 2025-11-28T14:24:29.099Z 2025-12-05T15:04:59.472Z
8624290 8624290 20251127040242_B2re6 US0038 2025-11-28T14:24:25.078Z 2025-12-05T15:04:57.971Z
8624227 8624227 20251127034509_mSe0y US0038 2025-11-28T14:24:19.027Z 2025-12-05T15:04:55.595Z
8624219 8624219 20251127034416_EhE3f US0038 2025-11-28T14:24:06.084Z 2025-12-05T15:04:55.252Z
8624176 8624176 20251127032638_yD1m7 US0038 2025-11-28T14:23:56.519Z 2025-12-05T15:04:51.710Z
8624141 8624141 20251127031852_ZqfEF US0038 2025-11-28T14:23:52.042Z 2025-12-05T15:04:48.170Z
8624125 8624125 20251127031417_6H8A7 US0038 2025-11-28T14:23:50.067Z 2025-12-05T15:04:46.265Z
8623802 8623802 20251127020516_b0Kga US0038 2025-11-28T14:22:54.942Z 2025-12-05T15:04:17.825Z
8623786 8623786 20251127020330_rMDfy US0038 2025-11-28T14:22:52.848Z 2025-12-05T15:04:16.843Z
8623575 8623575 20251127011159_0ZCWJ US0038 2025-11-28T14:22:12.358Z 2025-12-05T15:04:03.689Z
8623508 8623508 20251127005610_D7rza US0038 2025-11-28T14:22:04.255Z 2025-12-05T15:03:58.153Z
8623145 8623145 20251126230437_In4GU US0038 2025-11-28T14:20:57.651Z 2025-12-05T15:03:32.775Z
8592812 8592812 20251124092837_Ekkmi US0038 2025-11-25T14:28:02.791Z 2025-11-25T14:28:12.982Z
8592752 8592752 20251124091909_3Ywlr US0038 2025-11-25T14:27:37.812Z 2025-12-02T15:13:07.099Z
8592708 8592708 20251124090516_VrHjK US0038 2025-11-25T14:27:30.351Z 2025-12-02T15:13:06.660Z
8592703 8592703 20251124090211_RXU40 US0038 2025-11-25T14:27:29.935Z 2025-12-02T15:13:06.543Z
8592660 8592660 20251124085348_Anhpl US0038 2025-11-25T14:27:25.133Z 2025-12-02T15:13:06.130Z
8592658 8592658 20251124085318_emfS2 US0038 2025-11-25T14:27:24.842Z 2025-12-02T15:13:06.099Z
8592567 8592567 20251124083015_Qx4B7 US0038 2025-11-25T14:27:14.711Z 2025-12-02T15:13:05.340Z
8592513 8592513 20251124080936_kjeFN US0038 2025-11-25T14:26:53.737Z 2025-12-02T15:13:04.696Z
8592501 8592501 20251124080642_t4jpj US0038 2025-11-25T14:26:52.911Z 2025-12-02T15:13:04.674Z
8592499 8592499 20251124080544_eC6eE US0038 2025-11-25T14:26:52.558Z 2025-12-02T15:13:04.631Z
8592495 8592495 20251124080426_nPgSJ US0038 2025-11-25T14:26:50.545Z 2025-12-02T15:13:04.603Z
8592486 8592486 20251124075939_pIq9w US0038 2025-11-25T14:26:49.261Z 2025-12-02T15:13:04.574Z
8592475 8592475 20251124074923_pjwN1 US0038 2025-11-25T14:26:47.714Z 2025-12-02T15:13:04.436Z
8592429 8592429 20251124073407_mlhEO US0038 2025-11-25T14:26:42.965Z 2025-12-02T15:13:04.066Z
8592423 8592423 20251124073313_H2GW5 US0038 2025-11-25T14:26:42.409Z 2025-12-02T15:13:04.042Z
8592398 8592398 20251124071837_fjLw2 US0038 2025-11-25T14:26:40.166Z 2025-12-02T15:13:03.808Z
8592365 8592365 20251124070526_ESyJN US0038 2025-11-25T14:26:35.924Z 2025-12-02T15:13:03.591Z
8592350 8592350 20251124065607_7lLoM US0038 2025-11-25T14:26:34.413Z 2025-12-02T15:13:03.433Z
8592168 8592168 20251124055610_zDk1d US0038 2025-11-25T14:25:58.640Z 2025-12-02T15:13:02.167Z
8592156 8592156 20251124055516_94z0a US0038 2025-11-25T14:25:57.871Z 2025-12-02T15:13:02.115Z
8592119 8592119 20251124055114_jht1i US0038 2025-11-25T14:25:54.381Z 2025-12-02T15:13:01.946Z
8592094 8592094 20251124054716_N9lfB US0038 2025-11-25T14:25:52.091Z 2025-12-02T15:13:01.877Z
8592052 8592052 20251124053941_JiuHB US0038 2025-11-25T14:25:48.184Z 2025-12-02T15:13:01.591Z
8591987 8591987 20251124052946_3yma9 US0038 2025-11-25T14:25:29.260Z 2025-12-02T15:13:01.350Z
8591887 8591887 20251124051256_rXJ3c US0038 2025-11-25T14:25:17.725Z 2025-12-02T15:13:00.859Z
8591615 8591615 20251124043550_QmP04 US0038 2025-11-25T14:24:38.026Z 2025-12-02T15:12:59.671Z
8591528 8591528 20251124042252_N5Rku US0038 2025-11-25T14:24:30.551Z 2025-12-02T15:12:59.273Z
8591268 8591268 20251124035922_v4zhW US0038 2025-11-25T14:23:49.513Z 2025-12-02T15:12:57.725Z
8590602 8590602 20251124025535_6sLsY US0038 2025-11-25T14:22:16.727Z 2025-12-02T15:12:52.740Z
8590228 8590228 20251124023016_lpNRk US0038 2025-11-25T14:21:34.314Z 2025-12-02T15:12:43.915Z
8589360 8589360 20251124012849_zNvJY US0038 2025-11-25T14:19:44.825Z 2025-12-02T15:12:22.766Z
8589308 8589308 20251124012337_OBp5f US0038 2025-11-25T14:19:37.699Z 2025-12-02T15:12:18.663Z
8589054 8589054 20251124005718_Ijz9E US0038 2025-11-25T14:18:56.403Z 2025-12-02T15:12:04.387Z
8588886 8588886 20251124004118_vcMTD US0038 2025-11-25T14:18:39.899Z 2025-12-02T15:11:58.490Z
8588648 8588648 20251124001851_viD3u US0038 2025-11-25T14:18:05.404Z 2025-12-02T15:11:49.856Z
8588252 8588252 20251123233506_53iE3 US0038 2025-11-25T14:17:08.719Z 2025-12-02T15:11:38.763Z
8588034 8588034 20251123231534_Eeg25 US0038 2025-11-25T14:16:37.159Z 2025-12-02T15:11:24.364Z
8588031 8588031 20251123231507_oMihI US0038 2025-11-25T14:16:36.845Z 2025-12-02T15:11:24.201Z
8587836 8587836 20251123225044_9V23y US0038 2025-11-25T14:16:09.542Z 2025-12-02T15:11:20.313Z
8584021 8584021 20251123103638_2wgmi US0038 2025-11-25T14:05:04.359Z 2025-12-02T15:09:45.356Z
8583983 8583983 20251123102940_EfwSb US0038 2025-11-25T14:04:48.998Z 2025-12-02T15:09:44.868Z
8583967 8583967 20251123102757_PDxrD US0038 2025-11-25T14:04:44.391Z 2025-12-02T15:09:44.708Z
8583940 8583940 20251123101927_cUxEd US0038 2025-11-25T14:04:39.575Z 2025-12-02T15:09:44.486Z

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