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

3,043 rows where station_code = "KR001A" 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
9541063 9541063 20260319191737_4RBGi KR001A 2026-03-21T12:28:28.124Z 2026-03-27T12:42:33.586Z
9541003 9541003 20260319185245_ukJDu KR001A 2026-03-21T12:28:22.604Z 2026-03-27T12:42:32.837Z
9540994 9540994 20260319185118_VDwmG KR001A 2026-03-21T12:28:22.000Z 2026-03-27T12:42:32.785Z
9540958 9540958 20260319184238_hCoSB KR001A 2026-03-21T12:28:19.339Z 2026-03-27T12:42:32.499Z
9540918 9540918 20260319183306_JngYR KR001A 2026-03-21T12:28:16.958Z 2026-03-27T12:42:32.037Z
9540847 9540847 20260319181523_E1Zsl KR001A 2026-03-21T12:28:13.137Z 2026-03-27T12:42:31.499Z
9540513 9540513 20260319160625_l02nX KR001A 2026-03-21T12:27:07.719Z 2026-03-27T12:42:23.495Z
9473506 9473506 20260313170718_vR6Gg KR001A 2026-03-14T12:15:10.957Z 2026-03-21T12:49:58.192Z
9473480 9473480 20260313170348_MBWNP KR001A 2026-03-14T12:15:09.001Z 2026-03-21T12:49:58.070Z
9473292 9473292 20260313163222_HtvTw KR001A 2026-03-14T12:14:47.798Z 2026-03-21T12:49:55.659Z
9396638 9396638 20260225203942_nmqC7 KR001A 2026-02-26T14:23:31.687Z 2026-03-05T14:38:49.332Z
9395976 9395976 20260225175121_136S3 KR001A 2026-02-26T14:22:40.912Z 2026-03-05T14:38:23.950Z
9389716 9389716 20260224201341_izepa KR001A 2026-02-25T14:25:21.149Z 2026-03-04T14:19:21.769Z
9389694 9389694 20260224195859_7D5N5 KR001A 2026-02-25T14:25:19.902Z 2026-03-04T14:19:20.839Z
9380062 9380062 20260222184849_I6u7z KR001A 2026-02-24T14:22:35.505Z 2026-02-24T14:22:35.505Z
9350382 9350382 20260218203225_kU8Ck KR001A 2026-02-20T14:02:00.691Z 2026-02-27T14:35:59.345Z
9310121 9310121 20260208102434_SCn2b KR001A 2026-02-10T14:16:33.169Z 2026-02-16T14:50:33.237Z
9271286 9271286 20260128205407_0SHzC KR001A 2026-01-29T14:15:50.382Z 2026-02-06T14:47:26.500Z
9256790 9256790 20260125103308_YCva7 KR001A 2026-01-26T14:02:04.416Z 2026-02-03T14:43:31.170Z
9250620 9250620 20260122111921_mX9B9 KR001A 2026-01-24T14:04:26.476Z 2026-01-31T14:57:48.264Z
9246469 9246469 20260121095600_VFsvU KR001A 2026-01-23T14:06:11.734Z 2026-01-30T14:51:39.393Z
9197798 9197798 20260113123752_1sMdV KR001A 2026-01-14T14:24:26.272Z 2026-01-21T15:06:24.875Z
9185668 9185668 20260111122742_n8FKA KR001A 2026-01-12T14:25:26.647Z 2026-01-19T15:21:17.963Z
9185597 9185597 20260111120950_DKEgr KR001A 2026-01-12T14:25:16.290Z 2026-01-19T15:21:08.900Z
9185564 9185564 20260111115933_jB3J6 KR001A 2026-01-12T14:25:12.358Z 2026-01-19T15:21:06.142Z
9169868 9169868 20260108120334_w13l3 KR001A 2026-01-09T14:14:56.605Z 2026-01-16T15:12:59.057Z
9169825 9169825 20260108112320_g03l8 KR001A 2026-01-09T14:14:43.642Z 2026-01-16T15:12:50.531Z
8993306 8993306 20251218212312_lxRkZ KR001A 2025-12-26T14:52:43.747Z 2025-12-27T15:27:27.843Z
8993161 8993161 20251218205010_XjlZv KR001A 2025-12-26T14:52:17.317Z 2025-12-26T14:52:17.317Z
8993141 8993141 20251218204728_8NHGa KR001A 2025-12-26T14:52:15.530Z 2025-12-26T14:52:15.530Z
8993100 8993100 20251218204031_cs2Gv KR001A 2025-12-26T14:52:12.511Z 2025-12-27T15:27:16.467Z
8993093 8993093 20251218204030_Y3730 KR001A 2025-12-26T14:52:12.279Z 2025-12-27T15:27:16.460Z
8993037 8993037 20251218203149_zQZ4d KR001A 2025-12-26T14:52:08.434Z 2025-12-27T15:27:10.791Z
8992941 8992941 20251218201339_3Ovsl KR001A 2025-12-26T14:52:02.601Z 2025-12-27T15:27:05.660Z
8992783 8992783 20251218195423_V02qA KR001A 2025-12-26T14:51:42.724Z 2025-12-27T15:26:55.199Z
8992758 8992758 20251218195017_2Sz87 KR001A 2025-12-26T14:51:39.827Z 2025-12-27T15:26:53.244Z
8992616 8992616 20251218193206_eBV9V KR001A 2025-12-26T14:51:30.705Z 2025-12-27T15:26:28.727Z
8992482 8992482 20251218191920_q4U0p KR001A 2025-12-26T14:51:09.656Z 2025-12-27T15:26:18.681Z
8992082 8992082 20251218182315_Rb84K KR001A 2025-12-26T14:50:25.893Z 2025-12-27T15:25:43.749Z
8992043 8992043 20251218181657_2WbQv KR001A 2025-12-26T14:50:13.677Z 2025-12-27T15:25:41.915Z
8991681 8991681 20251218171859_WrQIW KR001A 2025-12-26T14:49:24.751Z 2025-12-27T15:25:07.205Z
8991566 8991566 20251218170216_jEi6Y KR001A 2025-12-26T14:49:06.570Z 2025-12-27T15:25:01.224Z
8991441 8991441 20251218164127_b022U KR001A 2025-12-26T14:48:44.703Z 2025-12-27T15:24:57.413Z
8991372 8991372 20251218163518_h2hj3 KR001A 2025-12-26T14:48:36.938Z 2025-12-27T15:24:53.122Z
8991309 8991309 20251218162507_05K20 KR001A 2025-12-26T14:48:30.268Z 2025-12-27T15:24:52.253Z
8991224 8991224 20251218161303_N9Uc5 KR001A 2025-12-26T14:48:17.837Z 2025-12-27T15:24:47.867Z
8990770 8990770 20251218145903_PVHSC KR001A 2025-12-26T14:47:04.691Z 2025-12-26T14:47:04.691Z
8990767 8990767 20251218145902_AZNVh KR001A 2025-12-26T14:47:04.444Z 2025-12-26T14:47:04.444Z
8990480 8990480 20251218135643_3xcyH KR001A 2025-12-26T14:46:24.294Z 2025-12-26T14:46:24.294Z
8989793 8989793 20251218122515_koVZl KR001A 2025-12-26T14:44:55.311Z 2025-12-27T15:23:11.625Z
8988826 8988826 20251218105632_YBmcq KR001A 2025-12-26T14:43:09.797Z 2025-12-26T14:43:09.797Z
8981391 8981391 20251219172905_UhLyP KR001A 2025-12-26T14:24:38.702Z 2025-12-28T15:21:45.784Z
8957842 8957842 20251217133952_EMOs3 KR001A 2025-12-25T14:22:43.052Z 2025-12-26T15:01:41.016Z
8957358 8957358 20251217125931_x2WFd KR001A 2025-12-25T14:21:24.163Z 2025-12-26T15:01:17.980Z
8956313 8956313 20251217113502_QGV3v KR001A 2025-12-25T14:18:04.898Z 2025-12-26T15:00:22.070Z
8749447 8749447 20251209145518_cokzX KR001A 2025-12-13T15:36:21.670Z 2025-12-17T15:26:09.463Z
8748779 8748779 20251209131548_GPytk KR001A 2025-12-13T15:35:23.126Z 2025-12-17T15:25:12.782Z
8748455 8748455 20251209123359_pYk99 KR001A 2025-12-13T15:34:27.014Z 2025-12-17T15:25:06.245Z
8748145 8748145 20251209115251_Oi9dn KR001A 2025-12-13T15:33:42.935Z 2025-12-17T15:24:59.406Z
8731932 8731932 20251211134619_dwrfP KR001A 2025-12-13T14:44:17.470Z 2025-12-20T14:23:47.009Z
8731665 8731665 20251211131604_MiR2d KR001A 2025-12-13T14:43:18.266Z 2025-12-20T14:23:45.760Z
8731575 8731575 20251211131101_rm63X KR001A 2025-12-13T14:42:51.597Z 2025-12-20T14:23:45.418Z
8731416 8731416 20251211130146_fWkI3 KR001A 2025-12-13T14:42:33.460Z 2025-12-20T14:23:44.748Z
8731079 8731079 20251211124335_41qQE KR001A 2025-12-13T14:41:37.304Z 2025-12-20T14:23:42.984Z
8730928 8730928 20251211122657_W28ee KR001A 2025-12-13T14:40:46.239Z 2025-12-20T14:23:41.277Z
8705869 8705869 20251208205606_Mr7gI KR001A 2025-12-09T14:17:19.495Z 2025-12-17T15:33:32.512Z
8705861 8705861 20251208205520_RqWtc KR001A 2025-12-09T14:17:18.856Z 2025-12-17T15:33:32.188Z
8705844 8705844 20251208204846_eaCjH KR001A 2025-12-09T14:17:17.994Z 2025-12-17T15:33:31.916Z
8705653 8705653 20251208201751_5pOXe KR001A 2025-12-09T14:17:03.355Z 2025-12-17T15:33:17.967Z
8705641 8705641 20251208201639_lQzRs KR001A 2025-12-09T14:17:02.695Z 2025-12-17T15:33:17.577Z
8705567 8705567 20251208195122_bHE2K KR001A 2025-12-09T14:16:42.818Z 2025-12-17T15:33:06.601Z
8705552 8705552 20251208194803_kxj7c KR001A 2025-12-09T14:16:41.611Z 2025-12-17T15:33:01.054Z
8704132 8704132 20251208145520_L7dz2 KR001A 2025-12-09T14:13:51.685Z 2025-12-17T15:31:51.757Z
8703639 8703639 20251208135638_Fq0Yr KR001A 2025-12-09T14:12:28.618Z 2025-12-17T15:31:46.798Z
8703008 8703008 20251208122255_J0ZVa KR001A 2025-12-09T14:10:26.358Z 2025-12-17T15:31:39.039Z
8702691 8702691 20251208114817_2FLd8 KR001A 2025-12-09T14:09:19.412Z 2025-12-17T15:31:35.186Z
8679700 8679700 20251202204150_YY5op KR001A 2025-12-04T14:10:17.324Z 2025-12-11T14:44:55.581Z
8679377 8679377 20251202195745_jIwB3 KR001A 2025-12-04T14:09:41.191Z 2025-12-11T14:44:47.444Z
8678496 8678496 20251202142650_wluoG KR001A 2025-12-04T14:07:06.601Z 2025-12-11T14:43:46.373Z
8678463 8678463 20251202134455_6uPWw KR001A 2025-12-04T14:07:00.644Z 2025-12-11T14:43:44.879Z
8672930 8672930 20251201154033_L9MuR KR001A 2025-12-03T14:16:57.655Z 2025-12-10T14:38:09.114Z
8671532 8671532 20251201123023_uA6mZ KR001A 2025-12-03T14:12:56.436Z 2025-12-10T14:37:15.317Z
8671264 8671264 20251201115015_9KMIV KR001A 2025-12-03T14:11:57.809Z 2025-12-10T14:37:10.154Z
8658183 8658183 20251128134120_TPf8s KR001A 2025-12-01T14:40:34.701Z 2025-12-07T14:54:15.453Z
8645177 8645177 20251128204821_RQRfW KR001A 2025-11-30T14:23:10.933Z 2025-12-07T14:57:04.543Z
8645084 8645084 20251128203458_yUTWO KR001A 2025-11-30T14:23:02.390Z 2025-12-07T14:57:03.329Z
8644766 8644766 20251128195610_NmZXA KR001A 2025-11-30T14:22:23.772Z 2025-12-07T14:56:42.165Z
8644647 8644647 20251128193905_EXgwC KR001A 2025-11-30T14:22:11.772Z 2025-12-07T14:56:32.525Z
8644518 8644518 20251128193036_UPhc5 KR001A 2025-11-30T14:22:04.201Z 2025-12-07T14:56:22.440Z
8644499 8644499 20251128192855_WcX8i KR001A 2025-11-30T14:22:02.848Z 2025-12-07T14:56:22.079Z
8644437 8644437 20251128192649_9CbGG KR001A 2025-11-30T14:22:00.008Z 2025-12-07T14:56:21.384Z
8643927 8643927 20251128183953_lY6W6 KR001A 2025-11-30T14:20:49.989Z 2025-12-07T14:56:10.519Z
8643899 8643899 20251128183744_DUr3m KR001A 2025-11-30T14:20:47.953Z 2025-12-07T14:56:10.177Z
8643790 8643790 20251128182749_oC0e5 KR001A 2025-11-30T14:20:41.183Z 2025-12-07T14:56:08.207Z
8643654 8643654 20251128181155_r2RLY KR001A 2025-11-30T14:20:31.083Z 2025-12-07T14:56:05.761Z
8643263 8643263 20251128173954_pP3h7 KR001A 2025-11-30T14:19:48.971Z 2025-12-07T14:55:58.515Z
8642998 8642998 20251128171027_HQFI7 KR001A 2025-11-30T14:19:12.348Z 2025-12-07T14:55:24.625Z
8642742 8642742 20251128164304_clIaU KR001A 2025-11-30T14:18:33.980Z 2025-12-07T14:55:15.892Z
8642573 8642573 20251128162503_sMmIw KR001A 2025-11-30T14:18:19.329Z 2025-12-07T14:55:10.962Z
8641558 8641558 20251128145922_KL507 KR001A 2025-11-30T14:16:32.327Z 2025-12-07T14:54:57.026Z

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