Business loans by sector and industry of borrower (TOL 2008) by quarter since 2009

Tables

Dim year, T130 lkan tau 130 en px, Full historyTSV
Dimension Year (Year)
Dim year, T130 lkan tau 130 en px, LatestTSV
Dimension Year (Year)
Fact, T130 lkan tau 130 en px, Full historyTSV
Business loans by sector and industry of borrower (TOL2008) by quarter since 2009 by Year, Quarter, Lender sector, Borrower industry (TOL2008) and Variables
Fact, T130 lkan tau 130 en px, LatestTSV
Business loans by sector and industry of borrower (TOL2008) by quarter since 2009 by Year, Quarter, Lender sector, Borrower industry (TOL2008) and Variables

Column Descriptions

Fact, T130 lkan tau 130 en px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2012.
quarter	int	Datasource did not contain a description for Quarter. Column quarter has 141856 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 4.
lender_sector	string	Datasource did not contain a description for Lender_sector. Column lender_sector has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S13149.
borrower_industry_tol2008	string	Datasource did not contain a description for Borrower_industry_TOL2008. Column borrower_industry_tol2008 has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is S.
variables	string	Datasource did not contain a description for Variables. Column variables has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Antol_kanta and maximum string is Yhteensa_kanta.
business_loans_by_sector_and_industry_of_borrower_tol2008_by_quarter_since_2009	int	Datasource did not contain a description for Business_loans_by_sector_and_industry_of_borrower_TOL2008_by_quarter_since_2009. Column business_loans_by_sector_and_industry_of_borrower_tol2008_by_quarter_since_2009 has 141856 rows, out of which 6882 are empty, making the null percent 4.85. Minimum value is 0 and maximum value is 79146.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, T130 lkan tau 130 en px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2012.
quarter	int	Datasource did not contain a description for Quarter. Column quarter has 141856 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 4.
lender_sector	string	Datasource did not contain a description for Lender_sector. Column lender_sector has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is S1 and maximum string is S13149.
borrower_industry_tol2008	string	Datasource did not contain a description for Borrower_industry_TOL2008. Column borrower_industry_tol2008 has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is S.
variables	string	Datasource did not contain a description for Variables. Column variables has 141856 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Antol_kanta and maximum string is Yhteensa_kanta.
business_loans_by_sector_and_industry_of_borrower_tol2008_by_quarter_since_2009	int	Datasource did not contain a description for Business_loans_by_sector_and_industry_of_borrower_TOL2008_by_quarter_since_2009. Column business_loans_by_sector_and_industry_of_borrower_tol2008_by_quarter_since_2009 has 141856 rows, out of which 6882 are empty, making the null percent 4.85. Minimum value is 0 and maximum value is 79146.

Dim year, T130 lkan tau 130 en 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 2009 and maximum value is 2012.
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 2009 and maximum value is 2012.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim year, T130 lkan tau 130 en 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 2009 and maximum value is 2012.
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 2009 and maximum value is 2012.

Additional Info

Last Updated	July 21, 2019
Created	July 17, 2019