Thank you to all who spent time with us last night. We had a lot of fun and I have leftover pizza in the fridge so that's a plus but I'm not sure that we'll do that again. It's very labor intensive. My hope is that enough people saw how you can cut and slice all the data that comes in and make it much more useful and helpful than simply knowing the running total for the candidates. Primaries are one thing, but come the general election there is even more useful available data and even more ways to use it. The news organizations get a ton of useful data throughout the night and simply don't tell you very much about it or display it in a useful way and they don't put it into a historical context. With the help of a bunch of great volunteers we were able to do that for one race, imagine if they programmed their computers to output it for all the races. I really hope they do.
Ok, on to some observations: (remember none of these results are official and when the official certified numbers are released in about a month there will be some minor changes)
Last, the law was changed last year so that starting with this election all 110 election authorities in this state have to provide the State Board of Elections with precinct-level results in all of these races. Depending on how usable that data is we could potentially format it, collate it and have some fun with it. For example, it would be interesting to know which state rep/sen districts Rauner and Quinn performed the best/worst in. At least it would give them a pretty good idea where they need to shore up their base. Hopefully it is data we can use.
2010 R-IL GOV PRI there were 767,485 total votes, looks like 2014 will have around 800K. Dem crossover didn't carry Dillard, Republicans did— IL Election Data (@ILElectionData) March 19, 2014
In the 90 counties outside the Chicago Media Market Dillard beat Brady 41-20. I would have lost a lot of money predicting these numbers.— IL Election Data (@ILElectionData) March 19, 2014
One more quick number before we leave, in the downstate 96 counties Dillard beat Brady 40-19.— IL Election Data (@ILElectionData) March 19, 2014
Have a good night, thanks for hanging with us.— IL Election Data (@ILElectionData) March 19, 2014
We have almost 95% of the precincts reporting and a 2 point race. The AP has called the race so I'm taking my team to the bar.— IL Election Data (@ILElectionData) March 19, 2014
More important reminder, the projections are based on a lot of incomplete data and should be taken with a huge grain of salt.— IL Election Data (@ILElectionData) March 19, 2014
Reminder, we are doing this by data entry because the AP refuses to let me pay for their data. Imagine if we could do this for all the races— IL Election Data (@ILElectionData) March 19, 2014
With more than 89% of the vote in we have Rauner with about a 2% lead and projecting that he pretty much holds it.— IL Election Data (@ILElectionData) March 19, 2014
Man I wish there was good data on TV spending by media market.— IL Election Data (@ILElectionData) March 19, 2014
In the Champaign/Spfld/Decatur media market Dillard leads Rauner 48-25, in Quads MM it's Rauner 36-33, in Peoria its Dillard 36-24.— IL Election Data (@ILElectionData) March 19, 2014
Here's what can affect those projected totals, we don't always have the right number of precincts reporting affecting those projected number— IL Election Data (@ILElectionData) March 19, 2014
Ok I've turned on the projected totals, and these numbers are based on some assumptions, AND WE'RE DOING DATA ENTRY, but damn this is close— IL Election Data (@ILElectionData) March 19, 2014
Most of the outstanding vote will come from outside Cook, right now Rauner is up 15% in the collars while Dillard is up 9% downstate.— IL Election Data (@ILElectionData) March 19, 2014
Historically the downstate 96 makes up about 46-47% of the primary total and the collars make up about 31-32%.— IL Election Data (@ILElectionData) March 19, 2014
Surprise of the night (for me) in the downstate 96 counties with 34.91% in Dillard leads w/ 40.99%, Rauner 30.62%, Brady 17.97%, Rford 10.91— IL Election Data (@ILElectionData) March 19, 2014
There is 48% of the vote in in the Chicago media market, none of the rest have more than 15% reporting.— IL Election Data (@ILElectionData) March 19, 2014
Rauner is at just over 50% in the Chicago media market, his strongest, and that's where most of the vote is from so far.— IL Election Data (@ILElectionData) March 19, 2014
Republican Gubernatorial election results are starting to trickle in, you can see in great detail here: http://t.co/mb6vY3pL94— IL Election Data (@ILElectionData) March 19, 2014
As promised we are bringing live election results for the Illinois Gubernatorial Primary tonight. @ILElectionData.
Reminder: We'll have live election night results of the Rep. Gov's race. You can get a peek at the dashboard here: http://t.co/mb6vY3pL94— IL Election Data (@ILElectionData) March 17, 2014
On the night of the Illinois primary I plan to have live election night returns for the Illinois Gubernatorial Republican Primary. While you can get live statewide totals at almost any Illinois news site (and some even give you county by county totals) I plan to have live data that shows real time totals for the statewide vote broken out by county, by media market and by region (both traditional and expanded collars) and showing vote share. Right next to the live results you'll be able to scroll through all of the historical results for Republican primaries going back years or even decades. I spent the weekend building the dashboard display for this and I'm happy with how it turned out.
Most major news organizations subscribe to the AP election package and they get live data from the AP on election night, that is how they are able to display the election results. I have tried to pay the AP for this data and they refuse to let me subscribe because this isn't a "news organization". So while I'd really like to have complete access to live data on every race in the state and be able to display it in a way that is helpful and useful to the people who like or need to see results in great detail for this election we still have to do it by hand and so we can only do this one race for now.
This effort is more likely to crash this website than to work and be cool but we are going to try it anyway. I have bribed a group of friends with pizza and beer to lookup the live election results for the Republican Gubernatorial primary from all 110 election authorities. I have created a big spreadsheet that a group of about 10-12 friends will be entering data into and it is set up to run a bunch of calculations and display all the data the way I like to see it. If it works it should be interesting and a lot of fun, but most likely the hosting company will be down that day or the website will crash though. Either way I just hope it works well enough to encourage the big news organizations in Illinois to take a look at how they display election night results and see what they could be doing better.
This website has a lot of data stored about various elections, for example you can find performance maps in the MAPS section as well as campaign budget information in the BUDGETS section. I wanted to create an easily navigated quick glance section by race for this data to make the data easier to find and use. Now there is a new section called ELECTIONS. Click on each of the pages below to find a quick glance page for each of the constitutional offices in Illinois with direct links to map and budget data.
You can find performance maps for every Democratic and Republican primary candidate for statewide office going back to at least 2002 and many races from 1994-2000 are also available. You can see maps by county, by Cook County township and/or by Chicago ward.
I'm pretty happy with this development as now this website can display all of the statewide maps I've had in my files and had hoped to include.
You can now see MAPS for all candidates in an election instead of just one. I'm very, very happy to be able to share this latest update, this was something that really bothered me from the day this site went live almost a year ago. Even now the Google software used to generate these maps is officially listed as "experimental" so it should come as no surprise that certain functionality was limited or unavailable when I first launched this site but unfortunately the only workaround would have involved an incredibly labor intensive process so I just waited. Now I'm very happy to be able to visually display all of the data I wanted.
Previously for each race that MAPS were available you could only see the map for one candidate in each race, you could at best then infer how the opposition performed but the limitation was frustrating. Now you can see the performance map for all the candidates. So for example if you happen to remember that in 2006 the Rockford Register Star was fed up with the Democratic and Republican candidates for Governor and instead endorsed Green Party candidate Rich Whitney you can look at this map and see what effect that endorsement had.
So far all the map data has been for general elections only but now I can and will add all the statewide primaries. That will probably take a few weeks (I just do this in my spare time) but I want to have it done before the NHL playoffs start and I'm sure March Madness will make it harder to find some free time.
After I get the statewide primary maps up I'd like to add more to the Chicago Aldermanic data set. The 2011 elections are already in there but I've always been meaning to add 2007 and 2003. So that's the update plan for now. As always I hope you find this information useful. Let me know if you find any errors or have any requests.
A little late but as promised I have updated the BUDGETS section. I had previously made available monthly fundraising and spending budgets (along with monthly payroll and weekly media buys) for about 12 competitive Illinois congressional races in the last few cycles. I had promised to update that report library with the 6 competitive congressional races from the 2012 cycle as well as go back and create the same reports for statewide races.
In order to produce these reports I downloaded the transaction data from the electronically filed reports of the candidates and then went through them line by line and assigned them to their proper budget section. Now not only are the latest congressional races included but I included every major party candidate for constitutional office (Gov, Lt. Gov, AG, SOS, Comptroller and Treasurer) from the 2010, 2006 and 2002 cycles (roughly 75 candidates). Further I created some quick glance tables in case you just want to look at the overall total raised/spent, and I put the entire database of transactions online. If you want to query all of the individual transactions I used to create these reports you can now copy that data for your own files and use it to build your own custom reports.
Even if you consider yourself a political junkie you may not find this part of the site particularly useful. It is really most helpful for campaign staffers who have to manage their campaign budget, usually just a campaign manager and/or an operations director. But for the candidates and staffers responsible for creating a campaign budget and managing the campaign's spending decisions this data is almost invaluable and will save you hours while trying to figure out how other past campaigns have managed the same challenges.
The data includes three types of reports, 1) monthly campaign budgets; 2) monthly payroll budgets and 3) weekly general election paid media (mostly/usually television). There are a number of reasons this information can be useful. If you are running your campaign well you are going to try to keep your payroll and operating costs to a bare minimum, but it is helpful to know just how low you can reasonably keep those operating expenses and it's valuable to see when other campaigns started hiring employees and/or incurring expenses.
Another issue that financial planners struggle with is figuring out how much your campaign will be able to spend on paid media and when to start spending. It's helpful to see when other comparable races started their paid communication and it's very helpful to see how comparable campaigns did in their fundraising in the final weeks/months of the campaign. You will almost certainly start spending your paid media budget before knowing how much money will still come in during the remainder of the campaign. You will have to make some estimates/predictions and you are going to want to base those estimates on comparable data if possible.
Here you will find quick glance tables listing the amount raised and spent during the election cycle for every statewide campaign and the key congressional races in my database.
Here you will find monthly campaign budget reports, monthly payroll reports and weekly (fall) media buy reports for every statewide campaign and key recent congressional campaigns.
You may be curious about the individual transactions that were aggregated to assemble these campaign budget reports. Here you can query the database of individual transactions I used to build these reports including the various data fields I appended when I went through these transactions line by line. Every bit of data I have is available here. With this data you can build your own custom reports to suit your needs.
Like any other data set this one has limitations and caveats so if you're planning to study this highly specialized data it's probably worth your time to be aware of the additional information provided in the FAQ.
There have been a few changes in the law that will affect how the Governor and Lt. Governor will be elected in 2014. I'll cover those changes and their impact below but I'm still left with one unanswered question: can a Lt. Governor candidate raise and spend funds in support of his/her election and if so how does that work?
Let me begin by saying I'm not an election attorney (or attorney of any kind for that matter) so just because I have unanswered questions isn't necessarily a cause for alarm. However two key changes in the election code will be in effect for the first time in a Governor's race for the 2014 election:
Prior to either of these laws going into effect the Governor and Lt. Governor were elected separately and because there were no contribution limits either candidate or both could have as many committees as they wanted. Sometimes candidates for Governor and Lt. Governor would agree to campaign as a team (even though both would still be required to win independent elections) and other times the elections for Governor and Lt. Governor went forward with the candidates willing to let the elections play out and deal with any outcome.
In 2006 Republican Gubernatorial candidate Ron Gidwitz agreed to campaign with Lt. Governor Candidate Steve Rauschenberger and even though each candidate had their own candidate committee for their campaign funds (Gidwitz for Governor and Citizens for Rauschenberger, respectively) they also decided to create a 3rd joint committee called the Illinois Turnaround Team for funds that would ostensibly be used to pay for campaign activities to support both candidates. I can't think of any legal advantage gained by creating a 3rd committee, it seemed to be only for cosmetic purposes as they campaigned publicly as part of a team (a turnaround team) working jointly. Ultimately both candidates were unsuccessful in their respective primaries but it's a good example of the various options that were available to candidates prior to the new laws going into effect.
In the 2010 Democratic primary the campaigns for Governor and Lt. Governor proceeded independently and in the end Pat Quinn secured the Gubernatorial nomination while Scott Lee Cohen was the victorious Lt. Governor candidate. Cohen later dropped out after pressure by Quinn and other Democratic leaders. Subsequently the Democratic party selected Shelia Simon as a replacement candidate at Quinn's behest. Simon could have legally created a campaign committee to raise and spend funds in support of this election however she never opened one in her own name. Quinn has had the longstanding Taxpayers for Quinn committee and also in the spring of 2010 they created a committee called Quinn/Simon for Illinois which was used to raise and spend a significant amount of funds in support of the Quinn/Simon ticket that fall. Again this joint committee doesn't appear to have provided the Quinn/Simon campaign with any additional legal advantages it simply had the cosmetic effect of a ticket working together.
Looking ahead to 2014 it appears that the law that implemented campaign contribution limits for the first time will also prevent the creation of these additional joint committees as a candidate is limited to one and only one candidate committee:
(10 ILCS 5/9-2) (from Ch. 46, par. 9-2) Sec. 9-2. Political committee designations. (a) Every political committee shall be designated as a (i) candidate political committee, (ii) political party committee, (iii) political action committee, (iv) ballot initiative committee, or (v) independent expenditure committee. (b) Beginning January 1, 2011, no public official or candidate for public office may maintain or establish more than one candidate political committee for each office that public official or candidate holds or is seeking. The name of each candidate political committee shall identify the name of the public official or candidate supported by the candidate political committee. If a candidate establishes separate candidate political committees for each public office, the name of each candidate political committee shall also include the public office to which the candidate seeks nomination for election, election, or retention. If a candidate establishes one candidate political committee for multiple offices elected at different elections, then the candidate shall designate an election cycle, as defined in Section 9-1.9, for purposes of contribution limitations and reporting requirements set forth in this Article. No political committee, other than a candidate political committee, may include the name of a candidate in its name.
What is less clear is how the law applies to someone running for Lt. Governor. Here are a number of questions that immediately come to mind:
It's entirely possible all of these questions have very clear answers explicitly stated in the law, I'm not an election attorney and even though I have a lot of experience dealing with the Illinois election code I freely admit I'm no expert. But if some of these questions don't have clear answers hopefully the legislature can use the upcoming spring session to clarify the election code prior to the 2014 election cycle kicking into full gear.
As promised I have the updated quick glance and scorecards for the 6 targeted congressional districts in Illinois with the exception of some of the data in IL-17. The Peoria and Tazewell county clerks have not yet published their precinct-level election returns for 2012GE so I haven't yet been able to pull the Presidential race and turnout info for that district, I'll update everything once that data is available. Since everything else was ready I saw no need to delay publishing this. As always, you can find this data in the VOTE ANALYSIS section.
Take a look at the table below. The first three column in the table show the Dem Perf/Rep Perf/Diff for the congressional race and then the last three columns show the Dem Perf/Rep Perf/Diff for the Presidential race:
|Cong D||Cong R||Diff||Obama||Romney||Diff|
|IL-08||54.74%||45.26%||D +09.48||57.35%||40.97%||D +16.38|
|IL-10||50.63%||49.37%||D +01.25||57.47%||41.19%||D +16.28|
|IL-11||58.39%||41.31%||D +17.08||57.32%||40.95%||D +16.37|
|IL-12||51.65%||42.74%||D +08.91||49.62%||48.17%||D +01.44|
|IL-13||46.21%||46.55%||R +00.34||48.26%||49.19%||R +00.93|
A few things jump out at me:
For quick comparison by district to past races here's the Quick Glance:
|12CONG||D +09.48||D +01.25||D +17.08||D +08.91||R +00.34||D +06.55|
|12PRES||D +16.38||D +16.28||D +16.37||D +01.44||R +00.93||D +16.87|
|10SEN||R +11.33||R +12.79||R +06.28||R +08.52||R +18.72||R +14.84||R +01.59|
|10GOV||R +07.64||R +00.93||R +03.96||R +06.08||R +19.99||R +14.59||D +00.69|
|10AG||D +27.10||D +30.96||D +29.26||D +19.73||D +18.25||D +22.90||D +33.07|
|10SOS||D +39.33||D +41.61||D +41.56||D +27.14||D +28.91||D +33.39||D +42.85|
|10COMP||R +26.34||R +21.08||R +18.49||R +10.04||R +24.79||R +16.74||R +11.74|
|10TREAS||R +19.11||R +13.19||R +12.39||R +04.70||R +19.97||R +09.76||R +04.42|
|08PRES||D +21.18||D +25.57||D +21.32||D +10.99||D +09.31||D +19.37||D +25.14|
|08SEN||D +34.08||D +37.08||D +33.53||D +30.06||D +29.97||D +35.27||D +39.31|
|06GOV||D +08.28||D +14.74||D +08.31||D +10.55|
|06AG||D +51.06||D +33.62||D +32.84||D +48.20|
|06SOS||D +32.87||D +24.01||D +24.23||D +29.79|
|06COMP||D +30.45||D +27.21||D +27.33||D +32.76|
|06TREAS||D +09.18||D +11.67||D +10.53||D +12.70|
|04PRES||D +02.57||D +06.20||D +10.34|
|04SEN||D +33.15||D +38.42||D +42.92|
And as always you can find the full scorecards for each district by clicking on VOTE ANALYSIS on the top toolbar and then scrolling down to "Congressional District Analysis" or just follow this direct link.
If you find an error or you think something might be wrong let me know. In order to compile this data I have to aggregate data from many different sources and then try and format it so that it all fits together. There's a lot of copying and pasting involved and even though I check and doublecheck for mistakes they're still pretty easy to make.
Here are some thoughts on the data that stood out after looking at the various data points from the 2012 election in Illinois, in no particular order:
|▪||ANNOUNCEMENT: New Subscription Service and Free iPhone/iPad app|
|▪||2018 Cycle District Rankings|
|▪||Understanding the Governor's Race (General Election) - Governor Rauner's 2014 Fundraising|
|▪||Understanding the Governor's Race (Dem Primary) - The 2004 Primary for US Senate|
|▪||Understanding the Governor's Race (Dem Primary) - The Burris Coalition|