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

6,093 rows where station_code = "KR0023" 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
9607948 9607948 20260404200148_LFAfC KR0023 2026-04-05T12:05:01.185Z 2026-04-06T12:16:14.584Z
9602124 9602124 20260401195233_R0uXk KR0023 2026-04-02T12:05:01.120Z 2026-04-06T12:25:53.025Z
9602116 9602116 20260401194523_m5NRd KR0023 2026-04-02T12:04:57.714Z 2026-04-06T12:25:51.663Z
9600755 9600755 20260329142800_YS2KL KR0023 2026-04-01T12:13:41.209Z 2026-04-06T12:35:43.831Z
9594017 9594017 20260329174614_SS5XQ KR0023 2026-03-30T12:05:50.726Z 2026-04-06T12:36:08.735Z
9593994 9593994 20260329173104_Y2X3o KR0023 2026-03-30T12:05:45.605Z 2026-04-06T12:36:01.040Z
9591439 9591439 20260328163559_4fgzD KR0023 2026-03-29T12:04:25.296Z 2026-04-06T12:39:15.731Z
9591112 9591112 20260328132742_2HdIE KR0023 2026-03-29T12:03:51.604Z 2026-04-06T12:39:01.234Z
9588138 9588138 20260327195332_HEb0T KR0023 2026-03-28T12:07:14.190Z 2026-04-05T12:35:10.785Z
9583922 9583922 20260326201305_Wd4Vg KR0023 2026-03-27T12:10:08.076Z 2026-04-04T12:41:53.252Z
9583912 9583912 20260326201036_FafTT KR0023 2026-03-27T12:10:07.075Z 2026-04-04T12:41:53.042Z
9583872 9583872 20260326192118_fTJ2N KR0023 2026-03-27T12:09:58.754Z 2026-04-04T12:41:49.041Z
9583758 9583758 20260326174409_42TsM KR0023 2026-03-27T12:09:41.791Z 2026-04-04T12:41:37.488Z
9583627 9583627 20260326164351_bE520 KR0023 2026-03-27T12:09:21.207Z 2026-04-04T12:41:28.801Z
9583394 9583394 20260326141834_3jD9B KR0023 2026-03-27T12:08:39.798Z 2026-04-04T12:41:07.470Z
9583382 9583382 20260326140353_1cQTF KR0023 2026-03-27T12:08:37.904Z 2026-04-04T12:41:06.548Z
9583333 9583333 20260326125950_A9F8w KR0023 2026-03-27T12:08:27.151Z 2026-04-04T12:41:03.287Z
9579094 9579094 20260325201046_GZ9L0 KR0023 2026-03-26T12:09:18.487Z 2026-04-03T12:39:16.738Z
9579068 9579068 20260325191340_1oVmD KR0023 2026-03-26T12:09:15.779Z 2026-04-03T12:39:10.622Z
9579032 9579032 20260325174718_Okwnw KR0023 2026-03-26T12:09:10.911Z 2026-04-03T12:38:51.618Z
9579028 9579028 20260325174507_vD9sZ KR0023 2026-03-26T12:09:10.581Z 2026-04-03T12:38:51.521Z
9578972 9578972 20260325170320_qL4Kk KR0023 2026-03-26T12:09:02.867Z 2026-04-03T12:38:48.385Z
9578936 9578936 20260325163002_CEw7h KR0023 2026-03-26T12:08:54.469Z 2026-04-03T12:38:44.255Z
9578890 9578890 20260325154328_tZkjv KR0023 2026-03-26T12:08:46.485Z 2026-04-03T12:38:39.238Z
9578773 9578773 20260325143316_aa16G KR0023 2026-03-26T12:08:30.665Z 2026-04-03T12:38:32.203Z
9578552 9578552 20260325121407_OJE2b KR0023 2026-03-26T12:07:54.299Z 2026-04-03T12:38:07.882Z
9575256 9575256 20260323195711_gwIjU KR0023 2026-03-25T12:20:41.434Z 2026-03-31T12:28:52.495Z
9575242 9575242 20260323195310_v65lc KR0023 2026-03-25T12:20:40.309Z 2026-03-31T12:28:52.118Z
9575196 9575196 20260323192142_9DdAF KR0023 2026-03-25T12:20:30.225Z 2026-03-31T12:28:50.874Z
9575145 9575145 20260323185905_1S0a6 KR0023 2026-03-25T12:20:24.230Z 2026-03-31T12:28:49.604Z
9570283 9570283 20260322201946_ptabT KR0023 2026-03-24T12:22:55.325Z 2026-03-30T12:30:38.559Z
9570100 9570100 20260322191139_xGMay KR0023 2026-03-24T12:22:34.636Z 2026-03-30T12:30:27.786Z
9570094 9570094 20260322191027_X1KBL KR0023 2026-03-24T12:22:34.322Z 2026-03-30T12:30:27.713Z
9570087 9570087 20260322190900_flNGQ KR0023 2026-03-24T12:22:34.099Z 2026-03-30T12:30:27.627Z
9570063 9570063 20260322190416_gWV8Y KR0023 2026-03-24T12:22:32.191Z 2026-03-30T12:30:27.243Z
9570011 9570011 20260322185152_3QsG1 KR0023 2026-03-24T12:22:28.080Z 2026-03-30T12:30:26.358Z
9569968 9569968 20260322183852_GbyFN KR0023 2026-03-24T12:22:24.476Z 2026-03-30T12:30:25.523Z
9569867 9569867 20260322181230_HuS6F KR0023 2026-03-24T12:22:16.270Z 2026-03-30T12:30:22.596Z
9569724 9569724 20260322170956_0sYIn KR0023 2026-03-24T12:21:55.512Z 2026-03-30T12:30:18.265Z
9569546 9569546 20260322161009_EY1po KR0023 2026-03-24T12:21:20.874Z 2026-03-30T12:30:08.305Z
9569505 9569505 20260322155912_5k3sR KR0023 2026-03-24T12:21:15.501Z 2026-03-30T12:30:06.461Z
9569298 9569298 20260322144445_aR7bH KR0023 2026-03-24T12:20:28.760Z 2026-03-30T12:29:45.937Z
9569152 9569152 20260322134712_GZGtD KR0023 2026-03-24T12:19:55.252Z 2026-03-30T12:29:35.624Z
9569141 9569141 20260322133339_LKu9L KR0023 2026-03-24T12:19:52.735Z 2026-03-30T12:29:34.578Z
9569121 9569121 20260322132955_zIHm0 KR0023 2026-03-24T12:19:50.574Z 2026-03-30T12:29:33.937Z
9569025 9569025 20260322123722_Ee8tF KR0023 2026-03-24T12:19:27.337Z 2026-03-30T12:29:19.107Z
9566651 9566651 20260323135942_Hstab KR0023 2026-03-24T12:12:15.704Z 2026-03-31T12:27:55.081Z
9566102 9566102 20260323130410_a66xl KR0023 2026-03-24T12:11:20.419Z 2026-03-31T12:27:46.025Z
9551431 9551431 20260320194823_qkE5k KR0023 2026-03-22T12:26:39.997Z 2026-03-28T12:36:52.816Z
9551399 9551399 20260320194221_bQV3T KR0023 2026-03-22T12:26:38.198Z 2026-03-28T12:36:50.330Z
9551263 9551263 20260320190437_s5zrF KR0023 2026-03-22T12:26:21.199Z 2026-03-28T12:36:41.607Z
9551104 9551104 20260320182146_KtRPQ KR0023 2026-03-22T12:26:10.459Z 2026-03-28T12:36:40.009Z
9551048 9551048 20260320175958_2geHH KR0023 2026-03-22T12:26:07.407Z 2026-03-28T12:36:39.353Z
9550082 9550082 20260320160654_zqY3g KR0023 2026-03-22T12:24:54.452Z 2026-03-28T12:36:26.977Z
9549418 9549418 20260320145625_MkkDs KR0023 2026-03-22T12:23:57.896Z 2026-03-28T12:36:03.340Z
9545525 9545525 20260321104502_W04wv KR0023 2026-03-22T12:09:38.522Z 2026-03-29T12:19:41.037Z
9541271 9541271 20260319201232_CQdG6 KR0023 2026-03-21T12:28:47.550Z 2026-03-27T12:42:36.061Z
9541065 9541065 20260319191737_4RBGi KR0023 2026-03-21T12:28:28.124Z 2026-03-27T12:42:33.586Z
9540919 9540919 20260319183306_JngYR KR0023 2026-03-21T12:28:16.958Z 2026-03-27T12:42:32.037Z
9540514 9540514 20260319160625_l02nX KR0023 2026-03-21T12:27:07.743Z 2026-03-27T12:42:23.495Z
9540507 9540507 20260319160430_IQ2fk KR0023 2026-03-21T12:27:07.238Z 2026-03-27T12:42:23.400Z
9540463 9540463 20260319154615_hN7cE KR0023 2026-03-21T12:27:01.669Z 2026-03-27T12:42:22.271Z
9540089 9540089 20260319124815_Q5lUm KR0023 2026-03-21T12:26:02.356Z 2026-03-27T12:41:57.944Z
9539220 9539220 20260320142309_LC0LX KR0023 2026-03-21T12:19:09.430Z 2026-03-28T12:35:58.439Z
9539020 9539020 20260320140413_kHDl4 KR0023 2026-03-21T12:18:50.489Z 2026-03-28T12:35:56.090Z
9537627 9537627 20260320115134_TucEk KR0023 2026-03-21T12:16:07.792Z 2026-03-28T12:35:27.837Z
9528533 9528533 20260318162226_cHzk6 KR0023 2026-03-20T12:22:20.889Z 2026-03-26T12:38:36.684Z
9507035 9507035 20260316201008_5rbNE KR0023 2026-03-18T12:19:48.023Z 2026-03-24T12:41:37.824Z
9506996 9506996 20260316200457_AOG2h KR0023 2026-03-18T12:19:44.734Z 2026-03-24T12:41:36.901Z
9506767 9506767 20260316192416_0hg6H KR0023 2026-03-18T12:19:20.248Z 2026-03-24T12:41:34.680Z
9506682 9506682 20260316185002_ZBzN0 KR0023 2026-03-18T12:19:11.925Z 2026-03-24T12:41:34.178Z
9505074 9505074 20260317131800_YuXgc KR0023 2026-03-18T12:09:28.575Z 2026-03-25T12:42:26.243Z
9498164 9498164 20260316144052_sRXYH KR0023 2026-03-17T12:13:24.100Z 2026-03-24T12:41:25.122Z
9497599 9497599 20260316134911_3cm3t KR0023 2026-03-17T12:12:19.344Z 2026-03-24T12:41:23.556Z
9496984 9496984 20260316123917_52SOF KR0023 2026-03-17T12:11:03.697Z 2026-03-24T12:41:21.962Z
9491815 9491815 20260315200917_iRizM KR0023 2026-03-16T12:21:52.706Z 2026-03-23T12:22:42.425Z
9473860 9473860 20260313203247_viWnx KR0023 2026-03-14T12:16:06.147Z 2026-03-21T12:50:18.090Z
9473710 9473710 20260313182845_AchCL KR0023 2026-03-14T12:15:40.283Z 2026-03-21T12:50:00.568Z
9473697 9473697 20260313182543_nM2Ns KR0023 2026-03-14T12:15:38.458Z 2026-03-21T12:50:00.422Z
9473691 9473691 20260313182405_ZQN5w KR0023 2026-03-14T12:15:38.161Z 2026-03-21T12:50:00.238Z
9473649 9473649 20260313174748_63ziL KR0023 2026-03-14T12:15:32.042Z 2026-03-21T12:49:59.116Z
9473568 9473568 20260313172238_h9KBU KR0023 2026-03-14T12:15:19.821Z 2026-03-21T12:49:58.669Z
9473559 9473559 20260313172159_3CxXq KR0023 2026-03-14T12:15:19.003Z 2026-03-21T12:49:58.643Z
9473543 9473543 20260313171601_Ty3Va KR0023 2026-03-14T12:15:16.927Z 2026-03-21T12:49:58.534Z
9473481 9473481 20260313170348_MBWNP KR0023 2026-03-14T12:15:09.001Z 2026-03-21T12:49:58.070Z
9473463 9473463 20260313170200_FXNGZ KR0023 2026-03-14T12:15:07.529Z 2026-03-21T12:49:57.975Z
9473294 9473294 20260313163222_HtvTw KR0023 2026-03-14T12:14:47.830Z 2026-03-21T12:49:55.659Z
9473002 9473002 20260313153327_FoBGa KR0023 2026-03-14T12:14:17.387Z 2026-03-21T12:49:53.216Z
9472741 9472741 20260313145533_MAtBK KR0023 2026-03-14T12:13:49.201Z 2026-03-21T12:49:51.633Z
9472617 9472617 20260313143121_HSJ3r KR0023 2026-03-14T12:13:33.669Z 2026-03-21T12:49:50.058Z
9468397 9468397 20260312201223_iL7E0 KR0023 2026-03-13T12:21:45.556Z 2026-03-20T12:37:15.446Z
9468376 9468376 20260312195630_BLg1y KR0023 2026-03-13T12:21:43.498Z 2026-03-20T12:37:15.254Z
9468348 9468348 20260312194616_eve5w KR0023 2026-03-13T12:21:41.745Z 2026-03-20T12:37:14.965Z
9468344 9468344 20260312194331_iEvz1 KR0023 2026-03-13T12:21:41.494Z 2026-03-20T12:37:14.944Z
9468326 9468326 20260312193102_2QezZ KR0023 2026-03-13T12:21:40.107Z 2026-03-20T12:37:14.744Z
9468297 9468297 20260312191037_XFTBd KR0023 2026-03-13T12:21:37.922Z 2026-03-20T12:37:14.383Z
9468228 9468228 20260312183334_q9yrW KR0023 2026-03-13T12:21:31.460Z 2026-03-20T12:37:13.878Z
9468146 9468146 20260312175247_X2dtm KR0023 2026-03-13T12:21:17.970Z 2026-03-20T12:37:13.029Z
9468114 9468114 20260312173212_wxFqz KR0023 2026-03-13T12:21:14.811Z 2026-03-20T12:37:12.815Z
9467899 9467899 20260312152125_6oUH3 KR0023 2026-03-13T12:20:30.633Z 2026-03-20T12:37:10.552Z

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