legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by state
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1929-04-15 498
- 1913-04-07 496
- 1919-05-19 495
- 1917-04-02 494
- 1923-12-03 494
- 1931-12-07 494
- 1939-01-03 494
- 1921-04-11 491
- 1941-01-03 491
- 1943-01-06 486
- 1925-12-07 484
- 1927-12-05 484
- 1933-03-09 484
- 1947-01-03 484
- 1945-01-03 483
- 1951-01-03 483
- 1937-01-05 482
- 1961-01-03 482
- 1959-01-07 481
- 1915-12-06 480
- 1969-01-03 480
- 1981-01-05 480
- 1989-01-03 480
- 1935-01-03 479
- 1949-01-03 479
- 1957-01-03 479
- 1963-01-09 479
- 1975-01-14 478
- 1971-01-21 477
- 1977-01-04 477
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3051 | 3051 | Robert Baylor B000257 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3491 | 3491 | Gabriel Moore M000898 | rep | AL | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
3492 | 3492 | Gabriel Moore M000898 | rep | AL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3493 | 3493 | Gabriel Moore M000898 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3494 | 3494 | Gabriel Moore M000898 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3495 | 3495 | Gabriel Moore M000898 | sen | AL | 1831-12-05 | 1837-03-03 | 3 | Jackson | |||||||||||||
3737 | 3737 | Samuel Mardis M000128 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3738 | 3738 | Samuel Mardis M000128 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3763 | 3763 | John Murphy M001097 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4173 | 4173 | Clement Clay C000481 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4174 | 4174 | Clement Clay C000481 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4175 | 4175 | Clement Clay C000481 | sen | AL | 1837-09-04 | 1841-12-31 | 3 | Democrat | |||||||||||||
4254 | 4254 | Joab Lawler L000129 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
4255 | 4255 | Joab Lawler L000129 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4268 | 4268 | Francis Lyon L000542 | rep | AL | 1835-12-07 | 1837-03-03 | Whig | 5 | |||||||||||||
4269 | 4269 | Francis Lyon L000542 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 5 | |||||||||||||
4270 | 4270 | Joshua Martin M000192 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4271 | 4271 | Joshua Martin M000192 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4282 | 4282 | John McKinley M000519 | sen | AL | 1826-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
4283 | 4283 | John McKinley M000519 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4284 | 4284 | John McKinley M000519 | sen | AL | 1837-09-04 | 1837-12-31 | 3 | Democrat | |||||||||||||
4436 | 4436 | George Crabb C000847 | rep | AL | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4437 | 4437 | George Crabb C000847 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5001 | 5001 | Benjamin Shields S000359 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5118 | 5118 | Arthur Bagby B000030 | sen | AL | 1841-05-31 | 1843-03-03 | 3 | Democrat | |||||||||||||
5119 | 5119 | Arthur Bagby B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5131 | 5131 | James Belser B000354 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5189 | 5189 | James Dellet D000221 | rep | AL | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
5190 | 5190 | James Dellet D000221 | rep | AL | 1843-12-04 | 1845-03-03 | Whig | 1 | |||||||||||||
5379 | 5379 | Reuben Chapman C000316 | rep | AL | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
5380 | 5380 | Reuben Chapman C000316 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5381 | 5381 | Reuben Chapman C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5382 | 5382 | Reuben Chapman C000316 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5383 | 5383 | Reuben Chapman C000316 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5384 | 5384 | Reuben Chapman C000316 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5389 | 5389 | James Cottrell C000803 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5396 | 5396 | Edmund Dargan D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5475 | 5475 | Felix McConnell M000356 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5476 | 5476 | Felix McConnell M000356 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5494 | 5494 | William Payne P000154 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5495 | 5495 | William Payne P000154 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5496 | 5496 | William Payne P000154 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5579 | 5579 | William Yancey Y000003 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5580 | 5580 | William Yancey Y000003 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5702 | 5702 | John Gayle G000106 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 1 | |||||||||||||
5755 | 5755 | Dixon Lewis L000278 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5756 | 5756 | Dixon Lewis L000278 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
5757 | 5757 | Dixon Lewis L000278 | rep | AL | 1833-12-02 | 1835-03-03 | Nullifier | 4 | |||||||||||||
5758 | 5758 | Dixon Lewis L000278 | rep | AL | 1835-12-07 | 1837-03-03 | Nullifier | 4 | |||||||||||||
5759 | 5759 | Dixon Lewis L000278 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5760 | 5760 | Dixon Lewis L000278 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5761 | 5761 | Dixon Lewis L000278 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5762 | 5762 | Dixon Lewis L000278 | rep | AL | 1843-12-04 | 1844-04-22 | Democrat | 3 | |||||||||||||
5763 | 5763 | Dixon Lewis L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5764 | 5764 | Dixon Lewis L000278 | sen | AL | 1847-12-06 | 1848-10-25 | 2 | Democrat | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican | |||||||||||||
5874 | 5874 | William King K000217 | sen | AL | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5876 | 5876 | William King K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5877 | 5877 | William King K000217 | sen | AL | 1841-05-31 | 1844-04-15 | 2 | Democrat | |||||||||||||
5878 | 5878 | William King K000217 | sen | AL | 1848-07-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5879 | 5879 | William King K000217 | sen | AL | 1849-03-05 | 1852-12-20 | 3 | Democrat | |||||||||||||
5891 | 5891 | William Alston A000166 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 1 | |||||||||||||
5905 | 5905 | Franklin Bowdon B000680 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5906 | 5906 | Franklin Bowdon B000680 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5907 | 5907 | Franklin Bowdon B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6003 | 6003 | Henry Hilliard H000622 | rep | AL | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
6004 | 6004 | Henry Hilliard H000622 | rep | AL | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
6005 | 6005 | Henry Hilliard H000622 | rep | AL | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6016 | 6016 | David Hubbard H000880 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6017 | 6017 | David Hubbard H000880 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6018 | 6018 | Samuel Inge I000013 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6019 | 6019 | Samuel Inge I000013 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6227 | 6227 | John Bragg B000758 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6486 | 6486 | James Abercrombie A000012 | rep | AL | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6487 | 6487 | James Abercrombie A000012 | rep | AL | 1853-12-05 | 1855-03-03 | Whig | 2 | |||||||||||||
6675 | 6675 | Philip Phillips P000311 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6812 | 6812 | Benjamin Fitzpatrick F000174 | sen | AL | 1848-01-01 | 1849-12-31 | 2 | Democrat | |||||||||||||
6813 | 6813 | Benjamin Fitzpatrick F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6814 | 6814 | Benjamin Fitzpatrick F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6827 | 6827 | Sampson Harris H000252 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6828 | 6828 | Sampson Harris H000252 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6829 | 6829 | Sampson Harris H000252 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6830 | 6830 | Sampson Harris H000252 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6831 | 6831 | Sampson Harris H000252 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 7 | |||||||||||||
6924 | 6924 | William Smith S000637 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6925 | 6925 | William Smith S000637 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6926 | 6926 | William Smith S000637 | rep | AL | 1855-12-03 | 1857-03-03 | American | 4 | |||||||||||||
6941 | 6941 | Percy Walker W000064 | rep | AL | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
7031 | 7031 | James Dowdell D000464 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7032 | 7032 | James Dowdell D000464 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7033 | 7033 | James Dowdell D000464 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7221 | 7221 | Eli Shorter S000379 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
7222 | 7222 | Eli Shorter S000379 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7341 | 7341 | Clement Clay C000480 | sen | AL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7342 | 7342 | Clement Clay C000480 | sen | AL | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7346 | 7346 | David Clopton C000530 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7347 | 7347 | Williamson Cobb C000554 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 6 |
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);