Calgary Equity Index Overlay Statistics

The Calgary Equity Index Overlay Statistics are derived from Citizen Satisfaction surveys and census demographics.

The Calgary Equity Index is a decision-making tool designed to measure equity in Calgary, based on a social determinant of health (SDOH) framework. The SDOH are the range of interacting social and economic conditions that influence people’s health and well-being. This index provides an equity lens to examine the ways in which social and economic conditions are experienced and distributed among populations. It will help the City examine where inequities exist in different areas. Information is available for 113 Community Service Areas (CSAs) across Calgary. The CSAs were created by combining two adjacent Census Tracts to reach a population of around 10,000. The CSAs are numbered from 1 to 113, and are displayed on the map.

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/calgary-equity-index-overlay-statistics-7g5f-dkmi\".\"calgary_equity_index_overlay_statistics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.