002 -- Students and qualifications in education leading to a qualification by education and sector of education in 2004 to 2014

Tables

Dim data, Statfin opiskt pxt 002 px, Full historyTSV
Dimension Data (Tiedot)
Dim data, Statfin opiskt pxt 002 px, LatestTSV
Dimension Data (Tiedot)
Dim education, Statfin opiskt pxt 002 px, Full historyTSV
Dimension Education (Koulutus)
Dim education, Statfin opiskt pxt 002 px, LatestTSV
Dimension Education (Koulutus)
Dim sector of education, Statfin opiskt pxt 002 px, Full historyTSV
Dimension Sector_of_Education (Koulutussektori)
Dim sector of education, Statfin opiskt pxt 002 px, LatestTSV
Dimension Sector_of_Education (Koulutussektori)
Dim year, Statfin opiskt pxt 002 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin opiskt pxt 002 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin opiskt pxt 002 px, Full historyTSV
Students in post-comprehensive education leading to a qualification by Education, Sector of Education, Year and Data
Fact, Statfin opiskt pxt 002 px, LatestTSV
Students in post-comprehensive education leading to a qualification by Education, Sector of Education, Year and Data

Column Descriptions

Fact, Statfin opiskt pxt 002 px, Full history

Column	Type	Comment
education	int	Military education is included starting from 2010. . Column education has 735966 rows, out of which 594 are empty, making the null percent 0.08. Minimum value is 1101 and maximum value is 885601.
sector_of_education	int	Datasource did not contain a description for Sector_of_Education. Column sector_of_education has 735966 rows, out of which 122661 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
year	int	Datasource did not contain a description for Year. Column year has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2004 and maximum value is 2014.
data	string	Datasource did not contain a description for Data. Column data has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aloit and maximum string is Tutkn.
students_in_postcomprehensive_education_leading_to_a_qualification	int	Datasource did not contain a description for Students_in_postcomprehensive_education_leading_to_a_qualification. Column students_in_postcomprehensive_education_leading_to_a_qualification has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1273172.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin opiskt pxt 002 px, Latest

Column	Type	Comment
education	int	Military education is included starting from 2010. . Column education has 735966 rows, out of which 594 are empty, making the null percent 0.08. Minimum value is 1101 and maximum value is 885601.
sector_of_education	int	Datasource did not contain a description for Sector_of_Education. Column sector_of_education has 735966 rows, out of which 122661 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
year	int	Datasource did not contain a description for Year. Column year has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2004 and maximum value is 2014.
data	string	Datasource did not contain a description for Data. Column data has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aloit and maximum string is Tutkn.
students_in_postcomprehensive_education_leading_to_a_qualification	int	Datasource did not contain a description for Students_in_postcomprehensive_education_leading_to_a_qualification. Column students_in_postcomprehensive_education_leading_to_a_qualification has 735966 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 1273172.

Dim year, Statfin opiskt pxt 002 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 2004 and maximum value is 2014.
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 2004 and maximum value is 2014.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, Statfin opiskt pxt 002 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 2004 and maximum value is 2014.
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 2004 and maximum value is 2014.

Dim sector of education, Statfin opiskt pxt 002 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 6 rows, out of which 1 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
label	string	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Basic education and maximum string is University education.

Dim sector of education, Statfin opiskt pxt 002 px, Full history

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

Dim education, Statfin opiskt pxt 002 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1239 rows, out of which 1 are empty, making the null percent 0.08. Minimum value is 1101 and maximum value is 885601.
label	string	The label for the dimension value. Column label has 1239 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001101 Pre-Primary Educat... and first 25 characters of maximum string: 885601 Doctor of Arts (Mi...

Dim education, Statfin opiskt pxt 002 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1239 rows, out of which 1 are empty, making the null percent 0.08. Minimum value is 1101 and maximum value is 885601.
label	string	The label for the dimension value. Column label has 1239 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001101 Pre-Primary Educat... and first 25 characters of maximum string: 885601 Doctor of Arts (Mi...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim data, Statfin opiskt pxt 002 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 Aloit and maximum string is Tutkn.
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. Minimum string is New students, men and maximum string is Qualifications, women.

Dim data, Statfin opiskt pxt 002 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 Aloit and maximum string is Tutkn.
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. Minimum string is New students, men and maximum string is Qualifications, women.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 14, 2019
Created	July 14, 2019