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

Yritykset toimialoittain ja omistajatyypin mukaan 2001-2007 (TOL 2002)

Yritykset toimialoittain ja omistajatyypin mukaan 2001-2007 (TOL 2002)

Tables

Column Descriptions

Dim vuosi, T020 syr 2007 tau 102 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.

Fact, T020 syr 2007 tau 102 fi px, Full history

Column Type Comment
toimiala int Toimialaluokitus 2002 . Column toimiala has 26460 rows, out of which 9702 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
omistajatyyppi int Datasource did not contain a description for Omistajatyyppi. Column omistajatyyppi has 26460 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 5.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 26460 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.
yrityksen_tiedot int Datasource did not contain a description for Yrityksen_tiedot. Column yrityksen_tiedot has 26460 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_omistajatyypin_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialoittain_ja_omistajatyypin_mukaan_20012007_TOL_2002. Column yritykset_toimialoittain_ja_omistajatyypin_mukaan_20012007_tol_2002 has 26460 rows, out of which 12417 are empty, making the null percent 46.93. 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, T020 syr 2007 tau 102 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 90 rows, out of which 33 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 90 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T020 syr 2007 tau 102 fi px, Latest

Column Type Comment
toimiala int Toimialaluokitus 2002 . Column toimiala has 26460 rows, out of which 9702 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
omistajatyyppi int Datasource did not contain a description for Omistajatyyppi. Column omistajatyyppi has 26460 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 5.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 26460 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.
yrityksen_tiedot int Datasource did not contain a description for Yrityksen_tiedot. Column yrityksen_tiedot has 26460 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_omistajatyypin_mukaan_20012007_tol_2002 int Datasource did not contain a description for Yritykset_toimialoittain_ja_omistajatyypin_mukaan_20012007_TOL_2002. Column yritykset_toimialoittain_ja_omistajatyypin_mukaan_20012007_tol_2002 has 26460 rows, out of which 12417 are empty, making the null percent 46.93. Minimum value is 0 and maximum value is 374588446.

Dim toimiala, T020 syr 2007 tau 102 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 90 rows, out of which 33 are empty, making the null percent 36.67. Minimum value is 1 and maximum value is 99.
label string The label for the dimension value. Column label has 90 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Maatalous, riistatalou... and first 25 characters of maximum string: 99 Toimiala tuntematon...

Dim vuosi, T020 syr 2007 tau 102 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 yrityksen tiedot, T020 syr 2007 tau 102 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 yrityksen tiedot, T020 syr 2007 tau 102 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 omistajatyyppi, T020 syr 2007 tau 102 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 0 and maximum value is 5.
label string 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 string is Ahvenanmaan maakunta and maximum string is Yhteensä.

Dim omistajatyyppi, T020 syr 2007 tau 102 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 0 and maximum value is 5.
label string 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 string is Ahvenanmaan maakunta and maximum string is Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 14, 2019