Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
(→‎Contributions: update and addition)
(→‎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))
 
(One intermediate revision by one other user not shown)
Line 3: Line 3:
 
==General==
 
==General==
 
*Most scanned products / produits les plus scannés  
 
*Most scanned products / produits les plus scannés  
**http://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1
+
**https://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1
 
*Products containing B12 Vitamin
 
*Products containing B12 Vitamin
**http://world.openfoodfacts.org/cgi/search.pl?action=process&nutriment_0=vitamin-b12&nutriment_compare_0=lt&nutriment_value_0=0.00001
+
**https://world.openfoodfacts.org/cgi/search.pl?action=process&nutriment_0=vitamin-b12&nutriment_compare_0=lt&nutriment_value_0=0.00001
  
 
= Thematic lists =
 
= Thematic lists =
 
== Cheeses ==
 
== Cheeses ==
 
* A beautiful cheese line (Tacite)
 
* A beautiful cheese line (Tacite)
**http://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
+
**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)
**http://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
+
**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
**http://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
+
**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)
** http://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
+
** 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 http://goo.gl/RAcG9A
+
* Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella https://goo.gl/RAcG9A
**http://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
+
**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)
**http://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
+
**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)
**http://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
+
**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)
**http://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
+
**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)
**http://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
+
**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% : http://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
+
** 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 : http://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
+
** 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
**http://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
+
**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
 
* Sugars, Fat, Nutrition grades
**http://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
+
**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
**http://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
+
**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
**http://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
+
**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)
**http://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
+
**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
**http://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
+
**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)
**http://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
+
**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)
** http://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
+
** 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)
** http://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
+
** 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
**http://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
+
**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
 
* Organic puddings vs Regular Puddings
**http://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
+
**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 ==
 
== Meat ==
 
* glucid/protein ratio in meat (vince)
 
* glucid/protein ratio in meat (vince)
** http://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
+
** 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"
 
* Stephane questions Tacite's choice of meat :-D "@tacite : tes "new burgers" sont les moins riches en protéines du lot"
** http://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
+
** 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 ==
 
== Beers ==
 
* How much alcohol do Belgian beers contain ?
 
* How much alcohol do Belgian beers contain ?
** http://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
+
** 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 ==
 
== Ready-made meals ==
 
* How bad are they ?
 
* How bad are they ?
**http://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
+
**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 =
 
= Lists for contributors =
Line 87: Line 87:
 
== Contributions ==
 
== Contributions ==
 
* Most active countries in the last month:
 
* Most active countries in the last month:
**http://world.openfoodfacts.org/entry-date/2016-07/countries/
+
**https://world.openfoodfacts.org/entry-date/2016-07/countries/
* List of contributors: http://world.openfoodfacts.org/contributors
+
* 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 (world):
 
** List of active contributors for the past month (country):
 
** List of active contributors for the past month (country):
 
=== Special Contributors ===
 
=== Special Contributors ===
 
* Apps
 
* Apps
** http://world.openfoodfacts.org/contributor/date-limite-app (date-limite)
+
** https://world.openfoodfacts.org/contributor/date-limite-app (date-limite)
** http://world.openfoodfacts.org/contributor/pierrekilly (kwalito)
+
** https://world.openfoodfacts.org/contributor/pierrekilly (kwalito)
* http://world.openfoodfacts.org/contributor/openfoodfacts-contributors
+
* https://world.openfoodfacts.org/contributor/openfoodfacts-contributors
  
 
== Errors ==
 
== Errors ==
 
*Conflicts with EAN-13
 
*Conflicts with EAN-13
** http://world.openfoodfacts.org/code/conflict-with-ean-13
+
** https://world.openfoodfacts.org/code/conflict-with-ean-13
 
* Conflicts with UPC 12
 
* Conflicts with UPC 12
** http://world.openfoodfacts.org/code/conflict-with-upc-12
+
** https://world.openfoodfacts.org/code/conflict-with-upc-12
* Checkbot urls in #bot on http://openfoodfacts.slack.com
+
* Checkbot urls in #bot on https://openfoodfacts.slack.com
  
 
== Product attributes ==
 
== Product attributes ==
 
=== Brands ===
 
=== Brands ===
 
* List of brands of beer
 
* List of brands of beer
**http://world.openfoodfacts.org/categories/beers/brands
+
**https://world.openfoodfacts.org/categories/beers/brands
 
==== Brand Deep Dive ====
 
