Dave Wasserman has his Pres-by-county spreadsheet, and wwmiv has a congressional district PVI spreadsheet out there. I'm going to join the crowd and stick to the turf that I know best: California. More specifically, this is a spreadsheet of California State Legislature district PVIs, including both the state senate and the state assembly.
Update: Link removed.
For this spreadsheet, I used raw percentages, not two-party percentages. 2008 results were taken from Meridian Pacific, a GOP consulting firm (so I'm not linking to it), while 2012 results were culled the data from the counties' statements of vote.
As you can see, there are numerous gaps and missing numbers. Feel free to help fill in the blanks! Ok well, you have to do it in the comments below and I'll do the filling in. Also, feel free to correct any mistakes.
Once the spreadsheet is filled in (or when the Secretary of State comes out with a statement of vote supplement in February or April), I'll probably combine it with California congressional district PVI's that I'm (now openly announcing that I'm) stealing from wwmiv and compile a complete California district PVI sheet.
Below are some notes and proverbial asterisks of the spreadsheet that take a bit of explaining but are tangential to this diary. So unlike my other diaries and many other diaries on Daily Kos, reading below the Kossacks' Golden Poppy is optional, even discouraged for the faint of heart.
Read More