legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
186 rows where party = "Federalist" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35 | 35 | George Cabot C000009 | sen | MA | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
121 | 121 | Caleb Strong S001009 | sen | MA | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
141 | 141 | Fisher Ames A000174 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 1 | |||||||||||||
142 | 142 | Fisher Ames A000174 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 1 | |||||||||||||
143 | 143 | Fisher Ames A000174 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
144 | 144 | Fisher Ames A000174 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 8 | |||||||||||||
180 | 180 | George Leonard L000246 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 7 | |||||||||||||
181 | 181 | George Leonard L000246 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 6 | |||||||||||||
182 | 182 | George Leonard L000246 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 7 | |||||||||||||
225 | 225 | Benjamin Goodhue G000286 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 2 | |||||||||||||
226 | 226 | Benjamin Goodhue G000286 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 2 | |||||||||||||
227 | 227 | Benjamin Goodhue G000286 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
228 | 228 | Benjamin Goodhue G000286 | rep | MA | 1795-06-08 | 1796-06-11 | Federalist | 1 | |||||||||||||
229 | 229 | Benjamin Goodhue G000286 | sen | MA | 1796-06-11 | 1797-03-03 | 1 | Federalist | |||||||||||||
230 | 230 | Benjamin Goodhue G000286 | sen | MA | 1797-03-04 | 1800-11-08 | 1 | Federalist | |||||||||||||
243 | 243 | Theophilus Bradbury B000735 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 11 | |||||||||||||
244 | 244 | Theophilus Bradbury B000735 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 11 | |||||||||||||
248 | 248 | Stephen Bullock B001053 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 7 | |||||||||||||
264 | 264 | Nathaniel Freeman F000365 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 5 | |||||||||||||
284 | 284 | Isaac Parker P000058 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 12 | |||||||||||||
321 | 321 | Bailey Bartlett B000198 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 11 | |||||||||||||
322 | 322 | Bailey Bartlett B000198 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 11 | |||||||||||||
352 | 352 | Samuel Dexter D000296 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 1 | |||||||||||||
353 | 353 | Samuel Dexter D000296 | sen | MA | 1799-12-02 | 1801-03-03 | 2 | Federalist | |||||||||||||
399 | 399 | Samuel Lyman L000528 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 3 | |||||||||||||
400 | 400 | Samuel Lyman L000528 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 3 | |||||||||||||
401 | 401 | Samuel Lyman L000528 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
420 | 420 | John Reed R000120 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 6 | |||||||||||||
421 | 421 | John Reed R000120 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 6 | |||||||||||||
422 | 422 | John Reed R000120 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
423 | 423 | Theodore Sedgwick S000222 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 4 | |||||||||||||
424 | 424 | Theodore Sedgwick S000222 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 4 | |||||||||||||
425 | 425 | Theodore Sedgwick S000222 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
426 | 426 | Theodore Sedgwick S000222 | sen | MA | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
427 | 427 | Theodore Sedgwick S000222 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 1 | |||||||||||||
428 | 428 | Samuel Sewall S000259 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 10 | |||||||||||||
429 | 429 | Samuel Sewall S000259 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 10 | |||||||||||||
430 | 430 | Samuel Sewall S000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
433 | 433 | George Thatcher T000141 | rep | MA | 1789-03-04 | 1791-03-03 | Federalist | 6 | |||||||||||||
434 | 434 | George Thatcher T000141 | rep | MA | 1791-10-24 | 1793-03-03 | Federalist | 8 | |||||||||||||
435 | 435 | George Thatcher T000141 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 4 | |||||||||||||
436 | 436 | George Thatcher T000141 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 14 | |||||||||||||
437 | 437 | George Thatcher T000141 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 14 | |||||||||||||
438 | 438 | George Thatcher T000141 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 14 | |||||||||||||
445 | 445 | Dwight Foster F000301 | rep | MA | 1793-12-02 | 1795-03-03 | Federalist | 2 | |||||||||||||
446 | 446 | Dwight Foster F000301 | rep | MA | 1795-12-07 | 1797-03-03 | Federalist | 4 | |||||||||||||
447 | 447 | Dwight Foster F000301 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 4 | |||||||||||||
448 | 448 | Dwight Foster F000301 | sen | MA | 1800-01-01 | 1803-12-31 | 2 | Federalist | |||||||||||||
498 | 498 | Silas Lee L000204 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 12 | |||||||||||||
499 | 499 | Silas Lee L000204 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
503 | 503 | Ebenezer Mattoon M000259 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 3 | |||||||||||||
504 | 504 | Ebenezer Mattoon M000259 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 3 | |||||||||||||
517 | 517 | Nathan Read R000093 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
518 | 518 | Nathan Read R000093 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
524 | 524 | William Shepard S000330 | rep | MA | 1797-05-15 | 1799-03-03 | Federalist | 2 | |||||||||||||
525 | 525 | William Shepard S000330 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 2 | |||||||||||||
526 | 526 | William Shepard S000330 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 2 | |||||||||||||
561 | 561 | Phineas Bruce B000970 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 17 | |||||||||||||
567 | 567 | Manasseh Cutler C001026 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 11 | |||||||||||||
568 | 568 | Manasseh Cutler C001026 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 3 | |||||||||||||
573 | 573 | Thomas Dwight D000583 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 5 | |||||||||||||
600 | 600 | Nahum Mitchell M000824 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 7 | |||||||||||||
622 | 622 | Samuel Thatcher T000143 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 12 | |||||||||||||
623 | 623 | Samuel Thatcher T000143 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 16 | |||||||||||||
638 | 638 | Lemuel Williams W000526 | rep | MA | 1799-12-02 | 1801-03-03 | Federalist | 5 | |||||||||||||
639 | 639 | Lemuel Williams W000526 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 5 | |||||||||||||
640 | 640 | Lemuel Williams W000526 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
713 | 713 | Seth Hastings H000331 | rep | MA | 1801-12-07 | 1803-03-03 | Federalist | 4 | |||||||||||||
714 | 714 | Seth Hastings H000331 | rep | MA | 1803-10-17 | 1805-03-03 | Federalist | 10 | |||||||||||||
715 | 715 | Seth Hastings H000331 | rep | MA | 1805-12-02 | 1807-03-03 | Federalist | 10 | |||||||||||||
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 | |||||||||||||
937 | 937 | Joseph Allen A000136 | rep | MA | 1809-05-22 | 1811-03-03 | Federalist | 10 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1255 | 1255 | Leonard White W000385 | rep | MA | 1811-11-04 | 1813-03-03 | Federalist | 3 | |||||||||||||
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 | |||||||||||||
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 |
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);