Accommodation establishment capacity by region

Tables

Dim Information, Accommodation Establishment Capacity By RegionTSV
Dimension Information (Information)
Dim Opening Period, Accommodation Establishment Capacity By RegionTSV
Dimension Opening_period (Opening period)
Dim Region, Accommodation Establishment Capacity By RegionTSV
Dimension Region (Region)
Dim Size Category, Accommodation Establishment Capacity By RegionTSV
Dimension Size_category (Size category)
Dim Type Of Establishment, Accommodation Establishment Capacity By RegionTSV
Dimension Type_of_establishment (Type of establishment)
Dim Year, Accommodation Establishment Capacity By RegionTSV
Dimension Year (Year)
Fact, Accommodation Establishment Capacity By RegionTSV
Accommodation establishment capacity by region by Region, Opening period, Size category, Year, Information and Type of establishment

Column Descriptions

Fact, Accommodation Establishment Capacity By Region

Column	Type	Comment
region	string	Datasource did not contain a description for Region. Column region has 105600 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.
opening_period	string	Datasource did not contain a description for Opening_period. Column opening_period has 105600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is All opening periods and maximum string is Open all year round.
size_category	string	Datasource did not contain a description for Size_category. Column size_category has 105600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 19 rooms and maximum string is Min. 100 rooms.
year	int	Datasource did not contain a description for Year. Column year has 105600 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 2016.
information	string	Datasource did not contain a description for Information. Column information has 105600 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneita and maximum string is Mv_sahko_liitanta.
type_of_establishment	string	Datasource did not contain a description for Type_of_establishment. Column type_of_establishment has 105600 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 establishments... and first 25 characters of maximum string: Other accommodation estab...
accommodation_establishment_capacity_by_region	int	Datasource did not contain a description for Accommodation_establishment_capacity_by_region. Column accommodation_establishment_capacity_by_region has 105600 rows, out of which 41865 are empty, making the null percent 39.64. Minimum value is 0 and maximum value is 162740.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Region, Accommodation Establishment Capacity By Region

Column	Type	Comment
code	string	The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lapland and maximum string is Åland.
label	string	The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lapland and maximum string is Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Opening Period, Accommodation Establishment Capacity By Region

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 All opening periods and maximum string is Open all year round.
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 All opening periods and maximum string is Open all year round.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Size Category, Accommodation Establishment Capacity By Region

Column	Type	Comment
code	string	The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 19 rooms and maximum string is Min. 100 rooms.
label	string	The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 19 rooms and maximum string is Min. 100 rooms.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Year, Accommodation Establishment Capacity By Region

Column	Type	Comment
code	int	The code for the dimension value. Column code has 22 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 2016.
label	int	The label for the dimension value. Column label has 22 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 2016.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Information, Accommodation Establishment Capacity By Region

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Huoneita and maximum string is Mv_sahko_liitanta.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Number of beds and maximum string is Number of caravan places.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Type Of Establishment, Accommodation Establishment Capacity By Region

Column	Type	Comment
code	string	The code for the dimension value. Column code has 4 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 establishments... and first 25 characters of maximum string: Other accommodation estab...
label	string	The label for the dimension value. Column label has 4 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 establishments... and first 25 characters of maximum string: Other accommodation estab...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	April 12, 2019
Created	November 30, 2018