legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
408 rows where "start" is on date 1893-08-07 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12514 | 12514 | William Denson D000253 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12740 | 12740 | William Oates O000005 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12838 | 12838 | Louis Turpin T000434 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12942 | 12942 | Richard Clarke C000469 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12947 | 12947 | James Cobb C000549 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
13028 | 13028 | George Harrison H000270 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
13785 | 13785 | Gaston Robbins R000299 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13794 | 13794 | Jesse Stallings S000784 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13826 | 13826 | Joseph Wheeler W000338 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
17549 | 17549 | John Bankhead B000110 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12430 | 12430 | Clifton Breckinridge B000784 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13108 | 13108 | Robert Neill N000025 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
13809 | 13809 | William Terry T000137 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
14057 | 14057 | Philip McCulloch M000391 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
14069 | 14069 | Thomas McRae M000597 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
14292 | 14292 | Hugh Dinsmore D000358 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
14786 | 14786 | John Little L000352 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
16973 | 16973 | Marcus Smith S000589 | rep | AZ | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12470 | 12470 | Anthony Caminetti C000069 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12475 | 12475 | Marion Cannon C000122 | rep | CA | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
12531 | 12531 | Warren English E000189 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12568 | 12568 | Thomas Geary G000113 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12925 | 12925 | William Bowers B000692 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
13329 | 13329 | Samuel Hilborn H000583 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
13384 | 13384 | James Maguire M000059 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
14052 | 14052 | Eugene Loud L000448 | rep | CA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
15696 | 15696 | George Perkins P000232 | sen | CA | 1893-08-07 | 1897-03-03 | 3 | Republican | |||||||||||||
12754 | 12754 | Lafayette Pence P000199 | rep | CO | 1893-08-07 | 1895-03-03 | Populist | 1 | |||||||||||||
13850 | 13850 | John Bell B000341 | rep | CO | 1893-08-07 | 1895-03-03 | Populist | 2 | |||||||||||||
12513 | 12513 | Robert De Forest D000190 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12758 | 12758 | James Pigott P000344 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12795 | 12795 | Lewis Sperry S000732 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
13704 | 13704 | Joseph Hawley H000377 | sen | CT | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14148 | 14148 | Charles Russell R000521 | rep | CT | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
12483 | 12483 | John Causey C000257 | rep | DE | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12586 | 12586 | George Gray G000396 | sen | DE | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12962 | 12962 | Charles Cooper C000746 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
14398 | 14398 | Stephen Mallory M000085 | rep | FL | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12461 | 12461 | Thomas Cabaniss C000001 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12917 | 12917 | James Black B000502 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12976 | 12976 | Charles Crisp C000908 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
13056 | 13056 | Thomas Lawson L000146 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
13101 | 13101 | Charles Moses M001027 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13148 | 13148 | Benjamin Russell R000520 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13189 | 13189 | Henry Turner T000421 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
14389 | 14389 | John Maddox M000040 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
14486 | 14486 | Farish Tate T000046 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
14773 | 14773 | Rufus Lester L000255 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
15601 | 15601 | Leonidas Livingston L000368 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12612 | 12612 | Walter Hayes H000394 | rep | IA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13008 | 13008 | John Gear G000110 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
13313 | 13313 | Alva Hager H000015 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
13447 | 13447 | George Perkins P000233 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
13511 | 13511 | Thomas Updegraff U000019 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
13995 | 13995 | David Henderson H000478 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14761 | 14761 | John Lacey L000010 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
15042 | 15042 | Robert Cousins C000811 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
15083 | 15083 | Jonathan Dolliver D000404 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
15145 | 15145 | William Hepburn H000523 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
15547 | 15547 | John Hull H000942 | rep | IA | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12824 | 12824 | Willis Sweet S001110 | rep | ID | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12412 | 12412 | John Black B000504 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | -1 | |||||||||||||
12484 | 12484 | Robert Childs C000354 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
12522 | 12522 | Allan Durborow D000564 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12552 | 12552 | George Fithian F000162 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 16 | |||||||||||||
12555 | 12555 | William Forman F000275 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 18 | |||||||||||||
12556 | 12556 | Benjamin Funk F000427 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 14 | |||||||||||||
12575 | 12575 | Julius Goldzier G000269 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12632 | 12632 | Thomas Henderson H000489 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12662 | 12662 | Edward Lane L000058 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 17 | |||||||||||||
12682 | 12682 | John McDannold M000401 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12805 | 12805 | William Springer S000757 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12851 | 12851 | Hamilton Wheeler W000335 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
12893 | 12893 | James Aldrich A000082 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
13084 | 13084 | Lawrence McGann M000441 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
13130 | 13130 | Philip Post P000457 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
13354 | 13354 | Andrew Hunter H000980 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | -1 | |||||||||||||
14351 | 14351 | Albert Hopkins H000770 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14530 | 14530 | James Williams W000508 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 19 | |||||||||||||
14721 | 14721 | Robert Hitt H000649 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
14803 | 14803 | Benjamin Marsh M000145 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
15291 | 15291 | George Smith S000541 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 20 | |||||||||||||
18102 | 18102 | Joseph Cannon C000121 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
12437 | 12437 | John Bretz B000807 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12443 | 12443 | Elijah Brookshire B000886 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12446 | 12446 | Jason Brown B000924 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12460 | 12460 | William Bynum B001205 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12498 | 12498 | Charles Conn C000683 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12503 | 12503 | George Cooper C000750 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12592 | 12592 | Thomas Hammond H000134 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12679 | 12679 | Augustus Martin M000167 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
12689 | 12689 | William McNagny M000580 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12828 | 12828 | Arthur Taylor T000065 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12845 | 12845 | Daniel Waugh W000214 | rep | IN | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
13348 | 13348 | William Holman H000732 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
13359 | 13359 | Henry Johnson J000138 | rep | IN | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
12511 | 12511 | John Davis D000115 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 5 |
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);