1. Home
  2. Datasets
  3. Teollisuuden ja rakentamisen ...
To download the data set, please sign up or log in

Teollisuuden ja rakentamisen tilinpäätöstiedot 1999-2005

Teollisuuden ja rakentamisen tilinpäätöstiedot 1999-2005

Tables

Column Descriptions

Dim tiedot, Tetipa 2005 2006 12 15 db 002 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 69 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 Quick.
label string The label for the dimension value. Column label has 69 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineellinen käyttöomaisuu... and first 25 characters of maximum string: Quick ratio...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Tetipa 2005 2006 12 15 db 002 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 69 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 Quick.
label string The label for the dimension value. Column label has 69 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineellinen käyttöomaisuu... and first 25 characters of maximum string: Quick ratio...

Dim vuosi, Tetipa 2005 2006 12 15 db 002 fi px, Latest

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

Dim vuosi, Tetipa 2005 2006 12 15 db 002 fi px, Full history

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

Fact, Tetipa 2005 2006 12 15 db 002 fi px, Latest

Column Type Comment
toimiala int Toimialat on määritelty toimialaluokitus TOL2002:n mukaisina . Column toimiala has 42504 rows, out of which 16422 are empty, making the null percent 38.64. Minimum value is 10 and maximum value is 361.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 42504 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 Quick.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 42504 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2005.
suuruusluokka string Datasource did not contain a description for Suuruusluokka. Column suuruusluokka has 42504 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki and maximum string is Pk-yritykset.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 42504 rows, out of which 4192 are empty, making the null percent 9.86. Minimum value is -170367571 and maximum value is 371581307.

Fact, Tetipa 2005 2006 12 15 db 002 fi px, Full history

Column Type Comment
toimiala int Toimialat on määritelty toimialaluokitus TOL2002:n mukaisina . Column toimiala has 42504 rows, out of which 16422 are empty, making the null percent 38.64. Minimum value is 10 and maximum value is 361.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 42504 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 Quick.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 42504 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1999 and maximum value is 2005.
suuruusluokka string Datasource did not contain a description for Suuruusluokka. Column suuruusluokka has 42504 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kaikki and maximum string is Pk-yritykset.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 42504 rows, out of which 4192 are empty, making the null percent 9.86. Minimum value is -170367571 and maximum value is 371581307.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Tetipa 2005 2006 12 15 db 002 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 44 rows, out of which 17 are empty, making the null percent 38.64. Minimum value is 10 and maximum value is 361.
label string The label for the dimension value. Column label has 44 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: 45D Rakennuskonevuokraus ...

Dim suuruusluokka, Tetipa 2005 2006 12 15 db 002 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 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 suuruusluokka, Tetipa 2005 2006 12 15 db 002 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 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.

Dim toimiala, Tetipa 2005 2006 12 15 db 002 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 44 rows, out of which 17 are empty, making the null percent 38.64. Minimum value is 10 and maximum value is 361.
label string The label for the dimension value. Column label has 44 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: 45D Rakennuskonevuokraus ...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 20, 2019