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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21071 | 21071 | Charles Abernethy A000015 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
20079 | 20079 | Ernest Ackerman A000021 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
20083 | 20083 | Charles Adkins A000057 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 19 | |||||||||||||
20088 | 20088 | Richard Aldrich A000084 | rep | RI | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20092 | 20092 | John Allen A000131 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
22023 | 22023 | Thomas Amlie A000176 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
26165 | 26165 | August Andresen A000239 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21612 | 21612 | Abram Andrew A000240 | rep | MA | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
24252 | 24252 | Walter Andrews A000250 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 40 | |||||||||||||
20097 | 20097 | Samuel Arentz A000277 | rep | NV | 1931-12-07 | 1933-03-03 | Republican | 0 | |||||||||||||
21619 | 21619 | William Arnold A000300 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 23 | |||||||||||||
20107 | 20107 | James Aswell A000321 | rep | LA | 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 | |||||||||||||
21637 | 21637 | Isaac Bacharach B000009 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20111 | 20111 | Carl Bachmann B000012 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
22031 | 22031 | Robert Bacon B000019 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20112 | 20112 | Howard Baldrige B000082 | rep | NE | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
22495 | 22495 | William Bankhead B000113 | rep | AL | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
20119 | 20119 | Henry Barbour B000126 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
25874 | 25874 | Alben Barkley B000145 | sen | KY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
20120 | 20120 | William Barton B000217 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 16 | |||||||||||||
22861 | 22861 | Harry Beam B000274 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21110 | 21110 | James Beck B000290 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
21117 | 21117 | Carroll Beedy B000307 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20125 | 20125 | Edward Beers B000312 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 18 | |||||||||||||
20126 | 20126 | Joseph Biddle B000442 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 18 | |||||||||||||
19213 | 19213 | Hiram Bingham B000470 | sen | CT | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
19221 | 19221 | John Blaine B000520 | sen | WI | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
24749 | 24749 | Schuyler Bland B000545 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
21650 | 21650 | Thomas Blanton B000549 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 17 | |||||||||||||
24763 | 24763 | Sol Bloom B000565 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 19 | |||||||||||||
22874 | 22874 | John Boehne B000588 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20129 | 20129 | Frank Bohn B000596 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
22043 | 22043 | Gerald Boileau B000598 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | 8 | |||||||||||||
22880 | 22880 | Patrick Boland B000601 | rep | PA | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
22503 | 22503 | Chester Bolton B000606 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 22 | |||||||||||||
21131 | 21131 | Frank Bowman B000704 | rep | WV | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
22058 | 22058 | John Boylan B000726 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 15 | |||||||||||||
20134 | 20134 | Charles Brand B000766 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
21159 | 21159 | Frederick Britten B000847 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
19236 | 19236 | Smith Brookhart B000873 | sen | IA | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19238 | 19238 | Edwin Broussard B000895 | sen | LA | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
21167 | 21167 | Gordon Browning B000959 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
21172 | 21172 | George Brumm B000978 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 13 | |||||||||||||
21658 | 21658 | William Brunner B000981 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
22071 | 22071 | James Buchanan B001006 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
21663 | 21663 | John Buckbee B001020 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 12 | |||||||||||||
21176 | 21176 | Robert Bulkley B001045 | sen | OH | 1930-01-01 | 1933-03-03 | 3 | Democrat | |||||||||||||
24779 | 24779 | Alfred Bulwinkle B001056 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
24233 | 24233 | Thomas Burch B001069 | rep | VA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20143 | 20143 | Clark Burdick B001075 | rep | RI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20149 | 20149 | Olger Burtness B001146 | rep | ND | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
21183 | 21183 | Thomas Busby B001163 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
20152 | 20152 | Robert Butler B001187 | rep | OR | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21681 | 21681 | Joseph Byrns B001217 | rep | TN | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
20156 | 20156 | John Cable C000007 | rep | OH | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
20158 | 20158 | Ed Campbell C000081 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 11 | |||||||||||||
20166 | 20166 | Guy Campbell C000084 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 36 | |||||||||||||
20171 | 20171 | Harry Canfield C000114 | rep | IN | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
27683 | 27683 | Clarence Cannon C000117 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 9 | |||||||||||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
21684 | 21684 | Cap Carden C000140 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 4 | |||||||||||||
21188 | 21188 | Patrick Carley C000149 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
23365 | 23365 | Albert Carter C000195 | rep | CA | 1931-12-07 | 1933-03-03 | Republican | 6 | |||||||||||||
21192 | 21192 | Vincent Carter C000203 | rep | WY | 1931-12-07 | 1933-03-03 | Republican | 0 | |||||||||||||
22904 | 22904 | Wilburn Cartwright C000207 | rep | OK | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21691 | 21691 | Glover Cary C000214 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
21694 | 21694 | Bryant Castellow C000240 | rep | GA | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21697 | 21697 | Peter Cavicchia C000262 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 9 | |||||||||||||
29675 | 29675 | Emanuel Celler C000264 | rep | NY | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
24793 | 24793 | Virgil Chapman C000317 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
20174 | 20174 | James Chase C000328 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 23 | |||||||||||||
26800 | 26800 | Dennis Chavez C000338 | rep | NM | 1931-12-07 | 1933-03-03 | Democrat | 1 | |||||||||||||
20181 | 20181 | Carl Chindblom C000361 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
20184 | 20184 | Burnett Chiperfield C000364 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 15 | |||||||||||||
20186 | 20186 | Victor Christgau C000378 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20193 | 20193 | Charles Christopherson C000384 | rep | SD | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20199 | 20199 | Frank Clague C000401 | rep | MN | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20203 | 20203 | Robert Clancy C000412 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
24295 | 24295 | Jerome Clark C000439 | rep | NC | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
21203 | 21203 | John Clarke C000465 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 34 | |||||||||||||
23806 | 23806 | John Cochran C000565 | rep | MO | 1931-12-07 | 1933-03-03 | Democrat | 11 | |||||||||||||
21208 | 21208 | Thomas Cochran C000566 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 28 | |||||||||||||
20209 | 20209 | Cyrenus Cole C000608 | rep | IA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
22925 | 22925 | William Cole C000616 | rep | MD | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
20221 | 20221 | James Collier C000630 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 8 | |||||||||||||
22936 | 22936 | Ross Collins C000642 | rep | MS | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
20227 | 20227 | Don Colton C000652 | rep | UT | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
21707 | 21707 | Francis Condon C000673 | rep | RI | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
22099 | 22099 | William Connery C000694 | rep | MA | 1931-12-07 | 1933-03-03 | Democrat | 7 | |||||||||||||
21216 | 21216 | James Connolly C000698 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
20229 | 20229 | Edmund Cooke C000730 | rep | NY | 1931-12-07 | 1933-03-03 | Republican | 41 | |||||||||||||
20249 | 20249 | Henry Cooper C000752 | rep | WI | 1931-12-07 | 1933-03-03 | Republican | -1 |
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);