Data table via SPARQL

Aggregated GHG emissions by sector, EU-28

Data table via SPARQL Published 30 Aug 2016 Last modified 16 Sep 2016

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

year	sectors	obsValue
"1990"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"786"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1991"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"792"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1992"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"816"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1993"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"821"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1994"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"826"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1995"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"839"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1996"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"865"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1997"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"877"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1998"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"905"^^<http://www.w3.org/2001/XMLSchema#decimal>
"1999"^^<http://www.w3.org/2001/XMLSchema#int>	"Transport"	"924"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 175 rows in 0.003 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/aggregated-ghg-emissions-by-sector/daviz.json

For system integrators

Linked Data query (SPARQL)

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

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        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 sectors: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/Sectors/>
PREFIX sector: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/unfccc_crf_sector/>
PREFIX rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX common_countries: <http://rdfdata.eionet.europa.eu/eea/countries/>

SELECT DISTINCT
xsd:int(?year) as ?year
bif:substring( ?sectors_label, (coalesce( xsd:integer(bif:strchr( ?sectors_label, '-')), -2) +3) , 50) as ?sectors
round(sum(?unfccc_crf)/1000) as ?obsValue

WHERE {
  { 
    GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
    {
      _:unfccc_crf clrtap_nec_unfccc:year ?year .
      _:unfccc_crf clrtap_nec_unfccc:country_code ?geo .

      _:unfccc_crf clrtap_nec_unfccc:unit 'Gg CO2 equivalent' . 
      _:unfccc_crf clrtap_nec_unfccc:pollutant_name 'All greenhouse gases - (CO2 equivalent)' .
      {
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors .
        FILTER (?sectors in (sector:2, sector:1.A.3, 
                           sector:3, sector:5, sector:6))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT '1.x.x - Energy supply' as ?sectors_label {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors_x .
        FILTER (?sectors_x in (sector:1.A.1, sector:1.B))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      } UNION {
        { SELECT '1.A.4.x - Households and services' as ?sectors_label {}}
        _:unfccc_crf clrtap_nec_unfccc:sector_code ?sectors_x .
        FILTER (?sectors_x in (sector:1.A.4.a, sector:1.A.4.b))
        _:unfccc_crf clrtap_nec_unfccc:emissions ?unfccc_crf .
      }
    }
  }
  OPTIONAL { ?sectors rdfs:label ?sectors_label } .

  ?geo skos:notation ?geo_id .
  ?eeageo skos:notation ?geo_id .
  ?eeageo skos:inScheme common_countries: .
  common_countries:EU28 skos:member ?eeageo .
}
GROUP BY ?year ?sectors_code ?sectors_label
HAVING xsd:int(?year) >= 1990
ORDER BY ?sectors_label  ?year