primary-candidates-2018/rep_candidates

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

774 rows

View and edit SQL

Suggested facets: Office Type, Race Type, Race Primary Election Date, Primary Status, Primary Runoff Status, General Status, Won Primary, Rep 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?

Link rowid ▼ Candidate State District Office Type Race Type Race Primary Election Date Primary Status Primary Runoff Status General Status Primary % Won Primary Rep 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                            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "primary-candidates-2018/rep_candidates" (
"Candidate" TEXT,
  "State" TEXT,
  "District" TEXT,
  "Office Type" TEXT,
  "Race Type" TEXT,
  "Race Primary Election Date" TEXT,
  "Primary Status" TEXT,
  "Primary Runoff Status" TEXT,
  "General Status" TEXT,
  "Primary %" REAL,
  "Won Primary" TEXT,
  "Rep Party Support?" TEXT,
  "Trump Endorsed?" TEXT,
  "Bannon Endorsed?" TEXT,
  "Great America Endorsed?" TEXT,
  "NRA Endorsed?" TEXT,
  "Right to Life Endorsed?" TEXT,
  "Susan B. Anthony Endorsed?" TEXT,
  "Club for Growth Endorsed?" TEXT,
  "Koch Support?" TEXT,
  "House Freedom Support?" TEXT,
  "Tea Party Endorsed?" TEXT,
  "Main Street Endorsed?" TEXT,
  "Chamber Endorsed?" TEXT,
  "No Labels Support?" TEXT
);
Powered by Datasette · Query took 88.127ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub