61North provides an accepted snapshot of Statistics Canada's monthly, not seasonally adjusted Consumer Price Index (CPI), Table 18-10-0004-01. Ulono Technologies Inc. packages the data with English and French labels, source semantics and visible release information.
Documentation verified September 19, 2026. Accepted data covers January 1914–July 2026.
Coverage and freshness
The initial accepted snapshot has 1,150,908 observations and 2,139 series, spanning January 1914 through July 2026 overall. It includes 30 geographic labels and 359 product labels. Individual series start and end at different times. City-level coverage is selective, not coverage of every Canadian municipality. The dataset contains Canadian observations, even when accessed from another country.
The source release timestamp is 2026-08-17T08:30, preserved exactly as supplied without a timezone offset. Source reference month, source release time and 61North publication time describe different events. In particular, a September publication by 61North does not make the observations September CPI.
Source update frequency: Monthly. Statistics Canada publishes CPI monthly. 61North provides validated releases with clear coverage and version information. Check the status view for the latest available reference period and accepted release. Pending or failed candidates do not replace the prior accepted version. Corrections to earlier periods may appear in later accepted snapshots; record the release identifier alongside analytical results.
Get started
In Snowflake Marketplace, find Canadian Consumer Price Index — Bilingual History by Ulono Technologies Inc. The listing is available in AWS Canada Central; your Snowflake account must be in a supported region. Install it using an authorized role and choose a database name. Open a worksheet using that imported database and your own warehouse. The examples use RELEASES.<VIEW> so they work regardless of the database name you selected. Your Snowflake administrator manages access for other users in your account.
Start with release and source information, then explore Canada's recent CPI history, provincial indices and geographic coverage. Each query is read-only. Data access is free; the warehouse used to run your queries is your own Snowflake resource.
Scroll the table sideways if needed. Keyboard: focus the table and use the left and right arrow keys.
| View | Contents |
|---|---|
RELEASES.C01_FREE_OBSERVATIONS | Currently accepted monthly observations with both languages and source flags |
RELEASES.C01_FREE_DATASET_CATALOG | Dataset description, source/licence links, attribution and contract/release identifiers |
RELEASES.C01_FREE_DATASET_STATUS | Current release, coverage, row count, hashes, publication timestamps and source update frequency |
The data dictionary describes every column. These views expose the accepted version only; they are not an API for retrieving arbitrary historical release versions. A single statement joining status to observations can bind results to one release. Separate statements may straddle a future publication, so compare release identifiers before combining their outputs.
Reading the observations correctly
The observation grain is (PRODUCT_ID, VECTOR, REFERENCE_MONTH) within a release. PRODUCT_ID identifies the Statistics Canada table product; PRODUCT_EN and PRODUCT_FR identify the CPI product or group. Do not count English and French labels as separate observations.
VALUE is an exact decimal index level. Keep its unit/index base and scalar alongside the value. The current snapshot contains eleven bases; most records use 2002=100, but not all. Do not average or sum unrelated CPI series, or treat one geography's index level as an absolute price comparison with another's. No inflation-rate calculation or seasonal adjustment is supplied by this product.
REFERENCE_MONTH is represented by the first day of its month, not a daily observation. VECTOR identifies a source series; retain it for stable comparisons. Some historical rows have no DGUID: this does not make the observation invalid. Source STATUS, SYMBOL and TERMINATED values are preserved. Empty flag fields differ from a flagged missing value; do not turn source-null values into zero.
This release has 3,471 rows without a geography identifier, 59,308 terminated-series records and three estimated records. No numeric value is null in this snapshot, but future source releases can contain valid flagged nulls. The dictionary describes storage nullability separately from release checks. Consult the source table and its notes for Statistics Canada's methodology and flag definitions.
Quality and change handling
Before accepting a release, 61North reconciles the complete English and French resources, record and series counts, unique observation keys, numeric values, units, flags and metadata. Release evidence is tied to the source and transformation version. Publication changes the visible accepted version; a rejected candidate leaves the previous version available. Rollback can restore a previously accepted release.
These checks establish agreement with the selected source snapshot; they do not guarantee that the source is error-free or that CPI is suitable for every decision. The public interface contains observations and status, not private staging tables or validation controls. Use explicit column lists in applications. Any proposed breaking interface change requires release review and updated consumer documentation before rollout; this initial release does not advertise a fixed notice-period SLA.
Source, attribution and reuse
Adapted from Statistics Canada, Consumer Price Index, Table 18-10-0004-01, source release 2026-08-17T08:30, reference months 1914-01 to 2026-07. This does not constitute an endorsement by Statistics Canada of this product.
The Statistics Canada Open Licence governs the underlying information and requires source acknowledgment, accurate representation and consistent reuse. Consult that licence for its full conditions. Consumer calculations are your own derived results; retain appropriate source and release references when distributing them. The listing shows the applicable terms; they do not replace the upstream source licence.
Support
Use Contact Provider on the Marketplace listing for product access, documentation or data questions. Include the release identifier, reference period, vector, query ID and a minimal query where possible. Never send Snowflake credentials or unnecessary personal data.