Baselight
Sign In

FoodData Central

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

@kaggle.pranavkarnani_fooddata_central

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
  • 269.63 MB
  • 1841897 rows
  • 45 columns
Loading...
 

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
);