Data table via SPARQL
BG EL MK NO EU27 Spending on electrical and electronic goods as a proportion of total household expenditure, 1996 and 2011
Download this dataset
Dataset preview
(Live Query)
Received 5 rows in 0.001 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/bg-el-mk-no-eu27-spending-on-electrical-and/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.
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 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 unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
SELECT DISTINCT
?ugeo
sum(xsd:decimal(?1996)) as ?1996
#no data for 2012 -> 2011
sum(xsd:decimal(?2011)) as ?2012
WHERE {
{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_co3_c.rdf.gz>
{
_:nama_co3_c sdmx-dimension:refArea ?geo .
_:nama_co3_c property:coicop ?coicop . FILTER (?coicop in (coicop:CP053, coicop:CP082, coicop:CP091))
_:nama_co3_c sdmx-attribute:unitMeasure unit:PC_TOT .
{
_:nama_co3_c sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 1996)
_:nama_co3_c sdmx-measure:obsValue ?1996 .
} UNION {
_:nama_co3_c sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2011)
_:nama_co3_c sdmx-measure:obsValue ?2011 .
}
}
?geo rdfs:label ?ugeo . FILTER (?geo in (geo:EL, geo:EU27, geo:MK, geo:BG, geo:NO))
}
}
GROUP BY ?ugeo
Permalinks
- Permalink to this version
- 54279cb00f2f4bb797e7b9c4609d5d75
- Permalink to latest version
- GDY8KXPS7H
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/bg-el-mk-no-eu27-spending-on-electrical-and or scan the QR code.
PDF generated on 29 May 2022, 04:13 AM
Document Actions
Share with others