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

381 rows where 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 19

  • Democrat 174
  • Republican 122
  • Whig 22
  • Federalist 14
  • Jackson 13
  • - 11
  • Populist 7
  • Adams 3
  • American 3
  • Ind. Republican-Democrat 2
  • Pro-Administration 2
  • Anti-Administration 1
  • Conservative 1
  • Crawford Republican 1
  • Ind. Democrat 1
  • Independent 1
  • Jacksonian 1
  • National Greenbacker 1
  • Unknown 1

is_current 2

  • 0 365
  • 1 16

chamber 2

  • House 328
  • Senate 53

state 1

  • NC · 381 ✖
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   5 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
M000166 Alexander Martin Alexander Martin   Republican NC Senate   1793-12-02 1799-03-03 0   [] 407188       Alexander Martin     M 2 1799-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   16 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 2 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
B000456 Asa Biggs Asa Biggs   Democrat NC Senate   1845-12-01 1859-03-03 0   [] 401441       Asa Biggs   1811-02-04 M 3 1859-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
M000659 Augustus Merrimon Augustus Merrimon   Democrat NC Senate   1873-12-01 1879-03-03 0   [] 407645       Augustus Summerfield Merrimon   1830-09-15 M 2 1879-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
B000903 Bedford Brown Bedford Brown   Democrat NC Senate   1829-12-07 1841-03-03 0   [] 401860       Bedford Brown   1795-06-06 M 3 1841-03-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 4 0 0 0 0
H000368 Benjamin Hawkins Benjamin Hawkins   Pro-Administration NC Senate   1789-03-04 1795-03-03 0   [] 405237       Benjamin Hawkins   1754-08-15 M 2 1795-03-03 0 0 0 0 0
J000267 Benjamin Jordan Benjamin Jordan   Democrat NC Senate   1958-04-19 1973-01-03 0   [] 406159       B. Everett Jordan   1896-09-08 M 3 1973-01-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 4 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   10 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 10 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   7 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
H000679 Clyde Hoey Clyde Hoey   Democrat NC Senate   1919-05-19 1955-01-03 0   [] 405532       Clyde R. Hoey   1877-12-11 M 7 1955-01-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 21 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 122 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
R000144 David Reid David Reid   Democrat NC Senate   1843-12-04 1859-03-03 0   [] 409122       David Settle Reid   1813-04-19 M 3 1859-03-03 2 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   45 160 93 5621 8112382
S000955 David Stone David Stone   Republican NC Senate   1799-12-02 1815-03-03 0   [] 410414       David Stone (politician)   1770-02-17 M 3 1815-03-03 0 0 0 0 0
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   36 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   12 304 53 1686 8103105
F000437 Duncan Faircloth Duncan Faircloth Lauch Republican NC Senate   1993-01-05 1999-01-03 0   [] 403968 01329   S227 Lauch Faircloth   1928-01-14 M 2 1999-01-03 2 410 0 0 0
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
D000601 Elizabeth Dole Elizabeth Dole   Republican NC Senate   2003-01-07 2009-01-03 0 N00008071 ["S2NC00083"] 300035 01698 41533 S292 Elizabeth Dole   1936-07-29 F 2 2009-01-03 0 246 74 1977 5758
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

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 122.404ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API