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 district
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23824 | 23824 | Ralph Daughton D000067 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23878 | 23878 | Robert Henry H000515 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
23973 | 23973 | Paul Maloney M000091 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24010 | 24010 | James O’Connor O000029 | rep | MT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24069 | 24069 | James Robinson R000341 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24080 | 24080 | William Rowan R000473 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24308 | 24308 | Charles Clason C000473 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24633 | 24633 | Emory Price P000524 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24673 | 24673 | Max Schwabe S000156 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24862 | 24862 | John Jennings J000096 | rep | TN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24945 | 24945 | Earl Michener M000693 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25099 | 25099 | Chase Woodhouse W000714 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25106 | 25106 | Earle Clements C000506 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25160 | 25160 | Howard Buffett B001039 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25185 | 25185 | Jesse Combs C000655 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25199 | 25199 | Edward Cox C000831 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25302 | 25302 | Leonard Hall H000060 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25359 | 25359 | John Kerr K000138 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25502 | 25502 | William Stigler S000923 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25507 | 25507 | Lowell Stockman S000936 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25658 | 25658 | Wesley D’Ewart D000281 | rep | MT | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25978 | 25978 | William Granahan G000369 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25987 | 25987 | Thomas Hand H000154 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26218 | 26218 | Francis Case C000221 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26392 | 26392 | William Hill H000613 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26548 | 26548 | Joseph O’Hara O000056 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26580 | 26580 | Errett Scrivner S000194 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26625 | 26625 | Henry Talle T000028 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26839 | 26839 | Clair Engle E000181 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26874 | 26874 | William Hess H000550 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
27479 | 27479 | John Riley R000260 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
27820 | 27820 | George Grant G000381 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
28832 | 28832 | John Fogarty F000233 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
28865 | 28865 | Charles Halleck H000081 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
29043 | 29043 | Margaret Smith S000590 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
31184 | 31184 | Wilbur Mills M000778 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
32247 | 32247 | Jennings Randolph R000046 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
33001 | 33001 | Henry Jackson J000013 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
35644 | 35644 | Jamie Whitten W000428 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23786 | 23786 | Michael Bradley B000743 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23844 | 23844 | William Gallagher G000019 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23845 | 23845 | Edward Gardner G000051 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23846 | 23846 | James Geelan G000117 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23872 | 23872 | Butler Hare H000200 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23929 | 23929 | Edward Kelly K000071 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24016 | 24016 | Emmet O’Neal O000089 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24089 | 24089 | Dave Satterfield S000069 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24090 | 24090 | Charles Savage S000080 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24108 | 24108 | Paul Stewart S000918 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24206 | 24206 | Thomas Winter W000645 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24337 | 24337 | Thomas D’Alesandro D000007 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24352 | 24352 | James Domengeaux D000406 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24436 | 24436 | Robert Grant G000384 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24450 | 24450 | John Gwynne G000543 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24685 | 24685 | William Stevenson S000896 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24969 | 24969 | Stephen Pace P000002 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25095 | 25095 | William Whittington W000430 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25258 | 25258 | Frank Fellows F000066 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25497 | 25497 | Karl Stefan S000845 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25580 | 25580 | Homer Angell A000257 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25635 | 25635 | William Cole C000614 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25803 | 25803 | Paul Shafer S000277 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26023 | 26023 | Justin Johnson J000157 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26475 | 26475 | Henry Latham L000108 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26713 | 26713 | Graham Barden B000139 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27092 | 27092 | Cleveland Bailey B000035 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27279 | 27279 | Carey Kefauver K000044 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27609 | 27609 | James Auchincloss A000227 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27712 | 27712 | John Chenoweth C000346 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
27790 | 27790 | Julian Gary G000091 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28320 | 28320 | Lindley Beckworth B000296 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
28716 | 28716 | James Trimble T000373 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
29407 | 29407 | Philip Philbin P000303 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
29545 | 29545 | George Andrews A000206 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
31802 | 31802 | Robert Sikes S000406 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23775 | 23775 | William Barry B000191 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23781 | 23781 | Lyle Boren B000640 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23801 | 23801 | Arthur Cannon C000115 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
23889 | 23889 | Pehr Holmes H000741 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
23966 | 23966 | Clare Luce L000497 | rep | CT | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24048 | 24048 | David Powers P000488 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24095 | 24095 | John Sheridan S000342 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24106 | 24106 | Frank Starkey S000812 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24185 | 24185 | Thaddeus Wasielewski W000183 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24270 | 24270 | Charles Bell B000332 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24331 | 24331 | William Cravens C000887 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24367 | 24367 | Patrick Drewry D000496 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24377 | 24377 | Hubert Ellis E000135 | rep | WV | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24430 | 24430 | George Gillie G000207 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24506 | 24506 | Robert Jones J000249 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24593 | 24593 | Frank Mathews M000233 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24666 | 24666 | Robert Rockwell R000369 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24839 | 24839 | Martin Gorski G000332 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24851 | 24851 | Samuel Hobbs H000663 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25308 | 25308 | Franck Havenner H000356 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25611 | 25611 | Joseph Bryson B000999 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25627 | 25627 | Albert Camp C000070 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25945 | 25945 | Mathew Ellsworth E000146 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26404 | 26404 | Otis Holmes H000740 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26485 | 26485 | Karl Le Compte L000157 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 4 |
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);