congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
343 rows where party = "Federalist" sorted by full_name
This data as json, CSV (advanced)
Suggested facets: district, first_served, last_served, ballotpedia_id, terms_count, served_until, trade_count, first_served (date), last_served (date), birthday (date), served_until (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| O000041 | Aaron | Ogden | Aaron Ogden | Federalist | NJ | Senate | 1801-12-07 | 1803-03-03 | 0 | [] | 408324 | Aaron Ogden | 1756-12-03 | M | 1 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000297 | Abiel | Foster | Abiel Foster | Federalist | NH | House | -1 | 1789-03-04 | 1803-03-03 | 0 | [] | 404246 | Abiel Foster | 1735-08-08 | M | 8 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000453 | Abijah | Bigelow | Abijah Bigelow | Federalist | MA | House | 11 | 1809-05-22 | 1815-03-03 | 0 | [] | 401438 | Abijah Bigelow | 1775-12-05 | M | 4 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| N000161 | Abraham | Nott | Abraham Nott | Federalist | SC | House | 6 | 1799-12-02 | 1801-03-03 | 0 | [] | 408242 | Abraham Nott | 1768-02-05 | M | 2 | 1801-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 | ||||||
| H000176 | Alexander | Hanson | Alexander Hanson | Federalist | MD | Senate | 1813-05-24 | 1819-04-23 | 0 | [] | 405057 | Alexander C. Hanson | 1786-02-27 | M | 2 | 1819-04-23 | 16 | 0 | 0 | 0 | 0 | |||||||
| S000483 | Amos | Slaymaker | Amos Slaymaker | Federalist | PA | House | 3 | 1813-05-24 | 1815-03-03 | 0 | [] | 409971 | Amos Slaymaker | 1755-03-11 | M | 2 | 1815-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 | ||||||
| W000128 | Artemas | Ward | Artemas Ward | Federalist | MA | House | 1 | 1813-05-24 | 1817-03-03 | 0 | [] | 411303 | Artemas Ward Jr. | 1762-01-09 | M | 3 | 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 | ||||||
| L000539 | Asa | Lyon | Asa Lyon | Federalist | VT | House | 0 | 1815-12-04 | 1817-03-03 | 0 | [] | 407023 | Asa Lyon | 1763-12-31 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000821 | Asahel | Stearns | Asahel Stearns | Federalist | MA | House | 4 | 1815-12-04 | 1817-03-03 | 0 | [] | 410286 | Asahel Stearns | 1774-06-17 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000198 | Bailey | Bartlett | Bailey Bartlett | Federalist | MA | House | 11 | 1797-05-15 | 1801-03-03 | 0 | [] | 401197 | Bailey Bartlett | 1750-01-29 | M | 3 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000049 | Barent | Gardenier | Barent Gardenier | Federalist | NY | House | 5 | 1807-10-26 | 1811-03-03 | 0 | [] | 412042 | Barent Gardenier | 1776-07-28 | M | 3 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000030 | Benjamin | Adams | Benjamin Adams | Federalist | MA | House | 11 | 1815-12-04 | 1821-03-03 | 0 | [] | 400691 | Benjamin Adams (politician) | 1764-12-16 | M | 4 | 1821-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000669 | Benjamin | Bourne | Benjamin Bourne | Federalist | RI | House | -1 | 1789-03-04 | 1797-03-03 | 0 | [] | 401631 | Benjamin Bourne | 1755-09-09 | M | 5 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000904 | Benjamin | Brown | Benjamin Brown | Federalist | MA | House | 16 | 1815-12-04 | 1817-03-03 | 0 | [] | 401861 | Benjamin Brown (politician) | 1756-09-23 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000286 | Benjamin | Goodhue | Benjamin Goodhue | Federalist | MA | Senate | 1789-03-04 | 1800-11-08 | 0 | [] | 404647 | Benjamin Goodhue | 1748-09-20 | M | 2 | 1800-11-08 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000915 | Benjamin | Huger | Benjamin Huger | Federalist | SC | House | 3 | 1799-12-02 | 1817-03-03 | 0 | [] | 405760 | Benjamin Huger (congressman) | M | 10 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| O000102 | Benjamin | Orr | Benjamin Orr | Federalist | MA | House | 16 | 1817-12-01 | 1819-03-03 | 0 | [] | 408359 | Benjamin Orr (Massachusetts politician) | 1772-12-01 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000330 | Benjamin | Pickman | Benjamin Pickman | Federalist | MA | House | 2 | 1809-05-22 | 1811-03-03 | 0 | [] | 408727 | Benjamin Pickman Jr. | 1763-09-30 | M | 2 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000029 | Benjamin | Tallmadge | Benjamin Tallmadge | Federalist | CT | House | -1 | 1801-12-07 | 1817-03-03 | 0 | [] | 410618 | Benjamin Tallmadge | 1754-02-25 | M | 9 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000046 | Benjamin | Walker | Benjamin Walker | Federalist | NY | House | 9 | 1801-12-07 | 1803-03-03 | 0 | [] | 411226 | Benjamin Walker (Continental Army officer) | M | 2 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| C000394 | Bradbury | Cilley | Bradbury Cilley | Federalist | NH | House | -1 | 1813-05-24 | 1817-03-03 | 0 | [] | 402533 | Bradbury Cilley | 1760-02-01 | M | 3 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000604 | Cadwallader | Colden | Cadwallader Colden | Federalist | NY | House | 1 | 1821-12-03 | 1823-03-03 | 0 | [] | 402733 | Cadwallader D. Colden | 1769-04-04 | M | 2 | 1823-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000130 | Caleb | Ellis | Caleb Ellis | Federalist | NH | House | -1 | 1805-12-02 | 1807-03-03 | 0 | [] | 403821 | Caleb Ellis | 1767-04-16 | M | 2 | 1807-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001009 | Caleb | Strong | Caleb Strong | Federalist | MA | Senate | 1789-03-04 | 1797-03-03 | 0 | [] | 410466 | Caleb Strong | 1745-01-09 | M | 2 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000248 | Calvin | Goddard | Calvin Goddard | Federalist | CT | House | -1 | 1801-12-07 | 1807-03-03 | 0 | [] | 404610 | Calvin Goddard (politician) | 1768-07-17 | M | 4 | 1807-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000324 | Charles | Atherton | Charles Atherton | Federalist | NH | House | -1 | 1815-12-04 | 1817-03-03 | 0 | [] | 400972 | Charles Humphrey Atherton | 1773-08-14 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000261 | Charles | Goldsborough | Charles Goldsborough | Federalist | MD | House | 8 | 1805-12-02 | 1817-03-03 | 0 | [] | 404623 | Charles Goldsborough | 1765-07-15 | M | 7 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000146 | Charles | Marsh | Charles Marsh | Federalist | VT | House | 0 | 1815-12-04 | 1817-03-03 | 0 | [] | 407169 | Charles Marsh (American politician) | 1765-07-10 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000501 | Charles | Ruggles | Charles Ruggles | Federalist | NY | House | 7 | 1821-12-03 | 1823-03-03 | 0 | [] | 409460 | Charles H. Ruggles | 1789-02-10 | M | 2 | 1823-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000293 | Chauncey | Goodrich | Chauncey Goodrich | Federalist | CT | Senate | 1795-12-07 | 1813-03-03 | 0 | [] | 404652 | Chauncey Goodrich | 1759-10-20 | M | 4 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000066 | Chauncey | Langdon | Chauncey Langdon | Federalist | VT | House | 0 | 1815-12-04 | 1817-03-03 | 0 | [] | 406575 | Chauncey Langdon | 1763-11-08 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000289 | Christopher | Champlin | Christopher Champlin | Federalist | RI | Senate | 1797-05-15 | 1811-12-31 | 0 | [] | 402431 | Christopher G. Champlin | 1768-04-12 | M | 3 | 1811-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000322 | Christopher | Gore | Christopher Gore | Federalist | MA | Senate | 1813-05-24 | 1817-03-03 | 0 | [] | 404680 | Christopher Gore | 1758-09-21 | M | 1 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000197 | Cyrus | King | Cyrus King | Federalist | MA | House | 14 | 1813-05-24 | 1817-03-03 | 0 | [] | 406358 | Cyrus King | 1772-09-06 | M | 3 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000530 | Daniel | Blaisdell | Daniel Blaisdell | Federalist | NH | House | -1 | 1809-05-22 | 1811-03-03 | 0 | [] | 401505 | Daniel Blaisdell | 1762-01-22 | M | 2 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001014 | Daniel | Buck | Daniel Buck | Federalist | VT | House | 2 | 1795-12-07 | 1797-03-03 | 0 | [] | 401964 | Daniel Buck | 1753-11-09 | M | 2 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000014 | Daniel | Cady | Daniel Cady | Federalist | NY | House | 14 | 1815-12-04 | 1817-03-03 | 0 | [] | 402176 | Daniel Cady | 1773-04-29 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000366 | Daniel | Chipman | Daniel Chipman | Federalist | VT | House | 0 | 1815-12-04 | 1817-03-03 | 0 | [] | 402505 | Daniel Chipman | 1765-10-22 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000293 | Daniel | Dewey | Daniel Dewey | Federalist | MA | House | 12 | 1813-05-24 | 1815-03-03 | 0 | [] | 403418 | Daniel Dewey | 1766-01-29 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000946 | Daniel | Morgan | Daniel Morgan | Federalist | VA | House | 1 | 1797-05-15 | 1799-03-03 | 0 | [] | 407914 | Daniel Morgan | M | 2 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000317 | Daniel | Sheffey | Daniel Sheffey | Federalist | VA | House | 6 | 1809-05-22 | 1817-03-03 | 0 | [] | 409815 | Daniel Sheffey | M | 5 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000875 | David | Brooks | David Brooks | Federalist | NY | House | 5 | 1797-05-15 | 1799-03-03 | 0 | [] | 401832 | David Brooks (American politician) | M | 2 | 1799-03-03 | 1 | 0 | 0 | 0 | 0 | |||||||
| D000002 | David | Daggett | David Daggett | Federalist | CT | Senate | 1813-05-24 | 1819-03-03 | 0 | [] | 403146 | David Daggett | 1764-12-31 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000811 | David | Hough | David Hough | Federalist | NH | House | -1 | 1803-10-17 | 1807-03-03 | 0 | [] | 405659 | David Hough (politician) | 1753-03-13 | M | 3 | 1807-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000043 | David | Ogden | David Ogden | Federalist | NY | House | 18 | 1817-12-01 | 1819-03-03 | 0 | [] | 408326 | David A. Ogden | 1770-01-10 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000301 | Dwight | Foster | Dwight Foster | Federalist | MA | Senate | 1793-12-02 | 1803-12-31 | 0 | [] | 404250 | Dwight Foster (politician, born 1757) | 1757-12-07 | M | 2 | 1803-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000996 | Ebenezer | Huntington | Ebenezer Huntington | Federalist | CT | House | -1 | 1809-05-22 | 1819-03-03 | 0 | [] | 405836 | Ebenezer Huntington | 1754-12-26 | M | 6 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000259 | Ebenezer | Mattoon | Ebenezer Mattoon | Federalist | MA | House | 3 | 1799-12-02 | 1803-03-03 | 0 | [] | 407277 | Ebenezer Mattoon | 1755-08-19 | M | 3 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000650 | Edward | Colston | Edward Colston | Federalist | VA | House | 2 | 1817-12-01 | 1819-03-03 | 0 | [] | 402778 | Edward Colston (U.S. Representative) | 1786-12-25 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000363 | Edward | Livermore | Edward Livermore | Federalist | MA | House | 3 | 1807-10-26 | 1811-03-03 | 0 | [] | 406855 | Edward St. Loe Livermore | 1762-04-05 | M | 3 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000388 | Egbert | Benson | Egbert Benson | Federalist | NY | House | 2 | 1789-03-04 | 1815-03-03 | 0 | [] | 401379 | Egbert Benson | 1746-06-21 | M | 14 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000317 | Eli | Ashmun | Eli Ashmun | Federalist | MA | Senate | 1816-01-01 | 1819-03-03 | 0 | [] | 400963 | Eli P. Ashmun | 1770-06-24 | M | 1 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000231 | Elias | Perkins | Elias Perkins | Federalist | CT | House | -1 | 1801-12-07 | 1803-03-03 | 0 | [] | 408634 | Elias Perkins | 1767-04-05 | M | 2 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000833 | Elijah | Brigham | Elijah Brigham | Federalist | MA | House | 11 | 1811-11-04 | 1817-03-03 | 0 | [] | 401790 | Elijah Brigham | 1751-07-07 | M | 4 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000026 | Elijah | Paine | Elijah Paine | Federalist | VT | Senate | 1795-12-07 | 1801-03-03 | 0 | [] | 408437 | Elijah Paine | 1757-01-21 | M | 2 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| P000463 | Elisha | Potter | Elisha Potter | Federalist | RI | House | -1 | 1795-12-07 | 1815-03-03 | 0 | [] | 408849 | Elisha Reynolds Potter | 1764-11-05 | M | 11 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000644 | Elisha | Winter | Elisha Winter | Federalist | NY | House | 12 | 1813-05-24 | 1815-03-03 | 0 | [] | 411798 | Elisha I. Winter | 1781-07-15 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000294 | Elizur | Goodrich | Elizur Goodrich | Federalist | CT | House | -1 | 1799-12-02 | 1801-03-03 | 0 | [] | 404653 | Elizur Goodrich | 1761-03-24 | M | 2 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000288 | Epaphroditus | Champion | Epaphroditus Champion | Federalist | CT | House | -1 | 1807-10-26 | 1817-03-03 | 0 | [] | 402430 | Epaphroditus Champion | 1756-04-06 | M | 6 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000173 | Ezekiel | Gilbert | Ezekiel Gilbert | Federalist | NY | House | 6 | 1793-12-02 | 1797-03-03 | 0 | [] | 404539 | Ezekiel Gilbert | 1756-03-25 | M | 3 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000421 | Ezekiel | Whitman | Ezekiel Whitman | Federalist | ME | House | 2 | 1809-05-22 | 1823-03-03 | 0 | [] | 411580 | Ezekiel Whitman | 1776-03-09 | M | 8 | 1823-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000174 | Fisher | Ames | Fisher Ames | Federalist | MA | House | 8 | 1789-03-04 | 1797-03-03 | 0 | [] | 400829 | Fisher Ames | 1758-04-09 | M | 5 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000076 | Francis | Malbone | Francis Malbone | Federalist | RI | Senate | 1793-12-02 | 1809-12-31 | 0 | [] | 407104 | Francis Malbone | 1759-03-20 | M | 3 | 1809-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000367 | Francis | White | Francis White | Federalist | VA | House | 2 | 1813-05-24 | 1815-03-03 | 0 | [] | 412116 | Francis White (Virginia politician) | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000069 | Franklin | Davenport | Franklin Davenport | Federalist | NJ | House | 5 | 1798-12-05 | 1801-03-03 | 0 | [] | 403207 | Franklin Davenport | M | 2 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| F000368 | Frederick | Frelinghuysen | Frederick Frelinghuysen | Federalist | NJ | Senate | 1793-12-02 | 1797-03-03 | 0 | [] | 404314 | Frederick Frelinghuysen (general) | 1753-04-13 | M | 1 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000482 | Gaylord | Griswold | Gaylord Griswold | Federalist | NY | House | 15 | 1803-10-17 | 1805-03-03 | 0 | [] | 404827 | Gaylord Griswold | 1767-12-18 | M | 2 | 1805-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000026 | George | Baer | George Baer | Federalist | MD | House | 4 | 1797-05-15 | 1817-03-03 | 0 | [] | 401031 | George Baer Jr. | M | 11 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000733 | George | Bradbury | George Bradbury | Federalist | MA | House | 15 | 1813-05-24 | 1817-03-03 | 0 | [] | 401693 | George Bradbury (American politician) | 1770-10-10 | M | 3 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000009 | George | Cabot | George Cabot | Federalist | MA | Senate | 1791-10-24 | 1797-03-03 | 0 | [] | 402171 | George Cabot | 1752-12-03 | M | 2 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000254 | George | Dent | George Dent | Federalist | MD | House | 1 | 1793-12-02 | 1801-03-03 | 0 | [] | 403392 | George Dent | M | 5 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| E000089 | George | Ege | George Ege | Federalist | PA | House | 5 | 1795-12-07 | 1799-03-03 | 0 | [] | 403782 | George Ege | 1748-03-09 | M | 3 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000148 | George | Hancock | George Hancock | Federalist | VA | House | 5 | 1793-12-02 | 1797-03-03 | 0 | [] | 405030 | George Hancock (Virginia politician) | 1754-06-13 | M | 3 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000246 | George | Leonard | George Leonard | Federalist | MA | House | 7 | 1789-03-04 | 1797-03-03 | 0 | [] | 406749 | George Leonard (congressman) | 1729-07-04 | M | 5 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001052 | George | Sullivan | George Sullivan | Federalist | NH | House | -1 | 1811-11-04 | 1813-03-03 | 0 | [] | 410506 | George Sullivan (New Hampshire politician) | 1771-08-29 | M | 2 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000141 | George | Thatcher | George Thatcher | Federalist | MA | House | 14 | 1789-03-04 | 1801-03-03 | 0 | [] | 410723 | George Thatcher | 1754-04-12 | M | 7 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000262 | George | Tibbits | George Tibbits | Federalist | NY | House | 10 | 1803-10-17 | 1805-03-03 | 0 | [] | 410836 | George Tibbits | 1763-01-14 | M | 2 | 1805-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| U000022 | George | Upham | George Upham | Federalist | NH | House | -1 | 1801-12-07 | 1803-03-03 | 0 | [] | 411045 | George B. Upham | 1768-12-27 | M | 2 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000114 | George | Walton | George Walton | Federalist | GA | Senate | 1795-11-16 | 1796-02-20 | 0 | [] | 412123 | George Walton | M | 1 | 1796-02-20 | 0 | 0 | 0 | 0 | 0 | ||||||||
| M000976 | Gouverneur | Morris | Gouverneur Morris | Federalist | NY | Senate | 1800-01-01 | 1803-03-03 | 0 | [] | 407944 | Gouverneur Morris | 1752-01-31 | M | 1 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000555 | Harmanus | Bleecker | Harmanus Bleecker | Federalist | NY | House | 7 | 1811-11-04 | 1813-03-03 | 0 | [] | 401530 | Harmanus Bleecker | 1779-10-09 | M | 2 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000127 | Harrison | Otis | Harrison Otis | Federalist | MA | Senate | 1797-05-15 | 1823-03-03 | 0 | [] | 408380 | Harrison Gray Otis (politician) | 1765-10-08 | M | 5 | 1823-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000235 | Henry | Glen | Henry Glen | Federalist | NY | House | 8 | 1793-12-02 | 1801-03-03 | 0 | [] | 404597 | Henry Glen | 1739-07-13 | M | 5 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000115 | Henry | Latimer | Henry Latimer | Federalist | DE | Senate | 1793-12-02 | 1801-12-31 | 0 | [] | 406621 | Henry Latimer (politician) | 1752-04-24 | M | 2 | 1801-12-31 | 0 | 0 | 0 | 0 | 0 | |||||||
| L000195 | Henry | Lee | Henry Lee | Federalist | VA | House | 19 | 1799-12-02 | 1801-03-03 | 0 | [] | 406698 | Henry Lee III | 1756-01-29 | M | 2 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000367 | Henry | Livingston | Henry Livingston | Federalist | NY | House | 8 | 1803-10-17 | 1807-03-03 | 0 | [] | 406859 | Henry W. Livingston | M | 3 | 1807-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| S000976 | Henry | Storrs | Henry Storrs | Federalist | NY | House | 14 | 1817-12-01 | 1831-03-03 | 0 | [] | 410435 | Henry R. Storrs | 1787-09-03 | M | 8 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000722 | Henry | Woods | Henry Woods | Federalist | PA | House | 10 | 1799-12-02 | 1803-03-03 | 0 | [] | 411874 | Henry Woods (Pennsylvania politician) | M | 3 | 1803-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| K000282 | Herman | Knickerbocker | Herman Knickerbocker | Federalist | NY | House | 6 | 1809-05-22 | 1811-03-03 | 0 | [] | 406439 | Herman Knickerbocker | 1779-07-27 | M | 2 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000803 | Hezekiah | Hosmer | Hezekiah Hosmer | Federalist | NY | House | 6 | 1797-05-15 | 1799-03-03 | 0 | [] | 405652 | Hezekiah L. Hosmer | 1765-06-07 | M | 2 | 1799-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000840 | Hosea | Moffitt | Hosea Moffitt | Federalist | NY | House | 10 | 1813-05-24 | 1817-03-03 | 0 | [] | 407814 | Hosea Moffitt | 1757-11-17 | M | 3 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000131 | Hugh | Caperton | Hugh Caperton | Federalist | VA | House | 7 | 1813-05-24 | 1815-03-03 | 0 | [] | 402281 | Hugh Caperton | 1781-04-17 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000551 | Hugh | Williamson | Hugh Williamson | Federalist | NC | House | 4 | 1789-03-04 | 1793-03-03 | 0 | [] | 411707 | Hugh Williamson | 1735-12-05 | M | 3 | 1793-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000155 | Humphrey | Marshall | Humphrey Marshall | Federalist | KY | Senate | 1795-12-07 | 1801-03-03 | 0 | [] | 407176 | Humphrey Marshall (politician) | M | 2 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| D000057 | Isaac | Darlington | Isaac Darlington | Federalist | PA | House | 2 | 1817-12-01 | 1819-03-03 | 0 | [] | 403196 | Isaac Darlington | 1781-12-13 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000058 | Isaac | Parker | Isaac Parker | Federalist | MA | House | 12 | 1797-05-15 | 1799-03-03 | 0 | [] | 408468 | Isaac Parker (Massachusetts judge) | 1768-06-17 | M | 2 | 1799-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);