Writing Projects

Pilot Script

ADP Plan

Arizona 2024 General Election Results

🟨 Andrei Cherny

  • Strong negative correlations with all racial and minority indicators:

    • HISP_PCT: –0.43 → significant

    • MIN_PCT: –0.47 → significant

    • HISP18_PCT: –0.42 → significant

    • MIN18_PCT: –0.47 → significant

  • R² values range from 0.18 to 0.22 — modest explanatory power.

  • Total Population 18+: correlation near zero (–0.01), not statistically significant.

🟡 Summary: Cherny underperformed in diverse precincts (especially Hispanic and minority-heavy areas). His support was concentrated in whiter precincts, with no meaningful pattern related to precinct size.

🟥 Amish Shah

  • Strong positive correlations with:

    • HISP_PCT: +0.48

    • MIN_PCT: +0.44

    • HISP18_PCT: +0.48

    • MIN18_PCT: +0.44

  • All statistically significant (p < 0.001).

  • Total Population 18+: mild negative correlation (–0.09) — not statistically meaningful.

  • R² values around 0.20–0.23

🟥 Summary: Shah was the strongest performer in diverse, minority, and Hispanic precincts. His support dropped slightly in more populous (denser) precincts, but not in a meaningful way. Clear demographic alignment with racially diverse communities.

🟧 Andrew Horne

  • No significant correlation with race or ethnicity:

    • Correlations: all near zero or slightly negative (–0.06 to –0.13), not significant.

  • Only notable pattern:

    • Total Population 18+: +0.22 correlation, positive regression coefficient

    • R² = 0.05 → weak, but statistically significant

🟧 Summary: Horne’s vote share was not strongly tied to race or ethnicity, but he did slightly better in more populated precincts — possibly reflecting strength in moderate, suburban areas with higher turnout.

🟦 Conor O’Callaghan

  • Moderate negative correlations with racial diversity:

    • HISP_PCT: –0.43

    • MIN_PCT: –0.41

    • HISP18_PCT: –0.42

    • MIN18_PCT: –0.41

    • All statistically significant

  • Total Population 18+: near-zero correlation (–0.03), not significant

🟦 Summary: Conor performed more strongly in precincts with lower racial diversity — not as strongly correlated as Cherny, but still inverse to diversity. No clear link to precinct size.

Marlene Woods

  • Very weak correlations with all demographics:

    • Ranged from –0.04 to –0.15

    • None particularly strong or meaningful

  • R² values low (< 0.03), even if some are statistically significant due to large sample

  • Mild inverse correlation with MIN_PCT and HISP18_PCT

Summary: Marlene’s support was not closely tied to any one demographic group. She had slight underperformance in more diverse precincts, but overall her appeal seemed broad-based and demographically neutral.

