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 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9067 | 9067 | George Adams A000035 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
14229 | 14229 | William Allison A000160 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8804 | 8804 | Oakes Ames A000175 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8249 | 8249 | George Anderson A000188 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
9073 | 9073 | Stevenson Archer A000274 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8505 | 8505 | Samuel Arnell A000286 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
13239 | 13239 | Jehu Baker B000066 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 12 | |||||||||||||
8259 | 8259 | John Baldwin B000091 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
11579 | 11579 | Nathaniel Banks B000116 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8260 | 8260 | Demas Barnes B000156 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9709 | 9709 | William Barnum B000166 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
8517 | 8517 | Fernando Beaman B000275 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8807 | 8807 | John Beatty B000283 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
11599 | 11599 | James Beck B000289 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
8820 | 8820 | John Bingham B000471 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 16 | |||||||||||||
8266 | 8266 | William Blackburn B000510 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
9716 | 9716 | James Blaine B000519 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
9095 | 9095 | George Boutwell B000674 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8528 | 8528 | Christopher Bowen B000681 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
9104 | 9104 | James Brooks B000881 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
8275 | 8275 | John Broomall B000889 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
9457 | 9457 | John Brown B000933 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8277 | 8277 | Ralph Buckland B001022 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8279 | 8279 | Walter Burleigh B001108 | rep | DK | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8537 | 8537 | Albert Burr B001134 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 10 | |||||||||||||
9758 | 9758 | Benjamin Butler B001174 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
11312 | 11312 | Roderick Butler B001188 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8539 | 8539 | Henry Cake C000024 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
9110 | 9110 | Simon Cameron C000068 | sen | PA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8281 | 8281 | Samuel Cary C000216 | rep | OH | 1867-03-04 | 1869-03-03 | Ind. Republican | 2 | |||||||||||||
8544 | 8544 | James Cavanaugh C000260 | rep | MT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8284 | 8284 | John Chanler C000302 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
8547 | 8547 | José Chaves C000337 | rep | NM | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
10621 | 10621 | George Chilcott C000352 | rep | CO | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8549 | 8549 | John Churchill C000392 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 22 | |||||||||||||
8286 | 8286 | Reader Clarke C000468 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8552 | 8552 | Sidney Clarke C000470 | rep | KS | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8287 | 8287 | Charles Clever C000517 | rep | NM | 1867-03-04 | 1869-03-03 | -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 | |||||||||||||
9127 | 9127 | John Coburn C000558 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8289 | 8289 | Cornelius Cole C000607 | sen | CA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8296 | 8296 | Schuyler Colfax C000626 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
10052 | 10052 | Roscoe Conkling C000681 | sen | NY | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8863 | 8863 | Burton Cook C000715 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8297 | 8297 | Henry Corbett C000771 | sen | OR | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8298 | 8298 | Manuel Corley C000778 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
10311 | 10311 | Thomas Cornell C000783 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 13 | |||||||||||||
8566 | 8566 | John Covode C000818 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 21 | |||||||||||||
15057 | 15057 | Shelby Cullom C000973 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8304 | 8304 | Garrett Davis D000099 | sen | KY | 1867-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
11341 | 11341 | Henry Dawes D000148 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
8571 | 8571 | John Deweese D000291 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8876 | 8876 | Oliver Dickey D000315 | rep | PA | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8315 | 8315 | Charles Drake D000484 | sen | MO | 1867-03-04 | 1871-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
8585 | 8585 | William Edwards E000085 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8323 | 8323 | Benjamin Eggleston E000090 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8587 | 8587 | Jacob Ela E000099 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9161 | 9161 | Charles Eldredge E000103 | rep | WI | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
8891 | 8891 | John Farnsworth F000024 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8595 | 8595 | Orange Ferriss F000093 | rep | NY | 1867-03-04 | 1869-03-03 | Republican | 16 | |||||||||||||
9168 | 9168 | Orris Ferry F000094 | sen | CT | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9803 | 9803 | Thomas Ferry F000095 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
8599 | 8599 | John Fox F000331 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
8334 | 8334 | John French F000378 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
10232 | 10232 | James Garfield G000063 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 19 | |||||||||||||
8908 | 8908 | James Getz G000145 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
8336 | 8336 | Adam Glossbrenner G000242 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 15 | |||||||||||||
8605 | 8605 | Jacob Golladay G000271 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8337 | 8337 | James Goss G000335 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8607 | 8607 | Samuel Gove G000347 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8338 | 8338 | Joseph Gravely G000389 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 4 |
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);