Someone asked me for some help creating some maps similar to the vote total maps we have in our MAPS section. I wrote a tutorial for creating a very basic vote total map using Google Fusion Tables to display a Google Map showing the vote totals. This particular tutorial will create a map for Obama’s 2012 Presidential performance by Chicago ward.
Download the Tutorial
Included in the file are:
- A Word document with step by step instructions.
- A KML file with the Chicago ward boundaries.
- An Excel file with the vote totals.
- An HTML file with the example output.
Instead of writing my usual post mortem blog post on the election results for last week’s mayor’s race I agreed to work with the Illinois Campaign for Political Reform to perform a somewhat longer and more in-depth election analysis and write a comprehensive report.
One of the elements I found most interesting was that we were able to use US Census data to find a workable definition of the “Two Chicagos” message that the Garcia campaign focused on and one of the more surprising outcomes was that Emanuel did better than I expected among voters in this less affluent, more minority segment of city voters.
A few other interesting observations:
- The Garcia campaign was able to turnout more Hispanic voters in April, something that is very difficult to do, and voters in Hispanic majority precincts made up a greater raw total of new voters in April than voters in African American majority precincts despite the fact that the Hispanic voting population is far smaller. In April there were almost 26K more voters than February in Hispanic majority precincts compared to just under 23K more voters in African American majority precincts.
- Despite the impressive increase in voters from majority Hispanic precincts the increase in voters in white majority precincts was even greater. There were about 46K more voters in white majority precincts in April than in February.
- Also, despite the impressive increase in new voters in Hispanic majority precincts Emanuel maintained roughly the same level of support in these precincts from February to April. In February Emanuel had the support of about 34% of the voters in Hispanic majority precincts and in April that only fell to 33% in Hispanic majority precincts, so despite the increase in enthusiasm and turnout Emanuel still held on to his supporters.
Go read the whole thing, there is a full analysis on this “Two Chicagos” element, plus data on turnout, income, education and race.
If you’re like me you want to download all of the Chicago Mayor election results in this April runoff by precinct and you don’t want to have to load each ward’s page and then copy and paste that into a spreadsheet. Paul Smith was kind enough to share a Python script to download the results but I was unfortunately unable to get his Python script to work so I wrote one in php and got that to work.
Download the 2015 Mayor Runoff by Precinct
Click on the link above to download the April Runoff Election Results by precinct. This will probably take 60 – 120 seconds to run before it lets you save the file. This script will check the CBOE website and then it will write the data to a CSV file that you should be able to download and open in Excel and it will have the Mayor’s race election results by precinct. If the CBOE updates their vote totals with either 1) updated precinct totals or 2) updated VBM totals (or both) just click on the link above again and it will pull the latest data.
If something isn’t working right let me know. Thanks.
One item really quick, I went to the CBOE website and pulled the registered voter totals from February and the ones they have currently listed for the runoff and put them into the table below, ordered by the largest increase to the smallest.
I had expected to see Hispanic wards with the largest raw increases for two reasons, 1) those wards generally have the lowest raw registration totals so they had the most room to grow and 2) some Hispanic focused polling showed significant enthusiasm about the election.
Instead the wards with the largest raw increase in registration since February tend to be wards that are affluent or white or both. Those are subgroups that tended to favor Emanuel in February. It’s impossible to say which candidates these new registrants are most likely to support, you could make a case for either candidate, but looking at these numbers they did not match the numbers I expected to find.
On election night back in February the only vote totals made available by the Chicago Board of Elections were the citywide totals. It wasn’t until around 11 or midnight that the ward by ward totals were available. There isn’t a whole lot of interesting analysis that can be gleaned from just the aggregate totals so I probably won’t be doing much tomorrow night.
My hope is that the major media outlets cover this election night well, I thought they did a good job with the runoff. Keep an eye on the Sun-Times, on election night in February a few of their reporters were discussing ward by ward totals well before the Chicago Board of Elections was making that data publicly available. Also, WBEZ has had a lot of good data work throughout this election.
Here are a few of the questions I think people will want to try to quantify on election night, if possible.
- How many total votes are projected: (total votes counted so far) / (whole number percent precincts reporting / 100)
- What percentage of the uncounted vote does the candidate who is behind need to win in order to move ahead?
- Separate the wards by majority African American, majority Hispanic, majority white and no majority, how did each candidate do? How many total votes in each area? Which areas saw the greatest increase/decrease in support levels and turnout?
You should be able to answer the first two questions even without ward by ward totals. Also, the CBOE should be able to tell you how many vote by mail applications were processed and how many ballots were returned so far. The remainder will be a useful number, if there are 20,000 outstanding VBM ballots and the election night totals are within 20,000 votes you’ll want to know that. Any vote by mail ballots have to be postmarked today to be counted but they can be received at any time in the next few weeks.
Unlike November there is no same day registration so the total number of uncounted provisional ballots will not be as significant.
On Thursday afternoon I will be speaking at a lunch panel on the Chicago municipal elections sponsored by the Illinois Campaign for Political Reform. The event is at noon in the French Room of the Union League Club, ticket info is available here.
I typically do a post-mortem in the day or two after the election to cover all the various insights available from the data. For this election I have agreed to be part of a larger and more comprehensive written report, I will probably even have to double check my spelling and grammar. The report should be available early next week, I’ll provide a link when it is available.