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,403 rows where station_code = "KR0026" 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
9607955 9607955 20260404201403_gPT9L KR0026 2026-04-05T12:05:02.759Z 2026-04-06T12:16:14.592Z
9607904 9607904 20260404183537_o0IG9 KR0026 2026-04-05T12:04:50.252Z 2026-04-06T12:16:14.552Z
9607886 9607886 20260404182316_RZD0l KR0026 2026-04-05T12:04:43.244Z 2026-04-06T12:16:14.545Z
9594018 9594018 20260329174614_SS5XQ KR0026 2026-03-30T12:05:50.726Z 2026-04-06T12:36:08.735Z
9591707 9591707 20260328195959_UJLqW KR0026 2026-03-29T12:04:52.913Z 2026-04-06T12:39:42.198Z
9591648 9591648 20260328181224_eefHV KR0026 2026-03-29T12:04:47.008Z 2026-04-06T12:39:36.995Z
9591440 9591440 20260328163559_4fgzD KR0026 2026-03-29T12:04:25.296Z 2026-04-06T12:39:15.731Z
9588108 9588108 20260327192230_6O9zt KR0026 2026-03-28T12:07:11.545Z 2026-04-05T12:35:08.906Z
9588043 9588043 20260327175513_wCfnz KR0026 2026-03-28T12:07:01.020Z 2026-04-05T12:35:05.518Z
9583913 9583913 20260326201036_FafTT KR0026 2026-03-27T12:10:07.076Z 2026-04-04T12:41:53.042Z
9583845 9583845 20260326191136_iRUZz KR0026 2026-03-27T12:09:55.905Z 2026-04-04T12:41:41.358Z
9583814 9583814 20260326184052_5bp2y KR0026 2026-03-27T12:09:51.469Z 2026-04-04T12:41:40.001Z
9583759 9583759 20260326174409_42TsM KR0026 2026-03-27T12:09:41.791Z 2026-04-04T12:41:37.488Z
9583383 9583383 20260326140353_1cQTF KR0026 2026-03-27T12:08:37.904Z 2026-04-04T12:41:06.548Z
9583377 9583377 20260326140144_34fyh KR0026 2026-03-27T12:08:36.943Z 2026-04-04T12:41:06.027Z
9579069 9579069 20260325191340_1oVmD KR0026 2026-03-26T12:09:15.779Z 2026-04-03T12:39:10.622Z
9579060 9579060 20260325184709_LW4rV KR0026 2026-03-26T12:09:14.981Z 2026-04-03T12:39:08.561Z
9578891 9578891 20260325154328_tZkjv KR0026 2026-03-26T12:08:46.485Z 2026-04-03T12:38:39.238Z
9578781 9578781 20260325143357_o9LKz KR0026 2026-03-26T12:08:31.374Z 2026-04-03T12:38:32.371Z
9575257 9575257 20260323195711_gwIjU KR0026 2026-03-25T12:20:41.434Z 2026-03-31T12:28:52.496Z
9575055 9575055 20260323182848_Q69jV KR0026 2026-03-25T12:20:12.560Z 2026-03-31T12:28:47.384Z
9575001 9575001 20260323180853_SKhZA KR0026 2026-03-25T12:20:03.364Z 2026-03-31T12:28:46.214Z
9574992 9574992 20260323180532_DiE1W KR0026 2026-03-25T12:20:02.027Z 2026-03-31T12:28:45.973Z
9574945 9574945 20260323174608_aJ79k KR0026 2026-03-25T12:19:55.810Z 2026-03-31T12:28:44.992Z
9570347 9570347 20260322203857_tA23T KR0026 2026-03-24T12:23:02.936Z 2026-03-30T12:30:40.412Z
9570285 9570285 20260322201946_ptabT KR0026 2026-03-24T12:22:55.325Z 2026-03-30T12:30:38.559Z
9570110 9570110 20260322191145_xDpAJ KR0026 2026-03-24T12:22:35.616Z 2026-03-30T12:30:27.848Z
9569913 9569913 20260322182457_XKuYQ KR0026 2026-03-24T12:22:20.616Z 2026-03-30T12:30:24.780Z
9569875 9569875 20260322181307_qtX94 KR0026 2026-03-24T12:22:16.899Z 2026-03-30T12:30:22.754Z
9569635 9569635 20260322163458_NESD2 KR0026 2026-03-24T12:21:35.655Z 2026-03-30T12:30:12.696Z
9569300 9569300 20260322144445_aR7bH KR0026 2026-03-24T12:20:28.760Z 2026-03-30T12:29:45.937Z
9569026 9569026 20260322123722_Ee8tF KR0026 2026-03-24T12:19:27.337Z 2026-03-30T12:29:19.107Z
9568086 9568086 20260323161146_gGKB0 KR0026 2026-03-24T12:14:30.044Z 2026-03-31T12:28:22.747Z
9567741 9567741 20260323154448_tLg3q KR0026 2026-03-24T12:14:05.272Z 2026-03-31T12:28:18.170Z
9566532 9566532 20260323135014_3E3ci KR0026 2026-03-24T12:12:02.393Z 2026-03-31T12:27:53.357Z
9558876 9558876 20260321160014_L7OUE KR0026 2026-03-23T12:10:38.235Z 2026-03-29T12:20:31.342Z
9550676 9550676 20260320165916_qHtJ1 KR0026 2026-03-22T12:25:35.979Z 2026-03-28T12:36:34.168Z
9550471 9550471 20260320164222_cQ46z KR0026 2026-03-22T12:25:25.263Z 2026-03-28T12:36:31.563Z
9548636 9548636 20260321152028_5ug0E KR0026 2026-03-22T12:15:44.527Z 2026-03-29T12:20:27.660Z
9547282 9547282 20260321131300_20oJB KR0026 2026-03-22T12:13:19.887Z 2026-03-29T12:20:08.397Z
9541300 9541300 20260319201401_k3ZRe KR0026 2026-03-21T12:28:48.679Z 2026-03-27T12:42:36.334Z
9540657 9540657 20260319171016_omPQM KR0026 2026-03-21T12:27:47.220Z 2026-03-27T12:42:28.869Z
9540585 9540585 20260319164606_S234Q KR0026 2026-03-21T12:27:33.391Z 2026-03-27T12:42:26.494Z
9540368 9540368 20260319152650_RBgJA KR0026 2026-03-21T12:26:55.072Z 2026-03-27T12:42:20.661Z
9540302 9540302 20260319150242_R9lXT KR0026 2026-03-21T12:26:41.063Z 2026-03-27T12:42:14.381Z
9540285 9540285 20260319150048_zpTxO KR0026 2026-03-21T12:26:39.485Z 2026-03-27T12:42:11.447Z
9540166 9540166 20260319140346_88b5p KR0026 2026-03-21T12:26:23.539Z 2026-03-27T12:42:02.411Z
9540090 9540090 20260319124815_Q5lUm KR0026 2026-03-21T12:26:02.356Z 2026-03-27T12:41:57.944Z
9539235 9539235 20260320142609_XgxBx KR0026 2026-03-21T12:19:10.382Z 2026-03-28T12:35:58.550Z
9527679 9527679 20260318150540_er5jy KR0026 2026-03-20T12:21:37.981Z 2026-03-26T12:38:30.491Z
9506624 9506624 20260316183759_1KV36 KR0026 2026-03-18T12:19:06.000Z 2026-03-24T12:41:33.820Z
9506551 9506551 20260316182044_L02IR KR0026 2026-03-18T12:18:55.357Z 2026-03-24T12:41:33.449Z
9498854 9498854 20260316153108_XQCcG KR0026 2026-03-17T12:14:34.318Z 2026-03-24T12:41:27.204Z
9498607 9498607 20260316151557_P4w45 KR0026 2026-03-17T12:14:10.671Z 2026-03-24T12:41:26.583Z
9497283 9497283 20260316131340_Xvo8E KR0026 2026-03-17T12:11:44.092Z 2026-03-24T12:41:22.747Z
9496985 9496985 20260316123917_52SOF KR0026 2026-03-17T12:11:03.717Z 2026-03-24T12:41:21.962Z
9481144 9481144 20260314144254_BnPM6 KR0026 2026-03-15T12:17:17.134Z 2026-03-22T12:42:43.383Z
9479891 9479891 20260314123447_PDc3U KR0026 2026-03-15T12:14:47.803Z 2026-03-22T12:42:39.833Z
9479820 9479820 20260314122744_xAMA6 KR0026 2026-03-15T12:14:41.700Z 2026-03-22T12:42:39.598Z
9473818 9473818 20260313195541_uy6GX KR0026 2026-03-14T12:16:00.080Z 2026-03-21T12:50:11.594Z
9473604 9473604 20260313173232_LoWEs KR0026 2026-03-14T12:15:25.935Z 2026-03-21T12:49:58.832Z
9473550 9473550 20260313172020_FlNhu KR0026 2026-03-14T12:15:17.863Z 2026-03-21T12:49:58.573Z
9472397 9472397 20260313135849_EZCAY KR0026 2026-03-14T12:13:08.154Z 2026-03-21T12:49:48.374Z
9468240 9468240 20260312183858_VcKYB KR0026 2026-03-13T12:21:32.307Z 2026-03-20T12:37:13.969Z
9468183 9468183 20260312180914_xwwV5 KR0026 2026-03-13T12:21:26.005Z 2026-03-20T12:37:13.348Z
9468148 9468148 20260312175247_X2dtm KR0026 2026-03-13T12:21:17.970Z 2026-03-20T12:37:13.029Z
9467942 9467942 20260312155212_9SBV8 KR0026 2026-03-13T12:20:38.784Z 2026-03-20T12:37:11.000Z
9467900 9467900 20260312152125_6oUH3 KR0026 2026-03-13T12:20:30.633Z 2026-03-20T12:37:10.552Z
9467793 9467793 20260312140613_iQKwk KR0026 2026-03-13T12:19:58.115Z 2026-03-20T12:37:09.293Z
9461144 9461144 20260311142919_g3Zwl KR0026 2026-03-12T12:16:32.005Z 2026-03-19T12:45:13.459Z
9455110 9455110 20260310184846_ocRoO KR0026 2026-03-11T12:10:27.577Z 2026-03-18T12:39:55.473Z
9455049 9455049 20260310181725_rsPGk KR0026 2026-03-11T12:10:20.960Z 2026-03-18T12:39:52.591Z
9455007 9455007 20260310175918_LBctv KR0026 2026-03-11T12:10:12.539Z 2026-03-18T12:39:51.466Z
9454689 9454689 20260310164535_YtrHr KR0026 2026-03-11T12:09:41.928Z 2026-03-18T12:39:48.390Z
9454596 9454596 20260310163402_opJEM KR0026 2026-03-11T12:09:33.301Z 2026-03-18T12:39:47.559Z
9454161 9454161 20260310153215_G9u3x KR0026 2026-03-11T12:08:51.553Z 2026-03-18T12:39:43.930Z
9453860 9453860 20260310144731_fvMKP KR0026 2026-03-11T12:08:20.940Z 2026-03-18T12:39:41.146Z
9453588 9453588 20260310140646_uAPnK KR0026 2026-03-11T12:07:53.653Z 2026-03-18T12:39:38.672Z
9453312 9453312 20260310132033_cfd5F KR0026 2026-03-11T12:07:22.928Z 2026-03-18T12:39:22.670Z
9450072 9450072 20260309190414_kXWA2 KR0026 2026-03-10T12:14:39.402Z 2026-03-17T12:42:36.200Z
9450049 9450049 20260309182644_ePK4f KR0026 2026-03-10T12:14:36.150Z 2026-03-17T12:42:34.169Z
9450031 9450031 20260309181228_pC4QC KR0026 2026-03-10T12:14:33.634Z 2026-03-17T12:42:33.881Z
9449951 9449951 20260309170920_FFPxD KR0026 2026-03-10T12:14:21.650Z 2026-03-17T12:42:32.758Z
9449512 9449512 20260309153459_4HSZG KR0026 2026-03-10T12:13:10.898Z 2026-03-17T12:42:29.402Z
9449075 9449075 20260309130157_Ti0M0 KR0026 2026-03-10T12:11:53.436Z 2026-03-17T12:42:25.785Z
9445055 9445055 20260308172749_8Hlrf KR0026 2026-03-09T12:12:35.331Z 2026-03-16T12:44:35.804Z
9444974 9444974 20260308163612_bURVl KR0026 2026-03-09T12:12:21.445Z 2026-03-16T12:44:34.922Z
9444566 9444566 20260308143233_SqaWK KR0026 2026-03-09T12:11:17.248Z 2026-03-16T12:44:30.682Z
9444551 9444551 20260308143009_2KZJ2 KR0026 2026-03-09T12:11:14.713Z 2026-03-16T12:44:30.582Z
9444483 9444483 20260308141124_kveZG KR0026 2026-03-09T12:11:01.057Z 2026-03-16T12:44:29.951Z
9444394 9444394 20260308134450_gnBAM KR0026 2026-03-09T12:10:43.160Z 2026-03-16T12:44:28.966Z
9444356 9444356 20260308133627_xigbm KR0026 2026-03-09T12:10:38.193Z 2026-03-16T12:44:28.656Z
9443970 9443970 20260308120902_QWoFm KR0026 2026-03-09T12:09:35.517Z 2026-03-16T12:44:24.073Z
9440534 9440534 20260307192410_ivBb0 KR0026 2026-03-08T12:13:50.557Z 2026-03-15T12:42:08.472Z
9440522 9440522 20260307191824_HvfhC KR0026 2026-03-08T12:13:49.572Z 2026-03-15T12:42:08.288Z
9440401 9440401 20260307175007_mJ2H1 KR0026 2026-03-08T12:13:32.237Z 2026-03-15T12:42:05.708Z
9440081 9440081 20260307160534_wYe99 KR0026 2026-03-08T12:12:34.932Z 2026-03-15T12:42:02.993Z
9439503 9439503 20260307135424_WHPPI KR0026 2026-03-08T12:10:34.427Z 2026-03-15T12:41:43.046Z
9439483 9439483 20260307134932_iydOC KR0026 2026-03-08T12:10:30.229Z 2026-03-15T12:41:42.960Z
9438956 9438956 20260307120240_W9hAO KR0026 2026-03-08T12:09:06.304Z 2026-03-15T12:41:37.224Z

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