SBA 7(a) and 504 loan data reports for loans approved since FY1991.

This report provides statistics on Year to Date (YTD) SBA Business Loan Approval Activity comparisons for Fiscal Years

Reflects total recovery rates, as a percent of the purchase amounts by purchase year, for the four large guarantied programs and an aggregate total for the small guarantied programs.

Analysis of ‘SBA Loans Case Data Set’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/larsen0966/sba-loans-case-data-set on 13 February 2022.

--- Dataset description provided by original source is as follows ---

Should This Loan be Approved or Denied?

If you like the data set and download it, an upvote would be appreciated.

The Small Business Administration (SBA) was founded in 1953 to assist small businesses in obtaining loans. Small businesses have been the primary source of employment in the United States. Helping small businesses help with job creation, which reduces unemployment. Small business growth also promotes economic growth. One of the ways the SBA helps small businesses is by guaranteeing bank loans. This guarantee reduces the risk to banks and encourages them to lend to small businesses. If the loan defaults, the SBA covers the amount guaranteed, and the bank suffers a loss for the remaining balance.

There have been several small business success stories like FedEx and Apple. However, the rate of default is very high. Many economists believe the banking market works better without the assistance of the SBA. Supporter claim that the social benefits and job creation outweigh any financial costs to the government in defaulted loans.

The Data Set

The original data set is from the U.S.SBA loan database, which includes historical data from 1987 through 2014 (899,164 observations) with 27 variables. The data set includes information on whether the loan was paid off in full or if the SMA had to charge off any amount and how much that amount was. The data set used is a subset of the original set. It contains loans about the Real Estate and Rental and Leasing industry in California. This file has 2,102 observations and 35 variables. The column Default is an integer of 1 or zero, and I had to change this column to a factor.

For more information on this data set go to https://amstat.tandfonline.com/doi/full/10.1080/10691898.2018.1434342

--- Original source retains full ownership of the source dataset ---

Less than **** of applications for loans by small businesses in the United States were approved in the fourth quarter of 2024. The approval rate of loans to small businesses in the U.S. has remained slightly above or under the ** percent mark, except during the first years of the COVID-19 pandemic. Those figures only refer to commercial and industrial loans to non-farm small businesses.

Graph and download economic data for Weighted-Average Effective Loan Rate for Small Business Administration (SBA) for All Commercial Banks (DISCONTINUED) (EEBNQ) from Q3 2012 to Q2 2017 about SBA, weighted-average, average, loans, banks, depository institutions, rate, and USA.

This dataset contains non-personally identifiable (non-PII) data from the U.S. Small Business Administration (SBA) Disaster Loan Program. Following a declared disaster, the SBA provides disaster assistance in the form of low-interest, long-term disaster loans for damages not covered by insurance or other recoveries to businesses of all sizes, private nonprofit organizations, as well as homeowners and renters. For more information about the SBA Disaster Loan Program, please visit www.sba.gov/disasterassistance. This dataset includes raw, unedited data from SBA’s Disaster Credit Management System (DCMS) which may have been entered directly by disaster survivors and as such is subject to human error. Additionally, the dollar values in the data set may not reflect subsequent changes to verified losses or approved loan amounts. SBA adjusts damages and loan amounts as needed based on the availability of new or corrected information. For example, verified loss and approved loan amounts may be increased later if new damages are discovered or the cost of repairs increase during the rebuilding project. Similarly, loan amounts may be decreased if the disaster survivor receives additional recoveries from insurance or grant assistance which duplicate SBA’s assistance, thereby decreasing the overall loan eligibility. This dataset is not intended to be an official Federal report, and should not be considered as such. If you have media inquiries about the SBA Disaster Loan Program, please email SBA’s Office of Communications and Public Liaison at press_office@sba.gov. For inquiries about how to submit a Freedom of Information Act (FOIA) or a Privacy Act request, please contact SBA’s Freedom of Information/Privacy Acts Office by email at foia@sba.gov. For all other inquiries about this data set, including requests from States and local governments for more detailed loan data, please email the SBA’s Office of Disaster Assistance’s Data Steward, Alejandro Contreras, at alejandro.contreras@sba.gov. Information for State and local governments on how to request a data sharing agreement with SBA to help identify and prevent duplications of benefits.

