Crowdsourcing Pres-by-CD: Florida Precinct Results

According to the Census Bureau, thirty of Florida’s 67 counties are split between multiple Congressional districts. (The remainder are all located entirely within single CDs.) Unfortunately for us, the state of Florida does not publish results by CD, which means that calculating pres-by-CD for FL requires digging down into precinct-level results.

Frustratingly, the Florida Division of elections doesn’t publish that information either. However, there is good news: Florida’s county-level election departments almost universally do. I’ve gone through all thirty split-county websites to try to track down this information. I was successful in all but two counties – let us know if you have any luck with Alachua and Jefferson. (UPDATE: Jefferson County sent me a spreadsheet in response to my email request to them, which you can find here.)

Anyhow, I’ve posted links for every set of precinct data I could find in this new spreadsheet. The linked files are in a variety of formats. Some are nicely parsed Excel or CSV files, some are clean TXT or HTML files, and some are thorny PDFs. (One non-split county, Glades, even posted a handwritten chart!) The most sophisticated sites will give you a choice of formats.

No matter how you slice it (and at the precinct level, you’re slicing it awful thin), there’s a lot of data to work with. Miami-Dade’s file, for instance, is over 2,700 pages. As Crisitunity observed, we’ve picked off most of the low-hanging fruit already, so bigger projects are what remains. But as Crisitunity also noted, with a million nerds pecking away at a million keyboards, we can accomplish just about anything we set our nerdly minds to.

So if you want to start tackling the big prize of Florida, check out the spreadsheet and have at it! And if you have any thoughts or strategies for how best to pursue this project, please share them in comments.

Crowdsourcing Pres-by-CD: First Wave of Results

Enough things have happened (such as states certifying their results) that we’re ready to roll out our first wave of results from Swing State Project’s big crowdsourcing project of compiling presidential results by congressional district. Usually, knowing presidential results by CD requires waiting for Polidata to compile this data and make it public in March… but the power of an infinite number of nerds typing on an infinite number of spreadsheets makes it possible for us to short-circuit the process. (There’s still tons of stuff left for enterprising nerds to do, especially if you have access to precinct-level data. Check our database in progress.)

Without further Apu, here’s the first wave, representing nearly one quarter of all congressional districts. Explanation of many of the technicalities follows below the chart (and a simple spreadsheet of just the 2008 numbers is available here):

