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

8,037 rows where station_code = "KR000R" 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
9271648 9271648 20260127185246_wre6Q KR000R 2026-01-29T14:22:04.973Z 2026-01-29T14:30:24.995Z
9267968 9267968 20260125204427_GPsR5 KR000R 2026-01-28T14:27:12.866Z 2026-01-29T14:38:23.813Z
9266698 9266698 20260127204716_0enD2 KR000R 2026-01-28T14:14:19.570Z 2026-01-29T14:30:25.175Z
9266585 9266585 20260127200124_QUFzR KR000R 2026-01-28T14:13:57.139Z 2026-01-29T14:30:25.134Z
9266560 9266560 20260127195231_ckRq3 KR000R 2026-01-28T14:13:53.157Z 2026-01-29T14:30:25.102Z
9266529 9266529 20260127194414_F8VpI KR000R 2026-01-28T14:13:47.113Z 2026-01-29T14:30:25.069Z
9266486 9266486 20260127193108_CrLRr KR000R 2026-01-28T14:13:40.846Z 2026-01-29T14:30:25.048Z
9266405 9266405 20260127191441_Ay8Jy KR000R 2026-01-28T14:13:25.492Z 2026-01-29T14:30:25.021Z
9266400 9266400 20260127191404_Twk4C KR000R 2026-01-28T14:13:25.146Z 2026-01-29T14:30:25.020Z
9266281 9266281 20260127183448_w5lWA KR000R 2026-01-28T14:13:08.740Z 2026-01-29T14:30:24.971Z
9266206 9266206 20260127180338_tvtau KR000R 2026-01-28T14:12:50.213Z 2026-01-29T14:30:24.924Z
9266171 9266171 20260127175143_Znm3J KR000R 2026-01-28T14:12:42.495Z 2026-01-29T14:30:24.904Z
9266133 9266133 20260127173748_yhSZx KR000R 2026-01-28T14:12:32.725Z 2026-01-29T14:30:24.894Z
9266074 9266074 20260127170914_45U3r KR000R 2026-01-28T14:12:20.306Z 2026-01-29T14:30:24.845Z
9266068 9266068 20260127170105_e7aWw KR000R 2026-01-28T14:12:18.893Z 2026-01-29T14:30:24.840Z
9265465 9265465 20260127151835_28I6g KR000R 2026-01-28T14:10:14.858Z 2026-01-29T14:30:24.556Z
9265226 9265226 20260127144344_5XOu2 KR000R 2026-01-28T14:09:34.157Z 2026-01-29T14:30:24.509Z
9265047 9265047 20260127140438_qRUG1 KR000R 2026-01-28T14:08:49.750Z 2026-01-29T14:30:24.425Z
9264526 9264526 20260127124246_IIQro KR000R 2026-01-28T14:06:34.193Z 2026-01-29T14:30:24.195Z
9263808 9263808 20260127101512_M03vN KR000R 2026-01-28T14:02:53.721Z 2026-01-29T14:30:18.946Z
9263352 9263352 20260124184813_qQ2iW KR000R 2026-01-27T14:21:33.895Z 2026-01-29T14:42:36.674Z
9262497 9262497 20260126213801_SZR5r KR000R 2026-01-27T14:09:20.109Z 2026-01-29T14:34:44.718Z
9262467 9262467 20260126205732_J7zIu KR000R 2026-01-27T14:09:14.834Z 2026-01-29T14:34:36.728Z
9262389 9262389 20260126201436_W2Yxx KR000R 2026-01-27T14:08:54.414Z 2026-01-29T14:34:28.519Z
9262338 9262338 20260126193602_eXfq6 KR000R 2026-01-27T14:08:44.393Z 2026-01-29T14:34:21.900Z
9262335 9262335 20260126193547_iEt35 KR000R 2026-01-27T14:08:43.828Z 2026-01-29T14:34:21.712Z
9262314 9262314 20260126190900_2igPZ KR000R 2026-01-27T14:08:33.377Z 2026-01-29T14:34:18.210Z
9262296 9262296 20260126185526_6sAXY KR000R 2026-01-27T14:08:30.443Z 2026-01-29T14:34:16.922Z
9262251 9262251 20260126183703_QWzwB KR000R 2026-01-27T14:08:19.704Z 2026-01-29T14:34:11.667Z
9259430 9259430 20260124204610_3p4pp KR000R 2026-01-26T14:16:58.535Z 2026-01-29T14:42:54.285Z
9259370 9259370 20260124203834_XtgS3 KR000R 2026-01-26T14:16:49.333Z 2026-01-29T14:42:50.344Z
9259262 9259262 20260124200312_jD4Dp KR000R 2026-01-26T14:16:23.412Z 2026-01-29T14:42:45.371Z
9259132 9259132 20260124190210_27cwn KR000R 2026-01-26T14:15:52.629Z 2026-01-29T14:42:38.145Z
9258936 9258936 20260124180443_fuZcm KR000R 2026-01-26T14:15:07.010Z 2026-01-29T14:42:20.087Z
9258698 9258698 20260124160739_rQXV6 KR000R 2026-01-26T14:13:56.925Z 2026-01-29T14:41:53.055Z
9258553 9258553 20260124142717_VvEQa KR000R 2026-01-26T14:12:56.077Z 2026-01-29T14:41:25.139Z
9258483 9258483 20260124132907_gTXDJ KR000R 2026-01-26T14:12:26.371Z 2026-01-29T14:41:14.529Z
9258397 9258397 20260124113456_8o4Xa KR000R 2026-01-26T14:11:37.152Z 2026-01-29T14:40:47.729Z
9258344 9258344 20260125213951_jdtbr KR000R 2026-01-26T14:10:31.773Z 2026-01-29T14:38:28.333Z
9258289 9258289 20260125205541_v32JE KR000R 2026-01-26T14:10:22.021Z 2026-01-29T14:38:24.636Z
9258160 9258160 20260125191343_tPsfP KR000R 2026-01-26T14:09:52.366Z 2026-01-29T14:38:06.114Z
9258142 9258142 20260125190629_APAd7 KR000R 2026-01-26T14:09:49.668Z 2026-01-27T14:17:19.112Z
9258060 9258060 20260125181907_c9Cxe KR000R 2026-01-26T14:09:18.726Z 2026-01-29T14:38:00.364Z
9257854 9257854 20260125162658_WJGv2 KR000R 2026-01-26T14:08:11.255Z 2026-01-29T14:37:44.953Z
9257530 9257530 20260125142239_KZfAH KR000R 2026-01-26T14:06:10.963Z 2026-01-29T14:37:25.889Z
9257511 9257511 20260125141439_LZt7S KR000R 2026-01-26T14:06:03.257Z 2026-01-29T14:37:24.558Z
9257474 9257474 20260125140028_LCJAw KR000R 2026-01-26T14:05:52.701Z 2026-01-29T14:37:14.567Z
9254822 9254822 20260123213806_AwZ6v KR000R 2026-01-25T14:10:51.792Z 2026-01-29T14:46:44.316Z
9254706 9254706 20260123204807_MzLX1 KR000R 2026-01-25T14:10:24.915Z 2026-01-29T14:46:36.591Z
9254682 9254682 20260123204510_Ummui KR000R 2026-01-25T14:10:21.095Z 2026-01-29T14:46:35.556Z
9254676 9254676 20260123204323_GpLnP KR000R 2026-01-25T14:10:19.571Z 2026-01-29T14:46:35.186Z
9254631 9254631 20260123203338_3FHVp KR000R 2026-01-25T14:10:06.929Z 2026-01-29T14:46:33.133Z
9254618 9254618 20260123202754_A17cY KR000R 2026-01-25T14:10:04.483Z 2026-01-29T14:46:32.624Z
9254607 9254607 20260123202055_aI6hh KR000R 2026-01-25T14:10:02.191Z 2026-01-29T14:46:32.121Z
9254602 9254602 20260123201937_443jn KR000R 2026-01-25T14:10:01.168Z 2026-01-29T14:46:31.852Z
9254579 9254579 20260123201448_DMNZC KR000R 2026-01-25T14:09:55.781Z 2026-01-29T14:46:30.781Z
9254574 9254574 20260123201345_u2WZn KR000R 2026-01-25T14:09:54.529Z 2026-01-29T14:46:30.512Z
9254505 9254505 20260123194945_IQd3b KR000R 2026-01-25T14:09:32.158Z 2026-01-29T14:46:27.316Z
9254440 9254440 20260123191755_VyV4k KR000R 2026-01-25T14:09:09.045Z 2026-01-29T14:46:23.809Z
9254325 9254325 20260123182107_NDX7f KR000R 2026-01-25T14:08:32.042Z 2026-01-29T14:46:07.467Z
9254285 9254285 20260123175248_ga50J KR000R 2026-01-25T14:08:18.403Z 2026-01-29T14:46:03.863Z
9251434 9251434 20260122201341_ZOIrj KR000R 2026-01-24T14:11:44.177Z 2026-01-29T14:51:41.483Z
9251152 9251152 20260122184422_3Z3KW KR000R 2026-01-24T14:10:19.539Z 2026-01-29T14:51:14.118Z
9251012 9251012 20260122174832_IYhcK KR000R 2026-01-24T14:09:27.017Z 2026-01-29T14:50:54.361Z
9248083 9248083 20260121212941_fybLu KR000R 2026-01-23T14:11:52.022Z 2026-01-29T14:56:53.719Z
9248061 9248061 20260121212100_4cx76 KR000R 2026-01-23T14:11:48.942Z 2026-01-29T14:56:52.731Z
9247960 9247960 20260121204702_JeNfE KR000R 2026-01-23T14:11:37.564Z 2026-01-29T14:56:45.729Z
9247955 9247955 20260121204455_D9N8i KR000R 2026-01-23T14:11:36.935Z 2026-01-29T14:56:45.542Z
9247901 9247901 20260121202734_xxmQa KR000R 2026-01-23T14:11:24.204Z 2026-01-29T14:56:43.064Z
9247765 9247765 20260121194504_nPGiQ KR000R 2026-01-23T14:11:05.024Z 2026-01-29T14:56:36.433Z
9247629 9247629 20260121191756_0u3aZ KR000R 2026-01-23T14:10:37.882Z 2026-01-29T14:56:20.819Z
9247605 9247605 20260121191353_HPkEW KR000R 2026-01-23T14:10:34.562Z 2026-01-29T14:56:17.223Z
9247347 9247347 20260121180749_1djgE KR000R 2026-01-23T14:09:52.788Z 2026-01-29T14:56:05.082Z
9247293 9247293 20260121175425_wLPiq KR000R 2026-01-23T14:09:36.966Z 2026-01-29T14:56:02.509Z
9247132 9247132 20260121171813_IvDaI KR000R 2026-01-23T14:09:09.073Z 2026-01-29T14:55:44.410Z
9246675 9246675 20260121133415_AEMJL KR000R 2026-01-23T14:07:33.395Z 2026-01-29T14:55:04.169Z
9246634 9246634 20260121130806_3A80P KR000R 2026-01-23T14:07:26.804Z 2026-01-29T14:55:01.549Z
9246584 9246584 20260121124027_89VUt KR000R 2026-01-23T14:07:12.101Z 2026-01-29T14:54:44.296Z
9246559 9246559 20260121121357_4VVNS KR000R 2026-01-23T14:07:02.471Z 2026-01-29T14:54:39.911Z
9246507 9246507 20260121104527_xP9d6 KR000R 2026-01-23T14:06:32.036Z 2026-01-29T14:54:15.192Z
9246482 9246482 20260121101248_2T23g KR000R 2026-01-23T14:06:17.228Z 2026-01-29T14:54:03.041Z
9246472 9246472 20260121100810_8zpkQ KR000R 2026-01-23T14:06:14.912Z 2026-01-29T14:53:55.679Z
9246466 9246466 20260122213929_b2D3A KR000R 2026-01-23T14:06:04.684Z 2026-01-29T14:51:56.408Z
9246459 9246459 20260122213055_SXatY KR000R 2026-01-23T14:06:03.366Z 2026-01-23T14:06:03.366Z
9246440 9246440 20260122211247_kO1VV KR000R 2026-01-23T14:05:57.765Z 2026-01-29T14:51:50.150Z
9246386 9246386 20260122195038_60z2l KR000R 2026-01-23T14:05:48.231Z 2026-01-23T14:05:48.231Z
9246363 9246363 20260122193548_WgZkz KR000R 2026-01-23T14:05:45.367Z 2026-01-29T14:51:27.016Z
9246345 9246345 20260122191733_NnKrN KR000R 2026-01-23T14:05:42.994Z 2026-01-29T14:51:22.033Z
9246331 9246331 20260122191457_ItGLo KR000R 2026-01-23T14:05:41.253Z 2026-01-23T14:05:41.253Z
9246228 9246228 20260122180901_ma0kG KR000R 2026-01-23T14:05:18.809Z 2026-01-29T14:50:59.265Z
9246136 9246136 20260122172047_3t2dR KR000R 2026-01-23T14:04:51.376Z 2026-01-29T14:50:47.546Z
9246091 9246091 20260122163914_2e7MK KR000R 2026-01-23T14:04:44.050Z 2026-01-29T14:50:43.454Z
9246054 9246054 20260122161558_I1bBF KR000R 2026-01-23T14:04:36.383Z 2026-01-29T14:50:40.182Z
9245952 9245952 20260122154326_YoBKC KR000R 2026-01-23T14:04:08.247Z 2026-01-29T14:50:26.734Z
9245911 9245911 20260122152544_wHpE7 KR000R 2026-01-23T14:04:00.528Z 2026-01-29T14:50:22.135Z
9245833 9245833 20260122144911_oKubN KR000R 2026-01-23T14:03:38.581Z 2026-01-29T14:50:15.870Z
9245637 9245637 20260122132956_BKkxO KR000R 2026-01-23T14:02:49.770Z 2026-01-23T14:02:49.770Z
9245619 9245619 20260122132322_Nz9CL KR000R 2026-01-23T14:02:38.604Z 2026-01-29T14:49:51.165Z
9245550 9245550 20260122130054_eIC62 KR000R 2026-01-23T14:02:21.634Z 2026-01-29T14:49:46.466Z
9245331 9245331 20260122114829_sYj44 KR000R 2026-01-23T14:01:30.639Z 2026-01-23T14:01:30.639Z

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