legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1933-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class
start (date) 11 ✖
- 1931-12-07 464
- 1927-12-05 24
- 1930-01-01 3
- 1928-01-01 1
- 1928-06-30 1
- 1929-04-15 1
- 1930-12-13 1
- 1932-01-01 1
- 1932-09-26 1
- 1932-11-22 1
- 1932-12-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21460 | 21460 | Camilo Osias O000118 | rep | PI | 1931-12-07 | 1933-03-03 | 0 | ||||||||||||||
21794 | 21794 | Pedro Guevara G000518 | rep | PI | 1931-12-07 | 1933-03-03 | 0 | ||||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
20018 | 20018 | Claude Swanson S001094 | sen | VA | 1929-04-15 | 1933-03-03 | 1 | Democrat | |||||||||||||
20107 | 20107 | James Aswell A000321 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20120 | 20120 | William Barton B000217 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 16 | |||||||||||||
20171 | 20171 | Harry Canfield C000114 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20221 | 20221 | James Collier C000630 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20270 | 20270 | Charles Crisp C000909 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20291 | 20291 | Ewin Davis D000098 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20307 | 20307 | Frederick Dominick D000408 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20310 | 20310 | Lewis Douglas D000455 | rep | AZ | 1931-12-07 | 1933-03-03 | Democrat | 0 | |||||||||||||
20318 | 20318 | Herbert Drane D000486 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20348 | 20348 | Charles Edwards E000062 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20354 | 20354 | Edward Eslick E000216 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20355 | 20355 | Willa Eslick E000217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20367 | 20367 | John Evans E000247 | rep | MT | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20370 | 20370 | John Fishburne F000143 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20371 | 20371 | Joel Flood F000211 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
20402 | 20402 | James Fulbright F000400 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
20415 | 20415 | Daniel Garrett G000081 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20420 | 20420 | Ralph Gilbert G000177 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20421 | 20421 | Courtland Gillen G000193 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20462 | 20462 | Robert Hall H000069 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20477 | 20477 | William Harris H000259 | sen | GA | 1931-12-07 | 1933-03-03 | 2 | Democrat | |||||||||||||
20563 | 20563 | James Igoe I000003 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20574 | 20574 | Robert Johnson J000171 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20591 | 20591 | Charles Karch K000010 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 22 | |||||||||||||
20619 | 20619 | Stanley Kunz K000342 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
20635 | 20635 | William Lankford L000082 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
20643 | 20643 | William Larsen L000103 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
20652 | 20652 | Norton Lichtenwalner L000300 | rep | PA | 1931-12-07 | 1933-03-03 | Democrat | 14 | |||||||||||||
20663 | 20663 | John Linthicum L000340 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20689 | 20689 | Samuel Major M000074 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | -1 | |||||||||||||
20713 | 20713 | William Mobley M000835 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20719 | 20719 | Charles Mooney M000887 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
20730 | 20730 | John Moore M000905 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20765 | 20765 | John Norton N000152 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20767 | 20767 | Ruth Owen O000154 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20771 | 20771 | LaFayette Patterson P000125 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20797 | 20797 | Percy Quin Q000014 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20824 | 20824 | Samuel Rutherford R000549 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20889 | 20889 | William Stevenson S000895 | rep | SC | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20890 | 20890 | Percy Stewart S000919 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20931 | 20931 | William Tierney T000267 | rep | CT | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20961 | 20961 | Henry Tucker T000399 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21013 | 21013 | Guinn Williams W000501 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 13 | |||||||||||||
21021 | 21021 | Effiegene Wingo W000634 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21038 | 21038 | William Wright W000773 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21060 | 21060 | Thomas Yon Y000021 | rep | FL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21065 | 21065 | Walter Walker W000069 | sen | CO | 1932-09-26 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
21071 | 21071 | Charles Abernethy A000015 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21078 | 21078 | Miles Allgood A000156 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21088 | 21088 | Edward Almon A000162 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21094 | 21094 | Oscar Auf Der Heide A000338 | rep | NJ | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21103 | 21103 | William Ayres A000354 | rep | KS | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21119 | 21119 | Hugo Black B000499 | sen | AL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21125 | 21125 | Loring Black B000505 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21140 | 21140 | Charles Brand B000767 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21148 | 21148 | Clay Briggs B000826 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21167 | 21167 | Gordon Browning B000959 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21176 | 21176 | Robert Bulkley B001045 | sen | OH | 1930-01-01 | 1933-03-03 | 3 | Democrat | |||||||||||||
21183 | 21183 | Thomas Busby B001163 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21188 | 21188 | Patrick Carley C000149 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21218 | 21218 | Edward Crump C000955 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21232 | 21232 | Clement Dickinson D000316 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21234 | 21234 | William Dieterich D000339 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | -1 | |||||||||||||
21239 | 21239 | John Douglass D000459 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21250 | 21250 | Lawrence Ellzey E000152 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21262 | 21262 | Duncan Fletcher F000200 | sen | FL | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21295 | 21295 | John Garner G000074 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 15 | |||||||||||||
21299 | 21299 | David Glover G000243 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21313 | 21313 | William Hastings H000333 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21322 | 21322 | Lynn Hornor H000792 | rep | WV | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21328 | 21328 | Edgar Howard H000836 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21346 | 21346 | Lamar Jeffers J000068 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21363 | 21363 | Bolivar Kemp K000085 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21377 | 21377 | George Lindsay L000325 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21382 | 21382 | Augustine Lonergan L000409 | rep | CT | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21388 | 21388 | Ralph Lozier L000489 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21392 | 21392 | James Major M000073 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 21 | |||||||||||||
21395 | 21395 | Charles Martin M000173 | rep | OR | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21407 | 21407 | James McClintic M000338 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21419 | 21419 | George McGill M000447 | sen | KS | 1930-01-01 | 1933-03-03 | 3 | Democrat | |||||||||||||
21429 | 21429 | Thomas McKeown M000511 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21436 | 21436 | Jacob Milligan M000766 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21442 | 21442 | John Morehead M000939 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21457 | 21457 | Frank Oliver O000072 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 23 | |||||||||||||
21462 | 21462 | Homer Parker P000056 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21497 | 21497 | Edward Pou P000474 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21503 | 21503 | Anning Prall P000495 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21509 | 21509 | Heartsill Ragon R000009 | rep | AR | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21524 | 21524 | Henry Rainey R000014 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 20 | |||||||||||||
21539 | 21539 | Ashton Shallenberger S000280 | rep | NE | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21576 | 21576 | Fletcher Swank S001089 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21598 | 21598 | Charles West W000301 | rep | OH | 1931-12-07 | 1933-03-03 | Democrat | 17 | |||||||||||||
21619 | 21619 | William Arnold A000300 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 23 | |||||||||||||
21650 | 21650 | Thomas Blanton B000549 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 17 | |||||||||||||
21658 | 21658 | William Brunner B000981 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21681 | 21681 | Joseph Byrns B001217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 6 |
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);