自動車運送事業の事故報告書の詳細情報(自動車運送事業における車両事故の概況(走行車両や事故状況、被害状況等)および事故に対する再発防止対策、ドライバーの運転状況・実績、当時の道路状況等の詳細情報)と交通事故統計情報(警察庁オープンデータ)に関する情報を統合したデータ(1,302レコード)
元の資料: 自動車運送事業の事故報告書データ(別記様式(第3条関係)、別表2 運転者の健康状態に起因する事故等の調査事項、別表3 車両故障事故報告書添付票)、交通事故統計情報データ(警察庁オープンデータ)
G空間情報センターのデータセット links-jidousyaunsoujigyoujiko-2025 の 01_jikohoukokusyo_koutsuujikotoukeijyouhou.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.motor_carrier_accidents ( accident_occurrence_date_and_time TIMESTAMP, weather_conditions VARCHAR, accident_location VARCHAR, latitude DOUBLE, longitude DOUBLE, line_or_road_name VARCHAR, vehicle_id BIGINT, circumstances_categories_1 VARCHAR, circumstances_categories_2 VARCHAR, circumstances_categories_3 VARCHAR, circumstances_subcategories_1 VARCHAR, circumstances_subcategories_2 VARCHAR, circumstances_subcategories_3 VARCHAR, prevention_measure_keyword_category_1 VARCHAR, prevention_measure_keyword_category_2 VARCHAR, prevention_measure_keyword_category_3 VARCHAR, prevention_measure_custom_keyword_1 VARCHAR, prevention_measure_custom_keyword_2 VARCHAR, prevention_measure_custom_keyword_3 VARCHAR, accident_type_category_overturn DOUBLE, accident_type_category_fall DOUBLE, accident_type_category_off_road BIGINT, accident_type_category_fire BIGINT, accident_type_category_railroad_crossing BIGINT, accident_type_category_collision BIGINT, accident_type_category_injury_or_fatality BIGINT, accident_type_category_hazardous_material BIGINT, accident_type_category_inside_vehicle BIGINT, accident_type_category_alcohol BIGINT, accident_type_category_health_related BIGINT, accident_type_category_aid_violation BIGINT, accident_type_category_vehicle_failure BIGINT, accident_type_category_traffic_obstruction BIGINT, accident_type_category_other BIGINT, accident_type_fall_condition_drop_height DOUBLE, accident_type_fall_condition_water_depth BIGINT, accident_type_collision_details VARCHAR, vehicle_details_model_name VARCHAR, vehicle_details_model_type VARCHAR, vehicle_details_body_type VARCHAR, vehicle_details_year_of_initial_registration BIGINT, vehicle_details_commercial_or_private VARCHAR, vehicle_details_category VARCHAR, vehicle_details_seating_capacity BIGINT, vehicle_details_number_of_occupants_at_the_time BIGINT, vehicle_details_maximum_load_capacity DOUBLE, vehicle_details_load_at_the_time DOUBLE, vehicle_details_cargo_contents VARCHAR, vehicle_details_hazardous_material_transported VARCHAR, vehicle_details_type_of_hazardous_material VARCHAR, road_conditions_type VARCHAR, road_conditions_width DOUBLE, road_conditions_incline VARCHAR, road_conditions_surface VARCHAR, road_conditions_pavement_conditions VARCHAR, road_conditions_warning_signs_installed VARCHAR, road_conditions_speed_limit BIGINT, road_conditions_railway_crossing_conditions VARCHAR, circumstances_speed_at_risk_recognition BIGINT, circumstances_distance_at_risk_recognition BIGINT, circumstances_slip_distance BIGINT, circumstances_vehicle_behavior_at_accident VARCHAR, circumstances_accident_location_on_road VARCHAR, circumstances_injuries_or_death_condition VARCHAR, circumstances_vehicle_fault_causing_accident VARCHAR, driver_details_age BIGINT, driver_details_years_of_experience_category VARCHAR, driver_details_permanent_or_temporary VARCHAR, driver_details_days_off_in_past_month BIGINT, driver_details_work_hours_before_accident VARCHAR, driver_details_distance_driven_before_accident DOUBLE, driver_details_days_worked_since_last_off_day BIGINT, driver_details_distance_driven_since_last_off_day DOUBLE, driver_details_damage_severity VARCHAR, driver_details_seatbelt_usage VARCHAR, driver_details_presence_of_relief_driver VARCHAR, driver_details_accident_history_in_last_3_years BIGINT, driver_details_traffic_law_violations_in_last_3_years VARCHAR, driver_details_aptitude_test_history_in_last_3_years VARCHAR, damage_level_death BIGINT, damage_level_death_passenger BIGINT, damage_level_serious_injury BIGINT, damage_level_serious_injury_passenger BIGINT, damage_level_minor_injury BIGINT, damage_level_minor_injury_passenger BIGINT, company_details_number_of_drivers_at_branch BIGINT, company_details_number_of_vehicles_at_branch BIGINT, vehicle_inspection_certificate_expiry_date VARCHAR, total_distance_driven_since_usage_start BIGINT, recent_major_modifications_details VARCHAR, recent_major_modifications_date_of_trial VARCHAR, recent_major_modifications_person_testing VARCHAR, distance_driven_since_installing_the_part BIGINT, part_equipment_maintenance_modification_1_date DATE, part_equipment_maintenance_modification_1_inspection VARCHAR, part_equipment_maintenance_modification_2_date DATE, part_equipment_maintenance_modification_2_inspection VARCHAR, part_equipment_maintenance_modification_3_date DATE, part_equipment_maintenance_modification_3_inspection VARCHAR, part_damage_or_detachment_status VARCHAR, failure_or_sudden_damage_type VARCHAR, administrative_area_code BIGINT, prefecture_name VARCHAR, subprefecture_or_promotion_bureau_name VARCHAR, county_or_designated_city_name VARCHAR, municipality_name VARCHAR, airbag_equipped_party_a BIGINT, airbag_equipped_party_b BIGINT, side_airbag_equipped_party_a BIGINT, side_airbag_equipped_party_b BIGINT, days_since_cognitive_test_party_a BIGINT, days_since_cognitive_test_party_b BIGINT, driving_practice_method_party_a BIGINT, driving_practice_method_party_b BIGINT, geometry VARCHAR, prefecture_code VARCHAR, geometry_1 GEOMETRY, source_sha256 VARCHAR );