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

6,732 rows where station_code = "KR000P" 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
8686931 8686931 20251203211705_Eejpb KR000P 2025-12-05T14:13:12.763Z 2025-12-06T14:22:12.254Z
8686832 8686832 20251203205921_MjUVd KR000P 2025-12-05T14:12:53.475Z 2025-12-06T14:22:09.493Z
8686759 8686759 20251203204457_rwSTd KR000P 2025-12-05T14:12:42.870Z 2025-12-06T14:22:05.188Z
8686749 8686749 20251203204301_gsMp6 KR000P 2025-12-05T14:12:42.319Z 2025-12-06T14:22:04.915Z
8686715 8686715 20251203203934_Fyv8Q KR000P 2025-12-05T14:12:40.316Z 2025-12-06T14:22:03.650Z
8686698 8686698 20251203203604_OHk28 KR000P 2025-12-05T14:12:38.290Z 2025-12-06T14:22:02.561Z
8686679 8686679 20251203203009_wLQ0T KR000P 2025-12-05T14:12:35.926Z 2025-12-06T14:22:01.674Z
8686653 8686653 20251203202540_kvpNe KR000P 2025-12-05T14:12:33.621Z 2025-12-06T14:22:01.036Z
8685408 8685408 20251203120052_m0mCV KR000P 2025-12-05T14:07:57.829Z 2025-12-06T14:19:59.187Z
8680058 8680058 20251202212805_0Cti5 KR000P 2025-12-04T14:11:00.275Z 2025-12-06T14:26:49.364Z
8680047 8680047 20251202212717_SkbvP KR000P 2025-12-04T14:10:59.020Z 2025-12-06T14:26:48.934Z
8680043 8680043 20251202212418_BzBgB KR000P 2025-12-04T14:10:58.183Z 2025-12-06T14:26:48.576Z
8680023 8680023 20251202211855_d4FcF KR000P 2025-12-04T14:10:55.009Z 2025-12-06T14:26:47.703Z
8679926 8679926 20251202211128_dzH0l KR000P 2025-12-04T14:10:47.090Z 2025-12-06T14:26:44.512Z
8679909 8679909 20251202211052_IeXUS KR000P 2025-12-04T14:10:45.835Z 2025-12-06T14:26:43.662Z
8679899 8679899 20251202210657_20izf KR000P 2025-12-04T14:10:37.812Z 2025-12-06T14:26:42.958Z
8679857 8679857 20251202210257_smYH9 KR000P 2025-12-04T14:10:34.199Z 2025-12-06T14:26:41.484Z
8679842 8679842 20251202210049_Yezcx KR000P 2025-12-04T14:10:30.409Z 2025-12-06T14:26:41.071Z
8679746 8679746 20251202204654_IR28D KR000P 2025-12-04T14:10:21.906Z 2025-12-06T14:26:38.453Z
8679743 8679743 20251202204519_Hy2XJ KR000P 2025-12-04T14:10:21.415Z 2025-12-06T14:26:38.347Z
8679586 8679586 20251202202530_bbP4b KR000P 2025-12-04T14:10:03.382Z 2025-12-06T14:26:27.816Z
8679564 8679564 20251202202137_4VGjt KR000P 2025-12-04T14:09:58.234Z 2025-12-06T14:26:26.775Z
8679535 8679535 20251202201939_HT871 KR000P 2025-12-04T14:09:56.585Z 2025-12-06T14:26:25.973Z
8679515 8679515 20251202201925_iWOSD KR000P 2025-12-04T14:09:55.646Z 2025-12-06T14:26:25.200Z
8679488 8679488 20251202201618_6vyBb KR000P 2025-12-04T14:09:53.549Z 2025-12-06T14:26:22.629Z
8679408 8679408 20251202200316_yo9Pz KR000P 2025-12-04T14:09:45.157Z 2025-12-06T14:26:18.743Z
8679365 8679365 20251202195249_LhP7r KR000P 2025-12-04T14:09:39.382Z 2025-12-06T14:26:16.105Z
8679302 8679302 20251202194037_3oAI9 KR000P 2025-12-04T14:09:23.171Z 2025-12-06T14:26:11.128Z
8679291 8679291 20251202193808_K3bNn KR000P 2025-12-04T14:09:21.792Z 2025-12-06T14:26:10.769Z
8679239 8679239 20251202192834_Dbdpz KR000P 2025-12-04T14:09:17.292Z 2025-12-06T14:26:08.513Z
8679114 8679114 20251202185602_v0l2L KR000P 2025-12-04T14:08:59.338Z 2025-12-06T14:25:55.534Z
8679057 8679057 20251202184857_vc6d3 KR000P 2025-12-04T14:08:51.561Z 2025-12-06T14:25:52.175Z
8678397 8678397 20251202122418_n2BiO KR000P 2025-12-04T14:06:33.167Z 2025-12-06T14:24:25.721Z
8678386 8678386 20251202120739_343nM KR000P 2025-12-04T14:06:18.902Z 2025-12-06T14:24:18.411Z
8678360 8678360 20251202104859_B2OiG KR000P 2025-12-04T14:05:38.313Z 2025-12-06T14:23:48.261Z
8673718 8673718 20251201212551_Sl8kW KR000P 2025-12-03T14:19:46.525Z 2025-12-06T14:33:29.459Z
8673638 8673638 20251201205042_O5QTU KR000P 2025-12-03T14:19:33.738Z 2025-12-06T14:33:26.419Z
8673632 8673632 20251201204746_TvE9i KR000P 2025-12-03T14:19:29.876Z 2025-12-06T14:33:26.103Z
8673584 8673584 20251201201537_s2I5G KR000P 2025-12-03T14:19:23.458Z 2025-12-06T14:33:24.162Z
8673554 8673554 20251201200207_ZonzB KR000P 2025-12-03T14:19:15.540Z 2025-12-06T14:33:22.534Z
8673545 8673545 20251201200111_SmGSd KR000P 2025-12-03T14:19:10.752Z 2025-12-06T14:33:22.300Z
8670922 8670922 20251201104653_shCYM KR000P 2025-12-03T14:10:44.210Z 2025-12-06T14:30:36.683Z
8670744 8670744 20251201100645_gJUnc KR000P 2025-12-03T14:09:58.957Z 2025-12-06T14:30:20.277Z
8670603 8670603 20251201094029_hOwoh KR000P 2025-12-03T14:09:29.398Z 2025-12-06T14:30:11.435Z
8663619 8663619 20251130211050_g77yF KR000P 2025-12-02T14:18:36.595Z 2025-12-06T14:40:05.122Z
8663488 8663488 20251130204942_MiWI3 KR000P 2025-12-02T14:18:22.072Z 2025-12-06T14:40:01.615Z
8663456 8663456 20251130204818_SC295 KR000P 2025-12-02T14:18:19.502Z 2025-12-06T14:40:01.118Z
8663454 8663454 20251130204812_DkWxO KR000P 2025-12-02T14:18:19.019Z 2025-12-06T14:40:01.010Z
8663344 8663344 20251130203619_bRxZj KR000P 2025-12-02T14:18:01.426Z 2025-12-06T14:39:58.734Z
8663200 8663200 20251130202039_rRP0N KR000P 2025-12-02T14:17:40.591Z 2025-12-06T14:39:55.952Z
8663188 8663188 20251130202019_LP25K KR000P 2025-12-02T14:17:37.680Z 2025-12-06T14:39:55.816Z
8663048 8663048 20251130200016_EHTU9 KR000P 2025-12-02T14:17:20.814Z 2025-12-06T14:39:45.020Z
8662873 8662873 20251130194241_dApIu KR000P 2025-12-02T14:16:54.354Z 2025-12-06T14:39:33.988Z
8662864 8662864 20251130194202_fAuJN KR000P 2025-12-02T14:16:53.780Z 2025-12-06T14:39:33.851Z
8662740 8662740 20251130192538_p0hjg KR000P 2025-12-02T14:16:26.931Z 2025-12-06T14:39:27.727Z
8662250 8662250 20251130182319_Wp1ah KR000P 2025-12-02T14:14:50.636Z 2025-12-06T14:38:57.166Z
8662212 8662212 20251130181841_YC9e6 KR000P 2025-12-02T14:14:43.174Z 2025-12-06T14:38:56.194Z
8662161 8662161 20251130180853_rbeHY KR000P 2025-12-02T14:14:33.932Z 2025-12-06T14:38:52.198Z
8662107 8662107 20251130175831_eC0OR KR000P 2025-12-02T14:14:20.342Z 2025-12-06T14:38:50.305Z
8661996 8661996 20251130174108_xUMcI KR000P 2025-12-02T14:13:55.661Z 2025-12-06T14:38:45.763Z
8645049 8645049 20251128203157_S9I3L KR000P 2025-11-30T14:23:01.018Z 2025-12-06T14:54:50.388Z
8644981 8644981 20251128202029_kUENa KR000P 2025-11-30T14:22:55.556Z 2025-12-06T14:54:49.615Z
8644976 8644976 20251128202023_Qulkr KR000P 2025-11-30T14:22:55.390Z 2025-12-06T14:54:49.550Z
8644796 8644796 20251128195852_7DrIC KR000P 2025-11-30T14:22:39.928Z 2025-12-06T14:54:47.462Z
8644789 8644789 20251128195744_pLMbH KR000P 2025-11-30T14:22:33.601Z 2025-12-06T14:54:47.359Z
8644695 8644695 20251128194521_L3tAV KR000P 2025-11-30T14:22:15.403Z 2025-12-06T14:54:46.224Z
8644686 8644686 20251128194515_IiMiS KR000P 2025-11-30T14:22:14.818Z 2025-12-06T14:54:46.141Z
8644465 8644465 20251128192806_ruzoM KR000P 2025-11-30T14:22:01.157Z 2025-12-06T14:54:42.610Z
8644326 8644326 20251128192027_llAF7 KR000P 2025-11-30T14:21:39.551Z 2025-12-06T14:54:40.859Z
8644202 8644202 20251128190716_NIwnK KR000P 2025-11-30T14:21:27.717Z 2025-12-06T14:54:39.215Z
8644014 8644014 20251128185007_r362v KR000P 2025-11-30T14:21:11.815Z 2025-12-06T14:54:36.933Z
8643811 8643811 20251128182845_daYCF KR000P 2025-11-30T14:20:42.603Z 2025-12-06T14:54:19.350Z
8643617 8643617 20251128180917_Hfee4 KR000P 2025-11-30T14:20:22.652Z 2025-12-06T14:53:56.878Z
8643331 8643331 20251128174355_nhcnu KR000P 2025-11-30T14:19:54.220Z 2025-12-06T14:53:47.833Z
8643088 8643088 20251128172033_HAxIu KR000P 2025-11-30T14:19:19.231Z 2025-12-06T14:53:40.477Z
8643042 8643042 20251128171527_7Xmyg KR000P 2025-11-30T14:19:15.953Z 2025-12-06T14:53:39.773Z
8643023 8643023 20251128171247_KYTtj KR000P 2025-11-30T14:19:13.937Z 2025-12-06T14:53:39.485Z
8642917 8642917 20251128170218_IbISn KR000P 2025-11-30T14:18:59.073Z 2025-12-06T14:53:37.836Z
8642818 8642818 20251128165346_22ktm KR000P 2025-11-30T14:18:41.692Z 2025-12-06T14:53:36.730Z
8642561 8642561 20251128162403_UP7SE KR000P 2025-11-30T14:18:18.915Z 2025-12-06T14:53:33.649Z
8642507 8642507 20251128161411_NGQoZ KR000P 2025-11-30T14:18:03.673Z 2025-12-06T14:53:32.995Z
8642493 8642493 20251128161306_1yFQx KR000P 2025-11-30T14:18:02.884Z 2025-12-06T14:53:32.759Z
8642428 8642428 20251128160318_iK3yG KR000P 2025-11-30T14:17:53.989Z 2025-12-06T14:53:31.487Z
8642373 8642373 20251128155905_DgRg0 KR000P 2025-11-30T14:17:50.880Z 2025-12-06T14:53:30.806Z
8641671 8641671 20251128150659_2k8D8 KR000P 2025-11-30T14:16:40.330Z 2025-12-06T14:52:44.451Z
8641345 8641345 20251128143526_lqMID KR000P 2025-11-30T14:15:47.249Z 2025-12-06T14:52:32.228Z
8641171 8641171 20251128140242_tmiyC KR000P 2025-11-30T14:14:47.538Z 2025-12-06T14:52:26.852Z
8641146 8641146 20251128135608_O9DbJ KR000P 2025-11-30T14:14:35.019Z 2025-12-06T14:52:25.397Z
8641043 8641043 20251128132316_Pl7Uc KR000P 2025-11-30T14:13:49.297Z 2025-12-06T14:52:19.878Z
8640979 8640979 20251128130942_VsRh3 KR000P 2025-11-30T14:13:11.548Z 2025-12-06T14:52:17.740Z
8640927 8640927 20251128124756_8s9D3 KR000P 2025-11-30T14:12:21.282Z 2025-12-06T14:51:51.704Z
8640904 8640904 20251128124308_fLDDD KR000P 2025-11-30T14:12:03.366Z 2025-12-06T14:51:44.734Z
8640843 8640843 20251128120043_q3o2Y KR000P 2025-11-30T14:11:10.216Z 2025-12-06T14:51:30.600Z
8640821 8640821 20251128115245_MluF0 KR000P 2025-11-30T14:11:06.841Z 2025-12-06T14:51:27.801Z
8640812 8640812 20251128113954_w9R6R KR000P 2025-11-30T14:11:00.008Z 2025-12-06T14:51:25.559Z
8632517 8632517 20251127211644_lS2py KR000P 2025-11-29T14:17:45.186Z 2025-12-06T15:01:24.095Z
8632481 8632481 20251127211154_lzR99 KR000P 2025-11-29T14:17:42.935Z 2025-12-06T15:01:20.404Z
8632277 8632277 20251127204510_nGMQM KR000P 2025-11-29T14:17:12.125Z 2025-12-06T15:01:07.360Z
8632255 8632255 20251127204427_osrgo KR000P 2025-11-29T14:17:11.415Z 2025-12-06T15:01:07.012Z
8632107 8632107 20251127203256_O7tRq KR000P 2025-11-29T14:17:00.796Z 2025-12-06T15:00:53.153Z

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