貸切バスの輸送実績は、事業用自動車数、従業員数、運転者数、走行キロ、実車キロ、輸送人員、旅行業者扱い、営業収入、交通事故件数、死者数、負傷者数、1人平均乗車キロ、輸送人キロ、平均乗車密度等の実績に関する情報を、ランク化(閾値設定)により秘匿化したデータです。(6,055レコード)
元の資料: 一般貸切旅客自動車運送事業輸送実績報告書
G空間情報センターのデータセット links-ippanryokyaku-2025 の 02_ippankashikiriryokyaku_yusoujisseki.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.bus_charter_transport_results ( report_date_fiscal_year VARCHAR, report_date_full_date VARCHAR, business_info_operator_id VARCHAR, report_business_type_fixed_route_regular BIGINT, report_business_type_fixed_route_irregular BIGINT, report_business_type_area_operation BIGINT, chartered_business BIGINT, business_overview_vehicles_rank VARCHAR, business_overview_employees_rank VARCHAR, business_overview_drivers_rank VARCHAR, transport_results_vehicles_total_existing_regional_rank VARCHAR, transport_results_vehicles_total_operating_regional_rank VARCHAR, transport_results_total_distance_regional_rank VARCHAR, transport_results_occupied_distance_regional_rank VARCHAR, transport_results_passengers_regional_rank VARCHAR, transport_results_operations_regional_rank VARCHAR, transport_results_operations_travel_agency_regional_rank VARCHAR, transport_results_operations_travel_agency_type1_local_tour_regional_rank VARCHAR, transport_results_operations_travel_agency_type2_intercity_tour_regional_rank VARCHAR, transport_results_operations_travel_agency_type3_other_regional_rank VARCHAR, transport_results_operating_revenue_regional_rank VARCHAR, transport_results_vehicles_total_existing_national_rank VARCHAR, transport_results_vehicles_total_operating_national_rank VARCHAR, transport_results_total_distance_national_rank VARCHAR, transport_results_occupied_distance_national_rank VARCHAR, transport_results_passengers_national_rank VARCHAR, transport_results_operations_national_rank VARCHAR, transport_results_operations_travel_agency_national_rank VARCHAR, transport_results_operations_travel_agency_type1_local_tour_national_rank VARCHAR, transport_results_operations_travel_agency_type2_intercity_tour_national_rank VARCHAR, transport_results_operations_travel_agency_type3_other_national_rank VARCHAR, transport_results_operating_revenue_national_rank VARCHAR, accidents_traffic_accidents_regional_rank VARCHAR, accidents_serious_accidents_regional_rank VARCHAR, accidents_fatalities_regional_rank VARCHAR, accidents_injuries_regional_rank VARCHAR, accidents_traffic_accidents_national_rank VARCHAR, accidents_serious_accidents_national_rank VARCHAR, accidents_fatalities_national_rank VARCHAR, accidents_injuries_national_rank VARCHAR, source_sha256 VARCHAR );