Replace Yes with 1 and No with 0
If you do not want to return both Yes/Nos and 1/0s, then exclude columns like

t1.'Domestic Violence' as DomesticViolence


from your query and have your CASE expression reference the source columns rather than their aliases:

case
  when (t1.'Domestic Violence' = 'Yes') then 1
  else 0
end as Domestic_Violence