next
previous
items

Data table via SPARQL

CO2-emission intensity from electricity generation

Data table via SPARQL Published 01 Jun 2021 Last modified 19 Jan 2022
30 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 D19 D22 D23 D15 D59 D16 D14 D97 index
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "European Union - 28 countries (2013-2020)" "1437.52733992"^^<http://www.w3.org/2001/XMLSchema#decimal> "348890.338"^^<http://www.w3.org/2001/XMLSchema#decimal> "301908.37466666666666666667"^^<http://www.w3.org/2001/XMLSchema#decimal> "1243.94829969222033894331"^^<http://www.w3.org/2001/XMLSchema#decimal> "40513.75355555555555555556"^^<http://www.w3.org/2001/XMLSchema#decimal> "166.9281778129729110333"^^<http://www.w3.org/2001/XMLSchema#decimal> "1410.87647750519324997661"^^<http://www.w3.org/2001/XMLSchema#decimal> "2594.31640697674418604651"^^<http://www.w3.org/2001/XMLSchema#decimal> "544"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Finland" "16.56255969"^^<http://www.w3.org/2001/XMLSchema#decimal> "4401.899"^^<http://www.w3.org/2001/XMLSchema#decimal> "2223.38677777777777777778"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.36570221645276504512"^^<http://www.w3.org/2001/XMLSchema#decimal> "500.201"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.88205338639021249689"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.24775560284297754201"^^<http://www.w3.org/2001/XMLSchema#decimal> "54.36767441860465116279"^^<http://www.w3.org/2001/XMLSchema#decimal> "188"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Turkey" "" "7825.886"^^<http://www.w3.org/2001/XMLSchema#decimal> "7825.886"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "1221.209"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "57.53263953488372093023"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Lithuania" "12.03045159"^^<http://www.w3.org/2001/XMLSchema#decimal> "4053.274"^^<http://www.w3.org/2001/XMLSchema#decimal> "1850.53177777777777777778"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.49253096837573609218"^^<http://www.w3.org/2001/XMLSchema#decimal> "57.653"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.17111885984472552312"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.6636498282204616153"^^<http://www.w3.org/2001/XMLSchema#decimal> "28.36189534883720930232"^^<http://www.w3.org/2001/XMLSchema#decimal> "200"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Iceland" "0.01352762"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.027"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.027"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01352762"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.01352762"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.50918604651162790697"^^<http://www.w3.org/2001/XMLSchema#decimal> "3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Romania" "66.49415212"^^<http://www.w3.org/2001/XMLSchema#decimal> "21488.397"^^<http://www.w3.org/2001/XMLSchema#decimal> "15214.18033333333333333334"^^<http://www.w3.org/2001/XMLSchema#decimal> "47.07908279364807776627"^^<http://www.w3.org/2001/XMLSchema#decimal> "774.47577777777777777778"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.3965542976896262253"^^<http://www.w3.org/2001/XMLSchema#decimal> "49.47563709133770399157"^^<http://www.w3.org/2001/XMLSchema#decimal> "64.29743023255813953488"^^<http://www.w3.org/2001/XMLSchema#decimal> "769"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "3.74534757"^^<http://www.w3.org/2001/XMLSchema#decimal> "1326.44"^^<http://www.w3.org/2001/XMLSchema#decimal> "944.68444444444444444445"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.66741924882904616868"^^<http://www.w3.org/2001/XMLSchema#decimal> "144.066"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.40678601596726576399"^^<http://www.w3.org/2001/XMLSchema#decimal> "3.07420526479631193267"^^<http://www.w3.org/2001/XMLSchema#decimal> "8.87159302325581395348"^^<http://www.w3.org/2001/XMLSchema#decimal> "347"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Sweden" "7.84752115"^^<http://www.w3.org/2001/XMLSchema#decimal> "1908.924"^^<http://www.w3.org/2001/XMLSchema#decimal> "285.59622222222222222223"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.17407628289496537775"^^<http://www.w3.org/2001/XMLSchema#decimal> "98.893"^^<http://www.w3.org/2001/XMLSchema#decimal> "0.40654573418687700503"^^<http://www.w3.org/2001/XMLSchema#decimal> "1.58062201708184238278"^^<http://www.w3.org/2001/XMLSchema#decimal> "146.48762790697674418604"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "11.10184636"^^<http://www.w3.org/2001/XMLSchema#decimal> "3294.235"^^<http://www.w3.org/2001/XMLSchema#decimal> "2701.47388888888888888889"^^<http://www.w3.org/2001/XMLSchema#decimal> "9.10419203851460371084"^^<http://www.w3.org/2001/XMLSchema#decimal> "863.14955555555555555556"^^<http://www.w3.org/2001/XMLSchema#decimal> "2.90888590263902308795"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.01307794115362679879"^^<http://www.w3.org/2001/XMLSchema#decimal> "50.28540697674418604651"^^<http://www.w3.org/2001/XMLSchema#decimal> "239"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Norway" "" "80.779"^^<http://www.w3.org/2001/XMLSchema#decimal> "27.17122222222222222223"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "0"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "121.69009302325581395348"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 990 rows in 0.168 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/co2-emission-intensity-from-electricity-generation-4/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 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 clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX unfccc_geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX common_countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
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
bif:either(?geo = geo:DE, 'Germany', ?ugeo) AS ?ugeo

