Pakistan/Yemen/Somalia Strike Data

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	PAKISTAN/YEMEN/SOMALIA DATA FROM NAF, LWJ AND TBIJ
2	New American Foundation (NAF) Data		Airstrikes in General (mostly drone), Pakistan and Yemen
3		Combined Totals (Pakistan, Yemen and Somalia), 2009-2016 (as of 9 June 2016)						Pakistan Data	as of 9 June 2016					Yemen Data	as of 9 June 2016				Somalia Data	as of 9 June 2016
4	Year	Strikes	Low End Civilian	High End Civilian Deaths	Average Civilian Deaths	Low End Proportion of Civilian deaths to strikes		Pakistan Strikes	non-drone, non-Obama	Pakistan Low End Civilian Casualties	Pak High End Civilian Casualties	Average civ cas		Yemen Strikes		Yemen Low End	Yemen High End		Somalia Strikes	how many were non-drone	Somalia Low End civilian casualties
5	2009	57	98	108	103	1.719298	2009	54	2 were Bush, but no civilian casualties	57	67	62	2009	2	NAF says both non-drone; 1 was definite missile (al-Majala), and in the other the weapons system was unclear according to TBIJ; both were Obama strikes	41	41	2009	1	NAF says 1 of 1 were non-drone	0	0
6	2010	101	18	25	21.5	0.178218	2010	100		14	19	16.5	2010	1		4	6	2010	0	0	0	0
7	2011	88	53	67	60	0.602273	2011	72		49	63	56	2011	12	NAF says 3 of the 12 strikes were non-drone	4	4	2011	4	NAF says 2 of the 4 were non-drone	0	0
8	2012	106	20	21	20.5	0.188679	2012	48		4	5	4.5	2012	56	NAF says 9 of the 56 strikes were non-drone	16	16	2012	2		0	0
9	2013	53	20	26	23	0.377358	2013	26		3	5	4	2013	25	NAF says 1 of the 25 strikes was non-drone	17	21	2013	2	NAF says 1 of 2 were non-drone	0	0
10	2014	42	5	5	5	0.119048	2014	22		0	0	0	2014	17		5	5	2014	3		0	0
11	2015	39	2	2	2	0.051282	2015	10		2	2	2	2015	24		0	0	2015	5	NAF says 1 of the 5 were non-drone	0	0
12	2016	28	0	3	1.5	0	2016	3		0	0	0	2016	16	NAF says 1 of the 16 was not a drone strike	0	0	2016	9	NAF says 4 of 9 were non-drone	0	3
13	Totals	514	216	257	236.5	0.420233
14
15	Long War Journals (LWJ) Data	Combined Data (Pakistan and Yemen), 2009-2016 (as of 9 June 2016)				LWJ Breakdown	Pakistan	as of 9 June 2016			Yemen	as of 9 June 2016
16		strikes	Civilian Deaths	proportion: civ/strikes			Pakistan Strikes	Pakistan Civilian Deaths	Civilian Deaths/strike		Yemen: Strikes		civilian deaths
17	2009	55	84	1.527273		2009	53	43	0.811321		2	al-majala, etc.	41
18	2010	121	20	0.165289		2010	117	14	0.119658		4		6
19	2011	74	30	0.405405		2011	64	30	0.46875		10		0
20	2012	87	39	0.448276		2012	46	4	0.086957		41		35
21	2013	54	31	0.574074		2013	28	14	0.5		26		17
22	2014	47	6	0.12766		2014	24	0	0		23		6
23	2015	34	2	0.058824		2015	11	2	0.181818		23		0
24	2016	20	0	0		2016	2	0	0		18		0
25	Totals	492	212	0.430894
26
27	The Bureau of Investigative Journalism (TBIJ) Data)	Combined Data (Pakistan, Yemen and Somalia), 2009-2016 (as fo 9 June 2016)								Pakistan				Yemen	as of June 9 2016				Somalia	as of 9 June 2016
28		Strikes(average)	Strikes (low)	Low End Civilian	High End Civilian	Average Civilian	Low End Proportion (civ/strike)	Average Proportion (civ/strike)		Pak Strikes	Pak Min Civilians Killed	Pak Max Civilians Killed	Avg. Civ Killed	Min strikes	Max Strikes	Minimum Civilians	Maximum Civilians		Minimum Strikes	Max Strikes	Min Civ deaths	Max Civ Deaths
29	2009	54	54	100	210	155	1.851852	2.87037	?pre-Obama strikes?	54	100	210	155	0	0	0	0		0	0	0	0
30	2010	128	128	89	197	143	0.695313	1.117188		128	89	197	143	0	0	0	0		0	0	0	0
31	2011	96	87	88	188	138	0.916667	1.4375		75	52	152	102	11	14	36	36		1	4	0	0
32	2012	115.5	89	20	76	48	0.17316	0.415584		50	13	63	38	37	51	7	12		2	2	0	1
33	2013	61.5	50	17	41	29	0.276423	0.471545		27	0	4	2	22	22	17	37		1	1	0	0
34	2014	56	45	4	13	8.5	0.071429	0.151786		25	0	2	1	17	19	4	9		3	3	0	2
35	2015	62	45	3	16	9.5	0.048387	0.153226		13	2	5	3.5	21	22	1	7		11	12	0	4
36	2016	33	23	4	4	4	0.121212	0.121212		3	1	1	1	12	12	0	0		8	8	3	3
37		606	521							375				120					26
38
39	Combined Totals for NAF, LWJ, TBIJ Using Averages (for strikes and civilians)
40		Strikes (Average)	Strikes (Low End)	Civilian Casualties (Low End)	Avgerage Civlian Casualties	Civilian Casualties (Low End)/Avgerage Strike Proportion (Civ/Strike)	Civilian Casualties (Average)/Strikes (Average) Proportion (civ/strike)	Civilain Casualties (Low End)/Strike (Low End)
41	2009	55.33333	55.33333	94	114	1.698795	2.060241	1.698795
42	2010	116.6667	116.6667	42.33333	61.5	0.362857	0.527143	0.362857
43	2011	86	83	57	76	0.662791	0.883721	0.686747
44	2012	102.8333	94	26.33333	35.83333	0.256078	0.34846	0.280142
45	2013	56.16667	52.33333	22.66667	27.66667	0.403561	0.492582	0.433121
46	2014	48.33333	44.66667	5	6.5	0.103448	0.134483	0.11194
47	2015	45	39.33333	2.333333	4.5	0.051852	0.1	0.059322
48	2016	36.66667	23.66667	1.333333	1.833333	0.036364	0.05	0.056338
49	Totals	547	509	251	327.8333	0.458867	0.59933	0.493124
50
51	2014-2016	130	107.6667	8.666667		Civilian Casualies/Total Strikes (2014-2016)	0.066667
52
53	Airwars Data for Iraq and Syria	Strikes	Minimum Civilian Deaths	Minimum Civilian Deaths/Strikes
54	2014-2016 (as of 9 June 2016)	12896	1278	0.0991
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100