ABC
1
Candidate
Stronger in…Weaker in…
2
Shah
Hispanic, minority, diverse areas
Slight drop in large precincts
3
ChernyWhiter, less diverse precinctsHispanic and minority areas
4
O’CallaghanWhiter precinctsDiverse communities
5
HorneMore populous precinctsNo demographic trend on race
6
WoodsVery neutral; broad distribution
Slightly weaker in minority areas
Precinct1st Place Name1st Place Party1st Place Votes2nd Place Name2nd Place Party2nd Place Votes3rd Place Name3rd Place Party3rd Place Votes4th Place Name4th Place Party4th Place VotesTop 2 Different PartyPercentage Difference (2nd vs 3rd)
0019 AMBERGRESS, MATTREP661BUTLER, KELLIDEM657GRESHAM, KARENDEM648CARTER, PAMELAREP563X0.69%
0021 ANDORABUTLER, KELLIDEM997GRESHAM, KARENDEM910GRESS, MATTREP888CARTER, PAMELAREP8491.22%
0023 ANNETTEGRESS, MATTREP1383CARTER, PAMELAREP1249BUTLER, KELLIDEM1126GRESHAM, KARENDEM11215.18%
0039 ASTERGRESS, MATTREP1056CARTER, PAMELAREP1001BUTLER, KELLIDEM768GRESHAM, KARENDEM73013.17%
0043 AVIANOGRESS, MATTREP1853CARTER, PAMELAREP1737BUTLER, KELLIDEM1666GRESHAM, KARENDEM15772.09%
0057 BETHANYBUTLER, KELLIDEM718GRESHAM, KARENDEM712GRESS, MATTREP699CARTER, PAMELAREP5930.92%
0060 BILTMOREBUTLER, KELLIDEM1128GRESS, MATTREP1090GRESHAM, KARENDEM1051CARTER, PAMELAREP922X1.82%
0092 CALAVEROSBUTLER, KELLIDEM753GRESHAM, KARENDEM721GRESS, MATTREP575CARTER, PAMELAREP52911.27%
0122 CHAPARRALGRESHAM, KARENDEM975BUTLER, KELLIDEM972GRESS, MATTREP940CARTER, PAMELAREP8441.67%
0125 CHENEYGRESS, MATTREP1833CARTER, PAMELAREP1666BUTLER, KELLIDEM954GRESHAM, KARENDEM92027.18%
0136 CLEARVIEWGRESS, MATTREP1437CARTER, PAMELAREP1383BUTLER, KELLIDEM1354GRESHAM, KARENDEM12981.06%
0137 CLEARWATERGRESS, MATTREP649CARTER, PAMELAREP571BUTLER, KELLIDEM456GRESHAM, KARENDEM43511.20%
0138 CLIFFVIEWBUTLER, KELLIDEM942GRESHAM, KARENDEM900GRESS, MATTREP594CARTER, PAMELAREP53120.48%
0144 COCOPAHGRESS, MATTREP897CARTER, PAMELAREP844BUTLER, KELLIDEM624GRESHAM, KARENDEM59714.99%
0158 COPPERGRESS, MATTREP1460CARTER, PAMELAREP1276GRESHAM, KARENDEM1266BUTLER, KELLIDEM12610.39%
0159 COPPER HILLSGRESS, MATTREP1215BUTLER, KELLIDEM1077CARTER, PAMELAREP1073GRESHAM, KARENDEM1037X0.19%
0202 DEERVIEWGRESS, MATTREP444CARTER, PAMELAREP406GRESHAM, KARENDEM368BUTLER, KELLIDEM3604.91%
0203 DEL JOYAGRESS, MATTREP1649CARTER, PAMELAREP1605BUTLER, KELLIDEM1296GRESHAM, KARENDEM123010.65%
0232 DOUBLETREEGRESS, MATTREP1531CARTER, PAMELAREP1389BUTLER, KELLIDEM921GRESHAM, KARENDEM89020.26%
0238 DREYFUSGRESS, MATTREP1135CARTER, PAMELAREP1030BUTLER, KELLIDEM997GRESHAM, KARENDEM9971.63%
0273 EVANSGRESS, MATTREP661BUTLER, KELLIDEM597CARTER, PAMELAREP589GRESHAM, KARENDEM577X0.67%
0275 EXETERGRESS, MATTREP740CARTER, PAMELAREP649BUTLER, KELLIDEM595GRESHAM, KARENDEM5504.34%
0292 FOXWOODBUTLER, KELLIDEM796GRESS, MATTREP773CARTER, PAMELAREP737GRESHAM, KARENDEM733X2.38%
0308 GEORGIABUTLER, KELLIDEM442GRESHAM, KARENDEM428GRESS, MATTREP275CARTER, PAMELAREP23821.76%
0322 GOLD DUSTBUTLER, KELLIDEM690GRESS, MATTREP652GRESHAM, KARENDEM636CARTER, PAMELAREP599X1.24%
0337 GREENWAYGRESS, MATTREP1386BUTLER, KELLIDEM1370CARTER, PAMELAREP1309GRESHAM, KARENDEM1299X2.28%
0366 HIBISCUSGRESHAM, KARENDEM464BUTLER, KELLIDEM462GRESS, MATTREP308CARTER, PAMELAREP24820.00%
0372 HILLERYGRESS, MATTREP1185CARTER, PAMELAREP1056BUTLER, KELLIDEM845GRESHAM, KARENDEM82411.10%
0373 HILLVIEWGRESS, MATTREP1503CARTER, PAMELAREP1434BUTLER, KELLIDEM1169GRESHAM, KARENDEM113410.18%
0385 HOPIGRESS, MATTREP1413CARTER, PAMELAREP1218BUTLER, KELLIDEM942GRESHAM, KARENDEM90212.78%
0386 HORIZONGRESS, MATTREP2593CARTER, PAMELAREP2309BUTLER, KELLIDEM1811GRESHAM, KARENDEM178212.09%
0393 INDIAN BENDBUTLER, KELLIDEM1070GRESHAM, KARENDEM1042GRESS, MATTREP1039CARTER, PAMELAREP9020.14%
0399 JACKRABBITGRESS, MATTREP1526CARTER, PAMELAREP1378BUTLER, KELLIDEM1264GRESHAM, KARENDEM12604.31%
0400 JANICEBUTLER, KELLIDEM905GRESS, MATTREP870CARTER, PAMELAREP847GRESHAM, KARENDEM827X1.34%
0413 JUSTINEGRESS, MATTREP1307CARTER, PAMELAREP1247BUTLER, KELLIDEM1032GRESHAM, KARENDEM9889.43%
0414 KACHINABUTLER, KELLIDEM1523GRESHAM, KARENDEM1430GRESS, MATTREP1117CARTER, PAMELAREP99612.29%
0421 KIVAGRESS, MATTREP649CARTER, PAMELAREP579BUTLER, KELLIDEM370GRESHAM, KARENDEM35822.02%
0435 LARKSPURBUTLER, KELLIDEM433GRESHAM, KARENDEM420GRESS, MATTREP369CARTER, PAMELAREP3196.46%
0453 LIONSGRESS, MATTREP417CARTER, PAMELAREP369BUTLER, KELLIDEM344GRESHAM, KARENDEM3253.51%
0467 LOOKOUT RIDGEGRESS, MATTREP1224BUTLER, KELLIDEM1220GRESHAM, KARENDEM1125CARTER, PAMELAREP1114X4.05%
0477 MADISONBUTLER, KELLIDEM543GRESHAM, KARENDEM490GRESS, MATTREP288CARTER, PAMELAREP25025.96%
0478 MADISON HEIGHTSBUTLER, KELLIDEM921GRESHAM, KARENDEM889GRESS, MATTREP779CARTER, PAMELAREP7186.59%
0501 MCCORMICK RANCHGRESS, MATTREP2574CARTER, PAMELAREP2440BUTLER, KELLIDEM2347GRESHAM, KARENDEM22701.94%
0502 MCDONALDGRESS, MATTREP405GRESHAM, KARENDEM372BUTLER, KELLIDEM371CARTER, PAMELAREP355X0.13%
0525 MOHAVEGRESS, MATTREP1408GRESHAM, KARENDEM1386BUTLER, KELLIDEM1374CARTER, PAMELAREP1258X0.43%
0532 MONTEROSAGRESS, MATTREP582CARTER, PAMELAREP565BUTLER, KELLIDEM440GRESHAM, KARENDEM40412.44%
0541 MUMMY MOUNTAINBUTLER, KELLIDEM1582GRESHAM, KARENDEM1497GRESS, MATTREP1423CARTER, PAMELAREP13112.53%
0543 MUSTANGGRESS, MATTREP1921CARTER, PAMELAREP1855BUTLER, KELLIDEM1545GRESHAM, KARENDEM14659.12%
0580 OAKHURSTGRESS, MATTREP499CARTER, PAMELAREP460BUTLER, KELLIDEM378GRESHAM, KARENDEM3539.79%
0588 ONYXBUTLER, KELLIDEM800GRESHAM, KARENDEM800GRESS, MATTREP679CARTER, PAMELAREP5958.18%
0590 ORANGE TREEGRESS, MATTREP649CARTER, PAMELAREP596BUTLER, KELLIDEM432GRESHAM, KARENDEM39215.95%
0611 PALO CRISTIGRESS, MATTREP1254CARTER, PAMELAREP1146BUTLER, KELLIDEM797GRESHAM, KARENDEM70717.96%
0619 PARK MEADOWSGRESS, MATTREP683CARTER, PAMELAREP624BUTLER, KELLIDEM436GRESHAM, KARENDEM43017.74%
0641 PILLARGRESS, MATTREP1434CARTER, PAMELAREP1360BUTLER, KELLIDEM1151GRESHAM, KARENDEM10698.32%
0643 PINE VALLEYGRESS, MATTREP1972CARTER, PAMELAREP1781BUTLER, KELLIDEM1280GRESHAM, KARENDEM126116.37%
0662 PRINCESSGRESS, MATTREP1240CARTER, PAMELAREP1114GRESHAM, KARENDEM737BUTLER, KELLIDEM72220.37%
0671 RAINTREEGRESS, MATTREP1025BUTLER, KELLIDEM1017GRESHAM, KARENDEM969CARTER, PAMELAREP951X2.42%
0679 REDWINGGRESHAM, KARENDEM1339BUTLER, KELLIDEM1319GRESS, MATTREP1166CARTER, PAMELAREP10276.16%
0727 SAN SIMONGRESS, MATTREP613BUTLER, KELLIDEM599GRESHAM, KARENDEM573CARTER, PAMELAREP560X2.22%
0728 SAN VICTORGRESS, MATTREP1039BUTLER, KELLIDEM996GRESHAM, KARENDEM994CARTER, PAMELAREP958X0.10%
0730 SANDPIPERGRESS, MATTREP1261CARTER, PAMELAREP1205BUTLER, KELLIDEM860GRESHAM, KARENDEM82316.71%
0734 SANTOGRESS, MATTREP1343CARTER, PAMELAREP1313BUTLER, KELLIDEM1102GRESHAM, KARENDEM10418.74%
0742 SENTRYGRESHAM, KARENDEM846BUTLER, KELLIDEM843GRESS, MATTREP808CARTER, PAMELAREP7462.12%
0745 SHADOW ROCKBUTLER, KELLIDEM1154GRESS, MATTREP1073GRESHAM, KARENDEM1036CARTER, PAMELAREP984X1.75%
0755 SIERRA PASSGRESS, MATTREP2165BUTLER, KELLIDEM1957CARTER, PAMELAREP1923GRESHAM, KARENDEM1922X0.88%
0807 SUNDOWNGRESS, MATTREP1149CARTER, PAMELAREP1022BUTLER, KELLIDEM908GRESHAM, KARENDEM8805.91%
0812 SUNNYSIDEGRESS, MATTREP554CARTER, PAMELAREP553BUTLER, KELLIDEM430GRESHAM, KARENDEM42812.51%
0828 TATUMGRESS, MATTREP1961CARTER, PAMELAREP1714GRESHAM, KARENDEM1533BUTLER, KELLIDEM15325.57%
0841 TOPEKAGRESS, MATTREP803BUTLER, KELLIDEM765GRESHAM, KARENDEM754CARTER, PAMELAREP698X0.72%
0874 VILLA RITAGRESS, MATTREP923BUTLER, KELLIDEM899GRESHAM, KARENDEM891CARTER, PAMELAREP797X0.45%
List of precincts where the top vote-getter for the Senate and the House were from different parties:
PrecinctSenate Winner PartyHOUSE WINNER PARTY
0019 AMBERDemocratREPUBLICAN
0337 GREENWAYDemocratREPUBLICAN
0467 LOOKOUT RIDGEDemocratREPUBLICAN
0502 MCDONALDDemocratREPUBLICAN
0525 MOHAVEDemocratREPUBLICAN
0671 RAINTREEDemocratREPUBLICAN
0727 SAN SIMONDemocratREPUBLICAN
0728 SAN VICTORDemocratREPUBLICAN
0841 TOPEKADemocratREPUBLICAN
0874 VILLA RITADemocratREPUBLICAN
There are no precincts where a Republican won the Senate race and a Democrat won the House race in LD4.

