It appears the various Councils have developed a tracking tool, Short Term Let Register, to follow the status of STL applications. Some of the Councils have this information in Excel spreadsheets, some more easily used than others. For instance the Highlands Council spreadsheet does not have a separate column for the town/city but the spreadsheet address column might be delineated to create that as a sortable field. If you don't have Excel you may ask for the data in a different format. Remember to check report run date at the top of the spreadsheet as the upload may be a couple weeks back.
I'm sharing the links to a few of the Councils where we have accommodations for our next visit. If you need help finding Registers of other Councils I'm happy to help.
https://www.highland.gov.uk/downloads/file/26149/short_term_let_public_register#feedback
https://www.argyll-bute.gov.uk/licences/short-term-lets-licence/register
from the Council website:
Due to a late surge of nearly a thousand Short Term Let (STL) applications, the current average processing time for applications is up to 24 weeks. Existing STL hosts (operating prior to the 1 October 2022) who submitted their applications and paid their fees by 1st October 2023 can continue to operate until their application is determined, although new hosts require to be licensed before operating. We would therefore be grateful if applicants did not contact us to simply chase progress updates, as this diverts resources from processing outstanding applications.
https://www.orkney.gov.uk/Service-Directory/L/short-term-let-licenses.htm