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

905 -- Palkansaajien kokonaisansiot tunnissa ammattiluokituksen, työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2009

905 -- Palkansaajien kokonaisansiot tunnissa ammattiluokituksen, työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2009

Tables

Column Descriptions

Dim tyonantajasektori, Statfinpas pra pxt 905 200900 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.

Dim kokoaikaisuus, Statfinpas pra pxt 905 200900 fi px, Full history

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

Fact, Statfinpas pra pxt 905 200900 fi px, Full history

Column Type Comment
ammattiluokka int Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 2784 rows, out of which 192 are empty, making the null percent 6.90. Minimum value is 1 and maximum value is 93.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 2784 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.
kokoaikaisuus int Datasource did not contain a description for Kokoaikaisuus. Column kokoaikaisuus has 2784 rows, out of which 1392 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2784 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 Tp_cv.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009 int Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009 has 2784 rows, out of which 664 are empty, making the null percent 23.85. Minimum value is 1 and maximum value is 1590617.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas pra pxt 905 200900 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 Lkm and maximum string is Tp_cv.
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 ammattiluokka, Statfinpas pra pxt 905 200900 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 29 rows, out of which 2 are empty, making the null percent 6.90. Minimum value is 1 and maximum value is 93.
label string The label for the dimension value. Column label has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 Sotilaat and maximum string is Tuntematon.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kokoaikaisuus, Statfinpas pra pxt 905 200900 fi px, Latest

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

Fact, Statfinpas pra pxt 905 200900 fi px, Latest

Column Type Comment
ammattiluokka int Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 2784 rows, out of which 192 are empty, making the null percent 6.90. Minimum value is 1 and maximum value is 93.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 2784 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.
kokoaikaisuus int Datasource did not contain a description for Kokoaikaisuus. Column kokoaikaisuus has 2784 rows, out of which 1392 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 2784 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 Tp_cv.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009 int Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2009 has 2784 rows, out of which 664 are empty, making the null percent 23.85. Minimum value is 1 and maximum value is 1590617.

Dim tyonantajasektori, Statfinpas pra pxt 905 200900 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 ammattiluokka, Statfinpas pra pxt 905 200900 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 29 rows, out of which 2 are empty, making the null percent 6.90. Minimum value is 1 and maximum value is 93.
label string The label for the dimension value. Column label has 29 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 Sotilaat and maximum string is Tuntematon.

Dim tiedot, Statfinpas pra pxt 905 200900 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 Lkm and maximum string is Tp_cv.
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...

Additional Info

Last Updated August 5, 2019
Created August 5, 2019