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

>10,000 rows count all where station_code = "US0003" 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
8691183 8691183 20251205040021_dgN2f US0003 2025-12-06T14:16:49.462Z 2025-12-06T14:18:01.052Z
8691061 8691061 20251205031744_pRBoy US0003 2025-12-06T14:16:23.382Z 2025-12-06T14:18:01.024Z
8690838 8690838 20251205020252_scVXA US0003 2025-12-06T14:15:39.058Z 2025-12-06T14:18:00.969Z
8690708 8690708 20251205012459_GcdGv US0003 2025-12-06T14:15:13.894Z 2025-12-06T14:18:00.942Z
8687540 8687540 20251205071724_JBtfn US0003 2025-12-06T14:00:38.291Z 2025-12-06T14:00:38.291Z
8687506 8687506 20251205065725_y9bON US0003 2025-12-06T14:00:32.194Z 2025-12-06T14:00:32.194Z
8687490 8687490 20251205064553_LV0Ul US0003 2025-12-06T14:00:28.243Z 2025-12-06T14:00:28.243Z
8687461 8687461 20251205063001_slhS2 US0003 2025-12-06T14:00:20.505Z 2025-12-06T14:00:20.505Z
8684523 8684523 20251204130318_MdELM US0003 2025-12-05T14:03:37.125Z 2025-12-06T14:18:00.534Z
8684516 8684516 20251204130059_89au0 US0003 2025-12-05T14:03:35.841Z 2025-12-06T14:18:00.532Z
8684316 8684316 20251204120349_6yDyA US0003 2025-12-05T14:02:41.848Z 2025-12-06T14:18:00.475Z
8684248 8684248 20251204114526_32A6f US0003 2025-12-05T14:02:21.772Z 2025-12-06T14:18:00.453Z
8684165 8684165 20251204110431_Nl21x US0003 2025-12-05T14:02:04.738Z 2025-12-06T14:18:00.432Z
8684115 8684115 20251204104910_DOrhz US0003 2025-12-05T14:01:58.715Z 2025-12-06T14:18:00.421Z
8684028 8684028 20251204101841_N3lvQ US0003 2025-12-05T14:01:35.194Z 2025-12-06T14:18:00.398Z
8683279 8683279 20251203064959_H3m2q US0003 2025-12-04T14:19:03.783Z 2025-12-06T14:29:49.121Z
8683056 8683056 20251203062320_gJA20 US0003 2025-12-04T14:18:30.894Z 2025-12-06T14:29:40.470Z
8682974 8682974 20251203061754_bIW1Q US0003 2025-12-04T14:18:25.060Z 2025-12-06T14:29:34.477Z
8682520 8682520 20251203054344_ukT0X US0003 2025-12-04T14:17:24.384Z 2025-12-06T14:29:13.595Z
8682483 8682483 20251203054007_C9cI6 US0003 2025-12-04T14:17:18.415Z 2025-12-06T14:29:09.534Z
8682475 8682475 20251203053858_eXL3z US0003 2025-12-04T14:17:17.291Z 2025-12-06T14:29:04.555Z
8682473 8682473 20251203053834_6ONDR US0003 2025-12-04T14:17:16.813Z 2025-12-06T14:29:04.460Z
8682460 8682460 20251203053759_BFfzn US0003 2025-12-04T14:17:15.266Z 2025-12-06T14:29:03.987Z
8682441 8682441 20251203053427_DfFnr US0003 2025-12-04T14:17:12.431Z 2025-12-06T14:29:03.116Z
8681932 8681932 20251203043012_DnUe7 US0003 2025-12-04T14:16:02.365Z 2025-12-06T14:28:40.766Z
8681748 8681748 20251203035536_shT6R US0003 2025-12-04T14:15:30.279Z 2025-12-06T14:28:28.077Z
8681532 8681532 20251203032242_IcEgD US0003 2025-12-04T14:15:00.285Z 2025-12-06T14:28:17.199Z
8681107 8681107 20251203022502_LcX7i US0003 2025-12-04T14:13:52.448Z 2025-12-06T14:27:49.946Z
8681033 8681033 20251203021516_6ksiH US0003 2025-12-04T14:13:37.098Z 2025-12-06T14:27:47.021Z
8680965 8680965 20251203020451_ysHUQ US0003 2025-12-04T14:13:28.022Z 2025-12-06T14:27:35.460Z
8680747 8680747 20251203011216_6gLq2 US0003 2025-12-04T14:12:51.377Z 2025-12-06T14:27:24.794Z
8677878 8677878 20251203125626_LPBIZ US0003 2025-12-04T14:02:51.938Z 2025-12-06T14:20:11.175Z
8677876 8677876 20251203125317_VDViT US0003 2025-12-04T14:02:51.419Z 2025-12-06T14:20:10.956Z
8677563 8677563 20251203104649_6ADp0 US0003 2025-12-04T14:01:46.008Z 2025-12-06T14:19:38.480Z
8677150 8677150 20251202071037_kQ6zQ US0003 2025-12-03T14:26:22.201Z 2025-12-06T14:35:36.910Z
8677025 8677025 20251202064124_HrG7L US0003 2025-12-03T14:26:12.662Z 2025-12-06T14:35:33.174Z
8676712 8676712 20251202061556_9MHGA US0003 2025-12-03T14:25:27.314Z 2025-12-06T14:35:27.393Z
8676695 8676695 20251202061243_YnjZh US0003 2025-12-03T14:25:26.605Z 2025-12-06T14:35:27.121Z
8676668 8676668 20251202061143_ZBDJq US0003 2025-12-03T14:25:25.597Z 2025-12-06T14:35:26.891Z
8676216 8676216 20251202054149_EjU09 US0003 2025-12-03T14:24:49.524Z 2025-12-06T14:35:18.907Z
8676075 8676075 20251202053452_qQlML US0003 2025-12-03T14:24:40.464Z 2025-12-06T14:35:07.798Z
8675674 8675674 20251202050546_IBWrR US0003 2025-12-03T14:24:00.270Z 2025-12-06T14:34:58.047Z
8675392 8675392 20251202043502_euzzk US0003 2025-12-03T14:23:39.874Z 2025-12-06T14:34:51.100Z
8675374 8675374 20251202043336_b7tHY US0003 2025-12-03T14:23:39.063Z 2025-12-06T14:34:50.835Z
8675166 8675166 20251202041107_fu2Nm US0003 2025-12-03T14:23:14.776Z 2025-12-06T14:34:46.089Z
8675159 8675159 20251202041002_ADRgJ US0003 2025-12-03T14:23:13.902Z 2025-12-06T14:34:44.693Z
8675095 8675095 20251202040026_7rgCR US0003 2025-12-03T14:23:02.063Z 2025-12-06T14:34:29.043Z
8674949 8674949 20251202034228_3zI1d US0003 2025-12-03T14:22:45.432Z 2025-12-06T14:34:25.157Z
8674858 8674858 20251202033426_2WCNB US0003 2025-12-03T14:22:30.133Z 2025-12-06T14:34:21.270Z
8674560 8674560 20251202024856_NnKr3 US0003 2025-12-03T14:22:00.901Z 2025-12-06T14:34:12.131Z
8674420 8674420 20251202022352_Kcr9b US0003 2025-12-03T14:21:37.340Z 2025-12-06T14:34:08.878Z
8670045 8670045 20251202125520_0Xgra US0003 2025-12-03T14:06:37.418Z 2025-12-06T14:24:32.447Z
8670043 8670043 20251202125518_8qDtU US0003 2025-12-03T14:06:36.777Z 2025-12-06T14:24:32.286Z
8670012 8670012 20251202124619_q5hD3 US0003 2025-12-03T14:06:29.855Z 2025-12-06T14:24:30.818Z
8669994 8669994 20251202124244_G5f88 US0003 2025-12-03T14:06:27.362Z 2025-12-06T14:24:30.100Z
8669971 8669971 20251202123912_19HbO US0003 2025-12-03T14:06:14.183Z 2025-12-06T14:24:28.995Z
8669965 8669965 20251202123835_7uMT2 US0003 2025-12-03T14:06:13.524Z 2025-12-06T14:24:28.864Z
8669941 8669941 20251202123047_B3SIw US0003 2025-12-03T14:06:06.425Z 2025-12-06T14:24:27.913Z
8669937 8669937 20251202123041_XtBjB US0003 2025-12-03T14:06:05.653Z 2025-12-06T14:24:27.818Z
8669868 8669868 20251202121907_JFSHN US0003 2025-12-03T14:05:52.968Z 2025-12-06T14:24:23.997Z
8669838 8669838 20251202121639_oTxJY US0003 2025-12-03T14:05:48.906Z 2025-12-06T14:24:22.872Z
8669766 8669766 20251202120857_v2g89 US0003 2025-12-03T14:05:24.028Z 2025-12-06T14:24:19.251Z
8669743 8669743 20251202120651_otLoG US0003 2025-12-03T14:05:20.379Z 2025-12-06T14:24:18.103Z
8669737 8669737 20251202120643_937f7 US0003 2025-12-03T14:05:19.892Z 2025-12-06T14:24:18.028Z
8669676 8669676 20251202115636_G6dqa US0003 2025-12-03T14:04:55.982Z 2025-12-06T14:24:14.369Z
8669656 8669656 20251202115318_aaqO0 US0003 2025-12-03T14:04:52.973Z 2025-12-06T14:24:13.518Z
8669650 8669650 20251202115230_2DKoi US0003 2025-12-03T14:04:52.265Z 2025-12-06T14:24:13.092Z
8669584 8669584 20251202113849_jVw1t US0003 2025-12-03T14:04:38.503Z 2025-12-06T14:24:04.718Z
8669559 8669559 20251202113137_Kcvhi US0003 2025-12-03T14:04:32.789Z 2025-12-06T14:24:02.302Z
8669490 8669490 20251202112100_ThBy1 US0003 2025-12-03T14:04:09.171Z 2025-12-06T14:23:57.958Z
8669416 8669416 20251202111003_8ICMq US0003 2025-12-03T14:03:40.938Z 2025-12-06T14:23:53.325Z
8669396 8669396 20251202110644_r45X1 US0003 2025-12-03T14:03:34.401Z 2025-12-06T14:23:52.022Z
8669353 8669353 20251202105918_S4VF2 US0003 2025-12-03T14:03:27.289Z 2025-12-06T14:23:50.405Z
8669338 8669338 20251202105603_iJ8hV US0003 2025-12-03T14:03:24.921Z 2025-12-06T14:23:49.835Z
8669324 8669324 20251202105316_BjqPJ US0003 2025-12-03T14:03:22.486Z 2025-12-06T14:23:49.195Z
8669304 8669304 20251202105107_dXHNT US0003 2025-12-03T14:03:19.908Z 2025-12-06T14:23:48.565Z
8669185 8669185 20251202102947_1f9lq US0003 2025-12-03T14:02:49.372Z 2025-12-06T14:23:39.451Z
8669126 8669126 20251202101700_4UI7g US0003 2025-12-03T14:02:40.642Z 2025-12-06T14:23:35.001Z
8669093 8669093 20251202101136_aVZt4 US0003 2025-12-03T14:02:23.119Z 2025-12-06T14:23:31.753Z
8669086 8669086 20251202101111_jF83B US0003 2025-12-03T14:02:22.575Z 2025-12-06T14:23:31.507Z
8669064 8669064 20251202100759_YNibN US0003 2025-12-03T14:02:13.110Z 2025-12-06T14:23:30.239Z
8669009 8669009 20251202095219_JfLpm US0003 2025-12-03T14:02:00.787Z 2025-12-06T14:23:25.834Z
8668966 8668966 20251202094106_2Hl5u US0003 2025-12-03T14:01:46.006Z 2025-12-06T14:23:23.554Z
8668950 8668950 20251202093821_uJfRJ US0003 2025-12-03T14:01:42.843Z 2025-12-06T14:23:22.847Z
8668934 8668934 20251202093210_XxUdK US0003 2025-12-03T14:01:37.919Z 2025-12-06T14:23:22.184Z
8668917 8668917 20251202092723_QtHln US0003 2025-12-03T14:01:36.150Z 2025-12-06T14:23:21.597Z
8668898 8668898 20251202091939_jsYys US0003 2025-12-03T14:01:33.523Z 2025-12-06T14:23:20.648Z
8668878 8668878 20251202091722_2vcNx US0003 2025-12-03T14:01:31.510Z 2025-12-06T14:23:16.137Z
8668869 8668869 20251202091422_YYptS US0003 2025-12-03T14:01:30.171Z 2025-12-06T14:23:15.413Z
8668847 8668847 20251202091140_kANJb US0003 2025-12-03T14:01:26.846Z 2025-12-06T14:23:14.123Z
8668837 8668837 20251202090942_SEcey US0003 2025-12-03T14:01:25.876Z 2025-12-06T14:23:13.819Z
8668711 8668711 20251202083646_XLL74 US0003 2025-12-03T14:00:55.145Z 2025-12-06T14:23:06.335Z
8668706 8668706 20251202083511_KddC5 US0003 2025-12-03T14:00:54.192Z 2025-12-06T14:23:05.661Z
8668621 8668621 20251202080225_SUWVV US0003 2025-12-03T14:00:36.427Z 2025-12-06T14:22:58.001Z
8668492 8668492 20251129064750_G9FsN US0003 2025-12-02T14:49:16.265Z 2025-12-06T14:57:16.386Z
8668482 8668482 20251129063257_Jz6io US0003 2025-12-02T14:49:13.683Z 2025-12-06T14:57:10.900Z
8668475 8668475 20251129061823_4gpSD US0003 2025-12-02T14:49:08.022Z 2025-12-06T14:57:06.164Z
8668468 8668468 20251129060605_0MdY7 US0003 2025-12-02T14:48:51.702Z 2025-12-06T14:56:58.538Z
8668461 8668461 20251129054339_mA4JJ US0003 2025-12-02T14:48:35.826Z 2025-12-06T14:56:49.359Z
8668444 8668444 20251129050533_o1o6f US0003 2025-12-02T14:48:26.340Z 2025-12-06T14:56:42.882Z

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