Difference between revisions of "Quality/Category Monitoring"

From Open Food Facts wiki
Jump to navigation Jump to search
(Created page with "This page lists categories that have been cleaned up and can be monitored regularly in order to find outliers: {| class="wikitable" |+Categories that can be monitored !categor...")
 
 
(25 intermediate revisions by one other user not shown)
Line 2: Line 2:
 
{| class="wikitable"
 
{| class="wikitable"
 
|+Categories that can be monitored
 
|+Categories that can be monitored
!category
+
!wiki description
!mirabelle
+
!products in category
 +
!mirabelle check
 
!last check
 
!last check
 
|-
 
|-
 +
|[[Category/Apple juices|apple juices]]
 
|[https://world.openfoodfacts.org/category/apple-juices apple juices]
 
|[https://world.openfoodfacts.org/category/apple-juices apple juices]
 
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+apple+juices+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aapple-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+300.01%0D%0A++++or+energy_100g+%3C+63%0D%0A++++or+fat_100g+%3E+1.01%0D%0A++++or+carbohydrates_100g+%3C+0.75%0D%0A++++or+carbohydrates_100g+%3E+20.71%0D%0A++++or+sugars_100g+%3C+0.69%0D%0A++++or+sugars_100g+%3E+16.71%0D%0A++++or+proteins_100g+%3E+1.01%0D%0A++++or+salt_100g+%3E+0.51%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+apple+juices+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aapple-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+300.01%0D%0A++++or+energy_100g+%3C+63%0D%0A++++or+fat_100g+%3E+1.01%0D%0A++++or+carbohydrates_100g+%3C+0.75%0D%0A++++or+carbohydrates_100g+%3E+20.71%0D%0A++++or+sugars_100g+%3C+0.69%0D%0A++++or+sugars_100g+%3E+16.71%0D%0A++++or+proteins_100g+%3E+1.01%0D%0A++++or+salt_100g+%3E+0.51%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 
|2023-06-06
 
|2023-06-06
 
|-
 
|-
|[https://world.openfoodfacts.org/category/olive-oils/ olive oils]
+
|[[Category/Apple nectars|apple nectars]]
|
+
|[https://world.openfoodfacts.org/category/apple-nectars link]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+apple+nectar+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aapple-nectars%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+261%0D%0A++++or+energy_100g+%3C+58%0D%0A++++or+fat_100g+%3E+0.51%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.51%0D%0A++++or+carbohydrates_100g+%3C+3.19%0D%0A++++or+carbohydrates_100g+%3E+15.1%0D%0A++++or+sugars_100g+%3C+3.0%0D%0A++++or+sugars_100g+%3E+14.6%0D%0A++++or+proteins_100g+%3E+0.61%0D%0A++++or+salt_100g+%3E+0.51%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-06
 +
|-
 +
|[[Category/Apricot nectars#Nutritional information|apricot nectars]]
 +
|[https://world.openfoodfacts.org/category/apricot-nectars/ link]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+apricot+nectar+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aapricot-nectars%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+354.1%0D%0A++++or+energy_100g+%3C+72.9%0D%0A++++or+fat_100g+%3E+0.81%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.51%0D%0A++++or+carbohydrates_100g+%3C+3.79%0D%0A++++or+carbohydrates_100g+%3E+19.1%0D%0A++++or+sugars_100g+%3C+3.79%0D%0A++++or+sugars_100g+%3E+19.1%0D%0A++++or+fiber_100g+%3E+2.01%0D%0A++++or+proteins_100g+%3E+0.81%0D%0A++++or+salt_100g+%3E+0.51%0D%0A++%29%0D%0Alimit%0D%0A++20&apricot= link]
 +
|2023-06-08
 +
|-
 +
|[[Category/Blueberry juices|blueberry juices]]
 +
|[https://world.openfoodfacts.org/category/blueberry-juices blueberry juices]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+blueberry+juices+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Ablueberry-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3C+120%0D%0A++++or+energy_100g+%3E+240%0D%0A++++or+fat_100g+%3E+0.51%0D%0A++++or+carbohydrates_100g+%3C+5.6%0D%0A++++or+carbohydrates_100g+%3E+13.1%0D%0A++++or+sugars_100g+%3C+4.0%0D%0A++++or+sugars_100g+%3E+11.1%0D%0A++++or+proteins_100g+%3E+0.8%0D%0A++++or+salt_100g+%3E+0.03%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-06
 +
|-
 +
|[[Category/Blueberry nectars#Production process.2Flabels|blueberry nectars]]
 +
|[https://world.openfoodfacts.org/category/blueberry-nectars link]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+blueberry+nectar+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Ablueberry-nectars%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+351.1%0D%0A++++or+energy_100g+%3C+52.9%0D%0A++++or+fat_100g+%3E+0.61%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.21%0D%0A++++or+carbohydrates_100g+%3C+5.59%0D%0A++++or+carbohydrates_100g+%3E+20.31%0D%0A++++or+sugars_100g+%3C+4.79%0D%0A++++or+sugars_100g+%3E+20.31%0D%0A++++or+fiber_100g+%3E+2.31%0D%0A++++or+proteins_100g+%3E+0.71%0D%0A++++or+salt_100g+%3E+0.11%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-07
 +
|-
 +
|[[Category/Canned peas and carrots|canned peas and carrots]]
 +
|[https://world.openfoodfacts.org/category/canned-peas-and-carrots link]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+canned+peas+and+carrots+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Acanned-peas-and-carrots%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+398%0D%0A++++or+energy_100g+%3C+117%0D%0A++++or+fat_100g+%3E+1.0%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.5%0D%0A++++or+carbohydrates_100g+%3C+3.33%0D%0A++++or+carbohydrates_100g+%3E+16.3%0D%0A++++or+sugars_100g+%3E+5.8%0D%0A++++or+fiber_100g+%3C+0.769%0D%0A++++or+fiber_100g+%3E+8.0%0D%0A++++or+proteins_100g+%3C+0.769%0D%0A++++or+proteins_100g+%3E+4.76%0D%0A++++or+salt_100g+%3E+1.1%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-30
 +
|-
 +
|[[Category/Grape juices|grape juices]]
 +
|grape juices
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+grape+juices+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Agrape-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3C+170%0D%0A++++or+energy_100g+%3E+445%0D%0A++++or+fat_100g+%3E+0.51%0D%0A++++or+carbohydrates_100g+%3C+6.2%0D%0A++++or+carbohydrates_100g+%3E+26.1%0D%0A++++or+sugars_100g+%3C+5.1%0D%0A++++or+sugars_100g+%3E+26.1%0D%0A++++or+proteins_100g+%3E+1.01%0D%0A++++or+salt_100g+%3E+0.2%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 
|2023-06-06
 
|2023-06-06
 
|-
 
|-
 +
|[[Category/Lime juices|lime juices]]
 
|
 
|
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+lime+juice+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Alime-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+151%0D%0A++++or+fat_100g+%3E+0.81%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.11%0D%0A++++or+carbohydrates_100g+%3E+9%0D%0A++++or+sugars_100g+%3E+3.4%0D%0A++++or+fiber_100g+%3E+0.5%0D%0A++++or+proteins_100g+%3E+0.51%0D%0A++++or+salt_100g+%3E+0.26%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-09
 +
|-
 +
|[[Category/Mango nectars|mango nectars]]
 +
|link
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+mango+nectar+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aapricot-nectars%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+294%0D%0A++++or+energy_100g+%3C+57%0D%0A++++or+fat_100g+%3E+0.51%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+0.51%0D%0A++++or+carbohydrates_100g+%3C+3.31%0D%0A++++or+carbohydrates_100g+%3E+18.1%0D%0A++++or+sugars_100g+%3C+2.99%0D%0A++++or+sugars_100g+%3E+16.1%0D%0A++++or+fiber_100g+%3E+1.81%0D%0A++++or+proteins_100g+%3E+1.01%0D%0A++++or+salt_100g+%3E+0.11%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-09
 +
|-
 +
|[[Category/Millet|millet]]
 
|
 
|
|
+
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+millet+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Amillet%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+1630%0D%0A++++or+energy_100g+%3C+1370%0D%0A++++or+fat_100g+%3E+4.71%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+1.2%0D%0A++++or+carbohydrates_100g+%3C+43.7%0D%0A++++or+carbohydrates_100g+%3E+81.2%0D%0A++++or+sugars_100g+%3E+4.9%0D%0A++++or+fiber_100g+%3C+1.39%0D%0A++++or+fiber_100g+%3E+16.0%0D%0A++++or+proteins_100g+%3C+8.59%0D%0A++++or+proteins_100g+%3E+12.0%0D%0A++++or+salt_100g+%3E+0.17%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-22
 +
|-
 +
|[[Category/Olive oils|olive oils]]
 +
|[https://world.openfoodfacts.org/category/olive-oils/ olive oils]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+olive+oil+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aolive-oils%25%22%0D%0A++and+%28%0D%0A++++categories_tags+like+%22%25sprays%25%22%0D%0A++++or+energy_100g+%3E+4180.0%0D%0A++++or+energy_100g+%3C+3280.0%0D%0A++++or+fat_100g+%3E+100.0%0D%0A++++or+fat_100g+%3C+85.7%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+26.0%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3C+5.0%0D%0A++++or+carbohydrates_100g+%3E+0.5%0D%0A++++or+sugars_100g+%3E+0.5%0D%0A++++or+proteins_100g+%3E+0.5%0D%0A++++or+salt_100g+%3E+0.6%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2024-01-01
 +
|-
 +
|[[Category/Orange juices|orange juices]]
 +
|[https://world.openfoodfacts.org/category/orange-juices link]
 +
|[https://mirabelle.openfoodfacts.org/products?sql=--+list+of+orange+juice+products+that+fall+outside+quality+envelope%0D%0Aselect%0D%0A++code%2C%0D%0A++url%0D%0Afrom%0D%0A++%5Ball%5D%0D%0Awhere%0D%0A++categories_tags+like+%22%25en%3Aorange-juices%25%22%0D%0A++and+%28%0D%0A++++energy_100g+%3E+306%0D%0A++++or+energy_100g+%3C+74%0D%0A++++or+fat_100g+%3E+1.01%0D%0A++++or+%5Bsaturated-fat_100g%5D+%3E+1.01%0D%0A++++or+carbohydrates_100g+%3C+3.5%0D%0A++++or+carbohydrates_100g+%3E+15.6%0D%0A++++or+sugars_100g+%3C+3.5%0D%0A++++or+sugars_100g+%3E+15.3%0D%0A++++or+fiber_100g+%3E+2.71%0D%0A++++or+proteins_100g+%3E+1.91%0D%0A++++or+salt_100g+%3E+0.51%0D%0A++++or+potassium_100g+%3C+0.056%0D%0A++++or+potassium_100g+%3E+0.243%0D%0A++++or+%5Bvitamin-c_100g%5D+%3C+0.7%0D%0A++++or+%5Bvitamin-c_100g%5D+%3E+81%0D%0A++++or+%5Bnutrition-score-fr_100g%5D+%3C+-3%0D%0A++++or+%5Bnutrition-score-fr_100g%5D+%3E+18%0D%0A++%29%0D%0Alimit%0D%0A++20 link]
 +
|2023-06-10
 
|}
 
|}
 +
 +
[[Category:Global_Taxonomies]]
 +
[[Category:Data quality]]
 +
[[Category:Category analysis]]

Latest revision as of 10:39, 7 August 2024

This page lists categories that have been cleaned up and can be monitored regularly in order to find outliers:

Categories that can be monitored
wiki description products in category mirabelle check last check
apple juices apple juices link 2023-06-06
apple nectars link link 2023-06-06
apricot nectars link link 2023-06-08
blueberry juices blueberry juices link 2023-06-06
blueberry nectars link link 2023-06-07
canned peas and carrots link link 2023-06-30
grape juices grape juices link 2023-06-06
lime juices link 2023-06-09
mango nectars link link 2023-06-09
millet link 2023-06-22
olive oils olive oils link 2024-01-01
orange juices link link 2023-06-10