RESOURCES FOR TRACKING COVID STIMULUS FUNDS

 

GOVERNMENT DATABASES AND RESOURCES

U.S. Department of the Treasury, SBA Paycheck Protection Program loan level data

U.S. Small Business Administration, open data sources and frequently requested records, including Section 7(a) loan data that is similar to data collected in the Paycheck Protection Program

North America Industry Classification System, NAICS/SIC search, lists specific industry codes that appear in Small Business Administration and other databases. A downloadable list of all NAICS codes is available from the U.S. Census Bureau here.

EDGAR, U.S. Securities and Exchange Commission, fillings by public companies

Congressional Research Service,  “COVID-19: Resources for Tracking Federal Spending,”   including the USASpending.gov database of federal contract and grant awards and other federal spending at the state, congressional district, and local level, which has tools to search and display COVID-19 spending data.

U.S. Department of Labor, Employment and Training Administration, unemployment insurance data, with state-level data going back 30 years

U.S. Bureau of Labor Statistics, local area unemployment statistics

Congressional Oversight Commission tracks COVID-19 relief money.

Congressional Select Subcommittee on the Coronavirus Crisis, Preliminary Analysis of Paycheck Protection Program Data

Pandemic Response Accountability Committee has a dashboard that shows the totality of CARES Act spending, as well as data on federal contracts related to COVID-19, localized to the state and county level

 

PRIVATE DATABASES AND TRACKERS

Good Jobs First, COVID stimulus watch, assembles CARES Act recipient data and combines it with information about each firm’s history of regulatory violations, previous government assistance, federal tax avoidance, and CEO and worker pay practices. In addition, violation tracker covers corporate and regulatory misconduct

Opportunity Insights, economic tracker, complies data on consumer spending, employment, small business revenue, and other indicators, by national, state, county and metro area. Project by Harvard University Professor of Public Economics Raj Chetty, Raj Chetty, John N. Friedman, Nathaniel Hendren, Michael Stepner. (See accompanying paper below.)

Project On Government Oversight, article on resources on oversight provisions in the CARES Act and a handout on similar resources

Project On Government Oversight, COVID Tracker covers federal stimulus spending, including grants, loans and contracts

ProPublica, coronavirus contracts, tracks federal purchases to fight coronavirus

Committee for a Responsible Federal Budget, COVID money tracker, wide-ranging data and information on coronavirus response

Rockefeller Institute of Government, COVID-19 state relief dashboard

Just Capital,  COVID-19 corporate response tracker,  tracks how corporations are responding to coronavirus

Google Database, various data sources, including coronavirus related datasets

 

DOCUMENTS AND WHITE PAPERS

FOIA lawsuit” Washington Post and other news organizations lawsuit against the U.S. Small Business Administration

Did the Paycheck Protection Program Hit the Target?” João Granja, Christos Makridis, Constantine Yannelis, and Eric Zwick, the National Bureau of Economic Research working paper, July 2020

How Did COVID-19 and Stabilization Policies Affect Spending and Employment? A New Real-Time Economic Tracker Based on Private Sector Data,” Opportunity Insights, Raj Chetty, John N. Friedman, Nathaniel Hendren, Michael Stepner, and the Opportunity Insights team, June 2020

 

RESOURCES ON STATE RESPONSES TO PANDEMIC

U.S. Department of the Treasury, CARES Act payments for state, local and tribal governments

National Conference of State Legislatures, data on bills related to and responding to COVID-19 that have been introduced in the 50 states and the District of Columbia

Pew Charitable Trusts, resources on how state governments are responding to the economic shock of coronavirus

 

VIDEO TUTORIALS AND TRAININGS ON HOW TO USE DATA ANALYSIS TOOLS

 

Tableau

NICAR, short video tutorials on Tableau, including intro to Tableau, joining data, pivoting data, filtering data, etc.

Tableau

Data Literacy, walkthrough on Tableau for journalists, USC Annenberg, 2019

 

Python

NICAR, Python intro tutorials based on short videos

Data Journalism,  Python tutorial

Little Columns, intro to Python, Jonathan Soma, Columbia University

Stack Overflow, lists coding related questions and answers. Users can post questions and search questions that have already been answered by its open community.

 

BOOKS ON DATA TOOLS

Data Wrangling with Python: Tips and Tools to Make Your Life Easier,” Jacqueline Kazil and Katharine Jarmul, February 2016

The Investigative Reporter’s Handbook: A Guild to Documents, Databases and Techniques,” Mark Horvit, Brant Houston and Investigative Reporters and Editors, June 2020