Real-time data tables

New data tables that provide the revision history of 28 economic and social time series are now available. Statistics Canada has always provided its users with the most recent data available, but after consulting some of its expert data users, the agency identified a need for real-time data—or vintage data—to make certain types of analysis easier. These new tables were created to fill this data gap.

Initially, the tables will contain vintages of data as of January 2015. However, some may be expanded to provide users with a longer time series. The real-time table will be released approximately one week after the standard data table.

Background

Statistical revisions are carried out regularly in the compilation of economic and social statistics. These revisions incorporate the most complete and current information from many sources (including surveys, administrative data and public accounts) and use improved estimation methods. While the majority of revisions are done within the months or quarters of a given reference year or on an annual basis, going back two to three years to incorporate benchmark information, some revisions are carried back further to incorporate major changes to concepts or classifications.

Statistics Canada's economic and social statistics programs have well-established policies that govern revisions. Every time Statistics Canada revises data for a given time period, it replaces the existing data table information with the revised data. This ensures that users always have the most up-to-date statistics.

This up-to-date (or revised) information meets the data requirements of most users. However, some users have said that they would like Statistics Canada to provide access to the different vintages of a given time series of economic or social data within a single table or database. A table or database that contains vintages of data is referred to in the international community as a real-time database.

Real-time databases allow users to examine a given time series of economic or social data as it appeared (and was used) at a given point in time before it was revised. This is helpful to users who may want to examine a policy decision—such as a change in interest rates or tax policy—based on the information that was available to policy makers at the time of the decision. These real-time tables help economic and social statistics users to better analyze the impact and development of policy, to prepare forecasts, and to test econometric models.

The revisions in the real-time data tables are not corrections to errors. They represent a normal step in the statistical process, in which statistical agencies produce new vintages of higher quality data as new information becomes available.

Publishing real-time data tables reflects Statistics Canada's values of transparency, accessibility, interpretability, and increased data relevance for users.

Real-time data tables

Statistics Canada will release real-time data for 21 economic and social time series (Table 1).
The real-time data tables will not replace the current data tables for these time series; they are a new product for data users.

The real-time data tables for these economic and social time series will be released approximately one week after the corresponding standard tables have been released and will have their own reference number. At this point, the tables will contain vintages of data starting with the January 2015 reference period. At a later date, some programs may include earlier reference periods to provide users with a longer time series.

Table 1: Real-time data tables
  Regular data table Real-time data table
Historical (real-time) releases of Consumer Price Index (CPI) statistics, measures of core inflation - Bank of Canada definitions, monthly (percent) 18-10-0256 18-10-0259
Historical (real-time) releases of retail trade, sales 20-10-0008 20-10-0054
Historical (real-time) releases of retail trade, sales, chained dollars and price index based on the North American Industry Classification System (NAICS), inactive 20-10-0011 20-10-0055
Historical (real-time) releases of wholesale trade, sales 20-10-0074 20-10-0019
Historical (real-time) releases of wholesale trade, inventories 20-10-0076 20-10-0020
Historical (real-time) releases of wholesale trade, sales, chained dollars and price index 20-10-0018 20-10-0023
Historical (real-time) releases of quarterly balance sheet and income statement items, by industry 33-10-0007 33-10-0160
Historical (real-time) releases of quarterly statement of changes in financial position and selected financial ratios, by industry 33-10-0008 33-10-0161
Historical (real-time) releases of manufacturing sales, by North American Industry Classification System (NAICS) and province 16-10-0048 16-10-0119
Historical (real-time) releases of real manufacturing sales, orders, inventory owned and inventory to sales ratio, 2007 dollars, seasonally adjusted, monthly (dollars unless otherwise noted), inactive 36-10-0476 36-10-0355
Historical (real-time) releases of balance of international payments, current account, seasonally adjusted, quarterly 36-10-0018 36-10-0042
Historical (real-time) releases of gross domestic product (GDP) at basic prices, by industry, monthly 36-10-0434 36-10-0491
Vintages of releases of gross domestic product, income-based 36-10-0103 36-10-0430
Vintages of releases of gross domestic product, expenditure-based 36-10-0104 36-10-0431
Historical (real-time) releases of merchandise imports and exports, customs and balance of payments basis for all countries, by seasonal adjustment and North American Product Classification System (NAPCS), inactive 12-10-0001 12-10-0089
Historical (real-time) releases of employment, monthly, unadjusted for seasonality 14-10-0201 14-10-0357
Historical (real-time) releases of average weekly earnings (including and excluding overtime), monthly, unadjusted for seasonality 14-10-0203 14-10-0358
Historical (real-time) releases of employment and average weekly earnings (including overtime) for all employees by industry, monthly, seasonally adjusted 14-10-0220 14-10-0331
Historical (real-time) releases of employment and average weekly earnings (including overtime) for all employees by province and territory, monthly, seasonally adjusted 14-10-0223 14-10-0332
Historical (real-time) releases of manufacturers' sales, inventories, orders and inventory to sales ratios, by North American Industry Classification System (NAICS), Canada 16-10-0047 16-10-0118
Historical (real-time) releases of the industrial product price index, by major product group, monthly, inactive 18-10-0029 18-10-0248
Historical (real-time) releases of merchandise imports and exports, customs and balance of payments basis for all countries, by seasonal adjustment and North American Product Classification System (NAPCS) 12-10-0121 12-10-0120
Historical (real-time) releases of real manufacturing sales, orders, inventory owned and inventory to sales ratio, 2012 dollars, seasonally adjusted 16-10-0013 16-10-0014
Historical (real-time) releases manufacturing capacity utilization rates 16-10-0012 16-10-0015
Historical (real-time) releases of wholesale sales, price and volume, seasonally adjusted 20-10-0003 20-10-0005
Historical (real-time) releases of retail sales, price, and volume 20-10-0078 20-10-0079
Historical (real time) releases of capital and repair expenditures, non-residential tangible assets, by industry and geography 34-10-0035 34-10-0278
Historical (real time) releases of capital and repair expenditures, non-residential tangible assets, by industry, Canada 34-10-0036 34-10-0279

