損益計算書は、鉄軌道業の営業収益・営業費・営業損益、自動車業の営業収益・営業費・営業損益、営業損益計、全事業経常利益、税引前損益、法人税等、当期損益、配当率に関する情報を有するデータです。(2,306レコード)
元の資料: 鉄道統計年報
G空間情報センターのデータセット links-tetsudoujigyou-2025 の 05_tetsudou_sonekikeisansyo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.railway_income_statement ( year BIGINT, company_name VARCHAR, supervisory_office VARCHAR, company_size VARCHAR, railway_operating_revenue_thousandjpy DOUBLE, railway_operating_expenses_thousandjpy DOUBLE, railway_operating_profitloss_thousandjpy DOUBLE, bus_operating_revenue_thousandjpy BIGINT, bus_operating_expenses_thousandjpy BIGINT, bus_operating_profitloss_thousandjpy BIGINT, realestate_operating_revenue_thousandjpy BIGINT, realestate_operating_expenses_thousandjpy BIGINT, realestate_operating_profitloss_thousandjpy BIGINT, other_business_revenue_thousandjpy DOUBLE, other_business_expenses_thousandjpy DOUBLE, other_business_profitloss_thousandjpy DOUBLE, total_operating_revenue_thousandjpy DOUBLE, total_operating_expenses_thousandjpy DOUBLE, total_operating_profitloss_thousandjpy DOUBLE, nonoperating_income_thousandjpy DOUBLE, nonoperating_expenses_thousandjpy DOUBLE, ordinary_profitloss_thousandjpy DOUBLE, extraordinary_income_fixedassetsales_thousandjpy DOUBLE, extraordinary_income_other_thousandjpy DOUBLE, extraordinary_income_total_thousandjpy DOUBLE, extraordinary_loss_fixedassetsales_thousandjpy DOUBLE, extraordinary_loss_other_thousandjpy DOUBLE, extraordinary_loss_total_thousandjpy DOUBLE, profitloss_before_tax_thousandjpy DOUBLE, corporate_tax_thousandjpy DOUBLE, corporate_tax_adjustment_thousandjpy DOUBLE, net_profitloss_thousandjpy DOUBLE, dividend_rate_firsthalf_percent DOUBLE, dividend_rate_secondhalf_percent DOUBLE, source_sha256 VARCHAR );