legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
This data as json, copyable, CSV
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 | C000942 | rep | AL | 1817-12-01 | 1819-03-03 | -1 | ||||||||||||||
2891 | M000495 | rep | AL | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2925 | O000150 | rep | AL | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
3492 | M000898 | rep | AL | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
6926 | S000637 | rep | AL | 1855-12-03 | 1857-03-03 | American | 4 | |||||||||||||
6941 | W000064 | rep | AL | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
4175 | C000481 | sen | AL | 1837-09-04 | 1841-12-31 | 3 | Democrat | |||||||||||||
4271 | M000192 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4284 | M000519 | sen | AL | 1837-09-04 | 1837-12-31 | 3 | Democrat | |||||||||||||
5001 | S000359 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5118 | B000030 | sen | AL | 1841-05-31 | 1843-03-03 | 3 | Democrat | |||||||||||||
5119 | B000030 | sen | AL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5131 | B000354 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5380 | C000316 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5381 | C000316 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5382 | C000316 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5383 | C000316 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5384 | C000316 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5389 | C000803 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5396 | D000052 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5475 | M000356 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5476 | M000356 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5494 | P000154 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5495 | P000154 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5496 | P000154 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5579 | Y000003 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5580 | Y000003 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5759 | L000278 | rep | AL | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5760 | L000278 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5761 | L000278 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
5762 | L000278 | rep | AL | 1843-12-04 | 1844-04-22 | Democrat | 3 | |||||||||||||
5763 | L000278 | sen | AL | 1844-04-22 | 1847-03-03 | 2 | Democrat | |||||||||||||
5764 | L000278 | sen | AL | 1847-12-06 | 1848-10-25 | 2 | Democrat | |||||||||||||
5876 | K000217 | sen | AL | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5877 | K000217 | sen | AL | 1841-05-31 | 1844-04-15 | 2 | Democrat | |||||||||||||
5878 | K000217 | sen | AL | 1848-07-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5879 | K000217 | sen | AL | 1849-03-05 | 1852-12-20 | 3 | Democrat | |||||||||||||
5905 | B000680 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5906 | B000680 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5907 | B000680 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
5940 | C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6016 | H000880 | rep | AL | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
6017 | H000880 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6018 | I000013 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
6019 | I000013 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6227 | B000758 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6675 | P000311 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6812 | F000174 | sen | AL | 1848-01-01 | 1849-12-31 | 2 | Democrat | |||||||||||||
6813 | F000174 | sen | AL | 1853-12-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6814 | F000174 | sen | AL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
6827 | H000252 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
6828 | H000252 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6829 | H000252 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6830 | H000252 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6831 | H000252 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 7 | |||||||||||||
6924 | S000637 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6925 | S000637 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
7031 | D000464 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7032 | D000464 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7033 | D000464 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7221 | S000379 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
7222 | S000379 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7341 | C000480 | sen | AL | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7342 | C000480 | sen | AL | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7346 | C000530 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7347 | C000554 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7348 | C000554 | rep | AL | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7349 | C000554 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7350 | C000554 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7351 | C000554 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
7352 | C000554 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7353 | C000554 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7369 | C001003 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7370 | C001003 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7519 | M000918 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7520 | M000918 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7580 | S000786 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7581 | S000786 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
8719 | S000352 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8880 | D000478 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8881 | D000478 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
8911 | G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8921 | H000155 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9365 | S000498 | rep | AL | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9366 | S000498 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9453 | B000738 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9475 | C000035 | rep | AL | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9476 | C000035 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9819 | G000086 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
9877 | L000306 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
9985 | W000512 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9986 | W000512 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10041 | C000509 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10107 | H000822 | rep | AL | 1841-05-31 | 1843-03-03 | Democrat | 0 | |||||||||||||
10108 | H000822 | rep | AL | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
10109 | H000822 | rep | AL | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
10110 | H000822 | rep | AL | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
10111 | H000822 | rep | AL | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
10112 | H000822 | rep | AL | 1853-12-05 | 1855-03-03 | Democrat | 5 | |||||||||||||
10113 | H000822 | rep | AL | 1855-12-03 | 1857-03-03 | Democrat | 5 | |||||||||||||
10114 | H000822 | rep | AL | 1857-12-07 | 1859-03-03 | Democrat | 5 |