congress_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
320 rows where state = "MD" sorted by full_name
This data as json, CSV (advanced)
party 14
- Democrat 136
- Republican 79
- Whig 26
- Federalist 22
- - 19
- Jackson 14
- Adams 5
- Unconditional Unionist 5
- Unionist 5
- American 3
- Anti Jacksonian 3
- Conservative 1
- Ind. Republican-Democrat 1
- Ind. Whig 1
state 1
- MD · 320 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B000535 | Albert | Blakeney | Albert Blakeney | Republican | MD | House | 2 | 1901-12-02 | 1923-03-03 | 0 | [] | 1850-09-28 | M | 12 | 1923-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000708 | Albert | Constable | Albert Constable | Democrat | MD | House | 5 | 1845-12-01 | 1847-03-03 | 0 | [] | 1805-06-03 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000784 | Albert | Wynn | Albert Wynn | Democrat | MD | House | 4 | 1993-01-05 | 2008-05-31 | 0 | ["H2MD05361"] | 01251 | 1951-09-10 | M | 8 | 2008-05-31 | 0 | 407 | 107 | 3987 | -7500 | 0 | 0 | ||
| E000231 | Alexander | Evans | Alexander Evans | Whig | MD | House | 5 | 1847-12-06 | 1853-03-03 | 0 | [] | 1818-09-13 | M | 4 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000176 | Alexander | Hanson | Alexander Hanson | Federalist | MD | Senate | 1813-05-24 | 1819-04-23 | 0 | [] | 1786-02-27 | M | 2 | 1819-04-23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| M000515 | Alexander | McKim | Alexander McKim | Republican | MD | House | 5 | 1809-05-22 | 1815-03-03 | 0 | [] | 1748-01-10 | M | 4 | 1815-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000034 | Alexander | Randall | Alexander Randall | Whig | MD | House | 4 | 1841-05-31 | 1843-03-03 | 0 | [] | 1803-01-03 | M | 2 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000101 | Ambrose | Kennedy | Ambrose Kennedy | Democrat | MD | House | 4 | 1931-12-07 | 1941-01-03 | 0 | [] | 1893-01-06 | M | 6 | 1941-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000307 | Andrew | Chapman | Andrew Chapman | Democrat | MD | House | 5 | 1881-12-05 | 1883-03-03 | 0 | [] | 1839-01-17 | M | 2 | 1883-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H001052 | Andy | Harris | Andy Harris | Republican | MD | House | 1 | 2011-01-05 | 2027-01-03 | 1 | ["H8MD01094"] | 02026 | 1957-01-25 | M | 9 | 0 | 262 | 42 | 9214 | 4136732 | 311202 | 2077714 | |||
| A000382 | Angela | Alsobrooks | Angela D. Alsobrooks | Democrat | MD | Senate | 2025-01-03 | 2031-01-03 | 1 | ["S4MD00327"] | S428 | 1971-02-23 | F | 2 | 0 | 96 | 38 | 915 | 1799015 | 3769530 | 26699481 | ||||
| B001304 | Anthony | Brown | Anthony G. Brown | Democrat | MD | House | 4 | 2017-01-03 | 2023-01-03 | 0 | ["H6MD04209"] | 1961-11-21 | M | 4 | 2023-01-03 | 0 | 131 | 133 | 3162 | 2211364 | 8288 | 0 | |||
| K000103 | Anthony | Kennedy | Anthony Kennedy | Unionist | MD | Senate | 1857-12-07 | 1863-03-03 | 0 | [] | 1810-12-21 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| M001232 | April | McClain Delaney | April McClain Delaney | Democrat | MD | House | 6 | 2025-01-03 | 2027-01-03 | 1 | ["H4MD06340"] | 1964-05-28 | F | 2 | 486 | 0 | 30 | 676 | 795193 | 570607 | 217131 | ||||
| V000043 | Archibald | Van Horne | Archibald Van Horne | Republican | MD | House | 2 | 1807-10-26 | 1811-03-03 | 0 | [] | M | 3 | 1811-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| G000326 | Arthur | Gorman | Arthur Gorman | Democrat | MD | Senate | 1881-12-05 | 1906-06-04 | 0 | [] | 1839-03-11 | M | 5 | 1906-06-04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| S000674 | Augustus | Sollers | Augustus Sollers | Whig | MD | House | 6 | 1841-05-31 | 1855-03-03 | 0 | [] | 1814-05-01 | M | 8 | 1855-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000702 | Barbara | Mikulski | Barbara A. Mikulski | Democrat | MD | Senate | 1977-01-04 | 2017-01-03 | 0 | ["S6MD00140"] | 00802 | S182 | 1936-07-20 | F | 7 | 2017-01-03 | 0 | 1793 | 417 | 5623 | 2008565 | 20 | 0 | ||
| C000660 | Barnes | Compton | Barnes Compton | Democrat | MD | House | 5 | 1885-12-07 | 1895-03-03 | 0 | [] | 1830-11-16 | M | 6 | 1895-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000238 | Benedict | Semmes | Benedict Semmes | MD | House | 2 | 1829-12-07 | 1833-03-03 | 0 | [] | 1789-11-01 | M | 3 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| C000710 | Benjamin | Contee | Benjamin Contee | MD | House | 3 | 1789-03-04 | 1791-03-03 | 0 | [] | M | 2 | 1791-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
| E000060 | Benjamin | Edwards | Benjamin Edwards | MD | House | 3 | 1793-12-02 | 1795-03-03 | 0 | [] | 1753-08-12 | M | 2 | 1795-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| H000232 | Benjamin | Harris | Benjamin Harris | Democrat | MD | House | 5 | 1863-12-07 | 1867-03-03 | 0 | [] | 1805-12-13 | M | 3 | 1867-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000835 | Benjamin | Howard | Benjamin Howard | Democrat | MD | House | 4 | 1829-12-07 | 1839-03-03 | 0 | [] | 1791-11-05 | M | 6 | 1839-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000141 | Benjamin | Cardin | Benjamin L. Cardin | Democrat | MD | Senate | 1987-01-06 | 2025-01-03 | 0 | ["H6MD03177", "S6MD03177"] | 00174 | S308 | 1943-10-05 | M | 7 | 2025-01-03 | 15 | 3753 | 785 | 8392 | 4788589 | 7792 | 29650 | ||
| B001220 | Beverly | Byron | Beverly Byron | Democrat | MD | House | 6 | 1979-01-15 | 1993-01-03 | 0 | [] | 00162 | 1932-07-27 | F | 8 | 1993-01-03 | 0 | 0 | 105 | 0 | 0 | 0 | 0 | ||
| L000189 | Blair | Lee | Blair Lee | Democrat | MD | Senate | 1914-01-28 | 1917-03-03 | 0 | [] | 1857-08-09 | M | 1 | 1917-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| R000576 | C. | Ruppersberger | C. A. Dutch Ruppersberger | Democrat | MD | House | 2 | 2003-01-07 | 2025-01-03 | 0 | ["H2MD02160"] | 01728 | 1946-01-31 | M | 12 | 2025-01-03 | 0 | 447 | 88 | 14504 | 4917283 | 14293 | 0 | ||
| S000401 | Carlton | Sickles | Carlton Sickles | Democrat | MD | House | 0 | 1963-01-09 | 1967-01-03 | 0 | [] | 1921-06-15 | M | 3 | 1967-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000387 | Carville | Benson | Carville Benson | Democrat | MD | House | 2 | 1917-04-02 | 1921-03-03 | 0 | [] | 1872-08-24 | M | 3 | 1921-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000058 | Charles | Calvert | Charles Calvert | Unionist | MD | House | 6 | 1861-07-04 | 1863-03-03 | 0 | [] | 1808-08-24 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000185 | Charles | Carroll | Charles Carroll | of Carrollton | MD | Senate | 1789-03-04 | 1793-03-03 | 0 | [] | 1737-09-19 | M | 1 | 1793-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| C000541 | Charles | Coady | Charles Coady | Democrat | MD | House | 3 | 1913-04-07 | 1921-03-03 | 0 | [] | 1868-02-22 | M | 5 | 1921-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000588 | Charles | Coffin | Charles Coffin | Republican | MD | House | 5 | 1893-08-07 | 1897-03-03 | 0 | [] | 1841-07-18 | M | 3 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000157 | Charles | Gibson | Charles Gibson | Democrat | MD | Senate | 1885-12-07 | 1897-03-03 | 0 | [] | 1842-01-19 | M | 3 | 1897-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| G000261 | Charles | Goldsborough | Charles Goldsborough | Federalist | MD | House | 8 | 1805-12-02 | 1817-03-03 | 0 | [] | 1765-07-15 | M | 7 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000241 | Charles | Mathias | Charles Mathias | Republican | MD | Senate | 1961-01-03 | 1987-01-03 | 0 | [] | 01391 | 1922-07-24 | M | 5 | 1987-01-03 | 0 | 0 | 786 | 0 | 0 | 0 | 0 | |||
| M000573 | Charles | McMillen | Charles McMillen | Democrat | MD | House | 4 | 1987-01-06 | 1993-01-03 | 0 | [] | 00783 | 1952-05-26 | M | 4 | 1993-01-03 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | ||
| P000292 | Charles | Phelps | Charles Phelps | Conservative | MD | House | 3 | 1865-12-04 | 1869-03-03 | 0 | [] | 1833-05-01 | M | 3 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000306 | Charles | Roberts | Charles Roberts | Democrat | MD | House | 2 | 1875-12-06 | 1879-03-03 | 0 | [] | 1842-04-19 | M | 3 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000127 | Charles | Schirm | Charles Schirm | Republican | MD | House | 4 | 1901-12-02 | 1903-03-03 | 0 | [] | 1864-08-12 | M | 2 | 1903-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000258 | Charles | Sewall | Charles Sewall | Democrat | MD | House | 3 | 1831-12-05 | 1843-03-03 | 0 | [] | M | 7 | 1843-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| V000128 | Chris | Van Hollen | Chris Van Hollen | Democrat | MD | Senate | 2003-01-07 | 2029-01-03 | 1 | ["H2MD08126", "S6MD03441"] | 01729 | S390 | 1959-01-10 | M | 5 | 7 | 2174 | 388 | 13975 | 5586593 | 1614967 | 0 | |||
| L000413 | Clarence | Long | Clarence Long | Democrat | MD | House | 2 | 1963-01-09 | 1985-01-03 | 0 | [] | 00703 | 1908-12-11 | M | 12 | 1985-01-03 | 0 | 0 | 245 | 0 | 0 | 0 | 0 | ||
| D000437 | Clement | Dorsey | Clement Dorsey | MD | House | 1 | 1825-12-05 | 1831-03-03 | 0 | [] | M | 4 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||
| M000941 | Constance | Morella | Constance Morella | Republican | MD | House | 8 | 1987-01-06 | 2003-01-03 | 0 | ["H0MD08021"] | 00833 | 1931-02-12 | F | 9 | 2003-01-03 | 0 | 939 | 238 | 0 | 0 | 0 | 0 | ||
| L000179 | Cornelius | Leary | Cornelius Leary | Unionist | MD | House | 3 | 1861-07-04 | 1863-03-03 | 0 | [] | 1813-10-22 | M | 2 | 1863-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000813 | Daniel | Brewster | Daniel Brewster | Democrat | MD | Senate | 1959-01-07 | 1969-01-03 | 0 | [] | 1923-11-23 | M | 2 | 1969-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| C000187 | Daniel | Carroll | Daniel Carroll | MD | House | 6 | 1789-03-04 | 1791-03-03 | 0 | [] | 1730-07-22 | M | 2 | 1791-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| E000141 | Daniel | Ellison | Daniel Ellison | Republican | MD | House | 4 | 1943-01-06 | 1945-01-03 | 0 | [] | 1886-02-14 | M | 2 | 1945-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000504 | Daniel | Henry | Daniel Henry | Democrat | MD | House | 1 | 1877-10-15 | 1881-03-03 | 0 | [] | 1823-02-19 | M | 3 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000570 | Daniel | Hiester | Daniel Hiester | Republican | MD | House | 4 | 1789-03-04 | 1805-03-03 | 0 | [] | 1747-06-25 | M | 9 | 1805-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| J000078 | Daniel | Jenifer | Daniel Jenifer | Whig | MD | House | 7 | 1831-12-05 | 1841-03-03 | 0 | [] | 1791-04-15 | M | 6 | 1841-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000483 | David | Trone | David J. Trone | Democrat | MD | House | 6 | 2019-01-03 | 2025-01-03 | 0 | ["H6MD08549"] | 1955-09-21 | M | 4 | 2025-01-03 | 48 | 90 | 103 | 3193 | 45517 | 5382 | 0 | |||
| L000277 | David | Lewis | David Lewis | Democrat | MD | House | 6 | 1911-04-04 | 1939-01-03 | 0 | [] | 1869-05-01 | M | 15 | 1939-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000905 | David | Stewart | David Stewart | Whig | MD | Senate | 1849-12-03 | 1851-03-03 | 0 | [] | 1800-09-13 | M | 1 | 1851-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000130 | David | Ward | David Ward | Democrat | MD | House | 1 | 1939-01-03 | 1945-01-03 | 0 | [] | 1871-09-17 | M | 4 | 1945-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H001021 | DeWitt | Hyde | DeWitt Hyde | Republican | MD | House | 6 | 1953-01-03 | 1959-01-03 | 0 | [] | 1909-03-21 | M | 4 | 1959-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| E000290 | Donna | Edwards | Donna F. Edwards | Democrat | MD | House | 4 | 2008-06-19 | 2017-01-03 | 0 | ["H6MD04183"] | 01894 | 1958-06-28 | F | 5 | 2017-01-03 | 0 | 346 | 46 | 6054 | 1251348 | 1563 | 0 | ||
| R000381 | Dudley | Roe | Dudley Roe | Democrat | MD | House | 1 | 1945-01-03 | 1947-01-03 | 0 | [] | 1881-03-23 | M | 2 | 1947-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000071 | Edward | Garmatz | Edward Garmatz | Democrat | MD | House | 3 | 1947-01-03 | 1973-01-03 | 0 | [] | 1903-02-07 | M | 14 | 1973-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000126 | Edward | Hammond | Edward Hammond | Democrat | MD | House | 3 | 1849-12-03 | 1853-03-03 | 0 | [] | 1812-03-17 | M | 3 | 1853-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| L000376 | Edward | Lloyd | Edward Lloyd | Jackson | MD | Senate | 1805-12-02 | 1827-03-03 | 0 | [] | 1779-07-22 | M | 4 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| L000414 | Edward | Long | Edward Long | Whig | MD | House | 6 | 1845-12-01 | 1847-03-03 | 0 | [] | 1808-09-28 | M | 2 | 1847-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000724 | Edward | Miller | Edward Miller | Republican | MD | House | 1 | 1947-01-03 | 1959-01-03 | 0 | [] | 1895-02-01 | M | 7 | 1959-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000239 | Edwin | Webster | Edwin Webster | Unconditional Unionist | MD | House | 2 | 1859-12-05 | 1867-03-03 | 0 | [] | 1829-03-31 | M | 5 | 1867-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| H000497 | Eli | Henkle | Eli Henkle | Democrat | MD | House | 5 | 1875-12-06 | 1881-03-03 | 0 | [] | 1828-11-24 | M | 4 | 1881-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000912 | Elias | Brown | Elias Brown | Jackson | MD | House | 5 | 1829-12-07 | 1831-03-03 | 0 | [] | 1793-05-09 | M | 2 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000984 | Elijah | Cummings | Elijah E. Cummings | Democrat | MD | House | 7 | 1996-04-16 | 2019-10-17 | 0 | ["H6MD07160"] | 00256 | 1951-01-18 | M | 12 | 2019-10-17 | 0 | 930 | 210 | 11871 | 3200954 | 1272 | 0 | ||
| W000576 | Ephraim | Wilson | Ephraim Wilson | Jackson | MD | House | 8 | 1827-12-03 | 1831-03-03 | 0 | [] | 1771-09-15 | M | 3 | 1831-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000577 | Ephraim | Wilson | Ephraim Wilson | Democrat | MD | Senate | 1873-12-01 | 1891-03-03 | 0 | [] | 1821-12-22 | M | 4 | 1891-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| C000282 | Ezekiel | Chambers | Ezekiel Chambers | Adams | MD | Senate | 1826-01-01 | 1835-03-03 | 0 | [] | 1788-02-28 | M | 2 | 1835-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| H000664 | Fetter | Hoblitzell | Fetter Hoblitzell | Democrat | MD | House | 3 | 1881-12-05 | 1885-03-03 | 0 | [] | 1838-10-07 | M | 3 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000797 | Francis | Brengle | Francis Brengle | Whig | MD | House | 2 | 1843-12-04 | 1845-03-03 | 0 | [] | 1807-11-26 | M | 2 | 1845-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| T000166 | Francis | Thomas | Francis Thomas | Republican | MD | House | 4 | 1831-12-05 | 1869-03-03 | 0 | [] | 1799-02-03 | M | 20 | 1869-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000371 | Frank | Kratovil | Frank Kratovil | Democrat | MD | House | 1 | 2009-01-06 | 2011-01-03 | 0 | ["H8MD01086"] | 01926 | 1968-05-29 | M | 2 | 2011-01-03 | 0 | 32 | 19 | 1655 | 1213716 | 80691 | 1054866 | ||
| S000304 | Frank | Shaw | Frank Shaw | Democrat | MD | House | 2 | 1885-12-07 | 1889-03-03 | 0 | [] | 1841-10-07 | M | 3 | 1889-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000499 | Frank | Small | Frank Small | Republican | MD | House | 5 | 1953-01-03 | 1955-01-03 | 0 | [] | 1896-07-15 | M | 2 | 1955-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000535 | Frank | Smith | Frank Smith | Democrat | MD | House | 5 | 1913-04-07 | 1915-03-03 | 0 | [] | 1859-08-27 | M | 2 | 1915-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000001 | Frank | Wachter | Frank Wachter | Republican | MD | House | 3 | 1899-12-04 | 1907-03-03 | 0 | [] | 1861-09-16 | M | 5 | 1907-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| S000957 | Frederick | Stone | Frederick Stone | Democrat | MD | House | 5 | 1867-03-04 | 1871-03-03 | 0 | [] | 1820-02-07 | M | 3 | 1871-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Z000007 | Frederick | Zihlman | Frederick Zihlman | Republican | MD | House | 6 | 1917-04-02 | 1931-03-03 | 0 | [] | 1879-10-02 | M | 8 | 1931-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| C000382 | Gabriel | Christie | Gabriel Christie | Republican | MD | House | 6 | 1793-12-02 | 1801-03-03 | 0 | [] | 1775-09-12 | M | 5 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000578 | Gabriel | Duvall | Gabriel Duvall | Republican | MD | House | 2 | 1793-12-02 | 1797-03-03 | 0 | [] | 1752-12-06 | M | 3 | 1797-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| B000026 | George | Baer | George Baer | Federalist | MD | House | 4 | 1797-05-15 | 1817-03-03 | 0 | [] | M | 11 | 1817-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| C000815 | George | Covington | George Covington | Democrat | MD | House | 1 | 1881-12-05 | 1885-03-03 | 0 | [] | 1838-09-12 | M | 3 | 1885-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| D000242 | George | Dennis | George Dennis | Democrat | MD | Senate | 1873-12-01 | 1879-03-03 | 0 | [] | 1822-04-08 | M | 2 | 1879-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| D000254 | George | Dent | George Dent | Federalist | MD | House | 1 | 1793-12-02 | 1801-03-03 | 0 | [] | M | 5 | 1801-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| F000012 | George | Fallon | George Fallon | Democrat | MD | House | 4 | 1945-01-03 | 1971-01-03 | 0 | [] | 1902-07-24 | M | 14 | 1971-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| G000012 | George | Gale | George Gale | MD | House | 5 | 1789-03-04 | 1791-03-03 | 0 | [] | 1756-06-03 | M | 2 | 1791-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| H000921 | George | Hughes | George Hughes | Democrat | MD | House | 6 | 1859-12-05 | 1861-03-03 | 0 | [] | 1806-09-30 | M | 2 | 1861-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| K000308 | George | Konig | George Konig | Democrat | MD | House | 3 | 1911-04-04 | 1915-03-03 | 0 | [] | 1856-01-26 | M | 3 | 1915-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| M000810 | George | Mitchell | George Mitchell | Jackson | MD | House | 6 | 1823-12-01 | 1833-03-03 | 0 | [] | 1781-03-03 | M | 6 | 1833-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000163 | George | Pearre | George Pearre | Republican | MD | House | 6 | 1899-12-04 | 1911-03-03 | 0 | [] | 1860-07-16 | M | 7 | 1911-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| P000250 | George | Peter | George Peter | Jackson | MD | House | 3 | 1816-10-07 | 1827-03-03 | 0 | [] | 1779-09-28 | M | 6 | 1827-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| R000006 | George | Radcliffe | George Radcliffe | Democrat | MD | Senate | 1935-01-03 | 1947-01-03 | 0 | [] | 1877-08-22 | M | 3 | 1947-01-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| V000095 | George | Vickers | George Vickers | Democrat | MD | Senate | 1868-01-01 | 1873-03-03 | 0 | [] | 1801-11-19 | M | 1 | 1873-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| W000179 | George | Washington | George Washington | Anti Jacksonian | MD | House | 5 | 1827-12-03 | 1837-03-03 | 0 | [] | 1789-08-20 | M | 6 | 1837-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| W000279 | George | Wellington | George Wellington | Republican | MD | Senate | 1895-12-02 | 1903-03-03 | 0 | [] | 1852-01-28 | M | 2 | 1903-03-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| G000513 | Gilbert | Gude | Gilbert Gude | Republican | MD | House | 8 | 1967-01-10 | 1977-01-03 | 0 | [] | 00474 | 1923-03-09 | M | 6 | 1977-01-03 | 0 | 0 | 264 | 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);