002 -- Peruskoulun vuosiluokkien 1-6 oppilaiden kielivalinnat maakunnittain, opetuskielittäin 2018

Tables

Dim opiskellun kielen laajuus, Statfin ava pxt 002 fi px, Full historyTSV
Dimension Opiskellun_kielen_laajuus (Opiskellun kielen laajuus)
Dim opiskellun kielen laajuus, Statfin ava pxt 002 fi px, LatestTSV
Dimension Opiskellun_kielen_laajuus (Opiskellun kielen laajuus)
Dim opiskeltu kieli, Statfin ava pxt 002 fi px, Full historyTSV
Dimension Opiskeltu_kieli (Opiskeltu kieli)
Dim opiskeltu kieli, Statfin ava pxt 002 fi px, LatestTSV
Dimension Opiskeltu_kieli (Opiskeltu kieli)
Dim oppilaitoksen opetuskieli, Statfin ava pxt 002 fi px, Full historyTSV
Dimension Oppilaitoksen_opetuskieli (Oppilaitoksen opetuskieli)
Dim oppilaitoksen opetuskieli, Statfin ava pxt 002 fi px, LatestTSV
Dimension Oppilaitoksen_opetuskieli (Oppilaitoksen opetuskieli)
Dim oppilaitoksen sijaintimaakunta, Statfin ava pxt 002 fi px, Full historyTSV
Dimension Oppilaitoksen_sijaintimaakunta (Oppilaitoksen sijaintimaakunta)
Dim oppilaitoksen sijaintimaakunta, Statfin ava pxt 002 fi px, LatestTSV
Dimension Oppilaitoksen_sijaintimaakunta (Oppilaitoksen sijaintimaakunta)
Dim tiedot, Statfin ava pxt 002 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin ava pxt 002 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Fact, Statfin ava pxt 002 fi px, Full historyTSV
Peruskoulun vuosiluokkien 1-6 oppilaiden kielivalinnat maakunnittain, opetuskielittäin 2018 muuttujina Oppilaitoksen sijaintimaakunta, Oppilaitoksen opetuskieli, Opiskeltu kieli, Opiskellun kielen laajuus ja Tiedot
Fact, Statfin ava pxt 002 fi px, LatestTSV
Peruskoulun vuosiluokkien 1-6 oppilaiden kielivalinnat maakunnittain, opetuskielittäin 2018 muuttujina Oppilaitoksen sijaintimaakunta, Oppilaitoksen opetuskieli, Opiskeltu kieli, Opiskellun kielen laajuus ja Tiedot

Column Descriptions

Dim oppilaitoksen opetuskieli, Statfin ava pxt 002 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, Statfin ava pxt 002 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: Kieltä opiskelevia oppila... and first 25 characters of maximum string: Kieltä opiskelevia tyttöj...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim oppilaitoksen sijaintimaakunta, Statfin ava pxt 002 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, Statfin ava pxt 002 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.

Dim tiedot, Statfin ava pxt 002 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: Kieltä opiskelevia oppila... and first 25 characters of maximum string: Kieltä opiskelevia tyttöj...

Dim opiskeltu kieli, Statfin ava pxt 002 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 opiskellun kielen laajuus, Statfin ava pxt 002 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 opiskellun kielen laajuus, Statfin ava pxt 002 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, Statfin ava pxt 002 fi px, Latest

Column	Type	Comment
oppilaitoksen_sijaintimaakunta	int	Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 10800 rows, out of which 540 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 10800 rows, out of which 1800 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 10800 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.
opiskellun_kielen_laajuus	string	Datasource did not contain a description for Opiskellun_kielen_laajuus. Column opiskellun_kielen_laajuus has 10800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 10800 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_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018	int	Datasource did not contain a description for Peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018. Column peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018 has 10800 rows, out of which 5400 are empty, making the null percent 50.00. Minimum value is 0 and maximum value is 273681.

Dim opiskeltu kieli, Statfin ava pxt 002 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.

Fact, Statfin ava pxt 002 fi px, Full history

Column	Type	Comment
oppilaitoksen_sijaintimaakunta	int	Datasource did not contain a description for Oppilaitoksen_sijaintimaakunta. Column oppilaitoksen_sijaintimaakunta has 10800 rows, out of which 540 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 10800 rows, out of which 1800 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 10800 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.
opiskellun_kielen_laajuus	string	Datasource did not contain a description for Opiskellun_kielen_laajuus. Column opiskellun_kielen_laajuus has 10800 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 10800 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_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018	int	Datasource did not contain a description for Peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018. Column peruskoulun_vuosiluokkien_16_oppilaiden_kielivalinnat_maakunnittain_opetuskielittain_2018 has 10800 rows, out of which 5400 are empty, making the null percent 50.00. Minimum value is 0 and maximum value is 273681.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim oppilaitoksen sijaintimaakunta, Statfin ava pxt 002 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.

Additional Info

Last Updated	September 20, 2019
Created	August 5, 2019