legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
343 rows where "start" is on date 1873-12-01 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9070 | 9070 | George Adams A000035 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9071 | 9071 | William Albert A000074 | rep | MD | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9072 | 9072 | Charles Albright A000077 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
14231 | 14231 | William Allison A000160 | sen | IA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9076 | 9076 | Stevenson Archer A000274 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9078 | 9078 | Moses Armstrong A000283 | rep | DK | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9080 | 9080 | William Arthur A000304 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9444 | 9444 | Thomas Ashe A000309 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
10259 | 10259 | John Atkins A000327 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9082 | 9082 | John Averill A000344 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9736 | 9736 | Henry Banning B000117 | rep | OH | 1873-12-01 | 1875-03-03 | Liberal Republican | 2 | |||||||||||||
9084 | 9084 | Joel Barber B000122 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9712 | 9712 | William Barnum B000166 | rep | CT | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9085 | 9085 | Granville Barrere B000173 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9088 | 9088 | Henry Barry B000189 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9447 | 9447 | Lyman Bass B000221 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 31 | |||||||||||||
11602 | 11602 | James Beck B000289 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9089 | 9089 | Josiah Begole B000316 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9741 | 9741 | Hiram Bell B000336 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9090 | 9090 | John Berry B000419 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 14 | |||||||||||||
9091 | 9091 | James Biery B000450 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9719 | 9719 | James Blaine B000519 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
13576 | 13576 | Richard Bland B000544 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
12087 | 12087 | James Blount B000568 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9092 | 9092 | Lewis Bogy B000595 | sen | MO | 1873-12-01 | 1877-12-31 | 3 | Democrat | |||||||||||||
9097 | 9097 | George Boutwell B000674 | sen | MA | 1873-12-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9098 | 9098 | Rees Bowen B000685 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9454 | 9454 | Nathan Bradley B000744 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10020 | 10020 | John Bright B000836 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9099 | 9099 | Frederick Bromberg B000864 | rep | AL | 1873-12-01 | 1875-03-03 | Liberal Republican | 1 | |||||||||||||
9107 | 9107 | James Brooks B000881 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9458 | 9458 | John Brown B000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
10655 | 10655 | Aylett Buckner B001031 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
9468 | 9468 | James Buffinton B001040 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
12450 | 12450 | Hezekiah Bundy B001059 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
9754 | 9754 | Horatio Burchard B001070 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9471 | 9471 | John Burleigh B001107 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
14603 | 14603 | Julius Burrows B001142 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9761 | 9761 | Benjamin Butler B001174 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
11315 | 11315 | Roderick Butler B001188 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9763 | 9763 | Richard Cain C000022 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9475 | 9475 | John Caldwell C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9111 | 9111 | Simon Cameron C000068 | sen | PA | 1873-12-01 | 1877-12-31 | 3 | Republican | |||||||||||||
10284 | 10284 | George Cannon C000119 | rep | UT | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
18093 | 18093 | Joseph Cannon C000121 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 14 | |||||||||||||
9112 | 9112 | Lewis Carpenter C000170 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9480 | 9480 | Thomas Cason C000232 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9483 | 9483 | Bernard Caulfield C000255 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9114 | 9114 | John Cessna C000265 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
9724 | 9724 | Jerome Chaffee C000271 | rep | CO | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9116 | 9116 | Norton Chipman C000370 | rep | DC | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
10031 | 10031 | Simeon Chittenden C000373 | rep | NY | 1873-12-01 | 1875-03-03 | Ind. Republican | 3 | |||||||||||||
9117 | 9117 | Amos Clark C000421 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
10292 | 10292 | John Clark C000442 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
9120 | 9120 | Freeman Clarke C000461 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 29 | |||||||||||||
9121 | 9121 | Charles Clayton C000493 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9122 | 9122 | Isaac Clements C000507 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 18 | |||||||||||||
10042 | 10042 | Hiester Clymer C000539 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
9125 | 9125 | Clinton Cobb C000544 | rep | NC | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9126 | 9126 | Stephen Cobb C000551 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9130 | 9130 | John Coburn C000558 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9132 | 9132 | Abram Comingo C000658 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10301 | 10301 | Omar Conger C000678 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
10053 | 10053 | Roscoe Conkling C000681 | sen | NY | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9133 | 9133 | Simon Conover C000701 | sen | FL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
10306 | 10306 | Philip Cook C000724 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9134 | 9134 | Franklin Corwin C000789 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9136 | 9136 | Aylett Cotton C000801 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
11697 | 11697 | Samuel Cox C000839 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
13916 | 13916 | Thomas Creamer C000899 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9776 | 9776 | Thomas Crittenden C000913 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9138 | 9138 | Alvah Crocker C000916 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9139 | 9139 | Philip Crooke C000927 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9141 | 9141 | Edward Crossland C000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9489 | 9489 | Lorenzo Crounse C000935 | rep | NE | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9142 | 9142 | Robert Crozier C000952 | sen | KS | 1873-12-01 | 1875-03-03 | 2 | Republican | |||||||||||||
9143 | 9143 | William Crutchfield C000961 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9146 | 9146 | Carlton Curtis C001007 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 19 | |||||||||||||
13628 | 13628 | Lorenzo Danford D000028 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
10324 | 10324 | Chester Darrall D000062 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9147 | 9147 | Alexander Davis D000091 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9149 | 9149 | John Davis D000119 | rep | WV | 1873-12-01 | 1875-03-03 | Ind. Democrat | 1 | |||||||||||||
11344 | 11344 | Henry Dawes D000148 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
9151 | 9151 | George Dennis D000242 | sen | MD | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
9150 | 9150 | David De Witt D000285 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 14 | |||||||||||||
9493 | 9493 | Samuel Dobbins D000383 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9153 | 9153 | William Donnan D000413 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9154 | 9154 | Stephen Dorsey D000441 | sen | AR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9158 | 9158 | Rodolphus Duell D000513 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 24 | |||||||||||||
11741 | 11741 | Mark Dunnell D000555 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9789 | 9789 | Milton Durham D000572 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
9793 | 9793 | Benjamin Eames E000005 | rep | RI | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
11020 | 11020 | John Eden E000042 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
9164 | 9164 | Charles Eldredge E000103 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
15093 | 15093 | Stephen Elkins E000110 | rep | NM | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9166 | 9166 | Robert Elliott E000128 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
11364 | 11364 | Charles Farwell F000037 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9169 | 9169 | Orris Ferry F000094 | sen | CT | 1873-12-01 | 1875-12-31 | 3 | Republican | |||||||||||||
9170 | 9170 | Moses Field F000105 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9173 | 9173 | William Finck F000118 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 12 |
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);