Looking at only incidents where CivilianKIA was greater than 0, I got 1458 events. In OpenOffice Calc (after downloading the convert text-to-numbers extension) I used DataPilot to divide these incidents
by Type:
Air Mission 2
Criminal Event 99
Enemy 1
Enemy Action 716
Explosive Hazard 2650
Friendly Action 162
Friendly Fire 34
Non-Combat Event 309
Other 19
Suspicious Incident 2
Total Result 3994
And by Category:
Accident 120
Ambush 62
ANA-on-ANP 1
ANP Training 12
Arrest 1
Arson 2
ARTY 4
Assassination 38
ATTACK 94
BLUE-GREEN 6
Looking at only incidents where CivilianKIA was greater than 0, I got 1458 events. In OpenOffice Calc (after downloading the convert text-to-numbers extension) I used DataPilot to divide these incidents
by Type:
Air Mission 2
Criminal Event 99
Enemy 1
Enemy Action 716
Explosive Hazard 2650
Friendly Action 162
Friendly Fire 34
Non-Combat Event 309
Other 19
Suspicious Incident 2
Total Result 3994
And by Category:
Accident 120
Ambush 62
ANA-on-ANP 1
ANP Training 12
Arrest 1
Arson 2
ARTY 4
Assassination 38
ATTACK 94
BLUE-GREEN 6
Blue-White 4
Carjacking 1
Close Air Support 12
Cordon/Search 3
Criminal Activity 1
Deliberate Attack 1
Demonstration 70
Direct Fire 351
Enemy Action 1
Escalation of Force 58
GREEN-GREEN 10
Green-White 3
Hard Landing 2
IDF Counter Fire 1
IED Ambush 44
IED Explosion 2143
IED Found/Cleared 303
Indirect Fire 98
Interdiction 7
Kidnapping 3
MEDEVAC 15
MEDEVAC (Local National) 16
Mine Found/Cleared 11
Mine Strike 56
Murder 67
Natural Disaster 100
Other 76
Other (Hostile Action) 71
OTHER OFFENSIVE 10
Patrol 2
Planned Event 7
Police Actions 1
Premature Detonation 29
RPG 1
SAFIRE 1
Surveillance 4
Theft 8
Tribal 10
Tribal Feud 3
UNEXPLODED ORDNANCE 11
Unknown Explosion 39
Total Result 3994
So, there are a total of 3994 civilian deaths in the Afghan War Diary. Most of them are attributed to Enemy Action (716) or Explosive Hazard (2650). Checking these numbers against the media data on civilian deaths (passive sampling) would be useful. It would also be useful to compare these to any data the Afghans have.
I will do military deaths next.
