legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
496 rows where "start" is on date 1917-04-02
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18007 | 18007 | Benjamin Welty W000291 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18013 | 18013 | James Wilson W000593 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
18022 | 18022 | William Wilson W000624 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18024 | 18024 | Teodoro Yangco Y000004 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18029 | 18029 | James Young Y000040 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18046 | 18046 | Fred Blackmon B000514 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18051 | 18051 | Oscar Bland B000542 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18056 | 18056 | George Bowers B000690 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18076 | 18076 | Sherman Burroughs B001138 | rep | NH | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18090 | 18090 | Philip Campbell C000097 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18113 | 18113 | Joseph Cannon C000121 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
18116 | 18116 | Thomas Chandler C000295 | rep | OK | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18120 | 18120 | Walter Chandler C000297 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18122 | 18122 | David Classon C000474 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18131 | 18131 | Ira Copley C000770 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18137 | 18137 | Thomas Crago C000853 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18145 | 18145 | Jaime De Veyra D000276 | rep | PI | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
18155 | 18155 | Thomas Dunn D000553 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 38 | |||||||||||||
18161 | 18161 | John Elston E000161 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18175 | 18175 | Henry Flood F000210 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18187 | 18187 | Joseph Fordney F000271 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 8 | |||||||||||||
18198 | 18198 | James Good G000275 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18204 | 18204 | Norman Gould G000342 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 36 | |||||||||||||
18212 | 18212 | Rufus Hardy H000198 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18222 | 18222 | Frederick Hicks H000564 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18233 | 18233 | James Husted H001005 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 25 | |||||||||||||
18237 | 18237 | Elijah Hutchinson H001012 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18240 | 18240 | Clifford Ireland I000030 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
18246 | 18246 | Henderson Jacoway J000041 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18264 | 18264 | Jonah Kalanianaole K000004 | rep | HI | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18269 | 18269 | Patrick Kelley K000061 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18274 | 18274 | Ambrose Kennedy K000100 | rep | RI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18284 | 18284 | Moses Kinkaid K000221 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18294 | 18294 | Milton Kraus K000323 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18299 | 18299 | Aaron Kreider K000327 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 18 | |||||||||||||
18314 | 18314 | Meyer London L000408 | rep | NY | 1917-04-02 | 1919-03-03 | Socialist | 12 | |||||||||||||
18316 | 18316 | Willfred Lufkin L000503 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
18332 | 18332 | James Mann M000104 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18338 | 18338 | William Mason M000228 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18342 | 18342 | Clifton McArthur M000298 | rep | OR | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18351 | 18351 | William McKinley M000521 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18354 | 18354 | Joseph McLaughlin M000540 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | -1 | |||||||||||||
18369 | 18369 | Franklin Mondell M000852 | rep | WY | 1917-04-02 | 1919-03-03 | Republican | 0 | |||||||||||||
18373 | 18373 | Adolphus Nelson N000029 | rep | WI | 1917-04-02 | 1919-03-03 | Republican | 11 | |||||||||||||
18379 | 18379 | John Nolan N000124 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18387 | 18387 | James Overstreet O000143 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18398 | 18398 | Lemuel Padgett P000012 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18411 | 18411 | Richard Parker P000070 | rep | NJ | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18418 | 18418 | John Peters P000253 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18428 | 18428 | Charles Reavis R000101 | rep | NE | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18449 | 18449 | William Rodenberg R000371 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 22 | |||||||||||||
18452 | 18452 | John Rose R000437 | rep | PA | 1917-04-02 | 1919-03-03 | Republican | 19 | |||||||||||||
18465 | 18465 | William Rucker R000494 | rep | MO | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18473 | 18473 | Isaac Siegel S000404 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 20 | |||||||||||||
18480 | 18480 | Thomas Sisson S000456 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18488 | 18488 | Campbell Slemp S000486 | rep | VA | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18501 | 18501 | Halvor Steenerson S000842 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 9 | |||||||||||||
18505 | 18505 | Walter Stiness S000927 | rep | RI | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18511 | 18511 | Burton Sweet S001106 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18518 | 18518 | Samuel Taylor T000100 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18545 | 18545 | Andrew Volstead V000114 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18549 | 18549 | Joseph Walsh W000101 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 16 | |||||||||||||
18555 | 18555 | James Woods W000723 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 6 | |||||||||||||
18567 | 18567 | Sydney Anderson A000233 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
18579 | 18579 | James Cantrill C000126 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
18589 | 18589 | Frank Clark C000430 | rep | FL | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18614 | 18614 | Charles Davis D000093 | rep | MN | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18622 | 18622 | Henry Dupré D000561 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18628 | 18628 | John Eagan E000001 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18633 | 18633 | Louis Fairfield F000007 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 12 | |||||||||||||
18644 | 18644 | William Fields F000113 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18656 | 18656 | William Graham G000364 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 14 | |||||||||||||
18670 | 18670 | William Greene G000430 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 15 | |||||||||||||
18677 | 18677 | Harry Hull H000941 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18688 | 18688 | Benjamin Humphreys H000960 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
18693 | 18693 | Andrieus Jones J000210 | sen | NM | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18704 | 18704 | Julius Kahn K000003 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
18716 | 18716 | Claude Kitchin K000250 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18725 | 18725 | Robert La Follette L000004 | sen | WI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18731 | 18731 | Edward Little L000349 | rep | KS | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18742 | 18742 | Henry Lodge L000393 | sen | MA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18752 | 18752 | John McKenzie M000506 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 13 | |||||||||||||
18757 | 18757 | George McLean M000547 | sen | CT | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18767 | 18767 | Merrill Moores M000928 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 7 | |||||||||||||
18775 | 18775 | Luther Mott M001041 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 32 | |||||||||||||
18780 | 18780 | Sydney Mudd M001060 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18789 | 18789 | Henry Osborne O000112 | rep | CA | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
18795 | 18795 | Calvin Paige P000024 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18801 | 18801 | Frank Park P000051 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
18805 | 18805 | John Rainey R000015 | rep | IL | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18811 | 18811 | James Reed R000118 | sen | MO | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
18813 | 18813 | Stuart Reed R000127 | rep | WV | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18825 | 18825 | Daniel Riordan R000264 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 11 | |||||||||||||
18834 | 18834 | Everett Sanders S000034 | rep | IN | 1917-04-02 | 1919-03-03 | Republican | 5 | |||||||||||||
18845 | 18845 | Isaac Sherwood S000355 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18852 | 18852 | John Smith S000573 | rep | MI | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18857 | 18857 | Homer Snyder S000666 | rep | NY | 1917-04-02 | 1919-03-03 | Republican | 33 | |||||||||||||
18863 | 18863 | Peter Tague T000014 | rep | MA | 1917-04-02 | 1919-03-03 | Democrat | 10 | |||||||||||||
18870 | 18870 | Horace Towner T000325 | rep | IA | 1917-04-02 | 1919-03-03 | Republican | 8 |
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);