next
previous
items

Data table via SPARQL

Index trendline for GDP

Data table via SPARQL Published 19 Jul 2017 Last modified 17 Nov 2021

Download this dataset

Dataset preview

(Live Query)

date ugeo category index
"2000"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2001"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "102"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2002"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "102.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2003"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "101.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "103.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2005"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "103.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "107.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "111.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "112.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int> "Germany" "GDP" "105.8"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 712 rows in 0.061 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/index-trendline-for-gdp-on-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



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

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 rdf-schema: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX indic_na: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_na/>
PREFIX na_item: <http://dd.eionet.europa.eu/vocabulary/eurostat/na_item/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT 
year(?date) as ?date
bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
'GDP' as ?category
round((?nama_10_gdp/?nama_10_gdp_idx)*1000)/10.0 as ?index
#?nama_10_gdp
#?nama_10_gdp_idx

WHERE {
{  
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_gdp.rdf.gz> 
  {
  _:nama_10_gdp sdmx-dimension:refArea ?geo . FILTER (year(?date) >= 2000) 
  _:nama_10_gdp sdmx-dimension:timePeriod ?date .
  _:nama_10_gdp property:na_item na_item:B1G . 
  _:nama_10_gdp sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
  _:nama_10_gdp sdmx-measure:obsValue ?nama_10_gdp . 

  _:nama_10_gdp_idx sdmx-dimension:refArea ?geo . 
  _:nama_10_gdp_idx sdmx-dimension:timePeriod ?date_idx . 
  FILTER (year(?date_idx) = 2000)
  _:nama_10_gdp_idx property:na_item na_item:B1G . 
  _:nama_10_gdp_idx sdmx-attribute:unitMeasure unit:CLV10_MEUR . 
  _:nama_10_gdp_idx sdmx-measure:obsValue ?nama_10_gdp_idx .

  } 
  ?geo rdf-schema:label ?ugeo .

  FILTER (?geo != geo:EU27 &&?geo != geo:EA19 && ?geo != geo:EA && ?geo != geo:EA12 && ?geo != geo:EA17 && ?geo != geo:EA18 && ?geo != geo:EU15 && ?geo != geo:JP && ?geo != geo:MK && ?geo != geo:US && ?geo != geo:ME && ?geo != geo:AL && ?geo != geo:AD && ?geo != geo:AM && ?geo != geo:AZ && ?geo != geo:EA16 && ?geo != geo:EEA30 && ?geo != geo:EEA31 && ?geo != geo:EFTA  && ?geo != geo:ME && ?geo != geo:UA && ?geo != geo:RU && ?geo != geo:MD && ?geo != geo:DE_TOT && ?geo != geo:BY && ?geo != geo:BA && ?geo != geo:FX && ?geo != geo:GE && ?geo != geo:LI && ?geo != geo:IS)


}
}
GROUP BY ?ugeo ?geo 
ORDER BY ?ugeo ?date


Permalinks

Geographic coverage

Temporal coverage

Tags

Filed under:
Filed under: gross domestic product
Document Actions