Election Spreadsheet

Brian Christopher Sears sent us this spreadsheet of election results. Thanks Brian!

Please note that the information is still being worked on and will remain incomplete until official numbers are printed by the US Government.

Not sure how useful it is as an embed (below), so here’s the link to it: 2012 Election spreadsheet Google Docs.

32 thoughts on “Election Spreadsheet

  1. ATBAFT

    Johnson goes over 1% if one assumes a conservative number of votes in Okla. and Mich – say twice what previous prez candidates received or same as Clark received.

  2. DSZ

    It seems that there was nothing they could really do in either state, especially Michigan. Court cases were fought vigorously and should have been won – in the past, presidential and vp substitution has been pretty widely accepted (see Thomas Eagleton), yet the Michigan SOS and courts were determined to enforce an outdated sore loser rule that Michigan had abrogated in the past for presidential elections (see John Anderson).

    Oklahoma has I think the earliest or second earliest petition deadline, and a very high petition requirement as well. The LP made a good faith effort to reach the required number of signatures, failed by a small margin, and made a suit which should have succeeded based on the precedent of other courts rejecting March and April petition deadlines. Then they got Americans Elect to put Johnson on their ballot line, but the courts again defied precedent and said the wishes of Americans Elect national supersede those of the state parties (nevermind that in the past there were separate Democratic nominees in southern states vs. all other states).

    If Gary runs in 2016 he won’t have the sore loser problem in Michigan he had in 2012, as long as he doesn’t run in the GOP primary. If he decides to run early enough perhaps there will be more time to meet the ridiculous OK requirements or hire professional petition gatherers. If the LNC had hired professionals in OK in 2012 (maybe they did?) but had failed anyway you’d probably complain. Failing that, what else would you want them to do, bribe some judges?

  3. Richard Winger

    The Oklahoma Libertarian Party lawsuit is alive and well and I expect it to eventually win.

    Gary Johnson will get a substantial number of write-ins in Michigan. But we don’t know how many he got until the Michigan official canvass is done.

  4. Michael H. Wilson

    Johnson’s latest numbers this a.m. in Washington State are from the SoS web site
    Gary Johnson / James P. Gray
    Libertarian Party Nominees
    40,360 1.33%.

  5. just wondering

    Has anyone bothered to compile what Johnson’s percentage of the vote was in the 48+DC states and/or, including Michigan, the 49+DC states where he was on the ballot?

  6. DSZ

    @6 – Thanks for the information Richard. I assume this is the original LP challenge to the early deadline filed way back in March, correct?

  7. Larry West

    @8: Ask and you shall receive.
    [Note: This is not based on the above spreadsheet, but an earlier version of the one I was creating.]
    State Total Votes Johnson Vote Johnson %
    Alabama 793620 12283 1.548%
    Alaska 115974 6892 5.943%
    Arizona 1000628 30868 3.085%
    Arkansas 393000 16217 4.126%
    California 6926067 125030 1.805%
    Colorado 1270368 33584 2.644%
    Connecticut 901002 12518 1.389%
    Delaware 242584 3882 1.600%
    Dist. Columbia 222979 1634 0.733%
    Florida 4236032 44684 1.055%
    Georgia 1763889 45099 2.557%
    Hawaii 306525 3838 1.252%
    Idaho 212699 9454 4.445%
    Illinois 2916811 54798 1.879%
    Indiana 1152345 50055 4.344%
    Iowa 823333 12825 1.558%
    Kansas 427918 19870 4.643%
    Kentucky 679364 17063 2.512%
    Louisiana 808395 18135 2.243%
    Maine 397754 13446 3.380%
    Maryland 1556968 28226 1.813%
    Massachusetts 1900575 30526 1.606%
    Michigan 2560016 0 0.000%
    Minnesota 1543084 35042 2.271%
    Mississippi 525909 6387 1.214%
    Missouri 1215031 43029 3.541%
    Montana 199008 13978 7.024%
    Nebraska 290758 10648 3.662%
    Nevada 529905 10908 2.058%
    New Hampshire 366089 8260 2.256%
    New Jersey 1924329 19260 1.001%
    New Mexico 409298 27433 6.702%
    New York 3862281 42145 1.091%
    North Carolina 2190248 44798 2.045%
    North Dakota 126466 5222 4.129%
    Ohio 2690841 47183 1.753%
    Oklahoma 443547 0 0.000%
    Oregon 865082 20841 2.409%
    Pennsylvania 2907448 48758 1.677%
    Rhode Island 280622 4380 1.561%
    South Carolina 845756 16060 1.899%
    South Dakota 144997 5795 3.997%
    Tennessee 959054 18569 1.936%
    Texas 3294482 88111 2.675%
    Utah 229463 11071 4.825%
    Vermont 191658 3499 1.826%
    Virginia 1971088 31152 1.580%
    Washington 1588309 36497 2.298%
    West Virginia 234925 6204 2.641%
    Wisconsin 1613950 20278 1.256%
    Wyoming 70790 5302 7.490%
    Guam 23067 357 1.548%

  8. Larry West

    I said it was an old file (I believe about a week old), not very up to date, but I think the percentages are close. The first number is the total number of votes [when I last updated],. the seond number is Johnson’s votes, and the third number is the second number divided by the first number, converted to a percentage.
    I don’t think there are any math errors since I just did Excel calculations based on the data I had. My up-to-date file is on a different computer that I don’t have access to right now. I’ll do the same Excel formulas on it and see if there are any changes in Johnson’s percentages anywhere in the last week.

  9. Stewart Flood

    Not even close. You’re not using the total votes cast, and even a week old report from SC would have reported about 1.9 million votes.

    Based on a quick look at your data, you appear to be reporting the votes for the democrats as the total votes cast, which is a serious math error — even for a week old file!

  10. George Phillies

    The correct Massachusetts numbers are

    Barack H. Obama Joseph R. Biden, Jr. Democratic 1,900,575 60.76%
    Willard Mitt Romney Paul Ryan Republican 1,177,370 37.64%
    Gary Johnson James P. Gray Libertarian 30,526 0.98%
    Jill Stein Cheri Honkala Green-Rainbow 19,663 0.63%

    The vote total in the spread sheet is way wrong. Perhaps the excel thingie read the wrong columns.

  11. Kleptocracy And You

    LOL- Garbage IN Garbage OUT ! All that WASTED work ! Remind someone in charge to not hire these guys – LOL

    GJ and crew wanted 5% to get that huge GRANT from Uncle Sammie. Under 1% just wasn’t close………

    What’s the new slogan ? Johnson’16 Live FREE to Break 1%

    If the government can’t keep drugs away from inmates who are locked in steel cages, surrounded by barbed wire, watched by armed guards, drug-tested, strip-searched, X-rayed, and videotaped – how can it possibly stop the flow of drugs to an entire nation? – Ron Crickenberger -> http://www.lp.org/

  12. Larry West

    I used the wrong formula on summing, — did a sum(b3,CS3) instead of a sum(b3:cs3).
    Here is the corrected numbers:
    State Total Votes Johnson Vote Johnson %
    Alabama 2064699 12283 0.595%
    Alaska 278189 6892 2.477%
    Arizona 2244150 30868 1.375%
    Arkansas 1065577 16217 1.522%
    California 11604870 125030 1.077%
    Colorado 2475423 33584 1.357%
    Connecticut 1562939 12628 0.808%
    Delaware 413890 3882 0.938%
    Dist. Columbia 243995 1634 0.670%
    Florida 8471024 44684 0.527%
    Georgia 3897839 45324 1.163%
    Hawaii 434519 3838 0.883%
    Idaho 651661 9454 1.451%
    Illinois 5091061 54798 1.076%
    Indiana 2618327 50055 1.912%
    Iowa 1581941 12920 0.817%
    Kansas 1131244 19870 1.756%
    Kentucky 1796787 17063 0.950%
    Louisiana 1994066 18157 0.911%
    Maine 710754 13446 1.892%
    Maryland 2612280 29200 1.118%
    Massachusetts 3128134 30526 0.976%
    Michigan 4717728 0 0.000%
    Minnesota 2939568 35158 1.196%
    Mississippi 1214004 6408 0.528%
    Missouri 2744935 43029 1.568%
    Montana 478981 13978 2.918%
    Nebraska 768450 10648 1.386%
    Nevada 1012407 10908 1.077%
    New Hampshire 705874 8319 1.179%
    New Jersey 3378818 19483 0.577%
    New Mexico 774334 27433 3.543%
    New York 6188973 42452 0.686%
    North Carolina 4510899 44798 0.993%
    North Dakota 322012 5222 1.622%
    Ohio 5379099 47287 0.879%
    Oklahoma 1334872 0 0.000%
    Oregon 1737823 23124 1.331%
    Pennsylvania 5647224 49169 0.871%
    Rhode Island 446046 4388 0.984%
    South Carolina 1963876 16319 0.831%
    South Dakota 363815 5795 1.593%
    Tennessee 2454470 18569 0.757%
    Texas 7965485 88111 1.106%
    Utah 923301 11071 1.199%
    Vermont 299307 3487 1.165%
    Virginia 3854378 31214 0.810%
    Washington 2996822 39693 1.325%
    West Virginia 661643 6204 0.938%
    Wisconsin 3056802 20278 0.663%
    Wyoming 249061 5326 2.138%
    Guam 31867 357 1.120%

  13. Larry West

    My apologies for the earlier error.
    If my calculations are correct, Johnson is 21,382 votes short of 1%.

  14. Michael H. Wilson

    GJ’s latest numbers from Washington State with votes still to be counted

    Gary Johnson / James P. Gray
    Libertarian Party Nominees
    40,866 1.34%

  15. PeterO

    I love the notion of a “Green Rainbow” party. Is that seven visible shades of green, with infragreen and ultragreen not visible to the naked eye?

  16. Zapper

    @19 Thanks for the numbers. Is it possible you could produce the same kind of list for Clark 1980 for comparison state by state.

  17. Kleptocracy And You

    @22 what about the Bikini wearing EYE?

    ?*!*!*!*!*!*!*!*!*?

    Many people claim that “libertarians are always whining about government being the problem, but they never offer solutions.” Let “Problem? Solved!” offer the solutions they seek. This is an alphabetically arranged list of common problems in society which are used to justify a government, and some of the possible, liberty-compatible solutions that could be used to solve the problems. No coercion needed! – http://www.kentforliberty.com/books.html

    “For a long time I felt that FDR had developed many thoughts and ideas that were his own to benefit this country, the United States. But, he didn’t. Most of his thoughts, his political ammunition, as it were, were carefully manufactured for him in advanced by the Council on Foreign Relations-One World Money group. Brilliantly, with great gusto, like a fine piece of artillery, he exploded that prepared “ammunition” in the middle of an unsuspecting target, the American people, and thus paid off and returned his internationalist political support.

    “The UN is but a long-range, international banking apparatus clearly set up for financial and economic profit by a small group of powerful One-World revolutionaries, hungry for profit and power.

    “The depression was the calculated ’shearing’ of the public by the World Money powers, triggered by the planned sudden shortage of supply of call money in the New York money market….The One World Government leaders and their ever close bankers have now acquired full control of the money and credit machinery of the U.S. via the creation of the privately owned Federal Reserve Bank.”

    Curtis Dall,

    FDR’s son-in-law as quoted in his book, My Exploited Father-in-Law

    – Got to know who your enemies are, before you can defeat them friends.

  18. Larry West

    @23 Zapper:
    Here is the list you requested. The first percentage is what Johnson received, and the second number is what Clark received in 1980 [and yes, he did get 11.66% in Alaska]. In half the states, Johnson did better than Clark, and in half he did worse.
    Alabama 0.59% 0.99%
    Alaska 2.48% 11.66%
    Arizona 1.38% 2.15%
    Arkansas 1.52% 1.07%
    California 1.08% 1.73%
    Colorado 1.36% 2.17%
    Connecticut 0.81% 0.61%
    Delaware 0.94% 0.84%
    Dist. Columbia 0.67% 0.63%
    Florida 0.53% 0.83%
    Georgia 1.16% 0.98%
    Hawaii 0.88% 1.08%
    Idaho 1.45% 1.93%
    Illinois 1.08% 0.82%
    Indiana 1.91% 0.88%
    Iowa 0.82% 1.00%
    Kansas 1.76% 1.48%
    Kentucky 0.95% 0.43%
    Louisiana 0.91% 0.53%
    Maine 1.89% 0.98%
    Maryland 1.12% 0.92%
    Massachusetts 0.98% 0.87%
    Michigan 0.00% 1.06%
    Minnesota 1.20% 1.54%
    Mississippi 0.53% 0.61%
    Missouri 1.57% 0.69%
    Montana 2.92% 2.70%
    Nebraska 1.39% 1.42%
    Nevada 1.08% 1.76%
    New Hampshire 1.18% 0.54%
    New Jersey 0.58% 0.69%
    New Mexico 3.54% 0.96%
    New York 0.69% 0.85%
    North Carolina 0.99% 0.52%
    North Dakota 1.62% 1.24%
    Ohio 0.88% 1.14%
    Oklahoma 0.00% 1.20%
    Oregon 1.33% 2.19%
    Pennsylvania 0.87% 0.73%
    Rhode Island 0.98% 0.59%
    South Carolina 0.83% 0.56%
    South Dakota 1.59% 1.17%
    Tennessee 0.76% 0.44%
    Texas 1.11% 0.83%
    Utah 1.20% 1.20%
    Vermont 1.17% 0.89%
    Virginia 0.81% 0.69%
    Washington 1.32% 1.68%
    West Virginia 0.94% 0.59%
    Wisconsin 0.66% 1.28%
    Wyoming 2.14% 2.55%

  19. Stewart Flood

    So…

    All that blustering by some states about how great Johnson was going to do there — and MOST OF THEM DECREASED IN PERCENTAGE FROM 1980!!!

    South Carolina just worked the message, talked to voters, and got our highest turnout and highest percentage ever!

  20. just wondering

    @19 — That’s not what I was looking for. If you could exclude Michigan and Guam, sum the first two columns and produce a percentage from those, that would be what I was asking for.

  21. just figuring

    @19 @30 et alia — if you want something done right…:

    Using http://www.uselectionatlas.org :

    125529686 total votes cast
    – 4724497 (MI)
    – 1334872 (OK)
    ———–
    119470317 votes cast in 48 states + DC where Gov. Johnson was on the ballot.

    Gov. Johnson received 1,236,280 votes in those 48 states and DC.

    Therefore, Gov. Johnson received 1.03% of the vote where he was actually on the ballot.

Leave a Reply