legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,677 rows where state = "MA"
This data as json, copyable, CSV (advanced)
party >10 ✖
- Republican 712
- Democrat 515
- Whig 133
- Federalist 116
- Adams 33
- American 11
- Democratic Republican 11
- Anti Jacksonian 7
- Anti Masonic 5
- Free Soil 4
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
773 | 773 | Peleg Wadsworth W000014 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 4 | |||||||||||||
774 | 774 | Peleg Wadsworth W000014 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 13 | |||||||||||||
775 | 775 | Peleg Wadsworth W000014 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 13 | |||||||||||||
776 | 776 | Peleg Wadsworth W000014 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 13 | |||||||||||||
777 | 777 | Peleg Wadsworth W000014 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 13 | |||||||||||||
778 | 778 | Peleg Wadsworth W000014 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
779 | 779 | Peleg Wadsworth W000014 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 15 | |||||||||||||
800 | 800 | Joseph Barker B000144 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
801 | 801 | Joseph Barker B000144 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 7 | |||||||||||||
802 | 802 | Barnabas Bidwell B000446 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
803 | 803 | Barnabas Bidwell B000446 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | -1 | |||||||||||||
825 | 825 | Jacob Crowninshield C000947 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
826 | 826 | Jacob Crowninshield C000947 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
827 | 827 | Jacob Crowninshield C000947 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
830 | 830 | Josiah Dean D000173 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 9 | |||||||||||||
860 | 860 | Daniel Ilsley I000009 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 15 | |||||||||||||
897 | 897 | Joseph Story S000978 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
937 | 937 | Joseph Allen A000136 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 10 | |||||||||||||
964 | 964 | Orchard Cook C000723 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
965 | 965 | Orchard Cook C000723 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 16 | |||||||||||||
966 | 966 | Orchard Cook C000723 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 16 | |||||||||||||
972 | 972 | Gideon Gardner G000054 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1018 | 1018 | Edward Livermore L000363 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1019 | 1019 | Edward Livermore L000363 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 3 | |||||||||||||
1048 | 1048 | Benjamin Pickman P000330 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 2 | |||||||||||||
1068 | 1068 | William Stedman S000828 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 11 | |||||||||||||
1069 | 1069 | William Stedman S000828 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 11 | |||||||||||||
1070 | 1070 | William Stedman S000828 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 11 | |||||||||||||
1071 | 1071 | William Stedman S000828 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 11 | |||||||||||||
1076 | 1076 | Jabez Upham U000023 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 10 | |||||||||||||
1077 | 1077 | Jabez Upham U000023 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 10 | |||||||||||||
1096 | 1096 | Ezekiel Bacon B000015 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 12 | |||||||||||||
1097 | 1097 | Ezekiel Bacon B000015 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 12 | |||||||||||||
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 | |||||||||||||
1142 | 1142 | Richard Cutts C001033 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 14 | |||||||||||||
1143 | 1143 | Richard Cutts C001033 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 14 | |||||||||||||
1144 | 1144 | Richard Cutts C001033 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
1145 | 1145 | Richard Cutts C001033 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 14 | |||||||||||||
1146 | 1146 | Richard Cutts C001033 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 14 | |||||||||||||
1147 | 1147 | Richard Cutts C001033 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1152 | 1152 | Barzillai Gannett G000039 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 17 | |||||||||||||
1153 | 1153 | Barzillai Gannett G000039 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | -1 | |||||||||||||
1177 | 1177 | Isaiah Green G000413 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 8 | |||||||||||||
1178 | 1178 | Isaiah Green G000413 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
1179 | 1179 | Isaiah Green G000413 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1208 | 1208 | Josiah Quincy Q000015 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 1 | |||||||||||||
1209 | 1209 | Josiah Quincy Q000015 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 1 | |||||||||||||
1210 | 1210 | Josiah Quincy Q000015 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 1 | |||||||||||||
1211 | 1211 | Josiah Quincy Q000015 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 1 | |||||||||||||
1217 | 1217 | Ebenezer Seaver S000215 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
1218 | 1218 | Ebenezer Seaver S000215 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1219 | 1219 | Ebenezer Seaver S000215 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 13 | |||||||||||||
1220 | 1220 | Ebenezer Seaver S000215 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 13 | |||||||||||||
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 | |||||||||||||
1241 | 1241 | Charles Turner T000416 | rep | MA | 1809-05-22 | 1811-03-03 | Republican | 7 | |||||||||||||
1242 | 1242 | Charles Turner T000416 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 7 | |||||||||||||
1246 | 1246 | Joseph Varnum V000074 | rep | MA | 1795-12-07 | 1797-03-03 | Democratic Republican | 9 | |||||||||||||
1247 | 1247 | Joseph Varnum V000074 | rep | MA | 1797-05-15 | 1799-03-03 | Democratic Republican | 9 | |||||||||||||
1248 | 1248 | Joseph Varnum V000074 | rep | MA | 1799-12-02 | 1801-03-03 | Democratic Republican | 9 | |||||||||||||
1249 | 1249 | Joseph Varnum V000074 | rep | MA | 1801-12-07 | 1803-03-03 | Democratic Republican | 9 | |||||||||||||
1250 | 1250 | Joseph Varnum V000074 | rep | MA | 1803-10-17 | 1805-03-03 | Democratic Republican | 4 | |||||||||||||
1251 | 1251 | Joseph Varnum V000074 | rep | MA | 1805-12-02 | 1807-03-03 | Democratic Republican | 4 | |||||||||||||
1252 | 1252 | Joseph Varnum V000074 | rep | MA | 1807-10-26 | 1809-03-03 | Democratic Republican | 4 | |||||||||||||
1253 | 1253 | Joseph Varnum V000074 | rep | MA | 1809-05-22 | 1811-03-03 | Democratic Republican | 4 | |||||||||||||
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 | |||||||||||||
1285 | 1285 | Abijah Bigelow B000453 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 11 | |||||||||||||
1286 | 1286 | Abijah Bigelow B000453 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 11 | |||||||||||||
1287 | 1287 | Abijah Bigelow B000453 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 11 | |||||||||||||
1314 | 1314 | Samuel Dana D000023 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1317 | 1317 | Samuel Davis D000134 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1328 | 1328 | Daniel Dewey D000293 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1330 | 1330 | William Ely E000168 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 5 | |||||||||||||
1331 | 1331 | William Ely E000168 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 5 | |||||||||||||
1332 | 1332 | William Ely E000168 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
1333 | 1333 | William Ely E000168 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 5 | |||||||||||||
1334 | 1334 | William Ely E000168 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1355 | 1355 | Levi Hubbard H000887 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1393 | 1393 | William Reed R000130 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 2 | |||||||||||||
1394 | 1394 | William Reed R000130 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1395 | 1395 | William Richardson R000231 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 4 | |||||||||||||
1396 | 1396 | William Richardson R000231 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1433 | 1433 | Abiel Wood W000687 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 17 | |||||||||||||
1469 | 1469 | George Bradbury B000733 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1470 | 1470 | George Bradbury B000733 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 15 | |||||||||||||
1475 | 1475 | Elijah Brigham B000833 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 10 | |||||||||||||
1476 | 1476 | Elijah Brigham B000833 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1477 | 1477 | Elijah Brigham B000833 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 11 | |||||||||||||
1479 | 1479 | Benjamin Brown B000904 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 16 | |||||||||||||
1489 | 1489 | James Carr C000176 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 17 | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1586 | 1586 | Christopher Gore G000322 | sen | MA | 1813-05-24 | 1815-03-03 | 1 | Federalist | |||||||||||||
1587 | 1587 | Christopher Gore G000322 | sen | MA | 1815-12-04 | 1817-03-03 | 1 | Federalist | |||||||||||||
1611 | 1611 | John Hulbert H000935 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1612 | 1612 | John Hulbert H000935 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 7 | |||||||||||||
1633 | 1633 | Cyrus King K000197 | rep | MA | 1813-05-24 | 1815-03-03 | Federalist | 14 | |||||||||||||
1634 | 1634 | Cyrus King K000197 | rep | MA | 1815-12-04 | 1817-03-03 | Federalist | 14 |
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);