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,687 rows where station_code = "KR000E" 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
9609948 9609948 20260405112433_1JIIE KR000E 2026-04-06T12:04:54.387Z 2026-04-06T12:04:54.387Z
9583838 9583838 20260326190819_RFZ2G KR000E 2026-03-27T12:09:55.368Z 2026-04-04T12:41:41.036Z
9583787 9583787 20260326181325_RVXBm KR000E 2026-03-27T12:09:45.654Z 2026-04-04T12:41:38.977Z
9583784 9583784 20260326181141_BkGpr KR000E 2026-03-27T12:09:45.197Z 2026-04-04T12:41:38.834Z
9579036 9579036 20260325175010_z9Bhm KR000E 2026-03-26T12:09:11.345Z 2026-04-03T12:38:51.899Z
9579006 9579006 20260325172824_sAea8 KR000E 2026-03-26T12:09:07.482Z 2026-04-03T12:38:50.034Z
9575206 9575206 20260323193040_dCfdL KR000E 2026-03-25T12:20:32.219Z 2026-03-31T12:28:51.076Z
9575201 9575201 20260323192652_eBs7p KR000E 2026-03-25T12:20:31.806Z 2026-03-31T12:28:50.999Z
9575165 9575165 20260323190432_GLPBm KR000E 2026-03-25T12:20:26.211Z 2026-03-31T12:28:50.156Z
9575110 9575110 20260323184537_9DCQ7 KR000E 2026-03-25T12:20:18.856Z 2026-03-31T12:28:48.678Z
9570343 9570343 20260322203821_KNuMa KR000E 2026-03-24T12:23:02.588Z 2026-03-30T12:30:40.335Z
9570298 9570298 20260322202430_Jv9VV KR000E 2026-03-24T12:22:57.206Z 2026-03-30T12:30:39.164Z
9570294 9570294 20260322202257_VAACY KR000E 2026-03-24T12:22:56.579Z 2026-03-30T12:30:38.972Z
9570189 9570189 20260322194516_hDsO1 KR000E 2026-03-24T12:22:46.726Z 2026-03-30T12:30:29.331Z
9570123 9570123 20260322191818_ZqtNN KR000E 2026-03-24T12:22:37.308Z 2026-03-30T12:30:28.137Z
9569974 9569974 20260322184057_HJvKc KR000E 2026-03-24T12:22:24.719Z 2026-03-30T12:30:25.574Z
9569952 9569952 20260322183408_99KeS KR000E 2026-03-24T12:22:23.358Z 2026-03-30T12:30:25.365Z
9569894 9569894 20260322181948_XIVOO KR000E 2026-03-24T12:22:19.076Z 2026-03-30T12:30:24.519Z
9569833 9569833 20260322175711_t7dSG KR000E 2026-03-24T12:22:10.033Z 2026-03-30T12:30:22.149Z
9569804 9569804 20260322174719_X9ZmA KR000E 2026-03-24T12:22:07.768Z 2026-03-30T12:30:21.621Z
9569432 9569432 20260322153449_wWC3U KR000E 2026-03-24T12:20:58.122Z 2026-03-30T12:29:58.128Z
9569398 9569398 20260322152218_ess7q KR000E 2026-03-24T12:20:52.317Z 2026-03-30T12:29:52.741Z
9569248 9569248 20260322142318_sq3BW KR000E 2026-03-24T12:20:17.821Z 2026-03-30T12:29:41.350Z
9569097 9569097 20260322132249_w2Zqb KR000E 2026-03-24T12:19:47.848Z 2026-03-30T12:29:33.073Z
9569047 9569047 20260322124939_pq7AP KR000E 2026-03-24T12:19:31.887Z 2026-03-30T12:29:20.893Z
9568926 9568926 20260322112617_gHt0n KR000E 2026-03-24T12:19:00.732Z 2026-03-30T12:29:09.272Z
9568873 9568873 20260322104427_XT1x3 KR000E 2026-03-24T12:18:44.719Z 2026-03-30T12:29:02.601Z
9568248 9568248 20260323162522_9GdVs KR000E 2026-03-24T12:14:47.352Z 2026-03-31T12:28:26.414Z
9568073 9568073 20260323161129_dm5Rv KR000E 2026-03-24T12:14:29.086Z 2026-03-31T12:28:22.609Z
9568008 9568008 20260323160626_27n0B KR000E 2026-03-24T12:14:23.285Z 2026-03-31T12:28:21.553Z
9567676 9567676 20260323154012_Gjrka KR000E 2026-03-24T12:13:57.472Z 2026-03-24T12:24:25.321Z
9567027 9567027 20260323143256_naNsG KR000E 2026-03-24T12:12:52.498Z 2026-03-31T12:28:07.386Z
9551587 9551587 20260320202628_hZgfF KR000E 2026-03-22T12:26:50.034Z 2026-03-28T12:36:58.432Z
9551363 9551363 20260320193249_CTcaY KR000E 2026-03-22T12:26:35.468Z 2026-03-28T12:36:47.555Z
9551292 9551292 20260320191319_C9cdh KR000E 2026-03-22T12:26:23.998Z 2026-03-28T12:36:41.969Z
9551272 9551272 20260320190557_6cchV KR000E 2026-03-22T12:26:21.928Z 2026-03-28T12:36:41.724Z
9551250 9551250 20260320190322_U704b KR000E 2026-03-22T12:26:20.752Z 2026-03-28T12:36:41.494Z
9551184 9551184 20260320184916_HFwJQ KR000E 2026-03-22T12:26:16.302Z 2026-03-28T12:36:40.856Z
9551152 9551152 20260320183815_M3IWj KR000E 2026-03-22T12:26:13.416Z 2026-03-28T12:36:40.341Z
9551035 9551035 20260320175437_M4LJJ KR000E 2026-03-22T12:26:06.333Z 2026-03-28T12:36:39.187Z
9550490 9550490 20260320164416_tEBZ5 KR000E 2026-03-22T12:25:26.239Z 2026-03-28T12:36:31.718Z
9550467 9550467 20260320164211_jn00J KR000E 2026-03-22T12:25:24.774Z 2026-03-28T12:36:31.479Z
9550256 9550256 20260320162424_xj27R KR000E 2026-03-22T12:25:04.650Z 2026-03-28T12:36:28.868Z
9550006 9550006 20260320155920_IyvVh KR000E 2026-03-22T12:24:42.751Z 2026-03-28T12:36:25.768Z
9549817 9549817 20260320154411_hD9lg KR000E 2026-03-22T12:24:30.903Z 2026-03-28T12:36:21.944Z
9549583 9549583 20260320151630_QuuJu KR000E 2026-03-22T12:24:16.977Z 2026-03-28T12:36:06.760Z
9549399 9549399 20260320145447_PHgqI KR000E 2026-03-22T12:23:57.344Z 2026-03-28T12:36:02.987Z
9547430 9547430 20260321132849_xyzSn KR000E 2026-03-22T12:13:39.657Z 2026-03-22T12:27:38.464Z
9547314 9547314 20260321131606_3hdg2 KR000E 2026-03-22T12:13:24.643Z 2026-03-29T12:20:08.604Z
9547154 9547154 20260321125809_gZKt3 KR000E 2026-03-22T12:13:06.137Z 2026-03-22T12:27:38.402Z
9547022 9547022 20260321124637_ZrMye KR000E 2026-03-22T12:12:48.643Z 2026-03-29T12:20:05.954Z
9545562 9545562 20260321104758_WU0JP KR000E 2026-03-22T12:09:44.855Z 2026-03-22T12:27:38.063Z
9540267 9540267 20260319145135_lsoMb KR000E 2026-03-21T12:26:35.193Z 2026-03-27T12:42:05.185Z
9540192 9540192 20260319142110_dJfFk KR000E 2026-03-21T12:26:27.080Z 2026-03-27T12:42:03.278Z
9540127 9540127 20260319132754_sn9lV KR000E 2026-03-21T12:26:11.792Z 2026-03-27T12:41:59.922Z
9539943 9539943 20260319110803_3e1Zk KR000E 2026-03-21T12:25:20.791Z 2026-03-27T12:41:47.422Z
9539923 9539923 20260319110430_UBs0k KR000E 2026-03-21T12:25:18.501Z 2026-03-27T12:41:46.917Z
9538849 9538849 20260320135114_Rz0bF KR000E 2026-03-21T12:18:29.727Z 2026-03-21T12:30:06.641Z
9538841 9538841 20260320134947_Llr25 KR000E 2026-03-21T12:18:28.403Z 2026-03-28T12:35:53.416Z
9538484 9538484 20260320130943_CJvkY KR000E 2026-03-21T12:17:50.397Z 2026-03-21T12:30:06.491Z
9538417 9538417 20260320130107_ss2JB KR000E 2026-03-21T12:17:39.781Z 2026-03-21T12:30:06.468Z
9538313 9538313 20260320125054_EJOHG KR000E 2026-03-21T12:17:28.699Z 2026-03-28T12:35:46.659Z
9536949 9536949 20260320104832_B1DQG KR000E 2026-03-21T12:14:44.120Z 2026-03-28T12:35:19.113Z
9529371 9529371 20260318180214_xOLA0 KR000E 2026-03-20T12:23:06.925Z 2026-03-26T12:39:00.404Z
9529356 9529356 20260318175320_Mn1KL KR000E 2026-03-20T12:23:06.018Z 2026-03-26T12:38:59.732Z
9529291 9529291 20260318173835_A1KbZ KR000E 2026-03-20T12:23:01.851Z 2026-03-26T12:38:54.904Z
9529022 9529022 20260318170809_IhU6g KR000E 2026-03-20T12:22:41.976Z 2026-03-26T12:38:42.346Z
9528785 9528785 20260318164435_UFt1n KR000E 2026-03-20T12:22:31.227Z 2026-03-26T12:38:38.090Z
9528402 9528402 20260318161201_n19r3 KR000E 2026-03-20T12:22:16.132Z 2026-03-26T12:38:36.001Z
9528315 9528315 20260318160428_FyHQP KR000E 2026-03-20T12:22:12.075Z 2026-03-26T12:38:35.318Z
9489197 9489197 20260315125839_35BPZ KR000E 2026-03-16T12:16:41.936Z 2026-03-23T12:22:33.480Z
9482615 9482615 20260314172821_mwfYW KR000E 2026-03-15T12:19:52.748Z 2026-03-22T12:42:48.475Z
9481274 9481274 20260314145636_Egve2 KR000E 2026-03-15T12:17:30.635Z 2026-03-22T12:42:43.964Z
9481136 9481136 20260314144045_6Z2vB KR000E 2026-03-15T12:17:13.422Z 2026-03-22T12:42:43.355Z
9480546 9480546 20260314134245_2E39D KR000E 2026-03-15T12:16:08.794Z 2026-03-22T12:42:41.614Z
9480410 9480410 20260314132842_5XDAl KR000E 2026-03-15T12:15:54.340Z 2026-03-22T12:42:41.232Z
9479737 9479737 20260314121450_uN73r KR000E 2026-03-15T12:14:26.433Z 2026-03-22T12:42:39.095Z
9473855 9473855 20260313203102_O5HcQ KR000E 2026-03-14T12:16:05.771Z 2026-03-21T12:50:17.969Z
9473847 9473847 20260313202506_5vkpK KR000E 2026-03-14T12:16:04.750Z 2026-03-21T12:50:17.612Z
9473843 9473843 20260313201121_GU5BM KR000E 2026-03-14T12:16:03.957Z 2026-03-21T12:50:16.042Z
9473841 9473841 20260313200936_Kgutc KR000E 2026-03-14T12:16:03.406Z 2026-03-21T12:50:15.883Z
9473833 9473833 20260313200427_rEp4a KR000E 2026-03-14T12:16:01.987Z 2026-03-21T12:50:13.516Z
9473815 9473815 20260313195037_HpCcW KR000E 2026-03-14T12:15:59.596Z 2026-03-21T12:50:10.380Z
9473777 9473777 20260313191725_D6Wo3 KR000E 2026-03-14T12:15:50.623Z 2026-03-21T12:50:01.904Z
9473628 9473628 20260313173914_nuAOh KR000E 2026-03-14T12:15:29.159Z 2026-03-21T12:49:58.934Z
9473510 9473510 20260313170940_bnjrS KR000E 2026-03-14T12:15:11.955Z 2026-03-21T12:49:58.257Z
9472745 9472745 20260313145557_Wu32R KR000E 2026-03-14T12:13:49.680Z 2026-03-21T12:49:51.657Z
9471677 9471677 20260313111503_rjPuJ KR000E 2026-03-14T12:11:06.028Z 2026-03-21T12:49:41.732Z
9468434 9468434 20260312205246_t0392 KR000E 2026-03-13T12:21:48.926Z 2026-03-20T12:37:16.169Z
9468427 9468427 20260312203929_gohnY KR000E 2026-03-13T12:21:48.210Z 2026-03-20T12:37:15.873Z
9468416 9468416 20260312203303_AUHEd KR000E 2026-03-13T12:21:47.282Z 2026-03-20T12:37:15.715Z
9468379 9468379 20260312195835_c9zKy KR000E 2026-03-13T12:21:43.759Z 2026-03-20T12:37:15.279Z
9468246 9468246 20260312183949_mPhuT KR000E 2026-03-13T12:21:32.545Z 2026-03-20T12:37:13.980Z
9468005 9468005 20260312162127_ah8Xl KR000E 2026-03-13T12:20:53.776Z 2026-03-20T12:37:11.499Z
9467877 9467877 20260312150807_gYbJS KR000E 2026-03-13T12:20:26.200Z 2026-03-20T12:37:10.123Z
9467855 9467855 20260312145901_almkd KR000E 2026-03-13T12:20:23.322Z 2026-03-20T12:37:09.996Z
9467767 9467767 20260312134652_QbYL7 KR000E 2026-03-13T12:19:54.943Z 2026-03-20T12:37:09.177Z
9462142 9462142 20260311203348_sLuuK KR000E 2026-03-12T12:18:35.957Z 2026-03-19T12:45:49.816Z
9462140 9462140 20260311203206_ZOI1E KR000E 2026-03-12T12:18:35.795Z 2026-03-19T12:45:49.757Z
9462064 9462064 20260311200551_uxJ8M KR000E 2026-03-12T12:18:23.774Z 2026-03-19T12:45:48.242Z

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