Registration / Login
text version
War and Peace

 Hot news

Main page » Reports » View
Printable version
Wikileaks Iraq: data journalism maps every death
23.10.10 08:31 Iraq War, "War on terror"

Simon Rogers

guardian.co.uk, Saturday 23 October 2010 17.57 BST

Data journalism works best when theres a lot of data to work with. Wikileaks Iraq war logs release has dumped some 391,000 records of the Iraq war into the public arean. Weve had them for a few weeks - what have we found out?

This is in a different league to the Wikileaks Afghanistan leak - theres a good case for saying the new release has made the war the most documented in history. Every minor detail is now there for us to analyse and breakdown but one factor stands out: the sheer volume of deaths, most of which are civilians.

Some key findings:

Total deaths

• The database records 109,032 deaths in total for the period
• The database records the following death counts: 66,081 civilians, 23,984 insurgents and 15,196 Iraqi security forces
• The worst place for deaths was Baghdad - 45,497, followed by MND north (which is the region that goes from Baghdad up to Kurdistan) where another 34,210 died. The quietest place was the north east with only 328 deaths

Murders and escalation of force

• 34,814 people were recorded as murdered in 24,840 incidents
• The worst month was December 2006 with 2,566 murders - and 2006 was the worst year with 16,870 murders
• The database records 12,578 escalation of force incidents (where someone is shot driving too fast at a checkpoint, for instance) - and these resulted in 778 recorded deaths

Improvised Explosive Devices (IEDs)

• There were 65,439 IED explosions over the period - with 31,780 deaths recorded on the database from those alone.
• There were another 44,620 IEDs found and cleared
• The worst month for IED explosions was May 2007 with 2,080 IED explosions

Download the data

The Guardian has decided not to republish the entire database, largely because we cant be sure the summary field doesnt contain confidential details of informants and so on. But, so you have some data to play with, we have provided this spreadsheet. It contains the records of every incident where someone dies, nearly 60,000 in all. We have removed the summary field so its just the basic data: the military heading, numbers of deaths and the geographic breakdown.

Get the fullscreen version

Google Fusion tables is fantastic for mapping out bulky datasets and they dont come much bulkier than this. We took all these incidents where someone had died and put it on the map above. The fullscreen version is easier to use. A few of the datapoints arent mapping correctly - but this may be a problem with the data.

You can download it below, plus weve broken down the deaths by cause and year in sortable tables. What can you do with it?

Data summary

Deaths and wounded
YEAR
Coalition forces
Iraqi forces
Civilians
Enemy
TOTAL DEATHS
TOTAL WOUNDED, all categories
2004 747 1,031 2,781 5,995 10,554 18,567
2005 856 2,256 5,746 3,594 12,452 24,850
2006 821 4,370 25,178 4,657 35,026 41,164
2007 919 4,718 23,333 6,793 35,763 55,804
2008 282 1,948 6,362 2,635 11,227 23,632
2009 146 873 2,681 310 4,010 12,365
TOTAL 3,771 15,196 66,081 23,984 109,032 176,382

