1. Home
  2. Datasets
  3. 114 j -- Household-dwelling ...
To download the data set, please sign up or log in

114 j -- Household-dwelling units with housing loan by age, debt class and major region, in 2017 money, 2002-2017

114 j -- Household-dwelling units with housing loan by age, debt class and major region, in 2017 money, 2002-2017

Tables

Column Descriptions

Fact, Statfin velk pxt 114j px, Full history

Column Type Comment
major_region int Datasource did not contain a description for Major_region. Column major_region has 9163 rows, out of which 1309 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 5.
age_of_reference_person int Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 9163 rows, out of which 1309 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
year int Datasource did not contain a description for Year. Column year has 9163 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 2018.
debt_class int Datasource did not contain a description for Debt_class. Column debt_class has 9163 rows, out of which 833 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 10.
householddwelling_units_with_housing_loans_number int Datasource did not contain a description for Householddwelling_units_with_housing_loans_number. Column householddwelling_units_with_housing_loans_number has 9163 rows, out of which 19 are empty, making the null percent 0.21. Minimum value is 1 and maximum value is 879531.
housing_loans_eur int Datasource did not contain a description for Housing_loans_EUR. Column housing_loans_eur has 9163 rows, out of which 998 are empty, making the null percent 10.89. Minimum value is 849 and maximum value is 2142720948.
interest_from_housing_loans_eur int Datasource did not contain a description for Interest_from_housing_loans_EUR. Column interest_from_housing_loans_eur has 9163 rows, out of which 22 are empty, making the null percent 0.24. Minimum value is 0 and maximum value is 2055745930.
other_debts_of_households_with_housing_loans_eur int Definition of Other debts is changed, see Concepts and definitions. . Column other_debts_of_households_with_housing_loans_eur has 9163 rows, out of which 178 are empty, making the null percent 1.94. Minimum value is 0 and maximum value is 2134819487.
study_loans_of_households_with_housing_loan_eur int From year 2015 on are study loans included in other debts. . Column study_loans_of_households_with_housing_loan_eur has 9163 rows, out of which 19 are empty, making the null percent 0.21. Minimum value is 0 and maximum value is 607050434.
loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_eur int Datasource did not contain a description for Loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_EUR. Column loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_eur has 9163 rows, out of which 42 are empty, making the null percent 0.46. Minimum value is 0 and maximum value is 1994682713.
debts_total_of_households_with_housing_loan_eur int Datasource did not contain a description for Debts_total_of_households_with_housing_loan_EUR. Column debts_total_of_households_with_housing_loan_eur has 9163 rows, out of which 1172 are empty, making the null percent 12.79. Minimum value is 849 and maximum value is 2144919425.
interest_total_eur int Datasource did not contain a description for Interest_total_EUR. Column interest_total_eur has 9163 rows, out of which 27 are empty, making the null percent 0.29. Minimum value is 10 and maximum value is 2088631204.
disposable_monetary_income_of_households_with_housing_loan_eur int Datasource did not contain a description for Disposable_monetary_income_of_households_with_housing_loan_EUR. Column disposable_monetary_income_of_households_with_housing_loan_eur has 9163 rows, out of which 576 are empty, making the null percent 6.29. Minimum value is 0 and maximum value is 2146849565.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age of reference person, Statfin velk pxt 114j 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 1 and maximum value is 6.
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 0-24 and maximum string is 65-.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age of reference person, Statfin velk pxt 114j 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 1 and maximum value is 6.
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 0-24 and maximum string is 65-.

Fact, Statfin velk pxt 114j px, Latest

Column Type Comment
major_region int Datasource did not contain a description for Major_region. Column major_region has 9163 rows, out of which 1309 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 5.
age_of_reference_person int Datasource did not contain a description for Age_of_reference_person. Column age_of_reference_person has 9163 rows, out of which 1309 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
year int Datasource did not contain a description for Year. Column year has 9163 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 2018.
debt_class int Datasource did not contain a description for Debt_class. Column debt_class has 9163 rows, out of which 833 are empty, making the null percent 9.09. Minimum value is 1 and maximum value is 10.
householddwelling_units_with_housing_loans_number int Datasource did not contain a description for Householddwelling_units_with_housing_loans_number. Column householddwelling_units_with_housing_loans_number has 9163 rows, out of which 19 are empty, making the null percent 0.21. Minimum value is 1 and maximum value is 879531.
housing_loans_eur int Datasource did not contain a description for Housing_loans_EUR. Column housing_loans_eur has 9163 rows, out of which 998 are empty, making the null percent 10.89. Minimum value is 849 and maximum value is 2142720948.
interest_from_housing_loans_eur int Datasource did not contain a description for Interest_from_housing_loans_EUR. Column interest_from_housing_loans_eur has 9163 rows, out of which 22 are empty, making the null percent 0.24. Minimum value is 0 and maximum value is 2055745930.
other_debts_of_households_with_housing_loans_eur int Definition of Other debts is changed, see Concepts and definitions. . Column other_debts_of_households_with_housing_loans_eur has 9163 rows, out of which 178 are empty, making the null percent 1.94. Minimum value is 0 and maximum value is 2134819487.
study_loans_of_households_with_housing_loan_eur int From year 2015 on are study loans included in other debts. . Column study_loans_of_households_with_housing_loan_eur has 9163 rows, out of which 19 are empty, making the null percent 0.21. Minimum value is 0 and maximum value is 607050434.
loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_eur int Datasource did not contain a description for Loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_EUR. Column loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_of_households_with_housing_loan_eur has 9163 rows, out of which 42 are empty, making the null percent 0.46. Minimum value is 0 and maximum value is 1994682713.
debts_total_of_households_with_housing_loan_eur int Datasource did not contain a description for Debts_total_of_households_with_housing_loan_EUR. Column debts_total_of_households_with_housing_loan_eur has 9163 rows, out of which 1172 are empty, making the null percent 12.79. Minimum value is 849 and maximum value is 2144919425.
interest_total_eur int Datasource did not contain a description for Interest_total_EUR. Column interest_total_eur has 9163 rows, out of which 27 are empty, making the null percent 0.29. Minimum value is 10 and maximum value is 2088631204.
disposable_monetary_income_of_households_with_housing_loan_eur int Datasource did not contain a description for Disposable_monetary_income_of_households_with_housing_loan_EUR. Column disposable_monetary_income_of_households_with_housing_loan_eur has 9163 rows, out of which 576 are empty, making the null percent 6.29. Minimum value is 0 and maximum value is 2146849565.

Dim major region, Statfin velk pxt 114j 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 major region, Statfin velk pxt 114j 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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019