Business loans by sector and industry of borrower (TOL 2002) by quarter in 2001-2008

Tables

Dim lender sector, T040 lkan tau 104 en px, Full historyTSV
Dimension Lender_sector (Lender sector)
Dim lender sector, T040 lkan tau 104 en px, LatestTSV
Dimension Lender_sector (Lender sector)
Dim quarter, T040 lkan tau 104 en px, Full historyTSV
Dimension Quarter (Quarter)
Dim quarter, T040 lkan tau 104 en px, LatestTSV
Dimension Quarter (Quarter)
Dim year, T040 lkan tau 104 en px, Full historyTSV
Dimension Year (Year)
Dim year, T040 lkan tau 104 en px, LatestTSV
Dimension Year (Year)
Fact, T040 lkan tau 104 en px, Full historyTSV
Business loans by sector and industry of borrower (TOL2002) by quarter in 2001-2008 by Year, Quarter, Lender sector, Borrower industry (TOL2002) and Tiedot
Fact, T040 lkan tau 104 en px, LatestTSV
Business loans by sector and industry of borrower (TOL2002) by quarter in 2001-2008 by Year, Quarter, Lender sector, Borrower industry (TOL2002) and Tiedot

Column Descriptions

Fact, T040 lkan tau 104 en px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 400000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 400000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is Q4.
lender_sector	string	Datasource did not contain a description for Lender_sector. Column lender_sector has 400000 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_tol2002	string	Datasource did not contain a description for Borrower_industry_TOL2002. Column borrower_industry_tol2002 has 400000 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 X-O.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 400000 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_tol2002_by_quarter_in_20012008	int	Datasource did not contain a description for Business_loans_by_sector_and_industry_of_borrower_TOL2002_by_quarter_in_20012008. Column business_loans_by_sector_and_industry_of_borrower_tol2002_by_quarter_in_20012008 has 400000 rows, out of which 14320 are empty, making the null percent 3.58. Minimum value is 0 and maximum value is 69328.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim quarter, T040 lkan tau 104 en px, Latest

Column	Type	Comment
code	string	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 string is Q1 and maximum string is Q4.
label	string	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 string is Q1 and maximum string is Q4.

Fact, T040 lkan tau 104 en px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 400000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.
quarter	string	Datasource did not contain a description for Quarter. Column quarter has 400000 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Q1 and maximum string is Q4.
lender_sector	string	Datasource did not contain a description for Lender_sector. Column lender_sector has 400000 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_tol2002	string	Datasource did not contain a description for Borrower_industry_TOL2002. Column borrower_industry_tol2002 has 400000 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 X-O.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 400000 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_tol2002_by_quarter_in_20012008	int	Datasource did not contain a description for Business_loans_by_sector_and_industry_of_borrower_TOL2002_by_quarter_in_20012008. Column business_loans_by_sector_and_industry_of_borrower_tol2002_by_quarter_in_20012008 has 400000 rows, out of which 14320 are empty, making the null percent 3.58. Minimum value is 0 and maximum value is 69328.

Dim year, T040 lkan tau 104 en px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.
label	int	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.

Dim year, T040 lkan tau 104 en px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.
label	int	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2008.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim lender sector, T040 lkan tau 104 en px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 25 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.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: S.121 Suomen Pankki... and first 25 characters of maximum string: S.13149 Muut sosiaaliturv...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim lender sector, T040 lkan tau 104 en px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 25 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.
label	string	The label for the dimension value. Column label has 25 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: S.121 Suomen Pankki... and first 25 characters of maximum string: S.13149 Muut sosiaaliturv...

Dim quarter, T040 lkan tau 104 en px, Full history

Column	Type	Comment
code	string	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 string is Q1 and maximum string is Q4.
label	string	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 string is Q1 and maximum string is Q4.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 21, 2019
Created	July 16, 2019