データ

Conditions for reuse

The Open Food Facts database is available under the Open Database License.
The individual contents of the database are available under the Database Contents License.
Products images are available under the Creative Commons Attribution ShareAlike licence. They may contain graphical elements subject to copyright or other rights, that may in some cases be reproduced (quotation rights or fair use).

Please read Terms and conditions of use and re-use before re-using the data.

Tell us about your reuse

We are very interested in learning what the Open Food Facts data is used for. It is not mandatory, but we would very much appreciate it if you tell us about your re-uses so that we can share them with the Open Food Facts community. You can also fill this form to get a chance to get your app featured.

Open Food Facts data exports

Database dumps and exports are generated nightly. データベースは非常に大きいため、エクスポートのフレーバーに応じて、データのさまざまな使用方法 見つけることができます。

Information on the different fields for the MongoDB dump and CSV exports is available at https://world.openfoodfacts.org/data/data-fields.txt

MongoDB dump

Data for all products is available in a MongoDB database dump.

Link

https://static.openfoodfacts.org/data/openfoodfacts-mongodbdump.gz

sha256sum

https://static.openfoodfacts.org/data/gz-sha256sum

md5sum

https://static.openfoodfacts.org/data/gz-md5sum

Delta Export

Daily delta exports are provided for the previous 14 days. The list of currently available delta files can be found at https://static.openfoodfacts.org/data/delta/index.txt.

Each line represents a file that is available at https://static.openfoodfacts.org/data/delta/{filename}.

The filename contains UNIX timestamp of the first and the last change contained in the JSON file, so that the delta files can be imported (after extraction) with mongoimport in alphabetical order.

Please note that due to the nature of mongoexport, the delta files cannot tell you about deleted products. To remove deleted products from your database, you will need to import the full MongoDB dump.

JSONL data export

The whole database is also available in JSONL format (sometimes called LDJSON or NDJSON) where each line is a JSON object. It represents the same data as the MongoDB export. The file is compressed with gzip.

Link

https://static.openfoodfacts.org/data/openfoodfacts-products.jsonl.gz

データベースを活用する適切な方法は、DuckDBを使用することです。 これは、大量のデータを数秒で処理するために設計されたインプロセス分析ツールです。 DuckDBを使用してOpen Food Factsデータベースを探索および処理する方法について説明した ブログ投稿 をお読みください。

Parquet Data Export on Hugging Face

A simplified version of the JSONL dump is also available in the Parquet format. During the conversion, we filtered columns that contains duplicated information, are used for internal debugging, or are simply irrelevant for users.

The Parquet format has proved to be handy:

• Data is organized by column, rather than by row, which saves storage space and speeds up analytics queries, i.e. you can select just the columns you care about, optimizing query performances, even on entry-level computers.
• Highly efficient data compression and decompression, making it good for storing and sharing big datasets of any kind,
• Supports complex data types and advanced nested data structures.

The dataset is available on Hugging Face, a collaborative Machine Learning ecosystem where developers and researchers can share models and datasets.

Link

https://huggingface.co/datasets/openfoodfacts/product-database/resolve/main/food.parquet?download=true

Find more information in the Wiki, including guidelines for data reuse and example queries to get started.

CSV Data Export

Data for all products, or some of the products, can be downloaded in the CSV format (readable with LibreOffice, Excel and many other spreadsheet software) through the advanced search form.

リンク

Food: https://static.openfoodfacts.org/data/en.openfoodfacts.org.products.csv.gz (compressed CSV in GZIP format: ~ 0.9 Gb, uncompressed: ~ 9 Gb)

Cosmetics: https://static.openbeautyfacts.org/data/en.openbeautyfacts.org.products.csv.gz

Pet Food: https://static.openpetfoodfacts.org/data/en.openpetfoodfacts.org.products.csv.gz

All other products: https://static.openproductsfacts.org/data/en.openproductsfacts.org.products.csv.gz

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

RDF Data Export

The database is also available in the RDF format (this is an experiment, not actively maintained anymore). You can read the announcement in French.

Link

