Dataset

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

003 -- Accommodation establishment capacity and capacity utilization

003 -- Accommodation establishment capacity and capacity utilization

Tables

Dim Information, T003 Accommodation Establishment Capacity And Capacity UtilizationTSV
Dimension Information (Information)
Dim Month, T003 Accommodation Establishment Capacity And Capacity UtilizationTSV
Dimension Month (Month)
Dim Region, T003 Accommodation Establishment Capacity And Capacity UtilizationTSV
Dimension Region (Region)
Dim Year, T003 Accommodation Establishment Capacity And Capacity UtilizationTSV
Dimension Year (Year)
Fact, T003 Accommodation Establishment Capacity And Capacity UtilizationTSV
Accommodation establishment capacity and capacity utilization by Year, Month, Information and Region

Column Descriptions

Fact, T003 Accommodation Establishment Capacity And Capacity Utilization

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.
accommodation_establishment_capacity_and_capacity_utilization	int	Datasource did not contain a description for Accommodation_establishment_capacity_and_capacity_utilization. Column accommodation_establishment_capacity_and_capacity_utilization has 45864 rows, out of which 627 are empty, making the null percent 1.37. Minimum value is 5 and maximum value is 173344.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Year, T003 Accommodation Establishment Capacity And Capacity Utilization

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, T003 Accommodation Establishment Capacity And Capacity Utilization

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, T003 Accommodation Establishment Capacity And Capacity Utilization

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, T003 Accommodation Establishment Capacity And Capacity Utilization

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	April 15, 2019
Created	April 12, 2019