908 -- Valtiontalous, vanhat indeksit hallinnonaloittain

Tables

Dim hallinnonala, Statfin jmhi pxt 908 fi px, Full historyTSV
Dimension Hallinnonala (Hallinnonala)
Dim hallinnonala, Statfin jmhi pxt 908 fi px, LatestTSV
Dimension Hallinnonala (Hallinnonala)
Dim perusvuosi, Statfin jmhi pxt 908 fi px, Full historyTSV
Dimension Perusvuosi (Perusvuosi)
Dim perusvuosi, Statfin jmhi pxt 908 fi px, LatestTSV
Dimension Perusvuosi (Perusvuosi)
Dim tiedot, Statfin jmhi pxt 908 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin jmhi pxt 908 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim vuosi, Statfin jmhi pxt 908 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin jmhi pxt 908 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Dim vuosineljannes, Statfin jmhi pxt 908 fi px, Full historyTSV
Dimension Vuosineljannes (Vuosineljännes)
Dim vuosineljannes, Statfin jmhi pxt 908 fi px, LatestTSV
Dimension Vuosineljannes (Vuosineljännes)
Fact, Statfin jmhi pxt 908 fi px, Full historyTSV
Valtiontalous, vanhat indeksit hallinnonaloittain muuttujina Hallinnonala, Perusvuosi, Vuosi, Vuosineljännes ja Tiedot
Fact, Statfin jmhi pxt 908 fi px, LatestTSV
Valtiontalous, vanhat indeksit hallinnonaloittain muuttujina Hallinnonala, Perusvuosi, Vuosi, Vuosineljännes ja Tiedot

Column Descriptions

Dim tiedot, Statfin jmhi pxt 908 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: Pisteluku.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosineljannes, Statfin jmhi pxt 908 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 908 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: Pisteluku.

Dim hallinnonala, Statfin jmhi pxt 908 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label	string	The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Yleinen hallinto... and first 25 characters of maximum string: SSS Valtiontalous yhteens...

Dim vuosineljannes, Statfin jmhi pxt 908 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 vuosi, Statfin jmhi pxt 908 fi px, Latest

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

Fact, Statfin jmhi pxt 908 fi px, Full history

Column	Type	Comment
hallinnonala	int	Datasource did not contain a description for Hallinnonala. Column hallinnonala has 10920 rows, out of which 840 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
perusvuosi	int	Datasource did not contain a description for Perusvuosi. Column perusvuosi has 10920 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 2000.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 10920 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 2016.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 10920 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 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
valtiontalous_vanhat_indeksit_hallinnonaloittain	int	Datasource did not contain a description for Valtiontalous_vanhat_indeksit_hallinnonaloittain. Column valtiontalous_vanhat_indeksit_hallinnonaloittain has 10920 rows, out of which 4765 are empty, making the null percent 43.64. Minimum value is 36 and maximum value is 547.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim perusvuosi, Statfin jmhi pxt 908 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 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 2000.
label	int	The label for the dimension value. Column label has 4 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 2000.

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

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

Dim hallinnonala, Statfin jmhi pxt 908 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 1 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
label	string	The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01 Yleinen hallinto... and first 25 characters of maximum string: SSS Valtiontalous yhteens...
orig_extractdate	string	The date when the data was originally fetched from the source.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 4 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 2000.
label	int	The label for the dimension value. Column label has 4 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 2000.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin jmhi pxt 908 fi px, Latest

Column	Type	Comment
hallinnonala	int	Datasource did not contain a description for Hallinnonala. Column hallinnonala has 10920 rows, out of which 840 are empty, making the null percent 7.69. Minimum value is 1 and maximum value is 12.
perusvuosi	int	Datasource did not contain a description for Perusvuosi. Column perusvuosi has 10920 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 2000.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 10920 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 2016.
vuosineljannes	string	Datasource did not contain a description for Vuosineljannes. Column vuosineljannes has 10920 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 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pojo.
valtiontalous_vanhat_indeksit_hallinnonaloittain	int	Datasource did not contain a description for Valtiontalous_vanhat_indeksit_hallinnonaloittain. Column valtiontalous_vanhat_indeksit_hallinnonaloittain has 10920 rows, out of which 4765 are empty, making the null percent 43.64. Minimum value is 36 and maximum value is 547.

Additional Info

Last Updated	August 4, 2019
Created	August 2, 2019