2018 Michigan precinct and election shapefile. ## RDH Date retrieval 12/03/2024 ## Sources Election results in part from the Michigan Secretary of State (https://miboecfr.nictusa.com/cgi-bin/cfr/precinct_srch.cgi) and in part from individual county canvass reports. Precinct shapefile from Michigan GIS Open Data (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 LAN - Commissioner of General Land Office 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 RRC - Railroad Commissioner SAC - State Appeals Court (in AL: Civil Appeals) SBE - State Board of Education SCC - State Court of Criminal Appeals 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 G18USSRJAM - John James (Republican Party) G18USSDSTA - Debbie Stabenow (Democratic Party) G18USSUHUF - George Huffman (US Taxpayers Party) G18USSGSQU - Marcia Squier (Green Party) G18USSNWIL - John Wilhelm (Natural Law Party) G18GOVRSCH - Bill Schuette (Republican Party) G18GOVDWHI - Gretchen Whitmer (Democratic Party) G18GOVLGEL - Bill Gelineau (Libertarian Party) G18GOVUSCH - Todd Schleiger (US Taxpayers Party) G18GOVGKUR - Jennifer Kurland (Green Party) G18GOVNBUT - Keith Butkovich (Natural Law Party) G18S0SRLAN - Mary Treder Lang (Republican Party) G18S0SDBEN - Jocelyn Benson (Democratic Party) G18S0SLSTE - Gregory Stempfle (Libertarian Party) G18S0SUGAL - Robert Gale (US Taxpayers Party) G18ATGRLEO - Tom Leonard (Republican Party) G18ATGDNES - Dana Nessel (Democratic Party) G18ATGLGIO - Lisa Gioia (Libertarian Party) G18ATGUVAN - Gerald Van Sickle (US Taxpayers Party) G18ATGIGRA - Chris Graveline (Independent) G18SBERCAR - Tami Carlone (Republican Party) G18SBERZEI - Richard Zeile (Republican Party) G18SBEDPRI - Judith Pritchett (Democratic Party) G18SBEDTIL - Tiffany Tilley (Democratic Party) G18SBELBOM - Scotty Boman (Libertarian Party) G18SBELTAT - John Tatar (Libertarian Party) G18SBEUADA - Karen Adams (US Taxpayers Party) G18SBEULEV - Douglas Levesque (US Taxpayers Party) G18SBEGWEL - Sherry Wells (Green Party) G18SBEWHER - Mary Anne Hering (Working Class Party) G18SBEWSMI - Logan Smith (Working Class Party) *University of Michigan* G18UBRRNEW - Andrea Newman (Republican Party) G18UBRRRIC - Andrew Richner (Republican Party) G18UBRDACK - Jordan Acker (Democratic Party) G18UBRDBRO - Paul Brown (Democratic Party) G18UBRLHUD - James Hudler (Libertarian Party) G18UBRLJAS - John Jascob (Libertarian Party) G18UBRUSAN - Joe Sanger (US Taxpayers Party) G18UBRUVAN - Crystal Van Sickle (US Taxpayers Party) G18UBRGGRA - Kevin Graves (Green Party) G18UBRNSAL - Marge Sallows (Natural Law Party) *Michigan State University* G18UBRRDUT - Dave Dutch (Republican Party) G18UBRRMIL - Mike Miller (Republican Party) G18UBRDSCO - Brianna Scott (Democratic Party) G18UBRDTEB - Kelly Tebay (Democratic Party) G18UBRLCAM - Bruce Campbell (Libertarian Party) G18UBRLORZ - Tim Orzechowski (Libertarian Party) G18UBRUSA1 - Janet Sanger (US Taxpayers Party) G18UBRUSA2 - John Paul Sanger (US Taxpayers Party) G18UBRGMAR - Aaron Mariasy (Green Party) G18UBRNABR - Bridgette Abraham-Guzman (Natural Law Party) *Wayne State University* G18UBRRDUN - Diane Dunaskiss (Republican Party) G18UBRRNIC - David Nicholson (Republican Party) G18UBRDBAR - Bryan Barnhill (Democratic Party) G18UBRDKUM - Anil Kumar (Democratic Party) G18UBRLELG - Jon Elgas (Libertarian Party) G18UBRLHAR - John Hargenrader (Libertarian Party) G18UBRUSCH - Christine Schwartz (US Taxpayers Party) G18UBRUSOS - Marc Sosnowski (US Taxpayers Party) ## Processing Steps Several cities that cross county lines reported results from each county while the shapefile had a single precinct. These cross-county precincts were split at the county line with results assigned accordingly. Brown City - Lapeer/Sanilac Fenton City - Genesee/Oakland Richmond City - Macomb/St. Clair Although Clare City (Clare/Isabella) also crosses county lines the results for statewide elections were reported together by Clare County. Detroit City reports absentee votes via Absentee Vote Counting Boards. The cross-reference chart of AVCBs to precincts was received from OpenElections (https://github.com/openelections/openelections-sources-mi) and the AVCB votes were distributed accordingly by candidate to precincts based on their share of the precinct-level reported vote. Lapeer County similarly reported combined AVCB results for Elba, Lapeer, and Oregon townships. These were distributed by candidate to precincts based on their share of the precinct-level reported vote. Detroit 125 was split from Detroit 494 using the 2020 precinct shapefile.