路線バスの輸送実績は、事業種別(路線定期運行、路線不定期運行、区域運行)、事業用自動車数、従業員数、運転者数、路線、競合路線、運行系統数、走行キロ、実車キロ、輸送人員、営業収入、旅客運賃収入、交通事故件数、死者数、負傷者数、1人平均乗車キロ、輸送人キロ、平均乗車密度等の実績に関する情報を、ランク化(閾値設定)により秘匿化したデータです。(3,517レコード)
元の資料: 一般乗合旅客自動車運送事業輸送実績報告書
G空間情報センターのデータセット links-ippanryokyaku-2025 の 01_ippannoriairyokyaku_yusoujisseki.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.bus_route_transport_results ( status_date_fiscal_year VARCHAR, status_date_reported_date VARCHAR, business_info_operator_id BIGINT, buisiness_category_shared_ride_regular_route_time_tabled BIGINT, buisiness_category_shared_ride_regular_route_non_time_tabled BIGINT, buisiness_category_shared_ride_irregular_route BIGINT, charter BIGINT, regular_route_time_tabled_regular_route_non_time_tabled VARCHAR, buisiness_overview_number_of_vehicle_for_buisiness_rank VARCHAR, buisiness_overview_number_of_employee_rank VARCHAR, buisiness_overview_number_of_driver_employee_rank VARCHAR, buisiness_overview_number_of_regular_route_rank VARCHAR, buisiness_overview_number_of_inactive_route_rank VARCHAR, buisiness_overview_number_of_competing_route_rank VARCHAR, buisiness_overview_number_of_active_route_rank VARCHAR, transportation_record_vehicle_for_buisiness_number_of_total_actual_vehicle_jurisdicted_area_rank VARCHAR, transportation_record_vehicle_for_buisiness_number_of_total_active_vehicle_jurisdicted_area_rank VARCHAR, transportation_record_total_drived_kilometers_jurisdicted_area_rank VARCHAR, transportation_record_total_transported_kilometers_jurisdicted_area_rank VARCHAR, transportation_record_total_transported_number_of_passenger_jurisdicted_area_rank VARCHAR, transportation_record_total_transported_number_of_passenger_with_commuter_pass_jurisdicted_area_rank VARCHAR, transportation_record_operating_ernings_jurisdicted_area_rank VARCHAR, transportation_record_passenger_revenue_jurisdicted_area_rank VARCHAR, transportation_record_vehicle_for_buisiness_number_of_total_actual_vehicle_nationwide_rank VARCHAR, transportation_record_vehicle_for_buisiness_number_of_total_active_vehicle_nationwide_rank VARCHAR, transportation_record_total_drived_kilometers_nationwide_rank VARCHAR, transportation_record_total_transported_kilometers_nationwide_rank VARCHAR, transportation_record_total_transported_passenger_nationwide_rank VARCHAR, transportation_record_total_transported_passenger_with_commuter_pass_nationwide_rank VARCHAR, transportation_record_operating_ernings_nationwide_rank VARCHAR, transportation_record_passenger_revenue_nationwide_rank VARCHAR, accident_occurance_number_of_traffic_jurisdicted_area_rank VARCHAR, accident_occurance_number_of_major_jurisdicted_area_rank VARCHAR, accident_occurance_number_of_death_jurisdicted_area_rank VARCHAR, accident_occurance_number_of_injured_jurisdicted_area_rank VARCHAR, accident_occurance_number_of_traffic_nationwide_rank VARCHAR, accident_occurance_number_of_major_nationwide_rank VARCHAR, accident_occurance_number_of_death_nationwide_rank VARCHAR, accident_occurance_number_of_injured_nationwide_rank VARCHAR, regular_route_total_kilometers_rank VARCHAR, time_table_total_number_of_operation_rank VARCHAR, annual_transportation_record_total_drived_kilometers_rank VARCHAR, annual_transportation_record_total_transported_passenger_rank VARCHAR, annual_transportation_record_total_transported_passenger_with_commuter_pass_rank VARCHAR, annual_transportation_record_average_transported_kilometers_per_passenger_rank VARCHAR, annual_transportation_record_total_transported_kilometer_passenger_rank VARCHAR, annual_transportation_record_average_passenger_density_rank VARCHAR, annual_transportation_record_total_transportation_ernings_rank VARCHAR, annual_transportation_record_transportation_ernings_per_one_drived_kilometer_rank VARCHAR, buisiness_overview_jurisdicted_area_1_area_name DOUBLE, buisiness_overview_jurisdicted_area_1_number_of_vehicle_for_buisiness_rank VARCHAR, buisiness_overview_jurisdicted_area_1_number_of_empoyee_rank VARCHAR, buisiness_overview_jurisdicted_area_1_number_of_driver_empoyee_rank VARCHAR, buisiness_overview_jurisdicted_area_2_area_name DOUBLE, buisiness_overview_jurisdicted_area_2_number_of_vehicle_for_buisiness_rank VARCHAR, buisiness_overview_jurisdicted_area_2_number_of_empoyee_rank VARCHAR, buisiness_overview_jurisdicted_area_2_number_of_driver_empoyee_rank VARCHAR, buisiness_overview_jurisdicted_area_nationwide_number_of_vehicle_for_buisiness_rank VARCHAR, buisiness_overview_jurisdicted_area_nationwide_number_of_empoyee_rank VARCHAR, buisiness_overview_jurisdicted_area_nationwide_number_of_driver_empoyee_rank VARCHAR, transportation_record_jurisdicted_area_1_area_name DOUBLE, transportation_record_jurisdicted_area_1_number_of_total_actual_vehicle_nationwide_rank VARCHAR, transportation_record_jurisdicted_area_1_number_of_total_active_vehicle_nationwide_rank VARCHAR, transportation_record_jurisdicted_area_1_total_drived_kilometers_rank VARCHAR, transportation_record_jurisdicted_area_1_total_transported_kilometers_rank VARCHAR, transportation_record_jurisdicted_area_1_total_number_of_operation_rank VARCHAR, transportation_record_jurisdicted_area_1_total_transported_passengers_rank VARCHAR, transportation_record_jurisdicted_area_1_total_transported_passengers_with_commuter_pass_rank VARCHAR, transportation_record_jurisdicted_area_1_operating_ernings_rank VARCHAR, transportation_record_jurisdicted_area_1_passenger_revenue_rank VARCHAR, transportation_record_jurisdicted_area_2_area_name DOUBLE, transportation_record_jurisdicted_area_2_number_of_total_actual_vehicle_nationwide_rank VARCHAR, transportation_record_jurisdicted_area_2_number_of_total_active_vehicle_nationwide_rank VARCHAR, transportation_record_jurisdicted_area_2_total_drived_kilometers_rank VARCHAR, transportation_record_jurisdicted_area_2_total_transported_kilometers_rank VARCHAR, transportation_record_jurisdicted_area_2_total_number_of_operation_rank VARCHAR, transportation_record_jurisdicted_area_2_total_transported_passengers_rank VARCHAR, transportation_record_jurisdicted_area_2_total_transported_passengers_with_commuter_pass_rank VARCHAR, transportation_record_jurisdicted_area_2_operating_ernings_rank VARCHAR, transportation_record_jurisdicted_area_2_passenger_revenue_rank VARCHAR, transportation_record_nationwide_number_of_total_actual_vehicle_nationwide_rank VARCHAR, transportation_record_nationwide_number_of_total_active_vehicle_nationwide_rank VARCHAR, transportation_record_nationwide_total_drived_kilometers_rank VARCHAR, transportation_record_nationwide_total_transported_kilometers_rank VARCHAR, transportation_record_nationwide_total_number_of_operation_rank VARCHAR, transportation_record_nationwide_total_transported_passengers_rank VARCHAR, transportation_record_nationwide_total_transported_passengers_with_commuter_pass_rank VARCHAR, transportation_record_nationwide_operating_ernings_rank VARCHAR, transportation_record_nationwide_passenger_revenue_rank VARCHAR, accident_occurance_jurisdicted_area_1_area_name DOUBLE, accident_occurance_jurisdicted_area_1_number_of_traffic_jurisdicted_area_rank VARCHAR, accident_occurance_jurisdicted_area_1_number_of_major_jurisdicted_area_rank VARCHAR, accident_occurance_jurisdicted_area_1_number_of_death_jurisdicted_area_rank BIGINT, accident_occurance_jurisdicted_area_1_number_of_injured_jurisdicted_area_rank VARCHAR, accident_occurance_jurisdicted_area_2_area_name DOUBLE, accident_occurance_jurisdicted_area_2_number_of_traffic_jurisdicted_area_rank VARCHAR, accident_occurance_jurisdicted_area_2_number_of_major_jurisdicted_area_rank BIGINT, accident_occurance_jurisdicted_area_2_number_of_death_jurisdicted_area_rank BIGINT, accident_occurance_jurisdicted_area_2_number_of_injured_jurisdicted_area_rank VARCHAR, accident_occurance_nationwide_number_of_traffic_jurisdicted_area_rank VARCHAR, accident_occurance_nationwide_number_of_major_jurisdicted_area_rank VARCHAR, accident_occurance_nationwide_number_of_death_jurisdicted_area_rank BIGINT, accident_occurance_nationwide_number_of_injured_jurisdicted_area_rank VARCHAR, annual_transportation_record_total_drived_kilometers_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_total_transported_passenger_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_total_transported_passenger_with_commuter_pass_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_average_transported_kilometers_per_passenger_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_total_transported_kilometer_passenger_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_average_passenger_density_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_total_transportation_ernings_jurisdicted_area_add_up_rank VARCHAR, annual_transportation_record_transportation_ernings_per_one_drived_kilometer_jurisdicted_area_add_up_rank VARCHAR, source_sha256 VARCHAR );