home / fivethirtyeight

Menu
  • GraphQL API

Primary Candidates 2018: rep_candidates.csv

Table actions
  • GraphQL API for primary-candidates-2018/rep_candidates

This table contains the data behind the stories:

  • We Researched Hundreds Of Races. Here’s Who Democrats Are Nominating.
  • How’s The Progressive Wing Doing In Democratic Primaries So Far?
  • We Looked At Hundreds Of Endorsements. Here’s Who Republicans Are Listening To.

This project looks at patterns in open Democratic and Republican primary elections for the U.S. Senate, U.S. House and governor in 2018.

dem_candidates.csv contains information about the 811 candidates who have appeared on the ballot this year in Democratic primaries for Senate, House and governor, not counting races featuring a Democratic incumbent, as of August 7, 2018.

rep_candidates.csv contains information about the 774 candidates who have appeared on the ballot this year in Republican primaries for Senate, House and governor, not counting races featuring a Republican incumbent, through September 13, 2018.

Here is a description and source for each column in the accompanying datasets.

dem_candidates.csv and rep_candidates.csv include:

Column Description
Candidate All candidates who received votes in 2018’s Democratic primary elections for U.S. Senate, U.S. House and governor in which no incumbent ran. Supplied by Ballotpedia.
State The state in which the candidate ran. Supplied by Ballotpedia.
District The office and, if applicable, congressional district number for which the candidate ran. Supplied by Ballotpedia.
Office Type The office for which the candidate ran. Supplied by Ballotpedia.
Race Type Whether it was a “regular” or “special” election. Supplied by Ballotpedia.
Race Primary Election Date The date on which the primary was held. Supplied by Ballotpedia.
Primary Status Whether the candidate lost (“Lost”) the primary or won/advanced to a runoff (“Advanced”). Supplied by Ballotpedia.
Primary Runoff Status “None” if there was no runoff; “On the Ballot” if the candidate advanced to a runoff but it hasn’t been held yet; “Advanced” if the candidate won the runoff; “Lost” if the candidate lost the runoff. Supplied by Ballotpedia.
General Status “On the Ballot” if the candidate won the primary or runoff and has advanced to November; otherwise, “None.” Supplied by Ballotpedia.
Primary % The percentage of the vote received by the candidate in his or her primary. In states that hold runoff elections, we looked only at the first round (the regular primary). In states that hold all-party primaries (e.g., California), a candidate’s primary percentage is the percentage of the total Democratic vote they received. Unopposed candidates and candidates nominated by convention (not primary) are given a primary percentage of 100 but were excluded from our analysis involving vote share. Numbers come from official results posted by the secretary of state or local elections authority; if those were unavailable, we used unofficial election results from the New York Times.
Won Primary “Yes” if the candidate won his or her primary and has advanced to November; “No” if he or she lost.

dem_candidates.csv includes:

