Yritykset toimialoittain ja omistajatyypin mukaan 2007-2012 (TOL 2008 )

Tables

Dim omistajatyyppi, T020 syr tau 102 fi px, Full historyTSV
Dimension Omistajatyyppi (Omistajatyyppi)
Dim omistajatyyppi, T020 syr tau 102 fi px, LatestTSV
Dimension Omistajatyyppi (Omistajatyyppi)
Dim toimiala, T020 syr tau 102 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T020 syr tau 102 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim vuosi, T020 syr tau 102 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, T020 syr tau 102 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Dim yrityksen tiedot, T020 syr tau 102 fi px, Full historyTSV
Dimension Yrityksen_tiedot (Yrityksen tiedot)
Dim yrityksen tiedot, T020 syr tau 102 fi px, LatestTSV
Dimension Yrityksen_tiedot (Yrityksen tiedot)
Fact, T020 syr tau 102 fi px, Full historyTSV
Yritykset toimialoittain ja omistajatyypeittäin vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Omistajatyyppi, Vuosi ja Yrityksen tiedot
Fact, T020 syr tau 102 fi px, LatestTSV
Yritykset toimialoittain ja omistajatyypeittäin vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Omistajatyyppi, Vuosi ja Yrityksen tiedot

Column Descriptions

Dim omistajatyyppi, T020 syr tau 102 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 1 and maximum value is 99.
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 1 Yksityinen kotimainen and maximum string is 99 Yhteensä.

Fact, T020 syr tau 102 fi px, Full history

Column	Type	Comment
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 22050 rows, out of which 4410 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
omistajatyyppi	int	Datasource did not contain a description for Omistajatyyppi. Column omistajatyyppi has 22050 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 99.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 22050 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.
yrityksen_tiedot	int	Datasource did not contain a description for Yrityksen_tiedot. Column yrityksen_tiedot has 22050 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_omistajatyypeittain_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Yritykset_toimialoittain_ja_omistajatyypeittain_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_omistajatyypeittain_vuonna_20072012_tol_2008 has 22050 rows, out of which 7395 are empty, making the null percent 33.54. Minimum value is 0 and maximum value is 396591231.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim toimiala, T020 syr tau 102 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 105 rows, out of which 21 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
label	string	The label for the dimension value. Column label has 105 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Toimiala tuntematon and maximum string is X Toimiala tuntematon.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T020 syr tau 102 fi px, Latest

Column	Type	Comment
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 22050 rows, out of which 4410 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
omistajatyyppi	int	Datasource did not contain a description for Omistajatyyppi. Column omistajatyyppi has 22050 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 99.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 22050 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.
yrityksen_tiedot	int	Datasource did not contain a description for Yrityksen_tiedot. Column yrityksen_tiedot has 22050 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_omistajatyypeittain_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Yritykset_toimialoittain_ja_omistajatyypeittain_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_omistajatyypeittain_vuonna_20072012_tol_2008 has 22050 rows, out of which 7395 are empty, making the null percent 33.54. Minimum value is 0 and maximum value is 396591231.

Dim omistajatyyppi, T020 syr tau 102 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 1 and maximum value is 99.
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 1 Yksityinen kotimainen and maximum string is 99 Yhteensä.
orig_extractdate	string	The date when the data was originally fetched from the source.

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

Dim yrityksen tiedot, T020 syr 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 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 yrityksen tiedot, T020 syr 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 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...

Dim toimiala, T020 syr tau 102 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 105 rows, out of which 21 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
label	string	The label for the dimension value. Column label has 105 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00 Toimiala tuntematon and maximum string is X Toimiala tuntematon.

Additional Info

Last Updated	July 20, 2019
Created	July 19, 2019