1. Home
  2. Datasets
  3. 11 f 9 -- Bankruptcies by ...
To download the data set, please sign up or log in

11 f 9 -- Bankruptcies by industry (TOL 2008), 2003 M 01-2019 M 04

11 f 9 -- Bankruptcies by industry (TOL 2008), 2003 M 01-2019 M 04

Tables

Column Descriptions

Dim month, Statfin konk pxt 11f9 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 196 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2003M01 and maximum string is 2019M04.
label string The label for the dimension value. Column label has 196 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2003M01 and maximum string is 2019M04.

Dim legal form, Statfin konk pxt 11f9 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 4.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: General and limited partn... and first 25 characters of maximum string: Others...
orig_extractdate string The date when the data was originally fetched from the source.

Dim industry, Statfin konk pxt 11f9 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 358 rows, out of which 23 are empty, making the null percent 6.42. Minimum value is 1 and maximum value is 990.
label string The label for the dimension value. Column label has 358 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 011 Growing of non-perenn... and first 25 characters of maximum string: Unknown...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin konk pxt 11f9 px, Full history

Column Type Comment
industry int The industrial classification divides units into industry classes based on their main economic activity. The main economic activity is the one that produces a majority of the unit's value added. The classification used is the Finnish national classification (TOL) derived from the statistical classification of economic activities in the European Community (NACE). . Column industry has 350840 rows, out of which 22540 are empty, making the null percent 6.42. Minimum value is 1 and maximum value is 990.
month string Datasource did not contain a description for Month. Column month has 350840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2003M01 and maximum string is 2019M04.
legal_form int Legal form identifies the legal status of a legal person. The classification of legal forms is based on the company forms of the Trade Register and on the requirements of taxation legislation. The legal forms of enterprises and corporations are recorded in the Business Information System. Statistics Finland's classification of legal forms is based on this system and on the Tax Administration's coding of legal forms. Some of the Tax Administration's categories have been combined in Statistics Finland's classification. . Column legal_form has 350840 rows, out of which 70168 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 4.
bankruptcies_instigated_number_of_enterprises int Datasource did not contain a description for Bankruptcies_instigated_number_of_enterprises. Column bankruptcies_instigated_number_of_enterprises has 350840 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 345.
bankruptcies_instigated_number_of_employees int Datasource did not contain a description for Bankruptcies_instigated_number_of_employees. Column bankruptcies_instigated_number_of_employees has 350840 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 2126.
orig_extractdate string The date when the data was originally fetched from the source.

Dim industry, Statfin konk pxt 11f9 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 358 rows, out of which 23 are empty, making the null percent 6.42. Minimum value is 1 and maximum value is 990.
label string The label for the dimension value. Column label has 358 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 011 Growing of non-perenn... and first 25 characters of maximum string: Unknown...

Dim month, Statfin konk pxt 11f9 px, Full history

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

Fact, Statfin konk pxt 11f9 px, Latest

Column Type Comment
industry int The industrial classification divides units into industry classes based on their main economic activity. The main economic activity is the one that produces a majority of the unit's value added. The classification used is the Finnish national classification (TOL) derived from the statistical classification of economic activities in the European Community (NACE). . Column industry has 350840 rows, out of which 22540 are empty, making the null percent 6.42. Minimum value is 1 and maximum value is 990.
month string Datasource did not contain a description for Month. Column month has 350840 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2003M01 and maximum string is 2019M04.
legal_form int Legal form identifies the legal status of a legal person. The classification of legal forms is based on the company forms of the Trade Register and on the requirements of taxation legislation. The legal forms of enterprises and corporations are recorded in the Business Information System. Statistics Finland's classification of legal forms is based on this system and on the Tax Administration's coding of legal forms. Some of the Tax Administration's categories have been combined in Statistics Finland's classification. . Column legal_form has 350840 rows, out of which 70168 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 4.
bankruptcies_instigated_number_of_enterprises int Datasource did not contain a description for Bankruptcies_instigated_number_of_enterprises. Column bankruptcies_instigated_number_of_enterprises has 350840 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 345.
bankruptcies_instigated_number_of_employees int Datasource did not contain a description for Bankruptcies_instigated_number_of_employees. Column bankruptcies_instigated_number_of_employees has 350840 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 2126.

Dim legal form, Statfin konk pxt 11f9 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 1 and maximum value is 4.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: General and limited partn... and first 25 characters of maximum string: Others...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019