District Obama # McCain # Other # 2008 % 2004 % 2000 %
AL-01 117,804
(114,847-
120,761)
184,257
(180,524-
187,990)
2,195
(2,167-
2,222)
38.7/60.6 35/64 38/60
AK-AL 123,594 193,841 8,762 37.9/59.4 36/61 28/59
AR-01 95,102 145,340 7,185 38.4/58.7 47/52 50/48
AR-02 131,891 161,540 5,855 44.1/54.0 48/51 48/49
AR-03 96,485 185,055 6,894 33.5/64.2 36/62 37/60
AR-04 98,832 146,082 6,356 39.3/58.1 48/51 49/48
CO-03 160,746
(158,973-
162,519)
169,233
(167,036-
171,429)
5,602
(5,539-
5,664)
47.4/50.4 44/55 39/54
CO-05 129,101
(126,976-
131,226)
189,532
(187,084-
191,980)
4,982
(4,863-
5,100)
39.9/58.6 33/66 31/63
CT-01 218,367 108,315 4,365 66.0/32.7 60/39 62/33
CT-02 209,546 139,888 5,055 59.1/39.5 54/44 54/40
CT-03 201,334 116,962 3,872 62.5/36.3 56/42 60/34
CT-04 189,142 125,978 2,108 59.6/39.7 52/46 53/43
CT-05 181,902 136,898 4,048 56.3/42.4 49/49 52/43
DE-AL 255,459 152,374 4,579 61.9/37.0 53/46 55/42
ID-01 128,134 220,787 8,210 35.9/61.8 30/69 28/68
ID-02 108,693 183,022 7,387 36.3/61.2 30/69 28/67
IN-08 139,500
(137,953-
141,047)
150,945
(148,866-
153,024)
3,813
(3,734-
3,892)
47.4/51.3 38/62 42/57
IA-01 175,394 122,629 4,327 58.0/40.6 53/46 52/45
IA-02 190,973 122,395 5,671 59.9/38.4 55/44 53/43
IA-03 173,932 143,771 5,785 53.8/44.4 50/50 49/48
IA-04 166,104 142,396 5,724 52.9/45.3 48/51 48/49
IA-05 122,537 151,188 4,297 44.1/54.4 39/60 40/57
KY-01 104,626 176,807 4,424 36.6/61.9 36/63 40/58
KY-02 118,700 188,955 4,473 38.0/60.5 34/65 37/62
KY-03 193,260 150,552 3,393 55.7/43.4 51/49 50/48
KY-04 118,773 189,008 5,086 38.0/60.4 36/63 37/61
KY-05 75,815 162,614 4,241 31.2/67.0 39/61 42/57
KY-06 140,811 180,526 4,444 43.2/55.4 41/58 42/56
LA-01 74,405 214,479 4,708 25.3/73.1 28/71 31/67
LA-02 130,741 43,459 1,782 74.3/24.7 75/24 76/22
LA-03 97,420 163,294 5,306 36.6/61.4 41/58 45/52
LA-04 108,084 161,853 3,134 39.6/59.3 40/59 43/55
LA-05 103,707 175,097 3,638 36.7/62.0 37/62 40/57
LA-06 130,398 180,708 4,212 41.4/57.3 40/59 43/55
LA-07 103,500 187,607 4,915 35.0/63.4 39/60 42/55
ME-01 232,145 144,604 6,885 60.5/37.7 55/43 50/43
ME-02 189,778 150,669 7,090 54.6/43.4 52/46 48/45
MA-01 198,880 102,445 n/a 66.0/34.0 63/35 56/33
MA-02 178,090 117,272 n/a 60.3/39.7 59/40 58/35
MA-05 175,871 117,654 n/a 59.9/40.1 57/41 57/36
MA-06 192,502 135,956 n/a 58.6/41.4 58/41 57/36
MA-07 189,329 97,173 n/a 66.1/33.9 66/33 64/29
MA-08 202,962 32,749 n/a 86.1/13.9 79/19 73/15
MA-09 169,042 107,281 n/a 61.2/38.8 63/36 60/33
MA-10 196,218 155,288 n/a 55.8/44.2 56/43 54/39
MI-01 166,194 160,130 6,588 49.9/48.1 46/53 45/52
MI-02 167,607 179,427 5,878 47.5/50.8 39/60 38/59
MI-03 169,283 171,255 7,344 48.7/49.2 40/59 38/60
MI-04 170,275 163,886 5,928 50.2/48.2 44/55 44/54
MI-05 207,479 113,013 5,521 63.6/34.7 59/41 61/37
MI-06 177,324 146,377 3,365 54.2/44.8 46/53 45/52
MI-07 171,535 154,244 6,524 51.6/46.4 45/54 46/51
MI-08 198,207 172,346 6,412 52.6/45.7 45/54 47/51
MI-09 202,689 155,719 2,960 56.1/43.1 49/51 47/51
MI-10 160,971 166,932 7,452 48.0/49.8 43/57 45/53
MN-01 173,880 158,964 8,383 51.0/46.9 47/51 45/49
MN-02 193,218 198,966 7,683 48.3/49.8 45/54 44/51
MN-03 200,239 175,730 6,110 52.4/46.0 48/51 46/50
MN-04 217,982 113,600 6,835 64.4/33.6 62/37 57/37
MN-05 254,764 81,749 7,076 74.1/23.8 71/28 63/29
MN-06 183,950 219,939 8,519 44.6/53.3 42/57 42/52
MN-07 154,127 162,938 8,177 47.4/50.1 43/55 40/54
MN-08 195,128 163,506 8,810 53.1/44.5 53/46 49/44
MS-01 129,939 213,478 n/a 37.8/62.2 37/62 40/59
MS-02 196,400 99,428 n/a 66.4/33.6 59/40 57/41
MS-03 131,292 216,256 n/a 37.8/62.2 34/65 35/64
MS-04 93,661 198,756 n/a 32.0/68.0 31/68 33/65
MO-08 104,252
(100,910-
107,593)
178,358
(170,990-
185,726)
4,729
(4,606-
4,851)
36.3/62.1 36/64 39/59
MT-AL 231,667 242,763 16,662 47.2/49.4 39/59 33/58
NH-01 186,370 164,403 3,026 52.7/46.5 48/51 46/49
NH-02 198,456 152,131 3,225 56.1/43.0 52/47 48/47
NM-01 180,833 119,342 873 60.1/39.6 51/48 48/47
NM-02 114,928 118,063 3,298 48.6/50.0 41/58 43/54
NM-03 176,661 109,427 3,456 61.0/37.8 54/45 52/43
ND-AL 141,278 168,601 7,786 44.5/53.1 36/63 33/61
OR-01 228,817 135,975 10,108 61.0/36.3 55/44 50/44
OR-03 260,128 93,931 10,297 71.4/25.8 67/33 61/32
OR-05 192,355 154,488 9,385 54.0/43.4 49/50 47/48
RI-01 148,388 75,747 3,694 65.1/33.3 62/36 63/31
RI-02 148,159 89,642 4,110 61.3/37.1 57/41 60/33
SD-AL 170,924 203,054 7,997 44.8/53.2 38/60 38/60
TX-01 83,252
(81,507-
84,997)
187,768
(183,628-
191,907)
1,940
(1,901-
1,978)
30.5/68.8 31/69 33/68
TX-31 125,321
(123,983-
126,658)
173,294
(171,304-
175,284)
3,563
(3,535-
3,590)
41.5/57.3 33/67 32/69
VT-AL 219,262 98,974 6,790 67.5/30.5 59/39 51/41
VA-01 179,442 193,273 3,652 47.7/51.4 39/60 39/58
VA-02 142,257 136,725 2,991 50.5/48.5 42/58 43/55
VA-03 229,822 72,249 2,223 75.5/23.7 66/33 66/32
VA-04 178,795 173,358 3,087 50.3/48.8 43/57 44/54
VA-05 157,362 164,874 3,621 48.3/50.6 43/56 41/55
VA-06 134,212 182,573 3,869 41.9/56.9 36/63 37/60
VA-07 177,789 205,949 3,648 45.9/53.2 38/61 37/61
VA-08 234,203 100,234 3,594 69.3/29.7 64/35 57/38
VA-09 108,220 160,430 4,596 39.6/58.7 39/60 42/55
VA-10 205,964 179,337 4,025 52.9/46.1 44/55 41/56
VA-11 211,466 156,003 3,417 57.0/42.1 49/50 45/52
WV-01 103,096 141,016 4,279 41.5/56.8 42/58 43/54
WV-02 113,853 142,112 4,175 43.8/54.6 42/57 44/54
WV-03 87,178 114,933 4,011 42.3/55.8 46/53 51/47
WI-01 191,901 177,162 4,281 51.4/47.5 46/54 45/51
WI-02 286,089 123,495 5,054 69.0/29.8 62/37 58/36
WI-03 213,211 150,618 5,327 57.8/40.8 51/48 49/46
WI-04 234,468 73,447 3,108 75.4/23.6 70/30 66/30
WI-05 174,174 243,597 4,191 41.3/57.7 36/63 35/62
WI-06 181,198 176,871 4,996 49.9/48.7 43/56 42/53
WI-07 200,562 152,507 5,624 55.9/42.5 50/49 48/47
WI-08 195,608 164,696 4,711 53.6/45.1 44/55 43/52
WY-AL 82,868 164,958 6,832 32.5/64.8 29/69 28/69

