next
previous
items

Data table via SPARQL

Consumption of food in EU28

Data table via SPARQL Published 28 Nov 2016 Last modified 26 Aug 2017
This is an old version, kept for reference only.

Go to latest version
This page was archived on 26 Aug 2017 with reason: A new version has been published

Download this dataset

Dataset preview

(Live Query)

date itemCode item elementCode element unit value
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "2731"^^<http://www.w3.org/2001/XMLSchema#int> "Bovine Meat" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "17.98"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "2731"^^<http://www.w3.org/2001/XMLSchema#int> "Bovine Meat" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "15.66"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "2731"^^<http://www.w3.org/2001/XMLSchema#int> "Bovine Meat" "674"^^<http://www.w3.org/2001/XMLSchema#int> "Protein supply quantity" "kg/capita/yr" "2.53"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "2731"^^<http://www.w3.org/2001/XMLSchema#int> "Bovine Meat" "674"^^<http://www.w3.org/2001/XMLSchema#int> "Protein supply quantity" "kg/capita/yr" "2.19"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "2740"^^<http://www.w3.org/2001/XMLSchema#int> "Butter, Ghee" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "4.03"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "2740"^^<http://www.w3.org/2001/XMLSchema#int> "Butter, Ghee" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "3.67"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "2740"^^<http://www.w3.org/2001/XMLSchema#int> "Butter, Ghee" "674"^^<http://www.w3.org/2001/XMLSchema#int> "Protein supply quantity" "kg/capita/yr" "0.04"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "2740"^^<http://www.w3.org/2001/XMLSchema#int> "Butter, Ghee" "674"^^<http://www.w3.org/2001/XMLSchema#int> "Protein supply quantity" "kg/capita/yr" "0.03"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "2741"^^<http://www.w3.org/2001/XMLSchema#int> "Cheese" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "13.31"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int> "2741"^^<http://www.w3.org/2001/XMLSchema#int> "Cheese" "645"^^<http://www.w3.org/2001/XMLSchema#int> "Food supply quantity" "kg/capita/yr" "17.09"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 52 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/consumption-of-food/daviz.json

For system integrators

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org



http://semantic.eea.europa.eu/sparql

PREFIX tableFile: <http://semantic.eea.europa.eu/project/faostat/2016/foodsupply_livestockfish_e.csv#>

SELECT DISTINCT
year(?date) as ?date
?itemCode
?item
?elementCode
bif:either(?elementCode = 674, 'Protein supply quantity', 'Food supply quantity') as ?element
#?element
'kg/capita/yr' as ?unit
#0.375 converts g/capita/day to kg/capita/yr
bif:either(?elementCode = 674, round(sum(xsd:decimal(?value)) *0.365*100)/100.0, sum(xsd:decimal(?value)) ) as ?value

WHERE {
    GRAPH <http://semantic.eea.europa.eu/project/faostat/2016/foodsupply_livestockfish_e.csv> {
    {
      _:foodsupply_livestockfish_e tableFile:countryCode ?countryCode .
      _:foodsupply_livestockfish_e tableFile:country ?country .
      {
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCode .
        FILTER (?itemCode in (2731, 2738, 2741, 2733, 2743, 2732, 
                             2731, 2734, 2761, 2762, 2740, 2763))
        _:foodsupply_livestockfish_e tableFile:item ?item .
 
      } UNION {
        { SELECT 'Meat, other + edible offals' as ?item {} }
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCodeDummy .
        FILTER (?itemCodeDummy in ( 2763, 2735 ))

      } UNION {
        { SELECT 'Other fish and seafood' as ?item {} }
        _:foodsupply_livestockfish_e tableFile:itemCode ?itemCodeDummy .
        FILTER (?itemCodeDummy in (2767, 2764, 2766, 2765))
      }
     
      _:foodsupply_livestockfish_e tableFile:elementCode ?elementCode .
      FILTER (?elementCode in (674, 645))

      _:foodsupply_livestockfish_e tableFile:element ?element .
      _:foodsupply_livestockfish_e tableFile:unit ?unit .
      _:foodsupply_livestockfish_e tableFile:date ?date . 
      FILTER (year(?date) in (1995, 2011))
      _:foodsupply_livestockfish_e tableFile:value ?value .
    }
    FILTER (?countryCode = 5706)
  }
}


Permalinks

Document Actions