legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
492 rows where "end" is on date 1939-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22469 | 22469 | Alva Adams A000028 | sen | CO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22020 | 22020 | Walter Albaugh A000072 | rep | OH | 1937-01-05 | 1939-01-03 | Republican | 4 | |||||||||||||
22021 | 22021 | Arthur Aleshire A000088 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
25112 | 25112 | Asa Allen A000114 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
26694 | 26694 | Leo Allen A000138 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 13 | |||||||||||||
22472 | 22472 | Robert Allen A000145 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22022 | 22022 | William Allen A000151 | rep | DE | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22025 | 22025 | Thomas Amlie A000176 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 1 | |||||||||||||
22474 | 22474 | Charles Anderson A000184 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
30139 | 30139 | Leslie Arends A000216 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
26167 | 26167 | August Andresen A000239 | rep | MN | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
24255 | 24255 | Walter Andrews A000250 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 40 | |||||||||||||
22849 | 22849 | Laurence Arnold A000290 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
22484 | 22484 | William Ashbrook A000306 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22026 | 22026 | Richard Atkinson A000332 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22034 | 22034 | Robert Bacon B000019 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
22498 | 22498 | William Bankhead B000113 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
26709 | 26709 | Graham Barden B000139 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
25875 | 25875 | Alben Barkley B000145 | sen | KY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22463 | 22463 | Alexander Barry B000187 | sen | OR | 1938-01-01 | 1939-01-03 | 3 | Republican | |||||||||||||
23771 | 23771 | William Barry B000191 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22500 | 22500 | Bruce Barton B000211 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 17 | |||||||||||||
24732 | 24732 | George Bates B000232 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
25130 | 25130 | Joseph Bates B000237 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22864 | 22864 | Harry Beam B000274 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22869 | 22869 | Alfred Beiter B000320 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 41 | |||||||||||||
24266 | 24266 | Charles Bell B000332 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22035 | 22035 | John Bernard B000411 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 8 | |||||||||||||
22036 | 22036 | George Berry B000417 | sen | TN | 1937-05-06 | 1939-01-03 | 2 | Democrat | appointment | ||||||||||||
22039 | 22039 | Frederick Biermann B000449 | rep | IA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22040 | 22040 | Herbert Bigelow B000454 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22042 | 22042 | Charles Binderup B000466 | rep | NE | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
24752 | 24752 | Schuyler Bland B000545 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
24766 | 24766 | Sol Bloom B000565 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 19 | |||||||||||||
22877 | 22877 | John Boehne B000588 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
22046 | 22046 | Gerald Boileau B000598 | rep | WI | 1937-01-05 | 1939-01-03 | Progressive | 7 | |||||||||||||
22883 | 22883 | Patrick Boland B000601 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22507 | 22507 | Homer Bone B000614 | sen | WA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
23777 | 23777 | Lyle Boren B000640 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22053 | 22053 | Lewis Boyer B000724 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
27111 | 27111 | Frank Boykin B000725 | rep | AL | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
22061 | 22061 | John Boylan B000726 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
23782 | 23782 | Michael Bradley B000743 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
24282 | 24282 | Ralph Brewster B000816 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
27127 | 27127 | Overton Brooks B000884 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
21161 | 21161 | Fred Brown B000916 | sen | NH | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
26750 | 26750 | Paul Brown B000940 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22074 | 22074 | James Buchanan B001006 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22891 | 22891 | Frank Buck B001017 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
22895 | 22895 | Richard Buckler B001023 | rep | MN | 1937-01-05 | 1939-01-03 | Farmer-Labor | 9 | |||||||||||||
27664 | 27664 | Charles Buckley B001024 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 23 | |||||||||||||
21177 | 21177 | Robert Bulkley B001045 | sen | OH | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24782 | 24782 | Alfred Bulwinkle B001056 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24236 | 24236 | Thomas Burch B001069 | rep | VA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
26190 | 26190 | Usher Burdick B001079 | rep | ND | 1937-01-05 | 1939-01-03 | Republican | 0 | |||||||||||||
25171 | 25171 | William Byrne B001214 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 28 | |||||||||||||
22513 | 22513 | Millard Caldwell C000038 | rep | FL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
27686 | 27686 | Clarence Cannon C000117 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22088 | 22088 | Raymond Cannon C000124 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22516 | 22516 | Hattie Caraway C000138 | sen | AR | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
27701 | 27701 | Frank Carlson C000154 | rep | KS | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
23368 | 23368 | Albert Carter C000195 | rep | CA | 1937-01-05 | 1939-01-03 | Republican | 6 | |||||||||||||
22907 | 22907 | Wilburn Cartwright C000207 | rep | OK | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
26214 | 26214 | Francis Case C000221 | rep | SD | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22911 | 22911 | Joseph Casey C000225 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
29678 | 29678 | Emanuel Celler C000264 | rep | NY | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
22089 | 22089 | Edwin Champion C000287 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22519 | 22519 | Walter Chandler C000296 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
24796 | 24796 | Virgil Chapman C000317 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
24805 | 24805 | Ralph Church C000390 | rep | IL | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
22091 | 22091 | William Citron C000397 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 0 | |||||||||||||
22522 | 22522 | David Clark C000428 | rep | ID | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24298 | 24298 | Jerome Clark C000439 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22524 | 22524 | Joel Clark C000440 | sen | MO | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24304 | 24304 | Charles Clason C000473 | rep | MA | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22914 | 22914 | Harold Claypool C000489 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 11 | |||||||||||||
22917 | 22917 | Ernest Cluett C000535 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 29 | |||||||||||||
23809 | 23809 | John Cochran C000565 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 13 | |||||||||||||
22921 | 22921 | Harry Coffee C000582 | rep | NE | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23814 | 23814 | John Coffee C000584 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22094 | 22094 | Charles Colden C000605 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 17 | |||||||||||||
22928 | 22928 | William Cole C000616 | rep | MD | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
26239 | 26239 | William Cole C000617 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 37 | |||||||||||||
22938 | 22938 | Ross Collins C000642 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
29698 | 29698 | William Colmer C000645 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
22941 | 22941 | Lawrence Connery C000693 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
22102 | 22102 | William Connery C000694 | rep | MA | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
28375 | 28375 | Harold Cooley C000736 | rep | NC | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
26254 | 26254 | Jere Cooper C000755 | rep | TN | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
21723 | 21723 | Royal Copeland C000769 | sen | NY | 1935-01-03 | 1939-01-03 | 1 | Democrat | |||||||||||||
23376 | 23376 | John Costello C000795 | rep | CA | 1937-01-05 | 1939-01-03 | Democrat | 15 | |||||||||||||
25195 | 25195 | Edward Cox C000831 | rep | GA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22531 | 22531 | William Cravens C000886 | rep | AR | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
25204 | 25204 | Fred Crawford C000889 | rep | MI | 1937-01-05 | 1939-01-03 | Republican | 8 | |||||||||||||
23381 | 23381 | Edward Creal C000898 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22105 | 22105 | Charles Crosby C000928 | rep | PA | 1937-01-05 | 1939-01-03 | Democrat | 29 | |||||||||||||
25649 | 25649 | Robert Crosser C000932 | rep | OH | 1937-01-05 | 1939-01-03 | Democrat | 21 | |||||||||||||
22536 | 22536 | Eugene Crowe C000940 | rep | IN | 1937-01-05 | 1939-01-03 | Democrat | 9 | |||||||||||||
22954 | 22954 | Frank Crowther C000948 | rep | NY | 1937-01-05 | 1939-01-03 | Republican | 30 | |||||||||||||
23390 | 23390 | Francis Culkin C000968 | rep | NY | 1937-01-05 | 1939-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);