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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28666 | 28666 | Howard Smith S000554 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28648 | 28648 | Robert Secrest S000219 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
28590 | 28590 | Thomas Murray M001114 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28577 | 28577 | James Morrison M000995 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28557 | 28557 | Eugene McCarthy M000311 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28541 | 28541 | Joseph Martin M000191 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 14 | |||||||||||||
28517 | 28517 | John Kunkel K000341 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
28499 | 28499 | Eugene Keogh K000130 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
28483 | 28483 | Paul Jones J000246 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28461 | 28461 | Ralph Harvey H000310 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
28451 | 28451 | Oren Harris H000249 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28430 | 28430 | Albert Gore G000320 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28406 | 28406 | Winfield Denton D000260 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28397 | 28397 | Paul Dague D000004 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28381 | 28381 | Harold Cooley C000736 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28363 | 28363 | Frank Chelf C000342 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28348 | 28348 | Clarence Brown B000909 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
28334 | 28334 | Herbert Bonner B000621 | rep | NC | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
28322 | 28322 | Lindley Beckworth B000296 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
28286 | 28286 | William Winstead W000641 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28276 | 28276 | Earl Wilson W000572 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28266 | 28266 | Victor Wickersham W000439 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
28240 | 28240 | Francis Walter W000108 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
28221 | 28221 | Carl Vinson V000105 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28188 | 28188 | Thor Tollefson T000298 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28179 | 28179 | William Thornberry T000237 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28169 | 28169 | Katharine St. George S000764 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 29 | |||||||||||||
28164 | 28164 | George Smathers S000505 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28145 | 28145 | Harry Sheppard S000335 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
28131 | 28131 | John Shelley S000327 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28107 | 28107 | Roy Riehlman R000250 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 36 | |||||||||||||
28097 | 28097 | Albert Rains R000018 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
28059 | 28059 | Thomas O’Brien O000016 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28043 | 28043 | Albin Norblad N000133 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
28037 | 28037 | Thruston Morton M001022 | rep | KY | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
28032 | 28032 | Wayne Morse M001014 | sen | OR | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
28028 | 28028 | Almer Monroney M000859 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27955 | 27955 | Clarence Kilburn K000170 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 34 | |||||||||||||
27939 | 27939 | Olin Johnston J000195 | sen | SC | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27920 | 27920 | Benton Jensen J000100 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
27902 | 27902 | Walter Horan H000786 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27888 | 27888 | Charles Hoeven H000678 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
27881 | 27881 | Joseph Hill H000598 | sen | AL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27867 | 27867 | Bourke Hickenlooper H000559 | sen | IA | 1945-01-03 | 1951-01-03 | 3 | Republican | |||||||||||||
27854 | 27854 | Carl Hayden H000385 | sen | AZ | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
27831 | 27831 | William Green G000421 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27822 | 27822 | George Grant G000381 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27803 | 27803 | Leon Gavin G000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
27792 | 27792 | Julian Gary G000091 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27773 | 27773 | Antonio Fernós-Isern F000087 | rep | PR | 1949-01-03 | 1951-01-03 | Popular Democrat | 0 | |||||||||||||
27763 | 27763 | Carl Elliott E000120 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27754 | 27754 | Clyde Doyle D000481 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
27728 | 27728 | Clifford Davis D000094 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
27706 | 27706 | Frank Carlson C000154 | sen | KS | 1950-11-29 | 1951-01-03 | 3 | Republican | |||||||||||||
27692 | 27692 | Clarence Cannon C000117 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
27670 | 27670 | Charles Buckley B001024 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 25 | |||||||||||||
27645 | 27645 | John Bennett B000377 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
27611 | 27611 | James Auchincloss A000227 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27595 | 27595 | John Kennedy K000107 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27577 | 27577 | James Van Zandt V000069 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
27562 | 27562 | John Taber T000001 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 38 | |||||||||||||
27542 | 27542 | Brent Spence S000717 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27452 | 27452 | Samuel Rayburn R000082 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27422 | 27422 | Louis Rabaut R000001 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 14 | |||||||||||||
27403 | 27403 | William Norrell N000137 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27383 | 27383 | Morgan Moulder M001045 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
27373 | 27373 | Chester Merrow M000664 | rep | NH | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
27358 | 27358 | Gordon McDonough M000414 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
27349 | 27349 | Noah Mason M000224 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 15 | |||||||||||||
27336 | 27336 | Fred Marshall M000152 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27324 | 27324 | Peter Mack M000020 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
27308 | 27308 | Thomas Lane L000065 | rep | MA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27292 | 27292 | Paul Kilday K000171 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
27269 | 27269 | Carroll Kearns K000032 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 28 | |||||||||||||
27261 | 27261 | Walter Judd J000278 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27238 | 27238 | Clare Hoffman H000683 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
27218 | 27218 | Burr Harrison H000264 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
27204 | 27204 | James Frazier F000353 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27197 | 27197 | Ivor Fenton F000075 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
27171 | 27171 | James Davis D000109 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
27147 | 27147 | Robert Chiperfield C000365 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 19 | |||||||||||||
27133 | 27133 | Overton Brooks B000884 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27117 | 27117 | Frank Boykin B000725 | rep | AL | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27093 | 27093 | Cleveland Bailey B000035 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27080 | 27080 | Herman Andersen A000179 | rep | MN | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
27061 | 27061 | Hugh Addonizio A000054 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
27050 | 27050 | Gardner Withrow W000663 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27040 | 27040 | Roy Wier W000446 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27024 | 27024 | Dean Taylor T000070 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 33 | |||||||||||||
27015 | 27015 | Wint Smith S000640 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
27008 | 27008 | Richard Simpson S000436 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
26995 | 26995 | Edith Rogers R000392 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
26977 | 26977 | Edward Rees R000132 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26965 | 26965 | Daniel Reed R000113 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 45 | |||||||||||||
26941 | 26941 | Prince Preston P000516 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26932 | 26932 | James Polk P000408 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26919 | 26919 | Toby Morris M000991 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26907 | 26907 | Russell Mack M000021 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26896 | 26896 | Kenneth Keating K000036 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 40 | |||||||||||||
26887 | 26887 | Donald Jackson J000008 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 16 |
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);