home page   logout
home | message board | shared documents | data catalog | calendar | edit profile |

Dataset: hmda_93_05.dta

Description: HMDA Lending data

File Location

  home
         Finance
                HMDA
                       hmda_93_05.dta

Dataset Information

Source FFEIC
Geographic Detail Census Tract
Geographic Coverage Chicago, Cleveland, Dallas, Seattle
Year Coverage 1993-2005
Restrictions None
Comments

Click here for additional dataset information

Dataset Summary

Data Dictionary
Number of Rows: 48799
Number of Columns: 53
Column # Variable Variable Description Data Type No. Missing Min Value Max Value
1 fips FIPS geography (2000) character 0 NA NA
2 year year numeric 0 1993 2005
3 HMDA_loanamount_all_avg Weighted average loan amount (thousands of $ for all applications numeric 0 0 15950
4 HMDA_applicantincome_all_avg Weighted average income of applicant(s) (thousands of $) for all applications numeric 0 0 1515.8
5 HMDA_loanamount_all_med Median loan amount (thousands of $) – unweighted – for all applications numeric 0 0 15950
6 HMDA_applicantincome_all_med Median income of applicant(s) (thousands of $), unweighted, all applications numeric 0 0 523.077
7 HMDA_loanamount_org_avg Weighted average loan amount (thousands of $) for all originated loans numeric 0 0 31840
8 HMDA_applicantincome_org_avg Weighted average income of applicant(s) (thousands of $), all originated loans numeric 0 0 1693.303
9 HMDA_loanamount_org_med Median loan amount (thousands of $) – unweighted – for all originated loans numeric 0 0 31840
10 HMDA_applicantincome_org_med Median income of applicant(s) (thousands of $), unweighted, all originated loans numeric 0 0 820
11 HMDA_loanpurpose_purch Number of home purchase (one-to-four family) loan applications numeric 0 0 5603
12 HMDA_loanpurpose_improve Number of home improvement (one-to-four family) loan applications numeric 0 0 496
13 HMDA_loanpurpose_refin Number of refinancing (home purch or improve, 1-to-4 family) loan applications numeric 0 0 8946
14 HMDA_loanpurpose_multidw Number of multifamily dwelling (home purch, improve, & refin) loan applications numeric 0 0 76.831
15 HMDA_loans_org Number of loans originated numeric 0 0 10370
16 HMDA_loans_approvednotacc Number of applications approved but not accepted numeric 0 0 969
17 HMDA_loans_denied Number of applications denied by financial institution numeric 0 0 1359
18 HMDA_loans_org_purch Number of home purchase loans originated numeric 0 0 4393
19 HMDA_loans_org_improve Number of home improvement loans originated numeric 0 0 214.273
20 HMDA_loans_org_refin Number of refinancing loans originated numeric 0 0 7350
21 HMDA_loans_org_multidw Number of multifamily dwelling loans originated numeric 0 0 76.831
22 HMDA_loans_fha Number of FHA-insured (Federal Housing Administration) loan applications numeric 0 0 1138
23 HMDA_loans_occ_ownerocc Number of owner-occupied as a principal dwelling loan applications numeric 0 0 12293
24 HMDA_loans_occ_notownerocc Number of not owner-occupied housing loan applications numeric 0 0 1006
25 HMDA_loans_occ_notapplicable Number of not applicable loan applications numeric 0 0 138
26 HMDA_race_native Number of American Indian or Alaskan Native applicants numeric 0 0 50
27 HMDA_race_asian Number of Asian or Pacific Islander applicants numeric 0 0 1441
28 HMDA_race_black Number of Black applicants numeric 0 0 1639.5
29 HMDA_race_hispanic Number of Hispanic applicants numeric 0 0 897
30 HMDA_race_white Number of White applicants numeric 0 0 8388
31 HMDA_race_other Number of Other race applicants numeric 0 0 191
32 HMDA_race_notprovided Number of [race] Information not provided applicants numeric 0 0 1429
33 HMDA_race_notapplicable Number of [race] Not applicable applicants numeric 0 0 62
34 HMDA_loans_total Total number of loan applications numeric 0 0 12516
35 HMDA_loans_approved_norm Percent of loan applications approved ((action1 + action2)/loanpurptot) numeric 0 0 1
36 HMDA_loans_denied_norm Percent of loan applications denied (action3/loanpurptot) numeric 0 0 1
37 HMDA_loans_fha_norm Percent FHA loan applications (fhaloan/loanpurptot) numeric 0 0 1
38 HMDA_loans_occ_ownerocc_norm Percent of loan applications for owner occ housing units (occ1/(occ1 + occ2)) numeric 0 0 1
39 HMDA_loans_org_norm Percent of loans orig ((homeorg + imporg + refiorg + multiorg)/loanpurptot) numeric 0 0 1
40 HMDA_race_native_norm Percent of applicants that are American Indian or Alaska Native numeric 0 0 1
41 HMDA_race_asian_norm Percent of applicants that are Asian or Pacific Islander numeric 0 0 1
42 HMDA_race_black_norm Percent of applicants that are Black numeric 0 0 1
43 HMDA_race_hispanic_norm Percent of applicants that are Hispanic numeric 0 0 1
44 HMDA_race_white_norm Percent of applicants that are White numeric 0 0 1
45 HMDA_race_other_norm Percent of applicants that are Other race numeric 0 0 1
46 HMDA_subp_loanamount_avg Weighted average loan amount (thousands of $) for all originated subprime loans numeric 0 0 31840
47 HMDA_subp_applicantincome_avg Weighted avg inc of applicant(s) (thousands of $) for all orig subprime loans numeric 0 0 2967.667
48 HMDA_subp_loanamount_med Median loan amount (thousands of $) – unweighted – for all subprime orig loans numeric 0 0 31840
49 HMDA_subp_applicantincome_med Median inc of applicant(s) (thousands of $), unweighted, all subprime orig loans numeric 0 0 1260.5
50 HMDA_subp_loans_org_purch Number of home purchase (one-to-four family) subprime originated loans numeric 0 0 685
51 HMDA_subp_loans_org_improve Number of home improvement (one-to-four family) subprime originated loans numeric 0 0 76
52 HMDA_subp_loans_org_refin Number of refinancing (home purch or improv, 1-to-4 family) subprime orig loans numeric 0 0 364
53 HMDA_subp_loans_org_multidw Number of multifamily dwelling (home purch, improve, refin) subprime orig loans numeric 0 0 7


Data coverage by Census Tract / Year
Each cell count is the number of observations within the state/county, per year
State ID State County ID County y93 y94 y95 y96 y97 y98 y99 y00 y01 y02 y03 y04 y05
17 Illinois 1529 1866 1867 1867 1866 1871 1869 1870 1869 1864 1870 1867 1713
17031 Cook 1335 1334 1335 1335 1334 1339 1338 1339 1337 1333 1338 1336 1333
17037 DeKalb 0 21 21 21 21 21 20 21 21 21 21 21 20
17043 DuPage 147 147 147 147 147 147 147 147 147 147 147 147 147
17063 Grundy 0 9 9 9 9 9 9 9 9 9 9 9 9
17089 Kane 0 67 67 67 67 67 67 66 67 66 67 67 67
17093 Kendall 0 8 8 8 8 8 8 8 8 8 8 8 8
17097 Lake 0 151 151 151 151 151 151 151 151 151 151 150 0
17111 McHenry 47 47 47 47 47 47 47 47 47 47 47 47 47
17197 Will 0 82 82 82 82 82 82 82 82 82 82 82 82
39 Ohio 618 708 713 709 710 713 713 714 709 710 708 710 689
39007 Ashtabula 0 21 21 21 21 21 21 21 21 21 21 21 0
39035 Cuyahoga 498 494 499 495 496 499 499 500 495 496 495 497 497
39055 Geauga 21 21 21 21 21 21 21 21 21 21 21 21 21
39085 Lake 64 64 64 64 64 64 64 64 64 64 64 64 64
39093 Lorain 0 73 73 73 73 73 73 73 73 73 73 73 73
39103 Medina 34 34 34 34 34 34 34 34 34 34 34 34 34
39155 Trumbull 1 1 1 1 1 1 1 1 1 1 0 0 0
48 Texas 670 701 701 701 701 701 701 701 701 701 701 702 690
48085 Collin 85 85 85 85 85 85 85 85 85 85 85 85 85
48113 Dallas 487 487 487 487 487 487 487 487 487 487 487 485 487
48119 Delta 0 0 0 0 0 0 0 0 0 0 0 3 2
48121 Denton 56 56 56 56 56 56 56 56 56 56 56 56 56
48139 Ellis 22 22 22 22 22 22 22 22 22 22 22 22 22
48213 Henderson 0 14 14 14 14 14 14 14 14 14 14 14 0
48231 Hunt 0 17 17 17 17 17 17 17 17 17 17 17 17
48257 Kaufman 13 13 13 13 13 13 13 13 13 13 13 13 13
48397 Rockwall 7 7 7 7 7 7 7 7 7 7 7 7 7
53 Washington 507 528 528 527 528 528 527 527 527 528 527 527 506
53029 Island 0 21 21 21 21 21 21 21 21 21 21 21 0
53033 King 373 373 373 372 373 373 372 372 372 373 373 373 373
53053 Pierce 1 1 1 1 1 1 1 1 1 1 0 0 0
53061 Snohomish 133 133 133 133 133 133 133 133 133 133 133 133 133