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.

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/

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.

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).

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

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.

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

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.

SBA Coronavirus (COVID-19) Relief Options: Economic Injury Disaster Loan (EIDL) Loans Report

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.

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.

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.

Survey data are sourced from the recipients of 10 emergency grant and loan initiatives offered by Carolina Small Business Development Fund (CSBDF) to qualifying small business owners across North Carolina between February 2020 and February 2022. This includes 1 loan and 1 grant program offered by CSBDF with its own funds as well as 4 loan and 4 grant programs administered via partnerships across the public and philanthropic sector. In total 1,304 unique firms received 1,410 grants and loan interventions during the study period. A total of 570 responses were received, inclusive of 487 full and 83 partially complete surveys. The survey includes grantees from the (1) State of North Carolina's Historically Underutilized Business (HUB) Office ReToolNC Program, (2) the City of Raleigh COVID-19 Relief Fund, (3) the City of Durham and Durham County's Recovery Grant Program, (4) the NC IDEA Foundation's Northeastern Rural North Carolina Grant Initiative, and (5) CSBDF's Borrower Grant Program. Additionally, loan recipients were surveyed from the following emergency financing facilities: (1) Mecklenburg County's COVID-19 Fund and its subsequent iteration the (2) MeckLending Loan Program, (3) Golden LEAF's North Carolina Rapid Recovery Program, (4) the City of Durham's Recovery Loan Program, and (5) financing offered by CBSDF from its revolving loan capital during the study period.

This dataset combines all Spanish micro, small and medium firms that received ICO (Instituto de Crédito Oficial) guaranteed loans in 2020–2021 with a matched sample of non-treated peers drawn from the same NUTS-3 region and NACE Rev. 2 four-digit industry. Each firm-year record includes, treatment amount and first-treatment year, plus operational and financial metrics—employees , turnover, total assets, and interest-coverage ratio (ICR)— from 2017 to 2022. Structured as an unbalanced panel, it lets you compare how employment and turnover evolve for ICO COVID-19 supported firms versus matched controls.

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

Summary data for weekly applications received