DECJANFEB
07
201020112012
656 captures
24 Oct 2010 - 22 Mar 2021
About this capture
Turn autoplay off
Turn autoplay on
Please activate cookies in order to turn autoplay off
Text larger
·
smaller
About us
Today's paper
Zeitgeist
Today's hot topics
Next
Previous
Blog home
Wikileaks Iraq: data journalism maps every death
Data journalism allows us to really interrogate the Wikileaks Iraq war logs release. Here is the statistical breakdown - and data for you to download
Get the data
Get the fullscreen map
Tweet this
Wikileaks Iraq: a man holds his wounded daughter outside in August 2006 after being injured in road side bomb explosion. Photograph: Ali Abbas/EPA
UPDATE: an academic who has worked with the data has pointed out some of its limitations - you can read his take here
Data journalism works best when there's 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 arena. We've had them for a few weeks - what have we found out?
This is in a different league to the Wikileaks Afghanistan leak - there's 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 can't be sure the summary field doesn't contain confidential details of informants and so on. But, so you have some data to work 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 it's 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 don't 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 aren't mapping correctly - but this may be a problem with the data.
You can download it below, plus we've broken down the deaths by cause and year in sortable tables. What can you do with it?
Data summary
Deaths and wounded
Click heading to sort
YEARCoalition forcesIraqi forcesCiviliansEnemyTOTAL DEATHSTOTAL WOUNDED, all categories
20047471,0312,7815,99510,55418,567
20058562,2565,7463,59412,45224,850
20068214,37025,1784,65735,02641,164
20079194,71823,3336,79335,76355,804
20082821,9486,3622,63511,22723,632
20091468732,6813104,01012,365
TOTAL3,77115,19666,08123,984109,032176,382
Causes of death
Click heading to sort
CategoryCoalition forcesIraqi forcesCiviliansInsurgents
Accident42825659922
Ambush49385154
Arrest0122056
Arson061146
ARTY00241
Assassination01832467
Attack861,1671,6273,775
Attack Threat0011
Blue-Blue9234
Blue-Green05140
Blue-White00621
Border Ops0002
Breaching0010
Cache Found/Cleared21028236
Carjacking05275
Close Air Support005776
Confiscation00357
Cordon/Search24347316
Counter Mortar Fire00024
Deliberate Attack030119
Demonstration1164762
Detain021987
Direct Fire4824,2704,7666,807
Direct Fire Threat0010
Elicitation0100
Equipment Failure4230
Escalation of Force02268670
Explosive Remnants of War (ERW)/Turn In0010
Green-Blue51430
Green-Green058172
Green-White02480
IED Explosion2,1075,99020,2283,455
IED False0030
IED Found/Cleared63190579
IED Hoax1021
IED Pre-detonation00350
IED Suspected00037
IED Threat0002
Indirect Fire1922842,0871,040
Indirect Fire Threat0002
Intimidation Threat06181
Kidnapping06716118
Kidnapping Threat0020
Looting00183
Medevac3152
Mine Found/Cleared0021
Mine Strike3724306
Movement to Contact10077
Murder92,16932,56373
Murder Threat0010
Other19472584437
Other Defensive25141116
Other offensive0418639
Patrol034361
Police Actions011432
Raid127586619
Recon00013
Sabotage0260
SAFIRE67422317
SAFIRE Threat0010
Search and Attack00090
Shooting0180
Small Unit Actions2713653,129
Smuggling0152
Sniper Ops8617362364
Staff Estimate023800
Surveillance01861
TCP00525
Theft085714
Tribal Feud0141385
UAV00349
Unexploded Ordnance02153
Unknown Explosion42428461
Vehicle Interdiction00429
White-Blue0050
White-Green0001
White-White00200
Not known0100
TOTAL3,77115,19666,08123,984
Download the data

