001 -- Hotel capacity and capacity utilization
Tables
-
Dim information, Statfinpas matk pxt 001 201812 en px, Full historyTSV
Dimension Information (Information)
-
Dim information, Statfinpas matk pxt 001 201812 en px, LatestTSV
Dimension Information (Information)
-
Dim month, Statfinpas matk pxt 001 201812 en px, Full historyTSV
Dimension Month (Month)
-
Dim month, Statfinpas matk pxt 001 201812 en px, LatestTSV
Dimension Month (Month)
-
Dim region, Statfinpas matk pxt 001 201812 en px, Full historyTSV
Dimension Region (Region)
-
Dim region, Statfinpas matk pxt 001 201812 en px, LatestTSV
Dimension Region (Region)
-
Dim year, Statfinpas matk pxt 001 201812 en px, Full historyTSV
Dimension Year (Year)
-
Dim year, Statfinpas matk pxt 001 201812 en px, LatestTSV
Dimension Year (Year)
-
Fact, Statfinpas matk pxt 001 201812 en px, Full historyTSV
Hotel capacity and capacity utilization by Year, Month, Information and Region
-
Fact, Statfinpas matk pxt 001 201812 en px, LatestTSV
Hotel capacity and capacity utilization by Year, Month, Information and Region
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 |