1. Home
  2. Datasets
  3. 002 -- Maatilayritys: ...
To download the data set, please sign up or log in

002 -- Maatilayritys: Veronalaiset tulot, menot, varat ja velat maakunnittain ja kunnittain, vuodet 2004-2017

002 -- Maatilayritys: Veronalaiset tulot, menot, varat ja velat maakunnittain ja kunnittain, vuodet 2004-2017

Tables

Column Descriptions

Dim vuosi, Statfin mmtal 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 2004 and maximum value is 2017.
label int 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. Minimum value is 2004 and maximum value is 2017.

Fact, Statfin mmtal pxt 002 fi px, Latest

Column Type Comment
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 342916 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 342916 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 2017.
kunta17 int Datasource did not contain a description for Kunta17. Column kunta17 has 342916 rows, out of which 22792 are empty, making the null percent 6.65. Minimum value is 5 and maximum value is 992.
maatilayritys_veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain int Datasource did not contain a description for Maatilayritys_Veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain. Column maatilayritys_veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain has 342916 rows, out of which 9028 are empty, making the null percent 2.63. Minimum value is -120253 and maximum value is 754246.

Dim vuosi, Statfin mmtal 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 2004 and maximum value is 2017.
label int 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. Minimum value is 2004 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfin mmtal pxt 002 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 74 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 74 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 kunta17, Statfin mmtal pxt 002 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 331 rows, out of which 22 are empty, making the null percent 6.65. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 331 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Vårdö.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfin mmtal pxt 002 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 74 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 74 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 kunta17, Statfin mmtal pxt 002 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 331 rows, out of which 22 are empty, making the null percent 6.65. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 331 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Vårdö.

Fact, Statfin mmtal pxt 002 fi px, Full history

Column Type Comment
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 342916 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 342916 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 2017.
kunta17 int Datasource did not contain a description for Kunta17. Column kunta17 has 342916 rows, out of which 22792 are empty, making the null percent 6.65. Minimum value is 5 and maximum value is 992.
maatilayritys_veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain int Datasource did not contain a description for Maatilayritys_Veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain. Column maatilayritys_veronalaiset_tulot_menot_varat_ja_velat_maakunnittain_ja_kunnittain has 342916 rows, out of which 9028 are empty, making the null percent 2.63. Minimum value is -120253 and maximum value is 754246.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019