1. Home
  2. Datasets
  3. 001 -- Main type of activity ...
To download the data set, please sign up or log in

001 -- Main type of activity of completers of qualifications one year after graduation by field of education and by region of residence in 2007 to 2016

001 -- Main type of activity of completers of qualifications one year after graduation by field of education and by region of residence in 2007 to 2016

Tables

Column Descriptions

Fact, Statfinpas sijk pxt 001 201600 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 514800 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 2016.
level_of_education int National classification of education 2016 . Column level_of_education has 514800 rows, out of which 46800 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 514800 rows, out of which 39600 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 514800 rows, out of which 171600 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 514800 rows, out of which 25740 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
main_type_of_activity string Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 514800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Tyoton.
main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016 int Datasource did not contain a description for Main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016. Column main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016 has 514800 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 142573.

Fact, Statfinpas sijk pxt 001 201600 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 514800 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 2016.
level_of_education int National classification of education 2016 . Column level_of_education has 514800 rows, out of which 46800 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 514800 rows, out of which 39600 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 514800 rows, out of which 171600 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 514800 rows, out of which 25740 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
main_type_of_activity string Datasource did not contain a description for Main_type_of_activity. Column main_type_of_activity has 514800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Tyoton.
main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016 int Datasource did not contain a description for Main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016. Column main_type_of_activity_of_completers_of_qualifications_one_year_after_graduation_by_field_of_education_and_by_region_of_residence_in_2007_to_2016 has 514800 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 142573.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas sijk pxt 001 201600 px, Latest

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

Dim year, Statfinpas sijk pxt 001 201600 px, Full history

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

Dim level of education, Statfinpas sijk pxt 001 201600 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 level of education, Statfinpas sijk pxt 001 201600 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, Statfinpas sijk pxt 001 201600 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 field of education, Statfinpas sijk pxt 001 201600 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, Statfinpas sijk pxt 001 201600 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 gender, Statfinpas sijk pxt 001 201600 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, Statfinpas sijk pxt 001 201600 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.

Dim region of residence, Statfinpas sijk pxt 001 201600 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.

Dim main type of activity, Statfinpas sijk pxt 001 201600 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Tyoton.
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. First 25 characters of minimum string: Completers of qualificati... and first 25 characters of maximum string: Others...
orig_extractdate string The date when the data was originally fetched from the source.

Dim main type of activity, Statfinpas sijk pxt 001 201600 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Muu and maximum string is Tyoton.
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. First 25 characters of minimum string: Completers of qualificati... and first 25 characters of maximum string: Others...

Additional Info

Last Updated July 18, 2019
Created July 11, 2019