Dataset

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

001 -- Valtion kuukausipalkat ammateittain vuonna 2010

001 -- Valtion kuukausipalkat ammateittain vuonna 2010

Tables

Dim ammattinimike, Statfinpas vkp pxt 001 201000 fi px, Full historyTSV
Dimension Ammattinimike (Ammattinimike)
Dim ammattinimike, Statfinpas vkp pxt 001 201000 fi px, LatestTSV
Dimension Ammattinimike (Ammattinimike)
Dim sukupuoli, Statfinpas vkp pxt 001 201000 fi px, Full historyTSV
Dimension Sukupuoli (Sukupuoli)
Dim sukupuoli, Statfinpas vkp pxt 001 201000 fi px, LatestTSV
Dimension Sukupuoli (Sukupuoli)
Fact, Statfinpas vkp pxt 001 201000 fi px, Full historyTSV
Valtion kuukausipalkat ammateittain vuonna 2010 muuttujina Ammattinimike, Sukupuoli ja Tiedot
Fact, Statfinpas vkp pxt 001 201000 fi px, LatestTSV
Valtion kuukausipalkat ammateittain vuonna 2010 muuttujina Ammattinimike, Sukupuoli ja Tiedot

Column Descriptions

Fact, Statfinpas vkp pxt 001 201000 fi px, Full history

Column	Type	Comment
ammattinimike	string	Datasource did not contain a description for Ammattinimike. Column ammattinimike has 34047 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AGROLOGI and maximum string is YRITYSTUTKIJA.
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 34047 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 34047 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.
valtion_kuukausipalkat_ammateittain_vuonna_2010	int	Datasource did not contain a description for Valtion_kuukausipalkat_ammateittain_vuonna_2010. Column valtion_kuukausipalkat_ammateittain_vuonna_2010 has 34047 rows, out of which 8983 are empty, making the null percent 26.38. Minimum value is 0 and maximum value is 84784.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas vkp pxt 001 201000 fi px, Latest

Column	Type	Comment
ammattinimike	string	Datasource did not contain a description for Ammattinimike. Column ammattinimike has 34047 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AGROLOGI and maximum string is YRITYSTUTKIJA.
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 34047 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 34047 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.
valtion_kuukausipalkat_ammateittain_vuonna_2010	int	Datasource did not contain a description for Valtion_kuukausipalkat_ammateittain_vuonna_2010. Column valtion_kuukausipalkat_ammateittain_vuonna_2010 has 34047 rows, out of which 8983 are empty, making the null percent 26.38. Minimum value is 0 and maximum value is 84784.

Dim sukupuoli, Statfinpas vkp pxt 001 201000 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 sukupuoli, Statfinpas vkp pxt 001 201000 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 ammattinimike, Statfinpas vkp pxt 001 201000 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 873 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AGROLOGI and maximum string is YRITYSTUTKIJA.
label	string	The label for the dimension value. Column label has 873 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AGROLOGI and maximum string is YRITYSTUTKIJA.

Dim ammattinimike, Statfinpas vkp pxt 001 201000 fi px, Full history

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

Additional Info

Last Updated	July 21, 2019
Created	July 17, 2019