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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25475 | 25475 | Adolph Sabath S000001 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25482 | 25482 | Lansdale Sasscer S000067 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25504 | 25504 | William Stigler S000923 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25513 | 25513 | John Sullivan S001056 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25515 | 25515 | Boyd Tackett T000005 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25531 | 25531 | Thomas Underwood U000015 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25537 | 25537 | Philip Welch W000264 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25543 | 25543 | John Whitaker W000348 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25549 | 25549 | John Wood W000699 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25569 | 25569 | Edward deGraffenried D000198 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25591 | 25591 | Laurie Battle B000242 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25613 | 25613 | Joseph Bryson B000999 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25629 | 25629 | Albert Camp C000070 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25655 | 25655 | Robert Crosser C000932 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
25703 | 25703 | Edward Hart H000284 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
25706 | 25706 | Louis Heller H000460 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25710 | 25710 | Charles Howell H000858 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
25770 | 25770 | George O’Brien O000009 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 13 | |||||||||||||
25774 | 25774 | Harold Patten P000107 | rep | AZ | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25788 | 25788 | Kenneth Regan R000140 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 16 | |||||||||||||
25793 | 25793 | Dwight Rogers R000391 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
25814 | 25814 | Thomas Stanley S000797 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25818 | 25818 | James Sutton S001087 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25834 | 25834 | William Wheeler W000342 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25838 | 25838 | Joseph Wilson W000604 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25888 | 25888 | Maurice Burnside B001131 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25891 | 25891 | Frank Carlyle C000156 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25896 | 25896 | Richard Chatham C000336 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25907 | 25907 | Charles Deane D000175 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25919 | 25919 | John Dingell D000354 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
25956 | 25956 | Antonio Fernández F000085 | rep | NM | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
25979 | 25979 | William Granahan G000369 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26029 | 26029 | Woodrow Jones J000263 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
26040 | 26040 | Arthur Klein K000261 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 19 | |||||||||||||
26089 | 26089 | James Priest P000536 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26112 | 26112 | James Richards R000214 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26212 | 26212 | John Carroll C000189 | rep | CO | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26223 | 26223 | Earl Chudoff C000386 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
26260 | 26260 | Jere Cooper C000755 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
26316 | 26316 | Herman Eberharter E000029 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 32 | |||||||||||||
26329 | 26329 | Thomas Gordon G000316 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26340 | 26340 | Noble Gregory G000447 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26373 | 26373 | Lawrence Hays H000405 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
26459 | 26459 | Augustine Kelley K000058 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 27 | |||||||||||||
26470 | 26470 | Henderson Lanham L000077 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26565 | 26565 | Edward Robeson R000329 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26715 | 26715 | Graham Barden B000139 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26756 | 26756 | Paul Brown B000940 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
26793 | 26793 | Albert Carnahan C000162 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
26807 | 26807 | George Christopher C000383 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26816 | 26816 | Isidore Dollinger D000402 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 24 | |||||||||||||
26831 | 26831 | Carl Durham D000571 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26841 | 26841 | Clair Engle E000181 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26919 | 26919 | Toby Morris M000991 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26932 | 26932 | James Polk P000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26941 | 26941 | Prince Preston P000516 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27040 | 27040 | Roy Wier W000446 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27061 | 27061 | Hugh Addonizio A000054 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27093 | 27093 | Cleveland Bailey B000035 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27133 | 27133 | Overton Brooks B000884 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27171 | 27171 | James Davis D000109 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27204 | 27204 | James Frazier F000353 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27218 | 27218 | Burr Harrison H000264 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27292 | 27292 | Paul Kilday K000171 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
27308 | 27308 | Thomas Lane L000065 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27324 | 27324 | Peter Mack M000020 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
27336 | 27336 | Fred Marshall M000152 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27383 | 27383 | Morgan Moulder M001045 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27403 | 27403 | William Norrell N000137 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27422 | 27422 | Louis Rabaut R000001 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
27452 | 27452 | Samuel Rayburn R000082 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27542 | 27542 | Brent Spence S000717 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27595 | 27595 | John Kennedy K000107 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27670 | 27670 | Charles Buckley B001024 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
27692 | 27692 | Clarence Cannon C000117 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
27728 | 27728 | Clifford Davis D000094 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
27754 | 27754 | Clyde Doyle D000481 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
27763 | 27763 | Carl Elliott E000120 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27792 | 27792 | Julian Gary G000091 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27822 | 27822 | George Grant G000381 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27831 | 27831 | William Green G000421 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27881 | 27881 | Joseph Hill H000598 | sen | AL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27939 | 27939 | Olin Johnston J000195 | sen | SC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
28028 | 28028 | Almer Monroney M000859 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28059 | 28059 | Thomas O’Brien O000016 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28097 | 28097 | Albert Rains R000018 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28131 | 28131 | John Shelley S000327 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28145 | 28145 | Harry Sheppard S000335 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
28164 | 28164 | George Smathers S000505 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28179 | 28179 | William Thornberry T000237 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28221 | 28221 | Carl Vinson V000105 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28240 | 28240 | Francis Walter W000108 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
28266 | 28266 | Victor Wickersham W000439 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28286 | 28286 | William Winstead W000641 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 |
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);