HMDA Mortgage Loan Applications & Lending Data Scraper

Stream millions of official FFIEC/CFPB HMDA loan and application records by year, state, county, lender LEI, loan type, purpose, action, amount and property profile. Built for mortgage, fintech, housing, fair-lending and real-estate analytics.

---

What does the HMDA Mortgage Loan Applications & Lending Data Scraper do?

This Actor turns HMDA Mortgage Loan Applications & Lending Data into a structured dataset you can actually work with. You give it a search, it walks the result pages, and it writes one clean row per record into your dataset — ready to export as JSON, CSV or Excel, or to pull straight from the Apify API.

It runs on plain HTTP with no browser and no login, which keeps it fast and cheap, and it works the same on a free account as on a paid one. Every field documented below came from a real verification run of this Actor, so what you read here is what you get.

The current build returns 47 populated fields per record, of which 45 are present on virtually every row.

Who is it for?

• Analysts who need HMDA Mortgage Loan Applications & Lending Data data as a spreadsheet instead of a browser tab.
• Operations and research teams tracking how HMDA Mortgage Loan Applications & Lending Data listings change over time.
• Developers wiring a live data feed into an internal tool or database.
• Growth and sales teams building prospect and market lists from public data.
• AI teams assembling structured training or grounding data.

Use cases

• Export a full HMDA Mortgage Loan Applications & Lending Data search into a spreadsheet for analysis.
• Track how prices, volumes or availability move week over week by scheduling the run.
• Feed a dashboard or internal database with a repeatable, structured source.
• Build a market map by running several searches in one job.
• Enrich an existing list by matching on the identifiers in the output.

Why use this HMDA Mortgage Loan Applications & Lending Data Scraper?

• 🔑 No API key and no login — nothing to authenticate, nothing to expire.
• 📦 47 verified fields — every column below was confirmed against live output.
• 📄 Real pagination — it walks the result set instead of returning the first screen.
• 🎯 Bounded runs — caps in the input stop the job exactly where you want, so the bill is predictable.
• 💸 Tiered pay-per-result — you pay per row, and higher Apify plans pay less per row.
• 📊 Export anywhere — JSON, CSV, Excel, HTML, the API, or any Apify integration.

What data can you extract?

One row per record. These columns come from a live run, with the share of rows that carried a value:

Field	Type	Typically filled	Description
actionTaken	number	100%	Action taken
activityYear	number	100%	Activity year
applicantAge	string	100%	Applicant age
businessOrCommercialPurpose	number	100%	Business or commercial purpose
censusTract	string	100%	Census tract
conformingLoanLimit	string	100%	Conforming loan limit
constructionMethod	number	100%	Construction method
countyCode	number	100%	County code
debtToIncomeRatio	string	100%	Debt to income ratio
denialReason1	number	100%	Denial reason1
derivedEthnicity	string	100%	Derived ethnicity
derivedRace	string	100%	Derived race
derivedSex	string	100%	Derived sex
dwellingCategory	string	100%	Dwelling category
financialInstitutionLei	string	100%	Financial institution lei
incomeThousands	number	100%	Income thousands
interestRate	number	100%	Interest rate
lienStatus	number	100%	Lien status
loanAmount	number	100%	Loan amount
loanProductType	string	100%	Loan product type
loanPurpose	number	100%	Loan purpose
loanTermMonths	number	100%	Loan term months
loanToValueRatio	number	100%	Loan to value ratio
loanType	number	100%	Loan type
msaMd	string	100%	Msa md
msaMedianFamilyIncome	number	100%	Msa median family income
occupancyType	number	100%	Occupancy type
originationCharges	number	100%	Origination charges
preapproval	number	100%	Preapproval
propertyValue	number	100%	Property value
purchaserType	number	100%	Purchaser type
rateSpread	number	97%	Rate spread
recordId	string	100%	Record id
reverseMortgage	number	100%	Reverse mortgage
scrapedAt	string	100%	Scraped at
sourceFileUrl	string	100%	Source file url
sourceUrl	string	100%	Source url
stateCode	string	100%	State code
totalLoanCosts	number	100%	Total loan costs
totalUnits	number	100%	Total units
tractMinorityPopulationPercent	number	100%	Tract minority population percent
tractOneToFourFamilyHomes	number	100%	Tract one to four family homes
tractOwnerOccupiedUnits	number	100%	Tract owner occupied units
tractPopulation	number	100%	Tract population
tractToMsaIncomePercent	number	100%	Tract to msa income percent
discountPoints	number	58%	Discount points
lenderCredits	string	87%	Lender credits

