914 -- Teema 2010: MVL veronalaiset tulot, menot, varat ja velat tuotantosuunnittain tulos-tuki paneelin tiloilla, vv 2004-2010

Tables

Dim tiedot, Statfinpas mmtal pxt 914 201000 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas mmtal pxt 914 201000 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim vuosi, Statfinpas mmtal pxt 914 201000 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfinpas mmtal pxt 914 201000 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfinpas mmtal pxt 914 201000 fi px, Full historyTSV
Teema 2010: MVL aineistosta lasketut tulot, menot, varat ja velat maatalouden tulo-osuuden ja tuotantosuunnan mukaan muuttujina Tiedot, Vuosi, tuotantosuunta ja Maatalouden tulojen osuus kokonaistuloista
Fact, Statfinpas mmtal pxt 914 201000 fi px, LatestTSV
Teema 2010: MVL aineistosta lasketut tulot, menot, varat ja velat maatalouden tulo-osuuden ja tuotantosuunnan mukaan muuttujina Tiedot, Vuosi, tuotantosuunta ja Maatalouden tulojen osuus kokonaistuloista

Column Descriptions

Fact, Statfinpas mmtal pxt 914 201000 fi px, Full history

Column	Type	Comment
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _freq_ and maximum string is M30.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2004 and maximum value is 2010.
tuotantosuunta	int	Datasource did not contain a description for tuotantosuunta. Column tuotantosuunta has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 8.
maatalouden_tulojen_osuus_kokonaistuloista	int	Datasource did not contain a description for Maatalouden_tulojen_osuus_kokonaistuloista. Column maatalouden_tulojen_osuus_kokonaistuloista has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 100.
teema_2010_mvl_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan	int	Datasource did not contain a description for Teema_2010_MVL_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan. Column teema_2010_mvl_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan has 34335 rows, out of which 1109 are empty, making the null percent 3.23. Minimum value is -68161 and maximum value is 402852.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas mmtal pxt 914 201000 fi px, Latest

Column	Type	Comment
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _freq_ and maximum string is M30.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2004 and maximum value is 2010.
tuotantosuunta	int	Datasource did not contain a description for tuotantosuunta. Column tuotantosuunta has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 8.
maatalouden_tulojen_osuus_kokonaistuloista	int	Datasource did not contain a description for Maatalouden_tulojen_osuus_kokonaistuloista. Column maatalouden_tulojen_osuus_kokonaistuloista has 34335 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 100.
teema_2010_mvl_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan	int	Datasource did not contain a description for Teema_2010_MVL_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan. Column teema_2010_mvl_aineistosta_lasketut_tulot_menot_varat_ja_velat_maatalouden_tuloosuuden_ja_tuotantosuunnan_mukaan has 34335 rows, out of which 1109 are empty, making the null percent 3.23. Minimum value is -68161 and maximum value is 402852.

Dim tiedot, Statfinpas mmtal pxt 914 201000 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 109 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _freq_ and maximum string is M30.
label	string	The label for the dimension value. Column label has 109 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 Maatilayritysten lukum... and first 25 characters of maximum string: 46 Metsämaa ha/yritys...

Dim vuosi, Statfinpas mmtal pxt 914 201000 fi px, Full history

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

Dim tiedot, Statfinpas mmtal pxt 914 201000 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 109 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is _freq_ and maximum string is M30.
label	string	The label for the dimension value. Column label has 109 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 Maatilayritysten lukum... and first 25 characters of maximum string: 46 Metsämaa ha/yritys...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas mmtal pxt 914 201000 fi px, Latest

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

Additional Info

Last Updated	July 20, 2019
Created	July 14, 2019