Canadian Household Wealth Data 2020

Retail
tick

Annual Data

tick

Updated Annually

tick

> 2020

tick

At Postal and Census Geographies

tick

Canada

Summary

The dollar value of Canadian households' income, assets and debts for both Census and Postal geographies

This is a sample visualization of a small subset of this data product.
Loading...
Charts of Canadian Household Wealth Data 2020

Key Features

  • Canadian coverage at postal and census geographies
  • Dollar amounts of household income, assets and debts
  • Modeled by industry experts with economic and mathematical backgrounds
  • Lower level geographies roll up to higher level geographies ensuring data consistency
  • Suitable for geo-spatial applications

Documentation

Applications

  • Wealth data is useful in bank, ATM and retail location optimization planning. It helps define where the opportunity is to reach the right type of customer (by market, region, postal code, etc.). For example, if opening a new financial institution where are the households that have a higher than average value of assets potentially for investing?
  • Businesses can use wealth data to determine the next best steps on how to expand and optimize their product offerings. By understanding the wealth profile and segments of consumers and the trade area, businesses can focus on offering the right product mix to meet needs of their customer base. For example, a financial institution may offer full service brokerage services if their customer base likes to trade in stocks and bonds.
  • Wealth data is useful in targeting applications when a company is trying to locate top prospect households to direct communication messages to in marketing efforts.
  • Wealth data is essential in the not-for-profit sector to find out which donors have the potential to give a major gift.
  • Wealth data is integral for policy development and for the implementation and evaluation across a range of areas including fiscal, monetary, taxation, social welfare and housing policy.

Overview

This data product provides 2020 Wealth Data at the Postal and Census geographies for Canada. The geographic hierarchy is provided to allow for geographic aggregations by Province, FSA Forward Sortation Area, DA Dissemination Area, CD Census Division, etc.

Update
  • Annual
Dimension Coverage
  • Canadian postal geography (FSA and FSALDU) and census geographies (Province, CMA/CA, CSD, CD, DA, Community). Note: data is based on Canada Post 6 digit postal code household count data. There is a no statistically appropriate data to differentiate Statistics Canada data at the postal code level. As a result, demographic statistics, when used at the average level, are only differentiated to the Statistics Canada Dissemination Area level (56,582 areas).
Variable Coverage
  • Income, assets and debt variables
Data Input Sources
  • Data sources are Statistics Canada Census, Survey of Financial Security, Taxfiler and Canada Post

Dictionary

