2011 National Household Survey (NHS) - Income by Census Tracts, Dissemination Areas, Wards and Urban Service Areas

The data shows income frequency distribution for individuals and households in four different boundary types. The data was provided by Statistics Canada but it has been sectioned and transposed. The fields come from NHS profile reports of Statistics Canada and some information may not be available for all the boundaries. The fields have been arranged in the same order as NHS profile reports. To see a more complete description of the fields click on this link: http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/Page.cfm?Lang=E&Geo1=CSD&Code1=4811052&Data=Count&SearchText=Strathcona%20County&SearchType=Begins&SearchPR=01&A1=All&B1=All&GeoLevel=PR&GeoCode=10#tabs1

The field “Household income in 2010 of private households” in the Income of Households in 2010 section is not included in the data to avoid redundancy.

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 \"strathcona-ca/2011-national-household-survey-nhs-income-by-msd8-fzjh\".\"2011_national_household_survey_nhs_income_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.