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

919 rows where station_code = "US005Q" 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
8687055 8687055 20251204022943_upGbB US005Q 2025-12-05T14:13:45.081Z 2025-12-05T14:14:35.590Z
8687029 8687029 20251204015046_fzesP US005Q 2025-12-05T14:13:30.894Z 2025-12-05T14:14:35.573Z
8684114 8684114 20251204104727_Afxxh US005Q 2025-12-05T14:01:58.006Z 2025-12-05T14:01:58.006Z
8684096 8684096 20251204104142_TOJwu US005Q 2025-12-05T14:01:54.965Z 2025-12-05T14:01:54.965Z
8670377 8670377 20251201080028_TnT9r US005Q 2025-12-03T14:08:25.486Z 2025-12-05T14:23:18.386Z
8666899 8666899 20251201070049_PzQdu US005Q 2025-12-02T14:30:41.631Z 2025-12-05T14:37:03.702Z
8648430 8648430 20251129074905_wuqxV US005Q 2025-11-30T14:30:09.764Z 2025-12-05T14:53:24.896Z
8646663 8646663 20251129023739_vQ4er US005Q 2025-11-30T14:26:37.967Z 2025-12-05T14:51:46.825Z
8646491 8646491 20251129021117_BuDe5 US005Q 2025-11-30T14:26:04.280Z 2025-12-05T14:51:43.184Z
8639334 8639334 20251129105444_sBHmv US005Q 2025-11-30T14:04:36.157Z 2025-12-05T14:38:18.114Z
8639146 8639146 20251129103302_aMQtb US005Q 2025-11-30T14:03:53.563Z 2025-12-05T14:37:56.908Z
8638100 8638100 20251128082526_Br3CU US005Q 2025-11-29T14:28:30.083Z 2025-12-05T15:00:46.110Z
8637998 8637998 20251128075504_YGRhh US005Q 2025-11-29T14:28:23.365Z 2025-12-05T15:00:42.044Z
8637946 8637946 20251128073604_SFkj1 US005Q 2025-11-29T14:28:18.854Z 2025-12-05T15:00:37.417Z
8637913 8637913 20251128072856_g2Zwt US005Q 2025-11-29T14:28:06.474Z 2025-12-05T15:00:34.330Z
8637899 8637899 20251128072339_ysHlS US005Q 2025-11-29T14:28:00.014Z 2025-12-05T15:00:33.949Z
8637629 8637629 20251128060030_3h0E6 US005Q 2025-11-29T14:27:37.922Z 2025-12-05T15:00:10.985Z
8626593 8626593 20251128091013_FtkF6 US005Q 2025-11-29T14:00:59.081Z 2025-12-05T14:46:14.463Z
8626535 8626535 20251128085653_BWG0P US005Q 2025-11-29T14:00:39.757Z 2025-12-05T14:46:12.682Z
8626402 8626402 20251128083345_RDm5l US005Q 2025-11-29T14:00:14.751Z 2025-12-05T14:46:10.272Z
8623800 8623800 20251127020515_YZzE0 US005Q 2025-11-28T14:22:54.745Z 2025-12-05T15:04:17.608Z
8592847 8592847 20251124093427_SWSPQ US005Q 2025-11-25T14:28:07.519Z 2025-12-02T15:13:08.050Z
8592809 8592809 20251124092816_UPQfe US005Q 2025-11-25T14:28:01.028Z 2025-12-02T15:13:07.689Z
8592729 8592729 20251124091258_22wuv US005Q 2025-11-25T14:27:32.558Z 2025-12-02T15:13:06.821Z
8592666 8592666 20251124085436_B6iYT US005Q 2025-11-25T14:27:25.654Z 2025-12-02T15:13:06.148Z
8592608 8592608 20251124084153_2b0rJ US005Q 2025-11-25T14:27:19.149Z 2025-12-02T15:13:05.550Z
8592532 8592532 20251124081325_mtQFC US005Q 2025-11-25T14:26:56.016Z 2025-12-02T15:13:04.884Z
8592526 8592526 20251124081237_EFxml US005Q 2025-11-25T14:26:55.067Z 2025-12-02T15:13:04.836Z
8592520 8592520 20251124081136_1NDrO US005Q 2025-11-25T14:26:54.269Z 2025-12-02T15:13:04.796Z
8592465 8592465 20251124074558_Kg9ut US005Q 2025-11-25T14:26:46.965Z 2025-12-02T15:13:04.321Z
8592408 8592408 20251124072545_YEtBh US005Q 2025-11-25T14:26:40.859Z 2025-12-02T15:13:03.889Z
8592392 8592392 20251124071646_2xZr0 US005Q 2025-11-25T14:26:39.237Z 2025-12-02T15:13:03.764Z
8592384 8592384 20251124071119_Efr0E US005Q 2025-11-25T14:26:37.695Z 2025-12-02T15:13:03.671Z
8591731 8591731 20251124044855_a43Lj US005Q 2025-11-25T14:25:01.976Z 2025-12-02T15:13:00.206Z
8591093 8591093 20251124034608_5XIcH US005Q 2025-11-25T14:23:35.665Z 2025-12-02T15:12:57.050Z
8590884 8590884 20251124032328_UyEKh US005Q 2025-11-25T14:22:59.389Z 2025-12-02T15:12:55.971Z
8589951 8589951 20251124021021_zJo59 US005Q 2025-11-25T14:20:59.795Z 2025-12-02T15:12:40.486Z
8589726 8589726 20251124014850_kwn5M US005Q 2025-11-25T14:20:26.083Z 2025-12-02T15:12:34.301Z
8587837 8587837 20251123225044_9V23y US005Q 2025-11-25T14:16:09.542Z 2025-12-02T15:11:20.313Z
8583313 8583313 20251124102629_PqwUz US005Q 2025-11-25T14:01:17.779Z 2025-12-02T15:05:28.542Z
8583193 8583193 20251124095624_kcM2o US005Q 2025-11-25T14:00:40.904Z 2025-12-02T15:05:26.654Z
8583125 8583125 20251124093944_Joqgq US005Q 2025-11-25T14:00:20.715Z 2025-12-02T15:05:25.744Z
8582179 8582179 20251123042914_GvREd US005Q 2025-11-24T14:33:21.117Z 2025-12-01T15:22:17.922Z
8581301 8581301 20251122225947_Ol4ks US005Q 2025-11-24T14:31:24.599Z 2025-12-01T15:20:12.150Z
8525473 8525473 20251118105737_qQFgg US005Q 2025-11-20T14:36:59.410Z 2025-11-26T15:08:29.886Z
8525390 8525390 20251118104418_V5nJJ US005Q 2025-11-20T14:36:54.903Z 2025-11-26T15:08:28.196Z
8525373 8525373 20251118104151_somhS US005Q 2025-11-20T14:36:54.040Z 2025-11-26T15:08:26.235Z
8525358 8525358 20251118103851_bNa6j US005Q 2025-11-20T14:36:53.164Z 2025-11-26T15:08:25.957Z
8517207 8517207 20251118101954_DUgf6 US005Q 2025-11-19T14:42:57.326Z 2025-11-26T15:08:23.772Z
8517023 8517023 20251118093352_m62T0 US005Q 2025-11-19T14:42:22.807Z 2025-11-26T15:08:18.058Z
8516981 8516981 20251118092623_ALIg4 US005Q 2025-11-19T14:42:20.378Z 2025-11-26T15:08:17.122Z
8516913 8516913 20251118090616_6Nl1r US005Q 2025-11-19T14:42:17.311Z 2025-11-26T15:08:11.392Z
8516911 8516911 20251118090531_KKsJ3 US005Q 2025-11-19T14:42:17.151Z 2025-11-26T15:08:11.390Z
8516863 8516863 20251118084949_devkh US005Q 2025-11-19T14:42:14.966Z 2025-11-26T15:08:10.587Z
8516844 8516844 20251118084422_Hi4pw US005Q 2025-11-19T14:42:14.441Z 2025-11-19T14:42:14.441Z
8516775 8516775 20251118082944_h4vDD US005Q 2025-11-19T14:42:11.645Z 2025-11-26T15:08:09.226Z
8516749 8516749 20251118082406_rwXAN US005Q 2025-11-19T14:42:10.858Z 2025-11-26T15:08:09.154Z
8516747 8516747 20251118082355_roo5G US005Q 2025-11-19T14:42:10.750Z 2025-11-26T15:08:09.150Z
8516735 8516735 20251118082016_dPIxV US005Q 2025-11-19T14:42:09.985Z 2025-11-26T15:08:08.979Z
8516642 8516642 20251118075903_OvdGT US005Q 2025-11-19T14:42:06.680Z 2025-11-26T15:08:08.580Z
8516588 8516588 20251118074555_62h0D US005Q 2025-11-19T14:41:50.350Z 2025-11-26T15:08:08.324Z
8516511 8516511 20251118072237_ROTw5 US005Q 2025-11-19T14:41:39.858Z 2025-11-26T15:08:07.999Z
8516464 8516464 20251118070052_nru8K US005Q 2025-11-19T14:41:30.287Z 2025-11-26T15:08:07.686Z
8516329 8516329 20251118062312_L1bQs US005Q 2025-11-19T14:40:53.274Z 2025-11-26T15:08:06.945Z
8516210 8516210 20251118060210_GnLXx US005Q 2025-11-19T14:40:35.749Z 2025-11-26T15:08:06.512Z
8515828 8515828 20251118051056_cTLdU US005Q 2025-11-19T14:39:59.468Z 2025-11-26T15:08:04.464Z
8514882 8514882 20251118032103_I3xZr US005Q 2025-11-19T14:38:30.986Z 2025-11-26T15:07:57.704Z
8514803 8514803 20251118031100_5LrQx US005Q 2025-11-19T14:38:28.053Z 2025-11-26T15:07:57.174Z
8514787 8514787 20251118030907_ZNtER US005Q 2025-11-19T14:38:27.767Z 2025-11-26T15:07:57.103Z
8514716 8514716 20251118025529_XuGLm US005Q 2025-11-19T14:38:25.367Z 2025-11-26T15:07:56.436Z
8514565 8514565 20251118023610_pC9N0 US005Q 2025-11-19T14:38:19.944Z 2025-11-26T15:07:55.232Z
8498658 8498658 20251117103714_NXXq1 US005Q 2025-11-18T14:30:46.711Z 2025-11-25T15:11:29.056Z
8498650 8498650 20251117101631_k2C7w US005Q 2025-11-18T14:30:46.088Z 2025-11-25T15:11:27.581Z
8498639 8498639 20251117100451_421S8 US005Q 2025-11-18T14:30:44.518Z 2025-11-25T15:11:26.470Z
8498634 8498634 20251117100322_u5eXi US005Q 2025-11-18T14:30:44.079Z 2025-11-25T15:11:25.920Z
8498632 8498632 20251117095753_VB345 US005Q 2025-11-18T14:30:43.752Z 2025-11-25T15:11:25.648Z
8498585 8498585 20251117085726_jsyvH US005Q 2025-11-18T14:30:37.323Z 2025-11-25T15:11:17.889Z
8498567 8498567 20251117083941_eUeo9 US005Q 2025-11-18T14:30:34.950Z 2025-11-25T15:11:16.499Z
8498560 8498560 20251117083040_37Vd4 US005Q 2025-11-18T14:30:34.012Z 2025-11-25T15:11:15.762Z
8498556 8498556 20251117082449_w4N7K US005Q 2025-11-18T14:30:33.515Z 2025-11-25T15:11:15.378Z
8498552 8498552 20251117082036_rZIBc US005Q 2025-11-18T14:30:33.213Z 2025-11-25T15:11:14.869Z
8498545 8498545 20251117081442_zfiLR US005Q 2025-11-18T14:30:32.573Z 2025-11-25T15:11:14.609Z
8498517 8498517 20251117074917_r5sC7 US005Q 2025-11-18T14:30:30.550Z 2025-11-25T15:11:13.434Z
8497887 8497887 20251117055549_2MOai US005Q 2025-11-18T14:29:36.306Z 2025-11-25T15:10:55.991Z
8495836 8495836 20251117041220_rjw0f US005Q 2025-11-18T14:26:51.998Z 2025-11-25T15:10:04.645Z
8495808 8495808 20251117041030_PSM3j US005Q 2025-11-18T14:26:49.847Z 2025-11-25T15:10:01.052Z
8493787 8493787 20251117020715_BEwiX US005Q 2025-11-18T14:23:01.405Z 2025-11-25T15:09:22.127Z
8492857 8492857 20251117005510_18AMn US005Q 2025-11-18T14:20:44.951Z 2025-11-25T15:08:57.148Z
8492521 8492521 20251117003225_hNlpx US005Q 2025-11-18T14:20:09.687Z 2025-11-25T15:08:52.318Z
8461702 8461702 20251114095507_L7mgW US005Q 2025-11-15T14:24:46.828Z 2025-11-22T15:23:37.233Z
8461475 8461475 20251114092425_7aMfB US005Q 2025-11-15T14:24:19.409Z 2025-11-22T15:23:26.892Z
8461174 8461174 20251114084911_w4HVw US005Q 2025-11-15T14:23:57.173Z 2025-11-22T15:23:14.328Z
8460815 8460815 20251114075852_QYYLJ US005Q 2025-11-15T14:22:53.981Z 2025-11-22T15:22:49.178Z
8460777 8460777 20251114075159_306eG US005Q 2025-11-15T14:22:50.102Z 2025-11-22T15:22:48.167Z
8460607 8460607 20251114072502_UWBi9 US005Q 2025-11-15T14:22:22.534Z 2025-11-22T15:22:43.163Z
8460431 8460431 20251114070119_7UrCf US005Q 2025-11-15T14:22:06.303Z 2025-11-22T15:22:37.815Z
8460367 8460367 20251114064612_m13Gc US005Q 2025-11-15T14:22:01.851Z 2025-11-22T15:22:34.524Z
8460175 8460175 20251114061002_dQxRV US005Q 2025-11-15T14:21:29.557Z 2025-11-22T15:22:25.307Z
8459975 8459975 20251114052137_DJoCl US005Q 2025-11-15T14:21:10.418Z 2025-11-22T15:22:20.675Z
8459766 8459766 20251114044303_nEwyr US005Q 2025-11-15T14:20:34.878Z 2025-11-22T15:22:11.748Z

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