Every Election within Congressional District One

ABCDEFG
1
ContestNameWinner nameLoser nameWinner percentageLoser percentageMargin of Victory (%)
Vote differential
2
Presidential ElectorsTRUMP / VANCEHARRIS / WALZ50.6747.593.0814005
3
US SenateGALLEGO, RUBENLAKE, KARI51.4546.504.9522145
4
US Rep Dist CD-1SCHWEIKERT, DAVIDSHAH, AMISH51.8148.013.8116572
5
State Senator Dist-2SCHWIEBERT, JUDYBOLICK, SHAWNNA49.2548.790.46285
6
State Rep Dist-2SIMACEK, STEPHANIEWILMETH, JUSTIN31.7828.753.032837
7
State Rep Dist-2BRADSHAW, ARI DANIELWILMETH, JUSTIN28.9328.750.18165
8
State Senator Dist-3KAVANAGH, JOHNWrite-in98.002.0096.0081823
9
State Rep Dist-3CHAPLIK, JOSEPHCORLES, RICHARD38.6324.3414.2926197
10
State Rep Dist-3KOLODIN, ALEXANDERCORLES, RICHARD36.8324.3412.4922894
11
State Senator Dist-4WERNER, CARINEMARSH, CHRISTINE51.8148.093.725465
12
State Rep Dist-4GRESS, MATTBUTLER, KELLI27.4824.123.369262
13
State Rep Dist-4CARTER, PAMELABUTLER, KELLI25.0924.120.972670
14
State Senator Dist-5ALSTON, LELAORTEGA, JOSHUA61.2738.6022.6711575
15
State Rep Dist-5LIGUORI, SARAHPATOCS, REINA "REINA"38.2625.6812.589786
16
State Rep Dist-5MARQUEZ, AARONPATOCS, REINA "REINA"35.3425.689.677518
17
State Senator Dist-8KUBY, LAURENHOLZAPFEL, ROXANA55.5344.3111.225022
18
State Rep Dist-8CONNOLLY, JANEENDARROW, CADEN33.3028.694.613231
19
State Rep Dist-8GARCIA, BRIANDARROW, CADEN32.4128.693.722607
20
State Senator Dist-10FARNSWORTH, DAVID CHRISTIANDOYLE, ROBERT62.4037.5124.89783
21
State Rep Dist-10HEAP, RALPHHUNTER, HELEN31.8818.5613.32792
22
State Rep Dist-10OLSON, JUSTINHUNTER, HELEN31.0418.5612.47742
23
State Senator Dist-26BRAVO, FLAVIOHARRIS, VICTOR "VIC"66.8732.9733.901025
24
State Rep Dist-26AGUILAR, CESARROBERTS, FRANK34.0716.8917.19968
25
State Rep Dist-26CREWS, QUANT ROBERTS, FRANK33.0316.8916.14909
26
Corporation CommissionWALDEN, RACHELHILL, JONATHON17.8815.532.3527264
27
Corporation CommissionLOPEZ, RENEHILL, JONATHON17.2315.531.7019695
28
Corporation CommissionMARQUEZ PETERSON, LEAHILL, JONATHON17.0815.531.5517954
29
Board of Supervisors Dist 2-County SupervisorGALVIN, THOMASCIENIAWSKI, JULIE58.0741.8416.2431330
30
Board of Supervisors Dist 3-County SupervisorBROPHY MCGEE, KATEVALENZUELA, DANIEL52.2947.634.669768
31
Board of Supervisors Dist 5-County SupervisorGALLARDO, STEVENIEMANN, ANN76.2523.7552.5084
32
County AssessorCOOK, EDDIEFREEMAN, GREGORY55.5144.4311.0846000
33
County AttorneyMITCHELL, RACHELWOOTEN, TAMIKA N56.0243.9112.1150643
34
County RecorderHEAP, JUSTINSTRINGHAM, TIM52.7647.175.5923165
35
County School SuperintendentBOGGS, SHELLI LMETCALFE, LAURA52.2347.704.5318767
36
County SheriffSHERIDAN, JERRYKAMP, TYLER54.4045.498.9137466
37
County TreasurerALLEN, JOHN M.Write-in97.752.2595.50275765
38
JP-ARCADIA BILTMOREDRIGGS, LEONOREWrite-in96.933.0793.8525335
39
Constable-ARCADIA BILTMOREWIBLE, CHRISWrite-in97.022.9894.0424666
40
JP-NORTH MESAJONES, KYLE ISEARS, KIANA MARIA62.6637.2925.37888
41
Constable-NORTH MESACURTIS, JONWrite-in98.321.6896.652537
42
JP-DREAMY DRAWFITZWILLIAMS, ASHLEY JWrite-in94.982.5192.4748880
43
Constable-DREAMY DRAWTORRES, RHYSWrite-in97.572.4395.1447848
44
JP-MOON VALLEYARROYO, MIREYAIRISH, MICHAEL55.2044.6810.521618
45
Constable-MOON VALLEYMCRAE, MATTHEW HWrite-in97.122.8894.239380
46
JP-DESERT RIDGERIGGS, CATHYWrite-in98.641.3697.2865984
47
Constable-DESERT RIDGERICH, JAMESWrite-in98.691.3197.3864850
48
Glendale UHSD #205-GBM-4yrULAN, PAULCOLSON, JOAN JOANIE27.5322.125.412496
49
Glendale UHSD #205-GBM-4yrARITA, LAURA ICOLSON, JOAN JOANIE24.9822.122.861319
50
Glendale UHSD #205-GBM-4yrHUSSEY, PATTI JOCOLSON, JOAN JOANIE24.7722.122.651221
51
Glendale UHSD #205-QUESTIONBOND APPROVAL, YESBOND APPROVAL, NO60.7139.2921.415695
52
Phoenix UHSD #210-GBM-4yrCROSS, DEBBIERAMIREZ, ADEN31.5320.3911.145684
53
Phoenix UHSD #210-GBM-4yrMARQUEZ, AARONRAMIREZ, ADEN24.2320.393.831957
54
Phoenix UHSD #210-GBM-4yrPASTOR-RIVERA, FRANCISCO ISAACRAMIREZ, ADEN22.5620.392.161103
55
Tempe ESD #3-GBM-4yrEWERS, ALLISONTHIRY, RAY0
56
Tempe ESD #3-GBM-4yrLEMMON, JAMES J.THIRY, RAY0
57
Tempe ESD #3-GBM-4yrPEMBERTON, IVANTHIRY, RAY0
58
Tempe ESD #3-QUESTION 1BUDGET OVERRIDE CONTINUATION, NOBUDGET OVERRIDE CONTINUATION, YES0
59
Tempe ESD #3-QUESTION 2BUDGET INCREASE, NOBUDGET INCREASE, YES0
60
Mesa USD #4-GBM-4yrBENSON, SHARONDAVIS, COURTNEY23.4218.994.42395
61
Mesa USD #4-GBM-4yrSTEELE, EDDAVIS, COURTNEY19.2518.990.2623
62
Mesa USD #4-GBM-4yrCHILTON, JOSHDAVIS, COURTNEY19.0418.990.044
63
Washington ESD #6-GBM-4yrPETERSON, LINDSEYADAMS, BILL29.6421.058.594144
64
Washington ESD #6-GBM-4yrABBOTT-BAYARDI, JENNIADAMS, BILL26.7821.055.732763
65
Washington ESD #6-GBM-4yrKONETZNI, KARENADAMS, BILL22.0521.050.99479
66
Creighton ESD #14-GBM-4yrMARQUEZ, NICOLE E.URQUIDI, CARLA30.0718.9411.131590
67
Creighton ESD #14-GBM-4yrAYRES, HEATHER L.URQUIDI, CARLA26.7618.947.831118
68
Creighton ESD #14-GBM-4yrJONES, TRISTAN H.URQUIDI, CARLA23.4018.944.46637
69
Creighton ESD #14-QUESTIONBOND APPROVAL, YESBOND APPROVAL, NO53.8046.207.61661
70
Balsz ESD #31-GBM-4yrKNIGHT, GAIL QUINCENESHEPHERD, LEZLEY25.9222.583.34358
71
Balsz ESD #31-GBM-4yrGRACE, VICSHEPHERD, LEZLEY25.4422.582.86306
72
Balsz ESD #31-GBM-4yrGEORGE, JACOB MICHAELSHEPHERD, LEZLEY25.3222.582.75294
73
Balsz ESD #31-QUESTION 1BOND APPROVAL, YESBOND APPROVAL, NO60.0139.9920.031197
74
Balsz ESD #31-QUESTION 2BUDGET OVERRIDE CONTINUATION, YESBUDGET OVERRIDE CONTINUATION, NO61.1138.8922.211312
75
Scottsdale USD #48-GBM-4yrLEWIS, DONNABEASLEY, JEANNE18.8515.763.109127
76
Scottsdale USD #48-GBM-4yrPITTINSKY, MATTBEASLEY, JEANNE17.8315.762.076101
77
Scottsdale USD #48-GBM-4yrSHARKEY, MIKEBEASLEY, JEANNE17.6215.761.865480
78
Paradise Valley USD #69-GBM-4yrGREENBERG, ANNEJACKSON, EDWARD (EDDY)18.9415.643.309138
79
Paradise Valley USD #69-GBM-4yrLIM, AMANDAJACKSON, EDWARD (EDDY)18.1215.642.486858
80
Paradise Valley USD #69-GBM-4yrWANI, JESSICAJACKSON, EDWARD (EDDY)17.5915.641.955405
81
Cave Creek USD #93-GBM-4yrFORTNEY, JEFFLOPEZ, SHERI16.6413.643.012815
82
Cave Creek USD #93-GBM-4yrMOORE, DANLOPEZ, SHERI15.6913.642.051924
83
Cave Creek USD #93-GBM-4yrWALKER, BRIANNA LLOPEZ, SHERI15.3413.641.701592
84
Deer Valley USD #97-GBM-4yrBOTTFELD, STEVEPACK, KAREN15.8012.942.86482
85
Deer Valley USD #97-GBM-4yrSTOCKWELL, JULIEPACK, KAREN15.5912.942.64446
86
Deer Valley USD #97-GBM-4yrFISHER, KIMPACK, KAREN14.1112.941.16196
87
Deer Valley USD #97-QUESTION 1BOND APPROVAL, NOBOND APPROVAL, YES50.9749.031.94151
88
Deer Valley USD #97-QUESTION 2BUDGET OVERRIDE CONTINUATION, YESBUDGET OVERRIDE CONTINUATION, NO51.5048.503.00238
89
Fountain Hills USD #98-GBM-4yrDUCKWORTH, KIMWrite-in34.270.3033.977725
90
Fountain Hills USD #98-GBM-4yrRUTKOWSKI, RICHARDWrite-in33.720.3033.427600
91
Fountain Hills USD #98-GBM-4yrEVANS, ANNEWrite-in31.720.3031.427145
92
Fountain Hills USD #98-QUESTIONSALE, LEASE OR EXCHANGE OF REAL PROPERTY, YESSALE, LEASE OR EXCHANGE OF REAL PROPERTY, NO69.2730.7338.555861
93
CAWCD Board of DirectorsGODDARD, TERRYATKINS, LISA18.8917.771.1212010
94
Carefree-PROPOSITION 493YESNO56.7443.2613.47364
95
Fountain Hills-MayorFRIEDEL, GERRYDICKEY, GINNY55.1344.6610.481624
96
Fountain Hills-CouncilmemberWATTS, RICKMCMAHON, PEGGY26.3625.241.12293
97
Mesa-MayorFREEMAN, MARK A.SMITH, SCOTT51.3647.933.4396
98
Mesa Dist 1-CouncilmemberADAMS, RICHWILLIAMS, RON0
99
Mesa-QUESTION 1YESNO59.6740.3319.33580
100
Mesa-QUESTION 2BOND APPROVAL, YESBOND APPROVAL, NO60.7639.2421.53654
101
Mesa-QUESTION 3BOND APPROVAL, YESBOND APPROVAL, NO51.6248.383.2599
102
Mesa-QUESTION 4YESNO63.3336.6726.66778
103
Phoenix-MayorGALLEGO, KATEEVANS, MATT57.8741.9715.9035330
104
Phoenix Dist 1-CouncilmemberO'BRIEN, ANNWrite-in98.711.2997.421587
105
Phoenix Dist 3-CouncilmemberSTARK, DEBRAMILLAN, AYENSA61.5337.9923.5413850
106
Phoenix-PROPOSITION 487YESNO71.8828.1243.7591822
107
Phoenix-PROPOSITION 488YESNO79.6920.3159.39122472
108
Phoenix-PROPOSITION 489YESNO64.6635.3429.3261779
109
Paradise Valley-MayorSTANTON, MARKTHOMASSON, ANNA54.0545.578.49654
110
Scottsdale-MayorBOROWSKY, LISAORTEGA, DAVID "DAVE"54.1445.628.5211189
111
Scottsdale-CouncilmemberKWASMAN, ADAMCAPUTI, TAMMY29.8227.222.604835
112
Scottsdale-CouncilmemberMCALLEN, MARYANNCAPUTI, TAMMY28.8227.221.602979
113
Scottsdale-PROPOSITION 490YESNO58.2541.7516.5123244
114
Scottsdale-PROPOSITION 491YESNO66.1533.8532.3144840

