貸借対照表は、流動資産、固定資産、繰延資産、資産合計、流動負債、固定負債、引当金、負債合計、資本金、法定余剰金、利益余剰金、資本合計に関する情報を有するデータです。(2,308レコード)
元の資料: 鉄道統計年報
G空間情報センターのデータセット links-tetsudoujigyou-2025 の 06_tetsudou_taisyakutaisyouhyou.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.railway_balance_sheet ( year BIGINT, operator_name VARCHAR, jurisdiction VARCHAR, category VARCHAR, current_assets_quick_assets_cash_and_deposits DOUBLE, current_assets_quick_assets_trade_receivables DOUBLE, current_assets_quick_assets_securities BIGINT, current_assets_quick_assets_total DOUBLE, current_assets_inventories_supplies DOUBLE, current_assets_inventories_land_and_buildings_held_for_sale BIGINT, current_assets_inventories_others BIGINT, current_assets_inventories_total DOUBLE, current_assets_others DOUBLE, current_assets_allowance_for_doubtful_accounts DOUBLE, current_assets_total DOUBLE, current_assets_total_percent DOUBLE, non_current_assets_exclusive_for_business_railway DOUBLE, non_current_assets_exclusive_for_business_bus DOUBLE, non_current_assets_exclusive_for_business_real_estate BIGINT, non_current_assets_exclusive_for_business_other_businesses DOUBLE, non_current_assets_exclusive_for_business_total DOUBLE, non_current_assets_related_to_business_railway DOUBLE, non_current_assets_related_to_business_bus DOUBLE, non_current_assets_related_to_business_real_estate DOUBLE, non_current_assets_related_to_business_other_businesses DOUBLE, non_current_assets_related_to_business_total DOUBLE, non_current_assets_business_assets_total DOUBLE, non_current_assets_non_business_assets_total BIGINT, non_current_assets_construction_in_progress_railway DOUBLE, non_current_assets_construction_in_progress_bus DOUBLE, non_current_assets_construction_in_progress_real_estate DOUBLE, non_current_assets_construction_in_progress_other_businesses DOUBLE, non_current_assets_construction_in_progress_total DOUBLE, non_current_assets_investments_subsidiary_stock DOUBLE, non_current_assets_investments_long_term_prepaid_expenses DOUBLE, non_current_assets_investments_others DOUBLE, non_current_assets_investments_total DOUBLE, non_current_assets_allowance_for_doubtful_accounts_total BIGINT, non_current_assets_total DOUBLE, non_current_assets_total_percent DOUBLE, deferred_assets BIGINT, deferred_assets_percent DOUBLE, total_assets DOUBLE, total_assets_percent DOUBLE, current_liabilities_short_term_loans_payable DOUBLE, current_liabilities_bonds_due_within_one_year DOUBLE, current_liabilities_trade_payables_deposited_fares DOUBLE, current_liabilities_trade_payables_others DOUBLE, current_liabilities_allowance_for_bonuses DOUBLE, current_liabilities_others DOUBLE, current_liabilities_total DOUBLE, current_liabilities_total_percent DOUBLE, non_current_liabilities_bonds_payable DOUBLE, non_current_liabilities_long_term_loans_payable_mortgage_loans BIGINT, non_current_liabilities_long_term_loans_payable_loans_from_controlling_shareholder BIGINT, non_current_liabilities_long_term_loans_payable_loans_from_subsidiaries BIGINT, non_current_liabilities_long_term_loans_payable_others BIGINT, non_current_liabilities_long_term_loans_payable_total BIGINT, non_current_liabilities_allowance_for_retirement_benefits DOUBLE, non_current_liabilities_others DOUBLE, non_current_liabilities_total DOUBLE, non_current_liabilities_total_percent DOUBLE, provisions BIGINT, provisions_percent DOUBLE, total_liabilities DOUBLE, total_liabilities_percent DOUBLE, capital_stock DOUBLE, legal_capital_surplus_capital_reserve DOUBLE, legal_capital_surplus_other_capital_surplus DOUBLE, legal_capital_surplus_total DOUBLE, retained_earnings_legal_reserve DOUBLE, retained_earnings_voluntary_reserve BIGINT, retained_earnings_unappropriated_retained_earnings BIGINT, retained_earnings_total DOUBLE, others DOUBLE, total_equity DOUBLE, total_equity_percent DOUBLE, total_liabilities_and_equity DOUBLE, source_sha256 VARCHAR );