Difference between revisions of "Useful queries"

From Open Food Facts wiki
Jump to navigation Jump to search
Line 82: Line 82:
  
 
= Lists for contributors =
 
= Lists for contributors =
 +
 +
== Contributions ==
 
* Most active countries in the last month:
 
* Most active countries in the last month:
 
**http://world.openfoodfacts.org/entry-date/2015-07/countries/
 
**http://world.openfoodfacts.org/entry-date/2015-07/countries/
* List of ingredients: http://world.openfoodfacts.org/ingredients
 
** English ingredients:
 
** French ingredients:
 
 
* List of contributors: http://world.openfoodfacts.org/contributors
 
* 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 (world):
 
** List of active contributors for the past month (country):
 
** List of active contributors for the past month (country):
* List of categories:http://world.openfoodfacts.org/categories
 
* List of Entry Dates: http://world.openfoodfacts.org/entry-dates
 
  
 +
== Errors ==
 +
*Conflicts with EAN-13
 +
** http://world.openfoodfacts.org/code/conflict-with-ean-13
 +
* Checkbot urls in #bot on http://openfoodfacts.slack.com
 +
 +
== 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 107: Line 110:
 
** http://world.openfoodfacts.org/contributor/date-limite-app (date-limite)
 
** http://world.openfoodfacts.org/contributor/date-limite-app (date-limite)
 
** http://world.openfoodfacts.org/contributor/pierrekilly (kwalito)
 
** http://world.openfoodfacts.org/contributor/pierrekilly (kwalito)
==Low-hanging fruits ==
+
 
 +
== Random ==
 +
* List of ingredients: http://world.openfoodfacts.org/ingredients
 +
** English ingredients:
 +
** French ingredients:
 +
* 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/
 +
* List of Entry Dates: http://world.openfoodfacts.org/entry-dates
 +
 
 +
== 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
 
**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
 
**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
Line 130: Line 143:
  
  
==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:01, 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

Errors

Brand Deep Dive

Special Contributors

Random

Low-hanging fruits

Old products


To be sorted