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

002 -- Visitor arrivals and nights spend in hotels

002 -- Visitor arrivals and nights spend in hotels

Tables

Column Descriptions

Fact, Statfinpas matk pxt 002 201812 en px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 570024 rows, out of which 23751 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
month string Datasource did not contain a description for Month. Column month has 570024 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 12.
information string Datasource did not contain a description for Information. Column information has 570024 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muutos_yopyneet and maximum string is Yopyneet.
region string Datasource did not contain a description for Region. Column region has 570024 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 570024 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.
visitor_arrivals_and_nights_spend_in_hotels int Datasource did not contain a description for Visitor_arrivals_and_nights_spend_in_hotels. Column visitor_arrivals_and_nights_spend_in_hotels has 570024 rows, out of which 153933 are empty, making the null percent 27.00. Minimum value is -98 and maximum value is 17722475.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas matk pxt 002 201812 en px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 570024 rows, out of which 23751 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
month string Datasource did not contain a description for Month. Column month has 570024 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 12.
information string Datasource did not contain a description for Information. Column information has 570024 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muutos_yopyneet and maximum string is Yopyneet.
region string Datasource did not contain a description for Region. Column region has 570024 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 570024 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.
visitor_arrivals_and_nights_spend_in_hotels int Datasource did not contain a description for Visitor_arrivals_and_nights_spend_in_hotels. Column visitor_arrivals_and_nights_spend_in_hotels has 570024 rows, out of which 153933 are empty, making the null percent 27.00. Minimum value is -98 and maximum value is 17722475.

Dim information, Statfinpas matk pxt 002 201812 en px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muutos_yopyneet and maximum string is Yopyneet.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arrivals and maximum string is Change of nights spend, %.

Dim year, Statfinpas matk pxt 002 201812 en px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
label int The label for the dimension value. Column label has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.

Dim region, Statfinpas matk pxt 002 201812 en 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 month, Statfinpas matk pxt 002 201812 en px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is April and maximum string is December.
orig_extractdate string The date when the data was originally fetched from the source.

Dim information, Statfinpas matk pxt 002 201812 en px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muutos_yopyneet and maximum string is Yopyneet.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arrivals and maximum string is Change of nights spend, %.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas matk pxt 002 201812 en px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
label int The label for the dimension value. Column label has 24 rows, out of which 1 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim month, Statfinpas matk pxt 002 201812 en px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is April and maximum string is December.

Dim region, Statfinpas matk pxt 002 201812 en 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.

Additional Info

Last Updated July 21, 2019
Created July 16, 2019