legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
495 rows where "start" is on date 1923-12-03 sorted by party_affiliations
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18974 | 18974 | Frederick Gillett G000201 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18991 | 18991 | John Hill H000597 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18993 | 18993 | William Jarrett J000061 | rep | HI | 1923-12-03 | 1925-03-03 | Democrat | -1 | |||||||||||||
19003 | 19003 | Ben Johnson J000118 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19007 | 19007 | Oscar Keller K000057 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19018 | 19018 | John Langley L000072 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19029 | 19029 | Gordon Lee L000194 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19032 | 19032 | Walter Lineberger L000331 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19035 | 19035 | James Magee M000046 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19039 | 19039 | Melvin McLaughlin M000541 | rep | NE | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19043 | 19043 | Ogden Mills M000776 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19048 | 19048 | Cleveland Newton N000075 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19052 | 19052 | Francis Patterson P000114 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19056 | 19056 | Nathan Perlman P000239 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19058 | 19058 | Thomas Phillips P000314 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 26 | |||||||||||||
19069 | 19069 | John Raker R000019 | rep | CA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19086 | 19086 | John Rogers R000400 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19094 | 19094 | Arthur Rouse R000466 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19101 | 19101 | Frank Scott S000169 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19111 | 19111 | John Smithwick S000643 | rep | FL | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19115 | 19115 | William Swoope S001126 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 23 | |||||||||||||
19119 | 19119 | James Taylor T000082 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19129 | 19129 | Robert Thomas T000185 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19133 | 19133 | Jasper Tincher T000282 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19139 | 19139 | William Upshaw U000026 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19144 | 19144 | Edward Voigt V000110 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19157 | 19157 | Knud Wefald W000251 | rep | MN | 1923-12-03 | 1925-03-03 | Farmer-Labor | 9 | |||||||||||||
19164 | 19164 | Arthur Williams W000490 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19180 | 19180 | Harry Hawes H000362 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
19195 | 19195 | Daniel Anthony A000261 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19199 | 19199 | Joseph Beck B000291 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19204 | 19204 | James Begg B000314 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
19209 | 19209 | Victor Berger B000407 | rep | WI | 1923-12-03 | 1925-03-03 | Socialist | 5 | |||||||||||||
19218 | 19218 | Eugene Black B000495 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19224 | 19224 | William Boies B000597 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19231 | 19231 | William Bowling B000702 | rep | AL | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19253 | 19253 | Thomas Butler B001192 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19284 | 19284 | Porter Dale D000009 | sen | VT | 1923-12-03 | 1927-03-04 | 3 | Republican | |||||||||||||
19288 | 19288 | Martin Davey D000080 | rep | OH | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
19292 | 19292 | Joseph Deal D000169 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19297 | 19297 | Charles Faust F000047 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19303 | 19303 | Louis Frothingham F000395 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19313 | 19313 | James Gallivan G000024 | rep | MA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
19316 | 19316 | Frank Gardner G000053 | rep | IN | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19328 | 19328 | Finis Garrett G000082 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19339 | 19339 | William Green G000422 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19346 | 19346 | Thomas Harrison H000277 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19353 | 19353 | Ira Hersey H000544 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19357 | 19357 | Everette Howard H000837 | rep | OK | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19359 | 19359 | Meyer Jacobstein J000040 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 38 | |||||||||||||
19371 | 19371 | Everett Kent K000124 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 30 | |||||||||||||
19375 | 19375 | John Kindred K000191 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19382 | 19382 | Edward King K000200 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
19390 | 19390 | Ladislas Lazaro L000153 | rep | LA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19394 | 19394 | Bill Lowrey L000484 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19398 | 19398 | Homer Lyon L000543 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19403 | 19403 | Clarence MacGregor M000009 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 41 | |||||||||||||
19415 | 19415 | Martin Madden M000038 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19422 | 19422 | Walter Magee M000049 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19433 | 19433 | John Morin M000961 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 34 | |||||||||||||
19436 | 19436 | John Morrow M001004 | rep | NM | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19452 | 19452 | William Oldfield O000062 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19461 | 19461 | George Peery P000186 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19464 | 19464 | Henry Rathbone R000068 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
19467 | 19467 | James Reed R000119 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19475 | 19475 | Thomas Rubey R000491 | rep | MO | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
19485 | 19485 | Nicholas Sinnott S000450 | rep | OR | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19495 | 19495 | Ambrose Stephens S000855 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19500 | 19500 | Thaddeus Sweet S001109 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
19508 | 19508 | John Tillman T000276 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19515 | 19515 | William Vaile V000004 | rep | CO | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19524 | 19524 | William Vare V000071 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19541 | 19541 | Hays White W000374 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19549 | 19549 | Thomas Wilson W000617 | rep | MS | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
19552 | 19552 | Charles Winter W000643 | rep | WY | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
19565 | 19565 | Theodore Burton B001159 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 22 | |||||||||||||
19583 | 19583 | Thomas Bell B000348 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19590 | 19590 | John Box B000710 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19603 | 19603 | Edward Browne B000955 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19612 | 19612 | John Carew C000142 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
19619 | 19619 | John Casey C000223 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
19633 | 19633 | Louis Cramton C000870 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19642 | 19642 | Charles Curry C001000 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19653 | 19653 | Stephen Dempsey D000229 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 40 | |||||||||||||
19661 | 19661 | Edward Denison D000237 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
19667 | 19667 | Clarence Dill D000345 | sen | WA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19670 | 19670 | Thomas Doyle D000483 | rep | IL | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19680 | 19680 | Richard Elliott E000127 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19692 | 19692 | Edward Fenn F000072 | rep | CT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19701 | 19701 | Simeon Fess F000096 | sen | OH | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19706 | 19706 | Hubert Fisher F000149 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
19711 | 19711 | Roy Fitzgerald F000166 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
19720 | 19720 | Isauro Gabaldon G000001 | rep | PI | 1923-12-03 | 1925-03-03 | 0 | ||||||||||||||
19739 | 19739 | Frank Greene G000425 | sen | VT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19748 | 19748 | William Griest G000456 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19758 | 19758 | William Hammer H000123 | rep | NC | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19766 | 19766 | Andrew Hickey H000560 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
19772 | 19772 | Robert Howell H000868 | sen | NE | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
19774 | 19774 | Grant Hudson H000908 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
19780 | 19780 | Claude Hudspeth H000910 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 16 |
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);