002 -- Kuntatalous 2015=100 menolajeittain

Tables

Dim menolaji, Statfin jmhi pxt 002 fi px, Full historyTSV
Dimension Menolaji (Menolaji)
Dim menolaji, Statfin jmhi pxt 002 fi px, LatestTSV
Dimension Menolaji (Menolaji)
Dim nelj, Statfin jmhi pxt 002 fi px, Full historyTSV
Dimension Nelj (Nelj)
Dim nelj, Statfin jmhi pxt 002 fi px, LatestTSV
Dimension Nelj (Nelj)
Dim tiedot, Statfin jmhi pxt 002 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin jmhi pxt 002 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tilasto, Statfin jmhi pxt 002 fi px, Full historyTSV
Dimension Tilasto (Tilasto)
Dim tilasto, Statfin jmhi pxt 002 fi px, LatestTSV
Dimension Tilasto (Tilasto)
Dim vuosi, Statfin jmhi pxt 002 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin jmhi pxt 002 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfin jmhi pxt 002 fi px, Full historyTSV
Kuntatalous 2015=100 menolajeittain muuttujina Tilasto, Menolaji, Vuosi, Nelj ja Tiedot
Fact, Statfin jmhi pxt 002 fi px, LatestTSV
Kuntatalous 2015=100 menolajeittain muuttujina Tilasto, Menolaji, Vuosi, Nelj ja Tiedot

Column Descriptions

Dim tilasto, Statfin jmhi pxt 002 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 JMHI2015_KUNNAT and maximum string is JMHI2015_KUNTATALOUS.
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 Kuntatalous.

Fact, Statfin jmhi pxt 002 fi px, Full history

Column	Type	Comment
tilasto	string	Datasource did not contain a description for Tilasto. Column tilasto has 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is JMHI2015_KUNNAT and maximum string is JMHI2015_KUNTATALOUS.
menolaji	int	Datasource did not contain a description for Menolaji. Column menolaji has 3150 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 141.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2019.
nelj	string	Datasource did not contain a description for Nelj. Column nelj has 3150 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 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Neljannesmuutos and maximum string is Vuosimuutos.
kuntatalous_2015100_menolajeittain	int	Datasource did not contain a description for Kuntatalous_2015100_menolajeittain. Column kuntatalous_2015100_menolajeittain has 3150 rows, out of which 924 are empty, making the null percent 29.33. Minimum value is -40 and maximum value is 113.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin jmhi pxt 002 fi px, Latest

Column	Type	Comment
tilasto	string	Datasource did not contain a description for Tilasto. Column tilasto has 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is JMHI2015_KUNNAT and maximum string is JMHI2015_KUNTATALOUS.
menolaji	int	Datasource did not contain a description for Menolaji. Column menolaji has 3150 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 141.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2019.
nelj	string	Datasource did not contain a description for Nelj. Column nelj has 3150 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 3150 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Neljannesmuutos and maximum string is Vuosimuutos.
kuntatalous_2015100_menolajeittain	int	Datasource did not contain a description for Kuntatalous_2015100_menolajeittain. Column kuntatalous_2015100_menolajeittain has 3150 rows, out of which 924 are empty, making the null percent 29.33. Minimum value is -40 and maximum value is 113.

Dim vuosi, Statfin jmhi pxt 002 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 2015 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 2015 and maximum value is 2017.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfin jmhi pxt 002 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 2015 and maximum value is 2018.
label	int	The label for the dimension value. Column label has 4 rows, out of which 1 are empty, making the null percent 25.00. Minimum value is 2015 and maximum value is 2017.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 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 141.
label	string	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1.1.1. Palkat ja palkkiot... 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 menolaji, Statfin jmhi pxt 002 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 14 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 141.
label	string	The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1.1.1. Palkat ja palkkiot... and first 25 characters of maximum string: SSS Yhteensä, ml. liikela...

Dim nelj, Statfin jmhi pxt 002 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 tilasto, Statfin jmhi pxt 002 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 JMHI2015_KUNNAT and maximum string is JMHI2015_KUNTATALOUS.
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 Kuntatalous.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, Statfin jmhi pxt 002 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 Neljannesmuutos and maximum string is Vuosimuutos.
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 Indeksipisteluku and maximum string is Vuosimuutos, %.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim nelj, Statfin jmhi pxt 002 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 tiedot, Statfin jmhi pxt 002 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 Neljannesmuutos and maximum string is Vuosimuutos.
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 Indeksipisteluku and maximum string is Vuosimuutos, %.

Additional Info

Last Updated	July 21, 2019
Created	July 19, 2019