*Do file *Whose Conflict Prevention Works: Strong States vs. The Legitimate World Organisation *daily data (for Stata 17) version 17.0 use UCDP Georeferenced Event Dataset (GED) Global version 21.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 *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 *IDENTIFYING TIME PERIODS DURING, BEFORE AND AFTER UN MISSIONS gen preUnilat=0 gen preUN=0 gen durUnilat=0 gen durUN=0 gen afterUN=0 gen afterUnilat=0 replace durUN=1 if [country== "Angola" & date_start > 19881219 & date_start < 19990227 ] replace afterUN=1 if [country== "Angola" & date_start > 19990226 & date_start < 20020227 ] replace durUN=1 if [country== "Bosnia-Herzegovina" & date_start > 19920220 & date_start < 20021232 ] replace preUN=1 if [country== "Bosnia-Herzegovina" & date_start > 19890220 & date_start < 19920221 ] replace afterUN=1 if [country== "Bosnia-Herzegovina" & date_start > 20021231 & date_start < 20051232 ] replace durUN=1 if [country== "Cambodia (Kampuchea)" & date_start > 19911015 & date_start < 19930316 ] replace preUN=1 if [country== "Cambodia (Kampuchea)" & date_start > 19881016 & date_start < 19911016 ] replace afterUN=1 if [country== "Cambodia (Kampuchea)" & date_start > 19930315 & date_start < 19960316 ] replace durUN=1 if [country== "Burundi" & date_start > 20040520 & date_start < 20061232 ] replace preUN=1 if [country== "Burundi" & date_start > 20010520 & date_start < 20040521 ] replace afterUN=1 if [country== "Burundi" & date_start > 20061231 & date_start < 20091232 ] replace durUN=1 if [country== "Central African Republic" & date_start > 19980326 & date_start < 20000216 ] replace preUN=1 if [country== "Central African Republic" & date_start > 19950326 & date_start < 19980327 ] replace afterUN=1 if [country== "Central African Republic" & date_start > 20000216 & date_start < 20030216 ] replace durUN=1 if [country== "Central African Republic" & date_start > 20070924 & date_start < 20101232 ] replace preUN=1 if [country== "Central African Republic" & date_start > 20040924 & date_start < 20070925 ] replace afterUN=1 if [country== "Central African Republic" & date_start > 20101231 & date_start < 20121232 ] replace durUN=1 if [country== "Central African Republic" & date_start > 20140914 ] replace preUN=1 if [country== "Central African Republic" & date_start > 20121232 & date_start < 20140515 ] replace durUN=1 if [country== "Ivory Coast" & date_start > 20130512 & date_start < 20170631 ] replace preUN=1 if [country== "Ivory Coast" & date_start > 20100512 & date_start < 20130513 ] replace afterUN=1 if [country== "Ivory Coast" & date_start > 20170630 & date_start < 20200631 ] replace durUN=1 if [country== "Croatia" & date_start > 19950330 & date_start < 20021216 ] replace preUN=1 if [country== "Croatia" & date_start > 19920330 & date_start < 19950331 ] replace afterUN=1 if [country== "Croatia" & date_start > 20021215 & date_start < 20051216 ] replace durUN=1 if [country== "DR Congo (Zaire)" & date_start > 19991129 ] replace preUN=1 if [country== "DR Congo (Zaire)" & date_start > 19961129 & date_start < 19991130 ] replace durUN=1 if [country== "Ethiopia" & date_start > 20000600 & date_start < 20080732 ] replace preUN=1 if [country== "Ethiopia" & date_start > 19970600 & date_start < 20000601 ] replace afterUN=1 if [country== "Ethiopia" & date_start > 20080731 & date_start < 20110732 ] replace durUN=1 if [country== "Eritrea" & date_start > 20000600 & date_start < 20080732 ] replace preUN=1 if [country== "Eritrea" & date_start > 19970600 & date_start < 20000601 ] replace afterUN=1 if [country== "Eritrea" & date_start > 20080731 & date_start < 20110732 ] replace durUN=1 if [country== "Georgia" & date_start > 19930823 & date_start < 20090732 ] replace preUN=1 if [country== "Georgia" & date_start > 19900823 & date_start < 19930824 ] replace afterUN=1 if [country== "Georgia" & date_start > 20090731 & date_start < 20120732 ] replace durUN=1 if [country== "Guatemala" & operNr == 1 & date_start > 19891106 & date_start < 19920118 ] replace preUN=1 if [country== "Guatemala" & date_start > 19861106 & operNr == 1 & date_start < 19891107] replace afterUN=1 if [country== "Guatemala" & date_start < 19950118 & operNr == 1 & date_start > 19920117] replace durUN=1 if [country== "Guatemala" & date_start > 19970103 & operNr == 2 & date_start < 19970523 ] replace preUN=1 if [country== "Guatemala" & date_start > 19950522 & operNr == 2 & date_start < 19970104] replace afterUN=1 if [country== "Guatemala" & date_start > 19970522 & operNr == 2 & date_start < 20000523] replace durUN=1 if [country== "Haiti" & date_start > 19930922 & date_start < 20000316 ] replace preUN=1 if [country== "Haiti" & date_start > 19900922 & date_start < 19930923] replace afterUN=1 if [country== "Haiti" & date_start > 20000315 & date_start < 20030316] replace durUN=1 if [country== "Haiti" & date_start > 20040600 & date_start < 20191016 ] replace preUN=1 if [country== "Haiti" & date_start > 20010600 & date_start < 20040601] replace afterUN=1 if [country== "Haiti" & date_start > 20191015 & date_start < 20201232] replace durUN=1 if [country== "Iraq" & date_start > 19890100 & date_start < 19910229 ] replace afterUN=1 if [country== "Iraq" & date_start > 19910228 & date_start < 19940219] replace durUN=1 if [country== "Iran" & date_start > 19890100 & date_start < 19910229 ] replace afterUN=1 if [country== "Iran" & date_start > 19910228 & date_start < 19940219] replace durUN=1 if [country== "Kuwait" & date_start > 19910408 & date_start < 20031007 ] replace preUN=1 if [country== "Kuwait" & date_start > 19890100 & date_start < 19910409] replace afterUN=1 if [country== "Kuwait" & date_start > 20031006 & date_start < 20061007] replace durUN=1 if [country== "Iraq" & date_start > 19910408 & date_start < 20031007 ] replace preUN=1 if [country== "Iraq" & date_start > 19890100 & date_start < 19910409] replace afterUN=1 if [country== "Iraq" & date_start > 20031006 & date_start < 20061007] replace durUN=1 if [country== "Serbia (Yugoslavia)" & date_start > 19990609 & date_start < 20201232 ] replace preUN=1 if [country== "Serbia (Yugoslavia)" & date_start > 19960609 & date_start < 199906010] replace durUN=1 if [country== "Liberia" & date_start > 19930921 & date_start < 19970931 ] replace preUN=1 if [country== "Liberia" & date_start > 19900921 & date_start < 19930922] replace afterUN=1 if [country== "Liberia" & date_start > 19970930 & date_start < 20000931] replace durUN=1 if [country== "Liberia" & date_start > 20030918 & date_start < 20180331 ] replace preUN=1 if [country== "Liberia" & date_start > 20000918 & date_start < 20030919] replace afterUN=1 if [country== "Liberia" & date_start > 20180330 & date_start < 20210331] replace durUN=1 if [country== "Libya" & date_start > 19940503 & date_start < 19940614 ] replace preUN=1 if [country== "Libya" & date_start > 19910503 & date_start < 19940504] replace afterUN=1 if [country== "Libya" & date_start > 19940613 & date_start < 19970614] replace durUN=1 if [country== "Mali" & date_start > 20130424 & date_start < 20201232 ] replace preUN=1 if [country== "Mali" & date_start > 20100424 & date_start < 20130425] replace durUN=1 if [country== "Mozambique" & date_start > 19921215 & date_start < 19941210 ] replace preUN=1 if [country== "Mozambique" & date_start > 19891215 & date_start < 19921216] replace afterUN=1 if [country== "Mozambique" & date_start > 19041209 & date_start < 19971210] replace durUN=1 if [country== "Namibia" & date_start > 19890215 & date_start < 19900322] replace preUN=1 if [country== "Namibia" & date_start > 19860215 & date_start < 19890216] replace afterUN=1 if [country== "Namibia" & date_start > 19900321 & date_start < 19930322] replace durUN=1 if [country== "Macedonia, FYR" & date_start > 19950330 & date_start < 19990229 ] replace preUN=1 if [country== "Macedonia, FYR" & date_start > 19920330 & date_start < 19950331] replace afterUN=1 if [country== "Macedonia, FYR" & date_start > 19990228 & date_start < 20020229] replace durUN=1 if [country== "Rwanda" & date_start > 19930621 & date_start < 19960309] replace preUN=1 if [country== "Rwanda" & date_start > 19930621 & date_start < 19930622] replace afterUN=1 if [country== "Rwanda" & date_start > 19960308 & date_start < 19990309] replace durUN=1 if [country== "El Salvador" & date_start > 19910519 & date_start < 19950431] replace preUN=1 if [country== "El Salvador" & date_start > 19880519 & date_start < 19910520] replace afterUN=1 if [country== "El Salvador" & date_start > 19950430 & date_start < 19980431] replace durUN=1 if [country== "Sierra Leone" & date_start > 19980712 & date_start < 20051232] replace preUN=1 if [country== "Sierra Leone" & date_start > 19950712 & date_start < 19980713] replace afterUN=1 if [country== "Sierra Leone" & date_start > 20051231 & date_start < 20081232] replace durUN=1 if [country== "Somalia" & date_start > 19920423 & date_start < 20050329] replace preUN=1 if [country== "Somalia" & date_start > 19890423 & date_start < 19920424] replace afterUN=1 if [country== "Somalia" & date_start > 20050328 & date_start < 20080329] replace durUN=1 if [country== "Sudan" & date_start > 20071230 & date_start < 20201232] replace preUN=1 if [country== "Sudan" & date_start > 20041230 & date_start < 20071231] replace durUN=1 if [country== "South Sudan" & date_start > 20180314 & date_start < 20201232] replace preUN=1 if [country== "South Sudan" & date_start > 20150314 & date_start < 20180315] /* data on South Sudan before 2011 is included in the stats on the Sudan. Consequently, the peacekeeping missing between the two Sudans, UNISFA, has been ignored, here, as it is not possible to calculate the pre-mission fatalities for South Sudan as it did not exist before the mission. */ replace durUN=1 if [country== "Syria" & date_start > 20120420 & date_start < 20120820] replace preUN=1 if [country== "Syria" & date_start > 20090420 & date_start < 20120421] replace afterUN=1 if [country== "Syria" & date_start > 20120819 & date_start < 20150820] replace durUN=1 if [country== "Tajikistan" & date_start > 19941215 & date_start < 20000516] replace preUN=1 if [country== "Tajikistan" & date_start > 19911215 & date_start < 19941216] replace afterUN=1 if [country== "Tajikistan" & date_start > 20000515 & date_start < 20030516] *there are no events in West Sahara before or during the ongoing UN mission. *there are no events in East Timor before, during or after the ongoing UN mission. *IDENTIFYING TIME PERIODS DURING, BEFORE AND AFTER unilateral MISSIONS replace durUnilat =1 if [country== "Serbia (Yugoslavia)" & adm_1 == "Kosovo" & date_start > 19990323 & date_start < 19990611] replace preUnilat =1 if [country== "Serbia (Yugoslavia)" & adm_1 == "Kosovo" & date_start > 19960323 & date_start < 19990324] replace afterUnilat =1 if [country== "Serbia (Yugoslavia)" & adm_1 == "Kosovo" & date_start > 19990610 & date_start < 20020611] replace durUnilat =1 if [country== "Sierra Leone" & date_start > 20000506 & date_start < 20000616] replace preUnilat =1 if [country== "Sierra Leone" & date_start > 19970506 & date_start < 20000507] replace afterUnilat =1 if [country== "Sierra Leone" & date_start > 20000615 & date_start < 20030616] replace durUnilat =1 if [country== "Afghanistan" & date_start > 20010926 & date_start < 20210832] replace preUnilat =1 if [country== "Afghanistan" & date_start > 19980926 & date_start < 20010927] replace afterUnilat =1 if [country== "Afghanistan" & date_start > 20210831 & date_start < 20240832] replace durUnilat =1 if [country== "Pakistan" & date_start > 20011218 & date_start < 20171008] replace preUnilat =1 if [country== "Pakistan" & date_start > 19981218 & date_start < 20011219] replace afterUnilat =1 if [country== "Pakistan" & date_start > 20171007 & date_start < 20201008] replace operNr=2 if [country == "Iraq" & date_start > 20130631] replace durUnilat =1 if [country== "Iraq" & date_start > 20030316 & operNr==1 & date_start < 20111232] replace preUnilat =1 if [country== "Iraq" & date_start > 20000317 & operNr==1 & date_start < 20030320] replace afterUnilat =1 if [country== "Iraq" & date_start > 20111231 & operNr==1 & date_start < 20130632] replace durUnilat =1 if [country== "Iraq" & date_start > 20140807 & operNr==2 ] replace preUnilat =1 if [country== "Iraq" & date_start > 20130631 & date_start < 20140808 & operNr == 2] replace durUnilat =1 if [country== "Central African Republic" & date_start > 20061127 & date_start < 20061232] replace preUnilat =1 if [country== "Central African Republic" & date_start > 20031127 & date_start < 20061128] replace afterUnilat =1 if [country== "Central African Republic" & date_start > 20061231& date_start < 20091232] replace durUnilat =1 if [country== "Somalia" & date_start > 20070107] replace preUnilat =1 if [country== "Somalia" & date_start > 20040107& date_start < 20070108] replace durUnilat =1 if [country== "Georgia" & date_start > 20080806 & date_start < 20080813] replace preUnilat =1 if [country== "Georgia" & date_start > 20080806 & date_start < 20080807] replace afterUnilat =1 if [country== "Georgia" & date_start > 20080812& date_start < 20130813] replace durUnilat =1 if [country== "Mauritania" & date_start > 20140800] replace preUnilat =1 if [country== "Mauritania" & date_start > 20110800 & date_start < 20140801] replace operNr=2 if [country == "Libya" & date_start > 20131231] replace durUnilat =1 if [country== "Libya" & date_start > 20110318 & date_start < 20111031] replace preUnilat =1 if [country== "Libya" & date_start > 20080318 & date_start < 20110319] replace afterUnilat =1 if [country== "Libya" & date_start > 20111031 & date_start < 20131232] replace durUnilat =1 if [country== "Libya" & date_start > 20151112 & date_start < 20191031] replace preUnilat =1 if [country== "Libya" & date_start > 20131232 & date_start < 20151113] replace afterUnilat =1 if [country== "Libya" & date_start > 20191031& date_start < 20221031] replace durUnilat =1 if [country== "Yemen (North Yemen)" & date_start > 20080317] replace preUnilat =1 if [country== "Yemen (North Yemen)" & date_start > 20050317 & date_start < 20080318] replace durUnilat =1 if [country== "Mali" & date_start > 20130112] replace preUnilat =1 if [country== "Mali" & date_start > 20100112 & date_start < 20130113] replace durUnilat =1 if [country== "Ukraine" & date_start > 20140219] replace preUnilat =1 if [country== "Ukraine" & date_start > 20110219 & date_start < 20140220] replace durUnilat =1 if [country== "Syria" & date_start > 20140703 & operNr==1] replace preUnilat =1 if [country== "Syria" & date_start > 20110703 & date_start < 20140704 & operNr==1] replace durUnilat =1 if [country== "Syria" & date_start > 20150929] replace preUnilat =1 if [country== "Syria" & date_start > 20120929 & date_start < 20150930 & operNr == 2] *DAYS BEFORE, AFTER AND DURING UN MISSION gen preMissionDays=1095 gen postMissionDays=1095 replace preMissionDays=1015 if country== "Cambodia (Kampuchea)" replace preMissionDays=828 if country== "Kuwait" replace preMissionDays=45 if country== "Namibia" replace preMissionDays=869 if country== "El Salvador" replace preMissionDays=619 if [country== "Central African Republic" & year> 2012] replace preMissionDays=307 if [country=="Guatemala" & date_start <19950118] replace preMissionDays=515 if [country== "Haiti" & year >2002] replace preMissionDays=988 if [country== "Liberia" & date_start >20000930] replace preMissionDays=714 if [country== "Guatemala" & date_start <19950117] replace postMissionDays=1095 if [country== "Haiti" & year<2018] replace postMissionDays=820 if [country== "Liberia" & year<2017] replace postMissionDays=730 if [country== "Central African Republic" & year>2009 & year <2003] replace postMissionDays=1095 if [country== "Guatemala" & year <1995] replace postMissionDays=650 if [country=="Haiti" & year <2002] gen missiondays=0 replace missiondays=3716 if country == "Angola" replace missiondays=3870 if country == "Bosnia-Herzegovina" replace missiondays=932 if country == "Burundi" replace missiondays=515 if country == "Cambodia (Kampuchea)" replace missiondays=684 if [country == "Central African Republic" & operNr ==2] replace missiondays=1191 if [country == "Central African Republic" & operNr ==2] replace missiondays=2296 if [country == "Central African Republic" & operNr ==3] replace missiondays=5157 if country == "Ivory Coast" replace missiondays = 2780 if country == "Croatia" replace missiondays = 7695 if country == "DR Congo (Zaire)" replace missiondays=4811 if country == "East Timor" replace missiondays=2950 if country == "Ethiopia" replace missiondays=2950 if country == "Eritrea" replace missiondays=6178 if country == "Georgia" replace missiondays=800 if [country == "Guatemala" & operNr ==1] replace missiondays=138 if [country == "Guatemala" & operNr ==2] replace missiondays=2360 if [country == "Haiti" & operNr ==1] replace missiondays=5610 if [country == "Haiti" & operNr ==2] replace missiondays=929 if country == "Iran" replace missiondays=4922 if country == "Kuwait" replace missiondays= 7866 if country == "Serbia (Yugoslavia)" replace missiondays=1468 if [country == "Liberia" & operNr ==1] replace missiondays=5301 if [country == "Liberia" & operNr ==2] replace missiondays=39 if country == "Libya" replace missiondays=2801 if country == "Mali" replace missiondays= 718 if country == "Mozambique" replace missiondays=400 if country == "Namibia" replace missiondays=1425 if country == "Macedonia, FYR" replace missiondays=984 if country == "Rwanda" replace missiondays=1435 if country == "El Salvador" replace missiondays=2723 if country == "Sierra Leone" replace missiondays=1064 if country == "Somalia" replace missiondays=5752 if country == "Sudan" replace missiondays=1016 if country == "South Sudan" replace missiondays=119 if country == "Syria" replace missiondays=1974 if country == "Tajikistan" replace missiondays=7177 if country == "Western Sahara" *DAYS BEFORE, AFTER Unilateral MISSION gen preunilat=1095 gen postunilat =1095 gen unilatdays=0 replace preunilat =402 if [country== "Iraq" & operNr ==2] replace preunilat =828 if [country== "Libya" & operNr==2] replace postunilat =0 if country== "Afghanistan" replace postunilat =0 if country== "Iraq" replace postunilat =0 if country== "Somalia" replace postunilat =0 if country== "Mauritania" replace postunilat =0 if country== "Yemen (North Yemen)" replace postunilat =0 if country== "Mali" replace postunilat =0 if country== "Ukraine" replace postunilat =0 if country== "Syria" *DAYS DURING MISSIONS replace unilatdays =77 if [country == "Serbia (Yugoslavia)" & operNr == 2] replace unilatdays =38 if country == "Sierra Leone" replace unilatdays =7030 if country == "Afghanistan" replace unilatdays =5765 if country == "Pakistan" replace unilatdays =3200 if country == "Iraq" replace unilatdays =2334 if [country == "Iraq" & operNr ==2] replace unilatdays =229 if country == "Libya" replace unilatdays =1443 if [country == "Libya" & operNr ==2] replace unilatdays =33 if country == "Central African Republic" replace unilatdays =5099 if country == "Somalia" replace unilatdays = 6 if country == "Georgia" replace unilatdays = 2340 if country == "Mauritania" replace unilatdays =4664 if country == "Yemen (North Yemen)" replace unilatdays =2904 if country == "Mali" replace unilatdays = 2499 if country == "Ukraine" replace unilatdays =2368 if [country == "Syria" & operNr==1] replace unilatdays =1915 if [country == "Syria" & operNr ==2] *dropping countries that have not been in international interventions gen apu=0 replace apu=1 if country == "Afghanistan" replace apu=1 if country == "Angola" replace apu=1 if country == "Bosnia-Herzegovina" replace apu=1 if country == "Burundi" replace apu=1 if country == "Cambodia (Kampuchea)". replace apu=1 if country == "Central African Republic". replace apu=1 if country == "Croatia". replace apu=1 if country == "DR Congo (Zaire)" replace apu=1 if country == "East Timor" replace apu=1 if country == "El Salvador" replace apu=1 if country == "Eritrea" replace apu=1 if country == "Ethiopia" replace apu=1 if country == "Georgia" replace apu=1 if country == "Guatemala" replace apu=1 if country == "Haiti" replace apu=1 if country == "Iran" replace apu=1 if country == "Iraq" replace apu=1 if country == "Ivory Coast" replace apu=1 if country == "Kuwait" replace apu=1 if country == "Liberia" replace apu=1 if country == "Libya" replace apu=1 if country == "Macedonia, FYR" replace apu=1 if country == "Mali" replace apu=1 if country == "Mauritania" replace apu=1 if country == "Mozambique" replace apu=1 if country == "Namibia" replace apu=1 if country == "Pakistan" replace apu=1 if country == "Rwanda" replace apu=1 if country == "Serbia (Yugoslavia)" replace apu=1 if country == "Sierra Leone" replace apu=1 if country == "Somalia" replace apu=1 if country == "South Sudan" replace apu=1 if country == "Sudan" replace apu=1 if country == "Syria" replace apu=1 if country == "Tajikistan" replace apu=1 if country == "Ukraine" replace apu=1 if country == "Western Sahara" replace apu=1 if country == "Yemen (North Yemen)" drop if apu==0 *calculation of pre-, during and post operation fatalities, Unilateral operations sum( best ) if country == "Serbia (Yugoslavia)" & operNr == 2 & preUnilat == 1 sum( best ) if country == "Afghanistan" & preUnilat == 1 sum( best ) if country == "Sierra Leone" & preUnilat == 1 sum( best ) if country == "Pakistan" & preUnilat == 1 sum( best ) if country == "Iraq" & preUnilat == 1 sum( best ) if country == "Iraq" & operNr ==2 & preUnilat == 1 sum( best ) if country == "Libya" & preUnilat == 1 sum( best ) if country == "Libya" & operNr ==2 & preUnilat == 1 sum( best ) if country == "Central African Republic" & preUnilat == 1 sum( best ) if country == "Somalia" & preUnilat == 1 sum( best ) if country == "Georgia" & preUnilat == 1 sum( best ) if country == "Yemen (North Yemen)" & preUnilat == 1 sum( best ) if country == "Mali" & preUnilat == 1 sum( best ) if country == "Ukraine" & preUnilat == 1 sum( best ) if country == "Syria" & operNr==1 & preUnilat == 1 sum( best ) if country == "Syria" & operNr ==2 & preUnilat == 1 sum( best ) if country == "Serbia (Yugoslavia)" & operNr == 2 & durUnilat == 1 sum( best ) if country == "Afghanistan" & durUnilat == 1 sum( best ) if country == "Sierra Leone" & durUnilat == 1 sum( best ) if country == "Pakistan" & durUnilat == 1 sum( best ) if country == "Iraq" & durUnilat == 1 sum( best ) if country == "Iraq" & operNr ==2 & durUnilat == 1 sum( best ) if country == "Libya" & durUnilat == 1 sum( best ) if country == "Libya" & operNr ==2 & durUnilat == 1 sum( best ) if country == "Central African Republic" & durUnilat == 1 sum( best ) if country == "Somalia" & durUnilat == 1 sum( best ) if country == "Georgia" & durUnilat == 1 sum( best ) if country == "Yemen (North Yemen)" & durUnilat == 1 sum( best ) if country == "Mali" & durUnilat == 1 sum( best ) if country == "Ukraine" & durUnilat == 1 sum( best ) if country == "Syria" & operNr==1 & durUnilat == 1 sum( best ) if country == "Syria" & operNr ==2 & durUnilat == 1 sum( best ) if country == "Serbia (Yugoslavia)" & operNr == 2 & afterUnilat == 1 sum( best ) if country == "Afghanistan" & afterUnilat == 1 sum( best ) if country == "Sierra Leone" & afterUnilat == 1 sum( best ) if country == "Pakistan" & afterUnilat == 1 sum( best ) if country == "Iraq" & afterUnilat == 1 sum( best ) if country == "Iraq" & operNr ==2 & afterUnilat == 1 sum( best ) if country == "Libya" & afterUnilat == 1 sum( best ) if country == "Libya" & operNr ==2 & afterUnilat == 1 sum( best ) if country == "Central African Republic" & afterUnilat == 1 sum( best ) if country == "Somalia" & afterUnilat == 1 sum( best ) if country == "Georgia" & afterUnilat == 1 sum( best ) if country == "Yemen (North Yemen)" & afterUnilat == 1 sum( best ) if country == "Mali" & afterUnilat == 1 sum( best ) if country == "Ukraine" & afterUnilat == 1 sum( best ) if country == "Syria" & operNr==1 & afterUnilat == 1 sum( best ) if country == "Syria" & operNr ==2 & afterUnilat == 1 *calculation of pre-, during and post operation fatalities, UN operations sum( best ) if country == "Western Sahara" & preUN == 1 sum( best ) if country == "Tajikistan" & preUN == 1 sum( best ) if country == "Syria" & preUN == 1 sum( best ) if country == "South Sudan"& preUN == 1 sum( best ) if country == "Sudan" & preUN == 1 sum( best ) if country == "Somalia" & preUN == 1 sum( best ) if country == "Sierra Leone" & preUN == 1 sum( best ) if country == "El Salvador" & preUN == 1 sum( best ) if country == "Rwanda" & preUN == 1 sum( best ) if country == "Macedonia, FYR" & preUN == 1 sum( best ) if country == "Namibia" & preUN == 1 sum( best ) if country == "Mozambique" & preUN == 1 sum( best ) if country == "Mali" & preUN == 1 sum( best ) if country == "Libya" & preUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & preUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & preUN == 2 sum( best ) if country == "Serbia (Yugoslavia)" & preUN == 1 sum( best ) if country == "Kuwait" & preUN == 1 sum( best ) if country == "Iran" & preUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & preUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & preUN == 2 sum( best ) if country == "Guatemala" & operNr ==2 & preUN == 1 sum( best ) if country == "Guatemala" & operNr ==2 & preUN == 2 sum( best ) if country == "Georgia" & preUN == 1 sum( best ) if country == "Eritrea" & preUN == 1 sum( best ) if country == "Ethiopia" & preUN == 1 sum( best ) if country == "East Timor" & preUN == 1 sum( best ) if country == "DR Congo (Zaire)" & preUN == 1 sum( best ) if country == "Croatia" & preUN == 1 sum( best ) if country == "Ivory Coast" & preUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & preUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & preUN == 2 sum( best ) if country == "Central African Republic" & operNr ==3 & preUN == 3 sum( best ) if country == "Cambodia (Kampuchea)" & preUN == 1 sum( best ) if country == "Burundi" & preUN == 1 sum( best ) if country == "Bosnia-Herzegovina" & preUN == 1 sum( best ) if country == "Angola" & preUN == 1 sum( best ) if country == "Afghanistan" & preUN == 1 sum( best ) if country == "Afghanistan" & preUN == 1 sum( best ) if country == "Western Sahara" & durUN == 1 sum( best ) if country == "Tajikistan" & durUN == 1 sum( best ) if country == "Syria" & durUN == 1 sum( best ) if country == "South Sudan"& durUN == 1 sum( best ) if country == "Sudan" & durUN == 1 sum( best ) if country == "Somalia" & durUN == 1 sum( best ) if country == "Sierra Leone" & durUN == 1 sum( best ) if country == "El Salvador" & durUN == 1 sum( best ) if country == "Rwanda" & durUN == 1 sum( best ) if country == "Macedonia, FYR" & durUN == 1 sum( best ) if country == "Namibia" & durUN == 1 sum( best ) if country == "Mozambique" & durUN == 1 sum( best ) if country == "Mali" & durUN == 1 sum( best ) if country == "Libya" & durUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & durUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & durUN == 2 sum( best ) if country == "Serbia (Yugoslavia)" & durUN == 1 sum( best ) if country == "Kuwait" & durUN == 1 sum( best ) if country == "Iran" & durUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & durUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & durUN == 2 sum( best ) if country == "Guatemala" & operNr ==2 & durUN == 1 sum( best ) if country == "Guatemala" & operNr ==2 & durUN == 2 sum( best ) if country == "Georgia" & durUN == 1 sum( best ) if country == "Eritrea" & durUN == 1 sum( best ) if country == "Ethiopia" & durUN == 1 sum( best ) if country == "East Timor" & durUN == 1 sum( best ) if country == "DR Congo (Zaire)" & durUN == 1 sum( best ) if country == "Croatia" & durUN == 1 sum( best ) if country == "Ivory Coast" & durUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & durUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & durUN == 2 sum( best ) if country == "Central African Republic" & operNr ==3 & durUN == 3 sum( best ) if country == "Cambodia (Kampuchea)" & durUN == 1 sum( best ) if country == "Burundi" & durUN == 1 sum( best ) if country == "Bosnia-Herzegovina" & durUN == 1 sum( best ) if country == "Angola" & durUN == 1 sum( best ) if country == "Afghanistan" & durUN == 1 sum( best ) if country == "Afghanistan" & durUN == 1 sum( best ) if country == "Western Sahara" & afterUN == 1 sum( best ) if country == "Tajikistan" & afterUN == 1 sum( best ) if country == "Syria" & afterUN == 1 sum( best ) if country == "South Sudan"& afterUN == 1 sum( best ) if country == "Sudan" & afterUN == 1 sum( best ) if country == "Somalia" & afterUN == 1 sum( best ) if country == "Sierra Leone" & afterUN == 1 sum( best ) if country == "El Salvador" & afterUN == 1 sum( best ) if country == "Rwanda" & afterUN == 1 sum( best ) if country == "Macedonia, FYR" & afterUN == 1 sum( best ) if country == "Namibia" & afterUN == 1 sum( best ) if country == "Mozambique" & afterUN == 1 sum( best ) if country == "Mali" & afterUN == 1 sum( best ) if country == "Libya" & afterUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & afterUN == 1 sum( best ) if country == "Liberia" & operNr ==2 & afterUN == 2 sum( best ) if country == "Serbia (Yugoslavia)" & afterUN == 1 sum( best ) if country == "Kuwait" & afterUN == 1 sum( best ) if country == "Iran" & afterUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & afterUN == 1 sum( best ) if country == "Haiti" & operNr ==2 & afterUN == 2 sum( best ) if country == "Guatemala" & operNr ==2 & afterUN == 1 sum( best ) if country == "Guatemala" & operNr ==2 & afterUN == 2 sum( best ) if country == "Georgia" & afterUN == 1 sum( best ) if country == "Eritrea" & afterUN == 1 sum( best ) if country == "Ethiopia" & afterUN == 1 sum( best ) if country == "East Timor" & afterUN == 1 sum( best ) if country == "DR Congo (Zaire)" & afterUN == 1 sum( best ) if country == "Croatia" & afterUN == 1 sum( best ) if country == "Ivory Coast" & afterUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & afterUN == 1 sum( best ) if country == "Central African Republic" & operNr ==3 & afterUN == 2 sum( best ) if country == "Central African Republic" & operNr ==3 & afterUN == 3 sum( best ) if country == "Cambodia (Kampuchea)" & afterUN == 1 sum( best ) if country == "Burundi" & afterUN == 1 sum( best ) if country == "Bosnia-Herzegovina" & afterUN == 1 sum( best ) if country == "Angola" & afterUN == 1 sum( best ) if country == "Afghanistan" & afterUN == 1 sum( best ) if country == "Afghanistan" & afterUN == 1 *Results moved to Daily track record of UN and Unilateral operations.xls