1. Home
  2. Datasets
  3. 11 ap -- Kuntasektorin ...
To download the data set, please sign up or log in

11 ap -- Kuntasektorin tuntipalkat ammateittain (kuntasektorin ammattinimikkeistö), 2018

11 ap -- Kuntasektorin tuntipalkat ammateittain (kuntasektorin ammattinimikkeistö), 2018

Tables

Column Descriptions

Dim sukupuoli, Statfin ksp pxt 11ap 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 sukupuoli, Statfin ksp pxt 11ap 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, Statfin ksp pxt 11ap px, Full history

Column Type Comment
ammattinimike int Kevan ammattikoodin mukainen ammattinimike. . Column ammattinimike has 294 rows, out of which 3 are empty, making the null percent 1.02. Minimum value is 1020 and maximum value is 97088.
sukupuoli int Sukupuoli (sukupuolet yhteensä/miehet/naiset) . Column sukupuoli has 294 rows, out of which 98 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
vuosi int Aineiston tilastovuosi . Column vuosi has 294 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2018.
tuntipalkkaisia_yhteensa int (Tuntipalkkaiset) Lukumäärä yhteensä. . Column tuntipalkkaisia_yhteensa has 294 rows, out of which 47 are empty, making the null percent 15.99. Minimum value is 1 and maximum value is 6787.
saannollisen_tyoajan_tuntiansion_keskiarvo_et int (Tuntipalkkaiset) Säännöllisen työajan tuntiansion keskiarvo. . Column saannollisen_tyoajan_tuntiansion_keskiarvo_et has 294 rows, out of which 126 are empty, making the null percent 42.86. Minimum value is 10 and maximum value is 20.
kokonaistuntiansion_keskiarvo_et int (Tuntipalkkaiset) Kokonaistuntiansion keskiarvo, e/t . . Column kokonaistuntiansion_keskiarvo_et has 294 rows, out of which 126 are empty, making the null percent 42.86. Minimum value is 10 and maximum value is 20.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin ksp pxt 11ap px, Latest

Column Type Comment
ammattinimike int Kevan ammattikoodin mukainen ammattinimike. . Column ammattinimike has 294 rows, out of which 3 are empty, making the null percent 1.02. Minimum value is 1020 and maximum value is 97088.
sukupuoli int Sukupuoli (sukupuolet yhteensä/miehet/naiset) . Column sukupuoli has 294 rows, out of which 98 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
vuosi int Aineiston tilastovuosi . Column vuosi has 294 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2018.
tuntipalkkaisia_yhteensa int (Tuntipalkkaiset) Lukumäärä yhteensä. . Column tuntipalkkaisia_yhteensa has 294 rows, out of which 47 are empty, making the null percent 15.99. Minimum value is 1 and maximum value is 6787.
saannollisen_tyoajan_tuntiansion_keskiarvo_et int (Tuntipalkkaiset) Säännöllisen työajan tuntiansion keskiarvo. . Column saannollisen_tyoajan_tuntiansion_keskiarvo_et has 294 rows, out of which 126 are empty, making the null percent 42.86. Minimum value is 10 and maximum value is 20.
kokonaistuntiansion_keskiarvo_et int (Tuntipalkkaiset) Kokonaistuntiansion keskiarvo, e/t . . Column kokonaistuntiansion_keskiarvo_et has 294 rows, out of which 126 are empty, making the null percent 42.86. Minimum value is 10 and maximum value is 20.

Dim ammattinimike, Statfin ksp pxt 11ap px, Full history

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

Dim ammattinimike, Statfin ksp pxt 11ap px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 98 rows, out of which 1 are empty, making the null percent 1.02. Minimum value is 1020 and maximum value is 97088.
label string The label for the dimension value. Column label has 98 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.

Additional Info

Last Updated July 21, 2019
Created July 13, 2019