Tracking gang activity in Tennessee

The Tennessean's three-part series on gangs reveals a growing problem across the state, particularly in suburbia and small towns. Law enforcement is overwhelmed and schools are ripe recruiting grounds in what's part of a national trend of gangs expanding their influence to areas outside the urban core to sell drugs. The newspaper gained access to gangs, taking readers inside their world, while providing the most complete public accounting to date of gang activity across the state. Included in the online presentation is an interactive map of known gangs that operate in each of Tennessee's 95 counties. Relying on a confidential report, interviews, police records and court records, the newspaper's series found there's no consistent system to track gang activity. The lack of information leaves the public, and sometimes even law enforcement, in the dark about the scope of the problem. The paper also found some homicides with links to gangs never get reported as such by police.

Using Oklahoma Lottery Commission sales data and U.S. Census Bureau data, the Tulsa World found that some of Tulsa County's poorest areas spend the most money on lottery tickets per capita, according to a report by Gavin Off. An interactive map showing income vs. lottery spending can be found here.

"Tens of thousands of unsafe or decaying bridges carrying 100 million drivers a day must wait for repairs because states are spending stimulus money on spans that are already in good shape or on easier projects like repaving roads, an Associated Press analysis shows." An interactive map gives details state-by-state on bridge projects funded by stimulus money.

"The air across Iowa is so polluted that the state is perilously close to violating new federal limits aimed at protecting human health. Yet Iowans have no way of knowing what chemicals they are breathing because of a limited - and often inaccurate - system of monitoring pollution statewide, a Des Moines Register investigation found." An interactive map included with the package shows the top emitters of pollutants across the state.

The Statesman Journal recently ran a two-day package that showed how the newest and least experienced teachers in the Salem-Keizer School District work in the highest poverty schools, which was based on a data analysis by the newspaper. Salem-Keizer is the second largest school district in Oregon, with about 40,000 students. Using raw data from the school district and state education department, Statesman Journal education reporter Mackenzie Ryan analyzed teacher experience levels, student minority and poverty make up, and state test results at each school. The package included "case studies" of a high poverty school with high teacher turnover, a more affluent school where experienced teachers flock and a bucking-the-trend school that has achieved student success.

Steve Myers of Poynter interviewed Sarah Cohen, database editor for The Washington Post's investigative team, on her use of data visualization as part of exploratory reporting. Cohen spoke on the topic at the 2009 CAR Conference in Indianapolis. Download the tipsheet from her presentation here (pdf).

A story by William Heisel of the Los Angeles Times focuses on the failures of the federal government’s efforts to revitalize the housing market and to increase affordable housing. For a decade, the Department of Housing & Urban Development (HUD) has been giving local governments homes to refurbish and resell to low-income buyers.   The story found that the program has been a boon to investors and a bust for the poor families it was intended to help.  Included in the package is an interactive map showing what has happened to some of these homes in the city of San Bernardino, one of the areas hardest hit by foreclosures.

As many as 24,800 Tulsa County residents live in areas not reached by outdoor tornado sirens, a Tulsa World analysis found. Many of those residents live in the county's remote north or southwestern sections where farms have yet to give way to residential developments. Included with the story are searchable databases listing all the tornadoes in Oklahoma and nationally since 1950.

A series by The Washington Post takes a hard look at charter schools in Washington, D.C. Approximately one-third of city's children attend these independent, nonprofit schools. The investigation shows that much of the $1.6 billion in local and federal money spent on charter school over the past 12 years has gone to the purchase and renovation of school buildings creating some of the best facilities in the area. The Post found a conflict of interest in the regulation of these funds, as the key players included bankers and developers who stood to gain from the decisions. The charter schools are succeeding in their academic mission. The Post's analysis of test scores showed marked improvements among low-income students attending the charters.

Ian Demsky of The News Tribune in Tacoma, Wash. found that nearly a third of the voters in Pierce County cast their ballots for Democratic president-elect Barack Obama and Republican gubernatorial candidate Dino Rossi. The article includes maps of the areas that went for Obama and Rossi and the county's results of both races.