Road Traffic Mortality, YPLL, and Spatiotemporal Analysis – Medellín (2008–2025)

This dataset provides a comprehensive quantification of the social and economic burden of road traffic fatalities in Medellín, Colombia, from January 2008 to August 2025. It supports the research article titled "Quantifying the Social Burden and Spatiotemporal Concentration of Fatal Road Traffic Incidents in Medellín (2008–2025)"

The repository is structured to facilitate the replication of a two-phase methodological approach:

Phase I (Epidemiological & Economic Burden): Detailed calculation of Years of Potential Life Lost (YPLL) and the valuation of human capital loss using the Minimum Monthly Wage (SMLV) as a base unit. The analysis reveals a cumulative impact of 100,851 YPLL and an economic cost of 2.19 trillion COP.

Phase II (Spatiotemporal Analysis & Robustness): Georeferenced microdata of 2,762 fatalities, categorized by incident type. This phase includes the detection of critical clusters using the ICCE-T and a statistical robustness analysis (Moran’s I, Getis-Ord Gi*, and KDE sensitivity) provided in the accompanying R script.

Data & Code Structure:

Excel Workbook (Road_Traffic_Mortality_Medellin.xlsx): Contains five specialized sheets (Raw microdata, Age distribution proxies, YPLL matrices, and summary tables).

R Script (Robustness_Sensitivity_Analysis.R): Includes the code for spatial autocorrelation, local hotspot detection, and bandwidth sensitivity tests to ensure the stability of the findings.

This dataset is intended for urban planners, public health researchers, and transport engineers interested in urban resilience, Vision Zero policies, and the socio-economic determinants of road safety.