Data sources and licences
Two public agencies give all data of the site: the U.S. Small Business Administration and the Census Bureau.
Last checked against the SBA pages:
SBA 7(a) and 504 FOIA loan data
SBA publishes the files on its open data site: 7(a) & 504 FOIA. SBA describes the dataset in these words.
There are four files for the 7(a) loan program that segment the data by decade. There are two files for the 504 loan segmented by twenty years. A data dictionary is provided to help navigate the files. The FOIA data for the 7(a) and 504 programs are updated quarterly. The data is typically available one month after the quarter has ended.
Source: SBA open data, 7(a) & 504 FOIA, copied on .
- Licence. The dataset page gives the licence "U.S. Government Works". A work of the U.S. government is in the public domain.
- Data dictionary. SBA gives a data dictionary (xlsx). The glossary quotes it.
- Cadence. SBA changes the files each quarter. The site is built again when the files change.
| SBA file | Approvals | Data date | How the site read it |
|---|---|---|---|
| FOIA_504_FY1991_FY2009_asof_260630.csv | 111,066 | 30 Jun 2026 | Stored totals |
| FOIA_504_FY2010_Present_asof_260930.csv | 119,599 | 30 Sep 2026 | Read in this build |
| FOIA_7a_FY1991_FY1999_asof_260630.csv | 337,033 | 30 Jun 2026 | Stored totals |
| FOIA_7a_FY2000_FY2009_asof_260630.csv | 690,333 | 30 Jun 2026 | Stored totals |
| FOIA_7a_FY2010_FY2019_asof_260630.csv | 545,751 | 30 Jun 2026 | Stored totals |
| FOIA_7a_FY2020_Present_asof_260930.csv | 403,644 | 30 Sep 2026 | Read in this build |
The site stores the totals of the closed fiscal-year files and reads them again when SBA publishes them again. It reads the two open files in each build.
What the site keeps from a row
- The lender or CDC, with its SBA location number, city, state and FDIC or NCUA number.
- The state and the county of the project, the NAICS code and the franchise code and name.
- The fiscal year, the gross approval amount, the processing method, the term, the age of the business and the jobs supported.
- The loan status, the charged-off amount and, for 7(a), the initial interest rate and the fixed or variable indicator.
- For a 504 project, the name of the third-party lender when it is a bank or a credit union.
What the site drops
The site drops the borrower name, the street address, the city and the ZIP Code of the borrower. The file reader never passes them on. The reason
Census Bureau files
- County Business Patterns 2023. It gives the number of establishments of each county, state and NAICS code. The site uses it for approvals for each 1,000 establishments. For the old Connecticut counties it uses the 2021 file. County Business Patterns
- Geography files. Four files give the finder and the lists of nearby counties. They are the county adjacency file, the places gazetteer, the place-to-county file and the ZIP Code Tabulation Area file. Census reference files
- Licence. A work of the U.S. government is in the public domain.
This product uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.
Not the SBA
SBA Ledger is not the SBA and is not affiliated with the SBA or the Census Bureau. If a figure here differs from the SBA file, the SBA file is correct. Please report the difference.
Reuse
You can quote a table or a figure of the site with a link to its page and the data date. The data underneath is public. Get the original files from SBA.