2018 Michigan precinct and election shapefile. ## RDH Date retrieval 04/28/2021 ## Sources Election results from Michigan Secretary of State (https://miboecfr.nictusa.com/cgi-bin/cfr/precinct_srch.cgi) Election shapefile from Michigan GIS Open Data site (https://gis-michigan.opendata.arcgis.com/datasets/2018-voting-precincts) ## Fields metadata Vote Column Label Format ------------------------ Columns reporting votes follow a standard label pattern. One example is: G16PREDCli The first character is G for a general election, P for a primary, S for a special, and R for a runoff. Characters 2 and 3 are the year of the election. Characters 4-6 represent the office type (see list below). Character 7 represents the party of the candidate. Characters 8-10 are the first three letters of the candidate's last name. Office Codes A## - Ballot amendment, where ## is an identifier AGR - Commissioner of Agriculture ATG - Attorney General AUD - Auditor CFO - Chief Financial Officer CHA - Council Chairman COC - Corporation Commissioner COM - Comptroller CON - State Controller COU - City Council Member CSC - Clerk of the Supreme Court DEL - Delegate to the U.S. House GOV - Governor H## - U.S. House, where ## is the district number. AL: at large. HOD - House of Delegates, accompanied by a HOD_DIST column indicating district number HOR - U.S. House, accompanied by a HOR_DIST column indicating district number INS - Insurance Commissioner LAB - Labor Commissioner LND - Commissioner of Public/State Lands LTG - Lieutenant Governor MAY - Mayor MNI - State Mine Inspector PSC - Public Service Commissioner PUC - Public Utilities Commissioner RGT - State University Regent SAC - State Appeals Court SBE - State Board of Education SOC - Secretary of Commonwealth SOS - Secretary of State SPI - Superintendent of Public Instruction SPL - Commissioner of School and Public Lands SSC - State Supreme Court TAX - Tax Commissioner TRE - Treasurer UBR - University Board of Regents/Trustees/Governors USS - U.S. Senate Party Codes D and R will always represent Democrat and Republican, respectively. See the state-specific notes for the remaining codes used in a particular file; note that third-party candidates may appear on the ballot under different party labels in different states. ## Fields G18GOVRSCH - Bill Schueete (Republican Party) G18GOVDWHI - Gretchen Whitmer (Democratic Party) G18GOVLGEL - Bill Delineau (Libertarian Party) G18GOVTSCH - Todd Schleiger (US Taxpayers Party) G18GOVGKUR - Jennifer V. Kurland (Green Party) G18GOVNBUT - Keith Butkovich (Natural Law Party) G18SOSRLAN - Mary Treder Lang (Republican Party) G18SOSDBEN - Jocelyn Benson (Democratic Party) G18SOSLSTE - Gregory Scott Stempfle (Libertarian Party) G18SOSTGAL - Robert Gale (US Taxpayers Party) G18ATGRLEO - Tom Leonard (Republican Party) G18ATGDNES - Dana Nessel (Democratic Party) G18ATGLGIO - Lisa Lane Gioia (Libertarian Party) G18ATGTVAN - Gerald T. Van Sickle (US Taxpayers Party) G18ATGIGAR - Chris Graveline (Independent) G18USSRJAM - John James (Republican Party) G18USSDSTA - Debbie Stabenow (Democratic Party) G18USSTHUF - George E. Huffman III (US Taxpayers Party) G18USSGSQU - Marcia Squier (Green Party) G18USSNWIL - John Howard Wilhelm (Natural Law Party) G18SBERCAR - Tami Carlone (Republican Party) G18SBERZEI - Richard Zeile (Republican Party) G18SBEDPRI - Judith P. Pritchett (Democratic Party) G18SBEDTIL - Tiffany Tilley (Democratic Party) G18SBELBOM - Scotty Boman (Libertarian Party) G18SBELTAT - John J. Tatar (Libertarian Party) G18SBETADA - Karen Adams (US Taxpayers Party) G18SBETLEV - Douglas Levesque (US Taxpayers Party) G18SBEGWEL - Sherry A. Wells (Green Party) G18SBEWHER - Mary Anne Hering (Working Class Party) G18SBEWSMI - Logan R. Smith (Working Class Party) *University of Michigan* G18UBRRNEW - Andrea Fischer Newman (Republican Party) G18UBRRRIC - Andrew Richner (Republican Party) G18UBRDACK - Jordan Acker (Democratic Party) G18UBRDBRO - Paul Brown (Democratic Party) G18UBRLHUD - James Lewis Hudler (Libertarian Party) G18UBRLJAS - John Jascob (Libertarian Party) G18UBRTSAN - Joe Sanger (US Taxpayers Party) G18UBRTVAN - Crystal Van Sickle (US Taxpayers Party) G18UBRGGRA - Kevin A. Graves (Green Party) G18UBRNSAL - Marge Katchmark Sallows (Natural Law Party) *Michigan State University* G18UBRRDUT - Dave Dutch (Republican Party) G18UBRRMIL - Mike Miller (Republican Party) G18UBRDSCO - Brianna T. Scott (Democratic Party) G18UBRDTEB - Kelly Charron Tebay (Democratic Party) G18UBRLCAM - Bruce Campbell (Libertarian Party) G18UBRLORZ - Tim Orzechowski (Libertarian Party) G18UBRTSA1 - Janet M. Sanger (US Taxpayers Party) G18UBRTSA2 - John Paul Sanger (US Taxpayers Party) G18UBRGMAR - Aaron Mariasy (Green Party) G18UBRNABR - Bridgette R. Abraham-Guzman (Natural Law Party) *Wayne State University* G18UBRRDUN - Diane Dunaskiss (Republican Party) G18UBRRNIC - David Nicholson (Republican Party) G18UBRDBAR - Bryan C. Barnhill (Democratic Party) G18UBRDKUM - Anil Kumar (Democratic Party) G18UBRLELG - Jon Elgas (Libertarian Party) G18UBRLHAR - John T. Hargenrader (Libertarian Party) G18UBRTSCH - Christine C. Schwartz (US Taxpayers Party) G18UBRTSOS - Marc Joseph Sosnowski (US Taxpayers Party) ## Processing Steps Detroit 125 does not appear in the state's shapefile. Looking at a PDF on the city's website, it looks like it is some part of 494, but the boundary is not clear, so these results were merged together. A few counties use Absent Voter Counting Boards to report some or all absentee results. In some cases, these align with a single precinct, but in others, they correspond to multiple precincts. Notable in this is that all of Detroit uses AVCBs, of which each is made up of multiple precincts. These were distributed by candidate to precincts based on election day totals. Thank you to Derek Willis of OpenElections for the file linking Detroit precincts to AVCBs. Some counties report "Statistical Adjustments" with their precinct results which make the sum of the precinct totals match the official results. These can be positive or negative. In many cases these adjustments are small, but two cases are notable: Muskegon County has a +4630 adjustment for gubernatorial candidate Tood Schleiger and Barry County has a -722 adjustment for SBE candidate Tami Carlone. None of these adjustments, small or large, were distributed to precincts, which may result in candidate totals being slightly off official totals. Write-in vote totals have been excluded, since in most cases, a large share of their votes are accounted for via statistical adjustments. (For example, 1647 of MSU Trustee candidate David Mott's 1673 votes are found in these countywide figures.) Oakland County's Fenton precinct 2 results merged into Genesee County's Fenton precinct 2. St. Clair County's Richmond precinct 1 results merged into Macomb County's Richmond precinct 1.