Projects walkthroughs, tool teardowns, interviews, and more.
Articles tagged: story recipe
Magic spreadsheets to help you investigate neighborhood inequities
By Leon YinPosted on
Here’s how to use these tools and techniques to bring “receipts from streets” with little-to-no code.
Story recipe: U.S. schools restrain and seclude students thousands of times per school day—how often where you live?
By Emilie Munson, Ying Zhao, and Matt RocheleauPosted on
Where to find the data, how to explore it, and questions to ask to report the story for your community.
Story Recipe: Using Census migration data to find out where young adults are moving
By Brent Jones and Eric SchmidPosted on
Our reporting found that people who grow up in St. Louis tend to stay in St. Louis: About 3 out of 4 young adults who were here at age 16 were also here at age 26. Here’s how you can use federal data to see where people are moving to and from in your area.
Story Recipe: Exploring Census microdata about your countyPosted on
We recently received a request from a resident in Lincoln County, asking for assistance in locating data related to digital inclusion, in order to help enroll residents who qualify for the FCC Emergency Broadband Benefit. Information that can answer this question is collected by the U.S. Census Bureau’s American Community Survey—the summary tables provide details on household computer availability and internet subscriptions, poverty status at various levels of the federal poverty line, and SNAP receipt. What the tables don’t provide is the intersection of these characteristics. To answer this, we need the microdata or individual record data. Here’s how we went about answering this question.
COVID-19 story recipe: Analyze school enrollment changes in the districts you coverPosted on
The Stanford School Enrollment Project is a collaborative project that collects and normalizes school enrollment data from dozens of states, creating a dataset that didn’t exist before. Here’s how you can use the data to report on your community.
Story Recipe: Checking The Success Of Your State’s Efforts To Restore Voting Rights To The Formerly IncarceratedPosted on
We learned that no more than 1 in 4 formerly incarcerated voters had registered to vote in the 2020 election in four key states. We’ve documented our reporting process so you can use it in your state.
COVID-19 story recipe: A dashboard with at-risk health indicatorsPosted on
We teamed up to build a dashboard that shows two kinds of data: how widespread COVID–19 is in a community, alongside health indicators that show how some people are more at risk. We’ve open-sourced the project so you can use it too.
COVID-19 story recipe: Analyzing disparate impact based on race, poverty, and vulnerability in your area
By Hannah RechtPosted on
As new COVID-19 hot spots popped up across the country and states began to release data by race and ethnicity, the team at Kaiser Health News reported on why the illness was striking Black, Hispanic, and Native Americans so intensely. Here’s how you can use the data to report on your community.
A comparison of four major COVID-19 data sources
By Irena Fischer-Hwang and Justin MayoPosted on
A variety of datasets can help journalists track the spread of COVID-19. But which should you rely on? What’s the difference between them? What are the advantages and disadvantages to each? This guide will walk you through four major COVID-19 data sources: Johns Hopkins University, COVID Tracking Project, USAFacts, and The New York Times.
COVID-19 story recipe: Using AHA data to analyze hospital bed capacityPosted on
American Hospital Association data can help you estimate the total number of beds your region could need to treat patients in a COVID-19 outbreak, and how many beds are likely to be available based on expected usage patterns. Here’s how you can use the data to report on your community.
COVID-19 story recipe: Identifying communities at risk from the pandemic and its economic fallout
By Jayme FraserPosted on
Using data from the CDC and the federal Health Resources & Services Administration, USA Today found counties that are both medically underserved and vulnerable to disasters—places where residents would be most at risk of losing access to health care during the COVID-19 outbreak. Here’s how you can use the data to report on your community.
How to make sense of all the COVID-19 datasets right nowPosted on
There are a lot of COVID-19 datasets available, and it can be hard to know how they differ and which ones are most trustworthy. Here’s an overview of current datasets that journalists can rely on for stories.
COVID-19 story recipe: How to see what stocks members of Congress are dumping (or buying)
By Derek WillisPosted on
ProPublica used the Senate’s financial disclosures to find that not long after Sen. Richard Burr offered a positive assessment in public of the country’s ability to handle the coronavirus, he sold hundreds of thousands of (and potentially up to $1.7 million) dollars in stocks, a highly unusual series of trades for him. Here’s how you can reproduce the story for your community.
COVID-19 story recipe: How to analyze your region’s hospital capacity
By Erin PetenkoPosted on
VTDigger used Harvard Global Health Institute data to look into local hospitals’ capacity for handling an outbreak. Here’s how you can reproduce the story for your community.
COVID-19 story recipe: Analyzing nursing home data for infection-control problems
By Mike StuckaPosted on
A USA Today analysis found that three-quarters of nursing homes have been cited for infection-control problems in recent years. Here’s how you can reproduce the story for your community.