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 Brief Introduction to NewsgamesCan video games be used to tell the news?

    When the Financial Times released The Uber Game in 2017, the game immediately gained widespread popularity with more than 360,000 visits, rising up the ranks as the paper’s most popular interactive piece of the year. David Blood, the game’s lead developer, said that the average time spent on the page was about 20 minutes, which was substantially longer than what most Financial Times interactives tend to receive, according to Blood. The Uber Game was so successful that the Financial...

    Continue Reading

  • With the 25th CAR Conference upon us, let’s recall the first oneWhen the Web was young, data journalism pioneers gathered in Raleigh

    For a few days in October 1993, if you were interested in journalism and technology, Raleigh, North Carolina was the place you had to be. The first Computer-Assisted Reporting Conference offered by Investigative Reporters & Editors brought more than 400 journalists to Raleigh for 3½ days of panels, demos and hands-on lessons in how to use computers to find stories in data. That seminal event will be commemorated this week at the 25th CAR Conference, which...

    Continue Reading

  • Prototyping Augmented Reality

    Something that really frustrates me is that, while I’m excited about the potential AR has for storytelling, I don’t feel like I have really great AR experiences that I can point people to. We know that AR is great for taking a selfie with a Pikachu and it’s pretty good at measuring spaces (as long as your room is really well lit and your phone is fully charged) but beyond that, we’re really still figuring...

    Continue Reading

  • Capturing the Soundfield: Recording Ambisonics for VR

    When building experiences in virtual reality we’re confronted with the challenge of mimicking how sounds hit us in the real world from all directions. One useful tool for us to attempt this mimicry is called a soundfield microphone. We tested one of these microphones to explore how audio plays into building immersive experiences for virtual reality. Approaching ambisonics with the soundfield microphone has become popular in development for VR particularly for 360 videos. With it,...

    Continue Reading

  • Audience Engagement and Onboarding with Hearken Auditing the News Resurrecting History for VR Civic Engagement with City Bureau Automated Fact Checking Conversational Interface for News Creative Co-Author Crowdsourcing for Journalism Environmental Reporting with Sensors Augmented Reality Visualizations Exploring Data Visualization in VR Fact Flow Storytelling with GIFs Historical Census Data Information Spaces in AR/VR Contrasting Forms Of Interactive 3D Storytelling Interactive Audio Juxtapose Legislator Tracker Storytelling with Augmented Reality Music Magazine Navigating Virtual Reality Open Data Reporter Oscillations Personalize My Story Photo Bingo Photojournalism in 3D for VR and Beyond Podcast Discoverability Privacy Mirror Projection Mapping ProPublica Illinois Rethinking Election Coverage SensorGrid API and Dashboard Sidebar Smarter News Exploring Software Defined Radio Story for You Storyline: Charts that tell stories. Storytelling Layers on 360 Video Talking to Data Visual Recipes Watch Me Work Writing and Designing for Chatbots
  • Prototyping Spatial Audio for Movement Art

    One of Oscillations’ technical goals for this quarter’s Knight Lab Studio class was an exploration of spatial audio. Spatial audio is sound that exists in three dimensions. It is a perfect complement to 360 video, because sound sources can be localized to certain parts of the video. Oscillations is especially interested in using spatial audio to enhance the neuroscientific principles of audiovisual synchrony that they aim to emphasize in their productions. Existing work in spatial......

    Continue Reading

  • Audience Engagement and Onboarding with Hearken Auditing the News Resurrecting History for VR Civic Engagement with City Bureau Automated Fact Checking Conversational Interface for News Creative Co-Author Crowdsourcing for Journalism Environmental Reporting with Sensors Augmented Reality Visualizations Exploring Data Visualization in VR Fact Flow Storytelling with GIFs Historical Census Data Information Spaces in AR/VR Contrasting Forms Of Interactive 3D Storytelling Interactive Audio Juxtapose Legislator Tracker Storytelling with Augmented Reality Music Magazine Navigating Virtual Reality Open Data Reporter Oscillations Personalize My Story Photo Bingo Photojournalism in 3D for VR and Beyond Podcast Discoverability Privacy Mirror Projection Mapping ProPublica Illinois Rethinking Election Coverage SensorGrid API and Dashboard Sidebar Smarter News Exploring Software Defined Radio Story for You Storyline: Charts that tell stories. Storytelling Layers on 360 Video Talking to Data Visual Recipes Watch Me Work Writing and Designing for Chatbots
  • Oscillations Audience Engagement Research Findings

    During the Winter 2018 quarter, the Oscillations Knight Lab team was tasked in exploring the question: what constitutes an engaging live movement arts performance for audiences? Oscillations’ Chief Technology Officer, Ilya Fomin, told the team at quarter’s start that the startup aims to create performing arts experiences that are “better than reality.” In response, our team spent the quarter seeking to understand what is reality with qualitative research. Three members of the team interviewed more......

    Continue Reading

Storytelling Tools

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

View More