The easy ones to do were the at-large states, and states where the SoS has already reported by congressional district (Connecticut, Idaho, Kentucky, Minnesota, and Virginia). Also easy were states where district lines precisely follow county lines (Arkansas, Iowa, and West Virginia).

We also have a number of excellent spreadsheets in our portfolio where people were able to locate precinct, ward, or town data. (A huge thank you to everyone who has contributed, and one more reminder that there are still many more states to do, although they get progressively harder from here on out.) These include Louisiana, Maine, Massachusetts, Michigan, Mississippi, New Hampshire, New Mexico, Oregon, Rhode Island, and Wisconsin.

You may notice that not all the districts from MA, MI, and OR are included. That’s because in each of these states, there’s one pesky jursidiction that hasn’t reported at the precinct level yet: Fall River in Massachusetts, Wayne County in Michigan, and Josephine County in Oregon. If you find this data anywhere, please let us know! (A few other minor requests for our anonymous spreadsheet wizards: if the persons who did MA and MS have “other” data, could you add those to the databases? And whoever did WI, could you provide the “Wisconsin long” form that shows precinct-level data in split counties? Thanks in advance!)

You’re probably wondering about those ones where there’s a total and then a range of numbers in parentheses. These districts (AL-01, CO-03, CO-05, IN-08, MO-08, TX-01, and TX-31) are ones where there were county splits but I felt confident proceeding even without precinct data, because there was only one split county and it represented such a small percent of the total that even if I allocated the votes within the county completely wrong it still wouldn’t affect the total percentages by more than a fraction of one percent. In these cases, I’m presenting both range values (of the maximum and minimum possible) and a point estimate (calculated by allocating half of those counties’ votes for each candidate to the district in question, and half to the other district).