Every Election within Legislative District Four 2024 General

ABCDEFG
1
ContestNameWinner nameLoser name
Winner percentage
Loser percentage
Margin of Victory (%)
Vote differential
2
Presidential ElectorsTRUMP / VANCEHARRIS / WALZ50.8847.373.505395
3
US SenateGALLEGO, RUBENLAKE, KARI51.3846.734.647031
4
US Rep Dist CD-1SCHWEIKERT, DAVIDSHAH, AMISH52.1747.674.506648
5
State Senator Dist-4WERNER, CARINEMARSH, CHRISTINE51.8148.093.725465
6
State Rep Dist-4CARTER, PAMELABUTLER, KELLI25.0924.120.972670
7
State Rep Dist-4GRESS, MATTBUTLER, KELLI27.4824.123.369262
8
Corporation CommissionMARQUEZ PETERSON, LEAHILL, JONATHON17.2315.611.636456
9
Corporation CommissionLOPEZ, RENEHILL, JONATHON17.2815.611.676640
10
Corporation CommissionWALDEN, RACHELHILL, JONATHON17.9315.612.329214
11
Board of Supervisors Dist 2-County Supervisor
GALVIN, THOMASCIENIAWSKI, JULIE55.7044.2411.465844
12
Board of Supervisors Dist 3-County Supervisor
BROPHY MCGEE, KATEVALENZUELA, DANIEL56.0043.9412.0610997
13
County AssessorCOOK, EDDIEFREEMAN, GREGORY56.2143.7412.4617515
14
County AttorneyMITCHELL, RACHELWOOTEN, TAMIKA N56.7543.2013.5519180
15
County RecorderHEAP, JUSTINSTRINGHAM, TIM53.0346.906.138600
16
County School SuperintendentBOGGS, SHELLI LMETCALFE, LAURA52.5947.355.247365
17
County SheriffSHERIDAN, JERRYKAMP, TYLER54.7445.159.5913650
18
County TreasurerALLEN, JOHN M.Write-in97.902.1095.8095100
19
JP-ARCADIA BILTMOREDRIGGS, LEONOREWrite-in95.924.0891.848580
20
Constable-ARCADIA BILTMOREWIBLE, CHRISWrite-in96.053.9592.108345
21
JP-DREAMY DRAWFITZWILLIAMS, ASHLEY JWrite-in95.762.1293.6321576
22
Constable-DREAMY DRAWTORRES, RHYSWrite-in97.912.0995.8121097
23
JP-DESERT RIDGERIGGS, CATHYWrite-in98.281.7296.5713730
24
Constable-DESERT RIDGERICH, JAMESWrite-in98.411.5996.8313493
25
Phoenix UHSD #210-GBM-4yr
PASTOR-RIVERA, FRANCISCO ISAAC
MARQUEZ, AARON21.2420.620.6275
26
Phoenix UHSD #210-GBM-4yrRAMIREZ, ADENMARQUEZ, AARON22.2120.621.60192
27
Phoenix UHSD #210-GBM-4yrCROSS, DEBBIEMARQUEZ, AARON34.2920.6213.671643
28
Creighton ESD #14-GBM-4yrAYRES, HEATHER L.URQUIDI, CARLA26.1318.098.03258
29
Creighton ESD #14-GBM-4yrJONES, TRISTAN H.URQUIDI, CARLA26.2818.098.19263
30
Creighton ESD #14-GBM-4yrMARQUEZ, NICOLE E.URQUIDI, CARLA28.7118.0910.62341
31
Creighton ESD #14-QUESTIONBOND APPROVAL, NOBOND APPROVAL, YES50.9249.081.8341
32
Scottsdale USD #48-GBM-4yrSHARKEY, MIKEBEASLEY, JEANNE17.6615.671.992694
33
Scottsdale USD #48-GBM-4yrPITTINSKY, MATTBEASLEY, JEANNE18.0815.672.423263
34
Scottsdale USD #48-GBM-4yrLEWIS, DONNABEASLEY, JEANNE18.6515.672.984023
35
Paradise Valley USD #69-GBM-4yrWANI, JESSICAKLOOTWYK, NICHOLE17.6915.881.812702
36
Paradise Valley USD #69-GBM-4yrLIM, AMANDAKLOOTWYK, NICHOLE18.0915.882.213303
37
Paradise Valley USD #69-GBM-4yrGREENBERG, ANNEKLOOTWYK, NICHOLE18.9515.883.074588
38
CAWCD Board of DirectorsGODDARD, TERRYMACRE, HEATHER19.1117.761.354912
39
Phoenix-MayorGALLEGO, KATEEVANS, MATT55.4244.4310.999504
40
Phoenix Dist 3-CouncilmemberSTARK, DEBRAMILLAN, AYENSA62.3437.2625.084517
41
Phoenix-PROPOSITION 487YESNO71.9928.0143.9835943
42
Phoenix-PROPOSITION 488YESNO80.1119.8960.2148476
43
Phoenix-PROPOSITION 489YESNO67.2832.7234.5728358
44
Paradise Valley-MayorSTANTON, MARKTHOMASSON, ANNA54.0545.578.49654
45
Scottsdale-MayorBOROWSKY, LISA
ORTEGA, DAVID "DAVE"
51.5448.213.341356
46
Scottsdale-CouncilmemberKWASMAN, ADAMCAPUTI, TAMMY28.4828.080.40229
47
Scottsdale-CouncilmemberMCALLEN, MARYANNCAPUTI, TAMMY28.9928.080.91523
48
Scottsdale-PROPOSITION 490YESNO59.4740.5318.938048
49
Scottsdale-PROPOSITION 491YESNO67.8232.1835.6414810

