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 1925-12-07 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20065 | 20065 | Frederick Zihlman Z000007 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
21054 | 21054 | Richard Yates Y000011 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
21047 | 21047 | Adam Wyant W000776 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 31 | |||||||||||||
21041 | 21041 | Harry Wurzbach W000775 | rep | TX | 1925-12-07 | 1927-03-04 | Republican | 14 | |||||||||||||
21035 | 21035 | William Wright W000773 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19175 | 19175 | Harry Woodyard W000737 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
24218 | 24218 | Clifton Woodrum W000720 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
25555 | 25555 | Roy Woodruff W000718 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
21027 | 21027 | William Wood W000706 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
20059 | 20059 | John Wolverton W000684 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19553 | 19553 | Charles Winter W000643 | rep | WY | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20056 | 20056 | Otis Wingo W000635 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19550 | 19550 | Thomas Wilson W000617 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
22002 | 22002 | Riley Wilson W000608 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21016 | 21016 | William Williamson W000553 | rep | SD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20047 | 20047 | Thomas Williams W000542 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 24 | |||||||||||||
21010 | 21010 | Guinn Williams W000501 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 13 | |||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19165 | 19165 | Arthur Williams W000490 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
25085 | 25085 | William Whittington W000430 | rep | MS | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20039 | 20039 | Joseph Whitehead W000400 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
23751 | 23751 | Wallace White W000396 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19542 | 19542 | Hays White W000374 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
19163 | 19163 | Loren Wheeler W000339 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 21 | |||||||||||||
20996 | 20996 | George Welsh W000289 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20036 | 20036 | Royal Weller W000277 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 21 | |||||||||||||
25061 | 25061 | Richard Welch W000265 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19158 | 19158 | Knud Wefald W000251 | rep | MN | 1925-12-07 | 1927-03-04 | Farmer-Labor | 9 | |||||||||||||
24190 | 24190 | Zebulon Weaver W000230 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
21592 | 21592 | Henry Watson W000201 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
20032 | 20032 | Laurence Watres W000196 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
20990 | 20990 | Edward Wason W000185 | rep | NH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22824 | 22824 | Lindsay Warren W000166 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
19156 | 19156 | Francis Warren W000164 | sen | WY | 1925-12-07 | 1929-11-24 | 2 | Republican | |||||||||||||
19149 | 19149 | Anderson Walters W000109 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 20 | |||||||||||||
20983 | 20983 | Thomas Walsh W000104 | sen | MT | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20026 | 20026 | Jonathan Wainwright W000023 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 25 | |||||||||||||
19145 | 19145 | Edward Voigt V000110 | rep | WI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
22451 | 22451 | Frederick Vinson V000106 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 9 | |||||||||||||
28209 | 28209 | Carl Vinson V000105 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
20977 | 20977 | Bird Vincent V000101 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20972 | 20972 | Albert Vestal V000092 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
19525 | 19525 | William Vare V000071 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19516 | 19516 | William Vaile V000004 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19140 | 19140 | William Upshaw U000026 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
19511 | 19511 | Ralph Updike U000020 | rep | IN | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
21988 | 21988 | Mell Underwood U000012 | rep | OH | 1925-12-07 | 1927-03-04 | Democrat | 11 | |||||||||||||
20964 | 20964 | Charles Underhill U000006 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
19136 | 19136 | Lawrence Tyson T000456 | sen | TN | 1925-12-07 | 1929-12-31 | 2 | Democrat | |||||||||||||
24169 | 24169 | Millard Tydings T000446 | rep | MD | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
20958 | 20958 | Henry Tucker T000399 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 10 | |||||||||||||
23717 | 23717 | Allen Treadway T000358 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19135 | 19135 | Harold Tolley T000299 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 34 | |||||||||||||
23301 | 23301 | George Tinkham T000283 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19134 | 19134 | Jasper Tincher T000282 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 7 | |||||||||||||
20948 | 20948 | Charles Timberlake T000281 | rep | CO | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20939 | 20939 | John Tilson T000279 | rep | CT | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19509 | 19509 | John Tillman T000276 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
22441 | 22441 | Lloyd Thurston T000257 | rep | IA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20022 | 20022 | Charles Thompson T000194 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19130 | 19130 | Robert Thomas T000185 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
24153 | 24153 | John Thomas T000177 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19121 | 19121 | Harry Thayer T000146 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
20927 | 20927 | Maurice Thatcher T000142 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20922 | 20922 | Henry Temple T000119 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 25 | |||||||||||||
22808 | 22808 | James Taylor T000083 | rep | TN | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19120 | 19120 | James Taylor T000082 | rep | WV | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
19118 | 19118 | Herbert Taylor T000080 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 8 | |||||||||||||
23278 | 23278 | Edward Taylor T000072 | rep | CO | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
27550 | 27550 | John Taber T000001 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 36 | |||||||||||||
19116 | 19116 | William Swoope S001126 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 23 | |||||||||||||
20912 | 20912 | Philip Swing S001123 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
19501 | 19501 | Thaddeus Sweet S001109 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 32 | |||||||||||||
19114 | 19114 | Joshua Swartz S001097 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
21574 | 21574 | Fletcher Swank S001089 | rep | OK | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20004 | 20004 | Daniel Sutherland S001079 | rep | AK | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
24119 | 24119 | Hatton Sumners S001072 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20904 | 20904 | John Summers S001067 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
22796 | 22796 | Christopher Sullivan S001051 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 13 | |||||||||||||
19498 | 19498 | James Strother S001024 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
21565 | 21565 | Nathan Strong S001015 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 27 | |||||||||||||
20894 | 20894 | James Strong S001011 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
19997 | 19997 | George Stobbs S000931 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20886 | 20886 | William Stevenson S000895 | rep | SC | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
19496 | 19496 | Ambrose Stephens S000855 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19985 | 19985 | Charles Stedman S000827 | rep | NC | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
23692 | 23692 | Henry Steagall S000820 | rep | AL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
21552 | 21552 | Gale Stalker S000783 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 37 | |||||||||||||
19975 | 19975 | William Sproul S000759 | rep | KS | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19971 | 19971 | Elliott Sproul S000758 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
19966 | 19966 | James Spearing S000708 | rep | LA | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19962 | 19962 | John Speaks S000707 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 12 | |||||||||||||
19113 | 19113 | John Sosnowski S000680 | rep | MI | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
25027 | 25027 | Andrew Somers S000676 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
22421 | 22421 | Bertrand Snell S000652 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 31 | |||||||||||||
19112 | 19112 | John Smithwick S000643 | rep | FL | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
20864 | 20864 | Addison Smith S000511 | rep | ID | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
19486 | 19486 | Nicholas Sinnott S000450 | rep | OR | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
21546 | 21546 | James Sinclair S000442 | rep | ND | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20854 | 20854 | Robert Simmons S000419 | rep | NE | 1925-12-07 | 1927-03-04 | Republican | 6 |
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);