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

003 -- Yksityisen sektorin kuukausipalkkaisten ansiot koulutusluokituksen mukaan vuonna 2007

003 -- Yksityisen sektorin kuukausipalkkaisten ansiot koulutusluokituksen mukaan vuonna 2007

Tables

Column Descriptions

Dim sukupuoli, Statfinpas yskp pxt 003 200700 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 Miehet and maximum string is Naiset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas yskp pxt 003 200700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm and maximum string is Sans_p90.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Lukumäärä... and first 25 characters of maximum string: Säännöllisen työajan ansi...

Fact, Statfinpas yskp pxt 003 200700 fi px, Latest

Column Type Comment
koulutusluokitus int Datasource did not contain a description for Koulutusluokitus. Column koulutusluokitus has 7530 rows, out of which 15 are empty, making the null percent 0.20. Minimum value is 0 and maximum value is 9999.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 7530 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 7530 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm and maximum string is Sans_p90.
yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007 int Datasource did not contain a description for Yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007. Column yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007 has 7530 rows, out of which 1434 are empty, making the null percent 19.04. Minimum value is 1 and maximum value is 619500.

Dim tiedot, Statfinpas yskp pxt 003 200700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm and maximum string is Sans_p90.
label string The label for the dimension value. Column label has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Lukumäärä... and first 25 characters of maximum string: Säännöllisen työajan ansi...
orig_extractdate string The date when the data was originally fetched from the source.

Dim koulutusluokitus, Statfinpas yskp pxt 003 200700 fi px, Full history

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

Fact, Statfinpas yskp pxt 003 200700 fi px, Full history

Column Type Comment
koulutusluokitus int Datasource did not contain a description for Koulutusluokitus. Column koulutusluokitus has 7530 rows, out of which 15 are empty, making the null percent 0.20. Minimum value is 0 and maximum value is 9999.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 7530 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 7530 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm and maximum string is Sans_p90.
yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007 int Datasource did not contain a description for Yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007. Column yksityisen_sektorin_kuukausipalkkaisten_ansiot_koulutusluokituksen_mukaan_vuonna_2007 has 7530 rows, out of which 1434 are empty, making the null percent 19.04. Minimum value is 1 and maximum value is 619500.
orig_extractdate string The date when the data was originally fetched from the source.

Dim koulutusluokitus, Statfinpas yskp pxt 003 200700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 502 rows, out of which 1 are empty, making the null percent 0.20. Minimum value is 0 and maximum value is 9999.
label string The label for the dimension value. Column label has 502 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0 Yleissivistävä koulutus... and first 25 characters of maximum string: 9999 Muu koulutus, koulut...

Dim sukupuoli, Statfinpas yskp pxt 003 200700 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 Miehet and maximum string is Naiset.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019