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,062 rows where station_code = "US005H" 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
9609937 9609937 20260405111804_uEO83 US005H 2026-04-06T12:04:50.819Z 2026-04-06T12:04:50.819Z
9609816 9609816 20260405101746_7uGRC US005H 2026-04-06T12:04:01.617Z 2026-04-06T12:04:01.617Z
9609572 9609572 20260405082447_x89D1 US005H 2026-04-06T12:02:40.481Z 2026-04-06T12:02:40.481Z
9609532 9609532 20260405075302_D7YXT US005H 2026-04-06T12:02:23.272Z 2026-04-06T12:02:23.272Z
9609474 9609474 20260405071014_4LZvv US005H 2026-04-06T12:01:54.174Z 2026-04-06T12:01:54.174Z
9609461 9609461 20260405065215_FGZOI US005H 2026-04-06T12:01:50.709Z 2026-04-06T12:01:50.709Z
9609343 9609343 20260405050101_GF948 US005H 2026-04-06T12:01:19.436Z 2026-04-06T12:01:19.436Z
9607502 9607502 20260404100129_ASZgE US005H 2026-04-05T12:02:37.306Z 2026-04-06T12:16:14.451Z
9607422 9607422 20260404090500_zS9U9 US005H 2026-04-05T12:02:09.740Z 2026-04-06T12:16:14.433Z
9593469 9593469 20260329110750_tOzG2 US005H 2026-03-30T12:04:05.026Z 2026-04-06T12:35:20.610Z
9583178 9583178 20260326113201_192mn US005H 2026-03-27T12:07:56.994Z 2026-04-04T12:40:55.114Z
9582545 9582545 20260326082107_4SVG9 US005H 2026-03-27T12:06:06.449Z 2026-04-04T12:40:08.079Z
9582518 9582518 20260326081108_OhRx9 US005H 2026-03-27T12:06:01.315Z 2026-04-04T12:40:05.963Z
9582280 9582280 20260326061558_pG8fG US005H 2026-03-27T12:05:14.395Z 2026-04-04T12:39:48.243Z
9582182 9582182 20260326044922_N3ruy US005H 2026-03-27T12:04:50.377Z 2026-04-04T12:39:40.561Z
9578424 9578424 20260325114842_hRzYJ US005H 2026-03-26T12:07:35.757Z 2026-04-03T12:38:03.086Z
9578322 9578322 20260325111916_PH04a US005H 2026-03-26T12:07:18.562Z 2026-04-03T12:37:58.352Z
9578293 9578293 20260325111317_2SC3E US005H 2026-03-26T12:07:14.965Z 2026-04-03T12:37:57.437Z
9577565 9577565 20260325072548_Zv3dn US005H 2026-03-26T12:05:32.152Z 2026-04-03T12:37:06.949Z
9577462 9577462 20260325062337_7ldeC US005H 2026-03-26T12:05:12.694Z 2026-04-03T12:37:02.707Z
9577389 9577389 20260325053832_3ZuOY US005H 2026-03-26T12:04:59.878Z 2026-04-03T12:36:59.885Z
9572334 9572334 20260324083508_5tDPU US005H 2026-03-25T12:04:43.530Z 2026-04-02T12:35:14.570Z
9572296 9572296 20260324083030_DKic6 US005H 2026-03-25T12:04:36.789Z 2026-04-02T12:35:13.243Z
9571988 9571988 20260324064925_DP0Cp US005H 2026-03-25T12:03:26.085Z 2026-04-02T12:34:58.294Z
9563274 9563274 20260323075128_7I1tj US005H 2026-03-24T12:05:39.466Z 2026-03-31T12:26:39.880Z
9556335 9556335 20260322100618_aRCw2 US005H 2026-03-23T12:04:40.496Z 2026-03-30T12:28:57.843Z
9556274 9556274 20260322095227_oEhqx US005H 2026-03-23T12:04:36.396Z 2026-03-30T12:28:56.120Z
9553890 9553890 20260322022342_scLsN US005H 2026-03-23T12:01:57.993Z 2026-03-30T12:27:54.347Z
9545967 9545967 20260321112817_ElU3h US005H 2026-03-22T12:10:44.756Z 2026-03-29T12:19:46.291Z
9545839 9545839 20260321111233_IbfHB US005H 2026-03-22T12:10:22.593Z 2026-03-29T12:19:44.909Z
9545599 9545599 20260321105053_hKhXz US005H 2026-03-22T12:09:49.490Z 2026-03-29T12:19:41.701Z
9545165 9545165 20260321100912_l7c0b US005H 2026-03-22T12:08:47.551Z 2026-03-29T12:19:37.583Z
9544803 9544803 20260321092448_wk9AJ US005H 2026-03-22T12:07:51.116Z 2026-03-29T12:19:34.082Z
9544719 9544719 20260321091414_ikI60 US005H 2026-03-22T12:07:35.213Z 2026-03-29T12:19:32.987Z
9544361 9544361 20260321082337_u7FAh US005H 2026-03-22T12:06:34.195Z 2026-03-29T12:19:28.838Z
9543648 9543648 20260321043509_ZCPJQ US005H 2026-03-22T12:04:20.942Z 2026-03-29T12:19:09.722Z
9543142 9543142 20260321024631_8eiHN US005H 2026-03-22T12:02:47.430Z 2026-03-29T12:19:03.508Z
9537811 9537811 20260320120422_bqFsz US005H 2026-03-21T12:16:31.855Z 2026-03-28T12:35:29.573Z
9537510 9537510 20260320114251_DsLUG US005H 2026-03-21T12:15:56.902Z 2026-03-28T12:35:26.762Z
9536887 9536887 20260320104213_7Nzia US005H 2026-03-21T12:14:37.246Z 2026-03-28T12:35:18.355Z
9536877 9536877 20260320104033_a9jdw US005H 2026-03-21T12:14:35.451Z 2026-03-28T12:35:17.958Z
9536527 9536527 20260320100125_Oux2E US005H 2026-03-21T12:13:41.239Z 2026-03-28T12:35:03.027Z
9536299 9536299 20260320093106_zzmnq US005H 2026-03-21T12:13:03.669Z 2026-03-28T12:34:59.424Z
9536247 9536247 20260320092734_Fo1XK US005H 2026-03-21T12:12:54.652Z 2026-03-28T12:34:58.930Z
9536122 9536122 20260320091346_BD0iP US005H 2026-03-21T12:12:39.296Z 2026-03-28T12:34:57.845Z
9535784 9535784 20260320083321_kIBfp US005H 2026-03-21T12:11:51.812Z 2026-03-28T12:34:51.187Z
9535415 9535415 20260320072802_q792Z US005H 2026-03-21T12:10:42.732Z 2026-03-28T12:34:34.563Z
9535192 9535192 20260320060940_1i5cG US005H 2026-03-21T12:10:00.314Z 2026-03-28T12:34:29.132Z
9535021 9535021 20260320051154_l6SIK US005H 2026-03-21T12:09:30.954Z 2026-03-28T12:34:25.779Z
9534627 9534627 20260320040640_VMfa4 US005H 2026-03-21T12:08:30.214Z 2026-03-28T12:34:20.295Z
9523839 9523839 20260319104915_NEHPQ US005H 2026-03-20T12:12:04.445Z 2026-03-27T12:41:45.784Z
9523761 9523761 20260319103948_5LfFr US005H 2026-03-20T12:11:56.552Z 2026-03-27T12:41:44.326Z
9523449 9523449 20260319100705_wyjqT US005H 2026-03-20T12:11:27.859Z 2026-03-27T12:41:29.075Z
9523092 9523092 20260319092652_U75zg US005H 2026-03-20T12:10:52.370Z 2026-03-27T12:41:25.062Z
9522381 9522381 20260319073703_0myRw US005H 2026-03-20T12:09:41.715Z 2026-03-27T12:41:17.376Z
9522207 9522207 20260319064724_WglaM US005H 2026-03-20T12:09:18.579Z 2026-03-27T12:41:15.089Z
9522117 9522117 20260319060731_MDA3i US005H 2026-03-20T12:09:05.838Z 2026-03-27T12:41:13.976Z
9522085 9522085 20260319054043_ifK0Y US005H 2026-03-20T12:08:59.476Z 2026-03-27T12:41:13.525Z
9520155 9520155 20260319025652_KXtqi US005H 2026-03-20T12:05:50.500Z 2026-03-27T12:40:39.662Z
9512944 9512944 20260318080755_3qqKb US005H 2026-03-19T12:13:58.345Z 2026-03-26T12:37:50.301Z
9512657 9512657 20260318072707_7UBDy US005H 2026-03-19T12:13:11.952Z 2026-03-26T12:37:47.722Z
9512638 9512638 20260318072151_xfmZF US005H 2026-03-19T12:13:09.098Z 2026-03-26T12:37:47.503Z
9512549 9512549 20260318070156_2fIH0 US005H 2026-03-19T12:12:53.672Z 2026-03-26T12:37:46.535Z
9510762 9510762 20260318031330_27R96 US005H 2026-03-19T12:08:36.849Z 2026-03-26T12:37:16.506Z
9504561 9504561 20260317115816_KcEtH US005H 2026-03-18T12:08:22.186Z 2026-03-25T12:42:22.889Z
9504540 9504540 20260317115301_6rpyg US005H 2026-03-18T12:08:19.232Z 2026-03-25T12:42:22.767Z
9504440 9504440 20260317113629_kNz2U US005H 2026-03-18T12:08:03.658Z 2026-03-25T12:42:21.860Z
9504198 9504198 20260317105537_eovoD US005H 2026-03-18T12:07:25.634Z 2026-03-25T12:42:20.201Z
9503881 9503881 20260317100642_36PxV US005H 2026-03-18T12:06:41.241Z 2026-03-25T12:42:18.422Z
9503438 9503438 20260317085332_kipwq US005H 2026-03-18T12:05:39.521Z 2026-03-25T12:42:15.974Z
9487688 9487688 20260315104114_3kHC0 US005H 2026-03-16T12:13:29.069Z 2026-03-23T12:22:19.924Z
9328677 9328677 20260215122836_r2yLy US005H 2026-02-16T14:09:46.442Z 2026-02-24T14:42:29.218Z
9328086 9328086 20260215100157_0x2Ys US005H 2026-02-16T14:07:16.441Z 2026-02-24T14:42:06.611Z
9328049 9328049 20260215095541_r7v6y US005H 2026-02-16T14:07:06.925Z 2026-02-24T14:42:06.386Z
9327739 9327739 20260215082402_2Y8zQ US005H 2026-02-16T14:05:46.617Z 2026-02-24T14:42:00.739Z
9327717 9327717 20260215082222_V1KLV US005H 2026-02-16T14:05:40.210Z 2026-02-24T14:42:00.237Z
9327247 9327247 20260215044744_6CZCX US005H 2026-02-16T14:03:19.097Z 2026-02-24T14:41:50.046Z
9327015 9327015 20260215032700_Xpy6P US005H 2026-02-16T14:02:00.171Z 2026-02-24T14:41:40.175Z
9327012 9327012 20260215032609_0Skpn US005H 2026-02-16T14:01:59.247Z 2026-02-24T14:41:40.136Z
9326878 9326878 20260215025055_JkHeK US005H 2026-02-16T14:01:15.633Z 2026-02-24T14:41:37.718Z
9324544 9324544 20260214115606_AKAGJ US005H 2026-02-15T14:11:12.634Z 2026-02-23T14:47:00.955Z
9324403 9324403 20260214111626_3X6RU US005H 2026-02-15T14:10:24.658Z 2026-02-23T14:46:58.492Z
9324386 9324386 20260214111254_kaCFp US005H 2026-02-15T14:10:18.793Z 2026-02-23T14:46:57.971Z
9324344 9324344 20260214105448_7POXk US005H 2026-02-15T14:10:03.849Z 2026-02-23T14:46:57.206Z
9324329 9324329 20260214104855_IyQEp US005H 2026-02-15T14:09:59.317Z 2026-02-23T14:46:57.009Z
9320716 9320716 20260213122849_oR98r US005H 2026-02-14T14:08:19.227Z 2026-02-22T14:42:10.044Z
9320700 9320700 20260213121348_wpozO US005H 2026-02-14T14:08:11.786Z 2026-02-22T14:42:09.609Z
9320676 9320676 20260213120444_covuj US005H 2026-02-14T14:08:02.737Z 2026-02-22T14:42:08.958Z
9320638 9320638 20260213114712_vCS1n US005H 2026-02-14T14:07:49.668Z 2026-02-22T14:42:08.268Z
9320589 9320589 20260213112719_yb4Tc US005H 2026-02-14T14:07:35.285Z 2026-02-22T14:42:07.476Z
9320584 9320584 20260213112517_8BPdv US005H 2026-02-14T14:07:33.845Z 2026-02-22T14:42:07.417Z
9320531 9320531 20260213105922_QIIGX US005H 2026-02-14T14:07:15.628Z 2026-02-22T14:42:06.201Z
9320458 9320458 20260213102909_hx2Ur US005H 2026-02-14T14:06:48.668Z 2026-02-22T14:42:04.274Z
9320456 9320456 20260213102609_0Qopv US005H 2026-02-14T14:06:48.065Z 2026-02-22T14:42:04.263Z
9320295 9320295 20260213092404_o3MQ6 US005H 2026-02-14T14:05:49.329Z 2026-02-22T14:41:52.496Z
9320264 9320264 20260213090840_5UCMc US005H 2026-02-14T14:05:39.614Z 2026-02-22T14:41:51.821Z
9320257 9320257 20260213090748_0BrWF US005H 2026-02-14T14:05:38.178Z 2026-02-22T14:41:51.732Z
9318137 9318137 20260212124603_OdSmS US005H 2026-02-13T14:09:32.222Z 2026-02-21T14:37:18.364Z
9318090 9318090 20260212123219_Mwdrv US005H 2026-02-13T14:09:13.814Z 2026-02-21T14:37:17.753Z
9317752 9317752 20260212104429_N2LSM US005H 2026-02-13T14:07:03.872Z 2026-02-21T14:37:03.085Z

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