Published January 10, 2023 | Version 1.0
Dataset Open

Interurban road accidents with casualties in Spain (2016-2021)

Authors/Creators

Description

CSV that contains 1.000 records of interurban road accidents with casualties in Spain between 2016 and 2021. If you are interested in the whole country dataset, please do not hesitate to contact me and I will forward it to you. 

Data source of each record is the Spanish General Directorate of Traffic (DGT) and each row describes an accident by the following fields:

•        secuencial (int): the unique identifier for an occurrence record in DGT.
•        anyo (int): the four-digit year of the event date.
•        mes (int): the month as integer of the event date (encoded).
•        nombre_mes (str): the month name of the event date (decoded).
•        dia_semana (int): the integer day of the week when the accident occurred (encoded).
•        nombre_dia_semana (str): the name of the day when the accident occurred (decoded).
•        hora (int): the reported hour of the collision in 24-hour notation.
•        cod_provincia (int): the province code from INE where the accident is registered (encoded).
•        nombre_provincia (str): the province name where the accident is registered (decoded).
•        cod_municipio (int): the municipality code from INE where the accident is registered (encoded).
•        nombre_codigo_municipio (str): the municipality name where the accident is registered (decoded).
•        isla (str): an integer value to identify a Spanish island if the accident occurred out of the peninsula (encoded).
•        nombre_isla (str): the island name if applicable to the accident (decoded).
•        zona (int): an integer value to identify type of road (encoded).
•        nombre_zona (str): the name of the road type (decoded).
•        zona_agrupada (int): an integer value to group the road types in urban or interurban (encoded).
•        nombre_zona_agrupada (str): the group name of the road types (decoded).
•        carretera (str): the road attending to the national road numbering system in Spain where the accident is located.
•        km (int): the kilometre point of the road where the accident is located.
•        sentido_1f (int): the vehicle’s direction of traffic reported as integer when the accident occurred (encoded).
•        nombre_sentido (str): the vehicle’s direction of traffic reported when the accident occurred (decoded).
•        titularidad_via (int): the road ownership type as integer (encoded).
•        nombre_titularidad_via (str): the road ownership type description (decoded).
•        tipo_via (int): the type of road as integer attending to the project road classification (encoded).
•        nombre_tipo_via (str): the type of road description attending to the project road classification (decoded).
•        tipo_accidente (int): an integer value to identify the collision type and traffic context (encoded).
•        nombre_tipo_accidente (str): the description of the collision type and traffic context (decoded).
•        total_mu24h (int): the total number of fatalities registered in the accident, computed to 24 hours.
•        total_hg24h (int): the total number of hospitalised casualties recorded in the accident, counted over 30 days.
•        total_hl24h (int): the total number of non-hospitalised casualties recorded in the accident, computed to 24 hours.
•        total_victimas_24h (int): the total number of casualties (fatalities + hospitalised injured + non-hospitalised injured) recorded in the accident, computed over 24 hours.
•        total_mu30df (int): the total number of fatalities recorded in the accident, computed over 30 days.
•        total_hg30df (int): the total number of hospitalised casualties recorded in the accident, counted over 30 days.
•        total_hl30df (int): the total number of non-hospitalised casualties recorded in the accident, counted over 30 days.
•        total_victimas_30df (int): the total number of casualties (killed + injured in hospital + injured not in hospital) recorded in the accident, counted over 30 days.
•        total_vehiculos (int): the total number of vehicles involved recorded in the accident.
•        tot_peat_mu24h (int): the total number of pedestrian fatalities recorded in the accident, computed over 24 hours.
•        tot_bici_mu24h (int): the total number of cyclists killed recorded in the accident, computed to 24 hours.
•        tot_ciclo_mu24h (int): the total number of scooter riders killed recorded in the accident, computed on a 24-hour basis.
•        tot_moto_mu24h (int): the total number of motorcyclist fatalities recorded in the accident, computed on a 24-hour basis.
•        tot_tur_mu24h (int): the total number of car drivers and passengers killed recorded in the accident, counted to 24 hours.
•        tot_furg_mu24h (int): the total number of van drivers and passengers killed recorded in the accident, counted over 24 hours.
•        tot_cam_menos3500_mu24h (int): the total number of drivers and passengers of trucks ≤ 3,500 kg killed in the accident, counted over 24 hours.
•        tot_cam_mas3500_mu24h (int): the total number of drivers and passengers of trucks > 3,500 kg killed in the accident, counted over 24 hours.
•        tot_bus_mu24h (int): the total number of bus drivers and passengers fatalities recorded in the accident, counted over 24 hours.
•        tot_otro_mu24h (int): the total number of drivers and passengers of vehicles not classified in the above types killed in the accident, counted to 24 hours.
•        tot_sinespecif_mu24h (int): the total number of drivers and passengers of vehicles of unspecified type killed in the accident, counted over 24 hours.
•        tot_peat_mu30df (int): the total number of pedestrian fatalities recorded in the accident, computed to 30 days.
•        tot_bici_mu30df (int): the total number of cyclists killed recorded in the accident, counted over 30 days.
•        tot_ciclo_mu30df (int): the total number of scooted riders killed recorded in the accident, counted over 30 days.
•        tot_moto_mu30df (int): the total number of motorcyclist fatalities recorded in the accident, counted over 30 days.
•        tot_tur_mu30df (int): the total number of drivers and passengers of passenger cars killed in the accident, counted over 30 days. 
•        tot_furg_mu30df (int): the total number of van drivers and passengers killed recorded in the accident, counted over 30 days. 
•        tot_cam_menos3500_mu30df (int): the total number of drivers and passengers of trucks ≤ 3,500 kg killed in the accident, counted over 30 days.
•        tot_cam_mas3500_mu30df (int): the total number of drivers and passengers of trucks > 3,500 kg killed in the accident, counted over 30 days.
•        tot_bus_mu30df (int): the total number of bus drivers and passengers fatalities recorded in the accident, counted over 30 days.
•        tot_otro_mu30df (int): the total number of drivers and passengers of vehicles of types not classified in the above killed in the accident, counted over 30 days.
•        tot_sinespecif_mu30df (int): the total number of drivers and passengers of unspecified type vehicles killed in the crash, counted over 30 days.
•        nudo (int): an integer to identify whether the collisions occurred in an road junction or not (encoded).
•        nombre_nudo (str): the description to identify whether the collisions occurred in an road junction or not (decoded).
•        nudo_info (int): an integer that represents the type of road junction in which the collision occurred (encoded).
•        nombre_nudo_info (str): the description of the type of road junction in which the collision occurred (decoded).
•        carretera_cruce (str): the road attending to the national road numbering system in Spain where the accident is located.
•        priori_norma (int): an integer to identify if the road junction priority is determined by generic traffic rule (encoded).
•        nombre_priori_norma (str): the text to identify if the road junction priority is determined by generic traffic rule (decoded).
•        priori_agente (int): an integer to identify if the road junction priority is determined by agent (encoded).
•        nombre_priori_agente (str): the text to identify if the road junction priority is determined by agent (decoded).
•        priori_semaforo (int): an integer to identify if the road junction priority is determined by traffic light (encoded).
•        nombre_priori_semaforo (str): the text to identify if the road junction priority is determined by traffic light (decoded).
•        priori_vert_stop (int): an integer to identify if the road junction priority is determined by vertical stop sign (encoded).
•        nombre_priori_vert_stop (str): the text to identify if the road junction priority is determined by vertical stop sign (decoded).
•        priori_vert_ceda (int): an integer to identify if the road junction priority is determined by vertical yield sign (encoded).
•        nombre_priori_priori_vert_ceda (str): the text to identify if the road junction priority is determined by vertical yield sign (decoded).
•        priori_horiz_stop (int): an integer to identify if the road junction priority is determined by horizontal stop signal (encoded).
•        nombre_priori_horiz_stop (str): the text to identify if the road junction priority is determined by horizontal stop signal (decoded).
•        priori_horiz_ceda (int): an integer to identify if the road junction priority is determined by horizontal yield sign (encoded).
•        nombre_priori_horiz_ceda (str): the text to identify if the road junction priority is determined by horizontal yield sign (decoded).
•        priori_marcas (int): an integer to identify if the road junction priority is determined by road markings (encoded).
•        nombre_priori_marcas (str): the text to identify if the road junction priority is determined by road markings (decoded).
•        priori_pea_no_elev (int): an integer to identify if the road junction priority is determined by pedestrian crosswalk (encoded).
•        nombre_priori_pea_no_elev (str): the text to identify if the road junction priority is determined by pedestrian crosswalk (decoded).
•        priori_pea_elev (int): an integer to identify if the road junction priority is determined by raised pedestrian crossing (encoded).
•        nombre_priori_pea_elev (str): the text to identify if the road junction priority is determined by raised pedestrian crossing (decoded).
•        priori_marca_ciclos (int): an integer to identify if the road junction priority is determined by the bicycle crossing road marking (encoded).
•        nombre_priori_marca_ciclos (str): the text to identify if the road junction priority is determined by the bicycle crossing road marking (decoded).
•        priori_circunstancial (int): an integer to identify if the road junction priority is determined by signal used on an circumstantial basis (encoded).
•        nombre_priori_circunstancial (str): the text to identify if the road junction priority is determined by signal used on an circumstantial basis (decoded).
•        priori_otra (int): an integer to identify if the road junction priority is determined by other signalling not considered in the above (encoded).
•        nombre_priori_otra (str): the text to identify if the road junction priority is determined by other signalling not considered in the above (decoded).
•        condicion_nivel_circula (int): an integer to identify the condition of the traffic level at the place and time of the accident attending to DGT classification (encoded).
•        nombre_condicion_nivel_circula (str): the text to identify the condition of the traffic level at the place and time of the accident attending to DGT classification (decoded).
•        condicion_firme (int): an integer to classify the condition of the road surface at the scene of the accident (encoded).
•        nombre_condicion_firme (str): the text to classify the condition of the road surface at the scene of the accident (decoded).
•        condicion_iluminacion (int): an integer to identify the lighting conditions at the place and time of the accident (encoded).
•        nombre_condicion_iluminacion (str): the text to identify the lighting conditions at the place and time of the accident (decoded).
•        condicion_meteo (int): an integer to classify the meteorological conditions at the place and time of the accident (encoded).
•        nombre_condicion_meteo (str): the text to classify the meteorological conditions at the place and time of the accident (decoded).
•        condicion_niebla (int): an integer to identify the meteorological condition with regard to fog at the place and time of the accident (encoded).
•        nombre_condicion_niebla (str): the text to identify the meteorological condition with regard to fog at the place and time of the accident (decoded).
•        condicion_viento (int): an integer to classify the meteorological condition referring to wind at the place and time of the accident (encoded).
•        nombre_condicion_viento (str): the text to classify the meteorological condition referring to wind at the place and time of the accident (decoded).
•        visib_restringida_por (int): an integer to identify the elements affecting visibility at the scene of the accident (encoded).
•        nombre_visib_restringida_por (str): the text to identify the elements affecting visibility at the scene of the accident (decoded).
•        acera (int): an integer to classify the condition of the pavement. Only if the accident involved a pedestrian (encoded).
•        nombre_acera (str): the text to classify the condition of the pavement. Only if the accident involved a pedestrian (decoded).
•        trazado_planta (int): an integer to identify road layout in plan. Only on interurban roads (encoded).
•        nombre_trazado_planta (str): the text to identify road layout in plan. Only on interurban roads (decoded).
•        latitud (float): the latitude of the accident location coordinate in decimal degrees.
•        longitud (float): the length of the accident location coordinate in decimal degrees.
•        geom (geometry): geometry from latitude and longitude position. Developed for this project.

The context is the Final Master's Degree Project 'Analysis and Predictive Modelling of Wildlife–Vehicle Collision on Interurban Roads in Spain' (Data Science Master’s Degree of Universitat Oberta de Catalunya - UOC).

This dataset is the output of the interurban road accidents with casualties analysis and the code repository is available on GitHub.

Files

sample_car_accident_spain.csv

Files (714.7 kB)

Name Size Download all
md5:37f9fbcc0a17740cc96a218fceef17c7
714.7 kB Preview Download