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,876 rows where station_code = "KR0039" 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
8686954 8686954 20251203212158_lgSRj KR0039 2025-12-05T14:13:14.912Z 2025-12-05T14:14:35.529Z
8686778 8686778 20251203204856_eRLgS KR0039 2025-12-05T14:12:48.342Z 2025-12-05T14:14:35.487Z
8686672 8686672 20251203202842_kKZYI KR0039 2025-12-05T14:12:34.909Z 2025-12-05T14:14:35.454Z
8686641 8686641 20251203202355_hZp2d KR0039 2025-12-05T14:12:32.144Z 2025-12-05T14:14:35.446Z
8686487 8686487 20251203195551_qNNUf KR0039 2025-12-05T14:12:02.741Z 2025-12-05T14:14:35.405Z
8686215 8686215 20251203190624_bCWzh KR0039 2025-12-05T14:11:14.727Z 2025-12-05T14:14:35.324Z
8685826 8685826 20251203170249_QkiDZ KR0039 2025-12-05T14:10:05.075Z 2025-12-05T14:14:35.231Z
8685737 8685737 20251203162517_OeHj0 KR0039 2025-12-05T14:09:49.649Z 2025-12-05T14:14:35.195Z
8685725 8685725 20251203161954_V6R9e KR0039 2025-12-05T14:09:47.212Z 2025-12-05T14:14:35.191Z
8685660 8685660 20251203154712_85FJb KR0039 2025-12-05T14:09:30.774Z 2025-12-05T14:14:35.168Z
8685593 8685593 20251203151925_TOhOQ KR0039 2025-12-05T14:09:17.343Z 2025-12-05T14:14:35.139Z
8685590 8685590 20251203151811_VIoHz KR0039 2025-12-05T14:09:16.731Z 2025-12-05T14:14:35.138Z
8679222 8679222 20251202192754_4P2Jk KR0039 2025-12-04T14:09:14.874Z 2025-12-05T14:19:32.200Z
8679193 8679193 20251202192157_x24aM KR0039 2025-12-04T14:09:11.828Z 2025-12-05T14:19:31.223Z
8679124 8679124 20251202190112_YAlqU KR0039 2025-12-04T14:09:00.706Z 2025-12-05T14:19:27.710Z
8679050 8679050 20251202184607_uK41e KR0039 2025-12-04T14:08:50.606Z 2025-12-05T14:19:18.258Z
8678931 8678931 20251202181750_5rb0L KR0039 2025-12-04T14:08:33.073Z 2025-12-05T14:19:11.178Z
8678913 8678913 20251202181118_6pU6E KR0039 2025-12-04T14:08:31.394Z 2025-12-05T14:19:10.090Z
8678872 8678872 20251202175811_lv3ZT KR0039 2025-12-04T14:08:23.338Z 2025-12-05T14:19:06.404Z
8678785 8678785 20251202172706_AyWZb KR0039 2025-12-04T14:08:10.740Z 2025-12-05T14:18:59.861Z
8678744 8678744 20251202171601_XGfuV KR0039 2025-12-04T14:08:02.434Z 2025-12-05T14:18:57.383Z
8673714 8673714 20251201212449_EeAPu KR0039 2025-12-03T14:19:46.253Z 2025-12-05T14:27:01.534Z
8673673 8673673 20251201210544_NCjH9 KR0039 2025-12-03T14:19:43.255Z 2025-12-05T14:26:58.194Z
8673654 8673654 20251201205321_JBxoH KR0039 2025-12-03T14:19:41.015Z 2025-12-05T14:26:57.509Z
8673576 8673576 20251201200915_BtdCA KR0039 2025-12-03T14:19:21.458Z 2025-12-05T14:26:53.578Z
8673511 8673511 20251201194420_qYPpY KR0039 2025-12-03T14:19:03.701Z 2025-12-05T14:26:49.526Z
8672947 8672947 20251201154527_hi3rn KR0039 2025-12-03T14:16:59.006Z 2025-12-05T14:25:48.018Z
8672827 8672827 20251201152604_yf3fO KR0039 2025-12-03T14:16:38.159Z 2025-12-05T14:25:42.974Z
8672796 8672796 20251201151939_hQFBr KR0039 2025-12-03T14:16:29.878Z 2025-12-05T14:25:42.279Z
8672241 8672241 20251201140759_EZ0ol KR0039 2025-12-03T14:15:09.320Z 2025-12-05T14:25:15.020Z
8671147 8671147 20251201112456_h2Z9L KR0039 2025-12-03T14:11:26.431Z 2025-12-05T14:24:15.391Z
8663417 8663417 20251130204403_rcjNe KR0039 2025-12-02T14:18:15.577Z 2025-12-05T14:34:07.057Z
8663286 8663286 20251130202630_nscMp KR0039 2025-12-02T14:17:55.617Z 2025-12-05T14:34:03.834Z
8663158 8663158 20251130201653_m0NeJ KR0039 2025-12-02T14:17:33.617Z 2025-12-05T14:33:58.681Z
8663137 8663137 20251130201459_1NWAN KR0039 2025-12-02T14:17:30.738Z 2025-12-05T14:33:58.053Z
8663122 8663122 20251130201304_CH3yT KR0039 2025-12-02T14:17:29.496Z 2025-12-05T14:33:57.746Z
8663054 8663054 20251130200025_qUIMD KR0039 2025-12-02T14:17:21.162Z 2025-12-05T14:33:55.700Z
8662946 8662946 20251130194938_VnyLR KR0039 2025-12-02T14:17:05.387Z 2025-12-05T14:33:53.358Z
8662837 8662837 20251130193754_b5C7p KR0039 2025-12-02T14:16:49.911Z 2025-12-05T14:33:49.565Z
8662766 8662766 20251130192853_KT4Md KR0039 2025-12-02T14:16:31.326Z 2025-12-05T14:33:47.347Z
8662760 8662760 20251130192802_dmEic KR0039 2025-12-02T14:16:29.999Z 2025-12-05T14:33:47.072Z
8662588 8662588 20251130191159_nF4ZS KR0039 2025-12-02T14:15:56.488Z 2025-12-05T14:33:32.600Z
8662559 8662559 20251130191052_WtIhp KR0039 2025-12-02T14:15:53.260Z 2025-12-05T14:33:28.839Z
8661760 8661760 20251130170743_sgM6U KR0039 2025-12-02T14:12:57.207Z 2025-12-05T14:32:34.717Z
8648650 8648650 20251127211837_Ynm7y KR0039 2025-11-30T14:35:16.772Z 2025-12-05T14:56:22.767Z
8645270 8645270 20251128211020_DS2AE KR0039 2025-11-30T14:23:30.546Z 2025-12-05T14:50:35.627Z
8642844 8642844 20251128165411_NohH2 KR0039 2025-11-30T14:18:42.828Z 2025-12-05T14:49:05.544Z
8642781 8642781 20251128164749_vBT82 KR0039 2025-11-30T14:18:36.717Z 2025-12-05T14:49:04.891Z
8642690 8642690 20251128163859_weRst KR0039 2025-11-30T14:18:28.976Z 2025-12-05T14:49:03.248Z
8642632 8642632 20251128163220_BbWcZ KR0039 2025-11-30T14:18:23.187Z 2025-12-05T14:49:02.216Z
8642624 8642624 20251128163219_eg48j KR0039 2025-11-30T14:18:22.968Z 2025-12-05T14:49:02.125Z
8642411 8642411 20251128160122_asoh9 KR0039 2025-11-30T14:17:53.312Z 2025-12-05T14:48:59.438Z
8642227 8642227 20251128154014_ej8Tu KR0039 2025-11-30T14:17:41.758Z 2025-12-05T14:48:57.478Z
8642168 8642168 20251128153600_E67zf KR0039 2025-11-30T14:17:38.005Z 2025-12-05T14:48:56.609Z
8642046 8642046 20251128152732_c64EQ KR0039 2025-11-30T14:17:17.095Z 2025-12-05T14:48:54.800Z
8642024 8642024 20251128152545_skP8p KR0039 2025-11-30T14:17:15.366Z 2025-12-05T14:48:54.403Z
8641987 8641987 20251128152348_hol8r KR0039 2025-11-30T14:17:13.195Z 2025-12-05T14:48:53.920Z
8641966 8641966 20251128152157_RTfoT KR0039 2025-11-30T14:17:11.938Z 2025-12-05T14:48:53.673Z
8641930 8641930 20251128152036_uDx6Q KR0039 2025-11-30T14:17:09.958Z 2025-12-05T14:48:53.326Z
8641905 8641905 20251128151944_ShJmS KR0039 2025-11-30T14:17:08.396Z 2025-12-05T14:48:53.078Z
8641634 8641634 20251128150333_4w9jt KR0039 2025-11-30T14:16:36.344Z 2025-12-05T14:48:48.706Z
8641389 8641389 20251128144154_KgcoH KR0039 2025-11-30T14:15:59.481Z 2025-12-05T14:48:23.894Z
8641361 8641361 20251128143616_CIBEC KR0039 2025-11-30T14:15:47.830Z 2025-12-05T14:48:15.244Z
8641292 8641292 20251128142212_zA0es KR0039 2025-11-30T14:15:25.913Z 2025-12-05T14:48:07.740Z
8641253 8641253 20251128141608_arzEe KR0039 2025-11-30T14:15:11.097Z 2025-12-05T14:48:05.960Z
8641248 8641248 20251128141449_lOED7 KR0039 2025-11-30T14:15:10.210Z 2025-12-05T14:48:05.848Z
8641088 8641088 20251128134413_9HQbh KR0039 2025-11-30T14:14:11.855Z 2025-12-05T14:47:55.579Z
8641068 8641068 20251128133935_FsKnq KR0039 2025-11-30T14:14:03.812Z 2025-12-05T14:47:54.653Z
8632558 8632558 20251127211837_J3ROC KR0039 2025-11-29T14:17:47.234Z 2025-12-05T14:56:22.700Z
8632547 8632547 20251127211750_1RuQ1 KR0039 2025-11-29T14:17:46.912Z 2025-12-05T14:56:22.670Z
8632543 8632543 20251127211750_MmXw2 KR0039 2025-11-29T14:17:46.705Z 2025-12-05T14:56:22.597Z
8632521 8632521 20251127211717_w82wF KR0039 2025-11-29T14:17:45.459Z 2025-12-05T14:56:22.337Z
8631204 8631204 20251127183541_g6Ch6 KR0039 2025-11-29T14:14:55.822Z 2025-12-05T14:56:03.556Z
8631194 8631194 20251127183354_7nR5B KR0039 2025-11-29T14:14:54.662Z 2025-12-05T14:56:03.437Z
8630982 8630982 20251127175917_Tywtj KR0039 2025-11-29T14:14:15.262Z 2025-12-05T14:56:00.109Z
8630821 8630821 20251127173305_F3DD4 KR0039 2025-11-29T14:13:49.672Z 2025-12-05T14:55:57.552Z
8630743 8630743 20251127171218_KF2wk KR0039 2025-11-29T14:13:38.823Z 2025-12-05T14:55:51.975Z
8630662 8630662 20251127170144_FzxD7 KR0039 2025-11-29T14:13:25.521Z 2025-12-05T14:55:44.403Z
8630658 8630658 20251127170143_1WYaQ KR0039 2025-11-29T14:13:25.141Z 2025-12-05T14:55:44.281Z
8630119 8630119 20251127143240_Ixv5A KR0039 2025-11-29T14:11:40.750Z 2025-12-05T14:54:30.877Z
8621784 8621784 20251126162432_u7LFW KR0039 2025-11-28T14:16:35.874Z 2025-12-05T15:02:47.803Z
8621734 8621734 20251126161644_122pJ KR0039 2025-11-28T14:16:29.270Z 2025-12-05T15:02:47.436Z
8621696 8621696 20251126160539_DdosK KR0039 2025-11-28T14:16:24.106Z 2025-12-05T15:02:46.923Z
8621605 8621605 20251126154604_3cjrc KR0039 2025-11-28T14:16:14.574Z 2025-12-05T15:02:45.835Z
8621593 8621593 20251126154538_QvCUw KR0039 2025-11-28T14:16:13.554Z 2025-12-05T15:02:45.757Z
8621441 8621441 20251126151143_lJgcy KR0039 2025-11-28T14:15:43.293Z 2025-12-05T15:02:44.314Z
8621236 8621236 20251126144634_rMtlE KR0039 2025-11-28T14:15:08.821Z 2025-12-05T15:02:42.280Z
8621154 8621154 20251126143611_77Jh1 KR0039 2025-11-28T14:14:58.954Z 2025-12-05T15:02:41.488Z
8621147 8621147 20251126143546_va26l KR0039 2025-11-28T14:14:58.383Z 2025-12-05T15:02:41.411Z
8621125 8621125 20251126143108_yceV0 KR0039 2025-11-28T14:14:55.482Z 2025-12-05T15:02:41.049Z
8620592 8620592 20251126130217_MtNp1 KR0039 2025-11-28T14:13:17.917Z 2025-12-05T15:02:21.617Z
8620580 8620580 20251126130121_MiSv2 KR0039 2025-11-28T14:13:16.267Z 2025-12-05T15:02:20.209Z
8620445 8620445 20251126123559_fgK7M KR0039 2025-11-28T14:12:46.306Z 2025-12-05T15:02:04.907Z
8619680 8619680 20251126104550_arbW6 KR0039 2025-11-28T14:09:56.710Z 2025-12-05T15:01:04.508Z
8596059 8596059 20251124193231_fU9bN KR0039 2025-11-26T14:13:26.802Z 2025-12-02T15:06:29.075Z
8595982 8595982 20251124192121_38jql KR0039 2025-11-26T14:13:15.650Z 2025-12-02T15:06:24.663Z
8595875 8595875 20251124185435_SD5fR KR0039 2025-11-26T14:12:50.759Z 2025-12-02T15:06:20.502Z
8595598 8595598 20251124170946_PVbaH KR0039 2025-11-26T14:11:43.741Z 2025-12-02T15:06:02.177Z
8595592 8595592 20251124170720_12ByK KR0039 2025-11-26T14:11:42.717Z 2025-12-02T15:06:02.077Z
8595451 8595451 20251124155543_5zvzQ KR0039 2025-11-26T14:11:06.742Z 2025-12-02T15:05:57.050Z

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