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,196 rows where station_code = "KR0026" 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
9271236 9271236 20260128203444_2oL9G KR0026 2026-01-29T14:15:39.090Z 2026-01-29T14:15:39.090Z
9271030 9271030 20260128192630_i6lsP KR0026 2026-01-29T14:15:00.299Z 2026-01-29T14:15:00.299Z
9270941 9270941 20260128185611_9YY2v KR0026 2026-01-29T14:14:37.913Z 2026-01-29T14:14:37.913Z
9266726 9266726 20260127205534_m9VQC KR0026 2026-01-28T14:14:22.568Z 2026-01-29T14:30:25.207Z
9266596 9266596 20260127200413_qZtT4 KR0026 2026-01-28T14:14:02.297Z 2026-01-29T14:30:25.136Z
9266475 9266475 20260127192728_SxMsN KR0026 2026-01-28T14:13:39.758Z 2026-01-29T14:30:25.037Z
9266238 9266238 20260127182032_IuoQd KR0026 2026-01-28T14:12:56.723Z 2026-01-29T14:30:24.945Z
9266144 9266144 20260127174000_AwWW1 KR0026 2026-01-28T14:12:38.209Z 2026-01-29T14:30:24.896Z
9265936 9265936 20260127161642_ztGMb KR0026 2026-01-28T14:11:48.595Z 2026-01-29T14:30:24.740Z
9265598 9265598 20260127153715_Ipax1 KR0026 2026-01-28T14:10:39.517Z 2026-01-29T14:30:24.619Z
9263375 9263375 20260124202240_5i2v7 KR0026 2026-01-27T14:21:56.466Z 2026-01-29T14:42:47.770Z
9259164 9259164 20260124191523_5wd2p KR0026 2026-01-26T14:15:56.851Z 2026-01-29T14:42:39.872Z
9258977 9258977 20260124181634_LMlBz KR0026 2026-01-26T14:15:16.908Z 2026-01-29T14:42:21.490Z
9258855 9258855 20260124173851_CtqUB KR0026 2026-01-26T14:14:49.522Z 2026-01-29T14:42:15.280Z
9258824 9258824 20260124171901_38UEk KR0026 2026-01-26T14:14:33.457Z 2026-01-29T14:42:12.807Z
9258388 9258388 20260124110202_XlgQK KR0026 2026-01-26T14:11:21.378Z 2026-01-29T14:40:38.979Z
9258293 9258293 20260125205653_Z7Oum KR0026 2026-01-26T14:10:22.523Z 2026-01-29T14:38:24.813Z
9258219 9258219 20260125195524_UdbKr KR0026 2026-01-26T14:10:06.832Z 2026-01-29T14:38:11.811Z
9258066 9258066 20260125182044_D5A2U KR0026 2026-01-26T14:09:23.501Z 2026-01-29T14:38:01.282Z
9257741 9257741 20260125154633_jQE2I KR0026 2026-01-26T14:07:31.476Z 2026-01-29T14:37:37.584Z
9257324 9257324 20260125124615_YDVfJ KR0026 2026-01-26T14:04:44.882Z 2026-01-29T14:37:05.729Z
9254031 9254031 20260123134507_3UqAf KR0026 2026-01-25T14:06:29.585Z 2026-01-29T14:45:26.185Z
9251609 9251609 20260122212657_Ti8z0 KR0026 2026-01-24T14:12:35.830Z 2026-01-29T14:51:54.712Z
9251574 9251574 20260122210941_aHQbp KR0026 2026-01-24T14:12:20.063Z 2026-01-29T14:51:49.830Z
9251529 9251529 20260122204533_0XKbq KR0026 2026-01-24T14:12:09.155Z 2026-01-29T14:51:46.965Z
9251429 9251429 20260122201208_8ePqj KR0026 2026-01-24T14:11:43.392Z 2026-01-29T14:51:41.230Z
9251393 9251393 20260122195715_8ao47 KR0026 2026-01-24T14:11:35.443Z 2026-01-29T14:51:38.688Z
9251363 9251363 20260122194933_Znwvs KR0026 2026-01-24T14:11:26.032Z 2026-01-29T14:51:35.260Z
9251300 9251300 20260122193746_62u6d KR0026 2026-01-24T14:11:10.194Z 2026-01-29T14:51:27.460Z
9251224 9251224 20260122191348_UsWK0 KR0026 2026-01-24T14:10:48.228Z 2026-01-29T14:51:20.927Z
9251156 9251156 20260122184531_bnqje KR0026 2026-01-24T14:10:20.445Z 2026-01-29T14:51:14.561Z
9251139 9251139 20260122183937_Iaq6I KR0026 2026-01-24T14:10:14.914Z 2026-01-29T14:51:12.776Z
9251098 9251098 20260122182736_dp9pV KR0026 2026-01-24T14:09:59.231Z 2026-01-29T14:51:10.128Z
9251044 9251044 20260122175701_xDUHE KR0026 2026-01-24T14:09:34.644Z 2026-01-29T14:50:56.752Z
9250800 9250800 20260122150920_bNsAN KR0026 2026-01-24T14:07:26.835Z 2026-01-29T14:50:19.926Z
9250634 9250634 20260122113321_KBpck KR0026 2026-01-24T14:04:37.748Z 2026-01-29T14:49:19.991Z
9250606 9250606 20260122105842_xRX1q KR0026 2026-01-24T14:04:15.456Z 2026-01-29T14:49:11.862Z
9247915 9247915 20260121202907_iH6qV KR0026 2026-01-23T14:11:31.387Z 2026-01-29T14:56:43.622Z
9247889 9247889 20260121202445_vXQLe KR0026 2026-01-23T14:11:22.588Z 2026-01-29T14:56:42.601Z
9247885 9247885 20260121202257_612mk KR0026 2026-01-23T14:11:22.004Z 2026-01-29T14:56:42.320Z
9247781 9247781 20260121194545_wwbfs KR0026 2026-01-23T14:11:06.902Z 2026-01-29T14:56:37.121Z
9247413 9247413 20260121182724_OorJt KR0026 2026-01-23T14:10:00.815Z 2026-01-29T14:56:07.681Z
9247240 9247240 20260121174215_qZplr KR0026 2026-01-23T14:09:29.356Z 2026-01-29T14:55:51.421Z
9240710 9240710 20260120173113_XI9Ko KR0026 2026-01-22T14:09:41.541Z 2026-01-29T15:01:50.723Z
9240222 9240222 20260120140659_xiwkb KR0026 2026-01-22T14:07:06.559Z 2026-01-29T15:00:52.554Z
9240219 9240219 20260120135710_R3E0H KR0026 2026-01-22T14:07:04.682Z 2026-01-29T15:00:51.844Z
9240109 9240109 20260120122210_TYlcL KR0026 2026-01-22T14:05:45.242Z 2026-01-29T15:00:02.454Z
9233548 9233548 20260119134018_3O9oi KR0026 2026-01-21T14:08:02.790Z 2026-01-28T14:55:44.248Z
9226942 9226942 20260119133331_VlmyZ KR0026 2026-01-20T14:05:46.366Z 2026-01-28T14:55:43.141Z
9222130 9222130 20260117182030_ITgc0 KR0026 2026-01-19T14:13:25.408Z 2026-01-26T15:00:39.483Z
9222051 9222051 20260117175103_ZiISI KR0026 2026-01-19T14:13:01.162Z 2026-01-26T15:00:36.105Z
9221938 9221938 20260117171850_x4dg8 KR0026 2026-01-19T14:12:29.912Z 2026-01-26T15:00:31.307Z
9217474 9217474 20260116152935_EDPI3 KR0026 2026-01-18T14:07:17.713Z 2026-01-25T14:57:18.516Z
9217468 9217468 20260116152711_4JXGH KR0026 2026-01-18T14:07:16.416Z 2026-01-25T14:57:18.151Z
9217459 9217459 20260116152017_XbYGw KR0026 2026-01-18T14:07:14.846Z 2026-01-25T14:57:17.995Z
9217448 9217448 20260116145413_f18PQ KR0026 2026-01-18T14:07:05.953Z 2026-01-25T14:57:15.390Z
9217407 9217407 20260116133927_PYlDq KR0026 2026-01-18T14:06:39.693Z 2026-01-25T14:57:09.790Z
9217348 9217348 20260116122135_qbdoA KR0026 2026-01-18T14:05:40.387Z 2026-01-25T14:56:43.385Z
9216856 9216856 20260117131412_sc2Hk KR0026 2026-01-18T14:02:59.378Z 2026-01-26T14:59:32.712Z
9216295 9216295 20260116112905_CZFUO KR0026 2026-01-17T14:28:55.065Z 2026-01-24T15:15:21.739Z
9212414 9212414 20260115210811_KQQn0 KR0026 2026-01-17T14:11:42.145Z 2026-01-24T15:10:51.743Z
9212396 9212396 20260115210508_eniTW KR0026 2026-01-17T14:11:36.841Z 2026-01-24T15:10:51.096Z
9212214 9212214 20260115195827_TMjOc KR0026 2026-01-17T14:10:36.309Z 2026-01-24T15:10:32.313Z
9212037 9212037 20260115185213_umFOV KR0026 2026-01-17T14:09:36.345Z 2026-01-24T15:10:20.506Z
9211885 9211885 20260115181607_baaut KR0026 2026-01-17T14:08:55.410Z 2026-01-24T15:10:08.736Z
9211722 9211722 20260115172849_98NwL KR0026 2026-01-17T14:08:03.677Z 2026-01-24T15:09:48.943Z
9211423 9211423 20260115153143_M2CpS KR0026 2026-01-17T14:06:34.251Z 2026-01-24T15:09:13.391Z
9211333 9211333 20260115144324_9wLHw KR0026 2026-01-17T14:06:08.776Z 2026-01-24T15:09:07.405Z
9211248 9211248 20260115140722_gtddV KR0026 2026-01-17T14:05:47.164Z 2026-01-24T15:08:56.443Z
9210238 9210238 20260115114958_SpS9A KR0026 2026-01-16T14:19:13.948Z 2026-01-22T15:05:43.601Z
9210219 9210219 20260115094829_xCzLE KR0026 2026-01-16T14:19:09.093Z 2026-01-22T15:05:03.087Z
9199722 9199722 20260113210627_Sr5je KR0026 2026-01-15T14:12:07.908Z 2026-01-22T15:08:00.499Z
9199605 9199605 20260113203441_ybvHs KR0026 2026-01-15T14:11:36.791Z 2026-01-22T15:07:47.429Z
9199526 9199526 20260113201520_waXIz KR0026 2026-01-15T14:11:18.284Z 2026-01-22T15:07:26.111Z
9199515 9199515 20260113201512_X6Gcd KR0026 2026-01-15T14:11:16.626Z 2026-01-22T15:07:25.868Z
9199193 9199193 20260113192015_G42o3 KR0026 2026-01-15T14:09:42.077Z 2026-01-22T15:07:16.259Z
9199111 9199111 20260113190202_1DEYf KR0026 2026-01-15T14:09:17.047Z 2026-01-22T15:07:14.110Z
9199089 9199089 20260113190147_J00ur KR0026 2026-01-15T14:09:11.240Z 2026-01-22T15:07:13.767Z
9197803 9197803 20260113123900_LYT57 KR0026 2026-01-14T14:24:26.907Z 2026-01-21T15:06:25.011Z
9197572 9197572 20260113114753_3PeKg KR0026 2026-01-14T14:23:31.706Z 2026-01-14T14:25:08.746Z
9194509 9194509 20260112210717_C30oK KR0026 2026-01-14T14:09:31.822Z 2026-01-21T15:04:17.856Z
9193781 9193781 20260113180652_2ueYY KR0026 2026-01-14T14:03:16.267Z 2026-01-22T15:07:05.259Z
9193757 9193757 20260113175741_wy2io KR0026 2026-01-14T14:03:11.288Z 2026-01-22T15:07:04.113Z
9193713 9193713 20260113173803_kKc1C KR0026 2026-01-14T14:03:00.341Z 2026-01-22T15:07:00.981Z
9193634 9193634 20260113165121_zIpAz KR0026 2026-01-14T14:02:36.383Z 2026-01-22T15:06:32.441Z
9193549 9193549 20260113160805_CFK5q KR0026 2026-01-14T14:02:09.832Z 2026-01-22T15:06:25.773Z
9193363 9193363 20260113134914_VhgxX KR0026 2026-01-14T14:00:53.094Z 2026-01-14T14:00:53.094Z
9193349 9193349 20260113134007_MOYo5 KR0026 2026-01-14T14:00:47.705Z 2026-01-22T15:06:14.188Z
9193227 9193227 20260112113741_wvG6w KR0026 2026-01-13T14:30:52.610Z 2026-01-20T15:25:44.438Z
9188184 9188184 20260111211945_ait9B KR0026 2026-01-13T14:10:54.107Z 2026-01-20T15:21:26.043Z
9187658 9187658 20260111180833_9Lr7z KR0026 2026-01-13T14:08:16.337Z 2026-01-20T15:20:39.463Z
9187580 9187580 20260111174923_DW2lb KR0026 2026-01-13T14:07:54.608Z 2026-01-20T15:20:34.062Z
9187465 9187465 20260111171514_AeCn4 KR0026 2026-01-13T14:07:28.301Z 2026-01-20T15:20:29.837Z
9187338 9187338 20260111161527_CJQM4 KR0026 2026-01-13T14:06:50.286Z 2026-01-20T15:20:24.210Z
9187316 9187316 20260111160634_EkHoW KR0026 2026-01-13T14:06:41.943Z 2026-01-20T15:20:22.949Z
9187254 9187254 20260111155333_nZkXK KR0026 2026-01-13T14:06:24.994Z 2026-01-20T15:20:11.842Z
9187251 9187251 20260111155333_yY5DZ KR0026 2026-01-13T14:06:24.400Z 2026-01-20T15:20:11.714Z
9187234 9187234 20260111155044_Xa14i KR0026 2026-01-13T14:06:20.418Z 2026-01-20T15:20:10.752Z
9187083 9187083 20260111150430_FtH3d KR0026 2026-01-13T14:05:21.555Z 2026-01-20T15:19:58.284Z
9185420 9185420 20260111104636_Uh6D5 KR0026 2026-01-12T14:24:36.767Z 2026-01-19T15:20:23.955Z

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