鉄軌道業営業損益は、鉄軌道業営業収益(旅客収入・貨物収入・鉄道路線収入等)、鉄軌道業営業費(線路・電路・車両保存費・運転費・保守管理費等)、鉄道業営業損益、減価償却実施率に関する情報を有するデータです。(2,536レコード)
元の資料: 鉄道統計年報
G空間情報センターのデータセット links-tetsudoujigyou-2025 の 04_tetsudou_eigyousoneki.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.railway_operating_profit ( year BIGINT, corporation_name VARCHAR, jurisdiction VARCHAR, category VARCHAR, railway_operating_revenue_passenger_income_noncommuter_fare_thousand_yen DOUBLE, railway_operating_revenue_passenger_income_commuter_pass_thousand_yen DOUBLE, railway_operating_revenue_passenger_income_hand_baggage_etc_thousand_yen BIGINT, railway_operating_revenue_passenger_income_total_thousand_yen DOUBLE, railway_operating_revenue_passenger_income_total_percent DOUBLE, railway_operating_revenue_freight_income_thousand_yen BIGINT, railway_operating_revenue_freight_income_percent DOUBLE, railway_operating_revenue_track_income_total_thousand_yen BIGINT, railway_operating_revenue_track_income_total_percent DOUBLE, railway_operating_revenue_misc_transport_revenue_total_thousand_yen BIGINT, railway_operating_revenue_misc_transport_revenue_total_percent DOUBLE, railway_operating_revenue_total_total_thousand_yen DOUBLE, railway_operating_revenue_total_total_percent DOUBLE, railway_operating_expense_track_maintenance_personnel_thousand_yen DOUBLE, railway_operating_expense_track_maintenance_expense_thousand_yen DOUBLE, railway_operating_expense_track_maintenance_repair_thousand_yen DOUBLE, railway_operating_expense_track_maintenance_total_thousand_yen DOUBLE, railway_operating_expense_electric_line_maintenance_personnel_thousand_yen DOUBLE, railway_operating_expense_electric_line_maintenance_expense_thousand_yen DOUBLE, railway_operating_expense_electric_line_maintenance_repair_thousand_yen DOUBLE, railway_operating_expense_electric_line_maintenance_total_thousand_yen DOUBLE, railway_operating_expense_vehicle_maintenance_personnel_thousand_yen DOUBLE, railway_operating_expense_vehicle_maintenance_expense_thousand_yen DOUBLE, railway_operating_expense_vehicle_maintenance_repair_thousand_yen DOUBLE, railway_operating_expense_vehicle_maintenance_power_thousand_yen BIGINT, railway_operating_expense_vehicle_maintenance_total_thousand_yen DOUBLE, railway_operating_expense_operation_personnel_thousand_yen DOUBLE, railway_operating_expense_operation_expense_thousand_yen DOUBLE, railway_operating_expense_operation_power_thousand_yen DOUBLE, railway_operating_expense_operation_total_thousand_yen DOUBLE, railway_operating_expense_transport_personnel_thousand_yen DOUBLE, railway_operating_expense_transport_expense_thousand_yen DOUBLE, railway_operating_expense_transport_repair_thousand_yen DOUBLE, railway_operating_expense_transport_total_thousand_yen DOUBLE, railway_operating_expense_maintenance_management_personnel_thousand_yen DOUBLE, railway_operating_expense_maintenance_management_expense_thousand_yen DOUBLE, railway_operating_expense_maintenance_management_total_thousand_yen DOUBLE, railway_operating_expense_transport_management_personnel_thousand_yen DOUBLE, railway_operating_expense_transport_management_expense_thousand_yen DOUBLE, railway_operating_expense_transport_management_total_thousand_yen DOUBLE, railway_operating_expense_total_transport_cost_personnel_thousand_yen DOUBLE, railway_operating_expense_total_transport_cost_expense_thousand_yen DOUBLE, railway_operating_expense_total_transport_cost_repair_thousand_yen DOUBLE, railway_operating_expense_total_transport_cost_total_thousand_yen DOUBLE, railway_operating_expense_advertising_personnel_thousand_yen BIGINT, railway_operating_expense_advertising_expense_thousand_yen DOUBLE, railway_operating_expense_advertising_repair_thousand_yen BIGINT, railway_operating_expense_advertising_total_thousand_yen DOUBLE, railway_operating_expense_welfare_facility_personnel_thousand_yen BIGINT, railway_operating_expense_welfare_facility_expense_thousand_yen BIGINT, railway_operating_expense_welfare_facility_repair_thousand_yen BIGINT, railway_operating_expense_welfare_facility_total_thousand_yen BIGINT, railway_operating_expense_general_admin_personnel_thousand_yen BIGINT, railway_operating_expense_general_admin_expense_thousand_yen BIGINT, railway_operating_expense_general_admin_repair_thousand_yen BIGINT, railway_operating_expense_general_admin_total_thousand_yen BIGINT, railway_operating_expense_total_excl_tax_depr_personnel_thousand_yen DOUBLE, railway_operating_expense_total_excl_tax_depr_personnel_percent DOUBLE, railway_operating_expense_total_excl_tax_depr_expense_thousand_yen DOUBLE, railway_operating_expense_total_excl_tax_depr_expense_percent DOUBLE, railway_operating_expense_total_excl_tax_depr_repair_thousand_yen DOUBLE, railway_operating_expense_total_excl_tax_depr_repair_percent DOUBLE, railway_operating_expense_total_excl_tax_depr_power_thousand_yen DOUBLE, railway_operating_expense_total_excl_tax_depr_power_percent DOUBLE, railway_operating_expense_total_excl_tax_depr_total_thousand_yen DOUBLE, railway_operating_expense_total_excl_tax_depr_total_percent DOUBLE, railway_operating_expense_tax_national_thousand_yen DOUBLE, railway_operating_expense_tax_local_thousand_yen DOUBLE, railway_operating_expense_tax_other_thousand_yen BIGINT, railway_operating_expense_tax_total_thousand_yen DOUBLE, railway_operating_expense_depreciation_tangible_assets_thousand_yen DOUBLE, railway_operating_expense_depreciation_intangible_assets_thousand_yen DOUBLE, railway_operating_expense_depreciation_total_thousand_yen DOUBLE, railway_operating_expense_pre_welfare_income_personnel_thousand_yen DOUBLE, railway_operating_expense_pre_welfare_income_personnel_percent DOUBLE, railway_operating_expense_pre_welfare_income_expense_thousand_yen DOUBLE, railway_operating_expense_pre_welfare_income_expense_percent DOUBLE, railway_operating_expense_pre_welfare_income_total_thousand_yen DOUBLE, railway_operating_expense_pre_welfare_income_total_percent DOUBLE, railway_operating_expense_welfare_income_total_thousand_yen BIGINT, railway_operating_expense_net_operating_expense_total_thousand_yen DOUBLE, railway_operating_profit_loss_thousand_yen DOUBLE, operating_ratio_pre_depr_percent DOUBLE, operating_ratio_post_depr_percent DOUBLE, railway_fixed_assets_operating_profit_ratio_percent DOUBLE, current_depreciation_range_thousand_yen DOUBLE, depreciation_implementation_ratio_percent DOUBLE, total_car_km_km DOUBLE, operating_revenue_per_car_km_yen DOUBLE, operating_expense_per_car_km_yen DOUBLE, source_sha256 VARCHAR );