Primary Candidates 2018: rep_candidates.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
54 rows where Trump Endorsed? = "No"
This data as json, copyable, CSV (advanced)
Suggested facets: State, District, Office Type, Race Primary Election Date, Primary Status, Primary Runoff Status, General Status, Won Primary, NRA Endorsed?, Right to Life Endorsed?, Tea Party Endorsed?, Chamber Endorsed?
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? |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
146 | 146 | Don Baldauf | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 0.8 | No | No | No | No | No | ||||||||||
147 | 147 | Bob White | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 2.0 | No | No | No | No | No | ||||||||||
148 | 148 | Adam Putnam | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 36.6 | No | No | No | Yes | |||||||||||
149 | 149 | Timothy Devine | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 1.3 | No | No | No | No | No | ||||||||||
150 | 150 | Bob Langford | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 1.2 | No | No | No | No | No | ||||||||||
151 | 151 | John Joseph Mercadante | FL | Governor of Florida | Governor | Regular | 8/28/18 | Lost | None | None | 0.7 | No | No | No | No | No | ||||||||||
187 | 187 | Roque De La Fuente | FL | U.S. Senate Florida | Senator | Regular | 8/28/18 | Lost | None | None | 11.4 | No | No | No | No | No | No | |||||||||
189 | 189 | Casey Cagle | GA | Governor of Georgia | Governor | Regular | 5/22/18 | Advanced | Lost | None | 39.01 | No | No | Yes | No | |||||||||||
190 | 190 | Hunter Hill | GA | Governor of Georgia | Governor | Regular | 5/22/18 | Lost | None | None | 18.35 | No | No | No | Yes | |||||||||||
191 | 191 | Michael Williams | GA | Governor of Georgia | Governor | Regular | 5/22/18 | Lost | None | None | 4.88 | No | No | No | No | |||||||||||
192 | 192 | Clay Tippins | GA | Governor of Georgia | Governor | Regular | 5/22/18 | Lost | None | None | 12.21 | No | No | No | No | |||||||||||
193 | 193 | Eddie Hayes | GA | Governor of Georgia | Governor | Regular | 5/22/18 | Lost | None | None | 0.0 | No | No | No | No | |||||||||||
331 | 331 | Jim Hines | MI | Governor of Michigan | Governor | Regular | 8/7/18 | Lost | None | None | 11.0 | No | No | Yes | No | No | ||||||||||
332 | 332 | Brian Calley | MI | Governor of Michigan | Governor | Regular | 8/7/18 | Lost | None | None | 25.2 | No | No | Yes | No | No | ||||||||||
333 | 333 | Patrick Colbeck | MI | Governor of Michigan | Governor | Regular | 8/7/18 | Lost | None | None | 13.1 | No | No | Yes | No | No | ||||||||||
345 | 345 | Sandy Pensler | MI | U.S. Senate Michigan | Senator | Regular | 8/7/18 | Lost | None | None | 45.3 | No | No | No | No | No | ||||||||||
360 | 360 | Harry Welty | MN | U.S. House Minnesota District 8 | Representative | Regular | 8/14/18 | Lost | None | None | 10.3 | No | No | No | No | |||||||||||
374 | 374 | Austin Petersen | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 8.3 | No | No | No | No | No | No | No | ||||||||
376 | 376 | Tony Monetti | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 9.8 | No | No | No | No | No | No | No | ||||||||
377 | 377 | Courtland Sykes | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 2.1 | No | No | No | No | No | No | No | ||||||||
378 | 378 | Brian Hagg | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 1.0 | No | No | No | No | No | No | No | ||||||||
379 | 379 | Ken Patterson | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 2.9 | No | No | No | No | No | No | No | ||||||||
380 | 380 | Peter Pfeifer | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 2.5 | No | No | No | No | No | No | No | ||||||||
381 | 381 | Christina Smith | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 5.3 | No | No | No | No | No | No | No | ||||||||
382 | 382 | Bradley Krembs | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 0.7 | No | No | No | No | No | No | No | ||||||||
383 | 383 | Kristi Nichols | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 7.5 | No | No | No | No | No | No | No | ||||||||
384 | 384 | Fred Ryman | MO | U.S. Senate Missouri | Senator | Regular | 8/7/18 | Lost | None | None | 1.3 | No | No | No | No | No | No | No | ||||||||
405 | 405 | Thomas O'Neill | ND | U.S. Senate North Dakota | Senator | Regular | 6/12/18 | Lost | None | None | 12.13 | No | No | No | ||||||||||||
446 | 446 | Dan Schwartz | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 9.09 | No | No | No | No | |||||||||||
447 | 447 | Frederick Conquest | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 0.54 | No | No | No | No | |||||||||||
448 | 448 | Stephanie Carlisle | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 4.5 | No | No | No | No | |||||||||||
449 | 449 | Jared Fisher | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 4.71 | No | No | No | No | |||||||||||
450 | 450 | Bill Boyd | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 4.24 | No | No | No | No | |||||||||||
451 | 451 | Edward Dundas | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 0.41 | No | No | No | No | |||||||||||
452 | 452 | Stan Lusak | NV | Governor of Nevada | Governor | Regular | 6/12/18 | Lost | None | None | 0.71 | No | No | No | No | |||||||||||
517 | 517 | Don Eckhart | OH | U.S. Senate Ohio | Senator | Regular | 5/8/18 | Lost | None | None | 3.88 | No | No | No | No | No | No | |||||||||
518 | 518 | Mike Gibbons | OH | U.S. Senate Ohio | Senator | Regular | 5/8/18 | Lost | None | None | 31.69 | No | No | No | No | No | Yes | |||||||||
519 | 519 | Melissa Ackison | OH | U.S. Senate Ohio | Senator | Regular | 5/8/18 | Lost | None | None | 13.09 | No | No | No | No | No | No | |||||||||
520 | 520 | Dan Kiley | OH | U.S. Senate Ohio | Senator | Regular | 5/8/18 | Lost | None | None | 3.99 | No | No | No | No | No | No | |||||||||
635 | 635 | Aaron Pettigrew | TN | U.S. Senate Tennessee | Senator | Regular | 8/2/18 | Lost | None | None | 15.5 | No | No | No | No | No | No | No | ||||||||
704 | 704 | Mike Kennedy | UT | U.S. Senate Utah | Senator | Regular | 6/26/18 | Lost | None | None | 28.73 | No | No | |||||||||||||
751 | 751 | Bo Copley | WV | U.S. Senate West Virginia | Senator | Regular | 5/8/18 | Lost | None | None | 3.09 | No | No | No | No | No | No | No | ||||||||
752 | 752 | Jack Newbrough | WV | U.S. Senate West Virginia | Senator | Regular | 5/8/18 | Lost | None | None | 2.99 | No | No | No | No | No | No | No | ||||||||
753 | 753 | Don Blankenship | WV | U.S. Senate West Virginia | Senator | Regular | 5/8/18 | Lost | None | None | 19.97 | No | No | No | No | No | No | No | ||||||||
754 | 754 | Tom Willis | WV | U.S. Senate West Virginia | Senator | Regular | 5/8/18 | Lost | None | None | 9.84 | No | No | No | No | No | No | No | ||||||||
769 | 769 | Mark Gordon | WY | Governor of Wyoming | Governor | Regular | 8/21/18 | Advanced | None | On the Ballot | 33.4 | Yes | No | No | ||||||||||||
770 | 770 | Bill Dahlin | WY | Governor of Wyoming | Governor | Regular | 8/21/18 | Lost | None | None | 1.5 | No | No | No | ||||||||||||
771 | 771 | Harriet Hageman | WY | Governor of Wyoming | Governor | Regular | 8/21/18 | Lost | None | None | 21.5 | No | No | Yes | ||||||||||||
772 | 772 | Sam Galeotos | WY | Governor of Wyoming | Governor | Regular | 8/21/18 | Lost | None | None | 12.5 | No | No | Yes | ||||||||||||
774 | 774 | Taylor Haynes | WY | Governor of Wyoming | Governor | Regular | 8/21/18 | Lost | None | None | 5.6 | No | No | 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 );