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

2,303 rows where station_code = "BG0005" 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
8683462 8683462 20251202002316_I3aCt BG0005 2025-12-04T14:24:55.006Z 2025-12-06T14:33:41.920Z
8673878 8673878 20251202001205_WVbtt BG0005 2025-12-03T14:20:13.642Z 2025-12-06T14:33:38.794Z
8673852 8673852 20251202000046_x4EVW BG0005 2025-12-03T14:20:11.670Z 2025-12-06T14:33:38.024Z
8598702 8598702 20251125012028_lRcUc BG0005 2025-11-26T14:19:30.896Z 2025-12-02T15:08:05.994Z
8597556 8597556 20251124234638_TMWQV BG0005 2025-11-26T14:17:08.102Z 2025-12-02T15:07:37.617Z
8591517 8591517 20251124042155_AGUIX BG0005 2025-11-25T14:24:28.744Z 2025-12-02T15:12:59.097Z
8590623 8590623 20251124025844_23ERY BG0005 2025-11-25T14:22:18.635Z 2025-12-02T15:12:53.135Z
8590036 8590036 20251124021735_qE2IR BG0005 2025-11-25T14:21:09.319Z 2025-12-02T15:12:41.540Z
8589963 8589963 20251124021213_3YFFl BG0005 2025-11-25T14:21:01.726Z 2025-12-02T15:12:40.693Z
8589350 8589350 20251124012632_ilfe6 BG0005 2025-11-25T14:19:43.426Z 2025-12-02T15:12:20.323Z
8589339 8589339 20251124012522_6bJMq BG0005 2025-11-25T14:19:42.224Z 2025-12-02T15:12:20.229Z
8588943 8588943 20251124004658_FlNFH BG0005 2025-11-25T14:18:48.201Z 2025-12-02T15:12:02.947Z
8588851 8588851 20251124003648_oQuiv BG0005 2025-11-25T14:18:25.517Z 2025-12-02T15:11:56.804Z
8588172 8588172 20251123232926_meFeb BG0005 2025-11-25T14:17:00.063Z 2025-12-02T15:11:33.322Z
8588151 8588151 20251123232841_akKcj BG0005 2025-11-25T14:16:58.918Z 2025-12-02T15:11:30.532Z
8588002 8588002 20251123231212_qla8D BG0005 2025-11-25T14:16:34.031Z 2025-12-02T15:11:23.773Z
8585983 8585983 20251123182336_uNNh5 BG0005 2025-11-25T14:11:33.149Z 2025-12-02T15:10:38.951Z
8585907 8585907 20251123181602_J8YN2 BG0005 2025-11-25T14:11:18.422Z 2025-12-02T15:10:38.090Z
8585545 8585545 20251123165937_y6b4x BG0005 2025-11-25T14:10:02.718Z 2025-12-02T15:10:02.841Z
8468579 8468579 20251115003804_EM3GE BG0005 2025-11-16T14:17:59.829Z 2025-11-23T15:17:18.248Z
8468560 8468560 20251115003434_pdGRE BG0005 2025-11-16T14:17:57.587Z 2025-11-23T15:17:17.695Z
8466834 8466834 20251114190719_NwReM BG0005 2025-11-16T14:13:13.221Z 2025-11-23T15:17:05.233Z
8466524 8466524 20251114183601_GDUvs BG0005 2025-11-16T14:12:22.900Z 2025-11-23T15:17:03.391Z
8466327 8466327 20251114182028_suOcB BG0005 2025-11-16T14:11:51.702Z 2025-11-23T15:17:02.259Z
8466261 8466261 20251114181218_0mqKW BG0005 2025-11-16T14:11:41.532Z 2025-11-23T15:17:01.835Z
8458511 8458511 20251114002832_s0oKh BG0005 2025-11-15T14:17:00.799Z 2025-11-22T15:21:09.032Z
8455598 8455598 20251113171617_v2lys BG0005 2025-11-15T14:09:24.552Z 2025-11-22T15:20:19.597Z
8449643 8449643 20251113023900_Ihz0d BG0005 2025-11-14T14:21:03.527Z 2025-11-21T15:12:11.050Z
8449575 8449575 20251113022442_DvJnU BG0005 2025-11-14T14:20:55.501Z 2025-11-21T15:12:09.049Z
8449558 8449558 20251113022158_daR5v BG0005 2025-11-14T14:20:52.807Z 2025-11-21T15:12:08.752Z
8449403 8449403 20251113020539_PL3nS BG0005 2025-11-14T14:20:21.962Z 2025-11-21T15:11:59.543Z
8449265 8449265 20251113014004_VnGhN BG0005 2025-11-14T14:19:52.805Z 2025-11-21T15:11:57.227Z
8446974 8446974 20251112184545_6u88e BG0005 2025-11-14T14:12:36.704Z 2025-11-21T15:11:15.135Z
8446970 8446970 20251112184502_CRxN2 BG0005 2025-11-14T14:12:35.952Z 2025-11-21T15:11:15.063Z
8438981 8438981 20251112025947_ik6rI BG0005 2025-11-13T14:25:16.450Z 2025-11-20T15:24:55.456Z
8438729 8438729 20251112023148_z31z0 BG0005 2025-11-13T14:24:34.076Z 2025-11-20T15:24:46.371Z
8438559 8438559 20251112021156_gJKK6 BG0005 2025-11-13T14:24:05.884Z 2025-11-20T15:24:40.033Z
8438520 8438520 20251112020824_CwRQL BG0005 2025-11-13T14:23:58.266Z 2025-11-20T15:24:38.325Z
8438254 8438254 20251112014013_lM5wM BG0005 2025-11-13T14:23:12.442Z 2025-11-20T15:24:21.861Z
8437920 8437920 20251112005637_JMldZ BG0005 2025-11-13T14:22:18.648Z 2025-11-20T15:24:00.786Z
8437684 8437684 20251112003354_SnoJE BG0005 2025-11-13T14:21:47.641Z 2025-11-20T15:23:50.376Z
8437535 8437535 20251112001637_1mBDy BG0005 2025-11-13T14:21:17.028Z 2025-11-20T15:23:42.388Z
8437346 8437346 20251111235258_33Azd BG0005 2025-11-13T14:20:53.947Z 2025-11-20T15:23:28.498Z
8368781 8368781 20251103161852_50Vto BG0005 2025-11-05T14:03:48.235Z 2025-11-12T15:08:40.697Z
8365162 8365162 20251103020131_KYQOJ BG0005 2025-11-04T14:19:26.041Z 2025-11-11T15:06:31.118Z
8365029 8365029 20251103012353_2ApTv BG0005 2025-11-04T14:18:58.108Z 2025-11-11T15:06:27.571Z
8364953 8364953 20251103011222_2T37J BG0005 2025-11-04T14:18:49.624Z 2025-11-11T15:06:24.822Z
8364825 8364825 20251103004637_a3Vo6 BG0005 2025-11-04T14:18:20.697Z 2025-11-11T15:06:22.050Z
8364802 8364802 20251103004043_AJGCQ BG0005 2025-11-04T14:18:18.249Z 2025-11-11T15:06:21.625Z
8353782 8353782 20251102034857_d2s3f BG0005 2025-11-03T14:19:33.333Z 2025-11-10T15:08:41.489Z
8353734 8353734 20251102034043_mwa0J BG0005 2025-11-03T14:19:27.208Z 2025-11-10T15:08:32.646Z
8353515 8353515 20251102025830_4hz3o BG0005 2025-11-03T14:18:40.191Z 2025-11-10T15:08:09.853Z
8353369 8353369 20251102023339_QLILU BG0005 2025-11-03T14:18:10.368Z 2025-11-10T15:07:51.513Z
8349509 8349509 20251101182712_gSkrT BG0005 2025-11-03T14:07:32.159Z 2025-11-10T15:04:47.492Z
8333215 8333215 20251030234735_2sEbv BG0005 2025-11-02T14:22:02.538Z 2025-11-08T15:12:49.811Z
8331410 8331410 20251101020341_aydjS BG0005 2025-11-02T14:10:13.706Z 2025-11-09T15:02:09.663Z
8331312 8331312 20251101014639_fFoGS BG0005 2025-11-02T14:09:41.055Z 2025-11-09T15:01:44.779Z
8331199 8331199 20251101013024_4MB2Q BG0005 2025-11-02T14:09:20.140Z 2025-11-09T15:01:23.813Z
8331197 8331197 20251101013024_jgcO2 BG0005 2025-11-02T14:09:19.928Z 2025-11-09T15:01:23.619Z
8331099 8331099 20251101011316_5DtZy BG0005 2025-11-02T14:08:56.819Z 2025-11-09T15:01:03.044Z
8330882 8330882 20251101003235_N3aRJ BG0005 2025-11-02T14:08:09.753Z 2025-11-09T15:00:44.465Z
8330258 8330258 20251031220009_RYk2Z BG0005 2025-11-02T14:05:54.828Z 2025-11-09T15:00:21.469Z
8330175 8330175 20251031212735_wqMkq BG0005 2025-11-02T14:05:38.536Z 2025-11-09T15:00:13.939Z
8290150 8290150 20251028193838_CvEIM BG0005 2025-10-30T12:15:56.762Z 2025-11-06T15:12:04.569Z
8288881 8288881 20251028180430_Xzmbx BG0005 2025-10-30T12:11:45.575Z 2025-11-06T15:11:34.384Z
8288237 8288237 20251028170921_fML34 BG0005 2025-10-30T12:09:43.345Z 2025-11-06T15:11:05.646Z
8288003 8288003 20251028164515_QwI9c BG0005 2025-10-30T12:08:55.572Z 2025-11-06T15:10:55.696Z
8287856 8287856 20251028162815_FJhVD BG0005 2025-10-30T12:08:30.532Z 2025-11-06T15:10:54.150Z
8231510 8231510 20251025184959_SAK0s BG0005 2025-10-27T12:08:05.316Z 2025-11-03T15:15:39.968Z
8231380 8231380 20251025182804_yyPjJ BG0005 2025-10-27T12:07:38.255Z 2025-11-03T15:15:38.389Z
8231273 8231273 20251025181042_MyWI4 BG0005 2025-10-27T12:07:16.378Z 2025-11-03T15:15:37.325Z
8231231 8231231 20251025180255_uzIqL BG0005 2025-10-27T12:07:06.642Z 2025-11-03T15:15:36.353Z
8188996 8188996 20251022184830_eNv90 BG0005 2025-10-24T12:06:26.049Z 2025-10-31T13:08:11.054Z
8188992 8188992 20251022184718_GQV3G BG0005 2025-10-24T12:06:25.471Z 2025-10-31T13:08:11.032Z
8188485 8188485 20251022164532_jamaL BG0005 2025-10-24T12:04:25.308Z 2025-10-31T13:08:01.995Z
8156723 8156723 20251020031119_SRAb4 BG0005 2025-10-21T12:16:42.548Z 2025-10-28T13:08:44.196Z
8119284 8119284 20251016173658_E3qzT BG0005 2025-10-18T12:12:29.051Z 2025-10-25T13:25:39.707Z
8112729 8112729 20251016034018_Jjcqg BG0005 2025-10-17T12:13:30.095Z 2025-10-24T13:16:48.327Z
8093958 8093958 20251010230951_3xSde BG0005 2025-10-14T12:22:06.703Z 2025-10-19T12:49:55.077Z
8093956 8093956 20251010203011_ZN2FR BG0005 2025-10-14T12:21:56.476Z 2025-10-19T12:49:46.388Z
8078864 8078864 20251010031835_rmsxI BG0005 2025-10-11T12:10:15.413Z 2025-10-18T13:00:08.636Z
8078537 8078537 20251010014546_e2uwE BG0005 2025-10-11T12:09:06.188Z 2025-10-18T13:00:04.126Z
8078518 8078518 20251010013958_TFEh0 BG0005 2025-10-11T12:08:55.831Z 2025-10-18T13:00:03.891Z
8078111 8078111 20251009232042_jCFZj BG0005 2025-10-11T12:07:20.335Z 2025-10-18T12:59:55.850Z
8078058 8078058 20251009224313_AzjY0 BG0005 2025-10-11T12:07:10.292Z 2025-10-18T12:59:55.246Z
8077984 8077984 20251009214505_NN0CX BG0005 2025-10-11T12:06:48.331Z 2025-10-18T12:59:54.575Z
8077857 8077857 20251009194254_6qJOV BG0005 2025-10-11T12:06:07.200Z 2025-10-18T12:59:49.434Z
8077727 8077727 20251009165239_fDEnt BG0005 2025-10-11T12:05:19.651Z 2025-10-18T12:59:39.930Z
8066203 8066203 20251005031457_mpNK2 BG0005 2025-10-07T12:32:44.471Z 2025-10-13T12:33:56.372Z
8065814 8065814 20251005023413_Ml2vV BG0005 2025-10-07T12:31:59.534Z 2025-10-13T12:33:52.835Z
8065763 8065763 20251005022429_e3z0l BG0005 2025-10-07T12:31:53.041Z 2025-10-13T12:33:52.288Z
8065699 8065699 20251005021206_ZySPW BG0005 2025-10-07T12:31:25.720Z 2025-10-13T12:33:51.852Z
8065659 8065659 20251005020741_xfP30 BG0005 2025-10-07T12:31:21.227Z 2025-10-13T12:33:51.346Z
8064880 8064880 20251004225114_5pWBZ BG0005 2025-10-07T12:29:58.483Z 2025-10-13T12:33:39.317Z
8064875 8064875 20251004224824_s6OyT BG0005 2025-10-07T12:29:49.601Z 2025-10-13T12:33:39.294Z
8064797 8064797 20251004223037_oiaRH BG0005 2025-10-07T12:29:28.000Z 2025-10-13T12:33:33.778Z
8027606 8027606 20250930225124_mXYsB BG0005 2025-10-02T12:24:17.269Z 2025-10-09T12:38:20.847Z
8027468 8027468 20250930223620_yqJui BG0005 2025-10-02T12:23:45.720Z 2025-10-09T12:38:17.397Z
8027327 8027327 20250930222221_ZCAc2 BG0005 2025-10-02T12:23:31.294Z 2025-10-09T12:38:14.289Z
8027174 8027174 20250930220032_oGmOh BG0005 2025-10-02T12:23:01.219Z 2025-10-09T12:38:11.458Z

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