Dataset

B.C. Housing Affordability

ca.aeb68042-2d0a-4c55-8c09-2c700b74a812
Ask your agent

Use escrito dataset ca.aeb68042-2d0a-4c55-8c09-2c700b74a812

Connect an agent at https://data.escrito.io/mcp
About

Note: the best method to download the .csv file is to right click on the ‘Access/Download’ link on the box to the right, and then select ‘Save link as’ to download the .csv file directly. This data provides a quarterly overview of housing affordability for homeowners in B.C. and in its major cities (census metropolitan areas and census agglomerations). Housing affordability is measured using the Mortgage Payment Percent of Income (MPPI) which is calculated every quarter based on: • A hypothetical new home buyer earning the median after-tax income for the quarter • The median home sale price in a region • A 25-year variable-rate mortgage • The minimum down payment • The mortgage rate set at the average quarterly prime interest rate By combining home prices, income levels, and mortgage rates, the MPPI produces a full picture of housing affordability over time. A higher MPPI means it is less affordable to buy a home. For more information see: Summary Report: https://www2.gov.bc.ca/assets/gov/data/statistics/economy/building-permits/housing_affordability_bc_update.pdf Technical Note: https://www2.gov.bc.ca/assets/gov/data/statistics/economy/building-permits/housing_affordability_bc_technical_note.pdf Sources of Data: Statistics Canada (StatsCan): Income Data, Prime Rates, Consumer Price Index; BC Assessment Authority (BCA): House Prices Files (slice {"file": url}): - Housing Affordability for Homeowners in B.C., Quarterly Data (csv): https://catalogue.data.gov.bc.ca/dataset/aeb68042-2d0a-4c55-8c09-2c700b74a812/resource/d650f406-5f49-4648-85e8-3b5966bdb79c/download/bc-data-catalogue-bc.csv - Housing Affordability for New Homeowners in B.C., Census Metropolitan Areas Quarterly Data (csv): https://catalogue.data.gov.bc.ca/dataset/aeb68042-2d0a-4c55-8c09-2c700b74a812/resource/a71e6838-cda1-4acb-adfb-8515c4f9fec9/download/bc-data-catalogue-cma.csv - Housing Affordability for Renters in B.C., Census Metropolitan Areas Quarterly Data (csv): https://catalogue.data.gov.bc.ca/dataset/aeb68042-2d0a-4c55-8c09-2c700b74a812/resource/783af514-55ec-469d-ae12-f1ef21810273/download/bc-data-catalogue-cma-rent.csv

Cite as: Government of British Columbia | Gouvernment de la Colombie-Britannique. B.C. Housing Affordability. https://open.canada.ca/data/en/dataset/aeb68042-2d0a-4c55-8c09-2c700b74a812

Publisher
Open Government Portal (Canada)
Tier
Official
Covers
0001–now
Places
Canada
Updated
quarterly
Last modified
2026-08-26
Units
not stated
License
Open Government Licence - British Columbia
Method
https://open.canada.ca/data/en/dataset/aeb68042-2d0a-4c55-8c09-2c700b74a812

All datasets