1. Home
  2. Datasets
  3. 003 -- Vahvistettujen ...
To download the data set, please sign up or log in

003 -- Vahvistettujen yrityssaneerausohjelmien lkm. käsittelyajoittain sekä niissä olevat varat ja velat käräjäoikeuksittain 2017

003 -- Vahvistettujen yrityssaneerausohjelmien lkm. käsittelyajoittain sekä niissä olevat varat ja velat käräjäoikeuksittain 2017

Tables

Column Descriptions

Dim karajaoikeus, Statfinpas ysan pxt 003 201700 fi 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 702 and maximum value is 764.
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 Espoo and maximum string is Pohjanmaa.

Fact, Statfinpas ysan pxt 003 201700 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 1755 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 1755 rows, out of which 117 are empty, making the null percent 6.67. Minimum value is 702 and maximum value is 764.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1755 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 Makse.
vahvistetut_yrityssaneeraukset int Datasource did not contain a description for Vahvistetut_yrityssaneeraukset. Column vahvistetut_yrityssaneeraukset has 1755 rows, out of which 477 are empty, making the null percent 27.18. Minimum value is 1 and maximum value is 418893.

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

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 1755 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 1755 rows, out of which 117 are empty, making the null percent 6.67. Minimum value is 702 and maximum value is 764.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1755 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 Makse.
vahvistetut_yrityssaneeraukset int Datasource did not contain a description for Vahvistetut_yrityssaneeraukset. Column vahvistetut_yrityssaneeraukset has 1755 rows, out of which 477 are empty, making the null percent 27.18. Minimum value is 1 and maximum value is 418893.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas ysan 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.

Dim vuosi, Statfinpas ysan 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.

Dim karajaoikeus, Statfinpas ysan pxt 003 201700 fi 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 702 and maximum value is 764.
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 Espoo and maximum string is Pohjanmaa.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code string The code for the dimension value. Column code has 13 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 Makse.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Käsittelyaika 10 - 11 kk... and first 25 characters of maximum string: Maksettavaksi määrätty, 1...
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code string The code for the dimension value. Column code has 13 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 Makse.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Käsittelyaika 10 - 11 kk... and first 25 characters of maximum string: Maksettavaksi määrätty, 1...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019