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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27401 | 27401 | William Norrell N000137 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
27371 | 27371 | Chester Merrow M000664 | rep | NH | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
27356 | 27356 | Gordon McDonough M000414 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
27347 | 27347 | Noah Mason M000224 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
27306 | 27306 | Thomas Lane L000065 | rep | MA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
27290 | 27290 | Paul Kilday K000171 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 20 | |||||||||||||
27279 | 27279 | Carey Kefauver K000044 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27259 | 27259 | Walter Judd J000278 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
27236 | 27236 | Clare Hoffman H000683 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
27216 | 27216 | Burr Harrison H000264 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 7 | |||||||||||||
27195 | 27195 | Ivor Fenton F000075 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
27145 | 27145 | Robert Chiperfield C000365 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
27131 | 27131 | Overton Brooks B000884 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
27115 | 27115 | Frank Boykin B000725 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
27092 | 27092 | Cleveland Bailey B000035 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
27078 | 27078 | Herman Andersen A000179 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
27022 | 27022 | Dean Taylor T000070 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 33 | |||||||||||||
27006 | 27006 | Richard Simpson S000436 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
26993 | 26993 | Edith Rogers R000392 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
26975 | 26975 | Edward Rees R000132 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26963 | 26963 | Daniel Reed R000113 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 45 | |||||||||||||
26874 | 26874 | William Hess H000550 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26839 | 26839 | Clair Engle E000181 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
26829 | 26829 | Carl Durham D000571 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26803 | 26803 | Dennis Chavez C000338 | sen | NM | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26792 | 26792 | Albert Carnahan C000162 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26784 | 26784 | Gordon Canfield C000113 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
26777 | 26777 | Harry Byrd B001208 | sen | VA | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
26754 | 26754 | Paul Brown B000940 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
26727 | 26727 | James Beall B000271 | rep | MD | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
26713 | 26713 | Graham Barden B000139 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
26698 | 26698 | Leo Allen A000138 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 13 | |||||||||||||
26684 | 26684 | Charles Wolverton W000683 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26660 | 26660 | Richard Wigglesworth W000450 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 13 | |||||||||||||
26644 | 26644 | Charles Vursell V000125 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 23 | |||||||||||||
26636 | 26636 | John Vorys V000119 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
26625 | 26625 | Henry Talle T000028 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26613 | 26613 | Lawrence Smith S000585 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26604 | 26604 | Sidney Simpson S000437 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 20 | |||||||||||||
26580 | 26580 | Errett Scrivner S000194 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26548 | 26548 | Joseph O’Hara O000056 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26520 | 26520 | Arthur Miller M000715 | rep | NE | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26507 | 26507 | J. McGregor M000460 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
26497 | 26497 | Samuel McConnell M000354 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
26485 | 26485 | Karl Le Compte L000157 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26475 | 26475 | Henry Latham L000108 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26457 | 26457 | Augustine Kelley K000058 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 27 | |||||||||||||
26447 | 26447 | Bernard Kearney K000030 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 31 | |||||||||||||
26439 | 26439 | Robert Kean K000029 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
26429 | 26429 | Thomas Jenkins J000088 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
26404 | 26404 | Otis Holmes H000740 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26392 | 26392 | William Hill H000613 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26383 | 26383 | John Heselton H000549 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26371 | 26371 | Lawrence Hays H000405 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26353 | 26353 | Robert Hale H000036 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26345 | 26345 | Ralph Gwinn G000541 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 27 | |||||||||||||
26338 | 26338 | Noble Gregory G000447 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26327 | 26327 | Thomas Gordon G000316 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
26314 | 26314 | Herman Eberharter E000029 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 32 | |||||||||||||
26276 | 26276 | Paul Cunningham C000993 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
26258 | 26258 | Jere Cooper C000755 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 9 | |||||||||||||
26243 | 26243 | William Cole C000617 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 39 | |||||||||||||
26231 | 26231 | Cliff Clevenger C000515 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
26218 | 26218 | Francis Case C000221 | rep | SD | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
26171 | 26171 | August Andresen A000239 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26143 | 26143 | Jesse Wolcott W000668 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
26122 | 26122 | Dewey Short S000377 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
26110 | 26110 | James Richards R000214 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
26098 | 26098 | Chauncey Reed R000111 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
26087 | 26087 | James Priest P000536 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
26079 | 26079 | John Phillips P000309 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 22 | |||||||||||||
26070 | 26070 | Matthew Neely N000023 | rep | WV | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26051 | 26051 | Thomas Martin M000199 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
26038 | 26038 | Arthur Klein K000261 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 19 | |||||||||||||
26023 | 26023 | Justin Johnson J000157 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
26016 | 26016 | Clifford Hope H000768 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
25997 | 25997 | John Hinshaw H000640 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 20 | |||||||||||||
25987 | 25987 | Thomas Hand H000154 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
25978 | 25978 | William Granahan G000369 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
25970 | 25970 | Ralph Gamble G000031 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 28 | |||||||||||||
25954 | 25954 | Antonio Fernández F000085 | rep | NM | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
25945 | 25945 | Mathew Ellsworth E000146 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
25935 | 25935 | George Dondero D000411 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 17 | |||||||||||||
25923 | 25923 | James Dolliver D000403 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
25917 | 25917 | John Dingell D000354 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 15 | |||||||||||||
25860 | 25860 | Joseph O’Mahoney O000088 | sen | WY | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25850 | 25850 | George Bender B000356 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
25828 | 25828 | Alvin Weichel W000252 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 13 | |||||||||||||
25812 | 25812 | Thomas Stanley S000797 | rep | VA | 1946-11-05 | 1947-01-03 | Democrat | 5 | |||||||||||||
25809 | 25809 | Howard Smith S000553 | sen | NJ | 1944-01-01 | 1947-01-03 | 1 | Republican | |||||||||||||
25803 | 25803 | Paul Shafer S000277 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25791 | 25791 | Dwight Rogers R000391 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
25769 | 25769 | George O’Brien O000009 | rep | MI | 1945-01-03 | 1947-01-03 | Democrat | 13 | |||||||||||||
25753 | 25753 | John Lyle L000525 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
25743 | 25743 | William Langer L000070 | sen | ND | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
25740 | 25740 | William Knowland K000292 | sen | CA | 1945-08-14 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
25737 | 25737 | Harley Kilgore K000176 | sen | WV | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25719 | 25719 | Merlin Hull H000943 | rep | WI | 1945-01-03 | 1947-01-03 | Progressive | 9 | |||||||||||||
25701 | 25701 | Edward Hart H000284 | rep | NJ | 1945-01-03 | 1947-01-03 | Democrat | 14 |
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);