To download the data set, please sign up or log in

Tieteen ja teknologian työllinen henkilöstö ammatin ja koulutuksen mukaan vuosina 2000, 2004 ja 2005 (TOL 2002)

Tieteen ja teknologian työllinen henkilöstö ammatin ja koulutuksen mukaan vuosina 2000, 2004 ja 2005 (TOL 2002)

Tables

Column Descriptions

Dim vuosi, T110 tthv tau 111 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 2000 and maximum value is 2008.
label int 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 value is 2000 and maximum value is 2008.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T110 tthv tau 111 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 - 05 and maximum string is 99.
ammatti int Datasource did not contain a description for Ammatti. Column ammatti has 42000 rows, out of which 9000 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
koulutusaste int Datasource did not contain a description for Koulutusaste. Column koulutusaste has 42000 rows, out of which 26250 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 42000 rows, out of which 14000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005 int Datasource did not contain a description for Tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005. Column tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005 has 42000 rows, out of which 5824 are empty, making the null percent 13.87. Minimum value is 1 and maximum value is 1147066.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T110 tthv tau 111 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2008.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 - 05 and maximum string is 99.
ammatti int Datasource did not contain a description for Ammatti. Column ammatti has 42000 rows, out of which 9000 are empty, making the null percent 21.43. Minimum value is 21 and maximum value is 131.
koulutusaste int Datasource did not contain a description for Koulutusaste. Column koulutusaste has 42000 rows, out of which 26250 are empty, making the null percent 62.50. Minimum value is 81 and maximum value is 99.
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 42000 rows, out of which 14000 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 42000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005 int Datasource did not contain a description for Tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005. Column tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuosina_2000_2004_ja_2005 has 42000 rows, out of which 5824 are empty, making the null percent 13.87. Minimum value is 1 and maximum value is 1147066.

Dim toimiala, T110 tthv tau 111 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 25 rows, out of which 19 are empty, making the null percent 76.00. Minimum value is 45 and maximum value is 642.
label string The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Elintarvikkeet, tekstiili... and first 25 characters of maximum string: Toimiala tuntematon...

Dim vuosi, T110 tthv tau 111 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 2000 and maximum value is 2008.
label int 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 value is 2000 and maximum value is 2008.

Dim toimiala, T110 tthv tau 111 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 25 rows, out of which 19 are empty, making the null percent 76.00. Minimum value is 45 and maximum value is 642.
label string The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Elintarvikkeet, tekstiili... and first 25 characters of maximum string: Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 4, 2019