SUM(?unfccc_crf)/1000.0 AS ?D19
SUM(?ei_MAP) AS ?D22
(?D22 - (SUM(?dh_MAP)/0.9)) AS ?D23
?D19 * (?D23 / ?D22) AS ?D15
(SUM(?ei_AP) - (SUM(?dh_AP)/ 0.9)) AS ?D59 
?D15 * ?D59/ ?D23 AS ?D16
(?D15+?D16) aS ?D14

SUM(?GEP)/86 AS ?D97
ROUND(?D14 / ?D97 * 1000.0) AS ?index

#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)/86 AS ?GEP
#SUM(?unfccc_crf) AS ?unfccc_crf
  WHERE {{

      {{
        SELECT
          xsd:date(?year) AS ?date
          URI(replace(replace(replace(replace(xsd:string(?country_code), 'http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/', 'http://dd.eionet.europa.eu/vocabulary/eurostat/geo/'), 'EUX', 'EU27_2020'), 'GR', 'EL'), 'EUA', 'EU28')) AS ?geo
          ?unfccc_crf
        WHERE {
          GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
          {
            _:unfccc_crf clrtap_nec_unfccc:country_code ?country_code .
            _:unfccc_crf clrtap_nec_unfccc:year ?year .
            FILTER (?year != '1985-1987')
            {
              #_:unfccc_crf clrtap_nec_unfccc:unit 'Gg' .
              #_:unfccc_crf clrtap_nec_unfccc:pollutant_name 'CO2' .         
              _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' .         
              _:unfccc_crf clrtap_nec_unfccc:sector_code sector:1.A.1.a . 
              _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
            }
          }
          ?country_code skos:notation ?ugeo_unfccc .
        }
      }}

      } UNION {
      GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_bal_c_ktoe.rdf.gz>
        {
          _:nrg_bal_c sdmx-dimension:timePeriod ?date .
          _:nrg_bal_c sdmx-attribute:unitMeasure 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 .
              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_E, 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:GHP_APH
              ))
              _:nrg_bal_c measure:obsValue ?dh_AP .
           }
        } UNION {
          _:nrg_bal_c property:siec ?siec .
             FILTER (?siec IN (siec:TOTAL))
          _:nrg_bal_c property:nrg_bal ?nrg_bal .
              FILTER (?nrg_bal IN (
                  nrg_bal:GEP_MAPE, nrg_bal:GEP_MAPCHP,
                  nrg_bal:GEP_APE, nrg_bal:GEP_APCHP
              ))
              _:nrg_bal_c measure:obsValue ?GEP .
        }
      }
    }
    ?geo rdfs:label ?ugeo .
    FILTER (?geo IN (geo:EU27_2020, geo:EU28, geo:BE, geo:BG,
                     geo:CZ,	geo:DK,	geo:DE,	geo:EE,
                     geo:IE,	geo:EL,	geo:ES,	geo:FR,	
                     geo:HR,	geo:IT,	geo:CY,	geo:LV,
                     geo:LT,	geo:LU,	geo:HU,	geo:MT,		
                     geo:NL,	geo:AT,	geo:PL,	geo:PT,	
                     geo:RO,	geo:SI,	geo:SK,	geo:FI,
                     geo:SE,	geo:UK, geo:IS,	geo:TR,
                     geo:NO))

    FILTER (xsd:integer(substr(xsd:string(?date), 1, 4)) >= 1990) 
}
ORDER BY ?date


Permalinks

Geographic coverage

Temporal coverage

Topics

Topics:

Tags

Filed under:
Filed under: electricity generation
Document Actions