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)
start (date) >30 ✖
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1965-01-04 476
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 475
- 2003-01-07 474
- 2011-01-05 474
- 2017-01-03 474
- 1967-01-10 473
- 1999-01-06 473
- 2005-01-04 473
- 2007-01-04 473
- 2013-01-03 473
- 1995-01-04 472
- 2001-01-03 472
- 2009-01-06 472
- 2019-01-03 471
- 2021-01-03 471
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
27315 | 27315 | Joseph Loser L000446 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27316 | 27316 | Joseph Loser L000446 | rep | TN | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
27317 | 27317 | Joseph Loser L000446 | rep | TN | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
27318 | 27318 | Thaddeus Machrowicz M000014 | rep | MI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27319 | 27319 | Thaddeus Machrowicz M000014 | rep | MI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
27320 | 27320 | Thaddeus Machrowicz M000014 | rep | MI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
27321 | 27321 | Thaddeus Machrowicz M000014 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27322 | 27322 | Thaddeus Machrowicz M000014 | rep | MI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
27323 | 27323 | Thaddeus Machrowicz M000014 | rep | MI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
27324 | 27324 | Peter Mack M000020 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
27325 | 27325 | Peter Mack M000020 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
27326 | 27326 | Peter Mack M000020 | rep | IL | 1953-01-03 | 1955-01-03 | Democrat | 21 | |||||||||||||
27327 | 27327 | Peter Mack M000020 | rep | IL | 1955-01-05 | 1957-01-03 | Democrat | 21 | |||||||||||||
27328 | 27328 | Peter Mack M000020 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27329 | 27329 | Peter Mack M000020 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
27330 | 27330 | Peter Mack M000020 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
27331 | 27331 | Donald Magnuson M000052 | rep | WA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27332 | 27332 | Donald Magnuson M000052 | rep | WA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27333 | 27333 | Donald Magnuson M000052 | rep | WA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27334 | 27334 | Donald Magnuson M000052 | rep | WA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27335 | 27335 | Donald Magnuson M000052 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
27336 | 27336 | Fred Marshall M000152 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27337 | 27337 | Fred Marshall M000152 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27338 | 27338 | Fred Marshall M000152 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27339 | 27339 | Fred Marshall M000152 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27340 | 27340 | Fred Marshall M000152 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27341 | 27341 | Fred Marshall M000152 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27342 | 27342 | Fred Marshall M000152 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
27343 | 27343 | Noah Mason M000224 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 12 | |||||||||||||
27344 | 27344 | Noah Mason M000224 | rep | IL | 1939-01-03 | 1941-01-03 | Republican | 12 | |||||||||||||
27345 | 27345 | Noah Mason M000224 | rep | IL | 1941-01-03 | 1943-01-03 | Republican | 12 | |||||||||||||
27346 | 27346 | Noah Mason M000224 | rep | IL | 1943-01-06 | 1945-01-03 | Republican | 12 | |||||||||||||
27347 | 27347 | Noah Mason M000224 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
27348 | 27348 | Noah Mason M000224 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
27349 | 27349 | Noah Mason M000224 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
27350 | 27350 | Noah Mason M000224 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 15 | |||||||||||||
27351 | 27351 | Noah Mason M000224 | rep | IL | 1953-01-03 | 1955-01-03 | Republican | 15 | |||||||||||||
27352 | 27352 | Noah Mason M000224 | rep | IL | 1955-01-05 | 1957-01-03 | Republican | 15 | |||||||||||||
27353 | 27353 | Noah Mason M000224 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27354 | 27354 | Noah Mason M000224 | rep | IL | 1959-01-07 | 1961-01-03 | Republican | 15 |
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);