legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
222 rows where "end" is on date 1815-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448 | 1448 | John Alexander A000096 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
3030 | 3030 | Willis Alston A000167 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1796 | 1796 | William Anderson A000235 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1967 | 1967 | Stevenson Archer A000273 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1452 | 1452 | Daniel Avery A000345 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
3039 | 3039 | Philip Barbour B000131 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1465 | 1465 | David Bard B000137 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1273 | 1273 | William Barnett B000161 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
3609 | 3609 | William Baylies B000256 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1274 | 1274 | Thomas Bayly B000260 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1275 | 1275 | Reasin Beall B000273 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1278 | 1278 | Egbert Benson B000388 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
3055 | 3055 | George Bibb B000433 | sen | KY | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1287 | 1287 | Abijah Bigelow B000453 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 11 | |||||||||||||
1288 | 1288 | Thomas Bines B000467 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1289 | 1289 | Jesse Bledsoe B000554 | sen | KY | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
1291 | 1291 | Shadrack Bond B000612 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1292 | 1292 | John Bowen B000684 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1293 | 1293 | John Bowers B000691 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1294 | 1294 | Alexander Boyd B000715 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1469 | 1469 | George Bradbury B000733 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
2562 | 2562 | William Bradley B000748 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1473 | 1473 | James Breckinridge B000785 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1476 | 1476 | Elijah Brigham B000833 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1303 | 1303 | Robert Brown B000942 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1985 | 1985 | William Burwell B001160 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 14 | |||||||||||||
1305 | 1305 | Ezra Butler B001176 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1482 | 1482 | James Caldwell C000033 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
5634 | 5634 | John Calhoun C000044 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1487 | 1487 | George Campbell C000083 | sen | TN | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
2215 | 2215 | Newton Cannon C000123 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1306 | 1306 | Hugh Caperton C000131 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1493 | 1493 | Epaphroditus Champion C000288 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1495 | 1495 | John Chappell C000320 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1309 | 1309 | Langdon Cheves C000350 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1498 | 1498 | Bradbury Cilley C000394 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
3062 | 3062 | James Clark C000436 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
5931 | 5931 | Henry Clay C000482 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1511 | 1511 | David Clendenin C000510 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1521 | 1521 | John Clopton C000531 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 23 | |||||||||||||
1814 | 1814 | Oliver Comstock C000664 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1310 | 1310 | John Conard C000667 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
3339 | 3339 | Lewis Condict C000668 | rep | NJ | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1524 | 1524 | Thomas Cooper C000762 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 | |||||||||||||
1311 | 1311 | William Coxe C000843 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1528 | 1528 | William Crawford C000894 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
3354 | 3354 | William Creighton C000902 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1312 | 1312 | Edward Crouch C000934 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
2824 | 2824 | John Culpepper C000976 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
4183 | 4183 | Alfred Cuthbert C001023 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1314 | 1314 | Samuel Dana D000023 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1539 | 1539 | Samuel Dana D000024 | sen | CT | 1810-12-04 | 1815-03-03 | 1 | Federalist | |||||||||||||
1548 | 1548 | John Davenport D000075 | rep | CT | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1316 | 1316 | Roger Davis D000133 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1317 | 1317 | Samuel Davis D000134 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1326 | 1326 | John Dawson D000151 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1327 | 1327 | Peter Denoyelles D000252 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1825 | 1825 | Joseph Desha D000271 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1328 | 1328 | Daniel Dewey D000293 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1329 | 1329 | William Duval D000577 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
2015 | 2015 | Elias Earle E000007 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1551 | 1551 | Rufus Easton E000022 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1334 | 1334 | William Ely E000168 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1834 | 1834 | John Eppes E000197 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 16 | |||||||||||||
1335 | 1335 | David Evans E000238 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1336 | 1336 | Samuel Farrow F000036 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1562 | 1562 | William Findley F000124 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1839 | 1839 | James Fisk F000154 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1565 | 1565 | Jonathan Fisk F000155 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1337 | 1337 | Peter Forney F000279 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
3383 | 3383 | John Forsyth F000284 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1341 | 1341 | Meshack Franklin F000346 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 13 | |||||||||||||
1568 | 1568 | William Gaston G000096 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
1343 | 1343 | James Geddes G000116 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 19 | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1573 | 1573 | Thomas Gholson G000150 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 18 | |||||||||||||
1163 | 1163 | William Giles G000183 | sen | VA | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1169 | 1169 | Nicholas Gilman G000215 | sen | NH | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1575 | 1575 | Hugh Glasgow G000231 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1344 | 1344 | John Gloninger G000241 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1584 | 1584 | Charles Goldsborough G000261 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1850 | 1850 | Peterson Goodwyn G000306 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 19 | |||||||||||||
1586 | 1586 | Christopher Gore G000322 | sen | MA | 1813-05-24 | 1815-03-03 | 1 | Federalist | |||||||||||||
1345 | 1345 | Theodore Gourdin G000345 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1588 | 1588 | Isaac Griffin G000461 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 13 | |||||||||||||
1591 | 1591 | Thomas Grosvenor G000498 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
4493 | 4493 | Felix Grundy G000509 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1595 | 1595 | William Hale H000039 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1598 | 1598 | Bolling Hall H000045 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1779 | 1779 | Alexander Hanson H000176 | rep | MD | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1346 | 1346 | Thomas Harris H000254 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1347 | 1347 | Abraham Hasbrouck H000313 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1602 | 1602 | Aylett Hawes H000361 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
1348 | 1348 | Joseph Hawkins H000372 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1350 | 1350 | Edward Hempstead H000472 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1351 | 1351 | Samuel Henderson H000487 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1352 | 1352 | Samuel Hopkins H000778 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1353 | 1353 | Samuel Hopkins H000780 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 |
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);