legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "end" is on date 1861-03-03 sorted by address
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6808 | 6808 | Charles Durkee D000573 | sen | WI | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
6814 | 6814 | Benjamin Fitzpatrick F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6844 | 6844 | Alfred Iverson I000049 | sen | GA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6849 | 6849 | Robert Johnson J000172 | sen | AR | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6903 | 6903 | George Pugh P000560 | sen | OH | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6917 | 6917 | William Seward S000261 | sen | NY | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
6923 | 6923 | John Slidell S000487 | sen | LA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6960 | 6960 | David Yulee Y000061 | sen | FL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6961 | 6961 | William Bigler B000459 | sen | PA | 1856-01-01 | 1861-03-03 | 3 | Democrat | |||||||||||||
7046 | 7046 | Graham Fitch F000158 | sen | IN | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7067 | 7067 | James Green G000414 | sen | MO | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7075 | 7075 | William Gwin G000540 | sen | CA | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7080 | 7080 | James Hammond H000128 | sen | SC | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7266 | 7266 | Thomas Clingman C000524 | sen | NC | 1858-01-01 | 1861-03-03 | 3 | Democrat | |||||||||||||
7273 | 7273 | Green Adams A000036 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
7275 | 7275 | Garnett Adrain A000058 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 3 | |||||||||||||
7277 | 7277 | Thomas Anderson A000234 | rep | MO | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7278 | 7278 | William Anderson A000237 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
7279 | 7279 | John Ashmore A000316 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7281 | 7281 | William Avery A000347 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
7285 | 7285 | William Barksdale B000147 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7287 | 7287 | Thomas Barr B000172 | rep | NY | 1859-12-05 | 1861-03-03 | Ind. Democrat | 4 | |||||||||||||
7288 | 7288 | John Barret B000175 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7289 | 7289 | Charles Beale B000265 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 12 | |||||||||||||
7301 | 7301 | Thomas Bocock B000582 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7303 | 7303 | Milledge Bonham B000616 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7304 | 7304 | Alexander Boteler B000653 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 8 | |||||||||||||
7305 | 7305 | John Bouligny B000665 | rep | LA | 1859-12-05 | 1861-03-03 | American | 1 | |||||||||||||
7309 | 7309 | William Boyce B000713 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7310 | 7310 | Reese Brabson B000730 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7314 | 7314 | Lawrence Branch B000764 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7316 | 7316 | William Brayton B000779 | rep | RI | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7319 | 7319 | George Briggs B000829 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
7321 | 7321 | Francis Bristow B000842 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7328 | 7328 | John Burch B001068 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7331 | 7331 | Anson Burlingame B001112 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7333 | 7333 | Silas Burroughs B001139 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 31 | |||||||||||||
7334 | 7334 | Martin Butterfield B001199 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 25 | |||||||||||||
7335 | 7335 | John Carey C000144 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
7336 | 7336 | Luther Carter C000198 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7338 | 7338 | Charles Case C000219 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7340 | 7340 | Horace Clark C000435 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 8 | |||||||||||||
7345 | 7345 | Sherrard Clemens C000502 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
7346 | 7346 | David Clopton C000530 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7353 | 7353 | Williamson Cobb C000554 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7354 | 7354 | Stephen Coburn C000559 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7356 | 7356 | Clark Cochrane C000569 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7358 | 7358 | John Cochrane C000570 | rep | NY | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7359 | 7359 | George Cooper C000749 | rep | MI | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7361 | 7361 | James Craig C000857 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7365 | 7365 | Francis Craige C000862 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7368 | 7368 | Martin Crawford C000892 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7370 | 7370 | Jabez Curry C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7373 | 7373 | Thomas Davidson D000086 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7377 | 7377 | John Davis D000118 | rep | IN | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 7 | |||||||||||||
7379 | 7379 | Reuben Davis D000127 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7383 | 7383 | John Dick D000303 | rep | PA | 1859-12-05 | 1861-03-03 | Whig | -1 | |||||||||||||
7385 | 7385 | William Dimmick D000351 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 13 | |||||||||||||
7396 | 7396 | Henry Edmundson E000058 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 12 | |||||||||||||
7400 | 7400 | William English E000191 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7401 | 7401 | Experience Estabrook E000220 | rep | NE | 1859-12-05 | 1861-03-03 | -1 | ||||||||||||||
7404 | 7404 | Emerson Etheridge E000227 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
7409 | 7409 | Thomas Florence F000214 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7411 | 7411 | Stephen Foster F000312 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
7412 | 7412 | Ezra French F000377 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7415 | 7415 | Muscoe Garnett G000076 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7417 | 7417 | Lucius Gartrell G000088 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7419 | 7419 | John Gilmer G000217 | rep | NC | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 5 | |||||||||||||
7424 | 7424 | William Goode G000281 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7425 | 7425 | James Graham G000356 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 19 | |||||||||||||
7430 | 7430 | Chapin Hall H000046 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 24 | |||||||||||||
7431 | 7431 | Andrew Hamilton H000103 | rep | TX | 1859-12-05 | 1861-03-03 | Ind. Democrat | 2 | |||||||||||||
7434 | 7434 | James Harris H000244 | rep | MD | 1859-12-05 | 1861-03-03 | American | 3 | |||||||||||||
7436 | 7436 | John Haskin H000321 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 9 | |||||||||||||
7437 | 7437 | Robert Hatton H000349 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 5 | |||||||||||||
7438 | 7438 | Henry Haun H000353 | sen | CA | 1859-12-05 | 1861-03-03 | 1 | Democrat | |||||||||||||
7440 | 7440 | George Hawkins H000369 | rep | FL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7441 | 7441 | William Helmick H000462 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 15 | |||||||||||||
7443 | 7443 | Thomas Hindman H000628 | rep | AR | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7445 | 7445 | Charles Hoard H000658 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 23 | |||||||||||||
7446 | 7446 | William Howard H000846 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7449 | 7449 | William Howard H000847 | rep | MI | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7450 | 7450 | George Hughes H000921 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7458 | 7458 | William Irvine I000036 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 28 | |||||||||||||
7460 | 7460 | James Jackson J000016 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7462 | 7462 | Albert Jenkins J000081 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 11 | |||||||||||||
7463 | 7463 | John Jones J000235 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7464 | 7464 | Benjamin Junkin J000281 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 16 | |||||||||||||
7468 | 7468 | Laurence Keitt K000054 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7469 | 7469 | William Kenyon K000128 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
7471 | 7471 | David Kilgore K000175 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7473 | 7473 | Jacob Kunkel K000339 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7474 | 7474 | John Landrum L000053 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7479 | 7479 | Joseph Lane L000062 | sen | OR | 1859-12-05 | 1861-03-03 | 3 | Democrat | |||||||||||||
7480 | 7480 | Charles Larrabee L000099 | rep | WI | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7482 | 7482 | De Leach L000168 | rep | MI | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7484 | 7484 | Shelton Leake L000176 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 6 | |||||||||||||
7485 | 7485 | Moses Lee L000199 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 22 | |||||||||||||
7486 | 7486 | Henry Longnecker L000432 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
7487 | 7487 | Peter Love L000457 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 1 |
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);