Yritykset toimialoittain ja henkilöstön suuruusluokittain 2007-2012 (TOL 2008)

Tables

Dim henkiloston suuruusluokka, T040 syr tau 104 fi px, Full historyTSV
Dimension Henkiloston_suuruusluokka (Henkilöstön suuruusluokka)
Dim henkiloston suuruusluokka, T040 syr tau 104 fi px, LatestTSV
Dimension Henkiloston_suuruusluokka (Henkilöstön suuruusluokka)
Dim toimiala, T040 syr tau 104 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T040 syr tau 104 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim vuosi, T040 syr tau 104 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, T040 syr tau 104 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Dim yritysten tiedot, T040 syr tau 104 fi px, Full historyTSV
Dimension Yritysten_tiedot (Yritysten tiedot)
Dim yritysten tiedot, T040 syr tau 104 fi px, LatestTSV
Dimension Yritysten_tiedot (Yritysten tiedot)
Fact, T040 syr tau 104 fi px, Full historyTSV
Yritykset toimialoittain ja henkilöstön suuruusluokittain vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Henkilöstön suuruusluokka, Vuosi ja Yritysten tiedot
Fact, T040 syr tau 104 fi px, LatestTSV
Yritykset toimialoittain ja henkilöstön suuruusluokittain vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Henkilöstön suuruusluokka, Vuosi ja Yritysten tiedot

Column Descriptions

Fact, T040 syr tau 104 fi px, Full history

Column	Type	Comment
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 44100 rows, out of which 8820 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
henkiloston_suuruusluokka	int	Datasource did not contain a description for Henkiloston_suuruusluokka. Column henkiloston_suuruusluokka has 44100 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 10.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 44100 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 44100 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_henkiloston_suuruusluokittain_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Yritykset_toimialoittain_ja_henkiloston_suuruusluokittain_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_henkiloston_suuruusluokittain_vuonna_20072012_tol_2008 has 44100 rows, out of which 12713 are empty, making the null percent 28.83. Minimum value is 1 and maximum value is 396591231.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T040 syr tau 104 fi px, Latest

Column	Type	Comment
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 44100 rows, out of which 8820 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
henkiloston_suuruusluokka	int	Datasource did not contain a description for Henkiloston_suuruusluokka. Column henkiloston_suuruusluokka has 44100 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 10.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 44100 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 44100 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_henkiloston_suuruusluokittain_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Yritykset_toimialoittain_ja_henkiloston_suuruusluokittain_vuonna_20072012_TOL_2008. Column yritykset_toimialoittain_ja_henkiloston_suuruusluokittain_vuonna_20072012_tol_2008 has 44100 rows, out of which 12713 are empty, making the null percent 28.83. Minimum value is 1 and maximum value is 396591231.

Dim henkiloston suuruusluokka, T040 syr tau 104 fi px, Full history

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

Dim yritysten tiedot, T040 syr tau 104 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 vuosi, T040 syr tau 104 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, T040 syr tau 104 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 henkiloston suuruusluokka, T040 syr tau 104 fi px, Latest

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

Dim yritysten tiedot, T040 syr tau 104 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, T040 syr tau 104 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.

Dim toimiala, T040 syr tau 104 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 21, 2019
Created	July 18, 2019