Historic GHG emissions by major sectors

Data table via SPARQL Published 10 Nov 2015 Last modified 02 Feb 2016

Download this dataset

Dataset preview

(Live Query)

year ugeo sector_label GHG
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "3. Solvent and Other Product Use" "1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "7. Other" "0"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "6. Waste" "4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "4. Agriculture" "9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "1. Energy" "55"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "2. Industrial Processes" "10"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "2. Industrial Processes" "16"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "4. Agriculture" "11"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "1. Energy" "112"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1990"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "3. Solvent and Other Product Use" "0"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 4830 rows in 0.389 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/historic-ghg-emissions-by-major-sectors/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 clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>

SELECT
xsd:integer(?year) as ?year
?ugeo
?sector_label
round(sum(?unfccc_crf)/1000) AS ?GHG


WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
      _:unfccc_crf clrtap_nec_unfccc:sector_code ?sector_code . 
      FILTER (?sector_code in (sector:1, sector:2, sector:3, sector:4, sector:6, sector:7))

      _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . 
      FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)')
      _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year != ('KPBY'))

      _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .
      _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
    }
  ?geo rdfs:label ?ugeo .
  ?sector_code rdfs:label ?sector_label .
  }
} 
GROUP BY xsd:integer(?year) ?ugeo ?sector_label
HAVING xsd:integer(?year) >= 1990
ORDER BY xsd:integer(?year) ?ugeo


Related content

Document Actions