Overview

The following data comes from the United States Department of Agriculture's Food Composition Database. It contains data for various types of food including the amounts of different vitamins and minerals found in the foods as well as macronutrient percentages. The food covered spans a large variety of foods from butter to Campbell's soup.

https://ndb.nal.usda.gov/

Downloads

Download all of the following files.

Field Descriptions

JSON Path Type Comment Example Value
[0].Category unicode BUTTER
[0].Data dict {u'Niacin': 0.042, u'Major Minerals': {u'Copper': 0.0, u'Zinc': 0.09, u'Sodium': 576, u'Potassium': 24, u'Calcium': 24, u'Magnesium': 2, u'Iron': 0.02, u'Phosphorus': 24}, u'Vitamins': {u'Vitamin A - IU': 2499, u'Vitamin C': 0.0, u'Vitamin B12': 0.17, u'Vitamin B6': 0.003, u'Vitamin A - RAE': 684, u'Vitamin E': 2.32, u'Vitamin K': 7.0}, u'Carboydrate': 0.06, u'Selenium': 1.0, u'Thiamin': 0.005, u'Choline': 19, u'Beta Carotene': 158, u'Fiber': 0.0, u'Refuse Percentage': 0, u'Fat': {u'Saturated Fat': 51.368, u'Monosaturated Fat': 21.021, u'Total Lipid': 81.11, u'Polysaturated Fat': 3.043}, u'Water': 15.87, u'Lycopene': 0, u'Pantothenic Acid': 0.11, u'Ash': 2.11, u'Household Weights': {u'2nd Household Weight': 14, u'2nd Household Weight Description': u'1 tbsp', u'1st Household Weight': 227.0, u'1st Household Weight Description': u'1 cup'}, u'Retinol': 671, u'Manganese': 0.0, u'Beta Cryptoxanthin': 0, u'Riboflavin': 0.034, u'Cholesterol': 215, u'Lutein and Zeaxanthin': 0, u'Kilocalories': 717, u'Alpha Carotene': 0, u'Sugar Total': 0.059999999, u'Protein': 0.85}
[0].Description unicode BUTTER,WITH SALT
[0].Nutrient Data Bank Number int 1001
[0].Data.Fat.Saturated Fat float 51.368
[0].Data.Fat.Monosaturated Fat float 21.021
[0].Data.Fat.Total Lipid float 81.11
[0].Data.Fat.Polysaturated Fat float 3.043
[0].Data.Niacin float 0.042
[0].Data.Major Minerals dict In milligrams per 100 grams {u'Copper': 0.0, u'Zinc': 0.09, u'Sodium': 576, u'Potassium': 24, u'Calcium': 24, u'Magnesium': 2, u'Iron': 0.02, u'Phosphorus': 24}
[0].Data.Vitamins dict In milligrams per 100 grams {u'Vitamin A - IU': 2499, u'Vitamin C': 0.0, u'Vitamin B12': 0.17, u'Vitamin B6': 0.003, u'Vitamin A - RAE': 684, u'Vitamin E': 2.32, u'Vitamin K': 7.0}
[0].Data.Carboydrate float 0.06
[0].Data.Selenium float 1.0
[0].Data.Thiamin float 0.005
[0].Data.Choline int 19
[0].Data.Beta Carotene int 158
[0].Data.Fiber float 0.0
[0].Data.Refuse Percentage int 0
[0].Data.Fat dict {u'Saturated Fat': 51.368, u'Monosaturated Fat': 21.021, u'Total Lipid': 81.11, u'Polysaturated Fat': 3.043}
[0].Data.Water float 15.87
[0].Data.Lycopene int 0
[0].Data.Pantothenic Acid float 0.11
[0].Data.Ash float 2.11
[0].Data.Alpha Carotene int 0
[0].Data.Retinol int 671
[0].Data.Manganese float 0.0
[0].Data.Beta Cryptoxanthin int 0
[0].Data.Riboflavin float 0.034
[0].Data.Cholesterol int 215
[0].Data.Lutein and Zeaxanthin int 0
[0].Data.Kilocalories int 717
[0].Data.Household Weights dict {u'2nd Household Weight': 14, u'2nd Household Weight Description': u'1 tbsp', u'1st Household Weight': 227.0, u'1st Household Weight Description': u'1 cup'}
[0].Data.Sugar Total float 0.059999999
[0].Data.Protein float 0.85
[0].Data.Vitamins.Vitamin A - IU int 2499
[0].Data.Vitamins.Vitamin C float 0.0
[0].Data.Vitamins.Vitamin B12 float 0.17
[0].Data.Vitamins.Vitamin B6 float 0.003
[0].Data.Vitamins.Vitamin A - RAE int 684
[0].Data.Vitamins.Vitamin E float 2.32
[0].Data.Vitamins.Vitamin K float 7.0
[0].Data.Major Minerals.Copper float 0.0
[0].Data.Major Minerals.Iron float 0.02
[0].Data.Major Minerals.Sodium int 576
[0].Data.Major Minerals.Potassium int 24
[0].Data.Major Minerals.Calcium int 24
[0].Data.Major Minerals.Magnesium int 2
[0].Data.Major Minerals.Zinc float 0.09
[0].Data.Major Minerals.Phosphorus int 24
[0].Data.Household Weights.1st Household Weight Description unicode 1 cup
[0].Data.Household Weights.1st Household Weight float 227.0
[0].Data.Household Weights.2nd Household Weight int 14
[0].Data.Household Weights.2nd Household Weight Description unicode 1 tbsp