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

001 -- Palkkasummakuvaajat toimialoittain 2010=100 (TOL 2008)

001 -- Palkkasummakuvaajat toimialoittain 2010=100 (TOL 2008)

Tables

Column Descriptions

Dim ajanjakso, Statfinpas ktps pxt 001 201712 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 19 rows, out of which 7 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. puolivuosi and maximum string is Vuosi.
orig_extractdate string The date when the data was originally fetched from the source.

Dim toimiala, Statfinpas ktps pxt 001 201712 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 111 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1996 and maximum value is 2464.
label string The label for the dimension value. Column label has 111 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: Yksityinen sektori...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas ktps pxt 001 201712 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso int Datasource did not contain a description for Ajanjakso. Column ajanjakso has 194028 rows, out of which 71484 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1996 and maximum value is 2464.
sarja string Datasource did not contain a description for Sarja. Column sarja has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
palkkasummakuvaajat_toimialoittain_2010100_tol_2008 int Datasource did not contain a description for Palkkasummakuvaajat_toimialoittain_2010100_TOL_2008. Column palkkasummakuvaajat_toimialoittain_2010100_tol_2008 has 194028 rows, out of which 2869 are empty, making the null percent 1.48. Minimum value is -45 and maximum value is 336.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sarja, Statfinpas ktps pxt 001 201712 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 Alkuperainen and maximum string is Trendi.
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 Alkuperäinen sarja and maximum string is Trendisarja.

Dim toimiala, Statfinpas ktps pxt 001 201712 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 111 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1996 and maximum value is 2464.
label string The label for the dimension value. Column label has 111 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 07 Metallimalmien louhint... and first 25 characters of maximum string: Yksityinen sektori...

Dim vuosi, Statfinpas ktps pxt 001 201712 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
label int The label for the dimension value. Column label has 23 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.

Dim vuosi, Statfinpas ktps pxt 001 201712 fi px, Full history

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

Fact, Statfinpas ktps pxt 001 201712 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2017.
ajanjakso int Datasource did not contain a description for Ajanjakso. Column ajanjakso has 194028 rows, out of which 71484 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
toimiala int Datasource did not contain a description for Toimiala. Column toimiala has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1996 and maximum value is 2464.
sarja string Datasource did not contain a description for Sarja. Column sarja has 194028 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkuperainen and maximum string is Trendi.
palkkasummakuvaajat_toimialoittain_2010100_tol_2008 int Datasource did not contain a description for Palkkasummakuvaajat_toimialoittain_2010100_TOL_2008. Column palkkasummakuvaajat_toimialoittain_2010100_tol_2008 has 194028 rows, out of which 2869 are empty, making the null percent 1.48. Minimum value is -45 and maximum value is 336.

Dim ajanjakso, Statfinpas ktps pxt 001 201712 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 19 rows, out of which 7 are empty, making the null percent 36.84. Minimum value is 1 and maximum value is 12.
label string The label for the dimension value. Column label has 19 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1. puolivuosi and maximum string is Vuosi.

Dim sarja, Statfinpas ktps pxt 001 201712 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 Alkuperainen and maximum string is Trendi.
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 Alkuperäinen sarja and maximum string is Trendisarja.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created June 12, 2019