To download the data set, please sign up or log in

001 -- Peruskoulun vuosiluokkien 1-6 oppilaiden kielivalinnat maakunnittain, opetuskielittäin, vuosiluokittain 2015

001 -- Peruskoulun vuosiluokkien 1-6 oppilaiden kielivalinnat maakunnittain, opetuskielittäin, vuosiluokittain 2015

Tables

Column Descriptions

Fact, Statfinpas ava pxt 001 201500 fi px, Full history

Column Type Comment
oppilaitoksen_sijaintimaakunta int Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 25200 rows, out of which 1260 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
oppilaitoksen_opetuskieli int Datasource did not contain a description for Oppilaitoksen_opetuskieli. Column oppilaitoksen_opetuskieli has 25200 rows, out of which 4200 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 9.
opiskeltu_kieli int Datasource did not contain a description for Opiskeltu_kieli. Column opiskeltu_kieli has 25200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 10.
vuosiluokka int Datasource did not contain a description for Vuosiluokka. Column vuosiluokka has 25200 rows, out of which 3600 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
opiskellun_kielen_laajuus int Datasource did not contain a description for Opiskellun_kielen_laajuus. Column opiskellun_kielen_laajuus has 25200 rows, out of which 8400 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 25200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oppil.
peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015 int Datasource did not contain a description for Peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015. Column peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015 has 25200 rows, out of which 12810 are empty, making the null percent 50.83. Minimum value is 0 and maximum value is 238044.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosiluokka, Statfinpas ava pxt 001 201500 fi px, Full history

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

Dim opiskellun kielen laajuus, Statfinpas ava pxt 001 201500 fi 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 A1-kieli, yhteinen and maximum string is A2-kieli, vapaaehtoinen.

Dim oppilaitoksen sijaintimaakunta, Statfinpas ava pxt 001 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 ava pxt 001 201500 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
label string The label for the dimension value. Column label has 7 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 6. vuosiluokka.

Dim oppilaitoksen sijaintimaakunta, Statfinpas ava pxt 001 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 oppilaitoksen opetuskieli, Statfinpas ava pxt 001 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 9.
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 Englanti and maximum string is Muu.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas ava pxt 001 201500 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oppil.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kieltä opiskelevia oppila...
orig_extractdate string The date when the data was originally fetched from the source.

Dim opiskeltu kieli, Statfinpas ava pxt 001 201500 fi 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 1 and maximum value is 10.
label string 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 string is Englanti and maximum string is Muu kieli.

Dim opiskeltu kieli, Statfinpas ava pxt 001 201500 fi 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 1 and maximum value is 10.
label string 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 string is Englanti and maximum string is Muu kieli.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas ava pxt 001 201500 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oppil.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kieltä opiskelevia oppila...

Dim opiskellun kielen laajuus, Statfinpas ava pxt 001 201500 fi 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 A1-kieli, yhteinen and maximum string is A2-kieli, vapaaehtoinen.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas ava pxt 001 201500 fi px, Latest

Column Type Comment
oppilaitoksen_sijaintimaakunta int Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 25200 rows, out of which 1260 are empty, making the null percent 5.00. Minimum value is 1 and maximum value is 21.
oppilaitoksen_opetuskieli int Datasource did not contain a description for Oppilaitoksen_opetuskieli. Column oppilaitoksen_opetuskieli has 25200 rows, out of which 4200 are empty, making the null percent 16.67. Minimum value is 1 and maximum value is 9.
opiskeltu_kieli int Datasource did not contain a description for Opiskeltu_kieli. Column opiskeltu_kieli has 25200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 10.
vuosiluokka int Datasource did not contain a description for Vuosiluokka. Column vuosiluokka has 25200 rows, out of which 3600 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 6.
opiskellun_kielen_laajuus int Datasource did not contain a description for Opiskellun_kielen_laajuus. Column opiskellun_kielen_laajuus has 25200 rows, out of which 8400 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 25200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Oppil.
peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015 int Datasource did not contain a description for Peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015. Column peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittainvuosiluokittain_2015 has 25200 rows, out of which 12810 are empty, making the null percent 50.83. Minimum value is 0 and maximum value is 238044.

Dim oppilaitoksen opetuskieli, Statfinpas ava pxt 001 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 9.
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 Englanti and maximum string is Muu.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019