EMAS electricity

Data table via SPARQL Published 20 Feb 2018 Last modified 06 Jun 2019
34 min read
Topics: ,

Download this dataset

Dataset preview

(Live Query)

meter metercode appliance floor fte obsValue obsvaluefte unit month year date area
"3.9 m\u00e5ler 3 - ventilation" "99994"^^<http://www.w3.org/2001/XMLSchema#int> "Server cooling" "3" "196"^^<http://www.w3.org/2001/XMLSchema#int> "-8168"^^<http://www.w3.org/2001/XMLSchema#decimal> "-41.67346938775510204081"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "2"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016-02-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "212"^^<http://www.w3.org/2001/XMLSchema#int> "-4602"^^<http://www.w3.org/2001/XMLSchema#decimal> "-21.70754716981132075471"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "2013-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"3.9 m\u00e5ler 3 - ventilation" "99994"^^<http://www.w3.org/2001/XMLSchema#int> "Server cooling" "3" "211"^^<http://www.w3.org/2001/XMLSchema#int> "-2673"^^<http://www.w3.org/2001/XMLSchema#decimal> "-12.66824644549763033175"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "8"^^<http://www.w3.org/2001/XMLSchema#int> "2018"^^<http://www.w3.org/2001/XMLSchema#int> "2018-08-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "212"^^<http://www.w3.org/2001/XMLSchema#int> "-1677"^^<http://www.w3.org/2001/XMLSchema#decimal> "-7.91037735849056603773"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "7"^^<http://www.w3.org/2001/XMLSchema#int> "2013"^^<http://www.w3.org/2001/XMLSchema#int> "2013-07-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"3.9 m\u00e5ler 3 - ventilation" "99994"^^<http://www.w3.org/2001/XMLSchema#int> "Server cooling" "3" "211"^^<http://www.w3.org/2001/XMLSchema#int> "-1050"^^<http://www.w3.org/2001/XMLSchema#decimal> "-4.97630331753554502369"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "3"^^<http://www.w3.org/2001/XMLSchema#int> "2018"^^<http://www.w3.org/2001/XMLSchema#int> "2018-03-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "204"^^<http://www.w3.org/2001/XMLSchema#int> "-744"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.6470588235294117647"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2014"^^<http://www.w3.org/2001/XMLSchema#int> "2014-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "196"^^<http://www.w3.org/2001/XMLSchema#int> "-744"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.79591836734693877551"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2015"^^<http://www.w3.org/2001/XMLSchema#int> "2015-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "196"^^<http://www.w3.org/2001/XMLSchema#int> "-744"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.79591836734693877551"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2016"^^<http://www.w3.org/2001/XMLSchema#int> "2016-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "201"^^<http://www.w3.org/2001/XMLSchema#int> "-744"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.70149253731343283582"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2017"^^<http://www.w3.org/2001/XMLSchema#int> "2017-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M7" "99997"^^<http://www.w3.org/2001/XMLSchema#int> "Staff related" "1" "211"^^<http://www.w3.org/2001/XMLSchema#int> "-744"^^<http://www.w3.org/2001/XMLSchema#decimal> "-3.52606635071090047393"^^<http://www.w3.org/2001/XMLSchema#decimal> "Kw" "12"^^<http://www.w3.org/2001/XMLSchema#int> "2018"^^<http://www.w3.org/2001/XMLSchema#int> "2018-12-14"^^<http://www.w3.org/2001/XMLSchema#date> "7200"^^<http://www.w3.org/2001/XMLSchema#int>

Received 1493 rows in 0.316 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/emas-electricity/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 rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#> 
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> 
PREFIX emas: <http://reference.eionet.europa.eu/emas/schema/>

SELECT DISTINCT
  ?meter
  ?metercode
  ?appliance
  ?floor
  ?fte 
  ?obsValue*1.0 as ?obsValue
  (?obsValue*1.0 / ?fte) as ?obsvaluefte
  ?unit
  month(?date) as ?month
  ?year
  ?date
  ?area
WHERE { 
 GRAPH <http://r.eionet.europa.eu/rdfdumps/emas/emas_electricity.rdf.gz> {  
   ?emas rdf:type ?type .
   OPTIONAL {  ?emas emas:appliance ?appliance } .
   #electricity
   OPTIONAL { ?emas emas:building ?building } .
   OPTIONAL { ?emas emas:floor ?floor }.
   OPTIONAL { ?emas emas:meter ?meter } .
   OPTIONAL { ?emas emas:metercode ?metercode } .
   OPTIONAL { ?emas emas:month ?month } .
   OPTIONAL { ?emas emas:unit ?unit } .   
   OPTIONAL { ?emas emas:fte ?fte } .   
   ?emas sdmx-measure:obsValue ?obsValue .
   OPTIONAL { ?emas emas:obsvaluefte ?obsvaluefte } .   
   ?emas sdmx-dimension:timePeriod ?date .
   ?emas emas:year ?year .
   ?emas emas:area ?area .
 } 
}


Temporal coverage

Document Actions