TopicsTopics

Stay Connected

Follow ERS on Twitter
Subscribe to RSS feeds
Subscribe to ERS e-Newsletters.aspx
Listen to ERS podcasts
Read ERS blogs at USDA

Download the Data

Food dollar data tables are available in Excel and csv format. Some notes about the data files:

Nominal Data

The FoodDollarDataNominal.xls file and the NominalData.csv file include statistics reported in current year dollars. In the data rows, each row statistic covers a unique combination of year, unit of measurement, table number, and category number. These are defined as follows:

YEAR:   1993 to 2012

UNITS:  reported in both cents per domestic food dollar and total domestic food dollars ($ millions)

TABLE_NUM:

  1. Food dollar
  2. Food-at-home dollar
  3. Food-away-from-home dollar
  4. Food and beverage dollar
  5. Home food and beverage dollar
  6. Away food and beverage dollar
  7. Food at home: Cereals
  8. Food at home: Bakery products
  9. Food at home: Beef, pork and other meats
  10. Food at home: Poultry
  11. Food at home: Fish and seafood
  12. Food at home: Fresh milk
  13. Food at home: Processed dairy products
  14. Food at home: Eggs
  15. Food at home: Fats and oils
  16. Food at home: Fresh fruits
  17. Food at home: Fresh vegetables
  18. Food at home: Processed fruits and vegetables
  19. Food at home: Sugar and sweets
  20. Food at home: Other foods
  21. Home food and beverage: Nonalcoholic beverages
  22. Home food and beverage: Alcoholic beverages

CATEGORY_NUM:

  1. Total (Industry Groups)
  2. Agribusiness
  3. Farm production
  4. Food processing
  5. Packaging
  6. Transportation
  7. Wholesale trade
  8. Retail trade
  9. Foodservices
  10. Energy
  11. Finance & Insurance
  12. Advertising
  13. Legal & accounting
  14. Total food dollars
  15. Domestic food dollars
  16. Farm share                                                                                                

The data column statistics cover three primary value-added categories, and imports and row totals: 

  • Salary_and_benefits: Compensation to domestic hired labor for services on behalf of a domestic establishment that directs sales towards fulfilling the supply of food to the U.S. market.
  • Output_taxes: Excise, sales, property, and severance taxes (less subsidies), customs duties, and non-tax fees levied by Federal, State, and local governments.
  • Property_income: Compensation to owners of machinery, equipment, structures, natural resources, product inventory, and other tangible or intangible assets for services on behalf of a domestic establishment that directs sales to the U.S. food supply.
  • Imports: Compensation to international assets for their services on behalf of non-domestic establishments whose products are imported and used as production inputs by U.S. establishments that directs sales to the U.S. food supply (value added is assigned to industry groups the imported products are associated).
  • Total: The sum of value added from salary and benefits, output taxes, property income and imports.

Notes: Tables 7 to 16 are only available for benchmark years 1997, 2002, and 2007.  

Breakouts for salary and benefits, output taxes and property icome are not available for years 1993 to 1996, but are subsumed in the 'total' column. 

File Layout (comma separated with quotation (") field qualifiers):

Field and format:

  • table_num: numeric
  • TABLE_NAME: text
  • category_num: numeric
  • CATEGORY_DESC: text
  • year: numeric
  • units: text
  • salary_and_benefits: numeric
  • output_taxes: numeric
  • property_income: numeric
  • imports: numeric
  • total: numeric

Real Data 

The FoodDollarDataReal.xls file and the FoodDollarDataReal.csv file include statistics reported in constant year 2005 dollars. In the data rows, each row statistic covers a unique combination of year, unit of measurement, table number, and category number. These are defined as follows:

YEAR:   1993 to 2012

UNITS:  reported in both cents per domestic food dollar and total domestic food dollars ($ millions)

TABLE_NUM:

  1. Food dollar
  2. Food-at-home dollar
  3. Food-away-from-home dollar
  4. Food and beverage dollar
  5. Home food and beverage dollar
  6. Away food and beverage dollar

CATEGORY_NUM:  

  1. Total (Industry Groups)
  2. Agribusiness
  3. Farm production
  4. Food processing
  5. Packaging
  6. Transportation
  7. Wholesale trade
  8. Retail trade
  9. Foodservices
  10. Energy
  11. Finance & Insurance
  12. Advertising
  13. Legal & accounting
  14. Total food dollar
  15. Domestic food dollar
  16. Farm share                                                                                                

The data column statistics cover domestic value added, and imports and row totals: 

  • Value_added: Compensation to domestic establishments that direct sales to the U.S. food supply.
  •  Imports: Compensation to international assets for their services on behalf of non-domestic establishments whose products are imported and used as production inputs by U.S. establishments that directs sales to the U.S. food supply (value added is assigned to industry groups the imported products are associated).
  • Total: The sum of value added from domestic establishments and imports.                                                                                               

Note: Tables 7 to 16 are not available for the real accounts.

File Layout (comma separated with quotation (") field qualifiers):

Field and format:

  • table_num: numeric
  • TABLE_NAME: text
  • category_num: numeric
  • CATEGORY_DESC: text
  • year: numeric
  • units: text
  • value_added: numeric
  • imports: numeric
  • total: numeric                                                                                                      
Data Set  Download as Excel
DownloadsLast UpdatedNext Update
Food dollar nominal dataBack to top
Food dollar nominal data Download as Excel5/28/2014
Food dollar real dataBack to top
Food dollar real dataDownload as Excel5/28/2014

Last updated: Tuesday, June 10, 2014

For more information contact: Patrick Canning