Ppp Loan Lookup
ppp_loan_lookupLook up a business's Paycheck Protection Program (PPP) loan(s) by borrower name. Returns each loan's approved amount, jobs_reported (the headcount the business stated on its 2020-21 application), NAICS code, servicing and originating lender, approval date, first or second draw, loan status, and forgiveness amount and date. Names match from their first word ("Sumter Coatings" finds "SUMTER COATINGS, INC."); add zip to also match a word inside the name. Business borrowers only: sole proprietors, self-employed individuals and borrowers named as a person are excluded, and no street address is stored. Source: SBA PPP FOIA data, as of 2024-09-30.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| zip | No | Optional 5-digit borrower ZIP. With it, a word inside the name also matches. | |
| limit | No | Max loans to return (1-100, default 20). | |
| state | No | Optional 2-letter borrower state code to narrow common names, e.g. "SC". | |
| borrower_name | Yes | Business name, from its first word, e.g. "Sumter Coatings". Suffixes like Inc/LLC and punctuation are ignored. |