legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40,641 rows where type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: district, contact_form, office, rss_url, end (date)
start (date) 279 ✖
- 1919-05-19 466
- 1929-04-15 466
- 1917-04-02 464
- 1931-12-07 462
- 1939-01-03 462
- 1921-04-11 460
- 1923-12-03 460
- 1913-04-07 458
- 1941-01-03 456
- 1943-01-06 455
- 1927-12-05 454
- 1937-01-05 453
- 1947-01-03 453
- 1933-03-09 452
- 1951-01-03 452
- 1945-01-03 451
- 1961-01-03 450
- 1915-12-06 449
- 1925-12-07 449
- 1959-01-07 449
- 1969-01-03 449
- 1935-01-03 448
- 1981-01-05 448
- 1949-01-03 447
- 1975-01-14 447
- 1989-01-03 447
- 1957-01-03 446
- 1963-01-09 446
- 1971-01-21 446
- 1977-01-04 445
- 1983-01-03 445
- 1991-01-03 445
- 1953-01-03 444
- 1965-01-04 444
- 1973-01-03 444
- 1979-01-15 444
- 1985-01-03 444
- 1987-01-06 443
- 1955-01-05 442
- 1997-01-07 442
- 1967-01-10 440
- 1993-01-05 440
- 2003-01-07 440
- 2007-01-04 440
- 2009-01-06 440
- 2011-01-05 440
- 2017-01-03 440
- 1995-01-04 439
- 1999-01-06 439
- 2001-01-03 439
- 2005-01-04 439
- 2013-01-03 439
- 2015-01-06 439
- 2021-01-03 439
- 2019-01-03 438
- 1911-04-04 415
- 1907-12-02 409
- 1909-03-15 409
- 1905-12-04 407
- 1903-11-09 405
- 1899-12-04 383
- 1893-08-07 381
- 1895-12-02 377
- 1901-12-02 377
- 1897-03-15 372
- 1889-12-02 362
- 1883-12-03 354
- 1891-12-07 352
- 1885-12-07 341
- 1887-12-05 338
- 1875-12-06 319
- 1873-12-01 317
- 1881-12-05 317
- 1877-10-15 311
- 1879-03-18 311
- 1869-03-04 272
- 1835-12-07 264
- 1871-03-04 264
- 1833-12-02 263
- 1837-09-04 262
- 1839-12-02 262
- 1841-05-31 262
- 1857-12-07 255
- 1859-12-05 252
- 1853-12-05 251
- 1867-03-04 247
- 1849-12-03 246
- 1855-12-03 246
- 1845-12-01 242
- 1851-12-01 242
- 1843-12-04 240
- 1847-12-06 240
- 1825-12-05 232
- 1827-12-03 228
- 1829-12-07 228
- 1831-12-05 225
- 1823-12-01 224
- 1865-12-04 214
- 1815-12-04 212
- 1821-12-03 210
- 1861-07-04 210
- 1819-12-06 205
- 1813-05-24 204
- 1863-12-07 202
- 1817-12-01 199
- 1809-05-22 157
- 1807-10-26 155
- 1805-12-02 153
- 1811-11-04 152
- 1803-10-17 148
- 1801-12-07 118
- 1797-05-15 117
- 1799-12-02 115
- 1795-12-07 113
- 1793-12-02 111
- 1791-10-24 70
- 1789-03-04 65
- 1946-11-05 3
- 2012-11-13 3
- 2014-11-12 3
- 2016-11-14 3
- 2018-11-13 3
- 2022-09-13 3
- 1902-11-04 2
- 1991-11-05 2
- 1992-11-03 2
- 1993-05-04 2
- 1995-12-12 2
- 1998-04-07 2
- 2001-10-23 2
- 2006-11-13 2
- 2007-12-13 2
- 2009-11-03 2
- 2011-09-13 2
- 2017-06-26 2
- 2019-09-17 2
- 2020-05-19 2
- 2021-11-04 2
- 1790-12-07 1
- 1791-03-04 1
- 1792-11-22 1
- 1795-06-08 1
- 1797-01-03 1
- 1803-03-04 1
- 1806-02-24 1
- 1806-09-01 1
- 1807-01-26 1
- 1810-12-04 1
- 1828-02-23 1
- 1840-12-28 1
- 1851-03-04 1
- 1861-03-04 1
- 1881-03-04 1
- 1889-03-04 1
- 1898-11-08 1
- 1903-03-05 1
- 1904-05-19 1
- 1905-03-04 1
- 1912-07-30 1
- 1936-11-03 1
- 1939-01-05 1
- 1943-01-03 1
- 1946-08-24 1
- 1947-08-26 1
- 1948-04-17 1
- 1949-05-17 1
- 1952-08-02 1
- 1964-04-28 1
- 1965-01-09 1
- 1970-11-03 1
- 1973-03-06 1
- 1973-06-05 1
- 1975-04-29 1
- 1983-06-21 1
- 1984-11-06 1
- 1986-11-04 1
- 1987-08-18 1
- 1988-01-19 1
- 1988-06-14 1
- 1988-08-09 1
- 1988-11-08 1
- 1990-03-20 1
- 1990-09-22 1
- 1990-11-06 1
- 1993-04-13 1
- 1993-05-10 1
- 1993-05-24 1
- 1993-06-08 1
- 1993-12-07 1
- 1994-11-29 1
- 1996-03-26 1
- 1996-04-16 1
- 1996-05-21 1
- 1996-11-27 1
- 1997-05-13 1
- 1997-11-04 1
- 1998-03-10 1
- 1998-05-19 1
- 1998-06-23 1
- 1999-06-08 1
- 1999-11-06 1
- 2001-05-17 1
- 2001-06-07 1
- 2001-06-26 1
- 2001-11-29 1
- 2001-12-18 1
- 2002-02-27 1
- 2003-06-05 1
- 2004-02-17 1
- 2004-06-03 1
- 2004-07-21 1
- 2005-03-10 1
- 2005-09-06 1
- 2005-12-07 1
- 2006-06-13 1
- 2007-07-25 1
- 2007-09-04 1
- 2007-10-16 1
- 2008-03-08 1
- 2008-03-13 1
- 2008-04-08 1
- 2008-05-06 1
- 2008-05-07 1
- 2008-05-20 1
- 2008-06-19 1
- 2008-11-19 1
- 2009-04-07 1
- 2009-04-29 1
- 2009-07-16 1
- 2010-04-15 1
- 2010-05-20 1
- 2010-05-22 1
- 2010-06-08 1
- 2010-11-16 1
- 2010-11-18 1
- 2011-06-01 1
- 2011-07-19 1
- 2012-02-07 1
- 2012-06-12 1
- 2012-11-15 1
- 2013-04-09 1
- 2013-05-15 1
- 2013-06-04 1
- 2013-11-16 1
- 2013-12-12 1
- 2014-01-08 1
- 2014-03-11 1
- 2014-06-24 1
- 2015-05-12 1
- 2015-06-09 1
- 2015-09-17 1
- 2016-06-09 1
- 2017-01-10 1
- 2017-04-25 1
- 2017-06-21 1
- 2017-07-11 1
- 2017-11-13 1
- 2018-04-12 1
- 2018-05-07 1
- 2018-07-10 1
- 2018-09-05 1
- 2018-11-27 1
- 2018-11-29 1
- 2019-01-04 1
- 2019-06-03 1
- 2020-05-05 1
- 2020-07-21 1
- 2020-12-03 1
- 2021-02-11 1
- 2021-04-14 1
- 2021-05-11 1
- 2021-06-14 1
- 2021-07-30 1
- 2022-01-18 1
- 2022-06-07 1
- 2022-06-21 1
- 2022-07-12 1
- 2022-08-12 1
- 2022-11-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | Theodorick Bland B000546 | rep | VA | 1789-03-04 | 1791-03-03 | 9 | ||||||||||||||
3 | 3 | Aedanus Burke B001086 | rep | SC | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
4 | 4 | Daniel Carroll C000187 | rep | MD | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
5 | 5 | George Clymer C000538 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
6 | 6 | Benjamin Contee C000710 | rep | MD | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
10 | 10 | William Floyd F000224 | rep | NY | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
11 | 11 | George Gale G000012 | rep | MD | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
13 | 13 | Jonathan Grout G000500 | rep | MA | 1789-03-04 | 1791-03-03 | 8 | ||||||||||||||
15 | 15 | Benjamin Huntington H000995 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
21 | 21 | George Mathews M000234 | rep | GA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
23 | 23 | George Partridge P000092 | rep | MA | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
25 | 25 | William Smith S000624 | rep | MD | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
26 | 26 | Michael Stone S000961 | rep | MD | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
27 | 27 | Jeremiah Van Rensselaer V000053 | rep | NY | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
28 | 28 | Henry Wynkoop W000783 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
31 | 31 | John Ashe A000307 | rep | NC | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
32 | 32 | John Ashe A000307 | rep | NC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
33 | 33 | Robert Barnwell B000167 | rep | SC | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
40 | 40 | Elbridge Gerry G000139 | rep | MA | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
41 | 41 | Elbridge Gerry G000139 | rep | MA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
42 | 42 | Daniel Huger H000916 | rep | SC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
43 | 43 | Daniel Huger H000916 | rep | SC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
44 | 44 | Israel Jacobs J000036 | rep | PA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
45 | 45 | Philip Key K000158 | rep | MD | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
49 | 49 | Cornelius Schoonmaker S000140 | rep | NY | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
50 | 50 | Joshua Seney S000242 | rep | MD | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
51 | 51 | Joshua Seney S000242 | rep | MD | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
52 | 52 | Upton Sheredine S000340 | rep | MD | 1791-10-24 | 1793-03-03 | 6 | ||||||||||||||
53 | 53 | Roger Sherman S000349 | rep | CT | 1789-03-04 | 1791-03-03 | Pro-Administration | -1 | |||||||||||||
55 | 55 | Peter Silvester S000412 | rep | NY | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
56 | 56 | Peter Silvester S000412 | rep | NY | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
57 | 57 | John Steele S000832 | rep | NC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
58 | 58 | John Steele S000832 | rep | NC | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
59 | 59 | Samuel Sterett S000866 | rep | MD | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
60 | 60 | Jonathan Sturges S001047 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
61 | 61 | Jonathan Sturges S001047 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
62 | 62 | Thomas Tucker T000403 | rep | SC | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
63 | 63 | Thomas Tucker T000403 | rep | SC | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
64 | 64 | Anthony Wayne W000216 | rep | GA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
65 | 65 | Alexander White W000352 | rep | VA | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
66 | 66 | Alexander White W000352 | rep | VA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
67 | 67 | Hugh Williamson W000551 | rep | NC | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
68 | 68 | Hugh Williamson W000551 | rep | NC | 1791-10-24 | 1793-03-03 | Federalist | 4 | |||||||||||||
69 | 69 | Francis Willis W000560 | rep | GA | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
72 | 72 | James Armstrong A000280 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
73 | 73 | John Beatty B000282 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
74 | 74 | Elias Boudinot B000661 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
75 | 75 | Elias Boudinot B000661 | rep | NJ | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
76 | 76 | Elias Boudinot B000661 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
77 | 77 | Shearjashub Bourne B000671 | rep | MA | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
78 | 78 | Shearjashub Bourne B000671 | rep | MA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
80 | 80 | Lambert Cadwalader C000012 | rep | NJ | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
81 | 81 | Lambert Cadwalader C000012 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
82 | 82 | Thomas Carnes C000163 | rep | GA | 1793-12-02 | 1795-03-03 | 0 | ||||||||||||||
83 | 83 | Abraham Clark C000418 | rep | NJ | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
84 | 84 | Abraham Clark C000418 | rep | NJ | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
85 | 85 | David Cobb C000545 | rep | MA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
86 | 86 | Peleg Coffin C000591 | rep | MA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
87 | 87 | William Dawson D000157 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 8 | |||||||||||||
88 | 88 | Benjamin Edwards E000060 | rep | MD | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
89 | 89 | Thomas Fitzsimons F000178 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
90 | 90 | Thomas Fitzsimons F000178 | rep | PA | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
91 | 91 | Thomas Fitzsimons F000178 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
92 | 92 | Uriah Forrest F000282 | rep | MD | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
94 | 94 | Alexander Gillon G000211 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
95 | 95 | James Gordon G000311 | rep | NY | 1791-10-24 | 1793-03-03 | 6 | ||||||||||||||
96 | 96 | James Gordon G000311 | rep | NY | 1793-12-02 | 1795-03-03 | 9 | ||||||||||||||
97 | 97 | Samuel Griffin G000466 | rep | VA | 1789-03-04 | 1791-03-03 | 10 | ||||||||||||||
98 | 98 | Samuel Griffin G000466 | rep | VA | 1791-10-24 | 1793-03-03 | 10 | ||||||||||||||
99 | 99 | Samuel Griffin G000466 | rep | VA | 1793-12-02 | 1795-03-03 | 13 | ||||||||||||||
100 | 100 | Samuel Holten H000750 | rep | MA | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
101 | 101 | William Irvine I000035 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
102 | 102 | Amasa Learned L000178 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
103 | 103 | Amasa Learned L000178 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
104 | 104 | Richard Lee L000200 | rep | VA | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
105 | 105 | Richard Lee L000200 | rep | VA | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
106 | 106 | Richard Lee L000200 | rep | VA | 1793-12-02 | 1795-03-03 | 17 | ||||||||||||||
108 | 108 | Joseph McDowell M000424 | rep | NC | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
109 | 109 | Alexander Mebane M000622 | rep | NC | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
110 | 110 | John Mercer M000645 | rep | MD | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
111 | 111 | John Mercer M000645 | rep | MD | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
113 | 113 | William Montgomery M000873 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
114 | 114 | Joseph Neville N000055 | rep | VA | 1793-12-02 | 1795-03-03 | 3 | ||||||||||||||
115 | 115 | Nathaniel Niles N000109 | rep | VT | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
116 | 116 | Nathaniel Niles N000109 | rep | VT | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
117 | 117 | Andrew Pickens P000320 | rep | SC | 1793-12-02 | 1795-03-03 | 6 | ||||||||||||||
118 | 118 | Thomas Scott S000186 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
119 | 119 | Thomas Scott S000186 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
122 | 122 | Silas Talbot T000019 | rep | NY | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
123 | 123 | Thomas Tredwell T000361 | rep | NY | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
124 | 124 | Thomas Tredwell T000361 | rep | NY | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
125 | 125 | Peter Van Gaasbeck V000039 | rep | NY | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
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 | |||||||||||||
129 | 129 | Jeremiah Wadsworth W000013 | rep | CT | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
130 | 130 | Jeremiah Wadsworth W000013 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
131 | 131 | Jeremiah Wadsworth W000013 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
132 | 132 | Francis Walker W000051 | rep | VA | 1793-12-02 | 1795-03-03 | 14 | ||||||||||||||
133 | 133 | Artemas Ward W000127 | rep | MA | 1791-10-24 | 1793-03-03 | 7 | ||||||||||||||
134 | 134 | Artemas Ward W000127 | rep | MA | 1793-12-02 | 1795-03-03 | 2 |
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);