User:YULdigitalpreservation/nutritionInfo

Let's get more nutrition information in Wikidata

SPARQL Queries

Items with USDA NDB id

The following query uses these:

• Properties: USDA NDB number (P1978)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P1978 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Items with a OpenFoodFacts ingredient id

The following query uses these:

• Properties: Open Food Facts ingredient ID (P5930)   

  SELECT ?item ?itemLabel ?value
  {
  	?item wdt:P5930 ?value .
  	SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
  }
  

Try it!

Items with a CIQUAL2017 id

The following query uses these:

• Properties: CIQUAL2017 ID (P4696)   

  SELECT ?item ?itemLabel ?value
  WHERE 
  {
    ?item wdt:P4696 ?value .
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Databases about food/nutrition and their license info

The following query uses these:

• Items: database (Q8513)   , food (Q2095)   , chemical substance (Q79529)   , nutrition facts label (Q1531970)   , nutrition (Q2138622)   

• Properties: instance of (P31)   , main subject (P921)   , copyright license (P275)   

  SELECT ?item ?itemLabel ?subjectLabel ?licenseLabel
  WHERE 
  {
    ?item wdt:P31 wd:Q8513.
    ?item wdt:P921 ?subject.
    VALUES ?subject {wd:Q2095 wd:Q79529 wd:Q1531970 wd:Q2138622}
    OPTIONAL {?item wdt:P275 ?license}.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Things listed subclass of vegetable

The following query uses these:

• Items: vegetable (Q11004)   

• Properties: subclass of (P279)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P279 wd:Q11004.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Scholarly articles with 'food composition' as a main subject

The following query uses these:

• Items: academic journal article (Q18918145)   , food composition (Q5465452)   

• Properties: instance of (P31)   , main subject (P921)   

  SELECT ?item ?itemLabel 
  WHERE 
  {
    ?item wdt:P31 wd:Q18918145.
    ?item wdt:P921 wd:Q5465452.
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }
  

Try it!

Properties

• food energy (P7971)
• AUSNUT 2011–13 Food Group ID (P4618) AUSNUT 2011–13 Food Group ID identifier of a food group in AUSNUT 2011–13 (AUStralian Food and NUTrient Database) external-id
• AUSNUT food ID (P2759) AUSNUT food ID identifier of a food in the Australian Food, Supplement and Nutrient Database (AUSNUT) managed by Food Standards Australia New Zealand (FSANZ) external-id AUSNUT ID AUSNUT Food Identifier
• NUTTAB food ID (P2760) NUTTAB food ID Identifier of a food within the Nutrient Tables for use in Australia (NUTTAB) which is managed by Food Standards Australia New Zealand (FSANZ) external-id NUTTAB ID NUTTAB Food Identifier
• USDA NDB number (P1978) USDA NDB number identifier for a food item in the United States Department of Agriculture National Nutrient Database external-id NDB number
• CIQUAL2017 ID (P4696) CIQUAL2017 ID identifier for a food category in the French CIQUAL 2017 nutritional database
• FoodOn ID (P6767) FoodOn ID identifier for FoodOn, an ontology focused on categorization and processing of food for humans
• foods traditionally associated (P868) foods traditionally associated foods usually during the ceremony or associated with a certain settlement
• INRAN Italian Food ID (P4729) INRAN Italian Food ID identifier in the Italian national nutriment database
• Open Food Facts food additive ID (P1820) Open Food Facts food additive id represents a food additive on Open Food Facts
• Open Food Facts food category ID (P1821) Open Food Facts food category ID represents a food category on Open Food Facts
• Open Food Facts ingredient ID (P5930) Open Food Facts ingredient ID identifier of a food ingredient on Open Food Facts

External Databases

• World Nutrient Databases for Dietary Studies
• Foodb (Q16800711)