congress_members
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
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
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);