As we get more states done, we’ll roll more of them out. We’re expecting California and Nebraska to report by CD soon (which will give us another 56 CDs right there), but for almost all the other states, we’re missing precinct-level data. If you like this resource and have access to useful information, but don’t have the time or stamina to spreadsheet it all, please just let us know in the comments or the master database, and I’m sure someone else will pounce on it.

Crowdsourcing Pres-by-CD, 4th Thread

Right now we’re in a bit of a holding pattern with the presidential results by CD project. Most states haven’t yet certified final vote tallies, and some haven’t even finished counting. But the good news is that we have some preliminary numbers for the following states:

Connecticut

Iowa

Kentucky

Minnesota

New Hampshire

Rhode Island

Virginia

West Virginia

You can find these by clicking on the links in the “Calculations” column (column E) in the collaborative spreadsheet.

On the flipside, we still need links to official data sources for the following states:

Alabama

Florida

Indiana

Louisiana

Mississippi

New Jersey

Oklahoma

South Carolina

Tennessee

Utah

If you know the proper links to official results for any of these states, please enter them as a TinyURL on the spreadsheet. Even if official 2008 results haven’t yet been released (and as I say, in most states they have not), links to where you expect the official data to show up at some point would be greatly appreciated.

As always, please share any thoughts about this project in comments. Also, a couple of helpful resources from the US Census Bureau:

Just what is the Partisan Voter Index (PVI)?

Cross-posted at Election Inspection 

One of the things which I think tends to cause a little bit of confusion with regards to House races is the idea of Charlie Cook's Partisan Voter Index, so to solve a bit of the confusion, I'd like to take the time to discuss what the PVI is, how it's used, and its strengths and weaknesses. Just so we're clear, I have absolutely no connection to Charlie Cook or Polidata, nor should this necessarily be taken as their words. This is, essentially, a way to understand, at least to my mind, the logic behind the PVI.

So follow me, fellow SSPers and discover the wonder that is the PVI!

1. “What is the PVI?”

Wikipedia's entry defines it as:

The index for each congressional district is derived by averaging its results from the prior two presidential elections and comparing them to national results. The index indicates which party's candidate was more successful in that district, as well as the number of percentage points by which its results exceeded the national average. The index is formatted as a letter + number; in a district whose CPVI score is R+2, recent Republican presidential candidates received 2 percentage points more votes than the national average. Likewise, a CPVI score of D+3 shows the Democrats received 3 percentage points more votes than the national average.

Essentially, what the PVI attempts to do is to determine just how Democratic or Republican a district is compared to the rest of the country, which helps to give a better idea where the most and least competitive districts are.

2. “So does that mean that PVIs can change over time?”

Yes, every presidential election, the PVI is recalculated in order to determine what the voting patterns in each district were like. While PVIs are typically used with congressional districts, since we don't have the new data for the 2008 elections at the CD level yet, we'll use two different states as an example (Illinois, Indiana). First of all, let's figure out what the PVI of both states were before the 2008 presidential election: (Illinois 2000 and 2004 data; Indiana 2000 and 2004 data) First of all, we know that in 2000 and 2004 George Bush won 48% and 51% of the vote respectively (averaged out, the Republican nominee's vote percentage is 49.5) while the Democratic nominees Al Gore and John Kerry both got 48% of the vote. Using Illinois first, since we know that both Kerry and Gore got 55% of the vote in the state, we can determine that Illinois's previous PVI is 55-48, which gives us a PVI of D+7 (meaning that Illinois voted 7 points more Democratic than the rest of the country over the 2000 and 2004 presidential elections). For Indiana, we know that George Bush won 57% and 60% of the vote respectively (for an average of 58.5%), subtracting George Bush's national average from this state average (58.5-49.5) we find that Indiana has a PVI of R+9 (meaning that Indiana voted 9 points more Republican than the rest of the country). Now, to recalculate this for 2008, we take out the 2000 numbers of Al Gore and George Bush's first run and we add in Barack Obama and John McCain's numbers (for the national numbers, the average changes to 50.5% Democratic to 48.5% Republican) we would also take the new averages for Illinois (adding Obama's 62% to Kerry's 55% and dividing by 2 gives us 58.5%) and Indiana (adding McCain's 49% to Bush 2004's 60% and dividing by 2 gives us an average of 54.5%). Using the equations from above, we find that Illinois's PVI is now D+8.5 (which means that it moved more Democratic relative to the country) while Indiana's PVI changed to R+4 (meaning that it is now voting quite a bit less Republican than the rest of the country).

