get_county_lending
Get quarterly SBA 7(a) loan aggregates for US counties—loan count, total amount, charge-off rate, average loan size, and jobs supported. Filter by FIPS, date range, or industry.
Instructions
Get quarterly SBA 7(a) loan aggregates for a single US county — 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 5-digit county FIPS code (e.g. '06037' for Los Angeles County, CA). 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 |