legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "start" is on date 1929-04-15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20067 | 20067 | Frederick Zihlman Z000007 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
21059 | 21059 | Thomas Yon Y000021 | rep | FL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21056 | 21056 | Richard Yates Y000011 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | -1 | |||||||||||||
21049 | 21049 | Adam Wyant W000776 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
21043 | 21043 | Harry Wurzbach W000775 | rep | TX | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
21037 | 21037 | William Wright W000773 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
24220 | 24220 | Clifton Woodrum W000720 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
25557 | 25557 | Roy Woodruff W000718 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
21029 | 21029 | William Wood W000706 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
26676 | 26676 | Charles Wolverton W000683 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
24208 | 24208 | James Wolfenden W000678 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
21020 | 21020 | Effiegene Wingo W000634 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
22004 | 22004 | Riley Wilson W000608 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21018 | 21018 | William Williamson W000553 | rep | SD | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
21012 | 21012 | Guinn Williams W000501 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
26652 | 26652 | Richard Wigglesworth W000450 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
25087 | 25087 | William Whittington W000430 | rep | MS | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21600 | 21600 | James Whitley W000420 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 38 | |||||||||||||
20041 | 20041 | Joseph Whitehead W000400 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
23753 | 23753 | Wallace White W000396 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23319 | 23319 | Burton Wheeler W000330 | sen | MT | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
20998 | 20998 | George Welsh W000289 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20038 | 20038 | Royal Weller W000277 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
25063 | 25063 | Richard Welch W000265 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
21594 | 21594 | Henry Watson W000201 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20034 | 20034 | Laurence Watres W000196 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20992 | 20992 | Edward Wason W000185 | rep | NH | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
22826 | 22826 | Lindsay Warren W000166 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 1 | |||||||||||||
23315 | 23315 | David Walsh W000097 | sen | MA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
20030 | 20030 | Lewis Walker W000063 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
28211 | 28211 | Carl Vinson V000105 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
20979 | 20979 | Bird Vincent V000101 | rep | MI | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20974 | 20974 | Albert Vestal V000092 | rep | IN | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
24708 | 24708 | Arthur Vandenberg V000025 | sen | MI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21990 | 21990 | Mell Underwood U000012 | rep | OH | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
20966 | 20966 | Charles Underhill U000006 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
21983 | 21983 | Charles Turpin T000433 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
20960 | 20960 | Henry Tucker T000399 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 10 | |||||||||||||
23719 | 23719 | Allen Treadway T000358 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
21979 | 21979 | Park Trammell T000353 | sen | FL | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21975 | 21975 | John Townsend T000335 | sen | DE | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
23303 | 23303 | George Tinkham T000283 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20950 | 20950 | Charles Timberlake T000281 | rep | CO | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20941 | 20941 | John Tilson T000279 | rep | CT | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
22443 | 22443 | Lloyd Thurston T000257 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20024 | 20024 | Charles Thompson T000194 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20929 | 20929 | Maurice Thatcher T000142 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20924 | 20924 | Henry Temple T000119 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
22810 | 22810 | James Taylor T000083 | rep | TN | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
23280 | 23280 | Edward Taylor T000072 | rep | CO | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
24134 | 24134 | Malcolm Tarver T000045 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
27552 | 27552 | John Taber T000001 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
20914 | 20914 | Philip Swing S001123 | rep | CA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
21579 | 21579 | Jesse Swick S001114 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
20018 | 20018 | Claude Swanson S001094 | sen | VA | 1929-04-15 | 1933-03-03 | 1 | Democrat | |||||||||||||
20908 | 20908 | Charles Swanson S001093 | rep | IA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
24121 | 24121 | Hatton Sumners S001072 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20906 | 20906 | John Summers S001067 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20899 | 20899 | Patrick Sullivan S001059 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
22798 | 22798 | Christopher Sullivan S001051 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
21567 | 21567 | Nathan Strong S001015 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
20896 | 20896 | James Strong S001011 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20000 | 20000 | Ulysses Stone S000964 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19999 | 19999 | George Stobbs S000931 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20888 | 20888 | William Stevenson S000895 | rep | SC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19996 | 19996 | Hubert Stephens S000857 | sen | MS | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
19989 | 19989 | Leslie Steele S000835 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19987 | 19987 | Charles Stedman S000827 | rep | NC | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
23694 | 23694 | Henry Steagall S000820 | rep | AL | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21554 | 21554 | Gale Stalker S000783 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 37 | |||||||||||||
20880 | 20880 | William Stafford S000777 | rep | WI | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
19977 | 19977 | William Sproul S000759 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19973 | 19973 | Elliott Sproul S000758 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19968 | 19968 | James Spearing S000708 | rep | LA | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
19964 | 19964 | John Speaks S000707 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 12 | |||||||||||||
20870 | 20870 | Charles Sparks S000703 | rep | KS | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
25029 | 25029 | Andrew Somers S000676 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20868 | 20868 | Donald Snow S000659 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
22423 | 22423 | Bertrand Snell S000652 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
23673 | 23673 | Joseph Smith S000580 | rep | WV | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
20866 | 20866 | Addison Smith S000511 | rep | ID | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
19959 | 19959 | Charles Sloan S000491 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
22776 | 22776 | William Sirovich S000452 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 14 | |||||||||||||
21548 | 21548 | James Sinclair S000442 | rep | ND | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
19954 | 19954 | Albert Simms S000420 | rep | NM | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20856 | 20856 | Robert Simmons S000419 | rep | NE | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20851 | 20851 | Milton Shreve S000387 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
23338 | 23338 | Hugh Shott S000381 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
26116 | 26116 | Dewey Short S000377 | rep | MO | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
23239 | 23239 | Henrik Shipstead S000369 | sen | MN | 1929-04-15 | 1935-01-03 | 1 | Farmer-Labor | |||||||||||||
19953 | 19953 | Joseph Shaffer S000278 | rep | VA | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20843 | 20843 | Conrad Selvig S000236 | rep | MN | 1929-04-15 | 1931-03-03 | Republican | 9 | |||||||||||||
20840 | 20840 | Francis Seiberling S000229 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 14 | |||||||||||||
22769 | 22769 | George Seger S000228 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 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);