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 descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20069 | 20069 | Robert Carey C000146 | sen | WY | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
22202 | 22202 | Paul Greever G000440 | rep | WY | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
22978 | 22978 | Andrew Edmiston E000051 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23068 | 23068 | George Johnson J000132 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23676 | 23676 | Joseph Smith S000580 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
25339 | 25339 | John Kee K000039 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
25428 | 25428 | Robert Ramsay R000025 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
26068 | 26068 | Matthew Neely N000023 | sen | WV | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
32242 | 32242 | Jennings Randolph R000046 | rep | WV | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22024 | 22024 | Thomas Amlie A000176 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 1 | |||||||||||||
22045 | 22045 | Gerald Boileau B000598 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 7 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22353 | 22353 | Thomas O’Malley O000087 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22381 | 22381 | Michael Reilly R000155 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22399 | 22399 | George Schneider S000137 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 8 | |||||||||||||
23006 | 23006 | Bernard Gehrmann G000118 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 10 | |||||||||||||
23658 | 23658 | Harry Sauthoff S000079 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 2 | |||||||||||||
25714 | 25714 | Merlin Hull H000943 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 9 | |||||||||||||
27048 | 27048 | Gardner Withrow W000663 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 3 | |||||||||||||
21811 | 21811 | Samuel Hill H000607 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21858 | 21858 | Wesley Lloyd L000383 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22842 | 22842 | Monrad Wallgren W000088 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23038 | 23038 | Knute Hill H000600 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
24993 | 24993 | Charles Plumley P000395 | rep | VT | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
22327 | 22327 | Andrew Montague M000861 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22958 | 22958 | Colgate Darden D000050 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23523 | 23523 | Carter Glass G000232 | sen | VA | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
24223 | 24223 | Clifton Woodrum W000720 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
24235 | 24235 | Thomas Burch B001069 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24362 | 24362 | Patrick Drewry D000496 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
24383 | 24383 | John Flannagan F000191 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24751 | 24751 | Schuyler Bland B000545 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
27488 | 27488 | Absalom Robertson R000317 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
28659 | 28659 | Howard Smith S000554 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
23151 | 23151 | Orrice Murdock M001082 | rep | UT | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24064 | 24064 | James Robinson R000341 | rep | UT | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21652 | 21652 | Thomas Blanton B000549 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
21734 | 21734 | Oliver Cross C000931 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
21758 | 21758 | Joe Eagle E000003 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22073 | 22073 | James Buchanan B001006 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22291 | 22291 | Fontaine Maverick M000263 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
22294 | 22294 | William McFarlane M000440 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22392 | 22392 | Morgan Sanders S000037 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22412 | 22412 | Morris Sheppard S000337 | sen | TX | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22646 | 22646 | John Jones J000236 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 18 | |||||||||||||
23253 | 23253 | Charles South S000683 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
23566 | 23566 | Richard Kleberg K000257 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
23646 | 23646 | Nat Patton P000142 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23917 | 23917 | Luther Johnson J000159 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23954 | 23954 | Fritz Lanham L000076 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
24124 | 24124 | Hatton Sumners S001072 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
24586 | 24586 | Joseph Mansfield M000112 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24694 | 24694 | Robert Thomason T000189 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 16 | |||||||||||||
24713 | 24713 | Milton West W000304 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
26302 | 26302 | Martin Dies D000338 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
27445 | 27445 | Samuel Rayburn R000082 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
31255 | 31255 | John Patman P000103 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
31621 | 31621 | George Mahon M000065 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
21105 | 21105 | Nathan Bachman B000010 | sen | TN | 1933-03-09 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
21683 | 21683 | Joseph Byrns B001217 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22314 | 22314 | John Mitchell M000823 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22518 | 22518 | Walter Chandler C000296 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22729 | 22729 | Samuel McReynolds M000598 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22813 | 22813 | James Taylor T000083 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22819 | 22819 | Clarence Turner T000417 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23171 | 23171 | Herron Pearson P000165 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
26253 | 26253 | Jere Cooper C000755 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
27465 | 27465 | Brazilla Reece R000108 | rep | TN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21451 | 21451 | Peter Norbeck N000132 | sen | SD | 1933-03-09 | 1937-01-03 | 3 | Republican | |||||||||||||
21996 | 21996 | Theodore Werner W000299 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22075 | 22075 | William Bulow B001055 | sen | SD | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22230 | 22230 | Fred Hildebrandt H000584 | rep | SD | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21879 | 21879 | John McSwain M000604 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22084 | 22084 | James Byrnes B001215 | sen | SC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22175 | 22175 | Allard Gasque G000092 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22289 | 22289 | Gabriel Mahon M000064 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22435 | 22435 | John Taylor T000087 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
22720 | 22720 | Thomas McMillan M000572 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23488 | 23488 | Hampton Fulmer F000417 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
26105 | 26105 | James Richards R000214 | rep | SC | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
20712 | 20712 | Jesse Metcalf M000670 | sen | RI | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
21709 | 21709 | Francis Condon C000673 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22342 | 22342 | John O’Connell O000025 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22752 | 22752 | Charles Risk R000269 | rep | RI | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22633 | 22633 | Santiago Iglesias I000002 | rep | PR | 1935-01-03 | 1937-01-03 | Coalitionist | 0 | |||||||||||||
21737 | 21737 | Francisco Delgado D000218 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
21796 | 21796 | Pedro Guevara G000518 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
22362 | 22362 | Quintin Paredes P000050 | rep | PI | 1935-01-03 | 1937-01-03 | 0 | ||||||||||||||
21642 | 21642 | William Berlin B000409 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
21656 | 21656 | Joshua Brooks B000882 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 30 | |||||||||||||
21738 | 21738 | Charles Dietrich D000340 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21746 | 21746 | Isaac Doutrich D000460 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21747 | 21747 | Denis Driscoll D000501 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
21761 | 21761 | Clare Fenerty F000071 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21899 | 21899 | Theodore Moritz M000962 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 32 | |||||||||||||
21940 | 21940 | Harry Ransley R000061 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21942 | 21942 | William Richardson R000230 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 14 | |||||||||||||
21986 | 21986 | Charles Turpin T000433 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 12 |
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);