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

610 rows where station_code = "BG000H" 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
8683483 8683483 20251202031802_FKAKJ BG000H 2025-12-04T14:25:41.281Z 2025-12-06T14:34:17.343Z
8683481 8683481 20251202031129_Fd343 BG000H 2025-12-04T14:25:40.337Z 2025-12-06T14:34:16.626Z
8683467 8683467 20251202014652_XDud3 BG000H 2025-12-04T14:25:14.993Z 2025-12-06T14:34:01.559Z
8673853 8673853 20251202000046_x4EVW BG000H 2025-12-03T14:20:11.691Z 2025-12-06T14:33:38.024Z
8673825 8673825 20251201235134_7Q6Qc BG000H 2025-12-03T14:20:08.537Z 2025-12-06T14:33:36.588Z
8673794 8673794 20251201232612_Xrlgd BG000H 2025-12-03T14:20:03.878Z 2025-12-06T14:33:35.167Z
8673755 8673755 20251201222932_UxUBx BG000H 2025-12-03T14:19:57.896Z 2025-12-06T14:33:31.957Z
8665776 8665776 20251201035707_AyYkq BG000H 2025-12-02T14:24:27.807Z 2025-12-06T14:42:02.718Z
8608819 8608819 20251125225014_pGn2V BG000H 2025-11-27T14:16:56.043Z 2025-12-04T15:07:48.995Z
8598703 8598703 20251125012028_lRcUc BG000H 2025-11-26T14:19:30.896Z 2025-12-02T15:08:05.994Z
8597728 8597728 20251125000534_vDTuD BG000H 2025-11-26T14:17:29.106Z 2025-12-02T15:07:40.266Z
8596053 8596053 20251124192958_31BGT BG000H 2025-11-26T14:13:25.455Z 2025-12-02T15:06:28.856Z
8595710 8595710 20251124180449_YMEjo BG000H 2025-11-26T14:12:16.271Z 2025-12-02T15:06:05.869Z
8589965 8589965 20251124021213_3YFFl BG000H 2025-11-25T14:21:01.726Z 2025-12-02T15:12:40.694Z
8566748 8566748 20251122021015_0lfUJ BG000H 2025-11-23T14:17:15.392Z 2025-11-30T15:06:07.262Z
8507941 8507941 20251118001307_sxTyi BG000H 2025-11-19T14:16:24.445Z 2025-11-26T15:07:48.511Z
8507885 8507885 20251118000828_j5G3L BG000H 2025-11-19T14:16:16.501Z 2025-11-26T15:07:48.258Z
8494387 8494387 20251117024239_rVfeZ BG000H 2025-11-18T14:24:09.728Z 2025-11-25T15:09:35.773Z
8492800 8492800 20251117005309_DxZNY BG000H 2025-11-18T14:20:34.207Z 2025-11-25T15:08:56.998Z
8481567 8481567 20251116033252_lr2Ur BG000H 2025-11-17T14:21:20.602Z 2025-11-24T15:05:04.483Z
8480704 8480704 20251115230825_08SDC BG000H 2025-11-17T14:18:51.384Z 2025-11-24T15:04:55.425Z
8467490 8467490 20251114202415_6cNGx BG000H 2025-11-16T14:14:45.239Z 2025-11-23T15:17:09.565Z
8467009 8467009 20251114192652_Y5WxN BG000H 2025-11-16T14:13:31.252Z 2025-11-23T15:17:06.169Z
8465463 8465463 20251114163419_d9E4Y BG000H 2025-11-16T14:09:18.039Z 2025-11-23T15:16:56.197Z
8459376 8459376 20251114033600_Mo1HB BG000H 2025-11-15T14:19:31.888Z 2025-11-22T15:21:53.556Z
8459213 8459213 20251114031155_NihVc BG000H 2025-11-15T14:19:06.053Z 2025-11-22T15:21:43.046Z
8458270 8458270 20251113232642_30HGc BG000H 2025-11-15T14:16:05.241Z 2025-11-22T15:21:01.125Z
8458145 8458145 20251113224155_W3jxm BG000H 2025-11-15T14:15:43.558Z 2025-11-22T15:20:59.434Z
8457877 8457877 20251113213853_xvit0 BG000H 2025-11-15T14:14:50.297Z 2025-11-22T15:20:55.763Z
8457522 8457522 20251113203708_Qi8Fj BG000H 2025-11-15T14:13:44.682Z 2025-11-22T15:20:52.132Z
8457111 8457111 20251113195249_M02sv BG000H 2025-11-15T14:12:52.290Z 2025-11-22T15:20:49.221Z
8456089 8456089 20251113180534_XvlZd BG000H 2025-11-15T14:10:29.628Z 2025-11-22T15:20:39.149Z
8449273 8449273 20251113014039_Y9z6v BG000H 2025-11-14T14:19:53.353Z 2025-11-21T15:11:57.336Z
8449266 8449266 20251113014004_VnGhN BG000H 2025-11-14T14:19:52.805Z 2025-11-21T15:11:57.227Z
8448857 8448857 20251113003138_Gmn8f BG000H 2025-11-14T14:18:45.612Z 2025-11-21T15:11:40.057Z
8447941 8447941 20251112212609_q1n5b BG000H 2025-11-14T14:15:40.318Z 2025-11-21T15:11:23.263Z
8447690 8447690 20251112202540_ip4Jx BG000H 2025-11-14T14:14:50.637Z 2025-11-21T15:11:20.148Z
8447611 8447611 20251112201230_qLeWa BG000H 2025-11-14T14:14:40.843Z 2025-11-21T15:11:19.619Z
8447253 8447253 20251112192137_c3zdn BG000H 2025-11-14T14:13:29.227Z 2025-11-21T15:11:17.357Z
8446836 8446836 20251112182159_2lQSq BG000H 2025-11-14T14:12:05.557Z 2025-11-21T15:11:14.021Z
8365445 8365445 20251103031415_diAHm BG000H 2025-11-04T14:20:28.235Z 2025-11-11T15:07:20.777Z
8365372 8365372 20251103025044_QSsbE BG000H 2025-11-04T14:20:15.638Z 2025-11-11T15:07:00.924Z
8365351 8365351 20251103024604_PSEep BG000H 2025-11-04T14:20:12.931Z 2025-11-11T15:06:54.702Z
8365312 8365312 20251103023514_DBr3X BG000H 2025-11-04T14:20:06.899Z 2025-11-11T15:06:48.424Z
8365030 8365030 20251103012353_2ApTv BG000H 2025-11-04T14:18:58.108Z 2025-11-11T15:06:27.571Z
8364826 8364826 20251103004637_a3Vo6 BG000H 2025-11-04T14:18:20.697Z 2025-11-11T15:06:22.050Z
8334528 8334528 20251031020028_5S6UW BG000H 2025-11-02T14:25:20.724Z 2025-11-08T15:13:41.005Z
8331866 8331866 20251101032929_kmsUm BG000H 2025-11-02T14:11:52.619Z 2025-11-09T15:03:19.327Z
8331745 8331745 20251101030355_3M04J BG000H 2025-11-02T14:11:26.377Z 2025-11-09T15:03:14.238Z
8331675 8331675 20251101024833_wKPSN BG000H 2025-11-02T14:11:08.776Z 2025-11-09T15:03:06.270Z
8331353 8331353 20251101015153_R0wfB BG000H 2025-11-02T14:09:58.299Z 2025-11-09T15:01:59.246Z
8331006 8331006 20251101005648_Hs0wY BG000H 2025-11-02T14:08:39.617Z 2025-11-09T15:00:51.489Z
8330873 8330873 20251101003200_GAlib BG000H 2025-11-02T14:08:07.756Z 2025-11-09T15:00:44.174Z
8330441 8330441 20251031225637_wNZwJ BG000H 2025-11-02T14:06:36.741Z 2025-11-09T15:00:29.716Z
8319626 8319626 20251030021701_bSyVi BG000H 2025-11-01T12:25:03.501Z 2025-11-07T15:13:43.495Z
8319505 8319505 20251030021057_ySFNt BG000H 2025-11-01T12:24:51.893Z 2025-11-07T15:13:42.475Z
8319205 8319205 20251030015557_ugGTm BG000H 2025-11-01T12:24:13.329Z 2025-11-07T15:13:36.524Z
8319058 8319058 20251030014830_6CFJL BG000H 2025-11-01T12:23:43.336Z 2025-11-07T15:13:34.519Z
8316439 8316439 20251030170427_cbwAH BG000H 2025-11-01T12:05:43.460Z 2025-11-08T15:10:32.331Z
8314439 8314439 20251030005544_MCH1c BG000H 2025-10-31T12:39:06.571Z 2025-11-07T15:13:21.703Z
8314403 8314403 20251030005238_BSlyU BG000H 2025-10-31T12:39:04.493Z 2025-11-07T15:13:20.789Z
8313087 8313087 20251029235215_KoWjI BG000H 2025-10-31T12:37:28.156Z 2025-11-07T15:12:27.632Z
8313078 8313078 20251029235044_hyiXU BG000H 2025-10-31T12:37:27.408Z 2025-11-07T15:12:27.453Z
8312900 8312900 20251029233929_amSKa BG000H 2025-10-31T12:37:05.848Z 2025-11-07T15:12:19.965Z
8311912 8311912 20251029223503_7ZmHd BG000H 2025-10-31T12:36:29.975Z 2025-11-07T15:11:33.595Z
8311886 8311886 20251029223257_BxetV BG000H 2025-10-31T12:36:27.334Z 2025-11-07T15:11:33.264Z
8311289 8311289 20251029214231_9ErmH BG000H 2025-10-31T12:35:34.558Z 2025-11-07T15:11:27.237Z
8310537 8310537 20251029200623_ISMe9 BG000H 2025-10-31T12:34:35.324Z 2025-11-07T15:11:00.048Z
8310503 8310503 20251029200218_B3K5E BG000H 2025-10-31T12:34:33.844Z 2025-10-31T12:34:33.844Z
8299658 8299658 20251029033746_ryNZ4 BG000H 2025-10-30T12:52:07.423Z 2025-11-06T15:13:49.524Z
8298869 8298869 20251029021708_ph53i BG000H 2025-10-30T12:51:40.716Z 2025-11-06T15:13:21.612Z
8298804 8298804 20251029020855_svPJT BG000H 2025-10-30T12:51:38.285Z 2025-11-06T15:13:20.114Z
8298584 8298584 20251029013537_AUfm8 BG000H 2025-10-30T12:51:18.574Z 2025-11-06T15:13:01.079Z
8298509 8298509 20251029012607_oJsIT BG000H 2025-10-30T12:51:09.953Z 2025-11-06T15:12:57.723Z
8298365 8298365 20251029010734_hV3JJ BG000H 2025-10-30T12:50:57.748Z 2025-11-06T15:12:52.607Z
8298289 8298289 20251029005930_F99eh BG000H 2025-10-30T12:50:47.570Z 2025-11-06T15:12:49.598Z
8297921 8297921 20251029001958_mnhzJ BG000H 2025-10-30T12:49:47.523Z 2025-11-06T15:12:39.060Z
8297868 8297868 20251029001418_DA5P7 BG000H 2025-10-30T12:49:40.731Z 2025-11-06T15:12:37.869Z
8297732 8297732 20251028235553_t9KEN BG000H 2025-10-30T12:49:33.137Z 2025-11-06T15:12:34.820Z
8297680 8297680 20251028235102_8DMTq BG000H 2025-10-30T12:49:31.767Z 2025-11-06T15:12:33.603Z
8297326 8297326 20251028231008_8pJhD BG000H 2025-10-30T12:49:18.019Z 2025-11-06T15:12:27.359Z
8297252 8297252 20251028230259_Y4fMm BG000H 2025-10-30T12:49:15.341Z 2025-11-06T15:12:26.906Z
8296859 8296859 20251028220518_JTAB4 BG000H 2025-10-30T12:48:16.916Z 2025-11-06T15:12:23.532Z
8296630 8296630 20251028212254_IwFUz BG000H 2025-10-30T12:47:30.149Z 2025-11-06T15:12:11.030Z
8296284 8296284 20251028201806_8JfPX BG000H 2025-10-30T12:47:02.596Z 2025-11-06T15:12:08.020Z
8289659 8289659 20251028185848_p9yKn BG000H 2025-10-30T12:14:16.913Z 2025-11-06T15:12:00.735Z
8289271 8289271 20251028183047_2JqfT BG000H 2025-10-30T12:13:02.974Z 2025-11-06T15:11:50.068Z
8279456 8279456 20251027212217_8RJ2N BG000H 2025-10-29T12:36:55.277Z 2025-11-05T15:20:41.577Z
8256444 8256444 20251026013002_XEt7t BG000H 2025-10-28T12:29:32.750Z 2025-11-03T15:16:15.887Z
8256003 8256003 20251026011619_3Nvcu BG000H 2025-10-28T12:29:15.002Z 2025-11-03T15:16:13.120Z
8254885 8254885 20251026003534_ufAKI BG000H 2025-10-28T12:27:40.811Z 2025-11-03T15:16:09.161Z
8234858 8234858 20251026000830_J98AS BG000H 2025-10-27T12:16:30.089Z 2025-11-03T15:16:04.744Z
8234028 8234028 20251025232350_R8dWc BG000H 2025-10-27T12:14:43.745Z 2025-11-03T15:16:01.557Z
8232549 8232549 20251025212258_YMLLv BG000H 2025-10-27T12:11:02.707Z 2025-11-03T15:15:52.905Z
8231864 8231864 20251025193932_QzyZD BG000H 2025-10-27T12:09:10.786Z 2025-11-03T15:15:48.273Z
8210844 8210844 20251023200439_GD2W3 BG000H 2025-10-26T12:22:14.291Z 2025-11-01T13:10:00.198Z
8210591 8210591 20251023193737_i7ar1 BG000H 2025-10-26T12:21:33.189Z 2025-11-01T13:09:57.523Z
8210587 8210587 20251023193736_jeMu0 BG000H 2025-10-26T12:21:32.820Z 2025-11-01T13:09:55.103Z
8189633 8189633 20251022233357_1zBlY BG000H 2025-10-24T12:09:00.006Z 2025-10-31T13:08:26.563Z
8188995 8188995 20251022184718_GQV3G BG000H 2025-10-24T12:06:25.471Z 2025-10-31T13:08:11.033Z

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