legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
271 rows where "end" is on date 1869-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8287 | 8287 | Charles Clever C000517 | rep | NM | 1867-03-04 | 1869-03-03 | -1 | ||||||||||||||
8268 | 8268 | Nathaniel Boyden B000722 | rep | NC | 1867-03-04 | 1869-03-03 | Conservative | 6 | |||||||||||||
8419 | 8419 | Charles Phelps P000292 | rep | MD | 1867-03-04 | 1869-03-03 | Conservative | 3 | |||||||||||||
8455 | 8455 | Thomas Stewart S000920 | rep | NY | 1867-03-04 | 1869-03-03 | Conservative Republican | 6 | |||||||||||||
7969 | 7969 | Thomas Hendricks H000493 | sen | IN | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
7974 | 7974 | Reverdy Johnson J000169 | sen | MD | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
8246 | 8246 | David Patterson P000110 | sen | TN | 1866-01-01 | 1869-03-03 | 1 | Democrat | |||||||||||||
8260 | 8260 | Demas Barnes B000156 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8265 | 8265 | James Bayard B000248 | sen | DE | 1867-03-04 | 1869-03-03 | 1 | Democrat | |||||||||||||
8270 | 8270 | Benjamin Boyer B000723 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 6 | |||||||||||||
8284 | 8284 | John Chanler C000302 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
8310 | 8310 | Charles Denison D000235 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
8336 | 8336 | Adam Glossbrenner G000242 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 15 | |||||||||||||
8342 | 8342 | Asa Grover G000503 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8355 | 8355 | Elijah Hise H000644 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8357 | 8357 | Edward Holbrook H000710 | rep | ID | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8358 | 8358 | Julius Hotchkiss H000809 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8364 | 8364 | Richard Hubbard H000888 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8369 | 8369 | James Humphrey H000955 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 30 | |||||||||||||
8382 | 8382 | James Mann M000103 | rep | LA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8392 | 8392 | Hiram McCullough M000395 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8405 | 8405 | John Nicholson N000099 | rep | DE | 1867-03-04 | 1869-03-03 | Democrat | 0 | |||||||||||||
8407 | 8407 | Thomas Noell N000123 | rep | MO | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8436 | 8436 | John Pruyn P000554 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 14 | |||||||||||||
8441 | 8441 | Lewis Ross R000451 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 9 | |||||||||||||
8444 | 8444 | Charles Sitgreaves S000458 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8458 | 8458 | Stephen Taber T000002 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8537 | 8537 | Albert Burr B001134 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 10 | |||||||||||||
8544 | 8544 | James Cavanaugh C000260 | rep | MT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8599 | 8599 | John Fox F000331 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
8605 | 8605 | Jacob Golladay G000271 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8611 | 8611 | Charles Haight H000020 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8641 | 8641 | James Johnson J000145 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8678 | 8678 | John Morrissey M001001 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8680 | 8680 | William Mungen M001079 | rep | OH | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8737 | 8737 | Frederick Stone S000957 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8749 | 8749 | Nelson Tift T000269 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8755 | 8755 | Lawrence Trimble T000375 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8757 | 8757 | Daniel Van Auken V000014 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 11 | |||||||||||||
8788 | 8788 | George Woodward W000730 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
8908 | 8908 | James Getz G000145 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
8936 | 8936 | William Hooper H000767 | rep | UT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8953 | 8953 | James McCormick M000367 | rep | MO | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8973 | 8973 | George Morgan M000950 | rep | OH | 1867-03-04 | 1869-03-03 | Democrat | 13 | |||||||||||||
9047 | 9047 | Philadelph Van Trump V000060 | rep | OH | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
9067 | 9067 | George Adams A000035 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
9073 | 9073 | Stevenson Archer A000274 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9104 | 9104 | James Brooks B000881 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
9161 | 9161 | Charles Eldredge E000103 | rep | WI | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
9247 | 9247 | Samuel Marshall M000160 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 11 | |||||||||||||
9292 | 9292 | William Niblack N000083 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
9428 | 9428 | Pierce Young Y000048 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
9457 | 9457 | John Brown B000933 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
9547 | 9547 | Thomas Jones J000253 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 6 | |||||||||||||
9554 | 9554 | Michael Kerr K000143 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9709 | 9709 | William Barnum B000166 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
10418 | 10418 | James Knott K000290 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
10608 | 10608 | Fernando Wood W000694 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 9 | |||||||||||||
10864 | 10864 | William Robinson R000355 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
11599 | 11599 | James Beck B000289 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
11629 | 11629 | Charles Buckalew B001019 | sen | PA | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
11914 | 11914 | Samuel Randall R000039 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
13337 | 13337 | William Holman H000732 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
14959 | 14959 | William Whyte W000435 | sen | MD | 1868-01-01 | 1869-03-03 | 1 | Democrat | |||||||||||||
8281 | 8281 | Samuel Cary C000216 | rep | OH | 1867-03-04 | 1869-03-03 | Ind. Republican | 2 | |||||||||||||
8442 | 8442 | Lewis Selye S000237 | rep | NY | 1867-03-04 | 1869-03-03 | Ind. Republican | 28 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
7898 | 7898 | John Henderson H000483 | sen | MO | 1863-03-04 | 1869-03-03 | 1 | Republican | |||||||||||||
7931 | 7931 | John Conness C000695 | sen | CA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
7947 | 7947 | James Dixon D000369 | sen | CT | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
7949 | 7949 | James Doolittle D000428 | sen | WI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8001 | 8001 | Edwin Morgan M000949 | sen | NY | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8051 | 8051 | Peter Van Winkle V000066 | sen | WV | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8054 | 8054 | Benjamin Wade W000005 | sen | OH | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8249 | 8249 | George Anderson A000188 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8251 | 8251 | Delos Ashley A000312 | rep | NV | 1867-03-04 | 1869-03-03 | Republican | 0 | |||||||||||||
8256 | 8256 | James Ashley A000314 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
8259 | 8259 | John Baldwin B000091 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8266 | 8266 | William Blackburn B000510 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8272 | 8272 | Henry Bromwell B000865 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8275 | 8275 | John Broomall B000889 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8277 | 8277 | Ralph Buckland B001022 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8279 | 8279 | Walter Burleigh B001108 | rep | DK | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8286 | 8286 | Reader Clarke C000468 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8296 | 8296 | Schuyler Colfax C000626 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8298 | 8298 | Manuel Corley C000778 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8307 | 8307 | Columbus Delano D000214 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 13 | |||||||||||||
8311 | 8311 | Grenville Dodge D000395 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8314 | 8314 | Ignatius Donnelly D000417 | rep | MN | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8318 | 8318 | John Driggs D000498 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8321 | 8321 | Ephraim Eckley E000036 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 17 | |||||||||||||
8323 | 8323 | Benjamin Eggleston E000090 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8329 | 8329 | Thomas Eliot E000106 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8330 | 8330 | James Elliott E000123 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8331 | 8331 | William Fields F000112 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 19 | |||||||||||||
8332 | 8332 | Darwin Finney F000136 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 20 | |||||||||||||
8333 | 8333 | Alvan Flanders F000188 | rep | WA | 1867-03-04 | 1869-03-03 | Republican | -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);