next
previous
items

Data table via SPARQL

Milk Excluding Butter - Livestock and Fish Primary Equivalent dataset

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

Download this dataset

Dataset preview

(Live Query)

year item capita index
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.15"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.29"^^<http://www.w3.org/2001/XMLSchema#decimal> "101.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.42"^^<http://www.w3.org/2001/XMLSchema#decimal> "103.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.38"^^<http://www.w3.org/2001/XMLSchema#decimal> "103.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "105.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.42"^^<http://www.w3.org/2001/XMLSchema#decimal> "103.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Milk - Excluding Butter" "7.47"^^<http://www.w3.org/2001/XMLSchema#decimal> "104.5"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 14 rows in 0.033 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/milk-excluding-butter-livestock-and-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(xsd:double(?foodvalue))*365/10)/100.0 as ?foodvalue as ?capita
round(sum(xsd:double(?foodvalue))/sum(xsd:double(?foodvalue_idx))*1000)/10.0 as ?index

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 5706 .
     _:foodsupply_livestockfish_e faostat:item_code 2848 .
     _:foodsupply_livestockfish_e faostat:item ?item .
     _:foodsupply_livestockfish_e faostat:element 'Protein supply quantity (g/capita/day)' .
     _:foodsupply_livestockfish_e sdmx-dimension:timePeriod ?date . 
     FILTER (?date >= 2000)
     _:foodsupply_livestockfish_e sdmx-measure:obsValue ?foodvalue .

     _:foodsupply_livestockfish_e_idx faostat:area ?area .
     _:foodsupply_livestockfish_e_idx sdmx-dimension:refArea 5706 .
     _:foodsupply_livestockfish_e_idx faostat:item_code 2848 .
     _:foodsupply_livestockfish_e_idx faostat:item ?item .
     _:foodsupply_livestockfish_e_idx faostat:element 'Protein supply quantity (g/capita/day)' .
     _:foodsupply_livestockfish_e_idx sdmx-dimension:timePeriod 2000 . 
     _:foodsupply_livestockfish_e_idx sdmx-measure:obsValue ?foodvalue_idx .
   }}
  }
}
GROUP BY ?date
HAVING sum(?foodvalue) > 0
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

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