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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20002 | 20002 | Daniel Sutherland S001079 | rep | AK | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
18048 | 18048 | Fred Blackmon B000514 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | -1 | |||||||||||||
18426 | 18426 | Lilius Rainey R000017 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
18874 | 18874 | John Tyson T000455 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19230 | 19230 | William Bowling B000702 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
21083 | 21083 | Edward Almon A000162 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
21341 | 21341 | Lamar Jeffers J000068 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21821 | 21821 | George Huddleston H000903 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
21864 | 21864 | John McDuffie M000427 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
21903 | 21903 | William Oliver O000077 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
22490 | 22490 | William Bankhead B000113 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
23690 | 23690 | Henry Steagall S000820 | rep | AL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
18248 | 18248 | Henderson Jacoway J000041 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
18514 | 18514 | Chester Taylor T000069 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
18520 | 18520 | Samuel Taylor T000100 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19451 | 19451 | William Oldfield O000062 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19507 | 19507 | John Tillman T000276 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20054 | 20054 | Otis Wingo W000635 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21911 | 21911 | Tilman Parks P000075 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
22117 | 22117 | William Driver D000503 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
21623 | 21623 | Henry Ashurst A000319 | sen | AZ | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
27848 | 27848 | Carl Hayden H000385 | rep | AZ | 1921-04-11 | 1923-03-03 | Democrat | 0 | |||||||||||||
18163 | 18163 | John Elston E000161 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18381 | 18381 | John Nolan N000124 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18706 | 18706 | Julius Kahn K000003 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18746 | 18746 | James MacLafferty M000028 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18784 | 18784 | Mae Nolan N000125 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18791 | 18791 | Henry Osborne O000112 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
19031 | 19031 | Walter Lineberger L000331 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
19068 | 19068 | John Raker R000019 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19641 | 19641 | Charles Curry C001000 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20114 | 20114 | Henry Barbour B000126 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20372 | 20372 | Arthur Free F000359 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
20910 | 20910 | Philip Swing S001123 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
23072 | 23072 | Hiram Johnson J000140 | sen | CA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
24537 | 24537 | Clarence Lea L000163 | rep | CA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
19514 | 19514 | William Vaile V000004 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20469 | 20469 | Guy Hardy H000195 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20946 | 20946 | Charles Timberlake T000281 | rep | CO | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
23276 | 23276 | Edward Taylor T000072 | rep | CO | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
19691 | 19691 | Edward Fenn F000072 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19728 | 19728 | James Glynn G000246 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20381 | 20381 | Richard Freeman F000366 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20937 | 20937 | John Tilson T000279 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
21882 | 21882 | Schuyler Merritt M000663 | rep | CT | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
18305 | 18305 | Caleb Layton L000151 | rep | DE | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
18558 | 18558 | Thomas Bayard B000252 | sen | DE | 1922-11-08 | 1923-03-03 | 1 | Democrat | |||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
18591 | 18591 | Frank Clark C000430 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
19110 | 19110 | John Smithwick S000643 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20313 | 20313 | Herbert Drane D000486 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
21963 | 21963 | William Sears S000211 | rep | FL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21977 | 21977 | Park Trammell T000353 | sen | FL | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18389 | 18389 | James Overstreet O000143 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
18553 | 18553 | Thomas Watson W000205 | sen | GA | 1921-04-11 | 1923-03-03 | 3 | Democrat | |||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18803 | 18803 | Frank Park P000051 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 2 | |||||||||||||
18898 | 18898 | James Wise W000650 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 6 | |||||||||||||
19028 | 19028 | Gordon Lee L000194 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19138 | 19138 | William Upshaw U000026 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 5 | |||||||||||||
19582 | 19582 | Thomas Bell B000348 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 9 | |||||||||||||
20265 | 20265 | Charles Crisp C000909 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 3 | |||||||||||||
20630 | 20630 | William Lankford L000082 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 11 | |||||||||||||
20638 | 20638 | William Larsen L000103 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
21033 | 21033 | William Wright W000773 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
21135 | 21135 | Charles Brand B000767 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 8 | |||||||||||||
28207 | 28207 | Carl Vinson V000105 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 10 | |||||||||||||
18039 | 18039 | Henry Baldwin B000088 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18266 | 18266 | Jonah Kalanianaole K000004 | rep | HI | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
17799 | 17799 | William Kenyon K000129 | sen | IA | 1919-05-19 | 1923-03-03 | 2 | Republican | |||||||||||||
18200 | 18200 | James Good G000275 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18513 | 18513 | Burton Sweet S001106 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
18679 | 18679 | Harry Hull H000941 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18872 | 18872 | Horace Towner T000325 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 8 | |||||||||||||
19223 | 19223 | William Boies B000597 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
19338 | 19338 | William Green G000422 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
20204 | 20204 | Cyrenus Cole C000608 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20294 | 20294 | Lester Dickinson D000323 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
20491 | 20491 | Gilbert Haugen H000350 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20608 | 20608 | William Kopp K000314 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20801 | 20801 | Christian Ramseyer R000031 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
22574 | 22574 | Cassius Dowell D000468 | rep | IA | 1921-04-11 | 1923-03-03 | Republican | 7 | |||||||||||||
20394 | 20394 | Burton French F000375 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
20862 | 20862 | Addison Smith S000511 | rep | ID | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18072 | 18072 | Edwin Brooks B000877 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 23 | |||||||||||||
18115 | 18115 | Joseph Cannon C000121 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 18 | |||||||||||||
18133 | 18133 | Ira Copley C000770 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 11 | |||||||||||||
18229 | 18229 | Winnifred Huck H000900 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18242 | 18242 | Clifford Ireland I000030 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 16 | |||||||||||||
18334 | 18334 | James Mann M000104 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18340 | 18340 | William Mason M000228 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | -1 | |||||||||||||
18451 | 18451 | William Rodenberg R000371 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 22 | |||||||||||||
18470 | 18470 | Guy Shaw S000306 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 20 | |||||||||||||
18658 | 18658 | William Graham G000364 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
18754 | 18754 | John McKenzie M000506 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 13 | |||||||||||||
18763 | 18763 | Allen Moore M000890 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 19 | |||||||||||||
18807 | 18807 | John Rainey R000015 | rep | IL | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
18953 | 18953 | Charles Fuller F000407 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 12 |
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);