Data table via SPARQL

Economic profit from crops indexed 2010=100

Data table via SPARQL Published 14 Jun 2017 Last modified 14 Sep 2017

36 min read

Topics: Industry

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)

timePeriod	refArea	date	ugeo	label	index
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT>	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Austria"	"gross value added from crops"	"68.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT>	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Austria"	"gross value added from crops"	"101.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT>	"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Austria"	"gross value added from crops"	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/AT>	"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"Austria"	"gross value added from crops"	"118.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE>	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Belgium"	"gross value added from crops"	"112.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE>	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Belgium"	"gross value added from crops"	"108.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE>	"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Belgium"	"gross value added from crops"	"100"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BE>	"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"Belgium"	"gross value added from crops"	"103.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2004-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG>	"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Bulgaria"	"gross value added from crops"	"224.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006-12-31"^^<http://www.w3.org/2001/XMLSchema#date>	<http://dd.eionet.europa.eu/vocabulary/eurostat/geo/BG>	"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Bulgaria"	"gross value added from crops"	"81.7"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 119 rows in 0.076 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/economic-profit-from-crops-indexed/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 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 unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX indic_ag: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ag/>
PREFIX itm_newa: <http://dd.eionet.europa.eu/vocabulary/eurostat/itm_newa/>
PREFIX indic_ef: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_ef/>
PREFIX irrig: <http://dd.eionet.europa.eu/vocabulary/eurostat/irrig/> 
PREFIX agrarea: <http://dd.eionet.europa.eu/vocabulary/eurostat/agrarea/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/> 
PREFIX wat_proc: <http://dd.eionet.europa.eu/vocabulary/eurostat/wat_proc/>
PREFIX wat_src: <http://dd.eionet.europa.eu/vocabulary/eurostat/wat_src/>
PREFIX countries: <http://dd.eionet.europa.eu/vocabulary/common/countries/>
PREFIX swbewa2017: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/swbewa2017.tsv#>
PREFIX fadn2017: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/fadn2017.tsv#>
PREFIX abs_nace_A011_A013: <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/abs_nace_A011_A013.tsv#>

SELECT
?date as ?timePeriod
?geo as ?refArea
year(?date) as ?date
?ugeo
#?U_EUR/?ef_oluaareg
#?U_EUR_idx/?ef_oluaareg_idx 
'gross value added from crops' as ?label
round(( (?U_EUR/?ef_oluaareg) / (?U_EUR_idx/?ef_oluaareg_idx))*1000)/10.0 as ?index

{{
SELECT DISTINCT
?date
?geo
?ugeo

( ( sum(?10000_EUR) - (sum(?19010_EUR) + sum(?19040_EUR) + (sum(?19020_EUR) * (sum(?10000_EUR)/sum(?16000_EUR)))  + (sum(?19030_EUR) * (sum(?10000_EUR)/(sum(?10000_EUR)+sum(?13000_EUR))))) ) * (1.0-sum(xsd:decimal(?fadn2017))) )/7.0 as ?U_EUR

( ( sum(?10000_EUR_idx) - (sum(?19010_EUR_idx) + sum(?19040_EUR_idx) + (sum(?19020_EUR_idx) * (sum(?10000_EUR_idx)/sum(?16000_EUR_idx)))  + (sum(?19030_EUR_idx) * (sum(?10000_EUR_idx)/(sum(?10000_EUR_idx)+sum(?13000_EUR_idx))))) ) * (1.0-sum(xsd:decimal(?fadn2017_idx))) )/7.0 as ?U_EUR_idx

sum(?ef_oluaareg) as ?ef_oluaareg
sum(?ef_oluaareg_idx) as ?ef_oluaareg_idx

WHERE {{ 
  {
    GRAPH <http://semantic.eea.europa.eu/project/indicators/gap_filling_data/WREI004/2017/fadn2017.tsv>  
    {  
      _:fadn2017 fadn2017:date ?date .
      _:fadn2017 fadn2017:geo ?geo .
      _:fadn2017 fadn2017:obsValue ?fadn2017 .

      _:fadn2017_idx fadn2017:date ?date_idx .
      _:fadn2017_idx fadn2017:geo ?geo .
      _:fadn2017_idx fadn2017:obsValue ?fadn2017_idx .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/ef_oluaareg.rdf.gz>  
    {
      _:ef_oluaareg sdmx-dimension:timePeriod ?date . 
      _:ef_oluaareg sdmx-dimension:refArea ?geo . 
      _:ef_oluaareg property:indic_ef indic_ef:AGRAREA_HA . 
      _:ef_oluaareg property:agrarea agrarea:TOTAL . 
      _:ef_oluaareg sdmx-measure:obsValue ?ef_oluaareg .

      _:ef_oluaareg_idx sdmx-dimension:timePeriod ?date_idx . 
      _:ef_oluaareg_idx sdmx-dimension:refArea ?geo . 
      _:ef_oluaareg_idx property:indic_ef indic_ef:AGRAREA_HA . 
      _:ef_oluaareg_idx property:agrarea agrarea:TOTAL . 
      _:ef_oluaareg_idx sdmx-measure:obsValue ?ef_oluaareg_idx .
    }
  } UNION {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/aact_eaa07.rdf.gz>  { 
      _:aact_eaa07_EUR sdmx-dimension:timePeriod ?date . 
      _:aact_eaa07_EUR sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_EUR sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:aact_eaa07_EUR property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19010_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19040 .
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19040_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19020.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19020_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:19030.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?19030_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:13000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?13000_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:10000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?10000_EUR .
      } UNION {
        _:aact_eaa07_EUR property:itm_newa itm_newa:16000.
        _:aact_eaa07_EUR sdmx-measure:obsValue ?16000_EUR .
      }

      _:aact_eaa07_EUR_idx sdmx-dimension:timePeriod ?date_idx . 
      _:aact_eaa07_EUR_idx sdmx-dimension:refArea ?geo . 
      _:aact_eaa07_EUR_idx sdmx-attribute:unitMeasure unit:MIO_EUR . 
      _:aact_eaa07_EUR_idx property:indic_ag indic_ag:PROD_BP . 
      {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19010 . 
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19010_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19040 .
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19040_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19020.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19020_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:19030.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?19030_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:13000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?13000_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:10000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?10000_EUR_idx .
      } UNION {
        _:aact_eaa07_EUR_idx property:itm_newa itm_newa:16000.
        _:aact_eaa07_EUR_idx sdmx-measure:obsValue ?16000_EUR_idx .
      }
    }
  }

  ?geo skos:notation ?geoNotation  .
  ?geo skos:exactMatch ?eeauri .
  ?eeauri skos:inScheme countries: .
  ?eeauri rdfs:label ?ugeo .
  FILTER (strlen(?geoNotation) = 2)
  #FILTER (?geo = geo:AT)
  FILTER (year(?date) in (2005, 2007, 2010, 2013))
  FILTER (year(?date_idx) in (2010))
 }}
GROUP BY ?ugeo year(?date) ?geo

}}
HAVING (( (?U_EUR/?ef_oluaareg) / (?U_EUR_idx/?ef_oluaareg_idx))) > 0
ORDER BY ?ugeo ?date

Permalinks

Permalink to this version: 0b6424e25549452b821f6f732ec9004b
Permalink to latest version: C1F5HZKQDG

Geographic coverage

Austria Belgium Bulgaria Croatia Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands Poland Portugal Romania Slovakia Slovenia Spain Sweden United Kingdom