legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
729 rows where party = "Republican" and state = "MA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
157 | 157 | Henry Dearborn D000178 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 4 | |||||||||||||
158 | 158 | Henry Dearborn D000178 | rep | MA | 1795-12-07 | 1797-03-03 | Republican | 12 | |||||||||||||
183 | 183 | William Lyman L000530 | rep | MA | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
184 | 184 | William Lyman L000530 | rep | MA | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
265 | 265 | Nathaniel Freeman F000365 | rep | MA | 1797-05-15 | 1799-03-03 | Republican | 5 | |||||||||||||
455 | 455 | John Bacon B000017 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
500 | 500 | Levi Lincoln L000316 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
501 | 501 | Levi Lincoln L000316 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
527 | 527 | Josiah Smith S000582 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
593 | 593 | Simon Larned L000097 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
610 | 610 | Thomson Skinner S000471 | rep | MA | 1795-12-07 | 1797-03-03 | Republican | 1 | |||||||||||||
611 | 611 | Thomson Skinner S000471 | rep | MA | 1797-05-15 | 1799-03-03 | Republican | 1 | |||||||||||||
612 | 612 | Thomson Skinner S000471 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
667 | 667 | Phanuel Bishop B000488 | rep | MA | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
668 | 668 | Phanuel Bishop B000488 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
669 | 669 | Phanuel Bishop B000488 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 9 | |||||||||||||
670 | 670 | Phanuel Bishop B000488 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1256 | 1256 | William Widgery W000444 | rep | MA | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
1314 | 1314 | Samuel Dana D000023 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1355 | 1355 | Levi Hubbard H000887 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
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 | |||||||||||||
1523 | 1523 | Samuel Conner C000692 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1843 | 1843 | Joshua Gage G000003 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 19 | |||||||||||||
2012 | 2012 | Edward Dowse D000477 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 13 | |||||||||||||
2022 | 2022 | Walter Folger F000242 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2023 | 2023 | Walter Folger F000242 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2057 | 2057 | Martin Kinsley K000230 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 17 | |||||||||||||
2081 | 2081 | Marcus Morton M001019 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
2082 | 2082 | Marcus Morton M001019 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 10 | |||||||||||||
2093 | 2093 | James Parker P000060 | rep | MA | 1813-05-24 | 1815-03-03 | Republican | 19 | |||||||||||||
2094 | 2094 | James Parker P000060 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 18 | |||||||||||||
2124 | 2124 | Zabdiel Sampson S000026 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
2125 | 2125 | Zabdiel Sampson S000026 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 8 | |||||||||||||
2128 | 2128 | Henry Shaw S000307 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2129 | 2129 | Henry Shaw S000307 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 7 | |||||||||||||
2195 | 2195 | Gideon Barstow B000195 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2233 | 2233 | William Eustis E000230 | rep | MA | 1801-12-07 | 1803-03-03 | Republican | 8 | |||||||||||||
2234 | 2234 | William Eustis E000230 | rep | MA | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
2235 | 2235 | William Eustis E000230 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 13 | |||||||||||||
2236 | 2236 | William Eustis E000230 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 13 | |||||||||||||
2246 | 2246 | Mark Hill H000602 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 16 | |||||||||||||
2327 | 2327 | Jonathan Russell R000531 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 11 | |||||||||||||
2390 | 2390 | John Chandler C000291 | rep | MA | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
2391 | 2391 | John Chandler C000291 | rep | MA | 1807-10-26 | 1809-03-03 | Republican | 17 | |||||||||||||
2396 | 2396 | Joshua Cushman C001020 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 19 | |||||||||||||
2415 | 2415 | Timothy Fuller F000413 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
2416 | 2416 | Timothy Fuller F000413 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 4 | |||||||||||||
2417 | 2417 | Timothy Fuller F000413 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2418 | 2418 | Timothy Fuller F000413 | rep | MA | 1823-12-01 | 1825-03-03 | Republican | 4 | |||||||||||||
2634 | 2634 | Aaron Hobart H000659 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 8 | |||||||||||||
2635 | 2635 | Aaron Hobart H000659 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2655 | 2655 | Enoch Lincoln L000314 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
2656 | 2656 | Enoch Lincoln L000314 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 20 | |||||||||||||
2928 | 2928 | Albion Parris P000079 | rep | MA | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
2929 | 2929 | Albion Parris P000079 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
3206 | 3206 | Nathaniel Silsbee S000411 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
3207 | 3207 | Nathaniel Silsbee S000411 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 2 | |||||||||||||
3686 | 3686 | Benjamin Gorham G000324 | rep | MA | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
3687 | 3687 | Benjamin Gorham G000324 | rep | MA | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
7008 | 7008 | Calvin Chaffee C000270 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 10 | |||||||||||||
7017 | 7017 | Linus Comins C000659 | rep | MA | 1857-12-07 | 1859-03-03 | Republican | 4 |
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);