legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
777 rows where state = "AL" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: phone, fax, office, rss_url, start (date), end (date)
party 9 ✖
- Democrat 584
- Republican 145
- Jackson 19
- 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
4283 | 4283 | John McKinley M000519 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7348 | 7348 | Williamson Cobb C000554 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7349 | 7349 | Williamson Cobb C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7350 | 7350 | Williamson Cobb C000554 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7351 | 7351 | Williamson Cobb C000554 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
7352 | 7352 | Williamson Cobb C000554 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7353 | 7353 | Williamson Cobb C000554 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7369 | 7369 | Jabez Curry C001003 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7370 | 7370 | Jabez Curry C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7519 | 7519 | Sydenham Moore M000918 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7520 | 7520 | Sydenham Moore M000918 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7580 | 7580 | James Stallworth S000786 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7581 | 7581 | James Stallworth S000786 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
8280 | 8280 | John Callis C000057 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 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);