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

Yritykset toimialan ja sektoriluokan mukaan 2001-2007 (TOL 2002)

Yritykset toimialan ja sektoriluokan mukaan 2001-2007 (TOL 2002)

Tables

Column Descriptions

Fact, T030 syr 2007 tau 103 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 4165 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.
sektoriluokitus int Datasource did not contain a description for Sektoriluokitus. Column sektoriluokitus has 4165 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 4.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 4165 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.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 4165 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_toimialoittain_ja_sektoriluokan_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialoittain_ja_sektoriluokan_mukaan_20012007_TOL_2002. Column yritykset_toimialoittain_ja_sektoriluokan_mukaan_20012007_tol_2002 has 4165 rows, out of which 1783 are empty, making the null percent 42.81. Minimum value is 0 and maximum value is 374588446.

Fact, T030 syr 2007 tau 103 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 4165 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.
sektoriluokitus int Datasource did not contain a description for Sektoriluokitus. Column sektoriluokitus has 4165 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 4.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 4165 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.
yritysten_tiedot int Datasource did not contain a description for Yritysten_tiedot. Column yritysten_tiedot has 4165 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_toimialoittain_ja_sektoriluokan_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialoittain_ja_sektoriluokan_mukaan_20012007_TOL_2002. Column yritykset_toimialoittain_ja_sektoriluokan_mukaan_20012007_tol_2002 has 4165 rows, out of which 1783 are empty, making the null percent 42.81. Minimum value is 0 and maximum value is 374588446.
orig_extractdate string The date when the data was originally fetched from the source.

Dim yritysten tiedot, T030 syr 2007 tau 103 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.

Dim yritysten tiedot, T030 syr 2007 tau 103 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...

Dim sektoriluokitus, T030 syr 2007 tau 103 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 5 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 4.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Julkisyhteisöt and maximum string is Kotitaloudet.

Dim vuosi, T030 syr 2007 tau 103 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 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 vuosi, T030 syr 2007 tau 103 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 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 sektoriluokitus, T030 syr 2007 tau 103 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 5 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 4.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Julkisyhteisöt and maximum string is Kotitaloudet.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, T030 syr 2007 tau 103 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 toimiala, T030 syr 2007 tau 103 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...

Additional Info

Last Updated July 21, 2019
Created July 13, 2019