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

Teollisuuden tilinpäätöstiedot 2005-2008 (TOL 2002)

Teollisuuden tilinpäätöstiedot 2005-2008 (TOL 2002)

Tables

Column Descriptions

Fact, T020 tetipa tau 101 fi px, Full history

Column Type Comment
toimiala_tol_2002 int Datasource did not contain a description for Toimiala_TOL_2002. Column toimiala_tol_2002 has 17160 rows, out of which 5280 are empty, making the null percent 30.77. Minimum value is 10 and maximum value is 361.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKVELAT.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2008.
yrityksen_pksuuruusluokka_eumaaritelm string Datasource did not contain a description for Yrityksen_PKsuuruusluokka_EUmaaritelm. Column yrityksen_pksuuruusluokka_eumaaritelm has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yrity and maximum string is Pk-yritykset.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 17160 rows, out of which 936 are empty, making the null percent 5.45. Minimum value is -219878784 and maximum value is 470395758.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T020 tetipa tau 101 fi px, Latest

Column Type Comment
toimiala_tol_2002 int Datasource did not contain a description for Toimiala_TOL_2002. Column toimiala_tol_2002 has 17160 rows, out of which 5280 are empty, making the null percent 30.77. Minimum value is 10 and maximum value is 361.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKVELAT.
tilastovuosi int Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2008.
yrityksen_pksuuruusluokka_eumaaritelm string Datasource did not contain a description for Yrityksen_PKsuuruusluokka_EUmaaritelm. Column yrityksen_pksuuruusluokka_eumaaritelm has 17160 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yrity and maximum string is Pk-yritykset.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 17160 rows, out of which 936 are empty, making the null percent 5.45. Minimum value is -219878784 and maximum value is 470395758.

Dim toimiala tol 2002, T020 tetipa tau 101 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 39 rows, out of which 12 are empty, making the null percent 30.77. Minimum value is 10 and maximum value is 361.
label string The label for the dimension value. Column label has 39 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Kivi- ja ruskohiilen k... and first 25 characters of maximum string: 41 Veden puhdistus ja jak...

Dim toimiala tol 2002, T020 tetipa tau 101 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 39 rows, out of which 12 are empty, making the null percent 30.77. Minimum value is 10 and maximum value is 361.
label string The label for the dimension value. Column label has 39 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 10 Kivi- ja ruskohiilen k... and first 25 characters of maximum string: 41 Veden puhdistus ja jak...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, T020 tetipa tau 101 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 55 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKVELAT.
label string The label for the dimension value. Column label has 55 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineelliset nettoinvestoi... and first 25 characters of maximum string: Kokonaisvelat/liikevaihto...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, T020 tetipa tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 55 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AINETARV and maximum string is KOKVELAT.
label string The label for the dimension value. Column label has 55 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineelliset nettoinvestoi... and first 25 characters of maximum string: Kokonaisvelat/liikevaihto...

Dim tilastovuosi, T020 tetipa tau 101 fi px, Latest

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

Dim tilastovuosi, T020 tetipa tau 101 fi px, Full history

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

Dim yrityksen pksuuruusluokka eumaaritelm, T020 tetipa tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yrity and maximum string is Pk-yritykset.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki yritykset and maximum string is Pk-yritykset.

Dim yrityksen pksuuruusluokka eumaaritelm, T020 tetipa tau 101 fi px, Full history

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

Additional Info

Last Updated July 6, 2019
Created July 3, 2019