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

4,504 rows where station_code = "KR003U" 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
9271351 9271351 20260128214152_S9teW KR003U 2026-01-29T14:16:08.524Z 2026-01-29T14:16:08.524Z
9271261 9271261 20260128204039_20lHJ KR003U 2026-01-29T14:15:42.600Z 2026-01-29T14:15:42.600Z
9271213 9271213 20260128202449_tLQlG KR003U 2026-01-29T14:15:35.065Z 2026-01-29T14:15:35.065Z
9270983 9270983 20260128190546_zh2lg KR003U 2026-01-29T14:14:43.499Z 2026-01-29T14:14:43.499Z
9270916 9270916 20260128184815_Fcsvj KR003U 2026-01-29T14:14:33.553Z 2026-01-29T14:14:33.553Z
9270769 9270769 20260128173640_vuBX3 KR003U 2026-01-29T14:13:50.392Z 2026-01-29T14:13:50.392Z
9267217 9267217 20260126203556_2ctNn KR003U 2026-01-28T14:20:20.925Z 2026-01-29T14:34:34.520Z
9267176 9267176 20260126201436_IVWYB KR003U 2026-01-28T14:20:02.371Z 2026-01-29T14:34:28.695Z
9267065 9267065 20260126183703_9UvO3 KR003U 2026-01-28T14:18:49.829Z 2026-01-29T14:34:11.924Z
9267030 9267030 20260126181230_516dW KR003U 2026-01-28T14:18:26.111Z 2026-01-29T14:33:59.231Z
9266796 9266796 20260127212706_rQlt7 KR003U 2026-01-28T14:14:36.307Z 2026-01-29T14:30:25.219Z
9266790 9266790 20260127212514_VmNzB KR003U 2026-01-28T14:14:35.332Z 2026-01-29T14:30:25.218Z
9266632 9266632 20260127201032_dAqHK KR003U 2026-01-28T14:14:07.700Z 2026-01-29T14:30:25.143Z
9266621 9266621 20260127200800_2mBtN KR003U 2026-01-28T14:14:06.530Z 2026-01-29T14:30:25.141Z
9266593 9266593 20260127200140_RnG5u KR003U 2026-01-28T14:13:57.745Z 2026-01-29T14:30:25.134Z
9266589 9266589 20260127200124_QUFzR KR003U 2026-01-28T14:13:57.140Z 2026-01-29T14:30:25.134Z
9266495 9266495 20260127193157_NOGoK KR003U 2026-01-28T14:13:42.074Z 2026-01-29T14:30:25.049Z
9266471 9266471 20260127192519_i3sJN KR003U 2026-01-28T14:13:39.139Z 2026-01-29T14:30:25.034Z
9266358 9266358 20260127185804_l8z6V KR003U 2026-01-28T14:13:17.078Z 2026-01-29T14:30:25.000Z
9266267 9266267 20260127183331_NW0id KR003U 2026-01-28T14:13:06.707Z 2026-01-29T14:30:24.969Z
9266181 9266181 20260127175430_3G3O0 KR003U 2026-01-28T14:12:44.063Z 2026-01-29T14:30:24.906Z
9266150 9266150 20260127174124_HID2r KR003U 2026-01-28T14:12:38.679Z 2026-01-29T14:30:24.896Z
9266049 9266049 20260127165316_WBxqJ KR003U 2026-01-28T14:12:15.528Z 2026-01-29T14:30:24.830Z
9266004 9266004 20260127163216_GiYnN KR003U 2026-01-28T14:12:06.965Z 2026-01-29T14:30:24.811Z
9265622 9265622 20260127154202_YVKiR KR003U 2026-01-28T14:10:45.262Z 2026-01-29T14:30:24.624Z
9265437 9265437 20260127151558_E38pF KR003U 2026-01-28T14:10:10.589Z 2026-01-29T14:30:24.549Z
9263805 9263805 20260127101500_JUaSV KR003U 2026-01-28T14:02:52.616Z 2026-01-29T14:30:18.940Z
9259564 9259564 20260124212929_UsHEP KR003U 2026-01-26T14:17:28.312Z 2026-01-29T14:43:06.244Z
9259536 9259536 20260124212004_SWXHQ KR003U 2026-01-26T14:17:24.281Z 2026-01-29T14:43:04.803Z
9259392 9259392 20260124204019_AVv8i KR003U 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259318 9259318 20260124201408_3sep7 KR003U 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259297 9259297 20260124201207_YnQMw KR003U 2026-01-26T14:16:28.404Z 2026-01-29T14:42:46.653Z
9259215 9259215 20260124194126_zLo7M KR003U 2026-01-26T14:16:10.631Z 2026-01-29T14:42:42.893Z
9259187 9259187 20260124193108_32pFl KR003U 2026-01-26T14:16:02.629Z 2026-01-29T14:42:41.730Z
9259095 9259095 20260124185004_a0MD3 KR003U 2026-01-26T14:15:41.060Z 2026-01-29T14:42:36.835Z
9259068 9259068 20260124183630_K87GL KR003U 2026-01-26T14:15:34.182Z 2026-01-29T14:42:28.769Z
9259065 9259065 20260124183629_oKngO KR003U 2026-01-26T14:15:33.769Z 2026-01-29T14:42:28.559Z
9258948 9258948 20260124180614_7bAdg KR003U 2026-01-26T14:15:08.020Z 2026-01-29T14:42:20.377Z
9258941 9258941 20260124180443_fuZcm KR003U 2026-01-26T14:15:07.010Z 2026-01-29T14:42:20.087Z
9258688 9258688 20260124160506_pqhCz KR003U 2026-01-26T14:13:53.977Z 2026-01-29T14:41:52.109Z
9258678 9258678 20260124160201_8UkRM KR003U 2026-01-26T14:13:52.219Z 2026-01-29T14:41:51.086Z
9258660 9258660 20260124154543_ZCfY1 KR003U 2026-01-26T14:13:40.208Z 2026-01-29T14:41:48.747Z
9258617 9258617 20260124151442_1KQLV KR003U 2026-01-26T14:13:26.221Z 2026-01-29T14:41:42.150Z
9258554 9258554 20260124142717_VvEQa KR003U 2026-01-26T14:12:56.077Z 2026-01-29T14:41:25.139Z
9258523 9258523 20260124141040_3ovAt KR003U 2026-01-26T14:12:39.154Z 2026-01-29T14:41:21.313Z
9258468 9258468 20260124131632_qZZBi KR003U 2026-01-26T14:12:18.617Z 2026-01-29T14:41:05.878Z
9258407 9258407 20260124114634_9XCmM KR003U 2026-01-26T14:11:41.348Z 2026-01-29T14:40:49.635Z
9258399 9258399 20260124113456_8o4Xa KR003U 2026-01-26T14:11:37.152Z 2026-01-29T14:40:47.729Z
9258169 9258169 20260125191931_kQtK1 KR003U 2026-01-26T14:09:53.842Z 2026-01-29T14:38:06.491Z
9258122 9258122 20260125185939_kPnDn KR003U 2026-01-26T14:09:40.126Z 2026-01-26T14:09:40.126Z
9258102 9258102 20260125183846_ULR7W KR003U 2026-01-26T14:09:36.016Z 2026-01-29T14:38:03.167Z
9258031 9258031 20260125181120_Bv6D3 KR003U 2026-01-26T14:09:12.262Z 2026-01-29T14:37:59.388Z
9258024 9258024 20260125180708_FzupH KR003U 2026-01-26T14:09:10.890Z 2026-01-26T14:09:10.890Z
9257973 9257973 20260125173630_zO4iZ KR003U 2026-01-26T14:08:50.276Z 2026-01-26T14:08:50.276Z
9257806 9257806 20260125155939_JNWg3 KR003U 2026-01-26T14:07:48.144Z 2026-01-29T14:37:41.693Z
9254726 9254726 20260123210500_t3HBU KR003U 2026-01-25T14:10:28.243Z 2026-01-29T14:46:37.554Z
9254587 9254587 20260123201608_AqFCV KR003U 2026-01-25T14:09:58.553Z 2026-01-29T14:46:31.209Z
9254527 9254527 20260123195554_cWhll KR003U 2026-01-25T14:09:38.372Z 2026-01-29T14:46:28.521Z
9254436 9254436 20260123191730_a7GHL KR003U 2026-01-25T14:09:08.134Z 2026-01-29T14:46:23.508Z
9254424 9254424 20260123191458_H6DKL KR003U 2026-01-25T14:09:06.045Z 2026-01-29T14:46:22.159Z
9254390 9254390 20260123184951_3mIoM KR003U 2026-01-25T14:08:57.266Z 2026-01-29T14:46:13.370Z
9254259 9254259 20260123173517_HzwJQ KR003U 2026-01-25T14:08:09.780Z 2026-01-29T14:46:01.938Z
9251632 9251632 20260122213944_rkd13 KR003U 2026-01-24T14:12:40.858Z 2026-01-29T14:51:56.615Z
9251535 9251535 20260122204718_UjbqF KR003U 2026-01-24T14:12:09.579Z 2026-01-29T14:51:47.142Z
9251459 9251459 20260122202056_5FjH7 KR003U 2026-01-24T14:11:48.451Z 2026-01-29T14:51:42.800Z
9251426 9251426 20260122200907_sdfJ2 KR003U 2026-01-24T14:11:42.013Z 2026-01-29T14:51:40.381Z
9251404 9251404 20260122200157_OprOp KR003U 2026-01-24T14:11:37.288Z 2026-01-29T14:51:39.226Z
9251373 9251373 20260122195137_VuCr1 KR003U 2026-01-24T14:11:28.624Z 2026-01-29T14:51:37.601Z
9251359 9251359 20260122194915_qS6OL KR003U 2026-01-24T14:11:25.330Z 2026-01-29T14:51:32.744Z
9251295 9251295 20260122193551_pXD3s KR003U 2026-01-24T14:11:09.078Z 2026-01-29T14:51:27.176Z
9251234 9251234 20260122191559_Bf5Mw KR003U 2026-01-24T14:10:49.049Z 2026-01-29T14:51:21.382Z
9251070 9251070 20260122181908_gmSiM KR003U 2026-01-24T14:09:50.281Z 2026-01-29T14:51:00.209Z
9251002 9251002 20260122174246_Tz3z1 KR003U 2026-01-24T14:09:20.217Z 2026-01-29T14:50:51.978Z
9250990 9250990 20260122174149_n9h3v KR003U 2026-01-24T14:09:16.993Z 2026-01-29T14:50:51.293Z
9250978 9250978 20260122174054_r4n3O KR003U 2026-01-24T14:09:13.175Z 2026-01-29T14:50:51.015Z
9250858 9250858 20260122161458_nWL3B KR003U 2026-01-24T14:08:11.183Z 2026-01-29T14:50:39.837Z
9250648 9250648 20260122114829_u7QhG KR003U 2026-01-24T14:04:52.677Z 2026-01-29T14:49:24.341Z
9250638 9250638 20260122113754_qv2tT KR003U 2026-01-24T14:04:41.880Z 2026-01-29T14:49:21.633Z
9248077 9248077 20260121212458_uqvci KR003U 2026-01-23T14:11:51.163Z 2026-01-29T14:56:53.458Z
9248024 9248024 20260121211101_VuXbQ KR003U 2026-01-23T14:11:44.330Z 2026-01-29T14:56:48.747Z
9248005 9248005 20260121210602_uZ3sl KR003U 2026-01-23T14:11:42.345Z 2026-01-29T14:56:47.955Z
9247907 9247907 20260121202834_I8de7 KR003U 2026-01-23T14:11:25.488Z 2026-01-29T14:56:43.282Z
9247902 9247902 20260121202734_xxmQa KR003U 2026-01-23T14:11:24.204Z 2026-01-29T14:56:43.064Z
9247838 9247838 20260121200516_n1xEf KR003U 2026-01-23T14:11:13.904Z 2026-01-29T14:56:39.897Z
9247796 9247796 20260121195010_wMWd7 KR003U 2026-01-23T14:11:09.301Z 2026-01-29T14:56:38.072Z
9247775 9247775 20260121194510_MRovO KR003U 2026-01-23T14:11:06.192Z 2026-01-29T14:56:36.740Z
9247734 9247734 20260121193959_PfuyV KR003U 2026-01-23T14:11:00.280Z 2026-01-29T14:56:34.663Z
9247617 9247617 20260121191542_FXgZJ KR003U 2026-01-23T14:10:36.100Z 2026-01-29T14:56:19.750Z
9247594 9247594 20260121191002_02yXp KR003U 2026-01-23T14:10:32.758Z 2026-01-29T14:56:16.331Z
9247567 9247567 20260121190202_ZzExq KR003U 2026-01-23T14:10:28.904Z 2026-01-29T14:56:14.571Z
9246756 9246756 20260121141723_xoTjI KR003U 2026-01-23T14:07:53.413Z 2026-01-29T14:55:09.550Z
9246754 9246754 20260121141619_pTbTr KR003U 2026-01-23T14:07:52.828Z 2026-01-29T14:55:09.432Z
9246750 9246750 20260121141619_JYLHM KR003U 2026-01-23T14:07:52.607Z 2026-01-29T14:55:09.301Z
9246697 9246697 20260121134451_cwvJg KR003U 2026-01-23T14:07:36.827Z 2026-01-29T14:55:05.380Z
9241567 9241567 20260120210710_1CVxT KR003U 2026-01-22T14:13:44.780Z 2026-01-29T15:02:53.339Z
9241451 9241451 20260120202907_nW8Gh KR003U 2026-01-22T14:13:13.886Z 2026-01-29T15:02:39.157Z
9241427 9241427 20260120202606_rhAT0 KR003U 2026-01-22T14:13:04.694Z 2026-01-29T15:02:36.138Z
9241413 9241413 20260120202503_dxJpE KR003U 2026-01-22T14:12:58.571Z 2026-01-29T15:02:35.306Z
9241269 9241269 20260120194624_W6pEO KR003U 2026-01-22T14:12:19.790Z 2026-01-29T15:02:29.631Z
9241172 9241172 20260120191523_PQ2iG KR003U 2026-01-22T14:12:00.576Z 2026-01-29T15:02:24.855Z

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