Database Spring 2023

Answer each of the questions in the document directly under the question. Below all of the questions, include your code and indicate the question it addresses.

Part 1: Questions

Limit these results to loans that mapped to businesses with good address in census tracts with populations >= 100?

For these questions, use the American Community Survey (ACS) values: total_pop, hispanic_pop, black_pop, white_pop. (`bigquery-public-data.census_bureau_acs.censustract_2020_5yr`)

For your bank in your bank’s designated counties, how many loans mapped to census tracts with populations >= 100?

For your bank in your bank’s designated counties, what percentage of those loans went to businesses in census tracts that were majority black?

For your bank in your bank’s designated counties, what percentage of those loans went to businesses in census tracts that were majority Hispanic?

For your bank in your bank’s designated counties, what percentage of those loans went to businesses in census tracts that were majority white?

(Note: Don’t break down the results by individual county.)

For all banks that made loans to business in your bank’s designated counties, how many loans went to census tracts with populations >= 100?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts that were majority black?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts that were majority Hispanic?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts that were majority white?

Part 2: Questions

Using the income table: `classdata-324219.ppp.census_income` (see guide below). Limit these results to loans that mapped to businesses with good address in tracts with populations >= 100?

For your bank, what percent of its loans went to businesses in census tracts in your bank’s designated counties where the median family income is > 0% and < 50% of the MSA/MD median family income (Income_Level_Ind =1)?

For your bank, what percent of its loans went to businesses in census tracts in your bank’s designated counties where the median family income is >= 50% and < 80% of the MSA/MD median family income?

For your bank, what percent of its loans went to businesses in census tracts in your bank’s designated counties where the median family income is >= 80% and < 120% of the MSA/MD median family income?

For your bank, what percent of its loans went to businesses in census tracts in your bank’s designated counties where the median family income is >= 120% of the MSA/MD median family income?

(Note: Don’t break down the results by individual county.)

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts median family income is > 0% and < 50% of the MSA/MD median family income?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts median family income is >= 50% and < 80% of the MSA/MD median family income?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts median family income is >= 80% and < 120% of the MSA/MD median family income?

For all banks that made loans to business in your bank’s designated counties, what percent of those loans (tract populations >= 100) went to businesses in census tracts median family income is >= 120% of the MSA/MD median family income?