Line 1: |
Line 1: |
| This is a list of useful searches, for future reference. | | This is a list of useful searches, for future reference. |
− |
| |
− |
| |
| | | |
| ==General== | | ==General== |
| *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 | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&sort_by=unique_scans_n&page_size=20&page=1 |
| + | *Products containing B12 Vitamin |
| + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&nutriment_0=vitamin-b12&nutriment_compare_0=lt&nutriment_value_0=0.00001 |
| | | |
| + | = Thematic lists = |
| == Cheeses == | | == Cheeses == |
| * 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 | + | **https://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 |
| * Camemberts on a map (Vince) | | * Camemberts on a map (Vince) |
− | **http://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=camembert%20au%20lait%20cru&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&generate_map=1 | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=camembert%20au%20lait%20cru&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&generate_map=1 |
| + | |
| == Sodas == | | == Sodas == |
| * Cola soda graph with sugars and additives | | * 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 | + | **https://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 |
| * Another way to show sugars vs additives (bar graph) (stephane) | | * Another way to show sugars vs additives (bar graph) (stephane) |
− | ** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=sodas&sort_by=product_name&page_size=20&axis_x=sugars&axis_y=products_n&graph_title=Sucre%20dans%20les%20sodas&series_organic=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 | + | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=sodas&sort_by=product_name&page_size=20&axis_x=sugars&axis_y=products_n&graph_title=Sucre%20dans%20les%20sodas&series_organic=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
| | | |
| ==Nutella== | | ==Nutella== |
− | * Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella http://goo.gl/RAcG9A | + | * Made during the French Nutellagate (teolemon) - @RoyalSegolene @LPJofficiel : @OpenFoodFactsFr fournit des alternatives sans huile de palme au Nutella https://goo.gl/RAcG9A |
− | **http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=Complet&tagtype_1=categories&tag_contains_1=contains&tag_1=pates-a-tartiner-aux-noisettes-et-au-cacao&ingredients_from_palm_oil=without&ingredients_that_may_be_from_palm_oil=without&ingredients_from_or_that_may_be_from_palm_oil=without&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=states&tag_contains_0=contains&tag_0=Complet&tagtype_1=categories&tag_contains_1=contains&tag_1=pates-a-tartiner-aux-noisettes-et-au-cacao&ingredients_from_palm_oil=without&ingredients_that_may_be_from_palm_oil=without&ingredients_from_or_that_may_be_from_palm_oil=without&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| + | |
| == Yogurts == | | == Yogurts == |
| * 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 | + | **https://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 |
| *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 | + | **https://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 |
| *globalement moins les yaourts sont gras plus il y a d'additifs (stephane) | | *globalement moins les yaourts sont gras plus il y a d'additifs (stephane) |
− | **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=fat&axis_y=additives_n&series_with_sweeteners=on&graph=1 | + | **https://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=fat&axis_y=additives_n&series_with_sweeteners=on&graph=1 |
| * Fat and sugar within yogurts (with nice additions) (stephane) | | * Fat and sugar within yogurts (with nice additions) (stephane) |
− | **http://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=yogurt&sort_by=product_name&page_size=20&axis_x=fat&axis_y=sugars&graph_title=Fat%20and%20sugar%20in%20yogurts&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=yogurt&sort_by=product_name&page_size=20&axis_x=fat&axis_y=sugars&graph_title=Fat%20and%20sugar%20in%20yogurts&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
| | | |
| == Produits allégés == | | == Produits allégés == |
| *Bon d'après nos stats, les jambons -25% de sel ont -23% de sel. (stephane) :-) | | *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 | + | ** Moins 25% : https://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 | + | ** Normal : https://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 == | | == Breakfast Cereals - Les Céréales du Petit Déjeuner == |
| * Sugars & Fat | | * Sugars & Fat |
− | **http://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=breakfast%20cereal&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&graph=1 | + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=breakfast%20cereal&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&graph=1 |
| + | * Sugars, Fat, Nutrition grades |
| + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=c%C3%A9r%C3%A9ales%20pour%20petit%20dejeuner&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 |
| | | |
| == Nutrition grades == | | == Nutrition grades == |
| * Nutrition grades of the DB | | * Nutrition grades of the DB |
− | **http://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&graph_title=Score%20nutritionnel%20des%20produits%20de%20la%20base%20Open%20Food%20Facts&generate_graph_scatter_plot=1 | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&graph_title=Score%20nutritionnel%20des%20produits%20de%20la%20base%20Open%20Food%20Facts&generate_graph_scatter_plot=1 |
| * Nutrition grades with Organic status | | * Nutrition grades with Organic status |
− | **http://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&sort_by=product_name&page_size=20&axis_x=nutrition-score-fr&axis_y=products_n&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&generate_graph_scatter_plot=1 |
| *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 | + | **https://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 | | * 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 | + | **https://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 ==
| |
− | *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
| |
− | *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
| |
− | *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
| |
− |
| |
− | *Products with a specific barcode prefix with no brand
| |
− | **http://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed
| |
− | **Brand-Prefix matching at http://en.wiki.openfoodfacts.org/Global_brands_and_companies_taxonomy/Barcodes
| |
− | *Products with a wrong barcode
| |
− | **http://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1
| |
| == Organic == | | == Organic == |
| * Organic foodies like beer but not too much (Tacite, BS causation by Teolemon) | | * Organic foodies like beer but not too much (Tacite, BS causation by Teolemon) |
− | **http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Bi%C3%A8res&sort_by=unique_scans_n&page_size=20&axis_x=alcohol&axis_y=products_n&series_organic=on&series_fairtrade=on&graph=1 | + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=Bi%C3%A8res&sort_by=unique_scans_n&page_size=20&axis_x=alcohol&axis_y=products_n&series_organic=on&series_fairtrade=on&graph=1 |
| | | |
| ==Sugar== | | ==Sugar== |
| * Products with sugar /produits avec du sucre (stephane) | | * Products with sugar /produits avec du sucre (stephane) |
− | ** http://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=contains&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display | + | ** https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=ingredients&tag_contains_0=contains&tag_0=sucre&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| * 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 | + | ** https://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 == | | == Christmas puddings == |
| * Additives in Xmas 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 | + | **https://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 |
| + | * Organic puddings vs Regular Puddings |
| + | **https://uk.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=christmas%20pudding&sort_by=unique_scans_n&page_size=20&axis_x=additives_n&axis_y=products_n&graph_title=Additives%20in%20Christmas%20Pudding&series_organic=on&series_fairtrade=on&series_with_sweeteners=on&graph=1 |
| + | |
| + | == Meat == |
| + | * glucid/protein ratio in meat (vince) |
| + | ** https://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" |
| + | ** https://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 == |
| + | * How much alcohol do Belgian beers contain ? |
| + | ** https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=beer&tagtype_1=origins&tag_contains_1=contains&tag_1=Belgique&sort_by=unique_scans_n&page_size=1000&axis_x=alcohol&axis_y=products_n&graph=1 |
| + | |
| + | == Ready-made meals == |
| + | * How bad are they ? |
| + | **https://fr.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=%20plats%20pr%C3%A9par%C3%A9s%20%C3%A0%20r%C3%A9chauffer%20au%20micro-ondes&tagtype_1=nutrition_grades&tag_contains_1=does_not_contain&tag_1=unknown&sort_by=unique_scans_n&page_size=20&axis_x=sugars&axis_y=fat&series_nutrition_grades=on&graph=1 |
| + | |
| + | = Lists for contributors = |
| + | |
| + | == Contributions == |
| + | * Most active countries in the last month: |
| + | **https://world.openfoodfacts.org/entry-date/2016-07/countries/ |
| + | * List of contributors: https://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 |
| + | ** https://world.openfoodfacts.org/contributor/date-limite-app (date-limite) |
| + | ** https://world.openfoodfacts.org/contributor/pierrekilly (kwalito) |
| + | * https://world.openfoodfacts.org/contributor/openfoodfacts-contributors |
| + | |
| + | == Errors == |
| + | *Conflicts with EAN-13 |
| + | ** https://world.openfoodfacts.org/code/conflict-with-ean-13 |
| + | * Conflicts with UPC 12 |
| + | ** https://world.openfoodfacts.org/code/conflict-with-upc-12 |
| + | * Checkbot urls in #bot on https://openfoodfacts.slack.com |
| + | |
| + | == Product attributes == |
| + | === Brands === |
| + | * List of brands of beer |
| + | **https://world.openfoodfacts.org/categories/beers/brands |
| + | ==== Brand Deep Dive ==== |
| + | * List of brands: https://world.openfoodfacts.org/brands |
| + | ** List of countries with Nestlé products: https://world.openfoodfacts.org/brand/nestle/countries |
| + | ** What do Nestlé products contain ? https://world.openfoodfacts.org/brand/nestle/ingredients |
| + | ** Which contributors like Nestlé the most ? https://world.openfoodfacts.org/brand/nestle/contributors |
| + | ** Additives used in Nestlé products: https://world.openfoodfacts.org/brand/nestle/additives |
| + | ** Categories of Products that Nestlé produces: https://world.openfoodfacts.org/brand/nestle/categories |
| + | ** Packaging used by Nestlé products: https://world.openfoodfacts.org/brand/nestle/packaging |
| + | ** List of origins of ingredients for products from the Nestle brand: https://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: https://world.openfoodfacts.org/ingredients |
| + | ** English ingredients: |
| + | ** French ingredients: |
| + | |
| + | === Categories=== |
| + | * List of categories: https://world.openfoodfacts.org/categories |
| + | ** Categories from France (in English): https://world.openfoodfacts.org/country/france/categories/ |
| + | ** Categories from Spain (in English): https://world.openfoodfacts.org/country/spain/categories/ |
| + | * What ingredients can you find in beers ? |
| + | ** https://world.openfoodfacts.org/category/beers/ingredients |
| + | === Entry Dates === |
| + | * List of Entry Dates: https://world.openfoodfacts.org/entry-dates |
| + | |
| + | === Status / States=== |
| + | * https://world.openfoodfacts.org/states |
| + | * US products needing a category |
| + | ** |
| + | |
| + | === Nutriments === |
| + | * Unknown nutriments |
| + | ** https://world.openfoodfacts.org/unknown-nutrients |
| + | |
| + | == Low-hanging fruits == |
| + | === Alcohol === |
| + | *Products that are named wines but don’t have a wine category |
| + | **https://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 |
| + | *Products that contain alcohol but have no categories |
| + | **https://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 |
| + | *Products that are named chateau but don’t have a wine category |
| + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=chateau&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| + | *Products that have a year but don’t have a wine category |
| + | **https://world.openfoodfacts.org/cgi/search.pl?action=process&search_terms=2012&tagtype_0=states&tag_contains_0=contains&tag_0=Categories-to-be-completed&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| + | * Wine products needing a category for Open Wine Facts |
| + | **https://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 |
| + | |
| + | === M&S === |
| + | *M&S Products that can be labelled as sold in the UK |
| + | **https://fr.openfoodfacts.org/cgi/search.pl?search_terms=mark+spencers&search_simple=1 |
| + | |
| + | === Barcodes === |
| + | *Products with a specific barcode prefix with no brand |
| + | **https://world.openfoodfacts.org/code/3596710xxxxxx/state/brands-to-be-completed |
| + | **Brand-Prefix matching at https://en.wiki.openfoodfacts.org/Global_brands_and_companies_taxonomy/Barcodes |
| + | *Products with a wrong barcode |
| + | **https://fr.openfoodfacts.org/cgi/search.pl?search_terms=code+barre&search_simple=1 |
| + | |
| + | === International Products === |
| + | * [https://www.dm.de/ dm] products |
| + | **with main language <> 'de' |
| + | ***https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=lang&tag_contains_0=does_not_contain&tag_0=de&tagtype_1=brands&tag_contains_1=contains&tag_1=dm&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| + | **without selling country 'de' |
| + | ***https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=countries&tag_contains_0=does_not_contain&tag_0=de&tagtype_1=brands&tag_contains_1=contains&tag_1=dm&sort_by=unique_scans_n&page_size=20&axis_x=energy&axis_y=products_n&action=display |
| + | |
| == 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 80: |
Line 181: |
| **- Dernière modification = Avant le 31 juin 2012 inclus | | **- Dernière modification = Avant le 31 juin 2012 inclus |
| **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 | + | **https://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)
| + | =To be sorted= |
− | ** 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 ==
| |
− | * How much alcohol do Belgian beers contain ?
| |
− | ** http://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=beer&tagtype_1=origins&tag_contains_1=contains&tag_1=Belgique&sort_by=unique_scans_n&page_size=1000&axis_x=alcohol&axis_y=products_n&graph=1
| |
− | ==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 | + | **https://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 |