3. “Wait a minute, even though Obama won Indiana, its PVI is still so slanted towards the Republicans?”

Yes indeed. To make this a little easier, remember that the United States itself has a constant PVI of 0 (because it is being compared to itself). Because of this, it is possible for Obama to actually win a district that Kerry lost and yet the state gets a more Republican PVI. Looking at Florida (2000 and 2004) we can see that George Bush got 48% and 52% in 2000 and 2004 (with an average score of 50%), which makes Florida's old PVI R+0.5. In 2008, John McCain got 49% of the vote in Florida, so adding Bush 2004 and McCain's performance and averaging them gives the state an average Republican vote of 50.5%, which, in the context of the 2004-2008 national Republican average of 48.5, we can determine that Florida has a PVI of R+2. So even though Obama won a state that Kerry did not, its PVI actually become more Republican!

4. “Wait a minute, what good is this measure if it decides that a state that went Democratic is actually Republican?”

Think of the country as being the “center”, the “center” might be more Democratic and it might be more Republican at times, but regardless of which one it is, the country will always be at the “center”. The PVI is attempting to tell us how far away from the center a given area is.

5. “Ok, so the PVI is a way of determining where a district is compared to the country, I understand that, but why is it that some districts with Republican PVIs of 10 or greater can sometimes have Democrats representing them (and vice-versa)?”

Former House Speaker Tip O'Neill once said that “All politics are local” and this is what he's talking about. Skilled politicians like Democrats Chet Edwards (TX-17) and Jim Matheson (UT-02) are able to survive in districts that are extremely Republican. Or there are states like North Dakota that, while tending to vote for Democrats for congress but vote for Republicans for president.

6. “Does this make the PVI system worthless then?”

No, since these districts are becoming fewer and fewer as the country becomes more polarized, the PVI is extremely useful in the vast majority of districts. Of course, the PVI does not tell us vital information, like whether or not there are viable candidates in the district, whether or not it traditionally is a split-ticket area, or on how scandals would work.

7. “Ok ok, I get what the PVI is and why it's useful, but why two presidential elections, why not just use one?”

Because using only one set of election data means that the new PVI would suggest that something massive has changed, even if it was only a one time thing. Two presidential elections lets us hedge our bets a bit. For example, we know that Indiana voted 3 points more Republican than the rest of the country, yet we also know that the last two elections had Indiana voting 9 points more Republican than the rest of the country, the idea is that we should not ignore the past.

8. “So then why not be even more cautious and use 3 or 4 different elections?”

My answer would be that, while I could definitely see incorporating three presidential elections into data for a given presidential year, doing this can hedge too much (for example, Gore did 6 points worse in Colorado than he did nationally, Kerry only did 1 point worse than he did nationally, and Obama did a point better nationally, if we did that, then Colorado would have a R+2 lean instead of being considered a D+0). It's up to each individual to decide whether or not more data should be added, but this is mostly the balance between having too much data and having too little.

9. “The PVI is meant for congressional districts, and shouldn't apply to states, yet you keep using states as your examples, why?”

As was mentioned earlier, the PVI is usually only calculated for congressional districts, but that doesn't mean that they are the only thing which has a PVI. So long as we have the data, we can figure out, not only what the PVI for each state is, we can also figure out the PVI of each county and even the precinct level. The reason why I'm not using congressional districts in my example is because the data isn't available yet.

And there is my explanation of the Partisan Voting Index, as a project, I'll probably start calculating the PVIs of each individual state (look for it on Election Inspection).

PVI

PVI’s arent offically out but some numbers are available (CT, VA)

However it is easy to figure out by looking at vote by county and which county’s went for Obama or McCain.