Every Election with Overlap LD5 and CD1 2004 General

ABCDEFG
1
ContestNameWinner nameLoser name
Winner percentage
Loser percentage
Margin of Victory (%)
Vote differential
2
Presidential ElectorsHARRIS / WALZTRUMP / VANCE60.6437.3123.3212676
3
US SenateGALLEGO, RUBENLAKE, KARI64.4432.9331.5116901
4
US Rep Dist CD-1SHAH, AMISHSCHWEIKERT, DAVID62.1037.6924.4112720
5
State Senator Dist-5ALSTON, LELAORTEGA, JOSHUA61.2738.6022.6711575
6
State Rep Dist-5MARQUEZ, AARON
PATOCS, REINA "REINA"
35.3425.689.677518
7
State Rep Dist-5LIGUORI, SARAH
PATOCS, REINA "REINA"
38.2625.6812.589786
8
Corporation CommissionPOLACHECK, JOSHUAWALDEN, RACHEL18.9213.065.868004
9
Corporation CommissionHILL, JONATHONWALDEN, RACHEL19.7113.066.669089
10
Corporation CommissionAGUILAR, YLENIAWALDEN, RACHEL20.1713.067.119713
11
Board of Supervisors Dist 3-County Supervisor
VALENZUELA, DANIELBROPHY MCGEE, KATE56.7943.1113.686076
12
County AssessorFREEMAN, GREGORYCOOK, EDDIE57.8042.1215.687777
13
County AttorneyWOOTEN, TAMIKA NMITCHELL, RACHEL56.7243.1913.526770
14
County RecorderSTRINGHAM, TIMHEAP, JUSTIN61.4938.4123.0811424
15
County School SuperintendentMETCALFE, LAURABOGGS, SHELLI L61.8038.1223.6811696
16
County SheriffKAMP, TYLERSHERIDAN, JERRY59.5240.3019.229628
17
County TreasurerALLEN, JOHN M.Write-in95.744.2691.4729040
18
JP-ARCADIA BILTMOREDRIGGS, LEONOREWrite-in97.562.4495.1211862
19
Constable-ARCADIA BILTMOREWIBLE, CHRISWrite-in97.602.4095.2111601
20
JP-DREAMY DRAWFITZWILLIAMS, ASHLEY J*NOT QUALIFIED*93.043.4889.5610321
21
Constable-DREAMY DRAWTORRES, RHYSWrite-in96.713.2993.4310151
22
JP-MOON VALLEYARROYO, MIREYAIRISH, MICHAEL60.9938.9022.091606
23
Constable-MOON VALLEYMCRAE, MATTHEW HWrite-in96.453.5592.904237
24
Glendale UHSD #205-GBM-4yrHUSSEY, PATTI JOCOLSON, JOAN JOANIE24.5321.513.03795
25
Glendale UHSD #205-GBM-4yrARITA, LAURA ICOLSON, JOAN JOANIE25.5621.514.061065
26
Glendale UHSD #205-GBM-4yrULAN, PAULCOLSON, JOAN JOANIE27.7621.516.251642
27
Glendale UHSD #205-QUESTIONBOND APPROVAL, YESBOND APPROVAL, NO61.6138.3923.213484
28
Phoenix UHSD #210-GBM-4yr
PASTOR-RIVERA, FRANCISCO ISAAC
RAMIREZ, ADEN22.3019.602.70839
29
Phoenix UHSD #210-GBM-4yrMARQUEZ, AARONRAMIREZ, ADEN25.5719.605.971854
30
Phoenix UHSD #210-GBM-4yrCROSS, DEBBIERAMIREZ, ADEN31.3219.6011.713637
31
Washington ESD #6-GBM-4yrADAMS, BILLKONETZNI, KAREN20.8020.520.2873
32
Washington ESD #6-GBM-4yrABBOTT-BAYARDI, JENNIKONETZNI, KAREN27.7520.527.231913
33
Washington ESD #6-GBM-4yrPETERSON, LINDSEYKONETZNI, KAREN30.3820.529.862607
34
Creighton ESD #14-GBM-4yrJONES, TRISTAN H.URQUIDI, CARLA22.7518.973.78388
35
Creighton ESD #14-GBM-4yrAYRES, HEATHER L.URQUIDI, CARLA26.9618.977.99821
36
Creighton ESD #14-GBM-4yrMARQUEZ, NICOLE E.URQUIDI, CARLA30.4918.9711.521183
37
Creighton ESD #14-QUESTIONBOND APPROVAL, YESBOND APPROVAL, NO55.5044.5011.00667
38
Paradise Valley USD #69-GBM-4yrWANI, JESSICAKLOOTWYK, NICHOLE19.2313.605.63688
39
Paradise Valley USD #69-GBM-4yrLIM, AMANDAKLOOTWYK, NICHOLE21.1213.607.53920
40
Paradise Valley USD #69-GBM-4yrGREENBERG, ANNEKLOOTWYK, NICHOLE21.4813.607.88963
41
CAWCD Board of DirectorsGODDARD, TERRYMACRE, HEATHER21.4318.832.603307
42
Phoenix-MayorGALLEGO, KATEEVANS, MATT66.6333.1933.4416365
43
Phoenix Dist 3-CouncilmemberSTARK, DEBRAMILLAN, AYENSA59.4440.1319.312591
44
Phoenix-PROPOSITION 487YESNO73.5426.4647.0821717
45
Phoenix-PROPOSITION 488YESNO80.7019.3061.4027878
46
Phoenix-PROPOSITION 489YESNO65.6634.3431.3214618

