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,671 rows where station_code = "KR000B" 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
9607958 9607958 20260404201631_2k4in KR000B 2026-04-05T12:05:07.157Z 2026-04-06T12:16:14.595Z
9607946 9607946 20260404200148_LFAfC KR000B 2026-04-05T12:05:01.185Z 2026-04-06T12:16:14.584Z
9607879 9607879 20260404181925_Vviro KR000B 2026-04-05T12:04:41.592Z 2026-04-06T12:16:14.543Z
9588065 9588065 20260327182219_VeFWw KR000B 2026-03-28T12:07:06.962Z 2026-04-05T12:35:06.848Z
9583904 9583904 20260326200230_dKjPu KR000B 2026-03-27T12:10:05.994Z 2026-04-04T12:41:52.304Z
9583890 9583890 20260326195800_XfLvs KR000B 2026-03-27T12:10:03.135Z 2026-04-04T12:41:51.600Z
9583876 9583876 20260326192353_yaRi0 KR000B 2026-03-27T12:09:59.747Z 2026-04-04T12:41:49.530Z
9583810 9583810 20260326184035_oQzFN KR000B 2026-03-27T12:09:51.009Z 2026-04-04T12:41:39.912Z
9583781 9583781 20260326181101_4Kn9V KR000B 2026-03-27T12:09:44.760Z 2026-04-04T12:41:38.690Z
9579098 9579098 20260325202114_LUPFo KR000B 2026-03-26T12:09:18.930Z 2026-04-03T12:39:17.842Z
9579096 9579096 20260325201057_u2h7j KR000B 2026-03-26T12:09:18.707Z 2026-04-03T12:39:16.899Z
9579074 9579074 20260325192634_pg98B KR000B 2026-03-26T12:09:16.599Z 2026-04-03T12:39:11.525Z
9579038 9579038 20260325175936_3Xt8p KR000B 2026-03-26T12:09:11.693Z 2026-04-03T12:38:57.484Z
9579031 9579031 20260325174718_Okwnw KR000B 2026-03-26T12:09:10.911Z 2026-04-03T12:38:51.618Z
9578998 9578998 20260325171838_Zc2gp KR000B 2026-03-26T12:09:06.601Z 2026-04-03T12:38:49.361Z
9578996 9578996 20260325171702_SdYuc KR000B 2026-03-26T12:09:06.114Z 2026-04-03T12:38:49.298Z
9578970 9578970 20260325170320_qL4Kk KR000B 2026-03-26T12:09:02.848Z 2026-04-03T12:38:48.385Z
9578928 9578928 20260325162135_7GpZx KR000B 2026-03-26T12:08:53.193Z 2026-04-03T12:38:43.670Z
9578882 9578882 20260325154014_cz4mh KR000B 2026-03-26T12:08:45.559Z 2026-04-03T12:38:38.539Z
9578810 9578810 20260325150301_PB85X KR000B 2026-03-26T12:08:35.249Z 2026-04-03T12:38:34.470Z
9575113 9575113 20260323184539_jFt95 KR000B 2026-03-25T12:20:19.323Z 2026-03-31T12:28:48.769Z
9574989 9574989 20260323180220_4hE6u KR000B 2026-03-25T12:20:01.593Z 2026-03-31T12:28:45.912Z
9574720 9574720 20260323154857_7tLav KR000B 2026-03-25T12:17:49.318Z 2026-03-31T12:28:18.772Z
9570302 9570302 20260322202703_c0Ak8 KR000B 2026-03-24T12:22:57.897Z 2026-03-30T12:30:39.384Z
9570232 9570232 20260322200730_CvXx9 KR000B 2026-03-24T12:22:50.924Z 2026-03-30T12:30:37.585Z
9570050 9570050 20260322190125_tR3jy KR000B 2026-03-24T12:22:31.452Z 2026-03-30T12:30:27.098Z
9570009 9570009 20260322185152_3QsG1 KR000B 2026-03-24T12:22:28.080Z 2026-03-30T12:30:26.358Z
9569965 9569965 20260322183852_GbyFN KR000B 2026-03-24T12:22:24.476Z 2026-03-30T12:30:25.523Z
9569891 9569891 20260322181858_h6R5l KR000B 2026-03-24T12:22:18.913Z 2026-03-30T12:30:24.498Z
9569864 9569864 20260322181230_HuS6F KR000B 2026-03-24T12:22:16.238Z 2026-03-30T12:30:22.596Z
9569793 9569793 20260322174033_Gfo7O KR000B 2026-03-24T12:22:06.884Z 2026-03-30T12:30:21.355Z
9569787 9569787 20260322173658_fsWl4 KR000B 2026-03-24T12:22:06.257Z 2026-03-30T12:30:21.039Z
9569730 9569730 20260322171023_sy9PK KR000B 2026-03-24T12:21:55.938Z 2026-03-30T12:30:18.393Z
9569644 9569644 20260322163711_YkYj7 KR000B 2026-03-24T12:21:37.086Z 2026-03-30T12:30:13.099Z
9569503 9569503 20260322155912_5k3sR KR000B 2026-03-24T12:21:15.501Z 2026-03-30T12:30:06.461Z
9569456 9569456 20260322154150_aG3mr KR000B 2026-03-24T12:21:02.315Z 2026-03-30T12:30:03.750Z
9569367 9569367 20260322151029_iW3LU KR000B 2026-03-24T12:20:46.284Z 2026-03-30T12:29:50.596Z
9569139 9569139 20260322133339_LKu9L KR000B 2026-03-24T12:19:52.673Z 2026-03-30T12:29:34.578Z
9559026 9559026 20260321162020_38RrR KR000B 2026-03-23T12:10:51.713Z 2026-03-29T12:20:33.273Z
9551554 9551554 20260320201923_8iuqj KR000B 2026-03-22T12:26:47.759Z 2026-03-28T12:36:57.987Z
9551538 9551538 20260320201335_Huqqa KR000B 2026-03-22T12:26:46.486Z 2026-03-28T12:36:57.639Z
9551504 9551504 20260320195843_q0OPu KR000B 2026-03-22T12:26:44.442Z 2026-03-28T12:36:56.910Z
9551502 9551502 20260320195835_r8LUR KR000B 2026-03-22T12:26:44.294Z 2026-03-28T12:36:56.652Z
9551395 9551395 20260320194221_bQV3T KR000B 2026-03-22T12:26:38.198Z 2026-03-28T12:36:50.330Z
9551367 9551367 20260320193520_c2Twy KR000B 2026-03-22T12:26:36.174Z 2026-03-28T12:36:48.111Z
9551258 9551258 20260320190437_s5zrF KR000B 2026-03-22T12:26:21.198Z 2026-03-28T12:36:41.607Z
9551076 9551076 20260320180927_M3H8c KR000B 2026-03-22T12:26:08.977Z 2026-03-28T12:36:39.681Z
9551012 9551012 20260320174558_zXVq7 KR000B 2026-03-22T12:26:04.932Z 2026-03-28T12:36:38.946Z
9550707 9550707 20260320170246_y8VWO KR000B 2026-03-22T12:25:38.592Z 2026-03-28T12:36:35.203Z
9550062 9550062 20260320160437_Tfeff KR000B 2026-03-22T12:24:53.153Z 2026-03-28T12:36:26.652Z
9550059 9550059 20260320160437_jP9GY KR000B 2026-03-22T12:24:52.871Z 2026-03-28T12:36:26.615Z
9549924 9549924 20260320155523_98M8c KR000B 2026-03-22T12:24:36.906Z 2026-03-28T12:36:24.049Z
9549461 9549461 20260320150046_PS4cN KR000B 2026-03-22T12:24:01.551Z 2026-03-28T12:36:04.475Z
9547906 9547906 20260321141011_vucWA KR000B 2026-03-22T12:14:29.482Z 2026-03-29T12:20:22.351Z
9546021 9546021 20260321113105_Css7M KR000B 2026-03-22T12:10:50.001Z 2026-03-29T12:19:46.775Z
9540419 9540419 20260319153852_aWyHC KR000B 2026-03-21T12:26:59.178Z 2026-03-27T12:42:21.516Z
9540415 9540415 20260319153755_Xw6Q7 KR000B 2026-03-21T12:26:58.997Z 2026-03-27T12:42:21.492Z
9540215 9540215 20260319143845_dsew3 KR000B 2026-03-21T12:26:30.537Z 2026-03-27T12:42:04.130Z
9540203 9540203 20260319143438_CmTNz KR000B 2026-03-21T12:26:29.452Z 2026-03-27T12:42:03.877Z
9539939 9539939 20260319110726_K9Drb KR000B 2026-03-21T12:25:20.396Z 2026-03-27T12:41:47.361Z
9539385 9539385 20260320143840_n5TzP KR000B 2026-03-21T12:19:27.062Z 2026-03-21T12:30:06.892Z
9539018 9539018 20260320140413_kHDl4 KR000B 2026-03-21T12:18:50.489Z 2026-03-28T12:35:56.090Z
9538962 9538962 20260320140029_fmoWH KR000B 2026-03-21T12:18:40.733Z 2026-03-28T12:35:55.268Z
9538341 9538341 20260320125300_rUMZc KR000B 2026-03-21T12:17:32.365Z 2026-03-28T12:35:47.148Z
9537625 9537625 20260320115134_TucEk KR000B 2026-03-21T12:16:07.758Z 2026-03-28T12:35:27.837Z
9537468 9537468 20260320113934_RkyL8 KR000B 2026-03-21T12:15:53.014Z 2026-03-28T12:35:26.436Z
9536779 9536779 20260320103145_HVjH5 KR000B 2026-03-21T12:14:20.439Z 2026-03-28T12:35:15.952Z
9530204 9530204 20260318202417_MRilC KR000B 2026-03-20T12:24:12.078Z 2026-03-26T12:39:10.365Z
9529961 9529961 20260318194747_ZuP0T KR000B 2026-03-20T12:23:52.121Z 2026-03-26T12:39:07.850Z
9529814 9529814 20260318193350_AL8Is KR000B 2026-03-20T12:23:44.241Z 2026-03-26T12:39:06.702Z
9529445 9529445 20260318182618_yOnmG KR000B 2026-03-20T12:23:11.013Z 2026-03-26T12:39:02.743Z
9529438 9529438 20260318182359_42o2a KR000B 2026-03-20T12:23:10.540Z 2026-03-26T12:39:02.638Z
9529345 9529345 20260318175216_jHLPq KR000B 2026-03-20T12:23:05.403Z 2026-03-26T12:38:58.828Z
9529319 9529319 20260318174605_ljzuE KR000B 2026-03-20T12:23:03.540Z 2026-03-26T12:38:56.647Z
9529248 9529248 20260318173217_XKLo6 KR000B 2026-03-20T12:22:59.858Z 2026-03-26T12:38:52.444Z
9529144 9529144 20260318172010_J2pl3 KR000B 2026-03-20T12:22:55.537Z 2026-03-26T12:38:47.515Z
9528532 9528532 20260318162226_cHzk6 KR000B 2026-03-20T12:22:20.889Z 2026-03-26T12:38:36.684Z
9528221 9528221 20260318155140_Q30tO KR000B 2026-03-20T12:22:00.823Z 2026-03-26T12:38:34.744Z
9528178 9528178 20260318154806_w1nT3 KR000B 2026-03-20T12:21:58.160Z 2026-03-26T12:38:34.360Z
9491814 9491814 20260315200917_iRizM KR000B 2026-03-16T12:21:52.693Z 2026-03-23T12:22:42.425Z
9482592 9482592 20260314171825_6iF9d KR000B 2026-03-15T12:19:50.754Z 2026-03-22T12:42:48.309Z
9482409 9482409 20260314170458_ZQYkl KR000B 2026-03-15T12:19:37.432Z 2026-03-22T12:42:47.910Z
9481101 9481101 20260314143921_lSL13 KR000B 2026-03-15T12:17:10.006Z 2026-03-22T12:42:43.299Z
9480258 9480258 20260314131014_D0bVi KR000B 2026-03-15T12:15:36.124Z 2026-03-22T12:42:40.873Z
9479375 9479375 20260314113110_AQyO1 KR000B 2026-03-15T12:13:33.166Z 2026-03-22T12:42:26.547Z
9479247 9479247 20260314111638_qCWRO KR000B 2026-03-15T12:13:15.947Z 2026-03-22T12:42:21.654Z
9473789 9473789 20260313192034_4oe6y KR000B 2026-03-14T12:15:54.581Z 2026-03-21T12:50:02.120Z
9473786 9473786 20260313192022_ygdQi KR000B 2026-03-14T12:15:51.859Z 2026-03-21T12:50:02.083Z
9473711 9473711 20260313183129_Gg3Zf KR000B 2026-03-14T12:15:40.556Z 2026-03-21T12:50:00.570Z
9473448 9473448 20260313165953_0Gwkk KR000B 2026-03-14T12:15:05.883Z 2026-03-21T12:49:57.695Z
9473252 9473252 20260313162347_DxOxT KR000B 2026-03-14T12:14:42.905Z 2026-03-21T12:49:55.358Z
9473042 9473042 20260313154022_pDbos KR000B 2026-03-14T12:14:21.781Z 2026-03-21T12:49:53.642Z
9472862 9472862 20260313151650_pk2ST KR000B 2026-03-14T12:14:05.617Z 2026-03-21T12:49:52.480Z
9468354 9468354 20260312194747_uYAqv KR000B 2026-03-13T12:21:42.476Z 2026-03-20T12:37:15.051Z
9468337 9468337 20260312193631_70r2W KR000B 2026-03-13T12:21:40.960Z 2026-03-20T12:37:14.852Z
9468324 9468324 20260312193102_2QezZ KR000B 2026-03-13T12:21:40.107Z 2026-03-20T12:37:14.744Z
9468302 9468302 20260312191228_cnFO3 KR000B 2026-03-13T12:21:38.095Z 2026-03-20T12:37:14.441Z
9468295 9468295 20260312191037_XFTBd KR000B 2026-03-13T12:21:37.922Z 2026-03-20T12:37:14.383Z
9468263 9468263 20260312184801_eHZ9l KR000B 2026-03-13T12:21:34.427Z 2026-03-20T12:37:14.188Z
9468232 9468232 20260312183615_uZXlq KR000B 2026-03-13T12:21:31.700Z 2026-03-20T12:37:13.930Z

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