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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21606 | 21606 | Jackson Adair A000025 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
26693 | 26693 | Leo Allen A000138 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 13 | |||||||||||||
22024 | 22024 | Thomas Amlie A000176 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 1 | |||||||||||||
30138 | 30138 | Leslie Arends A000216 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 17 | |||||||||||||
26166 | 26166 | August Andresen A000239 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
21614 | 21614 | Abram Andrew A000240 | rep | MA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
24254 | 24254 | Walter Andrews A000250 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 40 | |||||||||||||
21621 | 21621 | William Arnold A000300 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
22483 | 22483 | William Ashbrook A000306 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
21626 | 21626 | Henry Ashurst A000319 | sen | AZ | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22853 | 22853 | Warren Austin A000342 | sen | VT | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
21628 | 21628 | Roy Ayers A000352 | rep | MT | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
21639 | 21639 | Isaac Bacharach B000009 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 2 | |||||||||||||
22033 | 22033 | Robert Bacon B000019 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
22497 | 22497 | William Bankhead B000113 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
26708 | 26708 | Graham Barden B000139 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23770 | 23770 | William Barry B000191 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22863 | 22863 | Harry Beam B000274 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22868 | 22868 | Alfred Beiter B000320 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 41 | |||||||||||||
24265 | 24265 | Charles Bell B000332 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21642 | 21642 | William Berlin B000409 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
22038 | 22038 | Frederick Biermann B000449 | rep | IA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22872 | 22872 | Theodore Bilbo B000460 | sen | MS | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22041 | 22041 | Charles Binderup B000466 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
25138 | 25138 | William Blackney B000515 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
24751 | 24751 | Schuyler Bland B000545 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
21652 | 21652 | Thomas Blanton B000549 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
24765 | 24765 | Sol Bloom B000565 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 19 | |||||||||||||
22876 | 22876 | John Boehne B000588 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
22045 | 22045 | Gerald Boileau B000598 | rep | WI | 1935-01-03 | 1937-01-03 | Progressive | 7 | |||||||||||||
22882 | 22882 | Patrick Boland B000601 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
22505 | 22505 | Chester Bolton B000606 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 22 | |||||||||||||
27110 | 27110 | Frank Boykin B000725 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22060 | 22060 | John Boylan B000726 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
21654 | 21654 | Martin Brennan B000799 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
21656 | 21656 | Joshua Brooks B000882 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 30 | |||||||||||||
26749 | 26749 | Paul Brown B000940 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 | |||||||||||||
21660 | 21660 | William Brunner B000981 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22073 | 22073 | James Buchanan B001006 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22890 | 22890 | Frank Buck B001017 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21665 | 21665 | John Buckbee B001020 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 12 | |||||||||||||
22894 | 22894 | Richard Buckler B001023 | rep | MN | 1935-01-03 | 1937-01-03 | Farmer-Labor | 9 | |||||||||||||
27663 | 27663 | Charles Buckley B001024 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 23 | |||||||||||||
24781 | 24781 | Alfred Bulwinkle B001056 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
24235 | 24235 | Thomas Burch B001069 | rep | VA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
26189 | 26189 | Usher Burdick B001079 | rep | ND | 1935-01-03 | 1937-01-03 | Republican | 0 | |||||||||||||
21667 | 21667 | Edward Burke B001089 | sen | NE | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21669 | 21669 | George Burnham B001124 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 20 | |||||||||||||
26776 | 26776 | Harry Byrd B001208 | sen | VA | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
21683 | 21683 | Joseph Byrns B001217 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22512 | 22512 | Millard Caldwell C000038 | rep | FL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
27685 | 27685 | Clarence Cannon C000117 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
21686 | 21686 | Cap Carden C000140 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
27700 | 27700 | Frank Carlson C000154 | rep | KS | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
21688 | 21688 | Archibald Carmichael C000159 | rep | AL | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21690 | 21690 | William Carpenter C000173 | rep | KS | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23367 | 23367 | Albert Carter C000195 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 6 | |||||||||||||
22906 | 22906 | Wilburn Cartwright C000207 | rep | OK | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21693 | 21693 | Glover Cary C000214 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22910 | 22910 | Joseph Casey C000225 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21696 | 21696 | Bryant Castellow C000240 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
21699 | 21699 | Peter Cavicchia C000262 | rep | NJ | 1935-01-03 | 1937-01-03 | Republican | 11 | |||||||||||||
29677 | 29677 | Emanuel Celler C000264 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
22518 | 22518 | Walter Chandler C000296 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
24795 | 24795 | Virgil Chapman C000317 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21701 | 21701 | Theodore Christianson C000381 | rep | MN | 1935-01-03 | 1937-01-03 | Republican | 5 | |||||||||||||
24804 | 24804 | Ralph Church C000390 | rep | IL | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
22090 | 22090 | William Citron C000397 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 0 | |||||||||||||
21703 | 21703 | James Claiborne C000402 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
22521 | 22521 | David Clark C000428 | rep | ID | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
24297 | 24297 | Jerome Clark C000439 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23808 | 23808 | John Cochran C000565 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 13 | |||||||||||||
22920 | 22920 | Harry Coffee C000582 | rep | NE | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22093 | 22093 | Charles Colden C000605 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 17 | |||||||||||||
22927 | 22927 | William Cole C000616 | rep | MD | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
26238 | 26238 | William Cole C000617 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 37 | |||||||||||||
21705 | 21705 | Samuel Collins C000643 | rep | CA | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
29697 | 29697 | William Colmer C000645 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21709 | 21709 | Francis Condon C000673 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
24320 | 24320 | Thomas Connally C000684 | sen | TX | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
22101 | 22101 | William Connery C000694 | rep | MA | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
28374 | 28374 | Harold Cooley C000736 | rep | NC | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
26253 | 26253 | Jere Cooper C000755 | rep | TN | 1935-01-03 | 1937-01-03 | Democrat | 8 | |||||||||||||
21720 | 21720 | John Cooper C000757 | rep | OH | 1935-01-03 | 1937-01-03 | Republican | 19 | |||||||||||||
21723 | 21723 | Royal Copeland C000769 | sen | NY | 1935-01-03 | 1939-01-03 | 1 | Democrat | |||||||||||||
21730 | 21730 | Parker Corning C000785 | rep | NY | 1935-01-03 | 1937-01-03 | Democrat | 28 | |||||||||||||
23375 | 23375 | John Costello C000795 | rep | CA | 1935-01-03 | 1937-01-03 | Democrat | 15 | |||||||||||||
25194 | 25194 | Edward Cox C000831 | rep | GA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22530 | 22530 | William Cravens C000886 | rep | AR | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
25203 | 25203 | Fred Crawford C000889 | rep | MI | 1935-01-03 | 1937-01-03 | Republican | 8 | |||||||||||||
23380 | 23380 | Edward Creal C000898 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22104 | 22104 | Charles Crosby C000928 | rep | PA | 1935-01-03 | 1937-01-03 | Democrat | 29 | |||||||||||||
21734 | 21734 | Oliver Cross C000931 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 11 | |||||||||||||
25648 | 25648 | Robert Crosser C000932 | rep | OH | 1935-01-03 | 1937-01-03 | Democrat | 21 | |||||||||||||
22535 | 22535 | Eugene Crowe C000940 | rep | IN | 1935-01-03 | 1937-01-03 | Democrat | 9 | |||||||||||||
22953 | 22953 | Frank Crowther C000948 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 30 | |||||||||||||
23389 | 23389 | Francis Culkin C000968 | rep | NY | 1935-01-03 | 1937-01-03 | Republican | 32 |
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);