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 1905-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13571 | 13571 | William Bate B000227 | sen | TN | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13620 | 13620 | Francis Cockrell C000576 | sen | MO | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
13966 | 13966 | Paris Gibson G000164 | sen | MT | 1901-12-02 | 1905-03-03 | 1 | Democrat | |||||||||||||
14238 | 14238 | De Badger B000021 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14239 | 14239 | Robert Baker B000073 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14243 | 14243 | Thomas Ball B000101 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14244 | 14244 | Edward Bassett B000225 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14245 | 14245 | Theodore Bell B000347 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14246 | 14246 | Allan Benny B000385 | rep | NJ | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14250 | 14250 | Maecenas Benton B000397 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 15 | |||||||||||||
14256 | 14256 | Phanor Breazeale B000781 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14261 | 14261 | James Butler B001178 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14263 | 14263 | John Cassingham C000239 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 17 | |||||||||||||
14267 | 14267 | Charles Cochran C000562 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14275 | 14275 | William Cowherd C000825 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14276 | 14276 | George Croft C000921 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14277 | 14277 | Theodore Croft C000922 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14280 | 14280 | Joseph Crowley C000943 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 23 | |||||||||||||
14285 | 14285 | Robert Davis D000132 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14290 | 14290 | James Denny D000250 | rep | MD | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14291 | 14291 | Charles Dickerman D000307 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 16 | |||||||||||||
14297 | 14297 | Hugh Dinsmore D000358 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14300 | 14300 | John Dougherty D000447 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14303 | 14303 | Martin Emerich E000170 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14308 | 14308 | Morgan Fitzpatrick F000176 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14315 | 14315 | George Foster F000303 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14332 | 14332 | Daniel Gooch G000273 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14340 | 14340 | Francis Griffith G000468 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14357 | 14357 | Henry Houston H000823 | rep | DE | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14358 | 14358 | George Howell H000862 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14364 | 14364 | James Kehoe K000045 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14369 | 14369 | Theodore Kluttz K000275 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14382 | 14382 | John Lind L000319 | rep | MN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14383 | 14383 | Edward Livernash L000365 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14388 | 14388 | Alfred Lucking L000500 | rep | MI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14394 | 14394 | John Maddox M000040 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
14396 | 14396 | William Mahoney M000069 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14405 | 14405 | George McClellan M000331 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14419 | 14419 | Robert Miers M000700 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14432 | 14432 | Rice Pierce P000337 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14449 | 14449 | John Rhea R000182 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14459 | 14459 | James Richardson R000222 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14460 | 14460 | Ira Rider R000242 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 14 | |||||||||||||
14464 | 14464 | Edward Robb R000296 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 13 | |||||||||||||
14468 | 14468 | James Robinson R000338 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 12 | |||||||||||||
14472 | 14472 | Robert Scarborough S000107 | rep | SC | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14474 | 14474 | Townsend Scudder S000202 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14476 | 14476 | Francis Shober S000373 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 17 | |||||||||||||
14477 | 14477 | Joseph Shull S000391 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 26 | |||||||||||||
14491 | 14491 | Farish Tate T000046 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
14500 | 14500 | John Thayer T000149 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14505 | 14505 | Charles Thompson T000196 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14519 | 14519 | Willard Vandiver V000032 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 14 | |||||||||||||
14520 | 14520 | Martin Wade W000007 | rep | IA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
14533 | 14533 | James Williams W000508 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 24 | |||||||||||||
14535 | 14535 | John Wilson W000599 | rep | AZ | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14539 | 14539 | William Wynn W000785 | rep | CA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14588 | 14588 | Sydney Bowie B000695 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14629 | 14629 | John Daniel D000035 | sen | VA | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14652 | 14652 | Scott Field F000107 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14665 | 14665 | Harvey Garber G000044 | rep | OH | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14670 | 14670 | George Gilbert G000174 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14695 | 14695 | William Hearst H000429 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
14731 | 14731 | Francis Hopkins H000773 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14733 | 14733 | John Hunt H000973 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
14758 | 14758 | Marcus Kline K000268 | rep | PA | 1903-11-09 | 1905-03-03 | Democrat | 13 | |||||||||||||
14778 | 14778 | Rufus Lester L000255 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
14791 | 14791 | John Little L000352 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14820 | 14820 | Allan McDermott M000403 | rep | NJ | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14822 | 14822 | William McNary M000584 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14839 | 14839 | Hernando Money M000854 | sen | MS | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14857 | 14857 | Gilbert Patterson P000117 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14860 | 14860 | Malcolm Patterson P000126 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 10 | |||||||||||||
14863 | 14863 | John Pinckney P000356 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
14879 | 14879 | Samuel Robertson R000324 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
14883 | 14883 | Jacob Ruppert R000513 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 16 | |||||||||||||
14899 | 14899 | David Smith S000525 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14906 | 14906 | Robert Southall S000684 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
14914 | 14914 | John Sullivan S001055 | rep | MA | 1903-11-09 | 1905-03-03 | Democrat | 11 | |||||||||||||
14916 | 14916 | James Taliaferro T000026 | sen | FL | 1899-12-04 | 1905-03-03 | 1 | Democrat | |||||||||||||
14922 | 14922 | South Trimble T000376 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
14925 | 14925 | Clarence Van Duzer V000033 | rep | NV | 1903-11-09 | 1905-03-03 | Democrat | 0 | |||||||||||||
14956 | 14956 | William Zenor Z000005 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
15009 | 15009 | Stephen Brundidge B000979 | rep | AR | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15019 | 15019 | Ben Caldwell C000029 | rep | IL | 1903-11-09 | 1905-03-03 | Democrat | 21 | |||||||||||||
15040 | 15040 | Samuel Cooper C000761 | rep | TX | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15072 | 15072 | Robert Davey D000081 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15117 | 15117 | John Gaines G000007 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
15126 | 15126 | Daniel Granger G000375 | rep | RI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15153 | 15153 | Wilson Hill H000614 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 4 | |||||||||||||
15175 | 15175 | William Kitchin K000252 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
15181 | 15181 | James Lamar L000028 | rep | MO | 1903-11-09 | 1905-03-03 | Democrat | 16 | |||||||||||||
15183 | 15183 | William Lamar L000031 | rep | FL | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
15198 | 15198 | Elijah Lewis L000281 | rep | GA | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
15218 | 15218 | Frank McLain M000533 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 7 | |||||||||||||
15231 | 15231 | Adolph Meyer M000679 | rep | LA | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15268 | 15268 | John Rixey R000287 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
15273 | 15273 | William Ryan R000563 | rep | NY | 1903-11-09 | 1905-03-03 | Democrat | 35 | |||||||||||||
15308 | 15308 | Ariosto Wiley W000466 | rep | AL | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
15351 | 15351 | Eaton Bowers B000689 | rep | MS | 1903-11-09 | 1905-03-03 | Democrat | 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);