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 caucus
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24108 | 24108 | Paul Stewart S000918 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24112 | 24112 | Jessie Sumner S001071 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
24129 | 24129 | Hatton Sumners S001072 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24132 | 24132 | Joseph Talbot T000018 | rep | CT | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
24142 | 24142 | Malcolm Tarver T000045 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24148 | 24148 | William Thom T000155 | rep | OH | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24163 | 24163 | John Tolan T000295 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24165 | 24165 | James Torrens T000315 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 21 | |||||||||||||
24167 | 24167 | Philip Traynor T000357 | rep | DE | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24178 | 24178 | Horace Voorhis V000118 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
24185 | 24185 | Thaddeus Wasielewski W000183 | rep | WI | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24199 | 24199 | Zebulon Weaver W000230 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
24202 | 24202 | Samuel Weiss W000257 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 33 | |||||||||||||
24206 | 24206 | Thomas Winter W000645 | rep | KS | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24216 | 24216 | James Wolfenden W000678 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
24228 | 24228 | Clifton Woodrum W000720 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24231 | 24231 | Raymond Baldwin B000095 | sen | CT | 1946-12-27 | 1947-01-03 | 1 | Republican | |||||||||||||
24242 | 24242 | Harry Cain C000021 | sen | WA | 1946-12-31 | 1947-01-03 | 1 | Republican | |||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
24245 | 24245 | Kingsley Taft T000008 | sen | OH | 1946-11-06 | 1947-01-03 | 1 | Republican | |||||||||||||
24250 | 24250 | James Almond A000163 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24259 | 24259 | Walter Andrews A000250 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 42 | |||||||||||||
24262 | 24262 | Samuel Arnold A000296 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
24270 | 24270 | Charles Bell B000332 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24273 | 24273 | Marion Bennett B000379 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24278 | 24278 | Frederick Bradley B000742 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
24284 | 24284 | Ralph Brewster B000816 | sen | ME | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24288 | 24288 | Ellsworth Buck B001016 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 16 | |||||||||||||
24302 | 24302 | Jerome Clark C000439 | rep | NC | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24308 | 24308 | Charles Clason C000473 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24310 | 24310 | Roy Clippinger C000529 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 24 | |||||||||||||
24321 | 24321 | Thomas Connally C000684 | sen | TX | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24326 | 24326 | William Courtney C000810 | rep | TN | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24331 | 24331 | William Cravens C000887 | rep | AR | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24337 | 24337 | Thomas D’Alesandro D000007 | rep | MD | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24347 | 24347 | John Delaney D000212 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
24352 | 24352 | James Domengeaux D000406 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24367 | 24367 | Patrick Drewry D000496 | rep | VA | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
24374 | 24374 | Alfred Elliott E000119 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
24377 | 24377 | Hubert Ellis E000135 | rep | WV | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24379 | 24379 | Edward Elsaesser E000159 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 43 | |||||||||||||
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 | |||||||||||||
24397 | 24397 | Hadwen Fuller F000404 | rep | NY | 1945-01-03 | 1947-01-03 | Republican | 35 | |||||||||||||
24406 | 24406 | Bertrand Gearhart G000111 | rep | CA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
24411 | 24411 | Charles Gerlach G000135 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
24425 | 24425 | Charles Gifford G000169 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
24430 | 24430 | George Gillie G000207 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24436 | 24436 | Robert Grant G000384 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24439 | 24439 | Percy Griffiths G000472 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 15 | |||||||||||||
24443 | 24443 | Chester Gross G000493 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 21 | |||||||||||||
24450 | 24450 | John Gwynne G000543 | rep | IA | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24453 | 24453 | Richard Harless H000212 | rep | AZ | 1945-01-03 | 1947-01-03 | Democrat | 0 | |||||||||||||
24458 | 24458 | Forest Harness H000217 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
24468 | 24468 | Fred Hartley H000298 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
24474 | 24474 | Joseph Hendricks H000492 | rep | FL | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
24478 | 24478 | George Howell H000863 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 21 | |||||||||||||
24485 | 24485 | Peterson Jarman J000058 | rep | AL | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
24491 | 24491 | Anton Johnson J000117 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 14 | |||||||||||||
24500 | 24500 | Noble Johnson J000165 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24506 | 24506 | Robert Jones J000249 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24511 | 24511 | Bartel Jonkman J000264 | rep | MI | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
24528 | 24528 | Harold Knutson K000301 | rep | MN | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
24533 | 24533 | Gerald Landis L000052 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 7 | |||||||||||||
24549 | 24549 | Clarence Lea L000163 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24553 | 24553 | Earl Lewis L000279 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
24593 | 24593 | Frank Mathews M000233 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24596 | 24596 | Edward McCowen M000374 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
24629 | 24629 | Walter Ploeser P000387 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 12 | |||||||||||||
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 | |||||||||||||
24638 | 24638 | Homer Ramey R000022 | rep | OH | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
24640 | 24640 | Leo Rayfiel R000083 | rep | NY | 1945-01-03 | 1947-01-03 | Democrat | 14 | |||||||||||||
24645 | 24645 | Ross Rizley R000288 | rep | OK | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
24648 | 24648 | Charles Robertson R000319 | rep | ND | 1945-01-03 | 1947-01-03 | Republican | 0 | |||||||||||||
24662 | 24662 | John Robsion R000358 | rep | KY | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
24666 | 24666 | Robert Rockwell R000369 | rep | CO | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
24673 | 24673 | Max Schwabe S000156 | rep | MO | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
24675 | 24675 | James Scoblick S000163 | rep | PA | 1946-11-05 | 1947-01-03 | Republican | 10 | |||||||||||||
24681 | 24681 | Raymond Springer S000755 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
24685 | 24685 | William Stevenson S000896 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
24690 | 24690 | Frank Sundstrom S001076 | rep | NJ | 1945-01-03 | 1947-01-03 | Republican | 11 | |||||||||||||
24699 | 24699 | Robert Thomason T000189 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 16 | |||||||||||||
24704 | 24704 | Harve Tibbott T000263 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 26 | |||||||||||||
24710 | 24710 | Arthur Vandenberg V000025 | sen | MI | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
24736 | 24736 | George Bates B000232 | rep | MA | 1945-01-03 | 1947-01-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
24808 | 24808 | Ralph Church C000390 | rep | IL | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
24818 | 24818 | Helen Douglas D000454 | rep | CA | 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);