Data table via SPARQL

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

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

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

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.003 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/consumer-prices-for-different-food/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
semantic.eea.europa.eu/sparql

SPARQL Query:


        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 .
 }
}