Data table via SPARQL
Spending on electrical and electronic goods as a proportion of total household expenditure, 1996 and 2012
Download this dataset
Dataset preview
(Live Query)
Received 33 rows in 0.050 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/spending-on-electrical-and-electronic/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
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
sum(xsd:decimal(?1996)) as ?1996
sum(xsd:decimal(?2012)) 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) = 2012)
_:nama_co3_c sdmx-measure:obsValue ?2012 .
}
}
?geo rdfs:label ?ugeo . FILTER (?geo != geo:EU27 and ?geo != geo:EL and ?geo != geo:RO and ?geo != geo:LT and ?geo != geo:MK and ?geo != geo:BG and ?geo != geo:NO)
}
}
GROUP BY ?geo ?ugeo
Permalinks
- Permalink to this version
- 208e4818430547eb826edc8a43684bf1
- Permalink to latest version
- QS8Y5F9XGR
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/spending-on-electrical-and-electronic or scan the QR code.
PDF generated on 13 Aug 2022, 05:43 AM
Document Actions
Share with others