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

1,818 rows where station_code = "KR002N" 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
8663443 8663443 20251130204749_8ZMRJ KR002N 2025-12-02T14:18:17.988Z 2025-12-06T14:40:00.792Z
8663416 8663416 20251130204403_rcjNe KR002N 2025-12-02T14:18:15.577Z 2025-12-06T14:40:00.323Z
8663399 8663399 20251130204254_h74rH KR002N 2025-12-02T14:18:14.283Z 2025-12-06T14:40:00.142Z
8663355 8663355 20251130203727_RpaGv KR002N 2025-12-02T14:18:02.232Z 2025-12-06T14:39:58.868Z
8663303 8663303 20251130202841_PcngH KR002N 2025-12-02T14:17:57.246Z 2025-12-06T14:39:57.704Z
8663172 8663172 20251130201748_ljGlA KR002N 2025-12-02T14:17:34.567Z 2025-12-06T14:39:54.949Z
8663077 8663077 20251130200609_vjTfm KR002N 2025-12-02T14:17:24.521Z 2025-12-06T14:39:48.467Z
8663039 8663039 20251130195939_JNglA KR002N 2025-12-02T14:17:19.527Z 2025-12-06T14:39:42.558Z
8662668 8662668 20251130191901_83zrY KR002N 2025-12-02T14:16:16.790Z 2025-12-06T14:39:25.720Z
8662618 8662618 20251130191508_Q2wBJ KR002N 2025-12-02T14:16:01.869Z 2025-12-06T14:39:24.173Z
8662587 8662587 20251130191159_nF4ZS KR002N 2025-12-02T14:15:56.488Z 2025-12-06T14:39:22.890Z
8662577 8662577 20251130191135_7yzZT KR002N 2025-12-02T14:15:55.460Z 2025-12-06T14:39:22.778Z
8644629 8644629 20251128193823_e3XDz KR002N 2025-11-30T14:22:10.326Z 2025-12-06T14:54:45.313Z
8644577 8644577 20251128193413_Itfji KR002N 2025-11-30T14:22:06.846Z 2025-12-06T14:54:44.623Z
8644334 8644334 20251128192036_K5pWt KR002N 2025-11-30T14:21:39.746Z 2025-12-06T14:54:40.925Z
8644167 8644167 20251128190407_J212A KR002N 2025-11-30T14:21:25.807Z 2025-12-06T14:54:38.945Z
8642755 8642755 20251128164454_J3e3a KR002N 2025-11-30T14:18:34.269Z 2025-12-06T14:53:35.900Z
8642392 8642392 20251128160033_HRzzm KR002N 2025-11-30T14:17:51.618Z 2025-12-06T14:53:31.114Z
8641803 8641803 20251128151431_mNmzT KR002N 2025-11-30T14:17:01.637Z 2025-12-06T14:52:55.576Z
8630080 8630080 20251127140640_KJSys KR002N 2025-11-29T14:11:31.416Z 2025-12-06T14:58:54.768Z
8620372 8620372 20251126122333_facqS KR002N 2025-11-28T14:12:34.190Z 2025-12-05T15:01:57.097Z
8620237 8620237 20251126120038_wQaTM KR002N 2025-11-28T14:12:03.488Z 2025-12-05T15:01:33.684Z
8620188 8620188 20251126115828_FbbUN KR002N 2025-11-28T14:11:59.092Z 2025-12-05T15:01:32.941Z
8620114 8620114 20251126114839_ks5cn KR002N 2025-11-28T14:11:40.352Z 2025-12-05T15:01:28.713Z
8619799 8619799 20251126110051_0Ba2I KR002N 2025-11-28T14:10:28.059Z 2025-12-05T15:01:09.363Z
8548504 8548504 20251120205839_Es9DH KR002N 2025-11-22T14:17:01.311Z 2025-11-29T14:54:22.771Z
8548272 8548272 20251120204723_Qvwa3 KR002N 2025-11-22T14:16:41.019Z 2025-11-29T14:54:22.282Z
8548133 8548133 20251120203817_TuHcS KR002N 2025-11-22T14:16:20.770Z 2025-11-29T14:54:22.022Z
8547992 8547992 20251120202803_bY9Tq KR002N 2025-11-22T14:16:09.333Z 2025-11-29T14:54:21.616Z
8547965 8547965 20251120202507_YBLcu KR002N 2025-11-22T14:16:01.572Z 2025-11-29T14:54:21.468Z
8547901 8547901 20251120202127_IzLt3 KR002N 2025-11-22T14:15:53.761Z 2025-11-29T14:54:21.250Z
8547818 8547818 20251120201556_SpcSe KR002N 2025-11-22T14:15:45.293Z 2025-11-29T14:54:21.047Z
8547782 8547782 20251120201159_jLAXc KR002N 2025-11-22T14:15:42.206Z 2025-11-29T14:54:20.984Z
8547738 8547738 20251120201035_ugCuf KR002N 2025-11-22T14:15:39.752Z 2025-11-29T14:54:20.926Z
8547017 8547017 20251120191642_NWnI3 KR002N 2025-11-22T14:14:02.426Z 2025-11-29T14:54:18.338Z
8546892 8546892 20251120190614_XVpD6 KR002N 2025-11-22T14:13:49.296Z 2025-11-29T14:54:17.978Z
8546843 8546843 20251120190019_DaEsG KR002N 2025-11-22T14:13:44.945Z 2025-11-29T14:54:17.856Z
8546830 8546830 20251120185816_V0nHq KR002N 2025-11-22T14:13:43.416Z 2025-11-29T14:54:17.702Z
8546720 8546720 20251120185107_cdSxk KR002N 2025-11-22T14:13:23.841Z 2025-11-29T14:54:17.426Z
8546272 8546272 20251120181322_fNTQS KR002N 2025-11-22T14:12:17.716Z 2025-11-29T14:54:10.213Z
8546236 8546236 20251120180737_80u40 KR002N 2025-11-22T14:12:11.451Z 2025-11-29T14:54:10.073Z
8546098 8546098 20251120175524_yDkm3 KR002N 2025-11-22T14:11:58.855Z 2025-11-29T14:54:09.135Z
8545878 8545878 20251120173753_wva4G KR002N 2025-11-22T14:11:29.249Z 2025-11-29T14:54:06.530Z
8545819 8545819 20251120173323_pTcLp KR002N 2025-11-22T14:11:23.747Z 2025-11-29T14:54:06.359Z
8545522 8545522 20251120165948_acjoN KR002N 2025-11-22T14:10:43.317Z 2025-11-29T14:54:03.552Z
8545488 8545488 20251120165519_QVZRq KR002N 2025-11-22T14:10:35.627Z 2025-11-29T14:54:03.494Z
8545332 8545332 20251120164218_Pnn82 KR002N 2025-11-22T14:10:20.317Z 2025-11-29T14:54:02.451Z
8545153 8545153 20251120161654_qrkUw KR002N 2025-11-22T14:09:51.795Z 2025-11-29T14:54:00.839Z
8544923 8544923 20251120154646_nQLFg KR002N 2025-11-22T14:09:15.885Z 2025-11-29T14:53:56.839Z
8544870 8544870 20251120154152_PZtXt KR002N 2025-11-22T14:09:09.504Z 2025-11-29T14:53:56.580Z
8544660 8544660 20251120152535_72eJB KR002N 2025-11-22T14:08:34.364Z 2025-11-29T14:53:49.389Z
8543579 8543579 20251120140514_wTkmU KR002N 2025-11-22T14:05:32.018Z 2025-11-29T14:53:26.915Z
8543477 8543477 20251120135831_lobFB KR002N 2025-11-22T14:05:20.328Z 2025-11-29T14:53:26.132Z
8530550 8530550 20251119121930_BaNKh KR002N 2025-11-21T14:01:58.233Z 2025-11-28T14:53:15.552Z
8489564 8489564 20251116170149_5Essm KR002N 2025-11-18T14:10:36.041Z 2025-11-25T15:07:31.968Z
8473909 8473909 20251115123626_jGmF1 KR002N 2025-11-17T14:03:19.972Z 2025-11-24T15:02:52.539Z
8473047 8473047 20251115115416_sLjgI KR002N 2025-11-17T14:01:01.073Z 2025-11-24T15:02:27.752Z
8472524 8472524 20251114114257_vAWfO KR002N 2025-11-16T14:33:56.785Z 2025-11-22T15:24:22.731Z
8472408 8472408 20251114112642_P53h9 KR002N 2025-11-16T14:33:30.442Z 2025-11-22T15:24:16.340Z
8472232 8472232 20251114110326_XG4LK KR002N 2025-11-16T14:33:07.733Z 2025-11-22T15:24:07.260Z
8472199 8472199 20251114105904_3nOvX KR002N 2025-11-16T14:33:05.304Z 2025-11-22T15:24:05.926Z
8472169 8472169 20251114105610_rpqkW KR002N 2025-11-16T14:33:03.993Z 2025-11-22T15:24:04.510Z
8472112 8472112 20251114105010_dzEje KR002N 2025-11-16T14:33:00.905Z 2025-11-22T15:24:01.894Z
8466669 8466669 20251114185020_sWFlg KR002N 2025-11-16T14:12:39.419Z 2025-11-23T15:17:04.248Z
8466462 8466462 20251114182825_VUvbt KR002N 2025-11-16T14:12:05.085Z 2025-11-23T15:17:02.739Z
8466449 8466449 20251114182824_c1haI KR002N 2025-11-16T14:12:04.858Z 2025-11-23T15:17:02.721Z
8466405 8466405 20251114182701_artmf KR002N 2025-11-16T14:12:00.641Z 2025-11-23T15:17:02.680Z
8466388 8466388 20251114182632_dhJIx KR002N 2025-11-16T14:11:59.709Z 2025-11-23T15:17:02.650Z
8466272 8466272 20251114181246_B773R KR002N 2025-11-16T14:11:42.794Z 2025-11-23T15:17:01.870Z
8465962 8465962 20251114173450_0x386 KR002N 2025-11-16T14:10:45.865Z 2025-11-23T15:16:59.825Z
8465643 8465643 20251114165538_V8KJH KR002N 2025-11-16T14:09:48.306Z 2025-11-23T15:16:57.471Z
8465623 8465623 20251114165314_tnVTg KR002N 2025-11-16T14:09:45.294Z 2025-11-23T15:16:57.290Z
8465377 8465377 20251114162823_B1xyJ KR002N 2025-11-16T14:09:10.123Z 2025-11-23T15:16:54.807Z
8465368 8465368 20251114162711_JjQNc KR002N 2025-11-16T14:09:09.376Z 2025-11-23T15:16:54.790Z
8465353 8465353 20251114162454_YM4UE KR002N 2025-11-16T14:09:08.610Z 2025-11-23T15:16:54.565Z
8465205 8465205 20251114160443_YDXSr KR002N 2025-11-16T14:08:35.665Z 2025-11-23T15:16:49.983Z
8464847 8464847 20251114152510_YM1Mp KR002N 2025-11-16T14:07:29.293Z 2025-11-23T15:16:32.234Z
8464794 8464794 20251114152134_2cHSW KR002N 2025-11-16T14:07:24.001Z 2025-11-23T15:16:31.821Z
8464568 8464568 20251114150544_Wy4gd KR002N 2025-11-16T14:06:42.487Z 2025-11-23T15:16:22.662Z
8464147 8464147 20251114141906_k6g0T KR002N 2025-11-16T14:05:18.300Z 2025-11-23T15:16:11.318Z
8464123 8464123 20251114141648_bnsD0 KR002N 2025-11-16T14:05:15.610Z 2025-11-23T15:16:10.325Z
8464100 8464100 20251114141541_W1n13 KR002N 2025-11-16T14:05:14.482Z 2025-11-23T15:16:10.010Z
8463452 8463452 20251114130857_qfAT6 KR002N 2025-11-16T14:03:17.976Z 2025-11-23T15:15:53.246Z
8463099 8463099 20251114122759_p9aPh KR002N 2025-11-16T14:01:50.756Z 2025-11-23T15:15:42.370Z
8463015 8463015 20251114122126_PDISz KR002N 2025-11-16T14:01:34.496Z 2025-11-23T15:15:39.736Z
8457564 8457564 20251113204447_YiJ70 KR002N 2025-11-15T14:13:49.197Z 2025-11-22T15:20:52.339Z
8457513 8457513 20251113203612_aiVHE KR002N 2025-11-15T14:13:42.850Z 2025-11-22T15:20:52.014Z
8457412 8457412 20251113202612_PLmln KR002N 2025-11-15T14:13:30.976Z 2025-11-22T15:20:51.256Z
8457377 8457377 20251113202132_frmgh KR002N 2025-11-15T14:13:19.447Z 2025-11-22T15:20:51.006Z
8457288 8457288 20251113201313_u4AfQ KR002N 2025-11-15T14:13:11.187Z 2025-11-22T15:20:50.519Z
8457274 8457274 20251113201213_94ZsT KR002N 2025-11-15T14:13:10.099Z 2025-11-22T15:20:50.441Z
8457182 8457182 20251113195842_QYbVE KR002N 2025-11-15T14:13:00.565Z 2025-11-22T15:20:49.720Z
8457165 8457165 20251113195824_2qWAE KR002N 2025-11-15T14:12:59.805Z 2025-11-22T15:20:49.682Z
8457128 8457128 20251113195419_t5RyQ KR002N 2025-11-15T14:12:55.550Z 2025-11-22T15:20:49.388Z
8457105 8457105 20251113195203_r1TAb KR002N 2025-11-15T14:12:45.188Z 2025-11-22T15:20:49.154Z
8456916 8456916 20251113193035_PnBVS KR002N 2025-11-15T14:12:25.962Z 2025-11-22T15:20:47.500Z
8456834 8456834 20251113192126_sHgbx KR002N 2025-11-15T14:12:10.224Z 2025-11-22T15:20:46.559Z
8456821 8456821 20251113192016_7XOHF KR002N 2025-11-15T14:12:09.400Z 2025-11-22T15:20:46.526Z
8456703 8456703 20251113191411_U0Oir KR002N 2025-11-15T14:11:57.286Z 2025-11-22T15:20:45.867Z
8456461 8456461 20251113184547_plWXs KR002N 2025-11-15T14:11:20.479Z 2025-11-22T15:20:44.404Z

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