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 rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21850 | 21850 | Frederick Lehlbach L000222 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
21822 | 21822 | George Huddleston H000903 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
21805 | 21805 | Samuel Hill H000607 | rep | WA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21790 | 21790 | Pedro Guevara G000518 | rep | PI | 1923-12-03 | 1925-03-03 | 0 | ||||||||||||||
21783 | 21783 | Anthony Griffin G000457 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 22 | |||||||||||||
21724 | 21724 | Parker Corning C000785 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 28 | |||||||||||||
21714 | 21714 | John Cooper C000757 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 19 | |||||||||||||
21677 | 21677 | Joseph Byrns B001217 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21646 | 21646 | Thomas Blanton B000549 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
21633 | 21633 | Isaac Bacharach B000009 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
21615 | 21615 | William Arnold A000300 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
21608 | 21608 | Abram Andrew A000240 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
21591 | 21591 | Henry Watson W000201 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
21573 | 21573 | Fletcher Swank S001089 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21564 | 21564 | Nathan Strong S001015 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
21551 | 21551 | Gale Stalker S000783 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 37 | |||||||||||||
21545 | 21545 | James Sinclair S000442 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21536 | 21536 | Ashton Shallenberger S000280 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21526 | 21526 | Frank Reid R000145 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
21520 | 21520 | Henry Rainey R000014 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
21505 | 21505 | Heartsill Ragon R000009 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21499 | 21499 | Anning Prall P000495 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
21493 | 21493 | Edward Pou P000474 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21475 | 21475 | Hubert Peavey P000174 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
21469 | 21469 | James Parker P000062 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 29 | |||||||||||||
21453 | 21453 | Frank Oliver O000072 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
21438 | 21438 | John Morehead M000939 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21432 | 21432 | Jacob Milligan M000766 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21425 | 21425 | Thomas McKeown M000511 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21413 | 21413 | Louis McFadden M000434 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
21403 | 21403 | James McClintic M000338 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21390 | 21390 | James Major M000073 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
21384 | 21384 | Ralph Lozier L000489 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21373 | 21373 | George Lindsay L000325 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21365 | 21365 | Jacob Kurtz K000344 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 21 | |||||||||||||
21354 | 21354 | Melville Kelly K000076 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 33 | |||||||||||||
21348 | 21348 | Magnus Johnson J000161 | sen | MN | 1923-12-03 | 1925-03-03 | 2 | Farmer-Labor | |||||||||||||
21342 | 21342 | Lamar Jeffers J000068 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21335 | 21335 | William James J000053 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
21324 | 21324 | Edgar Howard H000836 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21309 | 21309 | William Hastings H000333 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21291 | 21291 | John Garner G000074 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
21275 | 21275 | James Frear F000355 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
21248 | 21248 | George Edmonds E000053 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
21229 | 21229 | Clement Dickinson D000316 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21212 | 21212 | James Connolly C000698 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
21200 | 21200 | John Clarke C000465 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
21179 | 21179 | Thomas Busby B001163 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21169 | 21169 | George Brumm B000978 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
21163 | 21163 | Gordon Browning B000959 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21155 | 21155 | Frederick Britten B000847 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
21144 | 21144 | Clay Briggs B000826 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21136 | 21136 | Charles Brand B000767 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21121 | 21121 | Loring Black B000505 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21113 | 21113 | Carroll Beedy B000307 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21099 | 21099 | William Ayres A000354 | rep | KS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21084 | 21084 | Edward Almon A000162 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21074 | 21074 | Miles Allgood A000156 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21067 | 21067 | Charles Abernethy A000015 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
21026 | 21026 | William Wood W000706 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
21015 | 21015 | William Williamson W000553 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21009 | 21009 | Guinn Williams W000501 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
20995 | 20995 | George Welsh W000289 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20989 | 20989 | Edward Wason W000185 | rep | NH | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20982 | 20982 | Thomas Walsh W000104 | sen | MT | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
20963 | 20963 | Charles Underhill U000006 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20957 | 20957 | Henry Tucker T000399 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
20911 | 20911 | Philip Swing S001123 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
20903 | 20903 | John Summers S001067 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
20863 | 20863 | Addison Smith S000511 | rep | ID | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
20837 | 20837 | Thomas Schall S000113 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
20828 | 20828 | Archie Sanders S000032 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 39 | |||||||||||||
20816 | 20816 | Thomas Robinson R000352 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20802 | 20802 | Christian Ramseyer R000031 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20793 | 20793 | Percy Quin Q000014 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
20783 | 20783 | Fred Purnell P000573 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20754 | 20754 | John Nelson N000039 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20741 | 20741 | John Nelson N000038 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20735 | 20735 | Benjamin Murphy M001089 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 18 | |||||||||||||
20722 | 20722 | Charles Moore M000894 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20715 | 20715 | Charles Mooney M000887 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
20710 | 20710 | Jesse Metcalf M000670 | sen | RI | 1924-11-05 | 1925-03-03 | 2 | Republican | |||||||||||||
20705 | 20705 | James McLaughlin M000539 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
20690 | 20690 | Joe Manlove M000098 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
20686 | 20686 | Samuel Major M000074 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 7 |
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);