legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,365 rows where state = "NC" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- Democrat 745
- Republican 396
- Whig 74
- Jackson 59
- Federalist 35
- Populist 11
- Adams 6
- American 5
- Ind. Republican-Democrat 4
- Anti-Administration 2
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31 | 31 | John Ashe A000307 | rep | NC | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
32 | 32 | John Ashe A000307 | rep | NC | 1791-10-24 | 1793-03-03 | 3 | ||||||||||||||
57 | 57 | John Steele S000832 | rep | NC | 1789-03-04 | 1791-03-03 | 4 | ||||||||||||||
58 | 58 | John Steele S000832 | rep | NC | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
108 | 108 | Joseph McDowell M000424 | rep | NC | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
109 | 109 | Alexander Mebane M000622 | rep | NC | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
136 | 136 | Benjamin Williams W000491 | rep | NC | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
146 | 146 | Timothy Bloodworth B000563 | rep | NC | 1789-03-04 | 1791-03-03 | 3 | ||||||||||||||
2386 | 2386 | Hutchins Burton B001152 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2455 | 2455 | George Outlaw O000139 | rep | NC | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2490 | 2490 | Richard Spaight S000694 | rep | NC | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
2522 | 2522 | Robert Vance V000018 | rep | NC | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2882 | 2882 | John Long L000421 | rep | NC | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3131 | 3131 | Gabriel Holmes H000737 | rep | NC | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3607 | 3607 | Daniel Barringer B000181 | rep | NC | 1833-12-02 | 1835-03-03 | 8 | ||||||||||||||
2805 | 2805 | John Bryan B000988 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
2828 | 2828 | John Culpepper C000976 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 7 | |||||||||||||
2883 | 2883 | John Long L000421 | rep | NC | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2884 | 2884 | John Long L000421 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 10 | |||||||||||||
5075 | 5075 | Lewis Williams W000527 | rep | NC | 1825-12-05 | 1827-03-03 | Adams | 13 | |||||||||||||
5076 | 5076 | Lewis Williams W000527 | rep | NC | 1827-12-03 | 1829-03-03 | Adams | 13 | |||||||||||||
6893 | 6893 | Robert Paine P000030 | rep | NC | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
6905 | 6905 | Richard Puryear P000578 | rep | NC | 1855-12-03 | 1857-03-03 | American | 6 | |||||||||||||
6906 | 6906 | Edwin Reade R000095 | rep | NC | 1855-12-03 | 1857-03-03 | American | 5 | |||||||||||||
7418 | 7418 | John Gilmer G000217 | rep | NC | 1857-12-07 | 1859-03-03 | American | 5 | |||||||||||||
12339 | 12339 | Zebulon Vance V000021 | rep | NC | 1857-12-07 | 1859-03-03 | American | 8 | |||||||||||||
5957 | 5957 | Edmund Deberry D000181 | rep | NC | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 7 | |||||||||||||
87 | 87 | William Dawson D000157 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 8 | |||||||||||||
575 | 575 | James Gillespie G000196 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 6 | |||||||||||||
8268 | 8268 | Nathaniel Boyden B000722 | rep | NC | 1867-03-04 | 1869-03-03 | Conservative | 6 | |||||||||||||
2419 | 2419 | Alfred Gatlin G000099 | rep | NC | 1823-12-01 | 1825-03-03 | Crawford Republican | 1 | |||||||||||||
3854 | 3854 | Bedford Brown B000903 | sen | NC | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
4121 | 4121 | Robert Strange S000992 | sen | NC | 1836-12-05 | 1837-03-03 | 3 | Democrat | |||||||||||||
4122 | 4122 | Robert Strange S000992 | sen | NC | 1837-09-04 | 1840-11-16 | 3 | Democrat | |||||||||||||
4412 | 4412 | Jesse Bynum B001204 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4413 | 4413 | Jesse Bynum B001204 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4426 | 4426 | Henry Connor C000700 | rep | NC | 1823-12-01 | 1825-03-03 | Democrat | 11 | |||||||||||||
4433 | 4433 | Henry Connor C000700 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 11 | |||||||||||||
4434 | 4434 | Henry Connor C000700 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
4470 | 4470 | Charles Fisher F000144 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
4508 | 4508 | Micajah Hawkins H000373 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4509 | 4509 | Micajah Hawkins H000373 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4511 | 4511 | John Hill H000594 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
4562 | 4562 | William Montgomery M000874 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4563 | 4563 | William Montgomery M000874 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4609 | 4609 | Charles Shepard S000329 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4721 | 4721 | Greene Caldwell C000032 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 11 | |||||||||||||
5115 | 5115 | Archibald Arrington A000302 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5116 | 5116 | Archibald Arrington A000302 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5216 | 5216 | William Haywood H000411 | sen | NC | 1843-12-04 | 1847-03-03 | 3 | Democrat | |||||||||||||
5285 | 5285 | Romulus Saunders S000078 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
5286 | 5286 | Romulus Saunders S000078 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5386 | 5386 | Henry Clark C000434 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 8 | |||||||||||||
5412 | 5412 | James Dobbin D000381 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
5787 | 5787 | James McKay M000489 | rep | NC | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
5788 | 5788 | James McKay M000489 | rep | NC | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
5789 | 5789 | James McKay M000489 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5790 | 5790 | James McKay M000489 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5791 | 5791 | James McKay M000489 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5792 | 5792 | James McKay M000489 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6264 | 6264 | John Daniel D000034 | rep | NC | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
6265 | 6265 | John Daniel D000034 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6266 | 6266 | John Daniel D000034 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
6267 | 6267 | John Daniel D000034 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
6268 | 6268 | John Daniel D000034 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6269 | 6269 | John Daniel D000034 | rep | NC | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
6440 | 6440 | Abraham Venable V000084 | rep | NC | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6441 | 6441 | Abraham Venable V000084 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6442 | 6442 | Abraham Venable V000084 | rep | NC | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6491 | 6491 | William Ashe A000310 | rep | NC | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6492 | 6492 | William Ashe A000310 | rep | NC | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6493 | 6493 | William Ashe A000310 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6742 | 6742 | David Reid R000144 | rep | NC | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
6743 | 6743 | David Reid R000144 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
6744 | 6744 | David Reid R000144 | sen | NC | 1854-01-01 | 1859-03-03 | 2 | Democrat | |||||||||||||
6775 | 6775 | Asa Biggs B000456 | rep | NC | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
6776 | 6776 | Asa Biggs B000456 | sen | NC | 1855-12-03 | 1859-03-03 | 3 | Democrat | |||||||||||||
7218 | 7218 | Henry Shaw S000308 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
7219 | 7219 | Henry Shaw S000308 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7264 | 7264 | Thomas Clingman C000524 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
7265 | 7265 | Thomas Clingman C000524 | rep | NC | 1855-12-03 | 1857-03-03 | Democrat | 8 | |||||||||||||
7266 | 7266 | Thomas Clingman C000524 | sen | NC | 1858-01-01 | 1861-03-03 | 3 | Democrat | |||||||||||||
7311 | 7311 | Thomas Bragg B000759 | sen | NC | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7312 | 7312 | Lawrence Branch B000764 | rep | NC | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7313 | 7313 | Lawrence Branch B000764 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7314 | 7314 | Lawrence Branch B000764 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
7362 | 7362 | Francis Craige C000862 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 7 | |||||||||||||
7363 | 7363 | Francis Craige C000862 | rep | NC | 1855-12-03 | 1857-03-03 | Democrat | 7 | |||||||||||||
7364 | 7364 | Francis Craige C000862 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7365 | 7365 | Francis Craige C000862 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7555 | 7555 | Thomas Ruffin R000499 | rep | NC | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7556 | 7556 | Thomas Ruffin R000499 | rep | NC | 1855-12-03 | 1857-03-03 | Democrat | 2 | |||||||||||||
7557 | 7557 | Thomas Ruffin R000499 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7558 | 7558 | Thomas Ruffin R000499 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7631 | 7631 | Warren Winslow W000640 | rep | NC | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7632 | 7632 | Warren Winslow W000640 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7633 | 7633 | Warren Winslow W000640 | rep | NC | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
8665 | 8665 | John Manning M000109 | rep | NC | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
8923 | 8923 | James Harper H000222 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
9006 | 9006 | Sion Rogers R000402 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 4 |
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);