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

Yritykset toimialoittain ja oikeudellisen muodon mukaan 2007-2012 (TOL 2008)

Yritykset toimialoittain ja oikeudellisen muodon mukaan 2007-2012 (TOL 2008)

Tables

Column Descriptions

Dim vuosi, T010 syr tau 101 fi px, Latest

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

Fact, T010 syr tau 101 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
oikeudellinen_muoto int Datasource did not contain a description for Oikeudellinen_muoto. Column oikeudellinen_muoto has 6174 rows, out of which 882 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2012.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_tol_2008 int Datasource did not contain a description for Yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_tol_2008 has 6174 rows, out of which 784 are empty, making the null percent 12.70. Minimum value is 0 and maximum value is 396591231.
orig_extractdate string The date when the data was originally fetched from the source.

Dim yritysten tiedot, T010 syr tau 101 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 1 and maximum value is 7.
label string 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. First 25 characters of minimum string: Henkilöstö... and first 25 characters of maximum string: Liikevaihto/henkilö 1.000...

Fact, T010 syr tau 101 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
oikeudellinen_muoto int Datasource did not contain a description for Oikeudellinen_muoto. Column oikeudellinen_muoto has 6174 rows, out of which 882 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2007 and maximum value is 2012.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 6174 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 7.
yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_tol_2008 int Datasource did not contain a description for Yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_oikeudellisen_muodon_mukaan_vuonna_20072012_tol_2008 has 6174 rows, out of which 784 are empty, making the null percent 12.70. Minimum value is 0 and maximum value is 396591231.

Dim oikeudellinen muoto, T010 syr tau 101 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
label string 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 string is 11 Luonnollinen henkilö and maximum string is Y Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim oikeudellinen muoto, T010 syr tau 101 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 11 and maximum value is 99.
label string 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 string is 11 Luonnollinen henkilö and maximum string is Y Yhteensä.

Dim vuosi, T010 syr tau 101 fi px, Full history

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

Dim yritysten tiedot, T010 syr tau 101 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 1 and maximum value is 7.
label string 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. First 25 characters of minimum string: Henkilöstö... and first 25 characters of maximum string: Liikevaihto/henkilö 1.000...
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T010 syr tau 101 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A Maatalous, metsätalous ... and first 25 characters of maximum string: X Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T010 syr tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is A and maximum string is X.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: A Maatalous, metsätalous ... and first 25 characters of maximum string: X Toimiala tuntematon...

Additional Info

Last Updated November 3, 2022
Created August 6, 2019