legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "end" is on date 1937-01-03 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24586 | 24586 | Joseph Mansfield M000112 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24563 | 24563 | Louis Ludlow L000501 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
24544 | 24544 | Clarence Lea L000163 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24523 | 24523 | Harold Knutson K000301 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
24463 | 24463 | Fred Hartley H000298 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
24445 | 24445 | John Gwynne G000543 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24420 | 24420 | Charles Gifford G000169 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 15 | |||||||||||||
24401 | 24401 | Bertrand Gearhart G000111 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24383 | 24383 | John Flannagan F000191 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24362 | 24362 | Patrick Drewry D000496 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
24342 | 24342 | John Delaney D000212 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24297 | 24297 | Jerome Clark C000439 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24265 | 24265 | Charles Bell B000332 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
24254 | 24254 | Walter Andrews A000250 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 40 | |||||||||||||
24247 | 24247 | William Umstead U000005 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24235 | 24235 | Thomas Burch B001069 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24223 | 24223 | Clifton Woodrum W000720 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24211 | 24211 | James Wolfenden W000678 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
24194 | 24194 | Zebulon Weaver W000230 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
24158 | 24158 | John Tolan T000295 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24145 | 24145 | William Thom T000155 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24137 | 24137 | Malcolm Tarver T000045 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24124 | 24124 | Hatton Sumners S001072 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24099 | 24099 | John Snyder S000668 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
24064 | 24064 | James Robinson R000341 | rep | UT | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24054 | 24054 | Robert Ramspeck R000032 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24043 | 24043 | David Powers P000488 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
24036 | 24036 | William Pittenger P000371 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
24028 | 24028 | Hugh Peterson P000260 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24011 | 24011 | Emmet O’Neal O000089 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23994 | 23994 | James Mott M001040 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23983 | 23983 | Daniel McGehee M000446 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23977 | 23977 | Andrew May M000272 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23969 | 23969 | Paul Maloney M000091 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23961 | 23961 | Scott Lucas L000493 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23954 | 23954 | Fritz Lanham L000076 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
23940 | 23940 | Herman Kopplemann K000315 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23933 | 23933 | John Kinzer K000231 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23925 | 23925 | Edward Kelly K000071 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23917 | 23917 | Luther Johnson J000159 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23905 | 23905 | Jed Johnson J000150 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23890 | 23890 | Frank Hook H000757 | rep | MI | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
23884 | 23884 | Pehr Holmes H000741 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
23859 | 23859 | Clarence Hancock H000146 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 35 | |||||||||||||
23832 | 23832 | Samuel Dickstein D000335 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
23808 | 23808 | John Cochran C000565 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
23770 | 23770 | William Barry B000191 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23754 | 23754 | Wallace White W000396 | sen | ME | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23742 | 23742 | Benjamin Whelchel W000343 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
23722 | 23722 | Allen Treadway T000358 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23697 | 23697 | Henry Steagall S000820 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23682 | 23682 | Joe Starnes S000816 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23676 | 23676 | Joseph Smith S000580 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23668 | 23668 | Leonard Schuetz S000144 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23658 | 23658 | Harry Sauthoff S000079 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 2 | |||||||||||||
23646 | 23646 | Nat Patton P000142 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23638 | 23638 | James O’Leary O000065 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
23628 | 23628 | John Nichols N000092 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23613 | 23613 | Matthew Merritt M000661 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
23609 | 23609 | Charles McNary M000583 | sen | OR | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23599 | 23599 | Donald McLean M000545 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
23588 | 23588 | Melvin Maas M000001 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
23580 | 23580 | Lawrence Lewis L000291 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23574 | 23574 | William Lambertson L000037 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23566 | 23566 | Richard Kleberg K000257 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23559 | 23559 | Martin Kennedy K000111 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
23548 | 23548 | Carl Hatch H000334 | sen | NM | 1933-10-10 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
23541 | 23541 | Ulysses Guyer G000538 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23531 | 23531 | Robert Green G000415 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23523 | 23523 | Carter Glass G000232 | sen | VA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23507 | 23507 | Fred Gilchrist G000181 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
23500 | 23500 | Joseph Gavagan G000101 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23488 | 23488 | Hampton Fulmer F000417 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23476 | 23476 | Thomas Ford F000267 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23470 | 23470 | James Fitzpatrick F000175 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 24 | |||||||||||||
23461 | 23461 | Hamilton Fish F000142 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 26 | |||||||||||||
23446 | 23446 | Harry Englebright E000182 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23426 | 23426 | John Ditter D000363 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
23420 | 23420 | Wesley Disney D000362 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23413 | 23413 | Anthony Dimond D000353 | rep | AK | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
23402 | 23402 | Thomas Cullen C000970 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23389 | 23389 | Francis Culkin C000968 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 32 | |||||||||||||
23380 | 23380 | Edward Creal C000898 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23375 | 23375 | John Costello C000795 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
23367 | 23367 | Albert Carter C000195 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
23358 | 23358 | Arthur Capper C000133 | sen | KS | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23346 | 23346 | John Bankhead B000111 | sen | AL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23341 | 23341 | Josiah Bailey B000046 | sen | NC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23334 | 23334 | James Scrugham S000196 | rep | NV | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
23325 | 23325 | Clyde Williams W000494 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
23306 | 23306 | George Tinkham T000283 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23290 | 23290 | David Terry T000133 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23283 | 23283 | Edward Taylor T000072 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23266 | 23266 | Martin Sweeney S001102 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23260 | 23260 | William Sutphin S001086 | rep | NJ | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23253 | 23253 | Charles South S000683 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23244 | 23244 | John Smith S000572 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23234 | 23234 | Joseph Shannon S000287 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 5 |
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);