	activity_year	lei	derived_msa_md	state_code	county_code	census_tract	conforming_loan_limit	derived_loan_product_type	derived_dwelling_category	derived_ethnicity	...	denial_reason_2	denial_reason_3	denial_reason_4	tract_population	tract_minority_population_percent	ffiec_msa_md_median_family_income	tract_to_msa_income_percentage	tract_owner_occupied_units	tract_one_to_four_family_homes	tract_median_age_of_housing_units
0	2018	5493002QI2ILHHZH8D20	31084	CA	6037.0	6.037603e+09	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	...	NaN	NaN	NaN	7029	96.76	69300	65	885	1363	51
1	2018	549300ALNLUNS3Y53T24	44060	WA	53063.0	5.306301e+10	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	...	NaN	NaN	NaN	7568	11.19	64000	138	2002	2338	22
2	2018	549300PUSSF737Y6XW86	12060	GA	13223.0	1.322312e+10	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	...	NaN	NaN	NaN	11924	26.72	74400	125	3082	3775	13
3	2018	JJKC32MCHWDI71265Z06	17900	SC	45079.0	4.507901e+10	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	...	NaN	NaN	NaN	6860	53.85	68800	128	1815	2465	13
4	2018	5493002UNUIL8WHZAD63	31140	KY	21185.0	2.118503e+10	C	Conventional:First Lien	Single Family (1-4 Units):Site-Built	Not Hispanic or Latino	...	NaN	NaN	NaN	4719	6.42	70400	161	1412	1616	33

5 rows × 99 columns