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

7,610 rows where station_code = "KR003X" 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
9271271 9271271 20260128204532_AL2SJ KR003X 2026-01-29T14:15:44.150Z 2026-01-29T14:15:44.150Z
9271259 9271259 20260128203952_2P724 KR003X 2026-01-29T14:15:42.103Z 2026-01-29T14:15:42.103Z
9271242 9271242 20260128203607_aIcE1 KR003X 2026-01-29T14:15:39.892Z 2026-01-29T14:15:39.892Z
9271136 9271136 20260128200703_Bl6Wq KR003X 2026-01-29T14:15:20.555Z 2026-01-29T14:15:20.555Z
9271047 9271047 20260128192739_T9f6p KR003X 2026-01-29T14:15:01.930Z 2026-01-29T14:15:01.930Z
9271021 9271021 20260128192416_zPR5f KR003X 2026-01-29T14:14:58.581Z 2026-01-29T14:14:58.581Z
9270933 9270933 20260128185538_76Hbj KR003X 2026-01-29T14:14:36.578Z 2026-01-29T14:14:36.578Z
9270917 9270917 20260128184815_Fcsvj KR003X 2026-01-29T14:14:33.553Z 2026-01-29T14:14:33.553Z
9270910 9270910 20260128184425_toI2L KR003X 2026-01-29T14:14:32.496Z 2026-01-29T14:14:32.496Z
9270830 9270830 20260128180115_yLQBZ KR003X 2026-01-29T14:14:08.499Z 2026-01-29T14:14:08.499Z
9270800 9270800 20260128174513_2Rba2 KR003X 2026-01-29T14:14:00.252Z 2026-01-29T14:14:00.252Z
9270775 9270775 20260128173723_ZGbu5 KR003X 2026-01-29T14:13:51.944Z 2026-01-29T14:13:51.944Z
9270760 9270760 20260128173256_0j3Pa KR003X 2026-01-29T14:13:48.066Z 2026-01-29T14:13:48.066Z
9267966 9267966 20260125190629_XCeTL KR003X 2026-01-28T14:26:51.235Z 2026-01-29T14:38:05.321Z
9267249 9267249 20260126213802_oyor7 KR003X 2026-01-28T14:20:42.689Z 2026-01-29T14:34:44.909Z
9267239 9267239 20260126211310_9UKmM KR003X 2026-01-28T14:20:37.148Z 2026-01-29T14:34:41.624Z
9267237 9267237 20260126210812_ioLej KR003X 2026-01-28T14:20:32.516Z 2026-01-29T14:34:37.218Z
9267228 9267228 20260126204527_I0jJt KR003X 2026-01-28T14:20:26.390Z 2026-01-29T14:34:35.920Z
9267185 9267185 20260126202217_jEG7S KR003X 2026-01-28T14:20:10.086Z 2026-01-29T14:34:29.546Z
9267177 9267177 20260126201436_IVWYB KR003X 2026-01-28T14:20:02.371Z 2026-01-29T14:34:28.695Z
9267149 9267149 20260126195000_Bzmxr KR003X 2026-01-28T14:19:44.343Z 2026-01-29T14:34:24.912Z
9267147 9267147 20260126194934_KtOlh KR003X 2026-01-28T14:19:43.696Z 2026-01-29T14:34:24.693Z
9267109 9267109 20260126190901_X396r KR003X 2026-01-28T14:19:17.719Z 2026-01-29T14:34:18.346Z
9267103 9267103 20260126185746_9YA7b KR003X 2026-01-28T14:19:13.585Z 2026-01-29T14:34:17.291Z
9267037 9267037 20260126182223_UKv3d KR003X 2026-01-28T14:18:34.868Z 2026-01-29T14:34:00.579Z
9266934 9266934 20260126164921_76ZvK KR003X 2026-01-28T14:17:44.094Z 2026-01-29T14:33:45.994Z
9266915 9266915 20260126162004_HIrek KR003X 2026-01-28T14:17:36.317Z 2026-01-29T14:33:43.488Z
9266883 9266883 20260126154008_gUMSm KR003X 2026-01-28T14:17:14.033Z 2026-01-29T14:33:31.550Z
9266812 9266812 20260127213038_68yMG KR003X 2026-01-28T14:14:38.436Z 2026-01-29T14:30:25.222Z
9266706 9266706 20260127204910_3q6VA KR003X 2026-01-28T14:14:20.244Z 2026-01-29T14:30:25.187Z
9266668 9266668 20260127203024_2S0Gj KR003X 2026-01-28T14:14:13.889Z 2026-01-29T14:30:25.166Z
9266649 9266649 20260127202453_ORvUE KR003X 2026-01-28T14:14:11.177Z 2026-01-29T14:30:25.156Z
9266628 9266628 20260127200843_l2N2E KR003X 2026-01-28T14:14:07.257Z 2026-01-29T14:30:25.142Z
9266590 9266590 20260127200124_QUFzR KR003X 2026-01-28T14:13:57.140Z 2026-01-29T14:30:25.134Z
9266532 9266532 20260127194414_F8VpI KR003X 2026-01-28T14:13:47.113Z 2026-01-29T14:30:25.069Z
9266461 9266461 20260127192404_4Edb2 KR003X 2026-01-28T14:13:37.170Z 2026-01-29T14:30:25.032Z
9266407 9266407 20260127191441_Ay8Jy KR003X 2026-01-28T14:13:25.492Z 2026-01-29T14:30:25.021Z
9266402 9266402 20260127191404_Twk4C KR003X 2026-01-28T14:13:25.146Z 2026-01-29T14:30:25.020Z
9266312 9266312 20260127184805_6dT6P KR003X 2026-01-28T14:13:12.292Z 2026-01-29T14:30:24.991Z
9266207 9266207 20260127180338_tvtau KR003X 2026-01-28T14:12:50.213Z 2026-01-29T14:30:24.924Z
9266142 9266142 20260127173920_8aNgx KR003X 2026-01-28T14:12:37.435Z 2026-01-29T14:30:24.895Z
9266135 9266135 20260127173748_yhSZx KR003X 2026-01-28T14:12:32.725Z 2026-01-29T14:30:24.894Z
9266062 9266062 20260127165906_RlJDV KR003X 2026-01-28T14:12:16.856Z 2026-01-29T14:30:24.837Z
9266021 9266021 20260127163607_014KC KR003X 2026-01-28T14:12:08.882Z 2026-01-29T14:30:24.813Z
9266012 9266012 20260127163451_OycvQ KR003X 2026-01-28T14:12:07.971Z 2026-01-29T14:30:24.813Z
9265467 9265467 20260127151835_28I6g KR003X 2026-01-28T14:10:14.858Z 2026-01-29T14:30:24.556Z
9259340 9259340 20260124202947_0CHk6 KR003X 2026-01-26T14:16:37.337Z 2026-01-29T14:42:48.662Z
9259137 9259137 20260124190210_27cwn KR003X 2026-01-26T14:15:52.629Z 2026-01-29T14:42:38.145Z
9259102 9259102 20260124185028_tSOMj KR003X 2026-01-26T14:15:41.601Z 2026-01-29T14:42:36.994Z
9259044 9259044 20260124183238_UnLjS KR003X 2026-01-26T14:15:31.062Z 2026-01-29T14:42:27.691Z
9259017 9259017 20260124182347_6RGjl KR003X 2026-01-26T14:15:25.954Z 2026-01-29T14:42:26.120Z
9258942 9258942 20260124180443_fuZcm KR003X 2026-01-26T14:15:07.010Z 2026-01-29T14:42:20.087Z
9258739 9258739 20260124163129_Ltxm8 KR003X 2026-01-26T14:14:05.730Z 2026-01-29T14:41:59.015Z
9258704 9258704 20260124161146_B3Sjm KR003X 2026-01-26T14:13:58.869Z 2026-01-29T14:41:53.959Z
9258530 9258530 20260124141354_Nyd9y KR003X 2026-01-26T14:12:40.449Z 2026-01-29T14:41:21.968Z
9258486 9258486 20260124132924_e4YLn KR003X 2026-01-26T14:12:26.959Z 2026-01-29T14:41:14.695Z
9258444 9258444 20260124125136_augrJ KR003X 2026-01-26T14:12:07.137Z 2026-01-29T14:40:58.994Z
9258421 9258421 20260124121344_rW6TM KR003X 2026-01-26T14:11:53.163Z 2026-01-29T14:40:53.626Z
9258345 9258345 20260125213951_jdtbr KR003X 2026-01-26T14:10:31.773Z 2026-01-29T14:38:28.333Z
9258233 9258233 20260125200244_5ODkw KR003X 2026-01-26T14:10:08.655Z 2026-01-29T14:38:12.839Z
9258200 9258200 20260125193840_X8Vb4 KR003X 2026-01-26T14:10:00.391Z 2026-01-29T14:38:08.052Z
9258162 9258162 20260125191343_tPsfP KR003X 2026-01-26T14:09:52.366Z 2026-01-29T14:38:06.114Z
9258145 9258145 20260125190629_APAd7 KR003X 2026-01-26T14:09:49.668Z 2026-01-27T14:17:19.112Z
9258086 9258086 20260125183243_2v8K1 KR003X 2026-01-26T14:09:32.954Z 2026-01-29T14:38:02.463Z
9258016 9258016 20260125175852_Ftf3c KR003X 2026-01-26T14:09:08.558Z 2026-01-29T14:37:57.947Z
9257946 9257946 20260125171440_GKwGb KR003X 2026-01-26T14:08:42.599Z 2026-01-29T14:37:54.353Z
9257913 9257913 20260125170618_cz73y KR003X 2026-01-26T14:08:31.670Z 2026-01-29T14:37:52.927Z
9257887 9257887 20260125164911_gqQRQ KR003X 2026-01-26T14:08:26.116Z 2026-01-29T14:37:46.597Z
9257873 9257873 20260125164116_kjDDI KR003X 2026-01-26T14:08:15.150Z 2026-01-29T14:37:45.783Z
9257771 9257771 20260125155250_F3MLg KR003X 2026-01-26T14:07:40.346Z 2026-01-29T14:37:38.794Z
9257532 9257532 20260125142239_KZfAH KR003X 2026-01-26T14:06:10.963Z 2026-01-29T14:37:25.889Z
9257248 9257248 20260125123201_4JS25 KR003X 2026-01-26T14:04:25.859Z 2026-01-29T14:37:01.300Z
9256831 9256831 20260125103734_dYA19 KR003X 2026-01-26T14:02:10.803Z 2026-01-29T14:36:26.161Z
9254832 9254832 20260123214228_hQsz9 KR003X 2026-01-25T14:10:52.847Z 2026-01-29T14:46:44.534Z
9254686 9254686 20260123204510_WEqR4 KR003X 2026-01-25T14:10:21.802Z 2026-01-29T14:46:35.720Z
9254684 9254684 20260123204510_Ummui KR003X 2026-01-25T14:10:21.096Z 2026-01-29T14:46:35.556Z
9254634 9254634 20260123203338_3FHVp KR003X 2026-01-25T14:10:06.929Z 2026-01-29T14:46:33.133Z
9254603 9254603 20260123201937_443jn KR003X 2026-01-25T14:10:01.168Z 2026-01-29T14:46:31.852Z
9254533 9254533 20260123195742_eaDYq KR003X 2026-01-25T14:09:39.900Z 2026-01-29T14:46:28.847Z
9254528 9254528 20260123195554_cWhll KR003X 2026-01-25T14:09:38.372Z 2026-01-29T14:46:28.521Z
9254441 9254441 20260123191755_VyV4k KR003X 2026-01-25T14:09:09.045Z 2026-01-29T14:46:23.809Z
9254422 9254422 20260123191237_z62oX KR003X 2026-01-25T14:09:05.485Z 2026-01-29T14:46:15.165Z
9254326 9254326 20260123182107_NDX7f KR003X 2026-01-25T14:08:32.042Z 2026-01-29T14:46:07.467Z
9254181 9254181 20260123164055_8OvJZ KR003X 2026-01-25T14:07:41.620Z 2026-01-29T14:45:56.329Z
9251625 9251625 20260122213055_Fpxlt KR003X 2026-01-24T14:12:38.051Z 2026-01-29T14:51:55.715Z
9251584 9251584 20260122211405_LBlXd KR003X 2026-01-24T14:12:25.602Z 2026-01-29T14:51:50.724Z
9251437 9251437 20260122201341_ZOIrj KR003X 2026-01-24T14:11:44.177Z 2026-01-29T14:51:41.484Z
9251309 9251309 20260122193747_3atOv KR003X 2026-01-24T14:11:10.726Z 2026-01-29T14:51:27.666Z
9251216 9251216 20260122191144_opb5Q KR003X 2026-01-24T14:10:44.690Z 2026-01-29T14:51:20.272Z
9251115 9251115 20260122183051_CQy28 KR003X 2026-01-24T14:10:05.848Z 2026-01-29T14:51:11.091Z
9251041 9251041 20260122175235_AytOz KR003X 2026-01-24T14:09:33.290Z 2026-01-29T14:50:56.335Z
9251014 9251014 20260122174832_IYhcK KR003X 2026-01-24T14:09:27.017Z 2026-01-29T14:50:54.361Z
9250860 9250860 20260122161557_vc3ZG KR003X 2026-01-24T14:08:12.633Z 2026-01-29T14:50:40.046Z
9250828 9250828 20260122154446_YT3Zy KR003X 2026-01-24T14:07:47.305Z 2026-01-29T14:50:27.132Z
9250718 9250718 20260122132322_oNj30 KR003X 2026-01-24T14:06:03.930Z 2026-01-29T14:49:51.266Z
9250615 9250615 20260122105941_3aj1X KR003X 2026-01-24T14:04:15.992Z 2026-01-29T14:49:12.098Z
9250599 9250599 20260122103427_TYohr KR003X 2026-01-24T14:04:07.795Z 2026-01-29T14:49:04.307Z
9248085 9248085 20260121212941_fybLu KR003X 2026-01-23T14:11:52.022Z 2026-01-29T14:56:53.719Z
9248062 9248062 20260121212100_4cx76 KR003X 2026-01-23T14:11:48.942Z 2026-01-29T14:56:52.731Z
9247962 9247962 20260121204702_JeNfE KR003X 2026-01-23T14:11:37.564Z 2026-01-29T14:56:45.729Z

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