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

Tables

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

Column Descriptions

Dim tiedot, Statfinpas pra pxt 001 201700 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 tiedot, Statfinpas pra pxt 001 201700 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.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 181 rows, out of which 4 are empty, making the null percent 2.21. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 181 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 XXX Tuntematon.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas pra pxt 001 201700 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 tyonantajasektori, Statfinpas pra pxt 001 201700 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.

Fact, Statfinpas pra pxt 001 201700 fi px, Latest

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 13032 rows, out of which 288 are empty, making the null percent 2.21. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 13032 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 13032 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 13032 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_2017	int	Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2017. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2017 has 13032 rows, out of which 3028 are empty, making the null percent 23.24. Minimum value is 1 and maximum value is 1387525.

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

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

Column	Type	Comment
ammattiluokka	int	Datasource did not contain a description for Ammattiluokka. Column ammattiluokka has 13032 rows, out of which 288 are empty, making the null percent 2.21. Minimum value is 0 and maximum value is 962.
tyonantajasektori	string	Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 13032 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 13032 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 13032 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_2017	int	Datasource did not contain a description for Kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2017. Column kokoaikaisten_palkansaajien_lukumaarat_ja_kokonaisansiot_kuukaudessa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_sukupuolen_mukaan_vuonna_2017 has 13032 rows, out of which 3028 are empty, making the null percent 23.24. Minimum value is 1 and maximum value is 1387525.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tyonantajasektori, Statfinpas pra pxt 001 201700 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 201700 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 181 rows, out of which 4 are empty, making the null percent 2.21. Minimum value is 0 and maximum value is 962.
label	string	The label for the dimension value. Column label has 181 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 XXX Tuntematon.

Additional Info

Last Updated	September 22, 2019
Created	August 5, 2019