11 j 1 -- Yearly nights spent and arrivals by country of residence, 1995-2019*

Tables

Dim country, Statfin matk pxt 11j1 px, Full historyTSV
Dimension Country (Maa)
Dim country, Statfin matk pxt 11j1 px, LatestTSV
Dimension Country (Maa)
Dim region, Statfin matk pxt 11j1 px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin matk pxt 11j1 px, LatestTSV
Dimension Region (Maakunta)
Dim type of accommodation establishment, Statfin matk pxt 11j1 px, Full historyTSV
Dimension Type_of_accommodation_establishment (Majoitusliikkeen tyyppi)
Dim type of accommodation establishment, Statfin matk pxt 11j1 px, LatestTSV
Dimension Type_of_accommodation_establishment (Majoitusliikkeen tyyppi)
Dim year, Statfin matk pxt 11j1 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin matk pxt 11j1 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin matk pxt 11j1 px, Full historyTSV
Yearly nights spent and arrivals by country of residence by Region, Country, Type of accommodation establishment, Year and Information
Fact, Statfin matk pxt 11j1 px, LatestTSV
Yearly nights spent and arrivals by country of residence by Region, Country, Type of accommodation establishment, Year and Information

Column Descriptions

Dim region, Statfin matk pxt 11j1 px, Full history

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.

Dim region, Statfin matk pxt 11j1 px, Latest

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.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 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 2019.
label	int	The label for the dimension value. Column label has 25 rows, out of which 1 are empty, making the null percent 4.00. Minimum value is 1995 and maximum value is 2018.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin matk pxt 11j1 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 25 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 2019.
label	int	The label for the dimension value. Column label has 25 rows, out of which 1 are empty, making the null percent 4.00. Minimum value is 1995 and maximum value is 2018.

Dim country, Statfin matk pxt 11j1 px, Full history

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

Dim country, Statfin matk pxt 11j1 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is C020.
label	string	The label for the dimension value. Column label has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Africa and maximum string is China.

Fact, Statfin matk pxt 11j1 px, Full history

Column	Type	Comment
region	string	Maakunta . Column region has 30450 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.
country	string	Datasource did not contain a description for Country. Column country has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is C020.
type_of_accommodation_establishment	int	Datasource did not contain a description for Type_of_accommodation_establishment. Column type_of_accommodation_establishment has 30450 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 2.
year	int	* preliminary data . Column year has 30450 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 2019.
arrivals	int	Datasource did not contain a description for Arrivals. Column arrivals has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 20 and maximum value is 11967117.
nights_spent	int	Datasource did not contain a description for Nights_spent. Column nights_spent has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 50 and maximum value is 22235084.
change_of_nights_spent	int	Datasource did not contain a description for Change_of_nights_spent. Column change_of_nights_spent has 30450 rows, out of which 1584 are empty, making the null percent 5.20. Minimum value is -94 and maximum value is 496.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin matk pxt 11j1 px, Latest

Column	Type	Comment
region	string	Maakunta . Column region has 30450 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.
country	string	Datasource did not contain a description for Country. Column country has 30450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is C020.
type_of_accommodation_establishment	int	Datasource did not contain a description for Type_of_accommodation_establishment. Column type_of_accommodation_establishment has 30450 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 2.
year	int	* preliminary data . Column year has 30450 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 2019.
arrivals	int	Datasource did not contain a description for Arrivals. Column arrivals has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 20 and maximum value is 11967117.
nights_spent	int	Datasource did not contain a description for Nights_spent. Column nights_spent has 30450 rows, out of which 322 are empty, making the null percent 1.06. Minimum value is 50 and maximum value is 22235084.
change_of_nights_spent	int	Datasource did not contain a description for Change_of_nights_spent. Column change_of_nights_spent has 30450 rows, out of which 1584 are empty, making the null percent 5.20. Minimum value is -94 and maximum value is 496.

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

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

Dim type of accommodation establishment, Statfin matk pxt 11j1 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 2 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 2.
label	string	The label for the dimension value. Column label has 2 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: Hotels...

Additional Info

Last Updated	July 21, 2019
Created	July 16, 2019