# Rank the top SBA 7(a) lenders in Texas by loan volume

**Use case:** 

Roll up SBA 7(a) FOIA loan data by lender for Texas: loan counts, total and average dollars per bank. A ranked list for lender prospecting and BD.

## Input

```json
{
  "program": "7a",
  "state": "TX",
  "mode": "rollup-by-lender",
  "flagRisk": true,
  "maxResults": 100,
  "maxScanRows": 500000
}
```

## Output

```json
{
  "program": {
    "label": "Program",
    "format": "string"
  },
  "borrower_name": {
    "label": "Borrower name",
    "format": "string"
  },
  "borrower_state": {
    "label": "Borrower state",
    "format": "string"
  },
  "lender_name": {
    "label": "Lender name",
    "format": "string"
  },
  "gross_approval": {
    "label": "Gross approval ($)",
    "format": "number"
  },
  "approval_fiscal_year": {
    "label": "Approval fiscal year",
    "format": "integer"
  },
  "naics_code": {
    "label": "NAICS code",
    "format": "string"
  },
  "loan_status": {
    "label": "Loan status",
    "format": "string"
  },
  "charged_off": {
    "label": "Charged off",
    "format": "boolean"
  },
  "amount_per_job": {
    "label": "Amount per job ($)",
    "format": "number"
  },
  "risk_flags": {
    "label": "Risk flags",
    "format": "array"
  },
  "rollup_dimension": {
    "label": "Rollup dimension",
    "format": "string"
  },
  "loan_count": {
    "label": "Loan count",
    "format": "integer"
  },
  "total_approved": {
    "label": "Total approved ($)",
    "format": "number"
  },
  "avg_approved": {
    "label": "Average approved ($)",
    "format": "number"
  },
  "charge_off_rate": {
    "label": "Charge-off rate",
    "format": "number"
  }
}
```

## About this Actor

This example demonstrates how to use [SBA Loan Portfolio Explorer API — 7(a) & 504 Rollups](https://apify.com/malonestar/sba-loan-portfolio-explorer) with a specific input configuration. Visit the [Actor detail page](https://apify.com/malonestar/sba-loan-portfolio-explorer) to learn more, explore other use cases, and run it yourself.