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 16 Oct 2020

Download this dataset

Dataset preview

(Live Query)

date ugeo geo siec ei_MAP ei_AP dh_MAP dh_AP GEP
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/S2000> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/C0000X0350-0370> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/G3000> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/C0350-0370> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/W6100_6220> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/TOTAL> "735.467"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/O4000XBIO> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2018-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/P1000> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/G3000> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2017-01-01"^^<http://www.w3.org/2001/XMLSchema#date> "Albania" <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AL> <http://dd.eionet.europa.eu/vocabulary/eurostat/siec/P1000> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 9224 rows in 6.426 seconds.


https://www.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
#year(?date) AS ?date
?date
?ugeo
?geo
?siec
SUM(?ei_MAP) AS ?ei_MAP
SUM(?ei_AP) AS ?ei_AP
SUM(?dh_MAP) AS ?dh_MAP
SUM(?dh_AP) AS ?dh_AP
SUM(?GEP) AS ?GEP
  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, siec:TOTAL
                 ))
          {
              _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:TI_EHG_MAPE_E, nrg_bal:TI_EHG_MAPCHP_E, nrg_bal:TI_EHG_MAPH_E
              ))
              _:nrg_bal_c measure:obsValue ?ei_MAP .
          } UNION {
              _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:TI_EHG_APE, nrg_bal:TI_EHG_APCHP_E, nrg_bal:TI_EHG_APH_E
              ))
              _:nrg_bal_c measure:obsValue ?ei_AP .
          } UNION {
              _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:GHP_MAPCHP, nrg_bal:GHP_MAPH
              ))
              _:nrg_bal_c measure:obsValue ?dh_MAP .
          } UNION {
              _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:GHP_APCHP, nrg_bal:CHP_APH
              ))
              _:nrg_bal_c measure:obsValue ?dh_AP .
          } UNION {
              _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:GEP_APCHP, nrg_bal:GEP_MAPCHP
              ))
              _:nrg_bal_c measure:obsValue ?GEP .
          }
       
        }}
        #?siec rdfs:label ?siecLabel .
      }
      
      ?geo rdfs:label ?ugeo .
      #FILTER (?geo = geo:AT)
      #FILTER (year(?date) >= 2018) 
    }
ORDER BY ?geo DESC(?date)


Permalinks

Geographic coverage

Temporal coverage

Topics

Tags

Document Actions