Difference between revisions of "Useful queries"
Jump to navigation
Jump to search
| Line 59: | Line 59: | ||
* Products without sugar /produits sans sucre (stephane) | * Products without sugar /produits sans sucre (stephane) | ||
** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=does_not_contain&tag_0=sucre&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=ingredients&tag_contains_0=does_not_contain&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | ||
| − | + | == Christmas puddings == | |
| + | * Additives in Xmas puddings | ||
| + | **http://uk.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=christmas%20puddings&sort_by=unique_scans_n&page_size=20&axis_x=additives_n&axis_y=products_n&graph=1 | ||
== Old products == | == Old products == | ||
*Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite) | *Extraire toutes les fiches qui répondent à ces critères (stephane on request by tacite) | ||
| Line 69: | Line 71: | ||
* glucid/protein ratio in meat (vince) | * glucid/protein ratio in meat (vince) | ||
** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=viandes%20surgel%C3%A9es&sort_by=unique_scans_n&page_size=20&axis_x=proteins&axis_y=carbohydrates&graph=1 | ** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=viandes%20surgel%C3%A9es&sort_by=unique_scans_n&page_size=20&axis_x=proteins&axis_y=carbohydrates&graph=1 | ||
| + | * Stephane questions Tacite's choice of meat :-D "@tacite : tes "new burgers" sont les moins riches en protéines du lot" | ||
| + | ** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=preparations-de-viande-bovine-hachee&sort_by=unique_scans_n&page_size=20&axis_x=proteins&axis_y=fat&graph=1 | ||
== Beers == | == Beers == | ||
* How much alcohol do Belgian beers contain ? | * How much alcohol do Belgian beers contain ? | ||
Revision as of 15:30, 8 August 2015
This is a list of useful searches, for future reference.
General
- Most scanned products / produits les plus scannés
Cheeses
- A beautiful cheese line (Tacite)
- Camemberts on a map (Vince)
Sodas
- Cola soda graph with sugars and additives
Yogurts
- Yaourt (sucres et lipides)
- Teneur en fruit sur les yaourts aux fruits (Tacite)
- globalement moins les yaourts sont gras plus il y a d'additifs (stephane)
Produits allégés
- Bon d'après nos stats, les jambons -25% de sel ont -23% de sel. (stephane) :-)
- Moins 25% : http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=contains&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1
- Normal : http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Jambons%20blancs&tagtype_1=labels&tag_contains_1=does_not_contain&tag_1=Moins%2025%25%20de%20sel&sort_by=unique_scans_n&page_size=20&axis_x=sodium&axis_y=fat&graph=1
Breakfast Cereals - Les Céréales du Petit Déjeuner
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
- Products with a specific barcode prefix with no brand
- Products with a wrong barcode
Organic
- Organic foodies like beer but not too much (Tacite, BS causation by Teolemon)
Sugar
- Products with sugar /produits avec du sucre (stephane)
- Products without sugar /produits sans sucre (stephane)
Christmas puddings
- Additives in Xmas puddings
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
- glucid/protein ratio in meat (vince)
- Stephane questions Tacite's choice of meat :-D "@tacite : tes "new burgers" sont les moins riches en protéines du lot"
Beers
- How much alcohol do Belgian beers contain ?