legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
230 rows where "start" is on date 1865-12-04 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, class, district, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8077 | 8077 | John Alley A000155 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
14228 | 14228 | William Allison A000160 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8803 | 8803 | Oakes Ames A000175 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8080 | 8080 | Sydenham Ancona A000178 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 8 | |||||||||||||
8248 | 8248 | George Anderson A000188 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
10625 | 10625 | Henry Anthony A000262 | sen | RI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8504 | 8504 | Samuel Arnell A000286 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 6 | |||||||||||||
8250 | 8250 | Delos Ashley A000312 | rep | NV | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8255 | 8255 | James Ashley A000314 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
13238 | 13238 | Jehu Baker B000066 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 12 | |||||||||||||
8258 | 8258 | John Baldwin B000091 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
11578 | 11578 | Nathaniel Banks B000116 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8081 | 8081 | Abraham Barker B000142 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 17 | |||||||||||||
8084 | 8084 | Portus Baxter B000246 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8516 | 8516 | Fernando Beaman B000275 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8519 | 8519 | John Benjamin B000364 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8085 | 8085 | Teunis Bergen B000406 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
8086 | 8086 | John Bidwell B000447 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8819 | 8819 | John Bingham B000471 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
9715 | 9715 | James Blaine B000519 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8088 | 8088 | Henry Blow B000572 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
9094 | 9094 | George Boutwell B000674 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8269 | 8269 | Benjamin Boyer B000723 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 6 | |||||||||||||
8532 | 8532 | Allen Bradford B000737 | rep | CO | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8090 | 8090 | Augustus Brandegee B000768 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8271 | 8271 | Henry Bromwell B000865 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
9103 | 9103 | James Brooks B000881 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 8 | |||||||||||||
8274 | 8274 | John Broomall B000889 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8276 | 8276 | Ralph Buckland B001022 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
12449 | 12449 | Hezekiah Bundy B001059 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 11 | |||||||||||||
8278 | 8278 | Walter Burleigh B001108 | rep | DK | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8094 | 8094 | William Campbell C000104 | rep | TN | 1865-12-04 | 1867-03-03 | Unionist | 5 | |||||||||||||
8283 | 8283 | John Chanler C000302 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 7 | |||||||||||||
8546 | 8546 | José Chaves C000337 | rep | NM | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8285 | 8285 | Reader Clarke C000468 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8551 | 8551 | Sidney Clarke C000470 | rep | KS | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8558 | 8558 | Amasa Cobb C000543 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
10047 | 10047 | Alexander Coffroth C000593 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 16 | |||||||||||||
8295 | 8295 | Schuyler Colfax C000626 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
10051 | 10051 | Roscoe Conkling C000681 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 21 | |||||||||||||
8862 | 8862 | Burton Cook C000715 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8095 | 8095 | Edmund Cooper C000747 | rep | TN | 1865-12-04 | 1867-03-03 | Unionist | 4 | |||||||||||||
8869 | 8869 | Aaron Cragin C000852 | sen | NH | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8097 | 8097 | John Creswell C000904 | sen | MD | 1865-12-04 | 1867-03-03 | 3 | Unconditional Unionist | |||||||||||||
15056 | 15056 | Shelby Cullom C000973 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8098 | 8098 | Charles Culver C000977 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 20 | |||||||||||||
8099 | 8099 | William Darling D000055 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8101 | 8101 | Thomas Davis D000139 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 23 | |||||||||||||
11340 | 11340 | Henry Dawes D000148 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
8105 | 8105 | John Dawson D000153 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 21 | |||||||||||||
8106 | 8106 | Joseph Defrees D000192 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
8306 | 8306 | Columbus Delano D000214 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 13 | |||||||||||||
8108 | 8108 | Henry Deming D000227 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8309 | 8309 | Charles Denison D000235 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 12 | |||||||||||||
8109 | 8109 | Arthur Denny D000247 | rep | WA | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8577 | 8577 | Nathan Dixon D000375 | rep | RI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8110 | 8110 | William Dodge D000397 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8313 | 8313 | Ignatius Donnelly D000417 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8317 | 8317 | John Driggs D000498 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8112 | 8112 | Ebenezer Dumont D000524 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8320 | 8320 | Ephraim Eckley E000036 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 17 | |||||||||||||
8322 | 8322 | Benjamin Eggleston E000090 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
9160 | 9160 | Charles Eldredge E000103 | rep | WI | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
8328 | 8328 | Thomas Eliot E000106 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8890 | 8890 | John Farnsworth F000024 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8113 | 8113 | John Farquhar F000026 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
9802 | 9802 | Thomas Ferry F000095 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8117 | 8117 | William Fessenden F000099 | sen | ME | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
9172 | 9172 | William Finck F000118 | rep | OH | 1865-12-04 | 1867-03-03 | Democrat | 12 | |||||||||||||
10231 | 10231 | James Garfield G000063 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 19 | |||||||||||||
8335 | 8335 | Adam Glossbrenner G000242 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 15 | |||||||||||||
9181 | 9181 | Daniel Gooch G000274 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8119 | 8119 | John Goodwin G000301 | rep | AZ | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8121 | 8121 | Charles Goodyear G000307 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 14 | |||||||||||||
8126 | 8126 | Henry Grider G000455 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8128 | 8128 | James Grimes G000475 | sen | IA | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
8130 | 8130 | Josiah Grinnell G000478 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8340 | 8340 | John Griswold G000486 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 15 | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
9186 | 9186 | Robert Hale H000037 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
8134 | 8134 | Aaron Harding H000187 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
8344 | 8344 | Abner Harding H000188 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8136 | 8136 | Benjamin Harris H000232 | rep | MD | 1865-12-04 | 1867-03-03 | Democrat | 5 | |||||||||||||
8137 | 8137 | Roswell Hart H000292 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 28 | |||||||||||||
8620 | 8620 | Isaac Hawkins H000370 | rep | TN | 1865-12-04 | 1867-03-03 | Unionist | 7 | |||||||||||||
9727 | 9727 | Rutherford Hayes H000393 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8138 | 8138 | James Henderson H000480 | rep | OR | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8351 | 8351 | William Higby H000576 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8139 | 8139 | Ralph Hill H000604 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8354 | 8354 | Elijah Hise H000644 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8932 | 8932 | Phineas Hitchcock H000648 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8140 | 8140 | John Hogan H000691 | rep | MO | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8356 | 8356 | Edward Holbrook H000710 | rep | ID | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
13336 | 13336 | William Holman H000732 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8141 | 8141 | Sidney Holmes H000742 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 22 | |||||||||||||
9204 | 9204 | Samuel Hooper H000765 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8935 | 8935 | William Hooper H000767 | rep | UT | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8631 | 8631 | Giles Hotchkiss H000808 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 26 | |||||||||||||
8144 | 8144 | Jacob Howard H000839 | sen | MI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8360 | 8360 | Asahel Hubbard H000877 | rep | IA | 1865-12-04 | 1867-03-03 | 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);