Every Election with a One to One Matchup

ABCDEFGHIJ
1
Matchup Type
Count
MeanContest NameDemocrat NameRepublican Name
Democrat %
Republican %
Margin of Victory (%)
Gender Matchup
2
Female D vs Female R
6-5.75
Board of Supervisors Dist 1-County Supervisor
NAVARRO, JOELSTEWART, MARK48.2651.74-3.48Male D vs Male R
3
Female D vs Male R119.82
Board of Supervisors Dist 2-County Supervisor
CIENIAWSKI, JULIEGALVIN, THOMAS41.6758.33-16.65Female D vs Male R
4
Male D vs Female R5-2.76
Board of Supervisors Dist 3-County Supervisor
VALENZUELA, DANIELBROPHY MCGEE, KATE49.9850.02-0.04Male D vs Female R
5
Male D vs Male R113.98
Board of Supervisors Dist 4-County Supervisor
SANDOVAL, DAVID MLESKO, DEBBIE40.0459.96-19.92Male D vs Female R
6
Board of Supervisors Dist 5-County Supervisor
GALLARDO, STEVENIEMANN, ANN65.7834.2231.57Male D vs Female R
7
County AssessorFREEMAN, GREGORYCOOK, EDDIE46.0054.00-8.01Male D vs Male R
8
County AttorneyWOOTEN, TAMIKA NMITCHELL, RACHEL45.5154.49-8.99
Female D vs Female R
9
County RecorderSTRINGHAM, TIMHEAP, JUSTIN47.8552.15-4.30Male D vs Male R
10
County School SuperintendentMETCALFE, LAURABOGGS, SHELLI L48.5551.45-2.91
Female D vs Female R
11
County SheriffKAMP, TYLERSHERIDAN, JERRY46.5753.43-6.86Male D vs Male R
12
JP-MOON VALLEYARROYO, MIREYAIRISH, MICHAEL54.8145.199.62Female D vs Male R
13
JP-NORTH MESASEARS, KIANA MARIAJONES, KYLE I42.2157.79-15.59Female D vs Male R
14
State Senator Dist-10DOYLE, ROBERT
FARNSWORTH, DAVID CHRISTIAN
38.6961.31-22.63Male D vs Male R
15
State Senator Dist-11MIRANDA, CATHERINEAYALA, JOSHUA72.1727.8344.34Female D vs Male R
16
State Senator Dist-12
EPSTEIN, DENISE "MITZI"
VICINI, CARA58.1241.8816.24
Female D vs Female R
17
State Senator Dist-13WINTERS, SHARON LEEMESNARD, J.D.46.8753.13-6.26Female D vs Male R
18
State Senator Dist-14BROWN, ELIZABETHPETERSEN, WARREN39.8760.13-20.26Female D vs Male R
19
State Senator Dist-16SEAMAN, STACEYSHOPE JR., THOMAS "T.J."80.8419.1661.67Female D vs Male R
20
State Senator Dist-22DIAZ, EVAROBINSON, STEVE64.5935.4129.17Female D vs Male R
21
State Senator Dist-23FERNANDEZ, BRIANALTHERR, MICHELLE46.6453.36-6.71Male D vs Female R
22
State Senator Dist-26BRAVO, FLAVIOHARRIS, VICTOR "VIC"66.3433.6632.69Male D vs Male R
23
State Senator Dist-29STAFFORD, ERICSHAMP, JANAE40.6759.33-18.67Male D vs Female R
24
State Senator Dist-30MORGAINE, J'AIMEANGIUS, HILDY21.8478.16-56.32
Female D vs Female R
25
State Senator Dist-4MARSH, CHRISTINEWERNER, CARINE48.1451.86-3.73
Female D vs Female R
26
State Senator Dist-5ALSTON, LELAORTEGA, JOSHUA68.3031.7036.60Female D vs Male R
27
State Senator Dist-8KUBY, LAURENHOLZAPFEL, ROXANA60.6039.4021.20
Female D vs Female R
28
State Senator Dist-9BURCH, EVASCANTLEBURY, ROBERT51.7348.273.46Female D vs Male R
29
US Rep Dist CD-1SHAH, AMISHSCHWEIKERT, DAVID48.0951.91-3.81Male D vs Male R
30
US Rep Dist CD-2NEZ, JONATHANCRANE, ELI83.1916.8166.38Male D vs Male R
31
US Rep Dist CD-5SCHAFFNER, KATRINABIGGS, ANDY40.9459.06-18.12Female D vs Male R
32
US Rep Dist CD-7GRIJALVA, RAUL M.BUTIEREZ SR., DANIEL FRANCIS62.0038.0024.00Male D vs Male R
33
US Rep Dist CD-8WHITTEN, GREGORYHAMADEH, ABRAHAM "ABE"43.5056.50-13.00Male D vs Male R
34
US Rep Dist CD-9SMITH, QUACYGOSAR, PAUL41.3858.62-17.23Male D vs Male R

