legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,910 rows where type = "sen" sorted by party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4258 | 4258 | Lewis Linn L000338 | sen | MO | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4267 | 4267 | Wilson Lumpkin L000512 | sen | GA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4284 | 4284 | John McKinley M000519 | sen | AL | 1837-09-04 | 1837-12-31 | 3 | Democrat | |||||||||||||
4296 | 4296 | Alexander Mouton M001050 | sen | LA | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4335 | 4335 | William Roane R000293 | sen | VA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4352 | 4352 | Perry Smith S000600 | sen | CT | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4386 | 4386 | Richard Young Y000050 | sen | IL | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
4389 | 4389 | James Trotter T000380 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4390 | 4390 | Thomas Williams W000539 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4495 | 4495 | Felix Grundy G000509 | sen | TN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4622 | 4622 | Nathaniel Tallmadge T000032 | sen | NY | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4624 | 4624 | Benjamin Tappan T000039 | sen | OH | 1839-12-02 | 1845-03-03 | 1 | Democrat | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4639 | 4639 | Reuel Williams W000532 | sen | ME | 1839-12-02 | 1843-12-31 | 1 | Democrat | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4797 | 4797 | William Fulton F000425 | sen | AR | 1836-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4798 | 4798 | William Fulton F000425 | sen | AR | 1841-05-31 | 1845-03-03 | 2 | Democrat | |||||||||||||
4898 | 4898 | Samuel McRoberts M000599 | sen | IL | 1841-05-31 | 1843-12-31 | 2 | Democrat | |||||||||||||
4974 | 4974 | William Rives R000285 | sen | VA | 1836-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
5045 | 5045 | Robert Walker W000067 | sen | MS | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5046 | 5046 | Robert Walker W000067 | sen | MS | 1841-05-31 | 1845-12-31 | 2 | Democrat | |||||||||||||
5089 | 5089 | Levi Woodbury W000711 | sen | NH | 1841-05-31 | 1845-12-31 | 2 | Democrat | |||||||||||||
5107 | 5107 | George McDuffie M000426 | sen | SC | 1842-12-23 | 1843-03-03 | 3 | Democrat | |||||||||||||
5108 | 5108 | George McDuffie M000426 | sen | SC | 1843-12-04 | 1846-08-17 | 3 | Democrat | |||||||||||||
5111 | 5111 | Leonard Wilcox W000458 | sen | NH | 1842-01-01 | 1843-03-03 | 3 | Democrat | |||||||||||||
5113 | 5113 | William Allen A000150 | sen | OH | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5114 | 5114 | William Allen A000150 | sen | OH | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
5141 | 5141 | Sidney Breese B000793 | sen | IL | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5176 | 5176 | Walter Colquitt C000648 | sen | GA | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5213 | 5213 | Edward Hannegan H000167 | sen | IN | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5216 | 5216 | William Haywood H000411 | sen | NC | 1843-12-04 | 1847-03-03 | 3 | Democrat | |||||||||||||
5219 | 5219 | Daniel Huger H000917 | sen | SC | 1843-12-04 | 1845-12-31 | 2 | Democrat | |||||||||||||
5248 | 5248 | Lucius Lyon L000544 | sen | MI | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
5256 | 5256 | John Niles N000108 | sen | CT | 1835-12-07 | 1839-03-03 | 1 | Democrat | |||||||||||||
5257 | 5257 | John Niles N000108 | sen | CT | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5287 | 5287 | James Semple S000239 | sen | IL | 1843-12-04 | 1847-03-03 | 2 | Democrat | |||||||||||||
5294 | 5294 | Ambrose Sevier S000256 | sen | AR | 1836-09-18 | 1837-03-03 | 3 | Democrat | |||||||||||||
5295 | 5295 | Ambrose Sevier S000256 | sen | AR | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5296 | 5296 | Ambrose Sevier S000256 | sen | AR | 1843-12-04 | 1848-03-15 | 3 | Democrat | |||||||||||||
5335 | 5335 | Silas Wright W000770 | sen | NY | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5336 | 5336 | Silas Wright W000770 | sen | NY | 1843-12-04 | 1845-03-03 | 3 | Democrat | |||||||||||||
5337 | 5337 | Daniel Dickinson D000317 | sen | NY | 1844-11-30 | 1845-03-03 | 1 | Democrat | |||||||||||||
5338 | 5338 | Daniel Dickinson D000317 | sen | NY | 1845-03-04 | 1851-03-03 | 1 | Democrat | |||||||||||||
5340 | 5340 | Henry Foster F000304 | sen | NY | 1844-01-01 | 1845-12-31 | 3 | Democrat | |||||||||||||
5376 | 5376 | Joseph Chalmers C000273 | sen | MS | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5411 | 5411 | John Dix D000365 | sen | NY | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5422 | 5422 | John Fairfield F000006 | sen | ME | 1843-12-04 | 1845-03-03 | 1 | Democrat | |||||||||||||
5423 | 5423 | John Fairfield F000006 | sen | ME | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5454 | 5454 | Benning Jenness J000094 | sen | NH | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5498 | 5498 | Isaac Pennybacker P000216 | sen | VA | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5528 | 5528 | Jesse Speight S000715 | sen | MS | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5534 | 5534 | Daniel Sturgeon S001046 | sen | PA | 1840-01-01 | 1845-03-03 | 1 | Democrat | |||||||||||||
5535 | 5535 | Daniel Sturgeon S001046 | sen | PA | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5554 | 5554 | Hopkins Turney T000430 | sen | TN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5572 | 5572 | James Westcott W000308 | sen | FL | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5601 | 5601 | Chester Ashley A000311 | sen | AR | 1844-01-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5602 | 5602 | Chester Ashley A000311 | sen | AR | 1847-12-06 | 1849-03-03 | 2 | Democrat | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5638 | 5638 | John Calhoun C000044 | sen | SC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
5639 | 5639 | John Calhoun C000044 | sen | SC | 1841-05-31 | 1843-12-31 | 2 | Democrat | |||||||||||||
5640 | 5640 | John Calhoun C000044 | sen | SC | 1845-12-01 | 1847-03-03 | 2 | Democrat | |||||||||||||
5641 | 5641 | John Calhoun C000044 | sen | SC | 1847-12-06 | 1851-03-03 | 2 | Democrat | |||||||||||||
5674 | 5674 | Solomon Downs D000476 | sen | LA | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5694 | 5694 | Henry Foote F000251 | sen | MS | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5860 | 5860 | Solon Borland B000642 | sen | AR | 1848-03-30 | 1849-03-03 | 3 | Democrat | |||||||||||||
5861 | 5861 | Solon Borland B000642 | sen | AR | 1849-03-05 | 1853-04-11 | 3 | Democrat | |||||||||||||
5866 | 5866 | Augustus Dodge D000394 | sen | IA | 1848-12-07 | 1849-03-03 | 3 | Democrat | |||||||||||||
5867 | 5867 | Augustus Dodge D000394 | sen | IA | 1849-03-05 | 1855-02-22 | 3 | Democrat | |||||||||||||
5868 | 5868 | Thomas Fitzgerald F000167 | sen | MI | 1848-01-01 | 1849-12-31 | 1 | Democrat | |||||||||||||
5869 | 5869 | Herschel Johnson J000139 | sen | GA | 1848-01-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
5886 | 5886 | Wyman Moor M000889 | sen | ME | 1848-01-01 | 1849-03-03 | 1 | Democrat | |||||||||||||
5887 | 5887 | Isaac Walker W000055 | sen | WI | 1848-06-08 | 1849-03-03 | 3 | Democrat | |||||||||||||
5888 | 5888 | Isaac Walker W000055 | sen | WI | 1849-03-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
5897 | 5897 | David Atchison A000322 | sen | MO | 1843-12-04 | 1849-03-03 | 3 | Democrat | |||||||||||||
5898 | 5898 | David Atchison A000322 | sen | MO | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
5940 | 5940 | Jeremiah Clemens C000501 | sen | AL | 1849-12-03 | 1853-03-03 | 2 | Democrat | |||||||||||||
6084 | 6084 | Moses Norris N000140 | sen | NH | 1849-12-03 | 1855-03-03 | 3 | Democrat | |||||||||||||
6130 | 6130 | Pierre Soulé S000682 | sen | LA | 1847-12-06 | 1847-12-31 | 2 | Democrat | |||||||||||||
6131 | 6131 | Pierre Soulé S000682 | sen | LA | 1849-12-03 | 1853-12-31 | 3 | Democrat | |||||||||||||
6170 | 6170 | James Whitcomb W000349 | sen | IN | 1849-12-03 | 1853-03-03 | 3 | Democrat | |||||||||||||
6182 | 6182 | Robert Barnwell B000168 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
6185 | 6185 | Franklin Elmore E000158 | sen | SC | 1850-01-01 | 1851-03-03 | 2 | Democrat | |||||||||||||
6188 | 6188 | John Frémont F000374 | sen | CA | 1850-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6197 | 6197 | Robert Rhett R000184 | sen | SC | 1850-01-01 | 1853-03-03 | 2 | Democrat | |||||||||||||
6231 | 6231 | Richard Brodhead B000861 | sen | PA | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6253 | 6253 | Lewis Cass C000233 | sen | MI | 1845-12-01 | 1849-03-03 | 1 | Democrat | |||||||||||||
6254 | 6254 | Lewis Cass C000233 | sen | MI | 1849-12-03 | 1851-03-03 | 1 | Democrat | |||||||||||||
6255 | 6255 | Lewis Cass C000233 | sen | MI | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6278 | 6278 | Henry Dodge D000396 | sen | WI | 1848-01-01 | 1851-03-03 | 1 | 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);