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 = "US000E" 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
8684458 8684458 20251204124255_blne7 US000E 2025-12-05T14:03:24.060Z 2025-12-05T14:03:24.060Z
8684435 8684435 20251204123830_nA2hQ US000E 2025-12-05T14:03:13.320Z 2025-12-05T14:03:13.320Z
8684411 8684411 20251204123146_THQeM US000E 2025-12-05T14:03:01.871Z 2025-12-05T14:03:01.871Z
8684407 8684407 20251204123012_9p3NW US000E 2025-12-05T14:03:00.913Z 2025-12-05T14:03:00.913Z
8684329 8684329 20251204120639_KaRSY US000E 2025-12-05T14:02:44.118Z 2025-12-05T14:02:44.118Z
8682367 8682367 20251203052130_895WF US000E 2025-12-04T14:17:01.673Z 2025-12-05T14:22:26.161Z
8682277 8682277 20251203050845_LF2hL US000E 2025-12-04T14:16:43.525Z 2025-12-05T14:22:22.735Z
8682178 8682178 20251203045647_uZSUw US000E 2025-12-04T14:16:33.741Z 2025-12-05T14:22:17.302Z
8677159 8677159 20251202071151_8e0lw US000E 2025-12-03T14:26:22.597Z 2025-12-05T14:29:23.233Z
8677143 8677143 20251202070241_tcgyF US000E 2025-12-03T14:26:21.660Z 2025-12-05T14:29:22.879Z
8677094 8677094 20251202064839_Iko5A US000E 2025-12-03T14:26:17.481Z 2025-12-05T14:29:20.895Z
8677076 8677076 20251202064423_CAqEn US000E 2025-12-03T14:26:16.513Z 2025-12-05T14:29:20.401Z
8676760 8676760 20251202062115_2rhHX US000E 2025-12-03T14:25:32.819Z 2025-12-05T14:29:12.582Z
8676661 8676661 20251202061049_aB2tv US000E 2025-12-03T14:25:24.954Z 2025-12-05T14:29:10.177Z
8676239 8676239 20251202054231_yfKes US000E 2025-12-03T14:24:50.475Z 2025-12-05T14:28:50.901Z
8675841 8675841 20251202051849_d5f9y US000E 2025-12-03T14:24:25.661Z 2025-12-05T14:28:42.186Z
8675696 8675696 20251202051011_Y4jlw US000E 2025-12-03T14:24:10.972Z 2025-12-05T14:28:38.823Z
8675680 8675680 20251202050613_SqpmB US000E 2025-12-03T14:24:01.256Z 2025-12-05T14:28:38.158Z
8674986 8674986 20251202034525_TT4lI US000E 2025-12-03T14:22:48.013Z 2025-12-05T14:28:08.297Z
8674697 8674697 20251202030739_oJU2q US000E 2025-12-03T14:22:13.366Z 2025-12-05T14:27:59.929Z
8674367 8674367 20251202021300_aCFKp US000E 2025-12-03T14:21:32.560Z 2025-12-05T14:27:39.364Z
8673996 8673996 20251202005827_JlZM0 US000E 2025-12-03T14:20:42.138Z 2025-12-05T14:27:25.329Z
8670005 8670005 20251202124516_OorD2 US000E 2025-12-03T14:06:28.344Z 2025-12-05T14:18:05.273Z
8669886 8669886 20251202122140_KIvJ4 US000E 2025-12-03T14:05:55.878Z 2025-12-05T14:17:55.949Z
8669846 8669846 20251202121653_vAS73 US000E 2025-12-03T14:05:49.542Z 2025-12-05T14:17:52.056Z
8669810 8669810 20251202121303_ZNYV9 US000E 2025-12-03T14:05:33.848Z 2025-12-05T14:17:49.388Z
8669805 8669805 20251202121258_5eZcg US000E 2025-12-03T14:05:32.473Z 2025-12-05T14:17:49.130Z
8669693 8669693 20251202115910_22vCE US000E 2025-12-03T14:05:11.414Z 2025-12-05T14:17:42.205Z
8669684 8669684 20251202115722_flD7i US000E 2025-12-03T14:05:08.262Z 2025-12-05T14:17:41.402Z
8669637 8669637 20251202114836_BR93H US000E 2025-12-03T14:04:46.863Z 2025-12-05T14:17:38.461Z
8669617 8669617 20251202114255_fZWq0 US000E 2025-12-03T14:04:43.187Z 2025-12-05T14:17:35.564Z
8669594 8669594 20251202113859_ZUyAw US000E 2025-12-03T14:04:39.119Z 2025-12-05T14:17:34.553Z
8669315 8669315 20251202105245_bsHM9 US000E 2025-12-03T14:03:21.205Z 2025-12-05T14:17:08.073Z
8669252 8669252 20251202104107_wzKH3 US000E 2025-12-03T14:03:04.029Z 2025-12-05T14:17:02.017Z
8669217 8669217 20251202103306_Br9Zw US000E 2025-12-03T14:02:53.272Z 2025-12-05T14:16:59.118Z
8669173 8669173 20251202102910_2qncN US000E 2025-12-03T14:02:47.796Z 2025-12-05T14:16:56.632Z
8669032 8669032 20251202095458_31t2u US000E 2025-12-03T14:02:04.066Z 2025-12-05T14:16:44.875Z
8669024 8669024 20251202095412_cZhv3 US000E 2025-12-03T14:02:02.907Z 2025-12-05T14:16:44.521Z
8668974 8668974 20251202094239_jh9Uk US000E 2025-12-03T14:01:50.832Z 2025-12-05T14:16:33.008Z
8668961 8668961 20251202094037_XHuts US000E 2025-12-03T14:01:44.632Z 2025-12-05T14:16:24.194Z
8668862 8668862 20251202091253_1U2vu US000E 2025-12-03T14:01:28.699Z 2025-12-05T14:15:41.666Z
8668823 8668823 20251202090827_oJuhu US000E 2025-12-03T14:01:23.915Z 2025-12-05T14:15:34.599Z
8668792 8668792 20251202090014_tNnCn US000E 2025-12-03T14:01:19.589Z 2025-12-05T14:15:27.981Z
8668783 8668783 20251202085950_oW7sJ US000E 2025-12-03T14:01:13.772Z 2025-12-05T14:15:24.129Z
8668765 8668765 20251202085356_vJ1ZB US000E 2025-12-03T14:01:10.766Z 2025-12-05T14:15:18.823Z
8668757 8668757 20251202085123_FbDVV US000E 2025-12-03T14:01:03.307Z 2025-12-05T14:15:15.472Z
8668721 8668721 20251202084046_Lmq4W US000E 2025-12-03T14:00:56.489Z 2025-12-05T14:15:06.672Z
8668645 8668645 20251202080610_XOvsw US000E 2025-12-03T14:00:39.705Z 2025-12-05T14:14:48.709Z
8668582 8668582 20251202074711_Q180s US000E 2025-12-03T14:00:29.733Z 2025-12-05T14:14:45.371Z
8668543 8668543 20251202072923_8P3gQ US000E 2025-12-03T14:00:17.250Z 2025-12-05T14:14:39.100Z
8668243 8668243 20251130065436_DEzJw US000E 2025-12-02T14:42:14.092Z 2025-12-05T14:46:04.635Z
8668204 8668204 20251130063913_3cB4m US000E 2025-12-02T14:42:11.064Z 2025-12-05T14:46:02.471Z
8668146 8668146 20251130061727_BWCxF US000E 2025-12-02T14:42:04.846Z 2025-12-05T14:45:57.534Z
8668051 8668051 20251130054550_lARwO US000E 2025-12-02T14:41:32.549Z 2025-12-05T14:45:30.217Z
8668011 8668011 20251130054000_wbCIK US000E 2025-12-02T14:41:29.799Z 2025-12-05T14:45:28.578Z
8667990 8667990 20251130053717_aAYK3 US000E 2025-12-02T14:41:27.377Z 2025-12-05T14:45:27.512Z
8667934 8667934 20251130051213_rxKLm US000E 2025-12-02T14:41:19.444Z 2025-12-05T14:45:22.002Z
8667847 8667847 20251130043741_rSfr7 US000E 2025-12-02T14:40:38.139Z 2025-12-05T14:44:45.894Z
8667812 8667812 20251130041143_zRxIl US000E 2025-12-02T14:40:27.870Z 2025-12-05T14:44:37.038Z
8667759 8667759 20251130035038_L3lwC US000E 2025-12-02T14:40:17.096Z 2025-12-05T14:44:30.429Z
8667676 8667676 20251130031615_2qTaY US000E 2025-12-02T14:39:41.262Z 2025-12-05T14:43:55.800Z
8667671 8667671 20251130031436_S7fPz US000E 2025-12-02T14:39:40.128Z 2025-12-05T14:43:55.114Z
8667620 8667620 20251130025010_XOFuK US000E 2025-12-02T14:39:27.778Z 2025-12-05T14:43:44.076Z
8667579 8667579 20251130022301_cHE9W US000E 2025-12-02T14:38:57.342Z 2025-12-05T14:43:34.224Z
8667566 8667566 20251130021719_1QdT6 US000E 2025-12-02T14:38:54.974Z 2025-12-05T14:43:32.042Z
8667535 8667535 20251130020604_sXHuR US000E 2025-12-02T14:38:48.466Z 2025-12-05T14:43:19.790Z
8667516 8667516 20251130020358_u0ACf US000E 2025-12-02T14:38:46.620Z 2025-12-05T14:43:06.142Z
8667488 8667488 20251130015425_dKYWC US000E 2025-12-02T14:38:41.141Z 2025-12-05T14:43:02.411Z
8666958 8666958 20251129111550_flVyt US000E 2025-12-02T14:32:47.131Z 2025-12-05T14:38:24.187Z
8666946 8666946 20251129095549_dNs5L US000E 2025-12-02T14:32:04.298Z 2025-12-05T14:37:45.839Z
8660521 8660521 20251130130134_KGVA9 US000E 2025-12-02T14:08:12.676Z 2025-12-05T14:31:13.662Z
8660296 8660296 20251130122547_zlo9o US000E 2025-12-02T14:07:15.327Z 2025-12-05T14:31:03.388Z
8660241 8660241 20251130121036_bJZd3 US000E 2025-12-02T14:07:00.774Z 2025-12-05T14:31:00.407Z
8660180 8660180 20251130120253_1jfKi US000E 2025-12-02T14:06:49.372Z 2025-12-05T14:30:47.857Z
8660177 8660177 20251130120250_TLmfZ US000E 2025-12-02T14:06:48.897Z 2025-12-05T14:30:47.775Z
8660050 8660050 20251130114831_auEnP US000E 2025-12-02T14:06:22.038Z 2025-12-05T14:30:42.101Z
8660020 8660020 20251130114306_NjgN5 US000E 2025-12-02T14:06:14.732Z 2025-12-05T14:30:40.801Z
8659988 8659988 20251130113757_ShDEg US000E 2025-12-02T14:06:01.208Z 2025-12-05T14:30:39.862Z
8659955 8659955 20251130113258_Saptm US000E 2025-12-02T14:05:54.471Z 2025-12-05T14:30:38.010Z
8659932 8659932 20251130113116_oJRJc US000E 2025-12-02T14:05:51.458Z 2025-12-05T14:30:37.252Z
8659906 8659906 20251130112855_XiRrD US000E 2025-12-02T14:05:47.257Z 2025-12-05T14:30:36.408Z
8659900 8659900 20251130112746_zWmoa US000E 2025-12-02T14:05:45.773Z 2025-12-05T14:30:35.969Z
8659876 8659876 20251130112506_ipQ3Y US000E 2025-12-02T14:05:40.976Z 2025-12-05T14:30:34.685Z
8659766 8659766 20251130111337_f9JB4 US000E 2025-12-02T14:05:15.903Z 2025-12-05T14:30:30.814Z
8659730 8659730 20251130110948_JSsG3 US000E 2025-12-02T14:05:09.636Z 2025-12-05T14:30:29.588Z
8659627 8659627 20251130105631_9gtik US000E 2025-12-02T14:04:40.592Z 2025-12-05T14:30:25.728Z
8659589 8659589 20251130105249_wdQIe US000E 2025-12-02T14:04:34.868Z 2025-12-05T14:30:24.399Z
8659538 8659538 20251130104305_hwGVh US000E 2025-12-02T14:04:21.514Z 2025-12-05T14:30:19.817Z
8659534 8659534 20251130104247_p3QV1 US000E 2025-12-02T14:04:21.108Z 2025-12-05T14:30:17.534Z
8659497 8659497 20251130103610_cUaDD US000E 2025-12-02T14:04:11.333Z 2025-12-05T14:30:11.396Z
8659351 8659351 20251130101318_m2wKm US000E 2025-12-02T14:03:34.735Z 2025-12-05T14:30:02.737Z
8659302 8659302 20251130100737_L5j7x US000E 2025-12-02T14:03:25.596Z 2025-12-05T14:30:00.906Z
8659266 8659266 20251130100131_5r3w8 US000E 2025-12-02T14:03:18.918Z 2025-12-05T14:29:59.576Z
8659192 8659192 20251130094320_RPRuO US000E 2025-12-02T14:02:53.332Z 2025-12-05T14:29:56.377Z
8659186 8659186 20251130094241_gPDtU US000E 2025-12-02T14:02:51.971Z 2025-12-05T14:29:56.025Z
8659055 8659055 20251130092620_8jelA US000E 2025-12-02T14:02:23.710Z 2025-12-05T14:29:51.401Z
8659025 8659025 20251130091851_yuLJ3 US000E 2025-12-02T14:02:14.741Z 2025-12-05T14:29:50.114Z
8648494 8648494 20251129080744_yPbvi US000E 2025-11-30T14:30:15.576Z 2025-12-05T14:53:30.590Z
8648396 8648396 20251129074336_1ZUiX US000E 2025-11-30T14:30:08.130Z 2025-12-05T14:53:21.328Z
8648378 8648378 20251129074058_jLVdn US000E 2025-11-30T14:30:07.118Z 2025-12-05T14:53:19.201Z

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