Name: FoodData Central
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

FoodData Central

Source: US Department of Agriculture

Use: This dataset contains the basic nutrient information (sugar, fiber, carbohydrates, cholestrol levels etc. ) of over 1.8M food products approved for sale in US. The dataset is also categorized by product type.

Motivation:
I recently learnt that I was missing fiber in my diet. In an attempt to add more fiber I looked for fiber heavy cereals. Finding the right product in the grocery store was a nightmare as I had to scan through various products and compare them manually.

Later I took to the internet to browse through different food items sold in retail grocery outlets which could help add fiber to my diet. I found the FoodCentral dataset which was extremely convoluted and had over 20 CSV's, with no straightforward way to parse out nutrient information. I hence created this dataset which scans through all the different files and stitches the nutrient information along with the ID, Description and Ingredients of over 1.8M categorized food products approved for sale in USA.

Tables

Fda Approved Food Items W Nutrient Info

@kaggle.pranavkarnani_fooddata_central.fda_approved_food_items_w_nutrient_info

282.73 MB
1,841,897 rows
45 columns

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  -- Calcium, Ca-MG,
  "carbohydrate_by_difference_g" DOUBLE  -- Carbohydrate, By Difference-G,
  "cholesterol_mg" DOUBLE,
  "copper_cu_mg" DOUBLE  -- Copper, Cu-MG,
  "energy_kcal" DOUBLE,
  "fatty_acids_total_monounsaturated_g" DOUBLE  -- Fatty Acids, Total Monounsaturated-G,
  "fatty_acids_total_polyunsaturated_g" DOUBLE  -- Fatty Acids, Total Polyunsaturated-G,
  "fatty_acids_total_saturated_g" DOUBLE  -- Fatty Acids, Total Saturated-G,
  "fatty_acids_total_trans_g" DOUBLE  -- Fatty Acids, Total Trans-G,
  "fiber_soluble_g" DOUBLE  -- Fiber, Soluble-G,
  "fiber_total_dietary_g" DOUBLE  -- Fiber, Total Dietary-G,
  "folate_total_ug" DOUBLE  -- Folate, Total-UG,
  "folic_acid_ug" DOUBLE,
  "iron_fe_mg" DOUBLE  -- Iron, Fe-MG,
  "magnesium_mg_mg" DOUBLE  -- Magnesium, Mg-MG,
  "manganese_mn_mg" DOUBLE  -- Manganese, Mn-MG,
  "niacin_mg" DOUBLE,
  "pantothenic_acid_mg" DOUBLE,
  "phosphorus_p_mg" DOUBLE  -- Phosphorus, P-MG,
  "potassium_k_mg" DOUBLE  -- Potassium, K-MG,
  "protein_g" DOUBLE,
  "riboflavin_mg" DOUBLE,
  "sodium_na_mg" DOUBLE  -- Sodium, Na-MG,
  "sugars_added_g" DOUBLE  -- Sugars, Added-G,
  "sugars_total_including_nlea_g" DOUBLE  -- Sugars, Total Including NLEA-G,
  "thiamin_mg" DOUBLE,
  "total_lipid_fat_g" DOUBLE  -- Total Lipid (fat)-G,
  "total_sugar_alcohols_g" DOUBLE,
  "vitamin_a_iu_iu" DOUBLE  -- Vitamin A, IU-IU,
  "vitamin_b_12_ug" DOUBLE,
  "vitamin_b_6_mg" DOUBLE,
  "vitamin_c_total_ascorbic_acid_mg" DOUBLE  -- Vitamin C, Total Ascorbic Acid-MG,
  "vitamin_d_d2_d3_international_units_iu" DOUBLE  -- Vitamin D (D2 + D3), International Units-IU,
  "vitamin_d_d2_d3_ug" DOUBLE  -- Vitamin D (D2 + D3)-UG,
  "zinc_zn_mg" DOUBLE  -- Zinc, Zn-MG
);