Greenhouse gas emissions by EU Member State,1990,2000,2012

Data table via SPARQL Published 28 Jul 2014 Last modified 19 Apr 2016

Download this dataset

Dataset preview

(Live Query)

country_name difference 1990 2000 2012 pop_1990 pop_2010 pop_2012 pc_1990 pc_2000 pc_2012 pc_difference
"Albania" "" "" "" "" "3287"^^<http://www.w3.org/2001/XMLSchema#decimal> "3058"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" "" ""
"Andorra" "" "" "" "" "51"^^<http://www.w3.org/2001/XMLSchema#decimal> "66"^^<http://www.w3.org/2001/XMLSchema#decimal> "78"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"Armenia" "" "" "" "" "" "3227"^^<http://www.w3.org/2001/XMLSchema#decimal> "3274"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"Austria" "2.53"^^<http://www.w3.org/2001/XMLSchema#decimal> "78"^^<http://www.w3.org/2001/XMLSchema#decimal> "80"^^<http://www.w3.org/2001/XMLSchema#decimal> "80"^^<http://www.w3.org/2001/XMLSchema#decimal> "7645"^^<http://www.w3.org/2001/XMLSchema#decimal> "8002"^^<http://www.w3.org/2001/XMLSchema#decimal> "8408"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "10"^^<http://www.w3.org/2001/XMLSchema#decimal> "-6.78"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Azerbaijan" "" "" "" "" "" "8016"^^<http://www.w3.org/2001/XMLSchema#decimal> "9235"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"Belarus" "" "" "" "" "" "10019"^^<http://www.w3.org/2001/XMLSchema#decimal> "9465"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"Belgium" "-18.49"^^<http://www.w3.org/2001/XMLSchema#decimal> "143"^^<http://www.w3.org/2001/XMLSchema#decimal> "146"^^<http://www.w3.org/2001/XMLSchema#decimal> "117"^^<http://www.w3.org/2001/XMLSchema#decimal> "9948"^^<http://www.w3.org/2001/XMLSchema#decimal> "10239"^^<http://www.w3.org/2001/XMLSchema#decimal> "11095"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "11"^^<http://www.w3.org/2001/XMLSchema#decimal> "-26.92"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Bosnia-Herzegovina" "" "" "" "" "4499"^^<http://www.w3.org/2001/XMLSchema#decimal> "3753"^^<http://www.w3.org/2001/XMLSchema#decimal> "3839"^^<http://www.w3.org/2001/XMLSchema#decimal> "" "" "" ""
"Bulgaria" "-44.07"^^<http://www.w3.org/2001/XMLSchema#decimal> "109"^^<http://www.w3.org/2001/XMLSchema#decimal> "59"^^<http://www.w3.org/2001/XMLSchema#decimal> "61"^^<http://www.w3.org/2001/XMLSchema#decimal> "8767"^^<http://www.w3.org/2001/XMLSchema#decimal> "8191"^^<http://www.w3.org/2001/XMLSchema#decimal> "7327"^^<http://www.w3.org/2001/XMLSchema#decimal> "12"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "8"^^<http://www.w3.org/2001/XMLSchema#decimal> "-33.07"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Croatia" "-17.28"^^<http://www.w3.org/2001/XMLSchema#decimal> "32"^^<http://www.w3.org/2001/XMLSchema#decimal> "27"^^<http://www.w3.org/2001/XMLSchema#decimal> "26"^^<http://www.w3.org/2001/XMLSchema#decimal> "4773"^^<http://www.w3.org/2001/XMLSchema#decimal> "4498"^^<http://www.w3.org/2001/XMLSchema#decimal> "4276"^^<http://www.w3.org/2001/XMLSchema#decimal> "7"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "6"^^<http://www.w3.org/2001/XMLSchema#decimal> "-7.67"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 50 rows in 0.003 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/greenhouse-gas-emissions-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



semantic.eea.europa.eu/sparql

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX clrtap_geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX age: <http://rdfdata.eionet.europa.eu/eurostat/dic/age#>

SELECT
?country_name
round(((sum(?end_year)/sum(?start_year))-1)*10000)/100.0 as ?difference

(round(sum(?start_year)/1000)) as ?1990
(round(sum(?mid_year)/1000)) as ?2000
(round(sum(?end_year)/1000)) as ?2012
(round(sum(?pop_start_year)/1000)) as ?pop_1990
(round(sum(?pop_mid_year)/1000)) as ?pop_2010
(round(sum(?pop_end_year)/1000)) as ?pop_2012

round(sum(?start_year)/sum(?pop_start_year)*1000) as ?pc_1990
round(sum(?mid_year)/sum(?pop_mid_year)*1000) as ?pc_2000
round(sum(?end_year)/sum(?pop_end_year)*1000) as ?pc_2012
round((((sum(?end_year)/sum(?pop_end_year))/(sum(?start_year)/sum(?pop_start_year)))-1)*10000)/100.0 as ?pc_difference

WHERE {
{
  GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
   {
      _:unfccc_crf clrtap_nec_unfccc:country_code ?country_uri . FILTER (?country_uri != clrtap_geo:GB and ?country_uri != clrtap_geo:GR)
      _:unfccc_crf clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
      FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)') 
      _:unfccc_crf clrtap_nec_unfccc:sector_code sector:NT_excl .
      {
        _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year in ('1990'))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?start_year .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year in ('2000'))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?mid_year .
      } UNION {
        _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year in ('2012'))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?end_year .
      }
   }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz> 
   {
      _:demo_pjan sdmx-dimension:refArea ?country_uri . FILTER (?country_uri != geo:UK and ?country_uri != geo:EL)
      _:demo_pjan sdmx-dimension:age age:TOTAL . 
      _:demo_pjan sdmx-dimension:sex sex:sex-T . 
      {
        _:demo_pjan sdmx-dimension:timePeriod ?year . FILTER (year(?year) = 1990)
        _:demo_pjan sdmx-measure:obsValue ?pop_start_year .
      } UNION {
        _:demo_pjan sdmx-dimension:timePeriod ?year . FILTER (year(?year) = 2000)
        _:demo_pjan sdmx-measure:obsValue ?pop_mid_year .
      } UNION {
        _:demo_pjan sdmx-dimension:timePeriod ?year . FILTER (year(?year) = 2012)
        _:demo_pjan sdmx-measure:obsValue ?pop_end_year .
      }
   }
  }
  ?country_uri skos:notation ?country_code .
  ?country_uri_2 skos:notation ?country_code . 
  ?country_uri_2 skos:inScheme <http://rdfdata.eionet.europa.eu/eea/countries/> .
  ?country_uri_2 rdfs:label ?country_name .
 }
GROUP BY ?country_name
ORDER BY ?country_name


Related content

Document Actions