retailopenfoodfacts/product-databasefoodnutritioningredientsallergensmultilingualopen-dataodbltabularragcrowdsourced

Open Food Facts Product Database

Free

Open dataset

Sample structure: 78.2 / 100
3 download links issued
Seller: DataBazaar
Sign up to download

Already have an account? Log in

Agent? Connect your account →

Category
Retail
Records
4,549,749 rows
Format
PARQUET
Update Frequency
Not documented
Collection Method
auto_imported_huggingface_federated
PII
No flagged field names; not a privacy audit
File Size
~7179.55 MB
Download links issued
3

Source, license and coverage

Supplier documentation. These claims are separate from the automated sample score. A listing edit date is not a data freshness date.

License
agpl-3.0,odbl
Source / creator
huggingface: openfoodfacts/product-database
Collection method
auto_imported_huggingface_federated
Coverage start
Not documented
Coverage end
Not documented
Data last updated
Not documented
Update schedule
Not documented

Source documentation ↗

Sample structure score: 78.2 / 100

This automated check describes the inspected sample, not factual accuracy, legal rights, representativeness, or the quality of the entire dataset. It is not a customer rating.

Assessed 10 sample records (JSON) on 2026-10-09. All records in the provided sample were checked.

CheckPointsEvidence
Populated cells28.2 / 50514 of 910 top-level cells contain a value. Null, absent and blank values count as missing; zero and false count as populated.
Consistent value types30 / 30514 of 514 populated cells match their column's most common observed type. Types are inferred, not checked against real-world truth.
Consistent record shape20 / 2010 of 10 records have the expected fields. CSV/TSV use the header width; JSON uses the union of observed keys.
Field-level findings and improvements

Check missing cells and mixed types below. Document intentional missing values or mixed types in your field descriptions. Do not fill legitimate unknowns with invented values just to increase this score.

FieldMissing cellsMost common typeOther populated types
additives_n8 / 10number0 / 2
additives_tags0 / 10object0 / 10
allergens_tags0 / 10object0 / 10
brands_tags0 / 10object0 / 10
brands5 / 10string0 / 5
categories8 / 10string0 / 2
categories_tags4 / 10object0 / 6
checkers_tags0 / 10object0 / 10
cities_tags4 / 10object0 / 6
code0 / 10string0 / 10
complete0 / 10number0 / 10
completeness8 / 10number0 / 2
correctors_tags0 / 10object0 / 10
countries_tags0 / 10object0 / 10
created_t0 / 10number0 / 10
creator0 / 10string0 / 10
data_quality_errors_tags9 / 10object0 / 1
data_quality_info_tags9 / 10object0 / 1
data_quality_warnings_tags9 / 10object0 / 1
data_sources_tags9 / 10object0 / 1
editors9 / 10object0 / 1
emb_codes_tags4 / 10object0 / 6
emb_codes10 / 10unknown0 / 0
entry_dates_tags0 / 10object0 / 10
generic_name0 / 10object0 / 10
images0 / 10object0 / 10
informers_tags0 / 10object0 / 10
ingredients_analysis_tags8 / 10object0 / 2
ingredients_from_palm_oil_n8 / 10number0 / 2
ingredients_n8 / 10number0 / 2
ingredients_original_tags4 / 10object0 / 6
ingredients_percent_analysis4 / 10number0 / 6
ingredients_tags0 / 10object0 / 10
ingredients_text0 / 10object0 / 10
ingredients_with_specified_percent_n9 / 10number0 / 1
ingredients_with_unspecified_percent_n9 / 10number0 / 1
ingredients0 / 10string0 / 10
known_ingredients_n8 / 10number0 / 2
labels_tags4 / 10object0 / 6
labels9 / 10string0 / 1
lang0 / 10string0 / 10
languages_tags0 / 10object0 / 10
last_edit_dates_tags0 / 10object0 / 10
last_editor4 / 10string0 / 6
last_image_t1 / 10number0 / 9
last_modified_by4 / 10string0 / 6
last_modified_t0 / 10number0 / 10
last_updated_t0 / 10number0 / 10
link9 / 10string0 / 1
main_countries_tags9 / 10object0 / 1
manufacturing_places_tags4 / 10object0 / 6
manufacturing_places10 / 10unknown0 / 0
max_imgid0 / 10number0 / 10
minerals_tags1 / 10object0 / 9
misc_tags1 / 10object0 / 9
nucleotides_tags1 / 10object0 / 9
nutrient_levels_tags0 / 10object0 / 10
nutrition_data_per0 / 10string0 / 10
obsolete0 / 10boolean0 / 10
origins_tags4 / 10object0 / 6
origins10 / 10unknown0 / 0
owner_fields10 / 10unknown0 / 0
owner10 / 10unknown0 / 0
packagings_complete10 / 10unknown0 / 0
packaging_recycling_tags9 / 10object0 / 1
packaging_shapes_tags9 / 10object0 / 1
packaging_tags4 / 10object0 / 6
packaging_text0 / 10object0 / 10
packaging8 / 10string0 / 2
packagings9 / 10object0 / 1
photographers10 / 10unknown0 / 0
popularity_key9 / 10number0 / 1
popularity_tags9 / 10object0 / 1
product_name0 / 10object0 / 10
product_quantity_unit9 / 10string0 / 1
product_quantity7 / 10number0 / 3
purchase_places_tags4 / 10object0 / 6
quantity5 / 10string0 / 5
rev0 / 10number0 / 10
scans_n9 / 10number0 / 1
serving_quantity2 / 10number0 / 8
serving_size10 / 10unknown0 / 0
states_tags0 / 10object0 / 10
stores_tags4 / 10object0 / 6
stores10 / 10unknown0 / 0
traces_tags0 / 10object0 / 10
unique_scans_n9 / 10number0 / 1
unknown_ingredients_n4 / 10number0 / 6
unknown_nutrients_tags0 / 10object0 / 10
vitamins_tags1 / 10object0 / 9
schema_version0 / 10number0 / 10
How the score is calculated, its limitations, and how to correct an assessment →