Causes of death
Category
Coalition forces
Iraqi forces
Civilians
Insurgents
Accident 428 256 599 22
Ambush 4 93 85 154
Arrest 0 12 20 56
Arson 0 6 114 6
ARTY 0 0 2 41
Assassination 0 183 246 7
Attack 86 1,167 1,627 3,775
Attack Threat 0 0 1 1
Blue-Blue 9 2 3 4
Blue-Green 0 51 4 0
Blue-White 0 0 62 1
Border Ops 0 0 0 2
Breaching 0 0 1 0
Cache Found/Cleared 2 10 28 236
Carjacking 0 5 27 5
Close Air Support 0 0 5 776
Confiscation 0 0 3 57
Cordon/Search 2 43 47 316
Counter Mortar Fire 0 0 0 24
Deliberate Attack 0 3 0 119
Demonstration 1 16 476 2
Detain 0 2 19 87
Direct Fire 482 4,270 4,766 6,807
Direct Fire Threat 0 0 1 0
Elicitation 0 1 0 0
Equipment Failure 4 2 3 0
Escalation of Force 0 22 686 70
Explosive Remnants of War (ERW)/Turn In 0 0 1 0
Green-Blue 5 14 3 0
Green-Green 0 58 17 2
Green-White 0 2 48 0
IED Explosion 2,107 5,990 20,228 3,455
IED False 0 0 3 0
IED Found/Cleared 6 31 90 579
IED Hoax 1 0 2 1
IED Pre-detonation 0 0 3 50
IED Suspected 0 0 0 37
IED Threat 0 0 0 2
Indirect Fire 192 284 2,087 1,040
Indirect Fire Threat 0 0 0 2
Intimidation Threat 0 6 18 1
Kidnapping 0 67 161 18
Kidnapping Threat 0 0 2 0
Looting 0 0 18 3
Medevac 3 1 5 2
Mine Found/Cleared 0 0 2 1
Mine Strike 37 24 30 6
Movement to Contact 1 0 0 77
Murder 9 2,169 32,563 73
Murder Threat 0 0 1 0
Other 194 72 584 437
Other Defensive 2 5 141 116
Other offensive 0 4 18 639
Patrol 0 3 43 61
Police Actions 0 1 14 32
Raid 12 75 86 619
Recon 0 0 0 13
Sabotage 0 2 6 0
SAFIRE 67 4 22 317
SAFIRE Threat 0 0 1 0
Search and Attack 0 0 0 90
Shooting 0 1 8 0
Small Unit Actions 27 13 65 3,129
Smuggling 0 1 5 2
Sniper Ops 86 173 62 364
Staff Estimate 0 2 380 0
Surveillance 0 1 8 61
TCP 0 0 5 25
Theft 0 8 57 14
Tribal Feud 0 14 138 5
UAV 0 0 3 49
Unexploded Ordnance 0 2 15 3
Unknown Explosion 4 24 284 61
Vehicle Interdiction 0 0 4 29
White-Blue 0 0 5 0
White-Green 0 0 0 1
White-White 0 0 20 0
Not known 0 1 0 0
TOTAL 3,771 15,196 66,081 23,984

 

kouroush23.10.10 08:44
see also ññûëêà
Ðóññêèé
Archive
Forum

 Exclusiveread more rss

» Destruction of Ukraine’s Central Bank
» The World files their 27 Grievances against the United States of America.
» Yom Kippur War Redux – Petrol D0llar’s Last Hurrah
» How the Alchemists saved the Planet in 2019
» What will the US Treaty of Paris look like?
» Addition by Subtraction, (x, y)↦x−y
» Too Little, Too Late, will there be a Romanov ending for the Sudairi Seven?
» Week 21: When economic arguments end, the arms race begins

 Newsread more rss

» Afghan Taliban leader accuses U.S. of creating doubts over pact
» Kyrgyz President Accuses Atambayev of Violating Constitution by Resisting Detention
» Chinese foreign ministry slams U.S. interference in Venezuela
» With an eye on Russia, China and a horse, Pentagon chief visits Mongolia
» Pentagon Claims Iran Uses GPS Jamming in the Gulf So It Can Lure and Seize Foreign Ships
» USAF X-37B Military Space Planes Mystery Mission Circling Earth Hits 700 Days
» China destabilizing Indo-Pacific: U.S. Defense Secretary
» EU must change its negotiating terms for Brexit, says Barclay

 Reportsread more rss

» A Brief History of the CIA’s Dirty War in South Sudan
» US GDP report: Keynes on steroids
» Are Russia and the US Finally on the Same Page in Afghanistan?
» The IMF Takeover of Pakistan
» Voices from Syria’s Rukban Refugee Camp Belie Corporate Media Reporting
» Report Shows Corporations and Bolsonaro Teaming Up to Destroy the Amazon
» Ukraine: the presidents change, but the oligarchical system remains the same
» The Cowardice of Aung San Suu Kyi

 Commentariesread more rss

» The Biggest Threat to the US Indo-Pacific Strategy? Washington Itself.
» Ukraine on the cusp of change
» India’s Looming Agricultural Crisis: A Unique Chance to Change the System?
» The Saker interviews Stephen Karganovic
» Media and Politicians Ignore Oncoming Financial Crisis
» In an astonishing turn, George Soros and Charles Koch team up to end US ‘forever war’ policy
» Vladimir Putin says liberalism has ‘become obsolete’
» You Are Fighting In The Most Important Battle Of All Time

 Analysisread more rss

» A battle for supremacy between China and the US
» UAE Withdrawal from Yemen
» US, Pakistan move in tandem to end Afghan war
» Is Baoshang Bank China’s Lehman Brothers?
» From the Green Revolution to GMOs: Toxic Agriculture Is the Problem Not the Solution
» OPEC+ oil supply cuts signal smooth Gulf sailing
» G20 Osaka: the end of American leadership?
» Trump’s Brilliant Strategy to Dismember U.S. Dollar Hegemony
 
text version The site was founded by Natalia Laval in 2006 © 2006-2026 Inca Group "War and Peace"