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 rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
26203 | 26203 | Emmet Byrne B001211 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26206 | 26206 | Homer Capehart C000128 | sen | IN | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26210 | 26210 | Joseph Carrigg C000182 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
26382 | 26382 | Thomas Hennings H000502 | sen | MO | 1957-01-03 | 1960-09-13 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
26598 | 26598 | George Shuford S000390 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26602 | 26602 | Alfred Sieminski S000405 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
26610 | 26610 | Sidney Simpson S000437 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
26619 | 26619 | Lawrence Smith S000585 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26621 | 26621 | Simon Stauffer S000819 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
26631 | 26631 | Henry Talle T000028 | rep | IA | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26632 | 26632 | Donald Tewes T000139 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26642 | 26642 | John Vorys V000119 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
26650 | 26650 | Charles Vursell V000125 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 23 | |||||||||||||
26666 | 26666 | Richard Wigglesworth W000450 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26670 | 26670 | Alexander Wiley W000465 | sen | WI | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
26674 | 26674 | William Williams W000549 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 34 | |||||||||||||
26690 | 26690 | Charles Wolverton W000683 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
26704 | 26704 | Leo Allen A000138 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26706 | 26706 | LeRoy Anderson A000200 | rep | MT | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26719 | 26719 | Graham Barden B000139 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
26724 | 26724 | Albert Baumhart B000245 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26735 | 26735 | Alvin Bentley B000391 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 8 | |||||||||||||
26739 | 26739 | Albert Bosch B000646 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
26743 | 26743 | Charles Boyle B000727 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 12 | |||||||||||||
26746 | 26746 | Charles Brown B000908 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26760 | 26760 | Paul Brown B000940 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 10 | |||||||||||||
26766 | 26766 | Hamer Budge B001035 | rep | ID | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26768 | 26768 | John Burns B001127 | rep | HI | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
26773 | 26773 | Alvin Bush B001165 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 17 | |||||||||||||
26790 | 26790 | Gordon Canfield C000113 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 8 |
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);