calgary-ca/historical-community-populations-jtpc-xgsh
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 1 year ago
Indexed 2 hours ago

Historical Community Populations

The population, occupied dwelling count, and person per unit calculation of Calgary communities since 1968.

These data are collected from different sources and may be based on community boundaries that do not align perfectly with current boundaries. Data from 1968-1977 and 2016-present reflect community boundaries in those years. Data from 1978-2015 are based on the community boundaries in 2016. Where community boundaries have changed substantially over time, this is captured in the "notes" column. Population and dwelling unit totals do not include "Residual Sub Areas", so they may differ slightly from the totals published in official Civic Census records.

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/historical-community-populations-jtpc-xgsh\".\"historical_community_populations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • historical_community_populations
     
     
     
     
     
Upstream Metadata