def get_events_by_date_region(self, date, region):
events = []
for country in REGIONS.get(region):
cmd = 'select * from incidents_view where upper(country)="%s" and event_date >= date("%s") AND event_date < date("%s", "+1 day");'%(country.upper(), self.format_date(date), self.format_date(date))
output = self.db_access.execute(cmd)
events.extend(self.get_events_from_output(output))
return events
