home / openregs

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

328 rows where chamber = "House" and state = "NC" sorted by full_name

✎ View and edit SQL

This data as json, CSV (advanced)

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

party 17

  • Democrat 147
  • Republican 105
  • Whig 19
  • Federalist 14
  • - 11
  • Jackson 11
  • Populist 6
  • Adams 3
  • American 3
  • Ind. Republican-Democrat 2
  • Anti-Administration 1
  • Conservative 1
  • Crawford Republican 1
  • Ind. Democrat 1
  • Independent 1
  • Jacksonian 1
  • National Greenbacker 1

is_current 2

  • 0 314
  • 1 14

state 1

  • NC · 328 ✖

chamber 1

  • House · 328 ✖
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
R000162 Abraham Rencher Abraham Rencher   Whig NC House 10 1829-12-07 1843-03-03 0   [] 409139       Abraham Rencher   1798-08-12 M 8 1843-03-03 0 0 0 0 0
V000084 Abraham Venable Abraham Venable   Democrat NC House 5 1847-12-06 1853-03-03 0   [] 411140       Abraham Watkins Venable   1799-10-17 M 4 1853-03-03 0 0 0 0 0
T000050 Absalom Tatom Absalom Tatom   Republican NC House 4 1795-12-07 1797-03-03 0   [] 410638       Absalom Tatom     M 2 1797-03-03 0 0 0 0 0
M001240 Addison McDowell Addison P. McDowell   Republican NC House 6 2025-01-03 2027-01-03 1 N00054055 ["H4NC06177"] 457001       Addison McDowell   1994-01-21 M 2   0 23 13 445 752221
J000208 Alexander Jones Alexander Jones   Republican NC House 7 1865-12-04 1871-03-03 0   [] 406103       Alexander H. Jones   1822-07-21 M 4 1871-03-03 0 0 0 0 0
M000622 Alexander Mebane Alexander Mebane     NC House 4 1793-12-02 1795-03-03 0   [] 407611       Alexander Mebane   1744-11-26 M 2 1795-03-03 0 0 0 0 0
B001056 Alfred Bulwinkle Alfred Bulwinkle   Democrat NC House 11 1921-04-11 1951-01-03 0   [] 402003       Alfred L. Bulwinkle   1883-04-21 M 16 1951-01-03 0 0 0 0 0
D000385 Alfred Dockery Alfred Dockery   Whig NC House 3 1845-12-01 1853-03-03 0   [] 403501       Alfred Dockery   1797-12-11 M 5 1853-03-03 0 0 0 0 0
G000099 Alfred Gatlin Alfred Gatlin   Crawford Republican NC House 1 1823-12-01 1825-03-03 0   [] 404471       Alfred Moore Gatlin   1790-04-20 M 2 1825-03-03 0 0 0 0 0
R000479 Alfred Rowland Alfred Rowland   Democrat NC House 6 1887-12-05 1891-03-03 0   [] 409440       Alfred Rowland   1844-02-09 M 3 1891-03-03 0 0 0 0 0
S000103 Alfred Scales Alfred Scales   Democrat NC House 5 1857-12-07 1885-03-03 0   [] 409613       Alfred Moore Scales   1827-11-26 M 15 1885-03-03 0 0 0 0 0
W000002 Alfred Waddell Alfred Waddell   Democrat NC House 3 1871-03-04 1879-03-03 0   [] 411181       Alfred Moore Waddell   1834-09-16 M 5 1879-03-03 0 0 0 0 0
A000370 Alma Adams Alma S. Adams   Democrat NC House 12 2014-11-12 2027-01-03 1 N00035451 ["H4NC12100"] 412607 02201 5935   Alma Adams Alma Adams 1946-05-27 F 7   0 251 169 5669 3586318
F000240 Alonzo Folger Alonzo Folger   Democrat NC House 5 1939-01-03 1943-01-03 0   [] 404194       Alonzo Dillard Folger   1888-07-09 M 3 1943-01-03 0 0 0 0 0
S000389 Alonzo Shuford Alonzo Shuford   Populist NC House 7 1895-12-02 1899-03-03 0   [] 409883       Alonzo C. Shuford   1858-03-01 M 3 1899-03-03 0 0 0 0 0
L000240 Alton Lennon Alton Lennon   Democrat NC House 7 1953-07-10 1973-01-03 0   [] 406743       Alton Lennon   1906-08-17 M 11 1973-01-03 0 0 0 0 0
K000249 Alvin Kitchin Alvin Kitchin   Democrat NC House 8 1957-01-03 1963-01-03 0   [] 406408       Alvin Paul Kitchin   1908-09-13 M 4 1963-01-03 0 0 0 0 0
M000804 Anderson Mitchell Anderson Mitchell   Whig NC House 13 1841-05-31 1843-03-03 0   [] 407780       Anderson Mitchell   1800-06-13 M 2 1843-03-03 0 0 0 0 0
A000302 Archibald Arrington Archibald Arrington   Democrat NC House 8 1841-05-31 1845-03-03 0   [] 400944       Archibald Hunter Arrington   1809-11-13 M 3 1845-03-03 0 0 0 0 0
H000475 Archibald Henderson Archibald Henderson   Federalist NC House 2 1799-12-02 1803-03-03 0   [] 405338       Archibald Henderson (politician)   1768-08-07 M 3 1803-03-03 0 0 0 0 0
M000302 Archibald McBryde Archibald McBryde   Federalist NC House 7 1809-05-22 1813-03-03 0   [] 407317       Archibald McBryde   1766-09-28 M 3 1813-03-03 0 0 0 0 0
M000586 Archibald McNeill Archibald McNeill   Jackson NC House 7 1821-12-03 1827-03-03 0   [] 412168       Archibald McNeill     M 4 1827-03-03 0 0 0 0 0
W000489 Archibald Williams Archibald Williams   Democrat NC House 5 1891-12-07 1893-03-03 0   [] 411646       A. H. A. Williams   1842-10-22 M 2 1893-03-03 0 0 0 0 0
S000338 Augustine Shepperd Augustine Shepperd   Whig NC House 4 1827-12-03 1851-03-03 0   [] 409835       Augustine Henry Shepperd   1792-02-24 M 13 1851-03-03 0 0 0 0 0
Y000001 Bartlett Yancey Bartlett Yancey   Republican NC House 9 1813-05-24 1817-03-03 0   [] 411935       Bartlett Yancey   1785-02-19 M 3 1817-03-03 0 0 0 0 0
W000410 Basil Whitener Basil Whitener   Democrat NC House 10 1957-01-03 1969-01-03 0   [] 411570       Basil Whitener   1915-05-14 M 7 1969-01-03 0 0 0 0 0
B001062 Benjamin Bunn Benjamin Bunn   Democrat NC House 4 1889-12-02 1895-03-03 0   [] 402009       Benjamin H. Bunn   1844-10-19 M 4 1895-03-03 0 0 0 0 0
G000350 Benjamin Grady Benjamin Grady   Democrat NC House 3 1891-12-07 1895-03-03 0   [] 404706       Benjamin F. Grady   1831-10-10 M 3 1895-03-03 0 0 0 0 0
W000491 Benjamin Williams Benjamin Williams     NC House 10 1793-12-02 1795-03-03 0   [] 411648       Benjamin Williams   1751-01-01 M 2 1795-03-03 0 0 0 0 0
E000226 Bob Etheridge Bob Etheridge   Democrat NC House 2 1997-01-07 2011-01-03 0 N00002269 ["H6NC02080"] 400125 01482 118   Bob Etheridge   1941-08-07 M 8 2011-01-03 0 797 40 5884 1311094
K000405 Brad Knott Brad Knott   Republican NC House 13 2025-01-03 2027-01-03 1 N00053743 ["H4NC13116"] 457004       Brad Knott   1986-04-17 M 2   3 9 3 445 2648577
M001154 R. Miller Brad Miller Brad Democrat NC House 13 2003-01-07 2013-01-03 0 N00025093 ["H2NC13029"] 400280 01735 10205   Brad Miller (politician)   1953-05-19 M 6 2013-01-03 0 121 39 7489 563463
M000993 Cameron Morrison Cameron Morrison   Democrat NC House 10 1930-12-13 1945-01-03 0   [] 407961       Cameron A. Morrison   1869-10-05 M 8 1945-01-03 0 0 0 0 0
D000571 Carl Durham Carl Durham   Democrat NC House 6 1939-01-03 1961-01-03 0   [] 403674       Carl T. Durham   1892-08-28 M 12 1961-01-03 0 0 0 0 0
B000104 Cass Ballenger Cass Ballenger   Republican NC House 10 1986-11-04 2005-01-03 0 N00002377 ["H6NC10117"] 400015 00050     Cass Ballenger   1926-12-06 M 10 2005-01-03 0 537 8 1220 0
A000015 Charles Abernethy Charles Abernethy   Democrat NC House 3 1921-04-11 1935-01-03 0   [] 400677       Charles Laban Abernethy   1872-03-18 M 8 1935-01-03 0 0 0 0 0
B000845 Charles Britt Charles Britt   Democrat NC House 6 1983-01-03 1985-01-03 0   [] 401802 00125     Charles Robin Britt   1942-06-29 M 2 1985-01-03 0 0 0 0 0
C000826 Charles Cowles Charles Cowles   Republican NC House 8 1909-03-15 1911-03-03 0   [] 402944       Charles H. Cowles   1875-07-16 M 2 1911-03-03 0 0 0 0 0
D000175 Charles Deane Charles Deane   Democrat NC House 8 1947-01-03 1957-01-03 0   [] 403337       Charles B. Deane   1898-11-01 M 6 1957-01-03 0 0 0 0 0
F000144 Charles Fisher Charles Fisher   Democrat NC House 10 1817-12-01 1841-03-03 0   [] 404099       Charles Fisher (congressman)   1789-10-20 M 13 1841-03-03 0 0 0 0 0
H000761 Charles Hooks Charles Hooks   Republican NC House 5 1815-12-04 1825-03-03 0   [] 405612       Charles Hooks   1768-02-20 M 6 1825-03-03 0 0 0 0 0
J000123 Charles Johnson Charles Johnson   Republican NC House 8 1801-12-07 1803-03-03 0   [] 412057       Charles Johnson (North Carolina politician)     M 2 1803-03-03 0 0 0 0 0
J000205 Charles Jonas Charles Jonas   Republican NC House 9 1929-04-15 1931-03-03 0   [] 406100       Charles A. Jonas   1876-08-14 M 2 1931-03-03 0 0 0 0 0
J000206 Charles Jonas Charles Jonas   Republican NC House 9 1953-01-03 1973-01-03 0   [] 406101       Charles R. Jonas   1904-12-09 M 11 1973-01-03 0 0 0 0 0
M000172 Charles Martin Charles Martin   Populist NC House 6 1895-12-02 1899-03-03 0   [] 407194       Charles H. Martin (North Carolina politician)   1848-08-28 M 3 1899-03-03 0 0 0 0 0
M000324 Charles McClammy Charles McClammy   Democrat NC House 3 1887-12-05 1891-03-03 0   [] 407334       Charles W. McClammy   1839-05-29 M 3 1891-03-03 0 0 0 0 0
R000436 Charles Rose Charles Rose   Democrat NC House 7 1973-01-03 1997-01-03 0   [] 409400 00986     Charlie Rose (politician)   1939-08-10 M 13 1997-01-03 0 49 0 0 0
S000329 Charles Shepard Charles Shepard   Democrat NC House 4 1837-09-04 1841-03-03 0   [] 409826       Charles Biddle Shepard   1808-12-05 M 3 1841-03-03 0 0 0 0 0
S000827 Charles Stedman Charles Stedman   Democrat NC House 5 1911-04-04 1931-03-03 0   [] 410291       Charles Manly Stedman   1841-01-29 M 11 1931-03-03 0 0 0 0 0
T000067 Charles Taylor Charles Taylor   Republican NC House 11 1991-01-03 2007-01-03 0 N00002383 ["H8NC11038"] 400398 01141     Charles Taylor (North Carolina politician)   1941-01-23 M 9 2007-01-03 0 178 9 2428 0
T000158 Charles Thomas Charles Thomas   Republican NC House 2 1871-03-04 1875-03-03 0   [] 410740       Charles R. Thomas (1827–1891)   1827-02-07 M 3 1875-03-03 0 0 0 0 0
T000159 Charles Thomas Charles Thomas   Democrat NC House 3 1899-12-04 1911-03-03 0   [] 410741       Charles R. Thomas (1861–1931)   1861-08-21 M 7 1911-03-03 0 0 0 0 0
W000419 Charles Whitley Charles Whitley   Democrat NC House 3 1977-01-04 1987-01-03 0   [] 411578 01223     Charles Whitley   1927-01-03 M 6 1987-01-03 0 0 0 0 0
E000246 Charles (Chuck) Edwards Chuck Edwards   Republican NC House 11 2023-01-03 2027-01-03 1 N00049670 ["H2NC14050"] 456914   166600   Chuck Edwards   1960-09-13 M 3   0 134 41 1686 1405486
K000250 Claude Kitchin Claude Kitchin   Democrat NC House 2 1901-12-02 1925-03-03 0   [] 406409       Claude Kitchin   1869-03-24 M 13 1925-03-03 0 0 0 0 0
D000463 Clement Dowd Clement Dowd   Democrat NC House 6 1881-12-05 1885-03-03 0   [] 403573       Clement Dowd   1832-08-27 M 3 1885-03-03 0 0 0 0 0
C000544 Clinton Cobb Clinton Cobb   Republican NC House 1 1869-03-04 1875-03-03 0   [] 402677       Clinton L. Cobb   1842-08-25 M 4 1875-03-03 0 0 0 0 0
B000863 Curtis Brogden Curtis Brogden   Republican NC House 2 1877-10-15 1879-03-03 0   [] 401820       Curtis Hooks Brogden   1816-11-06 M 2 1879-03-03 0 0 0 0 0
B001311 Dan Bishop Dan Bishop   Republican NC House 8 2019-09-17 2025-01-03 0 N00044335 ["H0NC09187"] 412844   92423   Dan Bishop Dan Bishop 1964-07-01 M 4 2025-01-03 15 161 41 2111 4093275
B000181 Daniel Barringer Daniel Barringer     NC House 8 1825-12-05 1835-03-03 0   [] 401180       Daniel Laurens Barringer   1788-10-01 M 6 1835-03-03 0 0 0 0 0
B000182 Daniel Barringer Daniel Barringer   Whig NC House 3 1843-12-04 1849-03-03 0   [] 401181       Daniel Moreau Barringer   1806-07-30 M 4 1849-03-03 0 0 0 0 0
F000278 Daniel Forney Daniel Forney   Republican NC House 11 1815-12-04 1819-03-03 0   [] 404228       Daniel Munroe Forney     M 3 1819-03-03 0 0 0 0 0
R000523 Daniel Russell Daniel Russell   National Greenbacker NC House 3 1879-03-18 1881-03-03 0   [] 409481       Daniel Lindsay Russell   1845-08-07 M 2 1881-03-03 0 0 0 0 0
T000418 Daniel Turner Daniel Turner   Jackson NC House 6 1827-12-03 1829-03-03 0   [] 410987       Daniel Turner (North Carolina politician)   1796-09-21 M 2 1829-03-03 0 0 0 0 0
P000523 David Price David E. Price   Democrat NC House 4 1987-01-06 2023-01-03 0 N00002260 ["H6NC04037"] 400326 00930 119   David Price (American politician) David Price 1940-08-17 M 19 2023-01-03 96 673 156 12627 3210296
F000426 David Funderburk David Funderburk   Republican NC House 2 1995-01-04 1997-01-03 0   [] 404367 00421     David Funderburk   1944-04-28 M 2 1997-01-03 0 120 0 0 0
H000048 David Hall David Hall   Democrat NC House 12 1959-01-07 1961-01-03 0   [] 404933       David McKee Hall   1918-05-16 M 2 1961-01-03 0 0 0 0 0
H000432 David Heaton David Heaton   Republican NC House 2 1867-03-04 1871-03-03 0   [] 405298       David Heaton   1823-03-10 M 3 1871-03-03 0 0 0 0 0
H000479 David Henderson David Henderson   Democrat NC House 3 1961-01-03 1977-01-03 0   [] 405342 00530     David N. Henderson   1921-04-16 M 9 1977-01-03 0 0 0 0 0
O000138 David Outlaw David Outlaw   Whig NC House 9 1847-12-06 1853-03-03 0   [] 408390       David Outlaw   1806-09-14 M 4 1853-03-03 0 0 0 0 0
R000603 David Rouzer David Rouzer   Republican NC House 7 2015-01-06 2027-01-03 1 N00033527 ["H2NC07096"] 412641 02256 102964   David Rouzer David Rouzer 1972-02-16 M 7   19 160 93 5621 8112382
R000305 Deborah Ross Deborah K. Ross   Democrat NC House 2 2021-01-03 2027-01-03 1 N00038565 ["H0NC02125"] 456831       Deborah Ross (politician) Deborah Ross 1963-06-20 F 4   28 136 69 2135 2113323
B001081 Dempsey Burges Dempsey Burges   Republican NC House 8 1795-12-07 1799-03-03 0   [] 402027       Dempsey Burgess     M 3 1799-03-03 0 0 0 0 0
D000230 Donald Davis Donald G. Davis   Democrat NC House 1 2023-01-03 2027-01-03 1 N00049636 ["H2NC02287"] 456912   102950   Don Davis (North Carolina politician) Donald Davis 1971-08-29 M 3   0 304 53 1686 8103105
M000437 Duncan McFarlan Duncan McFarlan   Republican NC House 7 1805-12-02 1807-03-03 0   [] 412074       Duncan McFarlan     M 2 1807-03-03 0 0 0 0 0
R000545 Earl Ruth Earl Ruth   Republican NC House 8 1969-01-03 1975-01-03 0   [] 409501 01005     Earl B. Ruth   1916-02-07 M 4 1975-01-03 0 0 0 0 0
P000270 Ebenezer Pettigrew Ebenezer Pettigrew   Whig NC House 3 1835-12-07 1837-03-03 0   [] 408670       Ebenezer Pettigrew   1783-03-10 M 2 1837-03-03 0 0 0 0 0
B000507 Edmond Blackburn Edmond Blackburn   Republican NC House 8 1901-12-02 1907-03-03 0   [] 401486       E. Spencer Blackburn   1868-09-22 M 4 1907-03-03 0 0 0 0 0
D000181 Edmund Deberry Edmund Deberry   Whig NC House 3 1829-12-07 1851-03-03 0   [] 403342       Edmund Deberry   1787-08-14 M 12 1851-03-03 0 0 0 0 0
D000512 Edward Dudley Edward Dudley   Jackson NC House 5 1829-12-07 1831-03-03 0   [] 403622       Edward Bishop Dudley   1789-12-15 M 2 1831-03-03 0 0 0 0 0
P000474 Edward Pou Edward Pou   Democrat NC House 4 1901-12-02 1935-01-03 0   [] 408859       Edward W. Pou   1863-09-09 M 18 1935-01-03 0 0 0 0 0
S000799 Edward Stanly Edward Stanly   Whig NC House 8 1837-09-04 1853-03-03 0   [] 410265       Edward Stanly   1810-01-10 M 9 1853-03-03 0 0 0 0 0
R000095 Edwin Reade Edwin Reade   American NC House 5 1855-12-03 1857-03-03 0   [] 409075       Edwin Godwin Reade   1812-11-13 M 2 1857-03-03 0 0 0 0 0
W000231 Edwin Webb Edwin Webb   Democrat NC House 9 1903-11-09 1921-03-03 0   [] 411399       Edwin Y. Webb   1872-05-23 M 10 1921-03-03 0 0 0 0 0
P000498 Eliza Pratt Eliza Pratt   Democrat NC House 8 1945-01-03 1947-01-03 0   [] 408883       Eliza Jane Pratt   1902-03-05 F 2 1947-01-03 0 0 0 0 0
C000494 Eva Clayton Eva Clayton   Democrat NC House 1 1992-11-03 2003-01-03 0   ["H2NC01065"] 400532 00204     Eva Clayton   1934-09-16 F 6 2003-01-03 0 668 0 0 0
A000092 Evan Alexander Evan Alexander   Republican NC House 10 1806-02-24 1809-03-03 0   [] 412132       Evan Shelby Alexander     M 2 1809-03-03 0 0 0 0 0
W000050 Felix Walker Felix Walker   Republican NC House 12 1817-12-01 1823-03-03 0   [] 411229       Felix Walker (American politician)   1753-07-19 M 4 1823-03-03 0 0 0 0 0
C000862 Francis Craige Francis Craige   Democrat NC House 7 1853-12-05 1861-03-03 0   [] 402977       F. Burton Craige   1811-03-13 M 5 1861-03-03 0 0 0 0 0
S000372 Francis Shober Francis Shober   Democrat NC House 6 1869-03-04 1873-03-03 0   [] 409866       Francis Edwin Shober   1831-03-12 M 3 1873-03-03 0 0 0 0 0
B001238 Frank Ballance Frank Ballance   Democrat NC House 1 2003-01-07 2004-06-11 0 N00025005 [] 400014 01734     Frank Ballance   1942-02-15 M 1 2004-06-11 0 41 6 907 0
C000156 Frank Carlyle Frank Carlyle   Democrat NC House 7 1949-01-03 1957-01-03 0   [] 402305       F. Ertel Carlyle   1897-04-07 M 5 1957-01-03 0 0 0 0 0
H000147 Franklin Hancock Franklin Hancock   Democrat NC House 5 1929-04-15 1939-01-03 0   [] 405029       Franklin Wills Hancock Jr.   1894-11-01 M 6 1939-01-03 0 0 0 0 0
H000452 Fred Heineman Fred Heineman   Republican NC House 4 1995-01-04 1997-01-03 0   [] 405317 00527     Fred Heineman   1929-12-28 M 2 1997-01-03 0 49 0 0 0
W000707 Frederick Woodard Frederick Woodard   Democrat NC House 2 1893-08-07 1897-03-03 0   [] 411859       Frederick A. Woodard   1854-02-12 M 3 1897-03-03 0 0 0 0 0
B001251 George Butterfield G. K. Butterfield G.K. Democrat NC House 1 2004-07-21 2022-12-30 0 N00027035 ["H4NC01046"] 400616 01761 41077   G. K. Butterfield G.K. Butterfield 1947-04-27 M 10 2022-12-30 0 639 118 11548 4385436
H000737 Gabriel Holmes Gabriel Holmes     NC House -1 1825-12-05 1831-03-03 0   [] 405588       Gabriel Holmes     M 4 1831-03-03 0 0 0 0 0
H001065 George Holding George Holding   Republican NC House 2 2013-01-03 2021-01-03 0 N00033399 ["H2NC13110"] 412553 02143 136462   George Holding George E.B. Holding 1968-04-17 M 5 2021-01-03 31 214 42 4690 6421339
H000755 George Hood George Hood   Democrat NC House 3 1915-12-06 1919-03-03 0   [] 405606       George E. Hood   1875-01-25 M 3 1919-03-03 0 0 0 0 0
M001075 George Mumford George Mumford   Republican NC House 10 1817-12-01 1819-03-03 0   [] 412081       George Mumford     M 2 1819-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);
Powered by Datasette · Queries took 720.389ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API