National emissions reported to the UNFCCC and to the EU Greenhouse Gas Monitoring Mechanism for EU27

PREFIX clrtap_nec_unfccc: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/schema/>
PREFIX geo: <http://reference.eionet.europa.eu/clrtap_nec_unfccc/country/>

SELECT distinct 
?year
'EU27' as ?geo
sum(?emissions) as ?emissions
sum(?emissions_idx) as ?emissions_idx
round(  sum(?emissions)/sum(?emissions_idx)*1000)/10.0 as ?index
?year as ?order

WHERE {
{ 
 GRAPH <http://r.eionet.europa.eu/rdfdumps/clrtap_nec_unfccc/unfccc_crf.rdf.gz> 
  {
  _:unfccc_crf clrtap_nec_unfccc:year ?year . FILTER (?year != 'Kyoto Base-year')
  _:unfccc_crf clrtap_nec_unfccc:country_code ?country_code . FILTER (?country_code in (geo:EU27 ))
  _:unfccc_crf clrtap_nec_unfccc:pollutant_name ?pollutant_name . FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)')
  _:unfccc_crf clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
  _:unfccc_crf clrtap_nec_unfccc:emissions ?emissions .
 
  _:unfccc_crf_idx clrtap_nec_unfccc:year ?year_idx . FILTER (?year_idx = '1990')
  _:unfccc_crf_idx clrtap_nec_unfccc:country_code ?country_code . FILTER (?country_code in (geo:EU27 ))
  _:unfccc_crf_idx clrtap_nec_unfccc:pollutant_name ?pollutant_name . FILTER (?pollutant_name = 'All greenhouse gases - (CO2 equivalent)')
  _:unfccc_crf_idx clrtap_nec_unfccc:unit ?unit . FILTER (?unit = 'Gg CO2 equivalent')
  _:unfccc_crf_idx clrtap_nec_unfccc:emissions ?emissions_idx .
  } 
}
}
GROUP BY ?year ?year_idx ?pollutant_name
ORDER BY ?year