Data table via SPARQL

Comparison of FAO and Eurostat GDP for EEA members

Data table via SPARQL Published 04 Oct 2012 Last modified 09 Mar 2022

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)

code	countryname	faoGDP	estatGDP	differencePercentage	faogdpyear

Received 0 rows in 0.027 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/comparison-of-fao-and-eurostat-1/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 skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX fao: <http://www.fao.org/countryprofiles/geoinfo/geopolitical/resource/>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX p: <http://eurostat.linked-statistics.org/property#>
PREFIX dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX measure: <http://purl.org/linked-data/sdmx/2009/measure#>

SELECT ?code ?countryname
        bif:sprintf("%.1f",?faogdp) AS ?faoGDP
        bif:sprintf("%.1f",xsd:float(?estatgdp) * 1.395871) AS ?estatGDP
        bif:sprintf('%.2f',?faogdp / xsd:float(?estatgdp) / 0.01395871) AS ?differencePercentage
        ?faogdpyear
 WHERE {
  <http://rdfdata.eionet.europa.eu/eea/countries/EEA> skos:member ?ucountry.
  ?ucountry a skos:Concept ;
            skos:notation ?code;
            rdfs:label ?countryname;
            owl:sameAs ?faourl;
            owl:sameAs ?estaturl.
  ?faourl fao:GDPTotalInCurrentPrices ?faogdp;
          fao:GDPYear ?faogdpyear.
  ?obs    qb:dataSet <http://eurostat.linked-statistics.org/data/nama_gdp_c>;
          p:geo ?estaturl;
          p:indic_na <http://eurostat.linked-statistics.org/dic/indic_na#B1GM>;
          dimension:timePeriod ?year;
          p:unit <http://eurostat.linked-statistics.org/dic/unit#MIO_EUR>;
          measure:obsValue ?estatgdp.
 FILTER(?year = "2009-01-01"^^xsd:date)
} ORDER BY ?code