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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24388 | 24388 | John Flannagan F000191 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
24393 | 24393 | John Folger F000241 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24453 | 24453 | Richard Harless H000212 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24474 | 24474 | Joseph Hendricks H000492 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24485 | 24485 | Peterson Jarman J000058 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24549 | 24549 | Clarence Lea L000163 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24568 | 24568 | Louis Ludlow L000501 | rep | IN | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
24575 | 24575 | Carter Manasco M000094 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24591 | 24591 | Joseph Mansfield M000112 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
24600 | 24600 | Ernest McFarland M000438 | sen | AZ | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24611 | 24611 | Kenneth McKellar M000499 | sen | TN | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24633 | 24633 | Emory Price P000524 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
24635 | 24635 | Benjamin Rabin R000002 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 24 | |||||||||||||
24640 | 24640 | Leo Rayfiel R000083 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24699 | 24699 | Robert Thomason T000189 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24718 | 24718 | Milton West W000304 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
24726 | 24726 | Orville Zimmerman Z000009 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
24740 | 24740 | Andrew Biemiller B000448 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24756 | 24756 | Schuyler Bland B000545 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24770 | 24770 | Sol Bloom B000565 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
24786 | 24786 | Alfred Bulwinkle B001056 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
24800 | 24800 | Virgil Chapman C000317 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24818 | 24818 | Helen Douglas D000454 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
24854 | 24854 | Walter Huber H000898 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24895 | 24895 | John Lesinski L000251 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24906 | 24906 | Walter Lynch L000537 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 23 | |||||||||||||
24961 | 24961 | Mary Norton N000153 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
24969 | 24969 | Stephen Pace P000002 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24978 | 24978 | James Peterson P000261 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24986 | 24986 | Joseph Pfeifer P000285 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25015 | 25015 | George Sadowski S000011 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25037 | 25037 | Andrew Somers S000676 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
25083 | 25083 | Compton White W000361 | rep | ID | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25095 | 25095 | William Whittington W000430 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25099 | 25099 | Chase Woodhouse W000714 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25103 | 25103 | Francis Worley W000744 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 18 | |||||||||||||
25106 | 25106 | Earle Clements C000506 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25116 | 25116 | Asa Allen A000114 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25134 | 25134 | Joseph Bates B000237 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25155 | 25155 | Frank Buchanan B001002 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
25175 | 25175 | William Byrne B001214 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
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 | |||||||||||||
25230 | 25230 | Robert Doughton D000448 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
25281 | 25281 | Ed Gossett G000338 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25287 | 25287 | Walter Granger G000379 | rep | UT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25308 | 25308 | Franck Havenner H000356 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
25312 | 25312 | Erland Hedrick H000442 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25318 | 25318 | James Heffernan H000443 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
25344 | 25344 | John Kee K000039 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25359 | 25359 | John Kerr K000138 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25364 | 25364 | Henry Larcade L000095 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25398 | 25398 | John Murdock M001081 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25417 | 25417 | Donald O’Toole O000133 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25421 | 25421 | Thomas Pickett P000327 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
25445 | 25445 | John Rankin R000056 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
25473 | 25473 | Adolph Sabath S000001 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25480 | 25480 | Lansdale Sasscer S000067 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
25502 | 25502 | William Stigler S000923 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25512 | 25512 | John Sullivan S001056 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 11 | |||||||||||||
25547 | 25547 | John Wood W000699 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
25653 | 25653 | Robert Crosser C000932 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25737 | 25737 | Harley Kilgore K000176 | sen | WV | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25753 | 25753 | John Lyle L000525 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25769 | 25769 | George O’Brien O000009 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25791 | 25791 | Dwight Rogers R000391 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25812 | 25812 | Thomas Stanley S000797 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 5 | |||||||||||||
25860 | 25860 | Joseph O’Mahoney O000088 | sen | WY | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25917 | 25917 | John Dingell D000354 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
25954 | 25954 | Antonio Fernández F000085 | rep | NM | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25978 | 25978 | William Granahan G000369 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26038 | 26038 | Arthur Klein K000261 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
26070 | 26070 | Matthew Neely N000023 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26087 | 26087 | James Priest P000536 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26110 | 26110 | James Richards R000214 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26258 | 26258 | Jere Cooper C000755 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
26314 | 26314 | Herman Eberharter E000029 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
26327 | 26327 | Thomas Gordon G000316 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26338 | 26338 | Noble Gregory G000447 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26371 | 26371 | Lawrence Hays H000405 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26457 | 26457 | Augustine Kelley K000058 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 27 | |||||||||||||
26713 | 26713 | Graham Barden B000139 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
26754 | 26754 | Paul Brown B000940 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
26777 | 26777 | Harry Byrd B001208 | sen | VA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26792 | 26792 | Albert Carnahan C000162 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26803 | 26803 | Dennis Chavez C000338 | sen | NM | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26829 | 26829 | Carl Durham D000571 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26839 | 26839 | Clair Engle E000181 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27092 | 27092 | Cleveland Bailey B000035 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27115 | 27115 | Frank Boykin B000725 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27131 | 27131 | Overton Brooks B000884 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27216 | 27216 | Burr Harrison H000264 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 7 | |||||||||||||
27279 | 27279 | Carey Kefauver K000044 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27290 | 27290 | Paul Kilday K000171 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 20 |
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);