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

3,283 rows where station_code = "HR002E" 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
8667296 8667296 20251129210900_9CMhn HR002E 2025-12-02T14:36:32.842Z 2025-12-05T14:41:14.831Z
8665554 8665554 20251201033426_nXE9q HR002E 2025-12-02T14:23:53.586Z 2025-12-05T14:36:11.528Z
8665413 8665413 20251201031809_QlIh2 HR002E 2025-12-02T14:23:39.550Z 2025-12-05T14:35:59.874Z
8664902 8664902 20251201020115_CbIPf HR002E 2025-12-02T14:22:25.065Z 2025-12-05T14:35:35.772Z
8664751 8664751 20251201013426_WzEXZ HR002E 2025-12-02T14:22:01.319Z 2025-12-05T14:35:16.846Z
8664711 8664711 20251201013021_yLJCU HR002E 2025-12-02T14:21:57.121Z 2025-12-05T14:35:15.699Z
8656827 8656827 20251130051240_BH2BX HR002E 2025-12-01T14:29:04.156Z 2025-12-05T14:45:22.086Z
8656798 8656798 20251130050951_Jou2y HR002E 2025-12-01T14:29:00.939Z 2025-12-05T14:45:21.420Z
8656732 8656732 20251130050756_VoP8i HR002E 2025-12-01T14:28:58.462Z 2025-12-05T14:45:20.326Z
8656491 8656491 20251130045725_FwetB HR002E 2025-12-01T14:28:41.840Z 2025-12-01T14:28:41.840Z
8656466 8656466 20251130045643_TsxFI HR002E 2025-12-01T14:28:39.909Z 2025-12-05T14:45:16.451Z
8656417 8656417 20251130045547_KSlzT HR002E 2025-12-01T14:28:37.454Z 2025-12-01T14:28:37.454Z
8656394 8656394 20251130045237_2UHAG HR002E 2025-12-01T14:28:35.513Z 2025-12-01T14:28:35.513Z
8655882 8655882 20251130042227_F9waQ HR002E 2025-12-01T14:27:35.279Z 2025-12-05T14:44:40.554Z
8654987 8654987 20251130034024_tBK2i HR002E 2025-12-01T14:26:14.471Z 2025-12-05T14:44:26.606Z
8654895 8654895 20251130033816_iQdvv HR002E 2025-12-01T14:26:09.817Z 2025-12-05T14:44:25.683Z
8654610 8654610 20251130032230_yTQha HR002E 2025-12-01T14:25:37.444Z 2025-12-01T14:25:37.444Z
8654508 8654508 20251130031903_mi8Rs HR002E 2025-12-01T14:25:31.968Z 2025-12-05T14:44:07.906Z
8654494 8654494 20251130031826_C2oQG HR002E 2025-12-01T14:25:29.746Z 2025-12-01T14:25:29.746Z
8654491 8654491 20251130031824_OODgq HR002E 2025-12-01T14:25:29.449Z 2025-12-05T14:44:06.037Z
8654060 8654060 20251130025549_e5xJm HR002E 2025-12-01T14:24:47.978Z 2025-12-05T14:43:45.884Z
8653956 8653956 20251130024916_hzBKG HR002E 2025-12-01T14:24:32.545Z 2025-12-05T14:43:43.458Z
8653889 8653889 20251130024650_oRt0a HR002E 2025-12-01T14:24:26.094Z 2025-12-05T14:43:42.271Z
8653823 8653823 20251130024312_b08Li HR002E 2025-12-01T14:24:19.528Z 2025-12-05T14:43:40.682Z
8653675 8653675 20251130023338_D1wZ5 HR002E 2025-12-01T14:23:54.867Z 2025-12-05T14:43:37.336Z
8653633 8653633 20251130023204_XQNJs HR002E 2025-12-01T14:23:52.387Z 2025-12-01T14:35:22.380Z
8653627 8653627 20251130023121_JZjke HR002E 2025-12-01T14:23:50.953Z 2025-12-05T14:43:36.586Z
8653624 8653624 20251130023113_HgVEy HR002E 2025-12-01T14:23:49.253Z 2025-12-05T14:43:36.433Z
8653526 8653526 20251130022242_a3yR9 HR002E 2025-12-01T14:23:39.158Z 2025-12-05T14:43:34.081Z
8653478 8653478 20251130021816_vPzLQ HR002E 2025-12-01T14:23:33.719Z 2025-12-05T14:43:32.402Z
8653331 8653331 20251130021047_Mg5iU HR002E 2025-12-01T14:23:15.102Z 2025-12-05T14:43:29.170Z
8653145 8653145 20251130020019_CmREW HR002E 2025-12-01T14:22:53.247Z 2025-12-05T14:43:04.615Z
8652877 8652877 20251130014240_c4YxS HR002E 2025-12-01T14:22:26.811Z 2025-12-05T14:42:56.396Z
8652874 8652874 20251130014237_dYuER HR002E 2025-12-01T14:22:26.197Z 2025-12-05T14:42:55.959Z
8652701 8652701 20251130012750_k5isq HR002E 2025-12-01T14:22:00.165Z 2025-12-05T14:42:50.427Z
8652649 8652649 20251130012622_43YZd HR002E 2025-12-01T14:21:55.410Z 2025-12-05T14:42:49.435Z
8652583 8652583 20251130012219_vmj9F HR002E 2025-12-01T14:21:48.455Z 2025-12-05T14:42:48.254Z
8652502 8652502 20251130011302_sFpWA HR002E 2025-12-01T14:21:32.432Z 2025-12-05T14:42:45.919Z
8652324 8652324 20251130010256_XzzmV HR002E 2025-12-01T14:21:16.148Z 2025-12-05T14:42:42.825Z
8652088 8652088 20251130004521_QSbhF HR002E 2025-12-01T14:20:41.514Z 2025-12-05T14:42:17.805Z
8651980 8651980 20251130003910_KrMXx HR002E 2025-12-01T14:20:23.123Z 2025-12-05T14:42:12.799Z
8651961 8651961 20251130003735_iGuZS HR002E 2025-12-01T14:20:20.504Z 2025-12-05T14:42:12.471Z
8651942 8651942 20251130003547_Ft3sV HR002E 2025-12-01T14:20:18.593Z 2025-12-05T14:42:12.029Z
8651916 8651916 20251130003407_iTV6s HR002E 2025-12-01T14:20:15.828Z 2025-12-05T14:42:11.377Z
8651913 8651913 20251130003403_N654A HR002E 2025-12-01T14:20:15.460Z 2025-12-05T14:42:11.340Z
8651860 8651860 20251130002745_rYvLf HR002E 2025-12-01T14:20:08.277Z 2025-12-05T14:42:07.936Z
8651758 8651758 20251130001640_uOVAZ HR002E 2025-12-01T14:19:49.871Z 2025-12-05T14:42:05.244Z
8651691 8651691 20251130001050_VEWT1 HR002E 2025-12-01T14:19:41.558Z 2025-12-05T14:42:03.568Z
8651608 8651608 20251130000135_kMFbz HR002E 2025-12-01T14:19:27.392Z 2025-12-05T14:42:01.847Z
8651513 8651513 20251129235146_f9D89 HR002E 2025-12-01T14:19:15.039Z 2025-12-05T14:41:59.508Z
8651372 8651372 20251129233353_ve28d HR002E 2025-12-01T14:18:54.716Z 2025-12-05T14:41:56.520Z
8651299 8651299 20251129232223_dSeBT HR002E 2025-12-01T14:18:42.130Z 2025-12-05T14:41:54.094Z
8651288 8651288 20251129232157_nxbn0 HR002E 2025-12-01T14:18:40.803Z 2025-12-05T14:41:53.902Z
8651145 8651145 20251129224757_jFirR HR002E 2025-12-01T14:18:07.816Z 2025-12-05T14:41:50.131Z
8651057 8651057 20251129223511_k7w9K HR002E 2025-12-01T14:17:55.366Z 2025-12-05T14:41:47.978Z
8651023 8651023 20251129222437_5NpBg HR002E 2025-12-01T14:17:51.787Z 2025-12-05T14:41:34.429Z
8650942 8650942 20251129220903_aARHc HR002E 2025-12-01T14:17:35.075Z 2025-12-05T14:41:23.156Z
8650911 8650911 20251129220157_Hhx5l HR002E 2025-12-01T14:17:30.737Z 2025-12-05T14:41:22.373Z
8650863 8650863 20251129214614_0o3vs HR002E 2025-12-01T14:17:21.040Z 2025-12-05T14:41:21.272Z
8650752 8650752 20251129212124_RvGtz HR002E 2025-12-01T14:17:05.439Z 2025-12-05T14:41:16.360Z
8650454 8650454 20251129202338_vcKiE HR002E 2025-12-01T14:16:15.177Z 2025-12-05T14:41:08.191Z
8650451 8650451 20251129202206_PTI1T HR002E 2025-12-01T14:16:14.733Z 2025-12-05T14:41:08.051Z
8650440 8650440 20251129201934_4z8lA HR002E 2025-12-01T14:16:12.251Z 2025-12-05T14:41:07.507Z
8650359 8650359 20251129195951_inwjm HR002E 2025-12-01T14:15:53.538Z 2025-12-05T14:41:04.838Z
8649201 8649201 20251129163652_4v2mu HR002E 2025-12-01T14:11:25.941Z 2025-12-05T14:39:59.867Z
8647496 8647496 20251129044534_g20rx HR002E 2025-11-30T14:28:30.326Z 2025-12-05T14:52:41.389Z
8647389 8647389 20251129042907_ILFGS HR002E 2025-11-30T14:28:04.810Z 2025-12-05T14:52:38.941Z
8646841 8646841 20251129030043_FF7lg HR002E 2025-11-30T14:27:01.366Z 2025-12-05T14:51:55.227Z
8646820 8646820 20251129025939_KZg3n HR002E 2025-11-30T14:26:59.968Z 2025-12-05T14:51:54.836Z
8646809 8646809 20251129025813_olxRA HR002E 2025-11-30T14:26:59.383Z 2025-12-05T14:51:54.699Z
8646597 8646597 20251129022848_JsRZN HR002E 2025-11-30T14:26:14.929Z 2025-12-05T14:51:45.243Z
8646585 8646585 20251129022542_Mizb2 HR002E 2025-11-30T14:26:13.632Z 2025-12-05T14:51:44.982Z
8646549 8646549 20251129022023_fJpps HR002E 2025-11-30T14:26:08.893Z 2025-12-05T14:51:44.173Z
8646458 8646458 20251129020836_R3BwX HR002E 2025-11-30T14:26:01.260Z 2025-12-05T14:51:42.484Z
8646220 8646220 20251129012658_zOn4z HR002E 2025-11-30T14:25:26.942Z 2025-12-05T14:51:36.225Z
8646182 8646182 20251129012008_2FOJY HR002E 2025-11-30T14:25:22.392Z 2025-12-05T14:51:35.097Z
8645813 8645813 20251128235353_4ugN1 HR002E 2025-11-30T14:24:34.876Z 2025-12-05T14:51:14.813Z
8645287 8645287 20251128211243_lX4zS HR002E 2025-11-30T14:23:31.636Z 2025-12-05T14:50:35.925Z
8645277 8645277 20251128211047_BGd5E HR002E 2025-11-30T14:23:30.853Z 2025-12-05T14:50:35.710Z
8644824 8644824 20251128200234_AUUhh HR002E 2025-11-30T14:22:45.243Z 2025-12-05T14:50:27.517Z
8644482 8644482 20251128192829_iVUq4 HR002E 2025-11-30T14:22:01.867Z 2025-12-05T14:50:22.635Z
8644231 8644231 20251128190942_Mq7IO HR002E 2025-11-30T14:21:29.842Z 2025-12-05T14:50:18.342Z
8643982 8643982 20251128184657_PLUL8 HR002E 2025-11-30T14:20:57.066Z 2025-12-05T14:50:13.255Z
8636499 8636499 20251128035237_3O5Me HR002E 2025-11-29T14:25:35.071Z 2025-12-05T14:59:25.029Z
8636431 8636431 20251128034607_m55I3 HR002E 2025-11-29T14:25:29.928Z 2025-12-05T14:59:24.095Z
8636313 8636313 20251128033603_FWkPJ HR002E 2025-11-29T14:25:22.789Z 2025-12-05T14:59:22.808Z
8636043 8636043 20251128030938_SFN2s HR002E 2025-11-29T14:24:50.026Z 2025-12-05T14:59:18.557Z
8635949 8635949 20251128030145_5JQYd HR002E 2025-11-29T14:24:41.318Z 2025-12-05T14:59:17.207Z
8635943 8635943 20251128030121_usIHW HR002E 2025-11-29T14:24:40.925Z 2025-12-05T14:59:17.169Z
8635778 8635778 20251128024729_h4ZP3 HR002E 2025-11-29T14:24:09.041Z 2025-12-05T14:59:14.564Z
8635635 8635635 20251128023410_U5bdh HR002E 2025-11-29T14:23:57.892Z 2025-12-05T14:59:12.389Z
8635396 8635396 20251128020931_DnIYR HR002E 2025-11-29T14:23:20.411Z 2025-12-05T14:58:34.756Z
8635341 8635341 20251128020456_heyNR HR002E 2025-11-29T14:23:05.241Z 2025-12-05T14:58:34.242Z
8635248 8635248 20251128015636_jFtDc HR002E 2025-11-29T14:22:54.237Z 2025-12-05T14:58:32.960Z
8635223 8635223 20251128015424_AXdR7 HR002E 2025-11-29T14:22:51.579Z 2025-12-05T14:58:32.411Z
8635217 8635217 20251128015333_xAA5a HR002E 2025-11-29T14:22:50.823Z 2025-12-05T14:58:32.222Z
8635104 8635104 20251128014156_TmUsR HR002E 2025-11-29T14:22:40.869Z 2025-12-05T14:58:30.505Z
8635081 8635081 20251128014006_d9Nr3 HR002E 2025-11-29T14:22:38.907Z 2025-12-05T14:58:29.058Z
8635060 8635060 20251128013822_Y2Hnx HR002E 2025-11-29T14:22:36.668Z 2025-12-05T14:58:28.525Z
8634978 8634978 20251128013215_dw4hR HR002E 2025-11-29T14:22:20.616Z 2025-12-05T14:58:27.213Z

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