ファイル1の事業実績に関する情報と、営業費用、経常損益、流動・固定資産、負債・純資産等の財務情報を結合したデータ
G空間情報センターのデータセット links-kamotsujidousyaunsojigyo-2024 の 02_jigyoujissekihoukokusyo_zaimujyouho.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.trucking_business_results_financials ( business_operator_id_2 BIGINT, industry_category VARCHAR, business_content_1 VARCHAR, business_content_2 VARCHAR, business_content_3 VARCHAR, commercial_vehicle_count_rank BIGINT, commercial_vehicle_count_deviation_score DOUBLE, employee_count_rank BIGINT, employee_count_deviation_score DOUBLE, driver_count_rank BIGINT, driver_count_deviation_score DOUBLE, hokkaido_cumulative_existing_vehicle_count_rank BIGINT, hokkaido_cumulative_existing_vehicle_count_deviation_score DOUBLE, hokkaido_cumulative_operating_vehicle_count_rank BIGINT, hokkaido_cumulative_operating_vehicle_count_deviation_score DOUBLE, hokkaido_traveled_kilometers_rank BIGINT, hokkaido_traveled_kilometers_deviation_score DOUBLE, hokkaido_loaded_kilometers_rank BIGINT, hokkaido_loaded_kilometers_deviation_score DOUBLE, hokkaido_actual_transport_tons_rank BIGINT, hokkaido_actual_transport_tons_deviation_score DOUBLE, hokkaido_utilized_transport_tons_rank BIGINT, hokkaido_utilized_transport_tons_deviation_score DOUBLE, hokkaido_operating_revenue_rank BIGINT, hokkaido_operating_revenue_deviation_score DOUBLE, tohoku_cumulative_existing_vehicle_count_rank BIGINT, tohoku_cumulative_existing_vehicle_count_deviation_score DOUBLE, tohoku_cumulative_operating_vehicle_count_rank BIGINT, tohoku_cumulative_operating_vehicle_count_deviation_score DOUBLE, tohoku_traveled_kilometers_rank BIGINT, tohoku_traveled_kilometers_deviation_score DOUBLE, tohoku_loaded_kilometers_rank BIGINT, tohoku_loaded_kilometers_deviation_score DOUBLE, tohoku_actual_transport_tons_rank BIGINT, tohoku_actual_transport_tons_deviation_score DOUBLE, tohoku_utilized_transport_tons_rank BIGINT, tohoku_utilized_transport_tons_deviation_score DOUBLE, tohoku_operating_revenue_rank BIGINT, tohoku_operating_revenue_deviation_score DOUBLE, hokuriku_shinetsu_cumulative_existing_vehicle_count_rank BIGINT, hokuriku_shinetsu_cumulative_existing_vehicle_count_deviation_score DOUBLE, hokuriku_shinetsu_cumulative_operating_vehicle_count_rank BIGINT, hokuriku_shinetsu_cumulative_operating_vehicle_count_deviation_score DOUBLE, hokuriku_shinetsu_traveled_kilometers_rank BIGINT, hokuriku_shinetsu_traveled_kilometers_deviation_score DOUBLE, hokuriku_shinetsu_loaded_kilometers_rank BIGINT, hokuriku_shinetsu_loaded_kilometers_deviation_score DOUBLE, hokuriku_shinetsu_actual_transport_tons_rank BIGINT, hokuriku_shinetsu_actual_transport_tons_deviation_score DOUBLE, hokuriku_shinetsu_utilized_transport_tons_rank BIGINT, hokuriku_shinetsu_utilized_transport_tons_deviation_score DOUBLE, hokuriku_shinetsu_operating_revenue_rank BIGINT, hokuriku_shinetsu_operating_revenue_deviation_score DOUBLE, kanto_cumulative_existing_vehicle_count_rank BIGINT, kanto_cumulative_existing_vehicle_count_deviation_score DOUBLE, kanto_cumulative_operating_vehicle_count_rank BIGINT, kanto_cumulative_operating_vehicle_count_deviation_score DOUBLE, kanto_traveled_kilometers_rank BIGINT, kanto_traveled_kilometers_deviation_score DOUBLE, kanto_loaded_kilometers_rank BIGINT, kanto_loaded_kilometers_deviation_score DOUBLE, kanto_actual_transport_tons_rank BIGINT, kanto_actual_transport_tons_deviation_score DOUBLE, kanto_utilized_transport_tons_rank BIGINT, kanto_utilized_transport_tons_deviation_score DOUBLE, kanto_operating_revenue_rank BIGINT, kanto_operating_revenue_deviation_score DOUBLE, chubu_cumulative_existing_vehicle_count_rank BIGINT, chubu_cumulative_existing_vehicle_count_deviation_score DOUBLE, chubu_cumulative_operating_vehicle_count_rank BIGINT, chubu_cumulative_operating_vehicle_count_deviation_score DOUBLE, chubu_traveled_kilometers_rank BIGINT, chubu_traveled_kilometers_deviation_score DOUBLE, chubu_loaded_kilometers_rank BIGINT, chubu_loaded_kilometers_deviation_score DOUBLE, chubu_actual_transport_tons_rank BIGINT, chubu_actual_transport_tons_deviation_score DOUBLE, chubu_utilized_transport_tons_rank BIGINT, chubu_utilized_transport_tons_deviation_score DOUBLE, chubu_operating_revenue_rank BIGINT, chubu_operating_revenue_deviation_score DOUBLE, kinki_cumulative_existing_vehicle_count_rank BIGINT, kinki_cumulative_existing_vehicle_count_deviation_score DOUBLE, kinki_cumulative_operating_vehicle_count_rank BIGINT, kinki_cumulative_operating_vehicle_count_deviation_score DOUBLE, kinki_traveled_kilometers_rank BIGINT, kinki_traveled_kilometers_deviation_score DOUBLE, kinki_loaded_kilometers_rank BIGINT, kinki_loaded_kilometers_deviation_score DOUBLE, kinki_actual_transport_tons_rank BIGINT, kinki_actual_transport_tons_deviation_score DOUBLE, kinki_utilized_transport_tons_rank BIGINT, kinki_utilized_transport_tons_deviation_score DOUBLE, kinki_operating_revenue_rank BIGINT, kinki_operating_revenue_deviation_score DOUBLE, chugoku_cumulative_existing_vehicle_count_rank BIGINT, chugoku_cumulative_existing_vehicle_count_deviation_score DOUBLE, chugoku_cumulative_operating_vehicle_count_rank BIGINT, chugoku_cumulative_operating_vehicle_count_deviation_score DOUBLE, chugoku_traveled_kilometers_rank BIGINT, chugoku_traveled_kilometers_deviation_score DOUBLE, chugoku_loaded_kilometers_rank BIGINT, chugoku_loaded_kilometers_deviation_score DOUBLE, chugoku_actual_transport_tons_rank BIGINT, chugoku_actual_transport_tons_deviation_score DOUBLE, chugoku_utilized_transport_tons_rank BIGINT, chugoku_utilized_transport_tons_deviation_score DOUBLE, chugoku_operating_revenue_rank BIGINT, chugoku_operating_revenue_deviation_score DOUBLE, shikoku_cumulative_existing_vehicle_count_rank BIGINT, shikoku_cumulative_existing_vehicle_count_deviation_score DOUBLE, shikoku_cumulative_operating_vehicle_count_rank BIGINT, shikoku_cumulative_operating_vehicle_count_deviation_score DOUBLE, shikoku_traveled_kilometers_rank BIGINT, shikoku_traveled_kilometers_deviation_score DOUBLE, shikoku_loaded_kilometers_rank BIGINT, shikoku_loaded_kilometers_deviation_score DOUBLE, shikoku_actual_transport_tons_rank BIGINT, shikoku_actual_transport_tons_deviation_score DOUBLE, shikoku_utilized_transport_tons_rank BIGINT, shikoku_utilized_transport_tons_deviation_score DOUBLE, shikoku_operating_revenue_rank BIGINT, shikoku_operating_revenue_deviation_score DOUBLE, kyushu_cumulative_existing_vehicle_count_rank BIGINT, kyushu_cumulative_existing_vehicle_count_deviation_score DOUBLE, kyushu_cumulative_operating_vehicle_count_rank BIGINT, kyushu_cumulative_operating_vehicle_count_deviation_score DOUBLE, kyushu_traveled_kilometers_rank BIGINT, kyushu_traveled_kilometers_deviation_score DOUBLE, kyushu_loaded_kilometers_rank BIGINT, kyushu_loaded_kilometers_deviation_score DOUBLE, kyushu_actual_transport_tons_rank BIGINT, kyushu_actual_transport_tons_deviation_score DOUBLE, kyushu_utilized_transport_tons_rank BIGINT, kyushu_utilized_transport_tons_deviation_score DOUBLE, kyushu_operating_revenue_rank BIGINT, kyushu_operating_revenue_deviation_score DOUBLE, okinawa_cumulative_existing_vehicle_count_rank BIGINT, okinawa_cumulative_existing_vehicle_count_deviation_score DOUBLE, okinawa_cumulative_operating_vehicle_count_rank BIGINT, okinawa_cumulative_operating_vehicle_count_deviation_score DOUBLE, okinawa_traveled_kilometers_rank BIGINT, okinawa_traveled_kilometers_deviation_score DOUBLE, okinawa_loaded_kilometers_rank BIGINT, okinawa_loaded_kilometers_deviation_score DOUBLE, okinawa_actual_transport_tons_rank BIGINT, okinawa_actual_transport_tons_deviation_score DOUBLE, okinawa_utilized_transport_tons_rank BIGINT, okinawa_utilized_transport_tons_deviation_score DOUBLE, okinawa_operating_revenue_rank BIGINT, okinawa_operating_revenue_deviation_score DOUBLE, national_cumulative_existing_vehicle_count_rank BIGINT, national_cumulative_existing_vehicle_count_deviation_score DOUBLE, national_cumulative_operating_vehicle_count_rank BIGINT, national_cumulative_operating_vehicle_count_deviation_score DOUBLE, national_traveled_kilometers_rank BIGINT, national_traveled_kilometers_deviation_score DOUBLE, national_loaded_kilometers_rank BIGINT, national_loaded_kilometers_deviation_score DOUBLE, national_actual_transport_tons_rank BIGINT, national_actual_transport_tons_deviation_score DOUBLE, national_utilized_transport_tons_rank BIGINT, national_utilized_transport_tons_deviation_score DOUBLE, national_operating_revenue_rank BIGINT, national_operating_revenue_deviation_score DOUBLE, accident_count_traffic_accidents_rank BIGINT, accident_count_traffic_accidents_deviation_score DOUBLE, accident_count_major_accidents_rank BIGINT, accident_count_major_accidents_deviation_score DOUBLE, accident_count_fatalities_rank BIGINT, accident_count_fatalities_deviation_score DOUBLE, accident_count_injuries_rank BIGINT, accident_count_injuries_deviation_score DOUBLE, business_overview_commercial_vehicle_count_rank BIGINT, business_overview_commercial_vehicle_count_deviation_score DOUBLE, business_overview_employee_count_rank BIGINT, business_overview_employee_count_deviation_score DOUBLE, loaded_kilometers_rank BIGINT, loaded_kilometers_deviation_score DOUBLE, empty_kilometers_rank BIGINT, empty_kilometers_deviation_score DOUBLE, total_traveled_kilometers_rank BIGINT, total_traveled_kilometers_deviation_score DOUBLE, end_period_existing_vehicle_count_rank BIGINT, end_period_existing_vehicle_count_deviation_score DOUBLE, national_cumulative_existing_vehicle_count_rank_1 BIGINT, national_cumulative_existing_vehicle_count_deviation_score_1 DOUBLE, national_cumulative_operating_vehicle_count_rank_1 BIGINT, national_cumulative_operating_vehicle_count_deviation_score_1 DOUBLE, during_period_average_employee_count_rank BIGINT, during_period_average_employee_count_deviation_score DOUBLE, specific_business_operating_revenue_rank BIGINT, specific_business_operating_revenue_deviation_score DOUBLE, specific_business_operating_expenses_rank BIGINT, specific_business_operating_expenses_deviation_score DOUBLE, specific_business_operating_profit_loss_rank BIGINT, specific_business_operating_profit_loss_deviation_score DOUBLE, ancillary_business_operating_revenue_rank BIGINT, ancillary_business_operating_revenue_deviation_score DOUBLE, ancillary_business_operating_expenses_rank BIGINT, ancillary_business_operating_expenses_deviation_score DOUBLE, ancillary_business_operating_profit_rank BIGINT, ancillary_business_operating_profit_deviation_score DOUBLE, total_business_operating_revenue_rank BIGINT, total_business_operating_revenue_deviation_score DOUBLE, total_business_operating_expenses_rank BIGINT, total_business_operating_expenses_deviation_score DOUBLE, total_business_operating_profit_rank BIGINT, total_business_operating_profit_deviation_score DOUBLE, non_operating_revenue_rank BIGINT, non_operating_revenue_deviation_score DOUBLE, non_operating_expenses_rank BIGINT, non_operating_expenses_deviation_score DOUBLE, financial_expenses_rank BIGINT, financial_expenses_deviation_score DOUBLE, ordinary_revenue_rank BIGINT, ordinary_revenue_deviation_score DOUBLE, ordinary_expenses_rank BIGINT, ordinary_expenses_deviation_score DOUBLE, ordinary_profit_rank BIGINT, ordinary_profit_deviation_score DOUBLE, extraordinary_profit_rank BIGINT, extraordinary_profit_deviation_score DOUBLE, extraordinary_loss_rank BIGINT, extraordinary_loss_deviation_score DOUBLE, profit_before_taxes_rank BIGINT, profit_before_taxes_deviation_score DOUBLE, corporate_taxes_etc_rank BIGINT, corporate_taxes_etc_deviation_score DOUBLE, corporate_taxes_etc_adjustment_rank BIGINT, corporate_taxes_etc_adjustment_deviation_score DOUBLE, current_period_profit_rank BIGINT, current_period_profit_deviation_score DOUBLE, specific_business_non_operating_income_rank BIGINT, specific_business_non_operating_income_deviation_score DOUBLE, specific_business_ordinary_income_rank BIGINT, specific_business_ordinary_income_deviation_score DOUBLE, specific_business_ordinary_expenses_rank BIGINT, specific_business_ordinary_expenses_deviation_score DOUBLE, specific_business_ordinary_profit_rank BIGINT, specific_business_ordinary_profit_deviation_score DOUBLE, motor_vehicle_transport_operating_revenue_rank BIGINT, motor_vehicle_transport_operating_revenue_deviation_score DOUBLE, current_assets_rank BIGINT, current_assets_deviation_score DOUBLE, quick_assets_rank BIGINT, quick_assets_deviation_score DOUBLE, fare_receivables_rank BIGINT, fare_receivables_deviation_score DOUBLE, other_receivables_rank BIGINT, other_receivables_deviation_score DOUBLE, total_receivables_rank BIGINT, total_receivables_deviation_score DOUBLE, fixed_assets_rank BIGINT, fixed_assets_deviation_score DOUBLE, tangible_fixed_assets_rank BIGINT, tangible_fixed_assets_deviation_score DOUBLE, construction_in_progress_rank BIGINT, construction_in_progress_deviation_score DOUBLE, intangible_fixed_assets_rank BIGINT, intangible_fixed_assets_deviation_score DOUBLE, investments_and_other_assets_rank BIGINT, investments_and_other_assets_deviation_score DOUBLE, deferred_assets_rank BIGINT, deferred_assets_deviation_score DOUBLE, total_assets_rank BIGINT, total_assets_deviation_score DOUBLE, current_liabilities_rank BIGINT, current_liabilities_deviation_score DOUBLE, non_current_liabilities_rank BIGINT, non_current_liabilities_deviation_score DOUBLE, total_liabilities_rank BIGINT, total_liabilities_deviation_score DOUBLE, capital_stock_1_rank BIGINT, capital_stock_1_deviation_score DOUBLE, total_equity_rank BIGINT, total_equity_deviation_score DOUBLE, operating_expenses_transport_costs_personnel_rank BIGINT, operating_expenses_transport_costs_personnel_deviation_score DOUBLE, operating_expenses_transport_costs_fuel_rank BIGINT, operating_expenses_transport_costs_fuel_deviation_score DOUBLE, operating_expenses_transport_costs_gasoline_rank BIGINT, operating_expenses_transport_costs_gasoline_deviation_score DOUBLE, operating_expenses_transport_costs_diesel_rank BIGINT, operating_expenses_transport_costs_diesel_deviation_score DOUBLE, operating_expenses_transport_costs_other_fuel_rank BIGINT, operating_expenses_transport_costs_other_fuel_deviation_score DOUBLE, operating_expenses_transport_costs_repairs_rank BIGINT, operating_expenses_transport_costs_repairs_deviation_score DOUBLE, operating_expenses_transport_costs_vehicles_rank BIGINT, operating_expenses_transport_costs_vehicles_deviation_score DOUBLE, operating_expenses_transport_costs_other_rank BIGINT, operating_expenses_transport_costs_other_deviation_score DOUBLE, operating_expenses_transport_costs_fixed_assets_depreciation_rank BIGINT, operating_expenses_transport_costs_fixed_assets_depreciation_deviation_score DOUBLE, operating_expenses_transport_costs_vehicles_1_rank BIGINT, operating_expenses_transport_costs_vehicles_1_deviation_score DOUBLE, operating_expenses_transport_costs_other_1_rank BIGINT, operating_expenses_transport_costs_other_1_deviation_score DOUBLE, operating_expenses_transport_costs_insurance_rank BIGINT, operating_expenses_transport_costs_insurance_deviation_score DOUBLE, operating_expenses_transport_costs_facility_usage_fees_rank BIGINT, operating_expenses_transport_costs_facility_usage_fees_deviation_score DOUBLE, operating_expenses_transport_costs_vehicle_lease_fees_rank BIGINT, operating_expenses_transport_costs_vehicle_lease_fees_deviation_score DOUBLE, operating_expenses_transport_costs_facility_taxes_rank BIGINT, operating_expenses_transport_costs_facility_taxes_deviation_score DOUBLE, operating_expenses_transport_costs_accident_compensation_rank BIGINT, operating_expenses_transport_costs_accident_compensation_deviation_score DOUBLE, operating_expenses_transport_costs_road_usage_fees_rank BIGINT, operating_expenses_transport_costs_road_usage_fees_deviation_score DOUBLE, operating_expenses_transport_costs_ferry_boat_usage_fees_rank BIGINT, operating_expenses_transport_costs_ferry_boat_usage_fees_deviation_score DOUBLE, other_transport_costs_rank BIGINT, other_transport_costs_deviation_score DOUBLE, operating_expenses_general_administrative_rank BIGINT, operating_expenses_general_administrative_deviation_score DOUBLE, operating_expenses_general_administrative_personnel_rank BIGINT, operating_expenses_general_administrative_personnel_deviation_score DOUBLE, total_operating_expenses_rank BIGINT, total_operating_expenses_deviation_score DOUBLE, net_labor_hours_total_road_logistics DOUBLE, net_labor_hours_expected_road_logistics DOUBLE, net_labor_hours_non_expected_road_logistics DOUBLE, year BIGINT, source_sha256 VARCHAR );