DATA: download details of every death in Iraq (Google Fusion tables, requires Google login)
DATA: download the full sheet (no login)
DATA: download our analysis spreadsheet
World government data
Search the world's government with our gateway
Development and aid data
Search the world's global development data with our gateway
Can you do something with this data?
Flickr Please post your visualisations and mash-ups on our Flickr group
Get the A-Z of data
More at the Datastore directory
Follow us on Twitter
Posted by
Simon Rogers Saturday 23 October 2010 17.57 BST
guardian.co.uk
larger | smaller
World news
Iraq: The war logs · Iraq · US military
Media
WikiLeaks
UK news
Military
Technology
More from Datablog on
World news
Iraq: The war logs · Iraq · US military
Media
WikiLeaks
UK news
Military
More blogposts
More graphics
More on Iraq war logs
US turned over captives to Iraqi torture squads
'The US was part of the Wolf Brigade operation against us'
Omar Salem Shehab tells of torture at hands of notorious Iraqi police unit and says US forces were involved in his capture
Iraq war logs: experts' views
World media reaction
The truth for Hanaan Hamood Matrood
Prisoner beaten to death days after British handover
Operation Steel Curtain and its 25 ignored civilian casualties
Battle for Samarra killed dozens of innocent people
UN calls on Obama to investigate human rights abuses
A day in the life of the war
Secret files show how US ignored torture
Apache crew killed insurgents who tried to surrender
Frago 242 – a licence to torture
Iraq war logs reveal civilian body count of invasion is much higher
British blunder let al-Qaida kingpin Zarqawi off the hook
How coalition turned blind eye to detainee torture and abuse
Civilians gunned down at checkpoints
Iran accused of plotting attack on Green Zone
Detainees abused by coalition troops
US spy balloons blew towards Iran
US fails to answer for deaths of journalists
Apache helicopters kill 14 civilians in hunt for insurgents
How friendly fire from US troops became routine
Killings in the wake of Saddam's hanging
Iraq war logs: An introduction
Phil Shiner: Bringing Britain to book
Hamit Dardagan and John Sloboda: Why Iraq has the right to know the full toll
WikiLeaks v Washington
Live reaction and WikiLeaks address
Peter Beaumont: These crimes were not secret, they were tolerated
Related
Next
Previous
Blog home
Printable version Send to a friend Share Clip Contact us Article history
Comments in chronological order (Total 15 comments)
kerin
22 October 2010 10:01PM
Is that map actually working? All I see is a few 1 or 2 digit numbers in green boxes, but I've no idea what they represent. Are they years? Keys to a datatable? Road junction numbers?
Report abuse
| Link
efields
23 October 2010 12:11AM
The Google fusion table data seems to have no option to export. So in fact it can't be downloaded. Is there another place to find it?
Report abuse
| Link
Noskalator
23 October 2010 5:28AM
Most civilian deaths for 'murder'? What does murder entail? Murder by troops?
Interesting to note the number of civilian deaths from IED explosions. Perhaps a review on their usage is needed?
Report abuse
| Link
DarenB
23 October 2010 9:43AM
so you have some data to play with
Considering the subject, is that the best phrase to use?
Report abuse
coolmule
23 October 2010 11:39AM
No doubt that this information will provide those outside the 'fog-of-war' with a better understanding of what happed. However, we need to remember that the death-count here of over 100,000 Iraqis is that reported by the Allies i.e. the invaders in this war. The infamous quote "We don't do body counts" by Gen Tommy Franks leading US army said it all.
The neutral view on the number of people who died (by respected Lancet medical journal) was over 600,000 deaths by Oct-2006 alone. That research is the best we have and tragically, things are not over yet.
The Guarnaid should make that clear as a footnote to this article.
Report abuse
| Link
joinedup
23 October 2010 2:43PM
I agree with Darren B.
Similarly "Google Fusion tables is fantastic for mapping out bulky datasets and they don't come much bulkier than this" hardly rings with understanding and empathy, more like abstract data techie excitement.
Report abuse
| Link
AntonyIndia
23 October 2010 2:54PM
31,780 deaths by IEDs, of which 2,107 coalition forces, 3,455 insurgents themselves and the vast majority civilians.
Maybe extremist leaders world wide busy on Internet recruiting cannon fodder could just for a minute look at these numbers: IEDs are a losers tactic.
Report abuse
| Link
noKnownPhobia
23 October 2010 7:28PM
@ efields
The Google fusion table data seems to have no option to export. So in fact it can't be downloaded. Is there another place to find it?
Make your own HTML file
This works with Firefox with Firefox set as default browser
Left click spreadsheet field/Select All
Left click spreadsheet field again/View Source
In DOM of selection window: left click/Select All
In DOM of selection window: left click/Copy
Paste in NotePad (text file)
Save as “whatever_file_name.html” <=IMPORTANT
Save type As: select “All Files” <=IMPORTANT
Open “whatever_file_name.html”
Report abuse
| Link
amacd2
23 October 2010 7:50PM
Gosh, the level of detail and perfect record keeping of the American corporatist Empire almost matches that of the Nazi fascist Empire's detailed record keeping.
Oh, that's right ---- a corporatist Empire IS a fascist Empire. That's why Benito Mussolini himself said that fascism should really be called corporatism.
Rumor has it that the chain gun camera video from the earlier Wikileaks release is going to be used in an up-coming FOX video game.
As Chris Hedges compelling notes in his books, including his newest and incomparable "Death of the Liberal Class", imperialist wars for profit are beyond the pale and can never be justified by supposedly humanitarian rational.
Alan MacDonald
Sanford, Maine
Report abuse
| Link
noKnownPhobia
23 October 2010 8:31PM
@amacd2
Paragraphs 1-3 of your comment are wrong on the following counts-
Paragraph 1: The corporatist empire(s) is/are multi-national. The US and most other countries with large militaries answer a global "Admiralty Law" The US is just the worst.
Paragraph 2. As true as it may be, as far as context is concerned, that is an oft quoted misquote. Benito Mussolin never associated the two.
Paragraph 3. Echoing rumor is just wrong
Report abuse
| Link
CanuckDriver
23 October 2010 9:44PM
This comment has been removed by a moderator. Replies may also be deleted.
SimonRogers
23 October 2010 11:54PM
To export the file, go to FILE and EXPORT
Report abuse
TaghioffDaniel
24 October 2010 6:41AM
The summary is simple: This was a very bad idea, and never should have happened.
Also, if wiki-leaks can do this, why could none of the mainstream Media outlets manage something like this in all these years?
Report abuse
| Link
mannuel
24 October 2010 12:52PM

