legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
127 rows where state = "DE" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: party, url, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
126 | 126 | John Vining V000104 | rep | DE | 1789-03-04 | 1791-03-03 | Pro-Administration | 0 | |||||||||||||
127 | 127 | John Vining V000104 | rep | DE | 1791-10-24 | 1793-03-03 | Pro-Administration | 0 | |||||||||||||
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 | |||||||||||||
270 | 270 | Henry Latimer L000115 | rep | DE | 1793-12-02 | 1795-03-03 | Federalist | 0 | |||||||||||||
812 | 812 | James Broom B000888 | rep | DE | 1805-12-02 | 1807-03-03 | Federalist | 0 | |||||||||||||
813 | 813 | James Broom B000888 | rep | DE | 1807-10-26 | 1809-03-03 | Federalist | 0 | |||||||||||||
1101 | 1101 | James Bayard B000249 | rep | DE | 1797-05-15 | 1799-03-03 | Federalist | 0 | |||||||||||||
1102 | 1102 | James Bayard B000249 | rep | DE | 1799-12-02 | 1801-03-03 | Federalist | 0 | |||||||||||||
1103 | 1103 | James Bayard B000249 | rep | DE | 1801-12-07 | 1803-03-03 | Federalist | 0 | |||||||||||||
1524 | 1524 | Thomas Cooper C000762 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
1525 | 1525 | Thomas Cooper C000762 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 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 | |||||||||||||
2516 | 2516 | Nicholas Van Dyke V000037 | rep | DE | 1807-10-26 | 1809-03-03 | Federalist | 0 | |||||||||||||
2517 | 2517 | Nicholas Van Dyke V000037 | rep | DE | 1809-05-22 | 1811-03-03 | Federalist | 0 | |||||||||||||
2755 | 2755 | Daniel Rodney R000378 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2894 | 2894 | Louis McLane M000535 | rep | DE | 1817-12-01 | 1819-03-03 | Federalist | 0 | |||||||||||||
2895 | 2895 | Louis McLane M000535 | rep | DE | 1819-12-06 | 1821-03-03 | Federalist | 0 | |||||||||||||
2896 | 2896 | Louis McLane M000535 | rep | DE | 1821-12-03 | 1823-03-03 | Federalist | 0 | |||||||||||||
2897 | 2897 | Louis McLane M000535 | rep | DE | 1823-12-01 | 1825-03-03 | Jacksonian | 0 | |||||||||||||
2898 | 2898 | Louis McLane M000535 | rep | DE | 1825-12-05 | 1827-03-03 | Jackson | 0 | |||||||||||||
2935 | 2935 | Henry Ridgely R000245 | rep | DE | 1811-11-04 | 1813-03-03 | Federalist | 0 | |||||||||||||
2936 | 2936 | Henry Ridgely R000245 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
3155 | 3155 | Kensey Johns J000112 | rep | DE | 1827-12-03 | 1829-03-03 | Adams | 0 | |||||||||||||
3156 | 3156 | Kensey Johns J000112 | rep | DE | 1829-12-07 | 1831-03-03 | 0 | ||||||||||||||
4286 | 4286 | John Milligan M000767 | rep | DE | 1831-12-05 | 1833-03-03 | Whig | 0 | |||||||||||||
4287 | 4287 | John Milligan M000767 | rep | DE | 1833-12-02 | 1835-03-03 | Whig | 0 | |||||||||||||
4288 | 4288 | John Milligan M000767 | rep | DE | 1835-12-07 | 1837-03-03 | Whig | 0 | |||||||||||||
4289 | 4289 | John Milligan M000767 | rep | DE | 1837-09-04 | 1839-03-03 | Whig | 0 | |||||||||||||
4601 | 4601 | Thomas Robinson R000353 | rep | DE | 1839-12-02 | 1841-03-03 | Democrat | 0 | |||||||||||||
4749 | 4749 | Thomas Clayton C000499 | rep | DE | 1815-12-04 | 1817-03-03 | Federalist | 0 | |||||||||||||
5277 | 5277 | George Rodney R000379 | rep | DE | 1841-05-31 | 1843-03-03 | Whig | 0 | |||||||||||||
5278 | 5278 | George Rodney R000379 | rep | DE | 1843-12-04 | 1845-03-03 | Whig | 0 | |||||||||||||
6013 | 6013 | John Houston H000825 | rep | DE | 1845-12-01 | 1847-03-03 | Whig | 0 | |||||||||||||
6014 | 6014 | John Houston H000825 | rep | DE | 1847-12-06 | 1849-03-03 | Whig | 0 | |||||||||||||
6015 | 6015 | John Houston H000825 | rep | DE | 1849-12-03 | 1851-03-03 | Whig | 0 | |||||||||||||
6795 | 6795 | Elisha Cullen C000969 | rep | DE | 1855-12-03 | 1857-03-03 | American | 0 | |||||||||||||
7626 | 7626 | William Whiteley W000409 | rep | DE | 1857-12-07 | 1859-03-03 | Democrat | 0 | |||||||||||||
7627 | 7627 | William Whiteley W000409 | rep | DE | 1859-12-05 | 1861-03-03 | Democrat | 0 | |||||||||||||
7750 | 7750 | George Fisher F000147 | rep | DE | 1861-07-04 | 1863-03-03 | Unionist | 0 | |||||||||||||
8035 | 8035 | Nathaniel Smithers S000642 | rep | DE | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 0 | |||||||||||||
8045 | 8045 | William Temple T000120 | rep | DE | 1863-12-07 | 1865-03-03 | Democrat | 0 | |||||||||||||
8071 | 8071 | George Riddle R000239 | rep | DE | 1851-12-01 | 1853-03-03 | Democrat | 0 | |||||||||||||
8072 | 8072 | George Riddle R000239 | rep | DE | 1853-12-05 | 1855-03-03 | Democrat | 0 | |||||||||||||
8404 | 8404 | John Nicholson N000099 | rep | DE | 1865-12-04 | 1867-03-03 | Democrat | 0 | |||||||||||||
8405 | 8405 | John Nicholson N000099 | rep | DE | 1867-03-04 | 1869-03-03 | Democrat | 0 | |||||||||||||
8813 | 8813 | Benjamin Biggs B000457 | rep | DE | 1869-03-04 | 1871-03-03 | Democrat | 0 | |||||||||||||
8814 | 8814 | Benjamin Biggs B000457 | rep | DE | 1871-03-04 | 1873-03-03 | Democrat | 0 | |||||||||||||
9236 | 9236 | James Lofland L000398 | rep | DE | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
9983 | 9983 | James Williams W000506 | rep | DE | 1875-12-06 | 1877-03-03 | Democrat | 0 | |||||||||||||
9984 | 9984 | James Williams W000506 | rep | DE | 1877-10-15 | 1879-03-03 | Democrat | 0 | |||||||||||||
10442 | 10442 | Edward Martin M000178 | rep | DE | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10443 | 10443 | Edward Martin M000178 | rep | DE | 1881-12-05 | 1883-03-03 | Democrat | 0 | |||||||||||||
11117 | 11117 | Charles Lore L000443 | rep | DE | 1883-12-03 | 1885-03-03 | Democrat | 0 | |||||||||||||
11118 | 11118 | Charles Lore L000443 | rep | DE | 1885-12-07 | 1887-03-03 | Democrat | 0 | |||||||||||||
11892 | 11892 | John Penington P000209 | rep | DE | 1887-12-05 | 1889-03-03 | Democrat | 0 | |||||||||||||
11893 | 11893 | John Penington P000209 | rep | DE | 1889-12-02 | 1891-03-03 | Democrat | 0 | |||||||||||||
12482 | 12482 | John Causey C000257 | rep | DE | 1891-12-07 | 1893-03-03 | Democrat | 0 | |||||||||||||
12483 | 12483 | John Causey C000257 | rep | DE | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
13210 | 13210 | Jonathan Willis W000562 | rep | DE | 1895-12-02 | 1897-03-03 | Republican | 0 | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 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 | |||||||||||||
14357 | 14357 | Henry Houston H000823 | rep | DE | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
16294 | 16294 | Franklin Brockson B000853 | rep | DE | 1913-04-07 | 1915-03-03 | Democrat | 0 | |||||||||||||
16887 | 16887 | Thomas Miller M000758 | rep | DE | 1915-12-06 | 1917-03-03 | Republican | 0 | |||||||||||||
17379 | 17379 | Albert Polk P000407 | rep | DE | 1917-04-02 | 1919-03-03 | Democrat | 0 | |||||||||||||
17543 | 17543 | Lewis Ball B000100 | rep | DE | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
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 | |||||||||||||
18571 | 18571 | William Boyce B000712 | rep | DE | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
21073 | 21073 | Wilbur Adams A000050 | rep | DE | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
22022 | 22022 | William Allen A000151 | rep | DE | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22835 | 22835 | George Williams W000500 | rep | DE | 1939-01-03 | 1941-01-03 | Republican | 0 | |||||||||||||
23757 | 23757 | Earle Willey W000483 | rep | DE | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
24166 | 24166 | Philip Traynor T000357 | rep | DE | 1941-01-03 | 1943-01-03 | Democrat | 0 | |||||||||||||
24167 | 24167 | Philip Traynor T000357 | rep | DE | 1945-01-03 | 1947-01-03 | Democrat | 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 | |||||||||||||
28564 | 28564 | Harris McDowell M000418 | rep | DE | 1955-01-05 | 1957-01-03 | Democrat | 0 | |||||||||||||
28565 | 28565 | Harris McDowell M000418 | rep | DE | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
28566 | 28566 | Harris McDowell M000418 | rep | DE | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
28567 | 28567 | Harris McDowell M000418 | rep | DE | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
28568 | 28568 | Harris McDowell M000418 | rep | DE | 1965-01-04 | 1967-01-03 | Democrat | 0 | |||||||||||||
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 | |||||||||||||
31408 | 31408 | Pierre du Pont D000558 | rep | DE | 1971-01-21 | 1973-01-03 | Republican | 0 |
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);