Population and Housing Censuses Indicators of Latin America and the Caribbean

The Population and Housing Censuses database contains the censuses harmonized in such a way as to provide comparable census information over time and across countries. The variables in these databases are constructed under a common approach and structure, with standardized names, definitions, and disaggregations, and stored in a single file for each country. Currently, the harmonization of Population and Housing Censuses includes databases for 22 countries.

The indicators are categorized into seven themes: demographics, education, labor market, housing, income, migration, and diversity. When possible, we add multiple disaggregations for indicators. The available disaggregations are ethnicity, gender, age, education level, and area of geographic residence.

The management and harmonization of this database are provided by the Social Sector (SCL) of the Vice Presidency of Knowledge and Sectors to strengthen the analytical content of projects and studies.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"mydata-iadb/population-and-housing-censuses-indicators-of-864b-aqed\".\"population_and_housing_censuses_indicators_of\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.