Consumer prices for different food types, EU-27, 2001-2012

Data table via SPARQL Published 31 Jul 2014 Last modified 20 Apr 2016

Download this dataset

Dataset preview

(Live Query)

date category obsValue obsValue_idx index
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "95.45"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "103"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "97.55"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "105"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "99.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "107"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "100"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "108"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "101.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "109"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "105.59"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "114"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "117.48"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "127"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "115.46"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "124"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int> "Milk, cheese and eggs" "115.23"^^<http://www.w3.org/2001/XMLSchema#decimal> "92.78"^^<http://www.w3.org/2001/XMLSchema#decimal> "124"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 91 rows in 0.004 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/consumer-prices-for-different-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



semantic.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX qb: <http://purl.org/linked-data/cube#> 
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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX coicop: <http://rdfdata.eionet.europa.eu/eurostat/dic/coicop#>
PREFIX infotype: <http://rdfdata.eionet.europa.eu/eurostat/dic/infotype#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>

SELECT DISTINCT
year(?date) as ?date
?category
?obsValue
?obsValue_idx
round((?obsValue/?obsValue_idx)*100) as ?index
WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/prc_hicp_aind.rdf.gz> 
  {
    _:prc_hicp_aind sdmx-dimension:timePeriod ?date . FILTER (year(?date) >= 2001)
    _:prc_hicp_aind property:infotype infotype:AVX . 
    _:prc_hicp_aind sdmx-dimension:refArea geo:EU27 . 
    _:prc_hicp_aind property:coicop ?coicop .
    _:prc_hicp_aind sdmx-measure:obsValue ?obsValue .

    _:prc_hicp_aind_idx sdmx-dimension:timePeriod ?date_idx . FILTER (year(?date_idx) = 2001)
    _:prc_hicp_aind_idx property:infotype infotype:AVX . 
    _:prc_hicp_aind_idx sdmx-dimension:refArea geo:EU27 . 
    _:prc_hicp_aind_idx property:coicop ?coicop . 
    _:prc_hicp_aind_idx sdmx-measure:obsValue ?obsValue_idx .
 
    FILTER (?coicop in (coicop:CP00, coicop:CP01, coicop:CP011, coicop:CP0111, coicop:CP0112, coicop:CP0113, coicop:CP0114))
  } 
  ?geo skos:notation ?ugeo .
  ?coicop rdfs:label ?category .
 }
}


Related content

Document Actions