Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
 
(28 intermediate revisions by 4 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.
 
+
[[Category:Press]]
 
+
[[Category:Category analysis]]
 
 
 
==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
 +
**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)
**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)
 +
** 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==
 +
* 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)
**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)
 +
**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)
 +
**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 ==
 +
*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 ==
 
== 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
 +
**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
 +
**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
 +
**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
==Low hanging fruits ==
+
 
 +
== Organic ==
 +
* 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==
 +
* 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)
 +
** 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 ==
 +
* 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
 
*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
 +
**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
 
*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 ===
 
*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
== Organic ==
+
 
* Organic foodies like beer but not too much (Tacite, BS causation by Teolemon)
+
=== International Products ===
**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://www.dm.de/ dm] products
==To be sorted==
+
**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 ==
 +
*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
 +
 
 +
=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 10:11, 7 August 2024

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