117 s -- Accommodation establishment capacity by municipality, 1995-2018

Tables

Dim municipality, Statfin matk pxt 117s px, Full historyTSV
Dimension Municipality (Kunta)
Dim municipality, Statfin matk pxt 117s px, LatestTSV
Dimension Municipality (Kunta)
Dim type of establishment, Statfin matk pxt 117s px, Full historyTSV
Dimension Type_of_establishment (Toimiala)
Dim type of establishment, Statfin matk pxt 117s px, LatestTSV
Dimension Type_of_establishment (Toimiala)
Fact, Statfin matk pxt 117s px, Full historyTSV
Accommodation establishment capacity by municipality by Municipality, Type of establishment, Year and Information
Fact, Statfin matk pxt 117s px, LatestTSV
Accommodation establishment capacity by municipality by Municipality, Type of establishment, Year and Information

Column Descriptions

Fact, Statfin matk pxt 117s px, Full history

Column	Type	Comment
municipality	int	Datasource did not contain a description for Municipality. Column municipality has 27552 rows, out of which 96 are empty, making the null percent 0.35. Minimum value is 5 and maximum value is 992.
type_of_establishment	int	Datasource did not contain a description for Type_of_establishment. Column type_of_establishment has 27552 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.
year	int	Datasource did not contain a description for Year. Column year has 27552 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 27552 rows, out of which 20080 are empty, making the null percent 72.88. 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 27552 rows, out of which 20080 are empty, making the null percent 72.88. Minimum value is 0 and maximum value is 69671.
number_of_beds	int	Datasource did not contain a description for Number_of_beds. Column number_of_beds has 27552 rows, out of which 20080 are empty, making the null percent 72.88. Minimum value is 0 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 27552 rows, out of which 20082 are empty, making the null percent 72.89. Minimum value is 0 and maximum value is 23500.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin matk pxt 117s px, Latest

Column	Type	Comment
municipality	int	Datasource did not contain a description for Municipality. Column municipality has 27552 rows, out of which 96 are empty, making the null percent 0.35. Minimum value is 5 and maximum value is 992.
type_of_establishment	int	Datasource did not contain a description for Type_of_establishment. Column type_of_establishment has 27552 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.
year	int	Datasource did not contain a description for Year. Column year has 27552 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 27552 rows, out of which 20080 are empty, making the null percent 72.88. 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 27552 rows, out of which 20080 are empty, making the null percent 72.88. Minimum value is 0 and maximum value is 69671.
number_of_beds	int	Datasource did not contain a description for Number_of_beds. Column number_of_beds has 27552 rows, out of which 20080 are empty, making the null percent 72.88. Minimum value is 0 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 27552 rows, out of which 20082 are empty, making the null percent 72.89. Minimum value is 0 and maximum value is 23500.

Dim type of establishment, Statfin matk pxt 117s 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 type of establishment, Statfin matk pxt 117s 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...

Dim municipality, Statfin matk pxt 117s px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 287 rows, out of which 1 are empty, making the null percent 0.35. Minimum value is 5 and maximum value is 992.
label	string	The label for the dimension value. Column label has 287 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim municipality, Statfin matk pxt 117s px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 287 rows, out of which 1 are empty, making the null percent 0.35. Minimum value is 5 and maximum value is 992.
label	string	The label for the dimension value. Column label has 287 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.

Additional Info

Last Updated	July 22, 2019
Created	July 19, 2019