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

Tables

Dim building type, Statfinpas ashi pxt 007 201802 px, Full historyTSV
Dimension Building_type (Talotyyppi)
Dim building type, Statfinpas ashi pxt 007 201802 px, LatestTSV
Dimension Building_type (Talotyyppi)
Dim information, Statfinpas ashi pxt 007 201802 px, Full historyTSV
Dimension Information (Tiedot)
Dim information, Statfinpas ashi pxt 007 201802 px, LatestTSV
Dimension Information (Tiedot)
Dim month, Statfinpas ashi pxt 007 201802 px, Full historyTSV
Dimension Month (Kuukausi)
Dim month, Statfinpas ashi pxt 007 201802 px, LatestTSV
Dimension Month (Kuukausi)
Dim region, Statfinpas ashi pxt 007 201802 px, Full historyTSV
Dimension Region (Alue)
Dim region, Statfinpas ashi pxt 007 201802 px, LatestTSV
Dimension Region (Alue)
Fact, Statfinpas ashi pxt 007 201802 px, Full historyTSV
Price index of old dwellings in housing companies 2010=100 and numbers of transactions, monthly by Month, Information, Building type and Region
Fact, Statfinpas ashi pxt 007 201802 px, LatestTSV
Price index of old dwellings in housing companies 2010=100 and numbers of transactions, monthly by Month, Information, Building type and Region

Column Descriptions

Dim information, Statfinpas ashi pxt 007 201802 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.
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.

Dim region, Statfinpas ashi pxt 007 201802 px, Full history

Column	Type	Comment
code	string	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 string is esp and maximum string is oul.
label	string	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 string is Eastern Finland and maximum string is Oulu.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim region, Statfinpas ashi pxt 007 201802 px, Latest

Column	Type	Comment
code	string	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 string is esp and maximum string is oul.
label	string	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 string is Eastern Finland and maximum string is Oulu.

Fact, Statfinpas ashi pxt 007 201802 px, Latest

Column	Type	Comment
month	string	Datasource did not contain a description for Month. Column month has 32928 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010M01 and maximum string is 2018M02.
information	string	Datasource did not contain a description for Information. Column information has 32928 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.
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 32928 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.
region	string	Datasource did not contain a description for Region. Column region has 32928 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is esp and maximum string is oul.
price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly	int	Datasource did not contain a description for Price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly. Column price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly has 32928 rows, out of which 3850 are empty, making the null percent 11.69. Minimum value is -15 and maximum value is 7902.

Fact, Statfinpas ashi pxt 007 201802 px, Full history

Column	Type	Comment
month	string	Datasource did not contain a description for Month. Column month has 32928 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010M01 and maximum string is 2018M02.
information	string	Datasource did not contain a description for Information. Column information has 32928 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.
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 32928 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.
region	string	Datasource did not contain a description for Region. Column region has 32928 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is esp and maximum string is oul.
price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly	int	Datasource did not contain a description for Price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly. Column price_index_of_old_dwellings_in_housing_companies_2010100_and_numbers_of_transactions_monthly has 32928 rows, out of which 3850 are empty, making the null percent 11.69. Minimum value is -15 and maximum value is 7902.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim month, Statfinpas ashi pxt 007 201802 px, Latest

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

Dim building type, Statfinpas ashi pxt 007 201802 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 building type, Statfinpas ashi pxt 007 201802 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 information, Statfinpas ashi pxt 007 201802 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.
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 month, Statfinpas ashi pxt 007 201802 px, Full history

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

Additional Info

Last Updated	July 21, 2019
Created	July 19, 2019