https://data.wprdc.org/mn_MN/datastore/odata3.0/88611068-27e2-4064-84ff-cc6ed7410957 2017-11-07T02:59:05.606677Z https://data.wprdc.org/mn_MN/datastore/odata3.0//88611068-27e2-4064-84ff-cc6ed7410957(2) 2017-11-07T02:59:05.606677Z ckan 2 contest_name Name of the office (or referendum) for which ballots are cast President of the United States Mt. Lebanon Referendum https://data.wprdc.org/mn_MN/datastore/odata3.0//88611068-27e2-4064-84ff-cc6ed7410957(3) 2017-11-07T02:59:05.606677Z ckan 3 choice_name Name of the candidate (or the referendum option) Abraham Lincoln YES If there are no candidates running in the contest, there will only be a WRITE-IN candidate. https://data.wprdc.org/mn_MN/datastore/odata3.0//88611068-27e2-4064-84ff-cc6ed7410957(4) 2017-11-07T02:59:05.606677Z ckan 4 party_name Three-letter abbreviation for the political party of the candidate DEM REP CON = Constitution Party, DEM = Democratic Party, GRN = Green Party, IND = Independent, LIB = Libertarian Party, REP = Republican Party https://data.wprdc.org/mn_MN/datastore/odata3.0//88611068-27e2-4064-84ff-cc6ed7410957(5) 2017-11-07T02:59:05.606677Z ckan 5 total_votes Number of ballots cast for the candidate (or option) in that contest 445 55 https://data.wprdc.org/mn_MN/datastore/odata3.0//88611068-27e2-4064-84ff-cc6ed7410957(6) 2017-11-07T02:59:05.606677Z ckan 6 percent_of_votes The percent of all votes cast in that contest that the candidate got 89.0 11.0 Add up all the votes cast for the various options in a given contest to get the total votes cast in that contest. Divide the total_votes value for a particular candidate by the total votes cast for all candidates to get the percent_of_votes value for that candidate.