001 -- Preliminary financial statements, municipalities

Dim financial statement item, Statfin kta pxt 001 px, Full historyTSV
Dimension Financial_statement_item (Tilinpäätöserä)
Dim financial statement item, Statfin kta pxt 001 px, LatestTSV
Dimension Financial_statement_item (Tilinpäätöserä)
Dim region, Statfin kta pxt 001 px, Full historyTSV
Dimension Region (Alue)
Dim region, Statfin kta pxt 001 px, LatestTSV
Dimension Region (Alue)
Dim year, Statfin kta pxt 001 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin kta pxt 001 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin kta pxt 001 px, Full historyTSV
Preliminary financial statements, municipalities by Region, Financial statement item and Year
Fact, Statfin kta pxt 001 px, LatestTSV
Preliminary financial statements, municipalities by Region, Financial statement item and Year

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
label	string	The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland.
orig_extractdate	string	The date when the data was originally fetched from the source.

Column	Type	Comment
code	string	The code for the dimension value. Column code has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu...
label	string	The label for the dimension value. Column label has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustments to internal f... and first 25 characters of maximum string: Guarantees for others: Re...
orig_extractdate	string	The date when the data was originally fetched from the source.

Column	Type	Comment
region	int	Datasource did not contain a description for Region. Column region has 16968 rows, out of which 1616 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
financial_statement_item	string	Datasource did not contain a description for Financial_statement_item. Column financial_statement_item has 16968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu...
year	int	Datasource did not contain a description for Year. Column year has 16968 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.
preliminary_financial_statements_municipalities	int	Datasource did not contain a description for Preliminary_financial_statements_municipalities. Column preliminary_financial_statements_municipalities has 16968 rows, out of which 336 are empty, making the null percent 1.98. Minimum value is -29239625 and maximum value is 59009330.

Column	Type	Comment
region	int	Datasource did not contain a description for Region. Column region has 16968 rows, out of which 1616 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
financial_statement_item	string	Datasource did not contain a description for Financial_statement_item. Column financial_statement_item has 16968 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu...
year	int	Datasource did not contain a description for Year. Column year has 16968 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.
preliminary_financial_statements_municipalities	int	Datasource did not contain a description for Preliminary_financial_statements_municipalities. Column preliminary_financial_statements_municipalities has 16968 rows, out of which 336 are empty, making the null percent 1.98. Minimum value is -29239625 and maximum value is 59009330.
orig_extractdate	string	The date when the data was originally fetched from the source.

Column	Type	Comment
code	int	The code for the dimension value. Column code has 21 rows, out of which 2 are empty, making the null percent 9.52. Minimum value is 1 and maximum value is 21.
label	string	The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Central Finland and maximum string is Åland.

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 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018.
orig_extractdate	string	The date when the data was originally fetched from the source.

Column	Type	Comment
code	string	The code for the dimension value. Column code has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: aineelliset_hyodykkeet... and first 25 characters of maximum string: jaljella_oleva_paaoma_muu...
label	string	The label for the dimension value. Column label has 202 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Adjustments to internal f... and first 25 characters of maximum string: Guarantees for others: Re...

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 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2015 and maximum value is 2018.

Last Updated	July 20, 2019
Created	July 19, 2019