congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4,428 rows where chamber = "House" and 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)
| 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 | 0 | 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 | 0 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | 0 | 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | 0 | 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 | ||||||
| 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 | |||||||
| 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 | 45 | 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 | 0 | 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 | ||||||
| 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 | 0 | 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 | ||||||
| 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 | ||||||
| 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 | 9 | 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 | 2 | 71 | 9 | 2860 | 2417347 | ||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| 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 | 0 | 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 | ||||||
| V000121 | Albert | Vreeland | Albert Vreeland | Republican | NJ | House | 11 | 1939-01-03 | 1943-01-03 | 0 | [] | 411175 | Albert L. Vreeland | 1901-07-02 | M | 3 | 1943-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000197 | Albert | Watson | Albert Watson | Republican | SC | House | 2 | 1963-01-09 | 1971-01-03 | 0 | [] | 411368 | Albert Watson (South Carolina politician) | 1922-08-30 | M | 5 | 1971-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| W000351 | Albert | White | Albert White | Republican | IN | House | 8 | 1837-09-04 | 1863-03-03 | 0 | [] | 411513 | Albert Smith White | 1803-10-24 | M | 14 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| N000133 | Albin | Norblad | Albin Norblad | Republican | OR | House | 1 | 1945-01-03 | 1965-01-03 | 0 | [] | 408217 | A. Walter Norblad | 1908-09-12 | M | 11 | 1965-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| B000034 | Alexander | Bailey | Alexander Bailey | Republican | NY | House | 21 | 1867-03-04 | 1871-03-03 | 0 | [] | 401039 | Alexander H. Bailey | 1817-08-14 | M | 3 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| D000364 | Alexander | Diven | Alexander Diven | Republican | NY | House | 27 | 1861-07-04 | 1863-03-03 | 0 | [] | 403481 | Alexander S. Diven | 1809-02-10 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| H000194 | Alexander | Hardy | Alexander Hardy | Republican | IN | House | 2 | 1895-12-02 | 1897-03-03 | 0 | [] | 405075 | Alexander M. Hardy | 1847-12-16 | M | 2 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| 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 | ||||||
| M000406 | Alexander | McDill | Alexander McDill | Republican | WI | House | 8 | 1873-12-01 | 1875-03-03 | 0 | [] | 407406 | Alexander S. McDill | 1822-03-18 | M | 2 | 1875-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000417 | Alexander | McDowell | Alexander McDowell | Republican | PA | House | -1 | 1893-08-07 | 1895-03-03 | 0 | [] | 407417 | Alexander McDowell | 1845-03-04 | M | 2 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000515 | Alexander | McKim | Alexander McKim | Republican | MD | House | 5 | 1809-05-22 | 1815-03-03 | 0 | [] | 407509 | Alexander McKim | 1748-01-10 | M | 4 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| M000803 | Alexander | Mitchell | Alexander Mitchell | Republican | KS | House | 2 | 1911-04-04 | 1913-03-03 | 0 | [] | 407779 | Alexander C. Mitchell | 1860-10-11 | M | 2 | 1913-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000045 | Alexander | Ogle | Alexander Ogle | Republican | PA | House | 8 | 1817-12-01 | 1819-03-03 | 0 | [] | 408328 | Alexander Ogle | 1766-08-10 | M | 2 | 1819-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| O000101 | Alexander | Orr | Alexander Orr | Republican | KY | House | 2 | 1791-10-24 | 1797-03-03 | 0 | [] | 408358 | Alexander D. Orr | 1761-11-06 | M | 4 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| P000366 | Alexander | Pirnie | Alexander Pirnie | Republican | NY | House | 32 | 1959-01-07 | 1973-01-03 | 0 | [] | 408762 | Alexander Pirnie | 1903-04-16 | M | 8 | 1973-01-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| R000193 | Alexander | Rice | Alexander Rice | Republican | MA | House | 3 | 1859-12-05 | 1867-03-03 | 0 | [] | 409169 | Alexander H. Rice | 1818-08-30 | M | 5 | 1867-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| S000898 | Alexander | Stewart | Alexander Stewart | Republican | WI | House | 9 | 1895-12-02 | 1901-03-03 | 0 | [] | 410359 | Alexander Stewart (American politician) | 1829-09-12 | M | 4 | 1901-03-03 | 0 | 0 | 0 | 0 | 0 | ||||||
| T000063 | Alexander | Taylor | Alexander Taylor | Republican | PA | House | 21 | 1873-12-01 | 1875-03-03 | 0 | [] | 410649 | Alexander W. Taylor | 1815-03-22 | M | 2 | 1875-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);