Ppp Aggregate
ppp_aggregatePaycheck Protection Program (PPP) totals grouped by NAICS industry code, borrower state, or servicing lender: loan count, total approved, loans and dollars forgiven, forgiveness rate, and total jobs reported. Optionally scoped to one borrower state. Answers "which industries got the most PPP money in Texas" or "which lenders serviced the most PPP dollars". Business borrowers only (sole proprietors and individuals excluded). Source: SBA PPP FOIA data, as of 2024-09-30.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max groups to return (1-100, default 25). | |
| state | No | Optional 2-letter borrower state code to scope before grouping. | |
| group_by | No | naics | state | lender (default naics). | |
| order_by | No | Rank by total approved amount (default), loan count, or jobs reported. |