An inside look at The Guardian's effort to document deaths at the hands of law enforcement in "The Counted"

The Guardian's "The Counted" documents law enforcement killings in the United States.

On Nov. 15, Richard Perkins was fatally shot by officers in Oakland, California. His death marked the 1,000th entry in The Guardian’s The Counted’s database that now includes more than 1,063 names.

The project launched June 1, and has quickly won acclaim for its relatively robust law enforcement killings database, which is generated via tips submitted on the Guardian website or on social media. In fact, in October, James Comey, the director of the Federal Bureau of Investigation, called it “ridiculous [and] embarrassing” that the Guardian U.S. and the Washington Post, which created a similar database, do a better job of cataloguing these deaths than the federal government.

“It is unacceptable that the Washington Post and the Guardian newspaper from the UK are becoming the lead source of information about violent encounters between [U.S.] police and civilians,” Comey said, according to The Guardian U.S. “That is not good for anybody.”

Last week, the FBI announced it was planning to restructure the way it tracks deaths caused by police officers.

I had the opportunity to ask the Guardian U.S.’ interactive team members about their work on The Counted and the process of visualizing the data. Kenan Davis, Rich Harris, Nadja Popovich and Kenton Powell responded as a group via email.

Answers have been edited for style and clarity.

Knight Lab: Can you explain the general process the team went through to visualize the data from concept to completion? (Did it differ from past projects, or is there a similar process used for all projects?)

The Guardian: This was a much more collaborative project across the newsroom than anything we’d worked on before. Reporters Jon Swaine, Oliver Laughland and Jamiles Lartey were responsible for much of the data gathering and vetting for The Counted. They set up the methodology for how to gather and confirm cases, though our interactive team helped pull in an initial dataset from Killed By Police and Fatal Encounters that provided a foundation for the project. Our team worked on the main database and the corresponding map of people killed by police, and we did some wider data analysis. The Guardian US audience team planned the various community aspects of the project, including a tip sheet, a Facebook group and a Twitter feed. We consulted with each other often, meeting weekly as a group to discuss progress and share ideas.

There was a lot of back and forth about the database concept and design between various stakeholders in the office, including our team, the reporters and editors. We worked hard to get the tone right for this project – it's a difficult strike a balance between somber and compelling.

In other ways, the workflow was not dissimilar to other projects we’ve worked on before. Our team tends to work in a highly collaborative fashion, brainstorming together and mapping out the general outlines of a project before we each begin to contribute our own pieces.

Richard Perkins was the 1000th person to be added to The Guardian's "The Counted" project.

KL: What languages/tools were used to create the project?

TG: The project is written in JavaScript, specifically using a library that is maintained by team member Rich Harris, Ractive.js. We also used Mapbox for the mapping.

KL: When did the planning for the project begin? Was this something that started a long time before The Counted officially launched? If so, how long before? Also, how long did it take to create the final product, from concept to completion?

TG: Initial planning for the project began around March and we launched the database at the beginning of June. In all, it took about three months to complete, on and off.

KL: Can you explain how the data is visualized and why the team designed it the way it did?

TG: The main page needs to serve several different audiences – people looking for information about a specific case, people who have been following The Counted for some time, people who are visiting for the first time, and so on. For that reason, we felt it was important to have a ‘summary dashboard’ that could quickly paint a picture for newcomers, without obstructing people who just wanted to see what was new, or drill down into individual cases. We also wanted to avoid ‘chart fatigue’ or a sense that we’re reducing the cases to mere statistics – another reason not to overwhelm readers with visualizations.

Away from the main page, we occasionally produce bespoke visualizations for individual articles, such as these charts showing that black people killed by police are more than twice as likely to be unarmed as white people.

KL: Were there any other alternatives that were considered? If so, what were they and why did the team end up choosing what is now the final one?

TG: Initially, we didn’t display images on the tiles because of space constraints. The page was far more sterile without them and lacked humanity. We soon realized that we could put the images behind the text if we made the images grayscale. This humanized the project without sacrificing the efficiency and elegance of the tiles.

About the author

Benjamin Din

Student Fellow

Latest Posts

  • A Google Spreadsheets change affecting TimelineJS users

    Google recently changed something about their Sheets service which is causing many people to run into an error when they are making a new timeline. Note: there should be no impact on existing timelines! After this change, many of you click on the "preview" and get this message: An unexpected error occurred trying to read your spreadsheet data [SyntaxError] Timeline configuration has no events. There is a straightforward work-around, but it requires those of you who have...

    Continue Reading

  • How Americans think and feel about gun violence

    A man killed his wife, then himself. I want you to see his face and learn that he enjoyed fishing with his grandchildren. A small-time drug dealer is shot by two men in a parking lot. I find his Facebook profile and a photo shows him striking a playfully irreverent pose, giving the camera the middle finger. The photo’s comments take a mournful turn after a certain date. “Rest easy bro ???” Gun Memorial runs...

    Continue Reading

  • Software developers interested in journalism: Northwestern and The Washington Post want you!

    Northwestern University and The Washington Post are offering a unique opportunity for two talented software developers interested in applying their programming skills in media and journalism. Here’s the proposition: (1) a full-tuition scholarship to earn a master’s degree in journalism at Northwestern University, followed by (2) a six-month paid internship with The Post’s world-class engineering team, with the possibility of subsequent full-time employment. These opportunities are made possible by the John S. and James L....

    Continue Reading

  • What happened when Gun Memorial let anyone contribute directly to victim profiles

    If you’re reporting local or niche news, there’s a good chance that your audience collectively knows more about the story than you do. That’s especially true for us at Gun Memorial, a small publication with a nationwide mission of covering every American who is shot dead. In our latest, mostly successful, experiment, we let readers add to our stories without editor intervention. This article shares some lessons from that experience. Asking for reader contributions A...

    Continue Reading

  • How conversational interfaces make the internet more accessible for everyone

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. In 2004, human-computer interaction professor Alan Dix published the third edition of Human-Computer Interaction along with his colleagues, Janet Finley, Gregory Abowd, and Russell Beale. In a chapter called “The Interaction,” the authors wrote...

    Continue Reading

  • Three tools to help you make colorblind-friendly graphics

    This story is part of a series on bringing the journalism we produce to as many people as possible, regardless of language, access to technology, or physical capability. Find the series introduction, as well as a list of published stories here. I am one of the 8% of men of Northern European descent who suffers from red-green colorblindness. Specifically, I have a mild case of protanopia (also called protanomaly), which means that my eyes lack...

    Continue Reading

Storytelling Tools

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

View More