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, 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 | fec_ids | thomas_id | lis_id | birthday | gender | terms_count | served_until | trade_count | speech_count | bills_sponsored | vote_count | fec_total_received | fec_ie_for | fec_ie_against |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R000162 | Abraham | Rencher | Abraham Rencher | Whig | NC | House | 10 | 1829-12-07 | 1843-03-03 | 0 | [] | 1798-08-12 | M | 8 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| V000084 | Abraham | Venable | Abraham Venable | Democrat | NC | House | 5 | 1847-12-06 | 1853-03-03 | 0 | [] | 1799-10-17 | M | 4 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000050 | Absalom | Tatom | Absalom Tatom | Republican | NC | House | 4 | 1795-12-07 | 1797-03-03 | 0 | [] | M | 2 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| M001240 | Addison | McDowell | Addison P. McDowell | Republican | NC | House | 6 | 2025-01-03 | 2027-01-03 | 1 | ["H4NC06177"] | 1994-01-21 | M | 2 | 0 | 32 | 17 | 645 | 692551 | 194137 | 0 | ||||
| J000208 | Alexander | Jones | Alexander Jones | Republican | NC | House | 7 | 1865-12-04 | 1871-03-03 | 0 | [] | 1822-07-21 | M | 4 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000166 | Alexander | Martin | Alexander Martin | Republican | NC | Senate | 1793-12-02 | 1799-03-03 | 0 | [] | M | 2 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
| M000622 | Alexander | Mebane | Alexander Mebane | NC | House | 4 | 1793-12-02 | 1795-03-03 | 0 | [] | 1744-11-26 | M | 2 | 1795-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| B001056 | Alfred | Bulwinkle | Alfred Bulwinkle | Democrat | NC | House | 11 | 1921-04-11 | 1951-01-03 | 0 | [] | 1883-04-21 | M | 16 | 1951-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000385 | Alfred | Dockery | Alfred Dockery | Whig | NC | House | 3 | 1845-12-01 | 1853-03-03 | 0 | [] | 1797-12-11 | M | 5 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000099 | Alfred | Gatlin | Alfred Gatlin | Crawford Republican | NC | House | 1 | 1823-12-01 | 1825-03-03 | 0 | [] | 1790-04-20 | M | 2 | 1825-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000479 | Alfred | Rowland | Alfred Rowland | Democrat | NC | House | 6 | 1887-12-05 | 1891-03-03 | 0 | [] | 1844-02-09 | M | 3 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000103 | Alfred | Scales | Alfred Scales | Democrat | NC | House | 5 | 1857-12-07 | 1885-03-03 | 0 | [] | 1827-11-26 | M | 15 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000002 | Alfred | Waddell | Alfred Waddell | Democrat | NC | House | 3 | 1871-03-04 | 1879-03-03 | 0 | [] | 1834-09-16 | M | 5 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000370 | Alma | Adams | Alma S. Adams | Democrat | NC | House | 12 | 2014-11-12 | 2027-01-03 | 1 | ["H4NC12100"] | 02201 | 1946-05-27 | F | 7 | 0 | 252 | 177 | 6421 | 3389931 | 254447 | 50000 | |||
| F000240 | Alonzo | Folger | Alonzo Folger | Democrat | NC | House | 5 | 1939-01-03 | 1943-01-03 | 0 | [] | 1888-07-09 | M | 3 | 1943-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000389 | Alonzo | Shuford | Alonzo Shuford | Populist | NC | House | 7 | 1895-12-02 | 1899-03-03 | 0 | [] | 1858-03-01 | M | 3 | 1899-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000240 | Alton | Lennon | Alton Lennon | Democrat | NC | House | 7 | 1953-07-10 | 1973-01-03 | 0 | [] | 1906-08-17 | M | 11 | 1973-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000249 | Alvin | Kitchin | Alvin Kitchin | Democrat | NC | House | 8 | 1957-01-03 | 1963-01-03 | 0 | [] | 1908-09-13 | M | 4 | 1963-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000804 | Anderson | Mitchell | Anderson Mitchell | Whig | NC | House | 13 | 1841-05-31 | 1843-03-03 | 0 | [] | 1800-06-13 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| A000302 | Archibald | Arrington | Archibald Arrington | Democrat | NC | House | 8 | 1841-05-31 | 1845-03-03 | 0 | [] | 1809-11-13 | M | 3 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000475 | Archibald | Henderson | Archibald Henderson | Federalist | NC | House | 2 | 1799-12-02 | 1803-03-03 | 0 | [] | 1768-08-07 | M | 3 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000302 | Archibald | McBryde | Archibald McBryde | Federalist | NC | House | 7 | 1809-05-22 | 1813-03-03 | 0 | [] | 1766-09-28 | M | 3 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000586 | Archibald | McNeill | Archibald McNeill | Jackson | NC | House | 7 | 1821-12-03 | 1827-03-03 | 0 | [] | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000489 | Archibald | Williams | Archibald Williams | Democrat | NC | House | 5 | 1891-12-07 | 1893-03-03 | 0 | [] | 1842-10-22 | M | 2 | 1893-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000456 | Asa | Biggs | Asa Biggs | Democrat | NC | Senate | 1845-12-01 | 1859-03-03 | 0 | [] | 1811-02-04 | M | 3 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| S000338 | Augustine | Shepperd | Augustine Shepperd | Whig | NC | House | 4 | 1827-12-03 | 1851-03-03 | 0 | [] | 1792-02-24 | M | 13 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000659 | Augustus | Merrimon | Augustus Merrimon | Democrat | NC | Senate | 1873-12-01 | 1879-03-03 | 0 | [] | 1830-09-15 | M | 2 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| Y000001 | Bartlett | Yancey | Bartlett Yancey | Republican | NC | House | 9 | 1813-05-24 | 1817-03-03 | 0 | [] | 1785-02-19 | M | 3 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000410 | Basil | Whitener | Basil Whitener | Democrat | NC | House | 10 | 1957-01-03 | 1969-01-03 | 0 | [] | 1915-05-14 | M | 7 | 1969-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000903 | Bedford | Brown | Bedford Brown | Democrat | NC | Senate | 1829-12-07 | 1841-03-03 | 0 | [] | 1795-06-06 | M | 3 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| B001062 | Benjamin | Bunn | Benjamin Bunn | Democrat | NC | House | 4 | 1889-12-02 | 1895-03-03 | 0 | [] | 1844-10-19 | M | 4 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000350 | Benjamin | Grady | Benjamin Grady | Democrat | NC | House | 3 | 1891-12-07 | 1895-03-03 | 0 | [] | 1831-10-10 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000368 | Benjamin | Hawkins | Benjamin Hawkins | Pro-Administration | NC | Senate | 1789-03-04 | 1795-03-03 | 0 | [] | 1754-08-15 | M | 2 | 1795-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| J000267 | Benjamin | Jordan | Benjamin Jordan | Democrat | NC | Senate | 1958-04-19 | 1973-01-03 | 0 | [] | 1896-09-08 | M | 3 | 1973-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000491 | Benjamin | Williams | Benjamin Williams | NC | House | 10 | 1793-12-02 | 1795-03-03 | 0 | [] | 1751-01-01 | M | 2 | 1795-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| E000226 | Bob | Etheridge | Bob Etheridge | Democrat | NC | House | 2 | 1997-01-07 | 2011-01-03 | 0 | ["H6NC02080"] | 01482 | 1941-08-07 | M | 8 | 2011-01-03 | 0 | 797 | 64 | 5966 | 806359 | 280 | 442769 | ||
| K000405 | Brad | Knott | Brad Knott | Republican | NC | House | 13 | 2025-01-03 | 2027-01-03 | 1 | ["H4NC13116"] | 1986-04-17 | M | 2 | 3 | 18 | 5 | 645 | 944985 | 1540530 | 365380 | ||||
| M001154 | R. | Miller | Brad Miller | Brad | Democrat | NC | House | 13 | 2003-01-07 | 2013-01-03 | 0 | ["H2NC13029"] | 01735 | 1953-05-19 | M | 6 | 2013-01-03 | 0 | 121 | 39 | 7572 | 558039 | 282 | 0 | |
| M000993 | Cameron | Morrison | Cameron Morrison | Democrat | NC | House | 10 | 1930-12-13 | 1945-01-03 | 0 | [] | 1869-10-05 | M | 8 | 1945-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000571 | Carl | Durham | Carl Durham | Democrat | NC | House | 6 | 1939-01-03 | 1961-01-03 | 0 | [] | 1892-08-28 | M | 12 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000104 | Cass | Ballenger | Cass Ballenger | Republican | NC | House | 10 | 1986-11-04 | 2005-01-03 | 0 | ["H6NC10117"] | 00050 | 1926-12-06 | M | 10 | 2005-01-03 | 0 | 537 | 84 | 1221 | 0 | 0 | 0 | ||
| A000015 | Charles | Abernethy | Charles Abernethy | Democrat | NC | House | 3 | 1921-04-11 | 1935-01-03 | 0 | [] | 1872-03-18 | M | 8 | 1935-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000845 | Charles | Britt | Charles Britt | Democrat | NC | House | 6 | 1983-01-03 | 1985-01-03 | 0 | [] | 00125 | 1942-06-29 | M | 2 | 1985-01-03 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | ||
| C000826 | Charles | Cowles | Charles Cowles | Republican | NC | House | 8 | 1909-03-15 | 1911-03-03 | 0 | [] | 1875-07-16 | M | 2 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000175 | Charles | Deane | Charles Deane | Democrat | NC | House | 8 | 1947-01-03 | 1957-01-03 | 0 | [] | 1898-11-01 | M | 6 | 1957-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| F000144 | Charles | Fisher | Charles Fisher | Democrat | NC | House | 10 | 1817-12-01 | 1841-03-03 | 0 | [] | 1789-10-20 | M | 13 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000761 | Charles | Hooks | Charles Hooks | Republican | NC | House | 5 | 1816-12-02 | 1825-03-03 | 0 | [] | 1768-02-20 | M | 5 | 1825-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000123 | Charles | Johnson | Charles Johnson | Republican | NC | House | 8 | 1801-12-07 | 1803-03-03 | 0 | [] | M | 2 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| J000205 | Charles | Jonas | Charles Jonas | Republican | NC | House | 9 | 1929-04-15 | 1931-03-03 | 0 | [] | 1876-08-14 | M | 2 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000206 | Charles | Jonas | Charles Jonas | Republican | NC | House | 9 | 1953-01-03 | 1973-01-03 | 0 | [] | 1904-12-09 | M | 11 | 1973-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000172 | Charles | Martin | Charles Martin | Populist | NC | House | 6 | 1895-12-02 | 1899-03-03 | 0 | [] | 1848-08-28 | M | 3 | 1899-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000324 | Charles | McClammy | Charles McClammy | Democrat | NC | House | 3 | 1887-12-05 | 1891-03-03 | 0 | [] | 1839-05-29 | M | 3 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000436 | Charles | Rose | Charles Rose | Democrat | NC | House | 7 | 1973-01-03 | 1997-01-03 | 0 | [] | 00986 | 1939-08-10 | M | 13 | 1997-01-03 | 0 | 49 | 189 | 0 | 0 | 0 | 0 | ||
| S000329 | Charles | Shepard | Charles Shepard | Democrat | NC | House | 4 | 1837-09-04 | 1841-03-03 | 0 | [] | 1808-12-05 | M | 3 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000827 | Charles | Stedman | Charles Stedman | Democrat | NC | House | 5 | 1911-04-04 | 1931-03-03 | 0 | [] | 1841-01-29 | M | 11 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000067 | Charles | Taylor | Charles Taylor | Republican | NC | House | 11 | 1991-01-03 | 2007-01-03 | 0 | ["H8NC11038"] | 01141 | 1941-01-23 | M | 9 | 2007-01-03 | 0 | 178 | 49 | 2435 | 0 | 0 | 0 | ||
| T000158 | Charles | Thomas | Charles Thomas | Republican | NC | House | 2 | 1871-03-04 | 1875-03-03 | 0 | [] | 1827-02-07 | M | 3 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000159 | Charles | Thomas | Charles Thomas | Democrat | NC | House | 3 | 1899-12-04 | 1911-03-03 | 0 | [] | 1861-08-21 | M | 7 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000419 | Charles | Whitley | Charles Whitley | Democrat | NC | House | 3 | 1977-01-04 | 1987-01-03 | 0 | [] | 01223 | 1927-01-03 | M | 6 | 1987-01-03 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | ||
| E000246 | Charles (Chuck) | Edwards | Chuck Edwards | Republican | NC | House | 11 | 2023-01-03 | 2027-01-03 | 1 | ["H2NC14050"] | 1960-09-13 | M | 3 | 0 | 143 | 41 | 1886 | 1099457 | 331879 | 0 | ||||
| K000250 | Claude | Kitchin | Claude Kitchin | Democrat | NC | House | 2 | 1901-12-02 | 1925-03-03 | 0 | [] | 1869-03-24 | M | 13 | 1925-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000463 | Clement | Dowd | Clement Dowd | Democrat | NC | House | 6 | 1881-12-05 | 1885-03-03 | 0 | [] | 1832-08-27 | M | 3 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000544 | Clinton | Cobb | Clinton Cobb | Republican | NC | House | 1 | 1869-03-04 | 1875-03-03 | 0 | [] | 1842-08-25 | M | 4 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000679 | Clyde | Hoey | Clyde Hoey | Democrat | NC | Senate | 1919-05-19 | 1954-05-12 | 0 | [] | 1877-12-11 | M | 6 | 1954-05-12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| B000863 | Curtis | Brogden | Curtis Brogden | Republican | NC | House | 2 | 1877-10-15 | 1879-03-03 | 0 | [] | 1816-11-06 | M | 2 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B001311 | Dan | Bishop | Dan Bishop | Republican | NC | House | 8 | 2019-09-17 | 2025-01-03 | 0 | ["H0NC09187"] | 1964-07-01 | M | 4 | 2025-01-03 | 15 | 161 | 41 | 2662 | 986116 | 1529047 | 1473323 | |||
| B000181 | Daniel | Barringer | Daniel Barringer | NC | House | 8 | 1826-12-04 | 1835-03-03 | 0 | [] | 1788-10-01 | M | 5 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| B000182 | Daniel | Barringer | Daniel Barringer | Whig | NC | House | 3 | 1843-12-04 | 1849-03-03 | 0 | [] | 1806-07-30 | M | 4 | 1849-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| F000278 | Daniel | Forney | Daniel Forney | Republican | NC | House | 11 | 1815-12-04 | 1819-03-03 | 0 | [] | M | 3 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| R000523 | Daniel | Russell | Daniel Russell | National Greenbacker | NC | House | 3 | 1879-03-18 | 1881-03-03 | 0 | [] | 1845-08-07 | M | 2 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000418 | Daniel | Turner | Daniel Turner | Jackson | NC | House | 6 | 1827-12-03 | 1829-03-03 | 0 | [] | 1796-09-21 | M | 2 | 1829-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000523 | David | Price | David E. Price | Democrat | NC | House | 4 | 1987-01-06 | 2023-01-03 | 0 | ["H6NC04037"] | 00930 | 1940-08-17 | M | 19 | 2023-01-03 | 81 | 673 | 186 | 13262 | 3202962 | 1703 | 0 | ||
| F000426 | David | Funderburk | David Funderburk | Republican | NC | House | 2 | 1995-01-04 | 1997-01-03 | 0 | [] | 00421 | 1944-04-28 | M | 2 | 1997-01-03 | 0 | 120 | 4 | 0 | 0 | 0 | 0 | ||
| H000048 | David | Hall | David Hall | Democrat | NC | House | 12 | 1959-01-07 | 1961-01-03 | 0 | [] | 1918-05-16 | M | 2 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000432 | David | Heaton | David Heaton | Republican | NC | House | 2 | 1867-03-04 | 1871-03-03 | 0 | [] | 1823-03-10 | M | 3 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000479 | David | Henderson | David Henderson | Democrat | NC | House | 3 | 1961-01-03 | 1977-01-03 | 0 | [] | 00530 | 1921-04-16 | M | 9 | 1977-01-03 | 0 | 0 | 92 | 0 | 0 | 0 | 0 | ||
| O000138 | David | Outlaw | David Outlaw | Whig | NC | House | 9 | 1847-12-06 | 1853-03-03 | 0 | [] | 1806-09-14 | M | 4 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000144 | David | Reid | David Reid | Democrat | NC | Senate | 1843-12-04 | 1859-03-03 | 0 | [] | 1813-04-19 | M | 3 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| R000603 | David | Rouzer | David Rouzer | Republican | NC | House | 7 | 2015-01-06 | 2027-01-03 | 1 | ["H2NC07096"] | 02256 | 1972-02-16 | M | 7 | 18 | 162 | 97 | 6373 | 6293478 | 249540 | 1802907 | |||
| S000955 | David | Stone | David Stone | Republican | NC | Senate | 1799-12-02 | 1815-03-03 | 0 | [] | 1770-02-17 | M | 3 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| R000305 | Deborah | Ross | Deborah K. Ross | Democrat | NC | House | 2 | 2021-01-03 | 2027-01-03 | 1 | ["H0NC02125"] | 1963-06-20 | F | 4 | 28 | 147 | 82 | 2884 | 2286081 | 18490 | 0 | ||||
| B001081 | Dempsey | Burges | Dempsey Burges | Republican | NC | House | 8 | 1795-12-07 | 1799-03-03 | 0 | [] | M | 3 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| D000230 | Donald | Davis | Donald G. Davis | Democrat | NC | House | 1 | 2023-01-03 | 2027-01-03 | 1 | ["H2NC02287"] | 1971-08-29 | M | 3 | 0 | 345 | 55 | 1886 | 3732534 | 4528278 | 16919 | ||||
| F000437 | Duncan | Faircloth | Duncan Faircloth | Lauch | Republican | NC | Senate | 1993-01-05 | 1999-01-03 | 0 | [] | 01329 | S227 | 1928-01-14 | M | 2 | 1999-01-03 | 0 | 410 | 72 | 0 | 0 | 0 | 0 | |
| M000437 | Duncan | McFarlan | Duncan McFarlan | Republican | NC | House | 7 | 1805-12-02 | 1807-03-03 | 0 | [] | M | 2 | 1807-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| R000545 | Earl | Ruth | Earl Ruth | Republican | NC | House | 8 | 1969-01-03 | 1975-01-03 | 0 | [] | 01005 | 1916-02-07 | M | 4 | 1975-01-03 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | ||
| P000270 | Ebenezer | Pettigrew | Ebenezer Pettigrew | Whig | NC | House | 3 | 1835-12-07 | 1837-03-03 | 0 | [] | 1783-03-10 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000507 | Edmond | Blackburn | Edmond Blackburn | Republican | NC | House | 8 | 1901-12-02 | 1907-03-03 | 0 | [] | 1868-09-22 | M | 4 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000181 | Edmund | Deberry | Edmund Deberry | Whig | NC | House | 3 | 1829-12-07 | 1851-03-03 | 0 | [] | 1787-08-14 | M | 12 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000512 | Edward | Dudley | Edward Dudley | Jackson | NC | House | 5 | 1829-12-07 | 1831-03-03 | 0 | [] | 1789-12-15 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000474 | Edward | Pou | Edward Pou | Democrat | NC | House | 4 | 1901-12-02 | 1935-01-03 | 0 | [] | 1863-09-09 | M | 18 | 1935-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000799 | Edward | Stanly | Edward Stanly | Whig | NC | House | 8 | 1837-09-04 | 1853-03-03 | 0 | [] | 1810-01-10 | M | 9 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000095 | Edwin | Reade | Edwin Reade | American | NC | House | 5 | 1855-12-03 | 1857-03-03 | 0 | [] | 1812-11-13 | M | 2 | 1857-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000231 | Edwin | Webb | Edwin Webb | Democrat | NC | House | 9 | 1903-11-09 | 1921-03-03 | 0 | [] | 1872-05-23 | M | 10 | 1921-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000498 | Eliza | Pratt | Eliza Pratt | Democrat | NC | House | 8 | 1945-01-03 | 1947-01-03 | 0 | [] | 1902-03-05 | F | 2 | 1947-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000601 | Elizabeth | Dole | Elizabeth Dole | Republican | NC | Senate | 2003-01-07 | 2009-01-03 | 0 | ["S2NC00083"] | 01698 | S292 | 1936-07-29 | F | 2 | 2009-01-03 | 0 | 246 | 74 | 1977 | -6569 | 12327 | 0 | ||
| C000494 | Eva | Clayton | Eva Clayton | Democrat | NC | House | 1 | 1992-11-03 | 2003-01-03 | 0 | ["H2NC01065"] | 00204 | 1934-09-16 | F | 6 | 2003-01-03 | 0 | 668 | 27 | 0 | 0 | 0 | 0 | ||
| A000092 | Evan | Alexander | Evan Alexander | Republican | NC | House | 10 | 1806-02-24 | 1809-03-03 | 0 | [] | M | 2 | 1809-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000050 | Felix | Walker | Felix Walker | Republican | NC | House | 12 | 1817-12-01 | 1823-03-03 | 0 | [] | 1753-07-19 | M | 4 | 1823-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000862 | Francis | Craige | Francis Craige | Democrat | NC | House | 7 | 1853-12-05 | 1861-03-03 | 0 | [] | 1811-03-13 | M | 5 | 1861-03-03 | 0 | 0 | 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,
fec_ids TEXT,
thomas_id TEXT,
lis_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, fec_ie_for INTEGER DEFAULT 0, fec_ie_against 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);