001 -- Kokoaikaisten palkansaajien lukumäärät ja kokonaisansiot kuukaudessa ammattiluokituksen (AML 2010), työnantajasektorin ja sukupuolen mukaan vuonna 2011

Tables

Dim ammattiluokka, Statfinpas pra pxt 001 201100 fi px, Full historyTSV
Dimension Ammattiluokka (Ammattiluokka)
Dim ammattiluokka, Statfinpas pra pxt 001 201100 fi px, LatestTSV
Dimension Ammattiluokka (Ammattiluokka)
Dim sukupuoli, Statfinpas pra pxt 001 201100 fi px, Full historyTSV
Dimension Sukupuoli (Sukupuoli)
Dim sukupuoli, Statfinpas pra pxt 001 201100 fi px, LatestTSV
Dimension Sukupuoli (Sukupuoli)
Dim tiedot, Statfinpas pra pxt 001 201100 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas pra pxt 001 201100 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tyonantajasektori, Statfinpas pra pxt 001 201100 fi px, Full historyTSV
Dimension Tyonantajasektori (Työnantajasektori)
Dim tyonantajasektori, Statfinpas pra pxt 001 201100 fi px, LatestTSV
Dimension Tyonantajasektori (Työnantajasektori)
Fact, Statfinpas pra pxt 001 201100 fi px, Full historyTSV
Kokoaikaisten palkansaajien lukumäärät ja kokonaisansiot kuukaudessa ammattiluokituksen (AML 2010), työnantajasektorin ja sukupuolen mukaan vuonna 2011 muuttujina Ammattiluokka, Työnantajasektori, Sukupuoli ja Tiedot
Fact, Statfinpas pra pxt 001 201100 fi px, LatestTSV
Kokoaikaisten palkansaajien lukumäärät ja kokonaisansiot kuukaudessa ammattiluokituksen (AML 2010), työnantajasektorin ja sukupuolen mukaan vuonna 2011 muuttujina Ammattiluokka, Työnantajasektori, Sukupuoli ja Tiedot

Column Descriptions

Dim tiedot, Statfinpas pra pxt 001 201100 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
label	string	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokonaisansion 1.desiili,... 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 pra pxt 001 201100 fi px, Latest

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 12816 rows, out of which 144 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 12816 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 12816 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 12816 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011	int	Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011 has 12816 rows, out of which 1896 are empty, making the null percent 14.79. Minimum value is 1 and maximum value is 1410421.

Dim ammattiluokka, Statfinpas pra pxt 001 201100 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 178 rows, out of which 2 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 178 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 011 Upseerit and maximum string is X Tuntematon.

Dim tyonantajasektori, Statfinpas pra pxt 001 201100 fi px, Full history

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

Dim tiedot, Statfinpas pra pxt 001 201100 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
label	string	The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Kokonaisansion 1.desiili,... and first 25 characters of maximum string: Kokonaisansion variaatiok...

Dim tyonantajasektori, Statfinpas pra pxt 001 201100 fi px, Latest

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

Dim ammattiluokka, Statfinpas pra pxt 001 201100 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 178 rows, out of which 2 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 178 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 011 Upseerit and maximum string is X Tuntematon.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas pra 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.

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

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 12816 rows, out of which 144 are empty, making the null percent 1.12. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 12816 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is K and maximum string is V.
sukupuoli	string	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 12816 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 12816 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kkp_cv and maximum string is Kkp_p90.
kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011	int	Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2011 has 12816 rows, out of which 1896 are empty, making the null percent 14.79. Minimum value is 1 and maximum value is 1410421.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas pra 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.

Additional Info

Last Updated	September 20, 2019
Created	August 4, 2019