Delaware 2024 General Election Results Disaggregated to the 2020 Block ## RDH Date Retrieval 04/14/2026 ## Sources Precinct shapefile with election results retrieved from the (Redistricting Data Hub)[https://redistrictingdatahub.org/dataset/delaware-2024-general-election-precinct-level-results-and-boundaries/] Block shapefiles and data are retrieved from the (Redistricting Data Hub)[https://redistrictingdatahub.org/dataset/delaware-block-pl-94171-2020-by-table/] and originally from the Census Bureau's Public Law 94-171 dataset and TIGER shapefiles. ## Notes on Field Names: Columns reporting votes generally follow the pattern: One example is: GPREDCLI 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 Used: GOV - Governor INS - Insurance Commissioner LTG - Lieutenant Governor PRE - President of the United States USS - United States Senate CON## - United States Congress Congress SL## - Representative in General Assembly (State Legislative Lower) SU## - Senator in General Assembly (State Legislative Upper) Party Codes Used: C - Conservative D - Democrat I - Independent Party of Delaware L - Libertarian Party R - Republican ## Fields: Field Name Description GEOID20 Unique Block Identifier STATEFP State FIPS Code COUNTYFP County FIPS Code PRECINCTID Precinct Identifier VAP_MOD Modified Voting Age Population G24GOVDMEY MATT MEYER-:-Democratic Party-:-Governor G24GOVRRAM MIKE RAMONE-:-Republican Party-:-Governor G24INSDNAV TRINIDAD NAVARRO-:-Democratic Party-:-Insurance Commissioner G24INSRTAY RALPH TAYLOR-:-Republican Party-:-Insurance Commissioner G24LTGDGAY KYLE EVANS GAY-:-Democratic Party-:-Lieutenant Governor G24LTGRKIN RUTH BRIGGS KING-:-Republican Party-:-Lieutenant Governor G24PRECSUP VERMIN SUPREME AND JONATHAN REALZ-:-Conservative Party-:-President and Vice President G24PREDHAR KAMALA D. HARRIS AND TIM WALZ-:-Democratic Party-:-President and Vice President G24PREIKEN ROBERT F. KENNEDY JR. AND NICOLE SHANAHAN-:-Independent Party of Delaware-:-President and Vice President G24PRELOLI CHASE OLIVER AND MIKE TER MAAT-:-Libertarian Party-:-President and Vice President G24PRERTRU DONALD J. TRUMP AND JD VANCE-:-Republican Party-:-President and Vice President G24USSDROC LISA BLUNT ROCHESTER-:-Democratic Party-:-U.S. Senator G24USSIKAT MICHAEL "DR. MIKE" KATZ-:-Independent Party of Delaware-:-U.S. Senator G24USSRHAN ERIC HANSEN-:-Republican Party-:-U.S. Senator GCONALDMCB SARAH MCBRIDE-:-Democratic Party-:-U.S. Representative In Congress GCONALRWHA JOHN J. WHALEN III-:-Republican Party-:-U.S. Representative In Congress GSL01DCHU NNAMDI O. CHUKWUOCHA-:-Democratic Party-:-State Representative District 1 GSL02DBOL STEPHANIE T. BOLDEN-:-Democratic Party-:-State Representative District 2 GSL03DORT JOSUE O. ORTEGA-:-Democratic Party-:-State Representative District 3 GSL04DLIN GREGG LINDNER-:-Democratic Party-:-State Representative District 4 GSL04RHIL JEFF HILOVSKY-:-Republican Party-:-State Representative District 4 GSL05DJOH KENDRA JOHNSON-:-Democratic Party-:-State Representative District 5 GSL06DHEF DEBRA J. HEFFERNAN-:-Democratic Party-:-State Representative District 6 GSL06RKRA MICHAEL KRAWCZUK-:-Republican Party-:-State Representative District 6 GSL07DLAM LARRY D. LAMBERT JR.-:-Democratic Party-:-State Representative District 7 GSL07RSTO SHANE STONEMAN-:-Republican Party-:-State Representative District 7 GSL08DMOO SHERAE'A "RAE" MOORE-:-Democratic Party-:-State Representative District 8 GSL08RBER CHRIS BERONIO-:-Republican Party-:-State Representative District 8 GSL09DWIL TERRELL A. WILLIAMS-:-Democratic Party-:-State Representative District 9 GSL09RHEN KEVIN S. HENSLEY-:-Republican Party-:-State Representative District 9 GSL10DLEV MELANIE ROSS LEVIN-:-Democratic Party-:-State Representative District 10 GSL10RBUR BRENT BURDGE-:-Republican Party-:-State Representative District 10 GSL11RSPI JEFFREY N. SPIEGELMAN-:-Republican Party-:-State Representative District 11 GSL12DGRI KRISTA GRIFFITH-:-Democratic Party-:-State Representative District 12 GSL12RPIC STEVE PICKERING-:-Republican Party-:-State Representative District 12 GSL13DNEA DESHANNA NEAL-:-Democratic Party-:-State Representative District 13 GSL13RRAP DANNY RAPPA-:-Republican Party-:-State Representative District 13 GSL14DSNY CLAIRE SNYDER-HALL-:-Democratic Party-:-State Representative District 14 GSL14RSIM MIKE SIMPLER-:-Republican Party-:-State Representative District 14 GSL15DSMI KAMELA T. SMITH-:-Democratic Party-:-State Representative District 15 GSL16DCOO FRANKLIN D. COOKE JR.-:-Democratic Party-:-State Representative District 16 GSL17DMIN MELISSA "MIMI" MINOR-BROWN-:-Democratic Party-:-State Representative District 17 GSL18DPHI SOPHIE PHILLIPS-:-Democratic Party-:-State Representative District 18 GSL19DWIL KIM WILLIAMS-:-Democratic Party-:-State Representative District 19 GSL19RHOM ALEX HOMICH-:-Republican Party-:-State Representative District 19 GSL20DSEL STELL PARKER SELBY-:-Democratic Party-:-State Representative District 20 GSL20RMIL NIKKI MILLER-:-Republican Party-:-State Representative District 20 GSL21DBUR FRANK BURNS-:-Democratic Party-:-State Representative District 21 GSL21RMEN BRENDA MENNELLA-:-Republican Party-:-State Representative District 21 GSL22DBEA MONICA BEARD-:-Democratic Party-:-State Representative District 22 GSL22RSMI MICHAEL FRANCIS SMITH-:-Republican Party-:-State Representative District 22 GSL23DGOR MARA GORMAN-:-Democratic Party-:-State Representative District 23 GSL24DOSI ED OSIENSKI-:-Democratic Party-:-State Representative District 24 GSL24RGOD JOAN GODWIN-:-Republican Party-:-State Representative District 24 GSL25DROM CYNDIE ROMER-:-Democratic Party-:-State Representative District 25 GSL25RHAN DAVID HANSBERGER-:-Republican Party-:-State Representative District 25 GSL26DWIL MADINAH WILSON-ANTON-:-Democratic Party-:-State Representative District 26 GSL27DMOR ERIC MORRISON-:-Democratic Party-:-State Representative District 27 GSL27RGRI KRISTINA GRIFFING-:-Republican Party-:-State Representative District 27 GSL28DCAR WILLIAM CARSON-:-Democratic Party-:-State Representative District 28 GSL29DBUS WILLIAM BUSH-:-Democratic Party-:-State Representative District 29 GSL29REGI ANTHONY EGIPCIACO JR.-:-Republican Party-:-State Representative District 29 GSL30RMOR WM SHANNON MORRIS-:-Republican Party-:-State Representative District 30 GSL31DLYN SEAN M. LYNN-:-Democratic Party-:-State Representative District 31 GSL32DHAR KERRI EVELYN HARRIS-:-Democratic Party-:-State Representative District 32 GSL32RSPA AMY SPAMPINATO-:-Republican Party-:-State Representative District 32 GSL33RPOS CHARLES S. POSTLES JR.-:-Republican Party-:-State Representative District 33 GSL34DMIL TRACEY M. MILLER-:-Democratic Party-:-State Representative District 34 GSL34RYEA LYNDON D. YEARICK-:-Republican Party-:-State Representative District 34 GSL35RVAN JESSE R. VANDERWENDE-:-Republican Party-:-State Representative District 35 GSL36DBAL RONY J. BALTAZAR-LOPEZ-:-Democratic Party-:-State Representative District 36 GSL36RSHU BRYAN WILLIAM SHUPE-:-Republican Party-:-State Representative District 36 GSL37RGIL VALERIE JONES GILTNER-:-Republican Party-:-State Representative District 37 GSL38RGRA RONALD E. GRAY-:-Republican Party-:-State Representative District 38 GSL39RSHO DANIEL B. SHORT-:-Republican Party-:-State Representative District 39 GSL40RDUK TIMOTHY D. DUKES-:-Republican Party-:-State Representative District 40 GSL41DBRE TOM BRETT-:-Democratic Party-:-State Representative District 41 GSL41RCOL RICH COLLINS-:-Republican Party-:-State Representative District 41 GSU02CROE JON ROE-:-Conservative Party-:-State Senator District 2 GSU02DBRO DARIUS BROWN-:-Democratic Party-:-State Senator District 2 GSU03DLOC S. ELIZABETH LOCKMAN-:-Democratic Party-:-State Senator District 3 GSU04DSTU LAURA V. STURGEON-:-Democratic Party-:-State Senator District 4 GSU06DHUX RUSS HUXTABLE-:-Democratic Party-:-State Senator District 6 GSU06RSTE KIM HOEY STEVENSON-:-Republican Party-:-State Senator District 6 GSU10DHAN STEPHANIE L. HANSEN-:-Democratic Party-:-State Senator District 10 GSU11DTOW BRYAN TOWNSEND-:-Democratic Party-:-State Senator District 11 GSU16RBUC ERIC L. BUCKSON-:-Republican Party-:-State Senator District 16 GSU17DPAR TREY PARADEE-:-Democratic Party-:-State Senator District 17 GSU18RWIL DAVE WILSON-:-Republican Party-:-State Senator District 18 GSU21RRIC BRYANT L. RICHARDSON-:-Republican Party-:-State Senator District 21 ## Processing Steps Precinct and block shapefiles were retrieved from the sources listed above. The primary libraries used in processing are geopandas, pandas, and maup (https://github.com/mggg/maup) in Python. The block data was prepared by creating the VAP_MOD field which is the total Voting Age Population (P0040001) minus Correctional Facility/Prison Population (P0050003) which will be used as the denominator in disaggregation. The block file was queried out to include just the GEOID20, VAP_MOD, and geometry fields. To assign blocks to precincts, the maup.assign function was used. Some blocks did not receive an assignment but nearly all of these had a VAP_MOD value of 0, meaning those blocks should not receive any votes during allocation anyway. In the rare instance where there was a block with a VAP_MOD > 0 and no precinct assignment, the nearest precinct within the same county was identified using minimum polygon boundary distance and used as the block's assignment. After the blocks have received an assignment, they are grouped by their new assignment and summed to give a total VAP_MOD value for the precinct. A ratio is then calculated of VAP_MOD block / VAP_MOD precinct, which is applied to all candidate columns (those starting with "G24"). In some instances, there are precincts that sum to 0 for VAP_MOD but do contain votes. In order to not lose votes in the disaggregation process, these blocks are modified to VAP_MOD=1, then summed again to get a non-zero value denominator for VAP_MOD at the precinct. Therefore all blocks in the precinct would have the same ratio applied and receive the same distribution of votes. All blocks that have a modified VAP_MOD value were returned to their original value of 0 before extraction to maintain accuracy. A key assumption of maup is that a block receives one precinct as an assignment. The RDH checks for any precincts with votes which have not been assigned to any blocks. In these instances, the block file is clipped to each precinct geometry, and the block which has the largest area inside the precinct receives all of the votes from that precinct. The data are disaggregated from each of their respective split shapefiles (e.g. US House, State House, State Senate) from the source above, to preserve accuracy (rather than the _all_ file). They are joined back together and then a Hamilton rounding method is performed to ensure that all voters are whole numbers and sum exactly to the same totals. ## Additional Notes Please direct questions related to processing this dataset to info@redistrictingdatahub.org