API Fields

From Open Food Facts wiki
Revision as of 09:22, 24 April 2016 by Aleene (talk | contribs) (formatting)
Jump to navigation Jump to search

Data fields in the API

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

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

The file encoding is Unicode UTF-8. The character that separates fields is <tab> (tabulation).

Generalities

  • fields that end with _t are dates in the UNIX timestamp format (number of seconds since Jan 1st 1970)
  • fields that end with _datetime are dates in the iso8601 format: yyyy-mm-ddThh:mn:ssZ
  • fields that end with _tags are comma separated list of tags (e.g. categories_tags is the set of normalized tags computer from the categories field)
  • fields that end with a language 2 letter code (e.g. fr for French) is the set of tags in that language
  • fields that end with _100g correspond to the amount of a nutriment (in g) for 100 g or 100 ml of product

List of fields

general information

  • code : barcode of the product (can be EAN-13 or internal codes for some food stores), for products without a barcode, Open Food Facts assigns a number starting with the 200 reserved prefix
  • url : url of the product page on Open Food Facts
  • creator : contributor who first added the product
  • created_t : date that the product was added (UNIX timestamp format)
  • created_datetime : date that the product was added (iso8601 format: yyyy-mm-ddThh:mn:ssZ)
  • last_modified_t : date that the product page was last modified
  • last_modified_datetime
  • product_name : name of the product
  • generic_name
  • quantity : quantity and unit

tags

  • packaging : shape, material
  • packaging_tags
  • brands
  • brands_tags
  • categories
  • categories_tags
  • categories_fr
  • origins : origins of ingredients
  • origins_tags
  • manufacturing_places : places where manufactured or transformed
  • manufacturing_places_tags
  • labels
  • labels_tags
  • labels_fr
  • emb_codes
  • emb_codes_tags
  • first_packaging_code_geo : coordinates corresponding to the first packaging code indicated
  • cities
  • cities_tags
  • purchase_places
  • stores
  • countries : list of countries where the product is sold
  • countries_tags
  • countries_fr

ingredients

  • ingredients_text
  • traces
  • traces_tags

misc. data

  • serving_size : serving size in g (or ml)
  • no_nutriments : indicates if the nutrition facts are indicated on the food label
  • additives_n : number of food additives
  • additives
  • additives_tags
  • ingredients_from_palm_oil_n
  • ingredients_from_palm_oil
  • ingredients_from_palm_oil_tags
  • ingredients_that_may_be_from_palm_oil_n
  • ingredients_that_may_be_from_palm_oil
  • ingredients_that_may_be_from_palm_oil_tags
  • nutrition_grade_fr : nutrition grade ('a' to 'e'). see http://fr.openfoodfacts.org/score-nutritionnel-experimental-france
  • main_category
  • main_category_fr
  • image_url
  • image_small_url

nutrition facts

  • energy_100g
  • proteins_100g
  • casein_100g
  • serum-proteins_100g
  • nucleotides_100g
  • carbohydrates_100g
  • sugars_100g
  • sucrose_100g
  • glucose_100g
  • fructose_100g
  • lactose_100g
  • maltose_100g
  • maltodextrins_100g
  • starch_100g
  • polyols_100g
  • fat_100g
  • saturated-fat_100g
  • butyric-acid_100g
  • caproic-acid_100g
  • caprylic-acid_100g
  • capric-acid_100g
  • lauric-acid_100g
  • myristic-acid_100g
  • palmitic-acid_100g
  • stearic-acid_100g
  • arachidic-acid_100g
  • behenic-acid_100g
  • lignoceric-acid_100g
  • cerotic-acid_100g
  • montanic-acid_100g
  • melissic-acid_100g
  • monounsaturated-fat_100g
  • polyunsaturated-fat_100g
  • omega-3-fat_100g
  • alpha-linolenic-acid_100g
  • eicosapentaenoic-acid_100g
  • docosahexaenoic-acid_100g
  • omega-6-fat_100g
  • linoleic-acid_100g
  • arachidonic-acid_100g
  • gamma-linolenic-acid_100g
  • dihomo-gamma-linolenic-acid_100g
  • omega-9-fat_100g
  • oleic-acid_100g
  • elaidic-acid_100g
  • gondoic-acid_100g
  • mead-acid_100g
  • erucic-acid_100g
  • nervonic-acid_100g
  • trans-fat_100g
  • cholesterol_100g
  • fiber_100g
  • sodium_100g
  • alcohol_100g : % vol of alcohol
  • vitamin-a_100g
  • vitamin-d_100g
  • vitamin-e_100g
  • vitamin-k_100g
  • vitamin-c_100g
  • vitamin-b1_100g
  • vitamin-b2_100g
  • vitamin-pp_100g
  • vitamin-b6_100g
  • vitamin-b9_100g
  • vitamin-b12_100g
  • biotin_100g
  • pantothenic-acid_100g
  • silica_100g
  • bicarbonate_100g
  • potassium_100g
  • chloride_100g
  • calcium_100g
  • phosphorus_100g
  • iron_100g
  • magnesium_100g
  • zinc_100g
  • copper_100g
  • manganese_100g
  • fluoride_100g
  • selenium_100g
  • chromium_100g
  • molybdenum_100g
  • iodine_100g
  • caffeine_100g
  • taurine_100g
  • ph_100g : pH (no unit)
  • fruits-vegetables-nuts_100g : % of fruits, vegetables and nuts (excluding potatoes, yams, manioc)
  • carbon-footprint_100g : carbon footprint (indicated on some products)
  • nutrition-score-fr_100g : experimental nutrition score derived from the UK FSA score and adapted for the French market (formula defined by the team of Professor Hercberg)
  • nutrition-score-uk_100g : nutrition score defined by the UK Food Standards Administration (FSA)