1. Home
  2. Datasets
  3. 002 -- Kokoaikaisten ...
To download the data set, please sign up or log in

002 -- Kokoaikaisten palkansaajien lukumäärät ja kokonaisansiot kuukaudessa koulutusasteen, iän ja työnantajasektorin mukaan vuonna 2017

002 -- Kokoaikaisten palkansaajien lukumäärät ja kokonaisansiot kuukaudessa koulutusasteen, iän ja työnantajasektorin mukaan vuonna 2017

Tables

Column Descriptions

Dim koulutusaste, Statfinpas pra pxt 002 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alempi korkeakouluaste and maximum string is Tutkijakoulutusaste.
orig_extractdate string The date when the data was originally fetched from the source.

Dim koulutusaste, Statfinpas pra pxt 002 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alempi korkeakouluaste and maximum string is Tutkijakoulutusaste.

Dim tiedot, Statfinpas pra pxt 002 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
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. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...

Fact, Statfinpas pra pxt 002 201700 fi px, Full history

Column Type Comment
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
koulutusaste int Datasource did not contain a description for Koulutusaste. Column koulutusaste has 2304 rows, out of which 576 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
ikaryhma string Datasource did not contain a description for Ikaryhma. Column ikaryhma has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15 - 19 and maximum string is X Tuntematon.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017 has 2304 rows, out of which 326 are empty, making the null percent 14.15. Minimum value is 1 and maximum value is 1387525.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ikaryhma, Statfinpas pra pxt 002 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15 - 19 and maximum string is X Tuntematon.
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 15 - 19 and maximum string is X Tuntematon.

Fact, Statfinpas pra pxt 002 201700 fi px, Latest

Column Type Comment
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
koulutusaste int Datasource did not contain a description for Koulutusaste. Column koulutusaste has 2304 rows, out of which 576 are empty, making the null percent 25.00. Minimum value is 3 and maximum value is 8.
ikaryhma string Datasource did not contain a description for Ikaryhma. Column ikaryhma has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15 - 19 and maximum string is X Tuntematon.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_koulutusasteen_ian_ja_tyonantajasektorin_mukaan_vuonna_2017 has 2304 rows, out of which 326 are empty, making the null percent 14.15. Minimum value is 1 and maximum value is 1387525.

Dim tiedot, Statfinpas pra pxt 002 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
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. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...
orig_extractdate string The date when the data was originally fetched from the source.

Dim ikaryhma, Statfinpas pra pxt 002 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 15 - 19 and maximum string is X Tuntematon.
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 15 - 19 and maximum string is X Tuntematon.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tyonantajasektori, Statfinpas pra pxt 002 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuntasektori and maximum string is Valtio.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tyonantajasektori, Statfinpas pra pxt 002 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuntasektori and maximum string is Valtio.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019