I’m almost halfway through with blog posts about the 75* people featured in the Friends Album. I felt I needed to do two things to better wrap my head around these folks, where they’re from and how they are connected.

Firstly, I created yet another map in Google Maps, showing the locations for each of the friends featured so far (previously, I created a map showing the locations of the photographers I’ve found in Danbury, Connecticut). The photos were taken in New York, Connecticut and Massachusetts. A large number were taken in Danbury, Connecticut. Yonkers, New York, and New Milford, Connecticut, also were the sites of several photos each.

Friends Album Photo Location Google Map (links to Google Map)

It’s good to see the geographic dispersal of these photos, but I wanted a way to more intricately compare the data I’ve compiled from each image. I next created a Google spreadsheet that shows (where known) the names, locations, approximate dates, ages, photo types and assorted notes, along with thumbnail images for each photo.

Friends Album Google Doc Spreadsheet (links to spreadsheet)

I still have to go through and try all of the different sorts and filters available to me now that I’ve populated this with data. I’m trying to figure out if I can link the thumbnail images to their larger versions on the web. I’ll continue to update the spreadsheet as I investigate each photo. The link provided here will automatically update with my changes. I invite folks to check out both of these tools and let me know if you notice any patterns that I might be missing.

* Originally, I counted 75 people in the album, but now have found a couple of people with more than one photo included. As of now, the number of distinct individuals is probably closer to 70.