legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where party = "Democrat" and state = "MD"
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, phone, fax, contact_form, office, state_rank, rss_url, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4241 | 4241 | Benjamin Howard H000835 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4281 | 4281 | Isaac McKim M000516 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4418 | 4418 | James Carroll C000188 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4513 | 4513 | Solomon Hillen Solomon H000617 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4644 | 4644 | John Worthington W000748 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4645 | 4645 | John Worthington W000748 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
4873 | 4873 | John Mason M000219 | rep | MD | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
4998 | 4998 | Charles Sewall S000258 | rep | MD | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5066 | 5066 | James Williams W000509 | rep | MD | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5388 | 5388 | Albert Constable C000708 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5425 | 5425 | William Giles G000184 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5500 | 5500 | Thomas Perry P000245 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5765 | 5765 | Thomas Ligon L000307 | rep | MD | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5766 | 5766 | Thomas Ligon L000307 | rep | MD | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6318 | 6318 | Edward Hammond H000126 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6319 | 6319 | Edward Hammond H000126 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6689 | 6689 | Jacob Shower S000386 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6729 | 6729 | Joshua Van Sant V000057 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
7450 | 7450 | George Hughes H000921 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7472 | 7472 | Jacob Kunkel K000339 | rep | MD | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7473 | 7473 | Jacob Kunkel K000339 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7588 | 7588 | James Stewart S000910 | rep | MD | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7589 | 7589 | James Stewart S000910 | rep | MD | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7590 | 7590 | James Stewart S000910 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7787 | 7787 | Henry May M000275 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7825 | 7825 | James Pearce P000161 | sen | MD | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7826 | 7826 | James Pearce P000161 | sen | MD | 1861-07-04 | 1863-03-03 | 3 | Democrat | |||||||||||||
7974 | 7974 | Reverdy Johnson J000169 | sen | MD | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
8135 | 8135 | Benjamin Harris H000232 | rep | MD | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8136 | 8136 | Benjamin Harris H000232 | rep | MD | 1865-12-04 | 1867-03-03 | Democrat | 5 | |||||||||||||
8391 | 8391 | Hiram McCullough M000395 | rep | MD | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8392 | 8392 | Hiram McCullough M000395 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8463 | 8463 | Francis Thomas T000166 | rep | MD | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
8464 | 8464 | Francis Thomas T000166 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
8500 | 8500 | George Vickers V000095 | sen | MD | 1868-01-01 | 1873-03-03 | 3 | Democrat | |||||||||||||
8613 | 8613 | Patrick Hamill H000100 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
8616 | 8616 | William Hamilton H000118 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
8617 | 8617 | William Hamilton H000118 | rep | MD | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
8618 | 8618 | William Hamilton H000118 | rep | MD | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
8619 | 8619 | William Hamilton H000118 | sen | MD | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
8737 | 8737 | Frederick Stone S000957 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8738 | 8738 | Frederick Stone S000957 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8919 | 8919 | Samuel Hambleton H000095 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8920 | 8920 | Samuel Hambleton H000095 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8967 | 8967 | William Merrick M000655 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9001 | 9001 | John Ritchie R000275 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
9151 | 9151 | George Dennis D000242 | sen | MD | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
9598 | 9598 | William O’Brien O000017 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9599 | 9599 | William O’Brien O000017 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9653 | 9653 | Phillip Thomas T000182 | rep | MD | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
9654 | 9654 | Phillip Thomas T000182 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9920 | 9920 | Charles Roberts R000306 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9921 | 9921 | Charles Roberts R000306 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
9947 | 9947 | Thomas Swann S001092 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
9948 | 9948 | Thomas Swann S001092 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9949 | 9949 | Thomas Swann S001092 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9950 | 9950 | Thomas Swann S001092 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9951 | 9951 | Thomas Swann S001092 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
9971 | 9971 | William Walsh W000106 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9972 | 9972 | William Walsh W000106 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10091 | 10091 | James Groome G000492 | sen | MD | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
10100 | 10100 | Eli Henkle H000497 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10101 | 10101 | Eli Henkle H000497 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10102 | 10102 | Eli Henkle H000497 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10103 | 10103 | Daniel Henry H000504 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10104 | 10104 | Daniel Henry H000504 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10128 | 10128 | William Kimmel K000185 | rep | MD | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10129 | 10129 | William Kimmel K000185 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10291 | 10291 | Andrew Chapman C000307 | rep | MD | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
10457 | 10457 | Robert McLane M000537 | rep | MD | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
10458 | 10458 | Robert McLane M000537 | rep | MD | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
10459 | 10459 | Robert McLane M000537 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10460 | 10460 | Robert McLane M000537 | rep | MD | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10680 | 10680 | George Covington C000815 | rep | MD | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
10681 | 10681 | George Covington C000815 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10752 | 10752 | Fetter Hoblitzell H000664 | rep | MD | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10753 | 10753 | Fetter Hoblitzell H000664 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11008 | 11008 | William Cole C000615 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 3 | |||||||||||||
11038 | 11038 | John Findlay F000121 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
11039 | 11039 | John Findlay F000121 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11273 | 11273 | Ephraim Wilson W000577 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
11274 | 11274 | Ephraim Wilson W000577 | sen | MD | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
11508 | 11508 | Frank Shaw S000304 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11509 | 11509 | Frank Shaw S000304 | rep | MD | 1887-12-05 | 1889-03-03 | Democrat | 2 | |||||||||||||
12100 | 12100 | John Brown B000930 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12177 | 12177 | Charles Gibson G000157 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
12178 | 12178 | Charles Gibson G000157 | rep | MD | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12179 | 12179 | Charles Gibson G000157 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12180 | 12180 | Charles Gibson G000157 | sen | MD | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12259 | 12259 | Henry Page P000016 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12312 | 12312 | Herman Stump S001043 | rep | MD | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12313 | 12313 | Herman Stump S001043 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12422 | 12422 | Robert Bratton B000773 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12493 | 12493 | Barnes Compton C000660 | rep | MD | 1885-12-07 | 1887-03-03 | Democrat | 5 |
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);