Weekly road traffic collision (AXA Mexico) & weekly road traffic deaths
Data files
Aug 21, 2023 version files 111.09 KB
-
AXA_colisions_2015-2019.xls
50.69 KB
-
README.txt
1.52 KB
-
Road_traffic_deaths_2013-2019.xls
58.88 KB
Abstract
Dataset 1 (AXA collisions 2015–2019) was curated and used to evaluate the effect of two road traffic regulations implemented in Mexico City in 2015 and 2019 on collisions using an interrupted time series analysis. Collisions data came from insurance collision claims (January 2015 to December 2019). The dataset contains 8 variables: year (anio_n), week (semana), count of total collisions per week (c_total), count of collisions resulting in injury per week (c_p_lesion), binary variable to identify the 2015 intervention (limit), binary variable to identify the 2019 intervention (limit1), the number of weeks from baseline (time), an estimate of the number of insured vehicles per week (veh_a_cdmx).
Dataset 2 (Road traffic deaths 2013–2019) was curated and used to evaluate the effect of two road traffic regulations implemented in Mexico City in 2015 and 2019 on mortality using an interrupted time series analysis. Mortality data came from vital registries collated by the Mexican Institute for Geography and Statistics, INEGI, (January 2013 to December 2019). The dataset contains 7 variables: year (anio_ocur), week (semana), count of traffic-related deaths per week (def_trans), binary variable to identify the 2015 intervention (limit), binary variable to identify the 2019 intervention (limit1), the number of weeks from baseline (time) and an estimate of the Mexico City population per week (pob_tot_p).
Dataset 1 arises from publicly available data on insurance-reported collisions published on the website of the International Institute for Data Science (see reference below). The data were collected by claims adjusters from the company AXA at the site of the collision using an electronic device. These data were available for public use from January 2015 to December 2019 and include information on individual collisions and their characteristics: date the collision occurred, location (coordinates and adjuster reported location), type of vehicle involved and whether there were injuries or deaths. Data were processed and cleaned, mapping collisions, and keeping only those georeferenced within Mexico City boundaries as well as coded to Mexico City in the reported location variable. We then summed the number of collisions per week and merged it with data on an estimate of the number of insured registered vehicles per week (using information from registered vehicles and proportion of insured vehicles from the Mexican Association of Insurance companies). Two more variables were created, one that identifies the week when the intervention came into effect and another variable to number the weeks since baseline. This dataset contains all the necessary information to conduct the interrupted time series analysis for total collisions and collisions resulting in injuries.
Dataset 2: mortality data were validated and reported by INEGI (see reference below) from death certificates filed mainly by the Health Sector, using the International Classification of Disease, 10th Revision (ICD-10) for diagnosis codes. We used data from January 2013 to December 2019 and included deaths with the following ICD-10 codes: V02-V04 (.1-.9), V09, V092, V09.3, V09.9, V12-V14 (.3-.9), V19.4-V19.6, V19.9, V20-V28 (.3-.9), V29, V30-V39, V40-V79 (.4-.9), V80.3-V80.5, V81.1, V82.1, V82.1, V83-V86 (.0-.3), V87-V89.2 and V89.9. We summed the number of traffic-related deaths per week and merged it with data on an estimate of the total population in Mexico City per week (see refs below). Two more variables were created, one that identifies the week when the intervention came into effect and another variable to number the weeks since baseline. This dataset contains all the necessary information to conduct the interrupted time series analysis for road traffic deaths.
References to original data:
- Instituto Internacional de Ciencia de Datos. Datos AXA de Percances Viales [Internet]. 2020 [July 2021]. Available from: https://i2ds.org/datos-abiertos/.
- Instituto Nacional de Geografía y Estadística. Parque Vehicular [Internet]. 2019 [July 2021]. Available from: https://www.inegi.org.mx/temas/vehiculos/default.html#Tabulados.
- Dirección Ejecutiva de Líneas de Negocio área de Automóviles. Sistema Estadístico del Sector Asegurador del ramo Automóviles SESA 2018. Mexico City: Asociación Mexicana de Instituciones de Seguro, 2020.
- Instituto Nacional de Geografía y Estadística. Mortalidad [Internet]. 2020 [July 2021]. Available from: https://www.inegi.org.mx/programas/mortalidad/default.html#Datos_abiertos.
- World Health Organisation. ICD-10 Version:2010 [Internet]. 2010 [July 2021]. Available from: https://icd.who.int/browse10/2010/en.
- Consejo Nacional de Población. Proyecciones de la Población de México y de las Entidades Federativas, 2016-2050 [Internet]. 2018 [July 2021]. Available from: https://datos.gob.mx/busca/dataset/proyecciones-de-la-poblacion-de-mexico-y-de-las-entidades-federativas-2016-2050.