Instructions

🔹 Step 1: Identify CD-1 Precincts

From the "Maricopa County Precinct Number" sheet:

  • Filter rows where US Rep Dist CD = 1.

  • Extract the list of Precinct ExtId values — this is your official list of CD-1 precincts.

🔹 Step 2: Filter Vote Results to CD-1

Using the "Without BondsMeasures" sheet:

  • Keep only rows where Precinct ExtId matches the CD-1 list.

  • This ensures you're only analyzing votes cast within CD-1, regardless of contest boundaries.

🔹 Step 3: Tally Contest Results (CD-1 Votes Only)

For each contest:

  1. Aggregate vote totals by ContestName and Candidate Name.

  2. Calculate vote percentage for each candidate within their contest.

  3. Use the "Possible Winners" sheet to determine how many winners each contest allows.

  4. Rank candidates by votes.

  5. Mark top N candidates as winners, where N = Possible Winners.

For multi-winner contests:

  • Compare each winner to the top-losing candidate (i.e., highest-ranked non-winner).

  • This shows the narrowest margin that still secured a win.

🔹 Step 4: Compute Contest Outcome Metrics

For each winner vs. top-loser matchup:

  • Winner percentage = % of total CD-1 votes for winner

  • Loser percentage = % of total CD-1 votes for top-losing candidate

  • Margin of Victory (%) = Winner % – Loser %

  • Vote differential = Winner votes – Loser votes