Column Description
Partisan Lean The FiveThirtyEight partisan lean of the district or state in which the election was held. Partisan leans are calculated by finding the average difference between how a state or district voted in the past two presidential elections and how the country voted overall, with 2016 results weighted 75 percent and 2012 results weighted 25 percent.
Race “White” if we identified the candidate as non-Hispanic white; “Nonwhite” if we identified the candidate as Hispanic and/or any nonwhite race; blank if we could not identify the candidate’s race or ethnicity. To determine race and ethnicity, we checked each candidate’s website to see if he or she identified as a certain race. If not, we spent no more than two minutes searching online news reports for references to the candidate’s race.
Veteran? If the candidate’s website says that he or she served in the armed forces, we put “Yes.” If the website is silent on the subject (or explicitly says he or she didn’t serve), we put “No.” If the field was left blank, no website was available.
LGBTQ? If the candidate’s website says that he or she is LGBTQ (including indirect references like to a same-sex partner), we put “Yes.” If the website is silent on the subject (or explicitly says he or she is straight), we put “No.” If the field was left blank, no website was available.
Elected Official? We used Ballotpedia, VoteSmart and news reports to research whether the candidate had ever held elected office before, at any level. We put “Yes” if the candidate has held elected office before and “No” if not.
Self-Funder? We used Federal Election Committee fundraising data (for federal candidates) and state campaign-finance data (for gubernatorial candidates) to look up how much each candidate had invested in his or her own campaign, through either donations or loans. We put “Yes” if the candidate donated or loaned a cumulative $400,000 or more to his or her own campaign before the primary and “No” for all other candidates.
STEM? If the candidate identifies on his or her website that he or she has a background in the fields of science, technology, engineering or mathematics, we put “Yes.” If not, we put “No.” If the field was left blank, no website was available.
Obama Alum? We put “Yes” if the candidate mentions working for the Obama administration or campaign on his or her website, or if the candidate shows up on this list of Obama administration members and campaign hands running for office. If not, we put “No.”
Dem Party Support? “Yes” if the candidate was placed on the DCCC’s Red to Blue list before the primary, was endorsed by the DSCC before the primary, or if the DSCC/DCCC aired pre-primary ads in support of the candidate. (Note: according to the DGA’s press secretary, the DGA does not get involved in primaries.) “No” if the candidate is running against someone for whom one of the above things is true, or if one of those groups specifically anti-endorsed or spent money to attack the candidate. If those groups simply did not weigh in on the race, we left the cell blank.
Emily Endorsed? “Yes” if the candidate was endorsed by Emily’s List before the primary. “No” if the candidate is running against an Emily-endorsed candidate or if Emily’s List specifically anti-endorsed or spent money to attack the candidate. If Emily’s List simply did not weigh in on the race, we left the cell blank.
Gun Sense Candidate? “Yes” if the candidate received the Gun Sense Candidate Distinction from Moms Demand Action/Everytown for Gun Safety before the primary, according to media reports or the candidate’s website. “No” if the candidate is running against an candidate with the distinction. If Moms Demand Action simply did not weigh in on the race, we left the cell blank.
Biden Endorsed? “Yes” if the candidate was endorsed by Joe Biden before the primary. “No” if the candidate is running against a Biden-endorsed candidate or if Biden specifically anti-endorsed the candidate. If Biden simply did not weigh in on the race, we left the cell blank.
Warren Endorsed? “Yes” if the candidate was endorsed by Elizabeth Warren before the primary. “No” if the candidate is running against a Warren-endorsed candidate or if Warren specifically anti-endorsed the candidate. If Warren simply did not weigh in on the race, we left the cell blank.
Sanders Endorsed? “Yes” if the candidate was endorsed by Bernie Sanders before the primary. “No” if the candidate is running against a Sanders-endorsed candidate or if Sanders specifically anti-endorsed the candidate. If Sanders simply did not weigh in on the race, we left the cell blank.
Our Revolution Endorsed? “Yes” if the candidate was endorsed by Our Revolution before the primary, according to the Our Revolution website. “No” if the candidate is running against an Our Revolution-endorsed candidate or if Our Revolution specifically anti-endorsed or spent money to attack the candidate. If Our Revolution simply did not weigh in on the race, we left the cell blank.
Justice Dems Endorsed? “Yes” if the candidate was endorsed by Justice Democrats before the primary, according to the Justice Democrats website, candidate website or news reports. “No” if the candidate is running against a Justice Democrats-endorsed candidate or if Justice Democrats specifically anti-endorsed or spent money to attack the candidate. If Justice Democrats simply did not weigh in on the race, we left the cell blank.
PCCC Endorsed? “Yes” if the candidate was endorsed by the Progressive Change Campaign Committee before the primary, according to the PCCC website, candidate website or news reports. “No” if the candidate is running against a PCCC-endorsed candidate or if the PCCC specifically anti-endorsed or spent money to attack the candidate. If the PCCC simply did not weigh in on the race, we left the cell blank.
Indivisible Endorsed? “Yes” if the candidate was endorsed by Indivisible before the primary, according to the Indivisible website, candidate website or news reports. “No” if the candidate is running against an Indivisible-endorsed candidate or if Indivisible specifically anti-endorsed or spent money to attack the candidate. If Indivisible simply did not weigh in on the race, we left the cell blank.
WFP Endorsed? “Yes” if the candidate was endorsed by the Working Families Party before the primary, according to the WFP website, candidate website or news reports. “No” if the candidate is running against a WFP-endorsed candidate or if the WFP specifically anti-endorsed or spent money to attack the candidate. If the WFP simply did not weigh in on the race, we left the cell blank.
VoteVets Endorsed? “Yes” if the candidate was endorsed by VoteVets before the primary, according to the VoteVets website, candidate website or news reports. “No” if the candidate is running against a VoteVets-endorsed candidate or if VoteVets specifically anti-endorsed or spent money to attack the candidate. If VoteVets simply did not weigh in on the race, we left the cell blank.
No Labels Support? “Yes” if a No Labels-affiliated group (Citizens for a Strong America Inc., Forward Not Back, Govern or Go Home, United for Progress Inc. or United Together) spent money in support of the candidate in the primary. “No” if the candidate is running against an candidate supported by a No Labels-affiliated group or if a No Labels-affiliated group specifically anti-endorsed or spent money to attack the candidate. If No Labels simply did not weigh in on the race, we left the cell blank.

