home / fivethirtyeight

fivethirtyeight

Custom SQL query returning 101 rows (hide)

rowidCandidateStateDistrictOffice TypeRace TypeRace Primary Election DatePrimary StatusPrimary Runoff StatusGeneral StatusPrimary %Won PrimaryRep Party Support?Trump Endorsed?Bannon Endorsed?Great America Endorsed?NRA Endorsed?Right to Life Endorsed?Susan B. Anthony Endorsed?Club for Growth Endorsed?Koch Support?House Freedom Support?Tea Party Endorsed?Main Street Endorsed?Chamber Endorsed?No Labels Support?
1 Mike Dunleavy AK Governor of Alaska Governor Regular 8/21/18 Advanced None On the Ballot 61.8 Yes                            
2 Michael Sheldon AK Governor of Alaska Governor Regular 8/21/18 Lost None None 2.2 No                            
3 Mead Treadwell AK Governor of Alaska Governor Regular 8/21/18 Lost None None 31.9 No                            
4 Darin Colbry AK Governor of Alaska Governor Regular 8/21/18 Lost None None 0.6 No                            
5 Thomas Gordon AK Governor of Alaska Governor Regular 8/21/18 Lost None None 1.3 No                            
6 Merica Hlatcu AK Governor of Alaska Governor Regular 8/21/18 Lost None None 1.5 No                            
7 Gerald Heikes AK Governor of Alaska Governor Regular 8/21/18 Lost None None 0.7 No                            
8 Steve Smith AZ U.S. House Arizona District 1 Representative Regular 8/28/18 Lost None None 37.8 No Yes             Yes     Yes      
9 Wendy Rogers AZ U.S. House Arizona District 1 Representative Regular 8/28/18 Advanced None On the Ballot 43.4 Yes Yes             No     No      
10 Tiffany Shedd AZ U.S. House Arizona District 1 Representative Regular 8/28/18 Lost None None 18.8 No Yes             No     No      
11 Lea Marquez Peterson AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Advanced None On the Ballot 33.6 Yes Yes               Yes          
12 Casey Welch AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 21.4 No No               No          
13 Danny Morales AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 15.9 No No               No          
14 Brandon Martin AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 29.1 No No               No          
15 Edna San Miguel AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Lost None None 21.4 No                            
16 Sergio Arellano AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Lost None None 27.3 No                            
17 Nicolas Pierson AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Advanced None On the Ballot 51.4 Yes                            
18 Debbie Lesko AZ U.S. House Arizona District 8 Representative Special 2/27/18 Advanced None On the Ballot 35.77 Yes             Yes   Yes Yes        
19 Bob Stump AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 5.37 No             No   No No        
20 Clair Van Steenwyk AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 2.37 No             No   No No        
21 Phil Lovas AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 23.88 No             No   No No        
22 Richard Mack AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.42 No             No   No No        
23 Stephen Dolgos AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 0.48 No             No   No No        
24 Steve Montenegro AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 23.82 No             No   No No        
25 Christopher Sylvester AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.92 No             No   No No        
26 David Lien AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.77 No             No   No No        
27 Chad Allen AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.05 No             No   No No        
28 Brenden Dilley AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.03 No             No   No No        
29 Mark Yates AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None 1.12 No             No   No No        
30 Dave Giles AZ U.S. House Arizona District 9 Representative Regular 8/28/18 Lost None None 33.3 No No                          
31 Steve Ferrara AZ U.S. House Arizona District 9 Representative Regular 8/28/18 Advanced None On the Ballot 58.9 Yes Yes                          
32 Irina Baroness Von Behr AZ U.S. House Arizona District 9 Representative Regular 8/28/18 Lost None None 7.8 No No                          
33 Joe Arpaio AZ U.S. Senate Arizona Senator Regular 8/28/18 Lost None None 18.9 No     No No         No          
34 Kelli Ward AZ U.S. Senate Arizona Senator Regular 8/28/18 Lost None None 28.1 No     Yes Yes         No          
35 Martha McSally AZ U.S. Senate Arizona Senator Regular 8/28/18 Advanced None On the Ballot 53.0 Yes     No No         Yes          
36 John Cox CA Governor of California Governor Regular 6/5/18 Advanced None On the Ballot 70.15 Yes   Yes       Yes                
37 Peter Yuan Liu CA Governor of California Governor Regular 6/5/18 Lost None None 1.08 No   No       No                
38 Robert Newman CA Governor of California Governor Regular 6/5/18 Lost None None 1.77 No   No       No                
39 Travis Allen CA Governor of California Governor Regular 6/5/18 Lost None None 26.15 No   No       No                
40 Yvonne Girard CA Governor of California Governor Regular 6/5/18 Lost None None 0.85 No   No       No                
41 John Fitzgerald CA U.S. House California District 11 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
42 Lisa Remmer CA U.S. House California District 12 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
43 Cristina Osme̱a CA U.S. House California District 14 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
44 Rudy Peters CA U.S. House California District 15 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
45 Elizabeth Heng CA U.S. House California District 16 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes Yes                          
46 Ron Cohen CA U.S. House California District 17 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
47 Christine Russell CA U.S. House California District 18 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
48 Dale Mensing CA U.S. House California District 2 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
49 Justin Fareed CA U.S. House California District 24 Representative Regular 6/5/18 Advanced None On the Ballot 78.37 Yes Yes       Yes                  
50 Michael Erin Woody CA U.S. House California District 24 Representative Regular 6/5/18 Lost None None 21.63 No No       No                  
51 Antonio Sabato Jr. CA U.S. House California District 26 Representative Regular 6/5/18 Advanced None On the Ballot 53.04 Yes                            
52 Jeffrey Burum CA U.S. House California District 26 Representative Regular 6/5/18 Lost None None 46.96 No                     Yes      
53 Johnny Nalbandian CA U.S. House California District 28 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
54 Benito Bernal CA U.S. House California District 29 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
55 Charlie Schaupp CA U.S. House California District 3 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes           Yes                
56 Mark Reed CA U.S. House California District 30 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
57 Sean Flynn CA U.S. House California District 31 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes Yes                          
58 Kenneth Wright CA U.S. House California District 33 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
59 Ron Bassilian CA U.S. House California District 34 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
60 Christian Valiente CA U.S. House California District 35 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
61 Kimberlin Brown Pelzer CA U.S. House California District 36 Representative Regular 6/5/18 Advanced None On the Ballot 51.61 Yes Yes           Yes              
62 Stephan Wolkowicz CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 10.41 No No           No              
63 Dan Ball CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 17.39 No No           No              
64 Doug Hassett CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 11.21 No No           No              
65 Robert Bentley CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 9.38 No No           No              
66 Ryan Downing CA U.S. House California District 38 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
67 Young Kim CA U.S. House California District 39 Representative Regular 6/5/18 Advanced None On the Ballot 39.79 Yes Yes           Yes       Yes Yes    
68 Bob Huff CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 11.53 No No           No       No No    
69 John Cullum CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.24 No No           No       No No    
70 Phil Liberatore CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 21.22 No No           No       No No    
71 Shawn Nelson CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 12.45 No Yes           No       No No    
72 Andrew Sarega CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 1.05 No No           No       No No    
73 Steve Vargas CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 5.29 No No           No       No No    
74 Aja Smith CA U.S. House California District 41 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
75 Omar Navarro CA U.S. House California District 43 Representative Regular 6/5/18 Advanced None On the Ballot 56.02 Yes                            
76 Frank DeMartini CA U.S. House California District 43 Representative Regular 6/5/18 Lost None None 27.54 No                            
77 Edwin Duterte CA U.S. House California District 43 Representative Regular 6/5/18 Lost None None 16.44 No                            
78 Jazmina Saavedra CA U.S. House California District 44 Representative Regular 6/5/18 Lost None None 58.53 No                            
79 Stacey Dash CA U.S. House California District 44 Representative Regular 6/5/18 Lost None None 41.47 No                            
80 Russell Lambert CA U.S. House California District 46 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
81 John Briscoe CA U.S. House California District 47 Representative Regular 6/5/18 Advanced None On the Ballot 54.48 Yes                            
82 David Clifford CA U.S. House California District 47 Representative Regular 6/5/18 Lost None None 45.52 No                            
83 Diane Harkey CA U.S. House California District 49 Representative Regular 6/5/18 Advanced None On the Ballot 52.93 Yes Yes                   Yes      
84 Kristin Gaspar CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 18.34 No Yes                   No      
85 Rocky ChÌÁvez CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 15.66 No Yes                   No      
86 Joshua Schoonover CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.55 No No                   No      
87 Brian Maryott CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 6.26 No No                   No      
88 Craig Nordal CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.31 No No                   No      
89 David Medway CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.22 No No                   No      
90 Mike Schmitt CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 2.72 No No                   No      
91 Juan Hidalgo CA U.S. House California District 51 Representative Regular 6/5/18 Advanced None On the Ballot 49.39 Yes                            
92 Louis Fuentes CA U.S. House California District 51 Representative Regular 6/5/18 Lost None None 53.9 No                            
93 John Renison Jr. CA U.S. House California District 51 Representative Regular 6/5/18 Lost None None 45.22 No                            
94 Omar Qudrat CA U.S. House California District 52 Representative Regular 6/5/18 Advanced None On the Ballot 37.28 Yes No                          
95 James Veltmeyer CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 27.81 No No                          
96 John Horst CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 8.25 No No                          
97 Danny Casara CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 11.2 No No                          
98 Michael Allman CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 9.57 No Yes                          
99 Jeff Cullen CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 5.88 No No                          
100 Morgan Murtaugh CA U.S. House California District 53 Representative Regular 6/5/18 Advanced None On the Ballot 42.73 Yes                            
101 Matt Mendoza CA U.S. House California District 53 Representative Regular 6/5/18 Lost None None 40.43 No                            
Powered by Datasette · Query took 6.151ms