Data-Journalism   472

« earlier    

How rape goes unpunished in America
Across the country, dozens of law enforcement agencies are making it appear as though they have solved a significant share of their rape cases when they simply have closed them, according to an investigation by Newsy, Reveal from The Center for Investigative Reporting and ProPublica based on data from more than 60 police agencies nationwide.

They are able to declare cases resolved through what’s known as exceptional clearance. Federal guidelines allow police to use the classification when they have enough evidence to make an arrest and know who and where the suspect is, but can’t make an arrest for reasons outside their control.

Although criminal justice experts say the designation is supposed to be used sparingly, our data analysis shows that many departments rely heavily on exceptional clearance, which can make it appear that they are better at solving rape cases than they actually are.

Because exceptional clearance data is not readily accessible to the public, we read through hundreds of police reports and sent more than 100 public records requests to the largest law enforcement agencies in the country. We analyzed data for more than 70,000 rape cases, providing an unprecedented look at how America’s police close them.

Nearly half of the law enforcement agencies that provided records cleared more rapes through exceptional means than by actually arresting a suspect in 2016, the data analysis shows.

The Baltimore County Police Department, for example, reported to the public that it cleared 70 percent of its rape cases in 2016, nearly twice the national average. In reality, the department made arrests about 30 percent of the time, according to its internal data. The rest were exceptionally cleared.
data-journalism  policing 
4 weeks ago by danwin
Data Training Master Class Summaries (March 2019) - Google Docs
Skills list:


Afterwards, start with the skills list, which shows an outline of what you’ll learn, and the schedule, which links to all the other files. The schedule shows clearly how the various files and folders fit together in our training. Of course, feel free to mix and match however you see fit.

As stated in each worksheet, please do not use our data for reporting. We’ve altered files to make sure they fit with each lesson. You can always re-pull the data yourself if you’d like to use it though.
data-journalism  tutorial  spreadsheets  best 
4 weeks ago by danwin
About Unholstered | Unholstered
The Texas Tribune’s Unholstered project presents the results of a nearly yearlong investigation into when and why officers used lethal force in Texas, examining shootings that occurred between 2010 and 2015.

We focused on police departments in cities with a population of 100,000 or more at the time we began gathering data, totaling 36 cities that make up about half of Texas’ population.

We chose the 100,000 population threshold because shootings per department in smaller cities are sporadic and difficult to track. Even in some of the larger cities we studied, departments said they lacked the ability to keep records on police shootings.
spreadsheets  sdss  policing  data-journalism  methodology  open-data 
4 weeks ago by danwin
Exclusive: the real story of the MPs’ expenses scandal
10 years ago, The Telegraph began publication of an investigation known as The Expenses Files. It was described as the biggest political scandal of the past 30 years and its effects have been felt ever since. The men and women who helped bring the scandal to light have never spoken. Until now.
10 weeks ago by danwin
With fewer park employees than there are parks in St. Louis, corners get cut | Metro |

I'm excited to share a new level of data transparency for the Post-Dispatch @stltoday

For this story, you can see exactly where we got the data and how we analyzed it, via our GitHub page. I hope to continue doing this for as many stories as possible
10 weeks ago by danwin
Houston Cop Who Led Botched Drug Raid Overwhelmingly Arrested Black People - The Appeal
I looked at the data for 591 cases involving a Houston cop at the center of a deadly drug raid.

In 94% of those cases, the defendants were Black, and most of the arrests happened in a handful of poor neighborhoods and involved less than 1 gram of drugs.
12 weeks ago by danwin
‘Whoah, wait a minute, every reporter needs to be a data reporter’: Conversations with two generations of data journalists at the Los Angeles Times – The Data & News Society
Over the entrance to the Los Angeles Times headquarters hangs a banner with the newspaper’s promise to the world: REAL JOURNALISM, REAL IMPACT. When I visited in April 2018, the paper was still quietly situated in its historic downtown Los Angeles headquarters, right next to the City Hall and the Grand Park. Three months later, the paper moved out of its historic downtown building to a facility near Los Angeles International Airport, bringing itself closer to the rest of the nation in the latest episode in a series of ownership changes that have been going on for decades. I went there in search of a pair of data journalists, Doug Smith and Ben Welsh, who relayed to me a remarkable story of the evolution of data journalism in recent decades. Since Smith joined the LA Times in 1970, he has covered everything from local and state government to criminal justice to politics and education. Atypical among English literature majors, Smith has never feared numbers. “My predecessor Dick O’ Reilly started the data desk in the mid 1990s, and the data desk at that time consisted of Dick and one programmer, which you can call the first original data desk,” said Smith. “When I started to do some programming at that time, I wasn’t really writing code, I was using database management.” Smith said that’s how he started to do data work there.
data-journalism  profiles  nicar 
april 2019 by danwin

« earlier    

related tags

***  analytics  ap  archives  bad-data  baltimore  ben-welsh  best  book  brexit  build  case-search  census  charting  china  collaboration  compciv  courses  crime  crowdsourcing  data-anecdote  data-journalism  data-narratives  data-visualisation  data-visualization  data-viz  data  data_analysis  data_journalism  data_mining  database  datajournalism  datasette  dataviz  death-data  demographics  digitalhumanities  dirty-data  disinformation  dj  elections  explanation  facebook  feb19  foia  gov-tech  government  guardian  inequality  infograph  infographs  inspiration  investigations  jan18  journalism-training  journalism  jupyter  leave  longread  machine-journalism  machine-learning  making-stuff  mapping  maps  may18  media  methodology  muckrock_crowdsourcing_ideas  muckrock_feature_ideas  music  news-nerdery  news  newsflash  newspapers  nicar  online  open-data  padjo  pharmalot  policing  politics  profiles  project-idea  racial  remain  repetitive  replicate  research  retractions  scraping  sdss  segregation  simulation  sources  spreadsheets  statistics  textbook  thailand  to_foi  tool  training  tutorial  utility  vis-examples  visual-journalism  visualization  washington-post  web-archiving  web-scraping  workflow  広告 

Copy this bookmark: