Civic Census Results 1958-2019

The City of Calgary has been conducting the annual Civic Census since 1958. View the citywide and ward-level counts of dwelling units and residents over the past 60 years.

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/civic-census-results-19582019-rmai-qvzh\".\"civic_census_results_19582019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.