003 -- Foreign-language speaking and foreign students in post-comprehensive education leading to a qualification by location of education and sector of education in 2004 to 2016

Tables

Dim area, Statfin opiskt pxt 003 px, Full historyTSV
Dimension Area (Alue)
Dim area, Statfin opiskt pxt 003 px, LatestTSV
Dimension Area (Alue)
Dim information, Statfin opiskt pxt 003 px, Full historyTSV
Dimension Information (Tiedot)
Dim information, Statfin opiskt pxt 003 px, LatestTSV
Dimension Information (Tiedot)
Dim sector of education, Statfin opiskt pxt 003 px, Full historyTSV
Dimension Sector_of_Education (Koulutussektori)
Dim sector of education, Statfin opiskt pxt 003 px, LatestTSV
Dimension Sector_of_Education (Koulutussektori)
Dim year, Statfin opiskt pxt 003 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin opiskt pxt 003 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin opiskt pxt 003 px, Full historyTSV
Students in post-comprehensive education leading to a qualification by Year, Area, Sector of Education and Information
Fact, Statfin opiskt pxt 003 px, LatestTSV
Students in post-comprehensive education leading to a qualification by Year, Area, Sector of Education and Information

Column Descriptions

Fact, Statfin opiskt pxt 003 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 53820 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 2016.
area	int	The location of education is based on the location municipality of education (upper secondary school students, vocational education in educational institutions, polytechnic and university education) or the location municipality of the educational institution (comprehensive school education, adult basic education and matriculation examinations) or the location municipality of the education provider (vocational apprenticeship training). . Column area has 53820 rows, out of which 195 are empty, making the null percent 0.36. Minimum value is 5 and maximum value is 999.
sector_of_education	int	Datasource did not contain a description for Sector_of_Education. Column sector_of_education has 53820 rows, out of which 10764 are empty, making the null percent 20.00. Minimum value is 20 and maximum value is 50.
information	string	Datasource did not contain a description for Information. Column information has 53820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Op and maximum string is Vko.
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 53820 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 728128.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim information, Statfin opiskt pxt 003 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 Op and maximum string is Vko.
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 Foreign speaking students and maximum string is Students total.
orig_extractdate	string	The date when the data was originally fetched from the source.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 20 and maximum value is 50.
label	string	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. First 25 characters of minimum string: Sectors of education, tot... and first 25 characters of maximum string: Upper secondary general e...

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 5 rows, out of which 1 are empty, making the null percent 20.00. Minimum value is 20 and maximum value is 50.
label	string	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. First 25 characters of minimum string: Sectors of education, tot... and first 25 characters of maximum string: Upper secondary general e...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim information, Statfin opiskt pxt 003 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 Op and maximum string is Vko.
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 Foreign speaking students and maximum string is Students total.

Fact, Statfin opiskt pxt 003 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 53820 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 2016.
area	int	The location of education is based on the location municipality of education (upper secondary school students, vocational education in educational institutions, polytechnic and university education) or the location municipality of the educational institution (comprehensive school education, adult basic education and matriculation examinations) or the location municipality of the education provider (vocational apprenticeship training). . Column area has 53820 rows, out of which 195 are empty, making the null percent 0.36. Minimum value is 5 and maximum value is 999.
sector_of_education	int	Datasource did not contain a description for Sector_of_Education. Column sector_of_education has 53820 rows, out of which 10764 are empty, making the null percent 20.00. Minimum value is 20 and maximum value is 50.
information	string	Datasource did not contain a description for Information. Column information has 53820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Op and maximum string is Vko.
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 53820 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 728128.

Dim area, Statfin opiskt pxt 003 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 276 rows, out of which 1 are empty, making the null percent 0.36. Minimum value is 5 and maximum value is 999.
label	string	The label for the dimension value. Column label has 276 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Abroad and maximum string is Unknown.

Dim year, Statfin opiskt pxt 003 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 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 2016.
label	int	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. Minimum value is 2004 and maximum value is 2016.

Dim year, Statfin opiskt pxt 003 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 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 2016.
label	int	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. Minimum value is 2004 and maximum value is 2016.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim area, Statfin opiskt pxt 003 px, Full history

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

Additional Info

Last Updated	September 20, 2019
Created	August 5, 2019