FoodData Central

Nutrient information of ~2M food approved by FDA for sale in USA (As per USDA)

@kaggle.pranavkarnani_fooddata_central

Table List

1 table(269.63 MB)

Fda Approved Food Items W Nutrient Info

@kaggle.pranavkarnani_fooddata_central.fda_approved_food_items_w_nutrient_info

269.63 MB
1841897 rows
45 columns

fdc_id Fdc Id	brand_owner Brand Owner	description Description	ingredients Ingredients	gtin_upc Gtin Upc	serving_size Serving Size	serving_size_unit Serving Size Unit	branded_food_category Branded Food Category	modified_date Modified Date	available_date Available Date	calcium_ca_mg Calcium, Ca-MG	carbohydrate_by_difference_g Carbohydrate, By Difference-G	cholesterol_mg Cholesterol-MG	energy_kcal Energy-KCAL	fatty_acids_total_monounsaturated_g Fatty Acids, Total Monounsaturated-G	fatty_acids_total_polyunsaturated_g Fatty Acids, Total Polyunsaturated-G	fatty_acids_total_saturated_g Fatty Acids, Total Saturated-G	fiber_total_dietary_g Fiber, Total Dietary-G	folic_acid_ug Folic Acid-UG	iron_fe_mg Iron, Fe-MG	potassium_k_mg Potassium, K-MG	protein_g Protein-G	riboflavin_mg Riboflavin-MG	sodium_na_mg Sodium, Na-MG	sugars_total_including_nlea_g Sugars, Total Including NLEA-G	total_lipid_fat_g Total Lipid (fat)-G	vitamin_c_total_ascorbic_acid_mg Vitamin C, Total Ascorbic Acid-MG
1105904	Richardson Oilseed Products (US) Limited	WESSON Vegetable Oil 1 GAL	Vegetable Oil	27000612323	15	ml	Oils Edible	Fri Oct 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)				867	20	53.33	13.33									93.33
1105905	CAMPBELL SOUP COMPANY	SWANSON BROTH BEEF	INGREDIENTS: BEEF STOCK, CONTAINS LESS THAN 2% OF: MIREPOIX (CARROTS, CELERY, ONIONS), SALT, NATURAL FLAVORING, YEAST EXTRACT, CANE SUGAR.	51000198808	240	ml	Herbs/Spices/Extracts	Sat Sep 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		0.42		4								0.83		346	0.42
1105906	CAMPBELL SOUP COMPANY	CAMPBELL'S SLOW KETTLE SOUP CLAM CHOWDER	INGREDIENTS: CLAM STOCK, POTATOES, CLAMS, CREAM, VEGETABLE OIL (CORN, CANOLA, AND/OR SOYBEAN), CELERY, CONTAINS LESS THAN 2% OF: MODIFIED FOOD STARCH, SALT, WHEAT FLOUR, SOY PROTEIN CONCENTRATE, UNCURED SMOKED BACON PIECES-NO NITRATES OR NITRITES ADDED, EXCEPT FOR THOSE NATURALLY OCCURRING IN SEA SA…	51000213273	440	g	Prepared Soups	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	16	6.12	6	82			1.02	0.4		0.24	65	2.45		363	0.41	5.31
1105907	CAMPBELL SOUP COMPANY	CAMPBELL'S SLOW KETTLE SOUP CHEESE BROCCOLI	INGREDIENTS: WATER, CREAM, BROCCOLI, CELERY, VEGETABLE OIL (CORN, CANOLA, AND/OR SOYBEAN), MODIFIED FOOD STARCH, CHEDDAR CHEESE** (CHEDDAR CHEESE [CULTURED MILK, SALT, ENZYMES], WHEY, SALT, SODIUM PHOSPHATE), CONTAINS LESS THAN 2% OF: BUTTER, PARMESAN AND CHEDDAR CHEESE (MILK, CULTURES, SALT, ENZYME…	51000213303	440	g	Prepared Soups	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	33	5.31	10	82			2.45	0.4		0.16	65	1.22		322	0.82	6.12
1105908	CAMPBELL SOUP COMPANY	SWANSON BROTH CHICKEN	INGREDIENTS: CHICKEN STOCK, CONTAINS LESS THAN 2% OF: YEAST EXTRACT, DEHYDRATED CHICKEN, NATURAL FLAVORING, CARROT JUICE CONCENTRATE, CELERIAC JUICE CONCENTRATE, CHICKEN FAT, ONION EXTRACT.	51000224637	240	ml	Herbs/Spices/Extracts	Sat Oct 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4	0.42		4							12	0.83		15	0.42
1105909	CAMPBELL SOUP COMPANY	CAMPBELL'S SOUP BEAN AND HAM	INGREDIENTS: WATER, PEA BEANS, CARROTS, COOKED HAM - WATER ADDED (PORK, WATER, SALT, SUGAR, SODIUM PHOSPHATES, SODIUM ASCORBATE, SODIUM NITRITE), CELERY, CONTAINS LESS THAN 2% OF: MODIFIED FOOD STARCH, SUGAR, TOMATO PASTE, SALT, WHEAT FLOUR, YEAST EXTRACT, MONOSODIUM GLUTAMATE, NATURAL FLAVORING, BE…	51000227492	412	g	Prepared Soups	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	24	10.61	4	61				2.4		0.82	155	3.67		306	1.63	0.61
1105910	CAMPBELL SOUP COMPANY	SWANSON BROTH BEEF	INGREDIENTS: BEEF STOCK, CONTAINS LESS THAN 2% OF: MIREPOIX (CARROTS, CELERY, ONIONS), SALT, NATURAL FLAVORING, YEAST EXTRACT, CANE SUGAR.	51000024213	411	g	Herbs/Spices/Extracts	Sat Oct 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		0.43		4						0.09	13	0.85		353	0.43
1105911	CAMPBELL SOUP COMPANY	PREGO SAUCES TOMATO BASIL	INGREDIENTS: DICED TOMATOES IN TOMATO JUICE, TOMATO PUREE (WATER, TOMATO PASTE), ONIONS, OLIVE OIL, GARLIC, CONTAINS LESS THAN 1% OF: SALT, BASIL, CITRIC ACID, BLACK PEPPER, OREGANO.	51000227478	120	ml	Sauces/Spreads/Dips/Condiments	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	33	5.83		58			0.42	2.5		0.3	175	1.67		358	3.33	3.33
1105912	CAMPBELL SOUP COMPANY	CAMPBELL'S SOUP TOMATO	INGREDIENTS: TOMATO PUREE (WATER, TOMATO PASTE), WATER, HIGH FRUCTOSE CORN SYRUP, WHEAT FLOUR, CONTAINS LESS THAN 2% OF: VEGETABLE OIL (CORN, CANOLA, AND/OR SOYBEAN), SALT, POTASSIUM CHLORIDE, NATURAL FLAVORING, CITRIC ACID, ASCORBIC ACID (VITAMIN C), MONOPOTASSIUM PHOSPHATE, CELERY EXTRACT, GARLIC …	51000058874	120	ml	Prepared Soups	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	17	15		75		0.42		0.8		0.33	517	1.67		342	9.17	1.25	9.2
1105913	CAMPBELL SOUP COMPANY	CAMPBELL'S PASTA SPAGHETTIOS W FRANKS	INGREDIENTS: WATER, TOMATO PUREE (WATER, TOMATO PASTE), CHICKEN AND PORK FRANKFURTERS MADE WITH CHICKEN, PORK AND BEEF (MECHANICALLY SEPARATED CHICKEN, PORK, WATER, CORN SYRUP, SALT, BEEF, MODIFIED FOOD STARCH, DEXTROSE, ASCORBIC ACID, SODIUM NITRITE, NATURAL FLAVORS), ENRICHED PASTA (WHEAT FLOUR, N…	51000232847	443	g	Dough Based Products / Meals	Sat Sep 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12	11.51	10	87	1.19	0.6	0.79	1.2	22	0.63	147	3.57	0.079	238	3.97	2.78


