US import-price passthrough intelligence, monthly
Monthly US import-price passthrough intelligence, 1993-12 onward: ten BLS U.S. Import Price Index (end use) series via keyless FRED fredgraph.csv — all-commodities headline, the five end-use categories (foods, industrial supplies, capital goods, automotive, consumer goods), capital goods ex-computers, and ex-petroleum / ex-fuels / ex-fuels-and-computers aggregates — with MoM/YoY/3m-annualized growth, a 36m YoY z-score, a 0-100 within-month cost-pressure score + rank, import-deflation / rapid-surge / record-high / momentum-acceleration flags, and month context (end-use breadth, fuels-vs-core spread, core import YoY). One row per (month, series) x USA; in-window nulls fail loudly, never imputed; IREXFUELS/IREXFUELCO enter at their own first observation (2001-12/2003-03). Who joins this: shops join landed-cost pressure on year_month + country_code to time price changes and forecast margin compression; subscription businesses use core import YoY as a macro headwind feature.
- Rows
- 3,714
- Columns
- 22
- Source cadence
- Monthly
- Last refreshed
- Oct 1, 2026
- Theme
- economy
| Column | Type | Description |
|---|---|---|
| month_start | date | First day of the calendar month. (unit: date) |
| year_month | string | Calendar 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 (USA). (unit: string) |
| series_code | string | Panel code of the import-price series (e.g. all_commodities, consumer_goods, ex_fuels). (unit: string) |
| category | string | Human label of the BLS end-use category or aggregate (e.g. 'Consumer Goods, Excluding Automotives'). (unit: string) |
| index_base | string | Index base period of the series (most 2000=100; ex_fuels is Dec 2001=100; ex_fuels_computers is Mar 2003=100). Raw index_value levels are NOT comparable across series — use the growth features. (unit: string) |
| index_value | float | BLS import price index level, not seasonally adjusted. Comparable over time within a series, never across series (bases differ). (unit: index) |
| mom_pct | float | 1-month percent change of the index (null for each series' first panel month). (unit: percent) |
| yoy_pct | float | 12-month percent change of the index (null for each series' first panel year; never back-filled). (unit: percent) |
| ann3m_pct | float | 3-month percent change annualized: ((v/v-3)^4 - 1) * 100 (null for each series' first 3 panel months). (unit: percent) |
| yoy_z36 | float | Z-score of yoy_pct against its own trailing 36-month window (min 12 observations). (unit: z-score) |
| cost_pressure_score | float | 0-100 within-month cost-pressure score: the month's yoy_pct values winsorized to +/-15pp then min-maxed across the series with non-null yoy (min 2); 100 = the hottest import-price series that month, 0 = the coolest. Null when fewer than 2 series report. (unit: score) |
| pressure_rank | integer | Rank of cost_pressure_score within the month (1 = highest pressure; ties share the min rank). (unit: rank) |
| breadth_up_share | float | Share of the five end-use categories (foods_feeds_beverages, industrial_supplies_materials, capital_goods_ex_auto, automotive, consumer_goods) with yoy_pct > 0 that month; 1.0 = import inflation is broad-based. (unit: share) |
| fuels_spread_pp | float | Headline (all_commodities) yoy_pct minus ex_fuels yoy_pct, in percentage points; positive when fuels drive import inflation. (unit: points) |
| core_yoy_pct | float | yoy_pct of ex_fuels_computers (all commodities excluding computers, peripherals, semiconductors and fuels): the 'core' import-price read. (unit: percent) |
| import_deflation | integer | 1 when the series' yoy_pct is negative. (unit: flag) |
| rapid_surge | integer | 1 when the series' yoy_pct exceeds 5 (documented fixed cut point). (unit: flag) |
| record_high_12m | integer | 1 when the index level is the trailing-12-month maximum. (unit: flag) |
| accel_3m | integer | 1 when ann3m_pct exceeds yoy_pct by more than 3pp (momentum accelerating). (unit: flag) |
| row_hash | string | Deterministic 16-hex sha256 of year_month + USA + series_code + the index level (idempotency key). (unit: string) |
First 10 sample rows — a preview, not the complete dataset.
| month_start | year_month | country | country_code | series_code | category | index_base | index_value | mom_pct | yoy_pct | ann3m_pct | yoy_z36 | cost_pressure_score | pressure_rank | breadth_up_share | fuels_spread_pp | core_yoy_pct | import_deflation | rapid_surge | record_high_12m | accel_3m | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1993-12-01 | 1993-12 | United States | USA | all_commodities | All Commodities | Index 2000=100 | 93.5 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | 4a3cce8c12d032c5 |
| 1993-12-01 | 1993-12 | United States | USA | automotive | Automotive Vehicles, Parts and Engines | Index 2000=100 | 93.3 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | c221ab13a14d9275 |
| 1993-12-01 | 1993-12 | United States | USA | capital_goods_ex_auto | Capital Goods, Except Automotive | Index 2000=100 | 120.9 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | a38586042a8de145 |
| 1993-12-01 | 1993-12 | United States | USA | capital_goods_ex_computers | Capital Goods, Excluding Computers, Peripherals, and Semiconductors | Index 2000=100 | 107.4 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | 51702647eb82cefc |
| 1993-12-01 | 1993-12 | United States | USA | consumer_goods | Consumer Goods, Excluding Automotives | Index 2000=100 | 101.1 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | 1385986a8a2bec7a |
| 1993-12-01 | 1993-12 | United States | USA | ex_petroleum | All Imports Excluding Petroleum | Index 2000=100 | 101.3 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | 1135367551efe8cd |
| 1993-12-01 | 1993-12 | United States | USA | foods_feeds_beverages | Foods, Feeds, and Beverages | Index 2000=100 | 95.9 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | fa31093dfbddc05f |
| 1993-12-01 | 1993-12 | United States | USA | industrial_supplies_materials | Industrial Supplies and Materials | Index 2000=100 | 69.6 | — | — | — | — | — | — | — | — | — | — | — | 1 | — | 038a485b1a732dc1 |
| 1994-01-01 | 1994-01 | United States | USA | all_commodities | All Commodities | Index 2000=100 | 93.5 | 0 | — | — | — | — | — | — | — | — | — | — | 1 | — | c19a352b584cb49a |
| 1994-01-01 | 1994-01 | United States | USA | automotive | Automotive Vehicles, Parts and Engines | Index 2000=100 | 93.6 | 0.322 | — | — | — | — | — | — | — | — | — | — | 1 | — | 465cd9b2581a0d57 |
Profiled Oct 1, 2026 from snapshot 20261001T044130Z-ba86a0dbc648
Measured- Completeness
- 96.3%
- Rows
- 3,714
- Columns
- 22
- Columns with gaps
- 12
| Column | Missing | Distinct | Range | Distribution |
|---|---|---|---|---|
| month_startdate | 0% | 359 | Dec 1, 1993 → Aug 1, 2026 | — |
| year_monthvarchar | 0% | 381 | — |
|
| countryvarchar | 0% | 1 | — |
|
| country_codevarchar | 0% | 1 | — |
|
| series_codevarchar | 0% | 11 | — |
|
| categoryvarchar | 0% | 11 | — |
|
| index_basevarchar | 0% | 3 | — |
|
| index_valuedouble | 0% | 899 | 67.6 → 305.3median 110.7 | 76 outside 1st–99th percentile |
| mom_pctdouble | 0.51% | 3,541 | -18.22 → 9.33median 0.0701 | 74 outside 1st–99th percentile |
| yoy_pctdouble | 3.2% | 3,740 | -40.01 → 55.22median 0.6388 | 72 outside 1st–99th percentile |
| ann3m_pctdouble | 1.1% | 2,792 | -86.67 → 114.39median 0.7156 | 74 outside 1st–99th percentile |
| yoy_z36double | 6.2% | 3,570 | -3.73 → 3.67median 0.0114 | 70 outside 1st–99th percentile |
| cost_pressure_scoredouble | 3.3% | 3,290 | 0 → 100median 38.2 | |
| pressure_rankbigint | 3.3% | 11 | 1 → 10median 5 | |
| breadth_up_sharedouble | 2.6% | 6 | 0 → 1median 0.6 | |
| fuels_spread_ppdouble | 23.6% | 290 | -13.83 → 14.86median 0.4645 | 50 outside 1st–99th percentile |
| core_yoy_pctdouble | 27.6% | 240 | -5.25 → 7.97median 1.51 | 60 outside 1st–99th percentile |
| import_deflationbigint | 3.2% | 2 | 0 → 1median 0 | |
| rapid_surgebigint | 3.2% | 2 | 0 → 1median 0 | |
| record_high_12mbigint | 0% | 2 | 0 → 1median 0 | |
| accel_3mbigint | 3.5% | 2 | 0 → 1median 0 | |
| row_hashvarchar | 0% | 4,549 | — |
|
- Current
20261001T044130Z-ba86a0dbc648 · sha256 ba86a0dbc648…
3,714 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/fred_import_price_intel/us_import_price_passthrough_monthly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/fred_import_price_intel/us_import_price_passthrough_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/fred_import_price_intel/us_import_price_passthrough_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 20261001T044130Z-ba86a0dbc648 and its content hash, so readers get exactly the data you used.
US Import-Price Passthrough Intelligence (FRED, keyless). (2026). US import-price passthrough intelligence, monthly [Data set, snapshot 20261001T044130Z-ba86a0dbc648, sha256 ba86a0dbc648]. Datazimuts. Retrieved 2026-10-01, from https://datazimuts.com/en/datasets/fred_import_price_intel/us_import_price_passthrough_monthly?snapshot=20261001T044130Z-ba86a0dbc648
@misc{dz_fred_import_price_intel_us_import_price__ba86a0db,
title = {{US import-price passthrough intelligence, monthly}},
author = {{US Import-Price Passthrough Intelligence (FRED, keyless)}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/fred_import_price_intel/us_import_price_passthrough_monthly?snapshot=20261001T044130Z-ba86a0dbc648}},
note = {Snapshot 20261001T044130Z-ba86a0dbc648, sha256 ba86a0dbc648013be6b5de80c8afbaa5dc867c407d793cf293668ccf75b17076; accessed 2026-10-01}
}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=fred_import_price_intel%2Fus_import_price_passthrough_monthly&lang=en&theme=auto&snapshot=20261001T044130Z-ba86a0dbc648&x=year_month&y=index_value&agg=avg" title="US import-price passthrough intelligence, monthly" 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.