*Do file *The International Criminal Court and Organised Violence: Can Justice Serve Peace? *¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬----------- (transformed from a Stata File) All data is in Stata. version 17.0 use UCDP Georeferenced Event Dataset (GED) Global version 22.1 destring date_start, gen (Date_start) drop date_start rename Date_start date_start destring year, gen (Year) drop year rename Year year destring best, gen (Best) drop best rename Best best destring deaths_civilians, gen (Deaths_civilians) drop deaths_civilians rename Deaths_civilians deaths_civilians gen month=0 replace month=199801 if date_start >19980100 & date_start < 19980200 replace month=199802 if date_start >19980200 & date_start < 19980300 replace month=199803 if date_start >19980300 & date_start < 19980400 replace month=199804 if date_start >19980400 & date_start < 19980500 replace month=199805 if date_start >19980500 & date_start < 19980600 replace month=199806 if date_start >19980600 & date_start < 19980700 replace month=199807 if date_start >19980700 & date_start < 19980800 replace month=199808 if date_start >19980800 & date_start < 19980900 replace month=199809 if date_start >19980900 & date_start < 19981000 replace month=199810 if date_start >19981000 & date_start < 19981100 replace month=199811 if date_start >19981100 & date_start < 19981200 replace month=199812 if date_start >19981200 & date_start < 19981300 replace month=199901 if date_start >19990100 & date_start < 19990200 replace month=199902 if date_start >19990200 & date_start < 19990300 replace month=199903 if date_start >19990300 & date_start < 19990400 replace month=199904 if date_start >19990400 & date_start < 19990500 replace month=199905 if date_start >19990500 & date_start < 19990600 replace month=199906 if date_start >19990600 & date_start < 19990700 replace month=199907 if date_start >19990700 & date_start < 19990800 replace month=199908 if date_start >19990800 & date_start < 19990900 replace month=199909 if date_start >19990900 & date_start < 19991000 replace month=199910 if date_start >19991000 & date_start < 19991100 replace month=199911 if date_start >19991100 & date_start < 19991200 replace month=199912 if date_start >19991200 & date_start < 19991300 replace month=200001 if date_start >20000100 & date_start < 20000200 replace month=200002 if date_start >20000200 & date_start < 20000300 replace month=200003 if date_start >20000300 & date_start < 20000400 replace month=200004 if date_start >20000400 & date_start < 20000500 replace month=200005 if date_start >20000500 & date_start < 20000600 replace month=200006 if date_start >20000600 & date_start < 20000700 replace month=200007 if date_start >20000700 & date_start < 20000800 replace month=200008 if date_start >20000800 & date_start < 20000900 replace month=200009 if date_start >20000900 & date_start < 20001000 replace month=200010 if date_start >20001000 & date_start < 20001100 replace month=200011 if date_start >20001100 & date_start < 20001200 replace month=200012 if date_start >20001200 & date_start < 20001300 replace month=200101 if date_start >20010100 & date_start < 20010200 replace month=200102 if date_start >20010200 & date_start < 20010300 replace month=200103 if date_start >20010300 & date_start < 20010400 replace month=200104 if date_start >20010400 & date_start < 20010500 replace month=200105 if date_start >20010500 & date_start < 20010600 replace month=200106 if date_start >20010600 & date_start < 20010700 replace month=200107 if date_start >20010700 & date_start < 20010800 replace month=200108 if date_start >20010800 & date_start < 20010900 replace month=200109 if date_start >20010900 & date_start < 20011000 replace month=200110 if date_start >20011000 & date_start < 20011100 replace month=200111 if date_start >20011100 & date_start < 20011200 replace month=200112 if date_start >20011200 & date_start < 20011300 replace month=200201 if date_start >20020100 & date_start < 20020200 replace month=200202 if date_start >20020200 & date_start < 20020300 replace month=200203 if date_start >20020300 & date_start < 20020400 replace month=200204 if date_start >20020400 & date_start < 20020500 replace month=200205 if date_start >20020500 & date_start < 20020600 replace month=200206 if date_start >20020600 & date_start < 20020700 replace month=200207 if date_start >20020700 & date_start < 20020800 replace month=200208 if date_start >20020800 & date_start < 20020900 replace month=200209 if date_start >20020900 & date_start < 20021000 replace month=200210 if date_start >20021000 & date_start < 20021100 replace month=200211 if date_start >20021100 & date_start < 20021200 replace month=200212 if date_start >20021200 & date_start < 20021300 replace month=200301 if date_start >20030100 & date_start < 20030200 replace month=200302 if date_start >20030200 & date_start < 20030300 replace month=200303 if date_start >20030300 & date_start < 20030400 replace month=200304 if date_start >20030400 & date_start < 20030500 replace month=200305 if date_start >20030500 & date_start < 20030600 replace month=200306 if date_start >20030600 & date_start < 20030700 replace month=200307 if date_start >20030700 & date_start < 20030800 replace month=200308 if date_start >20030800 & date_start < 20030900 replace month=200309 if date_start >20030900 & date_start < 20031000 replace month=200310 if date_start >20031000 & date_start < 20031100 replace month=200311 if date_start >20031100 & date_start < 20031200 replace month=200312 if date_start >20031200 & date_start < 20031300 replace month=200401 if date_start >20040100 & date_start < 20040200 replace month=200402 if date_start >20040200 & date_start < 20040300 replace month=200403 if date_start >20040300 & date_start < 20040400 replace month=200404 if date_start >20040400 & date_start < 20040500 replace month=200405 if date_start >20040500 & date_start < 20040600 replace month=200406 if date_start >20040600 & date_start < 20040700 replace month=200407 if date_start >20040700 & date_start < 20040800 replace month=200408 if date_start >20040800 & date_start < 20040900 replace month=200409 if date_start >20040900 & date_start < 20041000 replace month=200410 if date_start >20041000 & date_start < 20041100 replace month=200411 if date_start >20041100 & date_start < 20041200 replace month=200412 if date_start >20041200 & date_start < 20041300 replace month=200501 if date_start >20050100 & date_start < 20050200 replace month=200502 if date_start >20050200 & date_start < 20050300 replace month=200503 if date_start >20050300 & date_start < 20050400 replace month=200504 if date_start >20050400 & date_start < 20050500 replace month=200505 if date_start >20050500 & date_start < 20050600 replace month=200506 if date_start >20050600 & date_start < 20050700 replace month=200507 if date_start >20050700 & date_start < 20050800 replace month=200508 if date_start >20050800 & date_start < 20050900 replace month=200509 if date_start >20050900 & date_start < 20051000 replace month=200510 if date_start >20051000 & date_start < 20051100 replace month=200511 if date_start >20051100 & date_start < 20051200 replace month=200512 if date_start >20051200 & date_start < 20051300 replace month=200601 if date_start >20060100 & date_start < 20060200 replace month=200602 if date_start >20060200 & date_start < 20060300 replace month=200603 if date_start >20060300 & date_start < 20060400 replace month=200604 if date_start >20060400 & date_start < 20060500 replace month=200605 if date_start >20060500 & date_start < 20060600 replace month=200606 if date_start >20060600 & date_start < 20060700 replace month=200607 if date_start >20060700 & date_start < 20060800 replace month=200608 if date_start >20060800 & date_start < 20060900 replace month=200609 if date_start >20060900 & date_start < 20061000 replace month=200610 if date_start >20061000 & date_start < 20061100 replace month=200611 if date_start >20061100 & date_start < 20061200 replace month=200612 if date_start >20061200 & date_start < 20061300 replace month=200701 if date_start >20070100 & date_start < 20070200 replace month=200702 if date_start >20070200 & date_start < 20070300 replace month=200703 if date_start >20070300 & date_start < 20070400 replace month=200704 if date_start >20070400 & date_start < 20070500 replace month=200705 if date_start >20070500 & date_start < 20070600 replace month=200706 if date_start >20070600 & date_start < 20070700 replace month=200707 if date_start >20070700 & date_start < 20070800 replace month=200708 if date_start >20070800 & date_start < 20070900 replace month=200709 if date_start >20070900 & date_start < 20071000 replace month=200710 if date_start >20071000 & date_start < 20071100 replace month=200711 if date_start >20071100 & date_start < 20071200 replace month=200712 if date_start >20071200 & date_start < 20071300 replace month=200801 if date_start >20080100 & date_start < 20080200 replace month=200802 if date_start >20080200 & date_start < 20080300 replace month=200803 if date_start >20080300 & date_start < 20080400 replace month=200804 if date_start >20080400 & date_start < 20080500 replace month=200805 if date_start >20080500 & date_start < 20080600 replace month=200806 if date_start >20080600 & date_start < 20080700 replace month=200807 if date_start >20080700 & date_start < 20080800 replace month=200808 if date_start >20080800 & date_start < 20080900 replace month=200809 if date_start >20080900 & date_start < 20081000 replace month=200810 if date_start >20081000 & date_start < 20081100 replace month=200811 if date_start >20081100 & date_start < 20081200 replace month=200812 if date_start >20081200 & date_start < 20081300 replace month=200901 if date_start >20090100 & date_start < 20090200 replace month=200902 if date_start >20090200 & date_start < 20090300 replace month=200903 if date_start >20090300 & date_start < 20090400 replace month=200904 if date_start >20090400 & date_start < 20090500 replace month=200905 if date_start >20090500 & date_start < 20090600 replace month=200906 if date_start >20090600 & date_start < 20090700 replace month=200907 if date_start >20090700 & date_start < 20090800 replace month=200908 if date_start >20090800 & date_start < 20090900 replace month=200909 if date_start >20090900 & date_start < 20091000 replace month=200910 if date_start >20091000 & date_start < 20091100 replace month=200911 if date_start >20091100 & date_start < 20091200 replace month=200912 if date_start >20091200 & date_start < 20091300 replace month=201001 if date_start >20100100 & date_start < 20100200 replace month=201002 if date_start >20100200 & date_start < 20100300 replace month=201003 if date_start >20100300 & date_start < 20100400 replace month=201004 if date_start >20100400 & date_start < 20100500 replace month=201005 if date_start >20100500 & date_start < 20100600 replace month=201006 if date_start >20100600 & date_start < 20100700 replace month=201007 if date_start >20100700 & date_start < 20100800 replace month=201008 if date_start >20100800 & date_start < 20100900 replace month=201009 if date_start >20100900 & date_start < 20101000 replace month=201010 if date_start >20101000 & date_start < 20101100 replace month=201011 if date_start >20101100 & date_start < 20101200 replace month=201012 if date_start >20101200 & date_start < 20101300 replace month=201101 if date_start >20110100 & date_start < 20110200 replace month=201102 if date_start >20110200 & date_start < 20110300 replace month=201103 if date_start >20110300 & date_start < 20110400 replace month=201104 if date_start >20110400 & date_start < 20110500 replace month=201105 if date_start >20110500 & date_start < 20110600 replace month=201106 if date_start >20110600 & date_start < 20110700 replace month=201107 if date_start >20110700 & date_start < 20110800 replace month=201108 if date_start >20110800 & date_start < 20110900 replace month=201109 if date_start >20110900 & date_start < 20111000 replace month=201110 if date_start >20111000 & date_start < 20111100 replace month=201111 if date_start >20111100 & date_start < 20111200 replace month=201112 if date_start >20111200 & date_start < 20111300 replace month=201201 if date_start >20120100 & date_start < 20120200 replace month=201202 if date_start >20120200 & date_start < 20120300 replace month=201203 if date_start >20120300 & date_start < 20120400 replace month=201204 if date_start >20120400 & date_start < 20120500 replace month=201205 if date_start >20120500 & date_start < 20120600 replace month=201206 if date_start >20120600 & date_start < 20120700 replace month=201207 if date_start >20120700 & date_start < 20120800 replace month=201208 if date_start >20120800 & date_start < 20120900 replace month=201209 if date_start >20120900 & date_start < 20121000 replace month=201210 if date_start >20121000 & date_start < 20121100 replace month=201211 if date_start >20121100 & date_start < 20121200 replace month=201212 if date_start >20121200 & date_start < 20121300 replace month=201301 if date_start >20130100 & date_start < 20130200 replace month=201302 if date_start >20130200 & date_start < 20130300 replace month=201303 if date_start >20130300 & date_start < 20130400 replace month=201304 if date_start >20130400 & date_start < 20130500 replace month=201305 if date_start >20130500 & date_start < 20130600 replace month=201306 if date_start >20130600 & date_start < 20130700 replace month=201307 if date_start >20130700 & date_start < 20130800 replace month=201308 if date_start >20130800 & date_start < 20130900 replace month=201309 if date_start >20130900 & date_start < 20131000 replace month=201310 if date_start >20131000 & date_start < 20131100 replace month=201311 if date_start >20131100 & date_start < 20131200 replace month=201312 if date_start >20131200 & date_start < 20131300 replace month=201401 if date_start >20140100 & date_start < 20140200 replace month=201402 if date_start >20140200 & date_start < 20140300 replace month=201403 if date_start >20140300 & date_start < 20140400 replace month=201404 if date_start >20140400 & date_start < 20140500 replace month=201405 if date_start >20140500 & date_start < 20140600 replace month=201406 if date_start >20140600 & date_start < 20140700 replace month=201407 if date_start >20140700 & date_start < 20140800 replace month=201408 if date_start >20140800 & date_start < 20140900 replace month=201409 if date_start >20140900 & date_start < 20141000 replace month=201410 if date_start >20141000 & date_start < 20141100 replace month=201411 if date_start >20141100 & date_start < 20141200 replace month=201412 if date_start >20141200 & date_start < 20141300 replace month=201501 if date_start >20150100 & date_start < 20150200 replace month=201502 if date_start >20150200 & date_start < 20150300 replace month=201503 if date_start >20150300 & date_start < 20150400 replace month=201504 if date_start >20150400 & date_start < 20150500 replace month=201505 if date_start >20150500 & date_start < 20150600 replace month=201506 if date_start >20150600 & date_start < 20150700 replace month=201507 if date_start >20150700 & date_start < 20150800 replace month=201508 if date_start >20150800 & date_start < 20150900 replace month=201509 if date_start >20150900 & date_start < 20151000 replace month=201510 if date_start >20151000 & date_start < 20151100 replace month=201511 if date_start >20151100 & date_start < 20151200 replace month=201512 if date_start >20151200 & date_start < 20151300 replace month=201601 if date_start >20160100 & date_start < 20160200 replace month=201602 if date_start >20160200 & date_start < 20160300 replace month=201603 if date_start >20160300 & date_start < 20160400 replace month=201604 if date_start >20160400 & date_start < 20160500 replace month=201605 if date_start >20160500 & date_start < 20160600 replace month=201606 if date_start >20160600 & date_start < 20160700 replace month=201607 if date_start >20160700 & date_start < 20160800 replace month=201608 if date_start >20160800 & date_start < 20160900 replace month=201609 if date_start >20160900 & date_start < 20161000 replace month=201610 if date_start >20161000 & date_start < 20161100 replace month=201611 if date_start >20161100 & date_start < 20161200 replace month=201612 if date_start >20161200 & date_start < 20161300 replace month=201701 if date_start >20170100 & date_start < 20170200 replace month=201702 if date_start >20170200 & date_start < 20170300 replace month=201703 if date_start >20170300 & date_start < 20170400 replace month=201704 if date_start >20170400 & date_start < 20170500 replace month=201705 if date_start >20170500 & date_start < 20170600 replace month=201706 if date_start >20170600 & date_start < 20170700 replace month=201707 if date_start >20170700 & date_start < 20170800 replace month=201708 if date_start >20170800 & date_start < 20170900 replace month=201709 if date_start >20170900 & date_start < 20171000 replace month=201710 if date_start >20171000 & date_start < 20171100 replace month=201711 if date_start >20171100 & date_start < 20171200 replace month=201712 if date_start >20171200 & date_start < 20171300 replace month=201801 if date_start >20180100 & date_start < 20180200 replace month=201802 if date_start >20180200 & date_start < 20180300 replace month=201803 if date_start >20180300 & date_start < 20180400 replace month=201804 if date_start >20180400 & date_start < 20180500 replace month=201805 if date_start >20180500 & date_start < 20180600 replace month=201806 if date_start >20180600 & date_start < 20180700 replace month=201807 if date_start >20180700 & date_start < 20180800 replace month=201808 if date_start >20180800 & date_start < 20180900 replace month=201809 if date_start >20180900 & date_start < 20181000 replace month=201810 if date_start >20181000 & date_start < 20181100 replace month=201811 if date_start >20181100 & date_start < 20181200 replace month=201812 if date_start >20181200 & date_start < 20181300 replace month=201901 if date_start >20190100 & date_start < 20190200 replace month=201902 if date_start >20190200 & date_start < 20190300 replace month=201903 if date_start >20190300 & date_start < 20190400 replace month=201904 if date_start >20190400 & date_start < 20190500 replace month=201905 if date_start >20190500 & date_start < 20190600 replace month=201906 if date_start >20190600 & date_start < 20190700 replace month=201907 if date_start >20190700 & date_start < 20190800 replace month=201908 if date_start >20190800 & date_start < 20190900 replace month=201909 if date_start >20190900 & date_start < 20191000 replace month=201910 if date_start >20191000 & date_start < 20191100 replace month=201911 if date_start >20191100 & date_start < 20191200 replace month=201912 if date_start >20191200 & date_start < 20191300 replace month=202001 if date_start >20200100 & date_start < 20200200 replace month=202002 if date_start >20200200 & date_start < 20200300 replace month=202003 if date_start >20200300 & date_start < 20200400 replace month=202004 if date_start >20200400 & date_start < 20200500 replace month=202005 if date_start >20200500 & date_start < 20200600 replace month=202006 if date_start >20200600 & date_start < 20200700 replace month=202007 if date_start >20200700 & date_start < 20200800 replace month=202008 if date_start >20200800 & date_start < 20200900 replace month=202009 if date_start >20200900 & date_start < 20201000 replace month=202010 if date_start >20201000 & date_start < 20201100 replace month=202011 if date_start >20201100 & date_start < 20201200 replace month=202012 if date_start >20201200 & date_start < 20201300 drop if year<1998 egen FatalPerMonth =sum( best ), by ( country month ) egen FatalCivilMonth =sum( deaths_civilians ), by ( country month ) egen FatalPerYear =sum( best ), by ( year ) egen FatalCivilYear =sum( deaths_civilians ), by ( country year ) *Specify conflict locations where the same country has many unrelated locations of organized violence replace country = "Aceh" if dyad_dset_id == "794" replace country = "East Timor" if dyad_dset_id == "155" *creating variables that help identify different operations in the same country gen operNr=0 replace operNr=1 if country == "Central African Republic" replace operNr=2 if [country== "Central African Republic" & year>2003 & year<2013] replace operNr=3 if [country== "Central African Republic" & year>2012] replace operNr=1 if country == "Guatemala" replace operNr=2 if [country== "Guatemala" & year>1995] replace operNr=1 if country == "Haiti" replace operNr=2 if [country== "Haiti" & year>2003] replace operNr=1 if country == "Somalia" replace operNr=2 if [country== "Somalia" & year>2000] replace operNr=1 if country == "Liberia" replace operNr=2 if [country== "Liberia" & date_start >20000930] replace operNr=1 if country == "Syria" replace operNr=2 if [country== "Syria" & date_start > 20120929] replace operNr=1 if country == "Serbia (Yugoslavia)" replace operNr=2 if [country== "Serbia (Yugoslavia)" & date_start > 19960323] *creating the variables for comparison of pre-, during- and after operation fatalities *Counting 60, 36 and 12 month pre-ICC fatalities *60 months, DRC sum best if country == "DR Congo (Zaire)" & month >199905 & month < 200406 *36 months, DRC sum best if country == "DR Congo (Zaire)" & month >200105 & month < 200406 *12 months, DRC sum best if country == "DR Congo (Zaire)" & month >200305 & month < 200406 *60 months, Uganda sum best if country == "Uganda" & month >199906 & month < 200407 *36 months, Uganda sum best if country == "Uganda" & month >200106 & month < 200407 *12 months, Uganda sum best if country == "Uganda" & month >200306 & month < 200407 *60 months, Sudan sum best if country == "Sudan" & month >200005 & month < 200506 *36 months, Sudan sum best if country == "Sudan" & month >200205 & month < 200506 *12 months, Sudan sum best if country == "Sudan" & month >200405 & month < 200506 *60 months, CAR I sum best if country == "Central African Republic" & month >200204 & month < 200705 *36 months, CAR I sum best if country == "Central African Republic" & month >200404 & month < 200705 *12 months, CAR I sum best if country == "Central African Republic" & month >200604 & month < 200705 *60 months, CAR II sum best if country == "Central African Republic" & month >200908 & month < 201409 *36 months, CAR II sum best if country == "Central African Republic" & month >201108 & month < 201409 *12 months, CAR II sum best if country == "Central African Republic" & month >201308 & month < 201409 *60 months, Kenya sum best if country == "Kenya" & month >200502 & month < 201003 *36 months, Kenya sum best if country == "Kenya" & month >200702 & month < 201003 *12 months, Kenya sum best if country == "Kenya" & month >200902 & month < 201003 *60 months, Libya sum best if country == "Libya" & month >200602 & month < 201103 *36 months, Libya sum best if country == "Libya" & month >200802 & month < 201103 *12 months, Libya sum best if country == "Libya" & month >201002 & month < 201103 *60 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >200609 & month < 201110 *36 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >200809 & month < 201110 *12 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >201009 & month < 201110 *60 months, Mali sum best if country == "Mali" & month >200712 & month < 201301 *36 months, Mali sum best if country == "Mali" & month >200912 & month < 201301 *12 months, Mali sum best if country == "Mali" & month >200912 & month < 201301 *60 months, Georgia sum best if country == "Georgia" & month >201012 & month < 201601 *36 months, Georgia sum best if country == "Georgia" & month >201212 & month < 201601 *12 months, Georgia sum best if country == "Georgia" & month >201412 & month < 201601 *36 months, Burundi sum best if country == "Burundi" & month >201409 & month < 201710 *12 months, Burundi sum best if country == "Burundi" & month >201609 & month < 201710 *12 months, Palestine sum best if country == "Israel" & month >201811 & month < 201912 *12 months, Bangladesh sum best if country == "Bangladesh" & month >201810 & month < 201911 *10 months, Afghanistan sum best if country == "Afghanistan" & month >201904 & month < 202003 *12 months, Myanmar sum best if country == "Myanmar" & month >201810 & month < 201911 *Results exported to Excel file (calculation of ICC fatalities before and after.xlslx) *Counting 60, 36 and 12 month post-ICC fatalities *60 months, DRC sum best if country == "DR Congo (Zaire)" & month >200405 & month < 200906 *36 months, DRC sum best if country == "DR Congo (Zaire)" & month >200405 & month < 200706 *12 months, DRC sum best if country == "DR Congo (Zaire)" & month >200405 & month < 200506 *60 months, Uganda sum best if country == "Uganda" & month >200406 & month < 200907 *36 months, Uganda sum best if country == "Uganda" & month >200406 & month < 200907 *12 months, Uganda sum best if country == "Uganda" & month >200406 & month < 200707 *60 months, Sudan sum best if country == "Sudan" & month >200505 & month < 201006 *36 months, Sudan sum best if country == "Sudan" & month >200505 & month < 200806 *12 months, Sudan sum best if country == "Sudan" & month >200505 & month < 200606 *60 months, CAR I sum best if country == "Central African Republic" & month >200704 & month < 201205 *36 months, CAR I sum best if country == "Central African Republic" & month >200704 & month < 201005 *12 months, CAR I sum best if country == "Central African Republic" & month >200704 & month < 200805 *60 months, CAR II sum best if country == "Central African Republic" & month >201408 & month < 201909 *36 months, CAR II sum best if country == "Central African Republic" & month >201408 & month < 201709 *12 months, CAR II sum best if country == "Central African Republic" & month >201408 & month < 201509 *60 months, Kenya sum best if country == "Kenya" & month >201002 & month < 201503 *36 months, Kenya sum best if country == "Kenya" & month >201002 & month < 201303 *12 months, Kenya sum best if country == "Kenya" & month >201002 & month < 201103 *60 months, Libya sum best if country == "Libya" & month >201102 & month < 201603 *36 months, Libya sum best if country == "Libya" & month >201102 & month < 201403 *12 months, Libya sum best if country == "Libya" & month >201102 & month < 201203 *60 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >201110 & month < 201610 *36 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >201110 & month < 201410 *12 months, Cote d Ivoire sum best if country == "Ivory Coast" & month >201110 & month < 201210 *60 months, Mali sum best if country == "Mali" & month >201300 & month < 201801 *36 months, Mali sum best if country == "Mali" & month >201300 & month < 201601 *12 months, Mali sum best if country == "Mali" & month >201300 & month < 201401 *60 months, Georgia sum best if country == "Georgia" & month >201600 & month < 202101 *36 months, Georgia sum best if country == "Georgia" & month >201600 & month < 201901 *12 months, Georgia sum best if country == "Georgia" & month >201600 & month < 201701 *36 months, Burundi sum best if country == "Burundi" & month >201709 & month < 202010 *12 months, Burundi sum best if country == "Burundi" & month >201709 & month < 201810 *12 months, Palestine sum best if country == "Israel" & month >201911 & month < 202012 *12 months, Bangladesh sum best if country == "Bangladesh" & month >201910 & month < 202011 *10 months, Afghanistan sum best if country == "Afghanistan" & month >202002 & month < 202012 *12 months, Myanmar sum best if country == "Myanmar" & month >201910 & month < 202011 *Results exported to Excel file (calculation of ICC fatalities before and after.xlslx) *Creation of Monthly data sort country month quietly by country month : gen dub = cond( _N==1,0,_n) drop if dub>1 *Generating months-variable for graphs, Libya drop if country =/= "Libya" gen Months = tm(1998m1)+_n-1 format %tm Months tsset Months *Creation of graphs for the article twoway (scatter FatalPerMonth Month )(lowess FatalPerMonth Month ) if country == "Libya" *same for all countries