Structure of the real-time tables

The real-time data tables show all revisions of a specific data point over time. Typically, Statistics Canada releases initial estimates for a given period (month or quarter), revises them in subsequent periods based on new information, then revises them again in an annual or historical revision process. Statistics Canada has determined that the most transparent way to present the vintages is to record the date that the data were released in The Daily, the agency's official release vehicle. The real-time data tables are as easy to use as standard tables, but with one important exception: they contain a vintage dimension that records the date of official release.

For example, let us suppose that on November 29, 2019, gross domestic product data for the third quarter of 2019 were released for the first time. The vintage (release) dimension would record the date as November 29, 2019. Suppose that on May 29, 2020, gross domestic product data for the first quarter of 2020 were released for the first time, along with a revised estimate for the third and the last quarter of 2019. A second entry would be made in the table for the third and the fourth quarter of 2019, and the vintage (release) dimension would have the value of May 29, 2020. As new vintages are added, the real-time tables will display the revised data for selected reference periods in columns.

Likewise, the initial estimates for each reference period appear as the last (non-missing) figure in each column. The comparison between the initial  and the most recent estimate therefore represents the difference between the first and last rows in the table for a given reference period. For the most recent reference period, the initial estimate and the most recent estimate are the same.

Figure 1 - Gross Domestic Product, Real-time data

Figure 1 - Gross Domestic Product, Real-time data
Description for Figure 1

This is a real-time data table which shows all revisions of a specific data point over time. On the horizontal axis, the columns indicate calendar years. Each year is subdivided into quarters. The rows of the vertical axis indicate the date data was released.

For each column, the last data point contains the initial data released for that year and quarter. Each subsequent cell above contains revised data for that year and quarter, with the revision date indicated in the corresponding vertical axis.

The first row contains the most recent estimate for each reference period in an economic or social time series. This estimate is consistent with the information in the standard data table for that time series.

Figure 2 - Gross Domestic Product, Real-time data, March 01, 2022

Figure 2 - Gross Domestic Product, Real-time data
Description for Figure 2

This is a real-time data table which shows all revisions of a specific data point over time. On the horizontal axis, the columns indicate calendar years. Each year is subdivided into quarters. The rows of the vertical axis indicate the date data was released.

For each column, the last data point contains the initial data released for that year and quarter. Each subsequent cell above contains revised data for that year and quarter, with the revision date indicated in the corresponding vertical axis.

The data in the top row is circled to show all the data released on that date. The data point at the end of the row is the initial release for the quarter indicated, all preceding data points are the most recent revisions to data previously released for past quarters.

The various revisions for a given reference period are shown in the column for that reference period. The release dates associated with each new reference period are on the left-hand side of the table in the vintage dimension.

Figure 3 - Gross Domestic Product, Real-time data, Q3, 2019

Figure 3 - Gross Domestic Product, Real-time data
Description for Figure 3

This is a real-time data table which shows all revisions of a specific data point over time. On the horizontal axis, the columns indicate calendar years. Each year is subdivided into quarters. The rows of the vertical axis indicate the date data was released.

For each column, the last data point contains the initial data released for that year and quarter. Each subsequent cell above contains revised data for that year and quarter, with the revision date indicated in the corresponding vertical axis.

The data in the first column is circled to show all revisions for a specific quarter since its initial release, at the bottom of the column.

The initial estimate for each reference period is the last figure in each column.

Figure 4 - Gross Domestic Product, Real-time data, November 29, 2019 to 2021

Figure 4 - Gross Domestic Product, Real-time data
Description for Figure 4

This is a real-time data table which shows all revisions of a specific data point over time. On the horizontal axis, the columns indicate calendar years. Each year is subdivided into quarters. The rows of the vertical axis indicate the date data was released.

For each column, the last data point contains the initial data released for that year and quarter. Each subsequent cell above contains revised data for that year and quarter, with the revision date indicated in the corresponding vertical axis.

Finally, if users want to examine the time series as it appeared at a specific point in time, they must select the row associated with that date.

Figure 5 - Gross Domestic Product, Real-time data, March 02, 2021

 Figure 5 - Gross Domestic Product, Real-time data
Description for Figure 5

This is a real-time data table which shows all revisions of a specific data point over time. On the horizontal axis, the columns indicate calendar years. Each year is subdivided into quarters. The rows of the vertical axis indicate the date data was released.

For each column, the last data point contains the initial data released for that year and quarter. Each subsequent cell above contains revised data for that year and quarter, with the revision date indicated in the corresponding vertical axis.

In the middle of the table, a row is circled to illustrate how a time series appeared at a specific point in time.

The importance of footnotes and context

Twenty-one real-time tables have been released to the public, and represent the majority of the key economic and social indicators produced by Statistics Canada. In most cases, revisions occur because the first vintages of estimates are based on incomplete information. As more up to date information becomes available, the data are revised. In some cases, revisions occur due to changes in concepts or methods. These types of revisions need to be analyzed differently than revisions made using updated information.

To help users in their analysis, the real-time tables will include detailed footnotes to provide context for the revisions. These footnotes should be used along with the data to understand how to interpret the various vintages. Specifically, users should exercise caution, since not taking the footnotes and other related metadata into consideration when using real-time data could lead to erroneous conclusions.