1. Home
  2. Datasets
  3. 003 -- Palkansaajien ...
To download the data set, please sign up or log in

003 -- Palkansaajien kokonaisansiot tunnissa ammattiluokituksen (AML 2010), työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2017

003 -- Palkansaajien kokonaisansiot tunnissa ammattiluokituksen (AML 2010), työnantajasektorin ja kokoaikaisuuden mukaan vuonna 2017

Tables

Column Descriptions

Dim ammattiluokka, Statfinpas pra pxt 003 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.

Dim osaaikaisuus, Statfinpas pra pxt 003 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 Kokoaikainen and maximum string is Osa-aikainen.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas pra pxt 003 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.
osaaikaisuus string Datasource did not contain a description for Osaaikaisuus. Column osaaikaisuus 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.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017 int Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017 has 13032 rows, out of which 3054 are empty, making the null percent 23.43. Minimum value is 1 and maximum value is 1668218.

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

Fact, Statfinpas pra pxt 003 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.
osaaikaisuus string Datasource did not contain a description for Osaaikaisuus. Column osaaikaisuus 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.
palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017 int Datasource did not contain a description for Palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_AML_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017. Column palkansaajien_kokonaisansiot_tunnissa_ammattiluokituksen_aml_2010_tyonantajasektorin_ja_kokoaikaisuuden_mukaan_vuonna_2017 has 13032 rows, out of which 3054 are empty, making the null percent 23.43. Minimum value is 1 and maximum value is 1668218.
orig_extractdate string The date when the data was originally fetched from the source.

Dim osaaikaisuus, Statfinpas pra pxt 003 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 Kokoaikainen and maximum string is Osa-aikainen.

Dim tyonantajasektori, Statfinpas pra pxt 003 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.

Dim ammattiluokka, Statfinpas pra pxt 003 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 tyonantajasektori, Statfinpas pra pxt 003 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 tiedot, Statfinpas pra pxt 003 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.

Additional Info

Last Updated September 22, 2019
Created August 5, 2019