Download the Data

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

Nominal Data

The FoodDollarDataNominal.xlsx file and the FoodDollarDataNominal.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 2022

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

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 group)
2. Agribusiness
3. Farm production
4. Food processing
5. Packaging
6. Transportation
7. Wholesale trade
8. Retail trade
9. Food services
10. Energy
11. Finance and insurance
12. Advertising
13. Legal and accounting
14. Total food dollars
15. Domestic food dollars
16. Farm share

The data column statistics cover three primary value added categories, 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 nontax 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 nondomestic 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 group with which the imported products are associated).
• Total: The sum of value added from salary and benefits, output taxes, property income, and imports.

Note: Tables 7–16 are only available for benchmark years 1997, 2002, 2007, and 2012.

Breakouts for salary and benefits, output taxes and property income are not available for years 1993–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.xlsx file and the FoodDollarDataReal.csv file include statistics reported in constant year 2012 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 2022

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

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 group)
2. Agribusiness
3. Farm production
4. Food processing
5. Packaging
6. Transportation
7. Wholesale trade
8. Retail trade
9. Food services
10. Energy
11. Finance and insurance
12. Advertising
13. Legal and accounting
14. Total food dollar
15. Domestic food dollar
16. Farm share

The data column statistics cover domestic value added, 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 nondomestic 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 with which the imported products are associated).
• Total: The sum of value added from domestic establishments and imports.

Note: Tables 7–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