This dataset includes small business loans or grants issued for emergency COVID-19 financial assistance. Underlying data is provided by the Department of Small Business Services (SBS). Dollar amounts are in actual dollars.

The coronavirus pandemic has had catastrophic consequences on small businesses in the United States. Between March and August 2020, monthly online searches for "small business loan forgiveness" increased by over 115,270 percent compared to the previous year. During that period, small businesses were also featured in seven of the top ten fastest growing search queries relating to "loans" in the United States.

This dataset consolidates public U.S. Small Business Administration (SBA) Economic Injury Disaster Loan (EIDL) data released during the COVID-19 pandemic.

It contains loan-level records issued between April and November 2020, documenting the scale and timing of emergency relief for small businesses across all U.S. states and territories.

The files were retrieved from the SBA’s open-data portal and standardized for analysis in Python (Pandas) and visualization in Tableau.

Fields include: • Loan amount (face value or obligation) • Approval date • State of recipient • Recipient identifier

Analytical use: This data supports exploration of post-COVID economic recovery patterns, showing how federal loan programs helped stabilize small businesses by region and time period.

Source: U.S. Small Business Administration Open Data

Last updated: November 2020

Prepared by: Christopher White (@cwhiteprofessional)

License: U.S. Government Works — This dataset is derived from public SBA data and is not subject to copyright protection under 17 U.S.C. §105. It may be freely reused and shared.

In March 2020, the value of loans fell by almost 50 percent compared to the previous year due to the coronavirus pandemic (COVID-19). Throughout April, the value of loans decreased by 72 percent compared to April last year. Also, there was a significant decrease in the number of loans granted. In April 2020, less than 43 percent of loans were given as compared to 2019.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

As a result of the coronavirus (COVID-19) crisis, many people worldwide faced job insecurity and income disruption. For mortgage borrowers in the United States, this means increased risk of delayed loan repayment, default and foreclosure.

In April 2020, the share of single-family housing mortgages owned by Freddie Mac that were in forbearance and delinquent for ** days spiked to ** percent. One year later, as of April 2021, approximately ** percent of the mortgage loans in forbearance were delinquent for over *** days.

RRF funding aims to fill gaps in immediate working capital for small businesses and nonprofits (including cultural organizations) until they can resume more normal operations. Recipients may or may not have applied for additional funding through Small Business Administration (SBA) loans and other federal disaster relief funding sources. Using $2 million of the City’s share of Food and Beverage Tax funds that the Bloomington Common Council approved for expenditure April 7, plus $500,000 of additional support approved by the Bloomington Urban Enterprise Association on April 8, the City is providing these immediate loans of up to $50,000 each to sustain area businesses in the short term and foster the regional economy. An advisory committee was appointed by the City of Bloomington to review applications and make recommendations for funding. This committee includes representatives from banking, financial services, and community organizations. Additionally, applicants may seek support on their application by contacting the City of Bloomington at economicvitality@bloomington.in.gov. For more information about this and other Recover Forward efforts, see: https://bloomington.in.gov/recoverforward

State-guaranteed loans during the COVID-19 crisis The Government is implementing an exceptional guarantee scheme to support the bank financing of companies, up to EUR 300 billion. Until December 31, companies of any size, regardless of the legal form of the company (including companies, traders, craftsmen, farmers, liberal professions, micro-entrepreneurs, associations and foundations engaged in economic activity), with the exception of civil real estate companies, credit institutions and finance companies, will be able to apply to their usual bank for a loan guaranteed by the State to support their cash flow. ### The Business Aid Scoreboard In order to offer visibility to all French people on the allocation of aid to enterprises, the Minister for Action and Public Accounts, with the technical support of the department Etalab of the Inter-Ministerial Directorate of Digital (DINUM), make available a scoreboard of which source code is available, which proposes a consolidated vision of the support provided to companies. ### Description of the data This dataset contains the data presented on the State Guaranteed Loans tab of the dashboard. The data shall inform, at regional and departmental granularity, the following data: — the number of loans guaranteed by the State; — the total amount of loans guaranteed by the State in euros; — the sector of activity of the beneficiary companies (via a section of the NAF code).

