Canada Government Essentials

Economic data from the Government of Canada

Overview

This product serves as a central source of Canadian government statistics and economic data.

Example topics covered:

• Gross domestic product (GDP)

• Retail sales

• Household income

• Consumer Price Index (CPI)

• Foreign exchange rates

• Total employment by industry

• Housing price indices

• Government of Canada debt securities

• Housing starts

Attributes, Data Sources, Sample Queries

Data is sourced from Canada’s national statistical office, Statistics Canada. A detailed description of the data is available by source. Source pages include key attributes (e.g. geographic coverage, time granularity, history, entity level), release frequency, notes & methodologies, and sample queries.

Statistics Canada

Cybersyn Geography Tables

All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details

Data Dictionary

📖pageData Dictionary

Releases & Changelog

12/19/23 - Added month-end assets and liabilities for the Bank of Canada from Statistics Canada

Expanded coverage of Statistics Canada, Canada's national statistical office, with month-end assets and liabilities for the Bank of Canada and Chartered Banks. Added month-end currency outside bank/chartered bank deposits for the Bank of Canada.

Select assets include: Government of Canada direct and guaranteed securities (e.g., Treasury Bills, Government of Canada bonds, mortgage bonds), provincial money market securities, provincial bonds, commercial paper, and corporate bonds.

Select liabilities include: notes in circulation, Canadian dollar deposits, securities sold under repurchase agreements, derivatives, foreign currency liabilities, and equity.

The data can be found in the following tables:

• CANADA_STATCAN_ATTRIBUTES includes a unique variable ID and a human-readable variable name. Each field represents a characteristic of the variable, including its unit of measurement, whether it's seasonally adjusted, frequency of measurement, its Statistics Canada report, and other related information

• CANADA_STATCAN_TIMESERIES provides historical values for each variable collected by Statistics Canada by GEO_ID. Each row represents a distinct timeseries, date, and value by geographic entity.

12/5/23 - Added interest rates posted by major chartered banks in Canada for selected products from Statistics Canada

Added interest rates for selected products posted by the six major chartered banks in Canada to the CANADA_STATCAN_ATTRIBUTES and CANADA_STATCAN_TIMESERIES tables. The typical rate is calculated based on the statistical mode of the rates published by the six banks.

The posted rates cover:

• Prime lending rate

• Conventional mortgages

• Guaranteed investment certificates

• Personal daily interest savings

• Non-checkable savings deposits

11/13/23 - Added 6 timeseries from Statistics Canada covering Canadian debt securities and real estate development

Added 6 new timeseries to the CANADA_STATCAN_TIMESERIES and CANADA_STATCAN_ATTRIBUTES tables from 3 of Statistics Canada’s underlying sources:

• Bank of Canada: Government of Canada debt gross new issues, retirements and net new issues, and par values

• Annual Survey of Service Industries: Real estate agents, brokers, and appraisers summary statistics (e.g. salaries, wages, operating revenue)

• Canada Mortgage and Housing Corporation:

  • Absorptions and unabsorbed inventory, newly completed dwellings, by type of dwelling unit in select census metropolitan areas

  • Absorptions and unabsorbed inventory, newly completed dwellings, by type of dwelling unit in census agglomerations of 50K+

  • Housing starts, under construction and completions in select census metropolitan areas

  • Housing starts, under construction and completions in census agglomerations of 50K+

7/28/23 - Removed age_group measure and labour_force_statistic fields

Removed three fields that were deprecated during the 7/16/23 release:

• age_group

• measure

• labour_force_statistic

7/16/23 - Added prices, output, and household income; schema changes in canada_statcan_attributes

• New datasets:

  • Household income and finances: Household income and consumption, household credit liabilities, and household savings rates

  • Prices and output: Core consumer price index, gross domestic product by industry group, and new housing price indices

• Updated datasets:

  • StatCan archived a number of retail trade series and published new series. Old series are marked “Archived…” in the report field. The latest series have been included to replace these.

• Schema changes:

  • The following fields in the canada_statcan_attributes table were updated. The deprecated fields will be removed on 7/28/2023.

    • age_group will be folded into demographic_group, which applies more broadly to age ranges, income groups, and household makeups (e.g., 35 to 44 years, lowest income quintile, elderly persons not in an economic family)

    • measure will be renamed report. The report column displays the StatCan dataset from which the data originates (e.g. Consumer Price Index, New Housing Price Index)

    • labour_force_statistic will be renamed statistic. The new statistic column will provide the label for the specific economic metric that is being reported (e.g. Median After Tax Income, Number of families)

Disclaimers

The data in this dataset is sourced on the individual source pages. Links to provider license, terms and disclaimers are provided where appropriate.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.