Find all duplicate records with (name, state, city) same
select v.venue_id, v.name, v.city, v.state from raw_data v
join
(select COUNT(concat(name,state,city)),name,state,city from raw_data
where source_id = 2 group by name,state,city
having COUNT(concat(name,state,city)) > 1) a
on
v.name = a.name and v.state = a.state and v.city = a.city and v.source_id = 2
order by v.name,v.state,v.city
