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,065 rows where station_code = "BG0002" 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
8683455 8683455 20251201234451_FwmYF BG0002 2025-12-04T14:24:49.973Z 2025-12-06T14:33:35.942Z
8683453 8683453 20251201232221_gw40a BG0002 2025-12-04T14:24:48.723Z 2025-12-06T14:33:35.139Z
8674316 8674316 20251202015922_3nwMw BG0002 2025-12-03T14:21:23.892Z 2025-12-06T14:34:03.873Z
8674019 8674019 20251202010923_lzJDH BG0002 2025-12-03T14:20:45.378Z 2025-12-06T14:33:45.614Z
8673816 8673816 20251201234451_UY2W0 BG0002 2025-12-03T14:20:06.636Z 2025-12-03T14:20:06.636Z
8673793 8673793 20251201232612_Xrlgd BG0002 2025-12-03T14:20:03.878Z 2025-12-06T14:33:35.167Z
8673768 8673768 20251201230126_4cMpl BG0002 2025-12-03T14:20:00.739Z 2025-12-06T14:33:33.599Z
8673766 8673766 20251201225642_rkK5B BG0002 2025-12-03T14:20:00.417Z 2025-12-06T14:33:33.425Z
8673754 8673754 20251201222932_UxUBx BG0002 2025-12-03T14:19:57.871Z 2025-12-06T14:33:31.957Z
8665775 8665775 20251201035707_AyYkq BG0002 2025-12-02T14:24:27.807Z 2025-12-06T14:42:02.718Z
8665613 8665613 20251201034344_XEkPa BG0002 2025-12-02T14:24:07.817Z 2025-12-06T14:41:41.826Z
8597684 8597684 20251125000010_Ul7Yb BG0002 2025-11-26T14:17:20.185Z 2025-12-02T15:07:39.588Z
8591075 8591075 20251124034314_GlBjj BG0002 2025-11-25T14:23:34.366Z 2025-12-02T15:12:56.994Z
8468256 8468256 20251114232837_1UOHQ BG0002 2025-11-16T14:17:07.163Z 2025-11-23T15:17:15.067Z
8459268 8459268 20251114032000_9edBn BG0002 2025-11-15T14:19:20.041Z 2025-11-22T15:21:45.330Z
8459212 8459212 20251114031155_NihVc BG0002 2025-11-15T14:19:06.053Z 2025-11-22T15:21:43.046Z
8450190 8450190 20251113035720_E3Ynb BG0002 2025-11-14T14:22:40.269Z 2025-11-21T15:12:30.046Z
8450171 8450171 20251113035510_siWA9 BG0002 2025-11-14T14:22:37.436Z 2025-11-21T15:12:29.744Z
8448856 8448856 20251113003138_Gmn8f BG0002 2025-11-14T14:18:45.611Z 2025-11-21T15:11:40.057Z
8351143 8351143 20251101222323_I6HBc BG0002 2025-11-03T14:12:52.873Z 2025-11-10T15:05:47.323Z
8350121 8350121 20251101194349_PuygO BG0002 2025-11-03T14:09:52.335Z 2025-11-10T15:05:27.883Z
8350054 8350054 20251101193846_Et8lC BG0002 2025-11-03T14:09:36.858Z 2025-11-10T15:05:24.073Z
8333839 8333839 20251031005450_ROi1x BG0002 2025-11-02T14:23:42.849Z 2025-11-08T15:13:01.385Z
8333777 8333777 20251031004550_fC3nq BG0002 2025-11-02T14:23:37.597Z 2025-11-08T15:12:59.433Z
8333399 8333399 20251031001009_0hBrg BG0002 2025-11-02T14:22:37.825Z 2025-11-08T15:12:53.569Z
8333253 8333253 20251030235257_or40m BG0002 2025-11-02T14:22:07.542Z 2025-11-08T15:12:50.994Z
8331909 8331909 20251101034126_ocRXk BG0002 2025-11-02T14:12:02.545Z 2025-11-09T15:03:21.972Z
8331863 8331863 20251101032902_MJ59R BG0002 2025-11-02T14:11:52.275Z 2025-11-09T15:03:19.296Z
8331498 8331498 20251101021710_Rc4uq BG0002 2025-11-02T14:10:29.837Z 2025-11-09T15:02:27.075Z
8331352 8331352 20251101015153_R0wfB BG0002 2025-11-02T14:09:58.299Z 2025-11-09T15:01:59.246Z
8331237 8331237 20251101013430_GTdcg BG0002 2025-11-02T14:09:25.599Z 2025-11-09T15:01:26.849Z
8331005 8331005 20251101005648_Hs0wY BG0002 2025-11-02T14:08:39.617Z 2025-11-09T15:00:51.489Z
8330872 8330872 20251101003200_GAlib BG0002 2025-11-02T14:08:07.756Z 2025-11-09T15:00:44.174Z
8330530 8330530 20251031231928_sEHFH BG0002 2025-11-02T14:06:52.983Z 2025-11-09T15:00:32.214Z
8330440 8330440 20251031225637_wNZwJ BG0002 2025-11-02T14:06:36.696Z 2025-11-09T15:00:29.716Z
8321590 8321590 20251030034052_LPy2w BG0002 2025-11-01T12:28:05.619Z 2025-11-07T15:15:31.417Z
8319625 8319625 20251030021701_bSyVi BG0002 2025-11-01T12:25:03.501Z 2025-11-07T15:13:43.495Z
8318883 8318883 20251030014521_5D4FF BG0002 2025-11-01T12:23:30.355Z 2025-11-07T15:13:33.147Z
8318738 8318738 20251030013835_Wu4s9 BG0002 2025-11-01T12:23:19.526Z 2025-11-07T15:13:31.331Z
8316438 8316438 20251030170427_cbwAH BG0002 2025-11-01T12:05:43.413Z 2025-11-08T15:10:32.331Z
8314332 8314332 20251030004957_zCSJ4 BG0002 2025-10-31T12:38:48.054Z 2025-11-07T15:13:20.256Z
8313961 8313961 20251030003117_Yj1kn BG0002 2025-10-31T12:38:14.277Z 2025-11-07T15:13:14.378Z
8312898 8312898 20251029233929_amSKa BG0002 2025-10-31T12:37:05.848Z 2025-11-07T15:12:19.965Z
8312857 8312857 20251029233454_7LJnN BG0002 2025-10-31T12:37:03.975Z 2025-11-07T15:12:18.132Z
8311885 8311885 20251029223257_BxetV BG0002 2025-10-31T12:36:27.333Z 2025-11-07T15:11:33.264Z
8310502 8310502 20251029200218_B3K5E BG0002 2025-10-31T12:34:33.844Z 2025-10-31T12:34:33.844Z
8310210 8310210 20251029191121_3lp8E BG0002 2025-10-31T12:34:08.575Z 2025-11-07T15:10:34.779Z
8310079 8310079 20251029183159_XRhxL BG0002 2025-10-31T12:33:31.355Z 2025-11-07T15:10:17.762Z
8309966 8309966 20251029181156_Do3iU BG0002 2025-10-31T12:32:53.363Z 2025-11-07T15:10:00.123Z
8309878 8309878 20251029173416_fcfQw BG0002 2025-10-31T12:32:18.017Z 2025-11-07T15:09:38.939Z
8309855 8309855 20251029170815_y2ts7 BG0002 2025-10-31T12:32:10.451Z 2025-11-07T15:09:34.064Z
8299656 8299656 20251029033746_ryNZ4 BG0002 2025-10-30T12:52:07.423Z 2025-11-06T15:13:49.524Z
8298622 8298622 20251029014304_qxeno BG0002 2025-10-30T12:51:28.478Z 2025-11-06T15:13:03.857Z
8298571 8298571 20251029013324_YImNM BG0002 2025-10-30T12:51:17.784Z 2025-11-06T15:13:00.952Z
8298366 8298366 20251029010737_NvKBf BG0002 2025-10-30T12:50:57.940Z 2025-11-06T15:12:52.729Z
8298287 8298287 20251029005930_F99eh BG0002 2025-10-30T12:50:47.570Z 2025-11-06T15:12:49.598Z
8298091 8298091 20251029003924_O8iQg BG0002 2025-10-30T12:50:09.459Z 2025-11-06T15:12:45.233Z
8298056 8298056 20251029003541_teoYc BG0002 2025-10-30T12:50:06.984Z 2025-11-06T15:12:44.366Z
8297325 8297325 20251028231008_8pJhD BG0002 2025-10-30T12:49:18.019Z 2025-11-06T15:12:27.359Z
8289717 8289717 20251028190249_9zsvY BG0002 2025-10-30T12:14:29.852Z 2025-10-30T12:14:29.852Z
8289706 8289706 20251028190216_Tc9TH BG0002 2025-10-30T12:14:22.774Z 2025-11-06T15:12:01.010Z
8289658 8289658 20251028185848_p9yKn BG0002 2025-10-30T12:14:16.913Z 2025-11-06T15:12:00.734Z
8289270 8289270 20251028183047_2JqfT BG0002 2025-10-30T12:13:02.974Z 2025-11-06T15:11:50.068Z
8288403 8288403 20251028172446_lzIDf BG0002 2025-10-30T12:10:14.899Z 2025-11-06T15:11:18.730Z
8288315 8288315 20251028171624_JpKpK BG0002 2025-10-30T12:09:53.420Z 2025-11-06T15:11:14.903Z
8279076 8279076 20251027193234_EXCYr BG0002 2025-10-29T12:35:37.258Z 2025-11-05T15:20:13.162Z
8278988 8278988 20251027185312_NV2Iz BG0002 2025-10-29T12:35:00.736Z 2025-11-05T15:19:54.492Z
8278742 8278742 20251027171539_3h5vg BG0002 2025-10-29T12:34:06.934Z 2025-11-05T15:19:02.211Z
8256338 8256338 20251026012713_U8mrn BG0002 2025-10-28T12:29:30.394Z 2025-11-03T15:16:15.665Z
8255752 8255752 20251026010618_XIwgc BG0002 2025-10-28T12:28:35.228Z 2025-11-03T15:16:12.510Z
8255178 8255178 20251026004807_BS1oM BG0002 2025-10-28T12:28:11.368Z 2025-11-03T15:16:09.854Z
8255124 8255124 20251026004644_Iyhb2 BG0002 2025-10-28T12:28:09.186Z 2025-11-03T15:16:09.712Z
8255046 8255046 20251026004405_MAjSa BG0002 2025-10-28T12:28:00.151Z 2025-11-03T15:16:09.624Z
8254891 8254891 20251026003600_uO3RA BG0002 2025-10-28T12:27:41.431Z 2025-11-03T15:16:09.175Z
8254883 8254883 20251026003534_ufAKI BG0002 2025-10-28T12:27:40.796Z 2025-11-03T15:16:09.161Z
8240074 8240074 20251025010908_8xa9R BG0002 2025-10-27T12:30:58.710Z 2025-11-02T15:05:26.808Z
8240068 8240068 20251025010858_aRjC8 BG0002 2025-10-27T12:30:58.531Z 2025-11-02T15:05:26.802Z
8240060 8240060 20251025010750_LCxap BG0002 2025-10-27T12:30:57.990Z 2025-11-02T15:05:26.792Z
8235563 8235563 20251024165047_3sEyM BG0002 2025-10-27T12:20:50.941Z 2025-11-02T15:05:03.075Z
8235421 8235421 20251026003219_AVbD3 BG0002 2025-10-27T12:17:32.185Z 2025-11-03T15:16:08.871Z
8234512 8234512 20251025234908_YiJLh BG0002 2025-10-27T12:15:47.834Z 2025-11-03T15:16:04.088Z
8234222 8234222 20251025233556_RAxgU BG0002 2025-10-27T12:15:14.532Z 2025-11-03T15:16:02.515Z
8234027 8234027 20251025232350_R8dWc BG0002 2025-10-27T12:14:43.745Z 2025-11-03T15:16:01.557Z
8231863 8231863 20251025193932_QzyZD BG0002 2025-10-27T12:09:10.786Z 2025-11-03T15:15:48.273Z
8231764 8231764 20251025192102_gCxn0 BG0002 2025-10-27T12:08:47.999Z 2025-11-03T15:15:47.199Z
8210589 8210589 20251023193737_i7ar1 BG0002 2025-10-26T12:21:33.188Z 2025-11-01T13:09:57.523Z
8210585 8210585 20251023193736_jeMu0 BG0002 2025-10-26T12:21:32.819Z 2025-11-01T13:09:55.103Z
8190894 8190894 20251022005419_FGLpA BG0002 2025-10-24T12:22:46.455Z 2025-10-30T13:13:08.992Z
8189843 8189843 20251023023536_Raeb1 BG0002 2025-10-24T12:09:54.650Z 2025-10-31T13:08:39.763Z
8188670 8188670 20251022173346_lJ0dz BG0002 2025-10-24T12:05:12.655Z 2025-10-31T13:08:07.457Z
8177309 8177309 20251021164615_gYtUe BG0002 2025-10-23T12:09:27.207Z 2025-10-30T13:12:43.616Z
8119283 8119283 20251016173658_E3qzT BG0002 2025-10-18T12:12:29.050Z 2025-10-25T13:25:39.707Z
8085533 8085533 20251011200452_L0Gxk BG0002 2025-10-13T12:06:12.741Z 2025-10-20T13:03:08.799Z
8078556 8078556 20251010014917_fBfeP BG0002 2025-10-11T12:09:09.106Z 2025-10-18T13:00:04.204Z
8078435 8078435 20251010011340_hwTos BG0002 2025-10-11T12:08:37.744Z 2025-10-18T13:00:01.247Z
8078274 8078274 20251010002831_Uw2RF BG0002 2025-10-11T12:07:59.142Z 2025-10-18T12:59:58.010Z
8078176 8078176 20251009234834_odN33 BG0002 2025-10-11T12:07:44.532Z 2025-10-18T12:59:56.824Z
8078163 8078163 20251009233922_JZ43Y BG0002 2025-10-11T12:07:32.949Z 2025-10-18T12:59:56.597Z
8078153 8078153 20251009233700_DOFhF BG0002 2025-10-11T12:07:31.258Z 2025-10-18T12:59:56.508Z
8078110 8078110 20251009232042_jCFZj BG0002 2025-10-11T12:07:20.335Z 2025-10-18T12:59:55.850Z

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