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

2,756 rows where station_code = "KR002M" 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
8679912 8679912 20251202211054_CMHKR KR002M 2025-12-04T14:10:46.273Z 2025-12-06T14:26:43.968Z
8679888 8679888 20251202210529_Kvr32 KR002M 2025-12-04T14:10:36.913Z 2025-12-06T14:26:42.278Z
8671026 8671026 20251201110448_2w3vr KR002M 2025-12-03T14:11:06.872Z 2025-12-06T14:30:40.241Z
8662009 8662009 20251130174155_vojJE KR002M 2025-12-02T14:13:57.832Z 2025-12-06T14:38:46.509Z
8644696 8644696 20251128194521_L3tAV KR002M 2025-11-30T14:22:15.403Z 2025-12-06T14:54:46.224Z
8644687 8644687 20251128194515_IiMiS KR002M 2025-11-30T14:22:14.818Z 2025-12-06T14:54:46.141Z
8644203 8644203 20251128190716_NIwnK KR002M 2025-11-30T14:21:27.718Z 2025-12-06T14:54:39.215Z
8644155 8644155 20251128190345_J07rp KR002M 2025-11-30T14:21:24.763Z 2025-12-06T14:54:38.792Z
8644016 8644016 20251128185007_r362v KR002M 2025-11-30T14:21:11.815Z 2025-12-06T14:54:36.933Z
8643950 8643950 20251128184112_uQ2MN KR002M 2025-11-30T14:20:53.022Z 2025-12-06T14:54:34.409Z
8643756 8643756 20251128182305_lj3CW KR002M 2025-11-30T14:20:38.816Z 2025-12-06T14:54:12.225Z
8643357 8643357 20251128174530_3oWfP KR002M 2025-11-30T14:19:56.193Z 2025-12-06T14:53:48.211Z
8643228 8643228 20251128173704_rN3M3 KR002M 2025-11-30T14:19:39.552Z 2025-12-06T14:53:44.113Z
8643071 8643071 20251128171700_QIKxu KR002M 2025-11-30T14:19:17.170Z 2025-12-06T14:53:40.071Z
8642378 8642378 20251128155905_R3KQy KR002M 2025-11-30T14:17:51.109Z 2025-12-06T14:53:30.807Z
8642374 8642374 20251128155905_DgRg0 KR002M 2025-11-30T14:17:50.880Z 2025-12-06T14:53:30.806Z
8642328 8642328 20251128155035_hFvDT KR002M 2025-11-30T14:17:47.761Z 2025-12-06T14:53:30.204Z
8641925 8641925 20251128152018_lR8Wy KR002M 2025-11-30T14:17:09.699Z 2025-12-06T14:53:08.561Z
8641845 8641845 20251128151645_T5ebT KR002M 2025-11-30T14:17:04.345Z 2025-12-06T14:52:58.409Z
8641685 8641685 20251128150659_UEZhZ KR002M 2025-11-30T14:16:41.772Z 2025-12-06T14:52:45.118Z
8641679 8641679 20251128150659_2k8D8 KR002M 2025-11-30T14:16:40.330Z 2025-12-06T14:52:44.451Z
8641148 8641148 20251128135608_O9DbJ KR002M 2025-11-30T14:14:35.019Z 2025-12-06T14:52:25.397Z
8641045 8641045 20251128132316_Pl7Uc KR002M 2025-11-30T14:13:49.297Z 2025-12-06T14:52:19.878Z
8640966 8640966 20251128125935_WdsaK KR002M 2025-11-30T14:12:54.028Z 2025-12-06T14:52:04.961Z
8640908 8640908 20251128124308_fLDDD KR002M 2025-11-30T14:12:03.406Z 2025-12-06T14:51:44.734Z
8640845 8640845 20251128120043_q3o2Y KR002M 2025-11-30T14:11:10.237Z 2025-12-06T14:51:30.600Z
8640822 8640822 20251128115245_MluF0 KR002M 2025-11-30T14:11:06.841Z 2025-12-06T14:51:27.801Z
8640813 8640813 20251128113954_w9R6R KR002M 2025-11-30T14:11:00.027Z 2025-12-06T14:51:25.559Z
8577787 8577787 20251122185507_qnsG3 KR002M 2025-11-24T14:09:39.141Z 2025-12-01T15:18:57.597Z
8548697 8548697 20251120211020_YwBCt KR002M 2025-11-22T14:17:28.216Z 2025-11-29T14:54:23.082Z
8548436 8548436 20251120205626_d7vTz KR002M 2025-11-22T14:16:54.259Z 2025-11-29T14:54:22.713Z
8548330 8548330 20251120204925_ZEDZc KR002M 2025-11-22T14:16:45.115Z 2025-11-29T14:54:22.390Z
8548271 8548271 20251120204723_Qvwa3 KR002M 2025-11-22T14:16:41.019Z 2025-11-29T14:54:22.282Z
8548145 8548145 20251120203905_rMDMx KR002M 2025-11-22T14:16:22.221Z 2025-11-29T14:54:22.053Z
8547889 8547889 20251120202002_c88jE KR002M 2025-11-22T14:15:51.087Z 2025-11-29T14:54:21.213Z
8547472 8547472 20251120195350_y9vzp KR002M 2025-11-22T14:15:12.072Z 2025-11-29T14:54:20.165Z
8547427 8547427 20251120194946_g5f2C KR002M 2025-11-22T14:15:07.611Z 2025-11-29T14:54:19.904Z
8547187 8547187 20251120193135_0REtj KR002M 2025-11-22T14:14:32.270Z 2025-11-29T14:54:18.885Z
8547146 8547146 20251120192704_P8G9d KR002M 2025-11-22T14:14:26.285Z 2025-11-29T14:54:18.758Z
8547084 8547084 20251120192032_Yvo4S KR002M 2025-11-22T14:14:16.331Z 2025-11-29T14:54:18.523Z
8547072 8547072 20251120191927_Vh1Sk KR002M 2025-11-22T14:14:15.453Z 2025-11-29T14:54:18.519Z
8547035 8547035 20251120191757_fGn0q KR002M 2025-11-22T14:14:04.908Z 2025-11-29T14:54:18.475Z
8547007 8547007 20251120191633_E63qp KR002M 2025-11-22T14:14:02.015Z 2025-11-29T14:54:18.336Z
8546952 8546952 20251120191109_TRTBM KR002M 2025-11-22T14:13:54.656Z 2025-11-29T14:54:18.079Z
8546946 8546946 20251120191044_V4hwh KR002M 2025-11-22T14:13:54.317Z 2025-11-29T14:54:18.075Z
8546806 8546806 20251120185636_2kmLI KR002M 2025-11-22T14:13:40.357Z 2025-11-29T14:54:17.652Z
8546676 8546676 20251120184613_MGAwu KR002M 2025-11-22T14:13:19.037Z 2025-11-29T14:54:17.370Z
8546643 8546643 20251120184520_LeddO KR002M 2025-11-22T14:13:15.883Z 2025-11-29T14:54:17.131Z
8546589 8546589 20251120184124_hJtp9 KR002M 2025-11-22T14:13:10.425Z 2025-11-29T14:54:16.476Z
8546586 8546586 20251120184119_LHePI KR002M 2025-11-22T14:13:09.994Z 2025-11-29T14:54:16.474Z
8546449 8546449 20251120183205_rny6Y KR002M 2025-11-22T14:12:47.129Z 2025-11-29T14:54:15.506Z
8546242 8546242 20251120180910_aBDuX KR002M 2025-11-22T14:12:12.009Z 2025-11-29T14:54:10.074Z
8546043 8546043 20251120175145_88ZZt KR002M 2025-11-22T14:11:54.289Z 2025-11-29T14:54:07.943Z
8546001 8546001 20251120174657_BAToP KR002M 2025-11-22T14:11:44.148Z 2025-11-29T14:54:07.780Z
8545560 8545560 20251120170451_iDRMn KR002M 2025-11-22T14:10:49.943Z 2025-11-29T14:54:03.598Z
8545533 8545533 20251120170023_E3YKr KR002M 2025-11-22T14:10:46.424Z 2025-11-29T14:54:03.571Z
8545528 8545528 20251120170009_KtCF3 KR002M 2025-11-22T14:10:45.083Z 2025-11-29T14:54:03.557Z
8545515 8545515 20251120165809_Q5uA2 KR002M 2025-11-22T14:10:37.950Z 2025-11-29T14:54:03.519Z
8545336 8545336 20251120164231_jGQtU KR002M 2025-11-22T14:10:20.654Z 2025-11-29T14:54:02.452Z
8545271 8545271 20251120163317_qhrZA KR002M 2025-11-22T14:10:13.080Z 2025-11-29T14:54:02.331Z
8545123 8545123 20251120161442_2zUb9 KR002M 2025-11-22T14:09:48.610Z 2025-11-29T14:54:00.222Z
8545034 8545034 20251120160133_ggyNq KR002M 2025-11-22T14:09:32.100Z 2025-11-29T14:53:57.571Z
8544895 8544895 20251120154443_YYlxx KR002M 2025-11-22T14:09:12.492Z 2025-11-29T14:53:56.621Z
8544886 8544886 20251120154250_Wq8Ra KR002M 2025-11-22T14:09:11.241Z 2025-11-29T14:53:56.588Z
8544878 8544878 20251120154240_rmTZy KR002M 2025-11-22T14:09:10.923Z 2025-11-29T14:53:56.584Z
8544861 8544861 20251120154116_eX9RP KR002M 2025-11-22T14:09:09.014Z 2025-11-29T14:53:56.466Z
8544459 8544459 20251120151434_uc5BU KR002M 2025-11-22T14:08:00.568Z 2025-11-29T14:53:46.632Z
8544389 8544389 20251120151017_exgc0 KR002M 2025-11-22T14:07:51.281Z 2025-11-29T14:53:43.817Z
8544202 8544202 20251120145803_0tOjl KR002M 2025-11-22T14:07:14.065Z 2025-11-29T14:53:42.051Z
8544051 8544051 20251120144417_iRJFG KR002M 2025-11-22T14:06:51.010Z 2025-11-29T14:53:36.751Z
8543730 8543730 20251120141841_Iy24N KR002M 2025-11-22T14:05:55.584Z 2025-11-29T14:53:28.941Z
8543605 8543605 20251120140652_xqqBZ KR002M 2025-11-22T14:05:40.165Z 2025-11-29T14:53:27.245Z
8543595 8543595 20251120140603_IrwfL KR002M 2025-11-22T14:05:38.386Z 2025-11-29T14:53:26.948Z
8543578 8543578 20251120140514_wTkmU KR002M 2025-11-22T14:05:32.018Z 2025-11-29T14:53:26.915Z
8543239 8543239 20251120133716_YCuXo KR002M 2025-11-22T14:04:28.381Z 2025-11-29T14:53:21.293Z
8543002 8543002 20251120131836_8lUot KR002M 2025-11-22T14:03:51.135Z 2025-11-29T14:53:17.532Z
8542960 8542960 20251120131407_1veJF KR002M 2025-11-22T14:03:44.333Z 2025-11-29T14:53:17.117Z
8542918 8542918 20251120130842_McG4E KR002M 2025-11-22T14:03:30.933Z 2025-11-29T14:53:16.545Z
8542702 8542702 20251120124227_LrF2G KR002M 2025-11-22T14:02:55.018Z 2025-11-29T14:53:14.488Z
8542694 8542694 20251120124219_d1JFx KR002M 2025-11-22T14:02:53.861Z 2025-11-29T14:53:14.441Z
8542368 8542368 20251120120424_DYY8E KR002M 2025-11-22T14:01:55.624Z 2025-11-29T14:53:09.798Z
8542045 8542045 20251120112204_ZHKkR KR002M 2025-11-22T14:01:04.243Z 2025-11-29T14:53:02.021Z
8542018 8542018 20251120111441_oIj6P KR002M 2025-11-22T14:00:59.847Z 2025-11-29T14:53:01.760Z
8530650 8530650 20251119123503_1qXzT KR002M 2025-11-21T14:02:20.545Z 2025-11-28T14:53:18.101Z
8530549 8530549 20251119121930_BaNKh KR002M 2025-11-21T14:01:58.233Z 2025-11-28T14:53:15.552Z
8530157 8530157 20251119110737_U3qoo KR002M 2025-11-21T14:00:37.727Z 2025-11-28T14:53:01.038Z
8530123 8530123 20251119110312_UKEQw KR002M 2025-11-21T14:00:29.437Z 2025-11-28T14:53:00.418Z
8525485 8525485 20251118105950_r1qDY KR002M 2025-11-20T14:37:00.012Z 2025-11-26T15:08:29.940Z
8525334 8525334 20251118103542_WpaLl KR002M 2025-11-20T14:36:51.996Z 2025-11-26T15:08:25.882Z
8520183 8520183 20251118185856_oEM9C KR002M 2025-11-20T14:09:15.819Z 2025-11-27T15:11:31.778Z
8490418 8490418 20251116192910_5eHtq KR002M 2025-11-18T14:13:57.824Z 2025-11-25T15:08:15.747Z
8490196 8490196 20251116185059_3n101 KR002M 2025-11-18T14:13:02.604Z 2025-11-25T15:08:04.127Z
8490170 8490170 20251116184621_FJlpo KR002M 2025-11-18T14:12:57.889Z 2025-11-25T15:08:03.328Z
8490113 8490113 20251116183533_qVgQG KR002M 2025-11-18T14:12:47.707Z 2025-11-25T15:08:02.798Z
8490081 8490081 20251116182840_ZZLkh KR002M 2025-11-18T14:12:40.008Z 2025-11-25T15:07:57.548Z
8489837 8489837 20251116174509_F2RO3 KR002M 2025-11-18T14:11:40.050Z 2025-11-25T15:07:42.746Z
8489739 8489739 20251116172909_VT3hu KR002M 2025-11-18T14:11:14.338Z 2025-11-25T15:07:40.752Z
8489735 8489735 20251116172905_tEbfJ KR002M 2025-11-18T14:11:13.790Z 2025-11-25T15:07:40.751Z
8489732 8489732 20251116172904_pv5Jn KR002M 2025-11-18T14:11:13.426Z 2025-11-25T15:07:40.749Z
8489681 8489681 20251116171930_bKAXX KR002M 2025-11-18T14:11:06.852Z 2025-11-25T15:07:39.492Z

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