Wikileaks Iraq: data journalism maps every death
Iraq-civilian-casualties-006.jpg
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
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
Click heading to sort
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
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
[You must be registered and logged in to see this link.]
Iraq-civilian-casualties-006.jpg
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
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
Click heading to sort
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
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
[You must be registered and logged in to see this link.]
Yesterday at 4:55 pm by Rocky
» utube 5/9/24 MM&C 0:02 / 46:46 PM - Al-Sudani - Golden Opportunity - Private Sector - Contra
Yesterday at 9:38 am by Rocky
» A leader in the National Bank: We are committed to the federal decision and to postpone the election
Yesterday at 9:28 am by Rocky
» Al-Hakim: Iraq's future cannot be mortgaged to volatile oil prices
Yesterday at 9:24 am by Rocky
» The conflict of the corridors: the path to development from a historical perspective and the door to
Yesterday at 9:22 am by Rocky
» The Kurdistan Region demands that the federal government spend 1.1 billion dinars.. What is the reas
Yesterday at 9:21 am by Rocky
» Tomorrow, Iraq is preparing to launch a complementary round of gas licensing
Yesterday at 9:19 am by Rocky
» A government move to restore the funds of the Trade Bank of Iraq
Yesterday at 9:17 am by Rocky
» The Central Bank informs France of plans to restructure the banking sector
Yesterday at 9:15 am by Rocky
» A government advisor reveals the fate of the budget tables
Yesterday at 9:13 am by Rocky
» Iranian mediation between Baghdad and Erbil... Revealing the most prominent files of Raisi’s visit t
Yesterday at 9:10 am by Rocky
» Reconstruction and development is a priority.. A parliamentary committee follows up and monitors gov
Yesterday at 9:08 am by Rocky
» Al-Hakim comments on the agreements concluded with Türkiye and confirms: Iraq is on the right path
Yesterday at 9:06 am by Rocky
» Tomorrow... Iraq takes a step that will give it gas equivalent to 200% of imported Iranian gas
Yesterday at 9:04 am by Rocky
» A long and disturbing message.. The Iraqi government “blames” the United Nations because of “other p
Yesterday at 9:00 am by Rocky
» The Governor of the Central Bank and the French Ambassador discuss developments in the banking secto
Yesterday at 5:18 am by Rocky
» Al-Bajari: Iraqi companies will have a great opportunity to work after opening the door to investmen
Yesterday at 5:16 am by Rocky
» Transparency: Imports from Sulaymaniyah and Halabja during the past week amounted to more than 10 bi
Yesterday at 5:13 am by Rocky
» Al-Sudani: The delayed projects left great damage to the level of services in Babylon
Yesterday at 5:12 am by Rocky
» Economist: The fluctuation of the dollar is “the balance of speculators”
Yesterday at 5:10 am by Rocky
» {Al-Furat News} publishes the text of Al-Sudani’s request to Guterres to end UNAMI’s work in Iraq
Yesterday at 5:08 am by Rocky
» A former MP accuses Türkiye of transferring its conflict with the workers to Iraq
Yesterday at 5:05 am by Rocky
» A call to the Sudanese to remove American forces from Iraq
Yesterday at 5:03 am by Rocky
» Oil Parliament: Ankara holds Erbil responsible for the oil fines it owes
Yesterday at 5:02 am by Rocky
» The government is silent...the reality of removing American forces from Iraq
Yesterday at 5:01 am by Rocky
» The radiation protection law in the first session of the next legislative term
Yesterday at 5:00 am by Rocky
» A Spanish company raises controversy and a representative reveals a parliamentary movement against i
Yesterday at 4:59 am by Rocky
» Sudanese officially requests the end of the United Nations mission in Iraq / documents
Yesterday at 4:58 am by Rocky
» Because its sessions were not held, the Kirkuk Council faces a judicial complaint, and its members d
Yesterday at 4:56 am by Rocky
» Former US Chief of Staff: We slaughtered huge numbers of innocent people in Iraq and other countries
Yesterday at 4:55 am by Rocky
» The Association of Private Banks counts the percentage of shares traded on the stock market during a
Yesterday at 4:53 am by Rocky
» The European Union and Iraq agree to increase cooperation between them
Yesterday at 4:52 am by Rocky
» American Bank: Expectations to increase Iraq’s oil capacity in 2025
Yesterday at 4:50 am by Rocky
» Central Bank Governor to the French Ambassador: The plan to restructure government banks will change
Yesterday at 4:48 am by Rocky
» Integrity confirms working to conclude a memorandum of understanding with the Kuwaiti Anti-Corruptio
Yesterday at 4:47 am by Rocky
» Highlights of the Prime Minister's visit to Babylon
Yesterday at 4:46 am by Rocky
» The Minister of Transport discusses with a Turkish delegation the latest developments in the develop
Yesterday at 4:44 am by Rocky
» Free of charge.. Issuing approximately 13 thousand unified cards for those covered by social protect
Yesterday at 4:42 am by Rocky
» A parliamentary committee advises the government to deter trespassers: Slums are one of the reasons
Yesterday at 4:41 am by Rocky
» Embassy Protection confirms to “Baghdad Today”: The missions are safe and we have taken proactive me
Yesterday at 4:38 am by Rocky
» Water resources resolve the controversy of the “Wadi Al-Tea” project.. It will nourish the Hamrin ic
Yesterday at 4:37 am by Rocky
» After approving the National Security Strategy...a parliamentary movement to host “responsible” figu
Yesterday at 4:36 am by Rocky
» Al-Hakim calls for the distribution of plots of land to the families of the martyrs of the Popular M
Yesterday at 4:34 am by Rocky
» Order 160 Committee completes the “port scandals” papers... and searches for a legal outlet for impl
Yesterday at 4:33 am by Rocky
» It revealed the details of its contract with four companies to complete the census requirements... P
Yesterday at 4:31 am by Rocky
» Egypt, Morocco and Qatar praise the Iraqi Integrity proposal to establish the Arab Law Enforcement C
Yesterday at 4:30 am by Rocky
» The Iraqi Parliament enters its legislative recess and requires holding an “extraordinary” session o
Yesterday at 4:28 am by Rocky
» The Sudanese has not rested since the morning.. He carried out 12 activities and allocated a trillio
Yesterday at 4:27 am by Rocky
» Blinken's agent: Erbil is a strategic ally of Washington in a 360-degree relationship
Yesterday at 4:25 am by Rocky
» Oil seeks to convert refinery products to “Euro 5”... high quality and environmentally friendly
Yesterday at 4:24 am by Rocky
» A leader in the framework: There is no need for early elections...the “legislative” elections will t
Yesterday at 4:23 am by Rocky
» Parliament decides to extend its legislative term by 30 days
Yesterday at 4:22 am by Rocky
» Iraq has the tenth worst economic growth in the world during the last 5 years
Yesterday at 4:19 am by Rocky
» Al-Hakim: The future cannot be mortgaged to volatile oil prices
Yesterday at 4:17 am by Rocky
» It will change the reality of Iraqi banks.. Al-Alaq reveals a plan that enjoys Sudanese support
Yesterday at 4:15 am by Rocky
» MM&C 5/9/24 The Federation of Chambers of Commerce and the European Union discuss cooperation to fin
Thu 09 May 2024, 9:27 am by Rocky
» MM&C 5/9/24 Customs, security and economic aspects
Thu 09 May 2024, 9:24 am by Rocky
» Union of Arab Banks: Iraq's environment encourages investment
Thu 09 May 2024, 6:57 am by Rocky
» Government advisor: Movement to recover bad debts for the benefit of the Iraqi Trade Bank
Thu 09 May 2024, 6:55 am by Rocky
» The International Development Bank announces the opening of its new branch in Erbil
Thu 09 May 2024, 6:52 am by Rocky
» Oil seeks to convert refinery products to “Euro 5”... high quality and environmentally friendly
Thu 09 May 2024, 6:50 am by Rocky
» Budget delay: the cry for help for paralyzed services and disrupted dreams
Thu 09 May 2024, 6:47 am by Rocky
» Oil: Completion of projects to improve the quality of petroleum products, and others are under imple
Thu 09 May 2024, 6:44 am by Rocky
» Chairman of the Securities Commission: 3 million shares, average daily trading volume
Thu 09 May 2024, 6:43 am by Rocky
» Tamim calls on the countries participating in the meetings of the Arab Administrative Development Or
Thu 09 May 2024, 6:41 am by Rocky
» Parliamentary Endowments: 39 thousand pilgrims, Iraq’s share, and waiving the religious obligation i
Thu 09 May 2024, 6:39 am by Rocky
» Washington refers to Iraqi legislation that “does not harm” his international presence, and Baghdad
Thu 09 May 2024, 6:34 am by Rocky
» Deputy: Extending the legislative term depends on sending the budget schedules
Thu 09 May 2024, 6:30 am by Rocky
» Parliamentary Legal: 88 draft laws on the parliamentary shelf
Thu 09 May 2024, 6:29 am by Rocky
» The head of the movement denies any Iraqi-American negotiations to remove the coalition
Thu 09 May 2024, 5:23 am by Rocky
» A deputy expects to resolve the issue of electing the Speaker of Parliament next week
Thu 09 May 2024, 5:22 am by Rocky
» Obtaining the approval of the Minister of Electricity to fill the energy shortage in Dhi Qar
Thu 09 May 2024, 5:21 am by Rocky
» Economist on the decline in dollar prices: My time and it will not reach its official price
Thu 09 May 2024, 5:20 am by Rocky
» The Iraqi Ministerial Council for National Security approves the 2024-2028 strategy
Thu 09 May 2024, 5:18 am by Rocky
» Mulla Bakhtiar: Nechirvan Barzani's visit to Iran melted the ice between Erbil and Tehran
Thu 09 May 2024, 5:17 am by Rocky
» Password "78"... Why did the Sudanese government's interrogations and noisy sessions decline?
Thu 09 May 2024, 5:16 am by Rocky
» JP Morgan forecasts an increase in the oil capacity of Iraq and other countries in 2025
Thu 09 May 2024, 5:15 am by Rocky
» Turkish Minister of Transport: The development road will cost $20 billion
Thu 09 May 2024, 5:13 am by Rocky
» The Supreme Committee for Reconstruction and Investment approves a package of strategic projects
Thu 09 May 2024, 5:12 am by Rocky
» Work: Preparing a unified national strategy to create job opportunities for youth
Thu 09 May 2024, 5:11 am by Rocky
» The Prime Minister's financial advisor reduces the risks of the budget deficit
Thu 09 May 2024, 5:10 am by Rocky
» Sudanese announces the signing of an agreement with Japan to finance small and medium enterprises in
Thu 09 May 2024, 5:09 am by Rocky
» Government Advisor: The Securities Commission represents the governance base for promoting financial
Thu 09 May 2024, 5:08 am by Rocky
» A unified national strategy to create job opportunities for youth
Thu 09 May 2024, 5:07 am by Rocky
» A one-week deadline to decide the position of Speaker of Parliament
Thu 09 May 2024, 5:06 am by Rocky
» Parliament: We coordinate with the competent regulatory authorities to examine medicines
Thu 09 May 2024, 5:04 am by Rocky
» The Commission suspends the Kurdistan Parliament's voting procedures
Thu 09 May 2024, 5:03 am by Rocky
» $100 million to localize the pharmaceutical industry
Thu 09 May 2024, 5:01 am by Rocky
» Increase in external remittances at the Central Bank
Thu 09 May 2024, 5:00 am by Rocky
» A government advisor reduces the risks of a budget deficit
Thu 09 May 2024, 4:54 am by Rocky
» Culture: We seek to invest in the stability of the country to advance the tourism sector
Thu 09 May 2024, 4:53 am by Rocky
» Integrity announces the results of a questionnaire on bribery in real estate registration department
Thu 09 May 2024, 4:50 am by Rocky
» Parliament comments on Sudanese plan to restructure the government apparatus: It needs radical refor
Thu 09 May 2024, 4:49 am by Rocky
» The dollar rises again against the Iraqi dinar in Baghdad
Thu 09 May 2024, 4:45 am by Rocky
» Politician: The government does not deal transparently with the issue of expelling the Americans
Thu 09 May 2024, 4:43 am by Rocky
» A government bank participating in an accounting project
Thu 09 May 2024, 4:42 am by Rocky
» Masrour Barzani: The Kurdistan Regional Government has implemented all its obligations and duties
Thu 09 May 2024, 4:41 am by Rocky
» French Consul: France strengthens relations with the Kurdistan Region
Thu 09 May 2024, 4:39 am by Rocky
» Studies Center: Sudanese faces the challenges of maintaining sustainable relations with the United S
Thu 09 May 2024, 4:38 am by Rocky