Name: En.openfoodfacts.org.products
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

En.openfoodfacts.org.products

Open Food Facts

Open Food Facts is a food products database made by everyone, for everyone. You can use it to make better food choices, and as it is open data, anyone can re-use it for any purpose. Open Food Facts is a non-profit project developed by thousands of volunteers from around the world.

Content

This dataset contains nutritional data for over a million products added by contributors around the world. It also contains Nutriscores and information on brands and packers.

knowledge

This dataset is used for data cleaning on heavy files and exploratory analysis.

Description

This file describes the fields from the CSV export of the products in the Open Food Facts database.

See https://world.openfoodfacts.org/data for more information.

The file encoding is Unicode UTF-8. The character that separates fields is

Tables

Cleaned Openfoodfacts

@kaggle.michaelfumery_enopenfoodfactsorgproducts.cleaned_openfoodfacts

121.2 MB
1,079,102 rows
24 columns

CREATE TABLE cleaned_openfoodfacts (
  "code" VARCHAR,
  "states_en" VARCHAR,
  "url" VARCHAR,
  "created_datetime" TIMESTAMP,
  "last_modified_datetime" TIMESTAMP,
  "creator" VARCHAR,
  "pnns_groups_2" VARCHAR,
  "countries_en" VARCHAR,
  "pnns_groups_1" VARCHAR,
  "product_name" VARCHAR,
  "energy_100g" DOUBLE,
  "proteins_100g" DOUBLE,
  "fat_100g" DOUBLE,
  "carbohydrates_100g" DOUBLE,
  "sugars_100g" DOUBLE,
  "salt_100g" DOUBLE,
  "sodium_100g" DOUBLE,
  "saturated_fat_100g" DOUBLE,
  "categories_en" VARCHAR,
  "main_category_en" VARCHAR,
  "nutriscore_score" DOUBLE,
  "nutriscore_grade" VARCHAR,
  "fiber_100g" DOUBLE,
  "fruits_vegetables_rate_100g" BIGINT
);

Countries En

@kaggle.michaelfumery_enopenfoodfactsorgproducts.countries_en

15.44 kB
240 rows
6 columns

CREATE TABLE countries_en (
  "n_1" BIGINT  -- 1,
  "n_4" BIGINT  -- 4,
  "af" VARCHAR,
  "afg" VARCHAR,
  "afghanistan" VARCHAR,
  "afghanistan_1" VARCHAR
);

En Openfoodfacts Org Products

@kaggle.michaelfumery_enopenfoodfactsorgproducts.en_openfoodfacts_org_products

416.9 MB
1,701,965 rows
184 columns

