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

004 -- Kuntasektorin kuukausipalkat toimialan (TOL 2008) mukaan vuonna 2016

004 -- Kuntasektorin kuukausipalkat toimialan (TOL 2008) mukaan vuonna 2016

Tables

Column Descriptions

Dim tiedot, Statfinpas ksp pxt 004 201600 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 14 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 14 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 ksp pxt 004 201600 fi px, Latest

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 9156 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 9156 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 9156 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.
kuntasektorin_kuukausipalkat_toimialan_tol_2008_mukaan_vuonna_2016 int Datasource did not contain a description for Kuntasektorin_kuukausipalkat_toimialan_TOL_2008_mukaan_vuonna_2016. Column kuntasektorin_kuukausipalkat_toimialan_tol_2008_mukaan_vuonna_2016 has 9156 rows, out of which 90 are empty, making the null percent 0.98. Minimum value is 1 and maximum value is 412041.

Dim sukupuoli, Statfinpas ksp pxt 004 201600 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 ksp pxt 004 201600 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 14 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 14 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 toimiala, Statfinpas ksp pxt 004 201600 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 218 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...
label string The label for the dimension value. Column label has 218 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...

Dim sukupuoli, Statfinpas ksp pxt 004 201600 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.

Fact, Statfinpas ksp pxt 004 201600 fi px, Full history

Column Type Comment
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 9156 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 9156 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 9156 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.
kuntasektorin_kuukausipalkat_toimialan_tol_2008_mukaan_vuonna_2016 int Datasource did not contain a description for Kuntasektorin_kuukausipalkat_toimialan_TOL_2008_mukaan_vuonna_2016. Column kuntasektorin_kuukausipalkat_toimialan_tol_2008_mukaan_vuonna_2016 has 9156 rows, out of which 90 are empty, making the null percent 0.98. Minimum value is 1 and maximum value is 412041.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Statfinpas ksp pxt 004 201600 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 218 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...
label string The label for the dimension value. Column label has 218 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01620 Kotieläintaloutta ... and first 25 characters of maximum string: 960 Muut henkilökohtai...
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