# Track Denied Mortgage Applications By State

**Use case:** 

Track Denied Mortgage Applications By State. Structured rows from HMDA Mortgage Loan Applications & Lending Data Scraper, exportable to CSV, JSON or Excel. No A

## Input

```json
{
  "years": [],
  "states": [],
  "counties": [],
  "loanTypes": [
    "1",
    "2",
    "3",
    "4"
  ],
  "actionTaken": [
    "3"
  ],
  "loanPurposes": [],
  "lienStatuses": [],
  "occupancyTypes": [],
  "institutionLeis": [],
  "maxResults": 1000
}
```

## Output

```json
{
  "activityYear": {
    "label": "Year",
    "format": "number"
  },
  "financialInstitutionLei": {
    "label": "Institution LEI",
    "format": "text"
  },
  "stateCode": {
    "label": "State",
    "format": "text"
  },
  "countyCode": {
    "label": "County",
    "format": "text"
  },
  "censusTract": {
    "label": "Census tract",
    "format": "text"
  },
  "loanProductType": {
    "label": "Loan product",
    "format": "text"
  },
  "dwellingCategory": {
    "label": "Dwelling",
    "format": "text"
  },
  "actionTaken": {
    "label": "Action",
    "format": "number"
  },
  "loanPurpose": {
    "label": "Purpose",
    "format": "number"
  },
  "lienStatus": {
    "label": "Lien",
    "format": "number"
  },
  "loanAmount": {
    "label": "Loan USD",
    "format": "number"
  },
  "loanToValueRatio": {
    "label": "LTV",
    "format": "number"
  },
  "interestRate": {
    "label": "Interest rate",
    "format": "number"
  },
  "propertyValue": {
    "label": "Property value",
    "format": "number"
  },
  "occupancyType": {
    "label": "Occupancy",
    "format": "number"
  },
  "incomeThousands": {
    "label": "Income $K",
    "format": "number"
  },
  "derivedRace": {
    "label": "Derived race",
    "format": "text"
  },
  "derivedSex": {
    "label": "Derived sex",
    "format": "text"
  },
  "tractMinorityPopulationPercent": {
    "label": "Tract minority %",
    "format": "number"
  },
  "sourceUrl": {
    "label": "Source",
    "format": "link"
  }
}
```

## About this Actor

This example demonstrates how to use [HMDA Mortgage Loan Applications & Lending Data Scraper](https://apify.com/logiover/hmda-mortgage-loan-applications-scraper.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/logiover/hmda-mortgage-loan-applications-scraper.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/logiover/hmda-mortgage-loan-applications-scraper.md

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).