legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
486 rows where "end" is on date 1949-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24480 | 24480 | Leo Isacson I000046 | rep | NY | 1947-01-03 | 1949-01-03 | American Labor | 24 | |||||||||||||
24916 | 24916 | Vito Marcantonio M000122 | rep | NY | 1947-01-03 | 1949-01-03 | American Labor | 18 | |||||||||||||
23550 | 23550 | Carl Hatch H000334 | sen | NM | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23637 | 23637 | Wilbert O’Daniel O000034 | sen | TX | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
23706 | 23706 | Arthur Stewart S000901 | sen | TN | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24022 | 24022 | John Overton O000146 | sen | LA | 1945-01-03 | 1949-01-03 | 3 | Democrat | |||||||||||||
24249 | 24249 | William Umstead U000005 | sen | NC | 1946-12-18 | 1949-01-03 | 2 | Democrat | appointment | ||||||||||||
24251 | 24251 | James Almond A000163 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24271 | 24271 | Charles Bell B000332 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24303 | 24303 | Jerome Clark C000439 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24327 | 24327 | William Courtney C000810 | rep | TN | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24332 | 24332 | William Cravens C000887 | rep | AR | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24338 | 24338 | Thomas D’Alesandro D000007 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24348 | 24348 | John Delaney D000212 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24353 | 24353 | James Domengeaux D000406 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24368 | 24368 | Patrick Drewry D000496 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24375 | 24375 | Alfred Elliott E000119 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24389 | 24389 | John Flannagan F000191 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24394 | 24394 | John Folger F000241 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24454 | 24454 | Richard Harless H000212 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24475 | 24475 | Joseph Hendricks H000492 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
24486 | 24486 | Peterson Jarman J000058 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24493 | 24493 | Glen Johnson J000133 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24550 | 24550 | Clarence Lea L000163 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24569 | 24569 | Louis Ludlow L000501 | rep | IN | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
24570 | 24570 | Georgia Lusk L000519 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
24576 | 24576 | Carter Manasco M000094 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24592 | 24592 | Joseph Mansfield M000112 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
24614 | 24614 | Hugh Meade M000617 | rep | MD | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24626 | 24626 | Preston Peden P000182 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
24634 | 24634 | Emory Price P000524 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
24636 | 24636 | Benjamin Rabin R000002 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 24 | |||||||||||||
24641 | 24641 | Leo Rayfiel R000083 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24700 | 24700 | Robert Thomason T000189 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24719 | 24719 | Milton West W000304 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
24727 | 24727 | Orville Zimmerman Z000009 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24728 | 24728 | Joseph Broughton B000894 | sen | NC | 1948-12-31 | 1949-01-03 | 2 | Democrat | |||||||||||||
24731 | 24731 | William Feazel F000057 | sen | LA | 1948-05-18 | 1949-01-03 | 3 | Democrat | appointment | ||||||||||||
24757 | 24757 | Schuyler Bland B000545 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24771 | 24771 | Sol Bloom B000565 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 20 | |||||||||||||
24787 | 24787 | Alfred Bulwinkle B001056 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
24801 | 24801 | Virgil Chapman C000317 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
24819 | 24819 | Helen Douglas D000454 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24840 | 24840 | Martin Gorski G000332 | rep | IL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24852 | 24852 | Samuel Hobbs H000663 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
24855 | 24855 | Walter Huber H000898 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24896 | 24896 | John Lesinski L000251 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24907 | 24907 | Walter Lynch L000537 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 23 | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24962 | 24962 | Mary Norton N000153 | rep | NJ | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
24970 | 24970 | Stephen Pace P000002 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
24979 | 24979 | James Peterson P000261 | rep | FL | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
24987 | 24987 | Joseph Pfeifer P000285 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25016 | 25016 | George Sadowski S000011 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25038 | 25038 | Andrew Somers S000676 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
25096 | 25096 | William Whittington W000430 | rep | MS | 1947-01-03 | 1949-01-03 | Democrat | 3 | |||||||||||||
25104 | 25104 | Francis Worley W000744 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 18 | |||||||||||||
25117 | 25117 | Asa Allen A000114 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25135 | 25135 | Joseph Bates B000237 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25156 | 25156 | Frank Buchanan B001002 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 33 | |||||||||||||
25163 | 25163 | Clarence Burton B001148 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25176 | 25176 | William Byrne B001214 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 32 | |||||||||||||
25186 | 25186 | Jesse Combs C000655 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25200 | 25200 | Edward Cox C000831 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25231 | 25231 | Robert Doughton D000448 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25282 | 25282 | Ed Gossett G000338 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
25288 | 25288 | Walter Granger G000379 | rep | UT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25309 | 25309 | Franck Havenner H000356 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25313 | 25313 | Erland Hedrick H000442 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25319 | 25319 | James Heffernan H000443 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 11 | |||||||||||||
25335 | 25335 | Hamilton Jones J000224 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
25345 | 25345 | John Kee K000039 | rep | WV | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
25360 | 25360 | John Kerr K000138 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25365 | 25365 | Henry Larcade L000095 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
25399 | 25399 | John Murdock M001081 | rep | AZ | 1947-01-03 | 1949-01-03 | Democrat | 0 | |||||||||||||
25418 | 25418 | Donald O’Toole O000133 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 13 | |||||||||||||
25422 | 25422 | Thomas Pickett P000327 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25503 | 25503 | William Stigler S000923 | rep | OK | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
25542 | 25542 | John Whitaker W000348 | rep | KY | 1948-04-17 | 1949-01-03 | Democrat | 2 | |||||||||||||
25548 | 25548 | John Wood W000699 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25590 | 25590 | Laurie Battle B000242 | rep | AL | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25612 | 25612 | Joseph Bryson B000999 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25628 | 25628 | Albert Camp C000070 | rep | GA | 1947-01-03 | 1949-01-03 | Democrat | 4 | |||||||||||||
25654 | 25654 | Robert Crosser C000932 | rep | OH | 1947-01-03 | 1949-01-03 | Democrat | 21 | |||||||||||||
25702 | 25702 | Edward Hart H000284 | rep | NJ | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25813 | 25813 | Thomas Stanley S000797 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
25955 | 25955 | Antonio Fernández F000085 | rep | NM | 1947-01-03 | 1949-01-03 | Democrat | 0 |
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);