CO2-emission intensity for Germany

Data table via SPARQL Published 20 Jul 2016 Last modified 27 Oct 2016

Download this dataset

Dataset preview

(Live Query)

date ugeo emission_intensity
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "808"^^<http://www.w3.org/2001/XMLSchema#int>
"1991"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "799"^^<http://www.w3.org/2001/XMLSchema#int>
"1992"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "799"^^<http://www.w3.org/2001/XMLSchema#int>
"1993"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "782"^^<http://www.w3.org/2001/XMLSchema#int>
"1994"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "782"^^<http://www.w3.org/2001/XMLSchema#int>
"1995"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "756"^^<http://www.w3.org/2001/XMLSchema#int>
"1996"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "756"^^<http://www.w3.org/2001/XMLSchema#int>
"1997"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "756"^^<http://www.w3.org/2001/XMLSchema#int>
"1998"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "739"^^<http://www.w3.org/2001/XMLSchema#int>
"1999"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "730"^^<http://www.w3.org/2001/XMLSchema#int>

Received 25 rows in 0.052 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/co2-emission-intensity-for-germany-1/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 indic_nrg: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nrg/>
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/>

SELECT DISTINCT
year(xsd:date(?date)) as ?date
'Germany' as ?ugeo

round(( sum(?unfccc_crf)*10000/ (sum(?nrg_100a)+sum(?nrg_110a) ) /1000 ))*100000/11630 as ?emission_intensity
#round(sum(?unfccc_crf)/1000) as ?unfccc_crf
#sum(?nrg_100a) as ?nrg_100a
#sum(?nrg_110a) as ?nrg_110a

WHERE {
  { 
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:country_code unfccc_geo:DE .
      _:unfccc_crf clrtap_nec_unfccc:year ?date .
      FILTER (?date != '1985-1987')
      {
        _:unfccc_crf clrtap_nec_unfccc:unit 'Gg' .
        _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'CO2' .
        _:unfccc_crf clrtap_nec_unfccc:sector_code  sector:1.A.1.a .
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      }
    }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_100a.rdf.gz>
    {
      _:nrg_100a sdmx-dimension:timePeriod ?date .
      _:nrg_100a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_100a sdmx-dimension:refArea geo:DE .
      _:nrg_100a property:product product:0000 .
      _:nrg_100a property:indic_nrg indic_nrg:B_101109 .
      _:nrg_100a sdmx-measure:obsValue ?nrg_100a .
     }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nrg_110a.rdf.gz>
    {
      _:nrg_110a sdmx-dimension:timePeriod ?date .
      _:nrg_110a sdmx-attribute:unitMeasure unit:KTOE .
      _:nrg_110a sdmx-dimension:refArea geo:DE .
      _:nrg_110a property:product ?product . 
      FILTER (?product in (product:6000, product:5200))
      _:nrg_110a property:indic_nrg indic_nrg:B_101121 .
      _:nrg_110a sdmx-measure:obsValue ?nrg_110a .
    } 
  }
}
GROUP BY xsd:date(?date)
ORDER BY xsd:date(?date)


Document Actions