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

5,698 rows where station_code = "KR002D" 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
9588102 9588102 20260327190836_q5Ub0 KR002D 2026-03-28T12:07:10.894Z 2026-04-05T12:35:08.245Z
9583889 9583889 20260326194442_D3ZZL KR002D 2026-03-27T12:10:02.567Z 2026-04-04T12:41:50.729Z
9583796 9583796 20260326181900_BMYnA KR002D 2026-03-27T12:09:49.073Z 2026-04-04T12:41:39.329Z
9583786 9583786 20260326181141_BkGpr KR002D 2026-03-27T12:09:45.198Z 2026-04-04T12:41:38.834Z
9579086 9579086 20260325194715_K4WkR KR002D 2026-03-26T12:09:17.742Z 2026-04-03T12:39:13.274Z
9579081 9579081 20260325192652_9ZHhg KR002D 2026-03-26T12:09:16.958Z 2026-04-03T12:39:11.797Z
9579008 9579008 20260325172824_sAea8 KR002D 2026-03-26T12:09:07.502Z 2026-04-03T12:38:50.034Z
9578944 9578944 20260325164509_Mm6aI KR002D 2026-03-26T12:08:55.768Z 2026-04-03T12:38:44.685Z
9578917 9578917 20260325155637_ywCWh KR002D 2026-03-26T12:08:50.096Z 2026-04-03T12:38:40.588Z
9578873 9578873 20260325151939_uxmuL KR002D 2026-03-26T12:08:44.183Z 2026-04-03T12:38:37.269Z
9578818 9578818 20260325150535_Cjum5 KR002D 2026-03-26T12:08:36.675Z 2026-03-26T12:08:36.675Z
9578418 9578418 20260325114830_PrzA1 KR002D 2026-03-26T12:07:34.770Z 2026-04-03T12:38:02.844Z
9574727 9574727 20260323160041_o1qyV KR002D 2026-03-25T12:18:03.267Z 2026-03-31T12:28:20.713Z
9570337 9570337 20260322203743_9wboj KR002D 2026-03-24T12:23:01.620Z 2026-03-30T12:30:40.169Z
9569895 9569895 20260322181948_XIVOO KR002D 2026-03-24T12:22:19.076Z 2026-03-30T12:30:24.519Z
9569474 9569474 20260322154636_YXOe4 KR002D 2026-03-24T12:21:05.961Z 2026-03-30T12:30:04.657Z
9569390 9569390 20260322151938_nANQJ KR002D 2026-03-24T12:20:50.960Z 2026-03-30T12:29:52.396Z
9569226 9569226 20260322141727_2hqSJ KR002D 2026-03-24T12:20:14.279Z 2026-03-30T12:29:40.045Z
9569098 9569098 20260322132249_w2Zqb KR002D 2026-03-24T12:19:47.848Z 2026-03-30T12:29:33.073Z
9569067 9569067 20260322130313_QOFXF KR002D 2026-03-24T12:19:37.065Z 2026-03-30T12:29:29.942Z
9568931 9568931 20260322112656_dFjeR KR002D 2026-03-24T12:19:01.306Z 2026-03-30T12:29:09.400Z
9567030 9567030 20260323143256_naNsG KR002D 2026-03-24T12:12:52.535Z 2026-03-31T12:28:07.386Z
9551610 9551610 20260320203347_r3yMF KR002D 2026-03-22T12:26:51.408Z 2026-03-28T12:36:58.711Z
9551589 9551589 20260320202628_hZgfF KR002D 2026-03-22T12:26:50.034Z 2026-03-28T12:36:58.432Z
9551533 9551533 20260320201201_ukPqF KR002D 2026-03-22T12:26:46.114Z 2026-03-28T12:36:57.444Z
9551075 9551075 20260320180837_HCJ80 KR002D 2026-03-22T12:26:08.809Z 2026-03-28T12:36:39.516Z
9549913 9549913 20260320155341_v6BZS KR002D 2026-03-22T12:24:36.010Z 2026-03-28T12:36:23.698Z
9549818 9549818 20260320154411_hD9lg KR002D 2026-03-22T12:24:30.903Z 2026-03-28T12:36:21.944Z
9547023 9547023 20260321124637_ZrMye KR002D 2026-03-22T12:12:48.643Z 2026-03-29T12:20:05.954Z
9545563 9545563 20260321104758_WU0JP KR002D 2026-03-22T12:09:44.856Z 2026-03-22T12:27:38.063Z
9540352 9540352 20260319152344_OMA36 KR002D 2026-03-21T12:26:53.314Z 2026-03-27T12:42:20.322Z
9540282 9540282 20260319145653_vXyzD KR002D 2026-03-21T12:26:37.608Z 2026-03-27T12:42:08.816Z
9540275 9540275 20260319145325_MxJ8J KR002D 2026-03-21T12:26:36.249Z 2026-03-27T12:42:05.419Z
9540195 9540195 20260319142110_dJfFk KR002D 2026-03-21T12:26:27.080Z 2026-03-27T12:42:03.278Z
9540128 9540128 20260319132754_sn9lV KR002D 2026-03-21T12:26:11.793Z 2026-03-27T12:41:59.922Z
9539942 9539942 20260319110726_K9Drb KR002D 2026-03-21T12:25:20.396Z 2026-03-27T12:41:47.361Z
9538314 9538314 20260320125054_EJOHG KR002D 2026-03-21T12:17:28.699Z 2026-03-28T12:35:46.659Z
9537451 9537451 20260320113844_j8yun KR002D 2026-03-21T12:15:48.097Z 2026-03-21T12:30:06.169Z
9536951 9536951 20260320104832_B1DQG KR002D 2026-03-21T12:14:44.152Z 2026-03-28T12:35:19.113Z
9530209 9530209 20260318202445_d9DhC KR002D 2026-03-20T12:24:12.392Z 2026-03-26T12:39:10.414Z
9529359 9529359 20260318175320_Mn1KL KR002D 2026-03-20T12:23:06.019Z 2026-03-26T12:38:59.732Z
9529292 9529292 20260318173835_A1KbZ KR002D 2026-03-20T12:23:01.851Z 2026-03-26T12:38:54.904Z
9528316 9528316 20260318160428_FyHQP KR002D 2026-03-20T12:22:12.106Z 2026-03-26T12:38:35.318Z
9491773 9491773 20260315193648_GLvD8 KR002D 2026-03-16T12:21:47.983Z 2026-03-23T12:22:41.770Z
9481443 9481443 20260314151545_qDlTC KR002D 2026-03-15T12:17:51.833Z 2026-03-22T12:42:44.614Z
9481137 9481137 20260314144045_6Z2vB KR002D 2026-03-15T12:17:13.422Z 2026-03-22T12:42:43.355Z
9480548 9480548 20260314134245_2E39D KR002D 2026-03-15T12:16:08.828Z 2026-03-22T12:42:41.614Z
9478919 9478919 20260314102346_t5JxB KR002D 2026-03-15T12:12:19.514Z 2026-03-22T12:42:12.462Z
9473857 9473857 20260313203102_O5HcQ KR002D 2026-03-14T12:16:05.771Z 2026-03-21T12:50:17.970Z
9473852 9473852 20260313202634_nFo1C KR002D 2026-03-14T12:16:05.136Z 2026-03-21T12:50:17.716Z
9473842 9473842 20260313200936_Kgutc KR002D 2026-03-14T12:16:03.406Z 2026-03-21T12:50:15.883Z
9473834 9473834 20260313200427_rEp4a KR002D 2026-03-14T12:16:01.987Z 2026-03-21T12:50:13.516Z
9473778 9473778 20260313191725_D6Wo3 KR002D 2026-03-14T12:15:50.623Z 2026-03-21T12:50:01.904Z
9473768 9473768 20260313191243_dOTzD KR002D 2026-03-14T12:15:48.575Z 2026-03-21T12:50:01.509Z
9473733 9473733 20260313184038_v3JPJ KR002D 2026-03-14T12:15:43.204Z 2026-03-21T12:50:00.779Z
9473730 9473730 20260313183952_Zrjuk KR002D 2026-03-14T12:15:42.882Z 2026-03-21T12:50:00.707Z
9473719 9473719 20260313183233_j4Opn KR002D 2026-03-14T12:15:41.915Z 2026-03-21T12:50:00.662Z
9473708 9473708 20260313182823_SfvdP KR002D 2026-03-14T12:15:39.996Z 2026-03-21T12:50:00.557Z
9473667 9473667 20260313180954_gMOeV KR002D 2026-03-14T12:15:35.350Z 2026-03-21T12:49:59.610Z
9473609 9473609 20260313173415_xAjVg KR002D 2026-03-14T12:15:26.871Z 2026-03-21T12:49:58.855Z
9473255 9473255 20260313162347_DxOxT KR002D 2026-03-14T12:14:42.905Z 2026-03-21T12:49:55.358Z
9472911 9472911 20260313152247_y6ytq KR002D 2026-03-14T12:14:09.735Z 2026-03-21T12:49:52.743Z
9468380 9468380 20260312195835_c9zKy KR002D 2026-03-13T12:21:43.759Z 2026-03-20T12:37:15.279Z
9468357 9468357 20260312194747_uYAqv KR002D 2026-03-13T12:21:42.476Z 2026-03-20T12:37:15.051Z
9468235 9468235 20260312183808_q465I KR002D 2026-03-13T12:21:31.982Z 2026-03-20T12:37:13.965Z
9468194 9468194 20260312181157_d9rAw KR002D 2026-03-13T12:21:27.743Z 2026-03-20T12:37:13.438Z
9468136 9468136 20260312174746_UM2hE KR002D 2026-03-13T12:21:17.300Z 2026-03-20T12:37:12.969Z
9468133 9468133 20260312174719_QzpYk KR002D 2026-03-13T12:21:17.083Z 2026-03-20T12:37:12.967Z
9468109 9468109 20260312173016_dPleI KR002D 2026-03-13T12:21:12.759Z 2026-03-20T12:37:12.695Z
9468007 9468007 20260312162127_ah8Xl KR002D 2026-03-13T12:20:53.801Z 2026-03-20T12:37:11.499Z
9467908 9467908 20260312152309_NIBOB KR002D 2026-03-13T12:20:31.463Z 2026-03-20T12:37:10.624Z
9467879 9467879 20260312150807_gYbJS KR002D 2026-03-13T12:20:26.214Z 2026-03-20T12:37:10.123Z
9467867 9467867 20260312150153_9lBPJ KR002D 2026-03-13T12:20:24.476Z 2026-03-20T12:37:10.060Z
9462057 9462057 20260311200304_4XNNU KR002D 2026-03-12T12:18:23.385Z 2026-03-19T12:45:48.081Z
9462048 9462048 20260311195525_iYJwU KR002D 2026-03-12T12:18:22.811Z 2026-03-19T12:45:47.904Z
9461920 9461920 20260311191952_YRCTg KR002D 2026-03-12T12:18:11.248Z 2026-03-19T12:45:46.013Z
9461381 9461381 20260311155632_G3sKq KR002D 2026-03-12T12:17:05.729Z 2026-03-19T12:45:20.048Z
9455325 9455325 20260310200333_lgz73 KR002D 2026-03-11T12:10:51.212Z 2026-03-18T12:40:00.220Z
9455088 9455088 20260310183751_A4rwS KR002D 2026-03-11T12:10:25.112Z 2026-03-18T12:39:54.659Z
9455086 9455086 20260310183708_OVNFL KR002D 2026-03-11T12:10:24.941Z 2026-03-18T12:39:54.584Z
9454991 9454991 20260310175444_JX32F KR002D 2026-03-11T12:10:11.138Z 2026-03-18T12:39:51.310Z
9454952 9454952 20260310174052_I34UP KR002D 2026-03-11T12:10:06.075Z 2026-03-18T12:39:50.861Z
9454855 9454855 20260310172015_bfvdI KR002D 2026-03-11T12:09:58.390Z 2026-03-18T12:39:49.884Z
9454746 9454746 20260310165753_TC5M0 KR002D 2026-03-11T12:09:48.812Z 2026-03-18T12:39:48.774Z
9453764 9453764 20260310143313_QcNfp KR002D 2026-03-11T12:08:08.655Z 2026-03-18T12:39:40.244Z
9450074 9450074 20260309190727_7Syks KR002D 2026-03-10T12:14:39.838Z 2026-03-17T12:42:36.333Z
9449677 9449677 20260309161255_dP1JK KR002D 2026-03-10T12:13:38.632Z 2026-03-17T12:42:30.615Z
9449576 9449576 20260309155554_kvlZ3 KR002D 2026-03-10T12:13:24.216Z 2026-03-17T12:42:29.944Z
9449090 9449090 20260309130612_tXD0F KR002D 2026-03-10T12:11:55.176Z 2026-03-17T12:42:25.902Z
9448822 9448822 20260309120606_BaVUu KR002D 2026-03-10T12:11:04.758Z 2026-03-17T12:42:23.375Z
9445062 9445062 20260308173607_lXrlg KR002D 2026-03-09T12:12:37.002Z 2026-03-16T12:44:36.001Z
9444899 9444899 20260308161213_zUtCC KR002D 2026-03-09T12:12:11.400Z 2026-03-16T12:44:34.166Z
9444496 9444496 20260308141142_iqT1b KR002D 2026-03-09T12:11:02.686Z 2026-03-16T12:44:30.013Z
9440499 9440499 20260307191146_ryfJz KR002D 2026-03-08T12:13:47.338Z 2026-03-15T12:42:08.015Z
9440432 9440432 20260307180448_YfHFj KR002D 2026-03-08T12:13:35.934Z 2026-03-15T12:42:05.928Z
9440245 9440245 20260307164619_pfdqU KR002D 2026-03-08T12:13:09.222Z 2026-03-15T12:42:04.363Z
9440211 9440211 20260307163648_x63Wy KR002D 2026-03-08T12:13:01.644Z 2026-03-15T12:42:04.169Z
9440207 9440207 20260307163547_yHBum KR002D 2026-03-08T12:13:00.654Z 2026-03-15T12:42:04.118Z
9439560 9439560 20260307140608_AwMty KR002D 2026-03-08T12:10:49.231Z 2026-03-15T12:41:43.626Z
9439475 9439475 20260307134653_sMFRS KR002D 2026-03-08T12:10:29.357Z 2026-03-15T12:41:42.889Z

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