Quality/Category Monitoring: Difference between revisions

From Open Food Facts wiki
No edit summary
No edit summary
 
(19 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
!wiki
!wiki description
!category
!products in category
!mirabelle
!mirabelle check
!last check
!last check
|-
|-
Line 16: Line 16:
|[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]
|[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
|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]]
|[[Category/Blueberry juices|blueberry juices]]
Line 21: Line 26:
|[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]
|[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
|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]]
|[[Category/Grape juices|grape juices]]
Line 26: Line 41:
|[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]
|[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]]
|[[Category/Olive oils|olive oils]]
|[https://world.openfoodfacts.org/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%0D%0A++++or+energy_100g+%3C+3280%0D%0A++++or+fat_100g+%3E+100%0D%0A++++or+fat_100g+%3C+85.7%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&olive= link]
|[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]
|2023-06-06
|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