1. Home
  2. Datasets
  3. Tieteen ja teknologian ...
To download the data set, please sign up or log in

Tieteen ja teknologian työllinen henkilöstö ammatin ja koulutuksen mukaan vuonna 2008 - 2009 (Toimialaluokitus 2008)

Tieteen ja teknologian työllinen henkilöstö ammatin ja koulutuksen mukaan vuonna 2008 - 2009 (Toimialaluokitus 2008)

Tables

Column Descriptions

Dim koulutusaste, T111 tthv tau 111 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Koulutusasteet yhteensä... and first 25 characters of maximum string: Muu tai tuntematon koulut...
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alempi korkeakouluaste ja... and first 25 characters of maximum string: Muu tai tuntematon koulut...

Dim sukupuoli, T111 tthv tau 111 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T111 tthv tau 111 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
label int The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.

Dim tiedot, T111 tthv tau 111 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Henkilöä.

Dim tiedot, T111 tthv tau 111 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Henkilöä.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T111 tthv tau 111 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen, tekninen to... and first 25 characters of maximum string: Toimiala tuntematon...
ammatti string Datasource did not contain a description for Ammatti. Column ammatti has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.
koulutusaste string Datasource did not contain a description for Koulutusaste. Column koulutusaste has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Koulutusasteet yhteensä... and first 25 characters of maximum string: Muu tai tuntematon koulut...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 20832 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_vuonna_2008_2009_toimialaluokitus_2008 int Datasource did not contain a description for Tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuonna_2008_2009_Toimialaluokitus_2008. Column tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuonna_2008_2009_toimialaluokitus_2008 has 20832 rows, out of which 3091 are empty, making the null percent 14.84. Minimum value is 1 and maximum value is 1147066.
orig_extractdate string The date when the data was originally fetched from the source.

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

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

Dim toimiala, T111 tthv tau 111 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen, tekninen to... and first 25 characters of maximum string: Toimiala tuntematon...
label string The label for the dimension value. Column label has 31 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen, tekninen to... and first 25 characters of maximum string: Toimiala tuntematon...

Dim koulutusaste, T111 tthv tau 111 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Koulutusasteet yhteensä... and first 25 characters of maximum string: Muu tai tuntematon koulut...
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alempi korkeakouluaste ja... and first 25 characters of maximum string: Muu tai tuntematon koulut...
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, T111 tthv tau 111 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.

Fact, T111 tthv tau 111 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen, tekninen to... and first 25 characters of maximum string: Toimiala tuntematon...
ammatti string Datasource did not contain a description for Ammatti. Column ammatti has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.
koulutusaste string Datasource did not contain a description for Koulutusaste. Column koulutusaste has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Koulutusasteet yhteensä... and first 25 characters of maximum string: Muu tai tuntematon koulut...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 20832 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Miehet and maximum string is Naiset.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 20832 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_vuonna_2008_2009_toimialaluokitus_2008 int Datasource did not contain a description for Tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuonna_2008_2009_Toimialaluokitus_2008. Column tieteen_ja_teknologian_tyollinen_henkilosto_ammatin_ja_koulutuksen_mukaan_vuonna_2008_2009_toimialaluokitus_2008 has 20832 rows, out of which 3091 are empty, making the null percent 14.84. Minimum value is 1 and maximum value is 1147066.

Dim ammatti, T111 tthv tau 111 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ammatti, T111 tthv tau 111 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Muut ammatit.

Dim vuosi, T111 tthv tau 111 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
label int The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2009.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019