The IRE Resource Center is a major research library containing more than 23,250 investigative stories — both print and broadcast. These stories are searchable online or by contacting the Resource Center directly (573-882-3364 or rescntr@ire.org) where a researcher can help you pinpoint what you need. Browse or search the tipsheet section of our library below. Stories are not available for download but can be easily ordered by contacting the Resource Center:
Search results for "database" ...
-
Green Inc., Environmentalism for Profit
With the groundbreaking series Green Inc., USA Today for the first time uncovers the truth behind the soaring movement toward constructing buildings that are certified as environmentally friendly. The series shows how "green" buildings often are barely different from their supposedly conventional counterparts -- except that green-building designers and owners often win huge tax breaks, zoning waivers and other valuable perks from government agencies. The series involves an unprecedented analysis of records for 7,100 green-certified buildings to show how the designers follow the easiest and cheapest steps to get certified. Numerous freedom-of-information requests revealed the enormous tax breaks awards to the building designers and owners, and also show how some buildings are falling far short of their environmental promise.
Tags: Environmental friendly; taxes; green buildings; certificated
-
Wilmington's Street Wars
Wilmington, Del., has become one of the most violent cities of its size in America. Nothing dramatized that fact more than several spectacular shootings in 2012, including one day in June when three people were shot to death in separate incidents, and a shootout a few weeks later at a soccer tournament that killed three people -- including a teenager waiting to play the game he loved. To document and study the violence he and other News Journal colleagues were covering, senior reporter Cris Barrish gathered information for a database detailing the 158 shootings, including 42 homicides, over a 20-month period. He learned that police made arrests in only one-third of the cases, many of which collapsed in court. His research into why police could not solve cases led to the revelation that both shooting suspects and victims had been arrested an average of about two dozen times, with many qualifying as habitual criminals -- a phenomenon that some authorities call "thugicide.'' His stories also explored the “don’t snitch’’ code of the streets that cripples prosecution of these cases, not only by the men on both sides of the gun barrel, but also by residents who are terrified of the gunmen and distrustful of law enforcement.
-
Dark Markets
The Wall Street Journal’s coverage of financial markets in 2012 performed a rare and extraordinary service: It exposed evidence of hidden manipulation by corporate executives and professional traders that the markets’ official government watchdogs were utterly unaware of. Reflecting potential widespread harm to millions of ordinary investors, federal prosecutors and securities regulators raced to follow the Journal stories with major investigations. A team of reporters spent six months creating a database examining how more than 20,000 corporate executives traded their own companies’ stocks over the course of eight years. What the team found was disturbing: More than 1,000 executives had generated big profits, or avoided big losses, by trading their company stock in the days ahead of corporate news announcements that led to big moves in the shares. The Journal also exposed a regulatory loophole that had helped the executives take advantage of inside knowledge ahead of other investors. The Federal Bureau of Investigation, the Manhattan U.S. Attorney's office and the Securities and Exchange Commission all launched investigations the day the Journal article appeared.
Tags: Financial markets; corporate executives; stocks; Federal Bureau of Investigation
-
Tampa Bay Times: Stand Your Ground
In the wake of the Trayvon Martin shooting controversy, the Tampa Bay Times systematically reviewed scores of "stand your ground" cases and created the first database of its kind to bring the facts of all these cases together as a single source.
-
Connecticut Superintendents
Viktoria Sundqvist, investigations editor at The Middletown Press, submitted FOI requests for all school superintendent contracts in Connecticut and gathered these contracts into a searchable database. The contracts were analyzed and salaries, mileage, vacation days and other perks were analyzed and made available to the public, in addition to links to the contracts.
Tags: Schools; school superintendents; salaries; public records
-
Who Can Vote? Comprehensive Database of U.S. Voter Fraud Uncovers No Evidence That Photo ID Is Needed
“Who Can Vote?” is the 2012 project of News21, a multimedia investigative reporting initiative funded by the Carnegie Corporation of New York and the John S. and James L. Knight Foundation and headquartered at the Walter Cronkite School of Journalism and Mass Communication at Arizona State University. Twenty-four students from 11 universities across the country worked on the project under the direction of journalism professionals. The project, launched just before the 2012 political conventions, consists of more than 20 in-depth reports and rich multimedia content that includes interactive databases and data visualizations, video profiles and photo galleries. Student reporters conducted an exhaustive public records search and built a comprehensive data base of voter fraud cases that revealed: • Since 2000, while fraud has occurred, the number of cases is infinitesimal. • In-person voter impersonation on Election Day, which prompted 37 state legislatures to enact or consider tough voter ID laws, is virtually non-existent. Only 10 such cases over more than a decade were reported. • There is more fraud in absentee ballots and voter registration than any other category. The analysis shows 329 cases of absentee ballot fraud and 364 cases of registration fraud. A required photo ID at the polls would not have prevented these cases. • Voters make a lot of mistakes, from people accidentally voting twice to voting in the wrong precinct. However, few cases reveal a coordinated effort to change election results. • Election officials make a lot of mistakes, giving voters ballots when they’ve already voted, for instance. Election workers are often confused about voters’ eligibility requirements.
Tags: elections; fraud; public records; voters; ballot
-
Seattle Police:Vanishing Videos
This story began as a relatively simple venture; how to get copies of police dashboard camera videos to provide watchdog oversight of a police department facing growing criticism. It grew into a major expose of questionable police tactics and a battle for public access to critical public records that is currently before the state Supreme Court. Over the course of a year and a half, KOMO TV’s fight for videos and the video database became a game of strategy and attrition as the Seattle Police Department denied us access to public records at every opportunity. We tried every means at our disposal to get these records including direct appeals to elected officials. Finally, with no other recourse, KOMO TV sued the SPD and the city of Seattle. Only then did we make our fight for these records public. What followed in 2012 was a cascade of stories; people coming forward alleging police misconduct and an attempt to hide the videos that would tell the truth. In addition to KOMO TV’s public records lawsuit, our investigation has prompted state legislators and other open records advocates to pursue changes in state law to ensure these records can no longer stay hidden.
Tags: police; camera videos; SPD; Seattle Police Department; public records
-
As Mine Protections Fail, Black Lung Cases Surge
A joint investigation by NPR and the Center for Public Integrity mined government databases and analyzed together for the first time ever, coal dust enforcement records and black lung occurrence data. We compiled what appear to be the most comprehensive accounts to date of an unexpected reemergence of black lung, sharp increases among younger miners, rapid progression to the most serious stages, widespread fraudulent coal dust testing by industry, weaknesses and loopholes in federal regulations, and ineffective enforcement by federal regulators. We asked Ken Ward Jr., the veteran coal industry reporter at the Charleston Gazette, to contribute web and print stories about the history of failed government regulation, as well as fraudulent coal dust testing specifically at the Upper Big Branch mine, where 29 miners died in an explosion fueled by coal dust in 2010. Our reporting prompted the Labor Department to establish an internal team to review the agency's enforcement of coal dust regulations, according to internal agency e-mails obtained by NPR. Federal regulators stepped up coal dust enforcement, targeting mines with a history of violations. Members of Congress cited the series in calling for tougher regulations, and one group launched a petition drive demanding action.
Tags: mining; miners; black lung disease; coal dust; government
-
A Lingering Mystery: Arizona ranked 3rd in country for number of human remains that are unidentified
The story uses data scraped from a federal database called NamUs to rank the number of unidentified remains in the country by state. Research into the matter shows Arizona's number is so high because of deaths on the border.
Tags: unidentified remains; deaths
-
Grave Mistakes
Most people have never heard of the Social Security Administration's so-called "Death Master File"- a database of deceased Americans created in 1980 under the Freedom of Information Act as an anti-fraud tool. But each year, many Americans discover that they are listed as deceased by the federal government. Identity thieves have learned to use the Death Master File to commit hundreds of thousands of acts of identity theft for tax fraud, including taking Social Security numbers of recently deceased children.
Tags: Social Security; Fraud; Death Master File; deceased Americans