legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1971-01-03 483
- 1983-01-03 481
- 1977-01-03 480
- 1975-01-03 479
- 1981-01-03 479
- 1965-01-03 478
- 1987-01-03 478
- 1967-01-03 477
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- 2005-01-03 472
- 2009-01-03 472
- 2023-01-03 472
- 2003-01-03 471
- 2007-01-03 471
- 2013-01-03 470
- 2019-01-03 470
- 2021-01-03 469
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27215 | 27215 | Kathryn Granahan G000368 | rep | PA | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
27216 | 27216 | Burr Harrison H000264 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 7 | |||||||||||||
27217 | 27217 | Burr Harrison H000264 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27218 | 27218 | Burr Harrison H000264 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27219 | 27219 | Burr Harrison H000264 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27220 | 27220 | Burr Harrison H000264 | rep | VA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27221 | 27221 | Burr Harrison H000264 | rep | VA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27222 | 27222 | Burr Harrison H000264 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27223 | 27223 | Burr Harrison H000264 | rep | VA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27224 | 27224 | Burr Harrison H000264 | rep | VA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27226 | 27226 | Edgar Hiestand H000568 | rep | CA | 1953-01-03 | 1955-01-03 | Republican | 21 | |||||||||||||
27227 | 27227 | Edgar Hiestand H000568 | rep | CA | 1955-01-05 | 1957-01-03 | Republican | 21 | |||||||||||||
27228 | 27228 | Edgar Hiestand H000568 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 21 | |||||||||||||
27229 | 27229 | Edgar Hiestand H000568 | rep | CA | 1959-01-07 | 1961-01-03 | Republican | 21 | |||||||||||||
27230 | 27230 | Edgar Hiestand H000568 | rep | CA | 1961-01-03 | 1963-01-03 | Republican | 21 | |||||||||||||
27231 | 27231 | Clare Hoffman H000683 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
27232 | 27232 | Clare Hoffman H000683 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
27233 | 27233 | Clare Hoffman H000683 | rep | MI | 1939-01-03 | 1941-01-03 | Republican | 4 | |||||||||||||
27234 | 27234 | Clare Hoffman H000683 | rep | MI | 1941-01-03 | 1943-01-03 | Republican | 4 | |||||||||||||
27235 | 27235 | Clare Hoffman H000683 | rep | MI | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
27236 | 27236 | Clare Hoffman H000683 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
27237 | 27237 | Clare Hoffman H000683 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
27238 | 27238 | Clare Hoffman H000683 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
27239 | 27239 | Clare Hoffman H000683 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
27240 | 27240 | Clare Hoffman H000683 | rep | MI | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
27241 | 27241 | Clare Hoffman H000683 | rep | MI | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
27242 | 27242 | Clare Hoffman H000683 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
27243 | 27243 | Clare Hoffman H000683 | rep | MI | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
27244 | 27244 | Clare Hoffman H000683 | rep | MI | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
27245 | 27245 | Lester Holtzman H000753 | rep | NY | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27246 | 27246 | Lester Holtzman H000753 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27247 | 27247 | Lester Holtzman H000753 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27248 | 27248 | Lester Holtzman H000753 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27249 | 27249 | Lester Holtzman H000753 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27250 | 27250 | Frank Ikard I000007 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
27251 | 27251 | Frank Ikard I000007 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 13 | |||||||||||||
27252 | 27252 | Frank Ikard I000007 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 13 | |||||||||||||
27253 | 27253 | Frank Ikard I000007 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
27254 | 27254 | Frank Ikard I000007 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 13 | |||||||||||||
27255 | 27255 | Frank Ikard I000007 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
27256 | 27256 | Thomas Johnson J000176 | rep | MD | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27257 | 27257 | Thomas Johnson J000176 | rep | MD | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27258 | 27258 | Walter Judd J000278 | rep | MN | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
27259 | 27259 | Walter Judd J000278 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
27260 | 27260 | Walter Judd J000278 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
27261 | 27261 | Walter Judd J000278 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27262 | 27262 | Walter Judd J000278 | rep | MN | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27263 | 27263 | Walter Judd J000278 | rep | MN | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
27264 | 27264 | Walter Judd J000278 | rep | MN | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
27265 | 27265 | Walter Judd J000278 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27266 | 27266 | Walter Judd J000278 | rep | MN | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27267 | 27267 | Walter Judd J000278 | rep | MN | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27268 | 27268 | Carroll Kearns K000032 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 28 | |||||||||||||
27269 | 27269 | Carroll Kearns K000032 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
27270 | 27270 | Carroll Kearns K000032 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 28 | |||||||||||||
27271 | 27271 | Carroll Kearns K000032 | rep | PA | 1953-01-03 | 1955-01-03 | Republican | 24 | |||||||||||||
27272 | 27272 | Carroll Kearns K000032 | rep | PA | 1955-01-05 | 1957-01-03 | Republican | 24 | |||||||||||||
27273 | 27273 | Carroll Kearns K000032 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
27274 | 27274 | Carroll Kearns K000032 | rep | PA | 1959-01-07 | 1961-01-03 | Republican | 24 | |||||||||||||
27275 | 27275 | Carroll Kearns K000032 | rep | PA | 1961-01-03 | 1963-01-03 | Republican | 24 | |||||||||||||
27276 | 27276 | Carey Kefauver K000044 | rep | TN | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
27277 | 27277 | Carey Kefauver K000044 | rep | TN | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
27278 | 27278 | Carey Kefauver K000044 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
27279 | 27279 | Carey Kefauver K000044 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27280 | 27280 | Carey Kefauver K000044 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
27281 | 27281 | Carey Kefauver K000044 | sen | TN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27282 | 27282 | Carey Kefauver K000044 | sen | TN | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
27283 | 27283 | Carey Kefauver K000044 | sen | TN | 1961-01-03 | 1963-12-31 | 2 | Democrat | |||||||||||||
27284 | 27284 | Robert Kerr K000144 | sen | OK | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27285 | 27285 | Robert Kerr K000144 | sen | OK | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
27286 | 27286 | Robert Kerr K000144 | sen | OK | 1961-01-03 | 1963-12-31 | 2 | Democrat | |||||||||||||
27287 | 27287 | Paul Kilday K000171 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 20 | |||||||||||||
27288 | 27288 | Paul Kilday K000171 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 20 | |||||||||||||
27289 | 27289 | Paul Kilday K000171 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
27290 | 27290 | Paul Kilday K000171 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
27291 | 27291 | Paul Kilday K000171 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
27292 | 27292 | Paul Kilday K000171 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
27293 | 27293 | Paul Kilday K000171 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
27294 | 27294 | Paul Kilday K000171 | rep | TX | 1953-01-03 | 1955-01-03 | Democrat | 20 | |||||||||||||
27295 | 27295 | Paul Kilday K000171 | rep | TX | 1955-01-05 | 1957-01-03 | Democrat | 20 | |||||||||||||
27296 | 27296 | Paul Kilday K000171 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27297 | 27297 | Paul Kilday K000171 | rep | TX | 1959-01-07 | 1961-01-03 | Democrat | 20 | |||||||||||||
27298 | 27298 | Paul Kilday K000171 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
27299 | 27299 | Alvin Kitchin K000249 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27300 | 27300 | Alvin Kitchin K000249 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
27301 | 27301 | Alvin Kitchin K000249 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
27302 | 27302 | Frank Kowalski K000320 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
27303 | 27303 | Frank Kowalski K000320 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
27304 | 27304 | Thomas Lane L000065 | rep | MA | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
27305 | 27305 | Thomas Lane L000065 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
27306 | 27306 | Thomas Lane L000065 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
27307 | 27307 | Thomas Lane L000065 | rep | MA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
27308 | 27308 | Thomas Lane L000065 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27309 | 27309 | Thomas Lane L000065 | rep | MA | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
27310 | 27310 | Thomas Lane L000065 | rep | MA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27311 | 27311 | Thomas Lane L000065 | rep | MA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27312 | 27312 | Thomas Lane L000065 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27313 | 27313 | Thomas Lane L000065 | rep | MA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27314 | 27314 | Thomas Lane L000065 | rep | MA | 1961-01-03 | 1963-01-03 | Democrat | 7 |
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);