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

1,511 rows where state = "NY" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

is_current 2

  • 0 1,483
  • 1 28

chamber 2

state 1

  • NY · 1,511 ✖
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
F000296 A. Foster A. Foster   Whig NY House 23 1841-05-31 1843-03-03 0   [] 412038       A. Lawrence Foster   1802-09-17 M 2 1843-03-03 0 0 0 0 0
B001133 Aaron Burr Aaron Burr   Republican NY Senate   1791-10-24 1797-03-03 0   [] 402077       Aaron Burr   1756-02-06 M 2 1797-03-03 0 0 0 0 0
C000568 Aaron Cochrane Aaron Cochrane   Republican NY House 19 1897-03-15 1901-03-03 0   [] 402697       Aaron Van Schaick Cochrane   1858-03-14 M 3 1901-03-03 0 0 0 0 0
H000006 Aaron Hackley Aaron Hackley   Republican NY House 17 1819-12-06 1821-03-03 0   [] 404891       Aaron Hackley Jr.   1783-05-06 M 2 1821-03-03 0 0 0 0 0
V000028 Aaron Vanderpoel Aaron Vanderpoel   Democrat NY House 8 1833-12-02 1841-03-03 0   [] 411122       Aaron Vanderpoel   1799-02-05 M 5 1841-03-03 0 0 0 0 0
W000125 Aaron Ward Aaron Ward   Democrat NY House 4 1825-12-05 1843-03-03 0   [] 411300       Aaron Ward (representative)   1790-07-05 M 10 1843-03-03 0 0 0 0 0
H000994 Abel Huntington Abel Huntington   Jackson NY House 1 1833-12-02 1837-03-03 0   [] 405834       Abel Huntington   1777-02-21 M 3 1837-03-03 0 0 0 0 0
M000099 Abijah Mann Abijah Mann   Jackson NY House 16 1833-12-02 1837-03-03 0   [] 407123       Abijah Mann Jr.   1793-09-24 M 3 1837-03-03 0 0 0 0 0
H000416 Abner Hazeltine Abner Hazeltine   Whig NY House 31 1833-12-02 1837-03-03 0   [] 405282       Abner Hazeltine   1793-06-10 M 3 1837-03-03 0 0 0 0 0
L000270 Abner Lewis Abner Lewis   Whig NY House 31 1845-12-01 1847-03-03 0   [] 412063       Abner Lewis   1801-08-17 M 2 1847-03-03 0 0 0 0 0
B000581 Abraham Bockee Abraham Bockee   Jackson NY House 5 1829-12-07 1837-03-03 0   [] 401552       Abraham Bockee   1784-02-03 M 5 1837-03-03 0 0 0 0 0
D000465 Abraham Dowdney Abraham Dowdney   Democrat NY House 12 1885-12-07 1887-03-03 0   [] 403575       Abraham Dowdney   1841-10-31 M 2 1887-03-03 0 0 0 0 0
G000380 Abraham Grant Abraham Grant   Democrat NY House 17 1837-09-04 1839-03-03 0   [] 404731       Abraham P. Grant   1804-04-05 M 2 1839-03-03 0 0 0 0 0
H000313 Abraham Hasbrouck Abraham Hasbrouck   Republican NY House 7 1813-05-24 1815-03-03 0   [] 405186       Abraham J. Hasbrouck   1773-10-16 M 2 1815-03-03 0 0 0 0 0
H000312 Abraham Hasbrouck Abraham Hasbrouck   Adams NY House 7 1825-12-05 1827-03-03 0   [] 405185       Abraham Bruyn Hasbrouck   1791-11-29 M 2 1827-03-03 0 0 0 0 0
M001074 Abraham Multer Abraham Multer   Democrat NY House 13 1947-01-03 1969-01-03 0   [] 408040       Abraham J. Multer   1900-12-24 M 12 1969-01-03 0 0 0 0 0
P000053 Abraham Parker Abraham Parker   Republican NY House 22 1881-12-05 1889-03-03 0   [] 408463       Abraham X. Parker   1831-11-14 M 5 1889-03-03 0 0 0 0 0
S000115 Abraham Schenck Abraham Schenck   Republican NY House 4 1815-12-04 1817-03-03 0   [] 409623       Abraham H. Schenck   1775-01-22 M 2 1817-03-03 0 0 0 0 0
S000122 Abraham Schermerhorn Abraham Schermerhorn   Whig NY House 28 1849-12-03 1853-03-03 0   [] 409630       Abraham M. Schermerhorn   1791-12-11 M 3 1853-03-03 0 0 0 0 0
S000853 Abraham Stephens Abraham Stephens   Democrat NY House 7 1851-12-01 1853-03-03 0   [] 410316       Abraham P. Stephens   1796-02-18 M 2 1853-03-03 0 0 0 0 0
V000030 Abraham Vanderveer Abraham Vanderveer   Democrat NY House 2 1837-09-04 1839-03-03 0   [] 411123       Abraham Vanderveer     M 2 1839-03-03 0 0 0 0 0
H000552 Abram Hewitt Abram Hewitt   Democrat NY House 10 1875-12-06 1887-03-03 0   [] 405414       Abram Hewitt   1822-07-31 M 7 1887-03-03 0 0 0 0 0
O000066 Abram Olin Abram Olin   Republican NY House 13 1857-12-07 1863-03-03 0   [] 408339       Abram B. Olin   1808-09-21 M 4 1863-03-03 0 0 0 0 0
W000027 Abram Wakeman Abram Wakeman   Ind. Republican-Democrat NY House 8 1855-12-03 1857-03-03 0   [] 411206       Abram Wakeman   1824-05-31 M 2 1857-03-03 0 0 0 0 0
P000477 Adam Powell Adam Powell   Democrat NY House 18 1945-01-03 1971-01-03 0   [] 408862       Adam Clayton Powell Jr.   1908-11-29 M 14 1971-01-03 0 0 0 0 0
L000017 Addison Laflin Addison Laflin   Republican NY House 20 1865-12-04 1871-03-03 0   [] 406527       Addison H. Laflin   1823-10-24 M 4 1871-03-03 0 0 0 0 0
T000037 Adolphus Tanner Adolphus Tanner   Republican NY House 15 1869-03-04 1871-03-03 0   [] 410626       Adolphus H. Tanner   1833-05-23 M 2 1871-03-03 0 0 0 0 0
E000297 Adriano Espaillat Adriano Espaillat   Democrat NY House 13 2017-01-03 2027-01-03 1 N00034549 ["H2NY13096"] 412718   14379   Adriano Espaillat Adriano Espaillat 1954-09-27 M 6   20 302 227 4296 1999157
H000813 Alanson Houghton Alanson Houghton   Republican NY House 37 1919-05-19 1923-03-03 0   [] 405661       Alanson B. Houghton   1863-10-10 M 3 1923-03-03 0 0 0 0 0
B000646 Albert Bosch Albert Bosch   Republican NY House 5 1953-01-03 1961-01-03 0   [] 401610       Albert H. Bosch   1908-10-30 M 5 1961-01-03 0 0 0 0 0
G000028 Albert Gallup Albert Gallup   Democrat NY House 10 1837-09-04 1839-03-03 0   [] 404404       Albert Gallup   1796-01-30 M 2 1839-03-03 0 0 0 0 0
R000457 Albert Rossdale Albert Rossdale   Republican NY House 23 1921-04-11 1923-03-03 0   [] 409421       Albert B. Rossdale   1878-10-23 M 2 1923-03-03 0 0 0 0 0
S000302 Albert Shaw Albert Shaw   Republican NY House -1 1899-12-04 1903-03-03 0   [] 409801       Albert D. Shaw   1841-12-21 M 3 1903-03-03 0 0 0 0 0
S000512 Albert Smith Albert Smith   Whig NY House 33 1843-12-04 1847-03-03 0   [] 409998       Albert Smith (New York politician)   1805-06-22 M 3 1847-03-03 0 0 0 0 0
T000343 Albert Tracy Albert Tracy   Whig NY House 30 1819-12-06 1825-03-03 0   [] 410914       Albert H. Tracy   1793-06-17 M 4 1825-03-03 0 0 0 0 0
B000034 Alexander Bailey Alexander Bailey   Republican NY House 21 1867-03-04 1871-03-03 0   [] 401039       Alexander H. Bailey   1817-08-14 M 3 1871-03-03 0 0 0 0 0
B000715 Alexander Boyd Alexander Boyd   Federalist NY House 13 1813-05-24 1815-03-03 0   [] 401676       Alexander Boyd   1764-09-14 M 2 1815-03-03 0 0 0 0 0
B001038 Alexander Buell Alexander Buell   Democrat NY House 17 1851-12-01 1853-03-03 0   [] 401988       Alexander H. Buell   1801-07-14 M 2 1853-03-03 0 0 0 0 0
D000364 Alexander Diven Alexander Diven   Republican NY House 27 1861-07-04 1863-03-03 0   [] 403481       Alexander S. Diven   1809-02-10 M 2 1863-03-03 0 0 0 0 0
P000366 Alexander Pirnie Alexander Pirnie   Republican NY House 32 1959-01-07 1973-01-03 0   [] 408762       Alexander Pirnie   1903-04-16 M 8 1973-01-03 0 0 0 0 0
O000172 Alexandria Ocasio-Cortez Alexandria Ocasio-Cortez   Democrat NY House 14 2019-01-03 2027-01-03 1 N00041162 ["H8NY15148"] 412804   180416   Alexandria Ocasio-Cortez Alexandria Ocasio-Cortez 1989-10-13 F 5   15 102 58 3087 1230858
D000018 Alfonse D’Amato Alfonse D’Amato   Republican NY Senate   1981-01-05 1999-01-03 0   [] 403142 01313   S147 Al D'Amato   1937-08-01 M 4 1999-01-03 0 777 0 0 0
B000003 Alfred Babcock Alfred Babcock   Whig NY House 33 1841-05-31 1843-03-03 0   [] 401009       Alfred Babcock   1805-04-15 M 2 1843-03-03 0 0 0 0 0
B000320 Alfred Beiter Alfred Beiter   Democrat NY House 41 1933-03-09 1943-01-03 0   [] 401312       Alfred F. Beiter   1894-07-07 M 6 1943-01-03 0 0 0 0 0
C000304 Alfred Chapin Alfred Chapin   Democrat NY House 1 1891-12-07 1893-03-03 0   [] 402446       Alfred C. Chapin   1848-03-08 M 2 1893-03-03 0 0 0 0 0
C000679 Alfred Conkling Alfred Conkling   Republican NY House 14 1821-12-03 1823-03-03 0   [] 402805       Alfred Conkling   1789-10-12 M 2 1823-03-03 0 0 0 0 0
E000164 Alfred Ely Alfred Ely   Republican NY House 29 1859-12-05 1863-03-03 0   [] 403855       Alfred Ely   1815-02-15 M 3 1863-03-03 0 0 0 0 0
S000057 Alfred Santangelo Alfred Santangelo   Democrat NY House 18 1957-01-03 1963-01-03 0   [] 409571       Alfred E. Santangelo   1912-06-04 M 4 1963-01-03 0 0 0 0 0
W000280 Alfred Wells Alfred Wells   Republican NY House 27 1859-12-05 1861-03-03 0   [] 411445       Alfred Wells   1814-05-27 M 2 1861-03-03 0 0 0 0 0
L000477 Allard Lowenstein Allard Lowenstein   Democrat NY House 5 1969-01-03 1971-01-03 0   [] 406966       Allard K. Lowenstein   1929-01-16 M 2 1971-01-03 0 0 0 0 0
W000038 Alton Waldon Alton Waldon   Democrat NY House 6 1985-01-03 1987-01-03 0   [] 411218 01194     Alton Waldon   1936-12-21 M 2 1987-01-03 0 0 0 0 0
D000020 Amasa Dana Amasa Dana   Democrat NY House 26 1839-12-02 1845-03-03 0   [] 403161       Amasa Dana   1792-10-19 M 4 1845-03-03 0 0 0 0 0
P000054 Amasa Parker Amasa Parker   Democrat NY House 20 1837-09-04 1839-03-03 0   [] 408464       Amasa J. Parker   1807-06-02 M 2 1839-03-03 0 0 0 0 0
J000044 Amaziah James Amaziah James   Republican NY House 19 1877-10-15 1881-03-03 0   [] 405949       Amaziah B. James   1812-07-01 M 3 1881-03-03 0 0 0 0 0
C000420 Ambrose Clark Ambrose Clark   Republican NY House 20 1861-07-04 1865-03-03 0   [] 402559       Ambrose W. Clark   1810-02-19 M 3 1865-03-03 0 0 0 0 0
M001105 Ambrose Murray Ambrose Murray   Republican NY House 10 1855-12-03 1859-03-03 0   [] 408069       Ambrose S. Murray   1807-11-27 M 3 1859-03-03 0 0 0 0 0
S000721 Ambrose Spencer Ambrose Spencer     NY House 10 1829-12-07 1831-03-03 0   [] 410190       Ambrose Spencer   1765-12-13 M 2 1831-03-03 0 0 0 0 0
H000814 Amory Houghton Amory Houghton Amo Republican NY House 29 1987-01-06 2005-01-03 0 N00001329 ["H6NY34069"] 400188 00563     Amo Houghton   1926-08-07 M 10 2005-01-03 0 254 35 1220 0
C000983 Amos Cummings Amos Cummings   Democrat NY House 10 1887-12-05 1903-03-03 0   [] 403092       Amos J. Cummings   1841-05-15 M 9 1903-03-03 0 0 0 0 0
G000373 Amos Granger Amos Granger   Republican NY House 24 1855-12-03 1859-03-03 0   [] 404725       Amos P. Granger   1789-06-03 M 3 1859-03-03 0 0 0 0 0
B000984 Andrew Bruyn Andrew Bruyn   Democrat NY House 22 1837-09-04 1839-03-03 0   [] 401936       Andrew DeWitt Bruyn   1790-11-18 M 2 1839-03-03 0 0 0 0 0
D000400 Andrew Doig Andrew Doig   Democrat NY House 16 1839-12-02 1843-03-03 0   [] 403514       Andrew W. Doig   1799-07-24 M 3 1843-03-03 0 0 0 0 0
M000319 Andrew McCarty Andrew McCarty   Ind. Republican-Democrat NY House 22 1855-12-03 1857-03-03 0   [] 407330       Andrew Z. McCarty   1808-07-14 M 2 1857-03-03 0 0 0 0 0
M000359 Andrew McCord Andrew McCord   Republican NY House 5 1803-10-17 1805-03-03 0   [] 412166       Andrew McCord     M 2 1805-03-03 0 0 0 0 0
O000070 Andrew Oliver Andrew Oliver   Democrat NY House 26 1853-12-05 1857-03-03 0   [] 408343       Andrew Oliver (New York politician)   1815-01-16 M 3 1857-03-03 0 0 0 0 0
P000257 Andrew Petersen Andrew Petersen   Republican NY House 9 1921-04-11 1923-03-03 0   [] 408660       Andrew Petersen   1870-03-10 M 2 1923-03-03 5 0 0 0 0
G000597 Andrew Garbarino Andrew R. Garbarino   Republican NY House 2 2021-01-03 2027-01-03 1 N00046030 ["H0NY02234"] 456836       Andrew Garbarino   1984-09-27 M 4   31 50 89 2135 12272948
S000676 Andrew Somers Andrew Somers   Democrat NY House 10 1925-12-07 1951-01-03 0   [] 410148       Andrew Lawrence Somers   1895-03-21 M 14 1951-01-03 0 0 0 0 0
W000488 Andrew Williams Andrew Williams   Republican NY House 18 1875-12-06 1879-03-03 0   [] 411645       Andrew Williams (congressman)   1828-08-27 M 3 1879-03-03 0 0 0 0 0
R000422 Angelo Roncallo Angelo Roncallo   Republican NY House 3 1973-01-03 1975-01-03 0   [] 409387 00982     Angelo D. Roncallo   1927-05-28 M 2 1975-01-03 0 0 0 0 0
B001276 Ann Marie Buerkle Ann Marie Buerkle   Republican NY House 25 2011-01-05 2013-01-03 0 N00031640 ["H0NY25078"] 412456 02045 127047   Ann Marie Buerkle   1951-05-08 F 2 2013-01-03 6 77 17 1605 4865980
P000495 Anning Prall Anning Prall   Democrat NY House 11 1923-12-03 1935-01-03 0   [] 408880       Anning Smith Prall   1870-09-17 M 7 1935-01-03 0 0 0 0 0
B000901 Anson Brown Anson Brown   Whig NY House 11 1839-12-02 1841-03-03 0   [] 401858       Anson Brown     M 2 1841-03-03 0 0 0 0 0
H000537 Anson Herrick Anson Herrick   Democrat NY House 9 1863-12-07 1865-03-03 0   [] 405399       Anson Herrick   1812-01-21 M 2 1865-03-03 0 0 0 0 0
M000358 Anson McCook Anson McCook   Republican NY House 8 1877-10-15 1883-03-03 0   [] 407364       Anson G. McCook   1835-10-10 M 4 1883-03-03 0 0 0 0 0
B001308 Anthony Brindisi Anthony Brindisi   Democrat NY House 22 2019-01-03 2021-01-03 0 N00041385 ["H8NY22151"] 412806   135258   Anthony Brindisi Anthony Brindisi 1978-11-22 M 2 2021-01-03 8 22 21 952 20226223
D000632 Anthony D'Esposito Anthony D’Esposito   Republican NY House 4 2023-01-03 2025-01-03 0 N00050681 ["H2NY04277"] 456922   174091   Anthony D'Esposito Anthony D'Esposito 1982-02-22 M 2 2025-01-03 4 64 34 1241 14544835
E000095 Anthony Eickhoff Anthony Eickhoff   Democrat NY House 7 1877-10-15 1879-03-03 0   [] 403786       Anthony Eickhoff   1827-09-11 M 2 1879-03-03 0 0 0 0 0
G000457 Anthony Griffin Anthony Griffin   Democrat NY House 22 1917-04-02 1937-01-03 0   [] 404802       Anthony J. Griffin   1866-04-01 M 11 1937-01-03 0 0 0 0 0
T000056 Anthony Tauriello Anthony Tauriello   Democrat NY House 43 1949-01-03 1951-01-03 0   [] 410644       Anthony F. Tauriello   1899-08-14 M 2 1951-01-03 0 0 0 0 0
W000792 Anthony Weiner Anthony Weiner   Democrat NY House 9 1999-01-06 2011-06-21 0 N00001110 ["H8NY09091"] 400426 01597 23162   Anthony Weiner   1964-09-04 M 7 2011-06-21 7 388 165 6345 252166
D000630 Antonio Delgado Antonio Delgado   Democrat NY House 19 2019-01-03 2022-05-25 0 N00040741 ["H8NY19181"] 412805   180313   Antonio Delgado Antonio Delgado (New York) 1977-01-28 M 2 2022-05-25 13 51 53 1401 8357625
B000558 Archibald Bliss Archibald Bliss   Democrat NY House 5 1875-12-06 1889-03-03 0   [] 401532       Archibald M. Bliss   1838-01-25 M 8 1889-03-03 0 0 0 0 0
C000456 Archibald Clarke Archibald Clarke   Republican NY House 21 1815-12-04 1817-03-03 0   [] 402594       Archibald S. Clarke     M 2 1817-03-03 0 0 0 0 0
L000335 Archibald Linn Archibald Linn   Whig NY House 11 1841-05-31 1843-03-03 0   [] 406828       Archibald L. Linn   1802-10-15 M 2 1843-03-03 0 0 0 0 0
N000112 Archibald Niven Archibald Niven   Democrat NY House 9 1845-12-01 1847-03-03 0   [] 408196       Archibald C. Niven   1803-12-08 M 2 1847-03-03 0 0 0 0 0
S000032 Archie Sanders Archie Sanders   Republican NY House 39 1917-04-02 1933-03-03 0   [] 409550       Archie D. Sanders   1857-06-17 M 9 1933-03-03 0 0 0 0 0
K000266 Ardolph Kline Ardolph Kline   Republican NY House 5 1921-04-11 1923-03-03 0   [] 406424       Ardolph L. Kline   1858-02-21 M 2 1923-03-03 0 0 0 0 0
L000437 Arphaxed Loomis Arphaxed Loomis   Democrat NY House 16 1837-09-04 1839-03-03 0   [] 406928       Arphaxed Loomis   1798-04-09 M 2 1839-03-03 0 0 0 0 0
K000261 Arthur Klein Arthur Klein   Democrat NY House 19 1941-01-03 1957-01-03 0   [] 406419       Arthur G. Klein   1904-08-08 M 9 1957-01-03 0 0 0 0 0
T000302 Arthur Tompkins Arthur Tompkins   Republican NY House 17 1899-12-04 1903-03-03 0   [] 410875       Arthur S. Tompkins   1865-08-26 M 3 1903-03-03 0 0 0 0 0
M000668 Arunah Metcalf Arunah Metcalf   Republican NY House 12 1811-11-04 1813-03-03 0   [] 407654       Arunah Metcalf   1771-08-15 M 2 1813-03-03 0 0 0 0 0
A000056 Asa Adgate Asa Adgate   Republican NY House 12 1815-12-04 1817-03-03 0   [] 400716       Asa Adgate   1767-11-17 M 2 1817-03-03 0 0 0 0 0
F000156 Asa Fitch Asa Fitch   Federalist NY House 6 1811-11-04 1813-03-03 0   [] 404111       Asa Fitch (politician)   1765-11-10 M 2 1813-03-03 0 0 0 0 0
F000157 Ashbel Fitch Ashbel Fitch   Democrat NY House 15 1887-12-05 1895-03-03 0   [] 404112       Ashbel P. Fitch   1848-10-08 M 5 1895-03-03 0 0 0 0 0
T000447 Asher Tyler Asher Tyler   Whig NY House 31 1843-12-04 1845-03-03 0   [] 411015       Asher Tyler   1798-05-10 M 2 1845-03-03 0 0 0 0 0
B000367 Augustus Bennet Augustus Bennet   Republican NY House 29 1945-01-03 1947-01-03 0   [] 401359       Augustus W. Bennet   1897-10-07 M 2 1947-01-03 0 0 0 0 0
F000338 Augustus Frank Augustus Frank   Republican NY House 29 1859-12-05 1865-03-03 0   [] 404287       Augustus Frank   1826-07-17 M 4 1865-03-03 0 0 0 0 0
H000152 Augustus Hand Augustus Hand   Democrat NY House 13 1839-12-02 1841-03-03 0   [] 405034       Augustus C. Hand   1803-09-04 M 2 1841-03-03 0 0 0 0 0
H000315 Augustus Hascall Augustus Hascall   Whig NY House 33 1851-12-01 1853-03-03 0   [] 405188       Augustus P. Hascall   1800-06-24 M 2 1853-03-03 0 0 0 0 0

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