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

001 -- Price index of old dwellings in housing companies 2010=100 and numbers of transactions, quarterly

001 -- Price index of old dwellings in housing companies 2010=100 and numbers of transactions, quarterly

Tables

Column Descriptions

Dim region, Statfinpas ashi pxt 001 2017q4 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 82 rows, out of which 59 are empty, making the null percent 71.95. Minimum value is 49 and maximum value is 905.
label string The label for the dimension value. Column label has 82 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Rovaniemi.

Dim year, Statfinpas ashi pxt 001 2017q4 px, Latest

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

Dim quarter, Statfinpas ashi pxt 001 2017q4 px, Latest

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

Dim region, Statfinpas ashi pxt 001 2017q4 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 82 rows, out of which 59 are empty, making the null percent 71.95. Minimum value is 49 and maximum value is 905.
label string The label for the dimension value. Column label has 82 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Rovaniemi.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas ashi pxt 001 2017q4 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
region string Datasource did not contain a description for Region. Column region has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 and maximum string is 698.
quarter int Datasource did not contain a description for Quarter. Column quarter has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
building_type int A classification for different types of dwellings. For example, blocks of flats, attached houses, detached houses. The dwelling price statistics utilise the categories blocks of flats and attached houses. The data on attached houses also include detached houses with shares in a housing corporation. . Column building_type has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3.
number_of_rooms int The number of rooms is the number of rooms in a dwelling. Kitchen is not counted as a room. Dwellings with at least three rooms belong to the category 3h+. . Column number_of_rooms has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3.
information string Datasource did not contain a description for Information. Column information has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Indeksi and maximum string is Lkm_julk.
price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly int Datasource did not contain a description for Price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly. Column price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly has 314880 rows, out of which 182479 are empty, making the null percent 57.95. Minimum value is -48 and maximum value is 71645.

Dim year, Statfinpas ashi pxt 001 2017q4 px, Full history

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

Dim building type, Statfinpas ashi pxt 001 2017q4 px, Full history

Column Type Comment
code int 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 value is 0 and maximum value is 3.
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 Blocks of flats and maximum string is Terraced houses.
orig_extractdate string The date when the data was originally fetched from the source.

Dim number of rooms, Statfinpas ashi pxt 001 2017q4 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 0 and maximum value is 3.
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 One-room flat and maximum string is Three-room flat+.
orig_extractdate string The date when the data was originally fetched from the source.

Dim number of rooms, Statfinpas ashi pxt 001 2017q4 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 0 and maximum value is 3.
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 One-room flat and maximum string is Three-room flat+.

Dim quarter, Statfinpas ashi pxt 001 2017q4 px, Full history

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

Dim building type, Statfinpas ashi pxt 001 2017q4 px, Latest

Column Type Comment
code int 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 value is 0 and maximum value is 3.
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 Blocks of flats and maximum string is Terraced houses.

Dim information, Statfinpas ashi pxt 001 2017q4 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Indeksi and maximum string is Lkm_julk.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Annual change (index 2010... and first 25 characters of maximum string: Number...

Dim information, Statfinpas ashi pxt 001 2017q4 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Indeksi and maximum string is Lkm_julk.
label string The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Annual change (index 2010... and first 25 characters of maximum string: Number...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas ashi pxt 001 2017q4 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2017.
region string Datasource did not contain a description for Region. Column region has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 049 and maximum string is 698.
quarter int Datasource did not contain a description for Quarter. Column quarter has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
building_type int A classification for different types of dwellings. For example, blocks of flats, attached houses, detached houses. The dwelling price statistics utilise the categories blocks of flats and attached houses. The data on attached houses also include detached houses with shares in a housing corporation. . Column building_type has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3.
number_of_rooms int The number of rooms is the number of rooms in a dwelling. Kitchen is not counted as a room. Dwellings with at least three rooms belong to the category 3h+. . Column number_of_rooms has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3.
information string Datasource did not contain a description for Information. Column information has 314880 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Indeksi and maximum string is Lkm_julk.
price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly int Datasource did not contain a description for Price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly. Column price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_quarterly has 314880 rows, out of which 182479 are empty, making the null percent 57.95. Minimum value is -48 and maximum value is 71645.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019