Open Prices

# Open Prices ## What is Open Prices? [Open Prices](https://prices.openfoodfacts.org/) is a project to collect and share prices of products around the world. It's a publicly available dataset that can be used for research, analysis, and more. Open Prices is developed and maintained by Open Food Facts. There are currently few companies that own large databases of product prices at the barcode level. These prices are not freely available, but sold at a high price to private actors, researchers and other organizations that can afford them. Open Prices aims to democratize access to price data by collecting and sharing product prices under an open license. The data is available under the [Open Database License (ODbL)](https://opendatacommons.org/licenses/odbl/1.0/), which means that it can be used for any purpose, as long as you credit Open Prices and any share modifications you make to the dataset. Images submitted as proof are licensed under the [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). ## Dataset description This dataset contains in Parquet format all price information contained in the Open Prices database. The dataset is updated daily. Here is a description of the most important columns: - `id`: The ID of the price in DB - `product_code`: The barcode of the product, null if the product is a "raw" product (fruit, vegetable, etc.) - `category_tag`: The category of the product, only present for "raw" products. We follow Open Food Facts category taxonomy for category IDs. - `labels_tags`: The labels of the product, only present for "raw" products. We follow Open Food Facts label taxonomy for label IDs. - `origins_tags`: The origins of the product, only present for "raw" products. We follow Open Food Facts origin taxonomy for origin IDs. - `price`: The price of the product, with the discount if any. - `price_is_discounted`: Whether the price is discounted or not. - `price_without_discount`: The price of the product without discount, null if the price is not discounted. - `price_per`: The unit for which the price is given (e.g. "KILOGRAM", "UNIT") - "currency": The currency of the price - `location_osm_id`: The OpenStreetMap ID of the location where the price was recorded. We use OpenStreetMap to identify uniquely the store where the price was recorded. - `location_osm_type`: The type of the OpenStreetMap location (e.g. "NODE", "WAY") - `location_id`: The ID of the location in the Open Prices database - `date`: The date when the price was recorded - `proof_id`: The ID of the proof of the price in the Open Prices DB - `owner`: a hash of the owner of the price, for privacy. - `created`: The date when the price was created in the Open Prices DB - `updated`: The date when the price was last updated in the Open Prices DB - `proof_file_path`: The path to the proof file in the Open Prices DB - `proof_type`: The type of the proof. Possible values are `RECEIPT`, `PRICE_TAG`, `GDPR_REQUEST`, `SHOP_IMPORT` - `proof_date`: The date of the proof - `proof_currency`: The currency of the proof, should be the same as the price currency - `proof_created`: The datetime when the proof was created in the Open Prices DB - `proof_updated`: The datetime when the proof was last updated in the Open Prices DB - `location_osm_display_name`: The display name of the OpenStreetMap location - `location_osm_address_city`: The city of the OpenStreetMap location - `location_osm_address_postcode`: The postcode of the OpenStreetMap location ## How can I download images? All images can be accessed under the `https://prices.openfoodfacts.org/img/` URL base. You just have to concatenate the `proof_file_path` column to this base URL to get the full URL of the image (ex: https://prices.openfoodfacts.org/img/0010/lqGHf3ZcVR.webp). ## Can I contribute to Open Prices? Of course! You can contribute by adding prices, trough the [Open Prices website](https://prices.openfoodfacts.org/) or through Open Food Facts mobile app. To participate in the technical development, you can check the [Open Prices GitHub repository](https://github.com/openfoodfacts/open-prices).# 开放价格（Open Prices） ## 什么是开放价格项目？ [开放价格（Open Prices）](https://prices.openfoodfacts.org/) 是一个面向全球收集并共享商品价格的项目。它是一份可公开获取的数据集，可用于研究、分析等多种场景。开放价格项目由开放食品事实（Open Food Facts）开发并维护。 当前全球范围内，掌握条形码级商品价格大型数据库的企业屈指可数。此类价格数据并未对外开放，而是以高昂的价格向具备支付能力的私人机构、研究人员及其他组织出售。 开放价格项目旨在通过开放许可协议收集并共享商品价格数据，推动价格数据获取的民主化。该数据集采用[开放数据库许可协议（Open Database License, ODbL）](https://opendatacommons.org/licenses/odbl/1.0/)进行授权，这意味着用户可将其用于任何用途，但需注明对开放价格项目的引用，并共享对数据集所做的任何修改。作为价格证明提交的图片则采用[知识共享署名-相同方式共享4.0国际许可协议（Creative Commons Attribution-ShareAlike 4.0 International）](https://creativecommons.org/licenses/by-sa/4.0/)进行授权。 ## 数据集说明 本数据集以Parquet格式存储开放价格数据库中的全部价格信息，每日更新。 以下为各核心字段的详细说明： - `id`：数据库中价格条目的唯一标识符 - `product_code`：商品的条形码，若商品为"原生态"商品（如水果、蔬菜等）则该字段为空 - `category_tag`：商品的分类标签，仅针对原生态商品存在。分类ID遵循开放食品事实的分类体系 - `labels_tags`：商品的标签信息，仅针对原生态商品存在。标签ID遵循开放食品事实的标签体系 - `origins_tags`：商品的原产地信息，仅针对原生态商品存在。原产地ID遵循开放食品事实的原产地体系 - `price`：商品的售价，包含折扣后的价格（若有） - `price_is_discounted`：标识该价格是否已享受折扣 - `price_without_discount`：商品的原价，若未享受折扣则该字段为空 - `price_per`：价格对应的计价单位（例如"KILOGRAM"即千克，"UNIT"即单件） - `currency`：价格使用的货币类型 - `location_osm_id`：价格记录地点的开放街道地图（OpenStreetMap，OSM）ID。我们通过开放街道地图唯一标识采集价格的商店 - `location_osm_type`：开放街道地图地点的类型（例如"NODE"即节点，"WAY"即道路/区域） - `location_id`：开放价格数据库中地点的标识符 - `date`：价格记录的日期 - `proof_id`：开放价格数据库中价格证明的标识符 - `owner`：为保护隐私，对价格数据所有者进行哈希处理后的字符串 - `created`：价格条目在开放价格数据库中的创建日期 - `updated`：价格条目在开放价格数据库中的最后更新日期 - `proof_file_path`：开放价格数据库中证明文件的存储路径 - `proof_type`：证明文件的类型，可选值包括`RECEIPT`（购物收据）、`PRICE_TAG`（价格标签）、`GDPR_REQUEST`（通用数据保护条例请求文件）、`SHOP_IMPORT`（商店导入文件） - `proof_date`：证明文件对应的日期 - `proof_currency`：证明文件中使用的货币，应与价格货币类型一致 - `proof_created`：证明文件在开放价格数据库中的创建时间 - `proof_updated`：证明文件在开放价格数据库中的最后更新时间 - `location_osm_display_name`：开放街道地图地点的展示名称 - `location_osm_address_city`：开放街道地图地点所属城市 - `location_osm_address_postcode`：开放街道地图地点对应的邮政编码 ## 如何下载图片？ 所有图片均可通过`https://prices.openfoodfacts.org/img/`基础URL访问，只需将`proof_file_path`字段拼接至该基础URL后，即可获取图片的完整访问地址（示例：https://prices.openfoodfacts.org/img/0010/lqGHf3ZcVR.webp）。 ## 我可以为开放价格项目贡献内容吗？ 当然可以！你可以通过[开放价格项目官网](https://prices.openfoodfacts.org/)或开放食品事实移动端应用提交商品价格数据。若想参与技术开发工作，可访问[开放价格项目GitHub仓库](https://github.com/openfoodfacts/open-prices)查看相关信息。