2016 Census of Canada - Citizenship

This is Statistics Canada collected census data for 2016. The data refers only to the population in private households. Residents of collective dwellings (dwellings of a commercial, institutional or communal nature) are excluded. Calgary geographic boundaries are from the municipal 2021 Census by Ward.

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 \"calgary-ca/2016-census-of-canada-citizenship-hj7c-iwum\".\"2016_census_of_canada_citizenship\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.