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 state descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19552 | 19552 | Charles Winter W000643 | rep | WY | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
19812 | 19812 | John Kendrick K000098 | sen | WY | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18563 | 18563 | Robert Allen A000144 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
18730 | 18730 | Thomas Lilly L000311 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18816 | 18816 | Stuart Reed R000127 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18832 | 18832 | Benjamin Rosenbloom R000441 | rep | WV | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19119 | 19119 | James Taylor T000082 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23066 | 23066 | George Johnson J000132 | rep | WV | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
26067 | 26067 | Matthew Neely N000023 | sen | WV | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18726 | 18726 | Robert La Follette L000004 | sen | WI | 1923-12-03 | 1925-12-31 | 1 | Republican | |||||||||||||
19144 | 19144 | Edward Voigt V000110 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
19199 | 19199 | Joseph Beck B000291 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 7 | |||||||||||||
19209 | 19209 | Victor Berger B000407 | rep | WI | 1923-12-03 | 1925-03-03 | Socialist | 5 | |||||||||||||
19603 | 19603 | Edward Browne B000955 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 8 | |||||||||||||
19842 | 19842 | Florian Lampert L000041 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20245 | 20245 | Henry Cooper C000752 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20754 | 20754 | John Nelson N000039 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
21275 | 21275 | James Frear F000355 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
21475 | 21475 | Hubert Peavey P000174 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
22394 | 22394 | George Schneider S000137 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
22759 | 22759 | John Schafer S000111 | rep | WI | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
18886 | 18886 | John Webster W000240 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19667 | 19667 | Clarence Dill D000345 | sen | WA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19882 | 19882 | John Miller M000739 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20449 | 20449 | Lindley Hadley H000008 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20569 | 20569 | Albert Johnson J000114 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20903 | 20903 | John Summers S001067 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
21805 | 21805 | Samuel Hill H000607 | rep | WA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
18648 | 18648 | Frederick Fleetwood F000194 | rep | VT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19284 | 19284 | Porter Dale D000009 | sen | VT | 1923-12-03 | 1927-03-04 | 3 | Republican | |||||||||||||
19739 | 19739 | Frank Greene G000425 | sen | VT | 1923-12-03 | 1929-03-03 | 1 | Republican | |||||||||||||
22606 | 22606 | Ernest Gibson G000158 | rep | VT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18675 | 18675 | James Hooker H000759 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
19292 | 19292 | Joseph Deal D000169 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19346 | 19346 | Thomas Harrison H000277 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19461 | 19461 | George Peery P000186 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19888 | 19888 | Robert Moore M000915 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
20017 | 20017 | Claude Swanson S001094 | sen | VA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
20957 | 20957 | Henry Tucker T000399 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22321 | 22321 | Andrew Montague M000861 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
24217 | 24217 | Clifton Woodrum W000720 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
24356 | 24356 | Patrick Drewry D000496 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
24745 | 24745 | Schuyler Bland B000545 | rep | VA | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19849 | 19849 | Elmer Leatherwood L000181 | rep | UT | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20223 | 20223 | Don Colton C000652 | rep | UT | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
21843 | 21843 | William King K000216 | sen | UT | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
18748 | 18748 | Earle Mayfield M000281 | sen | TX | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19218 | 19218 | Eugene Black B000495 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
19590 | 19590 | John Box B000710 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
19780 | 19780 | Claude Hudspeth H000910 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 16 | |||||||||||||
20411 | 20411 | Daniel Garrett G000081 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21009 | 21009 | Guinn Williams W000501 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 13 | |||||||||||||
21040 | 21040 | Harry Wurzbach W000775 | rep | TX | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
21144 | 21144 | Clay Briggs B000826 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
21291 | 21291 | John Garner G000074 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 15 | |||||||||||||
21646 | 21646 | Thomas Blanton B000549 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
22067 | 22067 | James Buchanan B001006 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
22386 | 22386 | Morgan Sanders S000037 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22640 | 22640 | John Jones J000236 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 18 | |||||||||||||
23911 | 23911 | Luther Johnson J000159 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23948 | 23948 | Fritz Lanham L000076 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
24118 | 24118 | Hatton Sumners S001072 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
24316 | 24316 | Thomas Connally C000684 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 11 | |||||||||||||
24580 | 24580 | Joseph Mansfield M000112 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
27439 | 27439 | Samuel Rayburn R000082 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
18833 | 18833 | William Salmon S000019 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19328 | 19328 | Finis Garrett G000082 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 9 | |||||||||||||
19706 | 19706 | Hubert Fisher F000149 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 10 | |||||||||||||
20287 | 20287 | Ewin Davis D000098 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
20546 | 20546 | Cordell Hull H000940 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
21163 | 21163 | Gordon Browning B000959 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 8 | |||||||||||||
21677 | 21677 | Joseph Byrns B001217 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
22723 | 22723 | Samuel McReynolds M000598 | rep | TN | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
22807 | 22807 | James Taylor T000083 | rep | TN | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
24608 | 24608 | Kenneth McKellar M000499 | sen | TN | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
27460 | 27460 | Brazilla Reece R000108 | rep | TN | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20189 | 20189 | Charles Christopherson C000384 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
20579 | 20579 | Royal Johnson J000173 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
21015 | 21015 | William Williamson W000553 | rep | SD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18745 | 18745 | William Logan L000406 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
20303 | 20303 | Frederick Dominick D000408 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20885 | 20885 | William Stevenson S000895 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21873 | 21873 | John McSwain M000604 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
22083 | 22083 | James Byrnes B001215 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 2 | |||||||||||||
22169 | 22169 | Allard Gasque G000092 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23482 | 23482 | Hampton Fulmer F000417 | rep | SC | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19909 | 19909 | Jeremiah O’Connell O000023 | rep | RI | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
20084 | 20084 | Richard Aldrich A000084 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20139 | 20139 | Clark Burdick B001075 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
23012 | 23012 | Peter Gerry G000141 | sen | RI | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
20333 | 20333 | Félix Dávila D000090 | rep | PR | 1923-12-03 | 1925-03-03 | Unionist | 0 | |||||||||||||
19720 | 19720 | Isauro Gabaldon G000001 | rep | PI | 1923-12-03 | 1925-03-03 | 0 | ||||||||||||||
21790 | 21790 | Pedro Guevara G000518 | rep | PI | 1923-12-03 | 1925-03-03 | 0 | ||||||||||||||
18605 | 18605 | William Croll C000923 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 14 | |||||||||||||
18606 | 18606 | Herbert Cummings C000987 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 17 | |||||||||||||
18655 | 18655 | Samuel Glatfelter G000234 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 22 | |||||||||||||
18848 | 18848 | Frank Sites S000457 | rep | PA | 1923-12-03 | 1925-03-03 | Democrat | 19 | |||||||||||||
18887 | 18887 | George Wertz W000300 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 20 | |||||||||||||
18912 | 18912 | Harris Bixler B000493 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 28 | |||||||||||||
19035 | 19035 | James Magee M000046 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 35 |
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);