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

9,185 rows where station_code = "KR0019" 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
9610098 9610098 20260405125834_3xbLl KR0019 2026-04-06T12:05:48.481Z 2026-04-06T12:05:48.481Z
9609927 9609927 20260405111526_AGyvQ KR0019 2026-04-06T12:04:47.589Z 2026-04-06T12:04:47.589Z
9609867 9609867 20260405104052_lLFbY KR0019 2026-04-06T12:04:23.375Z 2026-04-06T12:04:23.375Z
9607935 9607935 20260404193024_LWVBa KR0019 2026-04-05T12:04:58.510Z 2026-04-06T12:16:14.568Z
9604028 9604028 20260402150619_XQ2VZ KR0019 2026-04-03T12:05:37.406Z 2026-04-06T12:22:50.204Z
9603876 9603876 20260402132002_eP64K KR0019 2026-04-03T12:04:56.590Z 2026-04-06T12:22:39.152Z
9603836 9603836 20260402130258_brpU7 KR0019 2026-04-03T12:04:50.508Z 2026-04-06T12:22:36.691Z
9600757 9600757 20260329155134_M5eLr KR0019 2026-04-01T12:13:49.792Z 2026-04-06T12:35:49.303Z
9600101 9600101 20260331193759_1w3wk KR0019 2026-04-01T12:05:59.435Z 2026-04-06T12:28:57.234Z
9591663 9591663 20260328184114_pFi5E KR0019 2026-03-29T12:04:48.729Z 2026-04-06T12:39:37.952Z
9591641 9591641 20260328180941_4kLaW KR0019 2026-03-29T12:04:46.710Z 2026-04-06T12:39:29.679Z
9591631 9591631 20260328175307_SW66k KR0019 2026-03-29T12:04:46.168Z 2026-04-06T12:39:26.105Z
9591493 9591493 20260328165242_JfgAn KR0019 2026-03-29T12:04:30.327Z 2026-04-06T12:39:18.281Z
9591446 9591446 20260328163723_Rpsdm KR0019 2026-03-29T12:04:25.963Z 2026-04-06T12:39:15.961Z
9591033 9591033 20260328123654_4Yq6y KR0019 2026-03-29T12:03:41.685Z 2026-04-06T12:38:47.664Z
9588142 9588142 20260327195749_aXtD1 KR0019 2026-03-28T12:07:14.552Z 2026-04-05T12:35:11.111Z
9588115 9588115 20260327192702_snmNc KR0019 2026-03-28T12:07:12.028Z 2026-04-05T12:35:09.267Z
9588083 9588083 20260327183459_IR3Eh KR0019 2026-03-28T12:07:08.790Z 2026-04-05T12:35:07.390Z
9588045 9588045 20260327180414_k23nx KR0019 2026-03-28T12:07:03.508Z 2026-04-05T12:35:05.692Z
9588028 9588028 20260327173444_9x8Wt KR0019 2026-03-28T12:06:58.713Z 2026-04-05T12:35:04.911Z
9587969 9587969 20260327170656_5W5Zm KR0019 2026-03-28T12:06:49.358Z 2026-04-05T12:35:01.876Z
9587919 9587919 20260327165053_Oqv68 KR0019 2026-03-28T12:06:43.168Z 2026-04-05T12:34:59.439Z
9583893 9583893 20260326195956_CrgtB KR0019 2026-03-27T12:10:03.756Z 2026-04-04T12:41:51.790Z
9583881 9583881 20260326192625_PGjfE KR0019 2026-03-27T12:10:00.972Z 2026-04-04T12:41:49.976Z
9583879 9583879 20260326192446_38LRN KR0019 2026-03-27T12:10:00.364Z 2026-04-04T12:41:49.705Z
9583803 9583803 20260326182709_XoXqn KR0019 2026-03-27T12:09:49.858Z 2026-04-04T12:41:39.518Z
9583752 9583752 20260326174147_VV2vR KR0019 2026-03-27T12:09:41.195Z 2026-04-04T12:41:37.409Z
9583646 9583646 20260326165410_OYMw0 KR0019 2026-03-27T12:09:24.301Z 2026-04-04T12:41:29.575Z
9583614 9583614 20260326163647_W3S3A KR0019 2026-03-27T12:09:19.517Z 2026-04-04T12:41:28.314Z
9583530 9583530 20260326155247_62BTe KR0019 2026-03-27T12:09:04.133Z 2026-04-04T12:41:23.240Z
9583526 9583526 20260326154727_fpOxq KR0019 2026-03-27T12:09:03.823Z 2026-04-04T12:41:22.848Z
9583425 9583425 20260326145345_39Zzh KR0019 2026-03-27T12:08:45.686Z 2026-04-04T12:41:11.293Z
9583421 9583421 20260326145145_ujoMy KR0019 2026-03-27T12:08:44.907Z 2026-04-04T12:41:11.104Z
9583365 9583365 20260326134636_zR2il KR0019 2026-03-27T12:08:34.243Z 2026-04-04T12:41:05.134Z
9583335 9583335 20260326130500_Nvi2Y KR0019 2026-03-27T12:08:28.734Z 2026-04-04T12:41:03.393Z
9583311 9583311 20260326121828_GNcny KR0019 2026-03-27T12:08:21.167Z 2026-04-04T12:41:02.007Z
9579062 9579062 20260325185956_5dShl KR0019 2026-03-26T12:09:15.275Z 2026-04-03T12:39:09.045Z
9579041 9579041 20260325180145_jiUZm KR0019 2026-03-26T12:09:12.026Z 2026-04-03T12:38:58.105Z
9578979 9578979 20260325170352_OSKjY KR0019 2026-03-26T12:09:03.453Z 2026-04-03T12:38:48.593Z
9578828 9578828 20260325150708_fuy7K KR0019 2026-03-26T12:08:38.251Z 2026-04-03T12:38:35.225Z
9578764 9578764 20260325142829_d6Aeq KR0019 2026-03-26T12:08:26.846Z 2026-04-03T12:38:31.750Z
9578709 9578709 20260325134504_0Kq3k KR0019 2026-03-26T12:08:18.088Z 2026-04-03T12:38:17.931Z
9578688 9578688 20260325133055_1XcnQ KR0019 2026-03-26T12:08:15.410Z 2026-04-03T12:38:17.094Z
9575263 9575263 20260323200008_NfFiP KR0019 2026-03-25T12:20:42.109Z 2026-03-31T12:28:52.671Z
9575235 9575235 20260323194906_2cVko KR0019 2026-03-25T12:20:39.682Z 2026-03-31T12:28:51.976Z
9575129 9575129 20260323185045_P3nna KR0019 2026-03-25T12:20:21.714Z 2026-03-31T12:28:49.239Z
9574983 9574983 20260323175709_I5O5r KR0019 2026-03-25T12:19:59.926Z 2026-03-31T12:28:45.787Z
9568355 9568355 20260323163430_nx2FS KR0019 2026-03-24T12:14:56.724Z 2026-03-31T12:28:27.971Z
9568112 9568112 20260323161438_Icb32 KR0019 2026-03-24T12:14:35.006Z 2026-03-31T12:28:23.164Z
9567216 9567216 20260323145343_PjLwG KR0019 2026-03-24T12:13:13.884Z 2026-03-31T12:28:10.400Z
9567012 9567012 20260323143203_C3Lyd KR0019 2026-03-24T12:12:51.022Z 2026-03-31T12:28:07.140Z
9565492 9565492 20260323121326_UBXLA KR0019 2026-03-24T12:10:17.502Z 2026-03-31T12:27:36.430Z
9564848 9564848 20260323111318_FqTLI KR0019 2026-03-24T12:08:53.661Z 2026-03-31T12:27:16.414Z
9551268 9551268 20260320190440_Q5zDx KR0019 2026-03-22T12:26:21.438Z 2026-03-28T12:36:41.650Z
9551068 9551068 20260320180816_C2xcC KR0019 2026-03-22T12:26:08.651Z 2026-03-28T12:36:39.513Z
9550864 9550864 20260320171717_TKrNs KR0019 2026-03-22T12:25:48.461Z 2026-03-28T12:36:37.073Z
9550731 9550731 20260320170718_3UbAK KR0019 2026-03-22T12:25:40.225Z 2026-03-28T12:36:35.494Z
9550233 9550233 20260320162225_fiHAl KR0019 2026-03-22T12:25:03.275Z 2026-03-28T12:36:28.538Z
9550140 9550140 20260320161152_sTna8 KR0019 2026-03-22T12:24:57.177Z 2026-03-28T12:36:27.456Z
9549510 9549510 20260320150733_ENvog KR0019 2026-03-22T12:24:05.757Z 2026-03-28T12:36:05.136Z
9547909 9547909 20260321141046_FbID2 KR0019 2026-03-22T12:14:29.924Z 2026-03-22T12:27:38.567Z
9547626 9547626 20260321134728_j5jPa KR0019 2026-03-22T12:14:00.484Z 2026-03-29T12:20:10.743Z
9547569 9547569 20260321134253_p9ZTx KR0019 2026-03-22T12:13:55.238Z 2026-03-29T12:20:10.192Z
9541253 9541253 20260319201037_rZVN4 KR0019 2026-03-21T12:28:46.764Z 2026-03-27T12:42:35.938Z
9540928 9540928 20260319183358_3AY9L KR0019 2026-03-21T12:28:17.111Z 2026-03-27T12:42:32.058Z
9540755 9540755 20260319174946_oantM KR0019 2026-03-21T12:28:07.403Z 2026-03-27T12:42:30.707Z
9540723 9540723 20260319173237_Kna7Z KR0019 2026-03-21T12:27:57.384Z 2026-03-27T12:42:30.264Z
9540474 9540474 20260319154741_5a1mX KR0019 2026-03-21T12:27:02.633Z 2026-03-27T12:42:22.422Z
9540326 9540326 20260319151501_t2mxC KR0019 2026-03-21T12:26:50.601Z 2026-03-27T12:42:19.636Z
9540297 9540297 20260319150221_O6bH4 KR0019 2026-03-21T12:26:40.869Z 2026-03-27T12:42:13.099Z
9540251 9540251 20260319144956_347LT KR0019 2026-03-21T12:26:33.900Z 2026-03-27T12:42:04.945Z
9540022 9540022 20260319123224_3I3zZ KR0019 2026-03-21T12:25:56.581Z 2026-03-27T12:41:56.363Z
9539911 9539911 20260319105434_R20ns KR0019 2026-03-21T12:25:11.662Z 2026-03-27T12:41:46.202Z
9538576 9538576 20260320132058_SCRAL KR0019 2026-03-21T12:17:58.134Z 2026-03-28T12:35:50.291Z
9538432 9538432 20260320130458_nwUQz KR0019 2026-03-21T12:17:42.423Z 2026-03-21T12:30:06.475Z
9530061 9530061 20260318200223_awGhC KR0019 2026-03-20T12:23:57.281Z 2026-03-26T12:39:08.858Z
9507116 9507116 20260316202306_t8Yp7 KR0019 2026-03-18T12:19:54.697Z 2026-03-24T12:41:40.047Z
9506909 9506909 20260316195137_1Wfj3 KR0019 2026-03-18T12:19:34.107Z 2026-03-24T12:41:35.654Z
9506701 9506701 20260316185950_ldhLB KR0019 2026-03-18T12:19:14.074Z 2026-03-24T12:41:34.331Z
9504837 9504837 20260317123346_o1M01 KR0019 2026-03-18T12:09:01.261Z 2026-03-25T12:42:25.005Z
9503990 9503990 20260317102133_V3qPy KR0019 2026-03-18T12:06:55.355Z 2026-03-25T12:42:19.007Z
9500228 9500228 20260316175816_3tnxX KR0019 2026-03-17T12:17:00.684Z 2026-03-24T12:41:32.945Z
9500164 9500164 20260316174343_qLeWs KR0019 2026-03-17T12:16:51.980Z 2026-03-24T12:41:32.728Z
9499982 9499982 20260316171014_VxYeM KR0019 2026-03-17T12:16:32.797Z 2026-03-24T12:41:32.101Z
9499637 9499637 20260316163754_iwpaI KR0019 2026-03-17T12:15:54.327Z 2026-03-24T12:41:30.991Z
9498764 9498764 20260316152449_q4HlS KR0019 2026-03-17T12:14:25.853Z 2026-03-24T12:41:26.902Z
9498732 9498732 20260316152233_CsuGI KR0019 2026-03-17T12:14:21.455Z 2026-03-24T12:41:26.860Z
9498497 9498497 20260316151001_2rM3z KR0019 2026-03-17T12:14:01.773Z 2026-03-24T12:41:26.283Z
9498123 9498123 20260316143731_UN6M2 KR0019 2026-03-17T12:13:19.452Z 2026-03-24T12:41:25.029Z
9497908 9497908 20260316141932_qU47S KR0019 2026-03-17T12:12:53.444Z 2026-03-24T12:41:24.507Z
9497801 9497801 20260316141102_yJwUi KR0019 2026-03-17T12:12:40.675Z 2026-03-24T12:41:24.315Z
9497345 9497345 20260316132107_CwBC8 KR0019 2026-03-17T12:11:49.444Z 2026-03-24T12:41:22.938Z
9496668 9496668 20260316120347_dgZG9 KR0019 2026-03-17T12:10:19.322Z 2026-03-24T12:41:20.667Z
9496238 9496238 20260316110317_DwTUq KR0019 2026-03-17T12:09:20.358Z 2026-03-24T12:41:18.842Z
9480433 9480433 20260314133139_GkeO2 KR0019 2026-03-15T12:15:56.217Z 2026-03-22T12:42:41.349Z
9480334 9480334 20260314131848_tNnds KR0019 2026-03-15T12:15:44.171Z 2026-03-22T12:42:41.038Z
9480079 9480079 20260314125423_Ps4kP KR0019 2026-03-15T12:15:11.226Z 2026-03-22T12:42:40.321Z
9473839 9473839 20260313200804_cpSg0 KR0019 2026-03-14T12:16:03.189Z 2026-03-21T12:50:15.614Z
9473683 9473683 20260313181708_6dlUL KR0019 2026-03-14T12:15:37.426Z 2026-03-21T12:49:59.962Z
9473668 9473668 20260313181145_Gi0V2 KR0019 2026-03-14T12:15:35.693Z 2026-03-21T12:49:59.704Z

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