918 -- Teema 2007: Velkapaneeli, maatilayrityskohtaiset (MVL) tiedot tuotantosuunnittain 2004-2007

Tables

Dim tiedot, Statfinpas mmtal pxt 918 200700 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfinpas mmtal pxt 918 200700 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tuotantosuunta, Statfinpas mmtal pxt 918 200700 fi px, Full historyTSV
Dimension tuotantosuunta (tuotantosuunta)
Dim tuotantosuunta, Statfinpas mmtal pxt 918 200700 fi px, LatestTSV
Dimension tuotantosuunta (tuotantosuunta)
Dim velkojen muutos, Statfinpas mmtal pxt 918 200700 fi px, Full historyTSV
Dimension Velkojen_muutos (Velkojen muutos)
Dim velkojen muutos, Statfinpas mmtal pxt 918 200700 fi px, LatestTSV
Dimension Velkojen_muutos (Velkojen muutos)
Dim vuosi, Statfinpas mmtal pxt 918 200700 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfinpas mmtal pxt 918 200700 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfinpas mmtal pxt 918 200700 fi px, Full historyTSV
Teema: Velkapaneeli, maatilayrityskohtaiset (MVL) tiedot tuotantosuunnittain muuttujina Tiedot, Vuosi, tuotantosuunta ja Velkojen muutos
Fact, Statfinpas mmtal pxt 918 200700 fi px, LatestTSV
Teema: Velkapaneeli, maatilayrityskohtaiset (MVL) tiedot tuotantosuunnittain muuttujina Tiedot, Vuosi, tuotantosuunta ja Velkojen muutos

Column Descriptions

Dim tuotantosuunta, Statfinpas mmtal pxt 918 200700 fi px, Full history

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

Dim velkojen muutos, Statfinpas mmtal pxt 918 200700 fi px, Full history

Column	Type	Comment
code	float	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1.20 and maximum value is 1.20.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Velat alentuneet yli 20 %... and first 25 characters of maximum string: Velat lisääntyneet yli 20...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas mmtal pxt 918 200700 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 2004 and maximum value is 2007.
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 2004 and maximum value is 2007.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas mmtal pxt 918 200700 fi px, Full history

Column	Type	Comment
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 7848 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 7848 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 2007.
tuotantosuunta	int	Datasource did not contain a description for tuotantosuunta. Column tuotantosuunta has 7848 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.
velkojen_muutos	float	Datasource did not contain a description for Velkojen_muutos. Column velkojen_muutos has 7848 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1.20 and maximum value is 1.20.
teema_velkapaneeli_maatilayrityskohtaiset_mvl_tiedot_tuotantosuunnittain	int	Datasource did not contain a description for Teema_Velkapaneeli_maatilayrityskohtaiset_MVL_tiedot_tuotantosuunnittain. Column teema_velkapaneeli_maatilayrityskohtaiset_mvl_tiedot_tuotantosuunnittain has 7848 rows, out of which 2741 are empty, making the null percent 34.93. Minimum value is -1667 and maximum value is 630266.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas mmtal pxt 918 200700 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 2004 and maximum value is 2007.
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 2004 and maximum value is 2007.

Dim tiedot, Statfinpas mmtal pxt 918 200700 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...

Fact, Statfinpas mmtal pxt 918 200700 fi px, Latest

Column	Type	Comment
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 7848 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 7848 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 2007.
tuotantosuunta	int	Datasource did not contain a description for tuotantosuunta. Column tuotantosuunta has 7848 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.
velkojen_muutos	float	Datasource did not contain a description for Velkojen_muutos. Column velkojen_muutos has 7848 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1.20 and maximum value is 1.20.
teema_velkapaneeli_maatilayrityskohtaiset_mvl_tiedot_tuotantosuunnittain	int	Datasource did not contain a description for Teema_Velkapaneeli_maatilayrityskohtaiset_MVL_tiedot_tuotantosuunnittain. Column teema_velkapaneeli_maatilayrityskohtaiset_mvl_tiedot_tuotantosuunnittain has 7848 rows, out of which 2741 are empty, making the null percent 34.93. Minimum value is -1667 and maximum value is 630266.

Dim tiedot, Statfinpas mmtal pxt 918 200700 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 velkojen muutos, Statfinpas mmtal pxt 918 200700 fi px, Latest

Column	Type	Comment
code	float	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -1.20 and maximum value is 1.20.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Velat alentuneet yli 20 %... and first 25 characters of maximum string: Velat lisääntyneet yli 20...

Dim tuotantosuunta, Statfinpas mmtal pxt 918 200700 fi px, Latest

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

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019