next
previous
items

Data table via SPARQL

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.033 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


Permalinks

Document Actions