Reflects the number of loans approved by fiscal year for the major programs and aggregate totals for the other direct and guarantied programs.

SBA Disaster Loan Data provides verified loss and approved loan amount totals for both home and business disaster loans, segmented by city, county, zip code and state.

An aggregated dataset of PPP (Paycheck Protection Program) SBA (Small Business Administration) loans involving 3 million businesses would be a comprehensive collection of financial information, aimed at analyzing the distribution and impact of these loans. This dataset would include key details such as the names of the businesses, loan amounts, loan disbursement dates, and the terms of the loans. Additionally, the dataset would contain information on board members of these businesses, providing insights into the governance structures and potential networks influencing the flow of SBA funds. This aspect of the dataset can be crucial for understanding the distribution patterns of PPP loans, identifying trends in funding allocation among different types of businesses, and examining any correlations between board composition and loan receipt. Such a dataset would be valuable for various analyses, including: Financial Analysis: Assessing the financial health and stability of businesses that received PPP loans, and understanding how these loans have impacted their operations during challenging economic times. Governance Analysis: Evaluating the role of board members in acquiring PPP loans, and whether certain types of governance structures were more successful in securing funds. Economic Impact Assessment: Measuring the broader economic impact of the PPP loans, such as job retention, business survival rates, and sector-wise distribution of funds. Network Analysis: Mapping the connections between different businesses and their board members to identify any potential networks or clusters that may have influenced the flow of funds. Policy Evaluation: Providing data-driven insights to policymakers for assessing the effectiveness of the PPP program and for planning future economic relief measures.

Reflects the gross dollar amount of loans approved by fiscal year for the major loan programs and aggregate totals for the small programs. Gross approval includes loans that are cancelled in the current and subsequent years.

Small Business Lending in the United States, published by the SBA’s Office of Advocacy annually since 1994, looks at small business lending locally and nationally using two types of data supplied by depository institutions to their respective regulating agencies—Call Reports and Community Reinvestment Act (CRA) reports. The annual banking study includes cooperative banks in addition to existing depository institutions and gives a brief review on the institution lending patterns. The rankings and performance of these lenders are summarized and organized by state/territory, loan size, number of loans, and asset size of the institution. The Small Business Lending tables use the call report data to rank all lenders by state.

Graph and download economic data for Percent of Value of Loans, Small Business Administration (SBA) Backed for All Commercial and Industry Loans, Other Risk (Acceptable), Small Domestic Banks (DISCONTINUED) (EBAOXSSNQ) from Q3 2012 to Q2 2017 about SBA, commercial, domestic, percent, loans, banks, depository institutions, industry, and USA.

Complete set of loan-level data on the recipients of Paycheck Protection Program loans

Small Business Administration Loan Guarantee (SBA)

1.5 Million Loan Guarantees Across 7(a) and 504 Programs

By Noah Brod [source]

About this dataset

The Small Business Administration (SBA) Loan Guarantee Data provides a comprehensive look at loans that were approved by the SBA from January 1, 1990 to December 31, 1999. This dataset offers insight into roughly 1.5 million approved loans, including details such as the loan amount, interest rate, project county, and more.

This data was collected as part of an FOIA request and is updated quarterly for up-to-date information. It should be noted that the SBA is not a direct lender but rather a guarantor of the loan which is made by either a bank or non-bank lender.

The dataset includes detailed fields such as AsOfDate, Program Type, Gross Approval Amounts and Initial Interest Rates; Fanchise Codes and County Information; Delivery Method and Status Reports; Congressional Districts involved in financing these loans; Jobs Supported as part of each loan; Billing Information related to ChargeOff Dates and Amounts; SBADistrict Office associated with individual loan approvals ;and more!

