legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
266 rows where "start" is on date 1867-03-04
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8468 | 8468 | Francis Thomas T000166 | rep | MD | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8469 | 8469 | John Trimble T000374 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8472 | 8472 | Rowland Trowbridge T000385 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8475 | 8475 | Lyman Trumbull T000392 | sen | IL | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8478 | 8478 | Charles Upson U000027 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8481 | 8481 | Burt Van Horn V000040 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 29 | |||||||||||||
8482 | 8482 | Michel Vidal V000096 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8484 | 8484 | Henry Washburn W000172 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8487 | 8487 | Thomas Williams W000538 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 23 | |||||||||||||
8489 | 8489 | Stephen Wilson W000613 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 18 | |||||||||||||
8492 | 8492 | Frederick Woodbridge W000708 | rep | VT | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8505 | 8505 | Samuel Arnell A000286 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8512 | 8512 | Alexander Bailey B000034 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 21 | |||||||||||||
8517 | 8517 | Fernando Beaman B000275 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8520 | 8520 | John Benjamin B000364 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8523 | 8523 | Jacob Benton B000395 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8528 | 8528 | Christopher Bowen B000681 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8537 | 8537 | Albert Burr B001134 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 10 | |||||||||||||
8539 | 8539 | Henry Cake C000024 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
8544 | 8544 | James Cavanaugh C000260 | rep | MT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8547 | 8547 | José Chaves C000337 | rep | NM | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8549 | 8549 | John Churchill C000392 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 22 | |||||||||||||
8552 | 8552 | Sidney Clarke C000470 | rep | KS | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8555 | 8555 | Joseph Clift C000519 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8559 | 8559 | Amasa Cobb C000543 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8566 | 8566 | John Covode C000818 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 21 | |||||||||||||
8571 | 8571 | John Deweese D000291 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8578 | 8578 | Nathan Dixon D000375 | rep | RI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8580 | 8580 | Oliver Dockery D000386 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8585 | 8585 | William Edwards E000085 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8587 | 8587 | Jacob Ela E000099 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8595 | 8595 | Orange Ferriss F000093 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 16 | |||||||||||||
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 | |||||||||||||
8607 | 8607 | Samuel Gove G000347 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8611 | 8611 | Charles Haight H000020 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8614 | 8614 | Charles Hamilton H000105 | rep | FL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8621 | 8621 | Isaac Hawkins H000370 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8623 | 8623 | David Heaton H000432 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8628 | 8628 | Benjamin Hopkins H000771 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8635 | 8635 | Ebon Ingersoll I000017 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8639 | 8639 | Thomas Jenckes J000076 | rep | RI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8641 | 8641 | James Johnson J000145 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8644 | 8644 | Alexander Jones J000208 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8646 | 8646 | Norman Judd J000277 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8652 | 8652 | George Julian J000280 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8656 | 8656 | William Kelsey K000080 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 25 | |||||||||||||
8660 | 8660 | Addison Laflin L000017 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 20 | |||||||||||||
8662 | 8662 | Israel Lash L000105 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8666 | 8666 | Dennis McCarthy M000310 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 23 | |||||||||||||
8673 | 8673 | William Moore M000922 | rep | NJ | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8675 | 8675 | Daniel Morrell M000964 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 17 | |||||||||||||
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 | |||||||||||||
8682 | 8682 | Joseph Newsham N000072 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8686 | 8686 | Halbert Paine P000028 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8692 | 8692 | Charles Prince P000537 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8701 | 8701 | Robert Ridgway R000248 | rep | VA | 1867-03-04 | 1869-03-03 | Whig | -1 | |||||||||||||
8704 | 8704 | Logan Roots R000434 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8713 | 8713 | Robert Schenck S000118 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8726 | 8726 | Aaron Stevens S000875 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8735 | 8735 | William Stokes S000950 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8737 | 8737 | Frederick Stone S000957 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8747 | 8747 | Caleb Taylor T000068 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8749 | 8749 | Nelson Tift T000269 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8752 | 8752 | Thomas Tipton T000286 | sen | NE | 1867-03-04 | 1869-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
8760 | 8760 | Hamilton Ward W000133 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 27 | |||||||||||||
8765 | 8765 | Cadwallader Washburn W000170 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8774 | 8774 | Elihu Washburne W000176 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8777 | 8777 | Martin Welker W000270 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 14 | |||||||||||||
8780 | 8780 | Benjamin Whittemore W000427 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8788 | 8788 | George Woodward W000730 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
8804 | 8804 | Oakes Ames A000175 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8807 | 8807 | John Beatty B000283 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8820 | 8820 | John Bingham B000471 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 16 | |||||||||||||
8825 | 8825 | Austin Blair B000521 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8835 | 8835 | Thomas Boles B000603 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8863 | 8863 | Burton Cook C000715 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8876 | 8876 | Oliver Dickey D000315 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8891 | 8891 | John Farnsworth F000024 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8908 | 8908 | James Getz G000145 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
8917 | 8917 | George Halsey H000087 | rep | NJ | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8936 | 8936 | William Hooper H000767 | rep | UT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8946 | 8946 | John Lynch L000531 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8953 | 8953 | James McCormick M000367 | rep | MO | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8964 | 8964 | Ulysses Mercur M000646 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 13 | |||||||||||||
8973 | 8973 | George Morgan M000950 | rep | OH | 1867-03-04 | 1869-03-03 | Democrat | 13 | |||||||||||||
8990 | 8990 | John Peters P000252 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
9011 | 9011 | Samuel Shellabarger S000325 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
9018 | 9018 | Worthington Smith S000641 | rep | VT | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9035 | 9035 | John Taffe T000006 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9042 | 9042 | Ginery Twichell T000443 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9047 | 9047 | Philadelph Van Trump V000060 | rep | OH | 1867-03-04 | 1869-03-03 | Democrat | 12 | |||||||||||||
9060 | 9060 | John Wilson W000603 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 11 | |||||||||||||
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 |
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);