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

002 -- Velkajärjestelyä hakeneet henkilöt

002 -- Velkajärjestelyä hakeneet henkilöt

Tables

Column Descriptions

Dim velallisen ika, Statfinpas velj pxt 002 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is -24 and maximum string is 75+.
orig_extractdate string The date when the data was originally fetched from the source.

Dim asia, Statfinpas velj pxt 002 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm_asia.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Velallisten lkm.
orig_extractdate string The date when the data was originally fetched from the source.

Dim velallisen sukupuoli, Statfinpas velj pxt 002 201700 fi px, Full history

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

Dim velallisen sukupuoli, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Mies and maximum string is Nainen.

Dim perhetyyppi, Statfinpas velj pxt 002 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 6 rows, out of which 1 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
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 Aviopari and maximum string is Tuntematon.
orig_extractdate string The date when the data was originally fetched from the source.

Dim velallisen paaasiallinen toiminta, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 11 and maximum value is 99.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eläkeläinen and maximum string is Erittelemätön.

Dim velallisen paaasiallinen toiminta, Statfinpas velj pxt 002 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 11 and maximum value is 99.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eläkeläinen and maximum string is Erittelemätön.
orig_extractdate string The date when the data was originally fetched from the source.

Dim velallisen ika, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is -24 and maximum string is 75+.

Dim perhetyyppi, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 6 rows, out of which 1 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
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 Aviopari and maximum string is Tuntematon.

Dim asia, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm_asia.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Velallisten lkm.

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

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 11520 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2017.
velallisen_ika int Datasource did not contain a description for Velallisen_ika. Column velallisen_ika has 11520 rows, out of which 1440 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
velallisen_sukupuoli int Datasource did not contain a description for Velallisen_sukupuoli. Column velallisen_sukupuoli has 11520 rows, out of which 3840 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
velallisen_paaasiallinen_toiminta int Datasource did not contain a description for Velallisen_paaasiallinen_toiminta. Column velallisen_paaasiallinen_toiminta has 11520 rows, out of which 1440 are empty, making the null percent 12.50. Minimum value is 11 and maximum value is 99.
perhetyyppi int Datasource did not contain a description for Perhetyyppi. Column perhetyyppi has 11520 rows, out of which 1920 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
asia string Datasource did not contain a description for Asia. Column asia has 11520 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm_asia.
velkajarjestelya_hakeneet_henkilot int Datasource did not contain a description for Velkajarjestelya_hakeneet_henkilot. Column velkajarjestelya_hakeneet_henkilot has 11520 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 4252.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas velj pxt 002 201700 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 11520 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2017.
velallisen_ika int Datasource did not contain a description for Velallisen_ika. Column velallisen_ika has 11520 rows, out of which 1440 are empty, making the null percent 12.50. Minimum value is 1 and maximum value is 7.
velallisen_sukupuoli int Datasource did not contain a description for Velallisen_sukupuoli. Column velallisen_sukupuoli has 11520 rows, out of which 3840 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
velallisen_paaasiallinen_toiminta int Datasource did not contain a description for Velallisen_paaasiallinen_toiminta. Column velallisen_paaasiallinen_toiminta has 11520 rows, out of which 1440 are empty, making the null percent 12.50. Minimum value is 11 and maximum value is 99.
perhetyyppi int Datasource did not contain a description for Perhetyyppi. Column perhetyyppi has 11520 rows, out of which 1920 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
asia string Datasource did not contain a description for Asia. Column asia has 11520 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm_asia.
velkajarjestelya_hakeneet_henkilot int Datasource did not contain a description for Velkajarjestelya_hakeneet_henkilot. Column velkajarjestelya_hakeneet_henkilot has 11520 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 4252.

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

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

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

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

Additional Info

Last Updated March 28, 2024
Created August 6, 2019