事業用車両数や運転者数、地方別の走行キロ・実車キロ/実運送・利用運送/営業収入等の事業実績に関する事業実績情報を有するデータ
G空間情報センターのデータセット links-kamotsujidousyaunsojigyo-2024 の 01_jigyoujissekihoukokusyo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.trucking_business_results ( business_operator_id_1 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, year BIGINT, source_sha256 VARCHAR );