Difference between revisions of "Data fields"

From Open Food Facts wiki
Jump to navigation Jump to search
(common_name)
(→‎Serving size: serving_quantity)
(12 intermediate revisions by 2 users not shown)
Line 9: Line 9:
  
 
=== Fields completed by users ===
 
=== Fields completed by users ===
 +
All these fields can entered or modified by hand by the users.
 
[to be completed]
 
[to be completed]
  
 
==== Product name ====
 
==== Product name ====
 
The product name is the main name printed on the packaging. It can be a registered trademark such as Nutella. This data is important and useful as it's one of the most used data.
 
The product name is the main name printed on the packaging. It can be a registered trademark such as Nutella. This data is important and useful as it's one of the most used data.
 +
 +
If it's not a part of the name, it shouldn't contain the number of portions or a quantity: bad examples are "1 Onglet", "10 Burgers", "1L Sirop cerise"; "100% Cacao", "1848 Lait noisette" (name of a product); it shouldn't contain registered trademark symbols ®, HTML code such as <code>&amp;quot;</code>; it shouldn't be in capital letters except if they are used on the product; it shouldn't contain brands except if it's included in the name ("Kinder Bueno" is good while "Kronembourg 1664", "Stella" or "Vodka Smirnoff" are not); it shouldn't contain price.
  
 
At the beginning of 2020, more than 95% of Open Food Facts products have a product name:
 
At the beginning of 2020, more than 95% of Open Food Facts products have a product name:
Line 26: Line 29:
 
* <code>Petit déjeuner Nesquick</code> => you don't have to explain, just put the name from the packaging
 
* <code>Petit déjeuner Nesquick</code> => you don't have to explain, just put the name from the packaging
 
* <code>Nutella by Ferrero</code> => you shouldn't fill the brand here, there's a field for that :)
 
* <code>Nutella by Ferrero</code> => you shouldn't fill the brand here, there's a field for that :)
 +
 +
In the database, the technical name for this field is <code>product_name</code>.
  
  
 
==== Common name ====
 
==== Common name ====
The common name defines the product. It is the name used when you don't want or can't use the product name. This is the place where you say "Cocoa and hazelnuts spreads" instead of "Nutella". This name is very useful for our AI (artificial intelligence): it helps to guess the category of the product.
+
The common name defines the product. It is the name used when you don't want or can't use the product name. This is the place where you say <code>Cocoa and hazelnuts spreads</code> instead of <code>Nutella</code>. This name is very useful for our AI (artificial intelligence): it helps to guess the category of the product.
  
 
The common name might be equivalent to product category but sometimes not [examples].
 
The common name might be equivalent to product category but sometimes not [examples].
 +
 +
In the database, the technical name for this field is <code>generic_name</code>.
 +
 +
==== Quantity ====
 +
This is the quantity of the product, with the corresponding number of portions or unit. The best way to fill it is to enter the value as indicated on the product. Don't forget the units! If we can deduce the quantity in grams it can be used to calculate some things such as the carbon impact.
 +
 +
Examples:
 +
* <code>230g</code>
 +
* <code>230 g</code>
 +
* <code>6</code> (for 6 eggs)
 +
* <code>3 x 150g</code> (for a product with 3 boxes, each of 150g)
 +
 +
A complete wiki page is dedicated to [[products quantities]].
 +
 +
In the database, the technical name for this field is <code>quantity</code>.
 +
 +
See [https://world.openfoodfacts.org/data-quality/quantity-not-recognized quantities that are not recognized].
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+quantity+label%3Aquantity issues related to <code>quantity</code>].
 +
 +
==== Packaging ====
 +
This is the packaging of the product. Multiple values are allowed. There is no taxonomy for this field, so you can enter anything you find relevant including:
 +
* the substance of the packaging: glass, metal, plastic, etc.
 +
* the shape: bottle, can, etc.
 +
 +
You can write it in your own language. Don't hesitate to add as much data as you find relevant.
 +
 +
Two draft taxonomies has been proposed, don't hesitate to comment or help:
 +
* a [[Global_packaging_taxonomy|global taxonomy]]
 +
* and a [[Global_packaging_taxonomy_logos|packaging logos taxonomy]]
 +
 +
In the database, there's two fields related to packaging:
 +
* <code>packaging</code>: the list of values entered in the packaging field; e.g.: <code>Bottle,Glass</code>
 +
* <code>packaging_tags</code>: an array of different packaging tags
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+packaging+label%3Apackaging issues related to <code>packaging</code>].
 +
 +
==== Brands ====
 +
This is the brands of the product. The main brand, generally clearly displayed on the front pack, should be entered first. A product can have other brands:
 +
* when a product is a brand sold by a big company: <code>Actimel</code> is sold by <code>Danone</code>, see https://world.openfoodfacts.org/product/4009700036810/actimel-granatapfel
 +
* when a product is sold with its brand translated in two languages: <code>Nature Valley</code> is sometimes written <code>Val Nature</code>; see  https://world.openfoodfacts.org/product/0065633280267/barre-granola-erable-et-cassonade-nature-valley
 +
 +
