11 iz -- Monthly nights spent and arrivals by country of residence, 1995 M 01-2019 M 04*

Tables

Dim country, Statfin matk pxt 11iz px, Full historyTSV
Dimension Country (Maa)
Dim country, Statfin matk pxt 11iz px, LatestTSV
Dimension Country (Maa)
Dim month, Statfin matk pxt 11iz px, Full historyTSV
Dimension Month (Kuukausi)
Dim month, Statfin matk pxt 11iz px, LatestTSV
Dimension Month (Kuukausi)
Dim region, Statfin matk pxt 11iz px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin matk pxt 11iz px, LatestTSV
Dimension Region (Maakunta)
Dim type of accommodation establishment, Statfin matk pxt 11iz px, Full historyTSV
Dimension Type_of_accommodation_establishment (Majoitusliikkeen tyyppi)
Dim type of accommodation establishment, Statfin matk pxt 11iz px, LatestTSV
Dimension Type_of_accommodation_establishment (Majoitusliikkeen tyyppi)
Fact, Statfin matk pxt 11iz px, Full historyTSV
Monthly nights spent and arrivals by country of residence by Region, Country, Type of accommodation establishment, Month and Information
Fact, Statfin matk pxt 11iz px, LatestTSV
Monthly nights spent and arrivals by country of residence by Region, Country, Type of accommodation establishment, Month and Information

Column Descriptions

Fact, Statfin matk pxt 11iz px, Latest

Column	Type	Comment
region	string	Maakunta . Column region has 358092 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 358092 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 358092 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.
month	string	* preliminary data . Column month has 358092 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995M01 and maximum string is 2019M06.
arrivals	int	Datasource did not contain a description for Arrivals. Column arrivals has 358092 rows, out of which 95046 are empty, making the null percent 26.54. Minimum value is 20 and maximum value is 1753767.
nights_spent	int	Datasource did not contain a description for Nights_spent. Column nights_spent has 358092 rows, out of which 95046 are empty, making the null percent 26.54. Minimum value is 50 and maximum value is 3136744.
change_of_nights_spent	int	Datasource did not contain a description for Change_of_nights_spent. Column change_of_nights_spent has 358092 rows, out of which 108653 are empty, making the null percent 30.34. Minimum value is -98 and maximum value is 500.

Fact, Statfin matk pxt 11iz px, Full history

Column	Type	Comment
region	string	Maakunta . Column region has 358092 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 358092 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 358092 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.
month	string	* preliminary data . Column month has 358092 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995M01 and maximum string is 2019M06.
arrivals	int	Datasource did not contain a description for Arrivals. Column arrivals has 358092 rows, out of which 95046 are empty, making the null percent 26.54. Minimum value is 20 and maximum value is 1753767.
nights_spent	int	Datasource did not contain a description for Nights_spent. Column nights_spent has 358092 rows, out of which 95046 are empty, making the null percent 26.54. Minimum value is 50 and maximum value is 3136744.
change_of_nights_spent	int	Datasource did not contain a description for Change_of_nights_spent. Column change_of_nights_spent has 358092 rows, out of which 108653 are empty, making the null percent 30.34. Minimum value is -98 and maximum value is 500.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim type of accommodation establishment, Statfin matk pxt 11iz 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 month, Statfin matk pxt 11iz px, Full history

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

Dim country, Statfin matk pxt 11iz 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.

Dim month, Statfin matk pxt 11iz px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 292 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995M01 and maximum string is 2019M04.
label	string	The label for the dimension value. Column label has 292 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1995M01 and maximum string is 2019M04*.

Dim country, Statfin matk pxt 11iz 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 region, Statfin matk pxt 11iz 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 region, Statfin matk pxt 11iz 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 type of accommodation establishment, Statfin matk pxt 11iz 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	September 22, 2019
Created	August 6, 2019