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,996 rows where station_code = "KR001E" 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
8686845 8686845 20251203210210_xbxBi KR001E 2025-12-05T14:13:01.809Z 2025-12-05T14:14:35.502Z
8686703 8686703 20251203203707_oAftO KR001E 2025-12-05T14:12:38.727Z 2025-12-05T14:14:35.465Z
8686633 8686633 20251203202155_AGRTy KR001E 2025-12-05T14:12:31.190Z 2025-12-05T14:14:35.444Z
8686604 8686604 20251203201448_vqZM1 KR001E 2025-12-05T14:12:28.871Z 2025-12-05T14:14:35.437Z
8686546 8686546 20251203200109_87q9q KR001E 2025-12-05T14:12:12.746Z 2025-12-05T14:14:35.419Z
8686509 8686509 20251203195658_CFTHX KR001E 2025-12-05T14:12:04.196Z 2025-12-05T14:14:35.409Z
8686415 8686415 20251203194333_p83Uj KR001E 2025-12-05T14:11:51.050Z 2025-12-05T14:14:35.384Z
8686401 8686401 20251203194243_GgWNa KR001E 2025-12-05T14:11:50.685Z 2025-12-05T14:14:35.382Z
8686373 8686373 20251203193848_lUKaV KR001E 2025-12-05T14:11:49.143Z 2025-12-05T14:14:35.378Z
8686226 8686226 20251203191237_OEF2U KR001E 2025-12-05T14:11:16.192Z 2025-12-05T14:14:35.327Z
8673146 8673146 20251201171006_L72lL KR001E 2025-12-03T14:17:39.925Z 2025-12-05T14:26:12.485Z
8673029 8673029 20251201162545_4Txg3 KR001E 2025-12-03T14:17:09.329Z 2025-12-05T14:25:54.990Z
8672689 8672689 20251201150711_Jtj0U KR001E 2025-12-03T14:16:10.088Z 2025-12-05T14:25:38.739Z
8671701 8671701 20251201125020_rsLur KR001E 2025-12-03T14:13:21.833Z 2025-12-05T14:24:41.068Z
8671649 8671649 20251201124535_XAnt8 KR001E 2025-12-03T14:13:15.492Z 2025-12-05T14:24:38.972Z
8671534 8671534 20251201123023_uA6mZ KR001E 2025-12-03T14:12:56.436Z 2025-12-05T14:24:33.020Z
8671265 8671265 20251201115015_9KMIV KR001E 2025-12-03T14:11:57.831Z 2025-12-05T14:24:20.819Z
8670666 8670666 20251201095427_33UCB KR001E 2025-12-03T14:09:41.198Z 2025-12-05T14:23:44.159Z
8663528 8663528 20251130205640_hs7m7 KR001E 2025-12-02T14:18:24.581Z 2025-12-05T14:34:22.780Z
8663449 8663449 20251130204810_v3CCk KR001E 2025-12-02T14:18:18.416Z 2025-12-05T14:34:09.916Z
8663301 8663301 20251130202841_PcngH KR001E 2025-12-02T14:17:57.246Z 2025-12-05T14:34:04.241Z
8663131 8663131 20251130201445_FDWQG KR001E 2025-12-02T14:17:30.369Z 2025-12-05T14:33:57.965Z
8663084 8663084 20251130200659_rDLVK KR001E 2025-12-02T14:17:25.059Z 2025-12-05T14:33:56.710Z
8662961 8662961 20251130195029_gaOzb KR001E 2025-12-02T14:17:12.825Z 2025-12-05T14:33:53.584Z
8662907 8662907 20251130194643_rEPWr KR001E 2025-12-02T14:17:00.661Z 2025-12-05T14:33:52.045Z
8662806 8662806 20251130193355_41t4I KR001E 2025-12-02T14:16:45.825Z 2025-12-05T14:33:48.816Z
8662278 8662278 20251130182541_iV0om KR001E 2025-12-02T14:14:53.434Z 2025-12-05T14:33:14.792Z
8661845 8661845 20251130172243_qRz8L KR001E 2025-12-02T14:13:14.020Z 2025-12-05T14:32:37.727Z
8661839 8661839 20251130172108_dZxp5 KR001E 2025-12-02T14:13:12.911Z 2025-12-05T14:32:37.558Z
8661719 8661719 20251130165906_zgva3 KR001E 2025-12-02T14:12:43.408Z 2025-12-05T14:32:32.799Z
8661610 8661610 20251130162255_nxGH7 KR001E 2025-12-02T14:12:18.428Z 2025-12-05T14:32:26.794Z
8661557 8661557 20251130155132_vKlYX KR001E 2025-12-02T14:12:01.275Z 2025-12-05T14:32:13.476Z
8660898 8660898 20251130140925_13kcu KR001E 2025-12-02T14:09:37.725Z 2025-12-05T14:31:42.018Z
8660896 8660896 20251130140916_HbnCl KR001E 2025-12-02T14:09:37.293Z 2025-12-05T14:31:41.787Z
8660499 8660499 20251130125950_Pad5k KR001E 2025-12-02T14:08:08.912Z 2025-12-05T14:31:13.000Z
8659978 8659978 20251130113704_DgXvT KR001E 2025-12-02T14:05:59.576Z 2025-12-05T14:30:39.507Z
8659681 8659681 20251130110417_dr5Zi KR001E 2025-12-02T14:04:51.389Z 2025-12-05T14:30:27.650Z
8650473 8650473 20251129202632_VMzAW KR001E 2025-12-01T14:16:17.335Z 2025-12-05T14:41:08.640Z
8650404 8650404 20251129200935_f52Kn KR001E 2025-12-01T14:16:02.866Z 2025-12-05T14:41:06.233Z
8650374 8650374 20251129200428_CDenH KR001E 2025-12-01T14:15:56.250Z 2025-12-05T14:41:05.214Z
8649510 8649510 20251129173734_wwBl5 KR001E 2025-12-01T14:12:53.022Z 2025-12-05T14:40:10.883Z
8649356 8649356 20251129171447_F3WKu KR001E 2025-12-01T14:12:11.661Z 2025-12-05T14:40:05.922Z
8649231 8649231 20251129164646_J9JhF KR001E 2025-12-01T14:11:35.518Z 2025-12-05T14:40:01.423Z
8649189 8649189 20251129163445_AjpkS KR001E 2025-12-01T14:11:23.323Z 2025-12-05T14:39:58.114Z
8649154 8649154 20251129162738_6PpDv KR001E 2025-12-01T14:11:14.146Z 2025-12-05T14:39:45.374Z
8649083 8649083 20251129160616_n1vjT KR001E 2025-12-01T14:10:51.082Z 2025-12-05T14:39:34.053Z
8649069 8649069 20251129160135_ZvdVF KR001E 2025-12-01T14:10:48.256Z 2025-12-05T14:39:33.702Z
8649007 8649007 20251129154447_kGRuh KR001E 2025-12-01T14:10:26.141Z 2025-12-05T14:39:31.036Z
8648947 8648947 20251129152423_LDLoC KR001E 2025-12-01T14:10:02.174Z 2025-12-05T14:39:24.866Z
8648941 8648941 20251129152237_CKMZV KR001E 2025-12-01T14:10:01.213Z 2025-12-05T14:39:24.700Z
8648900 8648900 20251129145640_HcRuD KR001E 2025-12-01T14:09:22.955Z 2025-12-05T14:39:20.406Z
8648894 8648894 20251129144922_RKGpt KR001E 2025-12-01T14:09:17.080Z 2025-12-05T14:39:19.530Z
8645085 8645085 20251128203458_yUTWO KR001E 2025-11-30T14:23:02.390Z 2025-12-05T14:50:31.573Z
8644988 8644988 20251128202039_Chhfn KR001E 2025-11-30T14:22:56.128Z 2025-12-05T14:50:30.194Z
8644907 8644907 20251128201406_DhCRC KR001E 2025-11-30T14:22:51.563Z 2025-12-05T14:50:29.110Z
8644902 8644902 20251128201359_on3kA KR001E 2025-11-30T14:22:51.397Z 2025-12-05T14:50:29.058Z
8644746 8644746 20251128195125_PIhcw KR001E 2025-11-30T14:22:22.279Z 2025-12-05T14:50:26.476Z
8644626 8644626 20251128193823_e3XDz KR001E 2025-11-30T14:22:10.326Z 2025-12-05T14:50:24.839Z
8644574 8644574 20251128193413_Itfji KR001E 2025-11-30T14:22:06.846Z 2025-12-05T14:50:23.940Z
8644501 8644501 20251128192855_WcX8i KR001E 2025-11-30T14:22:02.848Z 2025-12-05T14:50:22.874Z
8644341 8644341 20251128192126_nH3vd KR001E 2025-11-30T14:21:40.002Z 2025-12-05T14:50:20.488Z
8643929 8643929 20251128183953_lY6W6 KR001E 2025-11-30T14:20:49.989Z 2025-12-05T14:50:06.953Z
8643792 8643792 20251128182749_oC0e5 KR001E 2025-11-30T14:20:41.183Z 2025-12-05T14:49:46.850Z
8643721 8643721 20251128181901_rS3d2 KR001E 2025-11-30T14:20:36.749Z 2025-12-05T14:49:42.538Z
8643569 8643569 20251128180705_K2WwD KR001E 2025-11-30T14:20:13.712Z 2025-12-05T14:49:27.680Z
8643541 8643541 20251128180540_QlXtu KR001E 2025-11-30T14:20:12.387Z 2025-12-05T14:49:26.299Z
8643463 8643463 20251128175950_v0Jc2 KR001E 2025-11-30T14:20:03.341Z 2025-12-05T14:49:18.418Z
8643388 8643388 20251128174803_J3cj1 KR001E 2025-11-30T14:19:57.910Z 2025-12-05T14:49:16.914Z
8643264 8643264 20251128173954_pP3h7 KR001E 2025-11-30T14:19:48.971Z 2025-12-05T14:49:14.704Z
8643232 8643232 20251128173708_2AIcn KR001E 2025-11-30T14:19:44.317Z 2025-12-05T14:49:14.211Z
8642743 8642743 20251128164304_clIaU KR001E 2025-11-30T14:18:33.980Z 2025-12-05T14:49:04.072Z
8642575 8642575 20251128162503_sMmIw KR001E 2025-11-30T14:18:19.329Z 2025-12-05T14:49:01.576Z
8642268 8642268 20251128154610_y6qaq KR001E 2025-11-30T14:17:43.171Z 2025-12-05T14:48:57.768Z
8642256 8642256 20251128154426_gZKU8 KR001E 2025-11-30T14:17:42.862Z 2025-12-05T14:48:57.710Z
8641384 8641384 20251128143938_xNbq3 KR001E 2025-11-30T14:15:52.232Z 2025-12-05T14:48:21.734Z
8631781 8631781 20251127200040_07u4c KR001E 2025-11-29T14:16:23.172Z 2025-12-05T14:56:11.587Z
8631765 8631765 20251127195856_wgCKe KR001E 2025-11-29T14:16:21.889Z 2025-12-05T14:56:11.538Z
8631675 8631675 20251127194324_DUgDW KR001E 2025-11-29T14:16:01.164Z 2025-12-05T14:56:10.335Z
8631455 8631455 20251127191001_2wLc8 KR001E 2025-11-29T14:15:23.165Z 2025-12-05T14:56:06.821Z
8631288 8631288 20251127184407_Nwnl0 KR001E 2025-11-29T14:15:04.338Z 2025-12-05T14:56:04.763Z
8631190 8631190 20251127183354_7nR5B KR001E 2025-11-29T14:14:54.662Z 2025-12-05T14:56:03.437Z
8631154 8631154 20251127182519_FnfxT KR001E 2025-11-29T14:14:42.734Z 2025-12-05T14:56:02.719Z
8631041 8631041 20251127180733_240bk KR001E 2025-11-29T14:14:27.642Z 2025-12-05T14:56:01.020Z
8631026 8631026 20251127180502_HO8ur KR001E 2025-11-29T14:14:26.571Z 2025-12-05T14:56:00.853Z
8630973 8630973 20251127175753_YZ3vT KR001E 2025-11-29T14:14:14.415Z 2025-12-05T14:55:59.988Z
8630959 8630959 20251127175600_8Kg74 KR001E 2025-11-29T14:14:13.323Z 2025-12-05T14:55:59.737Z
8630842 8630842 20251127173422_hN8Q9 KR001E 2025-11-29T14:13:51.412Z 2025-12-05T14:55:57.802Z
8630700 8630700 20251127170741_7CH4M KR001E 2025-11-29T14:13:29.397Z 2025-12-05T14:55:48.601Z
8630691 8630691 20251127170642_WMD2Z KR001E 2025-11-29T14:13:28.466Z 2025-12-05T14:55:46.896Z
8630503 8630503 20251127162917_xbQrF KR001E 2025-11-29T14:12:49.384Z 2025-12-05T14:55:32.066Z
8630426 8630426 20251127161128_IAgXY KR001E 2025-11-29T14:12:39.612Z 2025-12-05T14:55:23.474Z
8630350 8630350 20251127155536_ZGJZw KR001E 2025-11-29T14:12:22.570Z 2025-12-05T14:55:16.039Z
8630300 8630300 20251127154223_sPa3r KR001E 2025-11-29T14:12:15.226Z 2025-12-05T14:55:05.510Z
8630272 8630272 20251127153317_Jjdor KR001E 2025-11-29T14:12:12.165Z 2025-12-05T14:55:03.717Z
8630211 8630211 20251127152034_Qe2FU KR001E 2025-11-29T14:12:06.141Z 2025-12-05T14:54:52.490Z
8630168 8630168 20251127145740_ZJMO2 KR001E 2025-11-29T14:11:58.609Z 2025-12-05T14:54:45.440Z
8630115 8630115 20251127143233_EK7jB KR001E 2025-11-29T14:11:40.287Z 2025-12-05T14:54:30.844Z
8622456 8622456 20251126192415_jeKlK KR001E 2025-11-28T14:18:54.355Z 2025-12-05T15:02:57.136Z
8622443 8622443 20251126192159_fbJzH KR001E 2025-11-28T14:18:53.004Z 2025-12-05T15:02:56.963Z
8622359 8622359 20251126185636_qxT0e KR001E 2025-11-28T14:18:34.321Z 2025-12-05T15:02:55.900Z

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