All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data table via SPARQL
Received 96 rows in 0.030 seconds.
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.
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)
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/persons-employed-in-total-tourism or scan the QR code.
PDF generated on 01 Sep 2024, 07:03 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others