CREATE TABLE fda_approved_food_items_w_nutrient_info (
  "fdc_id" BIGINT,
  "brand_owner" VARCHAR,
  "description" VARCHAR,
  "ingredients" VARCHAR,
  "gtin_upc" VARCHAR,
  "serving_size" DOUBLE,
  "serving_size_unit" VARCHAR,
  "branded_food_category" VARCHAR,
  "modified_date" TIMESTAMP,
  "available_date" TIMESTAMP,
  "calcium_ca_mg" DOUBLE,
  "carbohydrate_by_difference_g" DOUBLE,
  "cholesterol_mg" DOUBLE,
  "copper_cu_mg" DOUBLE,
  "energy_kcal" DOUBLE,
  "fatty_acids_total_monounsaturated_g" DOUBLE,
  "fatty_acids_total_polyunsaturated_g" DOUBLE,
  "fatty_acids_total_saturated_g" DOUBLE,
  "fatty_acids_total_trans_g" DOUBLE,
  "fiber_soluble_g" DOUBLE,
  "fiber_total_dietary_g" DOUBLE,
  "folate_total_ug" DOUBLE,
  "folic_acid_ug" DOUBLE,
  "iron_fe_mg" DOUBLE,
  "magnesium_mg_mg" DOUBLE,
  "manganese_mn_mg" DOUBLE,
  "niacin_mg" DOUBLE,
  "pantothenic_acid_mg" DOUBLE,
  "phosphorus_p_mg" DOUBLE,
  "potassium_k_mg" DOUBLE,
  "protein_g" DOUBLE,
  "riboflavin_mg" DOUBLE,
  "sodium_na_mg" DOUBLE,
  "sugars_added_g" DOUBLE,
  "sugars_total_including_nlea_g" DOUBLE,
  "thiamin_mg" DOUBLE,
  "total_lipid_fat_g" DOUBLE,
  "total_sugar_alcohols_g" DOUBLE,
  "vitamin_a_iu_iu" DOUBLE,
  "vitamin_b_12_ug" DOUBLE,
  "vitamin_b_6_mg" DOUBLE,
  "vitamin_c_total_ascorbic_acid_mg" DOUBLE,
  "vitamin_d_d2_d3_international_units_iu" DOUBLE,
  "vitamin_d_d2_d3_ug" DOUBLE,
  "zinc_zn_mg" DOUBLE
);