legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
437 rows where "start" is on date 1903-11-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14425 | 14425 | Edmund Pettus P000279 | sen | AL | 1903-11-09 | 1907-12-31 | 3 | Democrat | |||||||||||||
14505 | 14505 | Charles Thompson T000196 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14588 | 14588 | Sydney Bowie B000695 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
15308 | 15308 | Ariosto Wiley W000466 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
16331 | 16331 | Henry Clayton C000495 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
16543 | 16543 | William Richardson R000227 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
16606 | 16606 | George Taylor T000078 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17554 | 17554 | John Bankhead B000110 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
17582 | 17582 | John Burnett B001121 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
18528 | 18528 | Oscar Underwood U000013 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14297 | 14297 | Hugh Dinsmore D000358 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14791 | 14791 | John Little L000352 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
15009 | 15009 | Stephen Brundidge B000979 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15713 | 15713 | Charles Reid R000142 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
15798 | 15798 | Robert Wallace W000082 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
16066 | 16066 | Robert Macon M000035 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16729 | 16729 | James Clarke C000463 | sen | AR | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
20807 | 20807 | Joseph Robinson R000347 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14535 | 14535 | John Wilson W000599 | rep | AZ | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14281 | 14281 | Milton Daniels D000042 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14286 | 14286 | Edward De Nivernais D000230 | rep | CA | 1903-11-09 | 1905-03-03 | Democratic and Union Labor | -1 | |||||||||||||
14383 | 14383 | Edward Livernash L000365 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14415 | 14415 | Victor Metcalf M000672 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14539 | 14539 | William Wynn W000785 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14673 | 14673 | James Gillett G000202 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15643 | 15643 | James McLachlan M000532 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
15698 | 15698 | George Perkins P000232 | sen | CA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
16123 | 16123 | James Needham N000021 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
16425 | 16425 | Joseph Knowland K000291 | rep | CA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14497 | 14497 | Henry Teller T000116 | sen | CO | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
14591 | 14591 | Franklin Brooks B000878 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14729 | 14729 | Herschel Hogg H000703 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14985 | 14985 | Robert Bonynge B000623 | rep | CO | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
16563 | 16563 | John Shafroth S000279 | rep | CO | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14437 | 14437 | Orville Platt P000382 | sen | CT | 1903-11-09 | 1905-12-31 | 3 | Republican | |||||||||||||
15201 | 15201 | George Lilley L000308 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15750 | 15750 | Nehemiah Sperry S000733 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
16001 | 16001 | Edward Henry H000505 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
17277 | 17277 | Ebenezer Hill H000591 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
18060 | 18060 | Frank Brandegee B000769 | rep | CT | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14226 | 14226 | James Allee A000110 | sen | DE | 1903-11-09 | 1907-03-03 | 2 | Republican | |||||||||||||
14357 | 14357 | Henry Houston H000823 | rep | DE | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
17544 | 17544 | Lewis Ball B000100 | sen | DE | 1903-11-09 | 1905-03-03 | 1 | Republican | |||||||||||||
14285 | 14285 | Robert Davis D000132 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14400 | 14400 | Stephen Mallory M000085 | sen | FL | 1903-11-09 | 1907-12-23 | 3 | Democrat | |||||||||||||
15183 | 15183 | William Lamar L000031 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
16991 | 16991 | Stephen Sparkman S000702 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14394 | 14394 | John Maddox M000040 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
14491 | 14491 | Farish Tate T000046 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14778 | 14778 | Rufus Lester L000255 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15198 | 15198 | Elijah Lewis L000281 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
15387 | 15387 | Alexander Clay C000478 | sen | GA | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15510 | 15510 | James Griggs G000473 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15525 | 15525 | William Howard H000848 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
15606 | 15606 | Leonidas Livingston L000368 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
15882 | 15882 | William Brantley B000770 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
16277 | 16277 | Charles Bartlett B000199 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
16653 | 16653 | Thomas Hardwick H000193 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
17047 | 17047 | William Adamson A000051 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
18257 | 18257 | Jonah Kalanianaole K000004 | rep | HI | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
14236 | 14236 | William Allison A000160 | sen | IA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14503 | 14503 | Lot Thomas T000179 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
14520 | 14520 | Martin Wade W000007 | rep | IA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14699 | 14699 | Thomas Hedge H000441 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14766 | 14766 | John Lacey L000010 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
14982 | 14982 | Benjamin Birdsall B000481 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
15031 | 15031 | James Conner C000690 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
15047 | 15047 | Robert Cousins C000811 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 5 | |||||||||||||
15150 | 15150 | William Hepburn H000523 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
15552 | 15552 | John Hull H000942 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
16188 | 16188 | Walter Smith S000623 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
20482 | 20482 | Gilbert Haugen H000350 | rep | IA | 1903-11-09 | 1905-03-03 | Republican | 4 | |||||||||||||
15516 | 15516 | Weldon Heyburn H000554 | sen | ID | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
20387 | 20387 | Burton French F000375 | rep | ID | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
14280 | 14280 | Joseph Crowley C000943 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 23 | |||||||||||||
14303 | 14303 | Martin Emerich E000170 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14315 | 14315 | George Foster F000303 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14356 | 14356 | Albert Hopkins H000770 | sen | IL | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14396 | 14396 | William Mahoney M000069 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14525 | 14525 | Vespasian Warner W000158 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 19 | |||||||||||||
14533 | 14533 | James Williams W000508 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 24 | |||||||||||||
14726 | 14726 | Robert Hitt H000649 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 13 | |||||||||||||
14807 | 14807 | Benjamin Marsh M000145 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 14 | |||||||||||||
15019 | 15019 | Ben Caldwell C000029 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 21 | |||||||||||||
15178 | 15178 | Philip Knopf K000289 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 7 | |||||||||||||
15296 | 15296 | George Smith S000541 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 25 | |||||||||||||
15347 | 15347 | Henry Boutell B000672 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 9 | |||||||||||||
15496 | 15496 | Joseph Graff G000351 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 16 | |||||||||||||
15613 | 15613 | William Lorimer L000444 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
15735 | 15735 | Howard Snapp S000650 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
16154 | 16154 | George Prince P000538 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 15 | |||||||||||||
17199 | 17199 | George Foss F000295 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 10 | |||||||||||||
17450 | 17450 | John Sterling S000870 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 17 | |||||||||||||
18016 | 18016 | William Wilson W000624 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18107 | 18107 | Joseph Cannon C000121 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 18 | |||||||||||||
18325 | 18325 | James Mann M000104 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
18443 | 18443 | William Rodenberg R000371 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 22 | |||||||||||||
18945 | 18945 | Charles Fuller F000407 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 12 | |||||||||||||
21511 | 21511 | Henry Rainey R000014 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 20 |
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);