legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by party
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169 | 169 | George Hancock H000148 | rep | VA | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
222 | 222 | James White W000377 | rep | TN | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
223 | 223 | James White W000377 | rep | TN | 1795-12-07 | 1797-03-03 | -1 | ||||||||||||||
233 | 233 | John Hunter H000982 | rep | SC | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
235 | 235 | John Laurance L000120 | rep | NY | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
236 | 236 | John Laurance L000120 | rep | NY | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
326 | 326 | John Brown B000929 | rep | VA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
327 | 327 | John Brown B000929 | rep | VA | 1791-03-04 | 1792-06-01 | -1 | ||||||||||||||
403 | 403 | William McMillan M000571 | rep | OH | 1799-12-02 | 1801-03-03 | -1 | ||||||||||||||
478 | 478 | Thomas Greene G000428 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
489 | 489 | Narsworthy Hunter H000986 | rep | MS | 1801-12-07 | 1803-03-03 | -1 | ||||||||||||||
509 | 509 | John Muhlenberg M001066 | rep | PA | 1789-03-04 | 1791-03-03 | -1 | ||||||||||||||
510 | 510 | John Muhlenberg M001066 | rep | PA | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
553 | 553 | Theodorus Bailey B000049 | rep | NY | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
758 | 758 | Thomas Sumter S001073 | rep | SC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
759 | 759 | Thomas Sumter S001073 | rep | SC | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
792 | 792 | John Milledge M000712 | rep | GA | 1792-11-22 | 1793-03-03 | 1 | ||||||||||||||
809 | 809 | Stephen Bradley B000745 | sen | VT | 1791-10-24 | 1795-03-03 | 3 | ||||||||||||||
817 | 817 | Daniel Clark C000426 | rep | OL | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
818 | 818 | Daniel Clark C000426 | rep | OL | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
877 | 877 | Benjamin Parke P000052 | rep | IN | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
878 | 878 | Benjamin Parke P000052 | rep | IN | 1807-10-26 | 1809-03-03 | -1 | ||||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
983 | 983 | James Hillhouse H000618 | rep | CT | 1791-10-24 | 1793-03-03 | -1 | ||||||||||||||
984 | 984 | James Hillhouse H000618 | rep | CT | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
1052 | 1052 | Julien Poydras P000493 | rep | OL | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
1290 | 1290 | Shadrack Bond B000612 | rep | IL | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
1291 | 1291 | Shadrack Bond B000612 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1349 | 1349 | Edward Hempstead H000472 | rep | MO | 1811-11-04 | 1813-03-03 | -1 | ||||||||||||||
1350 | 1350 | Edward Hempstead H000472 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1551 | 1551 | Rufus Easton E000022 | rep | MO | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1552 | 1552 | Rufus Easton E000022 | rep | MO | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1636 | 1636 | William Lattimore L000118 | rep | MS | 1803-10-17 | 1805-03-03 | -1 | ||||||||||||||
1637 | 1637 | William Lattimore L000118 | rep | MS | 1805-12-02 | 1807-03-03 | -1 | ||||||||||||||
1638 | 1638 | William Lattimore L000118 | rep | MS | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1639 | 1639 | William Lattimore L000118 | rep | MS | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1723 | 1723 | Benjamin Stephenson S000862 | rep | IL | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
1724 | 1724 | Benjamin Stephenson S000862 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1768 | 1768 | Jonathan Williams W000523 | rep | PA | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1783 | 1783 | Robert Harper H000225 | rep | SC | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
1901 | 1901 | Nathaniel Pope P000432 | rep | IL | 1815-12-04 | 1817-03-03 | -1 | ||||||||||||||
1902 | 1902 | Nathaniel Pope P000432 | rep | IL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2004 | 2004 | John Crowell C000942 | rep | AL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2196 | 2196 | James Bates B000235 | rep | AR | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
2197 | 2197 | James Bates B000235 | rep | AR | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2224 | 2224 | Joseph Dane D000026 | rep | ME | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
2232 | 2232 | James Duncan D000531 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2245 | 2245 | Joseph Hernández H000533 | rep | FL | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2328 | 2328 | Solomon Sibley S000400 | rep | MI | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
2329 | 2329 | Solomon Sibley S000400 | rep | MI | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2333 | 2333 | Selah Tuthill T000438 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2368 | 2368 | John Taylor T000086 | sen | VA | 1792-10-18 | 1793-03-02 | 2 | ||||||||||||||
2369 | 2369 | John Taylor T000086 | sen | VA | 1793-03-04 | 1794-05-11 | 2 | ||||||||||||||
2381 | 2381 | Samuel Breck B000783 | rep | PA | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2383 | 2383 | John Brown B000926 | rep | PA | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2387 | 2387 | John Cady C000015 | rep | NY | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2389 | 2389 | Richard Call C000050 | rep | FL | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2394 | 2394 | Lot Clark C000447 | rep | NY | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
2395 | 2395 | Ela Collins C000635 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
2398 | 2398 | Joshua Cushman C001020 | rep | ME | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2400 | 2400 | Job Durfee D000568 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2401 | 2401 | Justin Dwinell D000584 | rep | NY | 1823-12-01 | 1825-03-03 | 22 | ||||||||||||||
2405 | 2405 | Samuel Eddy E000040 | rep | RI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2409 | 2409 | William Ellis E000137 | rep | PA | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2410 | 2410 | William Ellis E000137 | rep | PA | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2411 | 2411 | Charles Foote F000249 | rep | NY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2413 | 2413 | Walter Forward F000291 | rep | PA | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2420 | 2420 | James Gazlay G000109 | rep | OH | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2422 | 2422 | Matthew Harvey H000309 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2423 | 2423 | William Hayward H000410 | rep | MD | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2426 | 2426 | James Hogeboom H000700 | rep | NY | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2431 | 2431 | Lemuel Jenkins J000085 | rep | NY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2433 | 2433 | John Johnson J000154 | rep | KY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2434 | 2434 | Samuel Lawrence L000138 | rep | NY | 1823-12-01 | 1825-03-03 | 25 | ||||||||||||||
2435 | 2435 | John Lee L000196 | rep | MD | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2437 | 2437 | Jabez Leftwich L000216 | rep | VA | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2439 | 2439 | Elisha Litchfield L000346 | rep | NY | 1823-12-01 | 1825-03-03 | 23 | ||||||||||||||
2443 | 2443 | Stephen Longfellow L000430 | rep | ME | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2445 | 2445 | James Matlack M000245 | rep | NJ | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2447 | 2447 | Aaron Matson M000247 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2448 | 2448 | Duncan McArthur M000299 | rep | OH | 1813-05-24 | 1815-03-03 | -1 | ||||||||||||||
2449 | 2449 | Duncan McArthur M000299 | rep | OH | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2453 | 2453 | Raphael Neale N000018 | rep | MD | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
2454 | 2454 | Henry Olin O000068 | rep | VT | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2455 | 2455 | George Outlaw O000139 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2456 | 2456 | John Patterson P000122 | rep | OH | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2463 | 2463 | William Plumer P000394 | rep | NH | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2472 | 2472 | Gabriel Richard R000210 | rep | MI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2473 | 2473 | John Richards R000216 | rep | NY | 1823-12-01 | 1825-03-03 | 19 | ||||||||||||||
2475 | 2475 | William Rochester R000360 | rep | NY | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2482 | 2482 | Thomas Ross R000456 | rep | OH | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2484 | 2484 | Peter Sharpe S000297 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2485 | 2485 | Peter Sharpe S000297 | rep | NY | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2486 | 2486 | Jonas Sibley S000397 | rep | MA | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2489 | 2489 | Arthur Smith S000515 | rep | VA | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2490 | 2490 | Richard Spaight S000694 | rep | NC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2496 | 2496 | Ansel Sterling S000868 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2498 | 2498 | Ebenezer Stoddard S000943 | rep | CT | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2502 | 2502 | Philip Thompson T000211 | rep | KY | 1823-12-01 | 1825-03-03 | 11 |
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);