006 -- Kuntatalous vanhat perusvuodet tehtäväalueittain

Tables

Dim perusvuosi, Statfin jmhi pxt 006 fi px, Full historyTSV
Dimension Perusvuosi (Perusvuosi)
Dim perusvuosi, Statfin jmhi pxt 006 fi px, LatestTSV
Dimension Perusvuosi (Perusvuosi)
Dim tehtavaalue, Statfin jmhi pxt 006 fi px, Full historyTSV
Dimension Tehtavaalue (Tehtäväalue)
Dim tehtavaalue, Statfin jmhi pxt 006 fi px, LatestTSV
Dimension Tehtavaalue (Tehtäväalue)
Dim tiedot, Statfin jmhi pxt 006 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin jmhi pxt 006 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim vuosi, Statfin jmhi pxt 006 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin jmhi pxt 006 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Dim vuosineljannes, Statfin jmhi pxt 006 fi px, Full historyTSV
Dimension Vuosineljannes (Vuosineljännes)
Dim vuosineljannes, Statfin jmhi pxt 006 fi px, LatestTSV
Dimension Vuosineljannes (Vuosineljännes)
Fact, Statfin jmhi pxt 006 fi px, Full historyTSV
Kuntatalous vanhat perusvuodet tehtäväalueittain muuttujina Perusvuosi, Tehtäväalue, Vuosi, Vuosineljännes ja Tiedot
Fact, Statfin jmhi pxt 006 fi px, LatestTSV
Kuntatalous vanhat perusvuodet tehtäväalueittain muuttujina Perusvuosi, Tehtäväalue, Vuosi, Vuosineljännes ja Tiedot

Column Descriptions

Fact, Statfin jmhi pxt 006 fi px, Full history

Column	Type	Comment
perusvuosi	int	Datasource did not contain a description for Perusvuosi. Column perusvuosi has 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1977 and maximum value is 2010.
tehtavaalue	int	Datasource did not contain a description for Tehtavaalue. Column tehtavaalue has 9450 rows, out of which 1350 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 122.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1975 and maximum value is 2019.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 9450 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 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
kuntatalous_vanhat_perusvuodet_tehtavaalueittain	int	Datasource did not contain a description for Kuntatalous_vanhat_perusvuodet_tehtavaalueittain. Column kuntatalous_vanhat_perusvuodet_tehtavaalueittain has 9450 rows, out of which 5164 are empty, making the null percent 54.65. Minimum value is 35 and maximum value is 583.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin jmhi pxt 006 fi px, Latest

Column	Type	Comment
perusvuosi	int	Datasource did not contain a description for Perusvuosi. Column perusvuosi has 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1977 and maximum value is 2010.
tehtavaalue	int	Datasource did not contain a description for Tehtavaalue. Column tehtavaalue has 9450 rows, out of which 1350 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 122.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1975 and maximum value is 2019.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 9450 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 9450 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
kuntatalous_vanhat_perusvuodet_tehtavaalueittain	int	Datasource did not contain a description for Kuntatalous_vanhat_perusvuodet_tehtavaalueittain. Column kuntatalous_vanhat_perusvuodet_tehtavaalueittain has 9450 rows, out of which 5164 are empty, making the null percent 54.65. Minimum value is 35 and maximum value is 583.

Dim perusvuosi, Statfin jmhi pxt 006 fi px, Full history

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

Dim perusvuosi, Statfin jmhi pxt 006 fi px, Latest

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

Dim tehtavaalue, Statfin jmhi pxt 006 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 122.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 Yleishallinto... and first 25 characters of maximum string: SS KUPHI Kuntien peruspal...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tehtavaalue, Statfin jmhi pxt 006 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 0 and maximum value is 122.
label	string	The label for the dimension value. Column label has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 Yleishallinto... and first 25 characters of maximum string: SS KUPHI Kuntien peruspal...

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

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

Dim vuosi, Statfin jmhi pxt 006 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 44 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1975 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 44 rows, out of which 1 are empty, making the null percent 2.27. Minimum value is 1975 and maximum value is 2017.

Dim vuosineljannes, Statfin jmhi pxt 006 fi px, Latest

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

Dim vuosineljannes, Statfin jmhi pxt 006 fi px, Full history

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

Dim tiedot, Statfin jmhi pxt 006 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
label	string	The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Indeksipisteluku.

Dim tiedot, Statfin jmhi pxt 006 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
label	string	The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Indeksipisteluku.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 18, 2019
Created	July 11, 2019