legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,910 rows where type = "sen" sorted by office
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107 | 107 | Alexander Martin M000166 | sen | NC | 1793-12-02 | 1799-03-03 | 2 | Republican | |||||||||||||
112 | 112 | Stephen Mitchell M000828 | sen | CT | 1793-12-02 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
120 | 120 | Caleb Strong S001009 | sen | MA | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
121 | 121 | Caleb Strong S001009 | sen | MA | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
128 | 128 | John Vining V000104 | sen | DE | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
137 | 137 | Paine Wingate W000633 | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
139 | 139 | Henry Tazewell T000107 | sen | VA | 1794-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
140 | 140 | George Walton W000114 | sen | GA | 1795-11-16 | 1796-02-20 | 2 | Federalist | |||||||||||||
145 | 145 | William Bingham B000474 | sen | PA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
147 | 147 | Timothy Bloodworth B000563 | sen | NC | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
167 | 167 | James Gunn G000526 | sen | GA | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
168 | 168 | James Gunn G000526 | sen | GA | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
176 | 176 | John Henry H000508 | sen | MD | 1789-03-04 | 1795-03-03 | 3 | Pro-Administration | |||||||||||||
177 | 177 | John Henry H000508 | sen | MD | 1795-12-07 | 1797-12-31 | 3 | Federalist | |||||||||||||
178 | 178 | John Langdon L000067 | sen | NH | 1789-03-04 | 1795-03-03 | 3 | Democratic Republican | |||||||||||||
179 | 179 | John Langdon L000067 | sen | NH | 1795-12-07 | 1801-03-03 | 3 | Republican | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
200 | 200 | Elijah Paine P000026 | sen | VT | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
205 | 205 | Jacob Read R000092 | sen | SC | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
221 | 221 | Jonathan Trumbull T000389 | sen | CT | 1795-12-07 | 1797-03-03 | 3 | Federalist | |||||||||||||
224 | 224 | William Blount B000570 | sen | TN | 1796-01-01 | 1797-12-31 | 2 | Republican | |||||||||||||
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 | |||||||||||||
231 | 231 | John Howard H000841 | sen | MD | 1796-12-05 | 1797-03-04 | 1 | Federalist | |||||||||||||
232 | 232 | John Howard H000841 | sen | MD | 1797-03-04 | 1803-03-03 | 1 | Federalist | |||||||||||||
234 | 234 | John Hunter H000982 | sen | SC | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
237 | 237 | John Laurance L000120 | sen | NY | 1796-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
238 | 238 | Josiah Tattnall T000052 | sen | GA | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
252 | 252 | Nathaniel Chipman C000369 | sen | VT | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
261 | 261 | Theodore Foster F000313 | sen | RI | 1790-06-12 | 1791-03-03 | 1 | Federalist | |||||||||||||
262 | 262 | Theodore Foster F000313 | sen | RI | 1791-03-04 | 1797-03-03 | 1 | Federalist | |||||||||||||
263 | 263 | Theodore Foster F000313 | sen | RI | 1797-05-15 | 1803-03-03 | 1 | Republican | |||||||||||||
271 | 271 | Henry Latimer L000115 | sen | DE | 1795-12-07 | 1797-03-03 | 1 | Federalist | |||||||||||||
272 | 272 | Henry Latimer L000115 | sen | DE | 1797-05-15 | 1801-12-31 | 1 | Federalist | |||||||||||||
273 | 273 | James Lloyd L000377 | sen | MD | 1797-05-15 | 1801-03-03 | 3 | Federalist | |||||||||||||
278 | 278 | Stevens Mason M000226 | sen | VA | 1794-01-01 | 1797-03-03 | 1 | Republican | |||||||||||||
279 | 279 | Stevens Mason M000226 | sen | VA | 1797-05-15 | 1803-03-03 | 1 | Republican | |||||||||||||
285 | 285 | James Ross R000448 | sen | PA | 1794-01-01 | 1797-03-03 | 1 | Federalist | |||||||||||||
286 | 286 | James Ross R000448 | sen | PA | 1797-05-15 | 1803-03-03 | 1 | Federalist | |||||||||||||
287 | 287 | John Rutherfurd R000550 | sen | NJ | 1791-10-24 | 1797-03-03 | 1 | Federalist | |||||||||||||
288 | 288 | John Rutherfurd R000550 | sen | NJ | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
289 | 289 | Philip Schuyler S000154 | sen | NY | 1789-03-04 | 1791-03-03 | 1 | Pro-Administration | |||||||||||||
290 | 290 | Philip Schuyler S000154 | sen | NY | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
317 | 317 | Joshua Clayton C000497 | sen | DE | 1798-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
318 | 318 | John Hobart H000661 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
319 | 319 | William North N000142 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
320 | 320 | James Watson W000202 | sen | NY | 1798-01-01 | 1801-03-03 | 1 | Federalist | |||||||||||||
328 | 328 | John Brown B000929 | sen | KY | 1792-06-18 | 1793-03-03 | 2 | Republican | |||||||||||||
329 | 329 | John Brown B000929 | sen | KY | 1793-03-04 | 1799-03-03 | 2 | Republican | |||||||||||||
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
334 | 334 | William Cocke C000572 | sen | TN | 1796-01-01 | 1797-03-03 | 1 | Republican | |||||||||||||
335 | 335 | William Cocke C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
341 | 341 | Franklin Davenport D000069 | sen | NJ | 1798-12-05 | 1799-03-03 | 1 | Federalist | |||||||||||||
347 | 347 | Jonathan Dayton D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
353 | 353 | Samuel Dexter D000296 | sen | MA | 1799-12-02 | 1801-03-03 | 2 | Federalist | |||||||||||||
374 | 374 | Ray Greene G000427 | sen | RI | 1797-05-15 | 1799-03-03 | 2 | Federalist | |||||||||||||
375 | 375 | Ray Greene G000427 | sen | RI | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
397 | 397 | Samuel Livermore L000364 | sen | NH | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
398 | 398 | Samuel Livermore L000364 | sen | NH | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
426 | 426 | Theodore Sedgwick S000222 | sen | MA | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
448 | 448 | Dwight Foster F000301 | sen | MA | 1800-01-01 | 1803-12-31 | 2 | Federalist | |||||||||||||
453 | 453 | William Hindman H000629 | sen | MD | 1800-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
454 | 454 | Gouverneur Morris M000976 | sen | NY | 1800-01-01 | 1803-03-03 | 1 | Federalist | |||||||||||||
459 | 459 | John Breckinridge B000787 | sen | KY | 1801-12-07 | 1805-12-31 | 3 | Republican | |||||||||||||
464 | 464 | John Colhoun C000627 | sen | SC | 1801-12-07 | 1803-03-03 | 3 | Republican | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
494 | 494 | James Jackson J000017 | sen | GA | 1793-12-02 | 1795-12-31 | 2 | Republican | |||||||||||||
495 | 495 | James Jackson J000017 | sen | GA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
502 | 502 | George Logan L000401 | sen | PA | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
512 | 512 | John Muhlenberg M001066 | sen | PA | 1801-12-07 | 1801-12-31 | 3 | Democratic Republican | |||||||||||||
513 | 513 | Aaron Ogden O000041 | sen | NJ | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
514 | 514 | Simeon Olcott O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
523 | 523 | James Sheafe S000312 | sen | NH | 1801-12-07 | 1803-03-03 | 3 | Federalist | |||||||||||||
538 | 538 | Uriah Tracy T000348 | sen | CT | 1796-10-13 | 1801-03-03 | 3 | Federalist | |||||||||||||
539 | 539 | Uriah Tracy T000348 | sen | CT | 1801-12-07 | 1807-03-03 | 3 | Federalist | |||||||||||||
548 | 548 | Pierce Butler B001186 | sen | SC | 1789-03-04 | 1793-03-03 | 2 | Democratic Republican | |||||||||||||
549 | 549 | Pierce Butler B001186 | sen | SC | 1793-12-02 | 1797-03-03 | 2 | Republican | |||||||||||||
550 | 550 | Pierce Butler B001186 | sen | SC | 1802-01-01 | 1805-03-03 | 3 | Republican | |||||||||||||
551 | 551 | De Clinton C000525 | sen | NY | 1802-01-01 | 1803-12-31 | 3 | Republican | |||||||||||||
552 | 552 | William Plumer P000393 | sen | NH | 1802-01-01 | 1807-03-03 | 3 | Federalist | |||||||||||||
557 | 557 | Theodorus Bailey B000049 | sen | NY | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
598 | 598 | Samuel Maclay M000029 | sen | PA | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
608 | 608 | Samuel Potter P000468 | sen | RI | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
617 | 617 | Israel Smith S000557 | sen | VT | 1803-10-17 | 1807-12-31 | 1 | Republican | |||||||||||||
618 | 618 | John Smith S000567 | sen | OH | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
635 | 635 | Abraham Venable V000083 | sen | VA | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
636 | 636 | Samuel White W000392 | sen | DE | 1801-12-07 | 1803-03-03 | 1 | Federalist | |||||||||||||
637 | 637 | Samuel White W000392 | sen | DE | 1803-10-17 | 1809-03-03 | 1 | Federalist | |||||||||||||
641 | 641 | John Armstrong A000282 | sen | NY | 1800-11-06 | 1801-03-03 | 3 | Republican | |||||||||||||
642 | 642 | John Armstrong A000282 | sen | NY | 1801-03-04 | 1802-02-05 | 3 | Republican | |||||||||||||
643 | 643 | John Armstrong A000282 | sen | NY | 1804-02-25 | 1804-06-30 | 1 | Republican | |||||||||||||
644 | 644 | Benjamin Howland H000870 | sen | RI | 1804-01-01 | 1809-03-03 | 1 | Republican | |||||||||||||
649 | 649 | Andrew Moore M000891 | sen | VA | 1804-01-01 | 1809-03-03 | 1 | Republican | |||||||||||||
661 | 661 | Abraham Baldwin B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
662 | 662 | Abraham Baldwin B000084 | sen | GA | 1805-12-02 | 1807-03-04 | 2 | Republican | |||||||||||||
691 | 691 | James Fenner F000074 | sen | RI | 1805-12-02 | 1807-12-31 | 2 | Republican | |||||||||||||
722 | 722 | Aaron Kitchell K000246 | sen | NJ | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
746 | 746 | Daniel Smith S000524 | sen | TN | 1798-01-01 | 1799-12-31 | 1 | Republican | |||||||||||||
747 | 747 | Daniel Smith S000524 | sen | TN | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
754 | 754 | Joseph Stanton S000805 | sen | RI | 1790-01-01 | 1793-03-03 | 2 | Anti-Administration |
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);