005 -- Accommodation establishment capacity by municipality

Tables

Dim Information, T005 Accommodation Establishment Capacity By MunicipalityTSV
Dimension Information (Information)
Dim Municipality, T005 Accommodation Establishment Capacity By MunicipalityTSV
Dimension Municipality (Municipality)
Dim Type Of Establishment, T005 Accommodation Establishment Capacity By MunicipalityTSV
Dimension Type_of_establishment (Type of establishment)
Dim Year, T005 Accommodation Establishment Capacity By MunicipalityTSV
Dimension Year (Year)
Fact, T005 Accommodation Establishment Capacity By MunicipalityTSV
Accommodation establishment capacity by municipality by Municipality, Year, Information and Type of establishment

Column Descriptions

Fact, T005 Accommodation Establishment Capacity By Municipality

Column	Type	Comment
municipality	string	Datasource did not contain a description for Municipality. Column municipality has 105984 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.
year	int	Datasource did not contain a description for Year. Column year has 105984 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 2017.
information	string	Datasource did not contain a description for Information. Column information has 105984 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 105984 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_municipality	int	Datasource did not contain a description for Accommodation_establishment_capacity_by_municipality. Column accommodation_establishment_capacity_by_municipality has 105984 rows, out of which 77289 are empty, making the null percent 72.93. Minimum value is 0 and maximum value is 170092.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim Municipality, T005 Accommodation Establishment Capacity By Municipality

Column	Type	Comment
code	string	The code for the dimension value. Column code has 288 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.
label	string	The label for the dimension value. Column label has 288 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 Type Of Establishment, T005 Accommodation Establishment Capacity By Municipality

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.

Dim Year, T005 Accommodation Establishment Capacity By Municipality

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

Dim Information, T005 Accommodation Establishment Capacity By Municipality

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.

Additional Info

Last Updated	April 14, 2019
Created	April 11, 2019