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

452 rows where state = "VA" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

is_current 2

  • 0 439
  • 1 13

chamber 2

state 1

  • VA · 452 ✖
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
M001200 A. McEachin A. Donald McEachin   Democrat VA House 4 2017-01-03 2022-11-28 0 N00039327 ["H6VA04061"] 412728   8230   Donald McEachin Donald McEachin 1961-10-10 M 3 2022-11-28 22 143 68 2611 2124219
S001209 Abigail Spanberger Abigail Davis Spanberger   Democrat VA House 7 2019-01-03 2025-01-03 0 N00041418 ["H8VA07094"] 412833   179682   Abigail Spanberger Abigail Spanberger 1979-08-07 F 4 2025-01-03 18 192 105 2642 29596418
V000083 Abraham Venable Abraham Venable   Republican VA Senate   1791-10-24 1805-03-03 0   [] 411139       Abraham B. Venable   1758-11-20 M 3 1805-03-03 0 0 0 0 0
F000402 Abram Fulkerson Abram Fulkerson   Readjuster Democrat VA House 9 1881-12-05 1883-03-03 0   [] 404344       Abram Fulkerson   1834-05-13 M 2 1883-03-03 0 0 0 0 0
T000368 Abram Trigg Abram Trigg   Republican VA House 6 1797-05-15 1809-03-03 0   [] 410937       Abram Trigg     M 7 1809-03-03 0 0 0 0 0
R000317 Absalom Robertson Absalom Robertson   Democrat VA Senate   1933-03-09 1967-01-03 0   [] 409288       A. Willis Robertson   1887-05-27 M 6 1967-01-03 0 0 0 0 0
J000081 Albert Jenkins Albert Jenkins   Democrat VA House 11 1857-12-07 1861-03-03 0   [] 405984       Albert G. Jenkins   1830-11-10 M 3 1861-03-03 0 0 0 0 0
B000653 Alexander Boteler Alexander Boteler   Ind. Republican-Democrat VA House 8 1859-12-05 1861-03-03 0   [] 401616       Alexander Boteler   1815-05-16 M 2 1861-03-03 0 0 0 0 0
D000091 Alexander Davis Alexander Davis   Democrat VA House 5 1873-12-01 1875-03-03 0   [] 403228       Alexander Davis (politician)   1833-01-17 M 2 1875-03-03 0 0 0 0 0
H000714 Alexander Holladay Alexander Holladay   Democrat VA House 8 1849-12-03 1853-03-03 0   [] 405566       Alexander Holladay   1811-09-18 M 3 1853-03-03 0 0 0 0 0
N000070 Alexander Newman Alexander Newman   Democrat VA House 15 1849-12-03 1851-03-03 0   [] 408158       Alexander Newman   1804-10-05 M 2 1851-03-03 0 0 0 0 0
S000646 Alexander Smyth Alexander Smyth   Jackson VA House 22 1817-12-01 1831-03-03 0   [] 410120       Alexander Smyth     M 8 1831-03-03 0 0 0 0 0
S001030 Alexander Stuart Alexander Stuart   Whig VA House 17 1841-05-31 1843-03-03 0   [] 410486       Alexander Hugh Holmes Stuart   1807-04-02 M 2 1843-03-03 0 0 0 0 0
W000352 Alexander White Alexander White     VA House 1 1789-03-04 1793-03-03 0   [] 411514       Alexander White (Virginia politician)     M 3 1793-03-03 0 0 0 0 0
W000568 Alexander Wilson Alexander Wilson   Republican VA House 5 1803-10-17 1809-03-03 0   [] 412119       Alexander Wilson (Virginia politician)     M 4 1809-03-03 0 0 0 0 0
P000478 Alfred Powell Alfred Powell   Adams VA House 17 1825-12-05 1827-03-03 0   [] 408863       Alfred H. Powell   1781-03-06 M 2 1827-03-03 0 0 0 0 0
B000319 Andrew Beirne Andrew Beirne   Democrat VA House 19 1837-09-04 1841-03-03 0   [] 401311       Andrew Beirne     M 3 1841-03-03 0 0 0 0 0
F000419 Andrew Fulton Andrew Fulton   Whig VA House 13 1847-12-06 1849-03-03 0   [] 404361       Andrew S. Fulton   1800-09-29 M 2 1849-03-03 0 0 0 0 0
M000861 Andrew Montague Andrew Montague   Democrat VA House 3 1913-04-07 1939-01-03 0   [] 407834       Andrew Jackson Montague   1862-10-03 M 14 1939-01-03 4 0 0 0 0
M000891 Andrew Moore Andrew Moore   Republican VA Senate   1789-03-04 1809-03-03 0   [] 407863       Andrew Moore (politician)     M 4 1809-03-03 0 0 0 0 0
S000891 Andrew Stevenson Andrew Stevenson   Jackson VA House 11 1821-12-03 1835-03-03 0   [] 410352       Andrew Stevenson   1784-01-21 M 8 1835-03-03 0 0 0 0 0
A000328 Archibald Atkinson Archibald Atkinson   Democrat VA House 1 1843-12-04 1849-03-03 0   [] 400977       Archibald Atkinson   1792-09-15 M 4 1849-03-03 0 0 0 0 0
A000340 Archibald Austin Archibald Austin   Republican VA House 16 1817-12-01 1819-03-03 0   [] 400990       Archibald Austin   1772-08-11 M 2 1819-03-03 0 0 0 0 0
S001032 Archibald Stuart Archibald Stuart   Democrat VA House 7 1837-09-04 1839-03-03 0   [] 410488       Archibald Stuart   1795-12-02 M 2 1839-03-03 0 0 0 0 0
M000213 Armistead Mason Armistead Mason   Republican VA Senate   1816-01-01 1817-03-03 0   [] 407231       Armistead Thomson Mason   1787-08-04 M 1 1817-03-03 0 0 0 0 0
S000515 Arthur Smith Arthur Smith     VA House 2 1819-12-06 1825-03-03 0   [] 410000       Arthur Smith (U.S. representative)   1785-11-15 M 4 1825-03-03 0 0 0 0 0
P000535 Auburn Pridemore Auburn Pridemore   Democrat VA House 9 1877-10-15 1879-03-03 0   [] 408919       Auburn Pridemore   1837-06-27 M 2 1879-03-03 2 0 0 0 0
C000308 Augustus Chapman Augustus Chapman   Democrat VA House 12 1843-12-04 1847-03-03 0   [] 402450       Augustus A. Chapman   1803-03-09 M 3 1847-03-03 0 0 0 0 0
H000361 Aylett Hawes Aylett Hawes   Republican VA House 10 1811-11-04 1817-03-03 0   [] 405230       Aylett Hawes   1768-04-21 M 4 1817-03-03 0 0 0 0 0
S000516 Ballard Smith Ballard Smith   Republican VA House 7 1815-12-04 1821-03-03 0   [] 412099       Ballard Smith (Virginia politician)     M 4 1821-03-03 0 0 0 0 0
C001105 Barbara Comstock Barbara Comstock   Republican VA House 10 2015-01-06 2019-01-03 0 N00036023 ["H4VA10089"] 412658 02273 112252   Barbara Comstock Barbara Comstock 1959-06-30 F 3 2019-01-03 88 381 32 2534 18991596
C001118 Ben Cline Ben Cline   Republican VA House 6 2019-01-03 2027-01-03 1 N00042296 ["H8VA06104"] 412832   50959   Ben Cline Ben Cline 1972-02-29 M 5   15 271 51 3087 1815038
E000223 Benjamin Estil Benjamin Estil   Adams VA House 22 1825-12-05 1827-03-03 0   [] 403909       Benjamin Estil   1780-03-13 M 2 1827-03-03 0 0 0 0 0
H000763 Benjamin Hooper Benjamin Hooper   Readjuster VA House 4 1883-12-03 1885-03-03 0   [] 405613       Benjamin S. Hooper   1835-03-06 M 2 1885-03-03 0 0 0 0 0
L000232 Benjamin Leigh Benjamin Leigh   Anti-Jacksonian VA Senate   1834-02-26 1836-07-04 0   [] 406735       Benjamin W. Leigh   1781-06-18 M 1 1836-07-04 5 0 0 0 0
D000450 Beverly Douglas Beverly Douglas   Democrat VA House 1 1875-12-06 1879-03-03 0   [] 403560       Beverly B. Douglas   1822-12-21 M 3 1879-03-03 0 0 0 0 0
G000595 Robert Good Bob Good Bob Republican VA House 5 2021-01-03 2025-01-03 0 N00045557 ["H0VA05160"] 456853   190745   Bob Good Bob Good 1965-09-11 M 3 2025-01-03 16 206 92 1690 11324968
G000289 Bob Goodlatte Bob Goodlatte   Republican VA House 6 1993-01-05 2019-01-03 0 N00009154 ["H2VA06115"] 400154 00446 27116   Bob Goodlatte Bob Goodlatte 1952-09-22 M 14 2019-01-03 23 1115 131 11227 4235559
H000264 Burr Harrison Burr Harrison   Democrat VA House 7 1946-11-05 1963-01-03 0   [] 405141       Burr Harrison   1904-07-02 M 9 1963-01-03 0 0 0 0 0
B000224 Burwell Bassett Burwell Bassett   Jackson VA House 8 1805-12-02 1829-03-03 0   [] 401220       Burwell Bassett   1764-03-18 M 13 1829-03-03 0 0 0 0 0
S000485 Campbell Slemp Campbell Slemp   Republican VA House 9 1903-11-09 1909-03-03 0   [] 409973       Campbell Slemp   1839-12-02 M 4 1909-03-03 0 0 0 0 0
S000486 Campbell Slemp Campbell Slemp   Republican VA House 9 1907-12-02 1923-03-03 0   [] 409974       C. Bascom Slemp   1870-09-04 M 9 1923-03-03 0 0 0 0 0
G000232 Carter Glass Carter Glass   Democrat VA Senate   1902-11-04 1946-05-28 0   [] 404594       Carter Glass   1858-01-04 M 8 1946-05-28 0 0 0 0 0
H000266 Carter Harrison Carter Harrison   Republican VA House 10 1793-12-02 1799-03-03 0   [] 412155       Carter Bassett Harrison     M 4 1799-03-03 0 0 0 0 0
C000151 Charles Carlin Charles Carlin   Democrat VA House -1 1907-12-02 1921-03-03 0   [] 402300       Charles Creighton Carlin   1866-04-08 M 8 1921-03-03 0 0 0 0 0
F000044 Charles Faulkner Charles Faulkner   Democrat VA House -1 1851-12-01 1877-03-03 0   [] 404004       Charles J. Faulkner   1806-07-06 M 14 1877-03-03 0 0 0 0 0
J000185 Charles Johnston Charles Johnston   Jackson VA House 22 1831-12-05 1833-03-03 0   [] 406080       Charles Clement Johnston   1795-04-30 M 2 1833-03-03 0 0 0 0 0
L000275 Charles Lewis Charles Lewis   Democrat VA House 11 1853-12-05 1855-03-03 0   [] 406773       Charles S. Lewis   1821-02-26 M 2 1855-03-03 0 0 0 0 0
M000642 Charles Mercer Charles Mercer   Whig VA House 14 1817-12-01 1841-03-03 0   [] 407628       Charles F. Mercer   1778-06-16 M 13 1841-03-03 0 0 0 0 0
O000040 Charles O’Ferrall Charles O’Ferrall   Democrat VA House 7 1883-12-03 1895-03-03 0   [] 408284       Charles T. O'Ferrall   1840-10-21 M 7 1895-03-03 0 0 0 0 0
P000438 Charles Porter Charles Porter   Republican VA House 3 1869-03-04 1873-03-03 0   [] 408829       Charles H. Porter (Virginia politician)   1833-06-21 M 3 1873-03-03 0 0 0 0 0
R000295 Charles Robb Charles Robb   Democrat VA Senate   1989-01-03 2001-01-03 0   ["S8VA00156"] 400564 01423   S207 Chuck Robb   1939-06-26 M 3 2001-01-03 0 440 0 672 0
U000030 Charles Upton Charles Upton   Unionist VA House 7 1861-07-04 1863-03-03 0   [] 411053       Charles H. Upton   1812-08-23 M 2 1863-03-03 0 0 0 0 0
C000424 Christopher Clark Christopher Clark   Republican VA House 13 1803-10-17 1807-03-03 0   [] 402563       Christopher H. Clark     M 3 1807-03-03 0 0 0 0 0
T000161 Christopher Thomas Christopher Thomas   Republican VA House 5 1873-12-01 1875-03-03 0   [] 410743       Christopher Thomas   1818-03-24 M 2 1875-03-03 0 0 0 0 0
B001148 Clarence Burton Clarence Burton   Democrat VA House 6 1947-01-03 1953-01-03 0   [] 402091       Clarence G. Burton   1886-12-14 M 4 1953-01-03 0 0 0 0 0
S001094 Claude Swanson Claude Swanson   Democrat VA Senate   1893-08-07 1933-03-03 0   [] 410547       Claude A. Swanson   1862-03-31 M 7 1933-03-03 0 0 0 0 0
W000720 Clifton Woodrum Clifton Woodrum   Democrat VA House 6 1923-12-03 1947-01-03 0   [] 411872       Clifton A. Woodrum   1887-04-27 M 13 1947-01-03 0 0 0 0 0
D000050 Colgate Darden Colgate Darden   Democrat VA House 2 1933-03-09 1943-01-03 0   [] 403189       Colgate Darden   1897-02-11 M 6 1943-01-03 0 0 0 0 0
T000369 Connally Trigg Connally Trigg   Democrat VA House 9 1885-12-07 1887-03-03 0   [] 410938       Connally Findlay Trigg   1847-09-18 M 2 1887-03-03 0 0 0 0 0
P000479 Cuthbert Powell Cuthbert Powell   Whig VA House 14 1841-05-31 1843-03-03 0   [] 408864       Cuthbert Powell   1775-03-04 M 2 1843-03-03 0 0 0 0 0
D000202 Daniel De Jarnette Daniel De Jarnette   Independent Democrat VA House -1 1859-12-05 1863-03-03 0   [] 403307       Daniel Coleman DeJarnette Sr.   1822-10-18 M 3 1863-03-03 0 0 0 0 0
M000946 Daniel Morgan Daniel Morgan   Federalist VA House 1 1797-05-15 1799-03-03 0   [] 407914       Daniel Morgan     M 2 1799-03-03 0 0 0 0 0
S000317 Daniel Sheffey Daniel Sheffey   Federalist VA House 6 1809-05-22 1817-03-03 0   [] 409815       Daniel Sheffey     M 5 1817-03-03 0 0 0 0 0
S000479 Daniel Slaughter Daniel Slaughter   Republican VA House 7 1985-01-03 1991-11-04 0   [] 409968 01068     D. French Slaughter Jr.   1925-05-20 M 4 1991-11-04 0 0 0 0 0
B001290 David Brat Dave Brat Dave Republican VA House 7 2014-11-12 2019-01-03 0 N00036013 ["H4VA07143"] 412605 02203 152270   Dave Brat David Brat 1964-07-27 M 3 2019-01-03 9 54 47 2582 5178662
S000069 Dave Satterfield Dave Satterfield   Democrat VA House 3 1937-01-05 1947-01-03 0   [] 409581       Dave E. Satterfield Jr.   1894-09-11 M 6 1947-01-03 0 0 0 0 0
G000066 David Garland David Garland   Republican VA House 21 1809-05-22 1811-03-03 0   [] 404439       David S. Garland   1769-09-27 M 2 1811-03-03 0 0 0 0 0
S000070 David Satterfield David Satterfield   Democrat VA House 3 1965-01-04 1981-01-03 0   [] 409582 01019     David E. Satterfield III   1920-12-02 M 9 1981-01-03 0 0 0 0 0
T000448 David Tyler David Tyler   Democrat VA House 2 1893-08-07 1897-03-03 0   [] 411016       David Gardiner Tyler   1846-07-12 M 3 1897-03-03 0 0 0 0 0
R000611 Denver Riggleman Denver Riggleman   Republican VA House 5 2019-01-03 2021-01-03 0 N00043541 ["H8VA05171"] 412831   181445   Denver Riggleman Denver Riggleman 1970-03-17 M 2 2021-01-03 4 57 15 952 1643834
B001292 Donald Beyer Donald S. Beyer, Jr.   Democrat VA House 8 2015-01-06 2027-01-03 1 N00036018 ["H4VA08224"] 412657 02272 1707   Don Beyer Don Beyer 1950-06-20 M 7   994 333 217 5621 4744690
R000589 Edward Rigell E. Scott Rigell Scott Republican VA House 2 2011-01-05 2017-01-03 0 N00030962 ["H0VA02084"] 412483 02068 121807   Scott Rigell   1960-05-28 M 4 2017-01-03 71 96 27 4134 3323704
W000574 Edgar Wilson Edgar Wilson   Anti Jacksonian VA House 21 1833-12-02 1835-03-03 0   [] 411729       Edgar C. Wilson   1800-10-18 M 2 1835-03-03 0 0 0 0 0
H000876 Edmund Hubard Edmund Hubard   Democrat VA House 4 1841-05-31 1847-03-03 0   [] 405722       Edmund W. Hubard   1806-02-20 M 4 1847-03-03 0 0 0 0 0
W000003 Edmund Waddill Edmund Waddill   Republican VA House 3 1889-12-02 1891-03-03 0   [] 411182       Edmund Waddill Jr.   1855-05-22 M 2 1891-03-03 0 0 0 0 0
C000650 Edward Colston Edward Colston   Federalist VA House 2 1817-12-01 1819-03-03 0   [] 402778       Edward Colston (U.S. Representative)   1786-12-25 M 2 1819-03-03 0 0 0 0 0
H000716 Edward Holland Edward Holland   Democrat VA House 2 1911-04-04 1921-03-03 0   [] 405568       Edward E. Holland   1861-02-26 M 6 1921-03-03 0 0 0 0 0
J000010 Edward Jackson Edward Jackson   Republican VA House 1 1819-12-06 1823-03-03 0   [] 405917       Edward B. Jackson   1793-01-25 M 3 1823-03-03 0 0 0 0 0
L000490 Edward Lucas Edward Lucas   Jackson VA House 15 1833-12-02 1837-03-03 0   [] 406978       Edward Lucas (congressman)   1780-10-20 M 3 1837-03-03 0 0 0 0 0
R000329 Edward Robeson Edward Robeson   Democrat VA House 1 1949-01-03 1959-01-03 0   [] 409300       Edward J. Robeson Jr.   1890-08-09 M 6 1959-01-03 0 0 0 0 0
S000077 Edward Saunders Edward Saunders   Democrat VA House 5 1905-12-04 1921-03-03 0   [] 409589       Edward W. Saunders   1860-10-20 M 9 1921-03-03 0 0 0 0 0
S001151 Edward Schrock Edward Schrock Ed Republican VA House 2 2001-01-03 2005-01-03 0 N00012656 [] 400362 01673     Ed Schrock   1941-04-06 M 3 2005-01-03 0 61 5 1220 0
V000085 Edward Venable Edward Venable   Democrat VA House 4 1889-12-02 1891-03-03 0   [] 411141       Edward Carrington Venable   1853-01-31 M 2 1891-03-03 0 0 0 0 0
G000394 Edwin Gray Edwin Gray   Republican VA House 19 1799-12-02 1813-03-03 0   [] 404744       Edwin Gray   1743-07-18 M 8 1813-03-03 0 0 0 0 0
L000591 Elaine Luria Elaine G. Luria   Democrat VA House 2 2019-01-03 2023-01-03 0 N00042293 ["H8VA02111"] 412830   179677   Elaine Luria Elaine Luria 1975-08-15 F 3 2023-01-03 17 123 45 1401 19032744
M000179 Elbert Martin Elbert Martin   Ind. Democrat VA House 13 1859-12-05 1861-03-03 0   [] 412163       Elbert S. Martin     M 2 1861-03-03 0 0 0 0 0
M000647 Elisha Meredith Elisha Meredith   Democrat VA House 8 1891-12-07 1897-03-03 0   [] 407633       Elisha E. Meredith   1848-12-26 M 4 1897-03-03 0 0 0 0 0
B000777 Elliott Braxton Elliott Braxton   Democrat VA House 7 1871-03-04 1873-03-03 0   [] 401736       Elliott M. Braxton   1823-10-08 M 2 1873-03-03 0 0 0 0 0
H000999 Eppa Hunton Eppa Hunton   Democrat VA Senate   1873-12-01 1895-03-03 0   [] 405839       Eppa Hunton   1822-09-22 M 4 1895-03-03 0 0 0 0 0
C001046 Eric Cantor Eric Cantor   Republican VA House 7 2001-01-03 2014-08-18 0 N00013131 ["H0VA07042"] 400060 01674 5121   Eric Cantor Eric Cantor 1963-06-06 M 7 2014-08-18 22 646 67 8609 8094651
V000138 Eugene Vindman Eugene Simon Vindman   Democrat VA House 7 2025-01-03 2027-01-03 1 N00054112 ["H4VA07234"] 457027       Eugene Vindman   1975-06-06 M 2   7 74 49 445 7817487
M000578 Fayette McMullen Fayette McMullen   Democrat VA House 13 1849-12-03 1857-03-03 0   [] 407569       Fayette McMullen   1805-05-18 M 5 1857-03-03 0 0 0 0 0
L000106 Francis Lassiter Francis Lassiter   Democrat VA House 4 1899-12-04 1911-03-03 0   [] 406613       Francis R. Lassiter   1866-02-18 M 7 1911-03-03 1 0 0 0 0
M000080 Francis Mallory Francis Mallory   Whig VA House 1 1837-09-04 1843-03-03 0   [] 407108       Francis Mallory   1807-12-12 M 4 1843-03-03 0 0 0 0 0
P000514 Francis Preston Francis Preston   Republican VA House 4 1793-12-02 1797-03-03 0   [] 408899       Francis Preston   1765-08-02 M 3 1797-03-03 0 0 0 0 0
R000284 Francis Rives Francis Rives   Democrat VA House 2 1837-09-04 1841-03-03 0   [] 409257       Francis E. Rives   1792-01-14 M 3 1841-03-03 0 0 0 0 0
W000051 Francis Walker Francis Walker     VA House 14 1793-12-02 1795-03-03 0   [] 411230       Francis Walker (Virginia politician)   1764-06-22 M 2 1795-03-03 0 0 0 0 0
W000367 Francis White Francis White   Federalist VA House 2 1813-05-24 1815-03-03 0   [] 412116       Francis White (Virginia politician)     M 2 1815-03-03 0 0 0 0 0
W000672 Frank Wolf Frank R. Wolf   Republican VA House 10 1981-01-05 2015-01-03 0 N00002073 ["H6VA10050"] 400435 01238 27120   Frank Wolf (politician) Frank Wolf 1939-01-30 M 18 2015-01-03 8 1496 78 8693 948594

Next page

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