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

001 -- Hotel capacity and capacity utilization

001 -- Hotel capacity and capacity utilization

Tables

Column Descriptions

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

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 45864 rows, out of which 1911 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
month int Datasource did not contain a description for Month. Column month has 45864 rows, out of which 3528 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
information string Datasource did not contain a description for Information. Column information has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
region string Datasource did not contain a description for Region. Column region has 45864 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.
hotel_capacity_and_capacity_utilization int Datasource did not contain a description for Hotel_capacity_and_capacity_utilization. Column hotel_capacity_and_capacity_utilization has 45864 rows, out of which 626 are empty, making the null percent 1.36. Minimum value is 6 and maximum value is 120638.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas matk pxt 001 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 month, Statfinpas matk pxt 001 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 month, Statfinpas matk pxt 001 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 year, Statfinpas matk pxt 001 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 region, Statfinpas matk pxt 001 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.

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

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Number of bed-places and maximum string is Price per night, €.

Fact, Statfinpas matk pxt 001 201812 en px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 45864 rows, out of which 1911 are empty, making the null percent 4.17. Minimum value is 1995 and maximum value is 2017.
month int Datasource did not contain a description for Month. Column month has 45864 rows, out of which 3528 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
information string Datasource did not contain a description for Information. Column information has 45864 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
region string Datasource did not contain a description for Region. Column region has 45864 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.
hotel_capacity_and_capacity_utilization int Datasource did not contain a description for Hotel_capacity_and_capacity_utilization. Column hotel_capacity_and_capacity_utilization has 45864 rows, out of which 626 are empty, making the null percent 1.36. Minimum value is 6 and maximum value is 120638.

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

Column Type Comment
code string The code for the dimension value. Column code has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneet and maximum string is Vrk_hinta.
label string The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Number of bed-places and maximum string is Price per night, €.
orig_extractdate string The date when the data was originally fetched from the source.

Dim region, Statfinpas matk pxt 001 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.

Additional Info

Last Updated September 20, 2019
Created August 4, 2019