I worked on the slideshow, twitter scroller, social wall, and the site navigation. I followed a PSD design to a near pixel perfect conversion. I also created this page where you can filter data from a Google Sheet by zip code, city, or county.
Here's a quick rundown how I came to render the Google Sheet data with filters. The document gets published to the web as a CSV file, then a brief PHP script converts the data to JSON and finally into static HTML. The process is automated once a day, and it saves on load times from using AJAX. The jQuery required to filter the results live is included in the script, so it never has to be manually updated beyond the original spreadsheet.
The social wall is an implementation of this jQuery social stream.