Do not rely on any pre-labeled "winner"/"loser" flags in the raw data.

🔹 Step 5: Sort Contests by Ballot Order

Use the "Candidate Order" sheet to sort final results by Contest Name, in official ballot order.

🔹 Step 6: Prepare Final Excel Output

  • 📄 Sheet: “CD-1”
    Each row = one winner compared to the top-losing candidate in that contest.

  • 📄 Additional Sheets: “LD2”, “LD3”, “LD4”, etc.
    Follow the same steps above, using the corresponding list of precincts for each LD.

📊 Required Columns in Final Output

ColumnDescriptionContest NameFull name of the contestWinner nameCandidate who won (compare even if multiple winners)Loser nameTop-losing candidate (highest non-winner)Winner percentage% of CD-1 votes received by winnerLoser percentage% of CD-1 votes received by loserMargin of Victory (%)Difference between winner and loser percentageVote differentialWinner votes – Loser votes (raw total)

🟢 Multi-Winner Example:

Contest: State Rep Dist-4
Possible Winners: 2
Top 3 vote-getters:

  • Alice — 33.2% ✅

  • Bob — 32.1% ✅

  • Carlos — 31.7% ❌

Compare:

  • Alice → Carlos

  • Bob → Carlos
    → Margin = 0.4%
    → Vote Differential = Bob votes – Carlos votes

    Do all of the steps and complete them without asking for each step.