Difference between revisions of "Useful queries"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
*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) | *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 | **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 | ||
* 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 | ||
| − | + | * 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 | ||
* 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 | ||
| Line 21: | Line 20: | ||
*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 == | ||
*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 | **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 == | ==Low hanging fruits == | ||
*Products that are named wines but don’t have a wine category | *Products that are named wines but don’t have a wine category | ||
| Line 29: | Line 31: | ||
*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 | **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 | ||
Revision as of 15:07, 8 August 2015
This is a list of useful searches, for future reference.
- Products with a specific barcode prefix with no brand
- Products with a wrong barcode
- Most scanned products / produits les plus scannés
- Teneur en fruit sur les yaourts aux fruits (Tacite)
- A beautiful cheese line (Tacite)
- Cola soda graph with sugars and additives
- Yaourt (sucres et lipides)
- Camemberts on a map (Vince)
- Weird graph by Stephane
Nutrition grades
- Nutrition grades for breakfast cereals (thr4nduil)
- Nutrition grades for prepared food
Low hanging fruits
- Products that are named wines but don’t have a wine category
- Products that contain alcohol but have no categories
- M&S Products that can be labelled as sold in the UK