legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
289 rows where "end" is on date 1873-03-03 sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8304 | 8304 | Garrett Davis D000099 | sen | KY | 1867-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8500 | 8500 | George Vickers V000095 | sen | MD | 1868-01-01 | 1873-03-03 | 3 | Democrat | |||||||||||||
8798 | 8798 | Ephraim Acker A000020 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
8810 | 8810 | Erasmus Beck B000288 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
8814 | 8814 | Benjamin Biggs B000457 | rep | DE | 1871-03-04 | 1873-03-03 | Democrat | 0 | |||||||||||||
8824 | 8824 | John Bird B000478 | rep | NJ | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8832 | 8832 | Francis Blair B000523 | sen | MO | 1871-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8838 | 8838 | Elliott Braxton B000777 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
8847 | 8847 | Robert Caldwell C000040 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
8853 | 8853 | Lewis Campbell C000096 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8854 | 8854 | John Carroll C000190 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 18 | |||||||||||||
8861 | 8861 | John Conner C000691 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8872 | 8872 | John Crebs C000900 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 13 | |||||||||||||
8874 | 8874 | John Critcher C000911 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8879 | 8879 | Ozro Dodds D000393 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8881 | 8881 | Peter Dox D000478 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8882 | 8882 | Dudley Du Bose D000510 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8884 | 8884 | Richard Duke D000521 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8896 | 8896 | Samuel Forker F000274 | rep | NJ | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8899 | 8899 | Henry Foster F000305 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 21 | |||||||||||||
8904 | 8904 | José Gallegos G000022 | rep | NM | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
8907 | 8907 | Abraham Garrett G000079 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8910 | 8910 | James Getz G000145 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
8912 | 8912 | Edward Golladay G000270 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8914 | 8914 | Samuel Griffith G000470 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 20 | |||||||||||||
8916 | 8916 | Richard Haldeman H000027 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 15 | |||||||||||||
8920 | 8920 | Samuel Hambleton H000095 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8921 | 8921 | William Handley H000155 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8922 | 8922 | James Hanks H000157 | rep | AR | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8923 | 8923 | James Harper H000222 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
8928 | 8928 | Ellery Hibbard H000556 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8938 | 8938 | William Hooper H000767 | rep | UT | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
8941 | 8941 | Andrew King K000193 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
8942 | 8942 | Thomas Kinsella K000226 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8944 | 8944 | Joseph Lewis L000289 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8949 | 8949 | Archibald MacIntyre M000017 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8950 | 8950 | Mahlon Manson M000114 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
8952 | 8952 | William McClelland M000335 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 24 | |||||||||||||
8955 | 8955 | James McCormick M000367 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8958 | 8958 | Henry McHenry M000468 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8960 | 8960 | John McKinney M000525 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
8962 | 8962 | Thompson McNeely M000585 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
8967 | 8967 | William Merrick M000655 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8968 | 8968 | Samuel Merritt M000662 | rep | ID | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
8969 | 8969 | Benjamin Meyers M000683 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 16 | |||||||||||||
8975 | 8975 | George Morgan M000950 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 13 | |||||||||||||
8982 | 8982 | Silas Niblack N000082 | rep | FL | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8996 | 8996 | William Price P000533 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
8998 | 8998 | Edward Rice R000197 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 10 | |||||||||||||
9000 | 9000 | John Rice R000202 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
9001 | 9001 | John Ritchie R000275 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9004 | 9004 | John Rogers R000397 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 16 | |||||||||||||
9006 | 9006 | Sion Rogers R000402 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9007 | 9007 | Robert Roosevelt R000428 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9013 | 9013 | Henry Sherwood S000354 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 18 | |||||||||||||
9015 | 9015 | Francis Shober S000372 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9024 | 9024 | Bradford Stevens S000876 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9034 | 9034 | Jabez Sutherland S001082 | rep | MI | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9039 | 9039 | Dwight Townsend T000331 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9041 | 9041 | Joseph Tuthill T000437 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 13 | |||||||||||||
9049 | 9049 | Philadelph Van Trump V000060 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 12 | |||||||||||||
9050 | 9050 | William Vaughan V000076 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9053 | 9053 | Joseph Warren W000165 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 15 | |||||||||||||
9055 | 9055 | William Williams W000544 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 30 | |||||||||||||
9064 | 9064 | Boyd Winchester W000628 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9066 | 9066 | Willis Machen M000012 | sen | KY | 1872-09-27 | 1873-03-03 | 3 | Democrat | |||||||||||||
9069 | 9069 | George Adams A000035 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9075 | 9075 | Stevenson Archer A000274 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9077 | 9077 | Moses Armstrong A000283 | rep | DK | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
9079 | 9079 | William Arthur A000304 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9106 | 9106 | James Brooks B000881 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9131 | 9131 | Abram Comingo C000658 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9140 | 9140 | Edward Crossland C000933 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9148 | 9148 | John Davis D000119 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9163 | 9163 | Charles Eldredge E000103 | rep | WI | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9198 | 9198 | William Herndon H000535 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9221 | 9221 | Charles Kendall K000090 | rep | NV | 1871-03-04 | 1873-03-03 | Democrat | 0 | |||||||||||||
9223 | 9223 | Charles Lamison L000039 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9233 | 9233 | James Leach L000170 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9249 | 9249 | Samuel Marshall M000160 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 11 | |||||||||||||
9276 | 9276 | Alexander Mitchell M000802 | rep | WI | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9294 | 9294 | William Niblack N000083 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9305 | 9305 | Hosea Parker P000057 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9314 | 9314 | Eli Perry P000242 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 14 | |||||||||||||
9323 | 9323 | William Read R000094 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9329 | 9329 | William Roberts R000316 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9334 | 9334 | James Robinson R000336 | rep | IL | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9365 | 9365 | Joseph Sloss S000498 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9377 | 9377 | Robert Speer S000713 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 17 | |||||||||||||
9430 | 9430 | Pierce Young Y000048 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9449 | 9449 | Samuel Bell B000346 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9497 | 9497 | Smith Ely E000167 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9556 | 9556 | Michael Kerr K000143 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9651 | 9651 | William Terry T000136 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9711 | 9711 | William Barnum B000166 | rep | CT | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9822 | 9822 | De Giddings G000166 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9846 | 9846 | Frank Hereford H000527 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9899 | 9899 | Clarkson Potter P000461 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 10 | |||||||||||||
9948 | 9948 | Thomas Swann S001092 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9965 | 9965 | Alfred Waddell W000002 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 3 |
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);