Starting to get some of the vote data into a mySQL database. The results so far are a still-buggy and slow-loading list of votes by State Rep district, with the unlabelled, far right column being the Pres. vote.
A few things to note in this beta version ...
there's a bug in the District 119 data for the names that I need to solve.
... also a bug in District 3 ... unless 180,000 people REALLY did come out to vote in that part of the state (seriously doubtful).
I still need to write a loop of code that calculates the Pres vote where there's no GOP candidate.
Check the number of Hispanic districts that went for Bush! Not the least of which was Leibowitz's.
The percentages are straight R vs D numbers. That leads to a few quirks, but mostly minor ones. Apologies for Houston's own James Rice Harris for his notable 20% independent showing.
Terry Keel ... WOW! Are you vulnerable or WHAT?!?!?!?
Dade Malcolm ... dude, how bad of a candidate do you have to be to run 4 points BEHIND Kerry? Casey McKinney disappeared into thin air and only ran 2 points behind him.
Seeing the numbers in Bohac's district leads me to rethink the outside odds of it being winnable. Worth a wider sample, but if a Dem can't find a way to score 45% in that district or better, then we're out of candidates. I'd put Bohac's district ahead of Talton's in terms of winnability.