legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
485 rows where "start" is on date 1947-01-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25446 | 25446 | John Rankin R000056 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25449 | 25449 | Monroe Redden R000104 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
25452 | 25452 | Robert Ross R000453 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25474 | 25474 | Adolph Sabath S000001 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25481 | 25481 | Lansdale Sasscer S000067 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25485 | 25485 | George Schwabe S000155 | rep | OK | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25487 | 25487 | Hardie Scott S000172 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25498 | 25498 | Karl Stefan S000845 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25503 | 25503 | William Stigler S000923 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25508 | 25508 | Lowell Stockman S000936 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25528 | 25528 | Harry Towe T000320 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25534 | 25534 | Richard Vail V000003 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25548 | 25548 | John Wood W000699 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25566 | 25566 | Roy Woodruff W000718 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25581 | 25581 | Homer Angell A000257 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25587 | 25587 | Frank Barrett B000176 | rep | WY | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25590 | 25590 | Laurie Battle B000242 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25597 | 25597 | Cecil Bishop B000486 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 25 | |||||||||||||
25602 | 25602 | Ernest Bramblett B000762 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25606 | 25606 | John Bricker B000820 | sen | OH | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25612 | 25612 | Joseph Bryson B000999 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25618 | 25618 | Fred Busbey B001161 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25622 | 25622 | Hugh Butler B001177 | sen | NE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25636 | 25636 | William Cole C000614 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25654 | 25654 | Robert Crosser C000932 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25659 | 25659 | Wesley D’Ewart D000281 | rep | MT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25666 | 25666 | Joseph Farrington F000034 | rep | HI | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25671 | 25671 | Ralph Flanders F000190 | sen | VT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25678 | 25678 | Angier Goodwin G000297 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25686 | 25686 | Louis Graham G000360 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 25 | |||||||||||||
25692 | 25692 | Harold Hagen H000014 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25702 | 25702 | Edward Hart H000284 | rep | NJ | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25720 | 25720 | Merlin Hull H000943 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
25726 | 25726 | Irving Ives I000050 | sen | NY | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25729 | 25729 | William Jenner J000093 | sen | IN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25734 | 25734 | Charles Kersten K000150 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25738 | 25738 | Harley Kilgore K000176 | sen | WV | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25741 | 25741 | William Knowland K000292 | sen | CA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25744 | 25744 | William Langer L000070 | sen | ND | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25749 | 25749 | Wingate Lucas L000496 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 12 | |||||||||||||
25754 | 25754 | John Lyle L000525 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
25758 | 25758 | George Malone M000086 | sen | NV | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25760 | 25760 | Edward Martin M000177 | sen | PA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25762 | 25762 | Joseph McCarthy M000315 | sen | WI | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25779 | 25779 | C. Poulson P000475 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25787 | 25787 | Kenneth Regan R000140 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
25792 | 25792 | Dwight Rogers R000391 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25804 | 25804 | Paul Shafer S000277 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25810 | 25810 | Howard Smith S000553 | sen | NJ | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25813 | 25813 | Thomas Stanley S000797 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25821 | 25821 | Edward Thye T000259 | sen | MN | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25825 | 25825 | Arthur Watkins W000190 | sen | UT | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
25829 | 25829 | Alvin Weichel W000252 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 13 | |||||||||||||
25833 | 25833 | William Wheeler W000342 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25837 | 25837 | Joseph Wilson W000604 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25851 | 25851 | George Bender B000356 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25861 | 25861 | Joseph O’Mahoney O000088 | sen | WY | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25906 | 25906 | Charles Deane D000175 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25918 | 25918 | John Dingell D000354 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
25924 | 25924 | James Dolliver D000403 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25936 | 25936 | George Dondero D000411 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
25946 | 25946 | Mathew Ellsworth E000146 | rep | OR | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
25955 | 25955 | Antonio Fernández F000085 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
25971 | 25971 | Ralph Gamble G000031 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 28 | |||||||||||||
25988 | 25988 | Thomas Hand H000154 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25998 | 25998 | John Hinshaw H000640 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 20 | |||||||||||||
26017 | 26017 | Clifford Hope H000768 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26024 | 26024 | Justin Johnson J000157 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26039 | 26039 | Arthur Klein K000261 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 19 | |||||||||||||
26052 | 26052 | Thomas Martin M000199 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26080 | 26080 | John Phillips P000309 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 22 | |||||||||||||
26088 | 26088 | James Priest P000536 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
26099 | 26099 | Chauncey Reed R000111 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
26111 | 26111 | James Richards R000214 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26123 | 26123 | Dewey Short S000377 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26144 | 26144 | Jesse Wolcott W000668 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26156 | 26156 | John Allen A000133 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
26172 | 26172 | August Andresen A000239 | rep | MN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26211 | 26211 | John Carroll C000189 | rep | CO | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26219 | 26219 | Francis Case C000221 | rep | SD | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26232 | 26232 | Cliff Clevenger C000515 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26244 | 26244 | William Cole C000617 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 39 | |||||||||||||
26259 | 26259 | Jere Cooper C000755 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
26265 | 26265 | Frederic Coudert C000804 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 17 | |||||||||||||
26277 | 26277 | Paul Cunningham C000993 | rep | IA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
26283 | 26283 | William Dawson D000155 | rep | UT | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26315 | 26315 | Herman Eberharter E000029 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 32 | |||||||||||||
26328 | 26328 | Thomas Gordon G000316 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
26339 | 26339 | Noble Gregory G000447 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26346 | 26346 | Ralph Gwinn G000541 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 27 | |||||||||||||
26354 | 26354 | Robert Hale H000036 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26372 | 26372 | Lawrence Hays H000405 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
26384 | 26384 | John Heselton H000549 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
26393 | 26393 | William Hill H000613 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
26405 | 26405 | Otis Holmes H000740 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26430 | 26430 | Thomas Jenkins J000088 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
26440 | 26440 | Robert Kean K000029 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 12 | |||||||||||||
26448 | 26448 | Bernard Kearney K000030 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 31 | |||||||||||||
26458 | 26458 | Augustine Kelley K000058 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 27 |
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);