901 -- Myönnetyt rakennusluvat 1990-2014

Tables

Dim kuukausi, Statfinpas ras pxt 901 201412 fi px, Full historyTSV
Dimension Kuukausi (Kuukausi)
Dim kuukausi, Statfinpas ras pxt 901 201412 fi px, LatestTSV
Dimension Kuukausi (Kuukausi)
Dim lupatiedot, Statfinpas ras pxt 901 201412 fi px, Full historyTSV
Dimension Lupatiedot (Lupatiedot)
Dim lupatiedot, Statfinpas ras pxt 901 201412 fi px, LatestTSV
Dimension Lupatiedot (Lupatiedot)
Dim rakennuksen kayttotarkoitus, Statfinpas ras pxt 901 201412 fi px, Full historyTSV
Dimension Rakennuksen_kayttotarkoitus (Rakennuksen käyttötarkoitus)
Dim rakennuksen kayttotarkoitus, Statfinpas ras pxt 901 201412 fi px, LatestTSV
Dimension Rakennuksen_kayttotarkoitus (Rakennuksen käyttötarkoitus)
Dim vuosi, Statfinpas ras pxt 901 201412 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfinpas ras pxt 901 201412 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfinpas ras pxt 901 201412 fi px, Full historyTSV
Myönnetyt rakennusluvat muuttujina Vuosi, Kuukausi, Rakennuksen käyttötarkoitus ja Lupatiedot
Fact, Statfinpas ras pxt 901 201412 fi px, LatestTSV
Myönnetyt rakennusluvat muuttujina Vuosi, Kuukausi, Rakennuksen käyttötarkoitus ja Lupatiedot

Column Descriptions

Dim vuosi, Statfinpas ras pxt 901 201412 fi px, Full history

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

Dim vuosi, Statfinpas ras pxt 901 201412 fi px, Latest

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

Fact, Statfinpas ras pxt 901 201412 fi px, Full history

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 18900 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2014.
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 18900 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 M12.
rakennuksen_kayttotarkoitus	int	Datasource did not contain a description for Rakennuksen_kayttotarkoitus. Column rakennuksen_kayttotarkoitus has 18900 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 21.
lupatiedot	string	Datasource did not contain a description for Lupatiedot. Column lupatiedot has 18900 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkm and maximum string is Rtilav.
myonnetyt_rakennusluvat	int	Datasource did not contain a description for Myonnetyt_rakennusluvat. Column myonnetyt_rakennusluvat has 18900 rows, out of which 267 are empty, making the null percent 1.41. Minimum value is 0 and maximum value is 7961287.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim rakennuksen kayttotarkoitus, Statfinpas ras pxt 901 201412 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 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 21.
label	string	The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asuinkerrostalot... and first 25 characters of maximum string: Muut kuin asuinrakennukse...

Fact, Statfinpas ras pxt 901 201412 fi px, Latest

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 18900 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2014.
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 18900 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 M12.
rakennuksen_kayttotarkoitus	int	Datasource did not contain a description for Rakennuksen_kayttotarkoitus. Column rakennuksen_kayttotarkoitus has 18900 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 21.
lupatiedot	string	Datasource did not contain a description for Lupatiedot. Column lupatiedot has 18900 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkm and maximum string is Rtilav.
myonnetyt_rakennusluvat	int	Datasource did not contain a description for Myonnetyt_rakennusluvat. Column myonnetyt_rakennusluvat has 18900 rows, out of which 267 are empty, making the null percent 1.41. Minimum value is 0 and maximum value is 7961287.

Dim lupatiedot, Statfinpas ras pxt 901 201412 fi px, Latest

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 Alkm and maximum string is Rtilav.
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 Asunnot (kpl) and maximum string is Tilavuus (m3).

Dim kuukausi, Statfinpas ras pxt 901 201412 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 12 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 M12.
label	string	The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Elokuu and maximum string is Joulukuu.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim rakennuksen kayttotarkoitus, Statfinpas ras pxt 901 201412 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 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 21.
label	string	The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Asuinkerrostalot... and first 25 characters of maximum string: Muut kuin asuinrakennukse...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim lupatiedot, Statfinpas ras pxt 901 201412 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 Alkm and maximum string is Rtilav.
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 Asunnot (kpl) and maximum string is Tilavuus (m3).
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim kuukausi, Statfinpas ras pxt 901 201412 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 12 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 M12.
label	string	The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Elokuu and maximum string is Joulukuu.

Additional Info

Last Updated	July 12, 2019
Created	July 12, 2019