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

9,289 rows where station_code = "KR0009" 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
9271646 9271646 20260127185246_wre6Q KR0009 2026-01-29T14:22:04.973Z 2026-01-29T14:30:24.995Z
9271523 9271523 20260127172733_VGtJ9 KR0009 2026-01-29T14:21:09.521Z 2026-01-29T14:30:24.886Z
9271321 9271321 20260128211123_cyq2j KR0009 2026-01-29T14:16:02.154Z 2026-01-29T14:16:02.154Z
9271279 9271279 20260128204809_ZLckB KR0009 2026-01-29T14:15:45.427Z 2026-01-29T14:15:45.427Z
9271222 9271222 20260128202653_hF55h KR0009 2026-01-29T14:15:36.885Z 2026-01-29T14:15:36.885Z
9271217 9271217 20260128202641_mHkWQ KR0009 2026-01-29T14:15:36.404Z 2026-01-29T14:15:36.404Z
9271147 9271147 20260128201141_ZFP8m KR0009 2026-01-29T14:15:27.019Z 2026-01-29T14:15:27.019Z
9271126 9271126 20260128200407_CHRFt KR0009 2026-01-29T14:15:19.350Z 2026-01-29T14:15:19.350Z
9271093 9271093 20260128195420_SI3aN KR0009 2026-01-29T14:15:10.993Z 2026-01-29T14:15:10.993Z
9271050 9271050 20260128193027_CZfsA KR0009 2026-01-29T14:15:03.051Z 2026-01-29T14:15:03.051Z
9271034 9271034 20260128192703_SH87Q KR0009 2026-01-29T14:15:00.785Z 2026-01-29T14:15:00.785Z
9271007 9271007 20260128192051_P27Xs KR0009 2026-01-29T14:14:52.083Z 2026-01-29T14:14:52.083Z
9270984 9270984 20260128190629_90Twm KR0009 2026-01-29T14:14:44.145Z 2026-01-29T14:14:44.145Z
9270957 9270957 20260128190351_bdwku KR0009 2026-01-29T14:14:40.606Z 2026-01-29T14:14:40.606Z
9270934 9270934 20260128185552_R1rC9 KR0009 2026-01-29T14:14:37.457Z 2026-01-29T14:14:37.457Z
9270898 9270898 20260128184100_Cxvwx KR0009 2026-01-29T14:14:31.253Z 2026-01-29T14:14:31.253Z
9270821 9270821 20260128175610_ruyos KR0009 2026-01-29T14:14:07.223Z 2026-01-29T14:14:07.223Z
9270818 9270818 20260128175344_5ygNP KR0009 2026-01-29T14:14:06.532Z 2026-01-29T14:14:06.532Z
9270816 9270816 20260128175232_v27iH KR0009 2026-01-29T14:14:05.947Z 2026-01-29T14:14:05.947Z
9270801 9270801 20260128174838_U9GjM KR0009 2026-01-29T14:14:01.085Z 2026-01-29T14:14:01.085Z
9270758 9270758 20260128173256_0j3Pa KR0009 2026-01-29T14:13:48.066Z 2026-01-29T14:13:48.066Z
9270134 9270134 20260128150019_5TGh1 KR0009 2026-01-29T14:10:58.601Z 2026-01-29T14:10:58.601Z
9269909 9269909 20260128143059_KcdLG KR0009 2026-01-29T14:10:11.678Z 2026-01-29T14:10:11.678Z
9267246 9267246 20260126213047_mLTck KR0009 2026-01-28T14:20:41.439Z 2026-01-29T14:34:44.541Z
9267086 9267086 20260126184931_fxgnZ KR0009 2026-01-28T14:19:07.067Z 2026-01-29T14:34:15.616Z
9266918 9266918 20260126162910_e2PM2 KR0009 2026-01-28T14:17:39.561Z 2026-01-29T14:33:44.414Z
9266813 9266813 20260127213257_ncyEk KR0009 2026-01-28T14:14:38.877Z 2026-01-29T14:30:25.222Z
9266717 9266717 20260127205443_F43CU KR0009 2026-01-28T14:14:21.990Z 2026-01-29T14:30:25.195Z
9266580 9266580 20260127200004_zhpDq KR0009 2026-01-28T14:13:56.543Z 2026-01-29T14:30:25.133Z
9266544 9266544 20260127194815_3zihL KR0009 2026-01-28T14:13:49.398Z 2026-01-29T14:30:25.086Z
9266514 9266514 20260127194058_3oSiC KR0009 2026-01-28T14:13:45.730Z 2026-01-29T14:30:25.066Z
9266500 9266500 20260127193437_hXnvP KR0009 2026-01-28T14:13:43.040Z 2026-01-29T14:30:25.051Z
9266398 9266398 20260127191404_Twk4C KR0009 2026-01-28T14:13:25.146Z 2026-01-29T14:30:25.020Z
9266393 9266393 20260127191039_C4Z2X KR0009 2026-01-28T14:13:23.691Z 2026-01-29T14:30:25.019Z
9266343 9266343 20260127185752_18Ao3 KR0009 2026-01-28T14:13:16.225Z 2026-01-28T14:13:16.225Z
9266288 9266288 20260127184608_KlEyk KR0009 2026-01-28T14:13:10.743Z 2026-01-29T14:30:24.979Z
9266277 9266277 20260127183440_99Gk3 KR0009 2026-01-28T14:13:08.063Z 2026-01-29T14:30:24.970Z
9266250 9266250 20260127182938_3CyiN KR0009 2026-01-28T14:13:03.592Z 2026-01-29T14:30:24.964Z
9266222 9266222 20260127181703_kZbst KR0009 2026-01-28T14:12:54.611Z 2026-01-29T14:30:24.941Z
9266170 9266170 20260127175143_Znm3J KR0009 2026-01-28T14:12:42.495Z 2026-01-29T14:30:24.904Z
9266120 9266120 20260127172733_3ile0 KR0009 2026-01-28T14:12:29.348Z 2026-01-29T14:30:24.886Z
9266096 9266096 20260127172055_giEd9 KR0009 2026-01-28T14:12:25.447Z 2026-01-29T14:30:24.869Z
9266083 9266083 20260127171303_TUfDT KR0009 2026-01-28T14:12:22.694Z 2026-01-29T14:30:24.849Z
9266050 9266050 20260127165656_Dvw3l KR0009 2026-01-28T14:12:16.288Z 2026-01-29T14:30:24.836Z
9265954 9265954 20260127161846_jShLF KR0009 2026-01-28T14:11:51.497Z 2026-01-29T14:30:24.786Z
9264736 9264736 20260127130357_OsgXT KR0009 2026-01-28T14:07:25.750Z 2026-01-29T14:30:24.266Z
9264562 9264562 20260127124604_NqjE3 KR0009 2026-01-28T14:06:41.501Z 2026-01-29T14:30:24.220Z
9264517 9264517 20260127124031_MNmrs KR0009 2026-01-28T14:06:31.385Z 2026-01-29T14:30:24.192Z
9263806 9263806 20260127101512_M03vN KR0009 2026-01-28T14:02:53.716Z 2026-01-29T14:30:18.946Z
9263156 9263156 20260125171357_Xq6Fk KR0009 2026-01-27T14:17:17.133Z 2026-01-29T14:37:54.048Z
9263154 9263154 20260125170354_e0iVI KR0009 2026-01-27T14:17:16.612Z 2026-01-29T14:37:47.137Z
9262481 9262481 20260126211851_AMbcI KR0009 2026-01-27T14:09:18.468Z 2026-01-29T14:34:44.043Z
9262479 9262479 20260126211721_9umTA KR0009 2026-01-27T14:09:17.808Z 2026-01-29T14:34:43.101Z
9262459 9262459 20260126205050_YJHah KR0009 2026-01-27T14:09:12.602Z 2026-01-29T14:34:36.185Z
9262392 9262392 20260126201721_vbY1Z KR0009 2026-01-27T14:08:55.053Z 2026-01-29T14:34:29.084Z
9262293 9262293 20260126185526_6sAXY KR0009 2026-01-27T14:08:30.443Z 2026-01-29T14:34:16.922Z
9262289 9262289 20260126184945_vwNzO KR0009 2026-01-27T14:08:27.681Z 2026-01-29T14:34:15.819Z
9262263 9262263 20260126184157_pg28j KR0009 2026-01-27T14:08:22.460Z 2026-01-29T14:34:13.605Z
9262248 9262248 20260126183703_QWzwB KR0009 2026-01-27T14:08:19.704Z 2026-01-29T14:34:11.667Z
9262232 9262232 20260126182603_wVx52 KR0009 2026-01-27T14:08:16.692Z 2026-01-29T14:34:02.458Z
9262179 9262179 20260126174752_2tZSK KR0009 2026-01-27T14:08:01.454Z 2026-01-29T14:33:54.677Z
9262174 9262174 20260126174556_DLFwA KR0009 2026-01-27T14:08:00.357Z 2026-01-29T14:33:53.798Z
9258454 9258454 20260124130649_rVq7F KR0009 2026-01-26T14:12:12.136Z 2026-01-29T14:41:03.669Z
9258448 9258448 20260124130221_Tdusn KR0009 2026-01-26T14:12:10.420Z 2026-01-29T14:41:02.889Z
9258424 9258424 20260124122900_btG2d KR0009 2026-01-26T14:11:59.052Z 2026-01-29T14:40:55.341Z
9258135 9258135 20260125190413_7VwbT KR0009 2026-01-26T14:09:43.118Z 2026-01-29T14:38:05.042Z
9258118 9258118 20260125185527_F81Ls KR0009 2026-01-26T14:09:39.598Z 2026-01-29T14:38:04.146Z
9258103 9258103 20260125184130_g3EJN KR0009 2026-01-26T14:09:36.687Z 2026-01-29T14:38:03.269Z
9258092 9258092 20260125183614_pQYPX KR0009 2026-01-26T14:09:34.542Z 2026-01-26T14:09:34.542Z
9258059 9258059 20260125181907_c9Cxe KR0009 2026-01-26T14:09:18.726Z 2026-01-29T14:38:00.364Z
9257995 9257995 20260125174654_2EvRc KR0009 2026-01-26T14:09:01.928Z 2026-01-26T14:09:01.928Z
9257953 9257953 20260125172910_1bbir KR0009 2026-01-26T14:08:46.787Z 2026-01-29T14:37:55.086Z
9257896 9257896 20260125170443_Cy3Mh KR0009 2026-01-26T14:08:30.161Z 2026-01-29T14:37:52.185Z
9257880 9257880 20260125164356_6uq4E KR0009 2026-01-26T14:08:18.473Z 2026-01-26T14:08:18.473Z
9257846 9257846 20260125162116_pymmr KR0009 2026-01-26T14:08:08.834Z 2026-01-29T14:37:44.634Z
9257772 9257772 20260125155325_FVcdD KR0009 2026-01-26T14:07:40.983Z 2026-01-29T14:37:39.026Z
9257473 9257473 20260125140028_LCJAw KR0009 2026-01-26T14:05:52.700Z 2026-01-29T14:37:14.567Z
9257286 9257286 20260125124207_YxEh3 KR0009 2026-01-26T14:04:36.220Z 2026-01-29T14:37:04.021Z
9256873 9256873 20260125105538_XEZZR KR0009 2026-01-26T14:02:26.436Z 2026-01-29T14:36:33.488Z
9254821 9254821 20260123213806_AwZ6v KR0009 2026-01-25T14:10:51.792Z 2026-01-29T14:46:44.316Z
9254790 9254790 20260123212359_PJxQd KR0009 2026-01-25T14:10:45.761Z 2026-01-29T14:46:42.847Z
9254788 9254788 20260123212132_jdc2O KR0009 2026-01-25T14:10:44.954Z 2026-01-29T14:46:42.714Z
9254780 9254780 20260123211811_e2f3q KR0009 2026-01-25T14:10:43.367Z 2026-01-29T14:46:42.397Z
9254766 9254766 20260123211259_lQY4k KR0009 2026-01-25T14:10:40.200Z 2026-01-29T14:46:41.643Z
9254717 9254717 20260123210228_0toWU KR0009 2026-01-25T14:10:27.756Z 2026-01-29T14:46:37.433Z
9254705 9254705 20260123204807_MzLX1 KR0009 2026-01-25T14:10:24.915Z 2026-01-29T14:46:36.591Z
9254681 9254681 20260123204510_Ummui KR0009 2026-01-25T14:10:21.095Z 2026-01-29T14:46:35.556Z
9254675 9254675 20260123204323_GpLnP KR0009 2026-01-25T14:10:19.571Z 2026-01-29T14:46:35.186Z
9254615 9254615 20260123202754_A17cY KR0009 2026-01-25T14:10:04.483Z 2026-01-29T14:46:32.624Z
9254601 9254601 20260123201937_443jn KR0009 2026-01-25T14:10:01.168Z 2026-01-29T14:46:31.852Z
9254578 9254578 20260123201448_DMNZC KR0009 2026-01-25T14:09:55.781Z 2026-01-29T14:46:30.781Z
9254573 9254573 20260123201345_u2WZn KR0009 2026-01-25T14:09:54.529Z 2026-01-29T14:46:30.512Z
9254439 9254439 20260123191755_VyV4k KR0009 2026-01-25T14:09:09.045Z 2026-01-29T14:46:23.809Z
9254284 9254284 20260123175248_ga50J KR0009 2026-01-25T14:08:18.403Z 2026-01-29T14:46:03.863Z
9251544 9251544 20260122205039_n2acD KR0009 2026-01-24T14:12:12.519Z 2026-01-29T14:51:47.978Z
9250894 9250894 20260122164007_fcGJp KR0009 2026-01-24T14:08:35.950Z 2026-01-29T14:50:43.555Z
9250805 9250805 20260122151806_bIvij KR0009 2026-01-24T14:07:30.153Z 2026-01-29T14:50:20.915Z
9250678 9250678 20260122121557_B1cNL KR0009 2026-01-24T14:05:12.362Z 2026-01-29T14:49:31.641Z
9250616 9250616 20260122111510_ySn35 KR0009 2026-01-24T14:04:22.870Z 2026-01-29T14:49:14.930Z
9250602 9250602 20260122105655_c2GpY KR0009 2026-01-24T14:04:13.808Z 2026-01-29T14:49:11.158Z

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