タクシーの輸送実績は、事業用自動車数、従業員数、運転者数、走行キロ、実車キロ、輸送人員、実働率、運送回数、営業収入、実働社1日1車あたり営業収入、交通事故件数、重大事故件数、死者数、負傷者数、1人平均乗車キロ、輸送人キロ、平均乗車密度等の実績に関する情報を、ランク化及び偏差値により秘匿化したデータ化です。(924レコード)
元の資料: 一般乗用旅客自動車運送事業輸送実績報告書
G空間情報センターのデータセット links-ippanryokyaku-2025 の 03_ippanjyouyouryokyaku_yusoujisseki.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.taxi_transport_results ( business_id BIGINT, hire_or_taxi_separation_hire BIGINT, hire_or_taxi_separation_taxi BIGINT, fiscal_year BIGINT, address VARCHAR, address_geometry GEOMETRY, businessoverview_jurisdiction_area1_name VARCHAR, businessoverview_jurisdiction_area1_businessvehicles_rank VARCHAR, businessoverview_jurisdiction_area1_employees_rank VARCHAR, businessoverview_jurisdiction_area1_drivers_rank VARCHAR, businessoverview_jurisdiction_area2_name VARCHAR, businessoverview_jurisdiction_area2_businessvehicles_rank VARCHAR, businessoverview_jurisdiction_area2_employees_rank VARCHAR, businessoverview_jurisdiction_area2_drivers_rank VARCHAR, businessoverview_jurisdiction_area3_name VARCHAR, businessoverview_jurisdiction_area3_businessvehicles_rank VARCHAR, businessoverview_jurisdiction_area3_employees_rank VARCHAR, businessoverview_jurisdiction_area3_drivers_rank VARCHAR, businessoverview_jurisdiction_area4_name VARCHAR, businessoverview_jurisdiction_area4_businessvehicles_rank VARCHAR, businessoverview_jurisdiction_area4_employees_rank VARCHAR, businessoverview_jurisdiction_area4_drivers_rank VARCHAR, businessoverview_jurisdiction_area5_name VARCHAR, businessoverview_jurisdiction_area5_businessvehicles_rank VARCHAR, businessoverview_jurisdiction_area5_employees_rank VARCHAR, businessoverview_jurisdiction_area5_drivers_rank VARCHAR, transportperformance_jurisdiction_area1_name VARCHAR, transportperformance_jurisdiction_area1_businessvehicles_totalregistered_rank VARCHAR, transportperformance_jurisdiction_area1_businessvehicles_totalactive_rank VARCHAR, transportperformance_jurisdiction_area1_businessvehicles_operationrate_rank VARCHAR, transportperformance_jurisdiction_area1_traveldistance_rank VARCHAR, transportperformance_jurisdiction_area1_passengerdistance_rank VARCHAR, transportperformance_jurisdiction_area1_passengerrate_rank VARCHAR, transportperformance_jurisdiction_area1_trips_rank VARCHAR, transportperformance_jurisdiction_area1_passengers_rank VARCHAR, transportperformance_jurisdiction_area1_revenue_rank VARCHAR, transportperformance_jurisdiction_area1_revenuepervehicleperday_rank VARCHAR, transportperformance_jurisdiction_area2_name VARCHAR, transportperformance_jurisdiction_area2_businessvehicles_totalregistered_rank VARCHAR, transportperformance_jurisdiction_area2_businessvehicles_totalactive_rank VARCHAR, transportperformance_jurisdiction_area2_businessvehicles_operationrate_rank VARCHAR, transportperformance_jurisdiction_area2_traveldistance_rank VARCHAR, transportperformance_jurisdiction_area2_passengerdistance_rank VARCHAR, transportperformance_jurisdiction_area2_passengerrate_rank VARCHAR, transportperformance_jurisdiction_area2_trips_rank VARCHAR, transportperformance_jurisdiction_area2_passengers_rank VARCHAR, transportperformance_jurisdiction_area2_revenue_rank VARCHAR, transportperformance_jurisdiction_area2_revenuepervehicleperday_rank VARCHAR, transportperformance_jurisdiction_area3_name VARCHAR, transportperformance_jurisdiction_area3_businessvehicles_totalregistered_rank VARCHAR, transportperformance_jurisdiction_area3_businessvehicles_totalactive_rank VARCHAR, transportperformance_jurisdiction_area3_businessvehicles_operationrate_rank VARCHAR, transportperformance_jurisdiction_area3_traveldistance_rank VARCHAR, transportperformance_jurisdiction_area3_passengerdistance_rank VARCHAR, transportperformance_jurisdiction_area3_passengerrate_rank VARCHAR, transportperformance_jurisdiction_area3_trips_rank VARCHAR, transportperformance_jurisdiction_area3_passengers_rank VARCHAR, transportperformance_jurisdiction_area3_revenue_rank VARCHAR, transportperformance_jurisdiction_area3_revenuepervehicleperday_rank VARCHAR, transportperformance_jurisdiction_area4_name VARCHAR, transportperformance_jurisdiction_area4_businessvehicles_totalregistered_rank VARCHAR, transportperformance_jurisdiction_area4_businessvehicles_totalactive_rank VARCHAR, transportperformance_jurisdiction_area4_businessvehicles_operationrate_rank VARCHAR, transportperformance_jurisdiction_area4_traveldistance_rank VARCHAR, transportperformance_jurisdiction_area4_passengerdistance_rank VARCHAR, transportperformance_jurisdiction_area4_passengerrate_rank VARCHAR, transportperformance_jurisdiction_area4_trips_rank VARCHAR, transportperformance_jurisdiction_area4_passengers_rank VARCHAR, transportperformance_jurisdiction_area4_revenue_rank VARCHAR, transportperformance_jurisdiction_area4_revenuepervehicleperday_rank VARCHAR, transportperformance_jurisdiction_area5_name VARCHAR, transportperformance_jurisdiction_area5_businessvehicles_totalregistered_rank VARCHAR, transportperformance_jurisdiction_area5_businessvehicles_totalactive_rank VARCHAR, transportperformance_jurisdiction_area5_businessvehicles_operationrate_rank VARCHAR, transportperformance_jurisdiction_area5_traveldistance_rank VARCHAR, transportperformance_jurisdiction_area5_passengerdistance_rank VARCHAR, transportperformance_jurisdiction_area5_passengerrate_rank VARCHAR, transportperformance_jurisdiction_area5_trips_rank VARCHAR, transportperformance_jurisdiction_area5_passengers_rank VARCHAR, transportperformance_jurisdiction_area5_revenue_rank VARCHAR, transportperformance_jurisdiction_area5_revenuepervehicleperday_rank VARCHAR, accidents_jurisdiction_area1_name VARCHAR, accidents_jurisdiction_area1_trafficaccidents_rank VARCHAR, accidents_jurisdiction_area1_seriousaccidents_rank VARCHAR, accidents_jurisdiction_area1_deaths_rank VARCHAR, accidents_jurisdiction_area1_injuries_rank VARCHAR, accidents_jurisdiction_area2_name VARCHAR, accidents_jurisdiction_area2_trafficaccidents_rank VARCHAR, accidents_jurisdiction_area2_seriousaccidents_rank VARCHAR, accidents_jurisdiction_area2_deaths_rank VARCHAR, accidents_jurisdiction_area2_injuries_rank VARCHAR, accidents_jurisdiction_area3_name VARCHAR, accidents_jurisdiction_area3_trafficaccidents_rank VARCHAR, accidents_jurisdiction_area3_seriousaccidents_rank VARCHAR, accidents_jurisdiction_area3_deaths_rank VARCHAR, accidents_jurisdiction_area3_injuries_rank VARCHAR, accidents_jurisdiction_area4_name VARCHAR, accidents_jurisdiction_area4_trafficaccidents_rank VARCHAR, accidents_jurisdiction_area4_seriousaccidents_rank VARCHAR, accidents_jurisdiction_area4_deaths_rank VARCHAR, accidents_jurisdiction_area4_injuries_rank VARCHAR, accidents_jurisdiction_area5_name VARCHAR, accidents_jurisdiction_area5_trafficaccidents_rank VARCHAR, accidents_jurisdiction_area5_seriousaccidents_rank VARCHAR, accidents_jurisdiction_area5_deaths_rank VARCHAR, accidents_jurisdiction_area5_injuries_rank VARCHAR, prefecture_code VARCHAR, source_sha256 VARCHAR );