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 = "BE0001" 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
8624001 8624001 20251127024406_1Mx7G BE0001 2025-11-28T14:23:35.835Z 2025-12-05T15:04:33.773Z
8623899 8623899 20251127022331_NdImQ BE0001 2025-11-28T14:23:04.571Z 2025-12-05T15:04:25.640Z
8623897 8623897 20251127022306_r1flb BE0001 2025-11-28T14:23:04.176Z 2025-12-05T15:04:25.593Z
8623836 8623836 20251127021502_0oTXG BE0001 2025-11-28T14:22:59.087Z 2025-12-05T15:04:20.584Z
8623821 8623821 20251127021303_3uyRh BE0001 2025-11-28T14:22:57.216Z 2025-12-05T15:04:18.462Z
8623770 8623770 20251127015829_dVmuo BE0001 2025-11-28T14:22:51.005Z 2025-12-05T15:04:15.578Z
8623768 8623768 20251127015813_50oLE BE0001 2025-11-28T14:22:50.627Z 2025-12-05T15:04:15.536Z
8623707 8623707 20251127014904_3RuJk BE0001 2025-11-28T14:22:27.387Z 2025-12-05T15:04:10.531Z
8623694 8623694 20251127014607_dOh9l BE0001 2025-11-28T14:22:26.230Z 2025-12-05T15:04:09.839Z
8623659 8623659 20251127013839_7cq2r BE0001 2025-11-28T14:22:21.096Z 2025-12-05T15:04:06.696Z
8623562 8623562 20251127010755_j83pO BE0001 2025-11-28T14:22:10.111Z 2025-12-05T15:04:00.437Z
8623396 8623396 20251127002307_bS4m3 BE0001 2025-11-28T14:21:39.091Z 2025-12-05T15:03:48.649Z
8623355 8623355 20251127000847_O636s BE0001 2025-11-28T14:21:34.342Z 2025-12-05T15:03:44.505Z
8623143 8623143 20251126230426_GesOY BE0001 2025-11-28T14:20:57.323Z 2025-12-05T15:03:32.542Z
8623059 8623059 20251126224234_AWATX BE0001 2025-11-28T14:20:39.237Z 2025-12-05T15:03:27.212Z
8581707 8581707 20251123014920_hrPQp BE0001 2025-11-24T14:32:33.312Z 2025-12-01T15:21:18.777Z
8581533 8581533 20251123004629_ooa3u BE0001 2025-11-24T14:31:44.183Z 2025-12-01T15:20:53.745Z
8581515 8581515 20251123003433_MzlNF BE0001 2025-11-24T14:31:42.853Z 2025-12-01T15:20:50.820Z
8581460 8581460 20251123000041_QG3YQ BE0001 2025-11-24T14:31:36.288Z 2025-12-01T15:20:34.539Z
8581328 8581328 20251122231020_RRz58 BE0001 2025-11-24T14:31:26.541Z 2025-12-01T15:20:13.839Z
8581269 8581269 20251122224333_oeAJL BE0001 2025-11-24T14:31:23.121Z 2025-12-01T15:20:07.578Z
8578999 8578999 20251122220417_xXBJW BE0001 2025-11-24T14:13:16.452Z 2025-12-01T15:19:58.124Z
8578816 8578816 20251122212917_dFDtB BE0001 2025-11-24T14:12:46.150Z 2025-12-01T15:19:53.318Z
8578718 8578718 20251122211933_j5wa0 BE0001 2025-11-24T14:12:31.200Z 2025-12-01T15:19:50.612Z
8578711 8578711 20251122211850_0XtqH BE0001 2025-11-24T14:12:24.735Z 2025-12-01T15:19:50.506Z
8578681 8578681 20251122211451_XYNSK BE0001 2025-11-24T14:12:20.598Z 2025-12-01T15:19:49.752Z
8578583 8578583 20251122205851_hc32B BE0001 2025-11-24T14:12:09.440Z 2025-12-01T15:19:48.695Z
8577670 8577670 20251122184537_1cQyk BE0001 2025-11-24T14:09:21.202Z 2025-12-01T15:18:56.118Z
8577586 8577586 20251122183420_7wjDf BE0001 2025-11-24T14:09:06.769Z 2025-12-01T15:18:54.674Z
8577537 8577537 20251122182450_xmv52 BE0001 2025-11-24T14:08:59.400Z 2025-12-01T15:18:53.499Z
8577284 8577284 20251122175149_4vKr4 BE0001 2025-11-24T14:08:11.787Z 2025-12-01T15:18:46.540Z
8577185 8577185 20251122172845_ViqGV BE0001 2025-11-24T14:07:54.166Z 2025-11-24T14:07:54.166Z
8574294 8574294 20251122054408_jLnJH BE0001 2025-11-23T14:43:04.815Z 2025-11-30T15:07:04.602Z
8574222 8574222 20251122053016_5WLWr BE0001 2025-11-23T14:42:53.748Z 2025-11-30T15:07:02.774Z
8574220 8574220 20251122052939_2kRJm BE0001 2025-11-23T14:42:53.691Z 2025-11-30T15:07:02.746Z
8574106 8574106 20251122051108_t3SIQ BE0001 2025-11-23T14:42:18.885Z 2025-11-30T15:06:58.573Z
8574091 8574091 20251122050732_r2DEI BE0001 2025-11-23T14:42:16.931Z 2025-11-30T15:06:58.373Z
8574037 8574037 20251122050113_Ndba3 BE0001 2025-11-23T14:42:12.937Z 2025-11-30T15:06:56.038Z
8574032 8574032 20251122050101_02RIc BE0001 2025-11-23T14:42:12.580Z 2025-11-30T15:06:55.869Z
8573999 8573999 20251122045711_wjAnl BE0001 2025-11-23T14:42:11.225Z 2025-11-30T15:06:55.461Z
8573989 8573989 20251122045536_ZIwKF BE0001 2025-11-23T14:42:10.774Z 2025-11-30T15:06:54.849Z
8573892 8573892 20251122043338_Bwyw7 BE0001 2025-11-23T14:42:05.516Z 2025-11-30T15:06:48.189Z
8573859 8573859 20251122042840_H1vh9 BE0001 2025-11-23T14:42:04.053Z 2025-11-30T15:06:45.298Z
8573833 8573833 20251122041944_loTO4 BE0001 2025-11-23T14:42:02.475Z 2025-11-23T14:42:02.475Z
8573818 8573818 20251122041630_2Ie9X BE0001 2025-11-23T14:42:01.722Z 2025-11-30T15:06:41.343Z
8573753 8573753 20251122040454_YmmoZ BE0001 2025-11-23T14:41:57.912Z 2025-11-30T15:06:36.843Z
8573631 8573631 20251122034724_fyjnZ BE0001 2025-11-23T14:41:36.260Z 2025-11-30T15:06:33.630Z
8573581 8573581 20251122033602_M3xjS BE0001 2025-11-23T14:41:19.835Z 2025-11-30T15:06:31.805Z
8573551 8573551 20251122033039_Nlc2v BE0001 2025-11-23T14:41:16.876Z 2025-11-30T15:06:30.672Z
8573548 8573548 20251122033025_Wyd8Z BE0001 2025-11-23T14:41:16.671Z 2025-11-30T15:06:30.668Z
8573539 8573539 20251122032849_ecHAj BE0001 2025-11-23T14:41:16.161Z 2025-11-30T15:06:30.518Z
8573449 8573449 20251122031332_tjG7v BE0001 2025-11-23T14:41:11.932Z 2025-11-30T15:06:25.119Z
8573430 8573430 20251122031052_PxlM2 BE0001 2025-11-23T14:41:11.347Z 2025-11-30T15:06:23.303Z
8573414 8573414 20251122030917_BhM87 BE0001 2025-11-23T14:41:10.705Z 2025-11-30T15:06:22.866Z
8573386 8573386 20251122030349_lYoIA BE0001 2025-11-23T14:41:09.254Z 2025-11-30T15:06:19.903Z
8573378 8573378 20251122030229_rqT50 BE0001 2025-11-23T14:41:08.945Z 2025-11-30T15:06:19.822Z
8573211 8573211 20251122024313_yP8Vs BE0001 2025-11-23T14:41:00.808Z 2025-11-30T15:06:12.452Z
8573137 8573137 20251122023315_4ciJb BE0001 2025-11-23T14:40:45.861Z 2025-11-30T15:06:10.620Z
8572977 8572977 20251122021321_xVzbn BE0001 2025-11-23T14:40:30.442Z 2025-11-30T15:06:07.909Z
8572813 8572813 20251122014537_SpF3i BE0001 2025-11-23T14:39:45.371Z 2025-11-30T15:06:02.645Z
8572739 8572739 20251122013525_XUWBt BE0001 2025-11-23T14:39:40.886Z 2025-11-30T15:05:57.325Z
8572708 8572708 20251122013217_Y2DMo BE0001 2025-11-23T14:39:39.601Z 2025-11-30T15:05:55.800Z
8572670 8572670 20251122012544_h56JS BE0001 2025-11-23T14:39:37.541Z 2025-11-30T15:05:54.916Z
8572594 8572594 20251122011439_Cckzx BE0001 2025-11-23T14:39:33.550Z 2025-11-30T15:05:52.392Z
8572494 8572494 20251122010049_eIBjI BE0001 2025-11-23T14:39:28.881Z 2025-11-30T15:05:51.273Z
8572492 8572492 20251122010010_xoJSs BE0001 2025-11-23T14:39:28.714Z 2025-11-30T15:05:51.237Z
8572445 8572445 20251122004658_udIeY BE0001 2025-11-23T14:39:22.743Z 2025-11-30T15:05:49.845Z
8572422 8572422 20251122004209_JtX07 BE0001 2025-11-23T14:39:12.922Z 2025-11-30T15:05:49.500Z
8572401 8572401 20251122003715_oaWCO BE0001 2025-11-23T14:39:08.429Z 2025-11-30T15:05:49.020Z
8572397 8572397 20251122003654_c5Pu9 BE0001 2025-11-23T14:39:08.154Z 2025-11-30T15:05:48.962Z
8572316 8572316 20251122002406_3Nngl BE0001 2025-11-23T14:38:47.693Z 2025-11-30T15:05:44.638Z
8572257 8572257 20251122001243_yCKOH BE0001 2025-11-23T14:38:27.297Z 2025-11-30T15:05:42.338Z
8572245 8572245 20251122000920_ZLxF4 BE0001 2025-11-23T14:38:15.575Z 2025-11-30T15:05:42.076Z
8572212 8572212 20251122000232_FLa2A BE0001 2025-11-23T14:38:06.318Z 2025-11-30T15:05:41.617Z
8572160 8572160 20251121235236_5YoxW BE0001 2025-11-23T14:38:03.791Z 2025-11-30T15:05:40.471Z
8572109 8572109 20251121233900_Au51b BE0001 2025-11-23T14:38:01.108Z 2025-11-30T15:05:37.920Z
8572042 8572042 20251121232141_wCO78 BE0001 2025-11-23T14:37:56.460Z 2025-11-30T15:05:34.114Z
8571889 8571889 20251121224318_BWT5K BE0001 2025-11-23T14:37:48.978Z 2025-11-30T15:05:24.876Z
8571869 8571869 20251121223441_schCN BE0001 2025-11-23T14:37:47.816Z 2025-11-30T15:05:23.391Z
8571846 8571846 20251121222052_WTn9A BE0001 2025-11-23T14:37:46.286Z 2025-11-30T15:05:20.096Z
8571667 8571667 20251121214700_Aed1M BE0001 2025-11-23T14:37:32.130Z 2025-11-30T15:05:12.253Z
8571552 8571552 20251121211608_0fVjl BE0001 2025-11-23T14:36:54.127Z 2025-11-30T15:05:10.039Z
8571545 8571545 20251121211600_btLPR BE0001 2025-11-23T14:36:52.766Z 2025-11-30T15:05:09.983Z
8571529 8571529 20251121211110_BJUkT BE0001 2025-11-23T14:36:50.762Z 2025-11-30T15:05:08.573Z
8571508 8571508 20251121210216_yaagH BE0001 2025-11-23T14:36:45.722Z 2025-11-30T15:05:07.558Z
8571502 8571502 20251121210046_hqUA6 BE0001 2025-11-23T14:36:44.095Z 2025-11-30T15:05:07.523Z
8571481 8571481 20251121205421_MFBNJ BE0001 2025-11-23T14:36:35.756Z 2025-11-30T15:05:06.726Z
8571456 8571456 20251121205105_TvIYF BE0001 2025-11-23T14:36:30.405Z 2025-11-30T15:05:06.349Z
8571343 8571343 20251121201900_e91GU BE0001 2025-11-23T14:36:12.137Z 2025-11-30T15:04:54.445Z
8571312 8571312 20251121201314_dl3ef BE0001 2025-11-23T14:36:09.733Z 2025-11-30T15:04:53.737Z
8571285 8571285 20251121200535_twN3E BE0001 2025-11-23T14:36:08.804Z 2025-11-30T15:04:53.096Z
8571212 8571212 20251121194138_fIKTn BE0001 2025-11-23T14:36:03.989Z 2025-11-30T15:04:39.634Z
8571200 8571200 20251121193918_asuci BE0001 2025-11-23T14:36:03.051Z 2025-11-30T15:04:39.360Z
8571177 8571177 20251121193341_jSmtU BE0001 2025-11-23T14:36:02.084Z 2025-11-30T15:04:34.321Z
8571167 8571167 20251121193155_M3Fw6 BE0001 2025-11-23T14:36:01.712Z 2025-11-30T15:04:34.264Z
8571124 8571124 20251121191756_PAMm1 BE0001 2025-11-23T14:35:59.728Z 2025-11-30T15:04:29.394Z
8570891 8570891 20251121174553_2lduD BE0001 2025-11-23T14:35:06.964Z 2025-11-30T15:03:57.708Z
8570826 8570826 20251121172059_dK6si BE0001 2025-11-23T14:34:48.655Z 2025-11-30T15:03:46.195Z
8505698 8505698 20251117203652_2AATX BE0001 2025-11-19T14:11:07.694Z 2025-11-26T15:07:39.444Z
8505591 8505591 20251117202803_gwKdn BE0001 2025-11-19T14:10:53.445Z 2025-11-26T15:07:39.045Z

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