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

9,833 rows where station_code = "BE000Q" 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
9260784 9260784 20260122053608_pAudg BE000Q 2026-01-26T14:38:56.833Z 2026-01-29T14:58:42.852Z
9260771 9260771 20260122023230_yZ49o BE000Q 2026-01-26T14:38:06.364Z 2026-01-29T14:57:51.696Z
9260749 9260749 20260121212409_GDvr2 BE000Q 2026-01-26T14:37:00.449Z 2026-01-29T14:56:53.228Z
9260744 9260744 20260121183137_NvmNZ BE000Q 2026-01-26T14:36:14.099Z 2026-01-29T14:56:09.075Z
9259778 9259778 20260125000541_oWd3n BE000Q 2026-01-26T14:18:34.020Z 2026-01-29T14:43:18.764Z
9259729 9259729 20260124234424_fVzsY BE000Q 2026-01-26T14:18:18.658Z 2026-01-29T14:43:15.894Z
9255615 9255615 20260124041957_kZgW9 BE000Q 2026-01-25T14:14:06.772Z 2026-01-29T14:47:42.823Z
9249636 9249636 20260122060813_DCVdG BE000Q 2026-01-23T14:15:49.318Z 2026-01-29T14:58:47.475Z
9249627 9249627 20260122060813_5DVwn BE000Q 2026-01-23T14:15:48.888Z 2026-01-29T14:58:47.397Z
9249588 9249588 20260122060309_2jPgp BE000Q 2026-01-23T14:15:46.139Z 2026-01-29T14:58:46.280Z
9249496 9249496 20260122053218_KuYAx BE000Q 2026-01-23T14:15:36.267Z 2026-01-29T14:58:41.960Z
9249480 9249480 20260122052949_1MIai BE000Q 2026-01-23T14:15:29.332Z 2026-01-29T14:58:41.297Z
9249397 9249397 20260122050709_Cvh3r BE000Q 2026-01-23T14:15:18.015Z 2026-01-29T14:58:28.859Z
9249353 9249353 20260122050226_Uy8Wx BE000Q 2026-01-23T14:15:13.217Z 2026-01-29T14:58:27.039Z
9249326 9249326 20260122045006_QzGIO BE000Q 2026-01-23T14:15:10.804Z 2026-01-29T14:58:26.060Z
9249282 9249282 20260122043817_SrQn0 BE000Q 2026-01-23T14:15:06.966Z 2026-01-29T14:58:21.738Z
9249264 9249264 20260122043118_HFqon BE000Q 2026-01-23T14:15:04.732Z 2026-01-29T14:58:20.570Z
9249204 9249204 20260122040803_wgULS BE000Q 2026-01-23T14:14:51.307Z 2026-01-29T14:58:16.843Z
9249162 9249162 20260122035458_HhIUZ BE000Q 2026-01-23T14:14:41.944Z 2026-01-29T14:58:14.933Z
9249159 9249159 20260122035018_Tzg8W BE000Q 2026-01-23T14:14:41.478Z 2026-01-29T14:58:14.866Z
9249147 9249147 20260122034749_MGuEO BE000Q 2026-01-23T14:14:40.260Z 2026-01-29T14:58:14.387Z
9249133 9249133 20260122034520_NqVvz BE000Q 2026-01-23T14:14:39.361Z 2026-01-29T14:58:14.099Z
9249049 9249049 20260122032239_fNL7X BE000Q 2026-01-23T14:14:30.466Z 2026-01-29T14:58:10.783Z
9249029 9249029 20260122031326_haw2r BE000Q 2026-01-23T14:14:27.564Z 2026-01-29T14:58:09.879Z
9249014 9249014 20260122030630_2Vlox BE000Q 2026-01-23T14:14:25.412Z 2026-01-29T14:58:08.960Z
9248997 9248997 20260122030511_p0BKw BE000Q 2026-01-23T14:14:17.046Z 2026-01-29T14:58:07.872Z
9248969 9248969 20260122025620_UOuMn BE000Q 2026-01-23T14:14:13.787Z 2026-01-29T14:57:58.816Z
9248962 9248962 20260122025609_a3NIl BE000Q 2026-01-23T14:14:13.352Z 2026-01-29T14:57:57.846Z
9248877 9248877 20260122023400_CPxIz BE000Q 2026-01-23T14:14:02.538Z 2026-01-29T14:57:52.810Z
9248867 9248867 20260122023230_2FPOM BE000Q 2026-01-23T14:14:00.887Z 2026-01-25T14:27:09.217Z
9248785 9248785 20260122020950_oSQ8S BE000Q 2026-01-23T14:13:51.392Z 2026-01-29T14:57:46.574Z
9248711 9248711 20260122014959_HWgkq BE000Q 2026-01-23T14:13:29.989Z 2026-01-29T14:57:42.383Z
9248675 9248675 20260122013859_GPTfx BE000Q 2026-01-23T14:13:24.337Z 2026-01-29T14:57:40.229Z
9248653 9248653 20260122013354_6DbJg BE000Q 2026-01-23T14:13:21.878Z 2026-01-29T14:57:38.978Z
9248651 9248651 20260122013311_psDeX BE000Q 2026-01-23T14:13:21.491Z 2026-01-29T14:57:38.845Z
9248637 9248637 20260122012604_WeCIL BE000Q 2026-01-23T14:13:20.091Z 2026-01-29T14:57:38.187Z
9248545 9248545 20260122003722_qmndS BE000Q 2026-01-23T14:13:03.727Z 2026-01-29T14:57:26.090Z
9248437 9248437 20260121234650_2FdeR BE000Q 2026-01-23T14:12:47.917Z 2026-01-29T14:57:19.023Z
9248382 9248382 20260121232659_3XtTF BE000Q 2026-01-23T14:12:41.011Z 2026-01-29T14:57:16.270Z
9248360 9248360 20260121231257_8Fo2k BE000Q 2026-01-23T14:12:38.752Z 2026-01-29T14:57:15.632Z
9248282 9248282 20260121224615_6kDDh BE000Q 2026-01-23T14:12:24.323Z 2026-01-29T14:57:11.714Z
9248205 9248205 20260121221535_7rgxv BE000Q 2026-01-23T14:12:14.428Z 2026-01-29T14:57:08.523Z
9248192 9248192 20260121221247_7jvgw BE000Q 2026-01-23T14:12:13.148Z 2026-01-29T14:57:08.031Z
9248188 9248188 20260121220955_lRDnR BE000Q 2026-01-23T14:12:12.835Z 2026-01-29T14:57:07.765Z
9248176 9248176 20260121220238_BP3dl BE000Q 2026-01-23T14:12:11.492Z 2026-01-29T14:57:07.073Z
9248156 9248156 20260121215607_O7qy2 BE000Q 2026-01-23T14:12:09.424Z 2026-01-29T14:57:05.824Z
9248145 9248145 20260121215300_A2wi3 BE000Q 2026-01-23T14:12:08.082Z 2026-01-29T14:57:05.285Z
9248134 9248134 20260121214203_luwAe BE000Q 2026-01-23T14:12:06.557Z 2026-01-29T14:56:56.032Z
9248069 9248069 20260121212409_AzV3D BE000Q 2026-01-23T14:11:50.421Z 2026-01-25T14:26:09.119Z
9247979 9247979 20260121205609_hXJBf BE000Q 2026-01-23T14:11:39.956Z 2026-01-29T14:56:47.032Z
9247938 9247938 20260121203736_OBq5E BE000Q 2026-01-23T14:11:34.682Z 2026-01-29T14:56:44.622Z
9247933 9247933 20260121203638_3oYiS BE000Q 2026-01-23T14:11:34.280Z 2026-01-29T14:56:44.506Z
9247869 9247869 20260121201829_MN0gb BE000Q 2026-01-23T14:11:18.935Z 2026-01-29T14:56:41.460Z
9247853 9247853 20260121201211_VczUB BE000Q 2026-01-23T14:11:16.195Z 2026-01-29T14:56:40.697Z
9247750 9247750 20260121194331_Eq6HO BE000Q 2026-01-23T14:11:02.923Z 2026-01-29T14:56:35.730Z
9247655 9247655 20260121192432_Gulcu BE000Q 2026-01-23T14:10:41.383Z 2026-01-29T14:56:21.952Z
9247444 9247444 20260121183137_OzSJs BE000Q 2026-01-23T14:10:04.843Z 2026-01-25T14:25:16.448Z
9247286 9247286 20260121175424_GBOuI BE000Q 2026-01-23T14:09:36.698Z 2026-01-29T14:56:02.399Z
9247277 9247277 20260121175350_dgJxA BE000Q 2026-01-23T14:09:35.318Z 2026-01-29T14:55:58.498Z
9224836 9224836 20260118061538_iuy03 BE000Q 2026-01-19T14:26:20.428Z 2026-01-26T15:03:50.835Z
9224809 9224809 20260118060549_QZ8oY BE000Q 2026-01-19T14:26:12.758Z 2026-01-26T15:03:49.647Z
9224627 9224627 20260118052450_y5rkB BE000Q 2026-01-19T14:25:14.189Z 2026-01-26T15:03:42.764Z
9224575 9224575 20260118051434_CjTJO BE000Q 2026-01-19T14:25:04.771Z 2026-01-26T15:03:24.367Z
9224452 9224452 20260118044905_uaviK BE000Q 2026-01-19T14:24:29.815Z 2026-01-26T15:03:19.495Z
9224359 9224359 20260118042617_On7JU BE000Q 2026-01-19T14:24:04.104Z 2026-01-26T15:03:15.547Z
9224301 9224301 20260118041306_WZQRr BE000Q 2026-01-19T14:23:45.733Z 2026-01-26T15:03:12.450Z
9224248 9224248 20260118040026_Ng8wg BE000Q 2026-01-19T14:23:35.434Z 2026-01-26T15:03:10.539Z
9224121 9224121 20260118032820_LgfQe BE000Q 2026-01-19T14:22:59.321Z 2026-01-26T15:03:05.418Z
9224013 9224013 20260118030832_055NO BE000Q 2026-01-19T14:22:23.958Z 2026-01-26T15:02:47.898Z
9223999 9223999 20260118030655_dGVyE BE000Q 2026-01-19T14:22:21.145Z 2026-01-26T15:02:47.489Z
9223962 9223962 20260118030146_IYdkM BE000Q 2026-01-19T14:22:06.070Z 2026-01-26T15:02:46.158Z
9223936 9223936 20260118025708_YPFn2 BE000Q 2026-01-19T14:21:55.372Z 2026-01-26T15:02:42.274Z
9223897 9223897 20260118024416_2O3Lt BE000Q 2026-01-19T14:21:44.661Z 2026-01-26T15:02:40.472Z
9223754 9223754 20260118021848_vd2qq BE000Q 2026-01-19T14:20:55.624Z 2026-01-26T15:02:34.794Z
9223675 9223675 20260118020002_c0YTc BE000Q 2026-01-19T14:20:35.820Z 2026-01-26T15:02:31.771Z
9223580 9223580 20260118013057_hyKHz BE000Q 2026-01-19T14:20:02.739Z 2026-01-26T15:02:19.935Z
9223489 9223489 20260118005738_6GsIb BE000Q 2026-01-19T14:19:33.203Z 2026-01-26T15:02:10.751Z
9223374 9223374 20260118002744_DL29C BE000Q 2026-01-19T14:18:57.696Z 2026-01-26T15:02:04.458Z
9223364 9223364 20260118002523_knHlv BE000Q 2026-01-19T14:18:55.350Z 2026-01-26T15:02:04.072Z
9223336 9223336 20260118001727_M4rk8 BE000Q 2026-01-19T14:18:48.780Z 2026-01-26T15:02:02.782Z
9223319 9223319 20260118001231_cGZi7 BE000Q 2026-01-19T14:18:45.400Z 2026-01-26T15:02:02.104Z
9223303 9223303 20260118000847_LisfL BE000Q 2026-01-19T14:18:37.610Z 2026-01-26T15:02:01.626Z
9223288 9223288 20260118000636_3GeQC BE000Q 2026-01-19T14:18:35.121Z 2026-01-26T15:02:01.097Z
9223103 9223103 20260117230543_Hxr7F BE000Q 2026-01-19T14:17:44.978Z 2026-01-26T15:01:50.546Z
9223002 9223002 20260117220808_PJeGu BE000Q 2026-01-19T14:17:15.659Z 2026-01-26T15:01:31.591Z
9222955 9222955 20260117214105_PY82x BE000Q 2026-01-19T14:16:58.765Z 2026-01-26T15:01:29.533Z
9222889 9222889 20260117211722_USNDv BE000Q 2026-01-19T14:16:41.997Z 2026-01-26T15:01:24.701Z
9222534 9222534 20260117195209_j2FsJ BE000Q 2026-01-19T14:15:10.742Z 2026-01-26T15:01:12.815Z
9222439 9222439 20260117193349_sLaGZ BE000Q 2026-01-19T14:14:46.721Z 2026-01-26T15:00:53.913Z
9149266 9149266 20260104194817_l4H0g BE000Q 2026-01-06T14:04:42.500Z 2026-01-13T15:11:54.120Z
9149231 9149231 20260104193257_1lKN7 BE000Q 2026-01-06T14:04:29.384Z 2026-01-13T15:11:50.464Z
9148941 9148941 20260104181122_3HZN0 BE000Q 2026-01-06T14:03:11.181Z 2026-01-13T15:11:28.293Z
9148828 9148828 20260104173609_Z94ak BE000Q 2026-01-06T14:02:29.482Z 2026-01-13T15:11:20.828Z
9141552 9141552 20260104005914_VqoHe BE000Q 2026-01-05T14:14:47.178Z 2026-01-12T15:05:04.138Z
9130167 9130167 20260103022342_l5uww BE000Q 2026-01-04T14:08:44.904Z 2026-01-10T14:58:48.858Z
9129779 9129779 20260103003821_nIdKQ BE000Q 2026-01-04T14:06:22.009Z 2026-01-10T14:58:12.502Z
9126003 9126003 20251230180713_0n6YG BE000Q 2026-01-02T15:07:22.201Z 2026-01-07T15:12:47.744Z
9123512 9123512 20251231014057_D9d7T BE000Q 2026-01-02T14:29:41.701Z 2026-01-08T15:06:56.103Z
9123508 9123508 20251231014024_Yaksg BE000Q 2026-01-02T14:29:39.439Z 2026-01-08T15:06:55.302Z
9123419 9123419 20251231003923_LbPyP BE000Q 2026-01-02T14:27:19.448Z 2026-01-08T15:06:16.737Z

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