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

904 -- Rakentamisen palkkasummakuvaaja 2000=100 (TOL 2002)

904 -- Rakentamisen palkkasummakuvaaja 2000=100 (TOL 2002)

Tables

Column Descriptions

Dim toimiala, Statfinpas ktps pxt 904 200812 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MAA and maximum string is TAL.
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. First 25 characters of minimum string: Maa- ja vesirakentaminen ... and first 25 characters of maximum string: Talonrakentaminen: 45211,...

Dim toimiala, Statfinpas ktps pxt 904 200812 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MAA and maximum string is TAL.
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. First 25 characters of minimum string: Maa- ja vesirakentaminen ... and first 25 characters of maximum string: Talonrakentaminen: 45211,...
orig_extractdate string The date when the data was originally fetched from the source.

Dim kuukausi, Statfinpas ktps pxt 904 200812 fi px, Latest

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

Dim kuukausi, Statfinpas ktps pxt 904 200812 fi px, Full history

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

Dim indeksipisteluku, Statfinpas ktps pxt 904 200812 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 Ad and maximum string is Tre.
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.

Dim indeksipisteluku, Statfinpas ktps pxt 904 200812 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 Ad and maximum string is Tre.
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.

Fact, Statfinpas ktps pxt 904 200812 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 2016 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 2008.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 12.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MAA and maximum string is TAL.
indeksipisteluku string Datasource did not contain a description for Indeksipisteluku. Column indeksipisteluku has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ad and maximum string is Tre.
rakentamisen_palkkasummakuvaaja_2000100_tol_2002 int Datasource did not contain a description for Rakentamisen_palkkasummakuvaaja_2000100_TOL_2002. Column rakentamisen_palkkasummakuvaaja_2000100_tol_2002 has 2016 rows, out of which 36 are empty, making the null percent 1.79. Minimum value is -10 and maximum value is 214.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas ktps pxt 904 200812 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 14 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 2008.
label int The label for the dimension value. Column label has 14 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 2008.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas ktps pxt 904 200812 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 14 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 2008.
label int The label for the dimension value. Column label has 14 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 2008.

Fact, Statfinpas ktps pxt 904 200812 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 2016 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 2008.
kuukausi int Datasource did not contain a description for Kuukausi. Column kuukausi has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 12.
toimiala string Datasource did not contain a description for Toimiala. Column toimiala has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MAA and maximum string is TAL.
indeksipisteluku string Datasource did not contain a description for Indeksipisteluku. Column indeksipisteluku has 2016 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ad and maximum string is Tre.
rakentamisen_palkkasummakuvaaja_2000100_tol_2002 int Datasource did not contain a description for Rakentamisen_palkkasummakuvaaja_2000100_TOL_2002. Column rakentamisen_palkkasummakuvaaja_2000100_tol_2002 has 2016 rows, out of which 36 are empty, making the null percent 1.79. Minimum value is -10 and maximum value is 214.

Additional Info

Last Updated July 20, 2019
Created July 13, 2019