Tags : database

How to use CDC data to report on gun deaths

Dan Keating of the Washington Post used the CDC Wonder database to explore the racial breakdowns of gun deaths. What he found challenges the idea of having a gun for protection — at least for some.

"A white person is five times as likely to commit suicide with a gun as to be shot with a gun; for each African American who uses a gun to commit suicide, five are killed by other people with guns."

Learn how to use the same CDC data to investigate causes of death in your area.

Want more?

Read more ...

Nurses with criminal records allowed to keep working in Minn.

Our data-driven investigation, “When Nurses Fail,” found that hundreds of nurses with records of unsafe practice, patient harm, criminal charges or convictions continue to practice in Minnesota. A state monitoring program for drug-addicted health professionals allowed nurses to continue despite abusing drugs or alcohol, stealing from their patients and failing numerous drug tests.

Nurses with histories of drug use, crime or neglect were able to obtain licenses and find jobs because of flaws in the state background check system. Patients were unaware that their nurses had troubled backgrounds. One parent inadvertently hired a nurse with a history of making crystal ...

Read more ...

Behind the Story: How USA TODAY pieced together a confidential FBI database to count fugitives who go free

Brad Heath

Lamont Pride was a wanted man the day he fatally shot a New York City police officer during a 2011 robbery. Officials had already passed up opportunities to lock up Pride, who was wanted in connection with a North Carolina shooting. And when the fugitive appeared in a Brooklyn court on a drug charge, a judge aware of the warrant also decided to let him go. A few weeks later Officer Peter Figoski was dead.

USA TODAY reporter Brad Heath followed coverage of the high-profile case.

“This must be out of the ordinary,” Heath remembered thinking. “I wonder ...

Read more ...

Database used to highlight lax police misconduct oversight

We knew early in our investigation of Long Island police misconduct that police officers had committed dozens of disturbing offenses, ranging from cops who shot unarmed people to those who lied to frame the innocent. We also knew that New York state has some of the weakest oversight in the country.

What we didn’t know was if anyone had ever tried to change that. We suspected that the legislature, which reaps millions in contributions from law enforcement unions, hadn’t passed an attempt to rein in cops in years. But we needed to know for sure, and missing even ...

Read more ...

Financial data shows Okla. hospitals spend little on charity care

The idea to look at hospital finances and charity care came shortly after Oklahoma decided against expanding its Medicaid program under the Affordable Care Act.

After the state’s decision, the Oklahoma Hospital Association and others warned that the state’s hospitals – especially small rural hospitals – were already operating on slim budgets and the decision not to expand Medicaid and give more people health coverage would make the situation worse, including leading to closure of some hospitals.

To test this claim, Oklahoma Watch set out to get financial data for each hospital in the state. Along the way, we also ...

Read more ...

AUDIO: Using data to cover hazmat pollution

Journalists Denise Malan, Ben Poston and Tim Wheeler all used data to create stories on hazardous materials and the environment. The three discussed state and national databases that track pollution and hazardous waste at the NICAR Conference in Baltimore.

NICAR offers a hazardous waste database. Malan described how to use it and what kinds of data reporters can find.


She also gave examples of stories that were created from the dataset:

Iowa Watch: Little Information Exists About Hazardous Materials Traveling Across Iowa 

MinnPost: Visualizing hazmat incidents in Minnesota  

Public Source: PA fifth in the nation in hazardous spills  

 

Interested in ...

Read more ...

Records shed light on lax landlords, broken housing code system

The deaths of a young couple and a 4-year-old child in a Christmas Eve fire exposed significant problems with landlords renting dilapidated and dangerous properties in Columbus, Ohio.

In the immediate aftermath, city officials – acting on public outcry – made promises to fix its broken housing code system. But when the outcry died, so did those promises, prompting The Columbus Dispatch’s “Legacy of Neglect” series.

The four-day series produced such overwhelming results that the mayor, other city officials and their housing code enforcement unit immediately declared war on slumlords who, our reporting found, regularly rented houses with unsafe electrical systems ...

Read more ...

Join a live discussion about Econocheck

NICAR adviser David Herzog will be on hand Tuesday, Nov. 20 at 2 p.m Eastern (11 a.m. Pacific) for a live Q&A about EconoCheck on the Journalism AcceleratorEconoCheck, an IRE-Sunlight Foundation resource launched during the 2012 campaign, helps reporters quickly find and understand data about key indicators. Drop by to discuss how journalists can continue to tap into it for post-election economic reporting and how we might improve it.

What do you think about the way EconoCheck presents tools and information? Please join us to share your experience and ask anything you want to know.

OSHA Workplace Safety data updated at NICAR Data Library

The Workplace Safety database from the Occupational Health and Safety Administration (OSHA) has just been updated in the NICAR Database Library.

WHAT’S IN IT?

This ten-table database holds information on workplace inspections performed by both federal and state OSHA offices in all states and U.S. territories, from 1972 to Oct 2011 – just under 4 million records.

OSHA classifies businesses by their location, name and North American Industry Classification System (NAICS), making it possible to analyze inspections, violations and accidents involving a certain occupation or those in a given region or city. The data also include details on the ...

Read more ...

Spreading computer-assisted reporting techniques in Latin America

By Mc Nelly Torres

Víctor Hugo Michel is excited and overwhelmed.

He hasn’t stopped thinking about all the stories he will be able to report and write using the data analysis and investigative tools he learned this past weekend at the IberoAmericana University in México City.

“I never thought I could organize data, rank it and compare it electronically to find new trends and information which is not easy to see with the naked eye,” said Michel, a reporter for the newspaper Grupo Milenio in México City. “These tools are like using a new set of ...

Read more ...