In a widely-reported study of orchestrated deception, the Center for Public Integrity found that President Bush and seven top officials made 935 false statements leading up to the Iraq war. The Center’s main challenge was to pull together the sources of lies, integrate them into an easy to use and effective platform. The solution the Center was looking for had to deliver the following:
- Integration of 528 information sources
- Linking of timeline to political figure to lies
- Search by topic
- Capacity to slice and dice through database rapidly end efficiently
Squirro partnered with Visible Government to provide the integration of unstructured and structured data into a QlikView dashboard. This enabled the incorporation of 528 sources of information.
Once the sources integrated, they were linked to structured dimensions such as time and „author“ to enable easy slicing and dicing.
Finally Squirro added a layer of unstructured data analytics to facilitate the search of specific topics and concepts.
The Center for Public Integrity, thanks to the combination of unstructured and structured data, has been able to provide on their website a simple and elegant interface for the public to view and consume the information about the Iraq war.
Users can simply select any political figure and any period and gets a list of the corresponding deceptions.
The solution enables the user to search efficiently the 380,000 words of every public pronouncement by top Bush administration officials on the existence of weapons of mass destruction in Iraq and on the links between Iraq and Al Qaeda with a few simple clicks.
Check out the dashboard here.
About the Center for Public Integrity:
The Center for Public Integrity was founded in 1989 by Charles Lewis. We are one of the country’s oldest and largest nonpartisan, nonprofit investigative news organizations. Our mission: To serve democracy by revealing abuses of power, corruption and betrayal of public trust by powerful public and private institutions, using the tools of investigative journalism.