legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
969 rows where state = "MD" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, contact_form, office, rss_url, start (date), end (date)
party 17 ✖
- Democrat 473
- Republican 268
- Federalist 66
- Whig 48
- Jackson 30
- Adams 15
- American 10
- Unconditional Unionist 10
- Anti Jacksonian 8
- Unionist 7
- Anti-Jacksonian 2
- Democratic Republican 2
- Ind. Republican-Democrat 2
- Jacksonian 2
- Pro-Administration 2
- Conservative 1
- Ind. Whig 1
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9071 | 9071 | William Albert A000074 | rep | MD | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
17539 | 17539 | William Andrews A000253 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
653 | 653 | John Archer A000272 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
654 | 654 | John Archer A000272 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
655 | 655 | John Archer A000272 | rep | MD | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
1966 | 1966 | Stevenson Archer A000273 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1967 | 1967 | Stevenson Archer A000273 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1968 | 1968 | Stevenson Archer A000273 | rep | MD | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1969 | 1969 | Stevenson Archer A000273 | rep | MD | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
9073 | 9073 | Stevenson Archer A000274 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9074 | 9074 | Stevenson Archer A000274 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
9075 | 9075 | Stevenson Archer A000274 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9076 | 9076 | Stevenson Archer A000274 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
1454 | 1454 | George Baer B000026 | rep | MD | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
1455 | 1455 | George Baer B000026 | rep | MD | 1799-12-02 | 1801-03-03 | Federalist | 4 | |||||||||||||
1456 | 1456 | George Baer B000026 | rep | MD | 1815-12-04 | 1817-03-03 | Federalist | 4 | |||||||||||||
13562 | 13562 | William Baker B000076 | rep | MD | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13563 | 13563 | William Baker B000076 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13564 | 13564 | William Baker B000076 | rep | MD | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
23765 | 23765 | Harry Baldwin B000086 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23766 | 23766 | Harry Baldwin B000086 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
13242 | 13242 | Isaac Barber B000121 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
33230 | 33230 | Michael Barnes B000160 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 8 | |||||||||||||
33231 | 33231 | Michael Barnes B000160 | rep | MD | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
33232 | 33232 | Michael Barnes B000160 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 8 | |||||||||||||
33233 | 33233 | Michael Barnes B000160 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 8 | |||||||||||||
2776 | 2776 | John Barney B000162 | rep | MD | 1825-12-05 | 1827-03-03 | Adams | 5 | |||||||||||||
2777 | 2777 | John Barney B000162 | rep | MD | 1827-12-03 | 1829-03-03 | Adams | 5 | |||||||||||||
39118 | 39118 | Roscoe Bartlett B000208 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
39119 | 39119 | Roscoe Bartlett B000208 | rep | MD | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
39120 | 39120 | Roscoe Bartlett B000208 | rep | MD | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
39121 | 39121 | Roscoe Bartlett B000208 | rep | MD | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
39122 | 39122 | Roscoe Bartlett B000208 | rep | MD | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
39123 | 39123 | Roscoe Bartlett B000208 | rep | MD | 2003-01-07 | 2005-01-03 | Republican | 6 | http://www.bartlett.house.gov | ||||||||||||
39124 | 39124 | Roscoe Bartlett B000208 | rep | MD | 2005-01-04 | 2007-01-03 | Republican | 6 | http://www.bartlett.house.gov | ||||||||||||
39125 | 39125 | Roscoe Bartlett B000208 | rep | MD | 2007-01-04 | 2009-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39126 | 39126 | Roscoe Bartlett B000208 | rep | MD | 2009-01-06 | 2011-01-03 | Republican | 6 | http://bartlett.house.gov | ||||||||||||
39127 | 39127 | Roscoe Bartlett B000208 | rep | MD | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bartlett.house.gov | 2412 Rayburn HOB; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | http://www.bartlett.house.gov/Email_Roscoe/ | 2412 Rayburn House Office Building | |||||||
31949 | 31949 | Robert Bauman B000244 | rep | MD | 1973-01-03 | 1975-01-03 | Republican | 1 | |||||||||||||
31950 | 31950 | Robert Bauman B000244 | rep | MD | 1975-01-14 | 1977-01-03 | Republican | 1 | |||||||||||||
31951 | 31951 | Robert Bauman B000244 | rep | MD | 1977-01-04 | 1979-01-03 | Republican | 1 | |||||||||||||
31952 | 31952 | Robert Bauman B000244 | rep | MD | 1979-01-15 | 1981-01-03 | Republican | 1 | |||||||||||||
2198 | 2198 | Thomas Bayly B000258 | rep | MD | 1817-12-01 | 1819-03-03 | Federalist | 8 | |||||||||||||
2199 | 2199 | Thomas Bayly B000258 | rep | MD | 1819-12-06 | 1821-03-03 | Federalist | 8 | |||||||||||||
2200 | 2200 | Thomas Bayly B000258 | rep | MD | 1821-12-03 | 1823-03-03 | Federalist | 8 | |||||||||||||
26726 | 26726 | James Beall B000271 | rep | MD | 1943-01-06 | 1945-01-03 | Republican | 6 | |||||||||||||
26727 | 26727 | James Beall B000271 | rep | MD | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
26728 | 26728 | James Beall B000271 | rep | MD | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
26729 | 26729 | James Beall B000271 | rep | MD | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26730 | 26730 | James Beall B000271 | rep | MD | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26731 | 26731 | James Beall B000271 | sen | MD | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
26732 | 26732 | James Beall B000271 | sen | MD | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
29581 | 29581 | John Beall B000272 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
29582 | 29582 | John Beall B000272 | sen | MD | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
17560 | 17560 | Carville Benson B000387 | rep | MD | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17561 | 17561 | Carville Benson B000387 | rep | MD | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
35124 | 35124 | Helen Bentley B000392 | rep | MD | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
35125 | 35125 | Helen Bentley B000392 | rep | MD | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
35126 | 35126 | Helen Bentley B000392 | rep | MD | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
35127 | 35127 | Helen Bentley B000392 | rep | MD | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
35128 | 35128 | Helen Bentley B000392 | rep | MD | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
18049 | 18049 | Albert Blakeney B000535 | rep | MD | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
18050 | 18050 | Albert Blakeney B000535 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
24773 | 24773 | William Bolton B000609 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
13261 | 13261 | William Booze B000633 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
6223 | 6223 | Richard Bowie B000694 | rep | MD | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
6224 | 6224 | Richard Bowie B000694 | rep | MD | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6986 | 6986 | Thomas Bowie B000696 | rep | MD | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
6987 | 6987 | Thomas Bowie B000696 | rep | MD | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
559 | 559 | Walter Bowie B000697 | rep | MD | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
560 | 560 | Walter Bowie B000697 | rep | MD | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
12422 | 12422 | Robert Bratton B000773 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
5142 | 5142 | Francis Brengle B000797 | rep | MD | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
27656 | 27656 | Daniel Brewster B000813 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
27657 | 27657 | Daniel Brewster B000813 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27658 | 27658 | Daniel Brewster B000813 | sen | MD | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
3059 | 3059 | Elias Brown B000912 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
949 | 949 | John Brown B000928 | rep | MD | 1809-05-22 | 1811-03-03 | Republican | 7 | |||||||||||||
12100 | 12100 | John Brown B000930 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
18573 | 18573 | William Bruce B000972 | sen | MD | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
26201 | 26201 | John Butler B001180 | sen | MD | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26202 | 26202 | John Butler B001180 | sen | MD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
22900 | 22900 | William Byron B001206 | rep | MD | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
22901 | 22901 | William Byron B001206 | rep | MD | 1941-01-03 | 1941-02-27 | Democrat | 6 | |||||||||||||
34297 | 34297 | Beverly Byron B001220 | rep | MD | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
34298 | 34298 | Beverly Byron B001220 | rep | MD | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
34299 | 34299 | Beverly Byron B001220 | rep | MD | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
34300 | 34300 | Beverly Byron B001220 | rep | MD | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
34301 | 34301 | Beverly Byron B001220 | rep | MD | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
34302 | 34302 | Beverly Byron B001220 | rep | MD | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
34303 | 34303 | Beverly Byron B001220 | rep | MD | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
31472 | 31472 | Goodloe Byron B001221 | rep | MD | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31473 | 31473 | Goodloe Byron B001221 | rep | MD | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31474 | 31474 | Goodloe Byron B001221 | rep | MD | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31475 | 31475 | Goodloe Byron B001221 | rep | MD | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
22899 | 22899 | Katharine Byron B001222 | rep | MD | 1941-01-03 | 1941-05-27 | Democrat | 6 | |||||||||||||
44178 | 44178 | Anthony Brown B001304 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1505 Longworth House Office Building; Washington DC 20515-2004 | 202-225-8699 | 1505 Longworth House Office Building | |||||||||
44179 | 44179 | Anthony Brown B001304 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
44180 | 44180 | Anthony Brown B001304 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
7683 | 7683 | Charles Calvert C000058 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);