For example. Shea Porter’s district  had a PVI of R+1 or +2

but Obama carried each district and so logically this will flip it to a D+2,3 4 etc.

NY 19th,

NV 2nd

Disctricts held by republicans or Democrats which were split down will see huge flips soon letting to rest all the talk about “red” districts

Crowdsourcing Pres-by-CD, 3rd Thread

Just a quick update on our project to crowdsource presidential results by congressional district. The following states are all in need of links to official data sources and “plans of attack”:

Alabama

Colorado

Florida

Illinois

Indiana

Louisiana

Mississippi

New Jersey

Oklahoma

South Carolina

Tennessee

Texas

Utah

Washington

The data sources don’t have to have actual numbers available yet – in fact, since most states won’t certify their vote totals for a while yet, that is only to be expected. And as for “plan of attack,” I’m talking about how we expect to crunch the numbers – do the states publish results by CD? Do they divide up (relatively) neatly by towns or counties? Or will we have to rely on raw precinct data?

Please input any relevant links or information into this spreadsheet. Thanks!

Crowdsourcing Pres-by-CD, 2nd Thread

Last week I wrote about a new crowdsourcing project we’re undertaking here at SSP: compiling presidential voting results by congressional district. Here’s a quick status report:

  • We’ve figured out ways to calculated pres-by-CD for a little over half the states. See this spreadsheet, which anyone can edit.

  • However, there are many states where we don’t have a planned method for calculating the numbers. If you have thoughts about how to figure out those states, please add them (and any links you have to official or soon-to-be-official results).

  • Separately, if you’ve started doing work on some actual numbers, I strongly encourage you to share that work in separate Google spreadsheets. I’ve added a new column on the right in the “mothership” spreadsheet called “Calculations.” Please post URLs to any other spreadsheets you’ve created to crunch the data.

And if you have any other ideas for this project, please share them here in comments. Thanks!

UPDATE: Here’s a very simple example of what I mean by “showing your work.” The CT SoS very kindly makes raw presidential vote totals by CD available – you can see them in this PDF. I’ve uploaded a Google spreadsheet into which I’ve imported those numbers from the PDF, then did some super-simple math to calculate the percentages in each district.

Even if you’re working with something more complicated like counties or precincts, you can and should create something similar to my CT sheet. That way, everyone can see what data you’re using and verify that things look right.

UPDATE 2: Thanks to an awesome find by statsgeek, I put together a spreadsheet for MN as well. There are two tabs – “Formatted Data” is just a pretty condensed version of the raw data, which you can see in all its glory in the second tab. The state of MN actually made this extremely easy, going so far as to calculate the percentages each candidate got. It was just a matter of parsing the file properly and digging out the right numbers.

Crowdsourcing Project: Presidential Results by CD

(Bumped.)

A favorite reference for election junkies like those of us who inhabit this site is, of course, presidential results by congressional district. Unfortunately, most states don’t publish this data,  but it’s reliably churned out by a firm called Polidata every four years. It’s a difficult task, though, because it usually involves crunching data on a precinct level (and also figuring out what the hell to do with absentee ballots), so Polidata typically releases its findings some time in March after a presidential races.

But the good news is that, working together, we can come up with some preliminary data for at least some states. There are at least three types of states where we can get this data relatively easily:

1) States with just one at-large district (duh), like Montana.

2) States which actually publish presidential results by CD, such as Virginia.

3) States where district lines follow county lines or, in New England, township lines (or at least follow them closely), like Iowa.

Where we need help (at this stage) is in figuring out which states fall into the second and third categories. I know California also releases results by CD, but I believe a few other states do as well. And Arkansas and West Virginia follow county lines, but some other states probably do, too.

Also, let’s use this thread for brainstorming about other ways we might try to figure out presidential results by CD (short of acquiring detailed precinct-by-precinct data). Please share your thoughts in comments.

UPDATE: Jeffmd observes that some states offer easy-to-use precinct data, so where available, that might be an option as well. If you’re aware of any states which provide this information, please let us know that as well.

UPDATE 2: I’ve created a public Google Docs spreadsheet that we can use to compile a list of data sources. Please feel free to input any helpful information you’re aware of. Note that we’re not looking for the actual numbers just yet – rather, we want to know where we can find the numbers (and what format – ie, CD, county, precinct, etc. – we should be looking for). And if you are adding a URL, please use TinyURL.

Republicans Left in Blue Districts

