legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
869 rows where state = "AL" sorted by caucus
This data as json, copyable, CSV (advanced)
Suggested facets: district, phone, fax, contact_form, rss_url, start (date), end (date)
party 9 ✖
- Democrat 652
- Republican 163
- Jackson 25
- Whig 15
- Populist 3
- American 2
- National Greenbacker 2
- Nullifier 2
- Liberal Republican 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 | 2004 | John Crowell C000942 | rep | AL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2005 | 2005 | John Crowell C000942 | rep | AL | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2167 | 2167 | John Walker W000061 | sen | AL | 1819-12-06 | 1823-03-03 | 3 | Republican | |||||||||||||
2360 | 2360 | William Kelly K000079 | sen | AL | 1822-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2575 | 2575 | Henry Chambers C000284 | sen | AL | 1825-12-05 | 1827-03-03 | 3 | Jackson | |||||||||||||
2754 | 2754 | Israel Pickens P000322 | sen | AL | 1826-01-01 | 1827-03-03 | 3 | Jackson | |||||||||||||
2891 | 2891 | John McKee M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2892 | 2892 | John McKee M000495 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
2893 | 2893 | John McKee M000495 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
2925 | 2925 | George Owen O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2926 | 2926 | George Owen O000150 | rep | AL | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2927 | 2927 | George Owen O000150 | rep | AL | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
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 |
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);