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,501 rows where station_code = "KR0013" 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
9266077 9266077 20260127171134_IN3nN KR0013 2026-01-28T14:12:20.924Z 2026-01-29T14:30:24.847Z
9258721 9258721 20260124162420_EbtPE KR0013 2026-01-26T14:14:04.011Z 2026-01-29T14:41:58.076Z
9258591 9258591 20260124145502_Bb8v3 KR0013 2026-01-26T14:13:09.183Z 2026-01-29T14:41:32.762Z
9258009 9258009 20260125175451_c78OK KR0013 2026-01-26T14:09:07.641Z 2026-01-29T14:37:57.821Z
9257933 9257933 20260125170932_PBHwR KR0013 2026-01-26T14:08:40.171Z 2026-01-29T14:37:53.789Z
9257894 9257894 20260125170356_V8j3I KR0013 2026-01-26T14:08:29.250Z 2026-01-26T14:08:29.250Z
9257198 9257198 20260125122033_veFHr KR0013 2026-01-26T14:04:07.676Z 2026-01-29T14:36:54.313Z
9251165 9251165 20260122184743_NyV8q KR0013 2026-01-24T14:10:24.140Z 2026-01-29T14:51:15.528Z
9250879 9250879 20260122162618_LQRvv KR0013 2026-01-24T14:08:24.339Z 2026-01-29T14:50:42.067Z
9250829 9250829 20260122155259_1khZW KR0013 2026-01-24T14:07:50.041Z 2026-01-29T14:50:27.903Z
9250787 9250787 20260122145640_KDYqw KR0013 2026-01-24T14:07:12.246Z 2026-01-29T14:50:17.219Z
9250745 9250745 20260122140825_iVJWG KR0013 2026-01-24T14:06:40.266Z 2026-01-29T14:50:07.782Z
9247686 9247686 20260121192755_lrs15 KR0013 2026-01-23T14:10:47.452Z 2026-01-29T14:56:23.247Z
9246630 9246630 20260121125331_6bvyB KR0013 2026-01-23T14:07:22.937Z 2026-01-29T14:54:50.669Z
9246526 9246526 20260121110928_au3wK KR0013 2026-01-23T14:06:45.037Z 2026-01-29T14:54:29.053Z
9240181 9240181 20260120130433_QVvSY KR0013 2026-01-22T14:06:31.296Z 2026-01-29T15:00:34.999Z
9219542 9219542 20260117110115_KVKTP KR0013 2026-01-18T14:16:55.268Z 2026-01-25T14:59:31.302Z
9219484 9219484 20260117104321_rGHr2 KR0013 2026-01-18T14:16:38.708Z 2026-01-25T14:59:29.323Z
9217603 9217603 20260116182508_ZZDav KR0013 2026-01-18T14:08:09.310Z 2026-01-25T14:57:27.801Z
9217525 9217525 20260116170615_C30vV KR0013 2026-01-18T14:07:42.411Z 2026-01-25T14:57:24.206Z
9217520 9217520 20260116164640_PtUX3 KR0013 2026-01-18T14:07:40.322Z 2026-01-25T14:57:22.937Z
9217489 9217489 20260116155039_kwPI9 KR0013 2026-01-18T14:07:25.706Z 2026-01-25T14:57:20.128Z
9217479 9217479 20260116154051_M8buR KR0013 2026-01-18T14:07:21.140Z 2026-01-25T14:57:19.367Z
9217353 9217353 20260116123149_nqVyP KR0013 2026-01-18T14:05:54.193Z 2026-01-25T14:56:46.351Z
9217050 9217050 20260117142349_2PxhX KR0013 2026-01-18T14:04:03.404Z 2026-01-26T14:59:54.256Z
9216276 9216276 20260116104146_DO51k KR0013 2026-01-17T14:28:52.378Z 2026-01-24T15:15:07.225Z
9212061 9212061 20260115185928_620pQ KR0013 2026-01-17T14:09:44.407Z 2026-01-24T15:10:21.612Z
9211914 9211914 20260115182138_kqcA4 KR0013 2026-01-17T14:09:00.564Z 2026-01-24T15:10:10.548Z
9211810 9211810 20260115175529_0gdfp KR0013 2026-01-17T14:08:37.566Z 2026-01-24T15:09:56.961Z
9211690 9211690 20260115172157_w0qUe KR0013 2026-01-17T14:07:58.916Z 2026-01-24T15:09:46.868Z
9211652 9211652 20260115170540_Pb4ii KR0013 2026-01-17T14:07:40.297Z 2026-01-24T15:09:43.480Z
9211584 9211584 20260115164213_8lKJu KR0013 2026-01-17T14:07:24.171Z 2026-01-24T15:09:37.397Z
9210228 9210228 20260115103450_KhktZ KR0013 2026-01-16T14:19:10.942Z 2026-01-22T15:05:34.144Z
9197130 9197130 20260113101454_4H3lZ KR0013 2026-01-14T14:21:38.158Z 2026-01-21T15:06:14.345Z
9197022 9197022 20260113095642_Q3PrZ KR0013 2026-01-14T14:21:10.033Z 2026-01-21T15:06:12.597Z
9193784 9193784 20260113181514_7Lx1f KR0013 2026-01-14T14:03:19.119Z 2026-01-22T15:07:06.531Z
9193443 9193443 20260113150053_2YgCz KR0013 2026-01-14T14:01:30.309Z 2026-01-22T15:06:19.388Z
9193409 9193409 20260113143636_CdJ9i KR0013 2026-01-14T14:01:15.557Z 2026-01-22T15:06:17.235Z
9193336 9193336 20260113133748_BOsJa KR0013 2026-01-14T14:00:38.223Z 2026-01-22T15:06:13.592Z
9187728 9187728 20260111183804_ivQKD KR0013 2026-01-13T14:08:36.096Z 2026-01-20T15:20:42.871Z
9187424 9187424 20260111170636_njEOV KR0013 2026-01-13T14:07:13.914Z 2026-01-20T15:20:27.738Z
9187342 9187342 20260111161953_pTEXA KR0013 2026-01-13T14:06:52.084Z 2026-01-20T15:20:24.536Z
9187210 9187210 20260111154124_PsmYj KR0013 2026-01-13T14:06:09.984Z 2026-01-20T15:20:09.493Z
9187159 9187159 20260111152842_yzTjm KR0013 2026-01-13T14:05:49.154Z 2026-01-20T15:20:04.066Z
9186964 9186964 20260111143329_39v3g KR0013 2026-01-13T14:04:33.293Z 2026-01-20T15:19:38.775Z
9185896 9185896 20260111135008_n6iZH KR0013 2026-01-12T14:26:14.997Z 2026-01-19T15:22:04.159Z
9174391 9174391 20260109171842_iGhKB KR0013 2026-01-11T14:02:56.072Z 2026-01-18T15:06:41.814Z
9174386 9174386 20260109171558_H9bQA KR0013 2026-01-11T14:02:53.539Z 2026-01-18T15:06:41.411Z
9173667 9173667 20260109130702_q1aUd KR0013 2026-01-10T14:18:48.112Z 2026-01-17T15:26:20.795Z
9171406 9171406 20260108213421_To3vq KR0013 2026-01-10T14:07:15.082Z 2026-01-17T15:23:47.906Z
9171285 9171285 20260108204218_JH7Pw KR0013 2026-01-10T14:06:30.157Z 2026-01-17T15:23:41.831Z
9171192 9171192 20260108195405_RCMI7 KR0013 2026-01-10T14:05:53.694Z 2026-01-17T15:23:36.262Z
9171034 9171034 20260108184402_Y8Tq3 KR0013 2026-01-10T14:04:49.494Z 2026-01-17T15:23:16.938Z
9171008 9171008 20260108183222_IJ6uw KR0013 2026-01-10T14:04:40.334Z 2026-01-17T15:23:15.684Z
9170691 9170691 20260108162006_ub2MX KR0013 2026-01-10T14:02:53.373Z 2026-01-17T15:22:54.773Z
9170164 9170164 20260108145536_hEAXG KR0013 2026-01-09T14:15:57.770Z 2026-01-16T15:14:07.534Z
9170155 9170155 20260108145515_x352N KR0013 2026-01-09T14:15:56.374Z 2026-01-16T15:14:06.873Z
9170146 9170146 20260108145310_mVCPh KR0013 2026-01-09T14:15:55.533Z 2026-01-16T15:14:05.831Z
9170018 9170018 20260108134514_NtMAA KR0013 2026-01-09T14:15:35.072Z 2026-01-16T15:13:35.922Z
9169876 9169876 20260108121012_FaF9x KR0013 2026-01-09T14:15:03.131Z 2026-01-16T15:13:02.656Z
9169804 9169804 20260108105501_rbFMi KR0013 2026-01-09T14:14:41.002Z 2026-01-16T15:12:34.090Z
9166938 9166938 20260107210512_P3QWV KR0013 2026-01-09T14:05:32.787Z 2026-01-16T15:10:31.346Z
9166104 9166104 20260107162710_HUg6q KR0013 2026-01-09T14:01:33.055Z 2026-01-16T15:09:24.186Z
9165696 9165696 20260107145246_bZ2GT KR0013 2026-01-08T14:17:41.795Z 2026-01-13T15:05:23.853Z
9165542 9165542 20260107122538_5L3UQ KR0013 2026-01-08T14:16:48.856Z 2026-01-13T15:04:11.528Z
9152752 9152752 20260105131327_TqDZZ KR0013 2026-01-06T14:18:22.560Z 2026-01-13T15:16:26.131Z
9152567 9152567 20260105122040_Ix15I KR0013 2026-01-06T14:17:44.471Z 2026-01-13T15:16:04.868Z
9152186 9152186 20260105095702_Fo5qI KR0013 2026-01-06T14:16:09.712Z 2026-01-13T15:15:34.704Z
9126218 9126218 20260102212024_UPzLx KR0013 2026-01-03T14:01:08.032Z 2026-01-10T14:57:31.566Z
9125813 9125813 20251231185552_LLb32 KR0013 2026-01-02T14:56:09.196Z 2026-01-08T15:16:09.142Z
9125797 9125797 20251231185458_9ItVM KR0013 2026-01-02T14:56:06.427Z 2026-01-08T15:16:08.320Z
9125561 9125561 20251231182022_cViu1 KR0013 2026-01-02T14:55:32.322Z 2026-01-08T15:15:46.856Z
9121329 9121329 20251231212835_ewo1K KR0013 2026-01-02T14:06:50.615Z 2026-01-09T14:51:53.392Z
9121008 9121008 20251231202316_Stjxi KR0013 2026-01-02T14:05:27.076Z 2026-01-09T14:51:42.750Z
9121006 9121006 20251231202114_YByCa KR0013 2026-01-02T14:05:26.358Z 2026-01-09T14:51:42.649Z
9120939 9120939 20251231200555_5c1Gq KR0013 2026-01-02T14:05:03.456Z 2026-01-09T14:51:31.392Z
9120791 9120791 20251231193824_gfpSL KR0013 2026-01-02T14:04:16.847Z 2026-01-09T14:51:24.008Z
9120603 9120603 20251231191303_zYM4C KR0013 2026-01-02T14:03:21.345Z 2026-01-09T14:51:15.889Z
9108937 9108937 20251229195600_6Qz4c KR0013 2025-12-31T14:44:59.514Z 2026-01-06T15:22:07.360Z
9108475 9108475 20251229185702_1ug2h KR0013 2025-12-31T14:43:39.540Z 2026-01-06T15:21:36.124Z
9108390 9108390 20251229184143_rymt7 KR0013 2025-12-31T14:43:28.080Z 2026-01-06T15:21:33.459Z
9106757 9106757 20251230192028_8olOW KR0013 2025-12-31T14:29:40.268Z 2026-01-07T15:13:24.175Z
9106624 9106624 20251230182836_afKJn KR0013 2025-12-31T14:29:17.967Z 2026-01-07T15:12:58.096Z
9106498 9106498 20251230175027_62aws KR0013 2025-12-31T14:29:01.171Z 2026-01-07T15:12:42.590Z
9106246 9106246 20251230164147_uA0I7 KR0013 2025-12-31T14:28:14.433Z 2026-01-07T15:12:08.664Z
9105962 9105962 20251230144342_5S5Gb KR0013 2025-12-31T14:27:10.385Z 2026-01-07T15:11:27.776Z
9100521 9100521 20251229201934_fOTNY KR0013 2025-12-31T14:03:20.624Z 2026-01-07T15:05:20.522Z
9100483 9100483 20251229201124_oW0N3 KR0013 2025-12-31T14:03:06.814Z 2026-01-07T15:05:18.732Z
9100238 9100238 20251230202434_rIDY3 KR0013 2025-12-31T14:01:43.666Z 2026-01-08T15:04:22.609Z
9100213 9100213 20251230201900_iuXzI KR0013 2025-12-31T14:01:35.116Z 2026-01-08T15:04:19.877Z
9098914 9098914 20251227202708_zgboB KR0013 2025-12-30T15:11:15.797Z 2026-01-04T15:35:32.228Z
9098648 9098648 20251227194619_IpOZA KR0013 2025-12-30T15:10:42.912Z 2025-12-30T15:10:42.912Z
9098411 9098411 20251227190303_2VaQk KR0013 2025-12-30T15:10:28.565Z 2026-01-04T15:35:00.294Z
9097919 9097919 20251227174720_UF2E6 KR0013 2025-12-30T15:09:39.953Z 2026-01-04T15:34:24.906Z
9097470 9097470 20251227163857_5u7tr KR0013 2025-12-30T15:08:43.865Z 2026-01-04T15:33:56.226Z
9097416 9097416 20251227162312_nk9px KR0013 2025-12-30T15:08:39.703Z 2026-01-04T15:33:53.611Z
9097403 9097403 20251227162002_hsOBF KR0013 2025-12-30T15:08:38.612Z 2026-01-04T15:33:53.001Z
9097335 9097335 20251227160323_gxpbn KR0013 2025-12-30T15:08:33.461Z 2026-01-04T15:33:50.091Z
9097117 9097117 20251227153335_y0UaW KR0013 2025-12-30T15:08:23.258Z 2026-01-04T15:33:42.998Z
9094363 9094363 20251227121756_Y0TRP KR0013 2025-12-30T15:05:12.515Z 2026-01-04T15:31:40.079Z

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