Hopefully this question isn't off-topic. I've been trying to locate a comprehensive list of every mayor currently in office within the United States and I'm not finding much other than junk like "Current Mayors of the top 100 cities in the United States".
I'm looking for a resource that would contain all 16,374 mayors currently holding office and their party designation. Other than finding a site that charges money for this information I haven't seen anything while searching. Is there a free resource that is available for this type of stuff, or place where I can build a large query based on public datasets? Thank you.