Dataset: Open Food Facts April 2023

About this Dataset

Open Food Facts April 2023

Open Food Facts is a free, online and crowdsourced database of food products from around the world. This dataset includes the raw data downloaded on April 1, 2023 and a cleaned version of the data that contains a subset of the fields.

Tables

En Openfoodfacts Org Products

@kaggle.ndalziel_open_food_facts_april_2023.en_openfoodfacts_org_products

829.81 MB
2826354 rows
201 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,
  "last_modified_by" VARCHAR,
  "product_name" VARCHAR,
  "abbreviated_product_name" VARCHAR,
  "generic_name" VARCHAR,
  "quantity" VARCHAR,
  "packaging" VARCHAR,
  "packaging_tags" VARCHAR,
  "packaging_en" 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,
  "ingredients_tags" VARCHAR,
  "ingredients_analysis_tags" VARCHAR,
  "allergens" VARCHAR,
  "allergens_en" VARCHAR,
  "traces" VARCHAR,
  "traces_tags" VARCHAR,
  "traces_en" VARCHAR,
  "serving_size" VARCHAR,
  "serving_quantity" DOUBLE,
  "no_nutrition_data" VARCHAR,
  "additives_n" DOUBLE,
  "additives" VARCHAR,
  "additives_tags" VARCHAR,
  "additives_en" VARCHAR,
  "nutriscore_score" DOUBLE,
  "nutriscore_grade" VARCHAR,
  "nova_group" DOUBLE,
  "pnns_groups_1" VARCHAR,
  "pnns_groups_2" VARCHAR,
  "food_groups" VARCHAR,
  "food_groups_tags" VARCHAR,
  "food_groups_en" VARCHAR,
  "states" VARCHAR,
  "states_tags" VARCHAR,
  "states_en" VARCHAR,
  "brand_owner" VARCHAR,
  "ecoscore_score" DOUBLE,
  "ecoscore_grade" VARCHAR,
  "nutrient_levels_tags" VARCHAR,
  "product_quantity" DOUBLE,
  "owner" VARCHAR,
  "data_quality_errors_tags" VARCHAR,
  "unique_scans_n" DOUBLE,
  "popularity_tags" VARCHAR,
  "completeness" DOUBLE,
  "last_image_t" DOUBLE,
  "last_image_datetime" TIMESTAMP,
  "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,
  "butyric_acid_100g" DOUBLE,
  "caproic_acid_100g" DOUBLE,
  "caprylic_acid_100g" DOUBLE,
  "capric_acid_100g" DOUBLE,
  "lauric_acid_100g" DOUBLE,
  "myristic_acid_100g" DOUBLE,
  "palmitic_acid_100g" DOUBLE,
  "stearic_acid_100g" DOUBLE,
  "arachidic_acid_100g" DOUBLE
);