next
previous
items

Data table via SPARQL

Emissions by country for electricity consumption according to nrg_bal_c

Data table via SPARQL Published 16 Oct 2020 Last modified 25 Jan 2023
Topics:

Download this dataset

Dataset preview

(Live Query)

date geo TI_EHG_MAPE_E TI_EHG_MAPCHP_E TI_EHG_MAPH_E TI_EHG_APE_E TI_EHG_APCHP_E TI_EHG_APH_E GHP_MAPCHP GHP_MAPH GEP_APCHP GEP_MAPCHP
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/SI> "790.702"^^<http://www.w3.org/2001/XMLSchema#decimal> "287.219"^^<http://www.w3.org/2001/XMLSchema#decimal> "33.792"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "24.626"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "143.44"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.667"^^<http://www.w3.org/2001/XMLSchema#decimal> "14.772"^^<http://www.w3.org/2001/XMLSchema#decimal> "68.513"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG> "3132.374"^^<http://www.w3.org/2001/XMLSchema#decimal> "1082.05"^^<http://www.w3.org/2001/XMLSchema#decimal> "179.384"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.84"^^<http://www.w3.org/2001/XMLSchema#decimal> "75.955"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.049"^^<http://www.w3.org/2001/XMLSchema#decimal> "548.564"^^<http://www.w3.org/2001/XMLSchema#decimal> "166.071"^^<http://www.w3.org/2001/XMLSchema#decimal> "41.518"^^<http://www.w3.org/2001/XMLSchema#decimal> "292.055"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/UA> "10300.412"^^<http://www.w3.org/2001/XMLSchema#decimal> "4008.388"^^<http://www.w3.org/2001/XMLSchema#decimal> "5307.049"^^<http://www.w3.org/2001/XMLSchema#decimal> "76.589"^^<http://www.w3.org/2001/XMLSchema#decimal> "1670.529"^^<http://www.w3.org/2001/XMLSchema#decimal> "771.362"^^<http://www.w3.org/2001/XMLSchema#decimal> "1597.569"^^<http://www.w3.org/2001/XMLSchema#decimal> "5043.183"^^<http://www.w3.org/2001/XMLSchema#decimal> "181.823"^^<http://www.w3.org/2001/XMLSchema#decimal> "1189.407"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/RS> "5627.129"^^<http://www.w3.org/2001/XMLSchema#decimal> "1132.165"^^<http://www.w3.org/2001/XMLSchema#decimal> "540.588"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "228.234"^^<http://www.w3.org/2001/XMLSchema#decimal> "113.303"^^<http://www.w3.org/2001/XMLSchema#decimal> "91.807"^^<http://www.w3.org/2001/XMLSchema#decimal> "528.994"^^<http://www.w3.org/2001/XMLSchema#decimal> "26.79"^^<http://www.w3.org/2001/XMLSchema#decimal> "373.949"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/NL> "6830.049"^^<http://www.w3.org/2001/XMLSchema#decimal> "3895.704"^^<http://www.w3.org/2001/XMLSchema#decimal> "321.63"^^<http://www.w3.org/2001/XMLSchema#decimal> "30.422"^^<http://www.w3.org/2001/XMLSchema#decimal> "3481.661"^^<http://www.w3.org/2001/XMLSchema#decimal> "68.299"^^<http://www.w3.org/2001/XMLSchema#decimal> "819.56"^^<http://www.w3.org/2001/XMLSchema#decimal> "288.955"^^<http://www.w3.org/2001/XMLSchema#decimal> "1909.667"^^<http://www.w3.org/2001/XMLSchema#decimal> "1705.748"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/RO> "2051.924"^^<http://www.w3.org/2001/XMLSchema#decimal> "2030.869"^^<http://www.w3.org/2001/XMLSchema#decimal> "329.397"^^<http://www.w3.org/2001/XMLSchema#decimal> "970.233"^^<http://www.w3.org/2001/XMLSchema#decimal> "206.912"^^<http://www.w3.org/2001/XMLSchema#decimal> "59.781"^^<http://www.w3.org/2001/XMLSchema#decimal> "972.837"^^<http://www.w3.org/2001/XMLSchema#decimal> "281.754"^^<http://www.w3.org/2001/XMLSchema#decimal> "79.914"^^<http://www.w3.org/2001/XMLSchema#decimal> "494.088"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/HR> "260.836"^^<http://www.w3.org/2001/XMLSchema#decimal> "650.671"^^<http://www.w3.org/2001/XMLSchema#decimal> "47.105"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "73.896"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "198.686"^^<http://www.w3.org/2001/XMLSchema#decimal> "39.445"^^<http://www.w3.org/2001/XMLSchema#decimal> "32.915"^^<http://www.w3.org/2001/XMLSchema#decimal> "264.162"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/MD> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "226.461"^^<http://www.w3.org/2001/XMLSchema#decimal> "35.082"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.203"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.403"^^<http://www.w3.org/2001/XMLSchema#decimal> "38.172"^^<http://www.w3.org/2001/XMLSchema#decimal> "136.047"^^<http://www.w3.org/2001/XMLSchema#decimal> "34.179"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.376"^^<http://www.w3.org/2001/XMLSchema#decimal> "71.797"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/SK> "321.457"^^<http://www.w3.org/2001/XMLSchema#decimal> "964.659"^^<http://www.w3.org/2001/XMLSchema#decimal> "173.339"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "210.573"^^<http://www.w3.org/2001/XMLSchema#decimal> "29.286"^^<http://www.w3.org/2001/XMLSchema#decimal> "318.835"^^<http://www.w3.org/2001/XMLSchema#decimal> "158.212"^^<http://www.w3.org/2001/XMLSchema#decimal> "117.283"^^<http://www.w3.org/2001/XMLSchema#decimal> "244.368"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2020-01-01"^^<http://www.w3.org/2001/XMLSchema#date> <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/LV> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "366.32"^^<http://www.w3.org/2001/XMLSchema#decimal> "182.559"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.89"^^<http://www.w3.org/2001/XMLSchema#decimal> "13.93"^^<http://www.w3.org/2001/XMLSchema#decimal> "96.476"^^<http://www.w3.org/2001/XMLSchema#decimal> "178.77"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.122"^^<http://www.w3.org/2001/XMLSchema#decimal> "176.323"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1209 rows in 0.055 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/emissions-by-country-for-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



