I’m learning that old skool stakeholder engagement involves a lot of spreadsheets.
We needed to work out which UK Parliamentary constituencies some organisations were in, to identify who needed to be contacted about an issue. 400 organisations, in fact.
[UPDATE 2023 – The issue in question]
Could have been a boring day’s work for someone, but became instead quite an enjoyable lunchtime project exploring TheyWorkForYou‘s API to information about MPs.
And so to save others future pain, here’s a little thing that takes a list of postcodes, and returns details of the constituencies for each one: Which constituency is that in?
You could probably do the rest of the matching up work in Excel with some clever VLOOKUPs. If that’s your kinda thing.
This hosted version limits you to batches of 25; if you want to grab the code and host it yourself with your own API key, it’s free for anyone to use.