next
previous
items

Data table via SPARQL

UK - Greenhouse gas emissions,1990,2000,2012

Data table via SPARQL Published 03 Sep 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
"United Kingdom" "-25.1"^^<http://www.w3.org/2001/XMLSchema#decimal> "775.0"^^<http://www.w3.org/2001/XMLSchema#double> "690.0"^^<http://www.w3.org/2001/XMLSchema#double> "581.0"^^<http://www.w3.org/2001/XMLSchema#double> "57157"^^<http://www.w3.org/2001/XMLSchema#decimal> "58785"^^<http://www.w3.org/2001/XMLSchema#decimal> "63495"^^<http://www.w3.org/2001/XMLSchema#decimal> "14"^^<http://www.w3.org/2001/XMLSchema#decimal> "12"^^<http://www.w3.org/2001/XMLSchema#decimal> "9"^^<http://www.w3.org/2001/XMLSchema#decimal> "-32.58"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/uk-greenhouse-gas-emissions/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_nec_unfccc_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
'United Kingdom' as ?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 ?geo . FILTER (?geo = <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/GB>) 
      _: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 ?geo2 . FILTER (?geo2 = <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#UK>) 
      _: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 .
      }
   }
  }
 }


Permalinks

Document Actions