902 -- Kuntatalous 2005=100, menolajeittain

Tables

Dim kuntatyyppi, Statfin jmhi pxt 902 fi px, Full historyTSV
Dimension Kuntatyyppi (Kuntatyyppi)
Dim kuntatyyppi, Statfin jmhi pxt 902 fi px, LatestTSV
Dimension Kuntatyyppi (Kuntatyyppi)
Dim menolaji, Statfin jmhi pxt 902 fi px, Full historyTSV
Dimension Menolaji (Menolaji)
Dim menolaji, Statfin jmhi pxt 902 fi px, LatestTSV
Dimension Menolaji (Menolaji)
Dim vuosi, Statfin jmhi pxt 902 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin jmhi pxt 902 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfin jmhi pxt 902 fi px, Full historyTSV
Kuntatalous 2005=100, menolajeittain muuttujina Kuntatyyppi, Menolaji, Vuosi, Vuosineljännes ja Tiedot
Fact, Statfin jmhi pxt 902 fi px, LatestTSV
Kuntatalous 2005=100, menolajeittain muuttujina Kuntatyyppi, Menolaji, Vuosi, Vuosineljännes ja Tiedot

Column Descriptions

Dim menolaji, Statfin jmhi pxt 902 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 17 rows, out of which 1 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 141.
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. First 25 characters of minimum string: 0. Yhteensä, pl. liikelai... and first 25 characters of maximum string: SSS Yhteensä, ml. liikela...

Dim kuntatyyppi, Statfin jmhi pxt 902 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 Kunnat and maximum string is Kuntayhtymä.
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 Kunnat and maximum string is Kuntayhtymä.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin jmhi pxt 902 fi px, Full history

Column	Type	Comment
kuntatyyppi	string	Datasource did not contain a description for Kuntatyyppi. Column kuntatyyppi has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunnat and maximum string is Kuntayhtymä.
menolaji	int	Datasource did not contain a description for Menolaji. Column menolaji has 9180 rows, out of which 540 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 141.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2016.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is Q1-Q4.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Nelj_muutos and maximum string is Vv_muutos.
kuntatalous_2005100_menolajeittain	int	Datasource did not contain a description for Kuntatalous_2005100_menolajeittain. Column kuntatalous_2005100_menolajeittain has 9180 rows, out of which 1080 are empty, making the null percent 11.76. Minimum value is -44 and maximum value is 156.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim menolaji, Statfin jmhi pxt 902 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 17 rows, out of which 1 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 141.
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. First 25 characters of minimum string: 0. Yhteensä, pl. liikelai... and first 25 characters of maximum string: SSS Yhteensä, ml. liikela...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim kuntatyyppi, Statfin jmhi pxt 902 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 Kunnat and maximum string is Kuntayhtymä.
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 Kunnat and maximum string is Kuntayhtymä.

Fact, Statfin jmhi pxt 902 fi px, Latest

Column	Type	Comment
kuntatyyppi	string	Datasource did not contain a description for Kuntatyyppi. Column kuntatyyppi has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunnat and maximum string is Kuntayhtymä.
menolaji	int	Datasource did not contain a description for Menolaji. Column menolaji has 9180 rows, out of which 540 are empty, making the null percent 5.88. Minimum value is 0 and maximum value is 141.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2005 and maximum value is 2016.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is Q1-Q4.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 9180 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Nelj_muutos and maximum string is Vv_muutos.
kuntatalous_2005100_menolajeittain	int	Datasource did not contain a description for Kuntatalous_2005100_menolajeittain. Column kuntatalous_2005100_menolajeittain has 9180 rows, out of which 1080 are empty, making the null percent 11.76. Minimum value is -44 and maximum value is 156.

Dim vuosi, Statfin jmhi pxt 902 fi px, Full history

Column	Type	Comment
code	int	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 value is 2005 and maximum value is 2016.
label	int	The label for the dimension value. Column label has 12 rows, out of which 1 are empty, making the null percent 8.33. Minimum value is 2005 and maximum value is 2015.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfin jmhi pxt 902 fi px, Latest

Column	Type	Comment
code	int	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 value is 2005 and maximum value is 2016.
label	int	The label for the dimension value. Column label has 12 rows, out of which 1 are empty, making the null percent 8.33. Minimum value is 2005 and maximum value is 2015.

Additional Info

Last Updated	July 21, 2019
Created	July 18, 2019