legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,350 rows where class = 2 sorted by legislator_id
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5615 | 5615 | John Berrien B000413 | sen | GA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5616 | 5616 | John Berrien B000413 | sen | GA | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
22036 | 22036 | George Berry B000417 | sen | TN | 1937-05-06 | 1939-01-03 | 2 | Democrat | appointment | ||||||||||||
13858 | 13858 | James Berry B000418 | sen | AR | 1885-12-07 | 1889-03-03 | 2 | Democrat | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
3055 | 3055 | George Bibb B000433 | sen | KY | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
1284 | 1284 | William Bibb B000434 | sen | GA | 1813-11-06 | 1816-11-09 | 2 | Republican | |||||||||||||
38428 | 38428 | Joseph Biden B000444 | sen | DE | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
38429 | 38429 | Joseph Biden B000444 | sen | DE | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
38430 | 38430 | Joseph Biden B000444 | sen | DE | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
38431 | 38431 | Joseph Biden B000444 | sen | DE | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
38432 | 38432 | Joseph Biden B000444 | sen | DE | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
38433 | 38433 | Joseph Biden B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
38434 | 38434 | Joseph Biden B000444 | sen | DE | 2009-01-06 | 2009-01-15 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
7294 | 7294 | Kinsley Bingham B000473 | sen | MI | 1859-12-05 | 1861-12-31 | 2 | Republican | |||||||||||||
13870 | 13870 | Joseph Blackburn B000508 | sen | KY | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
9721 | 9721 | James Blaine B000519 | sen | ME | 1876-07-10 | 1877-03-03 | 2 | Republican | |||||||||||||
9722 | 9722 | James Blaine B000519 | sen | ME | 1877-03-05 | 1881-03-05 | 2 | Republican | |||||||||||||
27105 | 27105 | William Blakley B000536 | sen | TX | 1961-01-03 | 1961-12-31 | 2 | Democrat | appointment | ||||||||||||
18914 | 18914 | Coleman Blease B000553 | sen | SC | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
224 | 224 | William Blount B000570 | sen | TN | 1796-01-01 | 1797-12-31 | 2 | Republican | |||||||||||||
28785 | 28785 | James Boggs B000593 | sen | DE | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28786 | 28786 | James Boggs B000593 | sen | DE | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
22047 | 22047 | William Borah B000634 | sen | ID | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
22048 | 22048 | William Borah B000634 | sen | ID | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
22049 | 22049 | William Borah B000634 | sen | ID | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
22050 | 22050 | William Borah B000634 | sen | ID | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
22051 | 22051 | William Borah B000634 | sen | ID | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
22052 | 22052 | William Borah B000634 | sen | ID | 1937-01-05 | 1941-01-03 | 2 | Republican | |||||||||||||
34259 | 34259 | David Boren B000639 | sen | OK | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34260 | 34260 | David Boren B000639 | sen | OK | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34261 | 34261 | David Boren B000639 | sen | OK | 1991-01-03 | 1995-01-03 | 2 | Democrat | |||||||||||||
33240 | 33240 | Rudolph Boschwitz B000647 | sen | MN | 1978-12-30 | 1979-01-03 | 2 | Republican | |||||||||||||
33241 | 33241 | Rudolph Boschwitz B000647 | sen | MN | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
33242 | 33242 | Rudolph Boschwitz B000647 | sen | MN | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
2541 | 2541 | Charles Bouligny B000664 | sen | LA | 1824-01-01 | 1829-03-03 | 2 | Adams | |||||||||||||
14988 | 14988 | Jonathan Bourne B000670 | sen | OR | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
9097 | 9097 | George Boutwell B000674 | sen | MA | 1873-12-01 | 1877-03-03 | 2 | Republican | |||||||||||||
10642 | 10642 | Thomas Bowen B000686 | sen | CO | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
25854 | 25854 | Eva Bowring B000709 | sen | NE | 1954-04-16 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
79 | 79 | William Bradford B000739 | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | |||||||||||||
7311 | 7311 | Thomas Bragg B000759 | sen | NC | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
3319 | 3319 | John Branch B000763 | sen | NC | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
20135 | 20135 | Sam Bratton B000774 | sen | NM | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
20136 | 20136 | Sam Bratton B000774 | sen | NM | 1931-12-07 | 1933-12-31 | 2 | Democrat | |||||||||||||
25880 | 25880 | Henry Bridges B000823 | sen | NH | 1937-01-05 | 1943-01-03 | 2 | Republican | |||||||||||||
25881 | 25881 | Henry Bridges B000823 | sen | NH | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
25882 | 25882 | Henry Bridges B000823 | sen | NH | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25883 | 25883 | Henry Bridges B000823 | sen | NH | 1955-01-05 | 1961-01-03 | 2 | Republican | |||||||||||||
25884 | 25884 | Henry Bridges B000823 | sen | NH | 1961-01-03 | 1961-11-26 | 2 | Republican | |||||||||||||
14995 | 14995 | Frank Briggs B000827 | sen | NJ | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
19597 | 19597 | William Brock B000850 | sen | TN | 1929-09-02 | 1931-03-03 | 2 | Democrat | appointment | ||||||||||||
30195 | 30195 | Edward Brooke B000871 | sen | MA | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
30196 | 30196 | Edward Brooke B000871 | sen | MA | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
6468 | 6468 | Walker Brooke B000872 | sen | MS | 1852-01-01 | 1853-03-03 | 2 | Whig | |||||||||||||
19234 | 19234 | Smith Brookhart B000873 | sen | IA | 1922-01-01 | 1925-03-03 | 2 | Republican | |||||||||||||
19235 | 19235 | Smith Brookhart B000873 | sen | IA | 1925-12-07 | 1927-03-04 | 2 | Republican | |||||||||||||
23349 | 23349 | Charles Brooks B000874 | sen | IL | 1940-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
23350 | 23350 | Charles Brooks B000874 | sen | IL | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24728 | 24728 | Joseph Broughton B000894 | sen | NC | 1948-12-31 | 1949-01-03 | 2 | Democrat | |||||||||||||
24729 | 24729 | Joseph Broughton B000894 | sen | NC | 1949-01-03 | 1949-03-06 | 2 | Democrat | |||||||||||||
7326 | 7326 | Albert Brown B000900 | sen | MS | 1854-01-01 | 1859-03-03 | 2 | Democrat | |||||||||||||
7327 | 7327 | Albert Brown B000900 | sen | MS | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
3853 | 3853 | Bedford Brown B000903 | sen | NC | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
34288 | 34288 | George Brown B000919 | sen | CO | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
1976 | 1976 | James Brown B000921 | sen | LA | 1813-05-24 | 1817-03-03 | 2 | Republican | |||||||||||||
328 | 328 | John Brown B000929 | sen | KY | 1792-06-18 | 1793-03-03 | 2 | Republican | |||||||||||||
329 | 329 | John Brown B000929 | sen | KY | 1793-03-04 | 1799-03-03 | 2 | Republican | |||||||||||||
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
14997 | 14997 | Norris Brown B000939 | sen | NE | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
22013 | 22013 | Prentiss Brown B000941 | sen | MI | 1936-11-19 | 1937-01-03 | 2 | Democrat | |||||||||||||
22014 | 22014 | Prentiss Brown B000941 | sen | MI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
7676 | 7676 | Orville Browning B000960 | sen | IL | 1861-07-04 | 1863-12-31 | 2 | Republican | |||||||||||||
23351 | 23351 | Clayton Buck B001013 | sen | DE | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
1304 | 1304 | William Bulloch B001051 | sen | GA | 1813-05-24 | 1813-12-31 | 2 | Republican | |||||||||||||
22075 | 22075 | William Bulow B001055 | sen | SD | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22076 | 22076 | William Bulow B001055 | sen | SD | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
24241 | 24241 | Thomas Burch B001069 | sen | VA | 1946-05-31 | 1946-11-05 | 2 | Democrat | appointment | ||||||||||||
16316 | 16316 | Edwin Burleigh B001105 | sen | ME | 1913-04-07 | 1917-03-03 | 2 | Republican | |||||||||||||
15013 | 15013 | Henry Burnham B001125 | sen | NH | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15014 | 15014 | Henry Burnham B001125 | sen | NH | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
1808 | 1808 | James Burrill B001137 | sen | RI | 1817-12-01 | 1821-03-03 | 2 | Federalist | |||||||||||||
18079 | 18079 | Holm Bursum B001144 | sen | NM | 1921-04-11 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
13901 | 13901 | Joseph Burton B001154 | sen | KS | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
23353 | 23353 | Harlan Bushfield B001168 | sen | SD | 1943-01-06 | 1948-09-27 | 2 | Republican | |||||||||||||
24730 | 24730 | Vera Bushfield B001169 | sen | SD | 1948-10-06 | 1948-12-26 | 2 | Republican | appointment | ||||||||||||
12931 | 12931 | Marion Butler B001183 | sen | NC | 1895-12-02 | 1901-03-03 | 2 | Populist | |||||||||||||
11636 | 11636 | Matthew Butler B001184 | sen | SC | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11637 | 11637 | Matthew Butler B001184 | sen | SC | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11638 | 11638 | Matthew Butler B001184 | sen | SC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
548 | 548 | Pierce Butler B001186 | sen | SC | 1789-03-04 | 1793-03-03 | 2 | Democratic Republican | |||||||||||||
549 | 549 | Pierce Butler B001186 | sen | SC | 1793-12-02 | 1797-03-03 | 2 | Republican | |||||||||||||
22084 | 22084 | James Byrnes B001215 | sen | SC | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22085 | 22085 | James Byrnes B001215 | sen | SC | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
34262 | 34262 | William Bradley B001225 | sen | NJ | 1979-01-15 | 1985-01-03 | 2 | Democrat |
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);