CREATE TABLE en_openfoodfacts_org_products (
  "code" VARCHAR,
  "url" VARCHAR,
  "creator" VARCHAR,
  "created_t" BIGINT,
  "created_datetime" TIMESTAMP,
  "last_modified_t" BIGINT,
  "last_modified_datetime" TIMESTAMP,
  "product_name" VARCHAR,
  "abbreviated_product_name" VARCHAR,
  "generic_name" VARCHAR,
  "quantity" VARCHAR,
  "packaging" VARCHAR,
  "packaging_tags" VARCHAR,
  "packaging_text" VARCHAR,
  "brands" VARCHAR,
  "brands_tags" VARCHAR,
  "categories" VARCHAR,
  "categories_tags" VARCHAR,
  "categories_en" VARCHAR,
  "origins" VARCHAR,
  "origins_tags" VARCHAR,
  "origins_en" VARCHAR,
  "manufacturing_places" VARCHAR,
  "manufacturing_places_tags" VARCHAR,
  "labels" VARCHAR,
  "labels_tags" VARCHAR,
  "labels_en" VARCHAR,
  "emb_codes" VARCHAR,
  "emb_codes_tags" VARCHAR,
  "first_packaging_code_geo" VARCHAR,
  "cities" VARCHAR,
  "cities_tags" VARCHAR,
  "purchase_places" VARCHAR,
  "stores" VARCHAR,
  "countries" VARCHAR,
  "countries_tags" VARCHAR,
  "countries_en" VARCHAR,
  "ingredients_text" VARCHAR,
  "allergens" VARCHAR,
  "allergens_en" VARCHAR,
  "traces" VARCHAR,
  "traces_tags" VARCHAR,
  "traces_en" VARCHAR,
  "serving_size" VARCHAR,
  "serving_quantity" DOUBLE,
  "no_nutriments" VARCHAR,
  "additives_n" DOUBLE,
  "additives" VARCHAR,
  "additives_tags" VARCHAR,
  "additives_en" VARCHAR,
  "ingredients_from_palm_oil_n" DOUBLE,
  "ingredients_from_palm_oil" VARCHAR,
  "ingredients_from_palm_oil_tags" VARCHAR,
  "ingredients_that_may_be_from_palm_oil_n" DOUBLE,
  "ingredients_that_may_be_from_palm_oil" VARCHAR,
  "ingredients_that_may_be_from_palm_oil_tags" VARCHAR,
  "nutriscore_score" DOUBLE,
  "nutriscore_grade" VARCHAR,
  "nova_group" DOUBLE,
  "pnns_groups_1" VARCHAR,
  "pnns_groups_2" VARCHAR,
  "states" VARCHAR,
  "states_tags" VARCHAR,
  "states_en" VARCHAR,
  "brand_owner" VARCHAR,
  "main_category" VARCHAR,
  "main_category_en" VARCHAR,
  "image_url" VARCHAR,
  "image_small_url" VARCHAR,
  "image_ingredients_url" VARCHAR,
  "image_ingredients_small_url" VARCHAR,
  "image_nutrition_url" VARCHAR,
  "image_nutrition_small_url" VARCHAR,
  "energy_kj_100g" DOUBLE,
  "energy_kcal_100g" DOUBLE,
  "energy_100g" DOUBLE,
  "energy_from_fat_100g" DOUBLE,
  "fat_100g" DOUBLE,
  "saturated_fat_100g" DOUBLE,
  "n__butyric_acid_100g" DOUBLE  -- -butyric-acid 100g,
  "n__caproic_acid_100g" DOUBLE  -- -caproic-acid 100g,
  "n__caprylic_acid_100g" DOUBLE  -- -caprylic-acid 100g,
  "n__capric_acid_100g" DOUBLE  -- -capric-acid 100g,
  "n__lauric_acid_100g" DOUBLE  -- -lauric-acid 100g,
  "n__myristic_acid_100g" DOUBLE  -- -myristic-acid 100g,
  "n__palmitic_acid_100g" DOUBLE  -- -palmitic-acid 100g,
  "n__stearic_acid_100g" DOUBLE  -- -stearic-acid 100g,
  "n__arachidic_acid_100g" DOUBLE  -- -arachidic-acid 100g,
  "n__behenic_acid_100g" DOUBLE  -- -behenic-acid 100g,
  "n__lignoceric_acid_100g" DOUBLE  -- -lignoceric-acid 100g,
  "n__cerotic_acid_100g" DOUBLE  -- -cerotic-acid 100g,
  "n__montanic_acid_100g" DOUBLE  -- -montanic-acid 100g,
  "n__melissic_acid_100g" DOUBLE  -- -melissic-acid 100g,
  "monounsaturated_fat_100g" DOUBLE,
  "polyunsaturated_fat_100g" DOUBLE,
  "omega_3_fat_100g" DOUBLE,
  "n__alpha_linolenic_acid_100g" DOUBLE  -- -alpha-linolenic-acid 100g,
  "n__eicosapentaenoic_acid_100g" DOUBLE  -- -eicosapentaenoic-acid 100g,
  "n__docosahexaenoic_acid_100g" DOUBLE  -- -docosahexaenoic-acid 100g,
  "omega_6_fat_100g" DOUBLE
);