next
previous
items

Data table via SPARQL

Monthly distribution of the total number of arrivals and nights spent at tourist accommodation establishments

Data table via SPARQL Published 05 Jun 2017 Last modified 05 Jun 2017

Download this dataset

Dataset preview

(Live Query)

date obsValue
"1"^^<http://www.w3.org/2001/XMLSchema#int> "4.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2"^^<http://www.w3.org/2001/XMLSchema#int> "4.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"3"^^<http://www.w3.org/2001/XMLSchema#int> "5.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"4"^^<http://www.w3.org/2001/XMLSchema#int> "6.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"5"^^<http://www.w3.org/2001/XMLSchema#int> "8.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"6"^^<http://www.w3.org/2001/XMLSchema#int> "10.3"^^<http://www.w3.org/2001/XMLSchema#decimal>
"7"^^<http://www.w3.org/2001/XMLSchema#int> "15.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"8"^^<http://www.w3.org/2001/XMLSchema#int> "17.4"^^<http://www.w3.org/2001/XMLSchema#decimal>
"9"^^<http://www.w3.org/2001/XMLSchema#int> "10"^^<http://www.w3.org/2001/XMLSchema#decimal>
"10"^^<http://www.w3.org/2001/XMLSchema#int> "7.4"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 12 rows in 0.026 seconds.


https://www.eea.europa.eu/data-and-maps/daviz/sds/monthly-distribution-of-the-total/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 indic_to: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_to/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>

SELECT DISTINCT
month(?date) as ?date
round((sum(?obsValue)/12) / sum(?obsValue_year) *1000)/10.0 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) = 2015)
    _:tour_occ_nim sdmx-dimension:refArea geo:EU28 . 
    _: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 .

    _:tour_occ_nim_year sdmx-dimension:timePeriod ?date_year . 
    FILTER (year(?date_year) = 2015)
    _:tour_occ_nim_year sdmx-dimension:refArea geo:EU28 . 
    _:tour_occ_nim_year property:indic_to indic_to:B006 . 
    _:tour_occ_nim_year sdmx-attribute:unitMeasure unit:NR . 
    _:tour_occ_nim_year property:nace_r2 nace_r2:I551-I553 . 
    _:tour_occ_nim_year sdmx-measure:obsValue ?obsValue_year .
  }
}
ORDER BY month(?date)


Permalinks

Geographic coverage

Temporal coverage

Topics

Tags

Filed under:
Filed under: tourism accommodation
Document Actions