Teollisuuden alue- ja toimialatilasto 2012

Tables

Dim maakunta, T007 atoi tau 104 fi px, Full historyTSV
Dimension Maakunta (Maakunta)
Dim maakunta, T007 atoi tau 104 fi px, LatestTSV
Dimension Maakunta (Maakunta)
Dim tiedot, T007 atoi tau 104 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, T007 atoi tau 104 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tilastovuosi, T007 atoi tau 104 fi px, Full historyTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim tilastovuosi, T007 atoi tau 104 fi px, LatestTSV
Dimension Tilastovuosi (Tilastovuosi)
Dim toimiala, T007 atoi tau 104 fi px, Full historyTSV
Dimension Toimiala (Toimiala)
Dim toimiala, T007 atoi tau 104 fi px, LatestTSV
Dimension Toimiala (Toimiala)
Fact, T007 atoi tau 104 fi px, Full historyTSV
Maakunnittaiset tiedot toimialoittain koko teollisuudessa (BCDE) vuosina 2006-2012, TOL 2008 -luokitus muuttujina Maakunta, Toimiala, Tiedot ja Tilastovuosi
Fact, T007 atoi tau 104 fi px, LatestTSV
Maakunnittaiset tiedot toimialoittain koko teollisuudessa (BCDE) vuosina 2006-2012, TOL 2008 -luokitus muuttujina Maakunta, Toimiala, Tiedot ja Tilastovuosi

Column Descriptions

Dim maakunta, T007 atoi tau 104 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 20 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
label	string	The label for the dimension value. Column label has 20 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tilastovuosi, T007 atoi 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 2006 and maximum value is 2012.
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 2006 and maximum value is 2012.

Dim tiedot, T007 atoi tau 104 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 43 rows, out of which 4 are empty, making the null percent 9.30. Minimum string is and maximum string is Kulkatav.
label	string	The label for the dimension value. Column label has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineet ja tarvikkeet tili... and first 25 characters of maximum string: Kauppatavaroiden hankinta...

Dim toimiala, T007 atoi tau 104 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
label	string	The label for the dimension value. Column label has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tilastovuosi, T007 atoi 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 2006 and maximum value is 2012.
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 2006 and maximum value is 2012.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T007 atoi tau 104 fi px, Latest

Column	Type	Comment
maakunta	string	Datasource did not contain a description for Maakunta. Column maakunta has 246400 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 246400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 246400 rows, out of which 6160 are empty, making the null percent 2.50. Minimum string is and maximum string is Kulkatav.
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 246400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.
maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_bcde_vuosina_20062012_tol_2008_luokitus	int	Datasource did not contain a description for Maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_BCDE_vuosina_20062012_TOL_2008_luokitus. Column maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_bcde_vuosina_20062012_tol_2008_luokitus has 246400 rows, out of which 75270 are empty, making the null percent 30.55. Minimum value is -290870 and maximum value is 56585903.

Dim tiedot, T007 atoi tau 104 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 43 rows, out of which 4 are empty, making the null percent 9.30. Minimum string is and maximum string is Kulkatav.
label	string	The label for the dimension value. Column label has 43 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aineet ja tarvikkeet tili... and first 25 characters of maximum string: Kauppatavaroiden hankinta...
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T007 atoi tau 104 fi px, Full history

Column	Type	Comment
maakunta	string	Datasource did not contain a description for Maakunta. Column maakunta has 246400 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
toimiala	string	Datasource did not contain a description for Toimiala. Column toimiala has 246400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 246400 rows, out of which 6160 are empty, making the null percent 2.50. Minimum string is and maximum string is Kulkatav.
tilastovuosi	int	Datasource did not contain a description for Tilastovuosi. Column tilastovuosi has 246400 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2006 and maximum value is 2012.
maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_bcde_vuosina_20062012_tol_2008_luokitus	int	Datasource did not contain a description for Maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_BCDE_vuosina_20062012_TOL_2008_luokitus. Column maakunnittaiset_tiedot_toimialoittain_koko_teollisuudessa_bcde_vuosina_20062012_tol_2008_luokitus has 246400 rows, out of which 75270 are empty, making the null percent 30.55. Minimum value is -290870 and maximum value is 56585903.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim maakunta, T007 atoi tau 104 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 20 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...
label	string	The label for the dimension value. Column label has 20 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 Uusimaa... and first 25 characters of maximum string: Ulkomainen tai tuntematon...

Dim toimiala, T007 atoi tau 104 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...
label	string	The label for the dimension value. Column label has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: 39 Maaperän ja vesistöjen...

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019