Primary Candidates 2018: rep_candidates.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
8 rows where Race Primary Election Date = "9/12/18"
This data as json, copyable, CSV (advanced)
Suggested facets: District, Office Type, Primary Status, General Status, Won Primary, Susan B. Anthony 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? |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
585 | 585 | Giovanni Feroce | RI | Governor of Rhode Island | Governor | Regular | 9/12/18 | Lost | None | None | 3.5 | No | No | |||||||||||||
586 | 586 | Allan Fung | RI | Governor of Rhode Island | Governor | Regular | 9/12/18 | Advanced | None | On the Ballot | 56.4 | Yes | No | |||||||||||||
587 | 587 | Patricia Morgan | RI | Governor of Rhode Island | Governor | Regular | 9/12/18 | Lost | None | None | 40.1 | No | Yes | |||||||||||||
588 | 588 | Frederick Wysocki | RI | U.S. House Rhode Island District 1 | Representative | Regular | 9/12/18 | Lost | None | None | 21.6 | No | ||||||||||||||
589 | 589 | Patrick Donovan | RI | U.S. House Rhode Island District 1 | Representative | Regular | 9/12/18 | Advanced | None | On the Ballot | 78.4 | Yes | ||||||||||||||
590 | 590 | Salvatore Caiozzo | RI | U.S. House Rhode Island District 2 | Representative | Regular | 9/12/18 | Advanced | None | On the Ballot | 100.0 | Yes | ||||||||||||||
591 | 591 | Roque De La Fuente | RI | U.S. Senate Rhode Island | Senator | Regular | 9/12/18 | Lost | None | None | 12.3 | No | ||||||||||||||
592 | 592 | Robert Flanders Jr. | RI | U.S. Senate Rhode Island | Senator | Regular | 9/12/18 | Advanced | None | On the Ballot | 87.7 | 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 );