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

Liike-elämän palvelujen tilinpäätöstiedot 2012, ennakko (TOL 2008)

Liike-elämän palvelujen tilinpäätöstiedot 2012, ennakko (TOL 2008)

Tables

Column Descriptions

Dim toimiala, T005 patipa tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 691 Lakiasiainpalvelut and maximum string is 86 Terveyspalvelut.
label string The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 691 Lakiasiainpalvelut and maximum string is 86 Terveyspalvelut.

Fact, T005 patipa tau 101 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 2496 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 691 Lakiasiainpalvelut and maximum string is 86 Terveyspalvelut.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2496 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 Toimialat on määritelty toimialaluokitus TOL 2008:n mukaisina . Column tilastovuosi has 2496 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2011 and maximum value is 2012.
yrityksen_suuruusluokka_yrek string Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 2496 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.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 2496 rows, out of which 192 are empty, making the null percent 7.69. Minimum value is -218256092 and maximum value is 507143563.
orig_extractdate string The date when the data was originally fetched from the source.

Dim yrityksen suuruusluokka yrek, T005 patipa 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 yritykset 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 tiedot, T005 patipa tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 39 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 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: Aineelliset nettoinvestoi... and first 25 characters of maximum string: Kokonaisvelat/liikevaihto...

Dim tilastovuosi, T005 patipa tau 101 fi px, Latest

Column Type Comment
code int 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 value is 2011 and maximum value is 2012.
label int The label for the dimension value. Column label has 2 rows, out of which 1 are empty, making the null percent 50.00. Constant value is 2011.

Fact, T005 patipa tau 101 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 2496 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 691 Lakiasiainpalvelut and maximum string is 86 Terveyspalvelut.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2496 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 Toimialat on määritelty toimialaluokitus TOL 2008:n mukaisina . Column tilastovuosi has 2496 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2011 and maximum value is 2012.
yrityksen_suuruusluokka_yrek string Datasource did not contain a description for Yrityksen_suuruusluokka_yrek. Column yrityksen_suuruusluokka_yrek has 2496 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.
tilinpaatostiedot int Datasource did not contain a description for Tilinpaatostiedot. Column tilinpaatostiedot has 2496 rows, out of which 192 are empty, making the null percent 7.69. Minimum value is -218256092 and maximum value is 507143563.

Dim toimiala, T005 patipa tau 101 fi px, Full history

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

Dim tiedot, T005 patipa tau 101 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 39 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 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: 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 yrityksen suuruusluokka yrek, T005 patipa 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 yritykset 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 tilastovuosi, T005 patipa tau 101 fi px, Full history

Column Type Comment
code int 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 value is 2011 and maximum value is 2012.
label int The label for the dimension value. Column label has 2 rows, out of which 1 are empty, making the null percent 50.00. Constant value is 2011.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019