自動車運送事業の事故報告書の概要情報(事故発生日時、車両概要・積載量等、事故発生までの乗務時間・距離、死亡者・重傷者数等)を有するデータ(494,308レコード、2003~2023年度の20年間)
元の資料: 自動車運送事業の事故報告書データ(別記様式(第3条関係)、別表3 車両故障事故報告書添付票)
G空間情報センターのデータセット links-jidousyaunsoujigyoujiko-2024 の 02_jikohoukokusyo.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.motor_carrier_accident_reports ( occurrence_date_and_time TIMESTAMP, weather VARCHAR, location VARCHAR, latitude DOUBLE, longitude DOUBLE, vehicle_id BIGINT, accident_type_category VARCHAR, order_of_accident_occurrence VARCHAR, fall_height DOUBLE, water_depth DOUBLE, collision_condition VARCHAR, vehicle_1_model_name VARCHAR, vehicle_1_model_type VARCHAR, vehicle_1_body_type VARCHAR, vehicle_1_year_of_initial_registration_inspection BIGINT, vehicle_1_seating_capacity BIGINT, vehicle_1_load_at_the_time BIGINT, vehicle_1_maximum_load_capacity BIGINT, cargo_contents VARCHAR, transport_of_hazardous_material VARCHAR, type_of_hazardous_material VARCHAR, road_type VARCHAR, road_surface_condition VARCHAR, warning_signs_installed VARCHAR, speed_limit_on_road BIGINT, railway_crossing_condition VARCHAR, speed_at_risk_recognition BIGINT, distance_at_risk_recognition BIGINT, slip_distance BIGINT, vehicle_behavior_at_accident VARCHAR, accident_location VARCHAR, condition_of_injured_or_deceased VARCHAR, fault_location VARCHAR, permanent_temporary VARCHAR, days_off_in_the_past_month_before_accident BIGINT, working_hours_until_accident VARCHAR, distance_driven_until_accident BIGINT, days_worked_since_last_day_off BIGINT, total_distance_driven_since_last_day_off BIGINT, damage_level VARCHAR, seatbelt_usage VARCHAR, number_of_accidents BIGINT, number_of_violations BIGINT, number_of_deaths BIGINT, number_of_deaths_passengers BIGINT, number_of_serious_injuries BIGINT, number_of_serious_injuries_passengers BIGINT, number_of_minor_injuries BIGINT, number_of_minor_injuries_passengers BIGINT, total_driven_distance BIGINT, modification_contents VARCHAR, date_of_modification DATE, broken_or_detached_part_name VARCHAR, driven_distance_since_installation BIGINT, modification_date_1 DATE, modification_date_2 DATE, modification_date_3 DATE, fatigue_or_sudden_breakage_type VARCHAR, geometry GEOMETRY, source_sha256 VARCHAR );