Data table via SPARQL

EMAS electricity

Data table via SPARQL Published 20 Feb 2018 Last modified 24 Oct 2020

34 min read

Topics: Energy

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)

meter	metercode	appliance	floor	fte	obsValue	obsvaluefte	unit	month	year	date	area
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1586"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7.51658767772511848341"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"1"^^<http://www.w3.org/2001/XMLSchema#int>	"2018"^^<http://www.w3.org/2001/XMLSchema#int>	"2018-01-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1512"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7.16587677725118483412"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"1"^^<http://www.w3.org/2001/XMLSchema#int>	"2019"^^<http://www.w3.org/2001/XMLSchema#int>	"2019-01-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1310"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.20853080568720379146"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"2"^^<http://www.w3.org/2001/XMLSchema#int>	"2018"^^<http://www.w3.org/2001/XMLSchema#int>	"2018-02-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1425"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.75355450236966824644"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"2"^^<http://www.w3.org/2001/XMLSchema#int>	"2019"^^<http://www.w3.org/2001/XMLSchema#int>	"2019-02-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1380"^^<http://www.w3.org/2001/XMLSchema#decimal>	"6.54028436018957345971"^^<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-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1576"^^<http://www.w3.org/2001/XMLSchema#decimal>	"7.4691943127962085308"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"3"^^<http://www.w3.org/2001/XMLSchema#int>	"2019"^^<http://www.w3.org/2001/XMLSchema#int>	"2019-03-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1688"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"4"^^<http://www.w3.org/2001/XMLSchema#int>	"2018"^^<http://www.w3.org/2001/XMLSchema#int>	"2018-04-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"1794"^^<http://www.w3.org/2001/XMLSchema#decimal>	"8.50236966824644549763"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"4"^^<http://www.w3.org/2001/XMLSchema#int>	"2019"^^<http://www.w3.org/2001/XMLSchema#int>	"2019-04-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"2185"^^<http://www.w3.org/2001/XMLSchema#decimal>	"10.35545023696682464454"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"5"^^<http://www.w3.org/2001/XMLSchema#int>	"2018"^^<http://www.w3.org/2001/XMLSchema#int>	"2018-05-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>
"M6: Ground floor left side"	"21326083"^^<http://www.w3.org/2001/XMLSchema#int>	"Staff related"	"3"	"211"^^<http://www.w3.org/2001/XMLSchema#int>	"2163"^^<http://www.w3.org/2001/XMLSchema#decimal>	"10.25118483412322274881"^^<http://www.w3.org/2001/XMLSchema#decimal>	"Kw"	"5"^^<http://www.w3.org/2001/XMLSchema#int>	"2019"^^<http://www.w3.org/2001/XMLSchema#int>	"2019-05-15"^^<http://www.w3.org/2001/XMLSchema#date>	"7200"^^<http://www.w3.org/2001/XMLSchema#int>

Received 1697 rows in 0.272 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/emas-electricity/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:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


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