legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
438 rows where "end" is on date 1907-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14945 | 14945 | Frank Waskey W000184 | rep | AK | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14589 | 14589 | Sydney Bowie B000695 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
15309 | 15309 | Ariosto Wiley W000466 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
16332 | 16332 | Henry Clayton C000495 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16544 | 16544 | William Richardson R000227 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
16607 | 16607 | George Taylor T000078 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17555 | 17555 | John Bankhead B000110 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
17583 | 17583 | John Burnett B001121 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
18529 | 18529 | Oscar Underwood U000013 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
18980 | 18980 | James Heflin H000446 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14792 | 14792 | John Little L000352 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
15010 | 15010 | Stephen Brundidge B000979 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15714 | 15714 | Charles Reid R000142 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15799 | 15799 | Robert Wallace W000082 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
16067 | 16067 | Robert Macon M000035 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
16358 | 16358 | John Floyd F000222 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
20808 | 20808 | Joseph Robinson R000347 | rep | AR | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
16976 | 16976 | Marcus Smith S000589 | rep | AZ | 1905-12-04 | 1907-03-03 | Democrat | 0 | |||||||||||||
14674 | 14674 | James Gillett G000202 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15447 | 15447 | William Englebright E000183 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15638 | 15638 | Duncan McKinlay M000518 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
15644 | 15644 | James McLachlan M000532 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
16124 | 16124 | James Needham N000021 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
16182 | 16182 | Sylvester Smith S000614 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
16426 | 16426 | Joseph Knowland K000291 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
17252 | 17252 | Everis Hayes H000389 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
18698 | 18698 | Julius Kahn K000003 | rep | CA | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
14122 | 14122 | Thomas Patterson P000130 | sen | CO | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14592 | 14592 | Franklin Brooks B000878 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
14730 | 14730 | Herschel Hogg H000703 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14986 | 14986 | Robert Bonynge B000623 | rep | CO | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
15202 | 15202 | George Lilley L000308 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15751 | 15751 | Nehemiah Sperry S000733 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
16002 | 16002 | Edward Henry H000505 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
16006 | 16006 | Edwin Higgins H000578 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
17278 | 17278 | Ebenezer Hill H000591 | rep | CT | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
15015 | 15015 | Hiram Burton B001151 | rep | DE | 1905-12-04 | 1907-03-03 | Republican | 0 | |||||||||||||
15184 | 15184 | William Lamar L000031 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
16992 | 16992 | Stephen Sparkman S000702 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
18583 | 18583 | Frank Clark C000430 | rep | FL | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
14779 | 14779 | Rufus Lester L000255 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15199 | 15199 | Elijah Lewis L000281 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
15511 | 15511 | James Griggs G000473 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
15526 | 15526 | William Howard H000848 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
15607 | 15607 | Leonidas Livingston L000368 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
15883 | 15883 | William Brantley B000770 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 11 | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16278 | 16278 | Charles Bartlett B000199 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
16654 | 16654 | Thomas Hardwick H000193 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 10 | |||||||||||||
17048 | 17048 | William Adamson A000051 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
18386 | 18386 | James Overstreet O000143 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
19020 | 19020 | Gordon Lee L000194 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
19574 | 19574 | Thomas Bell B000348 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
18258 | 18258 | Jonah Kalanianaole K000004 | rep | HI | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
14700 | 14700 | Thomas Hedge H000441 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14767 | 14767 | John Lacey L000010 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14983 | 14983 | Benjamin Birdsall B000481 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
15032 | 15032 | James Conner C000690 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
15048 | 15048 | Robert Cousins C000811 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
15088 | 15088 | Jonathan Dolliver D000404 | sen | IA | 1901-03-04 | 1907-03-03 | 2 | Republican | |||||||||||||
15151 | 15151 | William Hepburn H000523 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
15416 | 15416 | Albert Dawson D000150 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
15553 | 15553 | John Hull H000942 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
16013 | 16013 | Elbert Hubbard H000882 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 11 | |||||||||||||
16189 | 16189 | Walter Smith S000623 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
20483 | 20483 | Gilbert Haugen H000350 | rep | IA | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
13939 | 13939 | Fred Dubois D000509 | sen | ID | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
20388 | 20388 | Burton French F000375 | rep | ID | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
14643 | 14643 | Frank Dickson D000329 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 23 | |||||||||||||
14727 | 14727 | Robert Hitt H000649 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
14808 | 14808 | Benjamin Marsh M000145 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 14 | |||||||||||||
14824 | 14824 | Anthony Michalek M000691 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14870 | 14870 | Zeno Rives R000286 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 21 | |||||||||||||
14949 | 14949 | Charles Wharton W000322 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 4 | |||||||||||||
15062 | 15062 | Shelby Cullom C000973 | sen | IL | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15179 | 15179 | Philip Knopf K000289 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 7 | |||||||||||||
15213 | 15213 | Charles McGavin M000444 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
15297 | 15297 | George Smith S000541 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 25 | |||||||||||||
15348 | 15348 | Henry Boutell B000672 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
15383 | 15383 | Pleasant Chapman C000315 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 24 | |||||||||||||
15497 | 15497 | Joseph Graff G000351 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 16 | |||||||||||||
15614 | 15614 | William Lorimer L000444 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
15624 | 15624 | Frank Lowden L000472 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 13 | |||||||||||||
15736 | 15736 | Howard Snapp S000650 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 11 | |||||||||||||
16099 | 16099 | James McKinney M000524 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 14 | |||||||||||||
16155 | 16155 | George Prince P000538 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 15 | |||||||||||||
17200 | 17200 | George Foss F000295 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 10 | |||||||||||||
17451 | 17451 | John Sterling S000870 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 17 | |||||||||||||
18017 | 18017 | William Wilson W000624 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
18108 | 18108 | Joseph Cannon C000121 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 18 | |||||||||||||
18326 | 18326 | James Mann M000104 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
18346 | 18346 | William McKinley M000521 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 19 | |||||||||||||
18444 | 18444 | William Rodenberg R000371 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 22 | |||||||||||||
18946 | 18946 | Charles Fuller F000407 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 12 | |||||||||||||
19406 | 19406 | Martin Madden M000038 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 1 | |||||||||||||
21512 | 21512 | Henry Rainey R000014 | rep | IL | 1905-12-04 | 1907-03-03 | Democrat | 20 | |||||||||||||
14624 | 14624 | George Cromer C000924 | rep | IN | 1905-12-04 | 1907-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);