rep_candidates.csv includes:

Column Description
Rep Party Support? “Yes” if the candidate was named to the NRCC’s Young Guns list (any tier) before the primary, was endorsed by the NRSC before the primary, was endorsed by the RGA before the primary or if the Senate Leadership Fund or Congressional Leadership Fund made independent expenditures in support of the candidate in the primary. “No” if the candidate is running against someone for whom one of the above things is true, or if one of those groups specifically anti-endorsed or spent money to attack the candidate. If those groups simply did not weigh in on the race, we left the cell blank.
Trump Endorsed? “Yes” if the candidate was endorsed by President Trump before the primary. “No” if the candidate is running against a Trump-endorsed candidate or if Trump specifically anti-endorsed the candidate. If Trump simply did not weigh in on the race, we left the cell blank.
Bannon Endorsed? “Yes” if the candidate was endorsed by Steve Bannon before the primary. “No” if the candidate is running against a Bannon-endorsed candidate or if Bannon specifically anti-endorsed the candidate. If Bannon simply did not weigh in on the race, we left the cell blank.
Great America Endorsed? “Yes” if the candidate was endorsed by the Great America Alliance before the primary, according to the Great America Alliance website, candidate website or news reports, or if Great America PAC spent money in the primary on the candidate’s behalf. “No” if the candidate is running against a Great America-endorsed candidate or if Great America specifically anti-endorsed or spent money to attack the candidate. If Great America simply did not weigh in on the race, we left the cell blank.
NRA Endorsed? “Yes” if the candidate was endorsed by the National Rifle Association before the primary, according to the NRA website, candidate website or news reports, or if the NRA made independent expenditures in the primary on the candidate’s behalf. “No” if the candidate is running against an NRA-endorsed candidate or if the NRA specifically anti-endorsed or spent money to attack the candidate. If the NRA simply did not weigh in on the race, we left the cell blank.
Right to Life Endorsed? “Yes” if the candidate was endorsed by the National Right to Life Committee or a local affiliate before the primary, according to the organization’s website, candidate website or news reports. “No” if the candidate is running against a Right to Life-endorsed candidate(s) or if Right to Life specifically anti-endorsed or spent money to attack the candidate. If Right to Life simply did not weigh in on the race, we left the cell blank.
Susan B. Anthony Endorsed? “Yes” if the candidate was endorsed by Susan B. Anthony List before the primary, according to the SBA List website, candidate website or news reports. “No” if the candidate is running against a SBA List-endorsed candidate or if SBA List specifically anti-endorsed or spent money to attack the candidate. If SBA List simply did not weigh in on the race, we left the cell blank.
Club for Growth Endorsed? “Yes” if the candidate was endorsed by the Club for Growth before the primary, according to the Club for Growth website, candidate website or news reports, or if Club for Growth Action made independent expenditures in the primary on the candidate’s behalf. “No” if the candidate is running against a Club for Growth-endorsed candidate or if the Club for Growth specifically anti-endorsed or spent money to attack the candidate. If the Club for Growth simply did not weigh in on the race, we left the cell blank.
Koch Support? “Yes” if the candidate was supported by the Koch brothers’ political network in the primary. This could include an endorsement from David or Charles Koch, financial support from groups like Americans for Prosperity (including a state affiliate), Freedom Partners Action Fund or KochPAC or an endorsement from one of those groups. “No” if the candidate is running against a Koch-endorsed candidate or if the Koch brothers’ political network specifically anti-endorsed or spent money to attack the candidate. If the Koch brothers’ political network simply did not weigh in on the race, we left the cell blank.
House Freedom Support? “Yes” if the candidate was supported by the House Freedom Fund in the primary. This could include an endorsement, a donation or an independent expenditure on the candidate’s behalf. “No” if the candidate is running against a House Freedom Fund-endorsed candidate or if the House Freedom Fund specifically anti-endorsed or spent money to attack the candidate. If the House Freedom Fund simply did not weigh in on the race, we left the cell blank.
Tea Party Endorsed? “Yes” if the candidate was endorsed by the Tea Party Express before the primary, according to the Tea Party Express website, candidate website or news reports. “No” if the candidate is running against a Tea Party Express-endorsed candidate or if Tea Party Express specifically anti-endorsed or spent money to attack the candidate. If Tea Party Express simply did not weigh in on the race, we left the cell blank.
Main Street Endorsed? “Yes” if the candidate was endorsed by the Republican Main Street Partnership before the primary, according to the candidate website or news reports. “No” if the candidate is running against a Main Street-endorsed candidate or if Main Street specifically anti-endorsed or spent money to attack the candidate. If Main Street simply did not weigh in on the race, we left the cell blank.
Chamber Endorsed? “Yes” if the candidate was endorsed by the U.S. Chamber of Commerce or a state-level chamber of commerce before the primary, according to the candidate website or news reports, or if the national or state chamber of commerce made independent expenditures for the candidate during the primary. “No” if the candidate is running against a Chamber of Commerce-endorsed candidate or if the Chamber of Commerce specifically anti-endorsed or spent money to attack the candidate. If the Chamber of Commerce simply did not weigh in on the race, we left the cell blank.

