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	3536	191	186
C001123	Gilbert Ray Cisneros, Jr.	Democrat	CA	House	1	2019-01-03	2027-01-03	2370	74	29
T000278	Tommy Tuberville	Republican	AL	Senate	1	2021-01-03	2027-01-03	1444	520	73
M001136	Lisa C. McClain	Republican	MI	House	1	2021-01-03	2027-01-03	1433	247	70
F000462	Lois Frankel	Democrat	FL	House	1	2013-01-03	2027-01-03	1351	452	90
G000599	Daniel S. Goldman	Democrat	NY	House	1	2023-01-03	2027-01-03	1307	82	54
L000590	Susie Lee	Democrat	NV	House	1	2019-01-03	2027-01-03	1290	158	85
W000802	Sheldon Whitehouse	Democrat	RI	Senate	1	2007-01-04	2031-01-03	1017	2396	487
B001292	Donald S. Beyer, Jr.	Democrat	VA	House	1	2015-01-06	2027-01-03	972	333	223
F000450	Virginia Foxx	Republican	NC	House	1	2005-01-04	2027-01-03	924	2099	220
H001082	Kevin Hern	Republican	OK	House	1	2018-11-13	2027-01-03	883	152	66
S001201	Thomas R. Suozzi	Democrat	NY	House	1	2017-01-03	2027-01-03	746	148	80
P000608	Scott H. Peters	Democrat	CA	House	1	2013-01-03	2027-01-03	741	220	214
C001047	Shelley Moore Capito	Republican	WV	Senate	1	2001-01-03	2027-01-03	740	1072	289
D000617	Suzan K. DelBene	Democrat	WA	House	1	2012-11-13	2027-01-03	712	234	139
B001327	Robert P. Bresnahan, Jr.	Republican	PA	House	1	2025-01-03	2027-01-03	653	21	17
C001035	Susan M. Collins	Republican	ME	Senate	1	1997-01-07	2027-01-03	637	3255	691
S001229	Jefferson Shreve	Republican	IN	House	1	2025-01-03	2027-01-03	634	32	15
C001101	Katherine M. Clark	Democrat	MA	House	1	2013-12-12	2027-01-03	592	211	80
J000310	Julie Johnson	Democrat	TX	House	1	2025-01-03	2027-01-03	508	37	22
L000397	Zoe Lofgren	Democrat	CA	House	1	1995-01-04	2027-01-03	463	1245	344
M001217	Jared Moskowitz	Democrat	FL	House	1	2023-01-03	2027-01-03	443	78	37
S000250	Pete Sessions	Republican	TX	House	1	1997-01-07	2027-01-03	399	1222	399
S001217	Rick Scott	Republican	FL	Senate	1	2019-01-08	2031-01-03	397	532	438
H001094	Val T. Hoyle	Democrat	OR	House	1	2023-01-03	2027-01-03	392	93	22
B001236	John Boozman	Republican	AR	Senate	1	2001-11-29	2029-01-03	365	1421	239
C001080	Judy Chu	Democrat	CA	House	1	2009-07-16	2027-01-03	349	575	246
R000609	John H. Rutherford	Republican	FL	House	1	2017-01-03	2027-01-03	348	249	46
C001114	John R. Curtis	Republican	UT	Senate	1	2017-11-13	2031-01-03	338	137	178
W000779	Ron Wyden	Democrat	OR	Senate	1	1981-01-05	2029-01-03	321	3477	1193
F000246	Pat Fallon	Republican	TX	House	1	2021-01-03	2027-01-03	321	316	56
A000372	Rick W. Allen	Republican	GA	House	1	2015-01-06	2027-01-03	295	403	60
M000934	Jerry Moran	Republican	KS	Senate	1	1997-01-07	2029-01-03	279	1568	472
W000804	Robert J. Wittman	Republican	VA	House	1	2007-12-13	2027-01-03	279	708	195
M001243	David McCormick	Republican	PA	Senate	1	2025-01-03	2031-01-03	278	21	32
M001232	April McClain Delaney	Democrat	MD	House	1	2025-01-03	2027-01-03	274	0	26
J000307	John James	Republican	MI	House	1	2023-01-03	2027-01-03	273	46	58
P000609	Gary J. Palmer	Republican	AL	House	1	2015-01-06	2027-01-03	260	124	96
L000595	Julia Letlow	Republican	LA	House	1	2021-04-14	2027-01-03	257	45	30
B001325	Sheri Biggs	Republican	SC	House	1	2025-01-03	2027-01-03	256	17	13
F000472	Scott Franklin	Republican	FL	House	1	2021-01-03	2027-01-03	255	61	46
M001236	Tim Moore	Republican	NC	House	1	2025-01-03	2027-01-03	230	33	24
H001061	John Hoeven	Republican	ND	Senate	1	2011-01-05	2029-01-03	225	758	208
F000110	Cleo Fields	Democrat	LA	House	1	1993-01-05	2027-01-03	223	102	16
C001075	Bill Cassidy	Republican	LA	Senate	1	2009-01-06	2027-01-03	215	800	498
W000821	Bruce Westerman	Republican	AR	House	1	2015-01-06	2027-01-03	213	540	75
P000197	Nancy Pelosi	Democrat	CA	House	1	1987-01-06	2027-01-03	212	2239	135
D000624	Debbie Dingell	Democrat	MI	House	1	2015-01-06	2027-01-03	204	873	249
P000595	Gary C. Peters	Democrat	MI	Senate	1	2009-01-06	2027-01-03	197	1113	557
K000375	William R. Keating	Democrat	MA	House	1	2011-01-05	2027-01-03	190	493	138