11 is -- Accommodation establishment capacity by region, 1995-2018

Tables

Dim opening period, Statfin matk pxt 11is px, Full historyTSV
Dimension Opening_period (Aukiololuokka)
Dim opening period, Statfin matk pxt 11is px, LatestTSV
Dimension Opening_period (Aukiololuokka)
Dim region, Statfin matk pxt 11is px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin matk pxt 11is px, LatestTSV
Dimension Region (Maakunta)
Dim size category, Statfin matk pxt 11is px, Full historyTSV
Dimension Size_category (Kokoluokka)
Dim size category, Statfin matk pxt 11is px, LatestTSV
Dimension Size_category (Kokoluokka)
Dim type of establishment, Statfin matk pxt 11is px, Full historyTSV
Dimension Type_of_establishment (Toimiala)
Dim type of establishment, Statfin matk pxt 11is px, LatestTSV
Dimension Type_of_establishment (Toimiala)
Dim year, Statfin matk pxt 11is px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin matk pxt 11is px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin matk pxt 11is px, Full historyTSV
Accommodation establishment capacity by region by Region, Type of establishment, Size category, Opening period, Year and Information
Fact, Statfin matk pxt 11is px, LatestTSV
Accommodation establishment capacity by region by Region, Type of establishment, Size category, Opening period, Year and Information

Column Descriptions

Dim region, Statfin matk pxt 11is px, Latest

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 MK01 and maximum string is MK21.
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 Central Finland and maximum string is Åland.

Fact, Statfin matk pxt 11is px, Full history

Column	Type	Comment
region	string	Datasource did not contain a description for Region. Column region has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
type_of_establishment	int	Datasource did not contain a description for Type_of_establishment. Column type_of_establishment has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 4.
size_category	int	Datasource did not contain a description for Size_category. Column size_category has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
opening_period	int	Datasource did not contain a description for Opening_period. Column opening_period has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
year	int	Datasource did not contain a description for Year. Column year has 28800 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 2018.
number_of_establishments	int	Datasource did not contain a description for Number_of_establishments. Column number_of_establishments has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 3 and maximum value is 1499.
number_of_rooms	int	Datasource did not contain a description for Number_of_rooms. Column number_of_rooms has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 2 and maximum value is 69671.
number_of_beds	int	Datasource did not contain a description for Number_of_beds. Column number_of_beds has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 10 and maximum value is 172668.
number_of_caravan_places	int	Datasource did not contain a description for Number_of_caravan_places. Column number_of_caravan_places has 28800 rows, out of which 11487 are empty, making the null percent 39.89. Minimum value is 0 and maximum value is 23500.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin matk pxt 11is px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 24 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 2018.
label	int	The label for the dimension value. Column label has 24 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 2018.

Dim year, Statfin matk pxt 11is px, Full history

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

Dim size category, Statfin matk pxt 11is px, Latest

Column	Type	Comment
code	int	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 value is 0 and maximum value is 4.
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.

Dim type of establishment, Statfin matk pxt 11is px, Latest

Column	Type	Comment
code	int	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 value is 1 and maximum value is 4.
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 accommodation establi... and first 25 characters of maximum string: Other accommodation estab...

Fact, Statfin matk pxt 11is px, Latest

Column	Type	Comment
region	string	Datasource did not contain a description for Region. Column region has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is MK21.
type_of_establishment	int	Datasource did not contain a description for Type_of_establishment. Column type_of_establishment has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 4.
size_category	int	Datasource did not contain a description for Size_category. Column size_category has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
opening_period	int	Datasource did not contain a description for Opening_period. Column opening_period has 28800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
year	int	Datasource did not contain a description for Year. Column year has 28800 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 2018.
number_of_establishments	int	Datasource did not contain a description for Number_of_establishments. Column number_of_establishments has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 3 and maximum value is 1499.
number_of_rooms	int	Datasource did not contain a description for Number_of_rooms. Column number_of_rooms has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 2 and maximum value is 69671.
number_of_beds	int	Datasource did not contain a description for Number_of_beds. Column number_of_beds has 28800 rows, out of which 11472 are empty, making the null percent 39.83. Minimum value is 10 and maximum value is 172668.
number_of_caravan_places	int	Datasource did not contain a description for Number_of_caravan_places. Column number_of_caravan_places has 28800 rows, out of which 11487 are empty, making the null percent 39.89. Minimum value is 0 and maximum value is 23500.

Dim type of establishment, Statfin matk pxt 11is px, Full history

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

Dim opening period, Statfin matk pxt 11is px, Full history

Column	Type	Comment
code	int	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 value is 0 and maximum value is 2.
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 region, Statfin matk pxt 11is px, Full history

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 MK01 and maximum string is MK21.
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 Central Finland and maximum string is Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim size category, Statfin matk pxt 11is px, Full history

Column	Type	Comment
code	int	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 value is 0 and maximum value is 4.
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 opening period, Statfin matk pxt 11is px, Latest

Column	Type	Comment
code	int	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 value is 0 and maximum value is 2.
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.

Additional Info

Last Updated	July 22, 2019
Created	July 20, 2019