Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
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==
Line 12: Line 10:
 
* 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
 
**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
 +
 
== Sodas ==
 
== Sodas ==
 
* Cola soda graph with sugars and additives
 
* Cola soda graph with sugars and additives
Line 21: Line 20:
 
* 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 http://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
 
**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
 +
 
== Yogurts ==
 
== Yogurts ==
 
* Yaourt (sucres et lipides)
 
* Yaourt (sucres et lipides)
Line 51: Line 51:
 
* 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
 
**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
 
==Low hanging fruits ==
 
*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
 
*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
 
*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
 
 
*Products with a specific barcode prefix with no brand
 
**http://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
 
*Products with a wrong barcode
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
 
* 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
 
  
 
== Organic ==
 
== Organic ==
Line 83: Line 67:
 
**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
 
**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
  
== 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
 
**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
 
 
== Meat ==
 
== Meat ==
 
* glucid/protein ratio in meat (vince)
 
* glucid/protein ratio in meat (vince)
Line 101: Line 79:
 
* 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
 
**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
 +
 +
==Low hanging fruits ==
 +
*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
 +
*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
 +
*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
 +
*Products with a specific barcode prefix with no brand
 +
**http://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
 +
*Products with a wrong barcode
 +
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
 +
* 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
 +
 +
== 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
 +
**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
 +
  
 
==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
 
**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

Revision as of 15:54, 8 August 2015

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

General

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

Low hanging fruits

Old products


To be sorted