legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1935-01-03 sorted by party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19648 | 19648 | Bronson Cutting C001028 | sen | NM | 1935-01-03 | 1935-05-06 | 1 | Republican | |||||||||||||
21614 | 21614 | Abram Andrew A000240 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
21639 | 21639 | Isaac Bacharach B000009 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21665 | 21665 | John Buckbee B001020 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21669 | 21669 | George Burnham B001124 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
21699 | 21699 | Peter Cavicchia C000262 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
21701 | 21701 | Theodore Christianson C000381 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
21705 | 21705 | Samuel Collins C000643 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21720 | 21720 | John Cooper C000757 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21760 | 21760 | William Ekwall E000098 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21767 | 21767 | Lynn Frazier F000354 | sen | ND | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21800 | 21800 | Frederick Hale H000031 | sen | ME | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21804 | 21804 | William Higgins H000580 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
21816 | 21816 | John Hollister H000728 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21838 | 21838 | Florence Kahn K000002 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21839 | 21839 | Henry Kimball K000183 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21856 | 21856 | Frederick Lehlbach L000222 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
21859 | 21859 | Verner Main M000071 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21861 | 21861 | Leroy Marshall M000158 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21888 | 21888 | Schuyler Merritt M000663 | rep | CT | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
21926 | 21926 | Randolph Perkins P000237 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
21940 | 21940 | Harry Ransley R000061 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21971 | 21971 | John Stewart S000915 | rep | DE | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
21973 | 21973 | William Thomas T000187 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 29 | |||||||||||||
21976 | 21976 | John Townsend T000335 | sen | DE | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21986 | 21986 | Charles Turpin T000433 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
22008 | 22008 | William Wilson W000622 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22033 | 22033 | Robert Bacon B000019 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22151 | 22151 | Benjamin Focht F000230 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 18 | |||||||||||||
22183 | 22183 | Philip Goodwin G000302 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 27 | |||||||||||||
22306 | 22306 | Charles Millard M000709 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 25 | |||||||||||||
22426 | 22426 | Bertrand Snell S000652 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 31 | |||||||||||||
22446 | 22446 | Lloyd Thurston T000257 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22505 | 22505 | Chester Bolton B000606 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 22 | |||||||||||||
22559 | 22559 | George Darrow D000063 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
22661 | 22661 | Bert Lord L000439 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 34 | |||||||||||||
22685 | 22685 | Carl Mapes M000119 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
22712 | 22712 | Clarence McLeod M000557 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
22752 | 22752 | Charles Risk R000269 | rep | RI | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22772 | 22772 | George Seger S000228 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
22813 | 22813 | James Taylor T000083 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22853 | 22853 | Warren Austin A000342 | sen | VT | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
22953 | 22953 | Frank Crowther C000948 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 30 | |||||||||||||
23075 | 23075 | Hiram Johnson J000140 | sen | CA | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23079 | 23079 | Samuel King K000214 | rep | HI | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
23240 | 23240 | Henrik Shipstead S000369 | sen | MN | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
23306 | 23306 | George Tinkham T000283 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23367 | 23367 | Albert Carter C000195 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
23389 | 23389 | Francis Culkin C000968 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 32 | |||||||||||||
23426 | 23426 | John Ditter D000363 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
23446 | 23446 | Harry Englebright E000182 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23461 | 23461 | Hamilton Fish F000142 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 26 | |||||||||||||
23507 | 23507 | Fred Gilchrist G000181 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
23541 | 23541 | Ulysses Guyer G000538 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
23574 | 23574 | William Lambertson L000037 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23588 | 23588 | Melvin Maas M000001 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
23599 | 23599 | Donald McLean M000545 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
23722 | 23722 | Allen Treadway T000358 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23859 | 23859 | Clarence Hancock H000146 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 35 | |||||||||||||
23884 | 23884 | Pehr Holmes H000741 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
23933 | 23933 | John Kinzer K000231 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23994 | 23994 | James Mott M001040 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
24036 | 24036 | William Pittenger P000371 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
24043 | 24043 | David Powers P000488 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 4 | |||||||||||||
24211 | 24211 | James Wolfenden W000678 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
24254 | 24254 | Walter Andrews A000250 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 40 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24401 | 24401 | Bertrand Gearhart G000111 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24420 | 24420 | Charles Gifford G000169 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 15 | |||||||||||||
24445 | 24445 | John Gwynne G000543 | rep | IA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24463 | 24463 | Fred Hartley H000298 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
24523 | 24523 | Harold Knutson K000301 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
24657 | 24657 | John Robsion R000358 | rep | KY | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24804 | 24804 | Ralph Church C000390 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
24822 | 24822 | Albert Engel E000178 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 9 | |||||||||||||
24882 | 24882 | William Lemke L000238 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
24911 | 24911 | Vito Marcantonio M000122 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
24940 | 24940 | Earl Michener M000693 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
24993 | 24993 | Charles Plumley P000395 | rep | VT | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
25004 | 25004 | Robert Rich R000209 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 16 | |||||||||||||
25051 | 25051 | James Wadsworth W000012 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 39 | |||||||||||||
25066 | 25066 | Richard Welch W000265 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
25138 | 25138 | William Blackney B000515 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
25203 | 25203 | Fred Crawford C000889 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
25240 | 25240 | Charles Eaton E000023 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
25492 | 25492 | Karl Stefan S000845 | rep | NE | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
25521 | 25521 | Charles Tobey T000289 | rep | NH | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
25560 | 25560 | Roy Woodruff W000718 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
25930 | 25930 | George Dondero D000411 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
26011 | 26011 | Clifford Hope H000768 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26093 | 26093 | Chauncey Reed R000111 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
26117 | 26117 | Dewey Short S000377 | rep | MO | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26138 | 26138 | Jesse Wolcott W000668 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 7 | |||||||||||||
26166 | 26166 | August Andresen A000239 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
26189 | 26189 | Usher Burdick B001079 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
26238 | 26238 | William Cole C000617 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 37 | |||||||||||||
26424 | 26424 | Thomas Jenkins J000088 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 10 |
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);