Useful queries

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

General

• 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

Cheeses

• 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
• 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
  • 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)
  • 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
• 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

Nutrition grades

• 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
• 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

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

Organic

• 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

To be sorted

• 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