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 = "US000U" 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
9596313 9596313 20260330121839_1ZAo4 US000U 2026-03-31T12:04:00.808Z 2026-04-06T12:31:09.040Z
9596215 9596215 20260330114809_2VOen US000U 2026-03-31T12:03:45.058Z 2026-04-06T12:31:03.876Z
9596187 9596187 20260330113958_QPJfY US000U 2026-03-31T12:03:41.444Z 2026-04-06T12:31:02.315Z
9596044 9596044 20260330104751_jnR5W US000U 2026-03-31T12:03:13.321Z 2026-04-06T12:30:48.730Z
9593609 9593609 20260329121000_Mnzm4 US000U 2026-03-30T12:04:31.761Z 2026-04-06T12:35:30.136Z
9593496 9593496 20260329112500_gttx8 US000U 2026-03-30T12:04:10.779Z 2026-04-06T12:35:22.229Z
9593487 9593487 20260329111344_N1PDP US000U 2026-03-30T12:04:08.658Z 2026-04-06T12:35:21.712Z
9593441 9593441 20260329104646_ea3q1 US000U 2026-03-30T12:03:58.770Z 2026-04-06T12:35:19.067Z
9593413 9593413 20260329102317_QDwn2 US000U 2026-03-30T12:03:53.167Z 2026-04-06T12:35:17.300Z
9593406 9593406 20260329102221_7slRp US000U 2026-03-30T12:03:52.172Z 2026-04-06T12:35:16.987Z
9593279 9593279 20260329085501_OLzDR US000U 2026-03-30T12:03:29.492Z 2026-04-06T12:35:01.891Z
9593149 9593149 20260329065441_Ft0HF US000U 2026-03-30T12:03:07.598Z 2026-04-06T12:34:53.354Z
9593087 9593087 20260329053029_kFiMk US000U 2026-03-30T12:02:54.114Z 2026-04-06T12:34:49.676Z
9590783 9590783 20260328111601_2pMI0 US000U 2026-03-29T12:03:17.483Z 2026-04-06T12:38:34.583Z
9590763 9590763 20260328111130_1YlQp US000U 2026-03-29T12:03:14.297Z 2026-04-06T12:38:33.742Z
9590750 9590750 20260328110824_MELKw US000U 2026-03-29T12:03:12.984Z 2026-04-06T12:38:32.911Z
9590563 9590563 20260328100507_zhBR0 US000U 2026-03-29T12:02:54.928Z 2026-04-06T12:38:24.299Z
9590329 9590329 20260328081625_vqSts US000U 2026-03-29T12:02:25.785Z 2026-04-06T12:38:01.565Z
9590129 9590129 20260328064208_fyzvz US000U 2026-03-29T12:02:03.838Z 2026-04-06T12:37:52.204Z
9590118 9590118 20260328063833_kfmtv US000U 2026-03-29T12:02:02.487Z 2026-04-06T12:37:51.626Z
9590100 9590100 20260328053708_XbwBS US000U 2026-03-29T12:02:00.591Z 2026-04-06T12:37:50.731Z
9587389 9587389 20260327122446_kaYpU US000U 2026-03-28T12:05:25.015Z 2026-04-05T12:34:24.788Z
9587336 9587336 20260327121129_iJT0f US000U 2026-03-28T12:05:19.065Z 2026-04-05T12:34:22.679Z
9587071 9587071 20260327110434_gN8HT US000U 2026-03-28T12:04:43.681Z 2026-04-05T12:34:00.910Z
9586964 9586964 20260327103341_OeOnt US000U 2026-03-28T12:04:28.133Z 2026-04-05T12:33:56.468Z
9586911 9586911 20260327101718_uL1ic US000U 2026-03-28T12:04:21.105Z 2026-04-05T12:33:54.069Z
9586839 9586839 20260327095610_6l6I3 US000U 2026-03-28T12:04:12.506Z 2026-04-05T12:33:51.485Z
9586776 9586776 20260327093256_UEoIZ US000U 2026-03-28T12:03:59.872Z 2026-04-05T12:33:48.146Z
9586762 9586762 20260327092825_BJNZW US000U 2026-03-28T12:03:57.028Z 2026-04-05T12:33:47.277Z
9586741 9586741 20260327092313_D3qxJ US000U 2026-03-28T12:03:54.257Z 2026-04-05T12:33:46.242Z
9586693 9586693 20260327091335_S5X29 US000U 2026-03-28T12:03:46.714Z 2026-04-05T12:33:37.747Z
9586519 9586519 20260327080922_AaUg8 US000U 2026-03-28T12:03:19.511Z 2026-04-05T12:33:28.901Z
9586506 9586506 20260327080411_P3kyD US000U 2026-03-28T12:03:18.191Z 2026-04-05T12:33:28.505Z
9586410 9586410 20260327071435_vVx09 US000U 2026-03-28T12:03:01.604Z 2026-04-05T12:33:24.310Z
9586315 9586315 20260327060705_nLSGj US000U 2026-03-28T12:02:49.171Z 2026-04-05T12:33:20.523Z
9586292 9586292 20260327055455_cqBwX US000U 2026-03-28T12:02:44.296Z 2026-04-05T12:33:19.357Z
9583265 9583265 20260326120236_95Z1B US000U 2026-03-27T12:08:14.108Z 2026-04-04T12:40:59.109Z
9583259 9583259 20260326120020_hU3Oe US000U 2026-03-27T12:08:12.847Z 2026-04-04T12:40:58.852Z
9583227 9583227 20260326114456_XBOwW US000U 2026-03-27T12:08:08.275Z 2026-04-04T12:40:57.619Z
9583216 9583216 20260326114336_GIHaj US000U 2026-03-27T12:08:06.468Z 2026-04-04T12:40:57.221Z
9583138 9583138 20260326112029_ShLH8 US000U 2026-03-27T12:07:51.526Z 2026-04-04T12:40:53.715Z
9583076 9583076 20260326105033_NjExG US000U 2026-03-27T12:07:36.489Z 2026-04-04T12:40:44.493Z
9582895 9582895 20260326095717_iqF8v US000U 2026-03-27T12:07:09.683Z 2026-04-04T12:40:35.420Z
9582831 9582831 20260326094342_rQ3Lm US000U 2026-03-27T12:06:56.979Z 2026-04-04T12:40:31.037Z
9582737 9582737 20260326091624_XX3sr US000U 2026-03-27T12:06:38.423Z 2026-04-04T12:40:26.310Z
9582731 9582731 20260326091611_WAfv5 US000U 2026-03-27T12:06:38.018Z 2026-04-04T12:40:26.171Z
9582729 9582729 20260326091532_3OsFa US000U 2026-03-27T12:06:37.454Z 2026-04-04T12:40:25.989Z
9582627 9582627 20260326084527_S46Jh US000U 2026-03-27T12:06:22.933Z 2026-04-04T12:40:16.172Z
9582452 9582452 20260326074119_hEW0f US000U 2026-03-27T12:05:49.268Z 2026-04-04T12:40:01.754Z
9582416 9582416 20260326071955_1GdQj US000U 2026-03-27T12:05:42.815Z 2026-04-04T12:40:00.181Z
9582363 9582363 20260326070533_B8wYF US000U 2026-03-27T12:05:33.385Z 2026-04-04T12:39:58.050Z
9582355 9582355 20260326070149_WAmeO US000U 2026-03-27T12:05:31.416Z 2026-04-04T12:39:57.642Z
9582309 9582309 20260326064109_tm8sI US000U 2026-03-27T12:05:20.917Z 2026-04-04T12:39:49.907Z
9581402 9581402 20260326030732_DA6g3 US000U 2026-03-27T12:03:00.184Z 2026-04-04T12:39:03.446Z
9581398 9581398 20260326030657_y16xk US000U 2026-03-27T12:02:59.385Z 2026-04-04T12:39:03.354Z
9578593 9578593 20260325123147_k8r7q US000U 2026-03-26T12:08:03.252Z 2026-04-03T12:38:09.894Z
9578587 9578587 20260325122524_jV1LK US000U 2026-03-26T12:08:02.003Z 2026-04-03T12:38:09.511Z
9578542 9578542 20260325121336_99ZDt US000U 2026-03-26T12:07:52.158Z 2026-04-03T12:38:07.568Z
9578441 9578441 20260325115127_qP2GS US000U 2026-03-26T12:07:39.325Z 2026-04-03T12:38:03.824Z
9578162 9578162 20260325103702_9SQHd US000U 2026-03-26T12:06:53.040Z 2026-04-03T12:37:41.766Z
9578135 9578135 20260325101935_YjHah US000U 2026-03-26T12:06:49.107Z 2026-04-03T12:37:38.685Z
9578124 9578124 20260325101248_G13Z0 US000U 2026-03-26T12:06:47.677Z 2026-04-03T12:37:38.249Z
9578071 9578071 20260325095321_KT894 US000U 2026-03-26T12:06:41.284Z 2026-04-03T12:37:35.968Z
9577962 9577962 20260325092432_1nuYU US000U 2026-03-26T12:06:27.398Z 2026-04-03T12:37:32.661Z
9577935 9577935 20260325091750_XqWmI US000U 2026-03-26T12:06:22.776Z 2026-04-03T12:37:31.566Z
9577924 9577924 20260325091556_MYY2Q US000U 2026-03-26T12:06:21.538Z 2026-04-03T12:37:31.209Z
9577871 9577871 20260325090802_787GF US000U 2026-03-26T12:06:16.457Z 2026-04-03T12:37:29.732Z
9577838 9577838 20260325085519_kIAml US000U 2026-03-26T12:06:12.300Z 2026-04-03T12:37:28.749Z
9577737 9577737 20260325082056_f73TQ US000U 2026-03-26T12:05:57.898Z 2026-04-03T12:37:25.219Z
9577710 9577710 20260325081143_udxAK US000U 2026-03-26T12:05:54.829Z 2026-04-03T12:37:24.151Z
9577609 9577609 20260325074350_wFraD US000U 2026-03-26T12:05:37.907Z 2026-04-03T12:37:10.515Z
9577588 9577588 20260325073519_MkRkC US000U 2026-03-26T12:05:35.315Z 2026-04-03T12:37:09.543Z
9577308 9577308 20260325044831_L82ry US000U 2026-03-26T12:04:44.576Z 2026-04-03T12:36:56.149Z
9577196 9577196 20260325041053_DSnRQ US000U 2026-03-26T12:04:22.523Z 2026-04-03T12:36:44.253Z
9573450 9573450 20260324121132_7C5YZ US000U 2026-03-25T12:08:02.501Z 2026-04-02T12:36:09.776Z
9573441 9573441 20260324120848_abImv US000U 2026-03-25T12:08:01.446Z 2026-04-02T12:36:09.061Z
9573349 9573349 20260324115454_V09rI US000U 2026-03-25T12:07:47.244Z 2026-04-02T12:36:05.747Z
9573316 9573316 20260324114850_d58zI US000U 2026-03-25T12:07:42.751Z 2026-04-02T12:36:04.258Z
9573173 9573173 20260324112705_FWMor US000U 2026-03-25T12:07:19.763Z 2026-04-02T12:35:58.421Z
9572962 9572962 20260324110250_iOq25 US000U 2026-03-25T12:06:51.844Z 2026-04-02T12:35:45.426Z
9572958 9572958 20260324110210_c1cOp US000U 2026-03-25T12:06:51.200Z 2026-04-02T12:35:45.274Z
9572943 9572943 20260324105850_NTEa2 US000U 2026-03-25T12:06:47.638Z 2026-04-02T12:35:44.426Z
9572921 9572921 20260324105131_awhNK US000U 2026-03-25T12:06:43.746Z 2026-04-02T12:35:43.646Z
9572910 9572910 20260324105059_rvTS4 US000U 2026-03-25T12:06:42.545Z 2026-04-02T12:35:43.419Z
9572890 9572890 20260324104558_El039 US000U 2026-03-25T12:06:38.837Z 2026-04-02T12:35:42.761Z
9572847 9572847 20260324104117_gH2L9 US000U 2026-03-25T12:06:30.029Z 2026-04-02T12:35:40.407Z
9572813 9572813 20260324102841_qFu86 US000U 2026-03-25T12:06:22.706Z 2026-04-02T12:35:39.174Z
9572740 9572740 20260324100457_jkWfo US000U 2026-03-25T12:06:10.942Z 2026-04-02T12:35:36.847Z
9572604 9572604 20260324093658_DP3mA US000U 2026-03-25T12:05:44.008Z 2026-04-02T12:35:31.494Z
9572437 9572437 20260324090409_8bmUF US000U 2026-03-25T12:05:10.165Z 2026-04-02T12:35:24.939Z
9572427 9572427 20260324090248_SENuC US000U 2026-03-25T12:05:06.006Z 2026-04-02T12:35:24.613Z
9572267 9572267 20260324082256_lPL8d US000U 2026-03-25T12:04:29.888Z 2026-04-02T12:35:11.701Z
9572248 9572248 20260324081816_3gV8F US000U 2026-03-25T12:04:25.066Z 2026-04-02T12:35:10.723Z
9572068 9572068 20260324072107_n0k6h US000U 2026-03-25T12:03:39.633Z 2026-04-02T12:35:01.568Z
9571979 9571979 20260324063938_seEtl US000U 2026-03-25T12:03:24.486Z 2026-04-02T12:34:57.888Z
9571972 9571972 20260324063856_pLhFD US000U 2026-03-25T12:03:23.496Z 2026-04-02T12:34:57.672Z
9571960 9571960 20260324062851_0iAP8 US000U 2026-03-25T12:03:21.939Z 2026-04-02T12:34:57.255Z
9571856 9571856 20260324052102_ZJ33n US000U 2026-03-25T12:03:00.495Z 2026-04-02T12:34:52.616Z
9571787 9571787 20260324041540_CE9wV US000U 2026-03-25T12:02:41.750Z 2026-04-02T12:34:48.788Z
9571736 9571736 20260324034721_E39ro US000U 2026-03-25T12:02:31.160Z 2026-04-02T12:34:41.671Z

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