本データは、東京運輸支局及び徳島運輸支局、長崎運輸支局の運送者(29件)を対象に、2020~2024年度における自家用有償旅客運送自動車数(寝台車、車いす車、兼用車、回転シート車、セダン等、バスの別)、走行キロ、輸送人員、運送収入、交通事故・重大事故件数、死者数、負傷者数に関する情報をデータ化したものです。(29レコード)
元の資料: 自家用有償旅客運送輸送実績報告書
G空間情報センターのデータセット links-rideshare-2025 の 01_jikayouyuushouryokyakuunsou_yusoujissekihoukokusho.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.rideshare_transport_results ( category VARCHAR, fiscal_year BIGINT, address VARCHAR, latitude DOUBLE, longitude DOUBLE, operator_id BIGINT, overview_area VARCHAR, overview_private_paid_passenger_vehicles_sleeper_units_area BIGINT, overview_private_paid_passenger_vehicles_sleeper_light_units_area BIGINT, overview_private_paid_passenger_vehicles_sleeper_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_sleeper_light_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_wheelchair_units_area BIGINT, overview_private_paid_passenger_vehicles_wheelchair_light_units_area BIGINT, overview_private_paid_passenger_vehicles_wheelchair_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_wheelchair_light_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_combination_units_area BIGINT, overview_private_paid_passenger_vehicles_combination_light_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_swivel_seat_units_area BIGINT, overview_private_paid_passenger_vehicles_swivel_seat_light_units_area BIGINT, overview_private_paid_passenger_vehicles_swivel_seat_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_swivel_seat_light_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_sedan_etc_units_area BIGINT, overview_private_paid_passenger_vehicles_sedan_etc_light_units_area BIGINT, overview_private_paid_passenger_vehicles_sedan_etc_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_sedan_etc_light_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_bus_units_area BIGINT, overview_private_paid_passenger_vehicles_bus_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_total_units_area BIGINT, overview_private_paid_passenger_vehicles_total_light_units_area BIGINT, overview_private_paid_passenger_vehicles_total_units_nationwide BIGINT, overview_private_paid_passenger_vehicles_total_light_units_nationwide BIGINT, overview_route_or_transport_area_route_area BIGINT, overview_route_or_transport_area_route_nationwide BIGINT, overview_route_or_transport_area_transport_area_area VARCHAR, overview_welfare_i_area BIGINT, overview_welfare_i_nationwide BIGINT, overview_welfare_ro_area BIGINT, overview_welfare_ro_nationwide BIGINT, overview_welfare_ha_area BIGINT, overview_welfare_ha_nationwide BIGINT, overview_welfare_ni_area BIGINT, overview_welfare_ni_nationwide BIGINT, overview_welfare_ho_area BIGINT, overview_welfare_ho_nationwide BIGINT, overview_welfare_he_area BIGINT, overview_welfare_he_nationwide BIGINT, overview_welfare_to_area BIGINT, overview_welfare_to_nationwide BIGINT, transport_results_total_distance_km_area BIGINT, transport_results_total_distance_km_nationwide BIGINT, transport_results_transported_persons_or_trips_persons_area BIGINT, transport_results_transported_persons_or_trips_persons_nationwide BIGINT, transport_results_transported_persons_or_trips_trips_area BIGINT, transport_results_transported_persons_or_trips_trips_nationwide BIGINT, transport_results_transport_revenue_thousand_yen_area BIGINT, transport_results_transport_revenue_thousand_yen_nationwide BIGINT, accidents_traffic_accidents_area BIGINT, accidents_traffic_accidents_nationwide BIGINT, accidents_serious_accidents_area BIGINT, accidents_serious_accidents_nationwide BIGINT, accidents_fatalities_area BIGINT, accidents_fatalities_nationwide BIGINT, accidents_injuries_area BIGINT, accidents_injuries_nationwide BIGINT, prefecture_code VARCHAR, geometry GEOMETRY, source_sha256 VARCHAR );