Fields below 90% are genuinely optional at the source — HMDA Mortgage Loan Applications & Lending Data does not publish them for every record. An empty value means the source did not show it, not that extraction failed.

Output example

{
  "actionTaken": 1,
  "activityYear": 2025,
  "applicantAge": "25-34",
  "businessOrCommercialPurpose": 2,
  "censusTract": "48141001501",
  "conformingLoanLimit": "C",
  "constructionMethod": 1,
  "countyCode": "48141",
  "debtToIncomeRatio": ">60%",
  "denialReason1": 10,
  "derivedEthnicity": "Hispanic or Latino",
  "derivedRace": "White",
  "derivedSex": "Female",
  "dwellingCategory": "Single Family (1-4 Units):Site-Built",
  "financialInstitutionLei": "549300IV3BQZRSE82O16",
  "incomeThousands": 46,
  "interestRate": 5.99,
  "lienStatus": 1,
  "loanAmount": 245000,
  "loanProductType": "Conventional:First Lien",
  "loanPurpose": 31,
  "loanTermMonths": 360
}

How to use

1. Open the Actor and fill in the search fields — the defaults below are a working example.
2. Set the result cap so the run stops where you want it.
3. Click Start, then export from the Output tab or pull the dataset through the API.

{
  "years": [
    "2025"
  ],
  "states": [
    "TX"
  ],
  "loanTypes": [
    "1",
    "2",
    "3",
    "4"
  ],
  "actionTaken": [
    "1"
  ],
  "minLoanAmount": 100000,
  "maxResults": 10000
}

Input parameters

Parameter	Type	Default	Description
years	array	[]	Four-digit years.
states	array	[]	Two-letter state codes.
counties	array	[]	Five-digit county FIPS codes for source-side geographic extraction.
loanTypes	array	["1", "2", "3", "4"]	1 conventional, 2 FHA, 3 VA, 4 USDA/RHS or FSA.
actionTaken	array	[]	Exact HMDA action codes, for example 1 originated, 2 approved not accepted or 3 denied.
loanPurposes	array	[]	Exact HMDA loan-purpose codes.
lienStatuses	array	[]	1 first lien, 2 subordinate lien.
occupancyTypes	array	[]	1 principal residence, 2 second residence, 3 investment property.
institutionLeis	array	[]	Exact Legal Entity Identifiers for one or more reporting lenders.
minLoanAmount	number	–	Minimum reported loan amount in USD.
maxLoanAmount	number	–	Maximum reported loan amount in USD.
minIncome	number	–	Minimum reported applicant income in USD; HMDA stores income in thousands.
maxIncome	number	–	Maximum reported applicant income in USD; HMDA stores income in thousands.
maxResults	integer	1000	Maximum HMDA loan/application records saved.

Tips for best results

• Broad searches return the deepest result sets; very narrow ones run out after a page or two.
• Use the result cap rather than the page cap when you want a predictable bill.
• Schedule the same input daily or weekly to build a history instead of a one-off snapshot.
• Lower the concurrency if you see retries — the source rate-limits aggressive crawling.
• Run several searches in one job instead of one search with a huge page count.
• Empty optional fields are normal; filter on the columns that matter to you after export.
• Deduplicate on the identifier column if you merge several runs together.
• Keep the proxy setting on the default unless the source blocks your region.

