USDA ERS Food Dollar Series
Datadory delivers usda ers food dollar series data: the official decomposition of every US food dollar into farm, processing, packaging, transportation, wholesale, retail and food-service shares - 47 spending accounts across three bills, 126,900 linearized rows spanning 2007-2024 nationally, delivered daily, weekly, or hourly.
What is the USDA ERS Food Dollar Series?
The receipt, itemized. The USDA ERS Food Dollar Series takes the American food spending dollar and accounts for where every cent lands along the supply chain - farm production, agribusiness, food processing, packaging, transportation and storage, food wholesale, food retail, food services, energy, and the professional services in between. It is the Economic Research Service's input-output reading of who captures what, built on BEA input-output tables through the Agri-Food Economic Data System and comprehensively rebuilt in the March 2026 release.
The scope runs to 47 food spending accounts: six aggregates (all food, food at home, food away from home, and the alcohol trio), 28 food-at-home product accounts from bakery products to beef, seven food-away-from-home outlets from full-service restaurants to schools, and six alcohol product and outlet accounts. Every account reads across three bills - marketing, industry group, and primary factor - in millions of dollars and in cents per domestic food dollar. Within the Financial Exchanges & Data catalog it is the value-chain margin record, not a price ticker. Get a sample of this dataset cut to the accounts and years you model.
What does a sample row look like?
One measurement, twelve identifying facts. Three rows exactly as they ship:
Year : 2024
Type : Food
Channel : All
Aggregation : Type total
Account : Xf1000
AccountName : Food
Series : Industry group bill
Category : 8
CategoryName : Food wholesale
ValueTypeDesc : Total
Unit : Cents per domestic food dollar
Value : 6.3
Series : Industry group bill
ValueTypeDesc : Total
Unit : Million U.S. Dollars
Value : 137393.8
Series : Primary factor bill
Channel : Food-at-home
Aggregation : Detail
AccountName : Cereals
ValueTypeDesc : Salary and benefits
Unit : Cents per domestic food dollar
Value : 49.3Read together they show why analysts like this shape. The first pins the headline: food wholesale captured 6.3 cents of the 2024 domestic food dollar. The second restates the same cell in absolute terms - $137,393.8 million - so share claims reconcile to dollar scale without a second source. The third drops to a single product account, cereals, and a single primary factor, salary and benefits, at 49.3 cents of the at-home cereal dollar. The layout is linearized - one value per row keyed by account, series, category, value type and unit - which filters cleanly on five identifying columns instead of fighting a wide pivot.
What fields does the dataset include?
Thirteen fields define every row of the current nominal series, each definition checked against the published data dictionary during the August 2026 research pass. The identifying columns stack into a natural key - year, spending type, channel, account, series, category, value type, unit - which is why joins against your own category master hold up without a crosswalk.
Two conventions worth internalizing before you build. Account codes all start with Xf plus four digits, where the first two digits encode the channel - so Xf1101 (Cereals) announces itself as a food-at-home detail account. And Category 8 within the industry group bill is Food wholesale, the cell distributor-margin models usually want first.
What does coverage look like across geography, time and granularity?
Geography - United States national totals. There is no state, metro or county cut anywhere in the series; the input-output construction prices the domestic supply chain as one system.
Temporal - the current model spans 2007-2024 annually. Archived files published under the prior 2011 model extend 1993-2023 in nominal and real terms, with real values expressed in constant 2017 dollars. The two vintages are built on different methodologies and are not directly comparable.
Granularity - one value per food spending account (47) per series (total spending, marketing bill, industry group bill, industry group by primary factor, primary factor bill) per industry group (13) per value type (total, salary and benefits, property income, output taxes, imported inputs) per unit - 126,900 rows in the current nominal series alone.
How is the data delivered?
API, files, or your warehouse. Daily, weekly, or hourly.
Your cadence is your call regardless of how often the underlying accounts move - most cells change on the annual cycle, and a scheduled warehouse load keeps dashboards current without anyone babysitting the pipeline. Every delivery ships the complete thirteen-field dictionary above, the sample rows, and the coverage profile mapped to the accounts and years you named.
Who uses this data, and for what?
- Distributor margin benchmarking - the 6.3-cent food wholesale share and its $137.4 billion 2024 dollar equivalent give wholesale and distribution teams an external yardstick for gross-margin arguments.
- Farm-versus-marketing share tracking - the marketing bill splits every food dollar between farm production and everything downstream, the cleanest public read on where price inflation actually sticks.
- Factor modeling - the primary factor bill decomposes each industry group into salaries and benefits, property income, output taxes and imported inputs; food wholesale's $74.3 billion labor component is one cell among hundreds.
- Channel mix analysis - food-at-home versus food-away-from-home shares quantify the restaurant-versus-grocery tug across 28 product categories and 7 outlet types.
- Category-level pass-through studies - detail accounts such as cereals support product-level chains from primary factor to final dollar.
- Citation-grade sourcing - methods are documented in ERS technical bulletins TB-1973 and TB-1974, so published numbers survive peer review and diligence.
Which personas get the most value?
Investors and quant researchers get a defensible margin series for food-system exposure models - see investors quants use cases. Data scientists and ML engineers get a linearized panel that pivots into features without cleanup - see data scientists use cases. Market researchers and consultants sizing food distribution get channel and category splits straight from the accounting identity - see market researchers use cases. Developers building data products get one flat schema across every account and year - see developers builders use cases. Journalists, academics and students get the canonical citation whenever a story says "only X cents of your food dollar reaches the farm."
Which datasets pair with this one?
- Annual Integrated Economic Survey (AIES) - the successor to the Annual Wholesale Trade Survey carrying services-sector trade receipts; the head-to-head sets out when each answers the margin question.
- U.S. Economic Census - Wholesale Trade (NAICS 424) - merchant-wholesale receipts and margins at establishment grain, the absolute-scale complement to the food-dollar shares.
- Food dollar series glossary entry - the vocabulary - bills, shares, factors - defined once.
- Wholesale share of the food dollar - a worked read of the distributor slice this series quantifies.
- USDA Economic Research Service source profile - the agency behind the series and its neighboring products.
Field dictionary
Every field below is documented against real records. The full dictionary ships with the sample.
| field | type | definition | example |
|---|---|---|---|
Year | integer | Calendar year of the estimate. | 2024 |
Type | string | Spending type: Food or Alcohol. | Food |
Channel | string | Spending channel: All, Food-at-home, Food-away-from-home, Alcohol-at-home or Alcohol-away-from-home. | Food-at-home |
Aggregation | string | Level of the account row: Total, Type total, or Detail for product-specific accounts. | Type total |
Account | string | Food spending account code; always 'Xf' plus four digits, the first two encoding the channel. | Xf1000 |
AccountName | string | Description of the account contents, e.g. Food, Cereals. | Food |
Series | string | Bill the row belongs to: Total spending, Marketing bill, Industry group bill, Industry group by primary factor, or Primary factor bill. | Industry group bill |
Category | integer | Category number within the series; in the industry group bill, 8 is Food wholesale. | 8 |
CategoryName | string | Description of the category, e.g. Industry group total, Food wholesale, Farm production, Food processing, Transportation and storage, Food retail, Food services. | Food wholesale |
ValueType | integer | Numeric key (1-5) for the value type description. | 1 |
ValueTypeDesc | string | Primary factor component of the value: Total, Salary and benefits, Property income, Output taxes, Imported inputs. | Total |
Unit | string | Unit of measure: Million U.S. Dollars or Cents per domestic food dollar. | Cents per domestic food dollar |
Value | number | The measured value for the row in the stated unit. | 6.3 |
Questions buyers ask
How far back does the USDA ERS Food Dollar Series go?
The current model covers 2007-2024. Archived files published under the earlier 2011 model extend 1993-2023 in nominal and real terms, with real figures in constant 2017 dollars. Because the 2026 rebuild changed methodology, treat the two vintages as related series rather than one continuous line.
What are the three bills in the series?
The marketing bill splits each food dollar between farm share and marketing share. The industry group bill assigns it across 13 groups from agriculture and food processing through wholesale, retail and food services. The primary factor bill decomposes those groups into salaries and benefits, property income, output taxes and imported inputs.
How much of the food dollar goes to wholesale?
In 2024, food wholesale captured 6.3 cents of the domestic food dollar, equal to $137,393.8 million. Of that, $74,278.2 million was salary and benefits - the primary-factor view shows what the wholesale margin pays for, not just how large it is.
Does the series break out states or metro areas?
No. Coverage is United States national totals; there is no state, metro or county detail anywhere in the series. The input-output construction prices the domestic food supply chain as a single system, so channel, category and factor cuts replace geographic ones.
Can a sample be cut to specific accounts and years?
Yes. Name the channels, product accounts and year range you care about - food-away-from-home outlets only, cereals back to 2007, wholesale by primary factor - and the sample arrives shaped to that scope with the full thirteen-field dictionary attached. Samples precede any commitment.
See the rows before you pay anything.
Name this dataset and we send real records from it — scoped to the fields you asked for.