UK Authorities Social Media Database

I want a single, tidy spreadsheet that lists every local authority, police force and fire & rescue service operating in the United Kingdom. For each organisation I only need four fields:

• Name
• Official PR / homepage URL
• Facebook page URL
• Twitter / X URL

Please make sure the links point to the organisation’s official accounts, not third-party or personal pages, and avoid duplicates created by joint services. I’m happy for you to scrape, use open data or compile the information manually—whichever route gives the most complete and up-to-date list.

Deliver the file as either an Excel workbook or a Google Sheet. One row per organisation, columns in the order shown above, sorted alphabetically by name so I can import it directly into our system. I’ll run a quick spot-check for accuracy before signing off.

If anything is unclear, feel free to message me before you start; otherwise I look forward to reviewing the finished spreadsheet.