legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
161 rows where "end" is on date 1867-03-03 and party = "Republican"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7695 | 7695 | Daniel Clark C000427 | sen | NH | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7718 | 7718 | Edgar Cowan C000819 | sen | PA | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7753 | 7753 | Lafayette Foster F000308 | sen | CT | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7762 | 7762 | Ira Harris H000242 | sen | NY | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7781 | 7781 | Henry Lane L000060 | sen | IN | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
7921 | 7921 | Benjamin Brown B000905 | sen | MO | 1863-12-07 | 1867-03-03 | 3 | Republican | |||||||||||||
7955 | 7955 | Solomon Foot F000248 | sen | VT | 1863-12-07 | 1867-03-03 | 1 | Republican | |||||||||||||
8077 | 8077 | John Alley A000155 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
8086 | 8086 | John Bidwell B000447 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8088 | 8088 | Henry Blow B000572 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8090 | 8090 | Augustus Brandegee B000768 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
8106 | 8106 | Joseph Defrees D000192 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
8108 | 8108 | Henry Deming D000227 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8109 | 8109 | Arthur Denny D000247 | rep | WA | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8110 | 8110 | William Dodge D000397 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8112 | 8112 | Ebenezer Dumont D000524 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8113 | 8113 | John Farquhar F000026 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8119 | 8119 | John Goodwin G000301 | rep | AZ | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8130 | 8130 | Josiah Grinnell G000478 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8137 | 8137 | Roswell Hart H000292 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 28 | |||||||||||||
8138 | 8138 | James Henderson H000480 | rep | OR | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8139 | 8139 | Ralph Hill H000604 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8141 | 8141 | Sidney Holmes H000742 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 22 | |||||||||||||
8145 | 8145 | Demas Hubbard H000881 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 19 | |||||||||||||
8147 | 8147 | John Hubbard H000885 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8149 | 8149 | James Hubbell H000893 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8151 | 8151 | James Humphrey H000954 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8159 | 8159 | Orlando Kellogg K000066 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
8161 | 8161 | Andrew Kuykendall K000347 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 13 | |||||||||||||
8164 | 8164 | James Lane L000061 | sen | KS | 1865-12-04 | 1867-03-03 | 2 | Republican | |||||||||||||
8170 | 8170 | John Longyear L000434 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8173 | 8173 | Walter McIndoe M000476 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8176 | 8176 | Donald McRuer M000600 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8178 | 8178 | Daniel Morris M000974 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 25 | |||||||||||||
8181 | 8181 | William Newell N000066 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8187 | 8187 | Henry Raymond R000084 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8191 | 8191 | Alexander Rice R000193 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8194 | 8194 | John Rice R000201 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8203 | 8203 | Ithamar Sloan S000492 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8207 | 8207 | John Starr S000817 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8208 | 8208 | Thomas Stilwell S000926 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 11 | |||||||||||||
8215 | 8215 | Martin Thayer T000150 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8219 | 8219 | Samuel Warner W000157 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8229 | 8229 | John Wentworth W000295 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8244 | 8244 | George Fogg F000234 | sen | NH | 1866-01-01 | 1867-03-03 | 3 | Republican | |||||||||||||
8248 | 8248 | George Anderson A000188 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
8258 | 8258 | John Baldwin B000091 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8271 | 8271 | Henry Bromwell B000865 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
8278 | 8278 | Walter Burleigh B001108 | rep | DK | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8285 | 8285 | Reader Clarke C000468 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8295 | 8295 | Schuyler Colfax C000626 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8306 | 8306 | Columbus Delano D000214 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8328 | 8328 | Thomas Eliot E000106 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8340 | 8340 | John Griswold G000486 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 15 | |||||||||||||
8344 | 8344 | Abner Harding H000188 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
8351 | 8351 | William Higby H000576 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8360 | 8360 | Asahel Hubbard H000877 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8366 | 8366 | Calvin Hulburd H000936 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 17 | |||||||||||||
8375 | 8375 | William Koontz K000311 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
8379 | 8379 | Benjamin Loan L000384 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8383 | 8383 | Turner Marquette M000140 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8386 | 8386 | James Marvin M000210 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 18 | |||||||||||||
8389 | 8389 | Joseph McClurg M000347 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8395 | 8395 | George Miller M000726 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 14 | |||||||||||||
8400 | 8400 | James Moorhead M000929 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 22 | |||||||||||||
8406 | 8406 | Thomas Noell N000123 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8409 | 8409 | James Nye N000177 | sen | NV | 1864-01-01 | 1867-03-03 | 3 | Republican | |||||||||||||
8412 | 8412 | James Patterson P000120 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8415 | 8415 | Sidney Perham P000226 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8423 | 8423 | Frederick Pike P000346 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8426 | 8426 | Tobias Plants P000376 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 15 | |||||||||||||
8429 | 8429 | Samuel Pomeroy P000423 | sen | KS | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
8433 | 8433 | Theodore Pomeroy P000424 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 24 | |||||||||||||
8446 | 8446 | Rufus Spalding S000697 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 18 | |||||||||||||
8453 | 8453 | Thaddeus Stevens S000887 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8471 | 8471 | Rowland Trowbridge T000385 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8474 | 8474 | Lyman Trumbull T000392 | sen | IL | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
8477 | 8477 | Charles Upson U000027 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8480 | 8480 | Burt Van Horn V000040 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 29 | |||||||||||||
8483 | 8483 | Henry Washburn W000172 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8486 | 8486 | Thomas Williams W000538 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 23 | |||||||||||||
8488 | 8488 | Stephen Wilson W000613 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 18 | |||||||||||||
8491 | 8491 | Frederick Woodbridge W000708 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
8532 | 8532 | Allen Bradford B000737 | rep | CO | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8546 | 8546 | José Chaves C000337 | rep | NM | 1865-12-04 | 1867-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);