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 party
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7401 | 7401 | Experience Estabrook E000220 | rep | NE | 1859-12-05 | 1861-03-03 | -1 | ||||||||||||||
7530 | 7530 | Miguel Otero O000125 | rep | NM | 1859-12-05 | 1861-03-03 | -1 | ||||||||||||||
7305 | 7305 | John Bouligny B000665 | rep | LA | 1859-12-05 | 1861-03-03 | American | 1 | |||||||||||||
7434 | 7434 | James Harris H000244 | rep | MD | 1859-12-05 | 1861-03-03 | American | 3 | |||||||||||||
7638 | 7638 | Samuel Woodson W000728 | rep | MO | 1859-12-05 | 1861-03-03 | American | 5 | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
7942 | 7942 | Henry Davis D000104 | rep | MD | 1859-12-05 | 1861-03-03 | American | 4 | |||||||||||||
8220 | 8220 | Edwin Webster W000239 | rep | MD | 1859-12-05 | 1861-03-03 | American | 2 | |||||||||||||
7275 | 7275 | Garnett Adrain A000058 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 3 | |||||||||||||
7340 | 7340 | Horace Clark C000435 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 8 | |||||||||||||
7377 | 7377 | John Davis D000118 | rep | IN | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 7 | |||||||||||||
7436 | 7436 | John Haskin H000321 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 9 | |||||||||||||
7550 | 7550 | John Reynolds R000175 | rep | NY | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 14 | |||||||||||||
7551 | 7551 | Jetur Riggs R000254 | rep | NJ | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 4 | |||||||||||||
7561 | 7561 | John Schwartz S000158 | rep | PA | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 8 | |||||||||||||
7766 | 7766 | John Hickman H000562 | rep | PA | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7288 | 7288 | John Barret B000175 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
7309 | 7309 | William Boyce B000713 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7314 | 7314 | Lawrence Branch B000764 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7328 | 7328 | John Burch B001068 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7379 | 7379 | Reuben Davis D000127 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
7409 | 7409 | Thomas Florence F000214 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
7424 | 7424 | William Goode G000281 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
7443 | 7443 | Thomas Hindman H000628 | rep | AR | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7446 | 7446 | William Howard H000846 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7450 | 7450 | George Hughes H000921 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
7468 | 7468 | Laurence Keitt K000054 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
7487 | 7487 | Peter Love L000457 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7492 | 7492 | William Maclay M000032 | rep | NY | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7493 | 7493 | Charles Martin M000171 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 11 | |||||||||||||
7495 | 7495 | Jacob McKenty M000503 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7502 | 7502 | John McQueen M000595 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7505 | 7505 | John McRae M000596 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7507 | 7507 | William Miles M000707 | rep | SC | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7513 | 7513 | John Millson M000780 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7517 | 7517 | William Montgomery M000875 | rep | PA | 1859-12-05 | 1861-03-03 | Democrat | 20 | |||||||||||||
7520 | 7520 | Sydenham Moore M000918 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7522 | 7522 | Isaac Morris M000977 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7543 | 7543 | Samuel Peyton P000284 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7547 | 7547 | Roger Pryor P000558 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7558 | 7558 | Thomas Ruffin R000499 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7560 | 7560 | Albert Rust R000544 | rep | AR | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7563 | 7563 | Charles Scott S000167 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7567 | 7567 | William Simms S000421 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7573 | 7573 | William Smith S000627 | rep | VA | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7581 | 7581 | James Stallworth S000786 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7587 | 7587 | Isaac Stevens S000881 | rep | WA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7590 | 7590 | James Stewart S000910 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7593 | 7593 | Lansing Stout S000981 | rep | OR | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7599 | 7599 | Miles Taylor T000094 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7606 | 7606 | James Thomas T000170 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7615 | 7615 | John Underwood U000010 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7627 | 7627 | William Whiteley W000409 | rep | DE | 1859-12-05 | 1861-03-03 | Democrat | 0 | |||||||||||||
7633 | 7633 | Warren Winslow W000640 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7641 | 7641 | John Wright W000765 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7652 | 7652 | William Allen A000149 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7679 | 7679 | Henry Burnett B001120 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7697 | 7697 | John Clark C000441 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7754 | 7754 | Philip Fouke F000316 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 8 |
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);