get_state_lending
Get quarterly SBA 7(a) loan aggregates by state: loan count, total amount, charge-off rate, average loan size, and jobs supported. Optionally filter by date range and industry.
Instructions
Get quarterly SBA 7(a) loan aggregates for a single US state — loan count, total amount, charge-off rate, average loan size, and jobs supported. Without period filters, returns the latest available quarterly observation. Provide both from_period and to_period (YYYY-Qq, e.g. '2024-Q1') for a time series. Params: fips is a 2-digit state FIPS code (e.g. '06' for California, '48' for Texas). Optional industry filter accepts a NAICS code to restrict aggregates to one industry. Source: US Small Business Administration, 7(a) Loan Program (public domain).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"fips": "<fips>"
},
"name": "get_state_lending"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fips | Yes | ||
| year | No | ||
| quarter | No | ||
| industry | No | ||
| to_period | No | ||
| from_period | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |