legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
480 rows where "start" is on date 1949-01-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33191 | 33191 | Clement Zablocki Z000001 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28749 | 28749 | Stephen Young Y000053 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 0 | |||||||||||||
36448 | 36448 | Sidney Yates Y000013 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25105 | 25105 | Francis Worley W000744 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 18 | |||||||||||||
25567 | 25567 | Roy Woodruff W000718 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25100 | 25100 | Chase Woodhouse W000714 | rep | CT | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25549 | 25549 | John Wood W000699 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
26686 | 26686 | Charles Wolverton W000683 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26145 | 26145 | Jesse Wolcott W000668 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
27050 | 27050 | Gardner Withrow W000663 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
28286 | 28286 | William Winstead W000641 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25838 | 25838 | Joseph Wilson W000604 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25098 | 25098 | George Wilson W000582 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
28276 | 28276 | Earl Wilson W000572 | rep | IN | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
29078 | 29078 | Edwin Willis W000559 | rep | LA | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
29068 | 29068 | John Williams W000517 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
26662 | 26662 | Richard Wigglesworth W000450 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
27040 | 27040 | Roy Wier W000446 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
30748 | 30748 | William Widnall W000445 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
28266 | 28266 | Victor Wickersham W000439 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25097 | 25097 | William Whittington W000430 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
35646 | 35646 | Jamie Whitten W000428 | rep | MS | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25084 | 25084 | Compton White W000361 | rep | ID | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25076 | 25076 | Cecil White W000359 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25543 | 25543 | John Whitaker W000348 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25075 | 25075 | Kenneth Wherry W000344 | sen | NE | 1949-01-03 | 1951-12-31 | 2 | Republican | |||||||||||||
25834 | 25834 | William Wheeler W000342 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25540 | 25540 | Thomas Werdel W000298 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
25073 | 25073 | Richard Welch W000265 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25537 | 25537 | Philip Welch W000264 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25830 | 25830 | Alvin Weichel W000252 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 13 | |||||||||||||
28240 | 28240 | Francis Walter W000108 | rep | PA | 1949-01-03 | 1951-01-03 | Democrat | 20 | |||||||||||||
25060 | 25060 | John Walsh W000100 | rep | IN | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25059 | 25059 | Earl Wagner W000019 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25058 | 25058 | James Wadsworth W000012 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 41 | |||||||||||||
26646 | 26646 | Charles Vursell V000125 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 24 | |||||||||||||
26638 | 26638 | John Vorys V000119 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 12 | |||||||||||||
28221 | 28221 | Carl Vinson V000105 | rep | GA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
26132 | 26132 | Harold Velde V000082 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 18 | |||||||||||||
27577 | 27577 | James Van Zandt V000069 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 22 | |||||||||||||
25531 | 25531 | Thomas Underwood U000015 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
28718 | 28718 | James Trimble T000373 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
25529 | 25529 | Harry Towe T000320 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 9 | |||||||||||||
28188 | 28188 | Thor Tollefson T000298 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28179 | 28179 | William Thornberry T000237 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
28695 | 28695 | Clark Thompson T000198 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 9 | |||||||||||||
25047 | 25047 | John Thomas T000175 | rep | NJ | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
28683 | 28683 | Albert Thomas T000156 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
31848 | 31848 | Olin Teague T000110 | rep | TX | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27024 | 27024 | Dean Taylor T000070 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 33 | |||||||||||||
25040 | 25040 | Anthony Tauriello T000056 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 43 | |||||||||||||
26627 | 26627 | Henry Talle T000028 | rep | IA | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25515 | 25515 | Boyd Tackett T000005 | rep | AR | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
27562 | 27562 | John Taber T000001 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 38 | |||||||||||||
25818 | 25818 | James Sutton S001087 | rep | TN | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
25513 | 25513 | John Sullivan S001056 | rep | MO | 1949-01-03 | 1951-01-03 | Democrat | 11 | |||||||||||||
25509 | 25509 | Lowell Stockman S000936 | rep | OR | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
25504 | 25504 | William Stigler S000923 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
25499 | 25499 | Karl Stefan S000845 | rep | NE | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
32314 | 32314 | Thomas Steed S000829 | rep | OK | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25814 | 25814 | Thomas Stanley S000797 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
32298 | 32298 | Harley Staggers S000778 | rep | WV | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28169 | 28169 | Katharine St. George S000764 | rep | NY | 1949-01-03 | 1951-01-03 | Republican | 29 | |||||||||||||
27542 | 27542 | Brent Spence S000717 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
30700 | 30700 | John Sparkman S000701 | sen | AL | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25039 | 25039 | Andrew Somers S000676 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
27015 | 27015 | Wint Smith S000640 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
29045 | 29045 | Margaret Smith S000590 | sen | ME | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
26615 | 26615 | Lawrence Smith S000585 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
28666 | 28666 | Howard Smith S000554 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25026 | 25026 | Frederick Smith S000536 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 8 | |||||||||||||
28164 | 28164 | George Smathers S000505 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
25020 | 25020 | Hugo Sims S000439 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
26606 | 26606 | Sidney Simpson S000437 | rep | IL | 1949-01-03 | 1951-01-03 | Republican | 20 | |||||||||||||
27008 | 27008 | Richard Simpson S000436 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 17 | |||||||||||||
31804 | 31804 | Robert Sikes S000406 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
26124 | 26124 | Dewey Short S000377 | rep | MO | 1949-01-03 | 1951-01-03 | Republican | 7 | |||||||||||||
28145 | 28145 | Harry Sheppard S000335 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 21 | |||||||||||||
28131 | 28131 | John Shelley S000327 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25805 | 25805 | Paul Shafer S000277 | rep | MI | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
28648 | 28648 | Robert Secrest S000219 | rep | OH | 1949-01-03 | 1951-01-03 | Democrat | 15 | |||||||||||||
26587 | 26587 | Hubert Scudder S000198 | rep | CA | 1949-01-03 | 1951-01-03 | Republican | 1 | |||||||||||||
26582 | 26582 | Errett Scrivner S000194 | rep | KS | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
30074 | 30074 | Hugh Scott S000174 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
25488 | 25488 | Hardie Scott S000172 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
27517 | 27517 | Andrew Schoeppel S000138 | sen | KS | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
30666 | 30666 | John Saylor S000102 | rep | PA | 1949-01-03 | 1951-01-03 | Republican | 26 | |||||||||||||
25482 | 25482 | Lansdale Sasscer S000067 | rep | MD | 1949-01-03 | 1951-01-03 | Democrat | 5 | |||||||||||||
25019 | 25019 | John Sanborn S000029 | rep | ID | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
27503 | 27503 | Leverett Saltonstall S000021 | sen | MA | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25017 | 25017 | George Sadowski S000011 | rep | MI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26574 | 26574 | Antoni Sadlak S000009 | rep | CT | 1949-01-03 | 1951-01-03 | Republican | 0 | |||||||||||||
25475 | 25475 | Adolph Sabath S000001 | rep | IL | 1949-01-03 | 1951-01-03 | Democrat | 7 | |||||||||||||
29027 | 29027 | Richard Russell R000536 | sen | GA | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
30644 | 30644 | John Rooney R000424 | rep | NY | 1949-01-03 | 1951-01-03 | Democrat | 12 | |||||||||||||
26995 | 26995 | Edith Rogers R000392 | rep | MA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
25793 | 25793 | Dwight Rogers R000391 | rep | FL | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
33721 | 33721 | Peter Rodino R000374 | rep | NJ | 1949-01-03 | 1951-01-03 | Democrat | 10 | |||||||||||||
26565 | 26565 | Edward Robeson R000329 | rep | VA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
27495 | 27495 | Absalom Robertson R000317 | sen | VA | 1949-01-03 | 1955-01-03 | 2 | Democrat |
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);