1. Home
  2. Datasets
  3. 005 -- Cost index of civil ...
To download the data set, please sign up or log in

005 -- Cost index of civil engineering works 2005=100, Indices by structure

005 -- Cost index of civil engineering works 2005=100, Indices by structure

Tables

Column Descriptions

Dim year, Statfinpas maku pxt 005 201809 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 2005 and maximum value is 2018.
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 2005 and maximum value is 2018.
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfinpas maku pxt 005 201809 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 2005 and maximum value is 2018.
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 2005 and maximum value is 2018.

Dim month, Statfinpas maku pxt 005 201809 px, Full history

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

Dim data, Statfinpas maku pxt 005 201809 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pisteluku.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Point figure.
orig_extractdate string The date when the data was originally fetched from the source.

Dim type, Statfinpas maku pxt 005 201809 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 20.
label string The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11-17 Total index and maximum string is Maintenance.
orig_extractdate string The date when the data was originally fetched from the source.

Dim data, Statfinpas maku pxt 005 201809 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pisteluku.
label string The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Point figure.

Fact, Statfinpas maku pxt 005 201809 px, Full history

Column Type Comment
year int Statistical year is the calendar year a set of statistics concerns. . Column year has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
month string Statistical month is the calendar month a set of statistics concerns. The average index figure for the year, months total, is an arithmetic mean of months index figures. . Column month has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is SSS.
type int Indeces are: foundation structures, earth structures, rock structures, surfacing, municipal engineering systems, concrete structures and other technical systems. Indeces separate from total index are: crushing work, road maintenance, street maintenance and railway maintenance. . Column type has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 20.
data string Datasource did not contain a description for Data. Column data has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pisteluku.
cost_index_of_civil_engineering_works_2005100_indices_by_structure int Datasource did not contain a description for Cost_index_of_civil_engineering_works_2005100_Indices_by_structure. Column cost_index_of_civil_engineering_works_2005100_indices_by_structure has 1820 rows, out of which 40 are empty, making the null percent 2.20. Minimum value is 90 and maximum value is 174.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas maku pxt 005 201809 px, Latest

Column Type Comment
year int Statistical year is the calendar year a set of statistics concerns. . Column year has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2018.
month string Statistical month is the calendar month a set of statistics concerns. The average index figure for the year, months total, is an arithmetic mean of months index figures. . Column month has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is SSS.
type int Indeces are: foundation structures, earth structures, rock structures, surfacing, municipal engineering systems, concrete structures and other technical systems. Indeces separate from total index are: crushing work, road maintenance, street maintenance and railway maintenance. . Column type has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 20.
data string Datasource did not contain a description for Data. Column data has 1820 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pisteluku.
cost_index_of_civil_engineering_works_2005100_indices_by_structure int Datasource did not contain a description for Cost_index_of_civil_engineering_works_2005100_Indices_by_structure. Column cost_index_of_civil_engineering_works_2005100_indices_by_structure has 1820 rows, out of which 40 are empty, making the null percent 2.20. Minimum value is 90 and maximum value is 174.

Dim month, Statfinpas maku pxt 005 201809 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M01 and maximum string is SSS.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Annual average and maximum string is December.

Dim type, Statfinpas maku pxt 005 201809 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 11 and maximum value is 20.
label string The label for the dimension value. Column label has 10 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 11-17 Total index and maximum string is Maintenance.

Additional Info

Last Updated July 14, 2019
Created July 14, 2019