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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8349 | 8349 | Thomas Haughey H000352 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8373 | 8373 | Francis Kellogg K000064 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8408 | 8408 | Benjamin Norris N000138 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8420 | 8420 | Charles Pierce P000332 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8330 | 8330 | James Elliott E000123 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8353 | 8353 | James Hinds H000631 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8704 | 8704 | Logan Roots R000434 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8835 | 8835 | Thomas Boles B000603 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
8289 | 8289 | Cornelius Cole C000607 | sen | CA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8352 | 8352 | William Higby H000576 | rep | CA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8641 | 8641 | James Johnson J000145 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
10621 | 10621 | George Chilcott C000352 | rep | CO | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8358 | 8358 | Julius Hotchkiss H000809 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8364 | 8364 | Richard Hubbard H000888 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
9168 | 9168 | Orris Ferry F000094 | sen | CT | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9637 | 9637 | Henry Starkweather S000815 | rep | CT | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9709 | 9709 | William Barnum B000166 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
8265 | 8265 | James Bayard B000248 | sen | DE | 1867-03-04 | 1869-03-03 | 1 | Democrat | |||||||||||||
8405 | 8405 | John Nicholson N000099 | rep | DE | 1867-03-04 | 1869-03-03 | Democrat | 0 | |||||||||||||
8279 | 8279 | Walter Burleigh B001108 | rep | DK | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8614 | 8614 | Charles Hamilton H000105 | rep | FL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8555 | 8555 | Joseph Clift C000519 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8585 | 8585 | William Edwards E000085 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8607 | 8607 | Samuel Gove G000347 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8692 | 8692 | Charles Prince P000537 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8749 | 8749 | Nelson Tift T000269 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9428 | 9428 | Pierce Young Y000048 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
8311 | 8311 | Grenville Dodge D000395 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8348 | 8348 | James Harlan H000211 | sen | IA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8361 | 8361 | Asahel Hubbard H000877 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
9237 | 9237 | William Loughridge L000451 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
10174 | 10174 | Hiram Price P000525 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
12045 | 12045 | James Wilson W000594 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
14229 | 14229 | William Allison A000160 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8357 | 8357 | Edward Holbrook H000710 | rep | ID | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8272 | 8272 | Henry Bromwell B000865 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8345 | 8345 | Abner Harding H000188 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8437 | 8437 | Green Raum R000071 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 13 | |||||||||||||
8441 | 8441 | Lewis Ross R000451 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 9 | |||||||||||||
8475 | 8475 | Lyman Trumbull T000392 | sen | IL | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8537 | 8537 | Albert Burr B001134 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 10 | |||||||||||||
8635 | 8635 | Ebon Ingersoll I000017 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8646 | 8646 | Norman Judd J000277 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8774 | 8774 | Elihu Washburne W000176 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8863 | 8863 | Burton Cook C000715 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8891 | 8891 | John Farnsworth F000024 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
9247 | 9247 | Samuel Marshall M000160 | rep | IL | 1867-03-04 | 1869-03-03 | Democrat | 11 | |||||||||||||
11112 | 11112 | John Logan L000403 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
13239 | 13239 | Jehu Baker B000066 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 12 | |||||||||||||
15057 | 15057 | Shelby Cullom C000973 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8296 | 8296 | Schuyler Colfax C000626 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8484 | 8484 | Henry Washburn W000172 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8652 | 8652 | George Julian J000280 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
9127 | 9127 | John Coburn C000558 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
9279 | 9279 | Oliver Morton M001020 | sen | IN | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9292 | 9292 | William Niblack N000083 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
9353 | 9353 | John Shanks S000284 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 11 | |||||||||||||
9417 | 9417 | William Williams W000545 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
9554 | 9554 | Michael Kerr K000143 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9853 | 9853 | Morton Hunter H000985 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
10487 | 10487 | Godlove Orth O000106 | rep | IN | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
13337 | 13337 | William Holman H000732 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
8430 | 8430 | Samuel Pomeroy P000423 | sen | KS | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8552 | 8552 | Sidney Clarke C000470 | rep | KS | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8304 | 8304 | Garrett Davis D000099 | sen | KY | 1867-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8342 | 8342 | Asa Grover G000503 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8355 | 8355 | Elijah Hise H000644 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8394 | 8394 | Samuel McKee M000497 | rep | KY | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
8605 | 8605 | Jacob Golladay G000271 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8755 | 8755 | Lawrence Trimble T000375 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
9067 | 9067 | George Adams A000035 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
9457 | 9457 | John Brown B000933 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
9547 | 9547 | Thomas Jones J000253 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 6 | |||||||||||||
10418 | 10418 | James Knott K000290 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
11599 | 11599 | James Beck B000289 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
8266 | 8266 | William Blackburn B000510 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8382 | 8382 | James Mann M000103 | rep | LA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8482 | 8482 | Michel Vidal V000096 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8682 | 8682 | Joseph Newsham N000072 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9389 | 9389 | Jacob Sypher S001140 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8259 | 8259 | John Baldwin B000091 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
8329 | 8329 | Thomas Eliot E000106 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8804 | 8804 | Oakes Ames A000175 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
9042 | 9042 | Ginery Twichell T000443 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9095 | 9095 | George Boutwell B000674 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
9205 | 9205 | Samuel Hooper H000765 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
9436 | 9436 | William Washburn W000174 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 9 | |||||||||||||
9758 | 9758 | Benjamin Butler B001174 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
11341 | 11341 | Henry Dawes D000148 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 10 | |||||||||||||
11579 | 11579 | Nathaniel Banks B000116 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8392 | 8392 | Hiram McCullough M000395 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8419 | 8419 | Charles Phelps P000292 | rep | MD | 1867-03-04 | 1869-03-03 | Conservative | 3 | |||||||||||||
8468 | 8468 | Francis Thomas T000166 | rep | MD | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8737 | 8737 | Frederick Stone S000957 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
9073 | 9073 | Stevenson Archer A000274 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8416 | 8416 | Sidney Perham P000226 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 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);