遇见数据集

Weekly road traffic collision (AXA Mexico) & weekly road traffic deaths

收藏
Mendeley Data2024-04-13 更新2024-06-28 收录
官方服务:

资源简介:

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.

数据集1源自国际数据科学学会(International Institute for Data Science)官网发布的公开保险报案碰撞事故数据(详见下文参考文献)。这些数据由安盛(AXA)公司的理赔查勘员在事故现场使用电子设备采集。该数据集的公开使用时段为2015年1月至2019年12月,涵盖单起碰撞事故及其特征信息:事故发生日期、事发地点(坐标及查勘员上报的位置)、涉事车辆类型,以及是否存在人员受伤或死亡情况。 研究人员对数据进行了加工与清洗,针对碰撞事故进行地理映射,仅保留墨西哥城境内具备地理坐标信息,且上报位置变量编码为墨西哥城的样本。随后按周统计碰撞事故总数量,并与每周注册投保车辆数量的估算数据进行合并(该估算数据基于墨西哥保险协会提供的注册车辆信息及投保车辆占比)。此外还构建了两个额外变量:一个用于标识干预措施生效的周次,另一个用于标记自基准期起的周序数。本数据集包含开展全量碰撞事故、致伤碰撞事故的间断时间序列分析所需的全部必要信息。 数据集2:死亡率数据由墨西哥国家地理与统计局(Instituto Nacional de Geografía y Estadística, INEGI)基于卫生部门主要提交的死亡证明进行验证并发布,诊断编码采用国际疾病分类第10版(International Classification of Disease, 10th Revision, ICD-10)。我们使用了2013年1月至2019年12月的数据集,纳入以下ICD-10编码对应的死亡案例: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及V89.9。按周统计道路交通相关死亡人数后,与墨西哥城每周总人口估算数据进行合并(详见下文参考文献)。同样构建了两个额外变量:一个用于标识干预措施生效的周次,另一个用于标记自基准期起的周序数。本数据集包含开展道路交通死亡人数间断时间序列分析所需的全部必要信息。 原始数据参考文献: 1. 国际数据科学学会(International Institute for Data Science). AXA道路事故数据[互联网]. 2020 [2021年7月检索]. 可从以下网址获取:https://i2ds.org/datos-abiertos/。 2. 墨西哥国家地理与统计局(Instituto Nacional de Geografía y Estadística). 机动车保有量[互联网]. 2019 [2021年7月检索]. 可从以下网址获取:https://www.inegi.org.mx/temas/vehiculos/default.html#Tabulados。 3. 安盛汽车业务线执行管理部. 汽车保险行业统计系统SESA 2018[R]. 墨西哥城:墨西哥保险机构协会,2020。 4. 墨西哥国家地理与统计局. 死亡率数据[互联网]. 2020 [2021年7月检索]. 可从以下网址获取:https://www.inegi.org.mx/programas/mortalidad/default.html#Datos_abiertos。 5. 世界卫生组织. 国际疾病分类第10版(ICD-10)2010版[互联网]. 2010 [2021年7月检索]. 可从以下网址获取:https://icd.who.int/browse10/2010/en。 6. 墨西哥全国人口委员会. 墨西哥及联邦实体人口预测(2016-2050)[互联网]. 2018 [2021年7月检索]. 可从以下网址获取:https://datos.gob.mx/busca/dataset/proyecciones-de-la-poblacion-de-mexico-y-de-las-entidades-federativas-2016-2050。

创建时间:
2023-09-12
二维码
社区交流群
二维码
科研交流群
商业服务