OK… now anyone who wants to look at this is more than welcome to it.
This is an Excel file into which I’ve managed to put all the information about the closed and open Chrysler dealerships. Because wordpress is stupid, I can’t upload an excel document, so I had to rename it so that it is a Word document. Just download it and change the extension to “.xls” and you’re set to go.
There are four sheets to the file. Two sheets are the raw data as best I could translate it. The other two sheets are the data cleaned up a little bit to make it more readable.
WARNING: For anyone who hasn’t worked with this kind of data before… data is ugly. Some stuff is missing, some things are misspelled, names are inconsistent and addresses haven’t been parsed. This isn’t meant to be the most perfect data source of all time. It’s just a format for the data that can be more easily organized, sorted, parsed, and analyzed.
So… go at it. From Excel, you should be able to export as a CSV (comma delimited), which is nice and fun to work with from a visualization point of view.