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,792 rows where station_code = "KR003A" 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
9271046 9271046 20260128192739_T9f6p KR003A 2026-01-29T14:15:01.930Z 2026-01-29T14:15:01.930Z
9270824 9270824 20260128175610_ruyos KR003A 2026-01-29T14:14:07.224Z 2026-01-29T14:14:07.224Z
9270774 9270774 20260128173723_ZGbu5 KR003A 2026-01-29T14:13:51.944Z 2026-01-29T14:13:51.944Z
9267234 9267234 20260126210325_LCxxj KR003A 2026-01-28T14:20:29.128Z 2026-01-29T14:34:36.884Z
9267102 9267102 20260126185746_9YA7b KR003A 2026-01-28T14:19:13.555Z 2026-01-29T14:34:17.291Z
9257515 9257515 20260125141439_LZt7S KR003A 2026-01-26T14:06:03.257Z 2026-01-29T14:37:24.558Z
9250824 9250824 20260122154446_YT3Zy KR003A 2026-01-24T14:07:47.305Z 2026-01-29T14:50:27.132Z
9247481 9247481 20260121184231_t631s KR003A 2026-01-23T14:10:09.995Z 2026-01-29T14:56:11.102Z
9246760 9246760 20260121141902_p3w9C KR003A 2026-01-23T14:07:54.247Z 2026-01-29T14:55:09.836Z
9246511 9246511 20260121104527_6AP4s KR003A 2026-01-23T14:06:33.299Z 2026-01-29T14:54:15.342Z
9218006 9218006 20260116214241_VT8Hl KR003A 2026-01-18T14:09:56.030Z 2026-01-25T14:57:54.819Z
9217881 9217881 20260116201835_g1Uej KR003A 2026-01-18T14:09:26.782Z 2026-01-25T14:57:50.589Z
9217860 9217860 20260116201203_yvfka KR003A 2026-01-18T14:09:19.516Z 2026-01-25T14:57:49.928Z
9217705 9217705 20260116191447_PycNo KR003A 2026-01-18T14:08:36.916Z 2026-01-25T14:57:44.975Z
9217580 9217580 20260116180935_BDkHh KR003A 2026-01-18T14:08:03.577Z 2026-01-25T14:57:27.051Z
9212044 9212044 20260115185245_Lo029 KR003A 2026-01-17T14:09:41.190Z 2026-01-24T15:10:20.762Z
9211894 9211894 20260115181652_6AK1y KR003A 2026-01-17T14:08:56.643Z 2026-01-24T15:10:09.074Z
9211824 9211824 20260115175654_59i4D KR003A 2026-01-17T14:08:39.341Z 2026-01-24T15:09:57.381Z
9211382 9211382 20260115150606_QH4Fd KR003A 2026-01-17T14:06:23.321Z 2026-01-24T15:09:11.424Z
9211354 9211354 20260115145651_yrZS0 KR003A 2026-01-17T14:06:13.207Z 2026-01-24T15:09:09.523Z
9197766 9197766 20260113122856_luVxQ KR003A 2026-01-14T14:24:19.696Z 2026-01-21T15:06:24.028Z
9194660 9194660 20260112214318_a0JRe KR003A 2026-01-14T14:10:12.222Z 2026-01-21T15:04:19.700Z
9193544 9193544 20260113160631_Wx6HE KR003A 2026-01-14T14:02:06.443Z 2026-01-22T15:06:25.416Z
9188090 9188090 20260111202327_CqDlq KR003A 2026-01-13T14:10:25.964Z 2026-01-20T15:21:12.203Z
9188044 9188044 20260111200601_LKmo5 KR003A 2026-01-13T14:10:09.311Z 2026-01-20T15:21:09.469Z
9188003 9188003 20260111195555_h6XZd KR003A 2026-01-13T14:09:57.118Z 2026-01-20T15:21:05.973Z
9187590 9187590 20260111174942_1ZBlq KR003A 2026-01-13T14:07:56.170Z 2026-01-20T15:20:34.386Z
9187404 9187404 20260111165425_6drt3 KR003A 2026-01-13T14:07:06.598Z 2026-01-20T15:20:26.777Z
9170916 9170916 20260108173710_p4rTR KR003A 2026-01-10T14:04:04.335Z 2026-01-17T15:23:11.093Z
9170650 9170650 20260108153408_Hy4Qa KR003A 2026-01-10T14:02:07.822Z 2026-01-17T15:22:41.071Z
9170091 9170091 20260108141818_3asWJ KR003A 2026-01-09T14:15:42.349Z 2026-01-16T15:13:53.948Z
9170080 9170080 20260108141738_B5OOk KR003A 2026-01-09T14:15:41.451Z 2026-01-16T15:13:53.391Z
9169909 9169909 20260108123000_vaAqp KR003A 2026-01-09T14:15:14.793Z 2026-01-16T15:13:16.615Z
9169722 9169722 20260108093124_Yt34a KR003A 2026-01-09T14:14:29.524Z 2026-01-16T15:12:15.671Z
9166961 9166961 20260107211507_hxNPc KR003A 2026-01-09T14:05:38.661Z 2026-01-16T15:10:32.124Z
9166790 9166790 20260107202353_ZjB0a KR003A 2026-01-09T14:04:54.781Z 2026-01-16T15:10:24.105Z
9166753 9166753 20260107201124_Ixm2V KR003A 2026-01-09T14:04:46.304Z 2026-01-16T15:10:22.186Z
9166696 9166696 20260107195411_REkyj KR003A 2026-01-09T14:04:27.540Z 2026-01-16T15:10:19.333Z
9166566 9166566 20260107191937_kFti2 KR003A 2026-01-09T14:03:51.922Z 2026-01-16T15:10:02.464Z
9166314 9166314 20260107174508_2vyES KR003A 2026-01-09T14:02:38.670Z 2026-01-16T15:09:39.795Z
9166078 9166078 20260107160437_7Pf4k KR003A 2026-01-09T14:01:18.767Z 2026-01-16T15:09:20.936Z
9165799 9165799 20260105211055_9LeMs KR003A 2026-01-08T14:19:59.362Z 2026-01-13T15:07:12.768Z
9165654 9165654 20260107140743_nnktP KR003A 2026-01-08T14:17:31.882Z 2026-01-13T15:04:58.790Z
9152312 9152312 20260105104531_yn4WM KR003A 2026-01-06T14:16:41.253Z 2026-01-13T15:15:44.174Z
9152290 9152290 20260105103949_k0bn3 KR003A 2026-01-06T14:16:37.203Z 2026-01-13T15:15:42.797Z
9152110 9152110 20260105092629_NXU7r KR003A 2026-01-06T14:15:49.574Z 2026-01-13T15:15:30.743Z
9148718 9148718 20260105211055_flm9V KR003A 2026-01-06T14:01:55.780Z 2026-01-07T14:17:58.225Z
9148666 9148666 20260105201723_JtecD KR003A 2026-01-06T14:01:37.138Z 2026-01-13T15:06:57.067Z
9125855 9125855 20251231190316_p6IhN KR003A 2026-01-02T14:56:16.106Z 2026-01-08T15:16:11.336Z
9125188 9125188 20251231170147_zOlH3 KR003A 2026-01-02T14:54:25.686Z 2026-01-08T15:15:17.061Z
9124822 9124822 20251231150429_V2hz4 KR003A 2026-01-02T14:52:53.558Z 2026-01-08T15:14:37.982Z
9123149 9123149 20260101182731_Vb9BO KR003A 2026-01-02T14:16:57.805Z 2026-01-09T14:54:29.283Z
9121391 9121391 20251231214621_F67PC KR003A 2026-01-02T14:07:06.285Z 2026-01-09T14:51:57.863Z
9121283 9121283 20251231212254_XcNmh KR003A 2026-01-02T14:06:35.701Z 2026-01-09T14:51:52.103Z
9121277 9121277 20251231212254_udwUn KR003A 2026-01-02T14:06:34.718Z 2026-01-09T14:51:52.010Z
9121221 9121221 20251231210531_5i4im KR003A 2026-01-02T14:06:16.132Z 2026-01-09T14:51:49.651Z
9121194 9121194 20251231210259_z1eYq KR003A 2026-01-02T14:06:11.110Z 2026-01-09T14:51:48.896Z
9120977 9120977 20251231201642_skZ3Y KR003A 2026-01-02T14:05:17.791Z 2026-01-09T14:51:41.412Z
9120968 9120968 20251231201509_oZi6H KR003A 2026-01-02T14:05:15.699Z 2026-01-09T14:51:38.841Z
9120902 9120902 20251231200142_fhimJ KR003A 2026-01-02T14:04:52.548Z 2026-01-09T14:51:29.935Z
9120887 9120887 20251231195739_oz9ii KR003A 2026-01-02T14:04:43.541Z 2026-01-09T14:51:29.105Z
9120823 9120823 20251231194347_pATpV KR003A 2026-01-02T14:04:25.448Z 2026-01-09T14:51:25.171Z
9120529 9120529 20260101213949_vsInZ KR003A 2026-01-02T14:02:53.816Z 2026-01-09T14:48:46.011Z
9120474 9120474 20260101210818_fh1z3 KR003A 2026-01-02T14:02:35.753Z 2026-01-09T14:48:42.331Z
9120462 9120462 20260101210647_AABwt KR003A 2026-01-02T14:02:33.747Z 2026-01-09T14:48:38.999Z
9120020 9120020 20251229190656_nGI4p KR003A 2026-01-01T15:19:08.993Z 2026-01-06T15:21:38.767Z
9120013 9120013 20251229185053_Tg1FC KR003A 2026-01-01T15:18:49.863Z 2026-01-06T15:21:35.434Z
9119962 9119962 20251229163448_NgCin KR003A 2026-01-01T15:17:17.250Z 2026-01-06T15:20:53.758Z
9108662 9108662 20251229191902_LtFW6 KR003A 2025-12-31T14:44:07.315Z 2026-01-06T15:21:43.456Z
9108565 9108565 20251229190656_iYPmM KR003A 2025-12-31T14:43:56.065Z 2026-01-06T15:21:38.850Z
9108449 9108449 20251229185053_TcaL3 KR003A 2025-12-31T14:43:36.497Z 2026-01-06T15:21:35.569Z
9107903 9107903 20251229172958_jzEP1 KR003A 2025-12-31T14:42:17.928Z 2026-01-06T15:21:04.911Z
9107864 9107864 20251229172644_68WQy KR003A 2025-12-31T14:42:13.226Z 2026-01-06T15:21:03.760Z
9107764 9107764 20251229171046_JlOVH KR003A 2025-12-31T14:41:51.598Z 2026-01-06T15:20:59.398Z
9107332 9107332 20251229152204_tHViJ KR003A 2025-12-31T14:40:35.845Z 2026-01-06T15:20:27.847Z
9106753 9106753 20251230191935_7oqK8 KR003A 2025-12-31T14:29:39.776Z 2026-01-07T15:13:24.081Z
9106662 9106662 20251230184357_EbUvW KR003A 2025-12-31T14:29:24.026Z 2026-01-07T15:13:11.714Z
9106592 9106592 20251230182227_j7bwb KR003A 2025-12-31T14:29:15.273Z 2026-01-07T15:12:53.681Z
9106137 9106137 20251230154543_0Q99B KR003A 2025-12-31T14:27:48.791Z 2026-01-07T15:11:48.135Z
9106094 9106094 20251230152807_3RFnG KR003A 2025-12-31T14:27:40.877Z 2026-01-07T15:11:45.343Z
9100829 9100829 20251229212047_Anjnu KR003A 2025-12-31T14:04:56.968Z 2026-01-07T15:05:40.347Z
9100597 9100597 20251229204810_lzlVb KR003A 2025-12-31T14:03:48.838Z 2026-01-07T15:05:24.888Z
9100556 9100556 20251229203253_qj3Oh KR003A 2025-12-31T14:03:35.651Z 2025-12-31T14:29:49.622Z
9100371 9100371 20251230213113_sP3GJ KR003A 2025-12-31T14:02:22.838Z 2026-01-08T15:04:47.965Z
9100175 9100175 20251230200821_p5ni3 KR003A 2025-12-31T14:01:22.436Z 2026-01-01T14:57:48.341Z
9100148 9100148 20251230200018_d4Wlj KR003A 2025-12-31T14:01:10.563Z 2026-01-08T15:04:04.502Z
9100135 9100135 20251230195751_mtdjR KR003A 2025-12-31T14:01:04.919Z 2026-01-08T15:04:03.488Z
9100076 9100076 20251230194642_Zz1vM KR003A 2025-12-31T14:00:45.353Z 2026-01-08T15:03:55.106Z
9075150 9075150 20251225211030_Hdv5F KR003A 2025-12-29T15:01:30.803Z 2026-01-02T15:48:45.499Z
9075145 9075145 20251225211023_8YsOW KR003A 2025-12-29T15:01:30.616Z 2026-01-02T15:48:45.125Z
9075074 9075074 20251225210428_qGIwd KR003A 2025-12-29T15:01:28.410Z 2026-01-02T15:48:43.817Z
9075021 9075021 20251225205627_v13d0 KR003A 2025-12-29T15:01:26.268Z 2026-01-02T15:48:42.609Z
9074874 9074874 20251225204127_BDVR4 KR003A 2025-12-29T15:01:22.125Z 2026-01-02T15:48:39.738Z
9074531 9074531 20251225201036_Nfasj KR003A 2025-12-29T15:01:06.480Z 2026-01-02T15:48:32.893Z
9074257 9074257 20251225193201_dEoHY KR003A 2025-12-29T15:00:22.779Z 2026-01-02T15:48:28.358Z
9074182 9074182 20251225192228_Lf2sC KR003A 2025-12-29T15:00:13.394Z 2026-01-02T15:48:16.306Z
9073922 9073922 20251225184450_2Y3BG KR003A 2025-12-29T14:59:58.350Z 2026-01-02T15:48:00.673Z
9073903 9073903 20251225184213_VG4XL KR003A 2025-12-29T14:59:57.845Z 2026-01-02T15:48:00.434Z
9073568 9073568 20251225180327_PCRdJ KR003A 2025-12-29T14:59:45.909Z 2026-01-02T15:47:53.845Z
9070906 9070906 20251226172845_GIt9z KR003A 2025-12-29T14:48:41.818Z 2026-01-03T15:42:17.859Z

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