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

005 -- Kuntasektorin tuntipalkat ammateittain vuonna 2017

005 -- Kuntasektorin tuntipalkat ammateittain vuonna 2017

Tables

Column Descriptions

Dim sukupuoli, Statfinpas ksp pxt 005 201700 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 ksp pxt 005 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 Kans_ka and maximum string is Sans_ka.
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. First 25 characters of minimum string: Kokonaistuntiansio, e/t... and first 25 characters of maximum string: Säännöllisen työajan tunt...

Dim ammattinimike, Statfinpas ksp pxt 005 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammattimies and maximum string is Yhdyskuntarakentaja.
label string The label for the dimension value. Column label has 108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Yhdyskuntarakentaja.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ammattinimike, Statfinpas ksp pxt 005 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammattimies and maximum string is Yhdyskuntarakentaja.
label string The label for the dimension value. Column label has 108 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammatit yhteensä and maximum string is Yhdyskuntarakentaja.

Fact, Statfinpas ksp pxt 005 201700 fi px, Latest

Column Type Comment
ammattinimike string Datasource did not contain a description for Ammattinimike. Column ammattinimike has 972 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ammattimies and maximum string is Yhdyskuntarakentaja.
sukupuoli int Datasource did not contain a description for Sukupuoli. Column sukupuoli has 972 rows, out of which 324 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 972 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kans_ka and maximum string is Sans_ka.
kuntasektorin_tuntipalkat_ammateittain_vuonna_2017 int Datasource did not contain a description for Kuntasektorin_tuntipalkat_ammateittain_vuonna_2017. Column kuntasektorin_tuntipalkat_ammateittain_vuonna_2017 has 972 rows, out of which 334 are empty, making the null percent 34.36. Minimum value is 1 and maximum value is 7402.

Dim tiedot, Statfinpas ksp pxt 005 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 Kans_ka and maximum string is Sans_ka.
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. First 25 characters of minimum string: Kokonaistuntiansio, e/t... and first 25 characters of maximum string: Säännöllisen työajan tunt...
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas ksp pxt 005 201700 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.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019