Difference between revisions of "Useful queries"
Jump to navigation
Jump to search
| Line 89: | Line 89: | ||
** List of active contributors for the past month (world): | ** List of active contributors for the past month (world): | ||
** List of active contributors for the past month (country): | ** List of active contributors for the past month (country): | ||
| + | === Special Contributors === | ||
| + | * Apps | ||
| + | ** http://world.openfoodfacts.org/contributor/date-limite-app (date-limite) | ||
| + | ** http://world.openfoodfacts.org/contributor/pierrekilly (kwalito) | ||
| + | |||
== Errors == | == Errors == | ||
| Line 95: | Line 100: | ||
* Checkbot urls in #bot on http://openfoodfacts.slack.com | * Checkbot urls in #bot on http://openfoodfacts.slack.com | ||
| − | == Brand Deep Dive == | + | |
| + | |||
| + | |||
| + | |||
| + | == Product attributes == | ||
| + | == Brands == | ||
| + | * List of brands of beer | ||
| + | **http://world.openfoodfacts.org/categories/beers/brands | ||
| + | === Brand Deep Dive === | ||
* List of brands: http://world.openfoodfacts.org/brands | * List of brands: http://world.openfoodfacts.org/brands | ||
** List of countries with Nestlé products: http://world.openfoodfacts.org/brand/nestle/countries | ** List of countries with Nestlé products: http://world.openfoodfacts.org/brand/nestle/countries | ||
| Line 106: | Line 119: | ||
** List of Nestlé products with ingredients that may be from palm oil: | ** List of Nestlé products with ingredients that may be from palm oil: | ||
| − | == | + | === Packaging === |
| − | + | === Origins === | |
| − | + | === Additives === | |
| − | + | === Ingredients === | |
| − | |||
| − | == | ||
* List of ingredients: http://world.openfoodfacts.org/ingredients | * List of ingredients: http://world.openfoodfacts.org/ingredients | ||
** English ingredients: | ** English ingredients: | ||
** French ingredients: | ** French ingredients: | ||
| + | |||
| + | === Categories=== | ||
* List of categories:http://world.openfoodfacts.org/categories | * List of categories:http://world.openfoodfacts.org/categories | ||
** Categories from France (in English): http://world.openfoodfacts.org/country/france/categories/ | ** Categories from France (in English): http://world.openfoodfacts.org/country/france/categories/ | ||
** Categories from Spain (in English): http://world.openfoodfacts.org/country/spain/categories/ | ** Categories from Spain (in English): http://world.openfoodfacts.org/country/spain/categories/ | ||
| + | * What ingredients can you find in beers ? | ||
| + | ** http://world.openfoodfacts.org/category/beers/ingredients | ||
| + | === Entry Dates === | ||
* List of Entry Dates: http://world.openfoodfacts.org/entry-dates | * List of Entry Dates: http://world.openfoodfacts.org/entry-dates | ||
| + | |||
| + | === Status / States=== | ||
| + | * http://world.openfoodfacts.org/states | ||
| + | * US products needing a category | ||
| + | ** | ||
== Low-hanging fruits == | == Low-hanging fruits == | ||
| Line 141: | Line 162: | ||
**Comme ça j'irais faire des photos des "vieux" produit pour les mettre à jour | **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 | **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 | ||
| − | |||
=To be sorted= | =To be sorted= | ||
*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 | ||
Revision as of 17:22, 8 August 2015
This is a list of useful searches, for future reference.
General
- Most scanned products / produits les plus scannés
Thematic lists
Cheeses
- A beautiful cheese line (Tacite)
- Camemberts on a map (Vince)
Sodas
- Cola soda graph with sugars and additives
- Another way to show sugars vs additives (bar graph) (stephane)
Nutella
- Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella http://goo.gl/RAcG9A
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)
- Fat and sugar within yogurts (with nice additions) (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
- Sugars & Fat
- Sugars, Fat, Nutrition grades
Nutrition grades
- Nutrition grades of the DB
- Nutrition grades with Organic status
- Nutrition grades for breakfast cereals (thr4nduil)
- Nutrition grades for prepared food
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
- Organic puddings vs Regular Puddings
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 ?
Ready-made meals
Lists for contributors
Contributions
- Most active countries in the last month:
- List of contributors: http://world.openfoodfacts.org/contributors
- List of active contributors for the past month (world):
- List of active contributors for the past month (country):
Special Contributors
- Apps
Errors
- Conflicts with EAN-13
- Checkbot urls in #bot on http://openfoodfacts.slack.com
Product attributes
Brands
- List of brands of beer
Brand Deep Dive
- List of brands: http://world.openfoodfacts.org/brands
- List of countries with Nestlé products: http://world.openfoodfacts.org/brand/nestle/countries
- What do Nestlé products contain ? http://world.openfoodfacts.org/brand/nestle/ingredients
- Which contributors like Nestlé the most ? http://world.openfoodfacts.org/brand/nestle/contributors
- Additives used in Nestlé products: http://world.openfoodfacts.org/brand/nestle/additives
- Categories of Products that Nestlé produces: http://world.openfoodfacts.org/brand/nestle/categories
- Packaging used by Nestlé products: http://world.openfoodfacts.org/brand/nestle/packaging
- List of origins of ingredients for products from the Nestle brand: http://world.openfoodfacts.org/brand/nestle/origins
- List of Nestlé products with ingredients that may be from palm oil:
Packaging
Origins
Additives
Ingredients
- List of ingredients: http://world.openfoodfacts.org/ingredients
- English ingredients:
- French ingredients:
Categories
- List of categories:http://world.openfoodfacts.org/categories
- Categories from France (in English): http://world.openfoodfacts.org/country/france/categories/
- Categories from Spain (in English): http://world.openfoodfacts.org/country/spain/categories/
- What ingredients can you find in beers ?
Entry Dates
- List of Entry Dates: http://world.openfoodfacts.org/entry-dates
Status / States
- http://world.openfoodfacts.org/states
- US products needing a category
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
- Wine products needing a category for Open Wine Facts
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