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.
  
*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
 
 
*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
 
**http://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1
*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
+
 
 +
*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
 +
== 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
 
**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
 +
* 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
 +
== 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
 
**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
 +
== 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
 
**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
* Camemberts on a map (Vince)
+
*Teneur en fruit sur les yaourts aux fruits (Tacite)
**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://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
*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
 
 
 
 
== Nutrition grades ==
 
== Nutrition grades ==
 
*Nutrition grades for breakfast cereals (thr4nduil)
 
*Nutrition grades for breakfast cereals (thr4nduil)
Line 33: Line 35:
 
*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
 
**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

Revision as of 15:09, 8 August 2015

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




Cheeses

Sodas

Yogurts =

Nutrition grades

Low hanging fruits