home / fivethirtyeight

Menu
  • GraphQL API

Primary Candidates 2018: dem_candidates.csv

Table actions
  • GraphQL API for primary-candidates-2018/dem_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

811 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, Race, Veteran?, LGBTQ?, Elected Official?, Self-Funder?, STEM?, Obama Alum?, Party Support?, Emily Endorsed?, Guns Sense Candidate?, Biden Endorsed?, Warren Endorsed? , Sanders Endorsed?, Our Revolution Endorsed?, Justice Dems Endorsed?, PCCC Endorsed?, Indivisible Endorsed?, WFP Endorsed?, VoteVets Endorsed?, No Labels Support?

Link rowid ▼ Candidate State District Office Type Race Type Race Primary Election Date Primary Status Primary Runoff Status General Status Partisan Lean Primary % Won Primary Race Veteran? LGBTQ? Elected Official? Self-Funder? STEM? Obama Alum? Party Support? Emily Endorsed? Guns Sense Candidate? Biden Endorsed? Warren Endorsed? Sanders Endorsed? Our Revolution Endorsed? Justice Dems Endorsed? PCCC Endorsed? Indivisible Endorsed? WFP Endorsed? VoteVets Endorsed? No Labels Support?
1 1 Anthony White (Alabama) AL Governor of Alabama Governor Regular 6/5/18 Lost None None -28.879999 3.4200001 No Nonwhite Yes No No No No No     No                    
2 2 Christopher Countryman AL Governor of Alabama Governor Regular 6/5/18 Lost None None -28.879999 1.74 No White No Yes No No No No     No                    
3 3 Doug "New Blue" Smith AL Governor of Alabama Governor Regular 6/5/18 Lost None None -28.879999 3.27 No White Yes No No No No No     No                    
4 4 James C. Fields AL Governor of Alabama Governor Regular 6/5/18 Lost None None -28.879999 8.0 No Nonwhite Yes No Yes No No No     No                    
5 5 Sue Bell Cobb AL Governor of Alabama Governor Regular 6/5/18 Lost None None -28.879999 28.98 No White No No Yes No No No     No                    
6 6 Walt Maddox AL Governor of Alabama Governor Regular 6/5/18 Advanced None On the Ballot -28.879999 54.599998 Yes White No No Yes No No No     Yes                    
7 7 Lizzetta Hill McConnell AL U.S. House Alabama District 1 Representative Regular 6/5/18 Lost None None -30.68 19.23 No Nonwhite No No No No Yes No                          
8 8 Robert Kennedy Jr. AL U.S. House Alabama District 1 Representative Regular 6/5/18 Advanced None On the Ballot -30.68 80.769997 Yes Nonwhite Yes No No No No No                          
9 9 Audri Scott Williams AL U.S. House Alabama District 2 Representative Regular 6/5/18 Lost None None -33.080002 39.560001 No Nonwhite Yes No No No No No                          
10 10 Tabitha Isner AL U.S. House Alabama District 2 Representative Regular 6/5/18 Advanced None On the Ballot -33.080002 60.439999 Yes White No No No No No No                          
11 11 Adia McClellan Winfrey AL U.S. House Alabama District 3 Representative Regular 6/5/18 Lost None None -33.66 34.240002 No Nonwhite No No No No Yes No     Yes                    
12 12 Mallory Hagan AL U.S. House Alabama District 3 Representative Regular 6/5/18 Advanced None On the Ballot -33.66 65.739998 Yes White No No No No No No     Yes                    
13 13 Lee Auman AL U.S. House Alabama District 4 Representative Regular 6/5/18 Advanced None On the Ballot -62.48 54.130001 Yes White No No No No No No     Yes                    
14 14 Rick Neighbors AL U.S. House Alabama District 4 Representative Regular 6/5/18 Lost None None -62.48 45.869999 No White Yes No No No No No     No                    
15 15 Peter Joffrion AL U.S. House Alabama District 5 Representative Regular 6/5/18 Advanced None On the Ballot -34.830002 100.0 Yes White No No No No No No                   Yes      
16 16 Danner Kline AL U.S. House Alabama District 6 Representative Regular 6/5/18 Advanced None On the Ballot -48.459999 100.0 Yes White No No No No No No     Yes                    
17 17 Jared Henderson AR Governor of Arkansas Governor Regular 5/22/18 Advanced None On the Ballot -28.639999 63.299999 Yes White No No No No Yes No                          
18 18 Leticia Sanders AR Governor of Arkansas Governor Regular 5/22/18 Lost None None -28.639999 36.700001 No Nonwhite No No No No No No                          
19 19 Chintan Desai AR U.S. House Arkansas District 1 Representative Regular 5/22/18 Advanced None On the Ballot -34.810001 100.0 Yes Nonwhite No No No No No No     Yes             Yes      
20 20 Clarke Tucker AR U.S. House Arkansas District 2 Representative Regular 5/22/18 Advanced None On the Ballot -13.51 57.82 Yes White No No Yes No No No Yes   Yes                    
21 21 Gwen Combs AR U.S. House Arkansas District 2 Representative Regular 5/22/18 Lost None None -13.51 20.299999 No White Yes No No No No No No   Yes                    
22 22 Jonathan Dunkley AR U.S. House Arkansas District 2 Representative Regular 5/22/18 Lost None None -13.51 9.3400002 No Nonwhite No No No No No No No   No                    
23 23 Paul Spencer AR U.S. House Arkansas District 2 Representative Regular 5/22/18 Lost None None -13.51 12.55 No White No No No No No No No   No                    
24 24 Joshua Mahony AR U.S. House Arkansas District 3 Representative Regular 5/22/18 Advanced None On the Ballot -34.560001 100.0 Yes White No No No No No No                   Yes      
25 25 Hayden Shamel AR U.S. House Arkansas District 4 Representative Regular 5/22/18 Advanced None On the Ballot -33.68 100.0 Yes White No No No No No No                          
26 26 Brianna Westbrook AZ U.S. House Arizona District 8 Representative Special 2/27/18 Lost None None -24.559999 39.720001 No White No Yes No No No No             Yes Yes          
27 27 Hiral Tipirneni AZ U.S. House Arizona District 8 Representative Special 2/27/18 Advanced None On the Ballot -24.559999 60.220001 Yes Nonwhite No No No No Yes No             No No          
28 28 Akinyemi Agbede CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.22 No Nonwhite No No No No Yes No     No       No            
29 29 Albert Caesar Mezzetti CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.28 No White Yes No Yes No No No     No       No            
30 30 Amanda Renteria CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 2.1500001 No Nonwhite No No No No No No     No       No            
31 31 Antonio Villaraigosa CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 21.290001 No Nonwhite No No Yes No No No     No       No            
32 32 Delaine Eastin CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 5.4000001 No White No No Yes No No No     Yes       Yes            
33 33 Gavin Newsom CA Governor of California Governor Regular 6/5/18 Advanced None On the Ballot 25.83 53.869999 Yes White No No Yes No No No     Yes       No            
34 34 John Chiang CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 15.08 No Nonwhite No No Yes No Yes No     Yes       No            
35 35 Juan Bribiesca CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.40000001 No Nonwhite No No No No Yes No     No       No            
36 36 Klement Tinaj CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.12 No Nonwhite No No No No No No     No       No            
37 37 Michael Shellenberger CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.73000002 No White No No No No No No     No       No            
38 38 Robert Davidson Griffis CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.25999999 No White No No No No No No     No       No            
39 39 Thomas Jefferson Cares CA Governor of California Governor Regular 6/5/18 Lost None None 25.83 0.20999999 No White No No No No Yes No     No       No            
40 40 Audrey Denney CA U.S. House California District 1 Representative Regular 6/5/18 Advanced None On the Ballot -21.379999 43.650002 Yes White No No No No No No             Yes Yes   No      
41 41 David Peterson CA U.S. House California District 1 Representative Regular 6/5/18 Lost None None -21.379999 7.3000002 No White No No No No No No             No No   No      
42 42 Jessica Holcombe CA U.S. House California District 1 Representative Regular 6/5/18 Lost None None -21.379999 28.540001 No White No No No No No No             No No   No      
43 43 Marty Walters CA U.S. House California District 1 Representative Regular 6/5/18 Lost None None -21.379999 20.51 No White No No No No No No             No No   Yes      
44 44 Dotty Nygard CA U.S. House California District 10 Representative Regular 6/5/18 Lost None None 0.62 1.89 No White No No No No Yes No No No No       Yes Yes   No      
45 45 Josh Harder CA U.S. House California District 10 Representative Regular 6/5/18 Advanced None On the Ballot 0.62 35.57 Yes White No No No No Yes No Yes No Yes       No No   No      
46 46 Michael Eggman CA U.S. House California District 10 Representative Regular 6/5/18 Lost None None 0.62 21.34 No White No No No No No No No No No       No No   No      
47 47 Mike Barkley CA U.S. House California District 10 Representative Regular 6/5/18 Lost None None 0.62 4.98 No White Yes No No No Yes No No No No       No No   No      
48 48 Sue Zwahlen CA U.S. House California District 10 Representative Regular 6/5/18 Lost None None 0.62 17.049999 No White No No Yes No Yes No No No No       No No   No      
49 49 Virginia Madueno CA U.S. House California District 10 Representative Regular 6/5/18 Lost None None 0.62 19.17 No Nonwhite No No Yes No No No No Yes Yes       No No   Yes      
50 50 TJ Cox CA U.S. House California District 21 Representative Regular 6/5/18 Advanced None On the Ballot 11.87 100.0 Yes Nonwhite No No No No Yes No Yes No                      
51 51 Andrew Janz CA U.S. House California District 22 Representative Regular 6/5/18 Advanced None On the Ballot -13.41 78.830002 Yes Nonwhite No No No No No No                          
52 52 Bobby Bliatout CA U.S. House California District 22 Representative Regular 6/5/18 Lost None None -13.41 12.26 No Nonwhite No No No No No No                          
53 53 Ricardo Franco CA U.S. House California District 22 Representative Regular 6/5/18 Lost None None -13.41 8.9099998 No Nonwhite No No No No Yes No                          
54 54 Kurtis Wilson CA U.S. House California District 23 Representative Regular 6/5/18 Lost None None -25.379999 4.8400002 No Nonwhite No No No No No No                          
55 55 Mary Helen Barro CA U.S. House California District 23 Representative Regular 6/5/18 Lost None None -25.379999 18.200001 No Nonwhite No No No No No No                          
56 56 Tatiana Matta CA U.S. House California District 23 Representative Regular 6/5/18 Advanced None On the Ballot -25.379999 42.720001 Yes Nonwhite No No No No No No                          
57 57 Wendy Reed CA U.S. House California District 23 Representative Regular 6/5/18 Lost None None -25.379999 34.25 No White No No No No No No                          
58 58 Bryan Caforio CA U.S. House California District 25 Representative Regular 6/5/18 Lost None None 2.02 38.259998 No White No No No No No No No No Yes       No Yes          
59 59 Jess Phoenix CA U.S. House California District 25 Representative Regular 6/5/18 Lost None None 2.02 13.24 No White No No No No Yes No No No Yes       Yes No          
60 60 Katie Hill CA U.S. House California District 25 Representative Regular 6/5/18 Advanced None On the Ballot 2.02 42.970001 Yes White No Yes No No No No Yes Yes Yes       No No          
61 61 Mary Pallant CA U.S. House California District 25 Representative Regular 6/5/18 Lost None None 2.02 5.54 No White No No No No No No No No         No No          
62 62 Andy Thorburn CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.99 20.440001 No White No No No Yes No No No No Yes       Yes     No   No  
63 63 Gil Cisneros CA U.S. House California District 39 Representative Regular 6/5/18 Advanced None On the Ballot 2.99 43.23 Yes Nonwhite Yes No No Yes No No Yes No Yes       No     No   Yes  
64 64 Herbert Lee CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.99 9.4200001 No Nonwhite No No No Yes Yes No No No No       No     No   No  
65 65 Mai Khanh Tran CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.99 11.69 No Nonwhite No No No Yes Yes No No Yes Yes       No     No   No  
66 66 Sam Jammal CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.99 11.98 No Nonwhite No No No No No Yes No No Yes       No     Yes   No  
67 67 Suzi Park Leggett CA U.S. House California District 39 Representative Regular 6/5/18 Lost None None 2.99 3.24 No Nonwhite No No No No No No No No No       No     No   No  
68 68 Jessica Morse CA U.S. House California District 4 Representative Regular 6/5/18 Advanced None On the Ballot -18.16 49.099998 Yes White No No No No No No     Yes       No No   Yes      
69 69 Regina Bateson CA U.S. House California District 4 Representative Regular 6/5/18 Lost None None -18.16 30.07 No White No No No No No No     Yes       No No   No      
70 70 Robert Lawton CA U.S. House California District 4 Representative Regular 6/5/18 Lost None None -18.16 5.25 No White No No No No No No     No       No No   No      
71 71 Roza Calderon CA U.S. House California District 4 Representative Regular 6/5/18 Lost None None -18.16 15.57 No Nonwhite No No No No Yes No     Yes       Yes Yes   No      
72 72 Julia Peacock CA U.S. House California District 42 Representative Regular 6/5/18 Advanced None On the Ballot -15.31 76.019997 Yes White No No No No No No     Yes             Yes      
73 73 Norman Quintero CA U.S. House California District 42 Representative Regular 6/5/18 Lost None None -15.31 23.98 No Nonwhite No No No No No No     No             No      
74 74 Brian Forde CA U.S. House California District 45 Representative Regular 6/5/18 Lost None None -1.4299999 13.06 No White No No No No Yes Yes No No Yes   No   No   No        
75 75 Dave Min CA U.S. House California District 45 Representative Regular 6/5/18 Lost None None -1.4299999 38.740002 No Nonwhite No No No No No No No No Yes   No   No   No        
76 76 Katie Porter CA U.S. House California District 45 Representative Regular 6/5/18 Advanced None On the Ballot -1.4299999 44.040001 Yes White No No No No No No Yes Yes Yes   Yes   Yes   Yes        
77 77 Kia Hamadanchy CA U.S. House California District 45 Representative Regular 6/5/18 Lost None None -1.4299999 4.1500001 No Nonwhite No No No No No No No No Yes   No   Yes   No        
78 78 Deanie Schaarsmith CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 1.79 No White No No No No No No No No No         No   No      
79 79 Hans Keirstead CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 37.439999 No White No No No Yes Yes No No No Yes         No   No      
80 80 Harley Rouda CA U.S. House California District 48 Representative Regular 6/5/18 Advanced None On the Ballot -4.1799998 37.599998 Yes White No No No Yes No No Yes No Yes         No   Yes      
81 81 Laura Oatman CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 3.01 No White No No No No Yes No No No No         Yes   No      
82 82 Michael Kotick CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 3.26 No White No No No No No No No No No         No   No      
83 83 Omar Siddiqui CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 10.81 No Nonwhite No No No Yes Yes No No No Yes         No   No      
84 84 Rachel Payne CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 4.4899998 No White No No No No Yes No No Yes No         No   No      
85 85 Tony Zarkades CA U.S. House California District 48 Representative Regular 6/5/18 Lost None None -4.1799998 1.6 No White Yes No No No Yes No No No No         No   No      
86 86 Douglas Applegate CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.42 25.76 No White Yes No No No No No No No           Yes No     Yes  
87 87 Mike Levin CA U.S. House California District 49 Representative Regular 6/5/18 Advanced None On the Ballot 1.42 34.400002 Yes White No No No No No No Yes No           No Yes     No  
88 88 Paul Kerr CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.42 8.75 No White Yes No No Yes No No No No           No No     No  
89 89 Sara Jacobs CA U.S. House California District 49 Representative Regular 6/5/18 Lost None None 1.42 31.09 No White No No No Yes No Yes No Yes           No No     No  
90 90 Ammar Campa-Najjar CA U.S. House California District 50 Representative Regular 6/5/18 Advanced None On the Ballot -19.48 48.360001 Yes Nonwhite No No No No No Yes               Yes Yes Yes      
91 91 Josh Butner CA U.S. House California District 50 Representative Regular 6/5/18 Lost None None -19.48 35.509998 No White Yes No No No No No               No No No   Yes  
92 92 Patrick Malloy CA U.S. House California District 50 Representative Regular 6/5/18 Lost None None -19.48 16.129999 No White No No No No No No               No No No      
93 93 Marge Doyle CA U.S. House California District 8 Representative Regular 6/5/18 Lost None   -17.33 59.610001   White No Yes No No Yes No                          
94 94 Rita Ramirez CA U.S. House California District 8 Representative Regular 6/5/18 Lost None   -17.33 27.67   Nonwhite No No No No No No                          
95 95 Ronald O'Donnell CA U.S. House California District 8 Representative Regular 6/5/18 Lost None   -17.33 12.71   White No No No No No No                          
96 96 Cary Kennedy CO Governor of Colorado Governor Regular 6/26/18 Lost None None 2.49 24.719999 No White No No Yes No No No   Yes Yes                    
97 97 Donna Lynne CO Governor of Colorado Governor Regular 6/26/18 Lost None None 2.49 7.2800002 No White No No Yes No No No   No No                    
98 98 Jared Polis CO Governor of Colorado Governor Regular 6/26/18 Advanced None On the Ballot 2.49 44.43 Yes White No Yes Yes Yes No No   No No                    
99 99 Michael Johnston CO Governor of Colorado Governor Regular 6/26/18 Lost None None 2.49 23.57 No White No No Yes No No Yes   No No                    
100 100 Joe Neguse CO U.S. House Colorado District 2 Representative Regular 6/26/18 Advanced None On the Ballot 18.040001 65.82 Yes Nonwhite No No No No No No                          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "primary-candidates-2018/dem_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,
  "Partisan Lean" REAL,
  "Primary %" REAL,
  "Won Primary" TEXT,
  "Race" TEXT,
  "Veteran?" TEXT,
  "LGBTQ?" TEXT,
  "Elected Official?" TEXT,
  "Self-Funder?" TEXT,
  "STEM?" TEXT,
  "Obama Alum?" TEXT,
  "Party Support?" TEXT,
  "Emily Endorsed?" TEXT,
  "Guns Sense Candidate?" TEXT,
  "Biden Endorsed?" TEXT,
  "Warren Endorsed? " TEXT,
  "Sanders Endorsed?" TEXT,
  "Our Revolution Endorsed?" TEXT,
  "Justice Dems Endorsed?" TEXT,
  "PCCC Endorsed?" TEXT,
  "Indivisible Endorsed?" TEXT,
  "WFP Endorsed?" TEXT,
  "VoteVets Endorsed?" TEXT,
  "No Labels Support?" TEXT
);
Powered by Datasette · Queries took 2065.841ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette