615 rows sorted by Category

View and edit SQL

Suggested facets: Party, Category

Link rowid Member Party District Congress Resignation Date Reason Source Category ▼
5 Tim Murphy R PA-18 115th 10/21/2017 Extramarital affair/abortion hypocrisy POLITICO A
41 Anthony Weiner D NY-09 112th 6/21/2011 Extramarital affair/sexting New York Times A
43 John Ensign R NV-SEN 112th 5/3/2011 Ethics investigation into extramarital affair Washington Post A
45 Chris Lee R NY-26 112th 2/9/2011 Extramarital affair/shirtless photo ABC News A
47 Mark Souder R IN-03 111th 5/21/2010 Extramarital affair Washington Post A
91 Bob Livingston R LA-01 106th 3/1/1999 Extramarital affairs New York Times A
151 Jon Hinson R MS-04 97th 4/13/1981 Extramarital affair (same-sex) Zimbio A
200 Wayne Hays D OH-18 94th 9/1/1976 Extramarital affair/paying his mistress a salary New York Times A
15 Ed Whitfield R KY-01 114th 9/6/2016 Ethics investigation Kentucky Center for Investigative Reporting B
16 Chaka Fattah D PA-02 114th 6/23/2016 Corruption conviction POLITICO B
18 Aaron Schock R IL-18 114th 3/31/2015 Personal spending of government funds POLITICO B
19 Michael Grimm R NY-11 114th 1/5/2015 Tax evasion CNN B
24 Trey Radel R FL-19 113th 1/27/2014 Cocaine possession USA Today B
70 Bob Ney R OH-18 109th 11/3/2006 Pleaded guilty to Abramoff influence-peddling scandal Associated Press B
72 Tom DeLay R TX-22 109th 6/9/2006 Campaign finance laundering & Abramoff scandal involvement New York Times B
75 Duke Cunningham R CA-50 109th 12/1/2005 Bribery and tax evasion San Diego Union-Tribune B
81 Bill Janklow R SD-AL 108th 1/20/2004 Convicted of manslaughter for a fatal car accident Minnesota Public Radio B
86 James Traficant D OH-17 107th 7/24/2002 Convicted of bribery, tax evasion, and racketeering CNN B
104 Walter Tucker III D CA-37 104th 12/15/1995 Convicted of extortion and tax evasion New York Times B
129 Robert Garcia D NY-18 101st 1/7/1990 Convicted of extortion New York Times B
131 Jim Wright D TX-12 101st 6/30/1989 Ethics investigation into personal financial gain Washington Post B
132 Tony Coelho D CA-15 101st 6/15/1989 Personal finances under investigation New York Times B
136 Mario Biaggi D NY-19 100th 8/8/1988 Convicted twice of corruption New York Times B
148 Fred Richmond D NY-14 97th 8/25/1982 Tax evasion, drug possession, campaign-finance irregularities UPI B
150 Raymond Lederer D PA-03 97th 4/29/1981 Bribery and conspiracy in Abscam scandal Associated Press B
152 Pete Williams D NJ-SEN 97th 3/11/1981 Bribery and conspiracy in Abscam scandal New York Times B
158 Frank Thompson D NJ-04 96th 12/29/1980 Bribery and conspiracy in Abscam scandal New York Times B
159 John Jenrette D SC-06 96th 12/10/1980 Bribery and conspiracy in Abscam scandal UPI B
160 Michael Myers D PA-01 96th 10/2/1980 Bribery in Abscam scandal UPI B
161 Charles Diggs Jr. D MI-13 96th 6/3/1980 Censured for mail fraud and kickbacks from staff U.S. House of Representatives B
164 Dan Flood D PA-11 96th 1/31/1980 Bribery and conspiracy UPI B
189 Richard Tonry D LA-01 95th 5/4/1977 Federal inquiry into voter fraud & illegal campaign contributions Roll Call B
344 J. Parnell Thomas R NJ-07 81st 1/2/1950 Convicted of fraud New York Observer B
482 John Langley R KY-10 69th 1/11/1926 Convicted of violating Prohibition laws Lexington Herald-Leader B
492 Truman Newberry R MI-SEN 67th 11/18/1922 Faced a vigorous election challenge due to his unethical campaign U.S. Senate B
532 Orrin Bleakley R PA-28 65th 4/3/1917 Convicted of spending too much money on his campaign PoliticsPA B
547 James McDermott D IL-04 63rd 7/21/1914 Implicated in lobbying scandal, resigned to avoid expulsion Sacramento Union B
591 Joseph Burton R KS-SEN 59th 6/4/1906 Convicted of corruption U.S. Senate B
48 Nathan Deal R GA-09 111th 3/21/2010 To focus on his run for governor; ethics investigation CREW B & C
22 Rob Andrews D NJ-01 113th 2/18/2014 Ethics investigation; took a job as a lobbyist Philadelphia Inquirer B & D
34 Jesse Jackson Jr. D IL-02 112th 11/21/2012 Bipolar disorder; under criminal investigation New York Times B & E
80 Frank Ballance D NC-01 108th 6/11/2004 Ill health; fraud and money laundering Associated Press B & E
90 Bud Shuster R PA-09 107th 2/5/2001 Ethics rebuke; "health scares" ABC News B & E
210 Ed Gurney R FL-SEN 93rd 12/31/1974 Retired; might've left early for pension, seniority, or indictment Orlando Sentinel B & G
7 Ryan Zinke R MT-AL 115th 3/1/2017 Appointed to Trump administration Bozeman Daily Chronicle C
8 Mick Mulvaney R SC-05 115th 2/16/2017 Appointed to Trump administration Associated Press C
9 Tom Price R GA-06 115th 2/10/2017 Appointed to Trump administration GeorgiaPol C
10 Jeff Sessions R AL-SEN 115th 2/8/2017 Appointed to Trump administration Washington Examiner C
11 Xavier Becerra D CA-34 115th 1/24/2017 Appointed California attorney general Los Angeles Times C
12 Mike Pompeo R KS-04 115th 1/23/2017 Appointed to Trump administration NBC News C
13 Candice Miller R MI-10 114th 12/31/2016 Elected Macomb County public works commish Detroit News C
14 Janice Hahn D CA-44 114th 12/4/2016 Elected to LA County Board of Supervisors Los Angeles Times C
23 Max Baucus D MT-SEN 113th 2/6/2014 Appointed to Obama administration The Missoulian C
25 Mel Watt D NC-12 113th 1/6/2014 Appointed to Obama administration Camel City Dispatch C
26 Rodney Alexander R LA-05 113th 9/27/2013 Appointed Louisiana VA secretary Roll Call C
28 Ed Markey D MA-05 113th 7/15/2013 Elected U.S. senator Boston Globe C
29 John Kerry D MA-SEN 113th 2/1/2013 Appointed to Obama administration Boston Globe C
31 Tim Scott R SC-01 112th 1/2/2013 Appointed U.S. senator U.S. House of Representatives C
33 Bob Filner D CA-51 112th 12/3/2012 Elected San Diego mayor USA Today C
38 Jay Inslee D WA-01 112th 3/20/2012 To focus on his run for governor Roll Call C
42 Dean Heller R NV-02 112th 5/9/2011 Appointed U.S. senator Las Vegas Sun C
46 Mark Kirk R IL-10 111th 11/29/2010 Elected U.S. senator Associated Press C
50 Neil Abercrombie D HI-01 111th 2/28/2010 To focus on his run for governor NPR C
52 John McHugh R NY-23 111th 9/21/2009 Appointed to Obama administration New York Times C
54 Ellen Tauscher D CA-10 111th 6/26/2009 Appointed to Obama administration KNTV C
55 Hilda Solis D CA-32 111th 2/24/2009 Appointed to Obama administration Associated Press C
56 Kirsten Gillibrand D NY-20 111th 1/26/2009 Appointed U.S. senator New York Daily News C
57 Hillary Clinton D NY-SEN 111th 1/21/2009 Appointed to Obama administration CNN C
58 Ken Salazar D CO-SEN 111th 1/20/2009 Appointed to Obama administration Denver Post C
59 Joe Biden D DE-SEN 111th 1/15/2009 Elected vice president CNN C
60 Rahm Emanuel D IL-05 110th 1/2/2009 Appointed to Obama administration CNN C
62 Barack Obama D IL-SEN 110th 11/16/2008 Elected president CNN C
65 Bobby Jindal R LA-01 110th 1/14/2008 Elected Louisiana governor Reuters C
66 Roger Wicker R MS-01 110th 12/31/2007 Appointed U.S. senator The Guardian C
73 Jon Corzine D NJ-SEN 109th 1/17/2006 Elected New Jersey governor U.S. Congress C
74 Bob Menendez D NJ-13 109th 1/16/2006 Appointed U.S. senator New York Times C
76 Christopher Cox R CA-48 109th 8/2/2005 Appointed to Bush administration Securities & Exchange Commission C
77 Rob Portman R OH-02 109th 4/29/2005 Appointed to Bush administration New York Times C
78 Porter Goss R FL-14 108th 9/23/2004 Appointed to Bush administration CQ Almanac C
82 Ernie Fletcher R KY-06 108th 12/8/2003 Elected Kentucky governor Fletcher/Pence Inaugural C
84 Frank Murkowski R AK-SEN 107th 12/2/2002 Elected Alaska governor U.S. Congress C
85 Tony Hall D OH-03 107th 9/9/2002 Appointed to Bush administration New York Times C
87 Steve Largent R OK-01 107th 2/15/2002 To focus on his run for governor The Oklahoman C
89 Asa Hutchinson R AR-03 107th 8/6/2001 Appointed to Bush administration Log Cabin Democrat C
95 Thomas Foglietta D PA-01 105th 11/11/1997 Appointed to Clinton administration Associated Press C
97 Bill Richardson D NM-03 105th 2/13/1997 Appointed to Clinton administration San Francisco Chronicle C
98 Ray Thornton D AR-02 104th 1/1/1997 Elected Arkansas Supreme Court justice U.S. Congress C
99 Sam Brownback R KS-02 104th 11/7/1996 Elected U.S. senator U.S. House of Representatives C
101 Bob Dole R KS-SEN 104th 6/11/1996 To focus on his run for president U.S. Congress C
103 Ron Wyden D OR-03 104th 2/5/1996 Elected U.S. senator U.S. Congress C
109 Jim Inhofe R OK-01 103rd 11/15/1994 Elected U.S. senator U.S. Congress C
112 Mike Espy D MS-02 103rd 1/22/1993 Appointed to Clinton administration Washington Post C
113 Leon Panetta D CA-17 103rd 1/21/1993 Appointed to Clinton administration Washington Post C
114 Lloyd Bentsen D TX-SEN 103rd 1/20/1993 Appointed to Clinton administration New York Times C
115 Les Aspin D WI-01 103rd 1/20/1993 Appointed to Clinton administration U.S. Congress C
116 Al Gore Jr. D TN-SEN 102nd 1/2/1993 Elected vice president CQ Almanac C
118 Kent Conrad D ND-SEN 102nd 12/14/1992 Elected to North Dakota's other U.S. Senate seat U.S. Senate C
122 Steve Bartlett R TX-03 102nd 3/11/1991 To focus on his run for Dallas mayor D Magazine C
123 Ed Madigan R IL-15 102nd 3/8/1991 Appointed to Bush administration U.S. Congress C
124 Pete Wilson R CA-SEN 102nd 1/7/1991 Elected California governor U.S. Congress C

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "congress-resignations/congressional_resignations" (
"Member" TEXT,
  "Party" TEXT,
  "District" TEXT,
  "Congress" TEXT,
  "Resignation Date" TEXT,
  "Reason" TEXT,
  "Source" TEXT,
  "Category" TEXT
Powered by Datasette · Query took 37.36ms