007 -- Household-dwelling units with housing loan by age of reference person, major region and rate of indebtedness 2002-2016, in 2016 money

Tables

Dim age of reference person, Statfinpas velk pxt 007 201600 px, Full historyTSV
Dimension Age_of_reference_person (Viitehenkilön ikä)
Dim age of reference person, Statfinpas velk pxt 007 201600 px, LatestTSV
Dimension Age_of_reference_person (Viitehenkilön ikä)
Dim data, Statfinpas velk pxt 007 201600 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfinpas velk pxt 007 201600 px, LatestTSV
Dimension Data (Tiedot)
Dim major region, Statfinpas velk pxt 007 201600 px, Full historyTSV
Dimension Major_region (Suuralue)
Dim major region, Statfinpas velk pxt 007 201600 px, LatestTSV
Dimension Major_region (Suuralue)
Dim rate of indeptedness, Statfinpas velk pxt 007 201600 px, Full historyTSV
Dimension Rate_of_indeptedness (Velkaantumisaste)
Dim rate of indeptedness, Statfinpas velk pxt 007 201600 px, LatestTSV
Dimension Rate_of_indeptedness (Velkaantumisaste)
Dim year, Statfinpas velk pxt 007 201600 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas velk pxt 007 201600 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas velk pxt 007 201600 px, Full historyTSV
Household-dwelling units with housing loan by Year, Major region, Age of reference person, Rate of indeptedness and Data
Fact, Statfinpas velk pxt 007 201600 px, LatestTSV
Household-dwelling units with housing loan by Year, Major region, Age of reference person, Rate of indeptedness and Data

Column Descriptions

Dim rate of indeptedness, Statfinpas velk pxt 007 201600 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 15 rows, out of which 1 are empty, making the null percent 6.67. Minimum value is 1 and maximum value is 14.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 100-150 and maximum string is 500-.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asukorot and maximum string is Kturaha.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Debts total... and first 25 characters of maximum string: Disposable monetary incom...

Fact, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
year	int	2002-2013 . Column year has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2016.
major_region	string	Regional classification 2013 . Column major_region has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is 5.
age_of_reference_person	int	Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 165375 rows, out of which 141750 are empty, making the null percent 85.71. Constant value is -24.
rate_of_indeptedness	int	Datasource did not contain a description for Rate_of_indeptedness. Column rate_of_indeptedness has 165375 rows, out of which 11025 are empty, making the null percent 6.67. Minimum value is 1 and maximum value is 14.
data	string	Datasource did not contain a description for Data. Column data has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asukorot and maximum string is Kturaha.
7_householddwelling_units_with_housing_loan	int	Datasource did not contain a description for 7_Householddwelling_units_with_housing_loan. Column 7_householddwelling_units_with_housing_loan has 165375 rows, out of which 2312 are empty, making the null percent 1.40. Minimum value is 0 and maximum value is 2147308407.

Dim age of reference person, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 6 are empty, making the null percent 85.71. Constant value is -24.
label	int	The label for the dimension value. Column label has 7 rows, out of which 6 are empty, making the null percent 85.71. Constant value is -24.

Dim year, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2016.
label	int	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2016.

Dim age of reference person, Statfinpas velk pxt 007 201600 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 6 are empty, making the null percent 85.71. Constant value is -24.
label	int	The label for the dimension value. Column label has 7 rows, out of which 6 are empty, making the null percent 85.71. Constant value is -24.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim major region, Statfinpas velk pxt 007 201600 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 5.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Capital district and maximum string is Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfinpas velk pxt 007 201600 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asukorot and maximum string is Kturaha.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Debts total... and first 25 characters of maximum string: Disposable monetary incom...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas velk pxt 007 201600 px, Full history

Column	Type	Comment
year	int	2002-2013 . Column year has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2002 and maximum value is 2016.
major_region	string	Regional classification 2013 . Column major_region has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is 5.
age_of_reference_person	int	Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 165375 rows, out of which 141750 are empty, making the null percent 85.71. Constant value is -24.
rate_of_indeptedness	int	Datasource did not contain a description for Rate_of_indeptedness. Column rate_of_indeptedness has 165375 rows, out of which 11025 are empty, making the null percent 6.67. Minimum value is 1 and maximum value is 14.
data	string	Datasource did not contain a description for Data. Column data has 165375 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asukorot and maximum string is Kturaha.
7_householddwelling_units_with_housing_loan	int	Datasource did not contain a description for 7_Householddwelling_units_with_housing_loan. Column 7_householddwelling_units_with_housing_loan has 165375 rows, out of which 2312 are empty, making the null percent 1.40. Minimum value is 0 and maximum value is 2147308407.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfinpas velk pxt 007 201600 px, Full history

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

Dim major region, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 5.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Capital district and maximum string is Åland.

Dim rate of indeptedness, Statfinpas velk pxt 007 201600 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 15 rows, out of which 1 are empty, making the null percent 6.67. Minimum value is 1 and maximum value is 14.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 100-150 and maximum string is 500-.

Additional Info

Last Updated	September 20, 2019
Created	August 5, 2019