道路運送法に基づき、自家用車を使って有償で旅客を運送するサービスを行う事業者が、運輸局に登録した内容を記録したもので、登録年月日、運送の種別、路線又は運送の区域、運送する旅客の範囲、自動車の数等に関する情報をテータ化したものです。(35レコード)
元の資料: 自家用有償旅客運送者登録簿
G空間情報センターのデータセット links-rideshare-2025 の 02_jikayouyuushouryokyakuunsou_tourokubo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.rideshare_registry ( id BIGINT, registration_date DATE, updated_registration_date DATE, address VARCHAR, transport_type VARCHAR, route_or_transport_area VARCHAR, notes VARCHAR, office_name_1_private_paid_passenger_vehicle_count_sleeper_light BIGINT, office_name_1_private_paid_passenger_vehicle_count_wheelchair_light BIGINT, office_name_1_private_paid_passenger_vehicle_count_multi_purpose_light BIGINT, office_name_1_private_paid_passenger_vehicle_count_sedan_light BIGINT, office_name_1_private_paid_passenger_vehicle_count_bus BIGINT, office_name_1_private_paid_passenger_vehicle_count_total_light BIGINT, office_name_2_private_paid_passenger_vehicle_count_sleeper_light BIGINT, office_name_2_private_paid_passenger_vehicle_count_wheelchair_light BIGINT, office_name_2_private_paid_passenger_vehicle_count_multi_purpose_light BIGINT, office_name_2_private_paid_passenger_vehicle_count_sedan_light BIGINT, office_name_2_private_paid_passenger_vehicle_count_bus BIGINT, office_name_2_private_paid_passenger_vehicle_count_total_light BIGINT, office_name_3_private_paid_passenger_vehicle_count_sleeper_light BIGINT, office_name_3_private_paid_passenger_vehicle_count_multi_purpose_light BIGINT, office_name_3_private_paid_passenger_vehicle_count_sedan_light BIGINT, office_name_3_private_paid_passenger_vehicle_count_bus BIGINT, office_name_3_private_paid_passenger_vehicle_count_total_light BIGINT, office_name_4_private_paid_passenger_vehicle_count_sleeper_light BIGINT, office_name_4_private_paid_passenger_vehicle_count_multi_purpose_light BIGINT, office_name_4_private_paid_passenger_vehicle_count_bus BIGINT, office_name_4_private_paid_passenger_vehicle_count_total_light BIGINT, prefecture_code VARCHAR, source_sha256 VARCHAR );