003 -- Kuntasektorin kuukausipalkat koulutusluokituksen mukaan vuonna 2017

Tables

Dim koulutusala, Statfinpas ksp pxt 003 201700 fi px, Full historyTSV
Dimension Koulutusala (Koulutusala)
Dim koulutusala, Statfinpas ksp pxt 003 201700 fi px, LatestTSV
Dimension Koulutusala (Koulutusala)
Dim koulutusaste, Statfinpas ksp pxt 003 201700 fi px, Full historyTSV
Dimension Koulutusaste (Koulutusaste)
Dim koulutusaste, Statfinpas ksp pxt 003 201700 fi px, LatestTSV
Dimension Koulutusaste (Koulutusaste)
Dim sukupuoli, Statfinpas ksp pxt 003 201700 fi px, Full historyTSV
Dimension Sukupuoli (Sukupuoli)
Dim sukupuoli, Statfinpas ksp pxt 003 201700 fi px, LatestTSV
Dimension Sukupuoli (Sukupuoli)
Dim tiedot, Statfinpas ksp pxt 003 201700 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas ksp pxt 003 201700 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Fact, Statfinpas ksp pxt 003 201700 fi px, Full historyTSV
Kuntasektorin kuukausipalkat koulutusluokituksen mukaan vuonna 2017 muuttujina Koulutusaste, Koulutusala, Sukupuoli ja Tiedot
Fact, Statfinpas ksp pxt 003 201700 fi px, LatestTSV
Kuntasektorin kuukausipalkat koulutusluokituksen mukaan vuonna 2017 muuttujina Koulutusaste, Koulutusala, Sukupuoli ja Tiedot

Column Descriptions

Dim sukupuoli, Statfinpas ksp pxt 003 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 Mies and maximum string is Nainen.
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 koulutusaste, Statfinpas ksp pxt 003 201700 fi px, Latest

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

Dim koulutusaste, Statfinpas ksp pxt 003 201700 fi px, Full history

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

Dim tiedot, Statfinpas ksp pxt 003 201700 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.

Fact, Statfinpas ksp pxt 003 201700 fi px, Full history

Column	Type	Comment
koulutusaste	string	Datasource did not contain a description for Koulutusaste. Column koulutusaste has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2 Ylempi perusaste and maximum string is 8 Tutkijakoulutusaste.
koulutusala	string	Datasource did not contain a description for Koulutusala. Column koulutusala has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Mies and maximum string is Nainen.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 33936 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_koulutusluokituksen_mukaan_vuonna_2017	int	Datasource did not contain a description for Kuntasektorin_kuukausipalkat_koulutusluokituksen_mukaan_vuonna_2017. Column kuntasektorin_kuukausipalkat_koulutusluokituksen_mukaan_vuonna_2017 has 33936 rows, out of which 18050 are empty, making the null percent 53.19. Minimum value is 1 and maximum value is 410482.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas ksp pxt 003 201700 fi px, Latest

Column	Type	Comment
koulutusaste	string	Datasource did not contain a description for Koulutusaste. Column koulutusaste has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2 Ylempi perusaste and maximum string is 8 Tutkijakoulutusaste.
koulutusala	string	Datasource did not contain a description for Koulutusala. Column koulutusala has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 33936 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Mies and maximum string is Nainen.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 33936 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_koulutusluokituksen_mukaan_vuonna_2017	int	Datasource did not contain a description for Kuntasektorin_kuukausipalkat_koulutusluokituksen_mukaan_vuonna_2017. Column kuntasektorin_kuukausipalkat_koulutusluokituksen_mukaan_vuonna_2017 has 33936 rows, out of which 18050 are empty, making the null percent 53.19. Minimum value is 1 and maximum value is 410482.

Dim sukupuoli, Statfinpas ksp pxt 003 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 Mies and maximum string is Nainen.
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 koulutusala, Statfinpas ksp pxt 003 201700 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...
label	string	The label for the dimension value. Column label has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas ksp pxt 003 201700 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 koulutusala, Statfinpas ksp pxt 003 201700 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...
label	string	The label for the dimension value. Column label has 101 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0011 Yleissivistävä koulu... and first 25 characters of maximum string: 9999 Muut tai tuntemattom...

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019