I will provide 2 lists of venues in excel spreadsheet:
1. A list of 1610 UK venues with venue name and city provided
2. A list of 297 venues with just the venue name, and could be located in either UK, IRL, US, CA or AUS
Task1 - for the 1610 UK venues - lookup (google) the venue and enter the VENUE_ADDR1 and VENUE_POSTCODE into the spreadsheet (expect 99.5% accuracy as venues are unique and cities are identified). Note that VENUE_ADDR2 and VENUE_ADDR3 can be used for long addresses.
Task2 - for the 297 venues in unknown cities and unknown countries, google and use any other necessary means to identify the VENUE_ADDRESS1, VENUE_CITY, VENUE_POSTCODE and VENUE_COUNTRY (will accept 'best endeavours' as this list of names could be vague and ambiguous and there could be multiple venues of the same name in several cities round the world). If you are unable to definitely determine a single city and country for the venue name, move the row to the 'Unable To Determine' worksheet.