Explore: Member Search

Search Congress members by name with stock trade, speech, and bill counts.

Custom SQL query returning 50 rows (hide)

SELECT cm.bioguide_id, cm.full_name, cm.party, cm.state, cm.chamber, cm.is_current, cm.first_served, cm.last_served, COALESCE(ms.trade_count, 0) AS trade_count, COALESCE(ms.speech_count, 0) AS speech_count, COALESCE(ms.bills_sponsored, 0) AS bills_sponsored FROM congress_members cm LEFT JOIN member_stats ms ON ms.bioguide_id = cm.bioguide_id WHERE cm.full_name LIKE '%' || :name || '%' ORDER BY cm.is_current DESC, trade_count DESC LIMIT 50

Query parameters

name

Edit SQL

This data as json, CSV

bioguide_id	full_name	party	state	chamber	is_current	first_served	last_served	trade_count	speech_count	bills_sponsored
G000583	Josh Gottheimer	Democrat	NJ	House	1	2017-01-03	2027-01-03	3609	201	208
C001123	Gilbert Ray Cisneros, Jr.	Democrat	CA	House	1	2019-01-03	2027-01-03	2757	82	33
T000278	Tommy Tuberville	Republican	AL	Senate	1	2021-01-03	2027-01-03	1632	555	78
M001136	Lisa C. McClain	Republican	MI	House	1	2021-01-03	2027-01-03	1434	284	71
F000462	Lois Frankel	Democrat	FL	House	1	2013-01-03	2027-01-03	1351	464	94
G000599	Daniel S. Goldman	Democrat	NY	House	1	2023-01-03	2027-01-03	1307	95	66
L000590	Susie Lee	Democrat	NV	House	1	2019-01-03	2027-01-03	1293	168	94
W000802	Sheldon Whitehouse	Democrat	RI	Senate	1	2007-01-04	2031-01-03	1037	2457	503
H001082	Kevin Hern	Republican	OK	House	1	2018-11-13	2027-01-03	1035	153	68
B001292	Donald S. Beyer, Jr.	Democrat	VA	House	1	2015-01-06	2027-01-03	981	351	241
F000450	Virginia Foxx	Republican	NC	House	1	2005-01-04	2027-01-03	928	2124	228
P000608	Scott H. Peters	Democrat	CA	House	1	2013-01-03	2027-01-03	856	222	223
S001201	Thomas R. Suozzi	Democrat	NY	House	1	2017-01-03	2027-01-03	750	159	83
C001047	Shelley Moore Capito	Republican	WV	Senate	1	2001-01-03	2027-01-03	746	1081	294
D000617	Suzan K. DelBene	Democrat	WA	House	1	2012-11-13	2027-01-03	726	237	143
A000383	Alan Armstrong	Republican	OK	Senate	1	2026-03-24	2027-01-03	707	13	2
B001327	Robert P. Bresnahan, Jr.	Republican	PA	House	1	2025-01-03	2027-01-03	654	35	22
C001035	Susan M. Collins	Republican	ME	Senate	1	1997-01-07	2027-01-03	637	3288	695
S001229	Jefferson Shreve	Republican	IN	House	1	2025-01-03	2027-01-03	636	40	19
C001101	Katherine M. Clark	Democrat	MA	House	1	2013-12-12	2027-01-03	600	219	80
J000310	Julie Johnson	Democrat	TX	House	1	2025-01-03	2027-01-03	587	41	27
M001232	April McClain Delaney	Democrat	MD	House	1	2025-01-03	2027-01-03	486	0	30
B001236	John Boozman	Republican	AR	Senate	1	2001-11-29	2029-01-03	483	1447	247
M001217	Jared Moskowitz	Democrat	FL	House	1	2023-01-03	2027-01-03	466	88	37
L000397	Zoe Lofgren	Democrat	CA	House	1	1995-01-04	2027-01-03	463	1263	350
S001217	Rick Scott	Republican	FL	Senate	1	2019-01-08	2031-01-03	415	559	476
M001243	David McCormick	Republican	PA	Senate	1	2025-01-03	2031-01-03	413	65	47
S000250	Pete Sessions	Republican	TX	House	1	1997-01-07	2027-01-03	403	1229	402
H001094	Val T. Hoyle	Democrat	OR	House	1	2023-01-03	2027-01-03	393	122	26
C001114	John R. Curtis	Republican	UT	Senate	1	2017-11-13	2031-01-03	363	150	192
C001080	Judy Chu	Democrat	CA	House	1	2009-07-16	2027-01-03	349	595	255
R000609	John H. Rutherford	Republican	FL	House	1	2017-01-03	2027-01-03	348	254	48
W000779	Ron Wyden	Democrat	OR	Senate	1	1981-01-05	2029-01-03	322	3640	1218
F000246	Pat Fallon	Republican	TX	House	1	2021-01-03	2027-01-03	321	319	60
A000372	Rick W. Allen	Republican	GA	House	1	2015-01-06	2027-01-03	313	430	62
M000934	Jerry Moran	Republican	KS	Senate	1	1997-01-07	2029-01-03	286	1622	485
W000804	Robert J. Wittman	Republican	VA	House	1	2007-12-13	2027-01-03	280	742	196
J000307	John James	Republican	MI	House	1	2023-01-03	2027-01-03	274	50	63
F000472	Scott Franklin	Republican	FL	House	1	2021-01-03	2027-01-03	267	67	47
B001325	Sheri Biggs	Republican	SC	House	1	2025-01-03	2027-01-03	265	28	16
P000609	Gary J. Palmer	Republican	AL	House	1	2015-01-06	2027-01-03	260	134	98
L000595	Julia Letlow	Republican	LA	House	1	2021-04-14	2027-01-03	257	49	32
F000110	Cleo Fields	Democrat	LA	House	1	1993-01-05	2027-01-03	238	167	17
M001236	Tim Moore	Republican	NC	House	1	2025-01-03	2027-01-03	237	45	32
T000490	David J. Taylor	Republican	OH	House	1	2025-01-03	2027-01-03	231	53	37
H001061	John Hoeven	Republican	ND	Senate	1	2011-01-05	2029-01-03	225	779	216
P000197	Nancy Pelosi	Democrat	CA	House	1	1987-01-06	2027-01-03	221	2248	135
C001075	Bill Cassidy	Republican	LA	Senate	1	2009-01-06	2027-01-03	215	881	519
W000821	Bruce Westerman	Republican	AR	House	1	2015-01-06	2027-01-03	213	605	78
N000189	Dan Newhouse	Republican	WA	House	1	2015-01-06	2027-01-03	212	407	154