legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1957-01-03 sorted by end descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26200 | 26200 | Prescott Bush B001167 | sen | CT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26202 | 26202 | John Butler B001180 | sen | MD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26213 | 26213 | John Carroll C000189 | sen | CO | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
26222 | 26222 | Francis Case C000221 | sen | SD | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27708 | 27708 | Frank Carlson C000154 | sen | KS | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27721 | 27721 | Joseph Clark C000444 | sen | PA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27751 | 27751 | Everett Dirksen D000360 | sen | IL | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27856 | 27856 | Carl Hayden H000385 | sen | AZ | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27869 | 27869 | Bourke Hickenlooper H000559 | sen | IA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27883 | 27883 | Joseph Hill H000598 | sen | AL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27941 | 27941 | Olin Johnston J000195 | sen | SC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
27975 | 27975 | Thomas Kuchel K000335 | sen | CA | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
27982 | 27982 | Frank Lausche L000122 | sen | OH | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28030 | 28030 | Almer Monroney M000859 | sen | OK | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28034 | 28034 | Wayne Morse M001014 | sen | OR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
28039 | 28039 | Thruston Morton M001022 | sen | KY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28166 | 28166 | George Smathers S000505 | sen | FL | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29116 | 29116 | George Aiken A000062 | sen | VT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29146 | 29146 | Wallace Bennett B000384 | sen | UT | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
29160 | 29160 | Alan Bible B000436 | sen | NV | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29225 | 29225 | Samuel Ervin E000211 | sen | NC | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
29283 | 29283 | James Fulbright F000401 | sen | AR | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
30864 | 30864 | Frank Church C000388 | sen | ID | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
30882 | 30882 | Norris Cotton C000802 | sen | NH | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31070 | 31070 | Jacob Javits J000064 | sen | NY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31167 | 31167 | Warren Magnuson M000053 | sen | WA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31381 | 31381 | Herman Talmadge T000035 | sen | GA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31404 | 31404 | Milton Young Y000047 | sen | ND | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
32735 | 32735 | Russell Long L000428 | sen | LA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
26382 | 26382 | Thomas Hennings H000502 | sen | MO | 1957-01-03 | 1960-09-13 | 3 | Democrat | |||||||||||||
26161 | 26161 | John Allen A000133 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26177 | 26177 | August Andresen A000239 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26181 | 26181 | John Beamer B000276 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26184 | 26184 | James Bowler B000698 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26188 | 26188 | Charles Brownson B000964 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26198 | 26198 | Usher Burdick B001079 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26210 | 26210 | Joseph Carrigg C000182 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26227 | 26227 | Earl Chudoff C000386 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26237 | 26237 | Cliff Clevenger C000515 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26249 | 26249 | William Cole C000617 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 37 | |||||||||||||
26264 | 26264 | Jere Cooper C000755 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26270 | 26270 | Frederic Coudert C000804 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26273 | 26273 | Albert Cretella C000905 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26282 | 26282 | Paul Cunningham C000993 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26286 | 26286 | William Dawson D000155 | rep | UT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26287 | 26287 | Vincent Dellay D000219 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
26294 | 26294 | John Dempsey D000228 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26295 | 26295 | David Dennison D000246 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 11 | |||||||||||||
26299 | 26299 | James Devereux D000278 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26309 | 26309 | Martin Dies D000338 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26320 | 26320 | Herman Eberharter E000029 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 28 | |||||||||||||
26325 | 26325 | Myron George G000129 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26333 | 26333 | Thomas Gordon G000316 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26344 | 26344 | Noble Gregory G000447 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26351 | 26351 | Ralph Gwinn G000541 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 27 | |||||||||||||
26359 | 26359 | Robert Hale H000036 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26364 | 26364 | Cecil Harden H000182 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26368 | 26368 | Robert Harrison H000275 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26369 | 26369 | Harry Haskell H000318 | rep | DE | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26377 | 26377 | Lawrence Hays H000405 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
26389 | 26389 | John Heselton H000549 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26398 | 26398 | William Hill H000613 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26402 | 26402 | Patrick Hillings H000623 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 25 | |||||||||||||
26410 | 26410 | Otis Holmes H000740 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26413 | 26413 | DeWitt Hyde H001021 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
26418 | 26418 | Benjamin James J000045 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26435 | 26435 | Thomas Jenkins J000088 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
26445 | 26445 | Robert Kean K000029 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26453 | 26453 | Bernard Kearney K000030 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 32 | |||||||||||||
26454 | 26454 | Russell Keeney K000042 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 14 | |||||||||||||
26463 | 26463 | Augustine Kelley K000058 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
26465 | 26465 | Coya Knutson K000300 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
26468 | 26468 | Otto Krueger K000332 | rep | ND | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26474 | 26474 | Henderson Lanham L000077 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26481 | 26481 | Henry Latham L000108 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26491 | 26491 | Karl Le Compte L000157 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26494 | 26494 | George Long L000416 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
26495 | 26495 | Edwin May M000274 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26503 | 26503 | Samuel McConnell M000354 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26513 | 26513 | J. McGregor M000460 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26514 | 26514 | Robert McIntosh M000483 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
26518 | 26518 | William McVey M000609 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26526 | 26526 | Arthur Miller M000715 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26532 | 26532 | Edward Miller M000724 | rep | MD | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26536 | 26536 | Albert Morano M000935 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26538 | 26538 | William Neal N000017 | rep | WV | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26544 | 26544 | Donald Nicholson N000097 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 9 | |||||||||||||
26545 | 26545 | F. Nimtz N000110 | rep | IN | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26554 | 26554 | Joseph O’Hara O000056 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26560 | 26560 | James Patterson P000119 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26564 | 26564 | Edmund Radwan R000008 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 41 | |||||||||||||
26569 | 26569 | Edward Robeson R000329 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26572 | 26572 | John Robsion R000359 | rep | KY | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26578 | 26578 | Antoni Sadlak S000009 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
26586 | 26586 | Errett Scrivner S000194 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26591 | 26591 | Hubert Scudder S000198 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26595 | 26595 | Timothy Sheehan S000315 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 11 |
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);