legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "end" is on date 1939-01-03 sorted by state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22498 | 22498 | William Bankhead B000113 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23683 | 23683 | Joe Starnes S000816 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23698 | 23698 | Henry Steagall S000820 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24023 | 24023 | Luther Patrick P000105 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24481 | 24481 | Peterson Jarman J000058 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24847 | 24847 | Samuel Hobbs H000663 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
27111 | 27111 | Frank Boykin B000725 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
27816 | 27816 | George Grant G000381 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
27879 | 27879 | Joseph Hill H000598 | sen | AL | 1938-01-11 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
30694 | 30694 | John Sparkman S000701 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22125 | 22125 | William Driver D000503 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22160 | 22160 | Claude Fuller F000408 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22516 | 22516 | Hattie Caraway C000138 | sen | AR | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22531 | 22531 | William Cravens C000886 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22659 | 22659 | Wade Kitchens K000248 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23291 | 23291 | David Terry T000133 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
30564 | 30564 | John McClellan M000332 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
25394 | 25394 | John Murdock M001081 | rep | AZ | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
27852 | 27852 | Carl Hayden H000385 | sen | AZ | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
21397 | 21397 | William McAdoo M000293 | sen | CA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22094 | 22094 | Charles Colden C000605 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22113 | 22113 | John Dockweiler D000387 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 16 | |||||||||||||
22298 | 22298 | John McGrath M000457 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22300 | 22300 | John McGroarty M000462 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22403 | 22403 | Byron Scott S000165 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22432 | 22432 | Henry Stubbs S001038 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22467 | 22467 | Thomas Storke S000973 | sen | CA | 1938-11-09 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22891 | 22891 | Frank Buck B001017 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23090 | 23090 | Charles Kramer K000321 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
23368 | 23368 | Albert Carter C000195 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
23376 | 23376 | John Costello C000795 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23447 | 23447 | Harry Englebright E000182 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
23477 | 23477 | Thomas Ford F000267 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
23896 | 23896 | Edouard Izac I000052 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
24159 | 24159 | John Tolan T000295 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24174 | 24174 | Horace Voorhis V000118 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
24370 | 24370 | Alfred Elliott E000119 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24402 | 24402 | Bertrand Gearhart G000111 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 9 | |||||||||||||
24545 | 24545 | Clarence Lea L000163 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
25067 | 25067 | Richard Welch W000265 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
25306 | 25306 | Franck Havenner H000356 | rep | CA | 1937-01-05 | 1939-01-03 | Progressive | 4 | |||||||||||||
28139 | 28139 | Harry Sheppard S000335 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22469 | 22469 | Alva Adams A000028 | sen | CO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22540 | 22540 | Fred Cummings C000985 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22693 | 22693 | John Martin M000186 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23284 | 23284 | Edward Taylor T000072 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23581 | 23581 | Lawrence Lewis L000291 | rep | CO | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
21383 | 21383 | Augustine Lonergan L000409 | sen | CT | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22091 | 22091 | William Citron C000397 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22373 | 22373 | Alfred Phillips P000305 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22990 | 22990 | William Fitzgerald F000169 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23229 | 23229 | James Shanley S000285 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23245 | 23245 | John Smith S000572 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23941 | 23941 | Herman Kopplemann K000315 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22022 | 22022 | William Allen A000151 | rep | DE | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22462 | 22462 | James Wilcox W000455 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22513 | 22513 | Millard Caldwell C000038 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23532 | 23532 | Robert Green G000415 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24470 | 24470 | Joseph Hendricks H000492 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24974 | 24974 | James Peterson P000261 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
34046 | 34046 | Claude Pepper P000218 | sen | FL | 1936-01-01 | 1939-01-03 | 3 | Democrat | |||||||||||||
22109 | 22109 | Braswell Deen D000187 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22740 | 22740 | Emmett Owen O000149 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23743 | 23743 | Benjamin Whelchel W000343 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24029 | 24029 | Hugh Peterson P000260 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24055 | 24055 | Robert Ramspeck R000032 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
24138 | 24138 | Malcolm Tarver T000045 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
24965 | 24965 | Stephen Pace P000002 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
25195 | 25195 | Edward Cox C000831 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25268 | 25268 | Walter George G000131 | sen | GA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
26750 | 26750 | Paul Brown B000940 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
28215 | 28215 | Carl Vinson V000105 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23080 | 23080 | Samuel King K000214 | rep | HI | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
22039 | 22039 | Frederick Biermann B000449 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22130 | 22130 | Edward Eicher E000094 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22447 | 22447 | Lloyd Thurston T000257 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 5 | |||||||||||||
22459 | 22459 | Otha Wearin W000221 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22581 | 22581 | Cassius Dowell D000468 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
23024 | 23024 | Vincent Harrington H000231 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
23055 | 23055 | William Jacobsen J000039 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23508 | 23508 | Fred Gilchrist G000181 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
24446 | 24446 | John Gwynne G000543 | rep | IA | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
24833 | 24833 | Guy Gillette G000205 | sen | IA | 1936-01-01 | 1939-01-03 | 3 | Democrat | |||||||||||||
21481 | 21481 | James Pope P000430 | sen | ID | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22522 | 22522 | David Clark C000428 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
25079 | 25079 | Compton White W000361 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
21235 | 21235 | William Dieterich D000339 | sen | IL | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22053 | 22053 | Lewis Boyer B000724 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
22089 | 22089 | Edwin Champion C000287 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22281 | 22281 | Lewis Long L000424 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22303 | 22303 | James Meeks M000631 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 18 | |||||||||||||
22383 | 22383 | Hugh Rigney R000256 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22440 | 22440 | Chester Thompson T000197 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 14 | |||||||||||||
22599 | 22599 | Frank Fries F000385 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22652 | 22652 | Kent Keller K000056 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 25 | |||||||||||||
22703 | 22703 | James McAndrews M000296 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22746 | 22746 | Claude Parsons P000086 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 24 | |||||||||||||
22849 | 22849 | Laurence Arnold A000290 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22864 | 22864 | Harry Beam B000274 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23085 | 23085 | Leo Kocialkowski K000303 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 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);