Voittoa tavoittelemattomat yhteisöt 2007-2012 (TOL 2008)

Tables

Dim sektori, T140 syr tau 114 fi px, Full historyTSV
Dimension Sektori (Sektori)
Dim sektori, T140 syr tau 114 fi px, LatestTSV
Dimension Sektori (Sektori)
Dim toimiala, T140 syr tau 114 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T140 syr tau 114 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim vuosi, T140 syr tau 114 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, T140 syr tau 114 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Dim yritysten tiedot, T140 syr tau 114 fi px, Full historyTSV
Dimension Yritysten_tiedot (Yritysten tiedot)
Dim yritysten tiedot, T140 syr tau 114 fi px, LatestTSV
Dimension Yritysten_tiedot (Yritysten tiedot)
Fact, T140 syr tau 114 fi px, Full historyTSV
Voittoa tavoittelemattomat yhteisöt työnantajina vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Sektori, Vuosi ja Yritysten tiedot
Fact, T140 syr tau 114 fi px, LatestTSV
Voittoa tavoittelemattomat yhteisöt työnantajina vuonna 2007-2012 (TOL 2008) muuttujina Toimiala, Sektori, Vuosi ja Yritysten tiedot

Column Descriptions

Dim sektori, T140 syr tau 114 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 151 and maximum value is 13149.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 13149 Muut sosiaaliturvar... and first 25 characters of maximum string: 152 Muut voittoa tavoitte...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T140 syr tau 114 fi px, Full history

Column	Type	Comment
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 1632 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 S.
sektori	int	Datasource did not contain a description for Sektori. Column sektori has 1632 rows, out of which 408 are empty, making the null percent 25.00. Minimum value is 151 and maximum value is 13149.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 1632 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 1632 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 4.
voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_TOL_2008. Column voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_tol_2008 has 1632 rows, out of which 739 are empty, making the null percent 45.28. Minimum value is 1 and maximum value is 3778620.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim yritysten tiedot, T140 syr tau 114 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 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 4.
label	string	The label for the dimension value. Column label has 4 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: Palkka/palkansaaja 1.000 ...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim yritysten tiedot, T140 syr tau 114 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 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 4.
label	string	The label for the dimension value. Column label has 4 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: Palkka/palkansaaja 1.000 ...

Dim vuosi, T140 syr tau 114 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.

Fact, T140 syr tau 114 fi px, Latest

Column	Type	Comment
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 1632 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 S.
sektori	int	Datasource did not contain a description for Sektori. Column sektori has 1632 rows, out of which 408 are empty, making the null percent 25.00. Minimum value is 151 and maximum value is 13149.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 1632 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 1632 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 4.
voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_tol_2008	int	Datasource did not contain a description for Voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_TOL_2008. Column voittoa_tavoittelemattomat_yhteisot_tyonantajina_vuonna_20072012_tol_2008 has 1632 rows, out of which 739 are empty, making the null percent 45.28. Minimum value is 1 and maximum value is 3778620.

Dim vuosi, T140 syr tau 114 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 toimiala, T140 syr tau 114 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 S.
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, metsätalous ... and first 25 characters of maximum string: S Muu palvelutoiminta...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim toimiala, T140 syr tau 114 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 S.
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, metsätalous ... and first 25 characters of maximum string: S Muu palvelutoiminta...

Dim sektori, T140 syr tau 114 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 151 and maximum value is 13149.
label	string	The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 13149 Muut sosiaaliturvar... and first 25 characters of maximum string: 152 Muut voittoa tavoitte...

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019