Block-Level Sociodemographic Dwelling Data for Barranquilla, Colombia from National Demographic Censuses 2005 and 2018

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 the proportion of dwellings with utility coverage and building material of dwellings per city block from census data, 2005 and 2018. The data were downloaded from the National Administrative Department of Statistics (DANE). The data were not validated independently.

Census data were provided at the level of persons, households, dwellings and spatial data (city blocks). To relate non-spatial and spatial data, city block codes (22 characters) were generated by concatenating the department code (2 characters), municipality (3 characters), class (1 character), rural sector (3 characters),rural section (2 characters), population center (3 characters), urban sector (4 characters), urban section (2 characters) and city block (2 characters).These codes were linked to the persons database. The 2005 and 2018 census had some records with missing information on water and sewer connection which were filled with the category "Not reported". Regarding the wall material variable, the 2005 census did not report this
information, so for that year this variable was filled in its entirety by the category “Not reported”. That same variable had some missing records in the 2018 census, which were managed in the same way. The 2005 and 2018 census data were merged into one dataset with the following attributes: city block code, census year, water connection, sewer connection and wall durability categories.