legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
498 rows where "end" is on date 1923-03-03 sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20063 | 20063 | Frederick Zihlman Z000007 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18905 | 18905 | George Young Y000036 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
21052 | 21052 | Richard Yates Y000011 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
21045 | 21045 | Adam Wyant W000776 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 22 | |||||||||||||
21039 | 21039 | Harry Wurzbach W000775 | rep | TX | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
21033 | 21033 | William Wright W000773 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19174 | 19174 | Harry Woodyard W000737 | rep | WV | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18557 | 18557 | James Woods W000723 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
25553 | 25553 | Roy Woodruff W000718 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
21025 | 21025 | William Wood W000706 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
18898 | 18898 | James Wise W000650 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18893 | 18893 | Samuel Winslow W000639 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20054 | 20054 | Otis Wingo W000635 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
22000 | 22000 | Riley Wilson W000608 | rep | LA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21014 | 21014 | William Williamson W000553 | rep | SD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20045 | 20045 | Thomas Williams W000542 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 24 | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21008 | 21008 | Guinn Williams W000501 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
23749 | 23749 | Wallace White W000396 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19540 | 19540 | Hays White W000374 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
19162 | 19162 | Loren Wheeler W000339 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 21 | |||||||||||||
18885 | 18885 | John Webster W000240 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
24188 | 24188 | Zebulon Weaver W000230 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
21590 | 21590 | Henry Watson W000201 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
20988 | 20988 | Edward Wason W000185 | rep | NH | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18881 | 18881 | Hallett Ward W000132 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18879 | 18879 | Charles Ward W000129 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 27 | |||||||||||||
19148 | 19148 | Anderson Walters W000109 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18551 | 18551 | Joseph Walsh W000101 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18547 | 18547 | Andrew Volstead V000114 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
18537 | 18537 | Lester Volk V000111 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
19143 | 19143 | Edward Voigt V000110 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
28207 | 28207 | Carl Vinson V000105 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
20970 | 20970 | Albert Vestal V000092 | rep | IN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
19523 | 19523 | William Vare V000071 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19514 | 19514 | William Vaile V000004 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19138 | 19138 | William Upshaw U000026 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20962 | 20962 | Charles Underhill U000006 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18874 | 18874 | John Tyson T000455 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
22817 | 22817 | Clarence Turner T000417 | rep | TN | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
20956 | 20956 | Henry Tucker T000399 | rep | VA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
23715 | 23715 | Allen Treadway T000358 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18872 | 18872 | Horace Towner T000325 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
23299 | 23299 | George Tinkham T000283 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
19132 | 19132 | Jasper Tincher T000282 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20946 | 20946 | Charles Timberlake T000281 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20937 | 20937 | John Tilson T000279 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19507 | 19507 | John Tillman T000276 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18523 | 18523 | Roy Thorpe T000245 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20020 | 20020 | Charles Thompson T000194 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
19128 | 19128 | Robert Thomas T000185 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18522 | 18522 | Peter Ten Eyck T000126 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 28 | |||||||||||||
20920 | 20920 | Henry Temple T000119 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 24 | |||||||||||||
18520 | 18520 | Samuel Taylor T000100 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
22806 | 22806 | James Taylor T000083 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
19117 | 19117 | Herbert Taylor T000080 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
23276 | 23276 | Edward Taylor T000072 | rep | CO | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18514 | 18514 | Chester Taylor T000069 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18865 | 18865 | Peter Tague T000014 | rep | MA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
20910 | 20910 | Philip Swing S001123 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18513 | 18513 | Burton Sweet S001106 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
21572 | 21572 | Fletcher Swank S001089 | rep | OK | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
20002 | 20002 | Daniel Sutherland S001079 | rep | AK | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
24117 | 24117 | Hatton Sumners S001072 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
20902 | 20902 | John Summers S001067 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
22794 | 22794 | Christopher Sullivan S001051 | rep | NY | 1921-04-11 | 1923-03-03 | Democrat | 13 | |||||||||||||
21563 | 21563 | Nathan Strong S001015 | rep | PA | 1921-04-11 | 1923-03-03 | Republican | 27 | |||||||||||||
20892 | 20892 | James Strong S001011 | rep | KS | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18509 | 18509 | Philip Stoll S000951 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18507 | 18507 | Walter Stiness S000927 | rep | RI | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20884 | 20884 | William Stevenson S000895 | rep | SC | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19494 | 19494 | Ambrose Stephens S000855 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18503 | 18503 | Halvor Steenerson S000842 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
19983 | 19983 | Charles Stedman S000827 | rep | NC | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
23690 | 23690 | Henry Steagall S000820 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20879 | 20879 | William Stafford S000777 | rep | WI | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
19969 | 19969 | Elliott Sproul S000758 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
19960 | 19960 | John Speaks S000707 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 12 | |||||||||||||
18859 | 18859 | Homer Snyder S000666 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 33 | |||||||||||||
22419 | 22419 | Bertrand Snell S000652 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 31 | |||||||||||||
19110 | 19110 | John Smithwick S000643 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18854 | 18854 | John Smith S000573 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20862 | 20862 | Addison Smith S000511 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18490 | 18490 | Campbell Slemp S000486 | rep | VA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
18482 | 18482 | Thomas Sisson S000456 | rep | MS | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19484 | 19484 | Nicholas Sinnott S000450 | rep | OR | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
21544 | 21544 | James Sinclair S000442 | rep | ND | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18475 | 18475 | Isaac Siegel S000404 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
20847 | 20847 | Milton Shreve S000387 | rep | PA | 1921-04-11 | 1923-03-03 | Ind. Republican | 25 | |||||||||||||
18471 | 18471 | Samuel Shelton S000328 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18470 | 18470 | Guy Shaw S000306 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
21963 | 21963 | William Sears S000211 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18469 | 18469 | Lon Scott S000181 | rep | TN | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
19100 | 19100 | Frank Scott S000169 | rep | MI | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
20836 | 20836 | Thomas Schall S000113 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 10 |
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);