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

003 -- Oppilaitosten tutkintoon johtamattoman aikuiskoulutuksen opetustunnit ja osallistujat 2004-2017

003 -- Oppilaitosten tutkintoon johtamattoman aikuiskoulutuksen opetustunnit ja osallistujat 2004-2017

Tables

Column Descriptions

Fact, Statfin oaiop pxt 003 fi px, Full history

Column Type Comment
oppilaitostyyppi int Datasource did not contain a description for Oppilaitostyyppi. Column oppilaitostyyppi has 3528 rows, out of which 252 are empty, making the null percent 7.14. Minimum value is 21 and maximum value is 99.
koulutustyyppi int Datasource did not contain a description for Koulutustyyppi. Column koulutustyyppi has 3528 rows, out of which 392 are empty, making the null percent 11.11. Minimum value is 1 and maximum value is 8.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 3528 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 2017.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 3528 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Osall and maximum string is Tunnit.
oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017 int Datasource did not contain a description for Oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017. Column oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017 has 3528 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 6151721.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin oaiop pxt 003 fi px, Latest

Column Type Comment
oppilaitostyyppi int Datasource did not contain a description for Oppilaitostyyppi. Column oppilaitostyyppi has 3528 rows, out of which 252 are empty, making the null percent 7.14. Minimum value is 21 and maximum value is 99.
koulutustyyppi int Datasource did not contain a description for Koulutustyyppi. Column koulutustyyppi has 3528 rows, out of which 392 are empty, making the null percent 11.11. Minimum value is 1 and maximum value is 8.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 3528 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 2017.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 3528 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Osall and maximum string is Tunnit.
oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017 int Datasource did not contain a description for Oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017. Column oppilaitosten_tutkintoon_johtamattoman_aikuiskoulutuksen_opetustunnit_ja_osallistujat_20042017 has 3528 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 6151721.

Dim koulutustyyppi, Statfin oaiop pxt 003 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 1 and maximum value is 8.
label string The label for the dimension value. Column label has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen lisäkoulutus... and first 25 characters of maximum string: Muu koulutus...
orig_extractdate string The date when the data was originally fetched from the source.

Dim koulutustyyppi, Statfin oaiop pxt 003 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 1 and maximum value is 8.
label string The label for the dimension value. Column label has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatillinen lisäkoulutus... and first 25 characters of maximum string: Muu koulutus...

Dim tiedot, Statfin oaiop pxt 003 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Osall and maximum string is Tunnit.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Opetustunnit, yhteensä and maximum string is Osallistujat, yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfin oaiop pxt 003 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Osall and maximum string is Tunnit.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Opetustunnit, yhteensä and maximum string is Osallistujat, yhteensä.

Dim vuosi, Statfin oaiop pxt 003 fi px, Full history

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

Dim vuosi, Statfin oaiop pxt 003 fi px, Latest

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

Dim oppilaitostyyppi, Statfin oaiop pxt 003 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 21 and maximum value is 99.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatilliset aikuiskoulut... and first 25 characters of maximum string: Muut oppilaitokset...
orig_extractdate string The date when the data was originally fetched from the source.

Dim oppilaitostyyppi, Statfin oaiop pxt 003 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 14 rows, out of which 1 are empty, making the null percent 7.14. Minimum value is 21 and maximum value is 99.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ammatilliset aikuiskoulut... and first 25 characters of maximum string: Muut oppilaitokset...

Additional Info

Last Updated July 20, 2019
Created July 11, 2019