908 -- Toimipaikat maakunnittain ja toimialoittain 2007-2012 (TOL 2008 )

Tables

Dim maakunta, Statfinpas alyr pxt 908 201200 fi px, Full historyTSV
Dimension Maakunta (Maakunta)
Dim maakunta, Statfinpas alyr pxt 908 201200 fi px, LatestTSV
Dimension Maakunta (Maakunta)
Dim toimiala, Statfinpas alyr pxt 908 201200 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, Statfinpas alyr pxt 908 201200 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Dim toimipaikkojen tiedot, Statfinpas alyr pxt 908 201200 fi px, Full historyTSV
Dimension Toimipaikkojen_tiedot (Toimipaikkojen tiedot)
Dim toimipaikkojen tiedot, Statfinpas alyr pxt 908 201200 fi px, LatestTSV
Dimension Toimipaikkojen_tiedot (Toimipaikkojen tiedot)
Dim vuosi, Statfinpas alyr pxt 908 201200 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfinpas alyr pxt 908 201200 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfinpas alyr pxt 908 201200 fi px, Full historyTSV
Toimipaikat maakunnittain ja toimialoittain vuonna 2007-2012 (TOL2008) muuttujina Maakunta, Toimiala, Vuosi ja Toimipaikkojen tiedot
Fact, Statfinpas alyr pxt 908 201200 fi px, LatestTSV
Toimipaikat maakunnittain ja toimialoittain vuonna 2007-2012 (TOL2008) muuttujina Maakunta, Toimiala, Vuosi ja Toimipaikkojen tiedot

Column Descriptions

Dim toimiala, Statfinpas alyr pxt 908 201200 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.

Dim maakunta, Statfinpas alyr pxt 908 201200 fi px, Full history

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

Dim vuosi, Statfinpas alyr pxt 908 201200 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 toimipaikkojen tiedot, Statfinpas alyr pxt 908 201200 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 1 and maximum value is 6.
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. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas alyr pxt 908 201200 fi px, Latest

Column	Type	Comment
maakunta	int	Datasource did not contain a description for Maakunta. Column maakunta has 71820 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 21.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 71820 rows, out of which 14364 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 71820 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.
toimipaikkojen_tiedot	int	Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 71820 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 6.
toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008	int	Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_TOL2008. Column toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 has 71820 rows, out of which 23445 are empty, making the null percent 32.64. Minimum value is 0 and maximum value is 187142124.

Dim toimipaikkojen tiedot, Statfinpas alyr pxt 908 201200 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 1 and maximum value is 6.
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. First 25 characters of minimum string: Aputoimipaikkoja... and first 25 characters of maximum string: Aputoimipaikkojen henkilö...

Dim maakunta, Statfinpas alyr pxt 908 201200 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 19 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 21.
label	string	The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 Uusimaa and maximum string is 21 Ahvenanmaa - Åland.

Dim toimiala, Statfinpas alyr pxt 908 201200 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 vuosi, Statfinpas alyr pxt 908 201200 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, Statfinpas alyr pxt 908 201200 fi px, Full history

Column	Type	Comment
maakunta	int	Datasource did not contain a description for Maakunta. Column maakunta has 71820 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 21.
toimiala	int	Datasource did not contain a description for Toimiala. Column toimiala has 71820 rows, out of which 14364 are empty, making the null percent 20.00. Minimum value is 0 and maximum value is 96.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 71820 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.
toimipaikkojen_tiedot	int	Datasource did not contain a description for Toimipaikkojen_tiedot. Column toimipaikkojen_tiedot has 71820 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 6.
toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008	int	Datasource did not contain a description for Toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_TOL2008. Column toimipaikat_maakunnittain_ja_toimialoittain_vuonna_20072012_tol2008 has 71820 rows, out of which 23445 are empty, making the null percent 32.64. Minimum value is 0 and maximum value is 187142124.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 20, 2019
Created	July 19, 2019