legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
163 rows where "start" is on date 1811-11-04 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1492 | 1492 | Epaphroditus Champion C000288 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1547 | 1547 | John Davenport D000075 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1640 | 1640 | Lyman Law L000126 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1728 | 1728 | Lewis Sturges S001048 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1743 | 1743 | Benjamin Tallmadge T000029 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1897 | 1897 | Timothy Pitkin P000368 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
2086 | 2086 | Jonathan Moseley M001023 | rep | CT | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1106 | 1106 | James Bayard B000249 | sen | DE | 1811-11-04 | 1813-03-03 | 2 | Federalist | |||||||||||||
2935 | 2935 | Henry Ridgely R000245 | rep | DE | 1811-11-04 | 1813-03-03 | Federalist | 0 | |||||||||||||
1136 | 1136 | Howell Cobb C000547 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1141 | 1141 | William Crawford C000895 | sen | GA | 1811-11-04 | 1813-12-31 | 2 | Republican | |||||||||||||
1272 | 1272 | William Barnett B000161 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1282 | 1282 | William Bibb B000434 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1597 | 1597 | Bolling Hall H000045 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
3252 | 3252 | George Troup T000382 | rep | GA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1290 | 1290 | Shadrack Bond B000612 | rep | IL | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3147 | 3147 | Jonathan Jennings J000097 | rep | IN | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
1661 | 1661 | Samuel McKee M000496 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1684 | 1684 | Stephen Ormsby O000100 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1824 | 1824 | Joseph Desha D000271 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
2293 | 2293 | Anthony New N000058 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
3055 | 3055 | George Bibb B000433 | sen | KY | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
3957 | 3957 | Richard Johnson J000170 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
5930 | 5930 | Henry Clay C000482 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1906 | 1906 | Thomas Robertson R000326 | rep | LA | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
1098 | 1098 | Ezekiel Bacon B000015 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
1128 | 1128 | Francis Carr C000175 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 17 | |||||||||||||
1147 | 1147 | Richard Cutts C001033 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1153 | 1153 | Barzillai Gannett G000039 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1179 | 1179 | Isaiah Green G000413 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1211 | 1211 | Josiah Quincy Q000015 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1221 | 1221 | Ebenezer Seaver S000215 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 13 | |||||||||||||
1237 | 1237 | Peleg Tallman T000033 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 16 | |||||||||||||
1242 | 1242 | Charles Turner T000416 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
1254 | 1254 | Joseph Varnum V000074 | sen | MA | 1811-11-04 | 1817-03-03 | 2 | Democratic Republican | |||||||||||||
1255 | 1255 | Leonard White W000385 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 3 | |||||||||||||
1256 | 1256 | William Widgery W000444 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
1286 | 1286 | Abijah Bigelow B000453 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 11 | |||||||||||||
1333 | 1333 | William Ely E000168 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 5 | |||||||||||||
1393 | 1393 | William Reed R000130 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
1395 | 1395 | William Richardson R000231 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1475 | 1475 | Elijah Brigham B000833 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 10 | |||||||||||||
1735 | 1735 | Samuel Taggart T000012 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1763 | 1763 | Laban Wheaton W000329 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 9 | |||||||||||||
1185 | 1185 | Philip Key K000159 | rep | MD | 1811-11-04 | 1813-03-03 | Federalist | 3 | |||||||||||||
1201 | 1201 | John Montgomery M000867 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1376 | 1376 | Alexander McKim M000515 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1583 | 1583 | Charles Goldsborough G000261 | rep | MD | 1811-11-04 | 1813-03-03 | Federalist | 8 | |||||||||||||
1933 | 1933 | Philip Stuart S001036 | rep | MD | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1966 | 1966 | Stevenson Archer A000273 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
2116 | 2116 | Samuel Ringgold R000263 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
2355 | 2355 | Robert Wright W000768 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
2870 | 2870 | Peter Little L000354 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
3710 | 3710 | Joseph Kent K000125 | rep | MD | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1349 | 1349 | Edward Hempstead H000472 | rep | MO | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
3281 | 3281 | George Poindexter P000402 | rep | MS | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
1110 | 1110 | William Blackledge B000511 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1117 | 1117 | Thomas Blount B000569 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1138 | 1138 | James Cochran C000564 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1191 | 1191 | Archibald McBryde M000302 | rep | NC | 1811-11-04 | 1813-03-03 | Federalist | 7 | |||||||||||||
1244 | 1244 | James Turner T000423 | sen | NC | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1340 | 1340 | Meshack Franklin F000346 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
1380 | 1380 | Joseph Pearson P000168 | rep | NC | 1811-11-04 | 1813-03-03 | Federalist | 10 | |||||||||||||
1719 | 1719 | Richard Stanford S000794 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
2674 | 2674 | Nathaniel Macon M000034 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
2751 | 2751 | Israel Pickens P000322 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 11 | |||||||||||||
2943 | 2943 | Lemuel Sawyer S000089 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
3029 | 3029 | Willis Alston A000167 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
5870 | 5870 | William King K000217 | rep | NC | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1100 | 1100 | Josiah Bartlett B000207 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1148 | 1148 | Samuel Dinsmoor D000357 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1169 | 1169 | Nicholas Gilman G000215 | sen | NH | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1180 | 1180 | Obed Hall H000064 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1181 | 1181 | John Harper H000223 | rep | NH | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1236 | 1236 | George Sullivan S001052 | rep | NH | 1811-11-04 | 1813-03-03 | Federalist | -1 | |||||||||||||
1121 | 1121 | Adam Boyd B000714 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1189 | 1189 | George Maxwell M000267 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1202 | 1202 | James Morgan M000951 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1205 | 1205 | Thomas Newbold N000064 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1357 | 1357 | Jacob Hufty H000914 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | 0 | |||||||||||||
2000 | 2000 | John Condit C000671 | sen | NJ | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
3338 | 3338 | Lewis Condict C000668 | rep | NJ | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1111 | 1111 | Harmanus Bleecker B000555 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 7 | |||||||||||||
1139 | 1139 | Thomas Cooke C000734 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1150 | 1150 | James Emott E000176 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 4 | |||||||||||||
1151 | 1151 | Asa Fitch F000156 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1188 | 1188 | Robert Livingston L000370 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1192 | 1192 | Arunah Metcalf M000668 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
1198 | 1198 | Samuel Mitchill M000831 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1206 | 1206 | William Paulding P000146 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1207 | 1207 | Benjamin Pond P000425 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1216 | 1216 | Thomas Sammons S000023 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1235 | 1235 | Silas Stow S000984 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 10 | |||||||||||||
1240 | 1240 | Uri Tracy T000347 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 13 | |||||||||||||
1245 | 1245 | Pierre Van Cortlandt V000023 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1451 | 1451 | Daniel Avery A000345 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1578 | 1578 | Thomas Gold G000257 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 11 | |||||||||||||
1590 | 1590 | Thomas Grosvenor G000498 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1695 | 1695 | Peter Porter P000446 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
2121 | 2121 | Ebenezer Sage S000012 | rep | NY | 1811-11-04 | 1813-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);