To download the data set, please sign up or log in

11 j 1 -- Yearly nights spent and arrivals by country of residence, 1995-2019*

11 j 1 -- Yearly nights spent and arrivals by country of residence, 1995-2019*

Tables

Column Descriptions

Fact, T11j1 Yearly Nights Spent And Arrivals By Country Of Residence 1995 2019

Column Type Comment
region string Datasource did not contain a description for Region. Column region has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
country string Datasource did not contain a description for Country. Column country has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is C020.
type_of_accommodation_establishment int Datasource did not contain a description for Type_of_accommodation_establishment. Column type_of_accommodation_establishment has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
year int * preliminary data . Column year has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2019.
arrivals int Datasource did not contain a description for Arrivals. Column arrivals has 30450 rows, out of which 467 are empty, making the null percent 1.53. Minimum value is 20 and maximum value is 11964471.
nights_spent int Datasource did not contain a description for Nights_spent. Column nights_spent has 30450 rows, out of which 467 are empty, making the null percent 1.53. Minimum value is 50 and maximum value is 22219252.
change_of_nights_spent int Datasource did not contain a description for Change_of_nights_spent. Column change_of_nights_spent has 30450 rows, out of which 1734 are empty, making the null percent 5.69. Minimum value is -94 and maximum value is 496.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Region, T11j1 Yearly Nights Spent And Arrivals By Country Of Residence 1995 2019

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MA1 and maximum string is MK21.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Country, T11j1 Yearly Nights Spent And Arrivals By Country Of Residence 1995 2019

Column Type Comment
code string The code for the dimension value. Column code has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is C020.
label string The label for the dimension value. Column label has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Africa and maximum string is China.
orig_extractdate string The date when the data was originally fetched from the source.

Dim Type Of Accommodation Establishment, T11j1 Yearly Nights Spent And Arrivals By Country Of Residence 1995 2019

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: All accommodation establi... and first 25 characters of maximum string: Hotels...
orig_extractdate string The date when the data was originally fetched from the source.

Dim Year, T11j1 Yearly Nights Spent And Arrivals By Country Of Residence 1995 2019

Column Type Comment
code int The code for the dimension value. Column code has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2019.
label int The label for the dimension value. Column label has 25 rows, out of which 2 are empty, making the null percent 8.00. Minimum value is 1995 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 12, 2019
Created April 12, 2019