legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
493 rows where "end" is on date 1925-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20003 | 20003 | Daniel Sutherland S001079 | rep | AK | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
18875 | 18875 | John Tyson T000455 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18988 | 18988 | James Heflin H000446 | sen | AL | 1920-11-03 | 1925-03-03 | 2 | Democrat | |||||||||||||
19231 | 19231 | William Bowling B000702 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21074 | 21074 | Miles Allgood A000156 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21084 | 21084 | Edward Almon A000162 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21342 | 21342 | Lamar Jeffers J000068 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21822 | 21822 | George Huddleston H000903 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
21865 | 21865 | John McDuffie M000427 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21904 | 21904 | William Oliver O000077 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
22491 | 22491 | William Bankhead B000113 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
23691 | 23691 | Henry Steagall S000820 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
27871 | 27871 | Joseph Hill H000598 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18838 | 18838 | Lewis Sawyer S000090 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19452 | 19452 | William Oldfield O000062 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19467 | 19467 | James Reed R000119 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19508 | 19508 | John Tillman T000276 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20055 | 20055 | Otis Wingo W000635 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
21505 | 21505 | Heartsill Ragon R000009 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21912 | 21912 | Tilman Parks P000075 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
22118 | 22118 | William Driver D000503 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
27849 | 27849 | Carl Hayden H000385 | rep | AZ | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
18707 | 18707 | Julius Kahn K000003 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
18747 | 18747 | James MacLafferty M000028 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
18785 | 18785 | Mae Nolan N000125 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18792 | 18792 | Henry Osborne O000112 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
18943 | 18943 | John Fredericks F000358 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19032 | 19032 | Walter Lineberger L000331 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19069 | 19069 | John Raker R000019 | rep | CA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19642 | 19642 | Charles Curry C001000 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20115 | 20115 | Henry Barbour B000126 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20373 | 20373 | Arthur Free F000359 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20911 | 20911 | Philip Swing S001123 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
24538 | 24538 | Clarence Lea L000163 | rep | CA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19060 | 19060 | Lawrence Phipps P000317 | sen | CO | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19515 | 19515 | William Vaile V000004 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20470 | 20470 | Guy Hardy H000195 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20947 | 20947 | Charles Timberlake T000281 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
23277 | 23277 | Edward Taylor T000072 | rep | CO | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18788 | 18788 | Patrick O’Sullivan O000123 | rep | CT | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19692 | 19692 | Edward Fenn F000072 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20382 | 20382 | Richard Freeman F000366 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20938 | 20938 | John Tilson T000279 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21883 | 21883 | Schuyler Merritt M000663 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
17545 | 17545 | Lewis Ball B000100 | sen | DE | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18571 | 18571 | William Boyce B000712 | rep | DE | 1923-12-03 | 1925-03-03 | Democrat | 0 | |||||||||||||
18592 | 18592 | Frank Clark C000430 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19111 | 19111 | John Smithwick S000643 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20314 | 20314 | Herbert Drane D000486 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21964 | 21964 | William Sears S000211 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18765 | 18765 | Robert Moore M000914 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
18804 | 18804 | Frank Park P000051 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18899 | 18899 | James Wise W000650 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19029 | 19029 | Gordon Lee L000194 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19139 | 19139 | William Upshaw U000026 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19583 | 19583 | Thomas Bell B000348 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
20266 | 20266 | Charles Crisp C000909 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20631 | 20631 | William Lankford L000082 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
20639 | 20639 | William Larsen L000103 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
21034 | 21034 | William Wright W000773 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21136 | 21136 | Charles Brand B000767 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
28208 | 28208 | Carl Vinson V000105 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
18993 | 18993 | William Jarrett J000061 | rep | HI | 1923-12-03 | 1925-03-03 | Democrat | -1 | |||||||||||||
18632 | 18632 | Hiram Evans E000243 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18680 | 18680 | Harry Hull H000941 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18873 | 18873 | Horace Towner T000325 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19224 | 19224 | William Boies B000597 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19234 | 19234 | Smith Brookhart B000873 | sen | IA | 1922-01-01 | 1925-03-03 | 2 | Republican | |||||||||||||
19339 | 19339 | William Green G000422 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20205 | 20205 | Cyrenus Cole C000608 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20295 | 20295 | Lester Dickinson D000323 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
20492 | 20492 | Gilbert Haugen H000350 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20609 | 20609 | William Kopp K000314 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20802 | 20802 | Christian Ramseyer R000031 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20816 | 20816 | Thomas Robinson R000352 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
22575 | 22575 | Cassius Dowell D000468 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20395 | 20395 | Burton French F000375 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20863 | 20863 | Addison Smith S000511 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17829 | 17829 | Joseph McCormick M000369 | sen | IL | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18574 | 18574 | James Buckley B001027 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
18659 | 18659 | William Graham G000364 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
18755 | 18755 | John McKenzie M000506 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
18760 | 18760 | Edward Miller M000723 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 22 | |||||||||||||
18764 | 18764 | Allen Moore M000890 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 19 | |||||||||||||
18808 | 18808 | John Rainey R000015 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18954 | 18954 | Charles Fuller F000407 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
18957 | 18957 | Frank Funk F000428 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19382 | 19382 | Edward King K000200 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
19415 | 19415 | Martin Madden M000038 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19464 | 19464 | Henry Rathbone R000068 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
19661 | 19661 | Edward Denison D000237 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
19670 | 19670 | Thomas Doyle D000483 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19875 | 19875 | Magne Michaelson M000690 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19970 | 19970 | Elliott Sproul S000758 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20046 | 20046 | Thomas Williams W000542 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20177 | 20177 | Carl Chindblom C000361 | rep | IL | 1923-12-03 | 1925-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);