The campaign maintained a series of large spreadsheets updated by teams of people around the US. The spreadsheets had a variety of different people, offices and coordinators with contact information for each. The campaign wanted to let the public find out who to contact in a way that could be maintained despite rapid changes.
I developed a program to automatically download the data from the spreadsheets using the Google Docs API, check appropriate values and then convert the data to a map. The map is a Google Maps map that has javascript filters and clicking on the items results in more information about that person.
