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

4,502 rows where station_code = "KR0039" 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
9271570 9271570 20260127180400_I64K3 KR0039 2026-01-29T14:21:34.109Z 2026-01-29T14:30:24.924Z
9271036 9271036 20260128192703_SH87Q KR0039 2026-01-29T14:15:00.785Z 2026-01-29T14:15:00.785Z
9271003 9271003 20260128191907_4UiwB KR0039 2026-01-29T14:14:50.496Z 2026-01-29T14:14:50.496Z
9270986 9270986 20260128190629_90Twm KR0039 2026-01-29T14:14:44.146Z 2026-01-29T14:14:44.146Z
9270959 9270959 20260128190351_bdwku KR0039 2026-01-29T14:14:40.607Z 2026-01-29T14:14:40.607Z
9270954 9270954 20260128185941_a8PXF KR0039 2026-01-29T14:14:40.132Z 2026-01-29T14:14:40.132Z
9270936 9270936 20260128185552_R1rC9 KR0039 2026-01-29T14:14:37.457Z 2026-01-29T14:14:37.457Z
9270819 9270819 20260128175344_5ygNP KR0039 2026-01-29T14:14:06.532Z 2026-01-29T14:14:06.532Z
9270726 9270726 20260128165353_02m3K KR0039 2026-01-29T14:13:32.911Z 2026-01-29T14:13:32.911Z
9270635 9270635 20260128161650_HgzQP KR0039 2026-01-29T14:13:04.735Z 2026-01-29T14:13:04.735Z
9270147 9270147 20260128150118_E8yy7 KR0039 2026-01-29T14:11:06.013Z 2026-01-29T14:11:06.013Z
9269928 9269928 20260128143221_StdAE KR0039 2026-01-29T14:10:14.583Z 2026-01-29T14:10:14.583Z
9269498 9269498 20260128132753_nj1fd KR0039 2026-01-29T14:08:17.383Z 2026-01-29T14:08:17.383Z
9267229 9267229 20260126205050_9YFCJ KR0039 2026-01-28T14:20:26.882Z 2026-01-29T14:34:36.062Z
9267206 9267206 20260126203140_GP3fZ KR0039 2026-01-28T14:20:18.544Z 2026-01-29T14:34:33.904Z
9267180 9267180 20260126201720_uG3Vv KR0039 2026-01-28T14:20:03.427Z 2026-01-29T14:34:28.981Z
9267090 9267090 20260126184945_l7uaD KR0039 2026-01-28T14:19:08.605Z 2026-01-29T14:34:15.938Z
9267087 9267087 20260126184931_fxgnZ KR0039 2026-01-28T14:19:07.067Z 2026-01-29T14:34:15.616Z
9267074 9267074 20260126184157_EFasm KR0039 2026-01-28T14:18:56.160Z 2026-01-29T14:34:13.485Z
9267011 9267011 20260126174752_0ogw2 KR0039 2026-01-28T14:18:16.032Z 2026-01-29T14:33:54.533Z
9267003 9267003 20260126174555_WvwDk KR0039 2026-01-28T14:18:13.644Z 2026-01-29T14:33:53.671Z
9266895 9266895 20260126155442_Lx3z2 KR0039 2026-01-28T14:17:19.303Z 2026-01-29T14:33:38.281Z
9266547 9266547 20260127194815_3zihL KR0039 2026-01-28T14:13:49.398Z 2026-01-29T14:30:25.086Z
9266535 9266535 20260127194506_miX23 KR0039 2026-01-28T14:13:47.777Z 2026-01-29T14:30:25.081Z
9266525 9266525 20260127194331_wIOU3 KR0039 2026-01-28T14:13:46.433Z 2026-01-29T14:30:25.068Z
9266520 9266520 20260127194058_3oSiC KR0039 2026-01-28T14:13:45.730Z 2026-01-29T14:30:25.066Z
9266345 9266345 20260127185752_18Ao3 KR0039 2026-01-28T14:13:16.225Z 2026-01-28T14:13:16.225Z
9266332 9266332 20260127185440_wRR2t KR0039 2026-01-28T14:13:14.562Z 2026-01-29T14:30:24.997Z
9266326 9266326 20260127185439_4UODp KR0039 2026-01-28T14:13:14.086Z 2026-01-29T14:30:24.996Z
9266303 9266303 20260127184643_dlBz2 KR0039 2026-01-28T14:13:11.807Z 2026-01-29T14:30:24.985Z
9266296 9266296 20260127184621_3Cap6 KR0039 2026-01-28T14:13:11.286Z 2026-01-29T14:30:24.984Z
9266290 9266290 20260127184608_KlEyk KR0039 2026-01-28T14:13:10.743Z 2026-01-29T14:30:24.979Z
9266224 9266224 20260127181703_kZbst KR0039 2026-01-28T14:12:54.611Z 2026-01-29T14:30:24.941Z
9266219 9266219 20260127180825_Chgdp KR0039 2026-01-28T14:12:53.540Z 2026-01-29T14:30:24.927Z
9266211 9266211 20260127180400_lNzd3 KR0039 2026-01-28T14:12:50.774Z 2026-01-28T14:12:50.774Z
9266123 9266123 20260127172733_3ile0 KR0039 2026-01-28T14:12:29.348Z 2026-01-29T14:30:24.886Z
9266098 9266098 20260127172055_giEd9 KR0039 2026-01-28T14:12:25.447Z 2026-01-29T14:30:24.869Z
9266085 9266085 20260127171303_TUfDT KR0039 2026-01-28T14:12:22.694Z 2026-01-29T14:30:24.849Z
9265961 9265961 20260127161943_B3D6V KR0039 2026-01-28T14:11:52.052Z 2026-01-29T14:30:24.787Z
9265959 9265959 20260127161846_jShLF KR0039 2026-01-28T14:11:51.497Z 2026-01-29T14:30:24.786Z
9264738 9264738 20260127130357_OsgXT KR0039 2026-01-28T14:07:25.750Z 2026-01-29T14:30:24.266Z
9264565 9264565 20260127124604_NqjE3 KR0039 2026-01-28T14:06:41.527Z 2026-01-29T14:30:24.220Z
9258260 9258260 20260125202227_CFZJg KR0039 2026-01-26T14:10:16.077Z 2026-01-29T14:38:20.306Z
9258105 9258105 20260125184130_g3EJN KR0039 2026-01-26T14:09:36.687Z 2026-01-29T14:38:03.269Z
9258099 9258099 20260125183643_QLKcA KR0039 2026-01-26T14:09:35.206Z 2026-01-29T14:38:02.814Z
9258095 9258095 20260125183614_pQYPX KR0039 2026-01-26T14:09:34.542Z 2026-01-26T14:09:34.542Z
9258046 9258046 20260125181637_3dWlT KR0039 2026-01-26T14:09:14.473Z 2026-01-29T14:37:59.825Z
9258028 9258028 20260125180758_E7MOf KR0039 2026-01-26T14:09:11.598Z 2026-01-26T14:09:11.598Z
9257978 9257978 20260125173828_XbbpK KR0039 2026-01-26T14:08:52.101Z 2026-01-26T14:08:52.101Z
9257956 9257956 20260125172910_1bbir KR0039 2026-01-26T14:08:46.787Z 2026-01-29T14:37:55.086Z
9257905 9257905 20260125170614_6WVm5 KR0039 2026-01-26T14:08:30.890Z 2026-01-29T14:37:52.564Z
9257899 9257899 20260125170443_Cy3Mh KR0039 2026-01-26T14:08:30.161Z 2026-01-29T14:37:52.185Z
9257862 9257862 20260125162942_3mruR KR0039 2026-01-26T14:08:12.653Z 2026-01-29T14:37:45.434Z
9257848 9257848 20260125162116_pymmr KR0039 2026-01-26T14:08:08.834Z 2026-01-29T14:37:44.634Z
9257291 9257291 20260125124207_YxEh3 KR0039 2026-01-26T14:04:36.220Z 2026-01-29T14:37:04.021Z
9256799 9256799 20260125103311_F77lG KR0039 2026-01-26T14:02:05.018Z 2026-01-29T14:36:24.827Z
9250984 9250984 20260122174117_4vimU KR0039 2026-01-24T14:09:13.857Z 2026-01-29T14:50:51.127Z
9250969 9250969 20260122173656_GcuJd KR0039 2026-01-24T14:09:10.612Z 2026-01-29T14:50:50.590Z
9250953 9250953 20260122173057_xQZUR KR0039 2026-01-24T14:09:04.142Z 2026-01-29T14:50:49.275Z
9250940 9250940 20260122171930_8S8Qc KR0039 2026-01-24T14:08:53.375Z 2026-01-29T14:50:47.427Z
9250862 9250862 20260122161612_LRW6c KR0039 2026-01-24T14:08:14.188Z 2026-01-29T14:50:40.326Z
9250721 9250721 20260122132701_PGt3D KR0039 2026-01-24T14:06:06.946Z 2026-01-29T14:49:51.802Z
9250707 9250707 20260122125517_Q9BWc KR0039 2026-01-24T14:05:41.999Z 2026-01-29T14:49:45.520Z
9250671 9250671 20260122121321_hryxl KR0039 2026-01-24T14:05:09.841Z 2026-01-29T14:49:30.621Z
9250665 9250665 20260122121321_YzviZ KR0039 2026-01-24T14:05:09.147Z 2026-01-29T14:49:30.387Z
9250656 9250656 20260122120116_oYfjN KR0039 2026-01-24T14:05:03.020Z 2026-01-29T14:49:28.360Z
9247622 9247622 20260121191747_qCDd0 KR0039 2026-01-23T14:10:36.898Z 2026-01-29T14:56:20.105Z
9247577 9247577 20260121190410_kEWi3 KR0039 2026-01-23T14:10:30.003Z 2026-01-29T14:56:15.233Z
9247396 9247396 20260121182508_gfL6w KR0039 2026-01-23T14:09:58.936Z 2026-01-29T14:56:07.058Z
9247210 9247210 20260121173610_2SSjn KR0039 2026-01-23T14:09:24.864Z 2026-01-29T14:55:49.930Z
9247120 9247120 20260121170836_3WvgJ KR0039 2026-01-23T14:09:04.744Z 2026-01-29T14:55:43.584Z
9246998 9246998 20260121161028_e6lxj KR0039 2026-01-23T14:08:43.648Z 2026-01-29T14:55:37.111Z
9246934 9246934 20260121154037_ApOvh KR0039 2026-01-23T14:08:31.355Z 2026-01-29T14:55:20.962Z
9246922 9246922 20260121153728_9OLKO KR0039 2026-01-23T14:08:29.386Z 2026-01-29T14:55:20.309Z
9246857 9246857 20260121150410_69eA4 KR0039 2026-01-23T14:08:08.160Z 2026-01-29T14:55:14.863Z
9246747 9246747 20260121141502_m07q0 KR0039 2026-01-23T14:07:52.167Z 2026-01-29T14:55:09.162Z
9246719 9246719 20260121135615_pV3LS KR0039 2026-01-23T14:07:42.504Z 2026-01-29T14:55:07.052Z
9246717 9246717 20260121135614_WBOaU KR0039 2026-01-23T14:07:42.151Z 2026-01-29T14:55:06.860Z
9246565 9246565 20260121122123_W8t4A KR0039 2026-01-23T14:07:04.392Z 2026-01-29T14:54:41.282Z
9246550 9246550 20260121120954_UKfsB KR0039 2026-01-23T14:07:00.468Z 2026-01-29T14:54:38.984Z
9246534 9246534 20260121113503_6Uw3R KR0039 2026-01-23T14:06:53.885Z 2026-01-29T14:54:34.402Z
9246518 9246518 20260121105651_h13KJ KR0039 2026-01-23T14:06:37.342Z 2026-01-29T14:54:20.036Z
9241694 9241694 20260120213446_GmO0V KR0039 2026-01-22T14:14:09.419Z 2026-01-29T15:02:57.238Z
9241247 9241247 20260120194110_7bbYu KR0039 2026-01-22T14:12:17.167Z 2026-01-29T15:02:28.749Z
9240808 9240808 20260120175324_C6EMK KR0039 2026-01-22T14:10:12.170Z 2026-01-29T15:01:55.963Z
9240750 9240750 20260120173839_TYWch KR0039 2026-01-22T14:09:49.731Z 2026-01-29T15:01:52.991Z
9240682 9240682 20260120172347_itwIV KR0039 2026-01-22T14:09:34.584Z 2026-01-29T15:01:38.343Z
9240655 9240655 20260120171537_ttiEK KR0039 2026-01-22T14:09:20.852Z 2026-01-29T15:01:36.899Z
9240603 9240603 20260120165714_mOHok KR0039 2026-01-22T14:09:07.812Z 2026-01-29T15:01:34.095Z
9240567 9240567 20260120164826_hy59i KR0039 2026-01-22T14:09:01.893Z 2026-01-29T15:01:30.825Z
9240537 9240537 20260120164300_Tj5vg KR0039 2026-01-22T14:08:48.152Z 2026-01-29T15:01:29.893Z
9240480 9240480 20260120162343_Y5m7z KR0039 2026-01-22T14:08:34.676Z 2026-01-29T15:01:27.214Z
9240438 9240438 20260120160643_3xy6L KR0039 2026-01-22T14:08:25.482Z 2026-01-29T15:01:24.399Z
9240339 9240339 20260120152134_EUh3w KR0039 2026-01-22T14:07:53.003Z 2026-01-29T15:01:17.834Z
9240193 9240193 20260120131305_o3Fgv KR0039 2026-01-22T14:06:36.331Z 2026-01-29T15:00:42.989Z
9240189 9240189 20260120131305_sxtn3 KR0039 2026-01-22T14:06:35.927Z 2026-01-29T15:00:42.098Z
9240175 9240175 20260120125821_RGVlY KR0039 2026-01-22T14:06:26.064Z 2026-01-29T15:00:32.307Z
9240132 9240132 20260120123218_SVncu KR0039 2026-01-22T14:05:59.872Z 2026-01-29T15:00:17.097Z
9240091 9240091 20260120121341_H5GJ8 KR0039 2026-01-22T14:05:38.692Z 2026-01-29T14:59:59.905Z
9240083 9240083 20260120121340_61AMH KR0039 2026-01-22T14:05:38.411Z 2026-01-29T14:59:59.744Z

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