legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
482 rows where "end" is on date 1951-01-03 sorted by party descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23838 | 23838 | Forrest Donnell D000414 | sen | MO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
23854 | 23854 | John Gurney G000532 | sen | SD | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
24738 | 24738 | George Bates B000232 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
24810 | 24810 | Ralph Church C000390 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
24829 | 24829 | Albert Engel E000178 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
24864 | 24864 | John Jennings J000096 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24874 | 24874 | Frank Keefe K000041 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
24879 | 24879 | Jay Le Fevre L000161 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 30 | |||||||||||||
24888 | 24888 | William Lemke L000238 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24899 | 24899 | Franklin Lichtenwalter L000301 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
24902 | 24902 | John Lodge L000395 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
24910 | 24910 | William Macy M000037 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
24925 | 24925 | Rolla McMillen M000574 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
24932 | 24932 | Herbert Meyer M000680 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
24947 | 24947 | Earl Michener M000693 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24989 | 24989 | William Pfeiffer P000286 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 42 | |||||||||||||
24991 | 24991 | Dayton Phillips P000306 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25000 | 25000 | Charles Plumley P000395 | rep | VT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25010 | 25010 | Robert Rich R000209 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25026 | 25026 | Frederick Smith S000536 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25047 | 25047 | John Thomas T000175 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25058 | 25058 | James Wadsworth W000012 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 41 | |||||||||||||
25073 | 25073 | Richard Welch W000265 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25125 | 25125 | John Anderson A000196 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25144 | 25144 | William Blackney B000515 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25153 | 25153 | Walter Brehm B000794 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25183 | 25183 | Albert Cole C000606 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25210 | 25210 | Fred Crawford C000889 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25247 | 25247 | Charles Eaton E000023 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25254 | 25254 | Charles Elston E000160 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
25297 | 25297 | Edwin Hall H000050 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 37 | |||||||||||||
25304 | 25304 | Leonard Hall H000060 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25325 | 25325 | Christian Herter H000548 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25333 | 25333 | Edward Jenison J000080 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 23 | |||||||||||||
25388 | 25388 | Eugene Millikin M000771 | sen | CO | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25409 | 25409 | Reid Murray M001112 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25488 | 25488 | Hardie Scott S000172 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25499 | 25499 | Karl Stefan S000845 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25509 | 25509 | Lowell Stockman S000936 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25518 | 25518 | Robert Taft T000009 | sen | OH | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25524 | 25524 | Charles Tobey T000289 | sen | NH | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
25529 | 25529 | Harry Towe T000320 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25540 | 25540 | Thomas Werdel W000298 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25567 | 25567 | Roy Woodruff W000718 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25573 | 25573 | Charles Potter P000460 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25582 | 25582 | Homer Angell A000257 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25588 | 25588 | Frank Barrett B000176 | rep | WY | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25598 | 25598 | Cecil Bishop B000486 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25603 | 25603 | Ernest Bramblett B000762 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 11 | |||||||||||||
25660 | 25660 | Wesley D’Ewart D000281 | rep | MT | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25667 | 25667 | Joseph Farrington F000034 | rep | HI | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25673 | 25673 | James Golden G000258 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25679 | 25679 | Angier Goodwin G000297 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
25693 | 25693 | Harold Hagen H000014 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25721 | 25721 | Merlin Hull H000943 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
25731 | 25731 | Edgar Jonas J000207 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
25780 | 25780 | C. Poulson P000475 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25805 | 25805 | Paul Shafer S000277 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25830 | 25830 | Alvin Weichel W000252 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
25925 | 25925 | James Dolliver D000403 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25937 | 25937 | George Dondero D000411 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
25947 | 25947 | Mathew Ellsworth E000146 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
25972 | 25972 | Ralph Gamble G000031 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
25989 | 25989 | Thomas Hand H000154 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25999 | 25999 | John Hinshaw H000640 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
26003 | 26003 | Richard Hoffman H000689 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
26018 | 26018 | Clifford Hope H000768 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26025 | 26025 | Justin Johnson J000157 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26044 | 26044 | Harold Lovre L000468 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26053 | 26053 | Thomas Martin M000199 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26073 | 26073 | Charles Nelson N000031 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26081 | 26081 | John Phillips P000309 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
26100 | 26100 | Chauncey Reed R000111 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
26124 | 26124 | Dewey Short S000377 | rep | MO | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
26145 | 26145 | Jesse Wolcott W000668 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26157 | 26157 | John Allen A000133 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26173 | 26173 | August Andresen A000239 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26194 | 26194 | Usher Burdick B001079 | rep | ND | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
26204 | 26204 | Homer Capehart C000128 | sen | IN | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
26220 | 26220 | Francis Case C000221 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26233 | 26233 | Cliff Clevenger C000515 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26245 | 26245 | William Cole C000617 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 39 | |||||||||||||
26266 | 26266 | Frederic Coudert C000804 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26278 | 26278 | Paul Cunningham C000993 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26321 | 26321 | Myron George G000129 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26347 | 26347 | Ralph Gwinn G000541 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 27 | |||||||||||||
26355 | 26355 | Robert Hale H000036 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26360 | 26360 | Cecil Harden H000182 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
26385 | 26385 | John Heselton H000549 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26394 | 26394 | William Hill H000613 | rep | CO | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26406 | 26406 | Otis Holmes H000740 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26414 | 26414 | Benjamin James J000045 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
26431 | 26431 | Thomas Jenkins J000088 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 10 |
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);