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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (date)
party 5 ✖
- Democrat 351
- Republican 119
- Progressive 7
- Farmer-Labor 4
- Coalitionist 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23413 | 23413 | Anthony Dimond D000353 | rep | AK | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21688 | 21688 | Archibald Carmichael C000159 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21828 | 21828 | George Huddleston H000903 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
21871 | 21871 | John McDuffie M000427 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21910 | 21910 | William Oliver O000077 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22497 | 22497 | William Bankhead B000113 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23346 | 23346 | John Bankhead B000111 | sen | AL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
23682 | 23682 | Joe Starnes S000816 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23697 | 23697 | Henry Steagall S000820 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24846 | 24846 | Samuel Hobbs H000663 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
27110 | 27110 | Frank Boykin B000725 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
27877 | 27877 | Joseph Hill H000598 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
20815 | 20815 | Joseph Robinson R000347 | sen | AR | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
21918 | 21918 | Tilman Parks P000075 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
22124 | 22124 | William Driver D000503 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22159 | 22159 | Claude Fuller F000408 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22310 | 22310 | John Miller M000738 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22530 | 22530 | William Cravens C000886 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23290 | 23290 | David Terry T000133 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
30563 | 30563 | John McClellan M000332 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21774 | 21774 | Isabella Greenway G000435 | rep | AZ | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21669 | 21669 | George Burnham B001124 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
21705 | 21705 | Samuel Collins C000643 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21813 | 21813 | John Hoeppel H000677 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
21838 | 21838 | Florence Kahn K000002 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22112 | 22112 | John Dockweiler D000387 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
22297 | 22297 | John McGrath M000457 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22299 | 22299 | John McGroarty M000462 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22402 | 22402 | Byron Scott S000165 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22431 | 22431 | Henry Stubbs S001038 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22890 | 22890 | Frank Buck B001017 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23089 | 23089 | Charles Kramer K000321 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
23367 | 23367 | Albert Carter C000195 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
23375 | 23375 | John Costello C000795 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
23446 | 23446 | Harry Englebright E000182 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23476 | 23476 | Thomas Ford F000267 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
24158 | 24158 | John Tolan T000295 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
24401 | 24401 | Bertrand Gearhart G000111 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24544 | 24544 | Clarence Lea L000163 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
25066 | 25066 | Richard Welch W000265 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
20250 | 20250 | Edward Costigan C000797 | sen | CO | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22539 | 22539 | Fred Cummings C000985 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22692 | 22692 | John Martin M000186 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23283 | 23283 | Edward Taylor T000072 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23580 | 23580 | Lawrence Lewis L000291 | rep | CO | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21804 | 21804 | William Higgins H000580 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21888 | 21888 | Schuyler Merritt M000663 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
22090 | 22090 | William Citron C000397 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
23228 | 23228 | James Shanley S000285 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23244 | 23244 | John Smith S000572 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
23940 | 23940 | Herman Kopplemann K000315 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
20479 | 20479 | Daniel Hastings H000325 | sen | DE | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
21263 | 21263 | Duncan Fletcher F000200 | sen | FL | 1933-03-09 | 1937-01-03 | 3 | Democrat | |||||||||||||
21968 | 21968 | William Sears S000211 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | -1 | |||||||||||||
22015 | 22015 | William Hill H000612 | sen | FL | 1936-07-01 | 1937-01-03 | 3 | Democrat | appointment | ||||||||||||
22018 | 22018 | Scott Loftin L000400 | sen | FL | 1936-05-26 | 1937-01-03 | 1 | Democrat | appointment | ||||||||||||
22461 | 22461 | James Wilcox W000455 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22512 | 22512 | Millard Caldwell C000038 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23531 | 23531 | Robert Green G000415 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24973 | 24973 | James Peterson P000261 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21696 | 21696 | Bryant Castellow C000240 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22108 | 22108 | Braswell Deen D000187 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22739 | 22739 | Emmett Owen O000149 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23742 | 23742 | Benjamin Whelchel W000343 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24028 | 24028 | Hugh Peterson P000260 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24054 | 24054 | Robert Ramspeck R000032 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24137 | 24137 | Malcolm Tarver T000045 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
25194 | 25194 | Edward Cox C000831 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
26749 | 26749 | Paul Brown B000940 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
28214 | 28214 | Carl Vinson V000105 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
29024 | 29024 | Richard Russell R000536 | sen | GA | 1933-03-09 | 1937-01-03 | 2 | Democrat | |||||||||||||
23079 | 23079 | Samuel King K000214 | rep | HI | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
20299 | 20299 | Lester Dickinson D000323 | sen | IA | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
21446 | 21446 | Richard Murphy M001103 | sen | IA | 1933-03-09 | 1937-01-03 | 3 | Democrat | |||||||||||||
21832 | 21832 | Bernhard Jacobsen J000038 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21994 | 21994 | Hubert Utterback U000036 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22038 | 22038 | Frederick Biermann B000449 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22129 | 22129 | Edward Eicher E000094 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22446 | 22446 | Lloyd Thurston T000257 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22458 | 22458 | Otha Wearin W000221 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23507 | 23507 | Fred Gilchrist G000181 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
24445 | 24445 | John Gwynne G000543 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
22051 | 22051 | William Borah B000634 | sen | ID | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
22521 | 22521 | David Clark C000428 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
25078 | 25078 | Compton White W000361 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21606 | 21606 | Jackson Adair A000025 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21621 | 21621 | William Arnold A000300 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
21654 | 21654 | Martin Brennan B000799 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21665 | 21665 | John Buckbee B001020 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21740 | 21740 | Donald Dobbins D000382 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
21829 | 21829 | Michael Igoe I000004 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21862 | 21862 | Harry Mason M000214 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
22277 | 22277 | James Lewis L000284 | sen | IL | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22302 | 22302 | James Meeks M000631 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
22439 | 22439 | Chester Thompson T000197 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
22651 | 22651 | Kent Keller K000056 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 25 | |||||||||||||
22702 | 22702 | James McAndrews M000296 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22745 | 22745 | Claude Parsons P000086 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 24 |
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);