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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26845 | 26845 | Clair Engle E000181 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26858 | 26858 | Aime Forand F000255 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26865 | 26865 | John Henderson H000484 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
26879 | 26879 | William Hess H000550 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
26884 | 26884 | Joseph Holt H000746 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 22 | |||||||||||||
26891 | 26891 | Donald Jackson J000008 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
26900 | 26900 | Kenneth Keating K000036 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 38 | |||||||||||||
26902 | 26902 | John Lafore L000018 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
26911 | 26911 | Russell Mack M000021 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26916 | 26916 | Harlan Mitchell M000812 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
26921 | 26921 | Toby Morris M000991 | rep | OK | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26936 | 26936 | James Polk P000408 | rep | OH | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
26938 | 26938 | Charles Porter P000439 | rep | OR | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
26945 | 26945 | Prince Preston P000516 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26969 | 26969 | Daniel Reed R000113 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 43 | |||||||||||||
26981 | 26981 | Edward Rees R000132 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26999 | 26999 | Edith Rogers R000392 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27012 | 27012 | Richard Simpson S000436 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 18 | |||||||||||||
27019 | 27019 | Wint Smith S000640 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
27028 | 27028 | Dean Taylor T000070 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 31 | |||||||||||||
27030 | 27030 | Ludwig Teller T000118 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27033 | 27033 | Edwin Thomson T000229 | rep | WY | 1957-01-03 | 1959-01-03 | Republican | 0 | |||||||||||||
27037 | 27037 | Stuyvesant Wainwright W000024 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27044 | 27044 | Roy Wier W000446 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27054 | 27054 | Gardner Withrow W000663 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27065 | 27065 | Hugh Addonizio A000054 | rep | NJ | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
27070 | 27070 | Hugh Alexander A000094 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27084 | 27084 | Herman Andersen A000179 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 7 | |||||||||||||
27089 | 27089 | Victor Anfuso A000255 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27097 | 27097 | Cleveland Bailey B000035 | rep | WV | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27101 | 27101 | Perkins Bass B000222 | rep | NH | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27107 | 27107 | Iris Blitch B000561 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27121 | 27121 | Frank Boykin B000725 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27124 | 27124 | James Breeding B000791 | rep | KS | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27137 | 27137 | Overton Brooks B000884 | rep | LA | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27151 | 27151 | Robert Chiperfield C000365 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 19 | |||||||||||||
27157 | 27157 | Marguerite Church C000389 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 13 | |||||||||||||
27160 | 27160 | Merwin Coad C000540 | rep | IA | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27167 | 27167 | Laurence Curtis C001011 | rep | MA | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
27175 | 27175 | James Davis D000109 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27178 | 27178 | Edwin Dooley D000425 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 26 | |||||||||||||
27201 | 27201 | Ivor Fenton F000075 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
27208 | 27208 | James Frazier F000353 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27213 | 27213 | Kathryn Granahan G000368 | rep | PA | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27222 | 27222 | Burr Harrison H000264 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27228 | 27228 | Edgar Hiestand H000568 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 21 | |||||||||||||
27242 | 27242 | Clare Hoffman H000683 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
27247 | 27247 | Lester Holtzman H000753 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27253 | 27253 | Frank Ikard I000007 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 13 | |||||||||||||
27265 | 27265 | Walter Judd J000278 | rep | MN | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27273 | 27273 | Carroll Kearns K000032 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 24 | |||||||||||||
27296 | 27296 | Paul Kilday K000171 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 20 | |||||||||||||
27299 | 27299 | Alvin Kitchin K000249 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
27312 | 27312 | Thomas Lane L000065 | rep | MA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27315 | 27315 | Joseph Loser L000446 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27321 | 27321 | Thaddeus Machrowicz M000014 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27328 | 27328 | Peter Mack M000020 | rep | IL | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27333 | 27333 | Donald Magnuson M000052 | rep | WA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27340 | 27340 | Fred Marshall M000152 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27353 | 27353 | Noah Mason M000224 | rep | IL | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27362 | 27362 | Gordon McDonough M000414 | rep | CA | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27377 | 27377 | Chester Merrow M000664 | rep | NH | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27387 | 27387 | Morgan Moulder M001045 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 11 | |||||||||||||
27393 | 27393 | Walter Mumma M001077 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 16 | |||||||||||||
27407 | 27407 | William Norrell N000137 | rep | AR | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27413 | 27413 | Gracie Pfost P000287 | rep | ID | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
27426 | 27426 | Louis Rabaut R000001 | rep | MI | 1957-01-03 | 1959-01-03 | Democrat | 14 | |||||||||||||
27431 | 27431 | John Ray R000077 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 15 | |||||||||||||
27456 | 27456 | Samuel Rayburn R000082 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
27474 | 27474 | Brazilla Reece R000108 | rep | TN | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27484 | 27484 | John Riley R000260 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27499 | 27499 | J. Rutherford R000547 | rep | TX | 1957-01-03 | 1959-01-03 | Democrat | 16 | |||||||||||||
27506 | 27506 | Alfred Santangelo S000057 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 18 | |||||||||||||
27509 | 27509 | Dalip Saund S000075 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 29 | |||||||||||||
27514 | 27514 | Gordon Scherer S000120 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27525 | 27525 | Horace Seely-Brown S000224 | rep | CT | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27530 | 27530 | Frank Smith S000533 | rep | MS | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27546 | 27546 | Brent Spence S000717 | rep | KY | 1957-01-03 | 1959-01-03 | Democrat | 5 | |||||||||||||
27566 | 27566 | John Taber T000001 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 36 | |||||||||||||
27570 | 27570 | Stewart Udall U000002 | rep | AZ | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
27581 | 27581 | James Van Zandt V000069 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 20 | |||||||||||||
27585 | 27585 | Phillip Weaver W000228 | rep | NE | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27591 | 27591 | Herbert Zelenko Z000003 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27604 | 27604 | Bruce Alger A000106 | rep | TX | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27615 | 27615 | James Auchincloss A000227 | rep | NJ | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27620 | 27620 | William Avery A000228 | rep | KS | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
27627 | 27627 | Howard Baker B000062 | rep | TN | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27637 | 27637 | Frank Becker B000292 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27649 | 27649 | John Bennett B000377 | rep | MI | 1957-01-03 | 1959-01-03 | Republican | 12 | |||||||||||||
27674 | 27674 | Charles Buckley B001024 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 24 | |||||||||||||
27696 | 27696 | Clarence Cannon C000117 | rep | MO | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27717 | 27717 | John Chenoweth C000346 | rep | CO | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
27732 | 27732 | Clifford Davis D000094 | rep | TN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27738 | 27738 | Steven Derounian D000266 | rep | NY | 1957-01-03 | 1959-01-03 | Republican | 2 | |||||||||||||
27758 | 27758 | Clyde Doyle D000481 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 23 | |||||||||||||
27767 | 27767 | Carl Elliott E000120 | rep | AL | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27777 | 27777 | Antonio Fernós-Isern F000087 | rep | PR | 1957-01-03 | 1959-01-03 | Popular Democrat | 0 | |||||||||||||
27786 | 27786 | Elijah Forrester F000283 | rep | GA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27796 | 27796 | Julian Gary G000091 | rep | VA | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27807 | 27807 | Leon Gavin G000102 | rep | PA | 1957-01-03 | 1959-01-03 | Republican | 23 |
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);