https://world.openfoodfacts.org/data/en.openfoodfacts.org.products.rdf.gz

画像データのエクスポート

All images and OCR results can either be downloaded from our server or from AWS (through the AWS Open Data Program). Check out our documentation to learn more about how to download images

ライブ JSON および XML API

A JSON API is also available to read the data for a product. This API is in particular used in the Open Food Facts mobile app.

私たちはAPIの残業を改善しますが、後方互換性を保つように注意しています。 Please get in touch if you use it, so that we can tell you about potential changes.

Discover our API

Contributing to improving our API and OpenAPI documentation

We're eager to finish the documentation of the API, add use-cases, and automate SDK generation. If you are an OpenAPI connoisseur, you are very welcome to help.

You are very welcome to use the API for production cases, as long as 1 API call = 1 real scan by a user. Any attempt to scrape the database using the API will very likely be blocked, as full daily exports are available on this very page.

Also, sending an HTTP header with your API call is a good way we can get in touch, should any issue arise.

XML API (unsupported)

.xml を使用して結果を XML で取得することもできます。

例: https://world.openfoodfacts.org/api/v2/product/737628064502.xml

This API is not actively maintained, and not officially documented.

Wrappers and SDKs

We probably have a wrapper for your favorite programming language. If we do, you can use it and improve it. If we don't, you can help create it.

They will let you consume data, as well as let your users contribute new data

General principles to make your users happy

• 多くの有用な計算値を含む製品に関する情報を検索できます。
• If you can't get the information on a specific product, you can get your user to send photos and data, that will then be processed by Open Food Facts AI and contributors to get the computed result you want to show them.
• You can also implement the complete flow so that they get immediately the result with some effort on their side.

If your users do not expect a result immediately (e.g. Inventory apps)

• 写真を送信する (正面/栄養/材料): ユーザーにとって最も負担の少ないもの
• The Open Food Facts AI - Robotoff - will generate some derived data from the photos
• Over time, other apps, and the Open Food Facts community will fill the data gaps

If your users expect a result immediately (e.g. Nutrition apps)

• 栄養成分表を提出 + カテゴリー > ニュートリスコアを取得
• 原材料を提出します > NOVAグループ(食品の超加工について)、添加物、アレルゲン、正規化された食材、ビーガン、ベジタリアン…
• カテゴリ + ラベル > を送信すると、すぐにエコ スコアが表示されます (環境への影響について)

Android and iPhone mobile app

The code for the Open Food Facts mobile app is available on GitHub (Flutter, Kotlin Android and Swift iOS).

We look to turn the deprecated Kotlin and Swift codebases into Kotlin and Swift SDKs, help welcome :-)

(Android iOS )。 The app allows users to scan the barcode of products, to view the product information, and to take and submit pictures and data for missing products.

You are welcome to reuse the code (it's open source) and help us improve it, for everyone, on all the planet.

SDKs

Filter by name:

Icon	Language / Framework	Resources	Discussion
	Cordova (Old App)	GitHub	N/A
	DART	GitHub pub.dev	N/A
	Elixir	GitHub	Slack Channel
	Go	GitHub	Slack Channel
	Java	GitHub	Slack Channel
	Spring Boot	GitHub	Slack Channel
	Kotlin	GitHub	Slack Channel
	NodeJS	GitHub	Slack Channel
	PHP	GitHub	Slack Channel
	PHP (Laravel)	GitHub	Slack Channel
	Python	GitHub	Slack Channel
	React Native	GitHub	Slack Channel
	Ruby	GitHub	Slack Channel
	赤茶色	GitHub	Slack Channel
	R	GitHub	Slack Channel
	Swift	GitHub	Slack Channel
	.NET/C#	GitHub	Slack Channel

Discussing data, API and exports

You can look at common FAQ questions about the API and Data Exports and common Open Food Facts questions

You can join the Open Food Facts Slack chatroom which is the preferred way to ask questions and discuss the API. Please ask your questions in the #api channel

You can open a thread on our API documentation repository

For any question regarding the data, you can contact us at reuse@openfoodfacts.org