1. Home
  2. Datasets
  3. 008 -- Vanhojen ...
To download the data set, please sign up or log in

008 -- Vanhojen osakeasuntojen neliöhinnat ja kauppojen lukumäärät kunnittain vuodesta 2008 lähtien

008 -- Vanhojen osakeasuntojen neliöhinnat ja kauppojen lukumäärät kunnittain vuodesta 2008 lähtien

Tables

Column Descriptions

Dim tiedot, Statfinpas ashi pxt 008 201600 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 Keskihinta and maximum string is Lkm.
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 Lukumäärä and maximum string is Neliöhinta.

Dim kunta, Statfinpas ashi pxt 008 201600 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.
label string The label for the dimension value. Column label has 334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.

Fact, Statfinpas ashi pxt 008 201600 fi px, Full history

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2016.
kunta string Datasource did not contain a description for Kunta. Column kunta has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.
talotyyppi string Datasource did not contain a description for Talotyyppi. Column talotyyppi has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kerrostalot and maximum string is Yhteensä.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Keskihinta and maximum string is Lkm.
vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien int Datasource did not contain a description for Vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien. Column vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien has 18036 rows, out of which 4007 are empty, making the null percent 22.22. Minimum value is 1 and maximum value is 11956.
orig_extractdate string The date when the data was originally fetched from the source.

Dim kunta, Statfinpas ashi pxt 008 201600 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.
label string The label for the dimension value. Column label has 334 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas ashi pxt 008 201600 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 Keskihinta and maximum string is Lkm.
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 Lukumäärä and maximum string is Neliöhinta.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas ashi pxt 008 201600 fi px, Full history

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

Dim vuosi, Statfinpas ashi pxt 008 201600 fi px, Latest

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

Fact, Statfinpas ashi pxt 008 201600 fi px, Latest

Column Type Comment
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2008 and maximum value is 2016.
kunta string Datasource did not contain a description for Kunta. Column kunta has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 - Alajärvi and maximum string is 421 - Lestijärvi.
talotyyppi string Datasource did not contain a description for Talotyyppi. Column talotyyppi has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kerrostalot and maximum string is Yhteensä.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 18036 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Keskihinta and maximum string is Lkm.
vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien int Datasource did not contain a description for Vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien. Column vanhojen_osakeasuntojen_neliohinnat_ja_kauppojen_lukumaarat_kunnittain_vuodesta_2008_lahtien has 18036 rows, out of which 4007 are empty, making the null percent 22.22. Minimum value is 1 and maximum value is 11956.

Dim talotyyppi, Statfinpas ashi pxt 008 201600 fi px, Full history

Column Type Comment
code string 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 string is Kerrostalot and maximum string is Yhteensä.
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 Kerrostalot and maximum string is Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 22, 2019
Created August 5, 2019