legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
73 rows where party = "Republican" and state = "DE"
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | John Patten P000108 | rep | DE | 1793-12-02 | 1795-03-03 | Republican | 0 | |||||||||||||
202 | 202 | John Patten P000108 | rep | DE | 1795-12-07 | 1797-03-03 | Republican | 0 | |||||||||||||
2031 | 2031 | Willard Hall H000076 | rep | DE | 1817-12-01 | 1819-03-03 | Republican | 0 | |||||||||||||
2032 | 2032 | Willard Hall H000076 | rep | DE | 1819-12-06 | 1821-03-03 | Republican | 0 | |||||||||||||
2365 | 2365 | Caesar Rodney R000377 | rep | DE | 1803-10-17 | 1805-03-03 | Republican | 0 | |||||||||||||
2366 | 2366 | Caesar Rodney R000377 | rep | DE | 1821-12-03 | 1822-01-24 | Republican | 0 | |||||||||||||
2367 | 2367 | Caesar Rodney R000377 | sen | DE | 1822-01-24 | 1823-01-29 | 1 | Republican | |||||||||||||
9236 | 9236 | James Lofland L000398 | rep | DE | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
11780 | 11780 | Anthony Higgins H000577 | sen | DE | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13210 | 13210 | Jonathan Willis W000562 | rep | DE | 1895-12-02 | 1897-03-03 | Republican | 0 | |||||||||||||
13711 | 13711 | John Hoffecker H000680 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
13712 | 13712 | Walter Hoffecker H000681 | rep | DE | 1899-12-04 | 1901-03-03 | Republican | 0 | |||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
15015 | 15015 | Hiram Burton B001151 | rep | DE | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
15016 | 15016 | Hiram Burton B001151 | rep | DE | 1907-12-02 | 1909-03-03 | Republican | 0 | |||||||||||||
15264 | 15264 | Harry Richardson R000221 | sen | DE | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
15995 | 15995 | William Heald H000422 | rep | DE | 1909-03-15 | 1911-03-03 | Republican | 0 | |||||||||||||
15996 | 15996 | William Heald H000422 | rep | DE | 1911-04-04 | 1913-03-03 | Republican | 0 | |||||||||||||
16241 | 16241 | Henry du Pont D000559 | sen | DE | 1906-01-01 | 1911-03-03 | 1 | Republican | |||||||||||||
16242 | 16242 | Henry du Pont D000559 | sen | DE | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
16887 | 16887 | Thomas Miller M000758 | rep | DE | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
17543 | 17543 | Lewis Ball B000100 | rep | DE | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18304 | 18304 | Caleb Layton L000151 | rep | DE | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
18305 | 18305 | Caleb Layton L000151 | rep | DE | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19177 | 19177 | Thomas du Pont D000560 | sen | DE | 1925-12-07 | 1929-03-03 | 2 | Republican | |||||||||||||
20478 | 20478 | Daniel Hastings H000325 | sen | DE | 1928-12-10 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
20479 | 20479 | Daniel Hastings H000325 | sen | DE | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
20532 | 20532 | Robert Houston H000826 | rep | DE | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20533 | 20533 | Robert Houston H000826 | rep | DE | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20534 | 20534 | Robert Houston H000826 | rep | DE | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20535 | 20535 | Robert Houston H000826 | rep | DE | 1931-12-07 | 1933-03-03 | Republican | 0 | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
21975 | 21975 | John Townsend T000335 | sen | DE | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21976 | 21976 | John Townsend T000335 | sen | DE | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22835 | 22835 | George Williams W000500 | rep | DE | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
25824 | 25824 | Herbert Warburton W000123 | rep | DE | 1953-01-03 | 1955-01-03 | Republican | 0 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
28739 | 28739 | John Williams W000518 | sen | DE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28740 | 28740 | John Williams W000518 | sen | DE | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28742 | 28742 | John Williams W000518 | sen | DE | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
28782 | 28782 | James Boggs B000593 | rep | DE | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
28783 | 28783 | James Boggs B000593 | rep | DE | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
28784 | 28784 | James Boggs B000593 | rep | DE | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
28785 | 28785 | James Boggs B000593 | sen | DE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28786 | 28786 | James Boggs B000593 | sen | DE | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
31408 | 31408 | Pierre du Pont D000558 | rep | DE | 1971-01-21 | 1973-01-03 | Republican | 0 | |||||||||||||
31409 | 31409 | Pierre du Pont D000558 | rep | DE | 1973-01-03 | 1975-01-03 | Republican | 0 | |||||||||||||
31410 | 31410 | Pierre du Pont D000558 | rep | DE | 1975-01-14 | 1977-01-03 | Republican | 0 | |||||||||||||
32632 | 32632 | Thomas Evans E000258 | rep | DE | 1977-01-04 | 1979-01-03 | Republican | 0 | |||||||||||||
32633 | 32633 | Thomas Evans E000258 | rep | DE | 1979-01-15 | 1981-01-03 | Republican | 0 | |||||||||||||
32634 | 32634 | Thomas Evans E000258 | rep | DE | 1981-01-05 | 1983-01-03 | Republican | 0 | |||||||||||||
36017 | 36017 | William Roth R000460 | rep | DE | 1967-01-10 | 1969-01-03 | Republican | 0 | |||||||||||||
36018 | 36018 | William Roth R000460 | rep | DE | 1969-01-03 | 1971-01-03 | Republican | 0 | |||||||||||||
36019 | 36019 | William Roth R000460 | sen | DE | 1971-01-21 | 1977-01-03 | 1 | Republican | |||||||||||||
36020 | 36020 | William Roth R000460 | sen | DE | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
36021 | 36021 | William Roth R000460 | sen | DE | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
36022 | 36022 | William Roth R000460 | sen | DE | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
36023 | 36023 | William Roth R000460 | sen | DE | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
38479 | 38479 | Michael Castle C000243 | rep | DE | 1993-01-05 | 1995-01-03 | Republican | 0 | |||||||||||||
38480 | 38480 | Michael Castle C000243 | rep | DE | 1995-01-04 | 1997-01-03 | Republican | 0 | |||||||||||||
38481 | 38481 | Michael Castle C000243 | rep | DE | 1997-01-07 | 1999-01-03 | Republican | 0 | |||||||||||||
38482 | 38482 | Michael Castle C000243 | rep | DE | 1999-01-06 | 2001-01-03 | Republican | 0 | |||||||||||||
38483 | 38483 | Michael Castle C000243 | rep | DE | 2001-01-03 | 2003-01-03 | Republican | 0 | |||||||||||||
38484 | 38484 | Michael Castle C000243 | rep | DE | 2003-01-07 | 2005-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38485 | 38485 | Michael Castle C000243 | rep | DE | 2005-01-04 | 2007-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38486 | 38486 | Michael Castle C000243 | rep | DE | 2007-01-04 | 2009-01-03 | Republican | 0 | http://www.house.gov/castle | ||||||||||||
38487 | 38487 | Michael Castle C000243 | rep | DE | 2009-01-06 | 2011-01-03 | Republican | 0 | http://www.house.gov/castle |
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);