Final energy consumption households per capita

Data table via SPARQL Published 24 Nov 2017 Last modified 24 Nov 2017
39 min read
This is an old version, kept for reference only.

Go to latest version
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date ugeo index demo_gind tsdpc320
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Turkey" "257.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "78218479"^^<http://www.w3.org/2001/XMLSchema#decimal> "20141"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Italy" "585.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "57969484"^^<http://www.w3.org/2001/XMLSchema#decimal> "33922"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "721.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "11274196"^^<http://www.w3.org/2001/XMLSchema#decimal> "8136"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Denmark" "748.5"^^<http://www.w3.org/2001/XMLSchema#decimal> "5683483"^^<http://www.w3.org/2001/XMLSchema#decimal> "4254"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Czech Republic" "651.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "10211216"^^<http://www.w3.org/2001/XMLSchema#decimal> "6649"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Kosovo (under United Nations Security Council Resolution 1244/99)" "166.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "2070500"^^<http://www.w3.org/2001/XMLSchema#decimal> "345"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Norway" "747.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "5190239"^^<http://www.w3.org/2001/XMLSchema#decimal> "3881"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2015"^^<http://www.w3.org/2001/XMLSchema#int> "Albania" "184.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "2889164"^^<http://www.w3.org/2001/XMLSchema#decimal> "532"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "France" "683.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "63001253"^^<http://www.w3.org/2001/XMLSchema#decimal> "43070"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Bulgaria" "276.4"^^<http://www.w3.org/2001/XMLSchema#decimal> "7658972"^^<http://www.w3.org/2001/XMLSchema#decimal> "2117"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 77 rows in 0.005 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/final-energy-consumption-households-per-capita/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 skos: <http://www.w3.org/2004/02/skos/core#> 
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX indic_de: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_de/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>

SELECT 
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
round((sum(?tsdpc320)*1000.0)/sum(?demo_gind)*10000.0)/10.0 as ?index
sum(?demo_gind) as ?demo_gind
sum(?tsdpc320) as ?tsdpc320
WHERE {
{

  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_gind.rdf.gz> 
    {
    _:demo_gind sdmx-dimension:timePeriod ?date .
    _:demo_gind sdmx-dimension:refArea ?geo .
    _:demo_gind property:indic_de indic_de:AVG .
    _:demo_gind sdmx-measure:obsValue ?demo_gind .
    }
} UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tsdpc320.rdf.gz>
    {
    _:tsdpc320 sdmx-dimension:timePeriod ?date .
    _:tsdpc320 property:indic_nrg indic_nrg:B_102010 .
    _:tsdpc320 sdmx-dimension:refArea ?geo .
    _:tsdpc320 property:product product:0000 .
    _:tsdpc320 sdmx-attribute:unitMeasure unit:KTOE .
    _:tsdpc320 sdmx-measure:obsValue ?tsdpc320 .
    } 
 } 
?geo rdfs:label ?ugeo .
FILTER (year(?date) in (2005, 2015))
} GROUP BY year(?date) ?geo ?ugeo
HAVING (sum(?tsdpc320)/sum(?demo_gind) > 0)


Related content

Temporal coverage

Document Actions
Filed under: