1. Home
  2. Datasets
  3. 001 -- Valtion kuukausipalkat ...
To download the data set, please sign up or log in

001 -- Valtion kuukausipalkat ammateittain vuonna 2009

001 -- Valtion kuukausipalkat ammateittain vuonna 2009

Tables

Column Descriptions

Dim ammattinimike, Statfinpas vkp pxt 001 200900 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 417 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 71 and maximum value is 96143.
label string The label for the dimension value. Column label has 417 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akatemiaprofessori and maximum string is Ympäristöneuvos.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ammattinimike, Statfinpas vkp pxt 001 200900 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 417 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 71 and maximum value is 96143.
label string The label for the dimension value. Column label has 417 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akatemiaprofessori and maximum string is Ympäristöneuvos.

Dim tiedot, Statfinpas vkp pxt 001 200900 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokoaikaisten lukumäärä... and first 25 characters of maximum string: Kokonaisansion variaatiok...

Dim sukupuoli, Statfinpas vkp pxt 001 200900 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.

Dim tiedot, Statfinpas vkp pxt 001 200900 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokoaikaisten lukumäärä... and first 25 characters of maximum string: Kokonaisansion variaatiok...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vkp pxt 001 200900 fi px, Latest

Column Type Comment
ammattinimike int Datasource did not contain a description for Ammattinimike. Column ammattinimike has 16263 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 71 and maximum value is 96143.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 16263 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 16263 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90.
valtion_kuukausipalkat_ammateittain_vuonna_2009 int Datasource did not contain a description for Valtion_kuukausipalkat_ammateittain_vuonna_2009. Column valtion_kuukausipalkat_ammateittain_vuonna_2009 has 16263 rows, out of which 4558 are empty, making the null percent 28.03. Minimum value is 0 and maximum value is 9410.

Dim sukupuoli, Statfinpas vkp pxt 001 200900 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.

Fact, Statfinpas vkp pxt 001 200900 fi px, Full history

Column Type Comment
ammattinimike int Datasource did not contain a description for Ammattinimike. Column ammattinimike has 16263 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 71 and maximum value is 96143.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 16263 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 16263 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_cv and maximum string is Kans_p90.
valtion_kuukausipalkat_ammateittain_vuonna_2009 int Datasource did not contain a description for Valtion_kuukausipalkat_ammateittain_vuonna_2009. Column valtion_kuukausipalkat_ammateittain_vuonna_2009 has 16263 rows, out of which 4558 are empty, making the null percent 28.03. Minimum value is 0 and maximum value is 9410.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated August 4, 2019
Created August 2, 2019