NPF Guide to Tracking COVID Cash
Investigative and Data Journalism Tips for Following the Pandemic Stimulus Money
NPF has published a guidebook to help journalists track taxpayer spending on pandemic relief. It includes useful databases, videos on how to use Excel, Python and other data tools and pro tips from leading investigative journalists.
Using Excel to Drill Into PPP Data
A Step-By-Step Guide to Analyzing COVID-19 PPP Data by State
Excel tips: How to use pivot tables, filters and the VLOOKUP function to zero in on COVID small business relief loans in your state.
COVID Cash and the Debt
What the huge infusion of federal money means for the nation’s long-term fiscal health.
The federal government has committed trillions to prop up the economy. How – and when – will it eventually pay for it?
A New Tool for Tracking COVID Cash
Volunteer Data Scientists Create Tool for Journalists
A group of data scientist volunteers has produced a new set of databases designed to make it easier for journalists to track federal pandemic stimulus funding.
Are Trade Wars Class Wars?
Inequality Within Countries Pits Worker Against Worker
Working class incomes have stagnated around the world as elites' wealth has increased. The winner of the U.S.-China trade war has been Wall Street. Two experts brief journalists on the connection between domestic inequality and trade conflicts.
Three Tools for Tracking COVID Cash
Updated tools to help reporters follow the pandemic stimulus money.
Millions of small and large businesses received COVID-fueled contracts and bailouts. Experts detail how to use three tracking tools to see who those companies are.
Tracking the People Receiving Loans
Top Investigative Reporters Offer Tips and Strategy on Backgrounding Businesses
The U.S. government has pushed out nearly 5 million small business loans. Learn how to find more about them.
Documenting Federal COVID Contracts
ProPublica Dashboard on Federal Contracts Helps Reporters Probe Coronavirus Spending
A data journalist details how he built a dashboard of every COVID-related government contract.
How Lobbying Shaped the CARES Act
Lobbyists Joust for Federal COVID Stimulus Funds
How journalists covering pandemic relief funds can use congressional disclosures to track lobbying and potential corruption.
Data Visualizations with Tableau
How to Create Smart Visualizations of COVID Loan Data
A data visualization expert on the Tableau platform offers tips on how to make numbers come alive for stories.
Who Got the COVID Cash
Where to Find Macro and Micro Data on the Government’s Coronavirus Stimulus Spending
The federal government has committed more than $4 trillion to prop up the economy. Here’s how to find out where it went.
Understanding the Jobs Report
Using BEA Data
Bureau of Economic Analysis Offers Insight on Nation, States
Federal agency allows reporters to track gross domestic product on the state level.
Mining Employment Data
Bureau of Labor Statistics Offers National, Local Focus
More than monthly jobs numbers, the Bureau of Labor Statistics tracks consumer spending, inflation and other vital data.
A Bird’s Eye View of Global Business
Six Decades of Asian Business Acumen
Merle Hinrich created a multinational company whose growth tracked the arc of modern global trade.
Intellectual Property and Trade
Enforcing Intellectual Property Rights in World Trade
What should happen when one country uses another's patented technology?
When Politics and Trade Collide
How American Politics Affects World Trade
Donald Trump's trade war with China is based on the politics of his supporters - just as China's response is based on its goals.
Reporting on Regional Trade
How Mid-Sized Countries Navigate World Trading System
Living in the shadow of the U.S.-China relationship can be tricky for smaller nations.
Career US Diplomat Talks Trade
Consul General for Hong Kong on Shifting Trade Winds
Long-term goals remain the same; what has changed is Trump's strategy.
Making Trade Come Alive for Readers
Reporters in Asia Talk Trade
It can be tricky to cover, but international trade is vital for readers to understand.
An Inside Look at Container Shipping
Hong Kong is the Seventh Largest Port in the World
Reporters learn about trade and the shipping industry via one Hong Kong company.
The American Perspective in Hong Kong
How the Chamber Sees the Trade War
American business interests are watching the Trump-China trade war warily.
Documenting Global Trade with Data
How Journalists Can Get a Handle on Trade
Numbers explaining imports and exports are widely available, if journalists know where to look.
Weapons in the Trade War
Trade Disputes Play Out In the Details of Federal Regulations
How so-called “Section 301” cases are used in the U.S. trade war with China.Weapons
China and the WTO
How China Has Fared in the WTO
Since its entry in 2001, China has become a major – and controversial – presence in the World Trade Organization.
The Belt and Road Initiative
How China’s Belt and Road Initiative Could Change World Trading
Going back to historical trading routes could be a boon for China – as well as other nations in the region.
China’s View on Trump and Trade
As Trump Tweets on Trade, Chinese Leaders Push Back
President Donald Trump is very open about his views on China and trade. How do leaders in Beijing see him in return?
Trade War Impacts
Assessing Impact of China, US Trade Battle
Tariff skirmishes between the U.S. and China are already being felt in those countries and beyond.
Understanding Global Value Chains
Companies Supply Their Goods From Around the Globe
The cross-border nature of modern manufacturing shows why a trade war can be widely disruptive.
Backdrop of the U.S.-China Trade Dispute
Fundamental Differences Between Economic Models
Decades of global trade practices have been upended by China and its state-directed economy.
Resources at the Fed
Federal Reserve Offers Range of Resources and Data
The Fed is more than just the body that sets interest rates.
Adapting Ag in a Changing Climate
Growing Seasons are Different; Crops Need to be as Well
Scientists are working to develop new varieties of major crops that can thrive in drier environments.
Using the Blockchain for Agriculture
Blockchain Technology Has the Potential to Revolutionize Ag Sector
By recording the steps in the food-supply chain, producers, regulators and consumers could better know where their food came from – and whether it is safe.
Trump Tariffs Roil Farmers
How Ag Tariffs Could Impact the Mid-Term Elections
The Farm Belt delivered for Trump in 2016. How will his ag tariffs play out in 2018?
Case Study: Tariffs and Automobiles
How Tariffs Could Affect Car Prices and Jobs
Auto sector pushes back on the threat of 25 percent tariffs.
Covering International Trade
Top Reporters Share Their Tips on Covering the Complexities of Trade
Trade is often numbers heavy and dry here’s how some journalists make it come alive.
Big Business and Trade Worries
Corporate America is Worried – and Pushing Back – on Trump Trade Actions
The view from the boardroom is that global trade has been beneficial for U.S. companies, so ramping up tariffs represents a big threat to business bottom line.
Understanding the WTO and Brexit
Are Trump’s Trade Actions Consistent with International Law?
A law professor and expert on international trade agreements says that some of the actions in the Trump administration’s trade war don’t follow international law.
Understanding NAFTA
The Agreement Is About More Than Free Trade
As renegotiations of the North American Free Trade Agreement heat up, where should journalists look for stories?
How Trade Actions Unfold
The Process for Engaging in a Trade War Involves Complaints at Different U.S. Agencies
‘Dumping,’ ‘countervailing duties,’ ‘tariffs’ – all buzz words in the enforcement of international trade. An expert decribes what they mean.
