Stanford Digital Repository

Geocoded loan data from the Paycheck Protection Program 2020 (PPP) by Reveal from the Center for Investigative Reporting

Placeholder Show Content

Abstract/Contents

Abstract
The federal Paycheck Protection Program (PPP), one of the largest financial bailouts since the Great Depression, injected billions of dollars into small businesses in 2020. Reveal from The Center for Investigative Reporting performed a geospatial analysis on 5.2 million loans from the first two rounds of PPP lending. The analysis showed stark disparities in recipients across the country
Data includes 1) geocoded information for every PPP loan in the first two rounds of the program, 2) demographic information for each census tract in the United States and Puerto Rico, along with demographic information for Guam, the Commonwealth of the Northern Mariana Islands, and the Virgin Islands , and 3) loan and business tabulations of selected large metros.
Reveal used the Big Local News platform to distribute their data. Stanford’s Big Local News platform is designed for journalists to share data and collaborate on projects. Journalists can log in to create their own projects and access data in Open Projects available to all platform users. The Data Archive contains publicly available data that has been preserved by Stanford Libraries.
Please see the README file for more information about the data collection and data analysis.

Description

Type of resource text, moving image
Place Stanford (Calif.)
Publisher Big Local News
Date created 2020 - 2021
Publication date May 1, 2021
Language English

Creators/Contributors

Data manager Oh, Soo
Analyst Al Elew, Mohamed
Publisher Reveal/Center for Investigative Reporting

Subjects

Subject Business
Subject Government
Subject Census Bureau
Subject COVID-19 Pandemic, 2020-
Subject United States
Subject Paycheck Protection Program (PPP)
Subject Big Local News
Subject 2020
Genre Dataset
Genre Tables (data)
Genre Geospatial data
Genre Statistics
Genre Census data

Bibliographic information

Note Citation for initial Reveal article: Morel, Laura C., Mohamed Al ELew, and Emily Harris. “Hundreds of Billions of Dollars in PPP Loans Marred by Racial Inequity.” Reveal. May 1, 2021. https://revealnews.org/article/rampant-racial-disparities-plagued-how-billions-of-dollars-in-ppp-loans-were-distributed-in-the-u-s/.
Note This story was produced with the support of the John S. Knight Journalism Fellowships and Big Local News at Stanford University.
Stories
Title
Big Local News
Abstract
Big Local News platform where the data files were hosted for analysis.
Title
Rampant racial disparities plagued how billions of dollars in PPP loans were distributed in the U.S.
Title
Which neighborhoods were neglected by the Paycheck Protection Program?
Title
Banking on inequity
Files
Title
ReportingNetworksSlides.pdf
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
ReportingNetworksWebinar_PPP.mp4
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
RevealOfficeHour.mp4
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
datasette_tutorial_ppp.mp4
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
datasette_tutorial_ppp.pdf
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
hud_tos_license.pdf
Abstract
These files are instruction/tutorial files showing users how to interact with the data and what some of the pitfalls are.
Title
ppp_census_tracts.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_data_dictionary.xlsx
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_12060_atlanta_sandy_springs_alpharetta_ga.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_29820_las_vegas_henderson_paradise_nv.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_12420_austin_round_rock_georgetown_tx.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_12580_baltimore_columbia_towson_md.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_16980_chicago_naperville_elgin_il_in_wi.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_19100_dallas_fort_worth_arlington_tx.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_19820_detroit_warren_dearborn_mi.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_26420_houston_the_woodlands_sugar_land_tx.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_31080_los_angeles_long_beach_anaheim_ca.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_32820_memphis_tn_ms_ar.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_33100_miami_fort_lauderdale_pompano_beach_fl.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_35620_new_york_newark_jersey_city_ny_nj_pa.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_38060_phoenix_mesa_chandler_az.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_40140_riverside_san_bernardino_ontario_ca.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_41180_st_louis_mo_il.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_41700_san_antonio_new_braunfels_tx.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_41740_san_diego_chula_vista_carlsbad_ca.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_41860_san_francisco_oakland_berkeley_ca.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_41940_san_jose_sunnyvale_santa_clara_ca.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_47260_virginia_beach_norfolk_newport_news_va_nc.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_lenders_47900_washington_arlington_alexandria_dc_va_md_wv.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_loans_geocoded.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_msa_performance.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
ppp_territories.csv
Abstract
These files contain the data, a data dictionary file for understanding the contents of certain columns, and a readme file.
Title
readme.md
Abstract
readme file in markdown format
Title
readme.pdf
Abstract
readme file as a pdf
Location https://purl.stanford.edu/cn690cd8420
Repository Stanford Digital Repository

Access conditions

Use and reproduction
User agrees that, where applicable, content will not be used to infringe the privacy or confidentiality rights of individuals. Content distributed via the Stanford Digital Repository may be subject to additional license and use restrictions applied by the depositor.
License
This work is licensed under an Open Data Commons Attribution License v1.0.

Preferred citation

Oh, Soo et al. (2021-05-01) Geocoded loan data from the Paycheck Protection Program 2020 (PPP) by Reveal from the Center for Investigative Reporting. Stanford Digital Repository. Available at: http://purl.stanford.edu/cn690cd8420

Collection

Big Local News

View other items in this collection in SearchWorks

Contact information

datateam@revealnews.org

Also listed in

View in SearchWorks

Loading usage metrics...