congress_members

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

11 rows where is_current = 1 and state = "TN" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: nickname, first_served, last_served, thomas_id, gender, terms_count, trade_count, vote_count, first_served (date), last_served (date), birthday (date), fec_ids (array)

party 2

chamber 2

state 1

is_current 1

bioguide_id first_name last_name full_name ▼ nickname party state chamber district 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
O000175 Andrew Ogles Andrew Ogles   Republican TN House 5 2023-01-03 2027-01-03 1 N00050943 ["H2TN05446"] 456939   48673   Andy Ogles Andy Ogles 1971-06-18 M 3   0 68 118 1686 3110291
H000601 Bill Hagerty Bill Hagerty   Republican TN Senate   2021-01-03 2027-01-03 1 N00045369 ["S0TN00169"] 456798   128466 S407 Bill Hagerty Bill Hagerty 1959-08-14 M 2   65 333 80 2345 6508207
F000459 Charles Fleischmann Charles J. "Chuck" Fleischmann Chuck Republican TN House 3 2011-01-05 2027-01-03 1 N00030815 ["H0TN03254"] 412476 02061 123456   Chuck Fleischmann Charles Fleischmann 1962-10-11 M 9   89 158 45 8430 4701576
K000392 David Kustoff David Kustoff   Republican TN House 8 2017-01-03 2027-01-03 1 N00025445 ["H2TN07103"] 412724   48997   David Kustoff David Kustoff 1966-10-08 M 6   27 110 104 4296 4198184
H001086 Diana Harshbarger Diana Harshbarger   Republican TN House 1 2021-01-03 2027-01-03 1 N00046688 ["H0TN01118"] 456844   190524   Diana Harshbarger Diana Harshbarger 1960-01-01 F 4   21 134 64 2135 2447435
R000612 John Rose John W. Rose   Republican TN House 6 2019-01-03 2027-01-03 1 N00041599 ["H8TN06094"] 412818   180452   John Rose (Tennessee politician) John Rose (Tennessee) 1965-02-23 M 5   22 313 35 3087 1249880
B001243 Marsha Blackburn Marsha Blackburn   Republican TN Senate   2003-01-07 2031-01-03 1 N00003105 ["H2TN06030", "S8TN00337"] 400032 01748 25186 S396 Marsha Blackburn Marsha Blackburn 1952-06-06 F 5   0 1979 496 14292 38279120
V000139 Matt Van Epps Matt Van Epps   Republican TN House 7 2025-12-04 2027-01-03 1   ["H6TN07161"] 457038       Matt Van Epps Matt Van Epps 1983-03-29 M 2   0 0 0 133 4167367
D000616 Scott DesJarlais Scott DesJarlais   Republican TN House 4 2011-01-05 2027-01-03 1 N00030957 ["H0TN04195"] 412477 02062 123473   Scott DesJarlais Scott DesJarlais 1964-02-21 M 9   2 145 52 8430 3076774
C001068 Steve Cohen Steve Cohen   Democrat TN House 9 2007-01-04 2027-01-03 1 N00003225 ["H6TN09068"] 412236 01878 24340   Steve Cohen (politician) Steve Cohen 1949-05-24 M 11   157 1312 446 11886 3832826
B001309 Tim Burchett Tim Burchett   Republican TN House 2 2019-01-03 2027-01-03 1 N00041594 ["H8TN02119"] 412817   24379   Tim Burchett Tim Burchett 1964-08-25 M 5   1 297 120 3087 810361

Advanced export

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

CSV options: 

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);