Updates

  • Post data for elections through Aug 7, 2018. [commit]
  • Fix record for David Trone. [commit]
  • Add new columns and update and added the result in Washington's 8th Congressional District (called Aug. 13). [commit]
  • Add Republican Candidates. [commit]

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

774 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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 1 Mike Dunleavy AK Governor of Alaska Governor Regular 8/21/18 Advanced None On the Ballot 61.8 Yes                            
2 2 Michael Sheldon AK Governor of Alaska Governor Regular 8/21/18 Lost None None 2.2 No                            
3 3 Mead Treadwell AK Governor of Alaska Governor Regular 8/21/18 Lost None None 31.9 No                            
4 4 Darin Colbry AK Governor of Alaska Governor Regular 8/21/18 Lost None None 0.6 No                            
5 5 Thomas Gordon AK Governor of Alaska Governor Regular 8/21/18 Lost None None 1.3 No                            
6 6 Merica Hlatcu AK Governor of Alaska Governor Regular 8/21/18 Lost None None 1.5 No                            
7 7 Gerald Heikes AK Governor of Alaska Governor Regular 8/21/18 Lost None None 0.7 No                            
8 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 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 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 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 12 Casey Welch AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 21.4 No No               No          
13 13 Danny Morales AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 15.9 No No               No          
14 14 Brandon Martin AZ U.S. House Arizona District 2 Representative Regular 8/28/18 Lost None None 29.1 No No               No          
15 15 Edna San Miguel AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Lost None None 21.4 No                            
16 16 Sergio Arellano AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Lost None None 27.3 No                            
17 17 Nicolas Pierson AZ U.S. House Arizona District 3 Representative Regular 8/28/18 Advanced None On the Ballot 51.4 Yes                            
18 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 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 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 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 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 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 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 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 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 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 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 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 30 Dave Giles AZ U.S. House Arizona District 9 Representative Regular 8/28/18 Lost None None 33.3 No No                          
31 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 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 33 Joe Arpaio AZ U.S. Senate Arizona Senator Regular 8/28/18 Lost None None 18.9 No     No No         No          
34 34 Kelli Ward AZ U.S. Senate Arizona Senator Regular 8/28/18 Lost None None 28.1 No     Yes Yes         No          
35 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 36 John Cox CA Governor of California Governor Regular 6/5/18 Advanced None On the Ballot 70.15 Yes   Yes       Yes                
37 37 Peter Yuan Liu CA Governor of California Governor Regular 6/5/18 Lost None None 1.08 No   No       No                
38 38 Robert Newman CA Governor of California Governor Regular 6/5/18 Lost None None 1.77 No   No       No                
39 39 Travis Allen CA Governor of California Governor Regular 6/5/18 Lost None None 26.15 No   No       No                
40 40 Yvonne Girard CA Governor of California Governor Regular 6/5/18 Lost None None 0.85 No   No       No                
41 41 John Fitzgerald CA U.S. House California District 11 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
42 42 Lisa Remmer CA U.S. House California District 12 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
43 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 44 Rudy Peters CA U.S. House California District 15 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
45 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 46 Ron Cohen CA U.S. House California District 17 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
47 47 Christine Russell CA U.S. House California District 18 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
48 48 Dale Mensing CA U.S. House California District 2 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
49 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 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 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 52 Jeffrey Burum CA U.S. House California District 26 Representative Regular 6/5/18 Lost None None 46.96 No                     Yes      
53 53 Johnny Nalbandian CA U.S. House California District 28 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
54 54 Benito Bernal CA U.S. House California District 29 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
55 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 56 Mark Reed CA U.S. House California District 30 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
57 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 58 Kenneth Wright CA U.S. House California District 33 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
59 59 Ron Bassilian CA U.S. House California District 34 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
60 60 Christian Valiente CA U.S. House California District 35 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
61 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 62 Stephan Wolkowicz CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 10.41 No No           No              
63 63 Dan Ball CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 17.39 No No           No              
64 64 Doug Hassett CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 11.21 No No           No              
65 65 Robert Bentley CA U.S. House California District 36 Representative Regular 6/5/18 Lost None None 9.38 No No           No              
66 66 Ryan Downing CA U.S. House California District 38 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
67 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 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 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 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 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 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 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 74 Aja Smith CA U.S. House California District 41 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
75 75 Omar Navarro CA U.S. House California District 43 Representative Regular 6/5/18 Advanced None On the Ballot 56.02 Yes                            
76 76 Frank DeMartini CA U.S. House California District 43 Representative Regular 6/5/18 Lost None None 27.54 No                            
77 77 Edwin Duterte CA U.S. House California District 43 Representative Regular 6/5/18 Lost None None 16.44 No                            
78 78 Jazmina Saavedra CA U.S. House California District 44 Representative Regular 6/5/18 Lost None None 58.53 No                            
79 79 Stacey Dash CA U.S. House California District 44 Representative Regular 6/5/18 Lost None None 41.47 No                            
80 80 Russell Lambert CA U.S. House California District 46 Representative Regular 6/5/18 Advanced None On the Ballot 100.0 Yes                            
81 81 John Briscoe CA U.S. House California District 47 Representative Regular 6/5/18 Advanced None On the Ballot 54.48 Yes                            
82 82 David Clifford CA U.S. House California District 47 Representative Regular 6/5/18 Lost None None 45.52 No                            
83 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 84 Kristin Gaspar CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 18.34 No Yes                   No      
85 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 86 Joshua Schoonover CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.55 No No                   No      
87 87 Brian Maryott CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 6.26 No No                   No      
88 88 Craig Nordal CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.31 No No                   No      
89 89 David Medway CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.22 No No                   No      
90 90 Mike Schmitt CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 2.72 No No                   No      
91 91 Juan Hidalgo CA U.S. House California District 51 Representative Regular 6/5/18 Advanced None On the Ballot 49.39 Yes                            
92 92 Louis Fuentes CA U.S. House California District 51 Representative Regular 6/5/18 Lost None None 53.9 No                            
93 93 John Renison Jr. CA U.S. House California District 51 Representative Regular 6/5/18 Lost None None 45.22 No                            
94 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 95 James Veltmeyer CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 27.81 No No                          
96 96 John Horst CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 8.25 No No                          
97 97 Danny Casara CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 11.2 No No                          
98 98 Michael Allman CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 9.57 No Yes                          
99 99 Jeff Cullen CA U.S. House California District 52 Representative Regular 6/5/18 Lost None None 5.88 No No                          
100 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 · Queries took 1893.185ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette