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

5,423 rows where station_code = "BR000F" 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
9798389 9798389 20260425231838_RIYVq BR000F 2026-04-27T12:23:01.107Z 2026-04-29T12:39:31.873Z
9788340 9788340 20260425083619_jzAVY BR000F 2026-04-26T12:24:13.705Z 2026-04-29T12:50:53.831Z
9788338 9788338 20260425083610_kHEso BR000F 2026-04-26T12:24:13.606Z 2026-04-29T12:50:53.756Z
9788334 9788334 20260425083223_eyx9q BR000F 2026-04-26T12:24:13.451Z 2026-04-29T12:50:53.324Z
9788301 9788301 20260425081456_0dT1r BR000F 2026-04-26T12:24:10.838Z 2026-04-29T12:50:51.725Z
9788257 9788257 20260425073957_8ZqrK BR000F 2026-04-26T12:24:07.177Z 2026-04-29T12:50:48.018Z
9788232 9788232 20260425072853_oUvuX BR000F 2026-04-26T12:24:04.841Z 2026-04-29T12:50:46.284Z
9788230 9788230 20260425072652_JlPmN BR000F 2026-04-26T12:24:04.579Z 2026-04-29T12:50:46.131Z
9788195 9788195 20260425071311_gD2Yq BR000F 2026-04-26T12:24:02.279Z 2026-04-29T12:50:43.981Z
9788171 9788171 20260425065553_gndkW BR000F 2026-04-26T12:24:00.104Z 2026-04-29T12:50:29.490Z
9788166 9788166 20260425064932_v3XZH BR000F 2026-04-26T12:23:59.810Z 2026-04-29T12:50:28.972Z
9788143 9788143 20260425063109_2eQ0c BR000F 2026-04-26T12:23:57.816Z 2026-04-29T12:50:27.863Z
9788125 9788125 20260425062102_wLLxr BR000F 2026-04-26T12:23:56.453Z 2026-04-29T12:50:27.418Z
9788118 9788118 20260425061836_3jBPe BR000F 2026-04-26T12:23:55.816Z 2026-04-29T12:50:27.132Z
9788077 9788077 20260425054236_TgXXa BR000F 2026-04-26T12:23:34.720Z 2026-04-29T12:50:25.334Z
9788069 9788069 20260425053901_gbicB BR000F 2026-04-26T12:23:34.149Z 2026-04-29T12:50:24.612Z
9788061 9788061 20260425052829_ozT5z BR000F 2026-04-26T12:23:33.665Z 2026-04-29T12:50:23.425Z
9787983 9787983 20260425034804_qhBsA BR000F 2026-04-26T12:23:21.778Z 2026-04-29T12:50:20.596Z
9787897 9787897 20260425031756_SKBTk BR000F 2026-04-26T12:23:17.897Z 2026-04-29T12:50:18.557Z
9787183 9787183 20260425021950_b5iXl BR000F 2026-04-26T12:22:01.548Z 2026-04-29T12:49:49.306Z
9786913 9786913 20260425020335_v6DUG BR000F 2026-04-26T12:21:42.831Z 2026-04-29T12:49:40.718Z
9773822 9773822 20260423074959_NnA9H BR000F 2026-04-25T12:53:11.037Z 2026-04-29T13:08:28.071Z
9773659 9773659 20260423072907_P2PU3 BR000F 2026-04-25T12:52:57.540Z 2026-04-29T13:08:25.172Z
9773650 9773650 20260423072749_qFcGc BR000F 2026-04-25T12:52:56.372Z 2026-04-29T13:08:25.095Z
9773580 9773580 20260423071854_KwO9j BR000F 2026-04-25T12:52:51.461Z 2026-04-29T13:08:24.147Z
9773546 9773546 20260423071019_4IDfP BR000F 2026-04-25T12:52:32.875Z 2026-04-29T13:08:23.490Z
9773304 9773304 20260423063628_pSW2I BR000F 2026-04-25T12:52:08.905Z 2026-04-29T13:08:17.861Z
9773301 9773301 20260423063613_V2boZ BR000F 2026-04-25T12:52:08.660Z 2026-04-29T13:08:17.794Z
9773231 9773231 20260423062158_5KJWS BR000F 2026-04-25T12:51:39.777Z 2026-04-29T13:08:16.738Z
9773225 9773225 20260423062119_temod BR000F 2026-04-25T12:51:39.370Z 2026-04-29T13:08:16.626Z
9773182 9773182 20260423061456_2nSwK BR000F 2026-04-25T12:51:36.623Z 2026-04-29T13:08:16.056Z
9773180 9773180 20260423061416_CyV3R BR000F 2026-04-25T12:51:36.331Z 2026-04-29T13:08:16.023Z
9773150 9773150 20260423061041_FRQJe BR000F 2026-04-25T12:51:31.410Z 2026-04-29T13:08:15.550Z
9773104 9773104 20260423060152_ApdDh BR000F 2026-04-25T12:51:28.384Z 2026-04-29T13:08:14.890Z
9773099 9773099 20260423060022_81tbm BR000F 2026-04-25T12:51:28.256Z 2026-04-29T13:08:14.856Z
9773057 9773057 20260423055251_7p8WC BR000F 2026-04-25T12:51:25.039Z 2026-04-29T13:08:14.212Z
9773018 9773018 20260423054551_2un68 BR000F 2026-04-25T12:51:21.051Z 2026-04-29T13:08:13.696Z
9772985 9772985 20260423053721_32UQ7 BR000F 2026-04-25T12:51:18.084Z 2026-04-29T13:08:13.363Z
9772952 9772952 20260423052350_DHqvd BR000F 2026-04-25T12:50:59.120Z 2026-04-29T13:08:12.965Z
9772725 9772725 20260423035114_HGKn7 BR000F 2026-04-25T12:50:31.055Z 2026-04-29T13:08:09.601Z
9772706 9772706 20260423034546_QW2cw BR000F 2026-04-25T12:50:11.566Z 2026-04-29T13:08:08.963Z
9772695 9772695 20260423034418_yTQSv BR000F 2026-04-25T12:50:10.706Z 2026-04-29T13:08:08.653Z
9772627 9772627 20260423025319_Ck6u2 BR000F 2026-04-25T12:49:51.215Z 2026-04-29T13:07:36.677Z
9772612 9772612 20260423024854_2fmjw BR000F 2026-04-25T12:49:48.344Z 2026-04-29T13:07:29.392Z
9772583 9772583 20260423024126_oW33y BR000F 2026-04-25T12:49:28.452Z 2026-04-29T13:07:17.798Z
9772550 9772550 20260423022153_qByPJ BR000F 2026-04-25T12:48:53.419Z 2026-04-29T13:07:05.996Z
9772543 9772543 20260423021512_B5wTr BR000F 2026-04-25T12:48:48.534Z 2026-04-29T13:07:03.989Z
9772488 9772488 20260423014138_7A7YA BR000F 2026-04-25T12:48:03.098Z 2026-04-29T13:06:41.740Z
9772480 9772480 20260423013038_orY5G BR000F 2026-04-25T12:47:38.308Z 2026-04-29T13:06:14.371Z
9772414 9772414 20260423005412_wIQQ2 BR000F 2026-04-25T12:46:41.339Z 2026-04-29T13:05:51.573Z
9772380 9772380 20260423002541_UCpn0 BR000F 2026-04-25T12:45:53.317Z 2026-04-29T13:05:14.930Z
9772378 9772378 20260423002511_XVBx8 BR000F 2026-04-25T12:45:51.117Z 2026-04-29T13:05:11.786Z
9771313 9771313 20260424074218_bF8XE BR000F 2026-04-25T12:34:45.850Z 2026-04-29T12:58:53.954Z
9771214 9771214 20260424072153_DenKJ BR000F 2026-04-25T12:34:26.826Z 2026-04-29T12:58:43.612Z
9771094 9771094 20260424065939_TVDAv BR000F 2026-04-25T12:34:09.241Z 2026-04-29T12:58:30.845Z
9770924 9770924 20260424062259_m94r6 BR000F 2026-04-25T12:33:37.733Z 2026-04-29T12:58:25.497Z
9770866 9770866 20260424055457_k7eWy BR000F 2026-04-25T12:33:21.020Z 2026-04-29T12:58:24.445Z
9770843 9770843 20260424054744_oBnqE BR000F 2026-04-25T12:33:18.909Z 2026-04-25T12:59:22.680Z
9770780 9770780 20260424052918_oRmtk BR000F 2026-04-25T12:33:08.092Z 2026-04-29T12:58:23.226Z
9770752 9770752 20260424051746_VJXud BR000F 2026-04-25T12:33:02.379Z 2026-04-29T12:58:22.508Z
9770743 9770743 20260424051654_XwnTO BR000F 2026-04-25T12:33:00.873Z 2026-04-29T12:58:22.272Z
9770670 9770670 20260424041655_fyjr4 BR000F 2026-04-25T12:32:39.354Z 2026-04-29T12:58:20.078Z
9770635 9770635 20260424040221_ZyAw1 BR000F 2026-04-25T12:32:34.621Z 2026-04-29T12:58:19.208Z
9770329 9770329 20260424031446_gXzMz BR000F 2026-04-25T12:31:55.833Z 2026-04-29T12:58:14.366Z
9768632 9768632 20260424014013_pEdJl BR000F 2026-04-25T12:27:46.571Z 2026-04-29T12:57:10.202Z
9767637 9767637 20260424005155_tQyUW BR000F 2026-04-25T12:25:01.494Z 2026-04-29T12:56:29.835Z
9766227 9766227 20260423233134_3tLCH BR000F 2026-04-25T12:21:22.082Z 2026-04-29T12:55:47.107Z
9765955 9765955 20260423231448_5Ohe0 BR000F 2026-04-25T12:20:43.164Z 2026-04-29T12:55:40.627Z
9740429 9740429 20260422074736_m922t BR000F 2026-04-23T12:26:12.181Z 2026-04-29T13:15:38.262Z
9740409 9740409 20260422074100_41x0K BR000F 2026-04-23T12:26:10.582Z 2026-04-29T13:15:37.027Z
9740384 9740384 20260422073558_CDJYZ BR000F 2026-04-23T12:26:07.599Z 2026-04-29T13:15:34.154Z
9740380 9740380 20260422073517_2VIZ9 BR000F 2026-04-23T12:26:05.632Z 2026-04-29T13:15:33.886Z
9740344 9740344 20260422072438_OvUlJ BR000F 2026-04-23T12:26:02.600Z 2026-04-29T13:15:31.541Z
9740226 9740226 20260422064417_6M1EZ BR000F 2026-04-23T12:25:49.485Z 2026-04-29T13:15:29.372Z
9740164 9740164 20260422062348_A0MKW BR000F 2026-04-23T12:25:29.841Z 2026-04-29T13:15:28.602Z
9740158 9740158 20260422062309_GsdkS BR000F 2026-04-23T12:25:29.297Z 2026-04-29T13:15:28.565Z
9740117 9740117 20260422061049_zhw1G BR000F 2026-04-23T12:25:21.746Z 2026-04-29T13:15:28.079Z
9740080 9740080 20260422055627_9K1ni BR000F 2026-04-23T12:25:18.843Z 2026-04-29T13:15:27.465Z
9740023 9740023 20260422053945_WB759 BR000F 2026-04-23T12:25:13.229Z 2026-04-29T13:15:24.922Z
9739985 9739985 20260422053101_RQO3s BR000F 2026-04-23T12:25:10.630Z 2026-04-29T13:15:24.339Z
9739957 9739957 20260422052211_BvpwF BR000F 2026-04-23T12:25:08.749Z 2026-04-29T13:15:24.074Z
9739905 9739905 20260422044751_FRbia BR000F 2026-04-23T12:24:48.283Z 2026-04-29T13:15:23.522Z
9739895 9739895 20260422044227_tNHaA BR000F 2026-04-23T12:24:46.815Z 2026-04-29T13:15:23.265Z
9739842 9739842 20260422041729_CDEO2 BR000F 2026-04-23T12:24:37.175Z 2026-04-29T13:15:22.570Z
9739838 9739838 20260422040720_HxTgG BR000F 2026-04-23T12:24:36.611Z 2026-04-29T13:15:22.547Z
9739770 9739770 20260422034259_G7dqg BR000F 2026-04-23T12:24:29.705Z 2026-04-29T13:15:21.386Z
9739263 9739263 20260422025812_uM4yJ BR000F 2026-04-23T12:23:37.854Z 2026-04-29T13:15:17.236Z
9738747 9738747 20260422023527_1CTl7 BR000F 2026-04-23T12:22:51.194Z 2026-04-29T13:15:13.523Z
9735451 9735451 20260422002352_egDc2 BR000F 2026-04-23T12:16:41.873Z 2026-04-29T13:13:27.963Z
9734880 9734880 20260421235705_tJz7E BR000F 2026-04-23T12:15:32.703Z 2026-04-29T13:13:16.165Z
9734621 9734621 20260421234345_rOOoQ BR000F 2026-04-23T12:14:59.614Z 2026-04-29T13:13:08.810Z
9734457 9734457 20260421233423_qcx07 BR000F 2026-04-23T12:14:35.644Z 2026-04-29T13:13:07.355Z
9734332 9734332 20260421232614_m9LXE BR000F 2026-04-23T12:14:20.148Z 2026-04-29T13:13:06.477Z
9733859 9733859 20260421230117_TY0AW BR000F 2026-04-23T12:13:08.517Z 2026-04-29T13:13:01.237Z
9733855 9733855 20260421230107_6b9Oh BR000F 2026-04-23T12:13:07.824Z 2026-04-29T13:13:01.155Z
9727690 9727690 20260421020711_W7yns BR000F 2026-04-22T12:22:53.869Z 2026-04-29T13:21:09.570Z
9727676 9727676 20260421020605_wZ2nk BR000F 2026-04-22T12:22:52.097Z 2026-04-29T13:21:09.434Z
9720383 9720383 20260420024419_xAzgO BR000F 2026-04-21T12:27:44.264Z 2026-04-28T13:39:19.365Z
9720255 9720255 20260420023251_HeXwv BR000F 2026-04-21T12:27:28.325Z 2026-04-28T13:39:17.264Z
9720076 9720076 20260420021409_M3kvY BR000F 2026-04-21T12:26:51.455Z 2026-04-28T13:39:04.704Z

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