Persons employed in total tourism industries and in selected tourism industries as share of those employed in total non-financial business economy

Data table via SPARQL Published 13 Jun 2017 Last modified 13 Jun 2017
Topics: ,

Download this dataset

Dataset preview

(Live Query)

date ugeo tourism total_tourism_industries
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "3"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Austria" "4.7"^^<http://www.w3.org/2001/XMLSchema#decimal> "12.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "United Kingdom" "3.3"^^<http://www.w3.org/2001/XMLSchema#decimal> "11.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Croatia" "3.6"^^<http://www.w3.org/2001/XMLSchema#decimal> "10.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Sweden" "1.9"^^<http://www.w3.org/2001/XMLSchema#decimal> "7.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Lithuania" "1.2"^^<http://www.w3.org/2001/XMLSchema#decimal> "5.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Slovakia" "1"^^<http://www.w3.org/2001/XMLSchema#decimal> "4.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Cyprus" "9"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Malta" "7.7"^^<http://www.w3.org/2001/XMLSchema#decimal> ""
"2012"^^<http://www.w3.org/2001/XMLSchema#int> "Ireland" "4.9"^^<http://www.w3.org/2001/XMLSchema#decimal> ""

Received 96 rows in 0.004 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/persons-employed-in-total-tourism/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 indic_sb: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_sb/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>

SELECT 
year(?date) as ?date

bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo

round(( sum(?H51_I55_N79) / sum(?B_N_S95_X_K) )*1000)/10.0 as ?tourism
round(( sum(?TI) / sum(?B_N_S95_X_K) )*1000)/10.0 as ?total_tourism_industries

#sum(?B_N_S95_X_K) as ?B_N_S95_X_K
#sum(?H51_I55_N79) as ?H51_I55_N79
#sum(?TI) as ?TI

WHERE {{ 
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/sbs_na_sca_r2.rdf.gz> 
    {
      _:sbs_na_sca_r2 sdmx-dimension:timePeriod ?date . 
      FILTER (year(?date) >= 2012)
      _:sbs_na_sca_r2 property:indic_sb indic_sb:V16110 . 
      _:sbs_na_sca_r2 sdmx-dimension:refArea ?geo . 
      {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:B-N_S95_X_K))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?B_N_S95_X_K .
      } UNION {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:TI))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?TI .
      } UNION {
        _:sbs_na_sca_r2 property:nace_r2 ?nace_r2 .
        FILTER (?nace_r2 in (nace_r2:H51, nace_r2:I55, nace_r2:N79))
        _:sbs_na_sca_r2 sdmx-measure:obsValue ?H51_I55_N79 .
      }
    }
  ?geo rdfs:label ?ugeo .
}}
ORDER BY ?date desc(?total_tourism_industries) desc(?tourism)


Temporal coverage

Document Actions
Filed under: