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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24642 | 24642 | Albert Reeves R000137 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
24646 | 24646 | Ross Rizley R000288 | rep | OK | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
24649 | 24649 | Charles Robertson R000319 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24663 | 24663 | John Robsion R000358 | rep | KY | 1947-01-03 | 1948-02-17 | Republican | 9 | |||||||||||||
24667 | 24667 | Robert Rockwell R000369 | rep | CO | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24669 | 24669 | Edward Rohrbough R000410 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24670 | 24670 | Charles Russell R000522 | rep | NV | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24671 | 24671 | George Sarbacher S000063 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
24674 | 24674 | Max Schwabe S000156 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24676 | 24676 | James Scoblick S000163 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24677 | 24677 | Melvin Snyder S000670 | rep | WV | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24682 | 24682 | Raymond Springer S000755 | rep | IN | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24686 | 24686 | William Stevenson S000896 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24688 | 24688 | William Stratton S000998 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24691 | 24691 | Frank Sundstrom S001076 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
24700 | 24700 | Robert Thomason T000189 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24705 | 24705 | Harve Tibbott T000263 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 26 | |||||||||||||
24706 | 24706 | Robert Twyman T000444 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
24711 | 24711 | Arthur Vandenberg V000025 | sen | MI | 1947-01-03 | 1951-04-18 | 1 | Republican | |||||||||||||
24719 | 24719 | Milton West W000304 | rep | TX | 1947-01-03 | 1949-01-03 | Democrat | 15 | |||||||||||||
24720 | 24720 | Harold Youngblood Y000058 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
24727 | 24727 | Orville Zimmerman Z000009 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
24737 | 24737 | George Bates B000232 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
24809 | 24809 | Ralph Church C000390 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
24819 | 24819 | Helen Douglas D000454 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 14 | |||||||||||||
24828 | 24828 | Albert Engel E000178 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
24863 | 24863 | John Jennings J000096 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
24873 | 24873 | Frank Keefe K000041 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
24878 | 24878 | Jay Le Fevre L000161 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 30 | |||||||||||||
24887 | 24887 | William Lemke L000238 | rep | ND | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
24896 | 24896 | John Lesinski L000251 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 16 | |||||||||||||
24898 | 24898 | Franklin Lichtenwalter L000301 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
24901 | 24901 | John Lodge L000395 | rep | CT | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
24907 | 24907 | Walter Lynch L000537 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 23 | |||||||||||||
24909 | 24909 | William Macy M000037 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24916 | 24916 | Vito Marcantonio M000122 | rep | NY | 1947-01-03 | 1949-01-03 | American Labor | 18 | |||||||||||||
24924 | 24924 | Rolla McMillen M000574 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 19 | |||||||||||||
24931 | 24931 | Herbert Meyer M000680 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
24946 | 24946 | Earl Michener M000693 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
24990 | 24990 | Dayton Phillips P000306 | rep | TN | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24999 | 24999 | Charles Plumley P000395 | rep | VT | 1947-01-03 | 1949-01-03 | Republican | 0 | |||||||||||||
25009 | 25009 | Robert Rich R000209 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 15 | |||||||||||||
25016 | 25016 | George Sadowski S000011 | rep | MI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
25018 | 25018 | John Sanborn S000029 | rep | ID | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25025 | 25025 | Frederick Smith S000536 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25038 | 25038 | Andrew Somers S000676 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
25046 | 25046 | John Thomas T000175 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
25057 | 25057 | James Wadsworth W000012 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 41 | |||||||||||||
25072 | 25072 | Richard Welch W000265 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
25107 | 25107 | Earle Clements C000506 | rep | KY | 1947-01-03 | 1948-01-06 | Democrat | 2 | |||||||||||||
25117 | 25117 | Asa Allen A000114 | rep | LA | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25124 | 25124 | John Anderson A000196 | rep | CA | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25128 | 25128 | Claude Bakewell B000080 | rep | MO | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25135 | 25135 | Joseph Bates B000237 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25143 | 25143 | William Blackney B000515 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
25152 | 25152 | Walter Brehm B000794 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 11 | |||||||||||||
25156 | 25156 | Frank Buchanan B001002 | rep | PA | 1947-01-03 | 1949-01-03 | Democrat | 33 | |||||||||||||
25161 | 25161 | Howard Buffett B001039 | rep | NE | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
25163 | 25163 | Clarence Burton B001148 | rep | VA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
25169 | 25169 | John Butler B001179 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 44 | |||||||||||||
25176 | 25176 | William Byrne B001214 | rep | NY | 1947-01-03 | 1949-01-03 | Democrat | 32 | |||||||||||||
25182 | 25182 | Albert Cole C000606 | rep | KS | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
25209 | 25209 | Fred Crawford C000889 | rep | MI | 1947-01-03 | 1949-01-03 | Republican | 8 | |||||||||||||
25231 | 25231 | Robert Doughton D000448 | rep | NC | 1947-01-03 | 1949-01-03 | Democrat | 9 | |||||||||||||
25246 | 25246 | Charles Eaton E000023 | rep | NJ | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
25253 | 25253 | Charles Elston E000160 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25275 | 25275 | Wilson Gillette G000206 | rep | PA | 1947-01-03 | 1949-01-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
25296 | 25296 | Edwin Hall H000050 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 37 | |||||||||||||
25303 | 25303 | Leonard Hall H000060 | rep | NY | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
25324 | 25324 | Christian Herter H000548 | rep | MA | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
25332 | 25332 | Edward Jenison J000080 | rep | IL | 1947-01-03 | 1949-01-03 | Republican | 18 | |||||||||||||
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 | |||||||||||||
25408 | 25408 | Reid Murray M001112 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 7 | |||||||||||||
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 |
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);