2020 MI General Precinct Boundary and Election Results ## RDH Date Retrieval 03/16/2022 ## Sources The RDH retrieved the VEST 2020 general precinct boundary and election results shapefile from [VEST's Harvard Dataverse](https://dataverse.harvard.edu/file.xhtml?fileId=5739924&version=34.0) The RDH retrieved raw 2020 general election results from Election results from the Michigan Secretary of State (https://miboecfr.nictusa.com/cgi-bin/cfr/precinct_srch.cgi) and precinct shapefiles from VEST's Michigan 2020 file. ## Notes on Field Names (adapted from VEST): Columns reporting votes generally follow the pattern: 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. One example is: G16PREDCLI To fit within the GIS 10 character limit for field names, the naming convention is slightly different for the State Legislature and US House of Representatives. All fields are listed below with definitions. Office Codes Used: SLXXX - State Legislative Lower District, accompanied by a SLDL_DIST column indicating district number SLPXX - State Legislative Lower - Partial Term CON## - U.S. House, accompanied by a CON_DIST column indicating district number PRE - President USS - U.S. Senator SBE - Member of the State Board of Education RUM - Regent of the University of Michigan TMS - Trustee of Michigan State University GWS - Governor of Wayne State University SCJ - Justice of Supreme Court AM2 - State Proposal - 20-2: Constitutional Amendment: Electronic Data and Communication Search Warrant AM1 - State Proposal - 20-1 ## Fields: Field Name Description UNIQUE_ID Unique Identifier COUNTYFP County FIP PRECINCTID Precinct identifier COUNTYFIPS County FIP cousubname County Subdivision Name elexpre Identifier Column ***mi_st_20_prec.zip*** G20AM1NO NO G20AM1YES YES G20AM2NO NO G20AM2YES YES G20GWSDDEW EVA GARZA DEWAELSCHE G20GWSDSTA SHIRLEY STANCATO G20GWSGODG SUSAN ODGERS G20GWSLELG JON ELGAS G20GWSRGAT DON GATES G20GWSRLAN TERRI LYNN LAND G20GWSTSCH CHRISTINE C. SCHWARTZ G20GWSUCON LLOYD ARTHUR CONWAY G20PREDBID JOSEPH R. BIDEN G20PREGHAW HOWIE HAWKINS G20PRELJOR JO JORGENSEN G20PRENDEL ROCKY DE LA FUENTE G20PRERTRU DONALD J. TRUMP G20PRETBLA DON BLANKENSHIP G20PREUCAR BRIAN T. CARROLL G20PREUHOE TOM HOEFLING G20PREUHUN TARA RENEE HUNTER G20PREUSIM JADE SIMMONS G20PREUWEL KASEY WELLS G20RUMDBER MARK BERNSTEIN G20RUMDDIG SHAUNA RYDER DIGGS G20RUMGMAW MICHAEL MAWILAI G20RUMLHUD JAMES L. HUDLER G20RUMLLAR ERIC LARSON G20RUMNBUT KEITH BUTKOVICH G20RUMRHUB SARAH HUBBARD G20RUMRMEY CARL MEYERS G20RUMTGRA RONALD E. GRAESER G20RUMTSIC CRYSTAL VAN SICKLE G20SBEDLIP ELLEN COGEN LIPTON G20SBEDSTR JASON STRAYHORN G20SBEGMAI TOM MAIR G20SBELHAL BILL HALL G20SBELHEW RICHARD A. HEWER G20SBERCAR TAMI CARLONE G20SBERFRE MICHELLE A. FREDERICK G20SBETADA KAREN ADAMS G20SBETLEV DOUGLAS LEVESQUE G20SBEWHER MARY ANNE HERING G20SBEWMCE HALI MCEACHERN G20SCJUHUB SUSAN L. HUBBARD G20SCJUKEL MARY KELLY G20SCJUMCC BRIDGET MARY MCCORMACK G20SCJUMOR KERRY LEE MORGAN G20SCJUNEP KATHERINE MARY NEPTON G20SCJUSWA BROCK SWARTZLE G20SCJUWEL ELIZABETH M. WELCH G20TMSDMOS BRIAN MOSALLAM G20TMSDVAS REMA ELLA VASSAR G20TMSGHU BRANDON HU G20TMSGLAU ROBIN LEA LAURAIN G20TMSLWHI WILL TYLER WHITE G20TMSNABR BRIDGETTE ABRAHAM-GUZMAN G20TMSROKE PAT O'KEEFE G20TMSRSCH TONYA SCHUITMAKER G20TMSTJMS JANET M. SANGER G20TMSTJPS JOHN PAUL SANGER G20USSDPET GARY PETERS G20USSGSQU MARCIA SQUIER G20USSNDER DOUG DERN G20USSRJAM JOHN JAMES G20USSTWIL VALERIE L. WILLIS G20USSUCAR ROBERT WILLIAM CARR G20USSUGAD LEONARD PAUL GADZINSKI ***mi_sldl_20_prec.zip*** SLDL_DIST State Legislative District GSL001DYAN TENISHA R. YANCEY GSL001LCRE GREGORY CRESWELL GSL001RLAN LATRICIA ANN LANIER GSL002DTAT JOE TATE GSL002RROD MAYRA RODRIGUEZ GSL002USIM DANETTA L. SIMPSON GSL003DTHA SHRI THANEDAR GSL003GBOY STEPHEN BOYLE GSL003RVIN ANITA VINSON GSL004DAIY ABRAHAM AIYASH GSL004RWEA HOWARD WEATHINGTON GSL004UALA MD RABBI ALAM GSL004WRAY LINDA RAYBURN GSL005DJOH CYNTHIA A. JOHNSON GSL005RDAY HAROLD M. DAY GSL006DCAR TYRONE CARTER GSL007DSCO HELENA SCOTT GSL007GBEL ANITA BELLE GSL007RCOL RONALD COLE GSL007WGIV KIMBERLY GIVENS GSL008DYOU STEPHANIE A. YOUNG GSL008RGOR MIROSLAWA TERESA GORAK GSL009DWHI KAREN WHITSETT GSL009RSTE JAMES STEPHENS GSL010DCAV MARY CAVANAGH GSL010RALC CATHY L. ALCORN GSL011DJON JEWELL JONES GSL011RTOW JAMES C. TOWNSEND GSL012DGAR ALEX GARZA GSL012RBAI MICHELLE BAILEY GSL013DLIB TULLIO LIBERATI GSL013RFRU MEGAN FRUMP GSL014DCLE CARA A. CLEMENTE GSL014RSTA DARRELL STASIK GSL014WCOL SIMONE R. COLEMAN GSL015DHAM ABDULLAH HAMMOUD GSL015RONE CARLA O'NEILL GSL015WBET LARRY DARNELL BETTS GSL016DCOL KEVIN COLEMAN GSL016RBAU EMILY BAUMAN GSL017DSLA CHRISTOPHER SLAT GSL017RJR. JOE BELLINO, JR. GSL018DHER KEVIN HERTEL GSL018RBAB MICHAEL BABAT GSL018UTIM CHRISTINE TIMMON GSL019DPOH LAURIE POHUTSKY GSL019RPTA MARTHA PTASHNIK GSL020DKOL MATT KOLESZAR GSL020RLAC JOHN LACNY GSL021DPUR RANJEEV PURI GSL021RHES LAUREL HESS GSL022DSTE RICHARD M. STEENLAND GSL022RWAR STEVEN G. WARNER GSL023DCAM DARRIN CAMILLERI GSL023RPOE JOHN POE GSL024DWOO MICHELLE WOODMAN GSL024RMAR STEVE MARINO GSL025DSHA NATE SHANNON GSL025RSMI PAUL M. SMITH GSL026DELL JIM ELLISON GSL026RMEI CHRIS MEISTER GSL027DWEI REGINA WEISS GSL027GWEL SHERRY A. WELLS GSL027LSTE GREGORY SCOTT STEMPFLE GSL027RGOS ELIZABETH GOSS GSL028DSTO LORI M. STONE GSL028LHOR FREDERICK HORNDT GSL028RCOL STEPHEN COLEGIO GSL029DCAR BRENDA CARTER GSL029RSUL S. DAVE SULLIVAN GSL030DCHE MICHAEL A. CHEHAB GSL030RFAR DIANA FARRINGTON GSL031DSOW WILLIAM J. SOWERBY GSL031RVAL LISA VALERIO-NOWC GSL032DBOU JUSTIN BOUCHER GSL032RHOR PAMELA HORNBERGER GSL033DJAB OLU JABARI GSL033RYAR JEFF YAROCH GSL034DNEE CYNTHIA R. NEELEY GSL034RMIR JAMES MIRAGLIA GSL035DBOL KYRA HARRIS BOLDEN GSL035LYOW TIM YOW GSL035RDAV DANIELA DAVIS GSL036DMUR ROBERT MURPHY GSL036RWOZ DOUGLAS C. WOZNIAK GSL037DSTE SAMANTHA STECKLOFF GSL037LYOU JAMES K. YOUNG GSL037RSWO MITCH SWOBODA GSL038DBRE KELLY A. BREEN GSL038RTUR CHASE TURNER GSL039DPUL JULIA PULVER GSL039LCRO ANTHONY CROFF GSL039RBER RYAN BERMAN GSL040DMAN MARI MANOOGIAN GSL040RCLE KENDRA CLEARY GSL041DKUP PADMA KUPPA GSL041RSOS ANDREW J. SOSNOSKI GSL042DBET DONNIE BETTES GSL042RBOL ANN BOLLIN GSL043DBRE NICOLE BREADON GSL043RSCH ANDREA K. SCHROEDER GSL044DFOR DENISE FORREST GSL044RMAD MATT MADDOCK GSL045DANN BARB ANNESS GSL045RTIS MARK TISDEL GSL046DLAM JODY LAMACCHIA GSL046RREI JOHN REILLY GSL047DSMI ADAM SMIDDY GSL047RBEZ ROBERT J. BEZOTTE GSL048DKEN SHERYL Y. KENNEDY GSL048RMAR DAVID W. MARTIN GSL049DCHE JOHN D. CHERRY GSL049RLUT BRYAN LUTZ GSL050DSNE TIM SNELLER GSL050RFIT CHRISTINA FITCHETT-HICKSON GSL051DMAY BRAD MAY GSL051RMUE MIKE MUELLER GSL052DLAS DONNA LASINSKI GSL052RMAR GREG MARQUIS GSL053DRAB YOUSEF RABHI GSL053RHOL JEAN E. HOLLAND GSL054DPET RONNIE DEAN PETERSON GSL054RCHU MARTIN A. CHURCH GSL055DBRA FELICIA BRABEC GSL055RBAI BOB BAIRD GSL056DKIT KEITH W. KITCHENS GSL056GII JEFFREY JON RUBLEY II GSL056RCLE TC CLEMENTS GSL057DGAR WILL GARCIA GSL057RKAH BRONNA KAHLE GSL058DBAR TAMARA C. BARNES GSL058RFIN ANDREW FINK GSL059DEAS AMY L. EAST GSL059RCAR STEVE CARRA GSL059UCOL JACK DANIEL COLEMAN GSL060DROG JULIE M. ROGERS GSL060RMIT GARY MITCHELL GSL060UMOO STEPHANIE L. MOORE GSL061DMOR CHRISTINE MORSE GSL061RHAL BRONWYN HALTOM GSL062DHAA JIM HAADSMA GSL062RMOR DAVE MORGAN GSL063DHOW LUKE HOWELL GSL063GPIE JOHN ANTHONY LA PIETRA GSL063LWOL RAFAEL WOLF GSL063RHAL MATT HALL GSL063UHAW RONALD LEE HAWKINS GSL064DHOF SANDRA HOFMAN-KINGSTON GSL064LPET NORMAN PETERSON GSL064RALE JULIE ALEXANDER GSL065DSMI NANCY SMITH GSL065RLIG SARAH L. LIGHTNER GSL066DWHE ABIGAIL WHEELER GSL066RGRI BETH GRIFFIN GSL067DHOP KARA HOPE GSL067RROS NATE J. ROSS GSL068DANT SARAH ANTHONY GSL068RATK ROBERT J. ATKINSON GSL069DBRI JULIE BRIXIE GSL069GGUT GENE GUTIERREZ GSL069RNOR GRACE S. NORRIS GSL070DGAR KAREN GARVEY GSL070ROUT PAT OUTMAN GSL071DWIT ANGELA WITWER GSL071GMCC DALTON R. MCCUISTON GSL071RJOH GINA JOHNSEN GSL072DCHE LILY CHENG-SCHULTING GSL072RJOH STEVEN JOHNSON GSL073DSAX BILL SAXTON GSL073RPOS BRYAN POSTHUMUS GSL073TGER THEODORE GERRARD GSL073UHEE RONALD LEE HEEREN GSL074DHIN MEAGAN L. HINTZ GSL074RHUI MARK E. HUIZENGA GSL075DLAG DAVID LAGRAND GSL075GBUL MARCO T. BULNES GSL075RMCK JAMES MCKEIVER GSL075WPAL LOUIS PALUS GSL076DHOO RACHEL HOOD GSL076RZAN DOUG ZANDSTRA GSL077DSMI BOB SMITH GSL077RBRA TOMMY BRANN GSL078DVAN DAN VANDENHEEDE GSL078NWAR ANDREW J. WARNER GSL078RPAQ BRAD PAQUETTE GSL079DPIT CHOKWE PITCHFORD GSL079RWEN PAULINE WENDZEL GSL080DALM ERIK ALMQUIST GSL080RWHI MARY WHITEFORD GSL081DBOU DEBBIE BOURGOIS GSL081REIS GARY R. EISEN GSL082DTKA JERRY TKACH GSL082RHOW GARY HOWELL GSL082UHAU KURT ALLAN HAUSAUER GSL083DARM STEPHANIE ARMSTRONG-HELTON GSL083RBEE ANDREW BEELER GSL084DWOO PATRICK J. WOOD GSL084RGRE PHIL GREEN GSL085DGAR ANDREA KELLY GARRISON GSL085RFRE BEN FREDERICK GSL086DHAY SUE HAYES GSL086RALB THOMAS A. ALBERT GSL087DMOL JAY MOLETTE GSL087RCAL JULIE A. CALLEY GSL088DCOR FRANKLIN CORNIELLE GSL088RMEE LUKE MEERMAN GSL089DBRO ANITA MARIE BROWN GSL089RLIL JIM LILLY GSL090DBAN CHRISTOPHER P. BANKS GSL090RSLA BRADLEY SLAGH GSL091DHOS BRIAN HOSTICKA GSL091RVAN GREG VANWOERKOM GSL092DSAB TERRY J. SABO GSL092RHAU MICHAEL L. HAUEISEN GSL093DRAI MUHAMMAD SALMAN RAIS GSL093RFIL GRAHAM FILLER GSL094DTIB DEMOND L. TIBBS GSL094RWAK RODNEY WAKEMAN GSL095DONE AMOS O'NEAL GSL095RDEM CHARLOTTE DEMAET GSL096DELD BRIAN K. ELDER GSL096RBES TIMOTHY BESON GSL097DYOU CELIA YOUNG-WENKEL GSL097RWEN JASON WENTWORTH GSL098DSCH SARAH SCHULZ GSL098RGLE ANNETTE GLENN GSL099DZAN JOHN ZANG GSL099GLAM MELISSA NOELLE LAMBERT GSL099RHAU ROGER HAUCK GSL100DCLA SANDY CLARKE GSL100RVAN SCOTT A. VANSINGEL GSL101DMCG BETH MCGILL-RIZER GSL101ROMA JACK O'MALLEY GSL102DSIG AMANDA SIGGINS GSL102RHOI MICHELE HOITENGA GSL103DLAR ZACH LARSON GSL103RREN DAIRE RENDON GSL104DONE DAN O'NEIL GSL104LCRU JASON CRUM GSL104RROT JOHN R. ROTH GSL105DBUR JONATHAN BURKE GSL105RBOR KEN BORTON GSL106DJOH LEEANN JOHNSON GSL106RALL SUE ALLOR GSL107DPAG JIM PAGE GSL107RDAM JOHN N. DAMOOSE GSL108DRIC RENEE RICHER GSL108RLAF BEAU MATTHEW LAFAVE GSL109DCAM SARA CAMBENSY GSL109RWAG MELODY WAGNER GSL109THAF JIM HAFEMAN GSL109ULAF DEBORAH SUE LAFAIVE GSL110DMET JANET METSA GSL110GSAU RICK SAUERMILCH GSL110RMAR GREGORY MARKKANEN GSLP04DAIY ABRAHAM AIYASH ***mi_cong_20_prec.zip*** CONG_DIST Congressional District GCON01DFER DANA FERGUSON GCON01LBOR BEN BOREN GCON01RBER JACK BERGMAN GCON02DBER BRYAN BERGHOEF GCON02GCRE JEAN-MICHEL CREVIERE GCON02LRIE MAX RIEKSE GCON02RHUI BILL HUIZENGA GCON02TSIC GERALD T. VAN SICKLE GCON03DSCH HILLARY SCHOLTEN GCON03RMEI PETER MEIJER GCON03UFUE RICHARD DAVID FUENTES GCON03UHOG SHANNON RUTH HOGAN GCON04DHIL JERRY HILLIARD GCON04GSLE AMY SLEPR GCON04LCAN DAVID CANNY GCON04RMOO JOHN MOOLENAAR GCON05DKIL DANIEL T. KILDEE GCON05LHAR JAMES HARRIS GCON05RKEL TIM KELLY GCON05WGOO KATHY GOODWIN GCON06DHOA JON HOADLEY GCON06GLAW JOHN LAWRENCE GCON06LDEP JEFF DEPOY GCON06RUPT FRED UPTON GCON06USOL JERRY SOLIS GCON07DDRI GRETCHEN D. DRISKELL GCON07RWAL TIM WALBERG GCON08DSLO ELISSA SLOTKIN GCON08LHAR JOE HARTMAN GCON08RJUN PAUL JUNGE GCON09DLEV ANDY LEVIN GCON09LSAL MIKE SALIBA GCON09RLAN CHARLES J. LANGWORTHY GCON09UTRO DOUGLAS ALLEN TROSZAK GCON09WKIR ANDREA L. KIRBY GCON10DBIZ KIMBERLY BIZON GCON10RMCC LISA MCCLAIN GCON11DSTE HALEY STEVENS GCON11LSCH LEONARD SCHWARTZ GCON11RESS ERIC S. ESSHAKI GCON11UACO FRANK ACOSTA GCON12DDIN DEBBIE DINGELL GCON12RJON JEFF JONES GCON12WWAL GARY WALKOWICZ GCON13DTLA RASHIDA TLAIB GCON13GWIL D.ETTA WILCOXON GCON13RDUD DAVID DUDENHOEFER GCON13TBOM ARTICIA BOMER GCON13UEAS DONALD EASON GCON13WJOH SAM JOHNSON GCON14DLAW BRENDA LAWRENCE GCON14GSHA CLYDE K. SHABAZZ GCON14LGIO LISA LANE GIOIA GCON14RPAT ROBERT VANCE PATRICK GCON14WKOL PHILIP KOLODY ## Processing Steps The RDH joined additional election results to VEST's existing precinct shapefile, including U.S. President, U.S. Senator, Member of the State Board of Education, Member of the University of Michigan Board of Regents, Member of the Michigan State University Board of Trustees, Member of the Wayne State University Board of Governors, Justice of the Supreme Court, Statewide Ballot Proposals using Python. For more information on the processing completed, visit our [Github repository](https://github.com/nonpartisan-redistricting-datahub/erj-mi) for Election Result Joins (ERJ) for Michigan. Where possible, the RDH validated the election results we processed against VEST's election results. For additional races the RDH manually checked state totals. For more information on this comparison, please see our processing on Github (https://github.com/nonpartisan-redistricting-datahub/erj-mi). ## Additional Notes When precincts contain votes for multiple districts, the precinct is intersected with the entire district shapefile. Votes are assigned to these intersected areas by district. One state legislative race, "GSLP04DAIY" is for a partial term, this race does not follow the same naming convention as the other columns. Totals from these precinct-level results do not always equal the totals of MI's official county-level election results. We are not able to identify the source of this discrepancy. This file does not include the statistical adjustment precincts, even so, in checking the totals with the statistical adjustments, they still do not match. The full list of differences is printed out in the Python notebook. GSL060UMOO has 1980 votes in the county totals file, but no precinct-level votes. Other differences between precinct-level totals and official county totals are less substantial. Please contact info@redistrictingdatahub.org for more information.