legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
409 rows where "end" is on date 1903-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14217 | 14217 | Robert Wilcox W000459 | rep | HI | 1901-12-02 | 1903-03-03 | -1 | ||||||||||||||
13322 | 13322 | Henry Heitfeld H000458 | sen | ID | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13366 | 13366 | James Jones J000231 | sen | AR | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13401 | 13401 | John McLaurin M000543 | sen | SC | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13460 | 13460 | Joseph Rawlins R000073 | sen | UT | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13508 | 13508 | George Turner T000420 | sen | WA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13518 | 13518 | George Vest V000091 | sen | MO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13844 | 13844 | Henry Allen A000125 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
13856 | 13856 | John Bellamy B000349 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13857 | 13857 | Oliver Belmont B000352 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
13862 | 13862 | Alexander Billmeyer B000465 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
13900 | 13900 | Robert Burke B001097 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
13907 | 13907 | Joseph Conry C000706 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13911 | 13911 | James Cooney C000744 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
13917 | 13917 | Thomas Creamer C000899 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
13929 | 13929 | Amos Cummings C000983 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
13934 | 13934 | Reese De Graffenreid D000194 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
13951 | 13951 | William Elliott E000129 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
13954 | 13954 | John Feely F000058 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
13955 | 13955 | De Flanagan F000185 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13958 | 13958 | William Fleming F000198 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
13965 | 13965 | Andrew Fox F000330 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13969 | 13969 | Robert Gordon G000314 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
13971 | 13971 | Henry Green G000411 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13984 | 13984 | James Hall H000054 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 28 | |||||||||||||
14000 | 14000 | Patrick Henry H000513 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14018 | 14018 | Charles Hooker H000758 | rep | MS | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14022 | 14022 | Alfred Jackson J000003 | rep | KS | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14025 | 14025 | Thomas Jett J000102 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 18 | |||||||||||||
14032 | 14032 | Frederick Kern K000131 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 21 | |||||||||||||
14036 | 14036 | Rudolph Kleberg K000258 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 11 | |||||||||||||
14048 | 14048 | Samuel Lanham L000078 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14061 | 14061 | Philip McCulloch M000391 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14073 | 14073 | Thomas McRae M000597 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14079 | 14079 | J. Mickey M000694 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14106 | 14106 | Nicholas Muller M001071 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14108 | 14108 | Howard Mutchler M001124 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14110 | 14110 | Henry Naphen N000004 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14115 | 14115 | James Norton N000150 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
14124 | 14124 | Rufus Polk P000410 | rep | PA | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
14125 | 14125 | Cornelius Pugsley P000565 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 16 | |||||||||||||
14141 | 14141 | William Rhea R000183 | rep | VA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14143 | 14143 | John Robinson R000345 | rep | NE | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14154 | 14154 | Joshua Salmon S000017 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14156 | 14156 | Thomas Selby S000231 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 16 | |||||||||||||
14166 | 14166 | John Sheppard S000336 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14173 | 14173 | Charles Snodgrass S000654 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14194 | 14194 | James Stokes S000947 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14196 | 14196 | Edward Swann S001090 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14201 | 14201 | William Talbert T000016 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14214 | 14214 | Charles Wheeler W000331 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14215 | 14215 | James White W000379 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14220 | 14220 | Dudley Wooten W000740 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14242 | 14242 | Thomas Ball B000101 | rep | TX | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14249 | 14249 | Maecenas Benton B000397 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14255 | 14255 | Phanor Breazeale B000781 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14260 | 14260 | James Butler B001178 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14262 | 14262 | John Cassingham C000239 | rep | OH | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
14266 | 14266 | Charles Cochran C000562 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14274 | 14274 | William Cowherd C000825 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14279 | 14279 | Joseph Crowley C000943 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 19 | |||||||||||||
14284 | 14284 | Robert Davis D000132 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14296 | 14296 | Hugh Dinsmore D000358 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14299 | 14299 | John Dougherty D000447 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14314 | 14314 | George Foster F000303 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14331 | 14331 | Daniel Gooch G000273 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14339 | 14339 | Francis Griffith G000468 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14363 | 14363 | James Kehoe K000045 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14368 | 14368 | Theodore Kluttz K000275 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14377 | 14377 | Asbury Latimer L000114 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14393 | 14393 | John Maddox M000040 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14395 | 14395 | William Mahoney M000069 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14399 | 14399 | Stephen Mallory M000085 | sen | FL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14404 | 14404 | George McClellan M000331 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14418 | 14418 | Robert Miers M000700 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14424 | 14424 | Edmund Pettus P000279 | sen | AL | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14431 | 14431 | Rice Pierce P000337 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14448 | 14448 | John Rhea R000182 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14458 | 14458 | James Richardson R000222 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14463 | 14463 | Edward Robb R000296 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 13 | |||||||||||||
14467 | 14467 | James Robinson R000338 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14471 | 14471 | Robert Scarborough S000107 | rep | SC | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14490 | 14490 | Farish Tate T000046 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14496 | 14496 | Henry Teller T000116 | sen | CO | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
14499 | 14499 | John Thayer T000149 | rep | MA | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14504 | 14504 | Charles Thompson T000196 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14518 | 14518 | Willard Vandiver V000032 | rep | MO | 1901-12-02 | 1903-03-03 | Democrat | 14 | |||||||||||||
14532 | 14532 | James Williams W000508 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 20 | |||||||||||||
14587 | 14587 | Sydney Bowie B000695 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14669 | 14669 | George Gilbert G000174 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
14777 | 14777 | Rufus Lester L000255 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14790 | 14790 | John Little L000352 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14819 | 14819 | Allan McDermott M000403 | rep | NJ | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14859 | 14859 | Malcolm Patterson P000126 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14878 | 14878 | Samuel Robertson R000324 | rep | LA | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
14882 | 14882 | Jacob Ruppert R000513 | rep | NY | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14898 | 14898 | David Smith S000525 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14921 | 14921 | South Trimble T000376 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14955 | 14955 | William Zenor Z000005 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
15008 | 15008 | Stephen Brundidge B000979 | rep | AR | 1901-12-02 | 1903-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);