legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
745 rows where party = "Democrat" and state = "NC"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, fax, contact_form, office, rss_url, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
9014 | 9014 | Francis Shober S000372 | rep | NC | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
9015 | 9015 | Francis Shober S000372 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9233 | 9233 | James Leach L000170 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9234 | 9234 | James Leach L000170 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9275 | 9275 | Augustus Merrimon M000659 | sen | NC | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
9444 | 9444 | Thomas Ashe A000309 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9445 | 9445 | Thomas Ashe A000309 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9917 | 9917 | William Robbins R000302 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9918 | 9918 | William Robbins R000302 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9919 | 9919 | William Robbins R000302 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
9965 | 9965 | Alfred Waddell W000002 | rep | NC | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
9966 | 9966 | Alfred Waddell W000002 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9967 | 9967 | Alfred Waddell W000002 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9968 | 9968 | Alfred Waddell W000002 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10059 | 10059 | Joseph Davis D000123 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
10060 | 10060 | Joseph Davis D000123 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10061 | 10061 | Joseph Davis D000123 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10130 | 10130 | William Kitchin K000251 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10202 | 10202 | Walter Steele S000838 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10203 | 10203 | Walter Steele S000838 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10226 | 10226 | Jesse Yeates Y000016 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10227 | 10227 | Jesse Yeates Y000016 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10228 | 10228 | Jesse Yeates Y000016 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10254 | 10254 | Robert Armfield A000278 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10255 | 10255 | Robert Armfield A000278 | rep | NC | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
10529 | 10529 | John Shackelford S000273 | rep | NC | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
10703 | 10703 | Clement Dowd D000463 | rep | NC | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
10704 | 10704 | Clement Dowd D000463 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
10877 | 10877 | Alfred Scales S000103 | rep | NC | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
10878 | 10878 | Alfred Scales S000103 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
10879 | 10879 | Alfred Scales S000103 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 5 |
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);