openregs: congress_members: 26 rows where chamber = "Senate" and state = "ID" sorted by full

All current and historical members of Congress (12,700+) from the congress-legislators project. Includes bioguide_id (universal key), party, state, chamber, and cross-reference IDs for OpenSecrets, FEC, GovTrack, and more.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

26 rows where chamber = "Senate" and state = "ID" sorted by full_name

descending

✎ View and edit SQL

This data as json, CSV (advanced)

bioguide_id	first_name	last_name	full_name ▼	nickname	party	state	chamber	first_served	last_served	is_current	opensecrets_id	fec_ids	govtrack_id	thomas_id	votesmart_id	lis_id	wikipedia_id	ballotpedia_id	birthday	gender	terms_count	served_until	trade_count	speech_count	bills_sponsored	vote_count	fec_total_received
M000716	Bert	Miller	Bert Miller		Democrat	ID	Senate	1949-01-03	1949-12-31	0		[]	407698				Bert H. Miller		1876-12-15	M	1	1949-12-31	0	0	0	0	0
G000337	Charles	Gossett	Charles Gossett		Democrat	ID	Senate	1945-11-17	1947-01-03	0		[]	404693				Charles C. Gossett		1888-09-02	M	1	1947-01-03	0	0	0	0	0
C000428	David	Clark	David Clark		Democrat	ID	Senate	1935-01-03	1945-01-03	0		[]	402566				D. Worth Clark		1902-04-02	M	2	1945-01-03	0	0	0	0	0
K000088	Dirk	Kempthorne	Dirk Kempthorne		Republican	ID	Senate	1993-01-05	1999-01-03	0		[]	406256	01376		S232	Dirk Kempthorne		1951-10-29	M	2	1999-01-03	0	371	0	0	0
C000388	Frank	Church	Frank Church		Democrat	ID	Senate	1957-01-03	1981-01-03	0		[]	402527	01305			Frank Church		1924-07-25	M	5	1981-01-03	0	0	0	0	0
G000288	Frank	Gooding	Frank Gooding		Republican	ID	Senate	1921-04-11	1929-03-03	0		[]	404649				Frank R. Gooding		1859-09-16	M	2	1929-03-03	0	0	0	0	0
D000509	Fred	Dubois	Fred Dubois		Democrat	ID	Senate	1887-12-05	1907-03-03	0		[]	403620				Fred Dubois	Fred Dubois	1851-05-29	M	4	1907-03-03	0	0	0	0	0
S000382	George	Shoup	George Shoup		Republican	ID	Senate	1890-01-01	1901-03-03	0		[]	409876				George L. Shoup		1836-06-15	M	2	1901-03-03	0	0	0	0	0
T000079	Glen	Taylor	Glen Taylor		Democrat	ID	Senate	1945-01-03	1951-01-03	0		[]	410663				Glen H. Taylor		1904-04-12	M	2	1951-01-03	0	0	0	0	0
D000585	Henry	Dworshak	Henry Dworshak		Republican	ID	Senate	1939-01-03	1963-01-03	0		[]	403688				Henry Dworshak		1894-08-29	M	5	1963-01-03	0	0	0	0	0
H000458	Henry	Heitfeld	Henry Heitfeld		Democrat	ID	Senate	1897-03-15	1903-03-03	0		[]	405323				Henry Heitfeld		1859-01-12	M	2	1903-03-03	0	0	0	0	0
W000269	Herman	Welker	Herman Welker		Republican	ID	Senate	1951-01-03	1957-01-03	0		[]	411435				Herman Welker		1906-12-11	M	2	1957-01-03	0	0	0	0	0
B000753	James	Brady	James Brady		Republican	ID	Senate	1913-04-07	1919-03-03	0		[]	401713				James H. Brady		1862-06-12	M	2	1919-03-03	0	0	0	0	0
R000584	James	Risch	James E. Risch		Republican	ID	Senate	2009-01-06	2027-01-03	1	N00029441	["S8ID00092"]	412322	01896	2919	S323	Jim Risch	Jim Risch	1943-05-03	M	4		0	1189	247	6005	3941717
M000346	James	McClure	James McClure		Republican	ID	Senate	1967-01-10	1991-01-03	0		[]	407355	01394		S063	Jim McClure (politician)		1924-12-27	M	5	1991-01-03	0	0	0	0	0
P000430	James	Pope	James Pope		Democrat	ID	Senate	1933-03-09	1939-01-03	0		[]	408821				James P. Pope		1884-03-31	M	2	1939-01-03	0	0	0	0	0
N000169	John	Nugent	John Nugent		Democrat	ID	Senate	1918-01-22	1921-01-14	0		[]	408250				John F. Nugent		1868-06-28	M	1	1921-01-14	0	0	0	0	0
T000172	John	Thomas	John Thomas		Republican	ID	Senate	1928-06-30	1945-12-31	0		[]	410753				John Thomas (Idaho politician)		1874-01-04	M	3	1945-12-31	0	0	0	0	0
P000238	Kirtland	Perky	Kirtland Perky		Democrat	ID	Senate	1912-11-18	1913-02-05	0		[]	408641				Kirtland I. Perky		1867-02-08	M	1	1913-02-05	0	0	0	0	0
C000858	Larry	Craig	Larry Craig		Republican	ID	Senate	1981-01-05	2009-01-03	0	N00002091	["S0ID00057"]	300029	00246	53288	S215	Larry Craig		1945-07-20	M	5	2009-01-03	0	2231	116	3282	-1000
J000269	Leonard	Jordan	Leonard Jordan		Republican	ID	Senate	1962-08-06	1973-01-03	0		[]	406161				Leonard B. Jordan		1899-05-15	M	2	1973-01-03	0	0	0	0	0
C000880	Michael	Crapo	Mike Crapo	Mike	Republican	ID	Senate	1993-01-05	2029-01-03	1	N00006267	["S8ID00027", "H2ID02034"]	300030	00250	26830	S266	Mike Crapo	Mike Crapo	1951-05-20	M	7		1	1460	300	9287	10137509
S001138	Steven	Symms	Steven Symms		Republican	ID	Senate	1973-01-03	1993-01-03	0		[]	410588	01132		S162	Steve Symms		1938-04-23	M	4	1993-01-03	0	0	0	0	0
H000554	Weldon	Heyburn	Weldon Heyburn		Republican	ID	Senate	1903-11-09	1913-03-03	0		[]	405416				Weldon B. Heyburn		1852-05-23	M	2	1913-03-03	0	0	0	0	0
B000634	William	Borah	William Borah		Republican	ID	Senate	1907-12-02	1941-01-03	0		[]	401599				William Borah		1865-06-29	M	6	1941-01-03	0	0	0	0	0
M000357	William	McConnell	William McConnell		Republican	ID	Senate	1890-01-01	1891-03-03	0		[]	407363				William J. McConnell		1839-09-18	M	1	1891-03-03	0	0	0	0	0

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE congress_members (
    bioguide_id TEXT PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    full_name TEXT,
    nickname TEXT,
    party TEXT,
    state TEXT,
    chamber TEXT,
    district INTEGER,
    first_served TEXT,
    last_served TEXT,
    is_current INTEGER,
    opensecrets_id TEXT,
    fec_ids TEXT,
    govtrack_id INTEGER,
    thomas_id TEXT,
    votesmart_id INTEGER,
    lis_id TEXT,
    wikipedia_id TEXT,
    ballotpedia_id TEXT,
    birthday TEXT,
    gender TEXT,
    terms_count INTEGER,
    served_until TEXT
, trade_count INTEGER DEFAULT 0, speech_count INTEGER DEFAULT 0, bills_sponsored INTEGER DEFAULT 0, vote_count INTEGER DEFAULT 0, fec_total_received INTEGER DEFAULT 0);
CREATE INDEX idx_cm_name ON congress_members(last_name, first_name);
CREATE INDEX idx_cm_party ON congress_members(party);
CREATE INDEX idx_cm_state ON congress_members(state);
CREATE INDEX idx_cm_chamber ON congress_members(chamber);
CREATE INDEX idx_cm_current ON congress_members(is_current);
CREATE INDEX idx_cm_current_trades ON congress_members(is_current DESC, trade_count DESC);