Difference between revisions of "Useful queries"

From Open Food Facts wiki
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:  
  
== Special Contributors ==
+
=== Packaging ===
* Apps
+
=== Origins ===
** http://world.openfoodfacts.org/contributor/date-limite-app (date-limite)
+
=== Additives ===
** http://world.openfoodfacts.org/contributor/pierrekilly (kwalito)
+
=== Ingredients ===
 
 
== Random ==
 
 
* 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

Thematic lists

Cheeses

Sodas

Nutella

Yogurts

Produits allégés

Breakfast Cereals - Les Céréales du Petit Déjeuner

Nutrition grades

Organic

Sugar

Christmas puddings

Meat

Beers

Ready-made meals

Lists for contributors

Contributions

Special Contributors


Errors



Product attributes

Brands

Brand Deep Dive

Packaging

Origins

Additives

Ingredients

Categories

Entry Dates

Status / States

Low-hanging fruits

Old products

To be sorted