legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
446 rows where "end" is on date 1909-03-03
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15319 | 15319 | John Stewart S000917 | sen | VT | 1908-01-01 | 1909-03-03 | 1 | Republican | |||||||||||||
15328 | 15328 | De Alexander A000091 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 36 | |||||||||||||
15334 | 15334 | Amos Allen A000112 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15336 | 15336 | Charles Barclay B000135 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 21 | |||||||||||||
15339 | 15339 | George Bartlett B000203 | rep | NV | 1907-12-02 | 1909-03-03 | Democrat | 0 | |||||||||||||
15342 | 15342 | Joseph Bennett B000378 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15349 | 15349 | Henry Boutell B000672 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15353 | 15353 | Eaton Bowers B000689 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15362 | 15362 | Walter Brownlow B000962 | rep | TN | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15366 | 15366 | Adam Byrd B001207 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15373 | 15373 | William Calderhead C000026 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15380 | 15380 | Adin Capron C000135 | rep | RI | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15384 | 15384 | Pleasant Chapman C000315 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 24 | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15390 | 15390 | William Cocks C000578 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15393 | 15393 | Ralph Cole C000612 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15395 | 15395 | Joel Cook C000718 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15399 | 15399 | Allen Cooper C000745 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 23 | |||||||||||||
15402 | 15402 | Harry Coudrey C000805 | rep | MO | 1907-12-02 | 1909-03-03 | Republican | 12 | |||||||||||||
15405 | 15405 | William Craig C000861 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15414 | 15414 | Francis Cushman C001018 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15417 | 15417 | Albert Dawson D000150 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15427 | 15427 | David De Armond D000167 | rep | MO | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15430 | 15430 | Edwin Denby D000232 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15432 | 15432 | Gerrit Diekema D000336 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15434 | 15434 | Albert Douglas D000449 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15436 | 15436 | Cyrus Durey D000567 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 25 | |||||||||||||
15439 | 15439 | Don Edwards E000065 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15444 | 15444 | William Ellis E000138 | rep | OR | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15448 | 15448 | William Englebright E000183 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15451 | 15451 | Jacob Fassett F000042 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 33 | |||||||||||||
15454 | 15454 | Otto Foelker F000231 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15457 | 15457 | William Foulkrod F000318 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15465 | 15465 | Charles Fowler F000320 | rep | NJ | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15470 | 15470 | Joseph Gaines G000008 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15476 | 15476 | Washington Gardner G000062 | rep | MI | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15480 | 15480 | John Gill G000188 | rep | MD | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15484 | 15484 | Oscar Gillespie G000198 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 12 | |||||||||||||
15489 | 15489 | Herman Goebel G000251 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15498 | 15498 | Joseph Graff G000351 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 16 | |||||||||||||
15504 | 15504 | William Graham G000363 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 29 | |||||||||||||
15512 | 15512 | James Griggs G000473 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15516 | 15516 | Weldon Heyburn H000554 | sen | ID | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15520 | 15520 | Edmund Hinshaw H000639 | rep | NE | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15527 | 15527 | William Howard H000848 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
15535 | 15535 | Benjamin Howell H000857 | rep | NJ | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15537 | 15537 | William Hubbard H000891 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15543 | 15543 | George Huff H000911 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 22 | |||||||||||||
15554 | 15554 | John Hull H000942 | rep | IA | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15563 | 15563 | Joseph Johnston J000193 | sen | AL | 1907-12-02 | 1909-03-03 | 3 | Democrat | |||||||||||||
15571 | 15571 | Joseph Keifer K000048 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15575 | 15575 | John Keliher K000055 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
15579 | 15579 | James Kennedy K000106 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 18 | |||||||||||||
15584 | 15584 | Charles Knapp K000279 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 28 | |||||||||||||
15587 | 15587 | Gustav Küstermann K000346 | rep | WI | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15590 | 15590 | Tulio Larrinaga L000102 | rep | PR | 1907-12-02 | 1909-03-03 | Unionist | 0 | |||||||||||||
15594 | 15594 | Francis Lassiter L000106 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15597 | 15597 | Charles Law L000124 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15608 | 15608 | Leonidas Livingston L000368 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15615 | 15615 | William Lorimer L000444 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
15622 | 15622 | William Lovering L000465 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 14 | |||||||||||||
15625 | 15625 | Frank Lowden L000472 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
15632 | 15632 | Harry Maynard M000283 | rep | VA | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15636 | 15636 | Samuel McEnery M000429 | sen | LA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15639 | 15639 | Duncan McKinlay M000518 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15645 | 15645 | James McLachlan M000532 | rep | CA | 1907-12-02 | 1909-03-03 | Republican | 7 | |||||||||||||
15651 | 15651 | James Miller M000733 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15667 | 15667 | Sydney Mudd M001059 | rep | MD | 1907-12-02 | 1909-03-03 | Republican | 5 | |||||||||||||
15671 | 15671 | Thomas Nicholls N000089 | rep | PA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15673 | 15673 | Joseph O’Connell O000026 | rep | MA | 1907-12-02 | 1909-03-03 | Democrat | 10 | |||||||||||||
15675 | 15675 | Pablo Ocampo O000020 | rep | PI | 1907-12-02 | 1909-03-03 | 0 | ||||||||||||||
15678 | 15678 | Jacob Olcott O000059 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 15 | |||||||||||||
15685 | 15685 | Herbert Parsons P000088 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 13 | |||||||||||||
15688 | 15688 | James Patterson P000118 | rep | SC | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15694 | 15694 | George Pearre P000163 | rep | MD | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
15698 | 15698 | George Perkins P000232 | sen | CA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
15703 | 15703 | James Perkins P000234 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 32 | |||||||||||||
15710 | 15710 | William Reeder R000131 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 6 | |||||||||||||
15715 | 15715 | Charles Reid R000142 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
15718 | 15718 | John Reynolds R000176 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 19 | |||||||||||||
15721 | 15721 | Joseph Rhinock R000185 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15727 | 15727 | Gordon Russell R000526 | rep | TX | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15732 | 15732 | Charles Scott S000166 | rep | KS | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15737 | 15737 | Howard Snapp S000650 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 11 | |||||||||||||
15744 | 15744 | George Southwick S000691 | rep | NY | 1907-12-02 | 1909-03-03 | Republican | 23 | |||||||||||||
15752 | 15752 | Nehemiah Sperry S000733 | rep | CT | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15759 | 15759 | Thomas Spight S000734 | rep | MS | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
15764 | 15764 | Isaac Stephenson S000863 | sen | WI | 1907-12-02 | 1909-03-03 | 3 | Republican | |||||||||||||
15766 | 15766 | George Sturgiss S001049 | rep | WV | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15768 | 15768 | John Swasey S001098 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15777 | 15777 | James Tawney T000060 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 1 | |||||||||||||
15784 | 15784 | Charles Thomas T000159 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15788 | 15788 | William Thomas T000186 | rep | OH | 1907-12-02 | 1909-03-03 | Republican | 19 | |||||||||||||
15794 | 15794 | Charles Tirrell T000287 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 4 | |||||||||||||
15796 | 15796 | William Tou Velle T000318 | rep | OH | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
15800 | 15800 | Robert Wallace W000082 | rep | AR | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
15809 | 15809 | Irving Wanger W000122 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15812 | 15812 | Charles Washburn W000171 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
15816 | 15816 | Charles Weisse W000259 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15818 | 15818 | Nelson Wheeler W000340 | rep | PA | 1907-12-02 | 1909-03-03 | Republican | 28 |
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);