legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1923-12-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20064 | 20064 | Frederick Zihlman Z000007 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
18906 | 18906 | George Young Y000036 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
21053 | 21053 | Richard Yates Y000011 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
21046 | 21046 | Adam Wyant W000776 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
21040 | 21040 | Harry Wurzbach W000775 | rep | TX | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
21034 | 21034 | William Wright W000773 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
24217 | 24217 | Clifton Woodrum W000720 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
25554 | 25554 | Roy Woodruff W000718 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
21026 | 21026 | William Wood W000706 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
18900 | 18900 | Joseph Wolff W000679 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
18899 | 18899 | James Wise W000650 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19552 | 19552 | Charles Winter W000643 | rep | WY | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
18894 | 18894 | Samuel Winslow W000639 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20055 | 20055 | Otis Wingo W000635 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18888 | 18888 | William Wilson W000621 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19549 | 19549 | Thomas Wilson W000617 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
22001 | 22001 | Riley Wilson W000608 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21015 | 21015 | William Williamson W000553 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20046 | 20046 | Thomas Williams W000542 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
21009 | 21009 | Guinn Williams W000501 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
19164 | 19164 | Arthur Williams W000490 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
23750 | 23750 | Wallace White W000396 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19541 | 19541 | Hays White W000374 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
23318 | 23318 | Burton Wheeler W000330 | sen | MT | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18887 | 18887 | George Wertz W000300 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
20995 | 20995 | George Welsh W000289 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20035 | 20035 | Royal Weller W000277 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
19157 | 19157 | Knud Wefald W000251 | rep | MN | 1923-12-03 | 1925-03-03 | Farmer-Labor | 9 | |||||||||||||
18886 | 18886 | John Webster W000240 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
24189 | 24189 | Zebulon Weaver W000230 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
21591 | 21591 | Henry Watson W000201 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20031 | 20031 | Laurence Watres W000196 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
18883 | 18883 | Elton Watkins W000191 | rep | OR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20989 | 20989 | Edward Wason W000185 | rep | NH | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18882 | 18882 | Hallett Ward W000132 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
18880 | 18880 | Charles Ward W000129 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
20025 | 20025 | Jonathan Wainwright W000023 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
19144 | 19144 | Edward Voigt V000110 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22450 | 22450 | Frederick Vinson V000106 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
28208 | 28208 | Carl Vinson V000105 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
20976 | 20976 | Bird Vincent V000101 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20971 | 20971 | Albert Vestal V000092 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19524 | 19524 | William Vare V000071 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19515 | 19515 | William Vaile V000004 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19139 | 19139 | William Upshaw U000026 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21987 | 21987 | Mell Underwood U000012 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
20963 | 20963 | Charles Underhill U000006 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
18875 | 18875 | John Tyson T000455 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
24168 | 24168 | Millard Tydings T000446 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
20957 | 20957 | Henry Tucker T000399 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
23716 | 23716 | Allen Treadway T000358 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21978 | 21978 | Park Trammell T000353 | sen | FL | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18873 | 18873 | Horace Towner T000325 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
23300 | 23300 | George Tinkham T000283 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19133 | 19133 | Jasper Tincher T000282 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20947 | 20947 | Charles Timberlake T000281 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20938 | 20938 | John Tilson T000279 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19508 | 19508 | John Tillman T000276 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20021 | 20021 | Charles Thompson T000194 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19129 | 19129 | Robert Thomas T000185 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
24152 | 24152 | John Thomas T000177 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
20926 | 20926 | Maurice Thatcher T000142 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20921 | 20921 | Henry Temple T000119 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
22807 | 22807 | James Taylor T000083 | rep | TN | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19119 | 19119 | James Taylor T000082 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23277 | 23277 | Edward Taylor T000072 | rep | CO | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18866 | 18866 | Peter Tague T000014 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
27549 | 27549 | John Taber T000001 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
19115 | 19115 | William Swoope S001126 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 23 | |||||||||||||
20911 | 20911 | Philip Swing S001123 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19500 | 19500 | Thaddeus Sweet S001109 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
20017 | 20017 | Claude Swanson S001094 | sen | VA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
21573 | 21573 | Fletcher Swank S001089 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20003 | 20003 | Daniel Sutherland S001079 | rep | AK | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
24118 | 24118 | Hatton Sumners S001072 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20903 | 20903 | John Summers S001067 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
22795 | 22795 | Christopher Sullivan S001051 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
21564 | 21564 | Nathan Strong S001015 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
20893 | 20893 | James Strong S001011 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20885 | 20885 | William Stevenson S000895 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19995 | 19995 | Hubert Stephens S000857 | sen | MS | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19495 | 19495 | Ambrose Stephens S000855 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18861 | 18861 | Charles Stengle S000850 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19984 | 19984 | Charles Stedman S000827 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
23691 | 23691 | Henry Steagall S000820 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21551 | 21551 | Gale Stalker S000783 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 37 | |||||||||||||
19974 | 19974 | William Sproul S000759 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19970 | 19970 | Elliott Sproul S000758 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19965 | 19965 | James Spearing S000708 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19961 | 19961 | John Speaks S000707 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
18860 | 18860 | Homer Snyder S000666 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 33 | |||||||||||||
22420 | 22420 | Bertrand Snell S000652 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 31 | |||||||||||||
19111 | 19111 | John Smithwick S000643 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
18855 | 18855 | John Smith S000573 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20863 | 20863 | Addison Smith S000511 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18848 | 18848 | Frank Sites S000457 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
19485 | 19485 | Nicholas Sinnott S000450 | rep | OR | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
21545 | 21545 | James Sinclair S000442 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20853 | 20853 | Robert Simmons S000419 | rep | NE | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20848 | 20848 | Milton Shreve S000387 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 29 |
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);