next
previous
items

Data table via SPARQL

Consumption of food in EU28

Data table via SPARQL Published 09 Mar 2017 Last modified 20 Jun 2017

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" "18"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<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.6"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<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.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<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.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<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" "16.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<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.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<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" "16.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<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" "16.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<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"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<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.1"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 532 rows in 0.072 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/consumption-of-food-1/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 sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#> 
PREFIX faostat: <http://reference.eionet.europa.eu/faostat/schema/>

SELECT DISTINCT
?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*10)/10.0, round(sum(xsd:decimal(?value))*10)/10.0 ) as ?value
WHERE {
    GRAPH <http://r.eionet.europa.eu/rdfdumps/faostat/foodsupply_livestockfish_e.rdf.gz> {
    {
      _:foodsupply_livestockfish_e faostat:area ?area .
      _:foodsupply_livestockfish_e sdmx-dimension:refArea ?refArea .
      {
        _:foodsupply_livestockfish_e faostat:item_code ?itemCode .
        FILTER (?itemCode in (2731, 2738, 2741, 2733, 2743, 2732, 
                              2731, 2734, 2761, 2762, 2740, 2763, 2744))
        _:foodsupply_livestockfish_e faostat:item ?item .
      } UNION {
        { SELECT 'Meat, other + edible offals' as ?item {} }
        _:foodsupply_livestockfish_e faostat:item_code ?itemCodeDummy .
        FILTER (?itemCodeDummy in ( 2763, 2735 ))

      } UNION {
        { SELECT 'Other fish and seafood' as ?item {} }
        _:foodsupply_livestockfish_e faostat:item_code ?itemCodeDummy .
        FILTER (?itemCodeDummy in (2767, 2764, 2766, 2765))
      }

      _:foodsupply_livestockfish_e faostat:element_code ?elementCode .
      FILTER (?elementCode in (674, 645))
 
      _:foodsupply_livestockfish_e faostat:element ?element .
      _:foodsupply_livestockfish_e faostat:unit ?unit .
      _:foodsupply_livestockfish_e sdmx-dimension:timePeriod ?date . 
      FILTER (?date >= 1995)
      _:foodsupply_livestockfish_e sdmx-measure:obsValue ?value .
    }

  }
  FILTER (?refArea = 5706)
}


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: food consumption, meat
Document Actions