How we arrived at this figure Contrary to what the police say, we found that half of all homicides under investigation in the three Metro Manila municipalities we reported on are linked to drugs. This document explains how we made this calculation. The National Capital Region Police Office (NCRPO) provided a spreadsheet of all homicides under investigation from July 2016 to the end of 2018. A copy of that spreadsheet is on page 2 of this document. According to the NCRPO, the number of homicides in the three cities are as follows: City Total Homicides Reported by the Police (July 2016 to December 2017) Quezon City 615 Manila 507 Caloocan 759 Total 1,881 The total number of drug-related homicides that we found from police records is 934 as shown in the following table: City Drug-Related Homicides (July 2016 to December 2017) in the Police Record* Quezon City 312 Manila 178 Caloocan 444 Total 934 ● Note that there are other homicides that have not been recorded by the police. We found nearly 300 more casualties from news reports, human rights groups, churches and other sources. We divided 934 by 1,881 and got 0.496 or about half. The police say that nationwide, only 10% of all reported homicides are drug-related. Our calculation shows that figure is closer to 50% in the three Metro Manila cities that are the focus of the study. But we also found many other drug-linked homicides that have not been recorded by the police, so this figure is at best an approximation. A database that lists all drug-linked homicides we found from multiple sources, not just the police, can be found here: ​https://data.world/stabile-center/ph-drug-war​. Homicld. can, Undgr muestlgatlon Jul!?F 1. 21316 - December a1, 2013 Incident Count Imum: [Imam n1 DISTRICT 1 STATION 11131-0111: 21111: 2111? Pol Fi?ainocan 4151' 302 Pal 2 Halaban :19 56 Pol 8111 3 50 1213 Pal 4 3:1 40 - TOTAL 3511 Pol 1 arikina 25 E53 P01 5m 2 Pol 8111 3 51' 55 P015111 -1 San Juan} 23 13 EPD - TDTAL 2:14 134 Pal Sm 1 Rana a 4B 13 Pm Sin 2 ends3111 Sta. 1U 16 3111 .A 19 2? Pol 5111 3 11 Pal 31:11 9 3 13 Pal $111 10 3 5 P01 511] 11 M31511: 11 14 TOTAL 191 Pol 3111 1 1411- 54 F111 8111 2 BE 52 FIJI 5111 234