NICAR15: 10 tips to avoid data mistakes in the newsroom

A big mistake when dealing with data can ruin your day. Luckily there are simple ways to avoid big mistakes and maintain credibility with your colleagues and your audience.

At NICAR 2015, a panel of data journalists from The New York Times, Wall Street Journal and Atlanta Journal-Constitution discussed the road blocks they've encountered when working with data for a story. The panel, moderated by MedPage Today reporter Coulter Jones, featured advice and cautions to keep in mind when dealing with numbers, editors  and deadline pressure in the newsroom.

1. Understand how people use the data

If you don’t understand how people use the data, you shouldn’t use the data. Especially on deadline. Sarah Cohen, editor of The New York Times' computer-assisted reporting team, said the first thing she does is talk to someone who's familiar with the data. This way, she won't misinterpret what it shows. "We have to be versatile," she said. "Otherwise we risk falling into the trap that all data is a story."

2. Avoid any superlative word ever

Factual errors aren't acceptable, and if you use a word like "first," "highest," "most," you'll probably be incorrect, Cohen said. She advised the audience to use words like "maybe the first" and  "among the highest." And same thing goes for proving a negative. If you say an agency doesn’t do something, you’re going to find out the next day they do.

3. Reread sentences in a random order

Rob Barry, a Wall Street Journal reporter, said he has a friend who randomizes the order of all the sentences in a story when he reviews them. This way, the friend doesn't fall into the trap of missing mistakes because they sound so familiar in the text. Errors are therefore more noticeable.

4. Color-code the story

In addition to reading the story in a randomized order, Cohen suggests reading the story from end to beginning. Or, you can color-code the story: a different color for summaries and facts. Take a look at them again: are they accurate?

5. Watch it like a hawk...

...Through the editorial process. Editors will push you to make conclusive statements, and you've got to fight back. John Perry, a journalist at The Atlanta Journal-Constitution, advised the audience to make sure that editors don't oversell what the data actually says.

6. Don't rerun the code. Rewrite it.

You can certainly rerun the code to see if it produces the same results for your data. But even if the data results match up, the conclusion could still be inaccurate if the code you used was faulty. So don't just rerun the code. Rewrite the code instead, and make sure you can produce the same results as before.

7. Keep a diary

Cohen keeps a record of everything she does or tries to do with the data. Because these stories can take months to work on, a diary helps her use her time more efficiently and recall what worked and didn't work.

8. Keep one team member in the dark

This way they won't be biased towards the data. Before publishing, see if they can produce the same results.

9. Don't have multiple versions of the data

This could mean you'll need to share the files through Dropbox, or a similar platform. Inevitably, your colleagues will save the data to their computer. Avoid mistakes by avoiding multiple versions of the data, and make sure there's always an original file you can go back to.

10. Slow it down

One of the biggest enemies to data reporting is speed. "The biggest mistakes I’ve made in my career have always been because of a short deadline, trying to do something quickly," Perry said. You simply have to slow it down to get it right.

About the author

Mallory Busch

Undergraduate Fellow

Latest Posts

  • A Big Change That Will Probably Affect Your Storymaps

    A big change is coming to StoryMapJS, and it will affect many, if not most existing storymaps. When making a storymap, one way to set a style and tone for your project is to set the "map type," also known as the "basemap." When we launched StoryMapJS, it included options for a few basemaps created by Stamen Design. These included the "watercolor" style, as well as the default style for new storymaps, "Toner Lite." Stamen...

    Continue Reading

  • Introducing AmyJo Brown, Knight Lab Professional Fellow

    AmyJo Brown, a veteran journalist passionate about supporting and reshaping local political journalism and who it engages, has joined the Knight Lab as a 2022-2023 professional fellow. Her focus is on building The Public Ledger, a data tool structured from local campaign finance data that is designed to track connections and make local political relationships – and their influence – more visible. “Campaign finance data has more stories to tell – if we follow the...

    Continue Reading

  • Interactive Entertainment: How UX Design Shapes Streaming Platforms

    As streaming develops into the latest age of entertainment, how are interfaces and layouts being designed to prioritize user experience and accessibility? The Covid-19 pandemic accelerated streaming services becoming the dominant form of entertainment. There are a handful of new platforms, each with thousands of hours of content, but not much change or differentiation in the user journeys. For the most part, everywhere from Netflix to illegal streaming platforms use similar video streaming UX standards, and...

    Continue Reading

  • Innovation with collaborationExperimenting with AI and investigative journalism in the Americas.

    Lee este artículo en español. How might we use AI technologies to innovate newsgathering and investigative reporting techniques? This was the question we posed to a group of seven newsrooms in Latin America and the US as part of the Americas Cohort during the 2021 JournalismAI Collab Challenges. The Collab is an initiative that brings together media organizations to experiment with AI technologies and journalism. This year,  JournalismAI, a project of Polis, the journalism think-tank at...

    Continue Reading

  • Innovación con colaboraciónCuando el periodismo de investigación experimenta con inteligencia artificial.

    Read this article in English. ¿Cómo podemos usar la inteligencia artificial para innovar las técnicas de reporteo y de periodismo de investigación? Esta es la pregunta que convocó a un grupo de siete organizaciones periodísticas en América Latina y Estados Unidos, el grupo de las Américas del 2021 JournalismAI Collab Challenges. Esta iniciativa de colaboración reúne a medios para experimentar con inteligencia artificial y periodismo. Este año, JournalismAI, un proyecto de Polis, la think-tank de periodismo...

    Continue Reading

  • AI, Automation, and Newsrooms: Finding Fitting Tools for Your Organization

    If you’d like to use technology to make your newsroom more efficient, you’ve come to the right place. Tools exist that can help you find news, manage your work in progress, and distribute your content more effectively than ever before, and we’re here to help you find the ones that are right for you. As part of the Knight Foundation’s AI for Local News program, we worked with the Associated Press to interview dozens of......

    Continue Reading

Storytelling Tools

We build easy-to-use tools that can help you tell better stories.

View More