There's no taxonomy for brands for the moment, so just do your best and don't waste too much time to enter brands.
 +
 +
A complete wiki page is dedicated to [[brands]].
 +
 +
In the database, this field is called <code>brands</code>.
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+ingredients+label%3Abrands issues related to <code>brands</code>].
 +
 +
==== Ingredients ====
 +
This field lists the [[ingredients]] of the product. This field is '''one of the most important''' as it is used for:
 +
* Nova calculation
 +
* Nutri-Score calculation: it is used to calculate the proportion of fruit and nuts
 +
* evaluation of some food preferences such as vegetarians, vegans, etc.
 +
* automatic identification of allergens (both substances and traces, see below)
 +
* etc.
 +
Thanks to automatic Optical Characters Recognition (OCR), this field can be filled by softwares. But OCR is not always good, and you should always verify the result.
 +
 +
Ingredients analysis also produce an array of all ingredients which allows translation in other languages. To allow analysis and translation, Open Food Facts community [https://github.com/openfoodfacts/openfoodfacts-server/blob/master/taxonomies/ingredients.txt has build a taxonomy]. You can contribute to it.
 +
 +
In the database, this field is called <code>ingredients_[country code]</code>.
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+ingredients+label%3Aingredients issues related to <code>ingredients</code>].
 +
 +
 +
==== Substances or products causing allergies or intolerances ====
 +
The substances are ingredients that are actually in the product, which could cause common allergies. This field can be filled by hand, but is also completed by automatic ingredients analysis.
 +
 +
Examples:
 +
* <code>Milk</code>
 +
* <code>Gluten</code>
 +
* <code>Nuts</code>
 +
 +
In the database, this field is an array of tags called <code>allergens_tags</code>.
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+traces+label%3Aallergens issues related to <code>allergens_tags</code>].
 +
 +
 +
==== Traces ====
 +
The traces are ingredients which are not used for the product itself but lay in the factory or the production process: the product might contains traces of these ingredients. Traces are really important if you are allergic.
 +
This field can be filled by hand, but is also completed by automatic ingredients analysis.
 +
 +
Examples:
 +
* <code>Milk</code>
 +
* <code>Gluten</code>
 +
* <code>Nuts</code>
 +
 +
In the database, the technical name for this field is <code>traces</code>.
 +
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+traces+label%3Atraces issues related to <code>traces</code>].
  
  
Line 60: Line 156:
 
* <code>1L</code>
 
* <code>1L</code>
  
Possible (while not recommanded):
+
Possible (while not recommended):
 
* <code>cookie 25g</code>
 
* <code>cookie 25g</code>
 
* <code>One Slice (50g)</code>
 
* <code>One Slice (50g)</code>
Line 70: Line 166:
 
* <code>30</code> => there is no unit
 
* <code>30</code> => there is no unit
  
In the database and in Product Opener software, the technical name for this field is <code>serving_size</code>.
+
In the database and in Product Opener software, the technical name for this field is <code>serving_size</code>. Based on <code>serving_size</code>, Open Food Facts computes a <code>serving_quantity</code> float number for 100g or 100ml. The <code>serving_quantity</code> can be found in the API or the data exports.
 +
 
 +
See [https://github.com/openfoodfacts/openfoodfacts-server/issues?q=is%3Aissue+is%3Aopen+serving+label%3Aportions issues related to <code>serving_size</code>].

Revision as of 14:09, 28 May 2020

Data fields

A "data field" is a structured information that has at least a specific usage. For example, the "product name" field allows us to easily recognize the main name printed on the packaging.

Open Food Facts manages different kinds of data fields:

  1. fields that can be completed by users, such as the name of the product, the brand, etc.
  2. fields that are always computed by machines such as the name of the contributor or the date of the contribution
  3. fields that are sometimes computed based on other fields, such as the Nutri-Score, the Nova score, etc.

Fields completed by users

All these fields can entered or modified by hand by the users. [to be completed]

Product name

The product name is the main name printed on the packaging. It can be a registered trademark such as Nutella. This data is important and useful as it's one of the most used data.

If it's not a part of the name, it shouldn't contain the number of portions or a quantity: bad examples are "1 Onglet", "10 Burgers", "1L Sirop cerise"; "100% Cacao", "1848 Lait noisette" (name of a product); it shouldn't contain registered trademark symbols ®, HTML code such as &quot;; it shouldn't be in capital letters except if they are used on the product; it shouldn't contain brands except if it's included in the name ("Kinder Bueno" is good while "Kronembourg 1664", "Stella" or "Vodka Smirnoff" are not); it shouldn't contain price.

At the beginning of 2020, more than 95% of Open Food Facts products have a product name:

The product name shouldn't include any other information such as the brand of the product, the weight, etc.

Good examples:

Bad examples:

  • Petit déjeuner Nesquick => you don't have to explain, just put the name from the packaging
  • Nutella by Ferrero => you shouldn't fill the brand here, there's a field for that :)

