Articles

Projects walkthroughs, tool teardowns, interviews, and more.

  1. How California newsrooms teamed up to gather pandemic data

    By Vignesh Ramachandran

    Posted on

    Data journalists from eight California newsrooms all benefit from a joint data-collection effort. Here’s how the collaboration works to free up more time for local journalism.

  2. The conversations local newsrooms should be having about COVID-19 coverage

    By Ryan Pitts

    Posted on

    We spent August and September in conversation with local journalists covering COVID-19, asking what they need most

  3. Meet the Baconator

    By Frank Sharpe

    Posted on

    How ProPublica developed a caching technique that isn’t exactly a static site generator but retains many of the benefits of one, allowing them to retain the CMS workflows they love.

  4. Watch Parties: Reaching New Audiences, and a New Place of Vulnerability

    By Sisi Wei

    Posted on

    How we planned and ran the SRCCON 2020 Watch Parties

  5. COVID-19 story recipe: A dashboard with at-risk health indicators

    By Dana Amihere, Alexandra Kanik, Lisa Pickoff-White, and Emily Zentner

    Posted 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.

  6. Introducing ‘Leavers’: results from a survey of 101 former journalists of color

    By Carla Murphy

    Posted on

    For the first time in 50 years, Black and other journalists of color (JOC) are waging a public campaign to air newsroom grievances. How do we move away from 50 years of lip service to sustained newsroom diversity? This survey points the way.

  7. Tell us what you need to cover COVID-19

    By Ryan Pitts

    Posted on

    For the next several months, OpenNews and Big Local News will work with local journalists to develop resources their newsrooms can use to better cover COVID-19. What should that support look like? We don’t know yet! But you can help us figure it out.

  8. Don’t panic. Collaborate.

    By Sarah Alvarez, Garance Burke, Matt Kiefer, and Michael Morisy

    Posted on

    The Covid Public Info project launched this spring, and has alreadycollected input from thousands of individual community members, filed hundreds of public records requests, and compared notes with dozens of journalists. Here are some highlights of what we’ve learned so far, and ways for you to get involved.

  9. Memberkit 1.0: Upgrade your analytics and build a data-powered membership program

    By Brian Boyer

    Posted on

    A field-tested set of reports, patterns, and techniques that can help your newsroom think about how to execute a data-driven strategy for membership.

  10. COVID-19 story recipe: Analyzing disparate impact based on race, poverty, and vulnerability in your area

    By Hannah Recht

    Posted 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.

  11. A comparison of four major COVID-19 data sources

    By Irena Fischer-Hwang and Justin Mayo

    Posted 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.

  12. COVID-19 story recipe: Using AHA data to analyze hospital bed capacity

    By Dilcia Mercedes

    Posted 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.

  13. COVID-19 story recipe: Identifying communities at risk from the pandemic and its economic fallout

    By Jayme Fraser

    Posted 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.

  14. How to make sense of all the COVID-19 datasets right now

    By Sinduja Rangarajan

    Posted 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.

  15. COVID-19 story recipe: How to see what stocks members of Congress are dumping (or buying)

    By Derek Willis

    Posted 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.

  16. Newsroom Execs and Managers: Ways to Uphold Your Diversity and Inclusivity Values During COVID-19

    By Sisi Wei

    Posted on

    Our values are even more important during a crisis. Here are a few practical strategies for thinking through tough decisions in an equitable and inclusive way.

  17. How we used Google sheets to build a fully-working newsgame prototype

    By Robin Kwong and Cale Tilford

    Posted on

    As the Financial Times developed a newsgame for a series on companies that pursue profit with purpose, Google sheets gave them a way to quickly generate a playable, shareable prototype. Here’s how they did it and what they learned.

  18. COVID-19 story recipe: How to analyze your region’s hospital capacity

    By Erin Petenko

    Posted 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.

  19. COVID-19 story recipe: Analyzing nursing home data for infection-control problems

    By Mike Stucka

    Posted 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.

  20. Event Roundup, March 2

    By Erika Owens

    Posted on

    It’s NICAR this week!

Current page