legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where "end" is on date 1921-03-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20062 | 20062 | Frederick Zihlman Z000007 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
18030 | 18030 | James Young Y000040 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18904 | 18904 | George Young Y000036 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
21051 | 21051 | Richard Yates Y000011 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18025 | 18025 | Teodoro Yangco Y000004 | rep | PI | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
21032 | 21032 | William Wright W000773 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19173 | 19173 | Harry Woodyard W000737 | rep | WV | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
18556 | 18556 | James Woods W000723 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
21024 | 21024 | William Wood W000706 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18897 | 18897 | James Wise W000650 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18892 | 18892 | Samuel Winslow W000639 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20053 | 20053 | Otis Wingo W000635 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18023 | 18023 | William Wilson W000624 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
21999 | 21999 | Riley Wilson W000608 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
20044 | 20044 | Thomas Williams W000542 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
21006 | 21006 | James Wickersham W000438 | rep | AK | 1919-05-19 | 1921-03-03 | Republican | 0 | |||||||||||||
23748 | 23748 | Wallace White W000396 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
19539 | 19539 | Hays White W000374 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
19161 | 19161 | Loren Wheeler W000339 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 21 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18008 | 18008 | Benjamin Welty W000291 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18884 | 18884 | John Webster W000240 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18004 | 18004 | Edwin Webb W000231 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
24187 | 24187 | Zebulon Weaver W000230 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17995 | 17995 | Walter Watson W000206 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19536 | 19536 | James Watson W000203 | sen | IN | 1916-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
21589 | 21589 | Henry Watson W000201 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17991 | 17991 | John Watkins W000193 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20987 | 20987 | Edward Wason W000185 | rep | NH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18878 | 18878 | Charles Ward W000129 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
19147 | 19147 | Anderson Walters W000109 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | -1 | |||||||||||||
18550 | 18550 | Joseph Walsh W000101 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 16 | |||||||||||||
25048 | 25048 | James Wadsworth W000012 | sen | NY | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
18546 | 18546 | Andrew Volstead V000114 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
18536 | 18536 | Lester Volk V000111 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19142 | 19142 | Edward Voigt V000110 | rep | WI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
28206 | 28206 | Carl Vinson V000105 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
20969 | 20969 | Albert Vestal V000092 | rep | IN | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17983 | 17983 | William Venable V000086 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19522 | 19522 | William Vare V000071 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19513 | 19513 | William Vaile V000004 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19137 | 19137 | William Upshaw U000026 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
18534 | 18534 | Oscar Underwood U000013 | sen | AL | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
23714 | 23714 | Allen Treadway T000358 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18871 | 18871 | Horace Towner T000325 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
23298 | 23298 | George Tinkham T000283 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 11 | |||||||||||||
19131 | 19131 | Jasper Tincher T000282 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 7 | |||||||||||||
20945 | 20945 | Charles Timberlake T000281 | rep | CO | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20936 | 20936 | John Tilson T000279 | rep | CT | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
19506 | 19506 | John Tillman T000276 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17977 | 17977 | Joseph Thompson T000210 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
20019 | 20019 | Charles Thompson T000194 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
19127 | 19127 | Robert Thomas T000185 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17029 | 17029 | Charles Thomas T000160 | sen | CO | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20919 | 20919 | Henry Temple T000119 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
18519 | 18519 | Samuel Taylor T000100 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
22805 | 22805 | James Taylor T000083 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
23275 | 23275 | Edward Taylor T000072 | rep | CO | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18864 | 18864 | Peter Tague T000014 | rep | MA | 1919-05-19 | 1921-03-03 | Democrat | 10 | |||||||||||||
17973 | 17973 | King Swope S001129 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17972 | 17972 | Charles Swindall S001121 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
18512 | 18512 | Burton Sweet S001106 | rep | IA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
24116 | 24116 | Hatton Sumners S001072 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
20901 | 20901 | John Summers S001067 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
22793 | 22793 | Christopher Sullivan S001051 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
21562 | 21562 | Nathan Strong S001015 | rep | PA | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
20891 | 20891 | James Strong S001011 | rep | KS | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18508 | 18508 | Philip Stoll S000951 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 6 | |||||||||||||
18506 | 18506 | Walter Stiness S000927 | rep | RI | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20883 | 20883 | William Stevenson S000895 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19493 | 19493 | Ambrose Stephens S000855 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18502 | 18502 | Halvor Steenerson S000842 | rep | MN | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
19982 | 19982 | Charles Stedman S000827 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
23689 | 23689 | Henry Steagall S000820 | rep | AL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
18491 | 18491 | Selden Spencer S000730 | sen | MO | 1918-01-01 | 1921-03-03 | 3 | Republican | |||||||||||||
18858 | 18858 | Homer Snyder S000666 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 33 | |||||||||||||
22418 | 22418 | Bertrand Snell S000652 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
19490 | 19490 | Reed Smoot S000644 | sen | UT | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19109 | 19109 | John Smithwick S000643 | rep | FL | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
16979 | 16979 | Marcus Smith S000589 | sen | AZ | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
16969 | 16969 | John Smith S000577 | sen | MD | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
18853 | 18853 | John Smith S000573 | rep | MI | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
16965 | 16965 | Hoke Smith S000551 | sen | GA | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
19184 | 19184 | Frank Smith S000534 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 17 | |||||||||||||
22786 | 22786 | Ellison Smith S000530 | sen | SC | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
20861 | 20861 | Addison Smith S000511 | rep | ID | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
17955 | 17955 | John Small S000500 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18489 | 18489 | Campbell Slemp S000486 | rep | VA | 1919-05-19 | 1921-03-03 | Republican | 9 | |||||||||||||
18481 | 18481 | Thomas Sisson S000456 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19483 | 19483 | Nicholas Sinnott S000450 | rep | OR | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
21543 | 21543 | James Sinclair S000442 | rep | ND | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17944 | 17944 | Thetus Sims S000441 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 8 |
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);