奈良運輸支局管内の事業者を対象とした、営業費用、経常損益、流動・固定資産、負債・純資産等の財務情報を有するデータ(324レコード)
G空間情報センターのデータセット links-kamotsujidousyaunsojigyo-2025 の 02_zaimujyouho_2025.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.trucking_financials_nara ( business_operator_id_2 BIGINT, specific_business_operating_revenue_rank BIGINT, specific_business_operating_expenses_rank BIGINT, specific_business_operating_profit_loss_rank BIGINT, ancillary_business_operating_revenue_rank BIGINT, ancillary_business_operating_expenses_rank BIGINT, ancillary_business_operating_profit_rank BIGINT, total_business_operating_revenue_rank BIGINT, total_business_operating_expenses_rank BIGINT, total_business_operating_profit_rank BIGINT, non_operating_revenue_rank BIGINT, non_operating_expenses_rank BIGINT, financial_expenses_rank BIGINT, ordinary_revenue_rank BIGINT, ordinary_expenses_rank BIGINT, ordinary_profit_rank BIGINT, extraordinary_profit_rank BIGINT, extraordinary_loss_rank BIGINT, profit_before_taxes_rank BIGINT, corporate_taxes_etc_rank BIGINT, corporate_taxes_etc_adjustment_rank BIGINT, current_period_profit_rank BIGINT, specific_business_non_operating_income_rank BIGINT, specific_business_ordinary_income_rank BIGINT, specific_business_ordinary_expenses_rank BIGINT, specific_business_ordinary_profit_rank BIGINT, motor_vehicle_transport_operating_revenue_rank BIGINT, current_assets_rank BIGINT, quick_assets_rank BIGINT, fare_receivables_rank BIGINT, other_receivables_rank BIGINT, total_receivables_rank BIGINT, fixed_assets_rank BIGINT, tangible_fixed_assets_rank BIGINT, construction_in_progress_rank BIGINT, intangible_fixed_assets_rank BIGINT, investments_and_other_assets_rank BIGINT, deferred_assets_rank BIGINT, total_assets_rank BIGINT, current_liabilities_rank BIGINT, non_current_liabilities_rank BIGINT, total_liabilities_rank BIGINT, capital_stock_1_rank BIGINT, total_equity_rank BIGINT, operating_expenses_transport_costs_personnel_rank BIGINT, operating_expenses_transport_costs_fuel_rank BIGINT, operating_expenses_transport_costs_gasoline_rank BIGINT, operating_expenses_transport_costs_diesel_rank BIGINT, operating_expenses_transport_costs_other_fuel_rank BIGINT, operating_expenses_transport_costs_repairs_rank BIGINT, operating_expenses_transport_costs_vehicles_rank BIGINT, operating_expenses_transport_costs_other_rank BIGINT, operating_expenses_transport_costs_fixed_assets_depreciation_rank BIGINT, operating_expenses_transport_costs_vehicles_1_rank BIGINT, operating_expenses_transport_costs_other_1_rank BIGINT, operating_expenses_transport_costs_insurance_rank BIGINT, operating_expenses_transport_costs_facility_usage_fees_rank BIGINT, operating_expenses_transport_costs_vehicle_lease_fees_rank BIGINT, operating_expenses_transport_costs_facility_taxes_rank BIGINT, operating_expenses_transport_costs_accident_compensation_rank BIGINT, operating_expenses_transport_costs_road_usage_fees_rank BIGINT, operating_expenses_transport_costs_ferry_boat_usage_fees_rank BIGINT, other_transport_costs_rank BIGINT, operating_expenses_general_administrative_rank BIGINT, operating_expenses_general_administrative_personnel_rank BIGINT, total_operating_expenses_rank BIGINT, source_sha256 VARCHAR );