This dataset includes small business loans or grants issued for emergency COVID-19 financial assistance. Underlying data is provided by the Department of Small Business Services (SBS). Dollar amounts are in actual dollars. This dataset will be refreshed on a quarterly basis.

Context

The Paycheck Protection Program (PPP) was passed by congress to give relief to businesses negatively impacted by Covid-19 in order to maintain pay for employees. The program gives forgivable loans to businesses that continue paying employees during the pandemic. The PPP quickly ran out of funds, limiting which businesses received relief. Some controversy around the program arose from large, publicly traded companies applying for and receiving PPP funds while many small businesses were unable to access relief.

Content

This dataset released by the treasury department on July 6 shows all loans above $150K given through the Paycheck Protection Program.

Acknowledgements

This dataset was posted by GovTrades, a mission-oriented organization working to increase transparency and accountability in policymaking. Check out GovTrades.org for data on stocks that elected officials buy and sell.

Tracking small business loans related to COVID-19.

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

See the Splitgraph documentation for more information.

The number of community banks in the United States has fallen from more than 13,000 in the mid-1980s to less than 5,000 today. These community-focused banks have consolidated mainly as a result of competitive pressures. Research shows that community banks are essential to maintaining economically fruitful communities, and losing these banks could be a significant blow to local infrastructure.

One example of the importance of community banks was their role in distributing Paycheck Protection Program (PPP)1 loans during the Covid-19 pandemic. The PPP was designed to help small businesses keep their workers employed during the pandemic by providing funds through a short-term loan backed by the Small Business Administration (SBA). Preliminary research by CSBS shows that state-chartered banks were the primary distributor of PPP loans, and that community banks played an outsized role in the distribution of PPP funds.

CSBS is providing complete loan-level PPP data [available here (full file, 300MB), here (sample data) and here (data definitions)] that combines the publicly available files made available on sba.gov. To allow for analysis on depository institutions, CSBS will also be adding FDIC Certificate numbers to this file. When the institution is a bank, the FDIC Certificate number will allow participants to link the PPP data to the quarterly Call Report of Income and Condition, which can be accessed here. CSBS is also providing a sample dataset that can be updated and examined in Excel. Questions regarding the data can be sent to data@csbs.org. CERT number is based on originating lender, not servicing lender. Field Name Field Description LoanNumber Loan Number (unique identifier) DateApproved Loan Funded Date SBAOfficeCode SBA Origination Office Code ProcessingMethod Loan Delivery Method (PPP for first draw; PPS for second draw) BorrowerName Borrower Name BorrowerAddress Borrower Street Address BorrowerCity Borrower City BorrowerState Borrower State BorrowerZip Borrower Zip Code LoanStatusDate Loan Status Date - Loan Status Date is blank when the loan is disbursed but not Paid In Full or Charged Off LoanStatus Loan Status Description - Loan Status is replaced by 'Exemption 4' when the loan is disbursed but not Paid in Full or Charged Off Term Loan Maturity in Months SBAGuarantyPercentage SBA Guaranty Percentage InitialApprovalAmount Loan Approval Amount (at origination) CurrentApprovalAmount Loan Approval Amount (current) UndisbursedAmount Undisbursed Amount FranchiseName Franchise Name ServicingLenderLocationID Lender Location ID (unique identifier) ServicingLenderName Servicing Lender Name ServicingLenderAddress Servicing Lender Street Address ServicingLenderCity Servicing Lender City ServicingLenderState Servicing Lender State ServicingLenderZip Servicing Lender Zip Code RuralUrbanIndicator Rural or Urban Indicator (R/U) HubzoneIndicator Hubzone Indicator (Y/N) LMIIndicator LMI Indicator (Y/N) BusinessAgeDescription Business Age Description ProjectCity Project City ProjectCountyName Project County Name ProjectState Project State ProjectZip Project Zip Code CD Project Congressional District JobsReported Number of Employees NAICSCode NAICS 6 digit code Race Borrower Race Description Ethnicity Borrower Ethnicity Description UTILITIES_PROCEED Note: Proceed data is lender reported at origination. On the PPP application the proceeds fields were check boxes. PAYROLL_PROCEED MORTGAGE_INTEREST_PROCEED RENT_PROCEED REFINANCE_EIDL_PROCEED HEALTH_CARE_PROCEED DEBT_INTEREST_PROCEED BusinessType Business Type Description OriginatingLenderLocationID Originating Lender ID (unique identifier) OriginatingLender Originating Lender Name OriginatingLenderCity Originating Lender City OriginatingLenderState Originating Lender State Gender Gender Indicator Veteran Veteran Indicator NonProfit 'Yes' if Business Type = Nonprofit Organization or Nonprofit Childcare Center or 501(c) Nonprofit ForgivenessAmount Forgiveness Amount ForgivenessDate Forgiveness Paid Date CERT Community Bank Flag State vs. National Charter