The 2006 election left a lot of unfinished business: a number of Republicans in Dem-friendly districts who survived strong challenges and got a two-year grace period. The 2008 saw another swath cut through these folks, but there are still some left to be picked off, so this list should give us an idea of where to train our fire in 2010 (and also where to expect retirements). Here are the top 10 most Democratic-leaning districts, rated by current PVI (note that PVIs will change soon, once clearer presidential numbers by district are released) represented by Republicans, before and after this week.

110th Congress Rep. PVI 111th Congress Rep. PVI
DE-AL Castle D+6.5 DE-AL Castle D+6.5
CT-04 Shays D+5.4 NJ-02 LoBiondo D+4.0
NJ-02 LoBiondo D+4.0 IL-10 Kirk D+3.6
IL-10 Kirk D+3.6 WA-08 Reichert (?) D+2.3
NY-25 Walsh D+3.4 PA-06 Gerlach D+2.2
NJ-03 Saxton D+3.3 NY-03 King D+2.1
NM-01 Wilson D+2.4 PA-15 Dent D+1.6
WA-08 Reichert D+2.3 FL-10 Young D+1.1
PA-06 Gerlach D+2.2 IA-04 Latham D+0.4
NY-03 King D+2.1 NY-23 McHugh R+0.2

Note that we’re down to only 9 GOPers left in districts with Dem-leaning PVIs (with the departures of Porter, Fosella, and Knollenberg as well).

Now let’s look at the flipside: Democrats in the darkest red districts. Not as much turnover here, but obviously it suggests Walt Minnick will be our greatest vulnerability for 2010 when he runs against a non-brain-damaged opponent.

110th Congress Rep. PVI 111th Congress Rep. PVI
TX-17 Edwards R+17.7 ID-01 Minnick R+18.9
UT-02 Matheson R+16.9 TX-17 Edwards R+17.7
MS-04 Taylor R+16.3 UT-02 Matheson R+16.9
TX-22 Lampson R+15.7 MS-04 Taylor R+16.3
ND-AL Pomeroy R+13.1 AL-02 Bright R+13.2
MO-04 Skelton R+10.8 ND-AL Pomeroy R+13.1
MS-01 Childers R+10.0 CA-04 Brown (?) R+10.9
SD-AL Herseth R+10.0 MO-04 Skelton R+10.8
IN-08 Ellsworth R+8.5 MS-01 Childers R+10.0
GA-08 Marshall R+8.4 SD-AL Herseth R+10.0

Nancy Boyda was #13 on the old list, and Don Cazayoux was #19. Kratovil and Markey will slot in on the new list at #11 and #13. Also, note that we now hold the 14th (ID-01) and 19th (TX-17) most Republican-leaning districts in the nation. The flipside of that, if you can imagine, would be if the Republicans held IL-02 (Jesse Jackson Jr. at D+34.9) and MA-08 (Capuano at D+33.0).

Post-2008 PVIs

This may be another one of those cases where I should wait until there’s actually been an election. But there have been a number of instances lately where I commented on a particular district’s PVI and thought to myself, “Yeah, but that PVI is going to change a lot after this election.” Nobody is polling the presidential race at the level of individual districts (except, of course, the states that have only one House district), so short of breaking out the crystal ball, I can’t address House districts with much specificity.

However, what I can do is use current polling to predict likely percentage splits for each state in 2008, and plug those numbers into the PVI formula along with the 2004 percentages to calculate new PVIs for each state. (PVI, of course, is used in the context of House districts, but the formula is easy enough, and can be applied to pretty much any unit of analysis: states, counties, legislative districts, precincts, and so on. In fact, I’m surprised it isn’t, as a means of analyzing Senate races.)

For 2008 numbers, I’m just going to use today’s projection for each state from 538.com. (These numbers fluctuate a bit every day, so this post will already be out of date tomorrow.) Not to say that Nate’s prediction model is the be-all-and-end-all, just that it’s a good model for my purposes, since it basically pushes every leaner and accounts for third-party votes (so that each total actually adds up to 100). Over the flip, for each state, is the old PVI (reflecting the 2000 and 2004 elections), the new PVI (reflecting the 2004 and 2008 elections), and the difference.

