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

466 rows where station_code = "BG000F" 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
8683458 8683458 20251201235922_E2Orp BG000F 2025-12-04T14:24:52.058Z 2025-12-05T14:27:19.913Z
8683456 8683456 20251201234451_FwmYF BG000F 2025-12-04T14:24:49.973Z 2025-12-05T14:27:18.161Z
8683452 8683452 20251201231704_HPLVS BG000F 2025-12-04T14:24:48.375Z 2025-12-05T14:27:16.852Z
8683444 8683444 20251201222933_1tu62 BG000F 2025-12-04T14:24:44.975Z 2025-12-05T14:27:04.230Z
8674317 8674317 20251202015922_3nwMw BG000F 2025-12-03T14:21:23.892Z 2025-12-05T14:27:36.011Z
8673817 8673817 20251201234451_UY2W0 BG000F 2025-12-03T14:20:06.636Z 2025-12-03T14:20:06.636Z
8597857 8597857 20251125001502_t7UA5 BG000F 2025-11-26T14:17:46.337Z 2025-12-02T15:07:41.110Z
8481301 8481301 20251116022639_XUCPc BG000F 2025-11-17T14:20:38.006Z 2025-11-24T15:05:01.932Z
8459039 8459039 20251114023754_vUvHk BG000F 2025-11-15T14:18:42.847Z 2025-11-22T15:21:33.502Z
8458910 8458910 20251114021029_zrJLb BG000F 2025-11-15T14:18:14.816Z 2025-11-22T15:21:27.313Z
8458191 8458191 20251113225658_3JNmR BG000F 2025-11-15T14:15:51.663Z 2025-11-22T15:21:00.066Z
8449399 8449399 20251113020227_4pmks BG000F 2025-11-14T14:20:21.525Z 2025-11-21T15:11:59.482Z
8448765 8448765 20251113001259_69sz3 BG000F 2025-11-14T14:18:18.355Z 2025-11-21T15:11:38.093Z
8447682 8447682 20251112202356_4lnCV BG000F 2025-11-14T14:14:48.307Z 2025-11-21T15:11:19.909Z
8331910 8331910 20251101034126_ocRXk BG000F 2025-11-02T14:12:02.545Z 2025-11-09T15:03:21.972Z
8319441 8319441 20251030020855_J7q5i BG000F 2025-11-01T12:24:34.038Z 2025-11-07T15:13:41.823Z
8309967 8309967 20251029181156_Do3iU BG000F 2025-10-31T12:32:53.363Z 2025-11-07T15:10:00.123Z
8299657 8299657 20251029033746_ryNZ4 BG000F 2025-10-30T12:52:07.423Z 2025-11-06T15:13:49.524Z
8298092 8298092 20251029003924_O8iQg BG000F 2025-10-30T12:50:09.459Z 2025-11-06T15:12:45.233Z
8297205 8297205 20251028225856_xFBg2 BG000F 2025-10-30T12:49:13.611Z 2025-11-06T15:12:26.583Z
8297107 8297107 20251028224625_UQZBy BG000F 2025-10-30T12:49:09.843Z 2025-11-06T15:12:25.737Z
8296798 8296798 20251028215039_13EO3 BG000F 2025-10-30T12:47:54.073Z 2025-11-06T15:12:20.492Z
8296746 8296746 20251028214150_VAx2w BG000F 2025-10-30T12:47:45.452Z 2025-11-06T15:12:16.969Z
8296414 8296414 20251028204018_qWT3s BG000F 2025-10-30T12:47:09.498Z 2025-11-06T15:12:09.144Z
8288405 8288405 20251028172446_lzIDf BG000F 2025-10-30T12:10:14.900Z 2025-11-06T15:11:18.730Z
8256339 8256339 20251026012713_U8mrn BG000F 2025-10-28T12:29:30.394Z 2025-11-03T15:16:15.665Z
8255125 8255125 20251026004644_Iyhb2 BG000F 2025-10-28T12:28:09.186Z 2025-11-03T15:16:09.712Z
8254884 8254884 20251026003534_ufAKI BG000F 2025-10-28T12:27:40.811Z 2025-11-03T15:16:09.161Z
8233547 8233547 20251025225604_K0l3k BG000F 2025-10-27T12:13:32.150Z 2025-11-03T15:15:59.706Z
8211609 8211609 20251023213856_fAMBW BG000F 2025-10-26T12:24:04.138Z 2025-11-01T13:10:07.495Z
8211355 8211355 20251023205623_vP24o BG000F 2025-10-26T12:23:24.562Z 2025-11-01T13:10:03.673Z
8188671 8188671 20251022173346_lJ0dz BG000F 2025-10-24T12:05:12.662Z 2025-10-31T13:08:07.457Z
7799795 7799795 20250910005218_L2U3X BG000F 2025-09-11T12:06:02.822Z 2025-09-18T12:59:23.402Z
7799275 7799275 20250909225944_dWpUB BG000F 2025-09-11T12:04:02.491Z 2025-09-18T12:59:13.346Z
7790179 7790179 20250908005432_RQ69d BG000F 2025-09-09T12:06:05.260Z 2025-09-16T12:51:00.087Z
7761063 7761063 20250904001354_PDwrN BG000F 2025-09-05T12:15:02.410Z 2025-09-12T12:49:17.168Z
7749984 7749984 20250902224815_MWTWY BG000F 2025-09-04T12:12:06.968Z 2025-09-11T12:43:39.168Z
7749836 7749836 20250902221548_0Ac40 BG000F 2025-09-04T12:11:34.652Z 2025-09-11T12:43:38.129Z
7742461 7742461 20250902022454_16GSv BG000F 2025-09-03T12:22:23.850Z 2025-09-10T12:47:21.844Z
7738683 7738683 20250901221447_Bz3QA BG000F 2025-09-03T12:13:22.381Z 2025-09-10T12:45:52.528Z
7737439 7737439 20250901200032_xtnUr BG000F 2025-09-03T12:09:16.183Z 2025-09-10T12:45:25.313Z
7729031 7729031 20250901011032_D2hq3 BG000F 2025-09-02T12:24:14.445Z 2025-09-09T12:48:24.354Z
7728975 7728975 20250901010723_2rgzi BG000F 2025-09-02T12:24:04.764Z 2025-09-09T12:48:24.074Z
7704995 7704995 20250830011440_AplkG BG000F 2025-08-31T12:25:33.394Z 2025-09-07T12:58:31.874Z
7695836 7695836 20250829021008_sOKGx BG000F 2025-08-30T12:27:15.816Z 2025-09-06T14:13:09.996Z
7683559 7683559 20250828012347_6h1EK BG000F 2025-08-29T12:22:03.882Z 2025-09-05T13:05:30.044Z
7682987 7682987 20250828004601_gIG4B BG000F 2025-08-29T12:20:45.925Z 2025-09-05T13:05:25.784Z
7681060 7681060 20250827221011_OGB7Z BG000F 2025-08-29T12:16:17.537Z 2025-09-05T13:05:11.706Z
7680428 7680428 20250827210058_2A7ZE BG000F 2025-08-29T12:14:20.107Z 2025-09-05T13:04:59.407Z
7670475 7670475 20250826213845_uYyWW BG000F 2025-08-28T12:18:14.218Z 2025-09-04T12:55:56.935Z
7658608 7658608 20250825231313_RSk30 BG000F 2025-08-27T12:20:21.223Z 2025-09-03T12:52:36.860Z
7656687 7656687 20250825211348_Geav5 BG000F 2025-08-27T12:15:42.081Z 2025-09-03T12:52:13.862Z
7649346 7649346 20250825020251_G8MvV BG000F 2025-08-26T12:30:27.576Z 2025-09-02T12:52:10.029Z
7645066 7645066 20250824220625_CYQv3 BG000F 2025-08-26T12:22:07.907Z 2025-09-02T12:51:37.388Z
7636305 7636305 20250824012935_ziesJ BG000F 2025-08-25T12:27:46.566Z 2025-09-01T12:56:09.947Z
7625671 7625671 20250823015442_33AhK BG000F 2025-08-24T12:26:24.600Z 2025-08-31T12:54:16.537Z
7623744 7623744 20250822224619_JbVDO BG000F 2025-08-24T12:22:45.362Z 2025-08-31T12:54:00.473Z
7613361 7613361 20250822015046_9LAns BG000F 2025-08-23T12:25:31.960Z 2025-08-30T12:59:37.766Z
7612376 7612376 20250822004514_KAWFN BG000F 2025-08-23T12:23:57.774Z 2025-08-30T12:59:32.921Z
7599848 7599848 20250820221718_iQnNY BG000F 2025-08-22T12:22:21.656Z 2025-08-29T12:56:32.973Z
7599291 7599291 20250820211608_aMC3c BG000F 2025-08-22T12:21:17.827Z 2025-08-29T12:56:27.044Z
7574322 7574322 20250817231009_nxywO BG000F 2025-08-20T12:36:25.934Z 2025-08-25T12:52:10.056Z
7530723 7530723 20250816000150_XdU3L BG000F 2025-08-18T12:04:30.302Z 2025-08-24T12:47:30.040Z
7527622 7527622 20250814204458_B25IG BG000F 2025-08-17T12:48:13.908Z 2025-08-22T12:47:32.968Z
7513644 7513644 20250814224835_y5Z3t BG000F 2025-08-17T12:05:05.360Z 2025-08-23T12:48:16.559Z
7513316 7513316 20250814223924_lfhwZ BG000F 2025-08-17T12:04:06.961Z 2025-08-23T12:48:14.413Z
7505395 7505395 20250814011643_3xMLF BG000F 2025-08-16T12:49:08.746Z 2025-08-22T12:46:48.213Z
7505109 7505109 20250814010132_szXkv BG000F 2025-08-16T12:49:00.946Z 2025-08-22T12:46:47.338Z
7504726 7504726 20250814003927_3axQy BG000F 2025-08-16T12:48:50.724Z 2025-08-22T12:46:45.449Z
7504552 7504552 20250814002929_ctwX0 BG000F 2025-08-16T12:48:24.507Z 2025-08-22T12:46:44.906Z
7504182 7504182 20250814001008_FswlQ BG000F 2025-08-16T12:47:47.551Z 2025-08-22T12:46:44.005Z
7502931 7502931 20250813190756_B6Hm3 BG000F 2025-08-16T12:44:24.342Z 2025-08-21T12:48:23.973Z
7502759 7502759 20250813183225_r0Yf9 BG000F 2025-08-16T12:44:17.674Z 2025-08-21T12:48:23.560Z
7498585 7498585 20250813234758_OIBDl BG000F 2025-08-16T12:13:01.062Z 2025-08-22T12:46:43.306Z
7498447 7498447 20250813234143_iglrU BG000F 2025-08-16T12:12:45.572Z 2025-08-22T12:46:43.191Z
7498439 7498439 20250813234059_QqLLW BG000F 2025-08-16T12:12:45.220Z 2025-08-22T12:46:43.188Z
7497982 7497982 20250813232255_yv9B9 BG000F 2025-08-16T12:11:26.139Z 2025-08-22T12:46:42.415Z
7497383 7497383 20250813225236_kp3Hm BG000F 2025-08-16T12:09:36.702Z 2025-08-22T12:46:40.716Z
7475385 7475385 20250813021503_rVtYk BG000F 2025-08-14T12:35:55.349Z 2025-08-21T12:47:43.355Z
7475121 7475121 20250813020907_K0W3b BG000F 2025-08-14T12:35:43.724Z 2025-08-21T12:47:40.950Z
7474756 7474756 20250813015922_IA8Wk BG000F 2025-08-14T12:35:32.110Z 2025-08-21T12:47:40.445Z
7474636 7474636 20250813015634_JJdK5 BG000F 2025-08-14T12:35:30.752Z 2025-08-21T12:47:40.231Z
7473727 7473727 20250813013453_YoLLw BG000F 2025-08-14T12:34:58.652Z 2025-08-21T12:47:37.876Z
7473609 7473609 20250813013121_FpQj3 BG000F 2025-08-14T12:34:50.908Z 2025-08-21T12:47:37.606Z
7464579 7464579 20250813010713_qtvtY BG000F 2025-08-14T12:15:01.340Z 2025-08-21T12:47:33.814Z
7463010 7463010 20250813003221_F3fkb BG000F 2025-08-14T12:13:44.658Z 2025-08-21T12:47:30.624Z
7462676 7462676 20250813002530_sdxjN BG000F 2025-08-14T12:13:19.632Z 2025-08-21T12:47:30.216Z
7461768 7461768 20250813000500_SNv63 BG000F 2025-08-14T12:12:17.911Z 2025-08-21T12:47:28.897Z
7459603 7459603 20250812231126_A22Id BG000F 2025-08-14T12:09:50.522Z 2025-08-21T12:47:25.118Z
7459525 7459525 20250812230915_zdTOz BG000F 2025-08-14T12:09:40.508Z 2025-08-21T12:47:25.000Z
7459416 7459416 20250812230647_8pTlj BG000F 2025-08-14T12:09:34.742Z 2025-08-21T12:47:24.858Z
7458477 7458477 20250812224327_nfeq9 BG000F 2025-08-14T12:08:25.182Z 2025-08-21T12:47:21.317Z
7456112 7456112 20250812214852_WTPzU BG000F 2025-08-14T12:06:08.188Z 2025-08-21T12:47:12.727Z
7455587 7455587 20250812213621_ADLOv BG000F 2025-08-14T12:05:25.790Z 2025-08-21T12:47:11.504Z
7454942 7454942 20250812212152_CMcjz BG000F 2025-08-14T12:04:38.714Z 2025-08-21T12:47:08.922Z
7453529 7453529 20250812203527_pKKUE BG000F 2025-08-14T12:01:51.618Z 2025-08-21T12:47:03.311Z
7448946 7448946 20250812011441_WIeCW BG000F 2025-08-13T12:15:01.395Z 2025-08-20T13:06:03.551Z
7443291 7443291 20250811205355_rPfjy BG000F 2025-08-13T12:04:03.202Z 2025-08-20T13:05:47.736Z
7432257 7432257 20250811000555_TGti2 BG000F 2025-08-12T12:10:47.770Z 2025-08-18T13:38:53.301Z
7428189 7428189 20250810194922_bpGEQ BG000F 2025-08-12T12:01:18.673Z 2025-08-18T13:36:57.288Z

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