Source - https://www.csbs.org/

As of July 2020, the New York-Newark-Jersey City metropolitan area had a delinquent retail balance, which equaled to more than *********** U.S. dollars during the COVID-19 pandemic. As for the delinquent retail balance of the Houston-The Woodlands-Sugar Land metropolitan area, it amounted up to only ***** million U.S. dollars during that time period.

Due to the extensive economic disruption caused by the COVID-19 pandemic, the United Kingdom's Government created a range of measures to help support businesses survive the loss in revenues and cashflow. The help smaller businesses (SMEs), the Coronavirus Business Interruption Loan Scheme (CBILS) was set up. The scheme operates through the British Business Bank via more than ** accredited lenders including high street banks, challenger banks, asset based lenders and smaller specialist local lenders. These lenders can then provide up to ************ British pounds (GBP) in the form of term loans, overdraft, invoice finance and asset finance.

Between the **** of May, 2020 and the **** of May, 2021, the cumulative value of lending through the Coronavirus Business Interruption Loan Scheme (CBILS) reached approximately ***** billion British pounds with more than ******* facilities approved.

PPP Loans of over $150k, as reported by SBA as of 6/30/21 Locations were geocoded by LA City Geocoder. Some locations may not have matched. https://www.sba.gov/funding-programs/loans/covid-19-relief-options/paycheck-protection-program/ppp-data

The COVID-19 pandemic had an impact on the financial sector in Colombia. Since the beginning of the isolation period in ************** until September of the same year, a grand total of ***** million credits were granted in the South American country. The vast majority corresponded to credit cards, with approximately *** million. Companies in Colombia received the second largest number of credits during the pandemic.

The Russian government allocated nearly 46 billion Russian rubles from the state's reserve fund to stimulating payments to doctors during the coronavirus (COVID-19) pandemic. Furthermore, over 33 billion Russian rubles were distributed to grants for regions to increase the number of hospital beds.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

In April 2020, due to the coronavirus (COVID-19) outbreak in Poland, the number of clients applying for loans decreased compared to the same period in 2019. At the same time, the number of customers whose loan applications were rejected increased.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Context

During the 2020 COVID-19 crisis, the Trump Administration made available loans intended for small businesses to help keep them afloat, called the Paycheck Protection Program (SBA PPP).

Content

The data contained here outlines all of the loans that were made through this program, including data such as: who received the loan, the amount of the loan, and identifying information about the recipient of the loan.

All 6 files contained herein are of the same Schema, but I kept them as 6 separate .txt files so users can open them in Excel to do visual exploration of the data if needed.

Acknowledgements

Data was made available through FOIA requests, by the Small Business Adminstration