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

001 -- Rakentamisen liikevaihtokuvaajat 2010=100 (TOL 2008)

001 -- Rakentamisen liikevaihtokuvaajat 2010=100 (TOL 2008)

Tables

Column Descriptions

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

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 13984 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 13984 rows, out of which 5152 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 13984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2309 and maximum value is 2312.
muuttuja string Datasource did not contain a description for Muuttuja. Column muuttuja has 13984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
sarja string Datasource did not contain a description for Sarja. Column sarja has 13984 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.
rakentamisen_liikevaihtokuvaajat_2010100_tol_2008 int Datasource did not contain a description for Rakentamisen_liikevaihtokuvaajat_2010100_TOL_2008. Column rakentamisen_liikevaihtokuvaajat_2010100_tol_2008 has 13984 rows, out of which 152 are empty, making the null percent 1.09. Minimum value is -43 and maximum value is 187.
orig_extractdate string The date when the data was originally fetched from the source.

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

Column Type Comment
code int 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 value is 2309 and maximum value is 2312.
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. First 25 characters of minimum string: 41 Talonrakentaminen... and first 25 characters of maximum string: 43 Erikoistunut rakennust...
orig_extractdate string The date when the data was originally fetched from the source.

Dim ajanjakso, Statfinpas rlv 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.

Fact, Statfinpas rlv pxt 001 201712 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 13984 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 13984 rows, out of which 5152 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 13984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2309 and maximum value is 2312.
muuttuja string Datasource did not contain a description for Muuttuja. Column muuttuja has 13984 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
sarja string Datasource did not contain a description for Sarja. Column sarja has 13984 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.
rakentamisen_liikevaihtokuvaajat_2010100_tol_2008 int Datasource did not contain a description for Rakentamisen_liikevaihtokuvaajat_2010100_TOL_2008. Column rakentamisen_liikevaihtokuvaajat_2010100_tol_2008 has 13984 rows, out of which 152 are empty, making the null percent 1.09. Minimum value is -43 and maximum value is 187.

Dim sarja, Statfinpas rlv 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.

Dim muuttuja, Statfinpas rlv pxt 001 201712 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Liikevaihto and maximum string is Määräindeksi.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas rlv 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 ajanjakso, Statfinpas rlv 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 vuosi, Statfinpas rlv 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.

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

Column Type Comment
code int 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 value is 2309 and maximum value is 2312.
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. First 25 characters of minimum string: 41 Talonrakentaminen... and first 25 characters of maximum string: 43 Erikoistunut rakennust...

Dim muuttuja, Statfinpas rlv pxt 001 201712 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is lv and maximum string is mi.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Liikevaihto and maximum string is Määräindeksi.

Dim sarja, Statfinpas rlv 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.

Additional Info

Last Updated July 21, 2019
Created July 18, 2019