To download the data set, please sign up or log in

003 -- Loppuun käsitellyt yksityishenkilöiden velkajärjestelyasiat käräjäoikeuksittain

003 -- Loppuun käsitellyt yksityishenkilöiden velkajärjestelyasiat käräjäoikeuksittain

Tables

Column Descriptions

Dim karajaoikeus, Statfinpas velj pxt 003 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 28 rows, out of which 1 are empty, making the null percent 3.57. Minimum value is 702 and maximum value is 771.
label string The label for the dimension value. Column label has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa and maximum string is Kemi-Tornio.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas velj pxt 003 201700 fi px, Full history

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

Fact, Statfinpas velj pxt 003 201700 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2017.
karajaoikeus int Datasource did not contain a description for Karajaoikeus. Column karajaoikeus has 16632 rows, out of which 594 are empty, making the null percent 3.57. Minimum value is 702 and maximum value is 771.
asian_laatu string Datasource did not contain a description for Asian_laatu. Column asian_laatu has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Au1 and maximum string is Au10.
loppuun_kasitellyt_velkajarjestelyt int Datasource did not contain a description for Loppuun_kasitellyt_velkajarjestelyt. Column loppuun_kasitellyt_velkajarjestelyt has 16632 rows, out of which 7529 are empty, making the null percent 45.27. Minimum value is 0 and maximum value is 5225.

Dim tiedot, Statfinpas velj pxt 003 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Au1 and maximum string is Au10.
label string The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asia siirretty and maximum string is Maksuohjelma vahvistettu.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas velj pxt 003 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Au1 and maximum string is Au10.
label string The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asia siirretty and maximum string is Maksuohjelma vahvistettu.

Dim asian laatu, Statfinpas velj pxt 003 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.
orig_extractdate string The date when the data was originally fetched from the source.

Dim asian laatu, Statfinpas velj pxt 003 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.

Dim karajaoikeus, Statfinpas velj pxt 003 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 28 rows, out of which 1 are empty, making the null percent 3.57. Minimum value is 702 and maximum value is 771.
label string The label for the dimension value. Column label has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa and maximum string is Kemi-Tornio.

Dim vuosi, Statfinpas velj pxt 003 201700 fi px, Latest

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

Fact, Statfinpas velj pxt 003 201700 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2017.
karajaoikeus int Datasource did not contain a description for Karajaoikeus. Column karajaoikeus has 16632 rows, out of which 594 are empty, making the null percent 3.57. Minimum value is 702 and maximum value is 771.
asian_laatu string Datasource did not contain a description for Asian_laatu. Column asian_laatu has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asiat yhteensä and maximum string is Muu velkajärjestelyasia.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 16632 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Au1 and maximum string is Au10.
loppuun_kasitellyt_velkajarjestelyt int Datasource did not contain a description for Loppuun_kasitellyt_velkajarjestelyt. Column loppuun_kasitellyt_velkajarjestelyt has 16632 rows, out of which 7529 are empty, making the null percent 45.27. Minimum value is 0 and maximum value is 5225.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated August 4, 2019
Created August 2, 2019