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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
19935 | 19935 | John Quayle Q000008 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19965 | 19965 | James Spearing S000708 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19984 | 19984 | Charles Stedman S000827 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20035 | 20035 | Royal Weller W000277 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
20055 | 20055 | Otis Wingo W000635 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20103 | 20103 | James Aswell A000321 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20167 | 20167 | Harry Canfield C000114 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20200 | 20200 | Robert Clancy C000412 | rep | MI | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20217 | 20217 | James Collier C000630 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20266 | 20266 | Charles Crisp C000909 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20287 | 20287 | Ewin Davis D000098 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
20363 | 20363 | John Evans E000247 | rep | MT | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20400 | 20400 | James Fulbright F000400 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
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 | |||||||||||||
20475 | 20475 | William Harris H000259 | sen | GA | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20546 | 20546 | Cordell Hull H000940 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20615 | 20615 | Stanley Kunz K000342 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
20659 | 20659 | John Linthicum L000340 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20686 | 20686 | Samuel Major M000074 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
20715 | 20715 | Charles Mooney M000887 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
20793 | 20793 | Percy Quin Q000014 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
20813 | 20813 | Joseph Robinson R000347 | sen | AR | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
20885 | 20885 | William Stevenson S000895 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20957 | 20957 | Henry Tucker T000399 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
20982 | 20982 | Thomas Walsh W000104 | sen | MT | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
21009 | 21009 | Guinn Williams W000501 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
21034 | 21034 | William Wright W000773 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21067 | 21067 | Charles Abernethy A000015 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
21099 | 21099 | William Ayres A000354 | rep | KS | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21121 | 21121 | Loring Black B000505 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21136 | 21136 | Charles Brand B000767 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21144 | 21144 | Clay Briggs B000826 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21163 | 21163 | Gordon Browning B000959 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21179 | 21179 | Thomas Busby B001163 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21229 | 21229 | Clement Dickinson D000316 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21291 | 21291 | John Garner G000074 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
21309 | 21309 | William Hastings H000333 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21324 | 21324 | Edgar Howard H000836 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21342 | 21342 | Lamar Jeffers J000068 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21373 | 21373 | George Lindsay L000325 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21384 | 21384 | Ralph Lozier L000489 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
21390 | 21390 | James Major M000073 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
21403 | 21403 | James McClintic M000338 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21425 | 21425 | Thomas McKeown M000511 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21432 | 21432 | Jacob Milligan M000766 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
21438 | 21438 | John Morehead M000939 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21453 | 21453 | Frank Oliver O000072 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
21493 | 21493 | Edward Pou P000474 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21499 | 21499 | Anning Prall P000495 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
21505 | 21505 | Heartsill Ragon R000009 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21520 | 21520 | Henry Rainey R000014 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 20 | |||||||||||||
21536 | 21536 | Ashton Shallenberger S000280 | rep | NE | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21573 | 21573 | Fletcher Swank S001089 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21615 | 21615 | William Arnold A000300 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 23 | |||||||||||||
21646 | 21646 | Thomas Blanton B000549 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
21677 | 21677 | Joseph Byrns B001217 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21724 | 21724 | Parker Corning C000785 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 28 | |||||||||||||
21783 | 21783 | Anthony Griffin G000457 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 22 | |||||||||||||
21805 | 21805 | Samuel Hill H000607 | rep | WA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
21873 | 21873 | John McSwain M000604 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21904 | 21904 | William Oliver O000077 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
21912 | 21912 | Tilman Parks P000075 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21943 | 21943 | William Rogers R000408 | rep | NH | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21952 | 21952 | John Sandlin S000043 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21964 | 21964 | William Sears S000211 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21987 | 21987 | Mell Underwood U000012 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
22001 | 22001 | Riley Wilson W000608 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22054 | 22054 | John Boylan B000726 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
22067 | 22067 | James Buchanan B001006 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22083 | 22083 | James Byrnes B001215 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
22095 | 22095 | William Connery C000694 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
22118 | 22118 | William Driver D000503 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
22161 | 22161 | Stephen Gambrill G000035 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
22169 | 22169 | Allard Gasque G000092 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
22194 | 22194 | Arthur Greenwood G000437 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
22222 | 22222 | Byron Harrison H000265 | sen | MS | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22321 | 22321 | Andrew Montague M000861 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22344 | 22344 | John O’Connor O000030 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
22386 | 22386 | Morgan Sanders S000037 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22410 | 22410 | Morris Sheppard S000337 | sen | TX | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
22450 | 22450 | Frederick Vinson V000106 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
22491 | 22491 | William Bankhead B000113 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22614 | 22614 | Thomas Goldsborough G000265 | rep | MD | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
22640 | 22640 | John Jones J000236 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
22723 | 22723 | Samuel McReynolds M000598 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22795 | 22795 | Christopher Sullivan S001051 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
22932 | 22932 | Ross Collins C000642 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 5 |
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);