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 state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6814 | 6814 | Benjamin Fitzpatrick F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
7370 | 7370 | Jabez Curry C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7520 | 7520 | Sydenham Moore M000918 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7581 | 7581 | James Stallworth S000786 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
10115 | 10115 | George Houston H000822 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
12271 | 12271 | James Pugh P000561 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
6849 | 6849 | Robert Johnson J000172 | sen | AR | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7443 | 7443 | Thomas Hindman H000628 | rep | AR | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7560 | 7560 | Albert Rust R000544 | rep | AR | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7075 | 7075 | William Gwin G000540 | sen | CA | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7328 | 7328 | John Burch B001068 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7438 | 7438 | Henry Haun H000353 | sen | CA | 1859-12-05 | 1861-03-03 | 1 | Democrat | |||||||||||||
7563 | 7563 | Charles Scott S000167 | rep | CA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7636 | 7636 | John Woodruff W000717 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7681 | 7681 | Alfred Burnham B001123 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7752 | 7752 | Lafayette Foster F000308 | sen | CT | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
7784 | 7784 | Dwight Loomis L000438 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
9167 | 9167 | Orris Ferry F000094 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7627 | 7627 | William Whiteley W000409 | rep | DE | 1859-12-05 | 1861-03-03 | Democrat | 0 | |||||||||||||
6960 | 6960 | David Yulee Y000061 | sen | FL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7440 | 7440 | George Hawkins H000369 | rep | FL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
6844 | 6844 | Alfred Iverson I000049 | sen | GA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7368 | 7368 | Martin Crawford C000892 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7417 | 7417 | Lucius Gartrell G000088 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7460 | 7460 | James Jackson J000016 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7463 | 7463 | John Jones J000235 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7487 | 7487 | Peter Love L000457 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7615 | 7615 | John Underwood U000010 | rep | GA | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
8930 | 8930 | Joshua Hill H000599 | rep | GA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
10735 | 10735 | Thomas Hardeman H000181 | rep | GA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7729 | 7729 | Samuel Curtis C001013 | rep | IA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8346 | 8346 | James Harlan H000211 | sen | IA | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
11999 | 11999 | William Vandever V000031 | rep | IA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7522 | 7522 | Isaac Morris M000977 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7754 | 7754 | Philip Fouke F000316 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7776 | 7776 | William Kellogg K000068 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7793 | 7793 | John McClernand M000337 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7989 | 7989 | Owen Lovejoy L000462 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
8473 | 8473 | Lyman Trumbull T000392 | sen | IL | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
8770 | 8770 | Elihu Washburne W000176 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8888 | 8888 | John Farnsworth F000024 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
9331 | 9331 | James Robinson R000336 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
11110 | 11110 | John Logan L000403 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 9 | |||||||||||||
7046 | 7046 | Graham Fitch F000158 | sen | IN | 1857-12-07 | 1861-03-03 | 3 | Democrat | |||||||||||||
7338 | 7338 | Charles Case C000219 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7377 | 7377 | John Davis D000118 | rep | IN | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 7 | |||||||||||||
7400 | 7400 | William English E000191 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7471 | 7471 | David Kilgore K000175 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7540 | 7540 | John Pettit P000278 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
7630 | 7630 | James Wilson W000589 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 8 | |||||||||||||
7740 | 7740 | William Dunn D000554 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7837 | 7837 | Albert Porter P000435 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
8292 | 8292 | Schuyler Colfax C000626 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
9290 | 9290 | William Niblack N000083 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
13333 | 13333 | William Holman H000732 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7534 | 7534 | Marcus Parrott P000085 | rep | KS | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7707 | 7707 | Martin Conway C000713 | rep | KS | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7273 | 7273 | Green Adams A000036 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
7278 | 7278 | William Anderson A000237 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
7321 | 7321 | Francis Bristow B000842 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
7518 | 7518 | Laban Moore M000907 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
7543 | 7543 | Samuel Peyton P000284 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7567 | 7567 | William Simms S000421 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7679 | 7679 | Henry Burnett B001120 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
7992 | 7992 | Robert Mallory M000082 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
9028 | 9028 | John Stevenson S000894 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
9456 | 9456 | John Brown B000933 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
6923 | 6923 | John Slidell S000487 | sen | LA | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7305 | 7305 | John Bouligny B000665 | rep | LA | 1859-12-05 | 1861-03-03 | American | 1 | |||||||||||||
7373 | 7373 | Thomas Davidson D000086 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7474 | 7474 | John Landrum L000053 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7599 | 7599 | Miles Taylor T000094 | rep | LA | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7331 | 7331 | Anson Burlingame B001112 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7602 | 7602 | Eli Thayer T000145 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
7648 | 7648 | Charles Adams A000032 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7735 | 7735 | Charles Delano D000213 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7861 | 7861 | Charles Train T000352 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 8 | |||||||||||||
8074 | 8074 | John Alley A000155 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
8188 | 8188 | Alexander Rice R000193 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
8325 | 8325 | Thomas Eliot E000106 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
9178 | 9178 | Daniel Gooch G000274 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
9464 | 9464 | James Buffinton B001040 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
11337 | 11337 | Henry Dawes D000148 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
7434 | 7434 | James Harris H000244 | rep | MD | 1859-12-05 | 1861-03-03 | American | 3 | |||||||||||||
7450 | 7450 | George Hughes H000921 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7473 | 7473 | Jacob Kunkel K000339 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
7590 | 7590 | James Stewart S000910 | rep | MD | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7825 | 7825 | James Pearce P000161 | sen | MD | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
7354 | 7354 | Stephen Coburn C000559 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
7525 | 7525 | Freeman Morse M001010 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7537 | 7537 | John Perry P000243 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7575 | 7575 | Daniel Somes S000678 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7624 | 7624 | Israel Washburn W000173 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 |
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);