営業キロ及び走行キロは、年度末営業キロ(旅客・貨物)、自己・他鉄道車両自線走行キロ(機関車・旅客車・貨物車・特殊車)、自己車両他線走行キロ(機関車・旅客車・貨物車・特殊車)に関する情報を有するデータです。(3,865レコード)
元の資料: 鉄道統計年報
G空間情報センターのデータセット links-tetsudoujigyou-2025 の 03_tetsudou_eigyoukiro.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.railway_operating_kilometers ( year BIGINT, corporation_name VARCHAR, jurisdiction VARCHAR, category VARCHAR, fiscal_year_total_operating_kilometers_passenger DOUBLE, fiscal_year_total_operating_kilometers_cargo DOUBLE, own_cars_own_line_running_kilometers_cars_locomotive_electric BIGINT, own_cars_own_line_running_kilometers_cars_locomotive_internal_combustion BIGINT, own_cars_own_line_running_kilometers_cars_locomotive_steam BIGINT, own_cars_own_line_running_kilometers_cars_locomotive_other BIGINT, own_cars_own_line_running_kilometers_cars_passenger_electric BIGINT, own_cars_own_line_running_kilometers_cars_passenger_internal_combustion BIGINT, own_cars_own_line_running_kilometers_cars_passenger_passenger BIGINT, own_cars_own_line_running_kilometers_cars_passenger_other BIGINT, own_cars_own_line_running_kilometers_cars_freight BIGINT, own_cars_own_line_running_kilometers_cars_special BIGINT, own_cars_own_line_running_kilometers_cars_total BIGINT, other_cars_own_line_running_kilometers_cars_locomotive_electric BIGINT, other_cars_own_line_running_kilometers_cars_locomotive_internal_combustion BIGINT, other_cars_own_line_running_kilometers_cars_locomotive_steam BIGINT, other_cars_own_line_running_kilometers_cars_locomotive_other BIGINT, other_cars_own_line_running_kilometers_cars_passenger_electric BIGINT, other_cars_own_line_running_kilometers_cars_passenger_internal_combustion BIGINT, other_cars_own_line_running_kilometers_cars_passenger_passenger BIGINT, other_cars_own_line_running_kilometers_cars_passenger_other BIGINT, other_cars_own_line_running_kilometers_cars_freight BIGINT, other_cars_own_line_running_kilometers_cars_special BIGINT, other_cars_own_line_running_kilometers_cars_total BIGINT, total_train_passenger BIGINT, total_train_freight BIGINT, total_train_mix BIGINT, total_train_total BIGINT, total_cars_locomotive_electric BIGINT, total_cars_locomotive_internal_combustion BIGINT, total_cars_locomotive_vaipor BIGINT, total_cars_locomotive_other BIGINT, total_cars_passenger_electric BIGINT, total_cars_passenger_internal_combustion BIGINT, total_cars_passenger_passenger BIGINT, total_cars_passenger_other BIGINT, total_cars_freight BIGINT, total_cars_special BIGINT, total_cars_total BIGINT, own_cars_other_line_running_kilometers_cars_locomotive_electric BIGINT, own_cars_other_line_running_kilometers_cars_locomotive_internal_combustion BIGINT, own_cars_other_line_running_kilometers_cars_locomotive_steam BIGINT, own_cars_other_line_running_kilometers_cars_locomotive_other BIGINT, own_cars_other_line_running_kilometers_cars_passenger_electric BIGINT, own_cars_other_line_running_kilometers_cars_passenger_internal_combustion BIGINT, own_cars_other_line_running_kilometers_cars_passenger_passenger BIGINT, own_cars_other_line_running_kilometers_cars_passenger_other BIGINT, own_cars_other_line_running_kilometers_cars_freight BIGINT, own_cars_other_line_running_kilometers_cars_special BIGINT, own_cars_other_line_running_kilometers_cars_total BIGINT, source_sha256 VARCHAR );