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

Yritykset toimialan ja oikeudellisen muodon mukaan 2001-2007 (TOL 2002)

Yritykset toimialan ja oikeudellisen muodon mukaan 2001-2007 (TOL 2002)

Tables

Column Descriptions

Dim yritysten tiedot, T010 syr 2007 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 0 and maximum value is 6.
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.

Fact, T010 syr 2007 tau 101 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 5831 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 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_TOL_2002. Column yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_tol_2002 has 5831 rows, out of which 911 are empty, making the null percent 15.62. Minimum value is 0 and maximum value is 374588446.

Dim vuosi, T010 syr 2007 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 2001 and maximum value is 2007.
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 2001 and maximum value is 2007.
orig_extractdate string The date when the data was originally fetched from the source.

Dim oikeudellinen muoto, T010 syr 2007 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 0 and maximum value is 6.
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 Avoin yhtiö and maximum string is Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T010 syr 2007 tau 101 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 17 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 17 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, riistatalous... and first 25 characters of maximum string: X Toimiala tuntematon...

Dim oikeudellinen muoto, T010 syr 2007 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 0 and maximum value is 6.
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 Avoin yhtiö and maximum string is Yhteensä.

Fact, T010 syr 2007 tau 101 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 5831 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 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2007.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 5831 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 6.
yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_TOL_2002. Column yritykset_toimialan_ja_oikeudellisen_muodon_mukaan_20012007_tol_2002 has 5831 rows, out of which 911 are empty, making the null percent 15.62. Minimum value is 0 and maximum value is 374588446.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code string The code for the dimension value. Column code has 17 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 17 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, riistatalous... 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 vuosi, T010 syr 2007 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 2001 and maximum value is 2007.
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 2001 and maximum value is 2007.

Dim yritysten tiedot, T010 syr 2007 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 0 and maximum value is 6.
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...

Additional Info

Last Updated September 20, 2019
Created August 2, 2019