Back in the primary we pulled together a team of volunteers to manually enter the election returns for the Republican Primary for Governor so that we could break down that data into usable chunks and draw conclusions in real time about how the race was unfolding. We will not be doing that for the general election next month, it's just not possible. Even if I wanted to I couldn't pull together the volunteers to perform that full real time analysis for even one race and to do it right it would need to be done for both the Governor's race and the Treasurer's race since recent polling shows that both of those races could go either way. (If you would like to do this yourself I'm giving away my tools for free below.)
Someone who is getting a live stream of election data needs to take the lead and format their output to give us the kind of useful data we need. My goal back in the primary was to demonstrate what could be done with all the election return data that comes in on election night if someone turned that data into something usable. These are the most important questions on election night:
Of the four questions above it has long been my frustration that news organizations really only attempt to answer questions 1 and 2 even though they have the means to answer questions 3 and 4 as well. They really only attempt to tell you the entire statewide totals and the number or percentage of the precincts reporting even though the means to provide much more information is easily available to them. You can't necessarily do this for every race but you can pretty easily put the statewide races into the proper context to either answer questions 3 and 4 or at least provide a pretty good guide.
News organizations can buy a live data stream from the AP, this is where most news organizations get the data they display on their websites on election night. I cannot do this, I tried, I asked for a quote to purchase this data and/or subscribe to the AP's service and I was explicitly told they would not allow me to be one of their customers because I was not a news organization. Clearly that's a stupid policy but it's not exactly shocking news that media people are bad at business.
But since news organizations have access to this data stream it's not much more work to format this data and run some basic mathematical calculations on the data to display the numbers in a usable format. They already have some developer write code to take the data out of the AP's data stream and then format it to display correctly on their election night web pages, just add a little extra effort to then display this info in a way that's helpful for people to understand.
News organizations I IMPLORE YOU use this as a guide and take these tools I am giving away for free and show us the data in a way that allows you to answer all four questions above instead of just the first two. Take the historical data found on this website (and below), take it, I mean literally take it, copy and paste it into your own election night websites or just use iframes and take the data directly from here. Let people compare the real time data with the historical data so they can draw conclusions about which candidates are beating/missing expectations and which candidates are likely to improve their position when the not yet reported election returns come in.
Campaigns, if you're looking to run your own election night vote counting operation and you want some help you can download the spreadsheets (and instructions) that we used in the primary here:
About Illinois Statewide Elections
There are 102 counties in the state but there are 110 election authorities (102 county and 8 municipal). The eight municipal election authorities are Chicago, Aurora, Galesburg, Bloomington, Peoria, East St. Louis, Danville and Rockford. The county election authorities in the counties where these cities are located only cover the precincts outside of these cities. So for example if you wanted to know how a candidate is performing in Cook County you would have to add that candidate's totals from both the Cook County Election Authority and the Chicago Board of Elections. So to get totals by county you have to account for these 110 individual inputs of data and add them correctly to be able to display the 102 county totals.
If you have all of the inputs above everything else is pretty easy. You can then add up the totals by media market and/or regions. Media markets are comprised of whole counties so this is an easy calculation. You can see a map of media markets here.
You can also calculate the totals by region. Typically in a general election the City of Chicago will be just under 20% of the total statewide vote and the Cook County suburbs will also be just under 20% of the total statewide vote. The five traditional collar counties (Lake, McHenry, Kane, DuPage and Will) will account for just under 25% of the total statewide vote and the remaining downstate 96 counties will account for between 35% - 40% of the total statewide vote. These segments have distinct historical voting patterns from one another and the speed of these election returns can vary so it's useful to see it broken down this way.
Also, if you'd like you can break the vote down by region using the expanded 11 collar counties instead of the traditional 5, for more on that see here.
Most importantly, if you don't want to take the time to segment all of these counties into these various definitions (by media market, by region, etc.) just download my spreadsheet from the link above, each of the 110 election authorities is already defined for you.
The whole point here is that if you can segment the returns coming in by media market or region and you have historical data to compare it to with the same geographical boundaries you can compare this partial data to the historical data and begin to answer the questions listed in #3 above: "Which candidates are overperforming/underperforming expectations? By how much? And where?"
Displaying Data by Media Market
Broadcast TV ads for statewide campaigns are segmented by media market. When campaigns purchase ads they do not necessarily purchase ads in every media market and different media markets are likely to see different ads. Some markets are also more efficient than others, for example the Champaign/Springfield/Decatur market and the Peoria media market are both entirely contained within the state's borders whereas a market like St. Louis bleeds over into Missouri so you would be paying there to air ads to many people (Missouri residents) who cannot vote in the election. Voters who live in inefficient media markets are likely to see fewer ads than voters in more efficient markets. Since campaigns don't communicate with all of the state's voters in the same way or with the same frequency in their paid media it is useful to segment the election returns in a way that mirrors the segmenting used when broadcast TV ads are purchased.
|Entire Tab Control:||<iframe src="https://illinoiselectiondata.com/analysis/mmgentabs.php" width="575" height="350" ></iframe>|
|Dem Perf:||<iframe width='500' height='250' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dEtwYV9zWE5IakxkY2pqOGVITTNvNWc&single=true&gid=0&range=a1%3Aac13&output=html'></iframe>|
|Rep Perf:||<iframe width='500' height='250' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dEZWTlBYYnh4cF8tdFVvbTNBVHljSkE&single=true&gid=0&range=a1%3Aac13&output=html'></iframe>|
|Vote Share:||<iframe width='500' height='250' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dG91VHJxZDBKS3hHVzlGeXpmVml4N1E&single=true&gid=0&range=a1%3Aac13&output=html'></iframe>|
|Turnout:||<iframe width='500' height='250' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dHM1MkdxbEZpWDNFMmUzWHMxR2tqZXc&single=true&gid=0&range=a1%3Ag12&output=html'></iframe>|
Displaying Data by Region
Bruce Rauner has publicly stated a goal of 20% in the City of Chicago. Prior to 2010 the Cook County suburbs had been a perfect bellweather for the state as a whole, but then 2010 Kirk and 2010 Rutherford became the first two candidates to win statewide without winning the Cook County suburbs for at least the last couple of decades. In the last Governor's race the downstate vote was historically interesting. Each of these regions has a story to tell.
You can decide for yourself if you'd rather show the regions using the traditional collars or the expanded collars (or both), I'd probably recommend using traditional collars (for an explanation of the difference see here).
|Entire Tab Control:||<iframe src="https://illinoiselectiondata.com/analysis/tradcollarsgentabs.php" width="575" height="275" ></iframe>|
|Dem Perf:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dEx3ZmpmVnN0eGtMMW03RjlvNEk5Ync&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Rep Perf:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dHVyV0x1Y1RHUGRkLUV2eTVmRW1lM0E&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Vote Share:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dERUSF9yYzdKZzBTRGpUU1pkQk9NM2c&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Turnout:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dG5oRGRGc3hsakY2NHdLNDBIY1Bobnc&single=true&gid=0&range=a1%3Ag7&output=html'></iframe>|
|Entire Tab Control:||<iframe src="https://illinoiselectiondata.com/analysis/expcollarsgentabs.php" width="575" height="275" ></iframe>|
|Dem Perf:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dEd2ZmhSV3VCNnZqUTdFUGZTak92WlE&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Rep Perf::||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dGNPWVFDaWZoVVBCa3NzOXJJV1pucXc&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Vote Share:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dGxNVXlnRTItZ2RFUUpNeElrd3lqU2c&single=true&gid=0&range=a1%3Aac8&output=html'></iframe>|
|Turnout:||<iframe width='500' height='160' frameborder='0' src='https://docs.google.com/spreadsheet/pub?key=0Ar6RxFH3Vvz9dG1WTlRuOUtwRF95WnhNUjBXVW16cmc&single=true&gid=0&range=a1%3Ag7&output=html'></iframe>|
Projecting the Uncounted Vote
The last question that everyone has on election night but very few even attempt to answer has to do with the votes that haven not yet been counted/reported. Which candidate does it favor?
There are any number of really complicated ways you can attempt to project an answer to that question, I'm going to go over two pretty simple methods. However they each have their drawbacks.
Method 1 - Extend the Current Voting Patters
I used this method when we covered the 2014 Republican Primary for Governor last spring. For each of the 110 different local election authorities I simply applied the current vote ratio and extrapolated those numbers as if 100% of that area's precincts had reported. For example, if in one area 5 out of 10 precincts have reported and Candidate A had 100 votes and Candidate B has 80 votes the extrapolated Projected totals would be that Candidate A is projected to receive 200 votes and Candidate B is projected to receive 160 votes in that area. Do that for all 110 election authorities and add up the results to get the projected totals.
It's a very simple projection formula and it performs poorly very early in the night when only a few precincts have reported. It obviously gets better with more data. It's the sum of 110 separate calculations which is helpful but it also assumes an even partisan (or candidate support) distribution within each of those 110 election authorities which in some instances is an incorrect assumption. But it's a pretty basic calculation that is easy to perform and will get you a decent projection.
However as I learned the hard way on election night last spring early voting can cause some trouble in the calculation. There were many counties that were reporting only their early voting totals and listed zero precincts reporting for a few hours before any of their returns started showing up. This will cause some problems with your calculations so you'll need to account for this.
You can use this method to both project what the final results might look like based on current vote totals and also to predict which candidate is favored to win the support of the yet uncounted vote.
Method 2 - Use A Generic Partisan Baseline
Method 1 creates projections based on actual candidate performance, this method is based on a baseline of generic partisan expectations.
For example, let's say you started with the Cook Partisan Voting Index for each of Illinois' 18 congressional districts and assigned them a partisan score. You could then take a weighted average of each district's uncounted vote weighted by this partisan score. Let's say that the only uncounted precincts remaining in the entire state were in the 5th and 6th CD's. Let's say that 25% of the vote in the 5th CD was still not reported and 50% of the 6th CD. If the 5th is D+16 and the 6th is R+4 then you could use these figures and get a weighted average of the expected generic partisan makeup of the yet unreported vote. Obviously you wouldn't want to use this method if you'r expecting a strong 3rd party candidate vote.
The other problem with this methodology is the Cook Partisan Voting Index itself, you'd probably want to normalize it to more realistically match the current election. The Cook PVI combines the last two Presidential elections by congressional district and scores them relative to the national average. So if a district is listed as R+4 it means that the Presidential vote in that congressional district over the last two Presidential elections was 4 points more Republican than the national average. If you were to take an average of all 18 congressional districts in Illinois you'd come up with a Cook PVI for the State of Illinois at a little over D+8, this means that in the last two presidential elections the State of Illinois was about 8 points more Democratic than the country as a whole.
Well obviously there are a few problems with that, 1) this isn't a Presidential year election, it's an off year election and the electorate is going to be more Republican leaning than in Presidential years, and 2) in the last two Presidential elections Illinois elected a favorite son so that would artificially inflate the Democratic support. If you were going to try to use the PVI in this way you'd want to normalize it to offset both of the issues above.
Please, please, please give us better, more useful data on election night. Please. If you have any questions you can find my contact info here.
With Libertarian candidate Chad Grimm on the ballot for Governor's race I thought I'd pull up some data on historical 3rd party support. Here's a table showing the 3rd party support for each statewide race since 2002.
I knew there was strong 3rd party support in the 2006 and 2010 Governors races but until I looked this up I didn't realize that a non-trivial level of support for 3rd party candidates is pretty common. There are a lot of races here between 3% - 5%.
The other thing I have noticed is that Grimm's polling has been really consistent (see the tracker below). For the polls in the last month (at the time of this writing) his support scores are 5.88%, 5.00%, 5.00%, 6.00%, 6.00%, 5.00% and 7.27%, it doesn't get much more consistent than that.
I'm still not entirely sure where Grimm's election day support will fall, it's entirely possible that a number of poll respondents who are pledging support for him could either not show up or undervote the Governor's race. They could still also be won over by one of the two major party candidates. But for now I feel a bit more confident about a narrower range than I was expecting before I looked this up.
With Rauner publicly acknowledging a goal of at least 20% in the City of Chicago and our recent in-depth discussion of the downstate vote in this race I thought I'd put together a little utility that allows you enter predictions for each candidate's performance in these various regions and see how your predictions affect the statewide total based on the 2010 vote share numbers.
You can find historical Democratic and Republican performance by region here:
Also, a summary of recent polling, including by region where available, is below.
Also, this utility defines collars as the traditional 5 collars of Lake, McHenry, DuPage, Kane and Will. For more on that topic see the FAQ here.
Bruce Rauner recently announced that he is going to spend the remainder of the race campaigning in and around the Chicago area. There is some decent logic behind this strategy, it has long been the conventional wisdom that Bill Brady lost the 2010 Governor's race in the suburbs, and the numbers back that up. Take a look at the table below that shows the performance of Brady (Governor, lost) and Mark Kirk (US Senate, won) in their 2010 respective races by region (expanded collars).General Election Republican Performance - Expanded Collars (FAQ)
|Region||2010 Kirk||2010 Brady||Difference||Vote Share|
|Cook County (all)||31.63%||28.61%||3.02%||37.51%|
|___Cook Burbs (only)||43.47%||39.50%||3.97%||19.02%|
The expanded collars table groups "downstate" as the 90 counties outside the Chicago media market. You can see that in 2010 it made up a little more than 34% of the vote and the performance of Brady and Kirk is nearly identical, even though Brady is considered to be from the conservative wing of the Republican party while Kirk is less so. Even though Brady is from McLean County and Kirk is from the Chicago suburbrs, the voters in these downstate counties rated them equally and their performance was essentially the same.
The biggest difference was in the Chicago media market. The difference between the two candidates in the Chicago suburbs was about 4% but it varied by township. The difference was most pronounced in the affluent north and western suburban townships:
|Township||2010 Kirk||2010 Brady||Difference|
In the 11 counties in the Chicago media market other than Cook County (collectively referred to here as the Collars) the difference between Kirk and Brady was about 3 and a half points with the Lake County numbers the most pronounced:
|County||2010 Kirk||2010 Brady||Difference|
If the Rauner campaign can win over the Kirk-Quinn voters from 2010 they could have enough votes to win the election and since all of those Kirk-Quinn voters from 2010 are in the Chicago media market it makes sense for them to focus their campaign there now that we have reached the home stretch.
But what about Pat Quinn and the other candidates? 2010 was a strange year for Democratic performance downstate in that it was abnormally low. Take a look at the table below showing the Democratic performance of the candidates in competitive contested elections over the last few decades in the downstate counties outside of the Chicago media market:
In 2010 Pat Quinn, Alexi Giannoulias and Robin Kelly all performed worse than Carol Moseley-Braun did in 1998 outside the Chicago media market, and she was carrying a lot of baggage by then while unsuccessfully trying to fend off a well funded challenger. On this list only Dawn Clark Netsch performed worse than the competitive Democratic candidates of 2010 and she lost in a blowout by 30 points. In 2002 Tom Dart lost his race for Treasurer to the popular Topinka and in 2006 the Republicans actively campaigned against Blagojevich in their legislative campaigns tying the local Democratic candidates to the unpopular downstate incumbent governor, yet both of those candidates performed more than 5 points higher than Quinn and Giannoulias in the 90 counties outside of the Chicago media market.
They weren't just losing, they were losing downstate counties that had a history of going to Democrats like Madison, Fulton and Franklin by almost 20 points:
The downstate numbers for the Democratic candidates in 2010 weren't just bad, they were historically bad. So the question becomes, was this a once cycle free fall or the new normal?
One simple answer is that by 2012 Barack Obama was back up to 45.11% in the downstate 90 counties. As I mentioned before some of those numbers were probably helped in the Quad Cities by Iowa advertising, take a look at the map of Obama's performance by county and you can see that his numbers in the Quad Cities media market are noticeably better than his performance in the surrounding areas. But either way, one cycle later and those numbers bounced back to a historical norm.
The Presidential race was the only statewide race in 2012 but the Democrats performed strongly in a bunch of targeted State Senate races as well. First time candidate Andy Manar won the 48th Senate District (1D, 1R House members) by more than 10 points in a central Illinois district that stretches from Springfield to Decatur and down to eastern Madison County. (you can view district maps here) In the 36th SD (2D House members) up near the Quad Cities Mike Jacobs won re-election by more than 9 points. In the 46th SD (1D, 1R House memebers) in the Peoria area Dave Koehler won re-election by more than 8 points. In the 47th SD (2R House members) that runs from Quincy to Galesburg to almost Springfield John Sullivan was re-elected by almost 13 points. In the Metro East's 56th SD (1D, 1R House members) Bill Haine won by more than 17 points. And in deep southern Illinois' 59th SD (2D House members) perennial target Gary Forby won by more than 18 points.
The historically low downstate numbers for the Democrats in 2010 didn't carry over into the 2012 races. What can we expect in 2014 though? It's not a presidential year so the electorate will be smaller and more Republican leaning than in presidential years. Also Illinois native and favorite son Obama will not be at the top of the ticket, instead it will be Dick Durbin in what looks to be a pretty safe race and then Pat Quinn who remains unpopular downstate, even among his own party.
In 2014 the Governor's race was the only statewide primary race on the Democratic side to feature more than one candidate. Pat Quinn faced off against little known candidate Tio Hardiman, the former executive director of Cease Fire. Hardiman had lost his job at Cease Fire after his wife filed a domestic violence case against him, later withdrawn. Prior to running Hardiman also had a different guilty plea to a misdemeanor for domestic violence against a former wife expunged from his record.
You would not expect that a Chicago former executive director of Cease Fire with a history of domestic violence to become the preferred candidate of downstate Democrats but in the 2014 Democratic primary for Governor that is what happened. In this case it likely had less to do with people voting for Hardiman and more likely these votes were cast against Quinn in protest.
First take a look at the map of Hardiman's performance in the City of Chicago, it's very consistent with no wards above 30%. Next look at his performance map in the Cook County suburbs, again the same consistency with no townships above 30%. Then look at his county by county performance map, the difference jumps out at you, especially in southern Illinois. Hardiman won Marion county with more than 72% of the vote. In 6 other counties (Alexander, Clinton, Jefferson, Shelby, Union and Washington) he took more than 60% of the vote. The southern half of the map is littered with counties painted shades of blue, green or grey for Hardiman. Once you get outside of Cook and the traditional 5 collar counties everything is over 30%.
It may have been true that 2010 was a historically poor year for Democrats downstate that won't automatically translate to a repeat performance for Democrats this cycle but it's also true that Quinn is facing a popularity issue this cycle with downstate members of his own party. If he's that unpopular among Democrats it's likely to be true of downstate independents as well.
There is natural room for vote growth for Quinn in his downstate numbers. Even if he can only muster being as popular as Blagojevich was during his 2006 re-elect that would still improve his downstate numbers by about 5 points and a 5 point improvement downstate would translate to about 60,000 votes his way (and 60,000 away from his opponent) based on 2010 numbers. The mid 40's looks to be about the sweet spot for a typical Democratic candidate in a contested, competitive election, a far cry from the 34% Quinn took in 2010, but if he could somehow increase his downstate performance by 10 points it would be worth 120,000 votes his way (and 120,000 away from his opponent). In 2010 the race was decided by about 30,000 votes so these are meaningful numbers.
But in order to do that he's going to have to campaign hard there and win over voters that were clearly very angry with him back in March. Unlike Rauner who will focus like a laser on the City and suburbs, Quinn's path to victory likely includes a significant downstate component.
And what about the downstate Democratic candidates for Treasurer and Comptroller Mike Frerichs and Shelia Simon? Both are native downstaters who can likely count on above average support from the area. But if they're looking at the very visible Quinn anger displayed in the primary can they afford to risk being lumped in with Quinn downstate if his numbers don't improve? I am sure they would like to have the luxury to count on longstanding downstate support so they could focus their time and money on the Chicago media market but if Quinn's downstate numbers don't improve is that a risk they can afford to take? The Democrats have three downstate candidates on their statewide slate this year, Durbin, Simon and Frerichs, a more favorable downstate slate over recent cycles. They should be well positioned to rebound in their downstate performance but it will be interesting to see how the whole ticket performs and where the candidates and their campaigns spend their time and money to capitalize on the geographic makeup of their statewide ticket.
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.