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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
9 | F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
18 | J000198 | sen | NC | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
19 | L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
24 | P000102 | sen | NJ | 1789-03-04 | 1791-03-03 | 2 | Pro-Administration | |||||||||||||
29 | D000324 | sen | NJ | 1790-01-01 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
79 | B000739 | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | |||||||||||||
93 | F000368 | sen | NJ | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
107 | M000166 | sen | NC | 1793-12-02 | 1799-03-03 | 2 | Republican | |||||||||||||
120 | S001009 | sen | MA | 1789-03-04 | 1793-03-03 | 2 | Pro-Administration | |||||||||||||
121 | S001009 | sen | MA | 1793-12-02 | 1797-03-03 | 2 | Federalist | |||||||||||||
128 | V000104 | sen | DE | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
137 | W000633 | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
139 | T000107 | sen | VA | 1794-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
140 | W000114 | sen | GA | 1795-11-16 | 1796-02-20 | 2 | Federalist | |||||||||||||
224 | B000570 | sen | TN | 1796-01-01 | 1797-12-31 | 2 | Republican | |||||||||||||
234 | H000982 | sen | SC | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
238 | T000052 | sen | GA | 1796-01-01 | 1799-03-03 | 2 | Republican | |||||||||||||
317 | C000497 | sen | DE | 1798-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
328 | B000929 | sen | KY | 1792-06-18 | 1793-03-03 | 2 | Republican | |||||||||||||
329 | B000929 | sen | KY | 1793-03-04 | 1799-03-03 | 2 | Republican | |||||||||||||
330 | B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
335 | C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
347 | D000165 | sen | NJ | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
353 | D000296 | sen | MA | 1799-12-02 | 1801-03-03 | 2 | Federalist | |||||||||||||
374 | G000427 | sen | RI | 1797-05-15 | 1799-03-03 | 2 | Federalist | |||||||||||||
375 | G000427 | sen | RI | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
397 | L000364 | sen | NH | 1793-12-02 | 1799-03-03 | 2 | Federalist | |||||||||||||
398 | L000364 | sen | NH | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
426 | S000222 | sen | MA | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
448 | F000301 | sen | MA | 1800-01-01 | 1803-12-31 | 2 | Federalist | |||||||||||||
468 | E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
494 | J000017 | sen | GA | 1793-12-02 | 1795-12-31 | 2 | Republican | |||||||||||||
514 | O000060 | sen | NH | 1801-12-07 | 1805-03-03 | 2 | Federalist | |||||||||||||
548 | B001186 | sen | SC | 1789-03-04 | 1793-03-03 | 2 | Democratic Republican | |||||||||||||
549 | B001186 | sen | SC | 1793-12-02 | 1797-03-03 | 2 | Republican | |||||||||||||
661 | B000084 | sen | GA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
662 | B000084 | sen | GA | 1805-12-02 | 1807-03-04 | 2 | Republican | |||||||||||||
691 | F000074 | sen | RI | 1805-12-02 | 1807-12-31 | 2 | Republican | |||||||||||||
722 | K000246 | sen | NJ | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
747 | S000524 | sen | TN | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
754 | S000805 | sen | RI | 1790-01-01 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
763 | S001073 | sen | SC | 1801-12-15 | 1805-03-03 | 2 | Republican | |||||||||||||
764 | S001073 | sen | SC | 1805-12-02 | 1810-12-16 | 2 | Republican | |||||||||||||
772 | T000249 | sen | KY | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
836 | F000344 | sen | NC | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
861 | J000220 | sen | GA | 1807-10-26 | 1807-12-31 | 2 | Republican | |||||||||||||
870 | M000240 | sen | RI | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
940 | A000197 | sen | TN | 1797-05-15 | 1799-03-03 | 2 | Republican | |||||||||||||
1044 | N000086 | sen | VA | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
1086 | W000411 | sen | TN | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
1092 | T000085 | sen | SC | 1810-12-31 | 1811-03-03 | 2 | Republican | |||||||||||||
1093 | T000085 | sen | SC | 1811-03-04 | 1816-11-15 | 2 | Republican | |||||||||||||
1104 | B000249 | sen | DE | 1804-11-13 | 1805-03-03 | 2 | Federalist | |||||||||||||
1105 | B000249 | sen | DE | 1805-03-04 | 1811-03-03 | 2 | Federalist | |||||||||||||
1106 | B000249 | sen | DE | 1811-11-04 | 1813-03-03 | 2 | Federalist | |||||||||||||
1140 | C000895 | sen | GA | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
1141 | C000895 | sen | GA | 1811-11-04 | 1813-12-31 | 2 | Republican | |||||||||||||
1161 | G000183 | sen | VA | 1804-12-04 | 1805-03-03 | 2 | Republican | |||||||||||||
1162 | G000183 | sen | VA | 1805-03-04 | 1811-03-03 | 2 | Republican | |||||||||||||
1163 | G000183 | sen | VA | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1168 | G000215 | sen | NH | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1169 | G000215 | sen | NH | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1182 | H000865 | sen | RI | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1243 | T000423 | sen | NC | 1805-12-02 | 1811-03-03 | 2 | Republican | |||||||||||||
1244 | T000423 | sen | NC | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1254 | V000074 | sen | MA | 1811-11-04 | 1817-03-03 | 2 | Democratic Republican | |||||||||||||
1269 | D000273 | sen | LA | 1812-01-01 | 1813-03-03 | 2 | Unknown | |||||||||||||
1271 | P000450 | sen | LA | 1812-01-01 | 1813-12-31 | 2 | Republican | |||||||||||||
1284 | B000434 | sen | GA | 1813-11-06 | 1816-11-09 | 2 | Republican | |||||||||||||
1304 | B001051 | sen | GA | 1813-05-24 | 1813-12-31 | 2 | Republican | |||||||||||||
1414 | S000941 | sen | NJ | 1796-01-01 | 1799-03-03 | 2 | Federalist | |||||||||||||
1423 | W000287 | sen | DE | 1799-12-02 | 1805-03-03 | 2 | Federalist | |||||||||||||
1424 | W000287 | sen | DE | 1813-05-24 | 1817-03-03 | 2 | Federalist | |||||||||||||
1435 | B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
1443 | T000220 | sen | NH | 1814-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1444 | W000053 | sen | KY | 1814-01-01 | 1815-03-03 | 2 | Republican | |||||||||||||
1446 | W000324 | sen | TN | 1814-01-01 | 1815-12-31 | 2 | Republican | |||||||||||||
1487 | C000083 | sen | TN | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1687 | P000324 | sen | MA | 1803-10-17 | 1805-03-03 | 2 | Federalist | |||||||||||||
1688 | P000324 | sen | MA | 1805-12-02 | 1811-03-03 | 2 | Federalist | |||||||||||||
1782 | H000186 | sen | KY | 1816-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1788 | M000213 | sen | VA | 1816-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
1789 | S000949 | sen | NC | 1816-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1790 | S000949 | sen | NC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
1808 | B001137 | sen | RI | 1817-12-01 | 1821-03-03 | 2 | Federalist | |||||||||||||
1812 | C000408 | sen | LA | 1817-12-01 | 1817-12-31 | 2 | Democratic Republican | |||||||||||||
1835 | E000197 | sen | VA | 1817-12-01 | 1819-12-31 | 2 | Republican | |||||||||||||
1880 | M000966 | sen | NH | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
1890 | O000127 | sen | MA | 1817-12-01 | 1823-03-03 | 2 | Federalist | |||||||||||||
1948 | W000516 | sen | TN | 1815-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1949 | W000516 | sen | TN | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
1976 | B000921 | sen | LA | 1813-05-24 | 1817-03-03 | 2 | Republican | |||||||||||||
1999 | C000671 | sen | NJ | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
2000 | C000671 | sen | NJ | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
2100 | P000354 | sen | SC | 1798-12-06 | 1799-03-03 | 2 | Republican | |||||||||||||
2101 | P000354 | sen | SC | 1799-12-02 | 1801-03-03 | 2 | Republican | |||||||||||||
2109 | P000386 | sen | VA | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
2166 | W000052 | sen | GA | 1819-12-06 | 1821-12-31 | 2 | Republican | |||||||||||||
2363 | L000378 | sen | MA | 1822-06-05 | 1823-03-03 | 2 | Adams | |||||||||||||
2364 | L000378 | sen | MA | 1823-12-01 | 1826-05-23 | 2 | Adams |