002 -- Distributions of prices per square meter of existing dwellings since 2010

Tables

Dim quarter, Statfinpas ashi pxt 002 2017q4 px, Full historyTSV
Dimension Quarter (Vuosineljännes)
Dim quarter, Statfinpas ashi pxt 002 2017q4 px, LatestTSV
Dimension Quarter (Vuosineljännes)
Dim region, Statfinpas ashi pxt 002 2017q4 px, Full historyTSV
Dimension Region (Alue)
Dim region, Statfinpas ashi pxt 002 2017q4 px, LatestTSV
Dimension Region (Alue)
Fact, Statfinpas ashi pxt 002 2017q4 px, Full historyTSV
Distributions of prices per square meter of existing dwellings since 2010 by Quarter, Region, Building type, Number of rooms and Information
Fact, Statfinpas ashi pxt 002 2017q4 px, LatestTSV
Distributions of prices per square meter of existing dwellings since 2010 by Quarter, Region, Building type, Number of rooms and Information

Column Descriptions

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

Column	Type	Comment
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 13056 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
region	int	In the regional division a geographical area is divided into smaller areas. Statistical regional divisions are such as divisions into municipalities and regions. . Column region has 13056 rows, out of which 3840 are empty, making the null percent 29.41. Minimum value is 49 and maximum value is 853.
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 13056 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 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 13056 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 13056 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Med and maximum string is Q3.
distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010	int	Datasource did not contain a description for Distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010. Column distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010 has 13056 rows, out of which 5094 are empty, making the null percent 39.02. Minimum value is 621 and maximum value is 8813.
orig_extractdate	string	The date when the data was originally fetched from the source.

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

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

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

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

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 17 rows, out of which 5 are empty, making the null percent 29.41. Minimum value is 49 and maximum value is 853.
label	string	The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo-Kauniainen and maximum string is Oulu.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas ashi pxt 002 2017q4 px, Latest

Column	Type	Comment
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 13056 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 2010Q1 and maximum string is 2017Q4.
region	int	In the regional division a geographical area is divided into smaller areas. Statistical regional divisions are such as divisions into municipalities and regions. . Column region has 13056 rows, out of which 3840 are empty, making the null percent 29.41. Minimum value is 49 and maximum value is 853.
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 13056 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 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 13056 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 13056 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Med and maximum string is Q3.
distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010	int	Datasource did not contain a description for Distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010. Column distributions_of_prices_per_square_meter_of_existing_dwellings_since_2010 has 13056 rows, out of which 5094 are empty, making the null percent 39.02. Minimum value is 621 and maximum value is 8813.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 17 rows, out of which 5 are empty, making the null percent 29.41. Minimum value is 49 and maximum value is 853.
label	string	The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo-Kauniainen and maximum string is Oulu.

Additional Info

Last Updated	July 21, 2019
Created	July 14, 2019