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

005 -- Kokoaikaisten palkansaajien kokonaisansiot toimialan (TOL 2008) mukaan vuonna 2014

005 -- Kokoaikaisten palkansaajien kokonaisansiot toimialan (TOL 2008) mukaan vuonna 2014

Tables

Column Descriptions

Dim toimiala tol 2008, Statfinpas pra pxt 005 201400 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 355 rows, out of which 24 are empty, making the null percent 6.76. Minimum value is 1 and maximum value is 990.
label string The label for the dimension value. Column label has 355 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 011 Yksivuotisten kasv... and first 25 characters of maximum string: ZZZ Toimiala tuntematon...

Fact, Statfinpas pra pxt 005 201400 fi px, Latest

Column Type Comment
toimiala_tol_2008 int Datasource did not contain a description for Toimiala_TOL_2008. Column toimiala_tol_2008 has 25560 rows, out of which 1728 are empty, making the null percent 6.76. Minimum value is 1 and maximum value is 990.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 25560 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 25560 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 25560 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_kokonaisansiot_toimialan_tol_2008_mukaan_vuonna_2014 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_kokonaisansiot_toimialan_TOL_2008_mukaan_vuonna_2014. Column kokoaikaisten_palkansaajien_kokonaisansiot_toimialan_tol_2008_mukaan_vuonna_2014 has 25560 rows, out of which 11835 are empty, making the null percent 46.30. Minimum value is 1 and maximum value is 1378148.

Dim tyonantajasektori, Statfinpas pra pxt 005 201400 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 toimiala tol 2008, Statfinpas pra pxt 005 201400 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 355 rows, out of which 24 are empty, making the null percent 6.76. Minimum value is 1 and maximum value is 990.
label string The label for the dimension value. Column label has 355 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 011 Yksivuotisten kasv... and first 25 characters of maximum string: ZZZ Toimiala tuntematon...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas pra pxt 005 201400 fi px, Full history

Column Type Comment
toimiala_tol_2008 int Datasource did not contain a description for Toimiala_TOL_2008. Column toimiala_tol_2008 has 25560 rows, out of which 1728 are empty, making the null percent 6.76. Minimum value is 1 and maximum value is 990.
tyonantajasektori string Datasource did not contain a description for Tyonantajasektori. Column tyonantajasektori has 25560 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 25560 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 25560 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_kokonaisansiot_toimialan_tol_2008_mukaan_vuonna_2014 int Datasource did not contain a description for Kokoaikaisten_palkansaajien_kokonaisansiot_toimialan_TOL_2008_mukaan_vuonna_2014. Column kokoaikaisten_palkansaajien_kokonaisansiot_toimialan_tol_2008_mukaan_vuonna_2014 has 25560 rows, out of which 11835 are empty, making the null percent 46.30. Minimum value is 1 and maximum value is 1378148.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, Statfinpas pra pxt 005 201400 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 005 201400 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 005 201400 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 sukupuoli, Statfinpas pra pxt 005 201400 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 tiedot, Statfinpas pra pxt 005 201400 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...

Additional Info

Last Updated September 22, 2019
Created August 6, 2019