congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5,276 rows where party = "Republican" 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 1
- Republican · 5,276 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||||
| B001133 | Aaron | Burr | Aaron Burr | Republican | NY | Senate | 1791-10-24 | 1797-03-03 | 0 | [] | 402077 | Aaron Burr | 1756-02-06 | M | 2 | 1797-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 | ||||||
| C000852 | Aaron | Cragin | Aaron Cragin | Republican | NH | Senate | 1855-12-03 | 1877-03-03 | 0 | [] | 402968 | Aaron H. Cragin | 1821-02-03 | M | 4 | 1877-03-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 | ||||||
| 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 | ||||||
| K000246 | Aaron | Kitchell | Aaron Kitchell | Republican | NJ | Senate | 1791-10-24 | 1809-12-31 | 0 | [] | 406405 | Aaron Kitchell | 1744-07-10 | M | 4 | 1809-12-31 | 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 | ||||||
| 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 | ||||||
| S000065 | Aaron | Sargent | Aaron Sargent | Republican | CA | Senate | 1861-07-04 | 1879-03-03 | 0 | [] | 409577 | Aaron A. Sargent | 1827-09-28 | M | 4 | 1879-03-03 | 2 | 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 | ||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| G000171 | Abijah | Gilbert | Abijah Gilbert | Republican | FL | Senate | 1849-12-03 | 1875-03-03 | 0 | [] | 404538 | Abijah Gilbert | 1806-06-18 | M | 5 | 1875-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 | ||||||
| L000011 | Abner | Lacock | Abner Lacock | Republican | PA | Senate | 1811-11-04 | 1819-03-03 | 0 | [] | 406521 | Abner Lacock | 1770-07-09 | M | 2 | 1819-03-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 | |||||||
| B000084 | Abraham | Baldwin | Abraham Baldwin | Republican | GA | Senate | 1789-03-04 | 1807-03-04 | 0 | [] | 401086 | Abraham Baldwin | 1754-11-22 | M | 4 | 1807-03-04 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| V000083 | Abraham | Venable | Abraham Venable | Republican | VA | Senate | 1791-10-24 | 1805-03-03 | 0 | [] | 411139 | Abraham B. Venable | 1758-11-20 | M | 3 | 1805-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 | ||||||
| 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 | |||||||
| W000486 | Abram | Williams | Abram Williams | Republican | CA | Senate | 1886-01-01 | 1887-03-03 | 0 | [] | 411643 | Abram Williams | 1832-02-03 | M | 1 | 1887-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 | |||||||
| 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 | ||||||
| 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 | ||
| 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 | ||||||
| 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 | ||||||
| F000298 | Addison | Foster | Addison Foster | Republican | WA | Senate | 1899-12-04 | 1905-03-03 | 0 | [] | 404247 | Addison G. Foster | 1837-01-28 | M | 2 | 1905-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 | ||||||
| A000172 | Adelbert | Ames | Adelbert Ames | Republican | MS | Senate | 1870-01-01 | 1875-03-03 | 0 | [] | 400827 | Adelbert Ames | 1835-10-31 | M | 1 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| 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 | ||||||
| J000113 | Adna | Johnson | Adna Johnson | Republican | OH | House | 10 | 1909-03-15 | 1911-03-03 | 0 | [] | 406014 | Adna R. Johnson | 1860-12-14 | M | 2 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| N000029 | Adolphus | Nelson | Adolphus Nelson | Republican | WI | House | 11 | 1917-04-02 | 1923-03-03 | 0 | [] | 408120 | Adolphus Peter Nelson | 1872-03-28 | M | 4 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000037 | Adolphus | Tanner | Adolphus Tanner | Republican | NY | House | 15 | 1869-03-04 | 1871-03-03 | 0 | [] | 410626 | Adolphus H. Tanner | 1833-05-23 | M | 2 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000261 | Adonijah | Welch | Adonijah Welch | Republican | FL | Senate | 1868-01-01 | 1869-03-03 | 0 | [] | 411429 | Adonijah Welch | 1821-04-12 | M | 1 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000733 | Adoniram | Holmes | Adoniram Holmes | Republican | IA | House | 10 | 1883-12-03 | 1889-03-03 | 0 | [] | 405584 | Adoniram J. Holmes | 1842-03-02 | M | 4 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S001172 | Adrian | Smith | Adrian Smith | Republican | NE | House | 3 | 2007-01-04 | 2027-01-03 | 1 | N00027623 | ["H6NE03115"] | 412217 | 01860 | 21284 | Adrian Smith (politician) | Adrian Smith | 1970-12-19 | M | 11 | 37 | 482 | 131 | 11886 | 8384271 | |||
| N000186 | Alan | Nunnelee | Alan Nunnelee | Republican | MS | House | 1 | 2011-01-05 | 2015-02-06 | 0 | N00031006 | ["H0MS01043"] | 412442 | 02034 | 8326 | Alan Nunnelee | Alan Nunnelee | 1958-10-09 | M | 3 | 2015-02-06 | 7 | 71 | 9 | 2860 | 2417347 | ||
| S000429 | Alan | Simpson | Alan Simpson | Republican | WY | Senate | 1979-01-15 | 1997-01-03 | 0 | [] | 409923 | 01435 | S142 | Alan Simpson (American politician) | 1931-09-02 | M | 4 | 1997-01-03 | 0 | 374 | 0 | 0 | 0 | |||||
| S000841 | Alan | Steelman | Alan Steelman | Republican | TX | House | 5 | 1973-01-03 | 1977-01-03 | 0 | [] | 410305 | 01106 | Alan Steelman | 1942-03-15 | M | 3 | 1977-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| W000688 | Alan | Wood | Alan Wood | Republican | PA | House | 7 | 1875-12-06 | 1877-03-03 | 0 | [] | 411840 | Alan Wood Jr. | 1834-07-06 | M | 2 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000813 | Alanson | Houghton | Alanson Houghton | Republican | NY | House | 37 | 1919-05-19 | 1923-03-03 | 0 | [] | 405661 | Alanson B. Houghton | 1863-10-10 | M | 3 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| K000182 | Alanson | Kimball | Alanson Kimball | Republican | WI | House | 6 | 1875-12-06 | 1877-03-03 | 0 | [] | 406344 | Alanson M. Kimball | 1827-03-12 | M | 2 | 1877-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| A000339 | Albert | Austin | Albert Austin | Republican | CT | House | 4 | 1939-01-03 | 1941-01-03 | 0 | [] | 400989 | Albert E. Austin | 1877-11-15 | M | 2 | 1941-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000245 | Albert | Baumhart | Albert Baumhart | Republican | OH | House | 13 | 1941-01-03 | 1961-01-03 | 0 | [] | 401239 | Albert David Baumhart Jr. | 1908-06-15 | M | 11 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000429 | Albert | Beveridge | Albert Beveridge | Republican | IN | Senate | 1899-12-04 | 1911-03-03 | 0 | [] | 401415 | Albert J. Beveridge | 1862-10-06 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| B000535 | Albert | Blakeney | Albert Blakeney | Republican | MD | House | 2 | 1901-12-02 | 1923-03-03 | 0 | [] | 401510 | Albert Blakeney | 1850-09-28 | M | 12 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000646 | Albert | Bosch | Albert Bosch | Republican | NY | House | 5 | 1953-01-03 | 1961-01-03 | 0 | [] | 401610 | Albert H. Bosch | 1908-10-30 | M | 5 | 1961-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000195 | Albert | Carter | Albert Carter | Republican | CA | House | 6 | 1925-12-07 | 1945-01-03 | 0 | [] | 402341 | Albert E. Carter | 1881-07-05 | M | 11 | 1945-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000606 | Albert | Cole | Albert Cole | Republican | KS | House | 1 | 1945-01-03 | 1953-01-03 | 0 | [] | 402735 | Albert M. Cole | 1901-10-13 | M | 5 | 1953-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000905 | Albert | Cretella | Albert Cretella | Republican | CT | House | 3 | 1953-01-03 | 1959-01-03 | 0 | [] | 403017 | Albert W. Cretella | 1897-04-22 | M | 4 | 1959-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| C000988 | Albert | Cummins | Albert Cummins | Republican | IA | Senate | 1908-11-24 | 1926-07-30 | 0 | [] | 403096 | Albert B. Cummins | 1850-02-15 | M | 4 | 1926-07-30 | 0 | 0 | 0 | 0 | 0 | |||||||
| D000150 | Albert | Dawson | Albert Dawson | Republican | IA | House | 2 | 1905-12-04 | 1911-03-03 | 0 | [] | 403283 | Albert F. Dawson | 1872-01-26 | M | 4 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000449 | Albert | Douglas | Albert Douglas | Republican | OH | House | 11 | 1907-12-02 | 1911-03-03 | 0 | [] | 403559 | Albert Douglas | 1852-04-25 | M | 3 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| E000178 | Albert | Engel | Albert Engel | Republican | MI | House | 9 | 1935-01-03 | 1951-01-03 | 0 | [] | 403868 | Albert J. Engel | 1888-01-01 | M | 9 | 1951-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| F000011 | Albert | Fall | Albert Fall | Republican | NM | Senate | 1912-03-27 | 1921-03-04 | 0 | [] | 403973 | Albert B. Fall | 1861-11-26 | M | 2 | 1921-03-04 | 0 | 0 | 0 | 0 | 0 | |||||||
| G000020 | Albert | Gallatin | Albert Gallatin | Republican | PA | House | 12 | 1795-12-07 | 1801-03-03 | 0 | [] | 404397 | Albert Gallatin | 1761-01-29 | M | 4 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000042 | Albert | Hall | Albert Hall | Republican | IN | House | 11 | 1925-12-07 | 1931-03-03 | 0 | [] | 404927 | Albert R. Hall (Indiana politician) | 1884-08-27 | M | 4 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000365 | Albert | Hawkes | Albert Hawkes | Republican | NJ | Senate | 1943-01-06 | 1949-01-03 | 0 | [] | 405234 | Albert W. Hawkes | 1878-11-20 | M | 2 | 1949-01-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000769 | Albert | Hopkins | Albert Hopkins | Republican | PA | House | 16 | 1891-12-07 | 1895-03-03 | 0 | [] | 405619 | Albert C. Hopkins | 1837-09-15 | M | 3 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000770 | Albert | Hopkins | Albert Hopkins | Republican | IL | Senate | 1885-12-07 | 1909-03-03 | 0 | [] | 405620 | Albert J. Hopkins | 1846-08-15 | M | 5 | 1909-03-03 | 0 | 0 | 0 | 0 | 0 | |||||||
| H000850 | Albert | Howe | Albert Howe | Republican | MS | House | 2 | 1873-12-01 | 1875-03-03 | 0 | [] | 405697 | Albert R. Howe | 1840-01-01 | M | 2 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000067 | Albert | Jefferis | Albert Jefferis | Republican | NE | House | 2 | 1919-05-19 | 1923-03-03 | 0 | [] | 405972 | Albert W. Jefferis | 1868-12-07 | M | 3 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000114 | Albert | Johnson | Albert Johnson | Republican | WA | House | 3 | 1913-04-07 | 1933-03-03 | 0 | [] | 406015 | Albert Johnson (congressman) | 1869-03-05 | M | 11 | 1933-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| J000115 | Albert | Johnson | Albert Johnson | Republican | PA | House | 23 | 1963-01-09 | 1977-01-03 | 0 | [] | 406016 | 00597 | Albert W. Johnson | 1906-04-17 | M | 8 | 1977-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| M000935 | Albert | Morano | Albert Morano | Republican | CT | House | 4 | 1951-01-03 | 1959-01-03 | 0 | [] | 407904 | Albert P. Morano | 1908-01-18 | M | 5 | 1959-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000435 | Albert | Porter | Albert Porter | Republican | IN | House | 6 | 1859-12-05 | 1863-03-03 | 0 | [] | 408826 | Albert G. Porter | 1824-04-20 | M | 3 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| Q000010 | Albert | Quie | Albert Quie | Republican | MN | House | 1 | 1957-01-03 | 1979-01-03 | 0 | [] | 408973 | 00936 | Al Quie | 1923-09-18 | M | 12 | 1979-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| R000137 | Albert | Reeves | Albert Reeves | Republican | MO | House | 5 | 1947-01-03 | 1949-01-03 | 0 | [] | 409116 | Albert L. Reeves Jr. | 1906-05-31 | M | 2 | 1949-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000238 | Albert | Riddle | Albert Riddle | Republican | OH | House | 19 | 1861-07-04 | 1863-03-03 | 0 | [] | 409214 | Albert G. Riddle | 1816-05-28 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000457 | Albert | Rossdale | Albert Rossdale | Republican | NY | House | 23 | 1921-04-11 | 1923-03-03 | 0 | [] | 409421 | Albert B. Rossdale | 1878-10-23 | M | 2 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000546 | Albert | Rutherford | Albert Rutherford | Republican | PA | House | 15 | 1937-01-05 | 1943-01-03 | 0 | [] | 409502 | Albert G. Rutherford | 1879-01-03 | M | 4 | 1943-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000302 | Albert | Shaw | Albert Shaw | Republican | NY | House | -1 | 1899-12-04 | 1903-03-03 | 0 | [] | 409801 | Albert D. Shaw | 1841-12-21 | M | 3 | 1903-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000420 | Albert | Simms | Albert Simms | Republican | NM | House | 1 | 1929-04-15 | 1931-03-03 | 0 | [] | 409914 | Albert G. Simms | 1882-10-08 | M | 2 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000514 | Albert | Smith | Albert Smith | Republican | AL | House | 6 | 1981-01-05 | 1983-01-03 | 0 | [] | 409999 | 01070 | Albert L. Smith Jr. | 1931-08-31 | M | 2 | 1983-01-03 | 0 | 0 | 0 | 0 | 0 | |||||
| T000191 | Albert | Thompson | Albert Thompson | Republican | OH | House | 11 | 1885-12-07 | 1891-03-03 | 0 | [] | 410771 | Albert C. Thompson | 1842-01-23 | M | 4 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| V000077 | Albert | Vaughn | Albert Vaughn | Republican | PA | House | 8 | 1951-01-03 | 1953-01-03 | 0 | [] | 411134 | Albert C. Vaughn | 1894-10-09 | M | 2 | 1953-01-03 | 4 | 0 | 0 | 0 | 0 | ||||||
| V000092 | Albert | Vestal | Albert Vestal | Republican | IN | House | 8 | 1917-04-02 | 1933-03-03 | 0 | [] | 411147 | Albert Henry Vestal | 1875-01-18 | M | 9 | 1933-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);