Thanks to the wonderful efforts of the DataMade team at Election Money who have made the Illinois State Board of Elections campaign finance data far more usable I have attempted my first crack at creating a (somewhat) current dashboard for the current cash position of each of the major party candidates for constitutional office. Please send me your feedback including any suggestions for new dashboards. My hope is to do the same for the State House and State Senate races and also look at some of the outside money PACs that file with the Illinois SBE. Here are some notes:
I mentioned this on Twitter but forgot to update the front page. All of the 2014 Illinois primary data has been completely updated. All of the vote total analysis in the ANALYSIS section is up to date as well as the MAPS and even the ELECTIONS page profiles. If you're interested in the primary postmortem scroll down below, it turns out our election night numbers were pretty accurate and all the items held up when compared to the actual certified vote totals.
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.