1. Home
  2. Datasets
  3. 113 p -- Debts of ...
To download the data set, please sign up or log in

113 p -- Debts of household-dwelling units by mucipalities, in 2017 money, 2002-2017

113 p -- Debts of household-dwelling units by mucipalities, in 2017 money, 2002-2017

Tables

Column Descriptions

Dim year, Statfin velk pxt 113p px, Full history

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

Dim year, Statfin velk pxt 113p px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 16 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 2017.
label int The label for the dimension value. Column label has 16 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 2017.

Fact, Statfin velk pxt 113p px, Full history

Column Type Comment
municipality int Datasource did not contain a description for Municipality. Column municipality has 4992 rows, out of which 16 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
year int Datasource did not contain a description for Year. Column year has 4992 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 2017.
householddwelling_units_number int Datasource did not contain a description for Householddwelling_units_number. Column householddwelling_units_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 51 and maximum value is 2680077.
housing_loans_eur int Datasource did not contain a description for Housing_loans_EUR. Column housing_loans_eur has 4992 rows, out of which 96 are empty, making the null percent 1.92. Minimum value is 265044 and maximum value is 2144151183.
householddwelling_units_with_housing_loasn_number int Datasource did not contain a description for Householddwelling_units_with_housing_loasn_number. Column householddwelling_units_with_housing_loasn_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9 and maximum value is 879531.
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 4992 rows, out of which 3 are empty, making the null percent 0.06. Minimum value is 7840 and maximum value is 2089725125.
other_debts_eur int Definition of Other debts is changed, see Concepts and definitions. . Column other_debts_eur has 4992 rows, out of which 27 are empty, making the null percent 0.54. Minimum value is 188084 and maximum value is 2107002150.
householddwelling_units_with_other_debts_number int Datasource did not contain a description for Householddwelling_units_with_other_debts_number. Column householddwelling_units_with_other_debts_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12 and maximum value is 1177198.
interest_from_other_debts_eur int Datasource did not contain a description for Interest_from_other_debts_EUR. Column interest_from_other_debts_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7029 and maximum value is 1356146433.
study_loans_eur int From year 2015 on are study loans included in other debts. . Column study_loans_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1856002579.
householddwelling_units_with_study_loans_number int From year 2015 on are study loans included in other debts. . Column householddwelling_units_with_study_loans_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 300606.
interest_from_study_loans_eur int Datasource did not contain a description for Interest_from_study_loans_EUR. Column interest_from_study_loans_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 96635993.
loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_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_EUR. Column loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_eur has 4992 rows, out of which 16 are empty, making the null percent 0.32. Minimum value is 63606 and maximum value is 1183952555.
householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number int Datasource did not contain a description for Householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number. Column householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3 and maximum value is 113767.
interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_eur int Datasource did not contain a description for Interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_EUR. Column interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2337 and maximum value is 329455062.
debts_tota_eur int Datasource did not contain a description for Debts_tota_EUR. Column debts_tota_eur has 4992 rows, out of which 134 are empty, making the null percent 2.68. Minimum value is 1126541 and maximum value is 2133523927.
householddwelling_units_with_debts_number int Datasource did not contain a description for Householddwelling_units_with_debts_number. Column householddwelling_units_with_debts_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24 and maximum value is 1519397.
interest_total_eur int Datasource did not contain a description for Interest_total_EUR. Column interest_total_eur has 4992 rows, out of which 11 are empty, making the null percent 0.22. Minimum value is 21547 and maximum value is 2015702191.
disposable_monetary_income_eur int Datasource did not contain a description for Disposable_monetary_income_EUR. Column disposable_monetary_income_eur has 4992 rows, out of which 128 are empty, making the null percent 2.56. Minimum value is 2365962 and maximum value is 2142003738.
orig_extractdate string The date when the data was originally fetched from the source.

Dim municipality, Statfin velk pxt 113p px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim municipality, Statfin velk pxt 113p px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 312 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.

Fact, Statfin velk pxt 113p px, Latest

Column Type Comment
municipality int Datasource did not contain a description for Municipality. Column municipality has 4992 rows, out of which 16 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
year int Datasource did not contain a description for Year. Column year has 4992 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 2017.
householddwelling_units_number int Datasource did not contain a description for Householddwelling_units_number. Column householddwelling_units_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 51 and maximum value is 2680077.
housing_loans_eur int Datasource did not contain a description for Housing_loans_EUR. Column housing_loans_eur has 4992 rows, out of which 96 are empty, making the null percent 1.92. Minimum value is 265044 and maximum value is 2144151183.
householddwelling_units_with_housing_loasn_number int Datasource did not contain a description for Householddwelling_units_with_housing_loasn_number. Column householddwelling_units_with_housing_loasn_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 9 and maximum value is 879531.
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 4992 rows, out of which 3 are empty, making the null percent 0.06. Minimum value is 7840 and maximum value is 2089725125.
other_debts_eur int Definition of Other debts is changed, see Concepts and definitions. . Column other_debts_eur has 4992 rows, out of which 27 are empty, making the null percent 0.54. Minimum value is 188084 and maximum value is 2107002150.
householddwelling_units_with_other_debts_number int Datasource did not contain a description for Householddwelling_units_with_other_debts_number. Column householddwelling_units_with_other_debts_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12 and maximum value is 1177198.
interest_from_other_debts_eur int Datasource did not contain a description for Interest_from_other_debts_EUR. Column interest_from_other_debts_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 7029 and maximum value is 1356146433.
study_loans_eur int From year 2015 on are study loans included in other debts. . Column study_loans_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1856002579.
householddwelling_units_with_study_loans_number int From year 2015 on are study loans included in other debts. . Column householddwelling_units_with_study_loans_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 300606.
interest_from_study_loans_eur int Datasource did not contain a description for Interest_from_study_loans_EUR. Column interest_from_study_loans_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 96635993.
loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_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_EUR. Column loans_taken_up_for_the_purpose_of_acquiring_income_or_charged_on_a_source_of_income_eur has 4992 rows, out of which 16 are empty, making the null percent 0.32. Minimum value is 63606 and maximum value is 1183952555.
householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number int Datasource did not contain a description for Householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number. Column householddwelling_units_with_loans_taken_up_for_the_purpose_of_acquiring_income_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3 and maximum value is 113767.
interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_eur int Datasource did not contain a description for Interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_EUR. Column interest_from_loans_taken_up_for_the_purpose_of_acquiring_income_eur has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2337 and maximum value is 329455062.
debts_tota_eur int Datasource did not contain a description for Debts_tota_EUR. Column debts_tota_eur has 4992 rows, out of which 134 are empty, making the null percent 2.68. Minimum value is 1126541 and maximum value is 2133523927.
householddwelling_units_with_debts_number int Datasource did not contain a description for Householddwelling_units_with_debts_number. Column householddwelling_units_with_debts_number has 4992 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24 and maximum value is 1519397.
interest_total_eur int Datasource did not contain a description for Interest_total_EUR. Column interest_total_eur has 4992 rows, out of which 11 are empty, making the null percent 0.22. Minimum value is 21547 and maximum value is 2015702191.
disposable_monetary_income_eur int Datasource did not contain a description for Disposable_monetary_income_EUR. Column disposable_monetary_income_eur has 4992 rows, out of which 128 are empty, making the null percent 2.56. Minimum value is 2365962 and maximum value is 2142003738.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019