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
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19780 | 19780 | Claude Hudspeth H000910 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
19806 | 19806 | Charles Kearns K000033 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19821 | 19821 | Edgar Kiess K000168 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
19829 | 19829 | David Kincheloe K000187 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19835 | 19835 | Ole Kvale K000349 | rep | MN | 1923-12-03 | 1925-03-03 | Farmer-Labor | 7 | |||||||||||||
19842 | 19842 | Florian Lampert L000041 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19849 | 19849 | Elmer Leatherwood L000181 | rep | UT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19861 | 19861 | Whitmell Martin M000201 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19875 | 19875 | Magne Michaelson M000690 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19882 | 19882 | John Miller M000739 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19888 | 19888 | Robert Moore M000915 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
19893 | 19893 | William Morgan M000959 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19900 | 19900 | Walter Newton N000079 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19905 | 19905 | David O’Connell O000022 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19909 | 19909 | Jeremiah O’Connell O000023 | rep | RI | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19915 | 19915 | James O’Connor O000028 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19930 | 19930 | Stephen Porter P000447 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
19935 | 19935 | John Quayle Q000008 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19949 | 19949 | Willis Sears S000212 | rep | NE | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19961 | 19961 | John Speaks S000707 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
19965 | 19965 | James Spearing S000708 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19970 | 19970 | Elliott Sproul S000758 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19974 | 19974 | William Sproul S000759 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19984 | 19984 | Charles Stedman S000827 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20003 | 20003 | Daniel Sutherland S001079 | rep | AK | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
20021 | 20021 | Charles Thompson T000194 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20025 | 20025 | Jonathan Wainwright W000023 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
20031 | 20031 | Laurence Watres W000196 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
20035 | 20035 | Royal Weller W000277 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
20046 | 20046 | Thomas Williams W000542 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20055 | 20055 | Otis Wingo W000635 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20064 | 20064 | Frederick Zihlman Z000007 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20084 | 20084 | Richard Aldrich A000084 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20103 | 20103 | James Aswell A000321 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20115 | 20115 | Henry Barbour B000126 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20121 | 20121 | Edward Beers B000312 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
20130 | 20130 | Charles Brand B000766 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
20139 | 20139 | Clark Burdick B001075 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20145 | 20145 | Olger Burtness B001146 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20154 | 20154 | John Cable C000007 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20162 | 20162 | Guy Campbell C000084 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 36 | |||||||||||||
20167 | 20167 | Harry Canfield C000114 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20177 | 20177 | Carl Chindblom C000361 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
20189 | 20189 | Charles Christopherson C000384 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20195 | 20195 | Frank Clague C000401 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20200 | 20200 | Robert Clancy C000412 | rep | MI | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20205 | 20205 | Cyrenus Cole C000608 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20217 | 20217 | James Collier C000630 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20223 | 20223 | Don Colton C000652 | rep | UT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20245 | 20245 | Henry Cooper C000752 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
20266 | 20266 | Charles Crisp C000909 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20276 | 20276 | Frederick Dallinger D000012 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20287 | 20287 | Ewin Davis D000098 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20295 | 20295 | Lester Dickinson D000323 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
20303 | 20303 | Frederick Dominick D000408 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20314 | 20314 | Herbert Drane D000486 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20325 | 20325 | Leonidas Dyer D000591 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
20333 | 20333 | Félix Dávila D000090 | rep | PR | 1923-12-03 | 1925-03-03 | Unionist | 0 | |||||||||||||
20363 | 20363 | John Evans E000247 | rep | MT | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20373 | 20373 | Arthur Free F000359 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20382 | 20382 | Richard Freeman F000366 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20395 | 20395 | Burton French F000375 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20400 | 20400 | James Fulbright F000400 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
20403 | 20403 | Milton Garber G000046 | rep | OK | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
20411 | 20411 | Daniel Garrett G000081 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20417 | 20417 | Ralph Gilbert G000177 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20439 | 20439 | George Graham G000354 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20449 | 20449 | Lindley Hadley H000008 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20463 | 20463 | Thomas Hall H000071 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20470 | 20470 | Guy Hardy H000195 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20492 | 20492 | Gilbert Haugen H000350 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20505 | 20505 | Willis Hawley H000379 | rep | OR | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20512 | 20512 | Homer Hoch H000669 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20523 | 20523 | William Holaday H000708 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
20546 | 20546 | Cordell Hull H000940 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20551 | 20551 | Morton Hull H000944 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20556 | 20556 | William Hull H000946 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 16 | |||||||||||||
20569 | 20569 | Albert Johnson J000114 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20579 | 20579 | Royal Johnson J000173 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20594 | 20594 | Samuel Kendall K000097 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20600 | 20600 | John Ketcham K000151 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20605 | 20605 | Henry Keyes K000161 | sen | NH | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
20609 | 20609 | William Kopp K000314 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20615 | 20615 | Stanley Kunz K000342 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20622 | 20622 | Fiorello La Guardia L000007 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
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 | |||||||||||||
20644 | 20644 | Scott Leavitt L000184 | rep | MT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20659 | 20659 | John Linthicum L000340 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20673 | 20673 | Nicholas Longworth L000433 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20686 | 20686 | Samuel Major M000074 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
20690 | 20690 | Joe Manlove M000098 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20705 | 20705 | James McLaughlin M000539 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20710 | 20710 | Jesse Metcalf M000670 | sen | RI | 1924-11-05 | 1925-03-03 | 2 | Republican | |||||||||||||
20715 | 20715 | Charles Mooney M000887 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
20722 | 20722 | Charles Moore M000894 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20735 | 20735 | Benjamin Murphy M001089 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 18 |
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);