This unique pool of data can offer invaluable insights into the mechanisms behind small business lending throughout the nineties in America – showing how much has changed since then but also how some trends remain consistent over time. The Small Business Administration Loan Guarantee Data can help shine light on important topics such as demographic disparities among borrowers or regional differences between approving offices - increasing our understanding of American business practices overall!

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

Research Ideas

• Using NaicsCode, initialize a visual representation of the most popular types of businesses that receive SBA loan ensures to get a better sense of which industries are the biggest uses for this financing program.
• Calculating Loan Status data over a period of time to analyse trends in terms of loan defaults and how much money is disbursed vs charged off.
• Examining GrossApproval and SBAGuarterNeedApproval data to determine which zipcodes or states have received more funding from the SBA and apply this information in aid targeting certain areas as part of govermental stimulus packages during tough economic times

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

Unknown License - Please check the dataset description for more information.

Columns

File: 7a_504_FOIA%20Data%20Dictionary.csv

File: FOIA%20-%207(a)(FY1991-FY1999).csv | Column name | Description | |:--------------------------|:-------------------------------------------------------------| | AsOfDate | Date the data was last updated. (Date) | | Program | Type of loan program. (String) | | BorrName | Name of the borrower. (String) | | BorrStreet | Street address of the borrower. (String) | | BorrCity | City of the borrower. (String) | | BorrState | State of the borrower. (String) | | BorrZip | Zip code of the borrower. (String) | | BankName | Name of the bank. (String) | | BankStreet | Street address of the bank. (String) | | BankCity | City of the bank. (String) | | BankState | State of the bank. (String) | | BankZip | Zip code of the bank. (String) | | GrossApproval | Total amount of the loan approved. (Number) | | SBAGuaranteedApproval | Amount of the loan guaranteed by the SBA. (Number) | | ApprovalDate | Date the loan was approved. (Date) | | ApprovalFiscalYear | Fiscal year the loan was approved. (Number) | | FirstDisbursementDate | Date the loan was disbursed. (Date) | | DeliveryMethod | Method of delivery for the loan. (String) | | subpgmdesc | Description of the loan program. (String) ...

Provides a list of all the datasets available in the Public Data Inventory for the Small Business Administration.

These files include a loan level list of all 7(a) and 504 loans approved since January 1, 1990 as well as the corresponding Data Dictionary. SBA 7(a) and 504 Loan Data Dictionary ,Monthly Report of SBA 7(a) and 504 Loan Data,1990 - 1999 SBA 7a Loan Data , 2000 - Present SBA 7(a) Loan Data and 1990 - Present SBA 504 Loan Data.

Advocacy’s small business lending report examines FDIC data to determine the state of bank lending to small businesses. This report, which analyzes loan data from June 2019 to June 2020, examines the small business lending market at the beginning of the COVID-19 pandemic. Small business loans (loans below $1 million) increased by nearly 40% from 2019 to 2020, largely due to the newly enacted Paycheck Protection Program. Alongside the report, the appendix tables provide bank level detail of small business lending activity and breakdowns at the state level.

United States - Percent of Value of Loans Small Business Administration (SBA) Backed by Size of Loan: ($ Thousands) $1,000 to $9,999, Domestic Banks (DISCONTINUED) was 0.10% in April of 2017, according to the United States Federal Reserve. Historically, United States - Percent of Value of Loans Small Business Administration (SBA) Backed by Size of Loan: ($ Thousands) $1,000 to $9,999, Domestic Banks (DISCONTINUED) reached a record high of 17.30 in January of 2016 and a record low of 0.00 in October of 2012. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Percent of Value of Loans Small Business Administration (SBA) Backed by Size of Loan: ($ Thousands) $1,000 to $9,999, Domestic Banks (DISCONTINUED) - last updated from the United States Federal Reserve on June of 2025.

description: Reflects total post-charge off recovery rates, as a percent of the amounts charged off by charge off year, for the major loan programs and aggregate totals by charge off year for the small direct and guarantied programs.; abstract: Reflects total post-charge off recovery rates, as a percent of the amounts charged off by charge off year, for the major loan programs and aggregate totals by charge off year for the small direct and guarantied programs.