Understanding the fields in the raw database

Hi all,

I’m brand new to the project, so apologies if this information is somewhere obvious, but I’m trying to understand the description of all the fields in the raw database. Specifically, I’m using the JSONL format of the database. I did read the page here: Reusing Open Food Facts Data - Open Food Facts wiki and specifically there is a lot of good information here: https://world.openfoodfacts.org/data/data-fields.txt, however it doesn’t seem to cover the majority of the tags in the database.

Some examples:

  1. I’m trying to figure out why the ingredients in this product (https://world.openfoodfacts.org/api/v0/product/0010700088130.json) have the word parentheses in them? If I look at the ingredients_text_debug it looks more or less like a normal ingredient list, but it seems that in ingredients_text some very weird things happened, i.e. “[” got transformed to the word parentheses, “flour” got transformed to the word “flower”. Is ingredients_text_debug like the raw OCR output of an image and ingredients_text some sort of machine learning post-process output?
  2. What is the relationship between data_quality_tags and states_tags? I see they appear to have a lot of overlap, but slight differences. For example data_quality_tags seems to have language specific ingredient completion tags like “en:ingredients-en-completed” while states_tags seems to be more generic like “en:ingredients-completed” only.
  3. What is the difference between _id, id, and code?

Thanks for any help!

1 Like