Filter
Column
Title
Data Type
Description
yearUpdate YearTextUpdate year of the data
dateDateDateUpdate year of the data point
post_code6 Digit Postal CodeTextCanada Post 6 Digit Postal Code
provProvinceTextIncludes 10 Canadian Provinces. Excludes the Nunuvat, the Yukon and Northwest Territories
fsa_codeForward Sortation Area (FSA) CodeTextForward Sortation Area
fsa_nameForward Sortation Area (FSA) NameTextForward Sortation Area Name
fsa_area_typeFSA Area TypeTextIndicates if the area is urban or rural
fsa_regionFSA RegionTextThe region name of the first character of the FSA code that is defined by Canada Post Corporation
cd_codeCensus Division CodeTextStatistics Canada (STC) Census Division Unique Identifier Code
cd_nameCensus Division NameTextSTC Census Division Name
cd_name_and_codeCensus Division Name & CodeTextSTC Census Division Name & Code (Hierarchy: Geography/Census Division)
csd_codeCensus Subdivision CodeTextSTC Census Subdivision Identifier Code
csd_nameCensus Subdivision NameTextSTC Census Subdivision Name
csd_name_and_codeCensus Subdivision Name & CodeTextSTC Census Subdivision Name & Unique Identifier Code (Hierarchy: Geography/Census Sub Division)
csd_typeCensus Subdivision TypeTextCensus Subdivision Type
cma_ca_codeCensus Metropolitan Area and Census Agglomeration CodeTextSTC Census Metropolitan Area and Census Agglomeration Unique Identifier Code
cma_ca_nameCensus Metropolitan Area and Census Agglomeration NameTextSTC Census Metropolitan Area and Census Agglomeration Name
cma_ca_name_and_codeCensus Metropolitan Area and Census Agglomeration Code & NameTextSTC Census Metropolitan Area and Census Agglomeration Name & Unique Identifier (Hierarchy: Geography/Census Metropolitan Area and Census Agglomeration)
da_codeDissemination Area CodeTextSTC Dissemination Area Unique Identifier
place_nameCommunity NameTextPlace name
longitudeLatitudeTextPostal Code Latitude (Hierarchy: Geography/Coordinates/Latitude)
latitudeLongitudeTextPostal Code Longitude (Hierarchy: Geography/Coordinates/Longitude)
priv_hhPrivate HouseholdsFloatPerson(s) who share the same dwelling (includes expenditures) and do not have a usual residence elsewhere in Canada or abroad. Includes the entire population.
total_assetsTotal assetsFloatSum of variables …
private_pensionsPrivate pension assetsFloatExcludes public plans administered or sponsored by governments: Old Age Security including the Guaranteed Income Supplement and the Spouse's Allowance, as well as the Canada/Quebec Pension Plans
rrsp_rrif_liraRegistered Retirement Savings Plans (RRSPs), Registered Retirement Income Funds (RRIFs), Locked-in Retirement Accounts (LIRAs) and otherFloatRegistered Retirement Savings Plans (RRSPs), Registered Retirement Income Funds (RRIFs), Locked-in Retirement Accounts (LIRAs) and other. Other includes Deferred Profit Sharing Plans, annuities and other miscellaneous pension assets.
employer_pensionEmployer-sponsored Registered Pension Plans (EPPs)FloatCurrent (termination) value of employer-sponsored Register Pension Plans
financial_assetsFinancial assets, non pensionFloatSum of variables ….
bank_depositsDeposits in financial institutionsFloatTotal value of money in the bank outside of registered retirement savings plans (includes Treasury Bills)
invest_fundsMutual funds, investment funds and income trustsFloatTotal value of mutual funds, investment funds, and income trusts outside of registered retirement savings plans
stocksStocksFloatTotal value of stocks outside of registered retirement savings plans
bondsBonds (saving and other)FloatTotal value of bonds outside of registered retirement savings plans
tax_free_savingsTax Free Saving Accounts (TFSA)FloatTotal value of tax free savings (max. contribution of $5,000 per year)
other_fin_assetsOther financial assetsFloatIncludes Registered Education Savings Plans (RESPs), mortgage-backed securities, money held in trust, money owed to the respondent and other miscellaneous financial assets, including shares of privately held companies.
non_fin_assetsNon-financial assetsFloatSum of variables 13 to 16
home_valuePrincipal residenceFloatCurrent value of principle residence
other_real_estateOther real estateFloatCurrent value of all other real estate excluding principle residence
vehicle_valueVehiclesFloatCurrent value of all vehicles including automotive, boats, and recreational vehicles
oth_non_fin_assetsOther non-financial assetsFloatCurrent value of all other non-financial assets other than real estate or vehicles (contents of home, jewelry, etc)
business_equityEquity in businessFloatCurrent value of all business interests including property, machinery and equipment, intellectual property, etc
total_debtTotal debtsFloatSum of variables 19 to 26
total_mortgageMortgagesFloatSum of variables 20 to 22
home_mortgageMortgage on principal residenceFloatLoan that uses the principal residence as collateral
other_mortgageMortgage on other real estateFloatLoan on real estate other than mortgage using principal residence as collateral
line_of_creditLine of creditFloatCurrent value of all lines of credit debt excluding credit card debt
credit_card_debtCredit card and installment debtFloatIncludes major credit cards and retail store cards, gasoline station cards, et cetera. Installment debt is the total amount owing on deferred payment or installment plans where the purchased item is to be paid for over a period of time.
student_loansStudent loansFloatCurrent value of student loans
vehicle_loansVehicle loansFloatCurrent value of all vehicles loans including for automotive, boats, and recreational vehicles
other_debtOther debtFloatAll other money owed
net_worthNet Worth (assets less debts)FloatTotal assets (1) minus total debts (18)

Sample Data

API

ALTADATA provides a powerfull API, compatible with JSON, CSV formats. You can connect, update and analyze our data products with cURL, Python, R, Ruby, Java or Javascript

Authentication

Getting an API key

You need to subscribe to an ALTADATA data product to get an API key. Once you subscribe to the data product you can find your API key on your Account Dashboard.

Auhenticating your requests

`api_key` is your access token. This token must be included on each API call with either a HTTP Header Authorization, or a query parameter api_key.

Example: https://www.altadata.io/data/api/re_01_excea_03?api_key=YOUR_API_KEY

ALTADATA API Reference Table