Not surprisingly (since we’re measuring the same thing, although my numbers are blunted by being averaged out with 2004 results), the “difference” results look a lot like this map Chris Bowers put together at Open Left showing the biggest shifts in the new Obama electoral map. Big D+ shifts in the West and Great Plains, R+ shifts in Appalachia and the Northeast. (This doesn’t mean that, for instance, the Northeast is most rightward or going to give a smaller percentage to Obama than Kerry. It’s more like it’s standing still while the rest of the country moves left.)

State 00-04 PVI 04-08 PVI Difference
Alabama R+9.6 R+11.2 R+1.6
Alaska R+13.6 R+8.1 D+5.5
Arizona R+3.7 R+4.9 R+1.2
Arkansas R+3.3 R+6.3 R+3.0
California D+5.9 D+6.9 D+1.0
Colorado R+2.8 R+0.5 D+2.3
Connecticut D+7.5 D+6.8 R+0.7
Delaware D+5.7 D+4.2 R+1.5
Florida R+0.8 R+2.2 R+1.4
Georgia R+6.6 R+6.3 D+0.3
Hawaii D+7.3 D+6.6 R+0.7
Idaho R+18.9 R+13.4 D+5.5
Illinois D+6.1 D+5.9 R+0.2
Indiana R+8.6 R+5.8 D+2.8
Iowa D+0.2 D+1.5 D+1.3
Kansas R+11.1 R+10.2 D+0.9
Kentucky R+8.3 R+9.4 R+1.1
Louisiana R+5.1 R+7.3 R+2.2
Maine D+4.0 D+6.0 D+2.0
Maryland D+7.8 D+7.4 R+0.4
Massachusetts D+13.6 D+10.1 R+3.5
Michigan D+2.6 D+1.9 R+0.7
Minnesota D+2.0 D+3.8 D+1.8
Mississippi R+8.7 R+7.8 D+0.9
Missouri R+2.2 R+2.5 R+0.3
Montana R+10.9 R+5.6 D+5.3
Nebraska R+15.1 R+12.0 D+3.1
Nevada R+1.1 R+1.3 R+0.2
New Hampshire D+0.5 D+1.8 D+1.3
New Jersey D+6.1 D+3.7 R+2.4
New Mexico D+0.4 D+1.0 D+0.6
New York D+11.3 D+8.7 R+2.6
North Carolina R+5.8 R+4.2 D+1.6
North Dakota R+13.3 R+8.2 D+5.1
Ohio R+0.9 D+0.2 D+1.1
Oklahoma R+12.8 R+12.8 R+0.0
Oregon D+1.6 D+3.1 D+1.5
Pennsylvania D+2.2 D+2.1 R+0.1
Rhode Island D+13.0 D+10.6 R+2.4
South Carolina R+7.8 R+6.4 D+1.4
South Dakota R+10.6 R+7.0 D+3.6
Tennessee R+4.1 R+7.4 R+3.3
Texas R+10.6 R+8.1 D+2.5
Utah R+21.8 R+17.9 D+3.9
Vermont D+8.0 D+11.1 D+3.1
Virginia R+3.6 R+2.1 D+1.5
Washington D+3.7 D+4.6 D+0.9
West Virginia R+4.3 R+5.4 R+1.1
Wisconsin D+0.6 D+2.3 D+1.7
Wyoming R+19.5 R+14.0 D+5.5

Now you might be sitting there thinking “Yeah, but I really want to know how Congressional District X is going to change!” Well, here’s a very rough method you might use: take the difference from the state where the district is, and apply it to the district. I’ll use my home district (WA-07) as an example. It’s currently D+30.3. Add D+0.9, and the adjusted PVI is D+31.2.

(Again, this is a rough method… different parts of different states are reddening or bluening at different rates. For instance, Seattle might not be bluening as fast as the sagebrush parts of the state; it’s kind of maxed out on liberalism, while eastern Washington has lots in common with Idaho, Montana, etc., where Obama is making up the most ground. On the other hand, because 2000 and the huge Nader effect that occurred is dropping out of the equation, maybe the PVI will shoot up even more in Seattle. Hard to tell, so just exercise your judgment.)

One last question, as a bonus. Does this rough method change the most and least liberal districts in the nation? Well, NY-16 is still safe in its position at #1, although it drops from D+43.4 to a nice moderate D+40.8. However, the most conservative district changes, as Utah is rapidly going one direction and Alabama is going the other. UT-03 falls from R+26.2 to R+22.3, while AL-06 goes up from R+25.2 to a batshit insane R+26.8.