Tourism overnights per season

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

Download this dataset

Dataset preview

(Live Query)

quarter date ugeo obsValue
"Quarter 3" "2004"^^<http://www.w3.org/2001/XMLSchema#int> "Belgium" "11030329"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 3" "2014"^^<http://www.w3.org/2001/XMLSchema#int> "United Kingdom" "121462022"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 1" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "Spain" "59117368"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 3" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "50621591"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 3" "2006"^^<http://www.w3.org/2001/XMLSchema#int> "Greece" "31578713"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 1" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "Montenegro" "182093"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 3" "2015"^^<http://www.w3.org/2001/XMLSchema#int> "Romania" "9935688"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 3" "2011"^^<http://www.w3.org/2001/XMLSchema#int> "Portugal" "19449973"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 2" "2014"^^<http://www.w3.org/2001/XMLSchema#int> "Romania" "4779514"^^<http://www.w3.org/2001/XMLSchema#decimal>
"Quarter 1" "2016"^^<http://www.w3.org/2001/XMLSchema#int> "Italy" "51742886"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 2005 rows in 0.230 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/tourism-overnights-per-season/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 geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
PREFIX indic_to: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_to/>

SELECT 
?quarter
?date
?ugeo
sum(?obsValue) as ?obsValue
{{
  SELECT
    bif:either( month(?date) in (1,2,3), 'Quarter 1', 
    bif:either( month(?date) in (4,5,6), 'Quarter 2', 
    bif:either( month(?date) in (7,8,9), 'Quarter 3', 'Quarter 4'))) as ?quarter
    year(?date) as ?date
    bif:either(?geo = geo:DE, 'Germany', ?ugeo) as ?ugeo
    sum(?obsValue) as ?obsValue
  WHERE {
    GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/tour_occ_nim.rdf.gz> 
    {
      _:tour_occ_nim sdmx-dimension:timePeriod ?date .
      FILTER (year(?date) >= 2000)
      _:tour_occ_nim sdmx-dimension:refArea ?geo . 
      _:tour_occ_nim property:indic_to indic_to:B006 . 
      _:tour_occ_nim sdmx-attribute:unitMeasure unit:NR . 
      _:tour_occ_nim property:nace_r2 nace_r2:I551-I553 . 
      _:tour_occ_nim sdmx-measure:obsValue ?obsValue .
    }
    ?geo skos:exactMatch ?eeauri .
    ?eeauri skos:inScheme <http://dd.eionet.europa.eu/vocabulary/common/countries/> .
    ?eeauri rdfs:label ?ugeo .
  }
}}


Related content

Visualisations produced

Temporal coverage

Document Actions
Filed under: