本データは、全国の事務所を対象に、2023・2024年度における乗用車、マイクロバス、トラック、特殊用途車、二輪車別の車種別車両数、延貸渡回数、延貸渡日車数、延走行キロ、延貸渡料金に関する情報をデータ化したものです。(8,305レコード)
元の資料: 貸渡実績報告書(様式1)、国土数値情報 行政ポリゴン
G空間情報センターのデータセット links-rentacars-2025 の 01_yousiki1_kashiwatashijissekihoukokusho.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.rental_car_results ( director_of_transport_branch VARCHAR, fiscal_year BIGINT, reporting_period VARCHAR, operator_id BIGINT, address VARCHAR, address_latitude DOUBLE, address_longitude VARCHAR, number_of_offices BIGINT, passenger_car_vehicle_count BIGINT, passenger_car_total_rental_times BIGINT, passenger_car_total_rental_days BIGINT, passenger_car_total_distance BIGINT, passenger_car_total_rental_fees BIGINT, passenger_car_light_vehicle_count BIGINT, passenger_car_light_total_rental_times BIGINT, passenger_car_light_total_rental_days BIGINT, passenger_car_light_total_distance BIGINT, passenger_car_light_total_rental_fees BIGINT, microbus_vehicle_count BIGINT, microbus_total_rental_times BIGINT, microbus_total_rental_days BIGINT, microbus_total_distance BIGINT, microbus_total_rental_fees BIGINT, truck_vehicle_count BIGINT, truck_total_rental_times BIGINT, truck_total_rental_days BIGINT, truck_total_distance BIGINT, truck_total_rental_fees BIGINT, truck_light_vehicle_count BIGINT, truck_light_total_rental_times BIGINT, truck_light_total_rental_days BIGINT, truck_light_total_distance BIGINT, truck_light_total_rental_fees BIGINT, special_purpose_vehicle_count BIGINT, special_purpose_total_rental_times BIGINT, special_purpose_total_rental_days BIGINT, special_purpose_total_distance BIGINT, special_purpose_total_rental_fees BIGINT, special_purpose_light_vehicle_count BIGINT, special_purpose_light_total_rental_times BIGINT, special_purpose_light_total_rental_days BIGINT, special_purpose_light_total_distance BIGINT, special_purpose_light_total_rental_fees BIGINT, motorcycle_vehicle_count BIGINT, motorcycle_total_rental_times BIGINT, motorcycle_total_rental_days BIGINT, motorcycle_total_distance BIGINT, motorcycle_total_rental_fees BIGINT, motorcycle_light_vehicle_count BIGINT, motorcycle_light_total_rental_times BIGINT, motorcycle_light_total_rental_days BIGINT, motorcycle_light_total_distance BIGINT, motorcycle_light_total_rental_fees BIGINT, total_vehicle_count BIGINT, total_rental_times BIGINT, total_rental_days BIGINT, total_distance BIGINT, total_rental_fees BIGINT, rental_results_total_rent_a_car_and_car_sharing_transport_branch VARCHAR, number_of_deposits BIGINT, number_of_rental_vehicles_one_way BIGINT, number_of_rental_vehicles_other_than_one_way BIGINT, number_of_rental_vehicles_total BIGINT, prefecture_name VARCHAR, sub_prefectural_name VARCHAR, county_or_designated_city_name VARCHAR, city_ward_town_name VARCHAR, administrative_area_code BIGINT, prefecture_code VARCHAR, geometry GEOMETRY, source_sha256 VARCHAR );