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 toimiala, T060 tetipa tau 106 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.

Dim suuruusluokka, T060 tetipa tau 106 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 toimiala, T060 tetipa tau 106 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 ...

Fact, T060 tetipa tau 106 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 tiedot, T060 tetipa tau 106 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 vuosi, T060 tetipa tau 106 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.

Dim vuosi, T060 tetipa tau 106 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 tiedot, T060 tetipa tau 106 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...

Fact, T060 tetipa tau 106 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.

Dim suuruusluokka, T060 tetipa tau 106 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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019