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.
Les titres et les descriptions proviennent des sources de données, en anglais.
- Lignes
- 230
- Colonnes
- 18
- Cadence de la source
- Mensuelle
- Dernière actualisation
- 29 sept. 2026
- Thème
- economy
| Colonne | 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 | — |
10 premières lignes d’exemple — un aperçu, pas le jeu de données complet.
| 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 | — | — |
- Actuelle
20260929T055550Z-79a06494cda5 · sha256 79a06494cda5…
230 lignes · premier instantané
Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (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)Point d’accès API : https://datazimuts.com/v1/datasets/consumer_macro_panel/consumer_macro_monthly
Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.
D’où viennent ces données et ce qui en a été fait. Le travail des autres apparaît sous forme de décomptes ; seuls les projets partagés sont nommés.
Citer cet instantané
Épinglé à l’instantané 20260929T055550Z-79a06494cda5 et à son empreinte, pour que vos lecteurs obtiennent exactement les données utilisées.
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/fr/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/fr/datasets/consumer_macro_panel/consumer_macro_monthly?snapshot=20260929T055550Z-79a06494cda5}},
note = {Snapshot 20260929T055550Z-79a06494cda5, sha256 79a06494cda541b49f5a6de164d5fbe8d75edca4b866a9f8f056f2eb145b8d50; accessed 2026-09-30}
}Intégrer un tableau ou un graphique
Collez ce code dans n’importe quelle page. L’intégration est épinglée au même instantané, suit le thème clair ou sombre du lecteur et affiche toujours la source, la licence et un lien de retour.
<iframe src="https://datazimuts.com/embed/chart?dataset=consumer_macro_panel%2Fconsumer_macro_monthly&lang=fr&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>
Posez une question sur ce jeu de données. Les réponses viennent uniquement de sa fiche, de son profil mesuré et de son historique, et citent les faits utilisés.