RRA
Data Products Capital Intelligence HMDA LAR Export

Capital Intelligence

HMDA LAR Export

Normalized HMDA loan application records for Caddo and Bossier parishes, 2007–2024 — consistent schema across the 2018 format change, enriched with parcel-level flood zone, distress, and adjudication status.

315K
Loan Applications
2007–2024
Coverage
Caddo + Bossier
Parishes
17
Annual Vintages

About this product

HMDA data is public but nearly unusable for multi-year analysis. The CFPB's 2018 format overhaul created a schema break that makes pre/post comparison require substantial normalization work. This product delivers a consistent schema across the full 2007–2024 span — one file, one format, 17 vintages reconciled.

RRA enrichment adds parcel-level physical context unavailable in the raw HMDA file: FEMA flood zone and SFHA designation, ground subsidence rate, composite parcel distress score, and adjudication status for the origination address. These fields enable analyses that the raw LAR cannot support — such as whether denial rates correlate with physical risk exposure, or whether originations are concentrated in lower-distress areas.

Primary use cases: CRA self-assessment (community banks documenting coverage across their assessment area), fair housing analysis (denial rate disparities by geography and borrower characteristics), academic research, and investment geography screening.

Buyers

  • Community banks performing CRA compliance self-assessment
  • Fair housing attorneys and advocacy organizations
  • CDFIs analyzing capital availability and lending gaps
  • Academic researchers and investigative journalists

Delivery

  • ·CSV file delivery, one row per loan application
  • ·Includes both originated and denied applications
  • ·Annual refresh — new HMDA vintage released each September
  • ·One-time purchase or annual subscription

Dataset Fields

— Standard HMDA Fields —
lei / institution_name
Lender Legal Entity Identifier and institution name
loan_type / loan_purpose
Conventional/FHA/VA/USDA; purchase/refinance/home improvement/HELOC
action_taken
Origination, denial, withdrawn, incomplete — application outcome
loan_amount
Loan amount in thousands
census_tract
FIPS census tract of the property
income
Applicant gross annual income (thousands)
denial_reason_1/2/3
Up to three lender-stated denial reasons
derived_race / derived_ethnicity
CFPB-derived applicant race and ethnicity categories
— RRA Enrichment Fields —
flood_zone / in_sfha
FEMA flood zone designation and Special Flood Hazard Area flag for the origination address
velocity_vert_mmyr
Ground subsidence rate at the parcel (InSAR-derived)
parcel_distress_score
Composite distress score for the origination parcel
adjudicated
Whether the origination parcel is currently adjudicated
neighborhood
RRA neighborhood assignment for the origination address
Request Sample →