Police-Reported Homicides in Bogota by Planning Zone Units, Colombia, 2012-2022

This dataset is part of the ESCALA (Study of Urban Health and Climate Change in Informal Settlements in Latin America) project that was funded by the Lacuna Fund of the Meridian Institute https://lacunafund.org/.

This dataset contains homicide cases reported by police in the municipal area of Bogotá, 2012-2022, by Planning Zone Units (UPZ - Unidad de Planeamiento Zonal). Data were provided by the Statistical, Criminal, Contraventional, and Operational Information System (SIEDCO). (1) Anomalous values in the column "HOMCOUNT" that may exceed realistic homicide counts (e.g., outliers or values below 0). (2) Missing or incomplete data for some UPZs where no homicides were reported. (3) Potential misalignment between UPZs in the dataset and official geographic definitions. (4) If "HOMRATE" includes calculated rates, errors may occur due to incorrect population denominators or missing population data for specific years. Data preprocessing included (1) flagging records with anomalous values in "HOMCOUNT" for further investigation while retaining them for analysis, (2) verifying missing "ID_UPZ" values against secondary sources to match the homicide data with official UPZs (3) checking the accuracy of population estimates for corresponding UPZs in cases where "HOMRATE" was calculated.