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 state_rank
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
9082 | 9082 | John Averill A000344 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9084 | 9084 | Joel Barber B000122 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
9089 | 9089 | Josiah Begole B000316 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
9111 | 9111 | Simon Cameron C000068 | sen | PA | 1873-12-01 | 1877-12-31 | 3 | Republican | |||||||||||||
9112 | 9112 | Lewis Carpenter C000170 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9114 | 9114 | John Cessna C000265 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
9116 | 9116 | Norton Chipman C000370 | rep | DC | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
9117 | 9117 | Amos Clark C000421 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
9133 | 9133 | Simon Conover C000701 | sen | FL | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
9150 | 9150 | David De Witt D000285 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 14 | |||||||||||||
9151 | 9151 | George Dennis D000242 | sen | MD | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
9164 | 9164 | Charles Eldredge E000103 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9166 | 9166 | Robert Elliott E000128 | rep | SC | 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 | |||||||||||||
9175 | 9175 | Wilder Foster F000315 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9176 | 9176 | James Freeman F000362 | rep | GA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9182 | 9182 | Daniel Gooch G000274 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9183 | 9183 | Lewis Gunckel G000523 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9184 | 9184 | John Hagans H000011 | rep | WV | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9185 | 9185 | John Hager H000016 | sen | CA | 1873-12-01 | 1875-03-03 | 1 | Democrat | |||||||||||||
9187 | 9187 | Robert Hale H000037 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 17 | |||||||||||||
9188 | 9188 | Horace Harrison H000271 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9190 | 9190 | Harrison Havens H000357 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9193 | 9193 | John Hawley H000376 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9195 | 9195 | Gerry Hazelton H000419 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9197 | 9197 | John Hazelton H000420 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9199 | 9199 | William Herndon H000535 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9200 | 9200 | Ebenezer Hoar H000653 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9201 | 9201 | Asa Hodges H000671 | rep | AR | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9208 | 9208 | Samuel Hooper H000765 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9210 | 9210 | Sherman Houghton H000815 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
9211 | 9211 | Albert Howe H000850 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9214 | 9214 | Timothy Howe H000856 | sen | WI | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9215 | 9215 | Ira Hyde H001023 | rep | MO | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
9216 | 9216 | William Hynes H001027 | rep | AR | 1873-12-01 | 1875-03-03 | Liberal Republican | -1 | |||||||||||||
9217 | 9217 | Hugh Jewett J000105 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9220 | 9220 | Stephen Kellogg K000067 | rep | CT | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9222 | 9222 | Charles Kendall K000090 | rep | NV | 1873-12-01 | 1875-03-03 | Democrat | 0 | |||||||||||||
9224 | 9224 | Charles Lamison L000039 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9226 | 9226 | William Lamport L000042 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 26 | |||||||||||||
9229 | 9229 | William Lansing L000088 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 23 | |||||||||||||
9230 | 9230 | Effingham Lawrence L000132 | rep | LA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9231 | 9231 | John Lawson L000144 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9234 | 9234 | James Leach L000170 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9235 | 9235 | Barbour Lewis L000271 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9236 | 9236 | James Lofland L000398 | rep | DE | 1873-12-01 | 1875-03-03 | Republican | 0 | |||||||||||||
9239 | 9239 | William Loughridge L000451 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9241 | 9241 | David Lowe L000473 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9242 | 9242 | Lloyd Lowndes L000481 | rep | MD | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9243 | 9243 | John Magee M000048 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
9250 | 9250 | Samuel Marshall M000160 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 19 | |||||||||||||
9251 | 9251 | James Martin M000184 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
9259 | 9259 | Horace Maynard M000284 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9261 | 9261 | Thomas McCreery M000385 | sen | KY | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
9262 | 9262 | Alexander McDill M000406 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9263 | 9263 | Obadiah McFadden M000435 | rep | WA | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9265 | 9265 | Ebenezer McJunkin M000487 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 23 | |||||||||||||
9269 | 9269 | George McKee M000494 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9270 | 9270 | William McLean M000553 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9271 | 9271 | John McNulta M000587 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 13 | |||||||||||||
9272 | 9272 | David Mellish M000637 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9274 | 9274 | Clinton Merriam M000653 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 21 | |||||||||||||
9275 | 9275 | Augustus Merrimon M000659 | sen | NC | 1873-12-01 | 1879-03-03 | 3 | Democrat |
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);