==== Brand Deep Dive ====
* List of brands: http://world.openfoodfacts.org/brands
+
* List of brands: https://world.openfoodfacts.org/brands
** List of countries with Nestlé products: http://world.openfoodfacts.org/brand/nestle/countries
+
** List of countries with Nestlé products: https://world.openfoodfacts.org/brand/nestle/countries
** What do Nestlé products contain ? http://world.openfoodfacts.org/brand/nestle/ingredients
+
** What do Nestlé products contain ? https://world.openfoodfacts.org/brand/nestle/ingredients
** Which contributors like Nestlé the most ? http://world.openfoodfacts.org/brand/nestle/contributors
+
** Which contributors like Nestlé the most ? https://world.openfoodfacts.org/brand/nestle/contributors
** Additives used in Nestlé products: http://world.openfoodfacts.org/brand/nestle/additives
+
** Additives used in Nestlé products: https://world.openfoodfacts.org/brand/nestle/additives
** Categories of Products that Nestlé produces: http://world.openfoodfacts.org/brand/nestle/categories
+
** Categories of Products that Nestlé produces: https://world.openfoodfacts.org/brand/nestle/categories
** Packaging used by Nestlé products: http://world.openfoodfacts.org/brand/nestle/packaging
+
** Packaging used by Nestlé products: https://world.openfoodfacts.org/brand/nestle/packaging
** List of origins of ingredients for products from the Nestle brand: http://world.openfoodfacts.org/brand/nestle/origins
+
** 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:  
 
** List of Nestlé products with ingredients that may be from palm oil:  
  
Line 123: Line 123:
 
=== Additives ===
 
=== Additives ===
 
=== Ingredients ===
 
=== Ingredients ===
* List of ingredients: http://world.openfoodfacts.org/ingredients
+
* List of ingredients: https://world.openfoodfacts.org/ingredients
 
** English ingredients:
 
** English ingredients:
 
** French ingredients:  
 
** French ingredients:  
  
 
=== Categories===
 
=== Categories===
* List of categories:http://world.openfoodfacts.org/categories
+
* List of categories: https://world.openfoodfacts.org/categories
** Categories from France (in English): http://world.openfoodfacts.org/country/france/categories/
+
** Categories from France (in English): https://world.openfoodfacts.org/country/france/categories/
** Categories from Spain (in English): http://world.openfoodfacts.org/country/spain/categories/
+
** Categories from Spain (in English): https://world.openfoodfacts.org/country/spain/categories/
 
* What ingredients can you find in beers ?
 
* What ingredients can you find in beers ?
** http://world.openfoodfacts.org/category/beers/ingredients
+
** https://world.openfoodfacts.org/category/beers/ingredients
 
=== Entry Dates ===
 
=== Entry Dates ===
* List of Entry Dates: http://world.openfoodfacts.org/entry-dates
+
* List of Entry Dates: https://world.openfoodfacts.org/entry-dates
  
 
=== Status / States===
 
=== Status / States===
* http://world.openfoodfacts.org/states
+
* https://world.openfoodfacts.org/states
 
* US products needing a category
 
* US products needing a category
 
**
 
**
Line 143: Line 143:
 
=== Nutriments ===
 
=== Nutriments ===
 
* Unknown nutriments
 
* Unknown nutriments
** http://world.openfoodfacts.org/unknown-nutrients
+
** https://world.openfoodfacts.org/unknown-nutrients
  
 
== Low-hanging fruits ==
 
== Low-hanging fruits ==
 
=== Alcohol ===
 
=== Alcohol ===
 
*Products that are named wines but don’t have a wine category
 
*Products that are named wines but don’t have a wine category
**http://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
+
**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
 
*Products that contain alcohol but have no categories
**http://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
+
**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
 
*Products that are named chateau but don’t have a wine category
**http://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
+
**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
 
*Products that have a year but don’t have a wine category
**http://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
+
**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
 
* Wine products needing a category for Open Wine Facts
**http://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
+
**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 ===
 
*M&S Products that can be labelled as sold in the UK
 
*M&S Products that can be labelled as sold in the UK
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1
+
**https://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1
  
 
=== Barcodes ===
 
=== Barcodes ===
 
*Products with a specific barcode prefix with no brand
 
*Products with a specific barcode prefix with no brand
**http://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed
+
**https://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed
**Brand-Prefix matching at http://en.wiki.openfoodfacts.org/Global_brands_and_companies_taxonomy/Barcodes
+
**Brand-Prefix matching at https://en.wiki.openfoodfacts.org/Global_brands_and_companies_taxonomy/Barcodes
 
*Products with a wrong barcode
 
*Products with a wrong barcode
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
+
**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 ==
Line 174: 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
**http://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
+
**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=
 
=To be sorted=
 
*Weird graph by Stephane
 
*Weird graph by Stephane
**http://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
+
**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

Latest revision as of 15:32, 20 April 2018

This is a list of useful searches, for future reference.

General

Thematic lists

Cheeses

Sodas

Nutella

Yogurts

Produits allégés

Breakfast Cereals - Les Céréales du Petit Déjeuner

Nutrition grades

Organic

Sugar

Christmas puddings

Meat

Beers

Ready-made meals

Lists for contributors

Contributions

Special Contributors

Errors

Product attributes

Brands

Brand Deep Dive

Packaging

Origins

Additives

Ingredients

Categories

Entry Dates

Status / States

Nutriments

Low-hanging fruits

Alcohol

M&S

Barcodes

International Products

Old products

To be sorted