legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1949-01-03 sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24857 | 24857 | Lester Hunt H000975 | sen | WY | 1949-01-03 | 1954-06-19 | 2 | Democrat | |||||||||||||
25588 | 25588 | Frank Barrett B000176 | rep | WY | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25314 | 25314 | Erland Hedrick H000442 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25346 | 25346 | John Kee K000039 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25431 | 25431 | Robert Ramsay R000025 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25888 | 25888 | Maurice Burnside B001131 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26071 | 26071 | Matthew Neely N000023 | sen | WV | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27093 | 27093 | Cleveland Bailey B000035 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
32298 | 32298 | Harley Staggers S000778 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
24741 | 24741 | Andrew Biemiller B000448 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
24874 | 24874 | Frank Keefe K000041 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25409 | 25409 | Reid Murray M001112 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
25721 | 25721 | Merlin Hull H000943 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
26615 | 26615 | Lawrence Smith S000585 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
27050 | 27050 | Gardner Withrow W000663 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
29652 | 29652 | John Byrnes B001216 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
29993 | 29993 | Alvin O’Konski O000058 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
30277 | 30277 | Glenn Davis D000102 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
33191 | 33191 | Clement Zablocki Z000001 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25391 | 25391 | Hugh Mitchell M000814 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26406 | 26406 | Otis Holmes H000740 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26907 | 26907 | Russell Mack M000021 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27902 | 27902 | Walter Horan H000786 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
28188 | 28188 | Thor Tollefson T000298 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
33003 | 33003 | Henry Jackson J000013 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25000 | 25000 | Charles Plumley P000395 | rep | VT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
24758 | 24758 | Schuyler Bland B000545 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25164 | 25164 | Clarence Burton B001148 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25262 | 25262 | Thomas Fugate F000399 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25814 | 25814 | Thomas Stanley S000797 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26565 | 26565 | Edward Robeson R000329 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27218 | 27218 | Burr Harrison H000264 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27792 | 27792 | Julian Gary G000091 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28666 | 28666 | Howard Smith S000554 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28878 | 28878 | Porter Hardy H000197 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
29512 | 29512 | Watkins Abbitt A000002 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25146 | 25146 | Reva Bosone B000649 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25289 | 25289 | Walter Granger G000379 | rep | UT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
24843 | 24843 | Ben Guill G000521 | rep | TX | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
25105 | 25105 | Francis Worley W000744 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
25187 | 25187 | Jesse Combs C000655 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25283 | 25283 | Ed Gossett G000338 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25423 | 25423 | Thomas Pickett P000327 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25750 | 25750 | Wingate Lucas L000496 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
25755 | 25755 | John Lyle L000525 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25788 | 25788 | Kenneth Regan R000140 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25838 | 25838 | Joseph Wilson W000604 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27292 | 27292 | Paul Kilday K000171 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
27452 | 27452 | Samuel Rayburn R000082 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28179 | 28179 | William Thornberry T000237 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28300 | 28300 | Lyndon Johnson J000160 | sen | TX | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28683 | 28683 | Albert Thomas T000156 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28695 | 28695 | Clark Thompson T000198 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
30347 | 30347 | Ovie Fisher F000152 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
31262 | 31262 | John Patman P000103 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
31454 | 31454 | Omar Burleson B001111 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 17 | |||||||||||||
31628 | 31628 | George Mahon M000065 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
31724 | 31724 | William Poage P000398 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
31848 | 31848 | Olin Teague T000110 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
33815 | 33815 | Lloyd Bentsen B000401 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
24864 | 24864 | John Jennings J000096 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
24991 | 24991 | Dayton Phillips P000306 | rep | TN | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
25818 | 25818 | James Sutton S001087 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26089 | 26089 | James Priest P000536 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26260 | 26260 | Jere Cooper C000755 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
27204 | 27204 | James Frazier F000353 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27281 | 27281 | Carey Kefauver K000044 | sen | TN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
27728 | 27728 | Clifford Davis D000094 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28430 | 28430 | Albert Gore G000320 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28590 | 28590 | Thomas Murray M001114 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
30922 | 30922 | Joseph Evins E000273 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26044 | 26044 | Harold Lovre L000468 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26220 | 26220 | Francis Case C000221 | rep | SD | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
28994 | 28994 | Karl Mundt M001078 | sen | SD | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
24844 | 24844 | James Hare H000202 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
24921 | 24921 | Burnet Maybank M000279 | sen | SC | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25020 | 25020 | Hugo Sims S000439 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25613 | 25613 | Joseph Bryson B000999 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26112 | 26112 | James Richards R000214 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
29447 | 29447 | Lucius Rivers R000280 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29936 | 29936 | John McMillan M000568 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28834 | 28834 | John Fogarty F000233 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27773 | 27773 | Antonio Fernós-Isern F000087 | rep | PR | 1949-01-03 | 1951-01-03 | Popular Democrat | 0 | |||||||||||||
24790 | 24790 | Anthony Cavalcante C000259 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 23 | |||||||||||||
24811 | 24811 | Robert Coffey C000586 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 26 | |||||||||||||
24816 | 24816 | Harry Davenport D000071 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 29 | |||||||||||||
24899 | 24899 | Franklin Lichtenwalter L000301 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
25010 | 25010 | Robert Rich R000209 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
25157 | 25157 | Frank Buchanan B001002 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 33 | |||||||||||||
25276 | 25276 | Wilson Gillette G000206 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
25370 | 25370 | James Lind L000318 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25411 | 25411 | Harry O’Neill O000095 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
25488 | 25488 | Hardie Scott S000172 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25687 | 25687 | Louis Graham G000360 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 25 | |||||||||||||
25979 | 25979 | William Granahan G000369 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26223 | 26223 | Earl Chudoff C000386 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 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);