Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
Line 6: Line 6:
 
*Products with a wrong barcode
 
*Products with a wrong barcode
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
 
**http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
*Most scanned products
+
*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
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1
 
*M&S Products that can be labelled as sold in the UK
 
*M&S Products that can be labelled as sold in the UK
Line 21: Line 21:
 
*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
 +
*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
 +
 +
==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

Revision as of 15:04, 8 August 2015

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

Low hanging fruits