Parameter Type Parameter Explanation Available Values Default
General size The number of records will be returned for each page. 5 - 100 20
General page The page number. It starts at 1 and increments one by one. Each page returns records that row count equals to the size parameter 1- ... 1
General format The data return format of API call json , csv json
General collapse The aggregation format of API call Examples are monthly, yearly, bystate, bycountry, etc. Refer to the data product documentation to see available aggregations for it. null
Select columns Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. More detail is in the following sections. *
Order order_by Column order is how you specify the content of an SQL ORDER BY clause. More detail is in the following sections. null
Lookup vary by column name Column lookups are how you specify the content of an SQL WHERE clause. More detail is in the following sections. *

Select

Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names. If not given, the default value is *(asterisk).

Example 1 :

Query : ?columns=C1,C2,C3 SQL Equivalent : Select C1,C2,C3 from DATA_PRODUCT

Example 2 :

Query : Not Given | ?columns= | ?columns=* SQL Equivalent : Select * from DATA_PRODUCT

Order

Column order is how you specify the content of an SQL ORDER BY clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names where each column name has an appropriate suffix (asc,desc) after _(underscore) or no suffix (means ascending).

Example :

Query : ?order_by=C1_asc,C2,C3_desc,C4_asc SQL Equivalent : Select * from DATA_PRODUCT order by C1 asc, C2, C4 desc, C4 asc

Order Type Suffix
Ascending null
Ascending asc
Descending desc

Lookup

Column lookups are how you specify the content of an SQL WHERE clause. They’re specifies as keyword arguments to the query string of API Call URL. Basic usage is appending _(underscore) then lookup type as a suffix to name of the column that you want to filter. The query parameter for a column is built like the format {COLUMN_NAME}_{LOOKUP_TYPE}

As a convenience when no lookup type is provided

Lookup Type Suffix Value Type Example SQL Equivalent
Equal to null String | Numeric | Datetime ?COLUMN=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Equal to eq String | Numeric | Datetime ?COLUMN_eq=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Not Equal to neq String | Numeric | Datetime ?COLUMN_neq=VALUE Select * from DATA_PRODUCT where COLUMN<>VALUE
Greater Than gt Numeric | Datetime ?COLUMN_gt=VALUE Select * from DATA_PRODUCT where COLUMN>VALUE
Greater Than or Equal to gte Numeric | Datetime ?COLUMN_gte=VALUE Select * from DATA_PRODUCT where COLUMN>=VALUE
Less Than lt Numeric | Datetime ?COLUMN_lt=VALUE Select * from DATA_PRODUCT where COLUMN,VALUE
Less Than or Equal to lte Numeric | Datetime ?COLUMN_lte=VALUE Select * from DATA_PRODUCT where COLUMN<=VALUE
In in String ?COLUMN_in=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN in ('V1','V2','V3')
Not In notin String ?COLUMN_notin=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN not in ('V1','V2','V3')

Data Access Examples

cURL
curl \ -H 'Authorization: api_key' \ 'https://www.altadata.io/data/api/re_01_excea_03'
Python (requests)
response = requests.get( 'https://www.altadata.io/data/api/re_01_excea_03', headers={'Authorization': 'api_key'} )
Ruby (open-uri)
require 'open-uri' response = URI.open('https://www.altadata.io/data/api/re_01_excea_03', "Authorization" => "api_key" )
Java (OkHttp)
Request request = new Request.Builder() .url("https://www.altadata.io/data/api/re_01_excea_03") .addHeader("Authorization", "api_key") .build(); Call call = client.newCall(request); Response response = call.execute();
Javascript (axios)
axios.request({ url: 'https://www.altadata.io/data/api/re_01_excea_03', method: 'get', headers: { 'Authorization', 'api_key'} }) .then(response => { console.log(response.data) })
R ( jsonlite )
library(jsonlite) data <- fromJSON(`https://www.altadata.io/data/api/re_01_excea_03`)

Frequently Asked Questions

HOW DO I SUBSCRIBE TO DATA PRODUCTS ON ALTADATA?
DO YOU PROVIDE CUSTOM DATASETS UPON REQUEST?
WHAT ARE THE DIFFERENT WAYS I CAN ACCESS MY SUBSCRIPTION DATA?
HOW CAN I QUICKLY LOOK AT WHAT IS IN THE DATA THAT I SUBSCRIBED TO?
HOW CAN I JOIN ALTADATA PARTNER NETWORK? DO YOU HAVE A LIST OF REQUIREMENTS?