Data table via SPARQL

Comparison of FAO and Eurostat GDP for EEA members

Data table via SPARQL Published 02 Apr 2012 Last modified 25 Jan 2023

This is an old version, kept for reference only.

Go to latest version

This page was archived on 26 Aug 2017 with reason: A new version has been published

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.032 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/comparison-of-fao-and-eurostat/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 owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX eea: <http://rdfdata.eionet.europa.eu/eea/ontology/>
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 {
  ?ucountry a eea:Country ;
            eea:code ?code;
            rdfs:label ?countryname;
            eea:memberOf <http://rdfdata.eionet.europa.eu/eea/countries/EEA>;
            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 && ?year < "2009-01-02"^^xsd:date)
} ORDER BY ?code