Difference between revisions of "Useful queries"
Jump to navigation
Jump to search
(→Low-hanging fruits: Add quries for dm products that lack German information (some have French as the main language, even though they are primarily in German)) |
|||
(17 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
This is a list of useful searches, for future reference. | This is a list of useful searches, for future reference. | ||
− | |||
− | |||
==General== | ==General== | ||
*Most scanned products / produits les plus scannés | *Most scanned products / produits les plus scannés | ||
− | ** | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1 |
+ | *Products containing B12 Vitamin | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&nutriment_0=vitamin-b12&nutriment_compare_0=lt&nutriment_value_0=0.00001 | ||
+ | = Thematic lists = | ||
== Cheeses == | == Cheeses == | ||
* A beautiful cheese line (Tacite) | * A beautiful cheese line (Tacite) | ||
− | ** | + | **https://world-fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Fromages&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=fat&graph=1 |
* Camemberts on a map (Vince) | * Camemberts on a map (Vince) | ||
− | ** | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=camembert%20au%20lait%20cru&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&generate_map=1 |
+ | |||
== Sodas == | == Sodas == | ||
* Cola soda graph with sugars and additives | * Cola soda graph with sugars and additives | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=sodas-au-cola&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=additives_n&series_with_sweeteners=on&graph=1 |
* Another way to show sugars vs additives (bar graph) (stephane) | * Another way to show sugars vs additives (bar graph) (stephane) | ||
− | ** | + | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=sodas&sort_by=product_name&page_size=20&axis_x=sugars&axis_y=products_n&graph_title=Sucre%20dans%20les%20sodas&series_organic=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
==Nutella== | ==Nutella== | ||
− | * Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella | + | * Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella https://goo.gl/RAcG9A |
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=Complet&tagtype_1=categories&tag_contains_1=contains&tag_1=pates-a-tartiner-aux-noisettes-et-au-cacao&ingredients_from_palm_oil=without&ingredients_that_may_be_from_palm_oil=without&ingredients_from_or_that_may_be_from_palm_oil=without&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
+ | |||
== Yogurts == | == Yogurts == | ||
* Yaourt (sucres et lipides) | * Yaourt (sucres et lipides) | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=yaourt&sort_by=unique_scans_n&page_size=20&axis_x=fat&axis_y=sugars&series_with_sweeteners=on&graph=1 |
*Teneur en fruit sur les yaourts aux fruits (Tacite) | *Teneur en fruit sur les yaourts aux fruits (Tacite) | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Yaourts&sort_by=unique_scans_n&page_size=20&axis_x=fruits-vegetables-nuts&axis_y=products_n&graph=1 |
*globalement moins les yaourts sont gras plus il y a d'additifs (stephane) | *globalement moins les yaourts sont gras plus il y a d'additifs (stephane) | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=yaourts&sort_by=unique_scans_n&page_size=20&axis_x=fat&axis_y=additives_n&series_with_sweeteners=on&graph=1 |
* Fat and sugar within yogurts (with nice additions) (stephane) | * Fat and sugar within yogurts (with nice additions) (stephane) | ||
− | ** | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=yogurt&sort_by=product_name&page_size=20&axis_x=fat&axis_y=sugars&graph_title=Fat%20and%20sugar%20in%20yogurts&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
== Produits allégés == | == Produits allégés == | ||
*Bon d'après nos stats, les jambons -25% de sel ont -23% de sel. (stephane) :-) | *Bon d'après nos stats, les jambons -25% de sel ont -23% de sel. (stephane) :-) | ||
− | ** Moins 25% : | + | ** Moins 25% : https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=contains&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1 |
− | ** Normal : | + | ** Normal : https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=does_not_contain&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1 |
== Breakfast Cereals - Les Céréales du Petit Déjeuner == | == Breakfast Cereals - Les Céréales du Petit Déjeuner == | ||
* Sugars & Fat | * Sugars & Fat | ||
− | ** | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=breakfast%20cereal&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&graph=1 |
+ | * Sugars, Fat, Nutrition grades | ||
+ | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=c%C3%A9r%C3%A9ales%20pour%20petit%20dejeuner&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 | ||
== Nutrition grades == | == Nutrition grades == | ||
* Nutrition grades of the DB | * Nutrition grades of the DB | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&graph_title=Score%20nutritionnel%20des%20produits%20de%20la%20base%20Open%20Food%20Facts&generate_graph_scatter_plot=1 |
* Nutrition grades with Organic status | * Nutrition grades with Organic status | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
*Nutrition grades for breakfast cereals (thr4nduil) | *Nutrition grades for breakfast cereals (thr4nduil) | ||
− | ** | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Breakfast%20cereals&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 |
* Nutrition grades for prepared food | * Nutrition grades for prepared food | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=plats%20pr%C3%A9par%C3%A9s&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Organic == | == Organic == | ||
* Organic foodies like beer but not too much (Tacite, BS causation by Teolemon) | * Organic foodies like beer but not too much (Tacite, BS causation by Teolemon) | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Bi%C3%A8res&sort_by=unique_scans_n&page_size=20&axis_x=alcohol&axis_y=products_n&series_organic=on&series_fairtrade=on&graph=1 |
==Sugar== | ==Sugar== | ||
* Products with sugar /produits avec du sucre (stephane) | * Products with sugar /produits avec du sucre (stephane) | ||
− | ** | + | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=contains&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
* Products without sugar /produits sans sucre (stephane) | * Products without sugar /produits sans sucre (stephane) | ||
− | ** | + | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=does_not_contain&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
== Christmas puddings == | == Christmas puddings == | ||
* Additives in Xmas puddings | * Additives in Xmas puddings | ||
− | ** | + | **https://uk.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=christmas%20puddings&sort_by=unique_scans_n&page_size=20&axis_x=additives_n&axis_y=products_n&graph=1 |
+ | * Organic puddings vs Regular Puddings | ||
+ | **https://uk.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=christmas%20pudding&sort_by=unique_scans_n&page_size=20&axis_x=additives_n&axis_y=products_n&graph_title=Additives%20in%20Christmas%20Pudding&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&graph=1 | ||
+ | |||
+ | == Meat == | ||
+ | * glucid/protein ratio in meat (vince) | ||
+ | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=viandes%20surgel%C3%A9es&sort_by=unique_scans_n&page_size=20&axis_x=proteins&axis_y=carbohydrates&graph=1 | ||
+ | * Stephane questions Tacite's choice of meat :-D "@tacite : tes "new burgers" sont les moins riches en protéines du lot" | ||
+ | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=preparations-de-viande-bovine-hachee&sort_by=unique_scans_n&page_size=20&axis_x=proteins&axis_y=fat&graph=1 | ||
+ | == Beers == | ||
+ | * How much alcohol do Belgian beers contain ? | ||
+ | ** https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=beer&tagtype_1=origins&tag_contains_1=contains&tag_1=Belgique&sort_by=unique_scans_n&page_size=1000&axis_x=alcohol&axis_y=products_n&graph=1 | ||
+ | |||
+ | == Ready-made meals == | ||
+ | * How bad are they ? | ||
+ | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=%20plats%20pr%C3%A9par%C3%A9s%20%C3%A0%20r%C3%A9chauffer%20au%20micro-ondes&tagtype_1=nutrition_grades&tag_contains_1=does_not_contain&tag_1=unknown&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 | ||
+ | |||
+ | = Lists for contributors = | ||
+ | |||
+ | == Contributions == | ||
+ | * Most active countries in the last month: | ||
+ | **https://world.openfoodfacts.org/entry-date/2016-07/countries/ | ||
+ | * List of contributors: https://world.openfoodfacts.org/contributors | ||
+ | ** List of active contributors for the past month (world): | ||
+ | ** List of active contributors for the past month (country): | ||
+ | === Special Contributors === | ||
+ | * Apps | ||
+ | ** https://world.openfoodfacts.org/contributor/date-limite-app (date-limite) | ||
+ | ** https://world.openfoodfacts.org/contributor/pierrekilly (kwalito) | ||
+ | * https://world.openfoodfacts.org/contributor/openfoodfacts-contributors | ||
+ | |||
+ | == Errors == | ||
+ | *Conflicts with EAN-13 | ||
+ | ** https://world.openfoodfacts.org/code/conflict-with-ean-13 | ||
+ | * Conflicts with UPC 12 | ||
+ | ** https://world.openfoodfacts.org/code/conflict-with-upc-12 | ||
+ | * Checkbot urls in #bot on https://openfoodfacts.slack.com | ||
+ | |||
+ | == Product attributes == | ||
+ | === Brands === | ||
+ | * List of brands of beer | ||
+ | **https://world.openfoodfacts.org/categories/beers/brands | ||
+ | ==== Brand Deep Dive ==== | ||
+ | * List of brands: https://world.openfoodfacts.org/brands | ||
+ | ** List of countries with Nestlé products: https://world.openfoodfacts.org/brand/nestle/countries | ||
+ | ** What do Nestlé products contain ? https://world.openfoodfacts.org/brand/nestle/ingredients | ||
+ | ** Which contributors like Nestlé the most ? https://world.openfoodfacts.org/brand/nestle/contributors | ||
+ | ** Additives used in Nestlé products: https://world.openfoodfacts.org/brand/nestle/additives | ||
+ | ** Categories of Products that Nestlé produces: https://world.openfoodfacts.org/brand/nestle/categories | ||
+ | ** Packaging used by Nestlé products: https://world.openfoodfacts.org/brand/nestle/packaging | ||
+ | ** List of origins of ingredients for products from the Nestle brand: https://world.openfoodfacts.org/brand/nestle/origins | ||
+ | ** List of Nestlé products with ingredients that may be from palm oil: | ||
+ | |||
+ | === Packaging === | ||
+ | === Origins === | ||
+ | === Additives === | ||
+ | === Ingredients === | ||
+ | * List of ingredients: https://world.openfoodfacts.org/ingredients | ||
+ | ** English ingredients: | ||
+ | ** French ingredients: | ||
+ | |||
+ | === Categories=== | ||
+ | * List of categories: https://world.openfoodfacts.org/categories | ||
+ | ** Categories from France (in English): https://world.openfoodfacts.org/country/france/categories/ | ||
+ | ** Categories from Spain (in English): https://world.openfoodfacts.org/country/spain/categories/ | ||
+ | * What ingredients can you find in beers ? | ||
+ | ** https://world.openfoodfacts.org/category/beers/ingredients | ||
+ | === Entry Dates === | ||
+ | * List of Entry Dates: https://world.openfoodfacts.org/entry-dates | ||
+ | |||
+ | === Status / States=== | ||
+ | * https://world.openfoodfacts.org/states | ||
+ | * US products needing a category | ||
+ | ** | ||
+ | |||
+ | === Nutriments === | ||
+ | * Unknown nutriments | ||
+ | ** https://world.openfoodfacts.org/unknown-nutrients | ||
+ | |||
+ | == Low-hanging fruits == | ||
+ | === Alcohol === | ||
+ | *Products that are named wines but don’t have a wine category | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | *Products that contain alcohol but have no categories | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&nutriment_0=alcohol&nutriment_compare_0=gt&nutriment_value_0=0&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&page=1 | ||
+ | *Products that are named chateau but don’t have a wine category | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=chateau&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | *Products that have a year but don’t have a wine category | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=2012&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | * Wine products needing a category for Open Wine Facts | ||
+ | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=vin&tagtype_0=states&tag_contains_0=contains&tag_0=Categories%20to%20be%20completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | |||
+ | === M&S === | ||
+ | *M&S Products that can be labelled as sold in the UK | ||
+ | **https://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1 | ||
+ | |||
+ | === Barcodes === | ||
+ | *Products with a specific barcode prefix with no brand | ||
+ | **https://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed | ||
+ | **Brand-Prefix matching at https://en.wiki.openfoodfacts.org/Global_brands_and_companies_taxonomy/Barcodes | ||
+ | *Products with a wrong barcode | ||
+ | **https://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1 | ||
+ | |||
+ | === International Products === | ||
+ | * [https://www.dm.de/ dm] products | ||
+ | **with main language <> 'de' | ||
+ | ***https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=lang&tag_contains_0=does_not_contain&tag_0=de&tagtype_1=brands&tag_contains_1=contains&tag_1=dm&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | **without selling country 'de' | ||
+ | ***https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=countries&tag_contains_0=does_not_contain&tag_0=de&tagtype_1=brands&tag_contains_1=contains&tag_1=dm&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
+ | |||
== Old products == | == Old products == | ||
*Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite) | *Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite) | ||
Line 80: | Line 181: | ||
**- Dernière modification = Avant le 31 juin 2012 inclus | **- Dernière modification = Avant le 31 juin 2012 inclus | ||
**Comme ça j'irais faire des photos des "vieux" produit pour les mettre à jour | **Comme ça j'irais faire des photos des "vieux" produit pour les mettre à jour | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=complet&sort_by=created_t&page_size=20&axis_x=energy&axis_y=products_n&page=618 |
− | + | ||
− | + | =To be sorted= | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
*Weird graph by Stephane | *Weird graph by Stephane | ||
− | ** | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=fruits-vegetables-nuts&generate_graph_scatter_plot=1 |
Revision as of 15:32, 20 April 2018
This is a list of useful searches, for future reference.
General
- Most scanned products / produits les plus scannés
- Products containing B12 Vitamin
Thematic lists
Cheeses
- A beautiful cheese line (Tacite)
- Camemberts on a map (Vince)
Sodas
- Cola soda graph with sugars and additives
- Another way to show sugars vs additives (bar graph) (stephane)
Nutella
- Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella https://goo.gl/RAcG9A
Yogurts
- Yaourt (sucres et lipides)
- Teneur en fruit sur les yaourts aux fruits (Tacite)
- globalement moins les yaourts sont gras plus il y a d'additifs (stephane)
- Fat and sugar within yogurts (with nice additions) (stephane)
Produits allégés
- Bon d'après nos stats, les jambons -25% de sel ont -23% de sel. (stephane) :-)
- Moins 25% : https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=contains&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1
- Normal : https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=does_not_contain&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1
Breakfast Cereals - Les Céréales du Petit Déjeuner
- Sugars & Fat
- Sugars, Fat, Nutrition grades
Nutrition grades
- Nutrition grades of the DB
- Nutrition grades with Organic status
- Nutrition grades for breakfast cereals (thr4nduil)
- Nutrition grades for prepared food
Organic
- Organic foodies like beer but not too much (Tacite, BS causation by Teolemon)
Sugar
- Products with sugar /produits avec du sucre (stephane)
- Products without sugar /produits sans sucre (stephane)
Christmas puddings
- Additives in Xmas puddings
- Organic puddings vs Regular Puddings
Meat
- glucid/protein ratio in meat (vince)
- Stephane questions Tacite's choice of meat :-D "@tacite : tes "new burgers" sont les moins riches en protéines du lot"
Beers
- How much alcohol do Belgian beers contain ?
Ready-made meals
Lists for contributors
Contributions
- Most active countries in the last month:
- List of contributors: https://world.openfoodfacts.org/contributors
- List of active contributors for the past month (world):
- List of active contributors for the past month (country):
Special Contributors
Errors
- Conflicts with EAN-13
- Conflicts with UPC 12
- Checkbot urls in #bot on https://openfoodfacts.slack.com
Product attributes
Brands
- List of brands of beer
Brand Deep Dive
- List of brands: https://world.openfoodfacts.org/brands
- List of countries with Nestlé products: https://world.openfoodfacts.org/brand/nestle/countries
- What do Nestlé products contain ? https://world.openfoodfacts.org/brand/nestle/ingredients
- Which contributors like Nestlé the most ? https://world.openfoodfacts.org/brand/nestle/contributors
- Additives used in Nestlé products: https://world.openfoodfacts.org/brand/nestle/additives
- Categories of Products that Nestlé produces: https://world.openfoodfacts.org/brand/nestle/categories
- Packaging used by Nestlé products: https://world.openfoodfacts.org/brand/nestle/packaging
- List of origins of ingredients for products from the Nestle brand: https://world.openfoodfacts.org/brand/nestle/origins
- List of Nestlé products with ingredients that may be from palm oil:
Packaging
Origins
Additives
Ingredients
- List of ingredients: https://world.openfoodfacts.org/ingredients
- English ingredients:
- French ingredients:
Categories
- List of categories: https://world.openfoodfacts.org/categories
- Categories from France (in English): https://world.openfoodfacts.org/country/france/categories/
- Categories from Spain (in English): https://world.openfoodfacts.org/country/spain/categories/
- What ingredients can you find in beers ?
Entry Dates
- List of Entry Dates: https://world.openfoodfacts.org/entry-dates
Status / States
- https://world.openfoodfacts.org/states
- US products needing a category
Nutriments
- Unknown nutriments
Low-hanging fruits
Alcohol
- Products that are named wines but don’t have a wine category
- Products that contain alcohol but have no categories
- Products that are named chateau but don’t have a wine category
- Products that have a year but don’t have a wine category
- Wine products needing a category for Open Wine Facts
M&S
- M&S Products that can be labelled as sold in the UK
Barcodes
- Products with a specific barcode prefix with no brand
- Products with a wrong barcode
International Products
- dm products
- with main language <> 'de'
- without selling country 'de'
Old products
- Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite)
- - Statut = Complet
- - Dernière modification = Avant le 31 juin 2012 inclus
- Comme ça j'irais faire des photos des "vieux" produit pour les mettre à jour
- https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=complet&sort_by=created_t&page_size=20&axis_x=energy&axis_y=products_n&page=618