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).
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 |