📊 HMDA Mortgage Loan Data Scraper

🚀 Export HMDA loan aggregations data in seconds. Structured records direct from the public ffiec.cfpb.gov endpoint to CSV, Excel, JSON, or XML.

🕒 Last updated: 2026-05-29 · 📊 11 fields per record · Public REST API · HMDA loan aggregations

The HMDA Mortgage Loan Data Scraper turns the ffiec.cfpb.gov public REST endpoint into a clean, structured dataset. It calls the endpoint with the parameters you supply, parses the JSON, and flattens each record into one row.

Dataset coverage depends on the upstream source. All field names are clean snake_case / camelCase, numeric strings are auto-cast to numbers, and upstream rate-limit notes are surfaced as a clean error record instead of crashing your pipeline.

🎯 Target Audience	💡 Primary Use Cases
📊 Analysts	Pull structured records for analysis
🏢 Finance teams	Snapshot data for dashboards and reports
🤖 ML engineers	Build training sets from public sources
📰 Journalists	Verify numbers for stories with one click
👩‍💻 Developers	Mirror upstream data into your own DB without writing client code
🎓 Researchers	Run reproducible studies on public data

📋 What the HMDA Mortgage Loan Data Scraper does

• Calls the public ffiec.cfpb.gov endpoint.
• Parses the JSON response and flattens each record into a clean row.
• Casts numeric fields to numbers so they import cleanly into Excel and BI tools.
• Surfaces upstream rate-limit or error notes as a single-row error record instead of crashing.
• Exports as CSV, Excel, JSON, JSONL, XML, RSS, or HTML.

💡 Why it matters: The raw HMDA loan aggregations JSON is verbose and hard to consume in spreadsheets. This actor normalizes the payload into one row per record so the data drops straight into pandas, BigQuery, or a Google Sheet.

🎬 Full Demo

🚧 Coming soon.

⚙️ Input

Field	Type	Required	Description
years	string	Yes	e.g. 2023,2024.
states	string	Yes	e.g. CA,NY.
actionsTaken	string	No	Comma-list.
races	string	No	Comma-list.
loanTypes	string	No	Comma-list.
maxItems	integer	No	Free users: 10. Paid users: up to 1,000,000. Prefill: 10.

Example 1:

{
  "years": "2023",
  "states": "CA",
  "maxItems": 100
}

Example 2:

{
  "years": "2022,2023",
  "states": "NY,TX",
  "actionsTaken": "1,3",
  "maxItems": 200
}

⚠️ Good to Know: The HMDA loan aggregations API is rate-limited. This actor surfaces rate-limit notes as a clean error record so your downstream pipeline can decide how to retry.

📊 Output

Each record is a flat object. error is always last.

Field	Type	Description
📅 year	number	HMDA reporting year.
🇺🇸 state	string	State code.
🏛️ county	string	County code.
⚡ actionTaken	string	Action code.
🏠 loanType	string	Loan type.
🎯 loanPurpose	string	Purpose.
🧑 race	string	Applicant race code.
🔢 count	number	Aggregated count.
💰 sumLoanAmount	number	Aggregated dollar sum.
🕒 scrapedAt	string	Fetch timestamp.
❌ error	string	Set on upstream error.

Sample record:

{
  "year": 2023,
  "state": "CA",
  "county": null,
  "actionTaken": "1",
  "loanType": "1",
  "loanPurpose": "1",
  "race": "5",
  "count": 12453,
  "sumLoanAmount": 4823000000,
  "scrapedAt": "2026-05-29T12:00:00.000Z",
  "error": null
}

✨ Why choose this Actor

| 🆓 | Works with the free, public HMDA loan aggregations endpoint. | | 🧹 | Clean snake_case keys ready for BI. | | 🔢 | Auto-casts numeric strings to real numbers. | | 🛟 | Surfaces rate-limit notes as a clean error record. | | 🔌 | Drop-in dataset replacement for the raw API. | | 💾 | Push to dataset → instant CSV / Excel / JSON / XML / RSS / HTML export. |

📈 How it compares to alternatives

Approach	Setup time	Clean keys?	Numeric casting?	Rate-limit handling?
Roll your own fetch	30 min +	❌	❌	❌
Generic API client	1 hr install + script	partial	partial	partial
This Actor	5 sec, no install	✅	✅	✅

🚀 How to use

1. Click Try for free.
2. Adjust input fields (or leave defaults).
3. Click Start. Within seconds, your dataset is ready — download as CSV, Excel, JSON, or XML, or pipe to your warehouse.

💼 Business use cases

📊 Analytics & dashboards. Pull HMDA loan aggregations data into a single CSV, feed BI tools, share with stakeholders.

🤖 ML feature engineering. Build clean training sets from HMDA loan aggregations for downstream models.

📰 Newsroom fact-checking. Verify numbers for stories in 30 seconds.

🏢 Treasury / ops. Schedule daily runs and pipe to your dashboard.

🔌 Automating HMDA Mortgage Loan Data Scraper

• Make / Zapier: trigger this actor on a schedule, push results to Airtable, Google Sheets, or Slack.
• Cron schedule: native Apify scheduler.
• Webhooks: POST to your endpoint the moment a run finishes.
• Pipe to BigQuery / Snowflake / Postgres: native Apify integrations.

🌟 Beyond business use cases

🎓 Education. Teach a class with real HMDA loan aggregations data instead of toy datasets.

🧪 Personal research. Track HMDA loan aggregations signals on your own schedule.

🤝 Non-profit & open data. Build public dashboards without writing client code.

🧰 Tinkering & prototyping. Spin up a feed in 5 seconds to test a new idea.

🤖 Ask an AI assistant about this scraper

Pop this README into ChatGPT, Claude, or any AI assistant and ask it to map your specific workflow to the actor's inputs.

❓ Frequently Asked Questions

❓ Do I need an API key? No. The CFPB HMDA browser API is open.

❓ What years are available? 2007 onward.

❓ Can I aggregate by demographic? Yes. Use the races, actionsTaken, loanTypes filters.

❓ What is action taken? Codes 1-8 (originated, approved-not-accepted, denied, etc.).

❓ Is this loan-level? No. This is the aggregations endpoint. Loan-level is a separate endpoint with much larger payloads.

❓ What format can I download? CSV, Excel, JSON, JSONL, XML, RSS, or HTML.

🔌 Integrate with any app

Apify ships native integrations with Make, Zapier, Slack, Discord, Google Drive, Google Sheets, Gmail, Airbyte, Keboola, Telegram, GitHub, and any REST API or webhook endpoint.

🔗 Recommended Actors

Actor	What it does
ParseForge Alpha Vantage Scraper	Stocks, FX, crypto, indicators.
ParseForge Yahoo Finance Scraper	Equities, funds, indices.
ParseForge OurAirports Scraper	Global airport database.
ParseForge NBA Stats Scraper	Player and team stats from NBA.com.

💡 Pro Tip: browse the complete ParseForge collection for 900+ production-grade scrapers.

---

Disclaimer: This actor scrapes only publicly available data. ParseForge is not affiliated with, endorsed by, or sponsored by any of the third-party services referenced. Users are responsible for complying with the target site's terms of service and applicable law. Create a free account w/ $5 credit.