Coalition forces Iraqi forces Civilians Insurgents
direct fire 82 4,270 4,766 6,807
indirect fire ,107 5,990 20,228 3,455
Murder 9 2,169 32,563 73
TOTAL 3,771 15,196 66,081 23,984
From the table it is seen that the civilian casualities are the highest in all forms of combat operations. Wonder whether the american and british soldiers went there to fight saddam Hussain's army or to kill the Iraqi civilians.It is indeed shameful.
Report abuse
| Link
bostonpoliticalgeek
25 October 2010 1:52AM
I would like to see this Baghdad data overlay onto a similar sized American city. It might be impactful to people to see how many deaths would have occurred in their own neighborhoods. Some readers would find the data points - or deaths - landing on their own addresses.
Report abuse
| Link
Comments on this page are now closed.
Comments
Sorry, commenting is not available at this time. Please try again later.
On World news
Last 24 hours
  1. 1. 
    Two packages explode in US government buildings in Maryland
  2. 2.
    Elizabeth Edwards wrote estranged husband out of will
  3. 4.
    Chinese jet fighter 'sighting' raises fears over region's military power balance
  4. 5.
    More than 30 women raped and beaten in DR Congo attack
  5. More most viewed
Last 24 hours
  1. More zeitgeist
Last 24 hours
  1. 1. 
    Eyewitness: Living on the edge
  2. 2.
    William Daley becomes Barack Obama's chief of staff
  3. 3.
    Afghan suicide bomber hits bath house
  4. 4.
    Allen Stanford trial postponed over depression and anxiety drug addiction
  5. 5.
    How the US let al-Qaida get its hands on an Iraqi weapons factory
  6. All today's stories
