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

8,992 rows where station_code = "KR000K" 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
9607905 9607905 20260404183918_Ymauz KR000K 2026-04-05T12:04:50.813Z 2026-04-06T12:16:14.554Z
9607661 9607661 20260404113516_RTYaQ KR000K 2026-04-05T12:03:22.291Z 2026-04-06T12:16:14.485Z
9603875 9603875 20260402132002_eP64K KR000K 2026-04-03T12:04:56.590Z 2026-04-06T12:22:39.152Z
9603835 9603835 20260402130258_brpU7 KR000K 2026-04-03T12:04:50.486Z 2026-04-06T12:22:36.691Z
9551353 9551353 20260320192950_5RcVb KR000K 2026-03-22T12:26:28.292Z 2026-03-28T12:36:47.128Z
9551343 9551343 20260320192702_23GyN KR000K 2026-03-22T12:26:27.530Z 2026-03-28T12:36:46.197Z
9551305 9551305 20260320191653_II2Kk KR000K 2026-03-22T12:26:24.896Z 2026-03-28T12:36:42.598Z
9551177 9551177 20260320184601_D8TB5 KR000K 2026-03-22T12:26:15.665Z 2026-03-28T12:36:40.731Z
9551141 9551141 20260320183521_owaUh KR000K 2026-03-22T12:26:13.053Z 2026-03-28T12:36:40.308Z
9551065 9551065 20260320180816_C2xcC KR000K 2026-03-22T12:26:08.651Z 2026-03-28T12:36:39.513Z
9550860 9550860 20260320171717_TKrNs KR000K 2026-03-22T12:25:48.461Z 2026-03-28T12:36:37.073Z
9550727 9550727 20260320170718_3UbAK KR000K 2026-03-22T12:25:40.225Z 2026-03-28T12:36:35.494Z
9550588 9550588 20260320165321_pxFkL KR000K 2026-03-22T12:25:31.592Z 2026-03-28T12:36:32.986Z
9550516 9550516 20260320164521_RC88n KR000K 2026-03-22T12:25:27.854Z 2026-03-28T12:36:32.066Z
9550278 9550278 20260320162648_9rS82 KR000K 2026-03-22T12:25:06.222Z 2026-03-28T12:36:29.129Z
9550143 9550143 20260320161253_409HM KR000K 2026-03-22T12:24:57.781Z 2026-03-28T12:36:27.608Z
9550137 9550137 20260320161152_sTna8 KR000K 2026-03-22T12:24:57.177Z 2026-03-28T12:36:27.456Z
9550074 9550074 20260320160642_rDx7n KR000K 2026-03-22T12:24:54.093Z 2026-03-28T12:36:26.902Z
9541374 9541374 20260319202626_vWoRd KR000K 2026-03-21T12:28:52.724Z 2026-03-27T12:42:37.005Z
9541135 9541135 20260319193921_bcACl KR000K 2026-03-21T12:28:38.646Z 2026-03-27T12:42:34.377Z
9541077 9541077 20260319191930_ZuvKg KR000K 2026-03-21T12:28:29.003Z 2026-03-27T12:42:33.771Z
9541050 9541050 20260319191158_zC532 KR000K 2026-03-21T12:28:27.217Z 2026-03-27T12:42:33.451Z
9541019 9541019 20260319190204_vSobX KR000K 2026-03-21T12:28:23.994Z 2026-03-27T12:42:33.099Z
9540965 9540965 20260319184434_OdeYy KR000K 2026-03-21T12:28:20.065Z 2026-03-27T12:42:32.514Z
9540900 9540900 20260319183033_GIkrf KR000K 2026-03-21T12:28:16.545Z 2026-03-27T12:42:32.020Z
9540778 9540778 20260319175515_1NpeX KR000K 2026-03-21T12:28:08.707Z 2026-03-27T12:42:30.879Z
9540758 9540758 20260319174952_nseoJ KR000K 2026-03-21T12:28:07.709Z 2026-03-27T12:42:30.727Z
9540720 9540720 20260319173237_Kna7Z KR000K 2026-03-21T12:27:57.384Z 2026-03-27T12:42:30.264Z
9540703 9540703 20260319172535_dkLee KR000K 2026-03-21T12:27:55.264Z 2026-03-27T12:42:29.874Z
9540699 9540699 20260319172445_RsWZ5 KR000K 2026-03-21T12:27:54.556Z 2026-03-27T12:42:29.728Z
9540688 9540688 20260319172319_MIAZp KR000K 2026-03-21T12:27:53.064Z 2026-03-27T12:42:29.586Z
9540649 9540649 20260319171010_IOKpy KR000K 2026-03-21T12:27:47.035Z 2026-03-27T12:42:28.849Z
9540551 9540551 20260319162921_wPTkN KR000K 2026-03-21T12:27:17.165Z 2026-03-27T12:42:25.274Z
9540482 9540482 20260319154849_EIIYN KR000K 2026-03-21T12:27:03.354Z 2026-03-27T12:42:22.569Z
9540450 9540450 20260319154441_dXmLx KR000K 2026-03-21T12:27:01.293Z 2026-03-27T12:42:22.165Z
9540359 9540359 20260319152526_POCYw KR000K 2026-03-21T12:26:54.197Z 2026-03-27T12:42:20.490Z
9540209 9540209 20260319143711_BRCMJ KR000K 2026-03-21T12:26:30.057Z 2026-03-27T12:42:04.008Z
9540201 9540201 20260319142936_Yq2Ol KR000K 2026-03-21T12:26:28.526Z 2026-03-27T12:42:03.643Z
9540143 9540143 20260319133624_krry2 KR000K 2026-03-21T12:26:17.819Z 2026-03-27T12:42:01.040Z
9539946 9539946 20260319111818_kfCzU KR000K 2026-03-21T12:25:23.322Z 2026-03-27T12:41:48.371Z
9539389 9539389 20260320143904_2rWyg KR000K 2026-03-21T12:19:27.881Z 2026-03-28T12:36:00.187Z
9539030 9539030 20260320140443_NVPk2 KR000K 2026-03-21T12:18:51.761Z 2026-03-28T12:35:56.243Z
9538574 9538574 20260320132058_SCRAL KR000K 2026-03-21T12:17:58.086Z 2026-03-28T12:35:50.291Z
9530366 9530366 20260318204211_MQWxs KR000K 2026-03-20T12:24:19.789Z 2026-03-26T12:39:11.535Z
9530058 9530058 20260318200223_awGhC KR000K 2026-03-20T12:23:57.281Z 2026-03-26T12:39:08.858Z
9529700 9529700 20260318191539_IpvzL KR000K 2026-03-20T12:23:34.088Z 2026-03-26T12:39:05.660Z
9529694 9529694 20260318191300_Ah5tD KR000K 2026-03-20T12:23:33.668Z 2026-03-26T12:39:05.600Z
9529579 9529579 20260318185713_nWZkb KR000K 2026-03-20T12:23:19.898Z 2026-03-26T12:39:04.608Z
9529484 9529484 20260318183721_ikhVB KR000K 2026-03-20T12:23:13.737Z 2026-03-26T12:39:03.314Z
9529456 9529456 20260318183113_GTq4m KR000K 2026-03-20T12:23:11.732Z 2026-03-26T12:39:02.938Z
9529427 9529427 20260318181944_4p9uY KR000K 2026-03-20T12:23:09.778Z 2026-03-26T12:39:02.527Z
9529393 9529393 20260318181059_aTMNH KR000K 2026-03-20T12:23:08.269Z 2026-03-26T12:39:02.159Z
9529327 9529327 20260318174634_1eXD7 KR000K 2026-03-20T12:23:03.999Z 2026-03-26T12:38:58.000Z
9529137 9529137 20260318172002_TUYgZ KR000K 2026-03-20T12:22:55.274Z 2026-03-26T12:38:47.464Z
9507120 9507120 20260316202306_rAQkw KR000K 2026-03-18T12:19:55.066Z 2026-03-24T12:41:40.116Z
9507113 9507113 20260316202306_t8Yp7 KR000K 2026-03-18T12:19:54.697Z 2026-03-24T12:41:40.047Z
9507056 9507056 20260316201221_WWGuc KR000K 2026-03-18T12:19:49.614Z 2026-03-24T12:41:38.212Z
9506956 9506956 20260316195750_hqokZ KR000K 2026-03-18T12:19:42.252Z 2026-03-24T12:41:36.489Z
9506931 9506931 20260316195608_z0lof KR000K 2026-03-18T12:19:40.970Z 2026-03-24T12:41:36.265Z
9506607 9506607 20260316183528_ALSim KR000K 2026-03-18T12:19:04.765Z 2026-03-24T12:41:33.749Z
9506593 9506593 20260316183252_QWz30 KR000K 2026-03-18T12:19:03.382Z 2026-03-24T12:41:33.698Z
9506580 9506580 20260316182636_ojqQx KR000K 2026-03-18T12:18:58.232Z 2026-03-24T12:41:33.610Z
9506554 9506554 20260316182106_hJ3Ef KR000K 2026-03-18T12:18:55.710Z 2026-03-24T12:41:33.458Z
9505311 9505311 20260317141250_4iYxX KR000K 2026-03-18T12:09:55.812Z 2026-03-25T12:42:27.622Z
9504769 9504769 20260317122154_TrSce KR000K 2026-03-18T12:08:50.151Z 2026-03-25T12:42:24.427Z
9504656 9504656 20260317120913_rvtzF KR000K 2026-03-18T12:08:34.926Z 2026-03-25T12:42:23.675Z
9503988 9503988 20260317102133_V3qPy KR000K 2026-03-18T12:06:55.324Z 2026-03-25T12:42:19.006Z
9500224 9500224 20260316175816_3tnxX KR000K 2026-03-17T12:17:00.684Z 2026-03-24T12:41:32.945Z
9500190 9500190 20260316175202_877eB KR000K 2026-03-17T12:16:54.758Z 2026-03-24T12:41:32.867Z
9500146 9500146 20260316174000_983mU KR000K 2026-03-17T12:16:49.230Z 2026-03-17T12:25:25.892Z
9500127 9500127 20260316173742_aF8gJ KR000K 2026-03-17T12:16:47.479Z 2026-03-24T12:41:32.618Z
9499965 9499965 20260316170902_2cG9S KR000K 2026-03-17T12:16:31.220Z 2026-03-24T12:41:32.018Z
9499807 9499807 20260316165028_3ucxX KR000K 2026-03-17T12:16:10.713Z 2026-03-24T12:41:31.429Z
9499763 9499763 20260316164422_Usn4N KR000K 2026-03-17T12:16:06.883Z 2026-03-24T12:41:31.346Z
9499540 9499540 20260316162954_btSY5 KR000K 2026-03-17T12:15:46.017Z 2026-03-24T12:41:30.670Z
9499502 9499502 20260316162808_pHFdF KR000K 2026-03-17T12:15:42.232Z 2026-03-24T12:41:30.502Z
9499492 9499492 20260316162703_T6HBy KR000K 2026-03-17T12:15:40.365Z 2026-03-24T12:41:30.418Z
9499119 9499119 20260316155532_1BKAW KR000K 2026-03-17T12:15:03.786Z 2026-03-24T12:41:28.145Z
9499066 9499066 20260316155026_0wE4A KR000K 2026-03-17T12:14:59.393Z 2026-03-24T12:41:27.996Z
9498761 9498761 20260316152449_q4HlS KR000K 2026-03-17T12:14:25.853Z 2026-03-24T12:41:26.902Z
9498584 9498584 20260316151541_CyzN4 KR000K 2026-03-17T12:14:09.396Z 2026-03-17T12:25:25.547Z
9498421 9498421 20260316150248_WgKZq KR000K 2026-03-17T12:13:54.155Z 2026-03-24T12:41:26.018Z
9497905 9497905 20260316141932_qU47S KR000K 2026-03-17T12:12:53.444Z 2026-03-24T12:41:24.507Z
9497618 9497618 20260316135111_BAHiJ KR000K 2026-03-17T12:12:21.317Z 2026-03-24T12:41:23.609Z
9497561 9497561 20260316134645_ZGwd7 KR000K 2026-03-17T12:12:15.802Z 2026-03-24T12:41:23.502Z
9496746 9496746 20260316121113_kIYvN KR000K 2026-03-17T12:10:29.617Z 2026-03-24T12:41:20.984Z
9496665 9496665 20260316120347_dgZG9 KR000K 2026-03-17T12:10:19.302Z 2026-03-24T12:41:20.667Z
9496433 9496433 20260316113319_CSY6q KR000K 2026-03-17T12:09:47.868Z 2026-03-17T12:25:24.973Z
9496235 9496235 20260316110317_DwTUq KR000K 2026-03-17T12:09:20.346Z 2026-03-24T12:41:18.842Z
9491829 9491829 20260315202413_9Ildn KR000K 2026-03-16T12:21:56.606Z 2026-03-23T12:22:42.539Z
9491808 9491808 20260315195744_e2KiF KR000K 2026-03-16T12:21:52.126Z 2026-03-23T12:22:42.240Z
9491801 9491801 20260315195030_39XS3 KR000K 2026-03-16T12:21:51.710Z 2026-03-23T12:22:42.137Z
9491768 9491768 20260315193459_oLRc9 KR000K 2026-03-16T12:21:47.593Z 2026-03-23T12:22:41.743Z
9491719 9491719 20260315185333_vw07L KR000K 2026-03-16T12:21:40.357Z 2026-03-23T12:22:41.091Z
9491703 9491703 20260315184159_9S2UP KR000K 2026-03-16T12:21:38.481Z 2026-03-23T12:22:41.018Z
9491646 9491646 20260315174625_rmuKk KR000K 2026-03-16T12:21:27.819Z 2026-03-23T12:22:40.312Z
9491537 9491537 20260315170343_DJZTj KR000K 2026-03-16T12:21:12.178Z 2026-03-23T12:22:39.792Z
9490785 9490785 20260315153006_LU8L6 KR000K 2026-03-16T12:19:45.161Z 2026-03-23T12:22:37.479Z
9490258 9490258 20260315143748_eJtn7 KR000K 2026-03-16T12:18:47.730Z 2026-03-23T12:22:36.150Z
9490237 9490237 20260315143054_Lj5Sr KR000K 2026-03-16T12:18:44.642Z 2026-03-23T12:22:36.030Z

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