Hawaii 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/hawaii-2024-general-election-precinct-level-results-and-boundaries/] Block shapefiles and data are retrieved from the (Redistricting Data Hub)[https://redistrictingdatahub.org/dataset/hawaii-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: PRE - President of the United States Q# - Statewide Ballot Measures (https://elections.hawaii.gov/voting/2024-proposed-amendments-to-the-hawaii-state-constitution/) USS - United State Senate CON## - U.S. Congress SL## - State Representative (State Legislative Lower). Note there are A/B seats for Idaho's State representative districts. SU## - State Senator (State Legislative Upper) TRUXX - Trustee Party Codes Used: A - American Solidarity D - Democrat I - Independent L - Libertarian N - Nonpartisan R - Republican S - Socialism and Liberation W - We the People ## 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 G24PREASON President and Vice President, (S) SONSKI, Peter For PRESIDENT ONAK, Lauren For VICE PRESIDENT G24PREDHAR President and Vice President, (D) HARRIS, Kamala D. For PRESIDENT WALZ, Tim For VICE PRESIDENT G24PREGSTE President and Vice President, (G) STEIN, Jill For PRESIDENT WARE, Rudolph For VICE PRESIDENT G24PRELOLI President and Vice President, (L) OLIVER, Chase For PRESIDENT TER MAAT, Mike For VICE PRESIDENT G24PRERTRU President and Vice President, (R) TRUMP, Donald J. For PRESIDENT VANCE, JD For VICE PRESIDENT G24PRESLDE President and Vice President, (SL) DE LA CRUZ, Claudia For PRESIDENT GARCIA, Karina For VICE PRESIDENT G24Q1NO Question #1, NO G24Q1YES Question #1, YES G24Q2NO Question #2, NO G24Q2YES Question #2, YES G24USSDHIR U.S. Senator, (D) HIRONO, Mazie K. G24USSGPOH U.S. Senator, (G) POHLMAN, Emma Jane Avila G24USSOBIL U.S. Senator, (W) BILLIONAIRE, Shelby Pikachu G24USSRMCD U.S. Senator, (R) MCDERMOTT, Bob GCON01DCAS U.S. Representative, Dist I, (D) CASE, Ed GCON01RLAR U.S. Representative, Dist I, (R) LARGEY, Patrick C. GCON02DTOK U.S. Representative, Dist II, (D) TOKUDA, Jill N. GCON02LTOM U.S. Representative, Dist II, (L) TOMAN, Aaron GCON02NMEY U.S. Representative, Dist II, (N) MEYER, Randall Kelly GCON02RBON U.S. Representative, Dist II, (R) BOND, Steve GSL03DTOD State Representative, Dist 3, (D) TODD, Christopher L.T. GSL03LMAR State Representative, Dist 3, (L) MARTIN, Austin D. (Shiloh) GSL03RWIL State Representative, Dist 3, (R) WILSON, Kanoa GSL04DILA State Representative, Dist 4, (D) ILAGAN, Greggor GSL04RHO, State Representative, Dist 4, (R) HO, Keikilani GSL05DKAP State Representative, Dist 5, (D) KAPELA, Jeanne GSL05LFOG State Representative, Dist 5, (L) FOGEL, Frederick F. GSL05ROYA State Representative, Dist 5, (R) OYAMA, Ashley GSL06DKAH State Representative, Dist 6, (D) KAHALOA, Kirstin GSL06RMAD State Representative, Dist 6, (R) MADISON, Sylvie M. GSL07DLOW State Representative, Dist 7, (D) LOWEN, Nicole GSL07RDAL State Representative, Dist 7, (R) DALHOUSE, Timothy A. (Tim) GSL08DTAR State Representative, Dist 8, (D) TARNAS, David A. GSL08RPER State Representative, Dist 8, (R) PERREIRA, Monique CobbAdams GSL11DAMA State Representative, Dist 11, (D) AMATO, Terez (T.Amato) GSL11RACA State Representative, Dist 11, (R) ACAIN, Aileen R. (Lily) GSL12DYAM State Representative, Dist 12, (D) YAMASHITA, Kyle T. GSL12GRYA State Representative, Dist 12, (G) RYAN, Rita M. GSL12RJOH State Representative, Dist 12, (R) JOHNSON, Dan GSL13DPOE State Representative, Dist 13, (D) POEPOE, Mahina GSL13RADA State Representative, Dist 13, (R) ADAM, Scott GSL14DCOC State Representative, Dist 14, (D) COCHRAN, Elle GSL14RARM State Representative, Dist 14, (R) ARMSTRONG, Kelly J. GSL15DNAK State Representative, Dist 15, (D) NAKAMURA, Nadine K. GSL15RMOR State Representative, Dist 15, (R) MORANZ, David A. GSL16DEVS State Representative, Dist 16, (D) EVSLIN, Luke A. GSL16RYOD State Representative, Dist 16, (R) YODER, Steve GSL17DMOR State Representative, Dist 17, (D) MORIKAWA, Daynette (Dee) GSL17RJAU State Representative, Dist 17, (R) JAUCH, Michael H. GSL20DNAK State Representative, Dist 20, (D) NAKADA GRANDINETTI, Tina GSL20RSOL State Representative, Dist 20, (R) SOLOMON, Corinne S. GSL21DSAY State Representative, Dist 21, (D) SAYAMA, Jackson D. GSL21RSEA State Representative, Dist 21, (R) SEASHELL, Joelle GSL22DGAR State Representative, Dist 22, (D) GARRETT, Andrew Takuya GSL22RIMA State Representative, Dist 22, (R) IMAMURA, Jeffrey H. GSL24DTAM State Representative, Dist 24, (D) TAM, Adrian GSL24RAND State Representative, Dist 24, (R) ANDERSON, Jillian T. GSL27DTAK State Representative, Dist 27, (D) TAKENOUCHI, Jenna GSL27RLIM State Representative, Dist 27, (R) LIM, Margaret U. GSL29DHUS State Representative, Dist 29, (D) HUSSEY, Ikaika Lardizabal GSL29RKAA State Representative, Dist 29, (R) KAAPU, Carole Kauhiwai GSL30DTEM State Representative, Dist 30, (D) TEMPLO, Shirley Ann Labadan GSL30RAZI State Representative, Dist 30, (R) AZINGA, P. M. GSL31DICH State Representative, Dist 31, (D) ICHIYAMA, Linda GSL31RVAL State Representative, Dist 31, (R) VALDEZ, Nancy A. GSL32DAIU State Representative, Dist 32, (D) AIU, Micah Pookela Kim GSL32RSHI State Representative, Dist 32, (R) SHIMIZU, Garner Musashi GSL34DTAK State Representative, Dist 34, (D) TAKAYAMA, Gregg GSL34RDUP State Representative, Dist 34, (R) DUPIO, Gaius, II GSL37DLA State Representative, Dist 37, (D) LA CHICA, Trish GSL37RKAA State Representative, Dist 37, (R) KAAUMOANA, Taylor GSL38DOZA State Representative, Dist 38, (D) OZAWA, Alexander Kekuanao'a GSL38RCHE State Representative, Dist 38, (R) CHEAPE MATSUMOTO, Lauren GSL39DROS State Representative, Dist 39, (D) ROSENLEE, Corey GSL39RPIE State Representative, Dist 39, (R) PIERICK, Elijah GSL40DMAR State Representative, Dist 40, (D) MARTINEZ, Rose GSL40OULU State Representative, Dist 40, (W) ULUFANUA, Christian P. GSL40RREY State Representative, Dist 40, (R) REYES ODA, Julie GSL41DCLA State Representative, Dist 41, (D) CLARK, John H., III GSL41RALC State Representative, Dist 41, (R) ALCOS, David A., III GSL42DPAR State Representative, Dist 42, (D) PARIS, Anthony Makana GSL42RGAR State Representative, Dist 42, (R) GARCIA, Diamond GSL45DDES State Representative, Dist 45, (D) DESOTO, Desire Auguste GSL45RMUR State Representative, Dist 45, (R) MURAOKA, Chris GSL46DPER State Representative, Dist 46, (D) PERRUSO, Amy A. GSL46RGAB State Representative, Dist 46, (R) GABRIEL, Daniel Michael GSL47DQUI State Representative, Dist 47, (D) QUINLAN, Sean GSL47RAGU State Representative, Dist 47, (R) AGUIRRE, John W. (Johnny) GSL48DKIT State Representative, Dist 48, (D) KITAGAWA, Lisa C. GSL48GDAI State Representative, Dist 48, (G) DAILY, Asheemo N. (Koda) GSL49DMAT State Representative, Dist 49, (D) MATAYOSHI, Scot GSL49RUBA State Representative, Dist 49, (R) UBANDO, Josiah (BrahKruz) GSL50DLEE State Representative, Dist 50, (D) LEE, Mike GSL50RCON State Representative, Dist 50, (R) CONNELLY, Timothy D. GSU03DKAN State Senator, Dist 3, (D) KANUHA, Dru Mamo GSU03RSUL State Senator, Dist 3, (R) SULLIVAN, Kurt (Sulli) GSU06DMCK State Senator, Dist 6, (D) MCKELVEY, Angus L.K. GSU06RWAL State Senator, Dist 6, (R) WALKER, Sheila GSU07DDEC State Senator, Dist 7, (D) DECOITE, Lynn Pualani GSU07RMAC State Senator, Dist 7, (R) MACARAEG, Gabby GSU12DMOR State Senator, Dist 12, (D) MORIWAKI, Sharon Y. GSU12RDAB State Senator, Dist 12, (R) DABBS, Shotaro GSU16DELE State Senator, Dist 16, (D) ELEFANTE, Brandon GSU16RBEE State Senator, Dist 16, (R) BEEKMAN, Pat GSU18DKID State Senator, Dist 18, (D) KIDANI, Michelle N. GSU18RSVR State Senator, Dist 18, (R) SVRCINA, Emil GSU22DGAT State Senator, Dist 22, (D) GATES, Cedric Asuega GSU22RDEC State Senator, Dist 22, (R) DECORTE, Samantha GSU23DSHA State Senator, Dist 23, (D) SHAFER, Ben GSU23RAWA State Senator, Dist 23, (R) AWA, Brenton GTRUALAHU At-Large Trustee, AHU ISA, Lei GTRUALAKI At-Large Trustee, AKINA, Keli'i GTRUKAAHU Kauai Resident Trustee, AHUNA, Dan GTRUKALIN Kauai Resident Trustee, LINDSEY, Laura A. GTRUMOALA Molokai Resident Trustee, ALAPA, Luana GTRUMONIH Molokai Resident Trustee, NIHIPALI, R. Kunani ## 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