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

4,509 rows where station_code = "BG000G" 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
8683477 8683477 20251202023156_7ulRh BG000G 2025-12-04T14:25:27.801Z 2025-12-06T14:34:09.995Z
8683473 8683473 20251202021956_BAoGr BG000G 2025-12-04T14:25:25.174Z 2025-12-06T14:34:08.660Z
8683471 8683471 20251202021040_MXHPg BG000G 2025-12-04T14:25:20.832Z 2025-12-06T14:34:06.015Z
8683469 8683469 20251202015807_beIo8 BG000G 2025-12-04T14:25:18.593Z 2025-12-06T14:34:03.445Z
8683432 8683432 20251201201034_kYFWK BG000G 2025-12-04T14:24:28.267Z 2025-12-06T14:33:23.660Z
8683415 8683415 20251201191748_oy9vx BG000G 2025-12-04T14:24:19.363Z 2025-12-06T14:33:09.777Z
8683387 8683387 20251201180341_G47CB BG000G 2025-12-04T14:23:56.651Z 2025-12-06T14:32:56.117Z
8673879 8673879 20251202001205_WVbtt BG000G 2025-12-03T14:20:13.642Z 2025-12-06T14:33:38.794Z
8673788 8673788 20251201231240_qcDnq BG000G 2025-12-03T14:20:02.977Z 2025-12-06T14:33:34.376Z
8673244 8673244 20251201174659_9kWOa BG000G 2025-12-03T14:18:04.936Z 2025-12-06T14:32:52.758Z
8665798 8665798 20251201035922_wtU3d BG000G 2025-12-02T14:24:30.096Z 2025-12-06T14:42:03.689Z
8665313 8665313 20251201030702_n69p3 BG000G 2025-12-02T14:23:23.474Z 2025-12-06T14:41:34.409Z
8607695 8607695 20251125211326_ty1ug BG000G 2025-11-27T14:14:21.886Z 2025-12-04T15:07:16.807Z
8607450 8607450 20251125205152_56Cng BG000G 2025-11-27T14:13:41.426Z 2025-12-04T15:07:02.242Z
8607296 8607296 20251125203747_JmNMS BG000G 2025-11-27T14:13:10.004Z 2025-12-04T15:06:59.994Z
8597326 8597326 20251124232610_o5XTr BG000G 2025-11-26T14:16:40.247Z 2025-12-02T15:07:28.255Z
8597231 8597231 20251124231531_si5CX BG000G 2025-11-26T14:16:24.678Z 2025-12-02T15:07:27.321Z
8597229 8597229 20251124231513_tcKuC BG000G 2025-11-26T14:16:24.514Z 2025-12-02T15:07:27.258Z
8596988 8596988 20251124224241_TESC1 BG000G 2025-11-26T14:15:51.446Z 2025-12-02T15:07:22.174Z
8596825 8596825 20251124221321_bQQp2 BG000G 2025-11-26T14:15:24.110Z 2025-12-02T15:07:15.164Z
8596216 8596216 20251124202302_Es1iN BG000G 2025-11-26T14:13:59.230Z 2025-12-02T15:06:49.585Z
8596188 8596188 20251124201741_KQcgH BG000G 2025-11-26T14:13:55.747Z 2025-12-02T15:06:49.165Z
8596112 8596112 20251124200042_3Oq2n BG000G 2025-11-26T14:13:35.002Z 2025-12-02T15:06:41.049Z
8595716 8595716 20251124180600_fN7t2 BG000G 2025-11-26T14:12:17.282Z 2025-12-02T15:06:06.228Z
8595645 8595645 20251124173713_KRa8q BG000G 2025-11-26T14:11:53.380Z 2025-12-02T15:06:04.371Z
8595530 8595530 20251124164045_SpfPS BG000G 2025-11-26T14:11:33.441Z 2025-12-02T15:06:00.868Z
8590855 8590855 20251124032303_L1V2z BG000G 2025-11-25T14:22:56.350Z 2025-12-02T15:12:55.851Z
8590587 8590587 20251124025500_mgFZi BG000G 2025-11-25T14:22:15.758Z 2025-12-02T15:12:50.439Z
8590310 8590310 20251124023345_qXZXR BG000G 2025-11-25T14:21:39.271Z 2025-12-02T15:12:46.261Z
8590064 8590064 20251124021852_ruuX4 BG000G 2025-11-25T14:21:20.234Z 2025-12-02T15:12:41.708Z
8589907 8589907 20251124020341_BvH4p BG000G 2025-11-25T14:20:54.421Z 2025-12-02T15:12:39.903Z
8589313 8589313 20251124012338_Z1dk2 BG000G 2025-11-25T14:19:38.012Z 2025-12-02T15:12:18.901Z
8589283 8589283 20251124012031_OVSwR BG000G 2025-11-25T14:19:35.758Z 2025-12-02T15:12:17.277Z
8588968 8588968 20251124004900_XKXOa BG000G 2025-11-25T14:18:50.068Z 2025-12-02T15:12:03.138Z
8588577 8588577 20251124001041_yu84p BG000G 2025-11-25T14:17:48.935Z 2025-12-02T15:11:49.330Z
8588370 8588370 20251123234942_2A65F BG000G 2025-11-25T14:17:27.998Z 2025-12-02T15:11:41.082Z
8588215 8588215 20251123233330_ONqjw BG000G 2025-11-25T14:17:05.110Z 2025-12-02T15:11:34.106Z
8587781 8587781 20251123224315_o228X BG000G 2025-11-25T14:16:02.640Z 2025-12-02T15:11:19.763Z
8587084 8587084 20251123212014_ACMiY BG000G 2025-11-25T14:14:32.287Z 2025-12-02T15:11:06.390Z
8586647 8586647 20251123202413_iHVnm BG000G 2025-11-25T14:13:32.464Z 2025-12-02T15:10:56.724Z
8585925 8585925 20251123181728_NgXFl BG000G 2025-11-25T14:11:19.819Z 2025-12-02T15:10:38.280Z
8577944 8577944 20251122191513_JBRV6 BG000G 2025-11-24T14:10:13.482Z 2025-12-01T15:19:03.900Z
8577585 8577585 20251122183349_kLn2m BG000G 2025-11-24T14:09:06.198Z 2025-12-01T15:18:54.544Z
8566613 8566613 20251122013050_wNFoj BG000G 2025-11-23T14:16:42.212Z 2025-11-30T15:05:55.595Z
8566605 8566605 20251122012531_0En4B BG000G 2025-11-23T14:16:41.155Z 2025-11-30T15:05:54.912Z
8566569 8566569 20251122011538_cxUUt BG000G 2025-11-23T14:16:35.653Z 2025-11-30T15:05:52.839Z
8566508 8566508 20251122005536_Jhwf6 BG000G 2025-11-23T14:16:27.138Z 2025-11-30T15:05:50.858Z
8566311 8566311 20251122000549_DjzG5 BG000G 2025-11-23T14:15:43.738Z 2025-11-30T15:05:41.866Z
8481641 8481641 20251116034302_eJdY6 BG000G 2025-11-17T14:21:28.511Z 2025-11-24T15:05:05.183Z
8481442 8481442 20251116031034_smnfn BG000G 2025-11-17T14:20:56.439Z 2025-11-24T15:05:03.490Z
8481251 8481251 20251116022103_j23SL BG000G 2025-11-17T14:20:32.735Z 2025-11-24T15:05:01.502Z
8481198 8481198 20251116020743_TcgAs BG000G 2025-11-17T14:20:11.507Z 2025-11-24T15:05:00.469Z
8481071 8481071 20251116013204_2rTiD BG000G 2025-11-17T14:19:55.258Z 2025-11-24T15:04:58.641Z
8481029 8481029 20251116012059_KIxib BG000G 2025-11-17T14:19:50.906Z 2025-11-24T15:04:58.296Z
8481005 8481005 20251116011551_Hw2Hd BG000G 2025-11-17T14:19:48.646Z 2025-11-24T15:04:58.041Z
8480990 8480990 20251116011205_eherY BG000G 2025-11-17T14:19:46.658Z 2025-11-24T15:04:57.877Z
8480978 8480978 20251116010628_nDpid BG000G 2025-11-17T14:19:45.644Z 2025-11-24T15:04:57.787Z
8480974 8480974 20251116010500_5ays4 BG000G 2025-11-17T14:19:44.421Z 2025-11-24T15:04:57.728Z
8480942 8480942 20251116005631_2D4mE BG000G 2025-11-17T14:19:28.912Z 2025-11-24T15:04:57.386Z
8480923 8480923 20251116005053_TMJkg BG000G 2025-11-17T14:19:27.284Z 2025-11-24T15:04:57.225Z
8480882 8480882 20251116003724_CP4t9 BG000G 2025-11-17T14:19:21.655Z 2025-11-24T15:04:56.927Z
8480867 8480867 20251116002931_X4QKG BG000G 2025-11-17T14:19:19.724Z 2025-11-24T15:04:56.752Z
8480803 8480803 20251116000009_J3yqK BG000G 2025-11-17T14:19:12.038Z 2025-11-24T15:04:56.159Z
8480573 8480573 20251115221526_zTTX7 BG000G 2025-11-17T14:18:32.359Z 2025-11-24T15:04:54.239Z
8480542 8480542 20251115220405_3qlsb BG000G 2025-11-17T14:18:28.847Z 2025-11-24T15:04:53.923Z
8480453 8480453 20251115213245_7Bfna BG000G 2025-11-17T14:18:19.686Z 2025-11-24T15:04:53.043Z
8479654 8479654 20251115194204_9uKXU BG000G 2025-11-17T14:16:26.278Z 2025-11-24T15:04:46.743Z
8479509 8479509 20251115192552_1Mw5Q BG000G 2025-11-17T14:16:11.321Z 2025-11-24T15:04:45.411Z
8479366 8479366 20251115191226_GrS2l BG000G 2025-11-17T14:15:44.795Z 2025-11-24T15:04:44.286Z
8479187 8479187 20251115184640_hjMZt BG000G 2025-11-17T14:15:09.603Z 2025-11-24T15:04:35.002Z
8478993 8478993 20251115182534_8V2Co BG000G 2025-11-17T14:14:49.849Z 2025-11-24T15:04:29.478Z
8478624 8478624 20251115173736_LNgM9 BG000G 2025-11-17T14:13:53.269Z 2025-11-24T15:04:17.188Z
8478573 8478573 20251115173124_DADKi BG000G 2025-11-17T14:13:48.130Z 2025-11-24T15:04:15.860Z
8469822 8469822 20251115033838_QCTMF BG000G 2025-11-16T14:21:21.410Z 2025-11-23T15:17:57.886Z
8469639 8469639 20251115031212_8Yr2z BG000G 2025-11-16T14:20:45.736Z 2025-11-23T15:17:53.224Z
8469451 8469451 20251115024931_jCrpf BG000G 2025-11-16T14:20:12.237Z 2025-11-23T15:17:39.912Z
8469365 8469365 20251115023600_LtK8v BG000G 2025-11-16T14:20:01.904Z 2025-11-23T15:17:38.851Z
8469324 8469324 20251115023335_2GIUq BG000G 2025-11-16T14:19:58.087Z 2025-11-23T15:17:38.532Z
8469252 8469252 20251115022222_e2x1X BG000G 2025-11-16T14:19:50.180Z 2025-11-23T15:17:37.738Z
8469235 8469235 20251115022049_e7Ebs BG000G 2025-11-16T14:19:39.958Z 2025-11-23T15:17:37.685Z
8469160 8469160 20251115020958_VBRF0 BG000G 2025-11-16T14:19:28.454Z 2025-11-23T15:17:35.174Z
8469139 8469139 20251115020547_sY5Ry BG000G 2025-11-16T14:19:24.842Z 2025-11-23T15:17:34.920Z
8469080 8469080 20251115015847_2y5c0 BG000G 2025-11-16T14:19:19.690Z 2025-11-23T15:17:34.176Z
8468984 8468984 20251115014424_oONqH BG000G 2025-11-16T14:18:55.925Z 2025-11-23T15:17:32.548Z
8468696 8468696 20251115005719_m1zVh BG000G 2025-11-16T14:18:14.613Z 2025-11-23T15:17:20.121Z
8468669 8468669 20251115004953_WtNzr BG000G 2025-11-16T14:18:10.969Z 2025-11-23T15:17:18.941Z
8468662 8468662 20251115004907_5rYOr BG000G 2025-11-16T14:18:07.920Z 2025-11-23T15:17:18.878Z
8468653 8468653 20251115004842_ljHFV BG000G 2025-11-16T14:18:07.366Z 2025-11-23T15:17:18.826Z
8468595 8468595 20251115004355_EjtC5 BG000G 2025-11-16T14:18:01.397Z 2025-11-23T15:17:18.509Z
8468445 8468445 20251115001243_ll24n BG000G 2025-11-16T14:17:33.260Z 2025-11-23T15:17:16.259Z
8468364 8468364 20251114235221_cksgL BG000G 2025-11-16T14:17:18.939Z 2025-11-23T15:17:15.842Z
8468063 8468063 20251114224402_PzMUL BG000G 2025-11-16T14:16:31.137Z 2025-11-23T15:17:13.944Z
8468061 8468061 20251114224240_ttADG BG000G 2025-11-16T14:16:30.535Z 2025-11-23T15:17:13.935Z
8468009 8468009 20251114223128_RlDiC BG000G 2025-11-16T14:16:24.745Z 2025-11-23T15:17:13.641Z
8468004 8468004 20251114223039_2595F BG000G 2025-11-16T14:16:24.318Z 2025-11-23T15:17:13.605Z
8467932 8467932 20251114221020_969qY BG000G 2025-11-16T14:16:01.516Z 2025-11-23T15:17:13.075Z
8467854 8467854 20251114212730_9xO63 BG000G 2025-11-16T14:15:49.861Z 2025-11-23T15:17:12.317Z
8467704 8467704 20251114205024_ltr2J BG000G 2025-11-16T14:15:17.040Z 2025-11-23T15:17:11.093Z
8467627 8467627 20251114204214_CBUeK BG000G 2025-11-16T14:15:08.376Z 2025-11-23T15:17:10.396Z
8467460 8467460 20251114202027_LaNce BG000G 2025-11-16T14:14:39.563Z 2025-11-23T15:17:09.342Z

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