https://semantic.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX product: <http://dd.eionet.europa.eu/vocabulary/eurostat/product/>
PREFIX siec: <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/>
PREFIX nrg_bal: <http://dd.eionet.europa.eu/vocabulary/eurostat/nrg_bal/>
PREFIX measure: <http://purl.org/linked-data/sdmx/2009/measure#>

SELECT DISTINCT
?date
#?ugeo
?geo
#?siec
SUM(?TI_EHG_MAPE_E) AS ?TI_EHG_MAPE_E

SUM(?TI_EHG_MAPCHP_E) AS ?TI_EHG_MAPCHP_E

SUM(?TI_EHG_MAPH_E) AS ?TI_EHG_MAPH_E

SUM(?TI_EHG_APE_E) AS ?TI_EHG_APE_E
SUM(?TI_EHG_APCHP_E) AS ?TI_EHG_APCHP_E
SUM(?TI_EHG_APH_E) AS ?TI_EHG_APH_E

SUM(?GHP_MAPCHP) AS ?GHP_MAPCHP
SUM(?GHP_MAPH) AS ?GHP_MAPH

SUM(?GEP_APCHP) AS ?GEP_APCHP
SUM(?GEP_MAPCHP) AS ?GEP_MAPCHP
  WHERE {
      {
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c.rdf.gz>
        {{
          _:nrg_bal_c sdmx-dimension:timePeriod ?date .
          _:nrg_bal_c sdmx-attribute:unitMeasure unit:KTOE .
          #unit:KTOE .
          _:nrg_bal_c sdmx-dimension:refArea ?geo .
          _:nrg_bal_c property:siec ?siec .
          FILTER (?siec IN (siec:C0000X0350-0370, siec:C0350-0370, 
                                siec:G3000, siec:O4000XBIO, 
                                siec:P1000, siec:S2000, 
                                siec:W6100_6220
                 ))
          {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_MAPE_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_MAPE_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_MAPCHP_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_MAPCHP_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_MAPH_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_MAPH_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_APE_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_APE_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_APCHP_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_APCHP_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:TI_EHG_APH_E .
              _:nrg_bal_c measure:obsValue ?TI_EHG_APH_E .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:GHP_MAPCHP .
              _:nrg_bal_c measure:obsValue ?GHP_MAPCHP .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:GHP_MAPH .
              _:nrg_bal_c measure:obsValue ?GHP_MAPH .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:CHP_APH .
              _:nrg_bal_c measure:obsValue ?CHP_APH .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:GEP_APCHP .
              _:nrg_bal_c measure:obsValue ?GEP_APCHP .
          } UNION {
              _:nrg_bal_c property:nrg_bal nrg_bal:GEP_MAPCHP .
              _:nrg_bal_c measure:obsValue ?GEP_MAPCHP .
          }
       
        }}
      }
     
      #?geo rdfs:label ?ugeo .
      #FILTER (?geo = geo:EU27_2019)
      #FILTER (?geo = geo:EU28)
      #FILTER (year(?date) >= 2018) 
      #FILTER (year(?date) = 1990) 
    }
