111 l -- Main type of activity of completers of qualifications one year after graduation, 2007-2017

Tables

Dim field of education, Statfin sijk pxt 111l px, Full historyTSV
Dimension Field_of_education (Koulutusala)
Dim field of education, Statfin sijk pxt 111l px, LatestTSV
Dimension Field_of_education (Koulutusala)
Dim gender, Statfin sijk pxt 111l px, Full historyTSV
Dimension Gender (Sukupuoli)
Dim gender, Statfin sijk pxt 111l px, LatestTSV
Dimension Gender (Sukupuoli)
Dim level of education, Statfin sijk pxt 111l px, Full historyTSV
Dimension Level_of_education (Koulutusaste)
Dim level of education, Statfin sijk pxt 111l px, LatestTSV
Dimension Level_of_education (Koulutusaste)
Dim region of residence, Statfin sijk pxt 111l px, Full historyTSV
Dimension Region_of_residence (Asuinmaakunta)
Dim region of residence, Statfin sijk pxt 111l px, LatestTSV
Dimension Region_of_residence (Asuinmaakunta)
Dim year, Statfin sijk pxt 111l px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin sijk pxt 111l px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin sijk pxt 111l px, Full historyTSV
Main type of activity of completers of qualifications one year after graduation in 2007 to 2017 by Year, Level of education, Field of education, Gender, Region of residence and Information
Fact, Statfin sijk pxt 111l px, LatestTSV
Main type of activity of completers of qualifications one year after graduation in 2007 to 2017 by Year, Level of education, Field of education, Gender, Region of residence and Information

Column Descriptions

Dim year, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 11 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 2017.
label	int	The label for the dimension value. Column label has 11 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 2017.

Dim level of education, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 31 and maximum value is 82.
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Doctoral degree and maximum string is Licentiate`s degree.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim field of education, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 0 and maximum value is 99.
label	string	The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry, fi... and first 25 characters of maximum string: Unknown...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim gender, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
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 Both sexes and maximum string is Females.

Dim level of education, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 31 and maximum value is 82.
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Doctoral degree and maximum string is Licentiate`s degree.

Dim year, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 11 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 2017.
label	int	The label for the dimension value. Column label has 11 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 2017.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region of residence, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 20 rows, out of which 1 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
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. Minimum string is Central Finland and maximum string is Åland.

Fact, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 566280 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 2017.
level_of_education	int	National classification of education 2016 . Column level_of_education has 566280 rows, out of which 51480 are empty, making the null percent 9.09. Minimum value is 31 and maximum value is 82.
field_of_education	int	National classification of education 2016 . Column field_of_education has 566280 rows, out of which 43560 are empty, making the null percent 7.69. Minimum value is 0 and maximum value is 99.
gender	int	Datasource did not contain a description for Gender. Column gender has 566280 rows, out of which 188760 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
region_of_residence	int	The region of residence at the end of the statistical reference year . Column region_of_residence has 566280 rows, out of which 28314 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
completers_of_qualifications_total	int	Completers of qualifications in the year preceding the statistical reference year in total by the highest qualification in the statistical reference year. . Column completers_of_qualifications_total has 566280 rows, out of which 353036 are empty, making the null percent 62.34. Minimum value is 1 and maximum value is 142573.

Fact, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 566280 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 2017.
level_of_education	int	National classification of education 2016 . Column level_of_education has 566280 rows, out of which 51480 are empty, making the null percent 9.09. Minimum value is 31 and maximum value is 82.
field_of_education	int	National classification of education 2016 . Column field_of_education has 566280 rows, out of which 43560 are empty, making the null percent 7.69. Minimum value is 0 and maximum value is 99.
gender	int	Datasource did not contain a description for Gender. Column gender has 566280 rows, out of which 188760 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
region_of_residence	int	The region of residence at the end of the statistical reference year . Column region_of_residence has 566280 rows, out of which 28314 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
completers_of_qualifications_total	int	Completers of qualifications in the year preceding the statistical reference year in total by the highest qualification in the statistical reference year. . Column completers_of_qualifications_total has 566280 rows, out of which 353036 are empty, making the null percent 62.34. Minimum value is 1 and maximum value is 142573.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim field of education, Statfin sijk pxt 111l px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 0 and maximum value is 99.
label	string	The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Agriculture, forestry, fi... and first 25 characters of maximum string: Unknown...

Dim gender, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
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 Both sexes and maximum string is Females.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region of residence, Statfin sijk pxt 111l px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 20 rows, out of which 1 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
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. Minimum string is Central Finland and maximum string is Åland.
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