legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
484 rows where "start" is on date 1951-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33192 | 33192 | Clement Zablocki Z000001 | rep | WI | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25844 | 25844 | Samuel Yorty Y000024 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 14 | |||||||||||||
36449 | 36449 | Sidney Yates Y000013 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
25568 | 25568 | Roy Woodruff W000718 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25551 | 25551 | John Wood W000700 | rep | ID | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
25550 | 25550 | John Wood W000699 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
26687 | 26687 | Charles Wolverton W000683 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26146 | 26146 | Jesse Wolcott W000668 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
27051 | 27051 | Gardner Withrow W000663 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
28287 | 28287 | William Winstead W000641 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
25839 | 25839 | Joseph Wilson W000604 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
28277 | 28277 | Earl Wilson W000572 | rep | IN | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
29079 | 29079 | Edwin Willis W000559 | rep | LA | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26671 | 26671 | William Williams W000549 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 35 | |||||||||||||
29069 | 29069 | John Williams W000517 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
26669 | 26669 | Alexander Wiley W000465 | sen | WI | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
26663 | 26663 | Richard Wigglesworth W000450 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
27041 | 27041 | Roy Wier W000446 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
30749 | 30749 | William Widnall W000445 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
28267 | 28267 | Victor Wickersham W000439 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
35647 | 35647 | Jamie Whitten W000428 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25544 | 25544 | John Whitaker W000348 | rep | KY | 1951-01-03 | 1951-12-15 | Democrat | 2 | |||||||||||||
25835 | 25835 | William Wheeler W000342 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
28256 | 28256 | James Wharton W000323 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 30 | |||||||||||||
25541 | 25541 | Thomas Werdel W000298 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
25539 | 25539 | Herman Welker W000269 | sen | ID | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
25538 | 25538 | Philip Welch W000264 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25831 | 25831 | Alvin Weichel W000252 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 13 | |||||||||||||
30117 | 30117 | John Watts W000212 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
28241 | 28241 | Francis Walter W000108 | rep | PA | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
26647 | 26647 | Charles Vursell V000125 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 24 | |||||||||||||
26639 | 26639 | John Vorys V000119 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 12 | |||||||||||||
28222 | 28222 | Carl Vinson V000105 | rep | GA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
26133 | 26133 | Harold Velde V000082 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 18 | |||||||||||||
25536 | 25536 | Albert Vaughn V000077 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 8 | |||||||||||||
27578 | 27578 | James Van Zandt V000069 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
28196 | 28196 | William Van Pelt V000051 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25535 | 25535 | Richard Vail V000003 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25532 | 25532 | Thomas Underwood U000015 | rep | KY | 1951-01-03 | 1951-03-17 | Democrat | 6 | |||||||||||||
28719 | 28719 | James Trimble T000373 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
25530 | 25530 | Harry Towe T000320 | rep | NJ | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28189 | 28189 | Thor Tollefson T000298 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25525 | 25525 | Charles Tobey T000289 | sen | NH | 1951-01-03 | 1953-12-31 | 3 | Republican | |||||||||||||
28180 | 28180 | William Thornberry T000237 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 10 | |||||||||||||
26128 | 26128 | Ruth Thompson T000216 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 9 | |||||||||||||
28696 | 28696 | Clark Thompson T000198 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 9 | |||||||||||||
28684 | 28684 | Albert Thomas T000156 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
31849 | 31849 | Olin Teague T000110 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27025 | 27025 | Dean Taylor T000070 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 33 | |||||||||||||
26628 | 26628 | Henry Talle T000028 | rep | IA | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25519 | 25519 | Robert Taft T000009 | sen | OH | 1951-01-03 | 1953-12-31 | 3 | Republican | |||||||||||||
25516 | 25516 | Boyd Tackett T000005 | rep | AR | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
27563 | 27563 | John Taber T000001 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 38 | |||||||||||||
25819 | 25819 | James Sutton S001087 | rep | TN | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25514 | 25514 | John Sullivan S001056 | rep | MO | 1951-01-03 | 1953-01-03 | Democrat | 11 | |||||||||||||
25510 | 25510 | Lowell Stockman S000936 | rep | OR | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
25505 | 25505 | William Stigler S000923 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
25500 | 25500 | Karl Stefan S000845 | rep | NE | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
32315 | 32315 | Thomas Steed S000829 | rep | OK | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
25815 | 25815 | Thomas Stanley S000797 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
32299 | 32299 | Harley Staggers S000778 | rep | WV | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28170 | 28170 | Katharine St. George S000764 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 29 | |||||||||||||
30090 | 30090 | William Springer S000756 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 22 | |||||||||||||
27543 | 27543 | Brent Spence S000717 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
27016 | 27016 | Wint Smith S000640 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
26616 | 26616 | Lawrence Smith S000585 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
28667 | 28667 | Howard Smith S000554 | rep | VA | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
27527 | 27527 | Frank Smith S000533 | rep | MS | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
28165 | 28165 | George Smathers S000505 | sen | FL | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25491 | 25491 | Edward Sittler S000461 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 23 | |||||||||||||
26607 | 26607 | Sidney Simpson S000437 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 20 | |||||||||||||
27009 | 27009 | Richard Simpson S000436 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 17 | |||||||||||||
31805 | 31805 | Robert Sikes S000406 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
26599 | 26599 | Alfred Sieminski S000405 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 13 | |||||||||||||
26125 | 26125 | Dewey Short S000377 | rep | MO | 1951-01-03 | 1953-01-03 | Republican | 7 | |||||||||||||
28146 | 28146 | Harry Sheppard S000335 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 21 | |||||||||||||
28132 | 28132 | John Shelley S000327 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26592 | 26592 | Timothy Sheehan S000315 | rep | IL | 1951-01-03 | 1953-01-03 | Republican | 11 | |||||||||||||
25806 | 25806 | Paul Shafer S000277 | rep | MI | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27522 | 27522 | Horace Seely-Brown S000224 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
28649 | 28649 | Robert Secrest S000219 | rep | OH | 1951-01-03 | 1953-01-03 | Democrat | 15 | |||||||||||||
26588 | 26588 | Hubert Scudder S000198 | rep | CA | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
26583 | 26583 | Errett Scrivner S000194 | rep | KS | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
30075 | 30075 | Hugh Scott S000174 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
25489 | 25489 | Hardie Scott S000172 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
25486 | 25486 | George Schwabe S000155 | rep | OK | 1951-01-03 | 1953-01-03 | Republican | 1 | |||||||||||||
28124 | 28124 | Paul Schenck S000117 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
30667 | 30667 | John Saylor S000102 | rep | PA | 1951-01-03 | 1953-01-03 | Republican | 26 | |||||||||||||
25483 | 25483 | Lansdale Sasscer S000067 | rep | MD | 1951-01-03 | 1953-01-03 | Democrat | 5 | |||||||||||||
26575 | 26575 | Antoni Sadlak S000009 | rep | CT | 1951-01-03 | 1953-01-03 | Republican | 0 | |||||||||||||
25476 | 25476 | Adolph Sabath S000001 | rep | IL | 1951-01-03 | 1953-01-03 | Democrat | 7 | |||||||||||||
25453 | 25453 | Robert Ross R000453 | rep | NY | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25797 | 25797 | Franklin Roosevelt R000425 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 20 | |||||||||||||
30645 | 30645 | John Rooney R000424 | rep | NY | 1951-01-03 | 1953-01-03 | Democrat | 12 | |||||||||||||
28621 | 28621 | Walter Rogers R000404 | rep | TX | 1951-01-03 | 1953-01-03 | Democrat | 18 | |||||||||||||
26996 | 26996 | Edith Rogers R000392 | rep | MA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
25794 | 25794 | Dwight Rogers R000391 | rep | FL | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29458 | 29458 | Byron Rogers R000389 | rep | CO | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
33722 | 33722 | Peter Rodino R000374 | rep | NJ | 1951-01-03 | 1953-01-03 | Democrat | 10 |
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);