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

Korkeasti koulutetun työllisen väestön toimialojen välinen liikkuvuus 2008 - 2009(Toimialaluokitus 2008)

Korkeasti koulutetun työllisen väestön toimialojen välinen liikkuvuus 2008 - 2009(Toimialaluokitus 2008)

Tables

Column Descriptions

Fact, T081 tthv tau 108 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 374976 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.
maakunta_tyossakayntikunta string Datasource did not contain a description for Maakunta_tyossakayntikunta. Column maakunta_tyossakayntikunta has 374976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa and maximum string is Lappi.
toimiala_edellinen_vuosi string Datasource did not contain a description for Toimiala_edellinen_vuosi. Column toimiala_edellinen_vuosi has 374976 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: Ei työllinen...
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 374976 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...
tutkinnot string Datasource did not contain a description for Tutkinnot. Column tutkinnot has 374976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aka_lkmtol and maximum string is Opa_lkmtol.
korkeasti_koulutettu_vaesto_2008_2009_toimialaluokitus_2008 int Datasource did not contain a description for Korkeasti_koulutettu_vaesto_2008_2009_Toimialaluokitus_2008. Column korkeasti_koulutettu_vaesto_2008_2009_toimialaluokitus_2008 has 374976 rows, out of which 267665 are empty, making the null percent 71.38. Minimum value is 0 and maximum value is 893212.

Fact, T081 tthv tau 108 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 374976 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.
maakunta_tyossakayntikunta string Datasource did not contain a description for Maakunta_tyossakayntikunta. Column maakunta_tyossakayntikunta has 374976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa and maximum string is Lappi.
toimiala_edellinen_vuosi string Datasource did not contain a description for Toimiala_edellinen_vuosi. Column toimiala_edellinen_vuosi has 374976 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: Ei työllinen...
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 374976 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...
tutkinnot string Datasource did not contain a description for Tutkinnot. Column tutkinnot has 374976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aka_lkmtol and maximum string is Opa_lkmtol.
korkeasti_koulutettu_vaesto_2008_2009_toimialaluokitus_2008 int Datasource did not contain a description for Korkeasti_koulutettu_vaesto_2008_2009_Toimialaluokitus_2008. Column korkeasti_koulutettu_vaesto_2008_2009_toimialaluokitus_2008 has 374976 rows, out of which 267665 are empty, making the null percent 71.38. Minimum value is 0 and maximum value is 893212.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, T081 tthv tau 108 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 vuosi, T081 tthv tau 108 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.

Dim toimiala edellinen vuosi, T081 tthv tau 108 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 32 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: Ei työllinen...
label string The label for the dimension value. Column label has 32 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: Ei työllinen...
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala edellinen vuosi, T081 tthv tau 108 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 32 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: Ei työllinen...
label string The label for the dimension value. Column label has 32 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: Ei työllinen...

Dim toimiala, T081 tthv tau 108 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, T081 tthv tau 108 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 tutkinnot, T081 tthv tau 108 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aka_lkmtol and maximum string is Opa_lkmtol.
label string The label for the dimension value. Column label has 9 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 korkeakoulututkint... and first 25 characters of maximum string: Opistoaste...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tutkinnot, T081 tthv tau 108 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aka_lkmtol and maximum string is Opa_lkmtol.
label string The label for the dimension value. Column label has 9 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 korkeakoulututkint... and first 25 characters of maximum string: Opistoaste...

Dim maakunta tyossakayntikunta, T081 tthv tau 108 fi px, Latest

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

Dim maakunta tyossakayntikunta, T081 tthv tau 108 fi px, Full history

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

Additional Info

Last Updated August 4, 2019
Created July 30, 2019