congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10,799 rows where chamber = "House" sorted by full_name
This data as json, CSV (advanced)
Suggested facets: gender, terms_count, first_served (date), last_served (date), birthday (date), served_until (date), fec_ids (array)
state >30
party >30
- Democrat 4,554
- Republican 4,428
- Whig 500
- Jackson 294
- Federalist 280
- - 224
- Adams 79
- Ind. Republican-Democrat 64
- American 41
- Populist 38
- Unionist 37
- Anti Jacksonian 31
- Anti Masonic 27
- Ind. Democrat 23
- National Greenbacker 18
- Independent 16
- Unconditional Unionist 14
- Ind. Republican 13
- Farmer-Labor 11
- Progressive 11
- Jacksonian 9
- Conservative 8
- Anti-Lecompton Democrat 7
- Liberal Republican 7
- Nullifier 7
- Anti-Jacksonian 6
- Free Soil 5
- Popular Democrat 5
- Readjuster 4
- Crawford Republican 3
- …
chamber 1
- House · 10,799 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| M001200 | A. | McEachin | A. Donald McEachin | Democrat | VA | House | 4 | 2017-01-03 | 2022-11-28 | 0 | N00039327 | ["H6VA04061"] | 412728 | 8230 | Donald McEachin | Donald McEachin | 1961-10-10 | M | 3 | 2022-11-28 | 22 | 143 | 68 | 2611 | 2124219 | |||
| F000465 | A. | Ferguson | A. Drew Ferguson IV | Republican | GA | House | 3 | 2017-01-03 | 2025-01-03 | 0 | N00039090 | ["H6GA03113"] | 412700 | 168132 | Drew Ferguson (politician) | Drew Ferguson | 1966-11-15 | M | 5 | 2025-01-03 | 22 | 99 | 39 | 3851 | 5994735 | |||
| F000296 | A. | Foster | A. Foster | Whig | NY | House | 23 | 1841-05-31 | 1843-03-03 | 0 | [] | 412038 | A. Lawrence Foster | 1802-09-17 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001314 | Aaron | Bean | Aaron Bean | Republican | FL | House | 4 | 2023-01-03 | 2027-01-03 | 1 | N00051369 | ["H2FL04211"] | 456888 | 53932 | Aaron Bean | Aaron Bean | 1967-01-25 | M | 3 | 4 | 137 | 40 | 1686 | 3394546 | ||||
| B000557 | Aaron | Bliss | Aaron Bliss | Republican | MI | House | 8 | 1889-12-02 | 1891-03-03 | 0 | [] | 401531 | Aaron T. Bliss | 1837-05-22 | M | 2 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000899 | Aaron | Brown | Aaron Brown | Democrat | TN | House | 6 | 1839-12-02 | 1845-03-03 | 0 | [] | 401856 | Aaron V. Brown | 1795-08-15 | M | 4 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000568 | Aaron | Cochrane | Aaron Cochrane | Republican | NY | House | 19 | 1897-03-15 | 1901-03-03 | 0 | [] | 402697 | Aaron Van Schaick Cochrane | 1858-03-14 | M | 3 | 1901-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000258 | Aaron | Ford | Aaron Ford | Democrat | MS | House | 4 | 1935-01-03 | 1943-01-03 | 0 | [] | 404210 | Aaron L. Ford | 1903-12-21 | M | 5 | 1943-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000006 | Aaron | Hackley | Aaron Hackley | Republican | NY | House | 17 | 1819-12-06 | 1821-03-03 | 0 | [] | 404891 | Aaron Hackley Jr. | 1783-05-06 | M | 2 | 1821-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000187 | Aaron | Harding | Aaron Harding | Democrat | KY | House | 4 | 1861-07-04 | 1867-03-03 | 0 | [] | 405068 | Aaron Harding | 1805-02-20 | M | 4 | 1867-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000207 | Aaron | Harlan | Aaron Harlan | Republican | OH | House | 7 | 1853-12-05 | 1859-03-03 | 0 | [] | 405086 | Aaron Harlan | 1802-09-08 | M | 4 | 1859-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000659 | Aaron | Hobart | Aaron Hobart | Adams | MA | House | 11 | 1819-12-06 | 1827-03-03 | 0 | [] | 405514 | Aaron Hobart | 1787-06-26 | M | 5 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000327 | Aaron | Kreider | Aaron Kreider | Republican | PA | House | 18 | 1913-04-07 | 1923-03-03 | 0 | [] | 406481 | Aaron S. Kreider | 1863-06-26 | M | 6 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000524 | Aaron | Lyle | Aaron Lyle | Republican | PA | House | 12 | 1809-05-22 | 1817-03-03 | 0 | [] | 407008 | Aaron Lyle | 1759-11-17 | M | 5 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000247 | Aaron | Matson | Aaron Matson | NH | House | -1 | 1821-12-03 | 1825-03-03 | 0 | [] | 407265 | Aaron Matson | M | 3 | 1825-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||||
| P000241 | Aaron | Perry | Aaron Perry | Republican | OH | House | 1 | 1871-03-04 | 1873-03-03 | 0 | [] | 408644 | Aaron F. Perry | 1815-01-01 | M | 2 | 1873-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001179 | Aaron | Schock | Aaron Schock | Republican | IL | House | 18 | 2009-01-06 | 2015-03-31 | 0 | N00029273 | ["H8IL18043"] | 412314 | 01920 | 33428 | Aaron Schock | Aaron Schock | 1981-05-28 | M | 4 | 2015-03-31 | 13 | 131 | 72 | 4608 | 3617141 | ||
| S000301 | Aaron | Shaw | Aaron Shaw | Democrat | IL | House | 16 | 1857-12-07 | 1885-03-03 | 0 | [] | 409800 | Aaron Shaw (representative) | 1811-12-19 | M | 15 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000875 | Aaron | Stevens | Aaron Stevens | Republican | NH | House | 2 | 1867-03-04 | 1871-03-03 | 0 | [] | 410337 | Aaron Fletcher Stevens | 1819-08-09 | M | 3 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000028 | Aaron | Vanderpoel | Aaron Vanderpoel | Democrat | NY | House | 8 | 1833-12-02 | 1841-03-03 | 0 | [] | 411122 | Aaron Vanderpoel | 1799-02-05 | M | 5 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000125 | Aaron | Ward | Aaron Ward | Democrat | NY | House | 4 | 1825-12-05 | 1843-03-03 | 0 | [] | 411300 | Aaron Ward (representative) | 1790-07-05 | M | 10 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000130 | Abbott | Lawrence | Abbott Lawrence | Whig | MA | House | 1 | 1835-12-07 | 1841-03-03 | 0 | [] | 406635 | Abbott Lawrence | 1792-12-16 | M | 4 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000467 | Abby | Finkenauer | Abby Finkenauer | Democrat | IA | House | 1 | 2019-01-03 | 2021-01-03 | 0 | N00040888 | ["H8IA01094"] | 412771 | 151127 | Abby Finkenauer | Abby Finkenauer | 1988-12-27 | F | 2 | 2021-01-03 | 6 | 16 | 39 | 952 | 9928559 | |||
| G000253 | Abe | Goff | Abe Goff | Republican | ID | House | 1 | 1947-01-03 | 1949-01-03 | 0 | [] | 404615 | Abe Goff | 1899-12-21 | M | 2 | 1949-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000994 | Abel | Huntington | Abel Huntington | Jackson | NY | House | 1 | 1833-12-02 | 1837-03-03 | 0 | [] | 405834 | Abel Huntington | 1777-02-21 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000461 | Abel | Wilder | Abel Wilder | Republican | KS | House | 1 | 1863-12-07 | 1865-03-03 | 0 | [] | 411618 | A. Carter Wilder | 1828-03-18 | M | 2 | 1865-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 | ||||||
| W000687 | Abiel | Wood | Abiel Wood | Republican | MA | House | 17 | 1813-05-24 | 1815-03-03 | 0 | [] | 411839 | Abiel Wood | 1772-07-22 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001209 | Abigail | Spanberger | Abigail Davis Spanberger | Democrat | VA | House | 7 | 2019-01-03 | 2025-01-03 | 0 | N00041418 | ["H8VA07094"] | 412833 | 179682 | Abigail Spanberger | Abigail Spanberger | 1979-08-07 | F | 4 | 2025-01-03 | 18 | 192 | 105 | 2642 | 29596418 | |||
| 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 | ||||||
| M000099 | Abijah | Mann | Abijah Mann | Jackson | NY | House | 16 | 1833-12-02 | 1837-03-03 | 0 | [] | 407123 | Abijah Mann Jr. | 1793-09-24 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000188 | Abner | Harding | Abner Harding | Republican | IL | House | 4 | 1865-12-04 | 1869-03-03 | 0 | [] | 405069 | Abner C. Harding | 1807-02-10 | M | 3 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000416 | Abner | Hazeltine | Abner Hazeltine | Whig | NY | House | 31 | 1833-12-02 | 1837-03-03 | 0 | [] | 405282 | Abner Hazeltine | 1793-06-10 | M | 3 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000270 | Abner | Lewis | Abner Lewis | Whig | NY | House | 31 | 1845-12-01 | 1847-03-03 | 0 | [] | 412063 | Abner Lewis | 1801-08-17 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000703 | Abner | Mikva | Abner Mikva | Democrat | IL | House | 10 | 1969-01-03 | 1981-01-03 | 0 | [] | 407686 | 00803 | Abner Mikva | 1926-01-21 | M | 7 | 1981-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| S000395 | Abner | Sibal | Abner Sibal | Republican | CT | House | 4 | 1961-01-03 | 1965-01-03 | 0 | [] | 409889 | Abner W. Sibal | 1921-04-11 | M | 3 | 1965-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000062 | Abner | Taylor | Abner Taylor | Republican | IL | House | 1 | 1889-12-02 | 1893-03-03 | 0 | [] | 410648 | Abner Taylor | M | 3 | 1893-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000142 | Abraham | Barker | Abraham Barker | Republican | PA | House | 17 | 1865-12-04 | 1867-03-03 | 0 | [] | 401143 | Abraham Andrews Barker | 1816-03-30 | M | 2 | 1867-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000581 | Abraham | Bockee | Abraham Bockee | Jackson | NY | House | 5 | 1829-12-07 | 1837-03-03 | 0 | [] | 401552 | Abraham Bockee | 1784-02-03 | M | 5 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000819 | Abraham | Brick | Abraham Brick | Republican | IN | House | 13 | 1899-12-04 | 1909-03-03 | 0 | [] | 401776 | Abraham L. Brick | 1860-05-27 | M | 6 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000418 | Abraham | Clark | Abraham Clark | NJ | House | -1 | 1791-10-24 | 1795-03-03 | 0 | [] | 402557 | Abraham Clark | 1726-02-15 | M | 3 | 1795-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000465 | Abraham | Dowdney | Abraham Dowdney | Democrat | NY | House | 12 | 1885-12-07 | 1887-03-03 | 0 | [] | 403575 | Abraham Dowdney | 1841-10-31 | M | 2 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000079 | Abraham | Garrett | Abraham Garrett | Democrat | TN | House | 3 | 1871-03-04 | 1873-03-03 | 0 | [] | 404451 | Abraham Ellison Garrett | 1830-03-06 | M | 2 | 1873-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000380 | Abraham | Grant | Abraham Grant | Democrat | NY | House | 17 | 1837-09-04 | 1839-03-03 | 0 | [] | 404731 | Abraham P. Grant | 1804-04-05 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000313 | Abraham | Hasbrouck | Abraham Hasbrouck | Republican | NY | House | 7 | 1813-05-24 | 1815-03-03 | 0 | [] | 405186 | Abraham J. Hasbrouck | 1773-10-16 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000312 | Abraham | Hasbrouck | Abraham Hasbrouck | Adams | NY | House | 7 | 1825-12-05 | 1827-03-03 | 0 | [] | 405185 | Abraham Bruyn Hasbrouck | 1791-11-29 | M | 2 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000805 | Abraham | Hostetler | Abraham Hostetler | Abram | Democrat | IN | House | 8 | 1879-03-18 | 1881-03-03 | 0 | [] | 405654 | Abraham J. Hostetler | 1818-11-22 | M | 2 | 1881-03-03 | 3 | 0 | 0 | 0 | 0 | |||||
| H001098 | Abraham | Hamadeh | Abraham J. Hamadeh | Republican | AZ | House | 8 | 2025-01-03 | 2027-01-03 | 1 | N00053795 | ["H4AZ08108"] | 456973 | Abraham Hamadeh | 1991-05-15 | M | 2 | 5 | 6 | 21 | 445 | 1475208 | ||||||
| K000025 | Abraham | Kazen | Abraham Kazen | Democrat | TX | House | 23 | 1967-01-10 | 1985-01-03 | 0 | [] | 406196 | 00621 | Abraham Kazen | 1919-01-17 | M | 10 | 1985-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| K000052 | Abraham | Keister | Abraham Keister | Republican | PA | House | 22 | 1913-04-07 | 1917-03-03 | 0 | [] | 406222 | Abraham Lincoln Keister | 1852-09-10 | M | 3 | 1917-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000015 | Abraham | Lafferty | Abraham Lafferty | Republican | OR | House | 3 | 1911-04-04 | 1915-03-03 | 0 | [] | 406525 | Walter Lafferty | 1875-06-10 | M | 3 | 1915-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000313 | Abraham | Lincoln | Abraham Lincoln | Whig | IL | House | 7 | 1847-12-06 | 1849-03-03 | 0 | [] | 406807 | Abraham Lincoln | Abraham Lincoln | 1809-02-12 | M | 2 | 1849-03-03 | 0 | 0 | 0 | 0 | 0 | |||||
| M000328 | Abraham | McClellan | Abraham McClellan | Democrat | TN | House | 2 | 1837-09-04 | 1843-03-03 | 0 | [] | 407338 | Abraham McClellan (Tennessee politician) | 1789-10-04 | M | 4 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000474 | Abraham | McIlvaine | Abraham McIlvaine | Whig | PA | House | 7 | 1843-12-04 | 1849-03-03 | 0 | [] | 407472 | Abraham Robinson McIlvaine | 1804-08-14 | M | 4 | 1849-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M001074 | Abraham | Multer | Abraham Multer | Democrat | NY | House | 13 | 1947-01-03 | 1969-01-03 | 0 | [] | 408040 | Abraham J. Multer | 1900-12-24 | M | 12 | 1969-01-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 | ||||||
| P000053 | Abraham | Parker | Abraham Parker | Republican | NY | House | 22 | 1881-12-05 | 1889-03-03 | 0 | [] | 408463 | Abraham X. Parker | 1831-11-14 | M | 5 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| 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 | ||||||
| S000115 | Abraham | Schenck | Abraham Schenck | Republican | NY | House | 4 | 1815-12-04 | 1817-03-03 | 0 | [] | 409623 | Abraham H. Schenck | 1775-01-22 | M | 2 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000122 | Abraham | Schermerhorn | Abraham Schermerhorn | Whig | NY | House | 28 | 1849-12-03 | 1853-03-03 | 0 | [] | 409630 | Abraham M. Schermerhorn | 1791-12-11 | M | 3 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000509 | Abraham | Smith | Abraham Smith | Republican | PA | House | 9 | 1873-12-01 | 1885-03-03 | 0 | [] | 409995 | A. Herr Smith | 1815-03-07 | M | 7 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000853 | Abraham | Stephens | Abraham Stephens | Democrat | NY | House | 7 | 1851-12-01 | 1853-03-03 | 0 | [] | 410316 | Abraham P. Stephens | 1796-02-18 | M | 2 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000030 | Abraham | Vanderveer | Abraham Vanderveer | Democrat | NY | House | 2 | 1837-09-04 | 1839-03-03 | 0 | [] | 411123 | Abraham Vanderveer | M | 2 | 1839-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 | ||||||
| A000240 | Abram | Andrew | Abram Andrew | Republican | MA | House | 6 | 1921-04-11 | 1937-01-03 | 0 | [] | 400869 | A. Piatt Andrew | 1873-02-12 | M | 9 | 1937-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000658 | Abram | Comingo | Abram Comingo | Democrat | MO | House | 8 | 1871-03-04 | 1875-03-03 | 0 | [] | 402785 | Abram Comingo | 1820-01-09 | M | 3 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000402 | Abram | Fulkerson | Abram Fulkerson | Readjuster Democrat | VA | House | 9 | 1881-12-05 | 1883-03-03 | 0 | [] | 404344 | Abram Fulkerson | 1834-05-13 | M | 2 | 1883-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000552 | Abram | Hewitt | Abram Hewitt | Democrat | NY | House | 10 | 1875-12-06 | 1887-03-03 | 0 | [] | 405414 | Abram Hewitt | 1822-07-31 | M | 7 | 1887-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000262 | Abram | Maury | Abram Maury | Whig | TN | House | 8 | 1835-12-07 | 1839-03-03 | 0 | [] | 407280 | Abram Poindexter Maury | 1801-12-26 | M | 3 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000066 | Abram | Olin | Abram Olin | Republican | NY | House | 13 | 1857-12-07 | 1863-03-03 | 0 | [] | 408339 | Abram B. Olin | 1808-09-21 | M | 4 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000368 | Abram | Trigg | Abram Trigg | Republican | VA | House | 6 | 1797-05-15 | 1809-03-03 | 0 | [] | 410937 | Abram Trigg | M | 7 | 1809-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| W000027 | Abram | Wakeman | Abram Wakeman | Ind. Republican-Democrat | NY | House | 8 | 1855-12-03 | 1857-03-03 | 0 | [] | 411206 | Abram Wakeman | 1824-05-31 | M | 2 | 1857-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000319 | Absalom | Chappell | Absalom Chappell | Whig | GA | House | -1 | 1843-12-04 | 1845-03-03 | 0 | [] | 402461 | Absalom H. Chappell | 1801-12-18 | M | 2 | 1845-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 | |||||||
| A000089 | Adam | Alexander | Adam Alexander | Jackson | TN | House | 9 | 1823-12-01 | 1827-03-03 | 0 | [] | 400748 | Adam Rankin Alexander | 1781-11-01 | M | 3 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000363 | Adam | Benjamin | Adam Benjamin | Democrat | IN | House | 1 | 1977-01-04 | 1983-01-03 | 0 | [] | 401355 | 00076 | Adam Benjamin Jr. | 1935-08-06 | M | 4 | 1983-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| B000714 | Adam | Boyd | Adam Boyd | Republican | NJ | House | -1 | 1803-10-17 | 1813-03-03 | 0 | [] | 401675 | Adam Boyd (politician) | 1746-03-21 | M | 6 | 1813-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B001207 | Adam | Byrd | Adam Byrd | Democrat | MS | House | 5 | 1903-11-09 | 1911-03-03 | 0 | [] | 402147 | Adam M. Byrd | 1859-07-06 | M | 5 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000242 | Adam | Glossbrenner | Adam Glossbrenner | Democrat | PA | House | 15 | 1865-12-04 | 1869-03-03 | 0 | [] | 404604 | Adam John Glossbrenner | 1810-08-31 | M | 3 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000605 | Adam | Gray | Adam Gray | Democrat | CA | House | 13 | 2025-01-03 | 2027-01-03 | 1 | N00050061 | ["H2CA13115"] | 456975 | Adam Gray | 1977-09-23 | M | 2 | 6 | 10 | 7 | 445 | 22104963 | ||||||
| H001000 | Adam | Huntsman | Adam Huntsman | Jackson | TN | House | 12 | 1835-12-07 | 1837-03-03 | 0 | [] | 405840 | Adam Huntsman | 1786-02-11 | M | 2 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000192 | Adam | King | Adam King | Jackson | PA | House | 10 | 1827-12-03 | 1833-03-03 | 0 | [] | 406353 | Adam King (congressman) | 1783-01-20 | M | 4 | 1833-03-03 | 1 | 0 | 0 | 0 | 0 | ||||||
| K000378 | Adam | Kinzinger | Adam Kinzinger | Republican | IL | House | 16 | 2011-01-05 | 2023-01-03 | 0 | N00030667 | ["H0IL11052"] | 412421 | 02014 | 116559 | Adam Kinzinger | Adam Kinzinger | 1978-02-27 | M | 7 | 2023-01-03 | 64 | 227 | 111 | 6744 | 7042104 | ||
| L000358 | Adam | Littlepage | Adam Littlepage | Democrat | WV | House | 6 | 1911-04-04 | 1919-03-03 | 0 | [] | 406850 | Adam Brown Littlepage | 1859-04-14 | M | 5 | 1919-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000477 | Adam | Powell | Adam Powell | Democrat | NY | House | 18 | 1945-01-03 | 1971-01-03 | 0 | [] | 408862 | Adam Clayton Powell Jr. | 1908-11-29 | M | 14 | 1971-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000586 | Adam | Putnam | Adam Putnam | Republican | FL | House | 12 | 2001-01-03 | 2011-01-03 | 0 | N00009618 | ["H0FL12051"] | 400328 | 01645 | 12913 | Adam Putnam | Adam Putnam | 1974-07-31 | M | 6 | 2011-01-03 | 5 | 315 | 70 | 5884 | 13130 | ||
| S000264 | Adam | Seybert | Adam Seybert | Republican | PA | House | 1 | 1809-05-22 | 1819-03-03 | 0 | [] | 409765 | Adam Seybert | 1773-05-16 | M | 6 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000510 | Adam | Smith | Adam Smith | Democrat | WA | House | 9 | 1997-01-07 | 2027-01-03 | 1 | N00007833 | ["H6WA09025"] | 400379 | 01528 | 845 | Adam Smith (Washington politician) | Adam Smith | 1965-06-15 | M | 16 | 38 | 716 | 182 | 14314 | 5979737 | |||
| S000664 | Adam | Snyder | Adam Snyder | Democrat | IL | House | 1 | 1837-09-04 | 1839-03-03 | 0 | [] | 410137 | Adam W. Snyder | 1799-10-06 | M | 2 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000776 | Adam | Wyant | Adam Wyant | Republican | PA | House | 31 | 1921-04-11 | 1933-03-03 | 0 | [] | 411925 | Adam Wyant | 1869-09-15 | M | 7 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000036 | Adamson | Tannehill | Adamson Tannehill | Republican | PA | House | 14 | 1813-05-24 | 1815-03-03 | 0 | [] | 410625 | Adamson Tannehill | 1750-05-23 | M | 2 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000043 | Addison | James | Addison James | Republican | KY | House | 3 | 1907-12-02 | 1909-03-03 | 0 | [] | 405948 | Addison James | 1849-02-27 | M | 2 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| L000017 | Addison | Laflin | Addison Laflin | Republican | NY | House | 20 | 1865-12-04 | 1871-03-03 | 0 | [] | 406527 | Addison H. Laflin | 1823-10-24 | M | 4 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000344 | Addison | McClure | Addison McClure | Republican | OH | House | 17 | 1881-12-05 | 1897-03-03 | 0 | [] | 407353 | Addison S. McClure | 1839-10-10 | M | 9 | 1897-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 | ||||||
| S000511 | Addison | Smith | Addison Smith | Republican | ID | House | 2 | 1913-04-07 | 1933-03-03 | 0 | [] | 409996 | Addison T. Smith | 1862-09-05 | M | 11 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000350 | Addison | White | Addison White | Whig | KY | House | 6 | 1851-12-01 | 1853-03-03 | 0 | [] | 411512 | Addison White | 1824-05-01 | M | 2 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| G000606 | Adelita | Grijalva | Adelita S. Grijalva | Democrat | AZ | House | 7 | 2025-11-12 | 2027-01-03 | 1 | ["H6AZ07121"] | 457037 | Adelita Grijalva | Adelita Grijalva | 1970-10-30 | F | 2 | 1 | 15 | 4 | 163 | 851360 | ||||||
| C000135 | Adin | Capron | Adin Capron | Republican | RI | House | 2 | 1897-03-15 | 1911-03-03 | 0 | [] | 402285 | Adin B. Capron | 1841-01-09 | M | 8 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000889 | Adlai | Stevenson | Adlai Stevenson | Democrat | IL | House | 13 | 1875-12-06 | 1881-03-03 | 0 | [] | 410350 | Adlai Stevenson I | 1835-10-23 | M | 4 | 1881-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);