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

6,613 rows where station_code = "US004C" 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
8682053 8682053 20251203044544_zk9td US004C 2025-12-04T14:16:17.536Z 2025-12-06T14:28:45.145Z
8682009 8682009 20251203043751_ZXNaO US004C 2025-12-04T14:16:09.226Z 2025-12-06T14:28:42.903Z
8681769 8681769 20251203040233_sbUTR US004C 2025-12-04T14:15:32.878Z 2025-12-06T14:28:30.249Z
8681766 8681766 20251203040133_HkjBe US004C 2025-12-04T14:15:32.223Z 2025-12-06T14:28:30.093Z
8681643 8681643 20251203033552_BHplq US004C 2025-12-04T14:15:10.948Z 2025-12-06T14:28:22.092Z
8681394 8681394 20251203030328_6LDT9 US004C 2025-12-04T14:14:37.541Z 2025-12-06T14:28:05.508Z
8681103 8681103 20251203022354_2gNQ2 US004C 2025-12-04T14:13:51.427Z 2025-12-06T14:27:49.475Z
8681009 8681009 20251203021153_a3acx US004C 2025-12-04T14:13:32.903Z 2025-12-06T14:27:46.240Z
8677652 8677652 20251203113038_HoiqK US004C 2025-12-04T14:02:12.283Z 2025-12-06T14:19:54.267Z
8677611 8677611 20251203110203_I2Tyg US004C 2025-12-04T14:01:58.151Z 2025-12-06T14:19:44.536Z
8677483 8677483 20251203102046_uc5Gw US004C 2025-12-04T14:01:23.150Z 2025-12-06T14:19:31.907Z
8669761 8669761 20251202120811_Wxufd US004C 2025-12-03T14:05:22.888Z 2025-12-06T14:24:18.988Z
8669735 8669735 20251202120639_90jc2 US004C 2025-12-03T14:05:19.275Z 2025-12-06T14:24:17.867Z
8669719 8669719 20251202120521_Q4CoD US004C 2025-12-03T14:05:16.572Z 2025-12-06T14:24:17.247Z
8669628 8669628 20251202114416_Y7BHi US004C 2025-12-03T14:04:45.165Z 2025-12-06T14:24:07.492Z
8669578 8669578 20251202113641_H76sf US004C 2025-12-03T14:04:36.703Z 2025-12-06T14:24:03.868Z
8669455 8669455 20251202111319_8Qhzd US004C 2025-12-03T14:03:59.808Z 2025-12-06T14:23:55.767Z
8669453 8669453 20251202111318_F7Smg US004C 2025-12-03T14:03:59.381Z 2025-12-06T14:23:55.621Z
8669450 8669450 20251202111312_C0IXP US004C 2025-12-03T14:03:58.885Z 2025-12-06T14:23:55.493Z
8669424 8669424 20251202111018_2cG3C US004C 2025-12-03T14:03:42.118Z 2025-12-06T14:23:53.735Z
8669409 8669409 20251202110847_VmTNC US004C 2025-12-03T14:03:39.237Z 2025-12-06T14:23:52.596Z
8669390 8669390 20251202110524_7tS46 US004C 2025-12-03T14:03:32.966Z 2025-12-06T14:23:51.641Z
8669385 8669385 20251202110442_3a0Bb US004C 2025-12-03T14:03:31.970Z 2025-12-06T14:23:51.431Z
8669198 8669198 20251202103115_u4QBL US004C 2025-12-03T14:02:50.303Z 2025-12-06T14:23:39.657Z
8669159 8669159 20251202102447_SAOHr US004C 2025-12-03T14:02:45.675Z 2025-12-06T14:23:38.439Z
8669141 8669141 20251202101851_nZ2Ql US004C 2025-12-03T14:02:42.657Z 2025-12-06T14:23:37.426Z
8669124 8669124 20251202101628_7XBFU US004C 2025-12-03T14:02:40.156Z 2025-12-06T14:23:34.772Z
8669122 8669122 20251202101606_cGxYQ US004C 2025-12-03T14:02:39.669Z 2025-12-06T14:23:34.379Z
8669098 8669098 20251202101216_aqbbr US004C 2025-12-03T14:02:24.401Z 2025-12-06T14:23:32.292Z
8669072 8669072 20251202100812_bTYNV US004C 2025-12-03T14:02:13.733Z 2025-12-06T14:23:30.373Z
8668663 8668663 20251202081312_gSQxh US004C 2025-12-03T14:00:46.022Z 2025-12-06T14:23:01.543Z
8668352 8668352 20251130073549_aIz24 US004C 2025-12-02T14:42:20.404Z 2025-12-06T14:50:30.787Z
8668315 8668315 20251130071734_XlCc1 US004C 2025-12-02T14:42:18.330Z 2025-12-06T14:50:30.237Z
8668158 8668158 20251130062300_6ew7z US004C 2025-12-02T14:42:06.343Z 2025-12-06T14:50:24.810Z
8668142 8668142 20251130061702_iUZyB US004C 2025-12-02T14:42:04.641Z 2025-12-06T14:50:23.822Z
8668117 8668117 20251130060826_McLhs US004C 2025-12-02T14:42:02.157Z 2025-12-06T14:50:22.632Z
8668094 8668094 20251130060114_fNK5X US004C 2025-12-02T14:42:00.654Z 2025-12-06T14:50:21.563Z
8667822 8667822 20251130041726_A3sql US004C 2025-12-02T14:40:29.939Z 2025-12-06T14:49:27.619Z
8660220 8660220 20251130120749_x8aQb US004C 2025-12-02T14:06:57.604Z 2025-12-06T14:36:57.087Z
8660217 8660217 20251130120726_83M3H US004C 2025-12-02T14:06:56.905Z 2025-12-06T14:36:56.948Z
8660196 8660196 20251130120405_dzlFR US004C 2025-12-02T14:06:52.891Z 2025-12-06T14:36:55.093Z
8660055 8660055 20251130114931_m75Al US004C 2025-12-02T14:06:22.569Z 2025-12-06T14:36:51.366Z
8659880 8659880 20251130112529_CdQdc US004C 2025-12-02T14:05:41.548Z 2025-12-06T14:36:45.747Z
8659824 8659824 20251130111945_J3C3O US004C 2025-12-02T14:05:25.490Z 2025-12-06T14:36:43.508Z
8659809 8659809 20251130111733_uChwP US004C 2025-12-02T14:05:22.353Z 2025-12-06T14:36:42.747Z
8659671 8659671 20251130110333_0rVH5 US004C 2025-12-02T14:04:49.152Z 2025-12-06T14:36:32.374Z
8659580 8659580 20251130105053_ypyWz US004C 2025-12-02T14:04:33.441Z 2025-12-06T14:36:24.173Z
8659564 8659564 20251130104911_Lnezh US004C 2025-12-02T14:04:29.842Z 2025-12-06T14:36:23.635Z
8659431 8659431 20251130102631_2zBaq US004C 2025-12-02T14:03:52.254Z 2025-12-06T14:36:18.001Z
8659320 8659320 20251130100906_2Pbtt US004C 2025-12-02T14:03:29.117Z 2025-12-06T14:36:14.152Z
8659315 8659315 20251130100837_Dnrgp US004C 2025-12-02T14:03:28.244Z 2025-12-06T14:36:14.035Z
8659272 8659272 20251130100258_l62hk US004C 2025-12-02T14:03:21.089Z 2025-12-06T14:36:12.880Z
8659270 8659270 20251130100214_oRk4u US004C 2025-12-02T14:03:20.430Z 2025-12-06T14:36:12.819Z
8659239 8659239 20251130095406_qGt7Y US004C 2025-12-02T14:03:04.934Z 2025-12-06T14:36:11.843Z
8659149 8659149 20251130094105_lZVoY US004C 2025-12-02T14:02:45.946Z 2025-12-06T14:36:08.962Z
8659015 8659015 20251130091807_oydBQ US004C 2025-12-02T14:02:09.698Z 2025-12-06T14:36:02.700Z
8658960 8658960 20251130090610_2N9uv US004C 2025-12-02T14:01:50.313Z 2025-12-06T14:35:59.664Z
8658935 8658935 20251130085914_tnZ7U US004C 2025-12-02T14:01:43.598Z 2025-12-06T14:35:55.350Z
8658928 8658928 20251130085751_Swbgr US004C 2025-12-02T14:01:40.652Z 2025-12-06T14:35:54.245Z
8658918 8658918 20251130085650_K8W1I US004C 2025-12-02T14:01:38.354Z 2025-12-06T14:35:53.242Z
8658901 8658901 20251130085427_xcKUw US004C 2025-12-02T14:01:27.964Z 2025-12-06T14:35:49.841Z
8658876 8658876 20251130084603_0G5F2 US004C 2025-12-02T14:01:21.027Z 2025-12-06T14:35:44.422Z
8638092 8638092 20251128082257_Jh0Nc US004C 2025-11-29T14:28:29.538Z 2025-12-06T15:04:07.922Z
8638086 8638086 20251128082101_zjF9X US004C 2025-11-29T14:28:29.091Z 2025-12-06T15:04:07.824Z
8638064 8638064 20251128081725_MPmW2 US004C 2025-11-29T14:28:27.603Z 2025-12-06T15:04:07.531Z
8638062 8638062 20251128081651_jjB22 US004C 2025-11-29T14:28:27.479Z 2025-12-06T15:04:07.519Z
8638042 8638042 20251128081213_bKNSM US004C 2025-11-29T14:28:26.163Z 2025-12-06T15:04:07.325Z
8638025 8638025 20251128080645_lMr2M US004C 2025-11-29T14:28:25.334Z 2025-12-06T15:04:07.090Z
8637844 8637844 20251128065039_znTWY US004C 2025-11-29T14:27:55.214Z 2025-12-06T15:04:04.843Z
8637783 8637783 20251128064041_2FuH3 US004C 2025-11-29T14:27:51.937Z 2025-12-06T15:04:04.123Z
8637705 8637705 20251128062144_grbbV US004C 2025-11-29T14:27:44.749Z 2025-12-06T15:04:03.164Z
8637696 8637696 20251128061758_SjJcl US004C 2025-11-29T14:27:43.836Z 2025-12-06T15:04:03.039Z
8637607 8637607 20251128055940_ALrY0 US004C 2025-11-29T14:27:37.498Z 2025-12-06T15:04:01.720Z
8637391 8637391 20251128053550_ZEudB US004C 2025-11-29T14:27:11.876Z 2025-12-06T15:03:59.576Z
8636990 8636990 20251128044620_ECFhn US004C 2025-11-29T14:26:30.574Z 2025-12-06T15:03:54.350Z
8636812 8636812 20251128042928_0BmWU US004C 2025-11-29T14:26:13.811Z 2025-12-06T15:03:45.383Z
8636493 8636493 20251128035106_16nFa US004C 2025-11-29T14:25:34.596Z 2025-12-06T15:03:20.855Z
8635607 8635607 20251128023143_4YswM US004C 2025-11-29T14:23:56.008Z 2025-12-06T15:02:47.186Z
8635489 8635489 20251128021902_90Ld5 US004C 2025-11-29T14:23:29.160Z 2025-12-06T15:02:45.255Z
8635255 8635255 20251128015816_3WWI2 US004C 2025-11-29T14:22:55.069Z 2025-12-06T15:02:42.572Z
8634268 8634268 20251128003346_8c1Wu US004C 2025-11-29T14:21:08.896Z 2025-12-06T15:01:56.895Z
8627872 8627872 20251128114733_wCalP US004C 2025-11-29T14:04:40.185Z 2025-12-06T14:51:26.383Z
8627813 8627813 20251128113846_x9y3f US004C 2025-11-29T14:04:33.660Z 2025-12-06T14:51:25.427Z
8627382 8627382 20251128105458_FZTI9 US004C 2025-11-29T14:03:28.125Z 2025-12-06T14:51:17.307Z
8627380 8627380 20251128105444_Od9tL US004C 2025-11-29T14:03:27.763Z 2025-12-06T14:51:17.208Z
8627192 8627192 20251128103343_y4ZzF US004C 2025-11-29T14:02:55.132Z 2025-12-06T14:51:14.157Z
8627177 8627177 20251128103305_vyAp3 US004C 2025-11-29T14:02:53.662Z 2025-12-06T14:51:13.985Z
8626722 8626722 20251128092812_lMV58 US004C 2025-11-29T14:01:19.633Z 2025-12-06T14:50:41.405Z
8626303 8626303 20251126084835_BIa2t US004C 2025-11-28T14:38:39.467Z 2025-12-04T15:12:11.554Z
8626293 8626293 20251126084609_MXGG0 US004C 2025-11-28T14:38:35.176Z 2025-12-04T15:12:11.215Z
8626287 8626287 20251126084532_tUoQb US004C 2025-11-28T14:38:32.995Z 2025-12-04T15:12:10.851Z
8626275 8626275 20251126084114_azNtO US004C 2025-11-28T14:38:29.765Z 2025-12-04T15:12:10.327Z
8626268 8626268 20251126083939_u7uEa US004C 2025-11-28T14:38:27.824Z 2025-12-04T15:12:09.591Z
8626230 8626230 20251126082412_Dbw2W US004C 2025-11-28T14:38:18.142Z 2025-12-04T15:12:02.517Z
8626187 8626187 20251126080641_2nM9M US004C 2025-11-28T14:38:04.546Z 2025-12-04T15:11:57.655Z
8626169 8626169 20251126080323_MTDqS US004C 2025-11-28T14:38:00.479Z 2025-12-04T15:11:55.016Z
8626120 8626120 20251126074103_6wBH7 US004C 2025-11-28T14:37:43.771Z 2025-12-04T15:11:53.044Z
8626119 8626119 20251126074037_pw1on US004C 2025-11-28T14:37:43.261Z 2025-12-04T15:11:52.947Z
8626116 8626116 20251126073939_4Wj2Z US004C 2025-11-28T14:37:42.616Z 2025-12-04T15:11:52.885Z
8626090 8626090 20251126073248_X5WZX US004C 2025-11-28T14:37:39.462Z 2025-12-04T15:11:52.255Z

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