In the database, the technical name for this field is product_name.


Common name

The common name defines the product. It is the name used when you don't want or can't use the product name. This is the place where you say Cocoa and hazelnuts spreads instead of Nutella. This name is very useful for our AI (artificial intelligence): it helps to guess the category of the product.

The common name might be equivalent to product category but sometimes not [examples].

In the database, the technical name for this field is generic_name.

Quantity

This is the quantity of the product, with the corresponding number of portions or unit. The best way to fill it is to enter the value as indicated on the product. Don't forget the units! If we can deduce the quantity in grams it can be used to calculate some things such as the carbon impact.

Examples:

  • 230g
  • 230 g
  • 6 (for 6 eggs)
  • 3 x 150g (for a product with 3 boxes, each of 150g)

A complete wiki page is dedicated to products quantities.

In the database, the technical name for this field is quantity.

See quantities that are not recognized.

See issues related to quantity.

Packaging

This is the packaging of the product. Multiple values are allowed. There is no taxonomy for this field, so you can enter anything you find relevant including:

  • the substance of the packaging: glass, metal, plastic, etc.
  • the shape: bottle, can, etc.

You can write it in your own language. Don't hesitate to add as much data as you find relevant.

Two draft taxonomies has been proposed, don't hesitate to comment or help:

In the database, there's two fields related to packaging:

  • packaging: the list of values entered in the packaging field; e.g.: Bottle,Glass
  • packaging_tags: an array of different packaging tags

See issues related to packaging.

Brands

This is the brands of the product. The main brand, generally clearly displayed on the front pack, should be entered first. A product can have other brands:

There's no taxonomy for brands for the moment, so just do your best and don't waste too much time to enter brands.

A complete wiki page is dedicated to brands.

In the database, this field is called brands.

See issues related to brands.

Ingredients

This field lists the ingredients of the product. This field is one of the most important as it is used for:

  • Nova calculation
  • Nutri-Score calculation: it is used to calculate the proportion of fruit and nuts
  • evaluation of some food preferences such as vegetarians, vegans, etc.
  • automatic identification of allergens (both substances and traces, see below)
  • etc.

Thanks to automatic Optical Characters Recognition (OCR), this field can be filled by softwares. But OCR is not always good, and you should always verify the result.

Ingredients analysis also produce an array of all ingredients which allows translation in other languages. To allow analysis and translation, Open Food Facts community has build a taxonomy. You can contribute to it.

In the database, this field is called ingredients_[country code].

See issues related to ingredients.


Substances or products causing allergies or intolerances

The substances are ingredients that are actually in the product, which could cause common allergies. This field can be filled by hand, but is also completed by automatic ingredients analysis.

Examples:

  • Milk
  • Gluten
  • Nuts

In the database, this field is an array of tags called allergens_tags.

See issues related to allergens_tags.


Traces

The traces are ingredients which are not used for the product itself but lay in the factory or the production process: the product might contains traces of these ingredients. Traces are really important if you are allergic. This field can be filled by hand, but is also completed by automatic ingredients analysis.

Examples:

  • Milk
  • Gluten
  • Nuts

In the database, the technical name for this field is traces.

See issues related to traces.


Best before date (expiration date)

The expiration date is a way to track product changes over time and to identify the most recent version. It's a data for manual usages. At this moment (2020-03), Open Food Facts apps and website don't make any usage of this field. An issue is open to throw off very old products in averages, it could be useful for it.

Be aware that, for the moment, this field is NOT normalized, so it probably contains dates in various formats that can be ambiguous (31/12/2019, 12/31/2019, 13 mai 2018, etc.).

It is possible to see:

In the database and in Product Opener software, the technical name for this field is expiration_date.


Serving size

Serving size has a specific goal: to let Open Food Facts app make a proportional calculation of each nutrient per serving size. If a candy's weight is 5 g, it can be chosen as the serving size: if these candies has 66 g of sugar per 100 g, it has about 3 g per candy. Allowed units are: kg, g, mg, µg, oz, l, dl, cl, ml, fl.oz, fl oz, г, мг, кг, л, дл, кл, мл, 毫克, 公斤, 毫升, 公升, 吨.

grammes, liter, etc., are NOT recognized.

Decimals can be written with a comma (,) or a point (.).

Good:

  • 60 g (preferred, for readability reasons)
  • 30g
  • 35G
  • 90 ml
  • 1L

Possible (while not recommended):

  • cookie 25g
  • One Slice (50g)
  • 97 g (0.5 cup)

Bad:

  • 30 gr => gr is not a correct unit
  • 9 candies and 2 biscuits => it's not possible to calculate a ratio because we don't know the weight of this portion
  • 30 => there is no unit

In the database and in Product Opener software, the technical name for this field is serving_size. Based on serving_size, Open Food Facts computes a serving_quantity float number for 100g or 100ml. The serving_quantity can be found in the API or the data exports.

See issues related to serving_size.