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
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
start (date) 7 ✖
- 1813-05-24 204
- 1809-05-22 7
- 1811-11-04 5
- 1810-01-01 2
- 1814-01-01 2
- 1810-12-04 1
- 1814-02-24 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
948 | 948 | Richard Brent B000802 | sen | VA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1012 | 1012 | John Lambert L000036 | sen | NJ | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1017 | 1017 | Michael Leib L000229 | sen | PA | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1056 | 1056 | Jonathan Robinson R000346 | sen | VT | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1095 | 1095 | Thomas Worthington W000750 | sen | OH | 1810-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
1273 | 1273 | William Barnett B000161 | rep | GA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1303 | 1303 | Robert Brown B000942 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1305 | 1305 | Ezra Butler B001176 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1306 | 1306 | Hugh Caperton C000131 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 7 | |||||||||||||
1309 | 1309 | Langdon Cheves C000350 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1310 | 1310 | John Conard C000667 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1311 | 1311 | William Coxe C000843 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1312 | 1312 | Edward Crouch C000934 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1314 | 1314 | Samuel Dana D000023 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1334 | 1334 | William Ely E000168 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
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 | |||||||||||||
1337 | 1337 | Peter Forney F000279 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 11 | |||||||||||||
1341 | 1341 | Meshack Franklin F000346 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 13 | |||||||||||||
1343 | 1343 | James Geddes G000116 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 19 | |||||||||||||
1344 | 1344 | John Gloninger G000241 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1345 | 1345 | Theodore Gourdin G000345 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 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 | |||||||||||||
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 | |||||||||||||
1354 | 1354 | Nathaniel Howell H000867 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 | |||||||||||||
1355 | 1355 | Levi Hubbard H000887 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1359 | 1359 | Parry Humphreys H000962 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1361 | 1361 | John Hyneman H001026 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1365 | 1365 | Richard Jackson J000025 | rep | RI | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1368 | 1368 | William Kennedy K000116 | rep | NC | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1369 | 1369 | John Kershaw K000149 | rep | SC | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1372 | 1372 | John Lefferts L000213 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1373 | 1373 | Jacob Markell M000132 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 14 | |||||||||||||
1377 | 1377 | Alexander McKim M000515 | rep | MD | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1378 | 1378 | Morris Miller M000747 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1381 | 1381 | Joseph Pearson P000168 | rep | NC | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1382 | 1382 | Jotham Post P000455 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1387 | 1387 | Elisha Potter P000463 | rep | RI | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1392 | 1392 | John Rea R000089 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1394 | 1394 | William Reed R000130 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1396 | 1396 | William Richardson R000231 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1400 | 1400 | James Schureman S000150 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1401 | 1401 | Samuel Sherwood S000356 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1402 | 1402 | Zebulon Shipherd S000366 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1403 | 1403 | Richard Skinner S000469 | rep | VT | 1813-05-24 | 1815-03-03 | Republican | 0 | |||||||||||||
1404 | 1404 | Amos Slaymaker S000483 | rep | PA | 1813-05-24 | 1815-03-03 | Federalist | 3 | |||||||||||||
1405 | 1405 | Isaac Smith S000556 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
1412 | 1412 | John Smith S000564 | rep | VA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1413 | 1413 | Samuel Smith S000608 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
1415 | 1415 | Richard Stockton S000941 | rep | NJ | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1418 | 1418 | David Stone S000955 | sen | NC | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
1421 | 1421 | Adamson Tannehill T000036 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 14 | |||||||||||||
1422 | 1422 | Joel Thompson T000205 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1425 | 1425 | Francis White W000367 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1426 | 1426 | James Whitehill W000402 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1431 | 1431 | Robert Whitehill W000404 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | -1 | |||||||||||||
1432 | 1432 | Elisha Winter W000644 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1433 | 1433 | Abiel Wood W000687 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 17 | |||||||||||||
1436 | 1436 | Joseph Kerr K000141 | sen | OH | 1814-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
1440 | 1440 | Jonathan Roberts R000313 | sen | PA | 1814-02-24 | 1815-03-03 | 1 | Republican | |||||||||||||
1444 | 1444 | George Walker W000053 | sen | KY | 1814-01-01 | 1815-03-03 | 2 | Republican | |||||||||||||
1448 | 1448 | John Alexander A000096 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1452 | 1452 | Daniel Avery A000345 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1465 | 1465 | David Bard B000137 | rep | PA | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
1469 | 1469 | George Bradbury B000733 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1473 | 1473 | James Breckinridge B000785 | rep | VA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1476 | 1476 | Elijah Brigham B000833 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1482 | 1482 | James Caldwell C000033 | rep | OH | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1487 | 1487 | George Campbell C000083 | sen | TN | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
1498 | 1498 | Bradbury Cilley C000394 | rep | NH | 1813-05-24 | 1815-03-03 | Federalist | -1 | |||||||||||||
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 | |||||||||||||
1524 | 1524 | Thomas Cooper C000762 | rep | DE | 1813-05-24 | 1815-03-03 | Federalist | 0 |
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);