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,205 rows where station_code = "KR000C" 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
9610073 9610073 20260405123324_UAXDv KR000C 2026-04-06T12:05:33.907Z 2026-04-07T12:13:19.203Z
9583902 9583902 20260326200144_p2k6i KR000C 2026-03-27T12:10:05.397Z 2026-04-04T12:41:52.174Z
9583823 9583823 20260326185229_wF91P KR000C 2026-03-27T12:09:52.750Z 2026-04-04T12:41:40.241Z
9583795 9583795 20260326181900_BMYnA KR000C 2026-03-27T12:09:49.062Z 2026-04-04T12:41:39.329Z
9579071 9579071 20260325191644_nDptO KR000C 2026-03-26T12:09:16.177Z 2026-04-03T12:39:10.753Z
9578816 9578816 20260325150535_Cjum5 KR000C 2026-03-26T12:08:36.675Z 2026-03-26T12:08:36.675Z
9578415 9578415 20260325114830_PrzA1 KR000C 2026-03-26T12:07:34.727Z 2026-04-03T12:38:02.844Z
9575103 9575103 20260323184246_kgkdz KR000C 2026-03-25T12:20:17.730Z 2026-03-31T12:28:48.468Z
9574655 9574655 20260323104147_pqr2X KR000C 2026-03-25T12:14:07.927Z 2026-03-31T12:27:10.038Z
9570266 9570266 20260322201632_7zsOJ KR000C 2026-03-24T12:22:53.573Z 2026-03-30T12:30:38.164Z
9570211 9570211 20260322195318_fjF1h KR000C 2026-03-24T12:22:48.866Z 2026-03-30T12:30:34.949Z
9569981 9569981 20260322184528_MzIHT KR000C 2026-03-24T12:22:25.943Z 2026-03-30T12:30:25.879Z
9569892 9569892 20260322181858_h6R5l KR000C 2026-03-24T12:22:18.913Z 2026-03-30T12:30:24.498Z
9569768 9569768 20260322172550_zB8xW KR000C 2026-03-24T12:22:02.517Z 2026-03-30T12:30:20.382Z
9569418 9569418 20260322152829_kCVjH KR000C 2026-03-24T12:20:55.227Z 2026-03-30T12:29:53.875Z
9569301 9569301 20260322144452_prFz8 KR000C 2026-03-24T12:20:28.969Z 2026-03-30T12:29:45.982Z
9569225 9569225 20260322141727_2hqSJ KR000C 2026-03-24T12:20:14.279Z 2026-03-30T12:29:40.045Z
9569013 9569013 20260322122456_tDgr0 KR000C 2026-03-24T12:19:23.585Z 2026-03-30T12:29:17.450Z
9551492 9551492 20260320195608_piD2O KR000C 2026-03-22T12:26:43.237Z 2026-03-28T12:36:56.264Z
9551297 9551297 20260320191617_Q342N KR000C 2026-03-22T12:26:24.501Z 2026-03-28T12:36:42.067Z
9551208 9551208 20260320185611_1K32V KR000C 2026-03-22T12:26:18.087Z 2026-03-28T12:36:41.064Z
9551084 9551084 20260320181525_aCGhS KR000C 2026-03-22T12:26:09.705Z 2026-03-28T12:36:39.792Z
9551074 9551074 20260320180837_HCJ80 KR000C 2026-03-22T12:26:08.809Z 2026-03-28T12:36:39.516Z
9551013 9551013 20260320174558_zXVq7 KR000C 2026-03-22T12:26:04.932Z 2026-03-28T12:36:38.946Z
9549971 9549971 20260320155821_2GNX2 KR000C 2026-03-22T12:24:41.136Z 2026-03-28T12:36:25.229Z
9549582 9549582 20260320151630_QuuJu KR000C 2026-03-22T12:24:16.977Z 2026-03-28T12:36:06.760Z
9547504 9547504 20260321133457_EqFKz KR000C 2026-03-22T12:13:48.371Z 2026-03-29T12:20:09.934Z
9547500 9547500 20260321133329_p6ijt KR000C 2026-03-22T12:13:47.592Z 2026-03-22T12:27:38.476Z
9546130 9546130 20260321113913_AENpj KR000C 2026-03-22T12:11:08.721Z 2026-03-22T12:27:38.192Z
9546046 9546046 20260321113218_pRtnX KR000C 2026-03-22T12:10:52.532Z 2026-03-22T12:27:38.171Z
9545561 9545561 20260321104758_WU0JP KR000C 2026-03-22T12:09:44.837Z 2026-03-22T12:27:38.063Z
9540207 9540207 20260319143626_ewMSd KR000C 2026-03-21T12:26:29.853Z 2026-03-27T12:42:03.975Z
9540155 9540155 20260319134804_V8pIM KR000C 2026-03-21T12:26:20.851Z 2026-03-27T12:42:01.822Z
9540032 9540032 20260319123657_39aPS KR000C 2026-03-21T12:25:57.848Z 2026-03-27T12:41:56.640Z
9539940 9539940 20260319110726_K9Drb KR000C 2026-03-21T12:25:20.396Z 2026-03-27T12:41:47.361Z
9539299 9539299 20260320143107_xqAIG KR000C 2026-03-21T12:19:15.181Z 2026-03-28T12:35:59.182Z
9538894 9538894 20260320135452_l9SpK KR000C 2026-03-21T12:18:33.437Z 2026-03-28T12:35:54.356Z
9538657 9538657 20260320133019_9yNyi KR000C 2026-03-21T12:18:06.939Z 2026-03-21T12:30:06.552Z
9537897 9537897 20260320121109_0e73J KR000C 2026-03-21T12:16:39.596Z 2026-03-21T12:30:06.302Z
9537685 9537685 20260320115625_kkENi KR000C 2026-03-21T12:16:15.421Z 2026-03-28T12:35:28.354Z
9530206 9530206 20260318202445_d9DhC KR000C 2026-03-20T12:24:12.364Z 2026-03-26T12:39:10.414Z
9529412 9529412 20260318181451_NQHs3 KR000C 2026-03-20T12:23:08.943Z 2026-03-26T12:39:02.406Z
9529408 9529408 20260318181406_YqMWG KR000C 2026-03-20T12:23:08.835Z 2026-03-26T12:39:02.399Z
9529346 9529346 20260318175216_jHLPq KR000C 2026-03-20T12:23:05.403Z 2026-03-26T12:38:58.828Z
9529290 9529290 20260318173835_A1KbZ KR000C 2026-03-20T12:23:01.851Z 2026-03-26T12:38:54.904Z
9528314 9528314 20260318160428_FyHQP KR000C 2026-03-20T12:22:12.075Z 2026-03-26T12:38:35.318Z
9527737 9527737 20260318151014_g5PHx KR000C 2026-03-20T12:21:41.310Z 2026-03-26T12:38:30.978Z
9491867 9491867 20260315204155_dZAMN KR000C 2026-03-16T12:22:01.027Z 2026-03-23T12:22:42.812Z
9491827 9491827 20260315202326_Q78u3 KR000C 2026-03-16T12:21:55.198Z 2026-03-23T12:22:42.521Z
9491753 9491753 20260315192226_SXAX2 KR000C 2026-03-16T12:21:44.770Z 2026-03-23T12:22:41.481Z
9481869 9481869 20260314160530_zqdAp KR000C 2026-03-15T12:18:39.303Z 2026-03-22T12:42:46.068Z
9481520 9481520 20260314152416_U3Xya KR000C 2026-03-15T12:17:59.863Z 2026-03-22T12:42:44.860Z
9479376 9479376 20260314113110_AQyO1 KR000C 2026-03-15T12:13:33.166Z 2026-03-22T12:42:26.547Z
9479248 9479248 20260314111638_qCWRO KR000C 2026-03-15T12:13:15.966Z 2026-03-22T12:42:21.654Z
9478918 9478918 20260314102346_t5JxB KR000C 2026-03-15T12:12:19.494Z 2026-03-22T12:42:12.462Z
9473869 9473869 20260313205543_s2yQb KR000C 2026-03-14T12:16:06.935Z 2026-03-21T12:50:21.547Z
9473800 9473800 20260313193914_jL72w KR000C 2026-03-14T12:15:56.702Z 2026-03-21T12:50:07.663Z
9473793 9473793 20260313192319_0w2CT KR000C 2026-03-14T12:15:55.527Z 2026-03-21T12:50:03.383Z
9473779 9473779 20260313191900_34Tcg KR000C 2026-03-14T12:15:50.942Z 2026-03-21T12:50:01.986Z
9473707 9473707 20260313182823_SfvdP KR000C 2026-03-14T12:15:39.996Z 2026-03-21T12:50:00.557Z
9472696 9472696 20260313144610_2PCI2 KR000C 2026-03-14T12:13:43.784Z 2026-03-21T12:49:50.983Z
9471869 9471869 20260313115153_2JT1h KR000C 2026-03-14T12:11:41.875Z 2026-03-21T12:49:44.153Z
9468355 9468355 20260312194747_uYAqv KR000C 2026-03-13T12:21:42.476Z 2026-03-20T12:37:15.051Z
9468234 9468234 20260312183808_q465I KR000C 2026-03-13T12:21:31.982Z 2026-03-20T12:37:13.965Z
9468130 9468130 20260312174719_QzpYk KR000C 2026-03-13T12:21:17.065Z 2026-03-20T12:37:12.967Z
9467865 9467865 20260312150153_9lBPJ KR000C 2026-03-13T12:20:24.438Z 2026-03-20T12:37:10.060Z
9462056 9462056 20260311200304_4XNNU KR000C 2026-03-12T12:18:23.384Z 2026-03-19T12:45:48.081Z
9461941 9461941 20260311193101_3YGKO KR000C 2026-03-12T12:18:13.530Z 2026-03-19T12:45:46.541Z
9455115 9455115 20260310185128_OrpMv KR000C 2026-03-11T12:10:28.344Z 2026-03-18T12:39:55.647Z
9454961 9454961 20260310174506_VMN8W KR000C 2026-03-11T12:10:07.886Z 2026-03-18T12:39:51.037Z
9454950 9454950 20260310174052_I34UP KR000C 2026-03-11T12:10:06.075Z 2026-03-18T12:39:50.861Z
9454937 9454937 20260310173931_MZNh8 KR000C 2026-03-11T12:10:05.178Z 2026-03-18T12:39:50.803Z
9454852 9454852 20260310172015_bfvdI KR000C 2026-03-11T12:09:58.390Z 2026-03-18T12:39:49.884Z
9453847 9453847 20260310144637_izSi3 KR000C 2026-03-11T12:08:19.639Z 2026-03-18T12:39:41.079Z
9453762 9453762 20260310143313_QcNfp KR000C 2026-03-11T12:08:08.640Z 2026-03-18T12:39:40.244Z
9449283 9449283 20260309141212_2nspX KR000C 2026-03-10T12:12:29.536Z 2026-03-17T12:42:27.459Z
9444903 9444903 20260308161330_fs6Pj KR000C 2026-03-09T12:12:12.370Z 2026-03-16T12:44:34.242Z
9444132 9444132 20260308123702_2Yj1c KR000C 2026-03-09T12:09:59.556Z 2026-03-16T12:44:26.378Z
9440242 9440242 20260307164619_pfdqU KR000C 2026-03-08T12:13:09.222Z 2026-03-15T12:42:04.363Z
9440167 9440167 20260307162610_kBKQe KR000C 2026-03-08T12:12:53.452Z 2026-03-15T12:42:03.716Z
9439940 9439940 20260307152914_xFrCy KR000C 2026-03-08T12:12:07.306Z 2026-03-15T12:42:01.633Z
9439854 9439854 20260307150848_lyf2X KR000C 2026-03-08T12:11:49.497Z 2026-03-15T12:42:00.846Z
9439593 9439593 20260307141839_1FQ26 KR000C 2026-03-08T12:10:58.122Z 2026-03-15T12:41:44.032Z
9439537 9439537 20260307135832_mx3NX KR000C 2026-03-08T12:10:44.026Z 2026-03-15T12:41:43.349Z
9438825 9438825 20260307114030_Lavot KR000C 2026-03-08T12:08:40.258Z 2026-03-15T12:41:35.901Z
9438728 9438728 20260307112435_Knph3 KR000C 2026-03-08T12:08:20.653Z 2026-03-15T12:41:34.958Z
9415233 9415233 20260228205536_shkmY KR000C 2026-03-02T14:07:36.555Z 2026-03-08T12:43:06.940Z
9415074 9415074 20260228195101_l0VNh KR000C 2026-03-02T14:07:17.210Z 2026-03-08T12:43:00.414Z
9414999 9414999 20260228191252_xv4Ii KR000C 2026-03-02T14:07:08.572Z 2026-03-08T12:42:57.024Z
9414855 9414855 20260228175402_STp2X KR000C 2026-03-02T14:06:53.501Z 2026-03-08T12:42:44.065Z
9396351 9396351 20260225191101_3MnFc KR000C 2026-02-26T14:23:12.494Z 2026-03-05T14:38:38.271Z
9396339 9396339 20260225190620_dssU4 KR000C 2026-02-26T14:23:11.392Z 2026-03-05T14:38:38.019Z
9396310 9396310 20260225190244_3qbK0 KR000C 2026-02-26T14:23:04.009Z 2026-03-05T14:38:37.462Z
9396283 9396283 20260225185803_ULcai KR000C 2026-02-26T14:23:02.492Z 2026-03-05T14:38:36.794Z
9396234 9396234 20260225184503_Ty9Be KR000C 2026-02-26T14:22:59.274Z 2026-03-05T14:38:35.664Z
9396087 9396087 20260225181423_lEBli KR000C 2026-02-26T14:22:48.001Z 2026-03-05T14:38:26.526Z
9396079 9396079 20260225180930_IS7vQ KR000C 2026-02-26T14:22:47.032Z 2026-03-05T14:38:26.233Z
9396010 9396010 20260225175704_gYRjk KR000C 2026-02-26T14:22:42.851Z 2026-03-05T14:38:24.553Z
9395780 9395780 20260225164110_atxhD KR000C 2026-02-26T14:22:17.220Z 2026-03-05T14:38:09.464Z
9395687 9395687 20260225160421_dZCSQ KR000C 2026-02-26T14:22:08.287Z 2026-03-05T14:38:04.447Z

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