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	3582	191	191
C001123	Gilbert Ray Cisneros, Jr.	Democrat	CA	House	1	2019-01-03	2027-01-03	2567	74	29
T000278	Tommy Tuberville	Republican	AL	Senate	1	2021-01-03	2027-01-03	1444	520	75
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	91
G000599	Daniel S. Goldman	Democrat	NY	House	1	2023-01-03	2027-01-03	1307	82	59
L000590	Susie Lee	Democrat	NV	House	1	2019-01-03	2027-01-03	1291	158	89
W000802	Sheldon Whitehouse	Democrat	RI	Senate	1	2007-01-04	2031-01-03	1020	2396	489
B001292	Donald S. Beyer, Jr.	Democrat	VA	House	1	2015-01-06	2027-01-03	972	333	232
F000450	Virginia Foxx	Republican	NC	House	1	2005-01-04	2027-01-03	925	2099	222
H001082	Kevin Hern	Republican	OK	House	1	2018-11-13	2027-01-03	888	152	67
P000608	Scott H. Peters	Democrat	CA	House	1	2013-01-03	2027-01-03	781	220	214
S001201	Thomas R. Suozzi	Democrat	NY	House	1	2017-01-03	2027-01-03	750	148	81
C001047	Shelley Moore Capito	Republican	WV	Senate	1	2001-01-03	2027-01-03	740	1072	290
D000617	Suzan K. DelBene	Democrat	WA	House	1	2012-11-13	2027-01-03	716	234	141
B001327	Robert P. Bresnahan, Jr.	Republican	PA	House	1	2025-01-03	2027-01-03	653	21	19
C001035	Susan M. Collins	Republican	ME	Senate	1	1997-01-07	2027-01-03	637	3255	694
S001229	Jefferson Shreve	Republican	IN	House	1	2025-01-03	2027-01-03	636	32	16
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	510	37	25
L000397	Zoe Lofgren	Democrat	CA	House	1	1995-01-04	2027-01-03	463	1245	346
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	400
S001217	Rick Scott	Republican	FL	Senate	1	2019-01-08	2031-01-03	397	532	455
H001094	Val T. Hoyle	Democrat	OR	House	1	2023-01-03	2027-01-03	393	93	24
B001236	John Boozman	Republican	AR	Senate	1	2001-11-29	2029-01-03	374	1421	240
C001080	Judy Chu	Democrat	CA	House	1	2009-07-16	2027-01-03	349	575	248
R000609	John H. Rutherford	Republican	FL	House	1	2017-01-03	2027-01-03	348	249	47
C001114	John R. Curtis	Republican	UT	Senate	1	2017-11-13	2031-01-03	338	137	180
M001232	April McClain Delaney	Democrat	MD	House	1	2025-01-03	2027-01-03	327	0	29
W000779	Ron Wyden	Democrat	OR	Senate	1	1981-01-05	2029-01-03	321	3477	1203
F000246	Pat Fallon	Republican	TX	House	1	2021-01-03	2027-01-03	321	316	58
M001243	David McCormick	Republican	PA	Senate	1	2025-01-03	2031-01-03	315	21	37
A000372	Rick W. Allen	Republican	GA	House	1	2015-01-06	2027-01-03	302	403	60
M000934	Jerry Moran	Republican	KS	Senate	1	1997-01-07	2029-01-03	279	1568	475
W000804	Robert J. Wittman	Republican	VA	House	1	2007-12-13	2027-01-03	279	708	195
J000307	John James	Republican	MI	House	1	2023-01-03	2027-01-03	273	46	61
P000609	Gary J. Palmer	Republican	AL	House	1	2015-01-06	2027-01-03	260	124	96
B001325	Sheri Biggs	Republican	SC	House	1	2025-01-03	2027-01-03	260	17	13
L000595	Julia Letlow	Republican	LA	House	1	2021-04-14	2027-01-03	257	45	32
F000472	Scott Franklin	Republican	FL	House	1	2021-01-03	2027-01-03	255	61	47
M001236	Tim Moore	Republican	NC	House	1	2025-01-03	2027-01-03	235	33	26
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	224	102	16
C001075	Bill Cassidy	Republican	LA	Senate	1	2009-01-06	2027-01-03	215	800	502
W000821	Bruce Westerman	Republican	AR	House	1	2015-01-06	2027-01-03	213	540	77
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	205	873	256
P000595	Gary C. Peters	Democrat	MI	Senate	1	2009-01-06	2027-01-03	201	1113	564
K000375	William R. Keating	Democrat	MA	House	1	2011-01-05	2027-01-03	198	493	139