fivethirtyeight: primary-candidates-2018/rep_candidates: 245 rows where Won Primary = "Yes"

This table contains the data behind the stories:

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

245 rows where Won Primary = "Yes"

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
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
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
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
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
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
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
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
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
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
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
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
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
91	91	Juan Hidalgo	CA	U.S. House California District 51	Representative	Regular	6/5/18	Advanced	None	On the Ballot	49.39	Yes
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
100	100	Morgan Murtaugh	CA	U.S. House California District 53	Representative	Regular	6/5/18	Advanced	None	On the Ballot	42.73	Yes
104	104	Andrew Grant	CA	U.S. House California District 7	Representative	Regular	6/5/18	Advanced	None	On the Ballot	69.15	Yes	Yes												Yes
106	106	Marla Livengood	CA	U.S. House California District 9	Representative	Regular	6/5/18	Advanced	None	On the Ballot	100.0	Yes						Yes
118	118	Walker Stapleton	CO	Governor of Colorado	Governor	Regular	6/26/18	Advanced	None	On the Ballot	47.67	Yes
122	122	Casper Stockham	CO	U.S. House Colorado District 1	Representative	Regular	6/26/18	Advanced	None	On the Ballot	100.0	Yes
123	123	Peter Yu	CO	U.S. House Colorado District 2	Representative	Regular	6/26/18	Advanced	None	On the Ballot	100.0	Yes
124	124	Mark Barrington	CO	U.S. House Colorado District 7	Representative	Regular	6/26/18	Advanced	None	On the Ballot	100.0	Yes
125	125	Bob Stefanowski	CT	Governor of Connecticut	Governor	Regular	8/14/18	Advanced	None	On the Ballot	29.3	Yes
130	130	Jennifer Nye	CT	U.S. House Connecticut District 1	Representative	Regular	8/14/18	Advanced	None	On the Ballot	100.0	Yes
131	131	Dan Postemski	CT	U.S. House Connecticut District 2	Representative	Regular	8/14/18	Advanced	None	On the Ballot	100.0	Yes
132	132	Angel Cadena	CT	U.S. House Connecticut District 3	Representative	Regular	8/14/18	Advanced	None	On the Ballot	100.0	Yes
133	133	Harry Arora	CT	U.S. House Connecticut District 4	Representative	Regular	8/14/18	Advanced	None	On the Ballot	100.0	Yes
134	134	Manny Santos	CT	U.S. House Connecticut District 5	Representative	Regular	8/14/18	Advanced	None	On the Ballot	51.7	Yes
137	137	Matthew Corey	CT	U.S. Senate Connecticut	Senator	Regular	8/14/18	Advanced	None	On the Ballot	76.7	Yes
140	140	Scott Walker	DE	U.S. House Delaware At-large District	Representative	Regular	9/6/18	Advanced	None	On the Ballot	53.0	Yes
142	142	Robert Arlett	DE	U.S. Senate Delaware	Senator	Regular	9/6/18	Advanced	None	On the Ballot	66.8	Yes
145	145	Ron DeSantis	FL	Governor of Florida	Governor	Regular	8/28/18	Advanced	None	On the Ballot	56.5	Yes		Yes							Yes				No
152	152	George Buck	FL	U.S. House Florida District 13	Representative	Regular	8/28/18	Advanced	None	On the Ballot	56.0	Yes						Yes
155	155	Ross Spano	FL	U.S. House Florida District 15	Representative	Regular	8/28/18	Advanced	None	On the Ballot	43.7	Yes
160	160	Greg Steube	FL	U.S. House Florida District 17	Representative	Regular	8/28/18	Advanced	None	On the Ballot	62.4	Yes					Yes			Yes	Yes	Yes	Yes	No	No
163	163	Nicolas Kimaz	FL	U.S. House Florida District 22	Representative	Regular	8/28/18	Advanced	None	On the Ballot	41.0	Yes						No
167	167	Joe Kaufman	FL	U.S. House Florida District 23	Representative	Regular	8/28/18	Advanced	None	On the Ballot	44.7	Yes
174	174	Maria Elvira Salazar	FL	U.S. House Florida District 27	Representative	Regular	8/28/18	Advanced	None	On the Ballot	40.5	Yes	Yes					No						Yes
178	178	Virginia Fuller	FL	U.S. House Florida District 5	Representative	Regular	8/28/18	Advanced	None	On the Ballot	100.0	Yes
181	181	Michael Waltz	FL	U.S. House Florida District 6	Representative	Regular	8/28/18	Advanced	None	On the Ballot	42.4	Yes						No
182	182	Mike Miller	FL	U.S. House Florida District 7	Representative	Regular	8/28/18	Advanced	None	On the Ballot	53.9	Yes	Yes					No						Yes
185	185	Wayne Liebnitzky	FL	U.S. House Florida District 9	Representative	Regular	8/28/18	Advanced	None	On the Ballot	100.0	Yes
186	186	Rick Scott	FL	U.S. Senate Florida	Senator	Regular	8/28/18	Advanced	None	On the Ballot	88.6	Yes		Yes				Yes		Yes	Yes				Yes
188	188	Brian Kemp	GA	Governor of Georgia	Governor	Regular	5/22/18	Advanced	Advanced	On the Ballot	25.55	Yes		Yes			No	No
194	194	David Callahan	GA	U.S. House Georgia District 13	Representative	Regular	5/22/18	Advanced	None	On the Ballot	93.0	Yes						Yes
196	196	Herman West Jr.	GA	U.S. House Georgia District 2	Representative	Regular	5/22/18	Advanced	None	On the Ballot	100.0	Yes
197	197	Joe Profit	GA	U.S. House Georgia District 4	Representative	Regular	5/22/18	Advanced	None	On the Ballot	100.0	Yes
198	198	Andria Tupola	HI	Governor of Hawaii	Governor	Regular	8/11/18	Advanced	None	On the Ballot	55.5	Yes
201	201	Cam Cavasso	HI	U.S. House Hawaii District 1	Representative	Regular	8/11/18	Advanced	None	On the Ballot	81.8	Yes
203	203	Brian Evans	HI	U.S. House Hawaii District 2	Representative	Regular	8/11/18	Advanced	None	On the Ballot	100.0	Yes
204	204	Ron Curtis	HI	U.S. Senate Hawaii	Senator	Regular	8/11/18	Advanced	None	On the Ballot	23.7	Yes
212	212	Chris Peters	IA	U.S. House Iowa District 2	Representative	Regular	6/5/18	Advanced	None	On the Ballot	100.0	Yes
213	213	Brad Little	ID	Governor of Idaho	Governor	Regular	5/15/18	Advanced	None	On the Ballot	37.29	Yes
220	220	Russ Fulcher	ID	U.S. House Idaho District 1	Representative	Regular	5/15/18	Advanced	None	On the Ballot	43.12	Yes								Yes		Yes		No
227	227	Jimmy Lee Tillman II	IL	U.S. House Illinois District 1	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
228	228	Doug Bennett	IL	U.S. House Illinois District 10	Representative	Regular	3/20/18	Advanced	None	On the Ballot	36.24	Yes	Yes
231	231	Nick Stella	IL	U.S. House Illinois District 11	Representative	Regular	3/20/18	Advanced	None	On the Ballot	79.33	Yes
233	233	Bill Fawell	IL	U.S. House Illinois District 17	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
234	234	David Merkle	IL	U.S. House Illinois District 2	Representative	Regular	3/20/18	Advanced	None	On the Ballot	36.59	Yes
237	237	Arthur Jones	IL	U.S. House Illinois District 3	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
238	238	Mark Wayne Lorch	IL	U.S. House Illinois District 4	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
239	239	Tom Hanson	IL	U.S. House Illinois District 5	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
240	240	Craig Cameron	IL	U.S. House Illinois District 7	Representative	Regular	3/20/18	Advanced	None	On the Ballot	56.33	Yes
242	242	Jitendra Diganvker	IL	U.S. House Illinois District 8	Representative	Regular	3/20/18	Advanced	None	On the Ballot	100.0	Yes
243	243	John Elleson	IL	U.S. House Illinois District 9	Representative	Regular	3/20/18	Advanced	None	On the Ballot	40.37	Yes
247	247	Mark Leyva	IN	U.S. House Indiana District 1	Representative	Regular	5/8/18	Advanced	None	On the Ballot	26.99	Yes
253	253	Jim Baird	IN	U.S. House Indiana District 4	Representative	Regular	5/8/18	Advanced	None	On the Ballot	36.59	Yes						Yes								No
260	260	Greg Pence	IN	U.S. House Indiana District 6	Representative	Regular	5/8/18	Advanced	None	On the Ballot	64.48	Yes				Yes		Yes
265	265	Wayne Harmon	IN	U.S. House Indiana District 7	Representative	Regular	5/8/18	Advanced	None	On the Ballot	28.81	Yes						No
271	271	Mike Braun	IN	U.S. Senate Indiana	Senator	Regular	5/8/18	Advanced	None	On the Ballot	41.17	Yes						Yes
278	278	Steve Watkins	KS	U.S. House Kansas District 2	Representative	Regular	8/7/18	Advanced	None	On the Ballot	26.2	Yes	Yes					No	No
281	281	Vickie Yates Glisson	KY	U.S. House Kentucky District 3	Representative	Regular	5/22/18	Advanced	None	On the Ballot	49.06	Yes	Yes					Yes
284	284	Liz Matory	MD	U.S. House Maryland District 2	Representative	Regular	6/26/18	Advanced	None	On the Ballot	42.01	Yes						Yes
288	288	Charles Anthony	MD	U.S. House Maryland District 3	Representative	Regular	6/26/18	Advanced	None	On the Ballot	43.59	Yes						No
291	291	George McDermott	MD	U.S. House Maryland District 4	Representative	Regular	6/26/18	Advanced	None	On the Ballot	100.0	Yes
292	292	William Devine III	MD	U.S. House Maryland District 5	Representative	Regular	6/26/18	Advanced	None	On the Ballot	57.56	Yes
294	294	Amie Hoeber	MD	U.S. House Maryland District 6	Representative	Regular	6/26/18	Advanced	None	On the Ballot	67.76	Yes	Yes					No
302	302	John Walsh	MD	U.S. House Maryland District 8	Representative	Regular	6/26/18	Advanced	None	On the Ballot	44.87	Yes
305	305	Tony Campbell	MD	U.S. Senate Maryland	Senator	Regular	6/26/18	Advanced	None	On the Ballot	29.22	Yes						Yes

Advanced export

JSON shape: default, array, newline-delimited

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
);

Primary Candidates 2018: rep_candidates.csv

Updates

245 rows where Won Primary = "Yes"

Advanced export