legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
409 rows where "start" is on date 1901-12-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14173 | 14173 | Charles Snodgrass S000654 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14176 | 14176 | William Stark S000811 | rep | NE | 1901-12-02 | 1903-03-03 | Populist | 4 | |||||||||||||
14184 | 14184 | George Steele S000830 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14188 | 14188 | James Stewart S000911 | rep | NJ | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14190 | 14190 | John Stewart S000916 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 21 | |||||||||||||
14194 | 14194 | James Stokes S000947 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14195 | 14195 | Frederic Storm S000974 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14196 | 14196 | Edward Swann S001090 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14201 | 14201 | William Talbert T000016 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14205 | 14205 | Robert Tayler T000061 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 18 | |||||||||||||
14207 | 14207 | Arthur Tompkins T000302 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 17 | |||||||||||||
14208 | 14208 | Emmett Tompkins T000307 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
14209 | 14209 | George Wagoner W000022 | rep | MO | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
14211 | 14211 | Edgar Weeks W000243 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14214 | 14214 | Charles Wheeler W000331 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14215 | 14215 | James White W000379 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14217 | 14217 | Robert Wilcox W000459 | rep | HI | 1901-12-02 | 1903-03-03 | -1 | ||||||||||||||
14219 | 14219 | Samuel Woods W000726 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14220 | 14220 | Dudley Wooten W000740 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14223 | 14223 | James Young Y000041 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
14242 | 14242 | Thomas Ball B000101 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14249 | 14249 | Maecenas Benton B000397 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14252 | 14252 | Vincent Boreing B000637 | rep | KY | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14255 | 14255 | Phanor Breazeale B000781 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14258 | 14258 | Henry Burk B001085 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14260 | 14260 | James Butler B001178 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14262 | 14262 | John Cassingham C000239 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
14266 | 14266 | Charles Cochran C000562 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14270 | 14270 | William Connell C000687 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14274 | 14274 | William Cowherd C000825 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14279 | 14279 | Joseph Crowley C000943 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 19 | |||||||||||||
14284 | 14284 | Robert Davis D000132 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14287 | 14287 | Federico Degetau D000196 | rep | PR | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
14296 | 14296 | Hugh Dinsmore D000358 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14299 | 14299 | John Dougherty D000447 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14301 | 14301 | William Douglas D000458 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 14 | |||||||||||||
14304 | 14304 | Alvin Evans E000232 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 20 | |||||||||||||
14309 | 14309 | Robert Foerderer F000232 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
14314 | 14314 | George Foster F000303 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14320 | 14320 | Henry Gibson G000161 | rep | TN | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14323 | 14323 | Joseph Gill G000189 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 16 | |||||||||||||
14329 | 14329 | Charles Gillet G000199 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 29 | |||||||||||||
14331 | 14331 | Daniel Gooch G000273 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14339 | 14339 | Francis Griffith G000468 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14345 | 14345 | Charles Hildebrant H000585 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
14355 | 14355 | Albert Hopkins H000770 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14363 | 14363 | James Kehoe K000045 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14365 | 14365 | Alfred Kittredge K000255 | sen | SD | 1901-12-02 | 1903-03-03 | 3 | Republican | |||||||||||||
14368 | 14368 | Theodore Kluttz K000275 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14370 | 14370 | Thomas Kyle K000355 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14377 | 14377 | Asbury Latimer L000114 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14386 | 14386 | Chester Long L000412 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
14393 | 14393 | John Maddox M000040 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14395 | 14395 | William Mahoney M000069 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14404 | 14404 | George McClellan M000331 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14414 | 14414 | Victor Metcalf M000672 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14418 | 14418 | Robert Miers M000700 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14421 | 14421 | Stephen Morgan M000957 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
14431 | 14431 | Rice Pierce P000337 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14444 | 14444 | Samuel Powers P000492 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14448 | 14448 | John Rhea R000182 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14458 | 14458 | James Richardson R000222 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14463 | 14463 | Edward Robb R000296 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
14467 | 14467 | James Robinson R000338 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14469 | 14469 | Bernard Rodey R000372 | rep | NM | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
14471 | 14471 | Robert Scarborough S000107 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14478 | 14478 | William Skiles S000466 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 14 | |||||||||||||
14490 | 14490 | Farish Tate T000046 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14499 | 14499 | John Thayer T000149 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14502 | 14502 | Lot Thomas T000179 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14504 | 14504 | Charles Thompson T000196 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14508 | 14508 | Thomas Tongue T000309 | rep | OR | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14514 | 14514 | Henry Van Voorhis V000062 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 15 | |||||||||||||
14518 | 14518 | Willard Vandiver V000032 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 14 | |||||||||||||
14524 | 14524 | Vespasian Warner W000158 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
14526 | 14526 | William Warnock W000161 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14532 | 14532 | James Williams W000508 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 20 | |||||||||||||
14537 | 14537 | Charles Wright W000756 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 15 | |||||||||||||
14542 | 14542 | Charles Dick D000302 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 19 | |||||||||||||
14552 | 14552 | Robert Adams A000044 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14567 | 14567 | Joseph Babcock B000004 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14570 | 14570 | Jacob Beidler B000317 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 20 | |||||||||||||
14578 | 14578 | Roswell Bishop B000489 | rep | MI | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14581 | 14581 | Edmond Blackburn B000507 | rep | NC | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14584 | 14584 | Justin Bowersock B000693 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14587 | 14587 | Sydney Bowie B000695 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14593 | 14593 | Webster Brown B000946 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14600 | 14600 | Elmer Burkett B001103 | rep | NE | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14622 | 14622 | George Cromer C000924 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14635 | 14635 | Alston Dayton D000163 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14638 | 14638 | Elias Deemer D000186 | rep | PA | 1901-12-02 | 1903-03-03 | Republican | 16 | |||||||||||||
14647 | 14647 | Blackburn Dovener D000461 | rep | WV | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14660 | 14660 | Loren Fletcher F000202 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14669 | 14669 | George Gilbert G000174 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14682 | 14682 | Charles Grosvenor G000497 | rep | OH | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14698 | 14698 | Thomas Hedge H000441 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14704 | 14704 | James Hemenway H000467 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14725 | 14725 | Robert Hitt H000649 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14754 | 14754 | John Ketcham K000152 | rep | NY | 1901-12-02 | 1903-03-03 | Republican | 18 | |||||||||||||
14765 | 14765 | John Lacey L000010 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 6 |
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);