1. Home
  2. Datasets
  3. 004 -- Peruskoulun oppilaat ...
To download the data set, please sign up or log in

004 -- Peruskoulun oppilaat maakunnittain, kunnittain, ylläpitäjittäin ja vuosiluokittain vuonna 2015

004 -- Peruskoulun oppilaat maakunnittain, kunnittain, ylläpitäjittäin ja vuosiluokittain vuonna 2015

Tables

Column Descriptions

Dim oppilaitoksen sijaintimaakunta, Statfinpas pop pxt 004 201500 fi 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 Ahvenanmaa and maximum string is Lappi.

Dim vuosiluokka, Statfinpas pop pxt 004 201500 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 12 rows, out of which 1 are empty, making the null percent 8.33. Minimum value is 0 and maximum value is 10.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. vuosiluokka and maximum string is Lisäopetus.

Dim oppilaitoksen sijaintikunta 2015, Statfinpas pop pxt 004 201500 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 318 rows, out of which 1 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
orig_extractdate string The date when the data was originally fetched from the source.

Dim oppilaitoksen yllapitaja, Statfinpas pop pxt 004 201500 fi 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 Ahvenanmaan maakunta and maximum string is Kuntayhtymä.

Dim tiedot, Statfinpas pop pxt 004 201500 fi 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 Oppil and maximum string is Tytot.
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. First 25 characters of minimum string: Peruskoulun oppilaat yhte... and first 25 characters of maximum string: Tytöt...

Dim oppilaitoksen yllapitaja, Statfinpas pop pxt 004 201500 fi 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 Ahvenanmaan maakunta and maximum string is Kuntayhtymä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas pop pxt 004 201500 fi 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 Oppil and maximum string is Tytot.
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. First 25 characters of minimum string: Peruskoulun oppilaat yhte... and first 25 characters of maximum string: Tytöt...
orig_extractdate string The date when the data was originally fetched from the source.

Dim oppilaitoksen sijaintikunta 2015, Statfinpas pop pxt 004 201500 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 318 rows, out of which 1 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 318 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.

Fact, Statfinpas pop pxt 004 201500 fi px, Latest

Column Type Comment
oppilaitoksen_sijaintimaakunta string Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 1373760 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
oppilaitoksen_sijaintikunta_2015 int Datasource did not contain a description for Oppilaitoksen_sijaintikunta_2015. Column oppilaitoksen_sijaintikunta_2015 has 1373760 rows, out of which 4320 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 992.
oppilaitoksen_yllapitaja int Datasource did not contain a description for Oppilaitoksen_yllapitaja. Column oppilaitoksen_yllapitaja has 1373760 rows, out of which 228960 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
vuosiluokka int Datasource did not contain a description for Vuosiluokka. Column vuosiluokka has 1373760 rows, out of which 114480 are empty, making the null percent 8.33. Minimum value is 0 and maximum value is 10.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1373760 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Oppil and maximum string is Tytot.
peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015 int Datasource did not contain a description for Peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015. Column peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015 has 1373760 rows, out of which 1328166 are empty, making the null percent 96.68. Minimum value is 0 and maximum value is 546065.

Dim oppilaitoksen sijaintimaakunta, Statfinpas pop pxt 004 201500 fi 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 Ahvenanmaa and maximum string is Lappi.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosiluokka, Statfinpas pop pxt 004 201500 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 12 rows, out of which 1 are empty, making the null percent 8.33. Minimum value is 0 and maximum value is 10.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. vuosiluokka and maximum string is Lisäopetus.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas pop pxt 004 201500 fi px, Full history

Column Type Comment
oppilaitoksen_sijaintimaakunta string Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 1373760 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 21.
oppilaitoksen_sijaintikunta_2015 int Datasource did not contain a description for Oppilaitoksen_sijaintikunta_2015. Column oppilaitoksen_sijaintikunta_2015 has 1373760 rows, out of which 4320 are empty, making the null percent 0.31. Minimum value is 5 and maximum value is 992.
oppilaitoksen_yllapitaja int Datasource did not contain a description for Oppilaitoksen_yllapitaja. Column oppilaitoksen_yllapitaja has 1373760 rows, out of which 228960 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 5.
vuosiluokka int Datasource did not contain a description for Vuosiluokka. Column vuosiluokka has 1373760 rows, out of which 114480 are empty, making the null percent 8.33. Minimum value is 0 and maximum value is 10.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 1373760 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Oppil and maximum string is Tytot.
peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015 int Datasource did not contain a description for Peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015. Column peruskoulun_oppilaat_maakunnittain_kunnittain_yllapitajittain_ja_vuosiluokittain_vuonna_2015 has 1373760 rows, out of which 1328166 are empty, making the null percent 96.68. Minimum value is 0 and maximum value is 546065.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated August 4, 2019
Created June 12, 2019