Integrations

Push results straight into Google Sheets, Slack, Zapier, Make, Airtable or any Webhook. You can also schedule the Actor and have each run append to the same dataset, which is how you turn a single export into a time series.

API usage

Replace <YOUR_TOKEN> with your Apify API token.

cURL

curl -X POST "https://api.apify.com/v2/acts/logiover~hmda-mortgage-loan-applications-scraper/run-sync-get-dataset-items?token=<YOUR_TOKEN>" \
  -H "Content-Type: application/json" \
  -d '{"years": ["2025"], "states": ["TX"], "loanTypes": ["1", "2", "3", "4"], "actionTaken": ["1"], "minLoanAmount": 100000, "maxResults": 10000}'

Python

from apify_client import ApifyClient

client = ApifyClient('<YOUR_TOKEN>')
run = client.actor('logiover/hmda-mortgage-loan-applications-scraper').call(run_input={"years": ["2025"], "states": ["TX"], "loanTypes": ["1", "2", "3", "4"], "actionTaken": ["1"], "minLoanAmount": 100000, "maxResults": 10000})
for item in client.dataset(run['defaultDatasetId']).iterate_items():
    print(item)

Node.js

import { ApifyClient } from 'apify-client';

const client = new ApifyClient({ token: '<YOUR_TOKEN>' });
const run = await client.actor('logiover/hmda-mortgage-loan-applications-scraper').call({"years": ["2025"], "states": ["TX"], "loanTypes": ["1", "2", "3", "4"], "actionTaken": ["1"], "minLoanAmount": 100000, "maxResults": 10000});
const { items } = await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

Use with AI agents (MCP)

This Actor is reachable through the Apify MCP server, so an AI agent can call it as a tool. Point the agent at https://mcp.apify.com and ask it something like "pull the first 200 listings from HMDA Mortgage Loan Applications & Lending Data and summarise them" — it receives the same structured rows you would get from the UI.

FAQ

Do I need a HMDA Mortgage Loan Applications & Lending Data account or API key?

No. The Actor reads publicly available pages only. There is nothing to authenticate and no credentials to rotate.

Does it work on the free plan?

Yes. Every feature is available on a free Apify account — nothing is gated behind a paid tier. Pricing is per result, and higher plans simply pay less per row.

How many listings can I get in one run?

As many as the search exposes. Raise the page and result caps together; the run stops at whichever limit it reaches first.

Why did I get fewer rows than I asked for?

The search ran out of records. That is normal for narrow queries — broaden the search or add more searches to one run.

Why are some fields empty?

HMDA Mortgage Loan Applications & Lending Data does not publish every attribute for every record. The table above shows how often each field is filled in practice.

What export formats are supported?

JSON, CSV, Excel, HTML and RSS from the Output tab, plus the Apify API and any integration you connect.

How fast is it?

It is pure HTTP with no browser, so a page of results typically takes a second or two.

Can I schedule it?

Yes. Use the Apify scheduler to run it on any interval and append each run to the same dataset.

Does it use a proxy?

It routes through Apify Proxy by default. You can switch groups or supply your own proxies in the input.

Is the output schema stable?

Yes. Field names and types are fixed, so downstream pipelines will not break between runs.

How often is the data refreshed?

Every run reads the live source. There is no cache, so the data is as current as the website itself.

What if the site changes its layout?

Open an issue on the Issues tab and it gets fixed — the Actor is actively maintained.

Is it legal?

This Actor reads only publicly available pages on HMDA Mortgage Loan Applications & Lending Data — the same content any visitor sees without logging in. It does not bypass authentication and does not collect private data. You remain responsible for how you use the output: respect the source's terms of service, applicable copyright, and data-protection law such as GDPR where personal data is involved.

Related scrapers

Browse the full collection at apify.com/logiover — Lead Generation tools and more.