ORDER BY DESC(?date)

Error when running query:

Error. Traceback (most recent call last):
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 287, in run_with_timeout
    ret = func(*args, **kwargs)
  File "/plone/buildout-cache/eggs/Products.ZSPARQLMethod-2.3-py2.7.egg/Products/ZSPARQLMethod/Method.py", line 215, in query_and_get_result
    result = sparql.query(*args, timeout = kwargs.get("timeout", 0) or 0)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 747, in query
    return s.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 416, in query
    return q.query(query, timeout, raw=raw)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 571, in query
    response = self._request(statement, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 558, in _request
    response = self._build_response(query, opener, buf, timeout)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 543, in _build_response
    timeout if timeout > 0 else None)
  File "/plone/buildout-cache/eggs/sparql_client-3.8-py2.7.egg/sparql.py", line 514, in _get_response
    response = opener.open(request, timeout=timeout)
  File "/usr/local/lib/python2.7/urllib2.py", line 429, in open
    response = self._open(req, data)
  File "/usr/local/lib/python2.7/urllib2.py", line 447, in _open
    '_open', req)
  File "/usr/local/lib/python2.7/urllib2.py", line 407, in _call_chain
    result = func(*args)
  File "/usr/local/lib/python2.7/urllib2.py", line 1241, in https_open
    context=self._context)
  File "/usr/local/lib/python2.7/urllib2.py", line 1201, in do_open
    r = h.getresponse(buffering=True)
  File "/usr/local/lib/python2.7/httplib.py", line 1148, in getresponse
    response.begin()
  File "/usr/local/lib/python2.7/httplib.py", line 448, in begin
    version, status, reason = self._read_status()
  File "/usr/local/lib/python2.7/httplib.py", line 404, in _read_status
    line = self.fp.readline(_MAXLINE + 1)
  File "/usr/local/lib/python2.7/socket.py", line 480, in readline
    data = self._sock.recv(self._rbufsize)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 194, in recv
    return self._base_recv(buflen, flags, into=False)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 227, in _base_recv
    read = self.read(nbytes)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 139, in read
    super(GreenSSLSocket, self).read, *args, **kwargs)
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/green/ssl.py", line 119, in _call_trampolining
    timeout_exc=timeout_exc('timed out'))
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/__init__.py", line 163, in trampoline
    return hub.switch()
  File "/plone/buildout-cache/eggs/eventlet-0.21.0-py2.7.egg/eventlet/hubs/hub.py", line 295, in switch
    return self.greenlet.switch()
SSLError: ('timed out',)


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Document Actions