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 phone
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8260 | 8260 | Demas Barnes B000156 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
8265 | 8265 | James Bayard B000248 | sen | DE | 1867-03-04 | 1869-03-03 | 1 | Democrat | |||||||||||||
8266 | 8266 | William Blackburn B000510 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8268 | 8268 | Nathaniel Boyden B000722 | rep | NC | 1867-03-04 | 1869-03-03 | Conservative | 6 | |||||||||||||
8270 | 8270 | Benjamin Boyer B000723 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
8281 | 8281 | Samuel Cary C000216 | rep | OH | 1867-03-04 | 1869-03-03 | Ind. Republican | 2 | |||||||||||||
8284 | 8284 | John Chanler C000302 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
8286 | 8286 | Reader Clarke C000468 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8287 | 8287 | Charles Clever C000517 | rep | NM | 1867-03-04 | 1869-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
8310 | 8310 | Charles Denison D000235 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
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 | |||||||||||||
8334 | 8334 | John French F000378 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8336 | 8336 | Adam Glossbrenner G000242 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 15 | |||||||||||||
8337 | 8337 | James Goss G000335 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8338 | 8338 | Joseph Gravely G000389 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8341 | 8341 | John Griswold G000486 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 15 | |||||||||||||
8342 | 8342 | Asa Grover G000503 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8343 | 8343 | Cornelius Hamilton H000106 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8345 | 8345 | Abner Harding H000188 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8349 | 8349 | Thomas Haughey H000352 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8352 | 8352 | William Higby H000576 | rep | CA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8353 | 8353 | James Hinds H000631 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
8361 | 8361 | Asahel Hubbard H000877 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8363 | 8363 | Chester Hubbard H000879 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8364 | 8364 | Richard Hubbard H000888 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8367 | 8367 | Calvin Hulburd H000936 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 17 | |||||||||||||
8369 | 8369 | James Humphrey H000955 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 30 | |||||||||||||
8373 | 8373 | Francis Kellogg K000064 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8374 | 8374 | Bethuel Kitchen K000247 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8376 | 8376 | William Koontz K000311 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 16 | |||||||||||||
8377 | 8377 | William Lincoln L000317 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 26 | |||||||||||||
8380 | 8380 | Benjamin Loan L000384 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8381 | 8381 | Rufus Mallory M000083 | rep | OR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8382 | 8382 | James Mann M000103 | rep | LA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8384 | 8384 | Turner Marquette M000140 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8387 | 8387 | James Marvin M000210 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 18 | |||||||||||||
8390 | 8390 | Joseph McClurg M000347 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8392 | 8392 | Hiram McCullough M000395 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8394 | 8394 | Samuel McKee M000497 | rep | KY | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8396 | 8396 | George Miller M000726 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 14 | |||||||||||||
8401 | 8401 | James Moorhead M000929 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 22 | |||||||||||||
8402 | 8402 | James Mullins M001073 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8403 | 8403 | Carman Newcomb N000065 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
8408 | 8408 | Benjamin Norris N000138 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8416 | 8416 | Sidney Perham P000226 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8417 | 8417 | Solomon Pettis P000274 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 20 | |||||||||||||
8419 | 8419 | Charles Phelps P000292 | rep | MD | 1867-03-04 | 1869-03-03 | Conservative | 3 | |||||||||||||
8420 | 8420 | Charles Pierce P000332 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8424 | 8424 | Frederick Pike P000346 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8425 | 8425 | William Pile P000350 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8427 | 8427 | Tobias Plants P000376 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 15 | |||||||||||||
8428 | 8428 | Daniel Polsley P000418 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8434 | 8434 | Theodore Pomeroy P000424 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 24 | |||||||||||||
8436 | 8436 | John Pruyn P000554 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 14 | |||||||||||||
8437 | 8437 | Green Raum R000071 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 13 | |||||||||||||
8438 | 8438 | William Robertson R000328 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
8441 | 8441 | Lewis Ross R000451 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 9 | |||||||||||||
8442 | 8442 | Lewis Selye S000237 | rep | NY | 1867-03-04 | 1869-03-03 | Ind. Republican | 28 | |||||||||||||
8444 | 8444 | Charles Sitgreaves S000458 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8447 | 8447 | Rufus Spalding S000697 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 18 | |||||||||||||
8454 | 8454 | Thaddeus Stevens S000887 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8455 | 8455 | Thomas Stewart S000920 | rep | NY | 1867-03-04 | 1869-03-03 | Conservative Republican | 6 |
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);