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

003 -- Valtion kuukausipalkat toimialaluokituksen mukaan vuonna 2017

003 -- Valtion kuukausipalkat toimialaluokituksen mukaan vuonna 2017

Tables

Column Descriptions

Dim sukupuoli, Statfinpas vkp pxt 003 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 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 y.
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 Sukupuolet yhteensä.

Dim sukupuoli, Statfinpas vkp pxt 003 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 3 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 y.
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 Sukupuolet yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Statfinpas vkp pxt 003 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 89 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...
label string The label for the dimension value. Column label has 89 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas vkp pxt 003 201700 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 3471 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 3471 rows, out of which 1157 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 3471 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans and maximum string is Kans_cv.
valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017 int Datasource did not contain a description for Valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017. Column valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017 has 3471 rows, out of which 1410 are empty, making the null percent 40.62. Minimum value is 2 and maximum value is 72223.

Dim toimiala, Statfinpas vkp pxt 003 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 89 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...
label string The label for the dimension value. Column label has 89 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...

Fact, Statfinpas vkp pxt 003 201700 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 3471 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 42991 Maa- ja vesirakenn... and first 25 characters of maximum string: 91010 Kirjastojen ja ark...
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 3471 rows, out of which 1157 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 3471 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans and maximum string is Kans_cv.
valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017 int Datasource did not contain a description for Valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017. Column valtion_kuukausipalkat_toimialaluokituksen_mukaan_vuonna_2017 has 3471 rows, out of which 1410 are empty, making the null percent 40.62. Minimum value is 2 and maximum value is 72223.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas vkp pxt 003 201700 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 and maximum string is Kans_cv.
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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019