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

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.

SBA Coronavirus (COVID-19) Relief Options: Paycheck Protection Program (PPP) Report and Data

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in Connecticut that received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient. This dataset includes loans under $150,000 and loans of $150,000 and above made to Connecticut businesses through August 8, 2020. Please see attached document for more details.

This dataset features PPP loan data distributed across the City of Los Angeles as of January 25, 2022. Data comes from SBA.gov.

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in Utah who received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient.

This dataset is published by the Atlanta Regional Commission Research & Analytics group to show Paycheck Protection Program Loans for Georgia summarized by ZIP Code. Source: US Department of Treasuryhttps://home.treasury.gov/policy-issues/cares-act/assistance-for-small-businesses/sba-paycheck-protection-program-loan-level-data

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

Dataset

This dataset was created by Ross Warren

Contents

Paycheck Protection Program loans are SBA loans that helps businesses keep their workforce employed during the Coronavirus (COVID-19) crisis, specific to Colorado. Includes < $150,000 loans and > $150,000 loans. Current law dictates that the Paycheck Protection Program (PPP) close at the end of August 8, 2020.

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in New Jersey who received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient.

Note: As per SBA, The Paycheck Protection Program (PPP) ended on May 31, 2021 so no updates has been made on this dataset.

Please see attached document on landing page for more details.

Aggregated Paycheck Protection Program (PPP) Loan Data

  Aggregated Paycheck Protection Program (PPP) Loan Data 
  Geography Level: State, CountyItem Vintage: Not Available
  Update Frequency: UnknownAgency: SBAAvailable File Type: Excel with website link 

  Return to Other Federal Agency Datasets Page

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

SBA Coronavirus (COVID-19) Relief Options: Paycheck Protection Program (PPP) Report (Approvals through 05-23-2020)

SBA Coronavirus (COVID-19) Relief Options: Paycheck Protection Program (PPP) Report (Approvals through 01-24-2020)

Analysis of ‘PPP Loans to Connecticut Businesses’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/260801af-02b7-4cd3-b864-ab8717b60a23 on 28 January 2022.

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

The Paycheck Protection Program (PPP) loans provide small businesses with the resources they need to maintain their payroll, hire back employees who may have been laid off, and cover applicable overhead. This data set includes businesses in Connecticut that received PPP funding, how much funding the employer received & how many jobs the employer claims they saved. The NAICS (National Industry Classification) was provided by the loan recipient.

This dataset includes loans under $150,000 and loans of $150,000 and above made to Connecticut businesses through August 8, 2020.

Please see attached document for more details.

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

The extract lists Paycheck Protection Program (PPP) loans across North Carolina from April through August 2020. The data is based on information submitted by lenders to the Small Businesses Administration (SBA). Data is available for the aforementioned period in two separate categories of loans: those under and above $150,000. The temporal resolution is daily and the spatial resolution is at the zip code level.

In response to the COVID-19 crisis, the Board's emergency lending facilities have provided a critical backstop. The Board launched a centralized 13(3) Lending Facilities Data Repository on November 6, 2020 to bring together the emergency lending facilities data from different systems and databases. Data from the Paycheck Protection Program Lending Facility (PPPLF) is now available in the repository. The Paycheck Protection Program is a loan designed to provide a direct incentive for small businesses to keep their workers on the payroll. The Small Business Administration (SBA) will forgive loans if all employee retention criteria are met, and the funds are used for eligible expenses. To bolster the effectiveness of the Small Business Administration's Paycheck Protection Program (PPP), the Federal Reserve is supplying liquidity to participating financial institutions through term financing backed by PPP loans to small businesses. The Paycheck Protection Program Liquidity Facility (PPPLF) will extend credit to eligible financial institutions that originate PPP loans, taking the loans as collateral at face value. The Federal Reserve Board ceased extending loans on July 30, 2021.

United States SBP: IF: Received Fin Assistance: PPP Loan Forgiveness data was reported at 46.800 % in 10 Jan 2022. This records an increase from the previous number of 43.800 % for 03 Jan 2022. United States SBP: IF: Received Fin Assistance: PPP Loan Forgiveness data is updated weekly, averaging 33.200 % from Feb 2021 (Median) to 10 Jan 2022, with 36 observations. The data reached an all-time high of 47.100 % in 20 Dec 2021 and a record low of 11.100 % in 01 Mar 2021. United States SBP: IF: Received Fin Assistance: PPP Loan Forgiveness data remains active status in CEIC and is reported by U.S. Census Bureau. The data is categorized under Global Database’s United States – Table US.S045: Small Business Pulse Survey: by Sector: Weekly. Beg Monday (Discontinued).

Context

Created under the Cares Act as a response to COVID economic disruption, the Paycheck Protection Program (PPP) offered emergency loans to small businesses in the United States with the goal of reducing job losses. To promote the program, borrowers may be eligible for loan forgiveness if at least 60% of the loan proceeds were used to pay workers.

Content

There are 3 data files:

• ppp_loan_data.cvs: In addition to the loan amount (in U.S. dollars), the data file contains loan-level demographic information on the loans originated under the PPP program. Geographic fields include state, city, U.S. Congressional District, and zip code. It also includes business ownership type and a detailed NAICS code indicating the borrower's type of business, originating bank, and some borrower characteristics.

• naics_6.csv: this file contains industry names to accompany the NAICS code in the data file

• zip_county_crosswalk.cvs: this file maps zip codes to U.S. counties for anyone interested in incorporating additional demographic, economic, or other data of interest.

Acknowledgements

This data comes from the U.S. Small Business Administration (https://www.sba.gov/funding-programs/loans/coronavirus-relief-options/paycheck-protection-program).