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,586 rows where station_code = "KR0028" 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
8686768 8686768 20251203204752_BMasZ KR0028 2025-12-05T14:12:43.415Z 2025-12-05T14:14:35.482Z
8686727 8686727 20251203204113_hCNak KR0028 2025-12-05T14:12:40.610Z 2025-12-05T14:14:35.471Z
8680005 8680005 20251202211706_pE0vm KR0028 2025-12-04T14:10:53.227Z 2025-12-05T14:20:13.246Z
8673606 8673606 20251201203359_quQDf KR0028 2025-12-03T14:19:26.667Z 2025-12-05T14:26:55.423Z
8673541 8673541 20251201195914_0q9dT KR0028 2025-12-03T14:19:09.474Z 2025-12-05T14:26:51.870Z
8673276 8673276 20251201175952_Gk33B KR0028 2025-12-03T14:18:09.884Z 2025-12-05T14:26:21.969Z
8673208 8673208 20251201173045_k3yTE KR0028 2025-12-03T14:17:59.018Z 2025-12-05T14:26:16.419Z
8673173 8673173 20251201172020_MHsU7 KR0028 2025-12-03T14:17:44.740Z 2025-12-05T14:26:13.797Z
8673031 8673031 20251201162545_4Txg3 KR0028 2025-12-03T14:17:09.329Z 2025-12-05T14:25:54.990Z
8673009 8673009 20251201161834_OCrp8 KR0028 2025-12-03T14:17:06.752Z 2025-12-05T14:25:54.181Z
8672933 8672933 20251201154033_L9MuR KR0028 2025-12-03T14:16:57.673Z 2025-12-05T14:25:47.515Z
8672865 8672865 20251201153132_Gik4f KR0028 2025-12-03T14:16:43.650Z 2025-12-05T14:25:44.711Z
8672339 8672339 20251201141854_ogtE3 KR0028 2025-12-03T14:15:19.042Z 2025-12-05T14:25:18.367Z
8672318 8672318 20251201141634_b5PTt KR0028 2025-12-03T14:15:17.288Z 2025-12-05T14:25:17.640Z
8671041 8671041 20251201110738_JEVBW KR0028 2025-12-03T14:11:09.237Z 2025-12-05T14:24:03.988Z
8661340 8661340 20251130151000_iIODe KR0028 2025-12-02T14:11:07.479Z 2025-12-05T14:31:58.096Z
8661105 8661105 20251130144324_HHIyp KR0028 2025-12-02T14:10:24.698Z 2025-12-05T14:31:49.760Z
8660904 8660904 20251130141010_0lVAB KR0028 2025-12-02T14:09:38.315Z 2025-12-05T14:31:42.293Z
8659945 8659945 20251130113154_pnBWw KR0028 2025-12-02T14:05:53.526Z 2025-12-05T14:30:37.783Z
8650669 8650669 20251129210337_vhT1w KR0028 2025-12-01T14:16:51.724Z 2025-12-05T14:41:13.954Z
8650518 8650518 20251129203427_nb2Hp KR0028 2025-12-01T14:16:22.570Z 2025-12-05T14:41:09.474Z
8650513 8650513 20251129203343_IxDjH KR0028 2025-12-01T14:16:21.035Z 2025-12-05T14:41:09.304Z
8650369 8650369 20251129200219_koigX KR0028 2025-12-01T14:15:54.748Z 2025-12-05T14:41:05.077Z
8650163 8650163 20251129193255_DOHEJ KR0028 2025-12-01T14:15:16.425Z 2025-12-05T14:40:58.172Z
8649930 8649930 20251129185346_zq2vI KR0028 2025-12-01T14:14:28.912Z 2025-12-05T14:40:27.451Z
8649764 8649764 20251129182115_EWvao KR0028 2025-12-01T14:13:52.823Z 2025-12-05T14:40:19.059Z
8649749 8649749 20251129181744_MZSRf KR0028 2025-12-01T14:13:44.514Z 2025-12-05T14:40:18.728Z
8649568 8649568 20251129174813_Ih7V9 KR0028 2025-12-01T14:13:04.788Z 2025-12-05T14:40:13.138Z
8649509 8649509 20251129173720_Zmk26 KR0028 2025-12-01T14:12:52.449Z 2025-12-05T14:40:10.768Z
8649486 8649486 20251129173232_CwuCb KR0028 2025-12-01T14:12:49.054Z 2025-12-05T14:40:10.014Z
8649420 8649420 20251129172314_D30yC KR0028 2025-12-01T14:12:29.391Z 2025-12-05T14:40:07.640Z
8649302 8649302 20251129170026_9cvcP KR0028 2025-12-01T14:11:56.570Z 2025-12-05T14:40:03.692Z
8649286 8649286 20251129165935_j3Spg KR0028 2025-12-01T14:11:53.591Z 2025-12-05T14:40:03.262Z
8649264 8649264 20251129165319_Vns7P KR0028 2025-12-01T14:11:48.854Z 2025-12-05T14:40:02.713Z
8649079 8649079 20251129160236_aoxUO KR0028 2025-12-01T14:10:49.630Z 2025-12-05T14:39:33.926Z
8648823 8648823 20251129133227_3h5fY KR0028 2025-12-01T14:07:48.352Z 2025-12-05T14:39:08.300Z
8648780 8648780 20251129122734_2s9Lp KR0028 2025-12-01T14:06:15.241Z 2025-12-05T14:38:37.201Z
8648733 8648733 20251129110109_2cduQ KR0028 2025-12-01T14:03:55.453Z 2025-12-05T14:38:20.253Z
8648705 8648705 20251129095641_JF53I KR0028 2025-12-01T14:01:43.542Z 2025-12-05T14:37:46.087Z
8645298 8645298 20251128211419_tOk3v KR0028 2025-11-30T14:23:32.577Z 2025-12-05T14:50:36.156Z
8645165 8645165 20251128204521_XQR6e KR0028 2025-11-30T14:23:10.386Z 2025-12-05T14:50:32.497Z
8645150 8645150 20251128204353_cxPrr KR0028 2025-11-30T14:23:09.981Z 2025-12-05T14:50:32.409Z
8645108 8645108 20251128203739_U1cmB KR0028 2025-11-30T14:23:03.450Z 2025-12-05T14:50:31.798Z
8645087 8645087 20251128203458_yUTWO KR0028 2025-11-30T14:23:02.390Z 2025-12-05T14:50:31.573Z
8645076 8645076 20251128203454_iL5l6 KR0028 2025-11-30T14:23:02.192Z 2025-12-05T14:50:31.530Z
8645003 8645003 20251128202217_RKKoC KR0028 2025-11-30T14:22:56.747Z 2025-12-05T14:50:30.371Z
8644990 8644990 20251128202039_Chhfn KR0028 2025-11-30T14:22:56.128Z 2025-12-05T14:50:30.194Z
8644909 8644909 20251128201406_DhCRC KR0028 2025-11-30T14:22:51.563Z 2025-12-05T14:50:29.110Z
8644866 8644866 20251128200732_k8krq KR0028 2025-11-30T14:22:48.579Z 2025-12-05T14:50:28.403Z
8644779 8644779 20251128195649_k2mbp KR0028 2025-11-30T14:22:23.945Z 2025-12-05T14:50:26.847Z
8644740 8644740 20251128194935_0nT7U KR0028 2025-11-30T14:22:21.764Z 2025-12-05T14:50:26.347Z
8644299 8644299 20251128191843_Qyxto KR0028 2025-11-30T14:21:36.987Z 2025-12-05T14:50:19.789Z
8644196 8644196 20251128190629_SM0FH KR0028 2025-11-30T14:21:27.254Z 2025-12-05T14:50:17.852Z
8644188 8644188 20251128190549_5cLIw KR0028 2025-11-30T14:21:26.740Z 2025-12-05T14:50:17.674Z
8644147 8644147 20251128190332_NsANE KR0028 2025-11-30T14:21:24.361Z 2025-12-05T14:50:17.165Z
8643944 8643944 20251128184111_PVUxs KR0028 2025-11-30T14:20:52.113Z 2025-12-05T14:50:07.445Z
8643932 8643932 20251128183953_lY6W6 KR0028 2025-11-30T14:20:49.989Z 2025-12-05T14:50:06.953Z
8643902 8643902 20251128183744_DUr3m KR0028 2025-11-30T14:20:47.953Z 2025-12-05T14:50:01.381Z
8643794 8643794 20251128182749_oC0e5 KR0028 2025-11-30T14:20:41.183Z 2025-12-05T14:49:46.850Z
8643685 8643685 20251128181447_l9fUB KR0028 2025-11-30T14:20:33.286Z 2025-12-05T14:49:34.873Z
8643602 8643602 20251128180837_icNYv KR0028 2025-11-30T14:20:15.748Z 2025-12-05T14:49:30.033Z
8643573 8643573 20251128180705_K2WwD KR0028 2025-11-30T14:20:13.712Z 2025-12-05T14:49:27.680Z
8643056 8643056 20251128171608_2ubj3 KR0028 2025-11-30T14:19:16.567Z 2025-12-05T14:49:09.179Z
8642911 8642911 20251128170154_mz2Uv KR0028 2025-11-30T14:18:58.119Z 2025-12-05T14:49:06.803Z
8642902 8642902 20251128170142_xZm0X KR0028 2025-11-30T14:18:57.539Z 2025-12-05T14:49:06.703Z
8642810 8642810 20251128165135_q6Ok2 KR0028 2025-11-30T14:18:38.525Z 2025-12-05T14:49:05.231Z
8642609 8642609 20251128163113_B1Wpy KR0028 2025-11-30T14:18:21.670Z 2025-12-05T14:49:01.970Z
8642577 8642577 20251128162503_sMmIw KR0028 2025-11-30T14:18:19.329Z 2025-12-05T14:49:01.576Z
8642271 8642271 20251128154610_y6qaq KR0028 2025-11-30T14:17:43.171Z 2025-12-05T14:48:57.768Z
8642259 8642259 20251128154426_gZKU8 KR0028 2025-11-30T14:17:42.862Z 2025-12-05T14:48:57.711Z
8642040 8642040 20251128152723_I19BN KR0028 2025-11-30T14:17:16.469Z 2025-12-05T14:48:54.672Z
8641603 8641603 20251128150111_iRIev KR0028 2025-11-30T14:16:34.698Z 2025-12-05T14:48:46.665Z
8641569 8641569 20251128145928_HzW22 KR0028 2025-11-30T14:16:33.076Z 2025-12-05T14:48:46.225Z
8640940 8640940 20251128125108_8c0jd KR0028 2025-11-30T14:12:24.371Z 2025-12-05T14:47:44.232Z
8640892 8640892 20251128123659_wTfhQ KR0028 2025-11-30T14:11:55.219Z 2025-12-05T14:47:41.377Z
8632424 8632424 20251127210516_SIv82 KR0028 2025-11-29T14:17:27.928Z 2025-12-05T14:56:20.938Z
8631759 8631759 20251127195822_HXx6f KR0028 2025-11-29T14:16:21.628Z 2025-12-05T14:56:11.514Z
8631730 8631730 20251127195524_PkvQy KR0028 2025-11-29T14:16:17.837Z 2025-12-05T14:56:11.244Z
8631586 8631586 20251127192814_9Zx4G KR0028 2025-11-29T14:15:47.473Z 2025-12-05T14:56:08.891Z
8631500 8631500 20251127191801_8wnoE KR0028 2025-11-29T14:15:38.230Z 2025-12-05T14:56:07.495Z
8631431 8631431 20251127190638_vLWCE KR0028 2025-11-29T14:15:20.778Z 2025-12-05T14:56:06.554Z
8631339 8631339 20251127185140_o3MjN KR0028 2025-11-29T14:15:08.467Z 2025-12-05T14:56:05.356Z
8630716 8630716 20251127170923_ArmIu KR0028 2025-11-29T14:13:34.161Z 2025-12-05T14:55:50.632Z
8630309 8630309 20251127154241_RR7EJ KR0028 2025-11-29T14:12:15.522Z 2025-12-05T14:55:06.040Z
8630267 8630267 20251127153108_yomXQ KR0028 2025-11-29T14:12:11.831Z 2025-12-05T14:55:00.068Z
8630238 8630238 20251127152541_gQ0H6 KR0028 2025-11-29T14:12:09.216Z 2025-12-05T14:54:54.838Z
8630125 8630125 20251127143823_imJ88 KR0028 2025-11-29T14:11:42.755Z 2025-12-05T14:54:32.389Z
8622006 8622006 20251126172730_e3BlV KR0028 2025-11-28T14:17:16.506Z 2025-12-05T15:02:50.473Z
8621866 8621866 20251126164732_3qf9E KR0028 2025-11-28T14:16:54.912Z 2025-12-05T15:02:48.719Z
8621854 8621854 20251126164512_JubGO KR0028 2025-11-28T14:16:53.629Z 2025-12-05T15:02:48.633Z
8621825 8621825 20251126163835_2OPe1 KR0028 2025-11-28T14:16:49.850Z 2025-12-05T15:02:48.284Z
8621769 8621769 20251126162202_TR1dh KR0028 2025-11-28T14:16:31.465Z 2025-12-05T15:02:47.652Z
8621761 8621761 20251126162147_CbP03 KR0028 2025-11-28T14:16:31.254Z 2025-12-05T15:02:47.632Z
8621710 8621710 20251126161034_48zty KR0028 2025-11-28T14:16:25.685Z 2025-12-05T15:02:47.123Z
8621655 8621655 20251126155748_7NN4h KR0028 2025-11-28T14:16:19.806Z 2025-12-05T15:02:46.377Z
8621578 8621578 20251126154211_Ko7HV KR0028 2025-11-28T14:16:02.996Z 2025-12-05T15:02:45.470Z
8621525 8621525 20251126152829_EiDjH KR0028 2025-11-28T14:15:53.280Z 2025-12-05T15:02:44.975Z
8621266 8621266 20251126144809_pBfTl KR0028 2025-11-28T14:15:10.861Z 2025-12-05T15:02:42.493Z
8621046 8621046 20251126141951_C7Ew3 KR0028 2025-11-28T14:14:36.046Z 2025-12-05T15:02:39.974Z
8620788 8620788 20251126133139_R6kDH KR0028 2025-11-28T14:13:54.604Z 2025-12-05T15:02:37.359Z

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