legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
488 rows where "end" is on date 1947-01-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29525 | 29525 | Thomas Abernethy A000016 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23764 | 23764 | Sherman Adams A000046 | rep | NH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25116 | 25116 | Asa Allen A000114 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26698 | 26698 | Leo Allen A000138 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 13 | |||||||||||||
24250 | 24250 | James Almond A000163 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
27078 | 27078 | Herman Andersen A000179 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
25123 | 25123 | John Anderson A000196 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
29545 | 29545 | George Andrews A000206 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
30143 | 30143 | Leslie Arends A000216 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
27609 | 27609 | James Auchincloss A000227 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26171 | 26171 | August Andresen A000239 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
24259 | 24259 | Walter Andrews A000250 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 42 | |||||||||||||
25580 | 25580 | Homer Angell A000257 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24262 | 24262 | Samuel Arnold A000296 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
27092 | 27092 | Cleveland Bailey B000035 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23343 | 23343 | Josiah Bailey B000046 | sen | NC | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
23766 | 23766 | Harry Baldwin B000086 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23769 | 23769 | Joseph Baldwin B000093 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
24231 | 24231 | Raymond Baldwin B000095 | sen | CT | 1946-12-27 | 1947-01-03 | 1 | Republican | |||||||||||||
23348 | 23348 | John Bankhead B000111 | sen | AL | 1943-01-06 | 1947-01-03 | 2 | Democrat | |||||||||||||
26713 | 26713 | Graham Barden B000139 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25586 | 25586 | Frank Barrett B000176 | rep | WY | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
30820 | 30820 | William Barrett B000178 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23775 | 23775 | William Barry B000191 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28772 | 28772 | Edward Bartlett B000201 | rep | AK | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24736 | 24736 | George Bates B000232 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
25134 | 25134 | Joseph Bates B000237 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26727 | 26727 | James Beall B000271 | rep | MD | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24270 | 24270 | Charles Bell B000332 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25850 | 25850 | George Bender B000356 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
23776 | 23776 | Augustus Bennet B000367 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
24273 | 24273 | Marion Bennett B000379 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24740 | 24740 | Andrew Biemiller B000448 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
22873 | 22873 | Theodore Bilbo B000460 | sen | MS | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25596 | 25596 | Cecil Bishop B000486 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 25 | |||||||||||||
25142 | 25142 | William Blackney B000515 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24756 | 24756 | Schuyler Bland B000545 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24770 | 24770 | Sol Bloom B000565 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
28790 | 28790 | Frances Bolton B000607 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
28332 | 28332 | Herbert Bonner B000621 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23781 | 23781 | Lyle Boren B000640 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27115 | 27115 | Frank Boykin B000725 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24278 | 24278 | Frederick Bradley B000742 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
23786 | 23786 | Michael Bradley B000743 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25151 | 25151 | Walter Brehm B000794 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
24284 | 24284 | Ralph Brewster B000816 | sen | ME | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
27131 | 27131 | Overton Brooks B000884 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
28346 | 28346 | Clarence Brown B000909 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
26754 | 26754 | Paul Brown B000940 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
23789 | 23789 | David Brumbaugh B000976 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
25611 | 25611 | Joseph Bryson B000999 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25155 | 25155 | Frank Buchanan B001002 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
24288 | 24288 | Ellsworth Buck B001016 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
27668 | 27668 | Charles Buckley B001024 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 25 | |||||||||||||
25160 | 25160 | Howard Buffett B001039 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24786 | 24786 | Alfred Bulwinkle B001056 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
23792 | 23792 | Berkeley Bunker B001061 | rep | NV | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
23796 | 23796 | William Burgin B001084 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25621 | 25621 | Hugh Butler B001177 | sen | NE | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25168 | 25168 | John Butler B001179 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 44 | |||||||||||||
26777 | 26777 | Harry Byrd B001208 | sen | VA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25175 | 25175 | William Byrne B001214 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
29650 | 29650 | John Byrnes B001216 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
24242 | 24242 | Harry Cain C000021 | sen | WA | 1946-12-31 | 1947-01-03 | 1 | Republican | |||||||||||||
25627 | 25627 | Albert Camp C000070 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23797 | 23797 | Howard Campbell C000085 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 29 | |||||||||||||
26784 | 26784 | Gordon Canfield C000113 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
23801 | 23801 | Arthur Cannon C000115 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27690 | 27690 | Clarence Cannon C000117 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
27705 | 27705 | Frank Carlson C000154 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
26792 | 26792 | Albert Carnahan C000162 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
23802 | 23802 | Edward Carville C000211 | sen | NV | 1945-07-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
30223 | 30223 | Clifford Case C000220 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
26218 | 26218 | Francis Case C000221 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
29682 | 29682 | Emanuel Celler C000264 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
24800 | 24800 | Virgil Chapman C000317 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26803 | 26803 | Dennis Chavez C000338 | sen | NM | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
28361 | 28361 | Frank Chelf C000342 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27712 | 27712 | John Chenoweth C000346 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27145 | 27145 | Robert Chiperfield C000365 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
24808 | 24808 | Ralph Church C000390 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
24302 | 24302 | Jerome Clark C000439 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24308 | 24308 | Charles Clason C000473 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25106 | 25106 | Earle Clements C000506 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26231 | 26231 | Cliff Clevenger C000515 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
24310 | 24310 | Roy Clippinger C000529 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 24 | |||||||||||||
23813 | 23813 | John Cochran C000565 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
23818 | 23818 | John Coffee C000584 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25181 | 25181 | Albert Cole C000606 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
25635 | 25635 | William Cole C000614 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26243 | 26243 | William Cole C000617 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 39 | |||||||||||||
29702 | 29702 | William Colmer C000645 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25185 | 25185 | Jesse Combs C000655 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24321 | 24321 | Thomas Connally C000684 | sen | TX | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
28379 | 28379 | Harold Cooley C000736 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
26258 | 26258 | Jere Cooper C000755 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
29718 | 29718 | Robert Corbett C000772 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 30 | |||||||||||||
24326 | 24326 | William Courtney C000810 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 7 |
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);