legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
483 rows where "start" is on date 1937-01-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25112 | 25112 | Asa Allen A000114 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
25091 | 25091 | William Whittington W000430 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
25079 | 25079 | Compton White W000361 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25067 | 25067 | Richard Welch W000265 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
25052 | 25052 | James Wadsworth W000012 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 39 | |||||||||||||
25041 | 25041 | John Thomas T000175 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 7 | |||||||||||||
25033 | 25033 | Andrew Somers S000676 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
25013 | 25013 | George Sadowski S000011 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25005 | 25005 | Robert Rich R000209 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 16 | |||||||||||||
24994 | 24994 | Charles Plumley P000395 | rep | VT | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
24982 | 24982 | Joseph Pfeifer P000285 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24974 | 24974 | James Peterson P000261 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24965 | 24965 | Stephen Pace P000002 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24957 | 24957 | Mary Norton N000153 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
24941 | 24941 | Earl Michener M000693 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
24929 | 24929 | John McSweeney M000606 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | -1 | |||||||||||||
24891 | 24891 | John Lesinski L000251 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24883 | 24883 | William Lemke L000238 | rep | ND | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
24865 | 24865 | Edwin Johnson J000127 | sen | CO | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
24847 | 24847 | Samuel Hobbs H000663 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24823 | 24823 | Albert Engel E000178 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24805 | 24805 | Ralph Church C000390 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
24796 | 24796 | Virgil Chapman C000317 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24782 | 24782 | Alfred Bulwinkle B001056 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24766 | 24766 | Sol Bloom B000565 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
24752 | 24752 | Schuyler Bland B000545 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24732 | 24732 | George Bates B000232 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
24722 | 24722 | Orville Zimmerman Z000009 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24714 | 24714 | Milton West W000304 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
24695 | 24695 | Robert Thomason T000189 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24658 | 24658 | John Robsion R000358 | rep | KY | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24587 | 24587 | Joseph Mansfield M000112 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24564 | 24564 | Louis Ludlow L000501 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24556 | 24556 | Henry Lodge L000394 | sen | MA | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
24545 | 24545 | Clarence Lea L000163 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24524 | 24524 | Harold Knutson K000301 | rep | MN | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
24481 | 24481 | Peterson Jarman J000058 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24470 | 24470 | Joseph Hendricks H000492 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24464 | 24464 | Fred Hartley H000298 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
24446 | 24446 | John Gwynne G000543 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
24421 | 24421 | Charles Gifford G000169 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 15 | |||||||||||||
24402 | 24402 | Bertrand Gearhart G000111 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24384 | 24384 | John Flannagan F000191 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24370 | 24370 | Alfred Elliott E000119 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24363 | 24363 | Patrick Drewry D000496 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24343 | 24343 | John Delaney D000212 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24304 | 24304 | Charles Clason C000473 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
24298 | 24298 | Jerome Clark C000439 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24282 | 24282 | Ralph Brewster B000816 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
24266 | 24266 | Charles Bell B000332 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24255 | 24255 | Walter Andrews A000250 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 40 | |||||||||||||
24248 | 24248 | William Umstead U000005 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24236 | 24236 | Thomas Burch B001069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24224 | 24224 | Clifton Woodrum W000720 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24212 | 24212 | James Wolfenden W000678 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
24195 | 24195 | Zebulon Weaver W000230 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
24174 | 24174 | Horace Voorhis V000118 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24159 | 24159 | John Tolan T000295 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24146 | 24146 | William Thom T000155 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
24138 | 24138 | Malcolm Tarver T000045 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24125 | 24125 | Hatton Sumners S001072 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24100 | 24100 | John Snyder S000668 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
24085 | 24085 | Dave Satterfield S000069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24065 | 24065 | James Robinson R000341 | rep | UT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24055 | 24055 | Robert Ramspeck R000032 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24044 | 24044 | David Powers P000488 | rep | NJ | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
24029 | 24029 | Hugh Peterson P000260 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24023 | 24023 | Luther Patrick P000105 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24012 | 24012 | Emmet O’Neal O000089 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24006 | 24006 | James O’Connor O000029 | rep | MT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23995 | 23995 | James Mott M001040 | rep | OR | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23984 | 23984 | Daniel McGehee M000446 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23978 | 23978 | Andrew May M000272 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23970 | 23970 | Paul Maloney M000091 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23962 | 23962 | Scott Lucas L000493 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23955 | 23955 | Fritz Lanham L000076 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23941 | 23941 | Herman Kopplemann K000315 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23934 | 23934 | John Kinzer K000231 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23926 | 23926 | Edward Kelly K000071 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23918 | 23918 | Luther Johnson J000159 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23906 | 23906 | Jed Johnson J000150 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23896 | 23896 | Edouard Izac I000052 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23891 | 23891 | Frank Hook H000757 | rep | MI | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23885 | 23885 | Pehr Holmes H000741 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
23860 | 23860 | Clarence Hancock H000146 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 35 | |||||||||||||
23833 | 23833 | Samuel Dickstein D000335 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23814 | 23814 | John Coffee C000584 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23809 | 23809 | John Cochran C000565 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
23782 | 23782 | Michael Bradley B000743 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23777 | 23777 | Lyle Boren B000640 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23771 | 23771 | William Barry B000191 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23755 | 23755 | Wallace White W000396 | sen | ME | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
23743 | 23743 | Benjamin Whelchel W000343 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23736 | 23736 | Elmer Wene W000294 | rep | NJ | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23728 | 23728 | Beverly Vincent V000100 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23723 | 23723 | Allen Treadway T000358 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23698 | 23698 | Henry Steagall S000820 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23683 | 23683 | Joe Starnes S000816 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23677 | 23677 | Joseph Smith S000580 | rep | WV | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23669 | 23669 | Leonard Schuetz S000144 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 7 |
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);