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,032 rows where station_code = "BG0009" 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
8608818 8608818 20251125225014_pGn2V BG0009 2025-11-27T14:16:56.043Z 2025-12-04T15:07:48.995Z
8607694 8607694 20251125211326_ty1ug BG0009 2025-11-27T14:14:21.886Z 2025-12-04T15:07:16.807Z
8607449 8607449 20251125205152_56Cng BG0009 2025-11-27T14:13:41.426Z 2025-12-04T15:07:02.242Z
8607295 8607295 20251125203747_JmNMS BG0009 2025-11-27T14:13:09.986Z 2025-12-04T15:06:59.994Z
8596212 8596212 20251124202302_Es1iN BG0009 2025-11-26T14:13:59.230Z 2025-12-02T15:06:49.585Z
8596110 8596110 20251124200042_3Oq2n BG0009 2025-11-26T14:13:35.002Z 2025-12-02T15:06:41.049Z
8579143 8579143 20251122222913_dKLOh BG0009 2025-11-24T14:13:41.957Z 2025-12-01T15:20:04.893Z
8577943 8577943 20251122191513_JBRV6 BG0009 2025-11-24T14:10:13.472Z 2025-12-01T15:19:03.900Z
8566747 8566747 20251122021015_0lfUJ BG0009 2025-11-23T14:17:15.391Z 2025-11-30T15:06:07.262Z
8566604 8566604 20251122012531_0En4B BG0009 2025-11-23T14:16:41.154Z 2025-11-30T15:05:54.911Z
8566568 8566568 20251122011538_cxUUt BG0009 2025-11-23T14:16:35.653Z 2025-11-30T15:05:52.839Z
8566507 8566507 20251122005536_Jhwf6 BG0009 2025-11-23T14:16:27.138Z 2025-11-30T15:05:50.858Z
8566310 8566310 20251122000549_DjzG5 BG0009 2025-11-23T14:15:43.695Z 2025-11-30T15:05:41.866Z
8481690 8481690 20251116035245_o7k0z BG0009 2025-11-17T14:21:33.182Z 2025-11-24T15:05:05.601Z
8481622 8481622 20251116033950_WB190 BG0009 2025-11-17T14:21:26.891Z 2025-11-24T15:05:04.973Z
8481566 8481566 20251116033252_lr2Ur BG0009 2025-11-17T14:21:20.602Z 2025-11-24T15:05:04.482Z
8481250 8481250 20251116022103_j23SL BG0009 2025-11-17T14:20:32.735Z 2025-11-24T15:05:01.502Z
8481228 8481228 20251116021305_yZZHT BG0009 2025-11-17T14:20:18.090Z 2025-11-24T15:05:01.158Z
8481162 8481162 20251116015934_v0oE3 BG0009 2025-11-17T14:20:05.159Z 2025-11-24T15:04:59.342Z
8481069 8481069 20251116013204_2rTiD BG0009 2025-11-17T14:19:55.257Z 2025-11-24T15:04:58.641Z
8481004 8481004 20251116011551_Hw2Hd BG0009 2025-11-17T14:19:48.646Z 2025-11-24T15:04:58.041Z
8480989 8480989 20251116011205_eherY BG0009 2025-11-17T14:19:46.658Z 2025-11-24T15:04:57.876Z
8480973 8480973 20251116010500_5ays4 BG0009 2025-11-17T14:19:44.421Z 2025-11-24T15:04:57.728Z
8480802 8480802 20251116000009_J3yqK BG0009 2025-11-17T14:19:12.038Z 2025-11-24T15:04:56.159Z
8480702 8480702 20251115230825_08SDC BG0009 2025-11-17T14:18:51.384Z 2025-11-24T15:04:55.425Z
8479508 8479508 20251115192552_1Mw5Q BG0009 2025-11-17T14:16:11.321Z 2025-11-24T15:04:45.411Z
8478992 8478992 20251115182534_8V2Co BG0009 2025-11-17T14:14:49.849Z 2025-11-24T15:04:29.478Z
8478572 8478572 20251115173124_DADKi BG0009 2025-11-17T14:13:48.116Z 2025-11-24T15:04:15.860Z
8469756 8469756 20251115032916_2X8JQ BG0009 2025-11-16T14:21:02.000Z 2025-11-23T15:17:57.313Z
8469487 8469487 20251115025249_tqGGY BG0009 2025-11-16T14:20:14.564Z 2025-11-23T15:17:40.120Z
8469449 8469449 20251115024931_jCrpf BG0009 2025-11-16T14:20:12.237Z 2025-11-23T15:17:39.912Z
8469233 8469233 20251115022049_e7Ebs BG0009 2025-11-16T14:19:39.958Z 2025-11-23T15:17:37.685Z
8469124 8469124 20251115020304_fufSF BG0009 2025-11-16T14:19:22.820Z 2025-11-23T15:17:34.722Z
8469078 8469078 20251115015847_2y5c0 BG0009 2025-11-16T14:19:19.690Z 2025-11-23T15:17:34.176Z
8468982 8468982 20251115014424_oONqH BG0009 2025-11-16T14:18:55.925Z 2025-11-23T15:17:32.548Z
8468694 8468694 20251115005719_m1zVh BG0009 2025-11-16T14:18:14.613Z 2025-11-23T15:17:20.121Z
8468651 8468651 20251115004842_ljHFV BG0009 2025-11-16T14:18:07.366Z 2025-11-23T15:17:18.826Z
8468593 8468593 20251115004355_EjtC5 BG0009 2025-11-16T14:18:01.396Z 2025-11-23T15:17:18.509Z
8468581 8468581 20251115003905_n3Jps BG0009 2025-11-16T14:17:59.972Z 2025-11-23T15:17:18.264Z
8468443 8468443 20251115001243_ll24n BG0009 2025-11-16T14:17:33.260Z 2025-11-23T15:17:16.259Z
8468363 8468363 20251114235221_cksgL BG0009 2025-11-16T14:17:18.939Z 2025-11-23T15:17:15.841Z
8468257 8468257 20251114232837_1UOHQ BG0009 2025-11-16T14:17:07.163Z 2025-11-23T15:17:15.067Z
8468007 8468007 20251114223128_RlDiC BG0009 2025-11-16T14:16:24.745Z 2025-11-23T15:17:13.641Z
8468005 8468005 20251114223059_Py0Eu BG0009 2025-11-16T14:16:24.619Z 2025-11-23T15:17:13.621Z
8467930 8467930 20251114221020_969qY BG0009 2025-11-16T14:16:01.516Z 2025-11-23T15:17:13.075Z
8467914 8467914 20251114220107_gbGHL BG0009 2025-11-16T14:15:59.426Z 2025-11-23T15:17:12.959Z
8467873 8467873 20251114214101_OuVVe BG0009 2025-11-16T14:15:52.753Z 2025-11-23T15:17:12.483Z
8467852 8467852 20251114212730_9xO63 BG0009 2025-11-16T14:15:49.860Z 2025-11-23T15:17:12.317Z
8467812 8467812 20251114211029_GA2CW BG0009 2025-11-16T14:15:43.811Z 2025-11-23T15:17:12.021Z
8467805 8467805 20251114210948_Q4yfT BG0009 2025-11-16T14:15:42.938Z 2025-11-23T15:17:11.986Z
8467707 8467707 20251114205101_YCOM7 BG0009 2025-11-16T14:15:17.673Z 2025-11-23T15:17:11.360Z
8467665 8467665 20251114204650_w3h4q BG0009 2025-11-16T14:15:12.797Z 2025-11-23T15:17:10.643Z
8467573 8467573 20251114203655_Ig2hq BG0009 2025-11-16T14:15:03.246Z 2025-11-23T15:17:10.094Z
8467458 8467458 20251114202027_LaNce BG0009 2025-11-16T14:14:39.563Z 2025-11-23T15:17:09.342Z
8467101 8467101 20251114193908_zFGBz BG0009 2025-11-16T14:13:50.149Z 2025-11-23T15:17:06.740Z
8465504 8465504 20251114164037_nNWLk BG0009 2025-11-16T14:09:26.026Z 2025-11-23T15:16:56.529Z
8465461 8465461 20251114163419_d9E4Y BG0009 2025-11-16T14:09:18.039Z 2025-11-23T15:16:56.197Z
8465404 8465404 20251114163029_zPc5r BG0009 2025-11-16T14:09:12.478Z 2025-11-23T15:16:55.898Z
8459548 8459548 20251114040338_8wDW7 BG0009 2025-11-15T14:20:00.870Z 2025-11-22T15:22:02.027Z
8459526 8459526 20251114040122_HCJDv BG0009 2025-11-15T14:19:57.893Z 2025-11-22T15:22:01.441Z
8459432 8459432 20251114035012_Joaxg BG0009 2025-11-15T14:19:39.501Z 2025-11-22T15:21:55.716Z
8459391 8459391 20251114033928_ofj3e BG0009 2025-11-15T14:19:33.375Z 2025-11-22T15:21:53.792Z
8459169 8459169 20251114030205_H2Ekd BG0009 2025-11-15T14:19:02.312Z 2025-11-22T15:21:40.098Z
8459085 8459085 20251114024559_wATmk BG0009 2025-11-15T14:18:48.970Z 2025-11-22T15:21:36.864Z
8459069 8459069 20251114024354_w3yrp BG0009 2025-11-15T14:18:47.043Z 2025-11-22T15:21:35.652Z
8458956 8458956 20251114022109_hDXIY BG0009 2025-11-15T14:18:19.720Z 2025-11-22T15:21:29.530Z
8458924 8458924 20251114021552_gqjy8 BG0009 2025-11-15T14:18:16.485Z 2025-11-22T15:21:28.589Z
8458900 8458900 20251114020643_aQSEd BG0009 2025-11-15T14:18:13.562Z 2025-11-22T15:21:27.070Z
8458892 8458892 20251114020622_QAI6o BG0009 2025-11-15T14:18:12.557Z 2025-11-22T15:21:26.995Z
8458767 8458767 20251114014241_e1W2v BG0009 2025-11-15T14:17:45.991Z 2025-11-22T15:21:21.638Z
8458720 8458720 20251114012634_ONtWT BG0009 2025-11-15T14:17:39.780Z 2025-11-22T15:21:20.285Z
8458675 8458675 20251114010825_YFRiU BG0009 2025-11-15T14:17:33.040Z 2025-11-22T15:21:17.038Z
8458672 8458672 20251114010825_tjMDD BG0009 2025-11-15T14:17:32.925Z 2025-11-22T15:21:16.797Z
8458663 8458663 20251114010643_5YET3 BG0009 2025-11-15T14:17:32.060Z 2025-11-22T15:21:16.722Z
8458653 8458653 20251114010512_60BKH BG0009 2025-11-15T14:17:30.075Z 2025-11-22T15:21:16.639Z
8458489 8458489 20251114002150_Quv53 BG0009 2025-11-15T14:16:57.778Z 2025-11-22T15:21:07.619Z
8448867 8448867 20251113003425_ybYRD BG0009 2025-11-14T14:18:47.609Z 2025-11-21T15:11:40.128Z
8448849 8448849 20251113002901_qltDS BG0009 2025-11-14T14:18:44.309Z 2025-11-21T15:11:39.630Z
8448608 8448608 20251112234506_TlRM8 BG0009 2025-11-14T14:18:00.132Z 2025-11-21T15:11:34.164Z
8448382 8448382 20251112230137_BK3UA BG0009 2025-11-14T14:17:18.098Z 2025-11-21T15:11:27.143Z
8448244 8448244 20251112222815_WZWPa BG0009 2025-11-14T14:16:43.420Z 2025-11-21T15:11:25.553Z
8447929 8447929 20251112212150_wh7tj BG0009 2025-11-14T14:15:38.591Z 2025-11-21T15:11:23.157Z
8447712 8447712 20251112202827_Nfuj4 BG0009 2025-11-14T14:14:56.720Z 2025-11-21T15:11:20.258Z
8447593 8447593 20251112201105_aVi9E BG0009 2025-11-14T14:14:38.356Z 2025-11-21T15:11:19.531Z
8447381 8447381 20251112193758_kdF80 BG0009 2025-11-14T14:13:58.837Z 2025-11-21T15:11:18.152Z
8447372 8447372 20251112193710_AQbwS BG0009 2025-11-14T14:13:57.573Z 2025-11-21T15:11:18.104Z
8446950 8446950 20251112184059_2GSo6 BG0009 2025-11-14T14:12:33.923Z 2025-11-21T15:11:14.933Z
8446636 8446636 20251112180127_wCtI9 BG0009 2025-11-14T14:11:26.904Z 2025-11-21T15:11:12.414Z
8446388 8446388 20251112172311_yW57C BG0009 2025-11-14T14:10:39.655Z 2025-11-21T15:11:09.840Z
8439402 8439402 20251112034651_qtAUi BG0009 2025-11-13T14:26:30.852Z 2025-11-20T15:25:19.647Z
8438982 8438982 20251112025947_ik6rI BG0009 2025-11-13T14:25:16.450Z 2025-11-20T15:24:55.456Z
8438779 8438779 20251112023841_W8lu2 BG0009 2025-11-13T14:24:42.544Z 2025-11-20T15:24:47.873Z
8438616 8438616 20251112021905_K9bBf BG0009 2025-11-13T14:24:21.493Z 2025-11-20T15:24:43.122Z
8438560 8438560 20251112021156_gJKK6 BG0009 2025-11-13T14:24:05.884Z 2025-11-20T15:24:40.033Z
8438521 8438521 20251112020824_CwRQL BG0009 2025-11-13T14:23:58.266Z 2025-11-20T15:24:38.325Z
8438490 8438490 20251112020520_0kjG7 BG0009 2025-11-13T14:23:53.382Z 2025-11-20T15:24:36.881Z
8438481 8438481 20251112020343_Z68p8 BG0009 2025-11-13T14:23:52.156Z 2025-11-20T15:24:36.753Z
8438368 8438368 20251112014932_vf2P2 BG0009 2025-11-13T14:23:38.947Z 2025-11-20T15:24:30.009Z
8438309 8438309 20251112014327_U1qD1 BG0009 2025-11-13T14:23:20.587Z 2025-11-20T15:24:24.512Z
8437921 8437921 20251112005637_JMldZ BG0009 2025-11-13T14:22:18.648Z 2025-11-20T15:24:00.786Z

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