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,995 rows where station_code = "KR002Q" 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
9266774 9266774 20260127211330_t3ml4 KR002Q 2026-01-28T14:14:32.954Z 2026-01-28T14:14:32.954Z
9266694 9266694 20260127204511_Rw3xa KR002Q 2026-01-28T14:14:18.425Z 2026-01-29T14:30:25.174Z
9266645 9266645 20260127202119_4iH5L KR002Q 2026-01-28T14:14:10.045Z 2026-01-29T14:30:25.152Z
9266240 9266240 20260127182032_IuoQd KR002Q 2026-01-28T14:12:56.724Z 2026-01-29T14:30:24.945Z
9266201 9266201 20260127180306_KW3Db KR002Q 2026-01-28T14:12:48.684Z 2026-01-29T14:30:24.922Z
9266191 9266191 20260127175832_U5ATM KR002Q 2026-01-28T14:12:46.201Z 2026-01-29T14:30:24.910Z
9259493 9259493 20260124210959_7YyKv KR002Q 2026-01-26T14:17:16.658Z 2026-01-29T14:42:57.190Z
9259456 9259456 20260124205417_LUNPW KR002Q 2026-01-26T14:17:02.709Z 2026-01-29T14:42:55.569Z
9259438 9259438 20260124205117_8dIio KR002Q 2026-01-26T14:16:59.703Z 2026-01-29T14:42:54.672Z
9259434 9259434 20260124205043_yUeND KR002Q 2026-01-26T14:16:59.315Z 2026-01-29T14:42:54.574Z
9259405 9259405 20260124204130_WCUjx KR002Q 2026-01-26T14:16:54.522Z 2026-01-29T14:42:51.647Z
9259290 9259290 20260124201122_2oF8U KR002Q 2026-01-26T14:16:27.373Z 2026-01-29T14:42:46.403Z
9259257 9259257 20260124200241_jzvVK KR002Q 2026-01-26T14:16:22.345Z 2026-01-29T14:42:45.120Z
9259111 9259111 20260124185437_VSoNO KR002Q 2026-01-26T14:15:42.661Z 2026-01-29T14:42:37.288Z
9259049 9259049 20260124183340_f3Vh2 KR002Q 2026-01-26T14:15:31.565Z 2026-01-29T14:42:27.834Z
9258955 9258955 20260124180833_ZPyz9 KR002Q 2026-01-26T14:15:09.751Z 2026-01-29T14:42:21.143Z
9258944 9258944 20260124180540_4dEX1 KR002Q 2026-01-26T14:15:07.451Z 2026-01-29T14:42:20.228Z
9258843 9258843 20260124172759_OfAfk KR002Q 2026-01-26T14:14:40.229Z 2026-01-29T14:42:14.460Z
9258723 9258723 20260124162420_EbtPE KR002Q 2026-01-26T14:14:04.011Z 2026-01-29T14:41:58.076Z
9258710 9258710 20260124161636_Q2Bgj KR002Q 2026-01-26T14:14:00.758Z 2026-01-29T14:41:54.694Z
9258620 9258620 20260124151530_1tz2C KR002Q 2026-01-26T14:13:26.813Z 2026-01-29T14:41:42.317Z
9258221 9258221 20260125195524_UdbKr KR002Q 2026-01-26T14:10:06.832Z 2026-01-29T14:38:11.811Z
9257867 9257867 20260125163452_z2yTv KR002Q 2026-01-26T14:08:14.288Z 2026-01-26T14:08:14.288Z
9257667 9257667 20260125152037_LUr2l KR002Q 2026-01-26T14:07:05.835Z 2026-01-29T14:37:33.867Z
9257113 9257113 20260125115659_yH1YL KR002Q 2026-01-26T14:03:42.837Z 2026-01-29T14:36:47.333Z
9254786 9254786 20260123211915_2qUl9 KR002Q 2026-01-25T14:10:43.762Z 2026-01-29T14:46:42.493Z
9254770 9254770 20260123211416_zAEfT KR002Q 2026-01-25T14:10:40.855Z 2026-01-29T14:46:41.775Z
9254594 9254594 20260123201818_HSQB1 KR002Q 2026-01-25T14:09:59.608Z 2026-01-29T14:46:31.483Z
9254571 9254571 20260123201334_S2wEz KR002Q 2026-01-25T14:09:50.723Z 2026-01-29T14:46:30.445Z
9254444 9254444 20260123191931_FjFKG KR002Q 2026-01-25T14:09:09.809Z 2026-01-29T14:46:24.023Z
9254415 9254415 20260123190432_3PBxm KR002Q 2026-01-25T14:09:03.537Z 2026-01-29T14:46:14.665Z
9251575 9251575 20260122210941_aHQbp KR002Q 2026-01-24T14:12:20.063Z 2026-01-29T14:51:49.830Z
9251554 9251554 20260122205729_a2MAp KR002Q 2026-01-24T14:12:13.816Z 2026-01-29T14:51:48.489Z
9251482 9251482 20260122202647_F5JNp KR002Q 2026-01-24T14:11:52.474Z 2026-01-29T14:51:43.663Z
9251431 9251431 20260122201208_8ePqj KR002Q 2026-01-24T14:11:43.392Z 2026-01-29T14:51:41.230Z
9251365 9251365 20260122194933_Znwvs KR002Q 2026-01-24T14:11:26.040Z 2026-01-29T14:51:35.260Z
9251329 9251329 20260122194252_x5fCZ KR002Q 2026-01-24T14:11:18.636Z 2026-01-29T14:51:29.033Z
9251194 9251194 20260122190330_gUn9o KR002Q 2026-01-24T14:10:36.142Z 2026-01-29T14:51:17.956Z
9251140 9251140 20260122183937_Iaq6I KR002Q 2026-01-24T14:10:14.914Z 2026-01-29T14:51:12.776Z
9251119 9251119 20260122183128_uQUBY KR002Q 2026-01-24T14:10:07.705Z 2026-01-29T14:51:11.658Z
9251117 9251117 20260122183056_JXFeU KR002Q 2026-01-24T14:10:07.169Z 2026-01-29T14:51:11.405Z
9251006 9251006 20260122174312_RVUhu KR002Q 2026-01-24T14:09:20.753Z 2026-01-29T14:50:52.160Z
9250774 9250774 20260122144641_NAf7i KR002Q 2026-01-24T14:07:04.610Z 2026-01-29T14:50:15.185Z
9250761 9250761 20260122143002_F9rCJ KR002Q 2026-01-24T14:06:55.653Z 2026-01-29T14:50:12.570Z
9248110 9248110 20260121213520_nSZ5B KR002Q 2026-01-23T14:11:57.536Z 2026-01-29T14:56:55.027Z
9248052 9248052 20260121211654_iMEyj KR002Q 2026-01-23T14:11:48.128Z 2026-01-29T14:56:52.511Z
9247998 9247998 20260121210344_XDCHs KR002Q 2026-01-23T14:11:42.051Z 2026-01-29T14:56:47.824Z
9247948 9247948 20260121204017_cNk32 KR002Q 2026-01-23T14:11:36.079Z 2026-01-29T14:56:45.181Z
9247916 9247916 20260121202907_iH6qV KR002Q 2026-01-23T14:11:31.387Z 2026-01-29T14:56:43.622Z
9247862 9247862 20260121201450_yzHir KR002Q 2026-01-23T14:11:16.514Z 2026-01-29T14:56:41.064Z
9247670 9247670 20260121192523_K9MGb KR002Q 2026-01-23T14:10:42.739Z 2026-01-29T14:56:22.378Z
9246955 9246955 20260121154509_X0HcP KR002Q 2026-01-23T14:08:34.791Z 2026-01-29T14:55:30.370Z
9246946 9246946 20260121154442_7eTty KR002Q 2026-01-23T14:08:33.516Z 2026-01-29T14:55:21.760Z
9240225 9240225 20260120140659_xiwkb KR002Q 2026-01-22T14:07:06.559Z 2026-01-29T15:00:52.554Z
9240067 9240067 20260120120454_401ge KR002Q 2026-01-22T14:05:30.161Z 2026-01-29T14:59:55.283Z
9240042 9240042 20260120114356_W8J2W KR002Q 2026-01-22T14:05:14.280Z 2026-01-29T14:59:48.873Z
9233549 9233549 20260119134018_3O9oi KR002Q 2026-01-21T14:08:02.820Z 2026-01-28T14:55:44.248Z
9221832 9221832 20260117164713_AIyzq KR002Q 2026-01-19T14:12:02.677Z 2026-01-26T15:00:11.949Z
9221828 9221828 20260117164410_Necfa KR002Q 2026-01-19T14:12:02.084Z 2026-01-26T15:00:11.787Z
9221820 9221820 20260117164158_3iT2Z KR002Q 2026-01-19T14:12:00.872Z 2026-01-26T15:00:11.430Z
9217999 9217999 20260116213325_UAE0J KR002Q 2026-01-18T14:09:54.412Z 2026-01-25T14:57:54.494Z
9217283 9217283 20260117155442_5sETd KR002Q 2026-01-18T14:05:09.916Z 2026-01-26T15:00:04.620Z
9217178 9217178 20260117150930_ZcGFZ KR002Q 2026-01-18T14:04:39.820Z 2026-01-26T14:59:59.149Z
9216998 9216998 20260117135820_kSImr KR002Q 2026-01-18T14:03:45.287Z 2026-01-26T14:59:51.677Z
9216885 9216885 20260117131937_hO0PO KR002Q 2026-01-18T14:03:08.672Z 2026-01-26T14:59:33.590Z
9211367 9211367 20260115150033_2E22Q KR002Q 2026-01-17T14:06:18.029Z 2026-01-24T15:09:10.498Z
9205662 9205662 20260113110509_RKN24 KR002Q 2026-01-15T14:40:12.027Z 2026-01-21T15:06:17.784Z
9199848 9199848 20260113213125_Z5kuH KR002Q 2026-01-15T14:12:44.019Z 2026-01-22T15:08:03.846Z
9199465 9199465 20260113200336_9hzzH KR002Q 2026-01-15T14:11:00.100Z 2026-01-22T15:07:24.876Z
9199021 9199021 20260113185138_29xib KR002Q 2026-01-15T14:08:55.282Z 2026-01-22T15:07:11.881Z
9198851 9198851 20260113181514_J5R60 KR002Q 2026-01-15T14:07:44.753Z 2026-01-22T15:07:06.579Z
9198803 9198803 20260113180516_Hpgsb KR002Q 2026-01-15T14:07:21.188Z 2026-01-22T15:07:04.874Z
9198548 9198548 20260113170307_5DrGX KR002Q 2026-01-15T14:05:23.039Z 2026-01-22T15:06:33.752Z
9198487 9198487 20260113164133_T8y1K KR002Q 2026-01-15T14:04:48.342Z 2026-01-22T15:06:31.489Z
9198402 9198402 20260113161243_e1MrL KR002Q 2026-01-15T14:04:03.314Z 2026-01-22T15:06:26.168Z
9198200 9198200 20260113143428_gYIRP KR002Q 2026-01-15T14:01:57.720Z 2026-01-22T15:06:16.998Z
9194592 9194592 20260112213006_GhP5a KR002Q 2026-01-14T14:09:54.963Z 2026-01-21T15:04:19.088Z
9194519 9194519 20260112210956_R7uVR KR002Q 2026-01-14T14:09:33.283Z 2026-01-21T15:04:18.004Z
9194482 9194482 20260112205922_EuBcl KR002Q 2026-01-14T14:09:25.064Z 2026-01-21T15:04:16.438Z
9194476 9194476 20260112205545_zGKAv KR002Q 2026-01-14T14:09:23.595Z 2026-01-21T15:04:14.437Z
9194016 9194016 20260112163152_dOki8 KR002Q 2026-01-14T14:06:36.007Z 2026-01-21T15:03:15.567Z
9186956 9186956 20260111143015_di5aZ KR002Q 2026-01-13T14:04:28.213Z 2026-01-20T15:19:37.190Z
9186944 9186944 20260111142804_X2xj0 KR002Q 2026-01-13T14:04:24.153Z 2026-01-20T15:19:35.233Z
9179964 9179964 20260110182801_2AkK6 KR002Q 2026-01-12T14:05:09.469Z 2026-01-19T15:15:38.646Z
9179736 9179736 20260110173643_YSb2P KR002Q 2026-01-12T14:04:05.985Z 2026-01-19T15:15:13.919Z
9179713 9179713 20260110172706_rbE2o KR002Q 2026-01-12T14:03:59.922Z 2026-01-19T15:15:12.651Z
9179672 9179672 20260110171624_A2gIY KR002Q 2026-01-12T14:03:48.828Z 2026-01-19T15:15:10.481Z
9179665 9179665 20260110171459_bzOBK KR002Q 2026-01-12T14:03:46.432Z 2026-01-19T15:15:10.248Z
9179482 9179482 20260110155859_0TtT3 KR002Q 2026-01-12T14:02:47.776Z 2026-01-19T15:14:46.451Z
9179459 9179459 20260110154645_uE5k2 KR002Q 2026-01-12T14:02:30.973Z 2026-01-19T15:14:40.059Z
9179050 9179050 20260110142446_sCZgB KR002Q 2026-01-11T14:16:31.146Z 2026-01-18T15:11:22.777Z
9170130 9170130 20260108143853_xLDgD KR002Q 2026-01-09T14:15:47.010Z 2026-01-16T15:14:00.594Z
9170097 9170097 20260108141950_8b3D5 KR002Q 2026-01-09T14:15:43.168Z 2026-01-16T15:13:54.754Z
9167008 9167008 20260107213217_7j5EW KR002Q 2026-01-09T14:05:48.844Z 2026-01-16T15:10:35.352Z
9167005 9167005 20260107213204_2f27r KR002Q 2026-01-09T14:05:48.251Z 2026-01-16T15:10:35.206Z
9166627 9166627 20260107193233_P2JNg KR002Q 2026-01-09T14:04:10.636Z 2026-01-16T15:10:07.432Z
9166489 9166489 20260107184914_SDMLP KR002Q 2026-01-09T14:03:26.970Z 2026-01-16T15:09:57.600Z
9166402 9166402 20260107181453_o5f1O KR002Q 2026-01-09T14:03:02.842Z 2026-01-16T15:09:52.063Z
9166273 9166273 20260107173731_pekAO KR002Q 2026-01-09T14:02:29.351Z 2026-01-16T15:09:37.400Z
9166211 9166211 20260107171914_rQyKb KR002Q 2026-01-09T14:02:08.783Z 2026-01-16T15:09:31.741Z

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