US-Canada consumer-macro panel: inflation, unemployment, sentiment, retail
Monthly US-Canada consumer-macro panel: CPI inflation (level, MoM %, YoY %; US series seasonally adjusted, Canadian series not), unemployment rate (SA %, MoM/YoY point changes, deviation from the trailing 12-month average), consumer sentiment (US index + YoY %; Canada null — no comparable monthly series), and retail sales (SA, millions of local currency, MoM %/YoY %; US series excludes motor vehicle and parts dealers, Canadian total includes them), plus a deterministic demand_pressure_score = mean of trailing-24-month z-scores of retail YoY growth, falling unemployment and CPI YoY. Upstream: FRED keyless fredgraph.csv (CPIAUCSL, UNRATE, UMCSENT, RSXFS) and Statistics Canada full-table CSV downloads (tables 18-10-0004-01 vector 41690973, 14-10-0287-01 vector 2062815, 20-10-0056-01 vector 1446859483). One row per year_month x country_code (USA/CAN); growth columns are the cross-country-comparable fields. Who joins this: a sales team joins monthly macro to pipeline value on year_month; a subscription business joins it to MRR on year_month + country_code. Upstream gaps propagate as nulls (e.g. the US October-2025 unemployment and November-2025 CPI releases were never published during the federal shutdown); the score needs at least two of its three z-components.
- Rows
- 230
- Columns
- 18
- Source cadence
- Monthly
- Last refreshed
- Sep 29, 2026
- Theme
- economy
| Column | Type | Description |
|---|---|---|
| date | date | First day of the observation month. (unit: date) |
| year_month | string | Observation month as YYYY-MM (panel join key). (unit: string) |
| country | string | Country name (shared normalization layer). (unit: string) |
| country_code | string | ISO 3166-1 alpha-3 country code (panel join key). (unit: string) |
| currency_code | string | ISO 4217 currency of retail_m_local: USD for USA, CAD for Canada. (unit: string) |
| cpi_index | float | Consumer price index level: US = FRED CPIAUCSL, seasonally adjusted (1982-84=100); Canada = StatCan 18-10-0004-01 vector 41690973, not seasonally adjusted (2002=100). Levels are not cross-country comparable; YoY is the primary inflation read and cpi_mom_pct mixes SA (US) with NSA (Canada) inputs. (unit: index) |
| cpi_yoy_pct | float | — |
| cpi_mom_pct | float | — |
| unemp_rate_pct | float | Unemployment rate, seasonally adjusted, percent: US = FRED UNRATE; Canada = StatCan 14-10-0287-01 vector 2062815. (unit: percent) |
| unemp_mom_pp | float | — |
| unemp_yoy_pp | float | — |
| unemp_vs_12m_avg_pp | float | — |
| sentiment_index | float | Consumer sentiment index: US = FRED UMCSENT (University of Michigan); Canada has no comparable monthly series — null on Canada rows. (unit: index) |
| sentiment_yoy_pct | float | — |
| retail_m_local | float | Retail sales, seasonally adjusted, millions of local currency: US = FRED RSXFS (USD millions, excludes motor vehicle and parts dealers); Canada = StatCan 20-10-0056-01 vector 1446859483 (thousands of CAD converted to CAD millions, total includes motor vehicle and parts dealers). Definitional difference on top of currency. (unit: millions of local currency) |
| retail_mom_pct | float | — |
| retail_yoy_pct | float | — |
| demand_pressure_score | float | — |
First 10 sample rows — a preview, not the complete dataset.
| date | year_month | country | country_code | currency_code | cpi_index | cpi_yoy_pct | cpi_mom_pct | unemp_rate_pct | unemp_mom_pp | unemp_yoy_pp | unemp_vs_12m_avg_pp | sentiment_index | sentiment_yoy_pct | retail_m_local | retail_mom_pct | retail_yoy_pct | demand_pressure_score |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017-01-01 | 2017-01 | Canada | CAN | CAD | 129.5 | — | — | 6.9 | — | — | — | — | — | 50,417.235 | — | — | — |
| 2017-01-01 | 2017-01 | United States | USA | USD | 243.618 | — | — | 4.7 | — | — | — | 98.5 | — | 408,269 | — | — | — |
| 2017-02-01 | 2017-02 | Canada | CAN | CAD | 129.7 | — | 0.154 | 6.6 | -0.3 | — | — | — | — | 49,863.452 | -1.098 | — | — |
| 2017-02-01 | 2017-02 | United States | USA | USD | 244.006 | — | 0.159 | 4.6 | -0.1 | — | — | 96.3 | — | 408,155 | -0.028 | — | — |
| 2017-03-01 | 2017-03 | Canada | CAN | CAD | 129.9 | — | 0.154 | 6.7 | 0.1 | — | — | — | — | 49,937.42 | 0.148 | — | — |
| 2017-03-01 | 2017-03 | United States | USA | USD | 243.892 | — | -0.047 | 4.4 | -0.2 | — | — | 96.9 | — | 407,630 | -0.129 | — | — |
| 2017-04-01 | 2017-04 | Canada | CAN | CAD | 130.4 | — | 0.385 | 6.5 | -0.2 | — | — | — | — | 50,827.438 | 1.782 | — | — |
| 2017-04-01 | 2017-04 | United States | USA | USD | 244.193 | — | 0.123 | 4.4 | 0 | — | — | 97 | — | 409,134 | 0.369 | — | — |
| 2017-05-01 | 2017-05 | Canada | CAN | CAD | 130.5 | — | 0.077 | 6.6 | 0.1 | — | — | — | — | 50,711.634 | -0.228 | — | — |
| 2017-05-01 | 2017-05 | United States | USA | USD | 244.004 | — | -0.077 | 4.4 | 0 | — | — | 97.1 | — | 406,609 | -0.617 | — | — |
- Current
20260929T055550Z-79a06494cda5 · sha256 79a06494cda5…
230 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/consumer_macro_panel/consumer_macro_monthly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/consumer_macro_panel/consumer_macro_monthly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/consumer_macro_panel/consumer_macro_monthly
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20260929T055550Z-79a06494cda5 and its content hash, so readers get exactly the data you used.
US-Canada Consumer-Macro Panel (derived). (2026). US-Canada consumer-macro panel: inflation, unemployment, sentiment, retail [Data set, snapshot 20260929T055550Z-79a06494cda5, sha256 79a06494cda5]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/consumer_macro_panel/consumer_macro_monthly?snapshot=20260929T055550Z-79a06494cda5
@misc{dz_consumer_macro_panel_consumer_macro_mont_79a06494,
title = {{US-Canada consumer-macro panel: inflation, unemployment, sentiment, retail}},
author = {{US-Canada Consumer-Macro Panel (derived)}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/consumer_macro_panel/consumer_macro_monthly?snapshot=20260929T055550Z-79a06494cda5}},
note = {Snapshot 20260929T055550Z-79a06494cda5, sha256 79a06494cda541b49f5a6de164d5fbe8d75edca4b866a9f8f056f2eb145b8d50; accessed 2026-09-30}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
<iframe src="https://datazimuts.com/embed/chart?dataset=consumer_macro_panel%2Fconsumer_macro_monthly&lang=en&theme=auto&snapshot=20260929T055550Z-79a06494cda5&x=date&y=cpi_index&agg=avg" title="US-Canada consumer-macro panel: inflation, unemployment, sentiment, retail" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.