About this data

Food products with ingredients, allergens, nutrition facts, and label data contributed by volunteers across 150 countries. Multilingual tabular dataset.

Retrieve with your agent or Python

Create an account and configure DATABAZAAR_API_KEY. This example retrieves free or already purchased data; it never makes a purchase. For a multi-file dataset, choose a file index from the manifest.

Download the Python example
python3 retrieve-dataset.py 75d8e1ff-547e-442e-95f3-d528eeace39b --output dataset.bin
Full supplier documentation
_PII signals: us_phone×61, credit_card_candidate×5 (0.3≤score<0.7) present in the sample. Common in public datasets (papers, logs) but worth knowing before joining with private data._ Original supplier listing: Open Food Facts Product Database 1.7M+ food products with ingredients, allergens, nutrition facts, and label data from 150 countries, contributed by 25k+ volunteers. Multilingual tabular dataset under ODbL/AGPL.

Schema

NameTypeDescription
additives_nINTEGER
additives_tagsVARCHAR[]
allergens_tagsVARCHAR[]
brands_tagsVARCHAR[]
brandsVARCHAR
categoriesVARCHAR
categories_tagsVARCHAR[]
checkers_tagsVARCHAR[]
cities_tagsVARCHAR[]
codeVARCHAR
completeINTEGER
completenessFLOAT
correctors_tagsVARCHAR[]
countries_tagsVARCHAR[]
created_tBIGINT
creatorVARCHAR
data_quality_errors_tagsVARCHAR[]
data_quality_info_tagsVARCHAR[]
data_quality_warnings_tagsVARCHAR[]
data_sources_tagsVARCHAR[]
editorsVARCHAR[]
emb_codes_tagsVARCHAR[]
emb_codesVARCHAR
entry_dates_tagsVARCHAR[]
generic_nameSTRUCT(lang VARCHAR, "text" VARCHAR)[]
imagesSTRUCT("key" VARCHAR, imgid INTEGER, rev INTEGER, sizes STRUCT("100" STRUCT(h INTEGER, w INTEGER), "200" STRUCT(h INTEGER, w INTEGER), "400" STRUCT(h INTEGER, w INTEGER), "full" STRUCT(h INTEGER, w INTEGER)), uploaded_t BIGINT, uploader VARCHAR)[]
informers_tagsVARCHAR[]
ingredients_analysis_tagsVARCHAR[]
ingredients_from_palm_oil_nINTEGER
ingredients_nINTEGER
ingredients_original_tagsVARCHAR[]
ingredients_percent_analysisINTEGER
ingredients_tagsVARCHAR[]
ingredients_textSTRUCT(lang VARCHAR, "text" VARCHAR)[]
ingredients_with_specified_percent_nINTEGER
ingredients_with_unspecified_percent_nINTEGER
ingredientsVARCHAR
known_ingredients_nINTEGER
labels_tagsVARCHAR[]
labelsVARCHAR
langVARCHAR
languages_tagsVARCHAR[]
last_edit_dates_tagsVARCHAR[]
last_editorVARCHAR
last_image_tBIGINT
last_modified_byVARCHAR
last_modified_tBIGINT
last_updated_tBIGINT
linkVARCHAR
main_countries_tagsVARCHAR[]
manufacturing_places_tagsVARCHAR[]
manufacturing_placesVARCHAR
max_imgidINTEGER
minerals_tagsVARCHAR[]
misc_tagsVARCHAR[]
nucleotides_tagsVARCHAR[]
nutrient_levels_tagsVARCHAR[]
nutrition_data_perVARCHAR
obsoleteBOOLEAN
origins_tagsVARCHAR[]
originsVARCHAR
owner_fieldsSTRUCT(field_name VARCHAR, "timestamp" BIGINT)[]
ownerVARCHAR
packagings_completeBOOLEAN
packaging_recycling_tagsVARCHAR[]
packaging_shapes_tagsVARCHAR[]
packaging_tagsVARCHAR[]
packaging_textSTRUCT(lang VARCHAR, "text" VARCHAR)[]
packagingVARCHAR
packagingsSTRUCT(material VARCHAR, number_of_units BIGINT, quantity_per_unit VARCHAR, quantity_per_unit_unit VARCHAR, quantity_per_unit_value VARCHAR, recycling VARCHAR, shape VARCHAR, weight_measured FLOAT)[]
photographersVARCHAR[]
popularity_keyBIGINT
popularity_tagsVARCHAR[]
product_nameSTRUCT(lang VARCHAR, "text" VARCHAR)[]
product_quantity_unitVARCHAR
product_quantityVARCHAR
purchase_places_tagsVARCHAR[]
quantityVARCHAR
revINTEGER
scans_nINTEGER
serving_quantityVARCHAR
serving_sizeVARCHAR
states_tagsVARCHAR[]
stores_tagsVARCHAR[]
storesVARCHAR
traces_tagsVARCHAR[]
unique_scans_nINTEGER
unknown_ingredients_nINTEGER
unknown_nutrients_tagsVARCHAR[]
vitamins_tagsVARCHAR[]
schema_versionINTEGER

Sample Data

Preview a sample of the data before downloading.

Public sample only. Sign in to retrieve the full dataset, including free datasets.

For AI Agents

Via MCP Server
# 1. Add to your agent's MCP config (claude_desktop_config.json or similar):
{
  "mcpServers": {
    "databazaar": { "command": "npx", "args": ["databazaar-mcp"] }
  }
}

# 2. Your agent can then call:
search_datasets({ query: "Open Food Facts Product Databa" })
// Found: 75d8e1ff-547e-442e-95f3-d528eeace39b
get_download_url({ dataset_id: "75d8e1ff-547e-442e-95f3-d528eeace39b" })  // free — sign in with MCP OAuth first
Via REST API
# Free dataset — sign in or use your account API key:
curl https://api.databazaar.io/datasets/75d8e1ff-547e-442e-95f3-d528eeace39b/download-url -H "Authorization: Bearer $DATABAZAAR_API_KEY"