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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23414 | 23414 | Anthony Dimond D000353 | rep | AK | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22498 | 22498 | William Bankhead B000113 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23347 | 23347 | John Bankhead B000111 | sen | AL | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
27878 | 27878 | Joseph Hill H000598 | rep | AL | 1937-01-05 | 1938-01-11 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
22311 | 22311 | John Miller M000738 | sen | AR | 1937-01-05 | 1941-12-31 | 2 | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
24865 | 24865 | Edwin Johnson J000127 | sen | CO | 1937-01-05 | 1943-01-03 | 2 | 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 | |||||||||||||
22235 | 22235 | James Hughes H000926 | sen | DE | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
29025 | 29025 | Richard Russell R000536 | sen | GA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
22226 | 22226 | Clyde Herring H000543 | sen | IA | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
22052 | 22052 | William Borah B000634 | sen | ID | 1937-01-05 | 1941-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
22278 | 22278 | James Lewis L000284 | sen | IL | 1937-01-05 | 1939-12-31 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
23121 | 23121 | Raymond McKeough M000510 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23144 | 23144 | Arthur Mitchell M000805 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 1 |
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);