legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1935-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21072 | 21072 | Charles Abernethy A000015 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21605 | 21605 | Jackson Adair A000025 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
21073 | 21073 | Wilbur Adams A000050 | rep | DE | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
26692 | 26692 | Leo Allen A000138 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
21079 | 21079 | Miles Allgood A000156 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21089 | 21089 | Edward Almon A000162 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21613 | 21613 | Abram Andrew A000240 | rep | MA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
24253 | 24253 | Walter Andrews A000250 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 40 | |||||||||||||
21090 | 21090 | Henry Arens A000276 | rep | MN | 1933-03-09 | 1935-01-03 | Farmer-Labor | 0 | |||||||||||||
21620 | 21620 | William Arnold A000300 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 23 | |||||||||||||
21625 | 21625 | Henry Ashurst A000319 | sen | AZ | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21095 | 21095 | Oscar Auf Der Heide A000338 | rep | NJ | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22852 | 22852 | Warren Austin A000342 | sen | VT | 1931-12-07 | 1935-01-03 | 1 | Republican | |||||||||||||
21627 | 21627 | Roy Ayers A000352 | rep | MT | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21104 | 21104 | William Ayres A000354 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21638 | 21638 | Isaac Bacharach B000009 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
22032 | 22032 | Robert Bacon B000019 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
21106 | 21106 | Joseph Bailey B000045 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21107 | 21107 | Charles Bakewell B000079 | rep | CT | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
22496 | 22496 | William Bankhead B000113 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
22862 | 22862 | Harry Beam B000274 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21111 | 21111 | James Beck B000290 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 2 | |||||||||||||
21118 | 21118 | Carroll Beedy B000307 | rep | ME | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
22867 | 22867 | Alfred Beiter B000320 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 41 | |||||||||||||
21641 | 21641 | William Berlin B000409 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
22037 | 22037 | Frederick Biermann B000449 | rep | IA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21126 | 21126 | Loring Black B000505 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21127 | 21127 | George Blanchard B000537 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
24750 | 24750 | Schuyler Bland B000545 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21651 | 21651 | Thomas Blanton B000549 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
24764 | 24764 | Sol Bloom B000565 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 19 | |||||||||||||
22875 | 22875 | John Boehne B000588 | rep | IN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22044 | 22044 | Gerald Boileau B000598 | rep | WI | 1933-03-09 | 1935-01-03 | Republican | 7 | |||||||||||||
22881 | 22881 | Patrick Boland B000601 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22504 | 22504 | Chester Bolton B000606 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 22 | |||||||||||||
21132 | 21132 | Frank Bowman B000704 | rep | WV | 1933-03-09 | 1935-01-03 | Republican | -1 | |||||||||||||
22059 | 22059 | John Boylan B000726 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
21141 | 21141 | Charles Brand B000767 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
21653 | 21653 | Martin Brennan B000799 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21149 | 21149 | Clay Briggs B000826 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21160 | 21160 | Frederick Britten B000847 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 9 | |||||||||||||
21655 | 21655 | Joshua Brooks B000882 | rep | PA | 1933-03-09 | 1935-01-03 | Democrat | 30 | |||||||||||||
21162 | 21162 | John Brown B000934 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
26748 | 26748 | Paul Brown B000940 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22011 | 22011 | Prentiss Brown B000941 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21168 | 21168 | Gordon Browning B000959 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21173 | 21173 | George Brumm B000978 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 13 | |||||||||||||
21659 | 21659 | William Brunner B000981 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22072 | 22072 | James Buchanan B001006 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
22889 | 22889 | Frank Buck B001017 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21664 | 21664 | John Buckbee B001020 | rep | IL | 1933-03-09 | 1935-01-03 | Republican | 12 | |||||||||||||
24780 | 24780 | Alfred Bulwinkle B001056 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
24234 | 24234 | Thomas Burch B001069 | rep | VA | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21666 | 21666 | Edward Burke B001089 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21178 | 21178 | John Burke B001094 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
21668 | 21668 | George Burnham B001124 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 20 | |||||||||||||
21184 | 21184 | Thomas Busby B001163 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
26775 | 26775 | Harry Byrd B001208 | sen | VA | 1933-03-09 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
21682 | 21682 | Joseph Byrns B001217 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21185 | 21185 | Claude Cady C000013 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22511 | 22511 | Millard Caldwell C000038 | rep | FL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
27684 | 27684 | Clarence Cannon C000117 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22086 | 22086 | Raymond Cannon C000124 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21685 | 21685 | Cap Carden C000140 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21189 | 21189 | Patrick Carley C000149 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21687 | 21687 | Archibald Carmichael C000159 | rep | AL | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21190 | 21190 | Terry Carpenter C000172 | rep | NE | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21689 | 21689 | William Carpenter C000173 | rep | KS | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23366 | 23366 | Albert Carter C000195 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 6 | |||||||||||||
21193 | 21193 | Vincent Carter C000203 | rep | WY | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
22905 | 22905 | Wilburn Cartwright C000207 | rep | OK | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21692 | 21692 | Glover Cary C000214 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21695 | 21695 | Bryant Castellow C000240 | rep | GA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21698 | 21698 | Peter Cavicchia C000262 | rep | NJ | 1933-03-09 | 1935-01-03 | Republican | 11 | |||||||||||||
29676 | 29676 | Emanuel Celler C000264 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 10 | |||||||||||||
24794 | 24794 | Virgil Chapman C000317 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21194 | 21194 | Ray Chase C000331 | rep | MN | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
26801 | 26801 | Dennis Chavez C000338 | rep | NM | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21700 | 21700 | Theodore Christianson C000381 | rep | MN | 1933-03-09 | 1935-01-03 | Republican | 0 | |||||||||||||
21198 | 21198 | Denver Church C000387 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21702 | 21702 | James Claiborne C000402 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
24296 | 24296 | Jerome Clark C000439 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21204 | 21204 | John Clarke C000465 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 34 | |||||||||||||
21205 | 21205 | Marian Clarke C000467 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 34 | |||||||||||||
23807 | 23807 | John Cochran C000565 | rep | MO | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21209 | 21209 | Thomas Cochran C000566 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 20 | |||||||||||||
21210 | 21210 | Thomas Coffin C000592 | rep | ID | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22092 | 22092 | Charles Colden C000605 | rep | CA | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22926 | 22926 | William Cole C000616 | rep | MD | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22937 | 22937 | Ross Collins C000642 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21704 | 21704 | Samuel Collins C000643 | rep | CA | 1933-03-09 | 1935-01-03 | Republican | 19 | |||||||||||||
29696 | 29696 | William Colmer C000645 | rep | MS | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21708 | 21708 | Francis Condon C000673 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
24319 | 24319 | Thomas Connally C000684 | sen | TX | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
22100 | 22100 | William Connery C000694 | rep | MA | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
21217 | 21217 | James Connolly C000698 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 5 | |||||||||||||
28373 | 28373 | Harold Cooley C000736 | rep | NC | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
26252 | 26252 | Jere Cooper C000755 | rep | TN | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21719 | 21719 | John Cooper C000757 | rep | OH | 1933-03-09 | 1935-01-03 | Republican | 19 | |||||||||||||
21722 | 21722 | Royal Copeland C000769 | sen | NY | 1929-04-15 | 1935-01-03 | 1 | Democrat |
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);