next
previous
items

Data table via SPARQL

Cereals Excluding Beer Total - Livestock and Fish Primary Equivalent dataset

Data table via SPARQL Published 09 Mar 2017 Last modified 10 Mar 2017

Download this dataset

Dataset preview

(Live Query)

year item capita index foodvalue popvalue
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "118.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "57418520"^^<http://www.w3.org/2001/XMLSchema#decimal> "483502"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "119.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "100.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "57756924"^^<http://www.w3.org/2001/XMLSchema#decimal> "484263"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "118.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "99.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "57318956"^^<http://www.w3.org/2001/XMLSchema#decimal> "484793"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "121.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "58875724"^^<http://www.w3.org/2001/XMLSchema#decimal> "485240"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "121.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "59086056"^^<http://www.w3.org/2001/XMLSchema#decimal> "485810"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "122"^^<http://www.w3.org/2001/XMLSchema#decimal> "102.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "59391680"^^<http://www.w3.org/2001/XMLSchema#decimal> "486650"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "124.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "60528668"^^<http://www.w3.org/2001/XMLSchema#decimal> "487802"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "126.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "106.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "61779420"^^<http://www.w3.org/2001/XMLSchema#decimal> "489213"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "124.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "61046708"^^<http://www.w3.org/2001/XMLSchema#decimal> "490822"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Cereals - Excluding Beer" "124.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.8"^^<http://www.w3.org/2001/XMLSchema#decimal> "61276216"^^<http://www.w3.org/2001/XMLSchema#decimal> "492525"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 19 rows in 0.001 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/cereals-excluding-beer-total-livestock-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
?date as ?year
sql:GROUP_CONCAT(?item, '') as ?item
(round(sum(?foodvalue)/sum(?popvalue)*10))/10.0 as ?capita
(round(( sum(?foodvalue)/sum(?popvalue) ) / (sum(?foodvalue_idx)/sum(?popvalue_idx) ) *1000))/10.0 as ?index
sum(?foodvalue) as ?foodvalue
sum(?popvalue) as ?popvalue

WHERE {
    {
   GRAPH <http://r.eionet.europa.eu/rdfdumps/faostat/foodsupply_crops_e.rdf.gz> {
   {
     _:foodsupply_crop_e sdmx-dimension:refArea 5706 .
     _:foodsupply_crop_e faostat:item_code 2905 . 
     _:foodsupply_crop_e faostat:item ?item .
     _:foodsupply_crop_e faostat:element_code 641 .
     _:foodsupply_crop_e sdmx-dimension:timePeriod ?date . 
     FILTER (?date >= 1995)
     _:foodsupply_crop_e faostat:unit 'tonnes' . 
     _:foodsupply_crop_e sdmx-measure:obsValue ?foodvalue .

     _:foodsupply_crop_e_idx sdmx-dimension:refArea 5706 .
     _:foodsupply_crop_e_idx faostat:item_code 2905 . 
     _:foodsupply_crop_e_idx faostat:element_code 641 .
     _:foodsupply_crop_e_idx sdmx-dimension:timePeriod 1995 . 
     _:foodsupply_crop_e_idx faostat:unit 'tonnes' . 
     _:foodsupply_crop_e_idx sdmx-measure:obsValue ?foodvalue_idx .
   }}
    } UNION {
    GRAPH <http://r.eionet.europa.eu/rdfdumps/faostat/population_e.rdf.gz> {
     _:population_e sdmx-dimension:refArea 5706 .
     _:population_e faostat:element_code 511 .
     _:population_e sdmx-dimension:timePeriod ?date . 
     FILTER (?date >= 1995)
     _:population_e sdmx-measure:obsValue ?popvalue .
     _:population_e_idx sdmx-dimension:refArea 5706 .
     _:population_e_idx faostat:element_code 511 .
     _:population_e_idx sdmx-dimension:timePeriod 1995 . 
     _:population_e_idx sdmx-measure:obsValue ?popvalue_idx .
    }
  }
}
GROUP BY ?date
HAVING sum(?foodvalue) > 0
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

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