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

001 -- Kuntasektorin kuukausipalkat ammateittain vuonna 2011

001 -- Kuntasektorin kuukausipalkat ammateittain vuonna 2011

Tables

Column Descriptions

Dim sukupuoli, Statfinpas ksp pxt 001 201100 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 001 201100 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_cv and maximum string is Kans_p90.
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.

Dim tiedot, Statfinpas ksp pxt 001 201100 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_cv and maximum string is Kans_p90.
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 ammattinimike, Statfinpas ksp pxt 001 201100 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1618 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...
label string The label for the dimension value. Column label has 1618 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...

Dim ammattinimike, Statfinpas ksp pxt 001 201100 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1618 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...
label string The label for the dimension value. Column label has 1618 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas ksp pxt 001 201100 fi px, Latest

Column Type Comment
ammattinimike string Datasource did not contain a description for Ammattinimike. Column ammattinimike has 67956 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 67956 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 67956 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.
kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011 int Datasource did not contain a description for Kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011. Column kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011 has 67956 rows, out of which 22227 are empty, making the null percent 32.71. Minimum value is 1 and maximum value is 427604.

Fact, Statfinpas ksp pxt 001 201100 fi px, Full history

Column Type Comment
ammattinimike string Datasource did not contain a description for Ammattinimike. Column ammattinimike has 67956 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aamu- ja iltapäiväkerhon ... and first 25 characters of maximum string: Äänimestari...
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 67956 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 67956 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.
kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011 int Datasource did not contain a description for Kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011. Column kuntasektorin_kuukausipalkat_ammateittain_vuonna_2011 has 67956 rows, out of which 22227 are empty, making the null percent 32.71. Minimum value is 1 and maximum value is 427604.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas ksp pxt 001 201100 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 July 16, 2019
Created July 14, 2019