Top topics on this site
Wikileaks war logs, Afghanistan & Iraq
Coalition government
Factfile UK
Government data
MPs expenses
Afghanistan
Public spending
Population
Defence
Health
Sites we like
Flowing Data
Infostethics
Everyblock
Visual Complexity
Many eyes
Dabble DB
Newsmap
Flickrtime
Google visualisations
Debategraph
Datablog weekly archives
Oct 2010
MTWTFSS
27282930
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Our correspondents on Twitter
Follow all the top stories of the day on Twitter with the Guardian's world news team
guardian_world: Рождеством Христовым - Happy Orthodox Christmas today apparently ...
about 1 hour, 32 minutes ago
guardian_world: Obama reshuffles inner circle to take on Republicans http://t.co/yHRJBDK
about 1 hour, 53 minutes ago
garyyounge: Removing the n word from Huck Finn makes little sense. Erasing references to bigotry doesn't erase its legacy, just distorts memory of it.
about 2 hours, 3 minutes ago
• Read more tweets from our foreign news team
• Follow all our correspondents on a Twitter list
Bestsellers from the Guardian shop
Latest news on guardian.co.uk
Last updated less than one minute ago
News
Party time for England in Sydney as Strauss's men record 3-1 Ashes success
This week's bestsellers
  1. 1. 
    Ultimate Guide to Mad Men
    by Will Dean
    £6.99
  2. 2. 
    Eyewitness Decade
    by Roger Tooth £17.50
  3. 3. 
    Parlour Games for Modern Families
    by Myfanwy Jones £7.99
  4. 4. 
    Women of the Revolution
    by Kira Cochrane £14.99
  5. 5. 
    Millions
    by Frank Boyce £4.79
Search the Guardian bookshop

Find the latest jobs in your sector:
Browse all jobs
Web Producer 100% (m/f), work place: Zurich
Zurich | unspecified
FIFA
Related information
Iraq war logs: WikiLeaks' virtual memorial
24 Oct 2010
Pratap Chatterjee: If the Pentagon had had to disclose details of all casualties in Iraq in real time, the public could have judged 'progress' for itself
Iraq war logs: live reaction and WikiLeaks address
23 Oct 2010
Massive leak of secret files reveals US authorities failed to investigate torture and abuse by Iraqi authorities and 15,000 unknown civilian deaths. Follow live updates
Hot topics
Australia floods
Republicans and Congress
The Ashes
US embassy cables
WikiLeaks
guardian.co.uk © Guardian News and Media Limited 2011
<div><img alt="" src="https://web.archive.org/web/20110107113804im_/http://hits.guardian.co.uk/b/ss/guardiangu-news,guardiangu-network/1/H.22.2/86020?ns=guardian&amp;pageName=Wikileaks+Iraq%3A+data+journalism+maps+every+death%3AGraphic%3A1465136&amp;ch=World+news&amp;c3=GU.co.uk&amp;c4=Iraq%3A+The+war+logs%2CIraq+%28News%29%2CWikiLeaks%2CMilitary+UK%2CUK+news%2CTechnology%2CWorld+news%2CUS+military+%28News%29&amp;c5=Digital+Media%2CNot+commercially+useful%2CCorporate+IT&amp;c6=Simon+Rogers&amp;c7=10-Oct-25&amp;c8=1465136&amp;c9=Graphic&amp;c10=Blogpost&amp;c11=World+news&amp;c13=&amp;c25=Datablog&amp;c30=content&amp;h2=GU%2FWorld+news%2FIraq%3A+The+war+logs&amp;c2=GUID:(none)" width="1" height="1"/></div>
<div><img src="https://web.archive.org/web/20110107113804im_/http://pix01.revsci.net/E05516/a3/0/0/0/0/0/0/0/0/0/noscript.gif" alt=""/></div>
Mobile siteSign inRegister
About usContact usPress officeGuardian Print CentreGuardian readers' editorObserver readers' editorTerms of servicePrivacy policyAdvertising guideDigital archiveDigital editionGuardian WeeklyBuy Guardian and Observer photosSubscribe
The GuardianG2 featuresComment and debateEditorials, letters and correctionsObituariesOther livesSportFilm & musicSubscribe
NewsWorld newsIraq: The war logs