# Open Food Facts derived database (Vufro), export of 2026-11-10

Published by Pick and Pack LLC (Vufro), 30 N Gould St Ste R, Sheridan WY 82801, USA. Contact: admin@vufro.app.

This is the food database Vufro builds from Open Food Facts and shows in its food catalogue.
We publish it here because the Open Database License asks that a derivative database that is
used publicly be offered to everyone under the same licence.

## Licence

This database is made available under the Open Database License v1.0 (ODbL):
https://opendatacommons.org/licenses/odbl/1-0/

Any rights in individual contents of the database are licensed under the Database Contents
License v1.0 (DbCL): https://opendatacommons.org/licenses/dbcl/1-0/

It contains information from Open Food Facts (https://world.openfoodfacts.org/), made available under the ODbL.
Attribution: (c) Open Food Facts contributors, https://world.openfoodfacts.org/

If you use, share or adapt this database, keep this notice with it, and if you publicly use a
database you derive from it, offer that database under the ODbL as well (ODbL sections 4.2 to 4.6).
Product photos are not included: we never copied them. Product and brand names can be trademarks
of their owners.

## Files

- `open-food-facts-derived-2026-11-10.jsonl.gz` (452,726,331 bytes): one JSON object per line, one per product.
  sha256 `912844b4cdf887285c67ed1491353e500390cc406172dc7009795b8584026c58`. The file is made of several gzip members one after
  another, which the gzip format allows: `gunzip`, `zcat`, Python's `gzip` module and Node's
  `zlib` read it as one stream.
- `open-food-facts-derived-2026-11-10.manifest.json`: counts, checksum, the nutrient legend and the source notices, as JSON.
- This README (`open-food-facts-derived-2026-11-10.README.md`).

The newest export is always at https://vufro.app/open-data/open-food-facts-derived-latest.jsonl.gz
(and `-latest.README.md`, `-latest.manifest.json`); this one stays available as
https://vufro.app/open-data/open-food-facts-derived-2026-11-10.jsonl.gz until the export after next. A new export is made
every week.

## What it holds

3,322,027 products: 3,294,501 active and 27,526 withdrawn,
0 of them corrected from a product label, 1 verified by the Vufro Food Classifier,
and 103,785 earlier versions.
The export reads the database in barcode order over a few hours (started 2026-11-10T10:47:36.060Z, finished
2026-11-10T14:48:59.731Z), so a product added or changed while it ran may appear in the next export instead.
The database held 3,322,027 products when the export started and 3,322,027 when it finished.

- Every product Open Food Facts has that Vufro keeps (a name, a valid barcode, energy, and at least two
  of protein, fat and carbohydrate), with its current version.
- Our changes to those products: units converted, total carbohydrate worked out, implausible values left out,
  portions, the NOVA group, food groups and additives we derived, corrections made from product labels
  that Vufro users photographed, and verifications by the Vufro Food Classifier (nutrients the
  product lacked and corrected values, each from the manufacturer's panel, the label or USDA FoodData Central,
  with the composition, flavonoids, gas and smell profile and diet-score values computed from them). All of it
  is under the ODbL.
- Earlier versions of a product, kept because a food diary that logged them keeps their numbers.
- Withdrawn products (no longer in Open Food Facts), kept for the same reason.

Not in it, because none of it comes from Open Food Facts: foods from USDA FoodData Central, the NIH Dietary
Supplement Label Database and national food tables (listed on the data sources page with their own licences),
foods Vufro users created that are not Open Food Facts products, and anyone's food diary or account.

## Fields

- `code`: the barcode as a GTIN-14. `status`: `active`, or `withdrawn` (no longer in Open Food Facts).
- `name`, `brand`, `ingredients` (as printed), `countries` (ISO 3166-1 alpha-2), `market` (first country, or WORLD),
  `category`, `quality` (`community`, or `suspect` when the panel does not add up), `inStoreCode` (a shop's own code,
  never matched from a scan).
- `per`: `100g` or `100ml`. `nutrients`: the amount per 100 g or 100 ml keyed by nutrient id (legend in the manifest);
  an object with a `flag` marks an estimated value. Carbohydrate id 205 is TOTAL carbohydrate (fibre included);
  -1205 is available carbohydrate as EU labels print it. Energy 208 is kcal.
- `serving`: the label's serving, when it gives one. `measures`: the portions we offer for logging.
- `offLastModified`: when the product was last edited in Open Food Facts. `scans`: Open Food Facts' count of
  unique scans (`unique_scans_n`), which we use to rank search results.
- `version`: our version number of the product; `changeKind`: why the current version exists (`create`,
  `source_update`, `correction`, `enrichment` for a verification, ...). `release` and `pipelineVersion` identify the data and code that made it.
- `verified` (only on a verified product): `version` (the verified version), `at`, and `profile`: the sources
  (`srcs`: `fdc:<FoodData Central id>`, `mfr:<manufacturer page>`, `label:<label>`), the filled (`fill`) and corrected
  (`corrections`: new value, source, old value) nutrients, the composition (`comp`: ingredient and share), flavonoids
  (mg per 100 g), the refined share of the carbohydrate, fat and fibre types, diet-score values (`score`), the gas
  and smell profile with the evidence for each FODMAP amount (`digestion`), and the classifier's judgments.
- `derived`: values we computed (NOVA group and where it came from, food groups, additives).
- `panel`: the stored nutrient cells (`n`: id -> [value, index into `srcs`, flag]) with their sources and any
  `left` (values the source gave that we left out as implausible). `dqs`: the stored diet-quality inputs.
- `history` (only on a product that changed): its earlier versions, oldest first, with the same fields plus `createdAt`.
