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

Dim region, Statfin matk pxt 11j1 px, Full history

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 region, Statfin matk pxt 11j1 px, Latest

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.

Dim year, Statfin matk pxt 11j1 px, Full history

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 1 are empty, making the null percent 4.00. Minimum value is 1995 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin matk pxt 11j1 px, Latest

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 1 are empty, making the null percent 4.00. Minimum value is 1995 and maximum value is 2018.

Dim country, Statfin matk pxt 11j1 px, Full history

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 country, Statfin matk pxt 11j1 px, Latest

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.

Fact, Statfin matk pxt 11j1 px, Full history

Column Type Comment
region string Maakunta . 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 322 are empty, making the null percent 1.06. Minimum value is 20 and maximum value is 11967117.
nights_spent int Datasource did not contain a description for Nights_spent. Column nights_spent has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 50 and maximum value is 22235084.
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 1584 are empty, making the null percent 5.20. Minimum value is -94 and maximum value is 496.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin matk pxt 11j1 px, Latest

Column Type Comment
region string Maakunta . 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 322 are empty, making the null percent 1.06. Minimum value is 20 and maximum value is 11967117.
nights_spent int Datasource did not contain a description for Nights_spent. Column nights_spent has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 50 and maximum value is 22235084.
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 1584 are empty, making the null percent 5.20. Minimum value is -94 and maximum value is 496.

Dim type of accommodation establishment, Statfin matk pxt 11j1 px, Full history

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 type of accommodation establishment, Statfin matk pxt 11j1 px, Latest

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...

Additional Info

Last Updated July 21, 2019
Created July 16, 2019