Afgan War Diary in Numbers
Wikileaks has released a document set called the Afgan War Diary, on July 25, 2010, an extraordinary compendium of over 91,000 reports covering the war in Afghanistan from 2004 to 2010. For more information visit http://wikileaks.org/wiki/Afghan_War_Diary,_2004-2010.
In this post I present this endless insane war in numbers. All numbers were taken from "Afgan War Diary" and manipulated using a MySQL database. It must be noted that 75.000 over 91.000 reports were released.
Section 1-Civilians Killed In Action
2004: 219 were killed
2005: 178 were killed
2006: 800 were killed
2007: 758 were killed
2008: 798 were killed
2009: 1241 were killed
Total civilians were killed during the period 2004-2009: 3994
Section 2-Civilians Wounded In Action
2004: 208 were wounded
2005: 454 were wounded
2006: 1794 were wounded
2007: 1962 were wounded
2008: 1980 were wounded
2009: 2646 were wounded
Total civilians were wounded during the period 2004-2009: 9044
Section 3-Enemies Killed In Action
2004: 343 were killed
2005: 890 were killed
2006: 2689 were killed
2007: 4044 were killed
2008: 2816 were killed
2009: 4437 were killed
Total enemies were killed during the period 2004-2009: 15219
Section 4-Enemies Wounded In Action
2004: 93 were wounded
2005: 200 were wounded
2006: 252 were wounded
2007: 377 were wounded
2008: 285 were wounded
2009: 617 were wounded
Total enemies were wounded during the period 2004-2009: 1824
Section 5-Friendly Killed In Action
2004: 22 were killed
2005: 71 were killed
2006: 142 were killed
2007: 186 were killed
2008: 244 were killed
2009: 481 were killed
Total friendly were killed during the period 2004-2009: 1146
Section 6-Friendly Wounded In Action
2004: 133 were wounded
2005: 480 were wounded
2006: 1083 were wounded
2007: 1652 were wounded
2008: 1255 were wounded
2009: 2693 were wounded
Total friendly were wounded during the period 2004-2009: 7296
Section 7-HostNation Killed In Action
2004: 218 were killed
2005: 180 were killed
2006: 605 were killed
2007: 951 were killed
2008: 699 were killed
2009: 1143 were killed
Total HostNations were killed during the period 2004-2009: 3796
Section 8-HostNation Wounded In Action
2004: 316 were wounded
2005: 504 were wounded
2006: 1379 were wounded
2007: 2093 were wounded
2008: 1749 were wounded
2009: 2444 were wounded
Total HostNations were wounded during the period 2004-2009: 8503
Total Killed: 24155
Total Wounded: 26667




















August 2nd, 2010 - 10:51
Congratulations! You got a major story of the files. But there is one more numeric column in the table: EnemyDetained. If you will look into this, you will see the following, ED as shortcut for EnemyDetained:
Year____ED
2004___623
2005___664
2006___559
2007___888
2008___754
2009__1573
Out of this, it’s possible to calculate a (enemy kill/enemy capture) ratio for each year. 2004 it were many more enemies captured than killed, but than it changed. Now it’s many more enemies killed than captured.
October 8th, 2010 - 09:04
1 out of every 4 Afghans killed is a civilian. good aiming USA!