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 descending
This data as json, copyable, CSV (advanced)
Suggested facets: end, party, end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20333 | 20333 | Félix Dávila D000090 | rep | PR | 1923-12-03 | 1925-03-03 | Unionist | 0 | |||||||||||||
19209 | 19209 | Victor Berger B000407 | rep | WI | 1923-12-03 | 1925-03-03 | Socialist | 5 | |||||||||||||
18570 | 18570 | Sydney Anderson A000233 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
18603 | 18603 | Raymond Cole C000613 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18617 | 18617 | Charles Davis D000093 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18632 | 18632 | Hiram Evans E000243 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18636 | 18636 | Louis Fairfield F000007 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 12 | |||||||||||||
18648 | 18648 | Frederick Fleetwood F000194 | rep | VT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
18651 | 18651 | Israel Foster F000306 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
18659 | 18659 | William Graham G000364 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
18673 | 18673 | William Greene G000430 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
18680 | 18680 | Harry Hull H000941 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18707 | 18707 | Julius Kahn K000003 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
18726 | 18726 | Robert La Follette L000004 | sen | WI | 1923-12-03 | 1925-12-31 | 1 | Republican | |||||||||||||
18728 | 18728 | Oscar Larson L000104 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18729 | 18729 | Robert Leach L000171 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
18734 | 18734 | Edward Little L000349 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18743 | 18743 | Henry Lodge L000393 | sen | MA | 1923-12-03 | 1924-11-09 | 1 | Republican | |||||||||||||
18747 | 18747 | James MacLafferty M000028 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
18755 | 18755 | John McKenzie M000506 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 13 | |||||||||||||
18758 | 18758 | George McLean M000547 | sen | CT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
18770 | 18770 | Merrill Moores M000928 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
18778 | 18778 | Luther Mott M001041 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 32 | |||||||||||||
18783 | 18783 | Sydney Mudd M001060 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
18798 | 18798 | Calvin Paige P000024 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18816 | 18816 | Stuart Reed R000127 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18830 | 18830 | Sidney Roach R000289 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18832 | 18832 | Benjamin Rosenbloom R000441 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
18837 | 18837 | Everett Sanders S000034 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18855 | 18855 | John Smith S000573 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18860 | 18860 | Homer Snyder S000666 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 33 | |||||||||||||
18873 | 18873 | Horace Towner T000325 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
18880 | 18880 | Charles Ward W000129 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 27 | |||||||||||||
18886 | 18886 | John Webster W000240 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
18887 | 18887 | George Wertz W000300 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
18894 | 18894 | Samuel Winslow W000639 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
18906 | 18906 | George Young Y000036 | rep | ND | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18912 | 18912 | Harris Bixler B000493 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 28 | |||||||||||||
18937 | 18937 | Benjamin Fairchild F000004 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
18943 | 18943 | John Fredericks F000358 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
19086 | 19086 | John Rogers R000400 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19101 | 19101 | Frank Scott S000169 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
19115 | 19115 | William Swoope S001126 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 23 | |||||||||||||
19133 | 19133 | Jasper Tincher T000282 | rep | KS | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19144 | 19144 | Edward Voigt V000110 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19164 | 19164 | Arthur Williams W000490 | rep | MI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
19224 | 19224 | William Boies B000597 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
19339 | 19339 | William Green G000422 | rep | IA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19353 | 19353 | Ira Hersey H000544 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19382 | 19382 | Edward King K000200 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 15 | |||||||||||||
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 | |||||||||||||
19464 | 19464 | Henry Rathbone R000068 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
19603 | 19603 | Edward Browne B000955 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
19711 | 19711 | Roy Fitzgerald F000166 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
19766 | 19766 | Andrew Hickey H000560 | rep | IN | 1923-12-03 | 1925-03-03 | Republican | 13 |
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);