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

>10,000 rows count all where station_code = "US0009" 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
9609901 9609901 20260405110255_Ndj79 US0009 2026-04-06T12:04:33.545Z 2026-04-06T12:04:33.545Z
9609405 9609405 20260405060428_YfNCz US0009 2026-04-06T12:01:39.976Z 2026-04-06T12:01:39.976Z
9607624 9607624 20260404112231_Ouxr1 US0009 2026-04-05T12:03:14.888Z 2026-04-06T12:16:14.477Z
9607555 9607555 20260404105734_F61Jl US0009 2026-04-05T12:02:55.617Z 2026-04-06T12:16:14.463Z
9607465 9607465 20260404093810_6gjfP US0009 2026-04-05T12:02:25.217Z 2026-04-06T12:16:14.444Z
9605724 9605724 20260403114122_78f7b US0009 2026-04-04T12:03:35.910Z 2026-04-06T12:18:15.078Z
9605596 9605596 20260403105428_As1pM US0009 2026-04-04T12:02:59.946Z 2026-04-06T12:18:06.974Z
9605568 9605568 20260403105004_2M4tk US0009 2026-04-04T12:02:56.087Z 2026-04-06T12:18:05.489Z
9605521 9605521 20260403103056_q6DNI US0009 2026-04-04T12:02:45.979Z 2026-04-06T12:18:00.969Z
9605474 9605474 20260403101133_dFzaU US0009 2026-04-04T12:02:29.856Z 2026-04-06T12:17:54.956Z
9603647 9603647 20260402113351_lgL24 US0009 2026-04-03T12:03:58.628Z 2026-04-06T12:22:19.482Z
9602708 9602708 20260402024141_CO1S2 US0009 2026-04-03T12:00:17.627Z 2026-04-06T12:21:04.728Z
9593605 9593605 20260329120756_tCi96 US0009 2026-03-30T12:04:30.959Z 2026-04-06T12:35:29.860Z
9593515 9593515 20260329113449_BaPYm US0009 2026-03-30T12:04:13.887Z 2026-04-06T12:35:23.299Z
9593446 9593446 20260329104925_XWcHA US0009 2026-03-30T12:03:59.225Z 2026-04-06T12:35:19.264Z
9593440 9593440 20260329104639_qSlAi US0009 2026-03-30T12:03:58.276Z 2026-04-06T12:35:18.910Z
9593307 9593307 20260329085609_acHEo US0009 2026-03-30T12:03:32.048Z 2026-04-06T12:35:02.506Z
9593191 9593191 20260329075206_JVI5Y US0009 2026-03-30T12:03:14.977Z 2026-04-06T12:34:55.701Z
9590818 9590818 20260328112712_pufvv US0009 2026-03-29T12:03:20.291Z 2026-04-06T12:38:35.839Z
9590692 9590692 20260328104418_Em5bT US0009 2026-03-29T12:03:07.465Z 2026-04-06T12:38:30.622Z
9590409 9590409 20260328090039_7fII9 US0009 2026-03-29T12:02:35.412Z 2026-04-06T12:38:06.616Z
9590261 9590261 20260328075614_LVC2d US0009 2026-03-29T12:02:20.638Z 2026-04-06T12:37:58.956Z
9590189 9590189 20260328072639_m0Ot3 US0009 2026-03-29T12:02:11.089Z 2026-04-06T12:37:55.534Z
9590151 9590151 20260328071339_xEVnQ US0009 2026-03-29T12:02:07.121Z 2026-04-06T12:37:53.545Z
9589638 9589638 20260328035238_TegGo US0009 2026-03-29T12:01:30.982Z 2026-04-06T12:37:29.871Z
9589456 9589456 20260328033040_sr7Ck US0009 2026-03-29T12:01:16.646Z 2026-04-06T12:37:24.292Z
9587137 9587137 20260327112344_byWRd US0009 2026-03-28T12:04:52.231Z 2026-04-05T12:34:03.769Z
9587099 9587099 20260327111208_LdroS US0009 2026-03-28T12:04:46.212Z 2026-04-05T12:34:01.692Z
9587009 9587009 20260327104440_qyy5M US0009 2026-03-28T12:04:33.387Z 2026-04-05T12:33:58.265Z
9586759 9586759 20260327092807_YEbra US0009 2026-03-28T12:03:56.617Z 2026-04-05T12:33:47.117Z
9586753 9586753 20260327092717_r2g3z US0009 2026-03-28T12:03:56.230Z 2026-04-05T12:33:46.917Z
9586589 9586589 20260327083418_E7SKc US0009 2026-03-28T12:03:30.076Z 2026-04-05T12:33:31.751Z
9586511 9586511 20260327080731_422b6 US0009 2026-03-28T12:03:18.563Z 2026-04-05T12:33:28.645Z
9586479 9586479 20260327075738_W9tcw US0009 2026-03-28T12:03:13.332Z 2026-04-05T12:33:27.510Z
9586469 9586469 20260327075554_nUuy3 US0009 2026-03-28T12:03:12.174Z 2026-04-05T12:33:27.210Z
9586426 9586426 20260327072702_3noKo US0009 2026-03-28T12:03:03.238Z 2026-04-05T12:33:24.854Z
9586418 9586418 20260327072258_n94PH US0009 2026-03-28T12:03:02.237Z 2026-04-05T12:33:24.524Z
9586335 9586335 20260327062917_za8rr US0009 2026-03-28T12:02:51.612Z 2026-04-05T12:33:21.288Z
9586243 9586243 20260327051547_9u7Qg US0009 2026-03-28T12:02:35.913Z 2026-04-05T12:33:09.980Z
9586224 9586224 20260327050122_kEm6R US0009 2026-03-28T12:02:33.651Z 2026-04-05T12:33:08.944Z
9583150 9583150 20260326112101_Y5bXa US0009 2026-03-27T12:07:52.698Z 2026-04-04T12:40:54.052Z
9582986 9582986 20260326103233_u4Zor US0009 2026-03-27T12:07:23.562Z 2026-04-04T12:40:39.026Z
9582979 9582979 20260326103213_J5EUc US0009 2026-03-27T12:07:23.189Z 2026-04-04T12:40:38.894Z
9582641 9582641 20260326085435_MEb5M US0009 2026-03-27T12:06:25.817Z 2026-04-04T12:40:17.032Z
9582289 9582289 20260326062151_4UKVQ US0009 2026-03-27T12:05:16.391Z 2026-04-04T12:39:48.718Z
9581924 9581924 20260326041211_lpPbj US0009 2026-03-27T12:04:11.497Z 2026-04-04T12:39:31.513Z
9578526 9578526 20260325121101_WA700 US0009 2026-03-26T12:07:49.865Z 2026-04-03T12:38:07.142Z
9578344 9578344 20260325112424_XU4sq US0009 2026-03-26T12:07:22.484Z 2026-04-03T12:37:59.466Z
9577716 9577716 20260325081314_BQgBq US0009 2026-03-26T12:05:55.606Z 2026-04-03T12:37:24.552Z
9577705 9577705 20260325081131_5v2LC US0009 2026-03-26T12:05:54.464Z 2026-04-03T12:37:23.955Z
9577484 9577484 20260325063249_KRmnX US0009 2026-03-26T12:05:15.547Z 2026-04-03T12:37:03.434Z
9577247 9577247 20260325042729_UiU5P US0009 2026-03-26T12:04:32.314Z 2026-04-03T12:36:53.212Z
9577184 9577184 20260325040837_gXodG US0009 2026-03-26T12:04:20.375Z 2026-04-03T12:36:39.720Z
9577128 9577128 20260325040042_gHP7J US0009 2026-03-26T12:04:13.675Z 2026-04-03T12:36:35.899Z
9573385 9573385 20260324120041_u1bad US0009 2026-03-25T12:07:51.877Z 2026-04-02T12:36:06.918Z
9573301 9573301 20260324114727_bVeBQ US0009 2026-03-25T12:07:40.699Z 2026-04-02T12:36:03.604Z
9573275 9573275 20260324114403_dSwoF US0009 2026-03-25T12:07:37.489Z 2026-04-02T12:36:02.390Z
9573061 9573061 20260324111309_Nrq0F US0009 2026-03-25T12:07:06.245Z 2026-04-02T12:35:54.405Z
9573058 9573058 20260324111215_Ii4cx US0009 2026-03-25T12:07:05.810Z 2026-04-02T12:35:54.315Z
9572999 9572999 20260324110536_FrUb3 US0009 2026-03-25T12:06:57.849Z 2026-04-02T12:35:46.630Z
9572713 9572713 20260324095908_PUZZO US0009 2026-03-25T12:06:05.752Z 2026-04-02T12:35:35.656Z
9572585 9572585 20260324093505_aqATt US0009 2026-03-25T12:05:39.239Z 2026-04-02T12:35:30.884Z
9572361 9572361 20260324084213_0eHCg US0009 2026-03-25T12:04:50.094Z 2026-04-02T12:35:21.544Z
9572292 9572292 20260324083022_MGW0Z US0009 2026-03-25T12:04:36.196Z 2026-04-02T12:35:13.076Z
9572264 9572264 20260324082212_faBXh US0009 2026-03-25T12:04:29.306Z 2026-04-02T12:35:11.602Z
9572071 9572071 20260324072213_9GvL2 US0009 2026-03-25T12:03:40.042Z 2026-04-02T12:35:01.677Z
9571821 9571821 20260324044117_AXvjS US0009 2026-03-25T12:02:52.061Z 2026-04-02T12:34:50.681Z
9564371 9564371 20260323102816_ARNqd US0009 2026-03-24T12:07:57.624Z 2026-03-31T12:27:08.073Z
9564351 9564351 20260323102456_rfsWM US0009 2026-03-24T12:07:54.681Z 2026-03-31T12:27:07.635Z
9564263 9564263 20260323101955_pcB8M US0009 2026-03-24T12:07:44.840Z 2026-03-31T12:27:06.281Z
9563892 9563892 20260323093052_QFnnS US0009 2026-03-24T12:06:58.359Z 2026-03-31T12:26:58.810Z
9563810 9563810 20260323091410_QWuQ1 US0009 2026-03-24T12:06:46.012Z 2026-03-31T12:26:57.056Z
9563575 9563575 20260323084603_J8S7c US0009 2026-03-24T12:06:17.111Z 2026-03-31T12:26:47.246Z
9563146 9563146 20260323072101_esyGe US0009 2026-03-24T12:05:14.998Z 2026-03-31T12:26:36.404Z
9563040 9563040 20260323045504_Q9P7Y US0009 2026-03-24T12:04:52.370Z 2026-03-31T12:26:33.156Z
9556418 9556418 20260322102954_JV5NY US0009 2026-03-23T12:04:46.776Z 2026-03-30T12:29:00.303Z
9556379 9556379 20260322101928_jlUFd US0009 2026-03-23T12:04:43.655Z 2026-03-30T12:28:59.198Z
9556359 9556359 20260322101534_ko7yx US0009 2026-03-23T12:04:42.545Z 2026-03-30T12:28:58.677Z
9556344 9556344 20260322100930_ybnJU US0009 2026-03-23T12:04:41.394Z 2026-03-30T12:28:58.146Z
9556263 9556263 20260322094907_tduWB US0009 2026-03-23T12:04:35.175Z 2026-03-30T12:28:55.553Z
9555902 9555902 20260322083424_N7Res US0009 2026-03-23T12:04:07.327Z 2026-03-30T12:28:38.675Z
9555524 9555524 20260322060346_gclsT US0009 2026-03-23T12:03:32.202Z 2026-03-30T12:28:28.455Z
9555519 9555519 20260322060346_cxUEo US0009 2026-03-23T12:03:32.069Z 2026-03-30T12:28:28.425Z
9555506 9555506 20260322055651_DwT83 US0009 2026-03-23T12:03:30.985Z 2026-03-30T12:28:27.881Z
9554815 9554815 20260322033717_P2DKb US0009 2026-03-23T12:02:52.107Z 2026-03-30T12:28:09.339Z
9546553 9546553 20260321120917_vFQiz US0009 2026-03-22T12:11:58.937Z 2026-03-29T12:20:02.254Z
9546350 9546350 20260321115507_XXG9k US0009 2026-03-22T12:11:32.625Z 2026-03-29T12:19:59.123Z
9545589 9545589 20260321104935_59h33 US0009 2026-03-22T12:09:48.322Z 2026-03-29T12:19:41.560Z
9545215 9545215 20260321101346_Fxwiy US0009 2026-03-22T12:08:55.584Z 2026-03-29T12:19:38.219Z
9545189 9545189 20260321101147_H7hQs US0009 2026-03-22T12:08:51.959Z 2026-03-29T12:19:37.932Z
9545129 9545129 20260321100450_zNRpg US0009 2026-03-22T12:08:39.614Z 2026-03-29T12:19:37.186Z
9545089 9545089 20260321100040_iMaYj US0009 2026-03-22T12:08:34.854Z 2026-03-29T12:19:36.878Z
9545018 9545018 20260321095125_c4yRZ US0009 2026-03-22T12:08:25.057Z 2026-03-29T12:19:36.256Z
9544938 9544938 20260321094342_tmGB1 US0009 2026-03-22T12:08:11.719Z 2026-03-29T12:19:35.431Z
9544517 9544517 20260321084940_BBgtE US0009 2026-03-22T12:07:04.815Z 2026-03-29T12:19:30.785Z
9544474 9544474 20260321084326_VUrR3 US0009 2026-03-22T12:06:57.725Z 2026-03-29T12:19:30.305Z
9544031 9544031 20260321070554_FV0ko US0009 2026-03-22T12:05:30.820Z 2026-03-29T12:19:15.384Z
9543918 9543918 20260321063039_6353U US0009 2026-03-22T12:05:10.797Z 2026-03-29T12:19:14.022Z
9543839 9543839 20260321054544_YDhHH US0009 2026-03-22T12:04:54.828Z 2026-03-29T12:19:12.990Z
9543693 9543693 20260321044714_WndIx US0009 2026-03-22T12:04:27.953Z 2026-03-29T12:19:10.218Z

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