legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
59 rows where party = "Jackson" and state = "NC"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2595 | 2595 | Weldon Edwards E000083 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
2633 | 2633 | Richard Hines H000634 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2679 | 2679 | Nathaniel Macon M000034 | sen | NC | 1825-12-05 | 1828-11-14 | 3 | Jackson | |||||||||||||
2686 | 2686 | Archibald McNeill M000586 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
2804 | 2804 | John Bryan B000988 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
2947 | 2947 | Lemuel Sawyer S000089 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
2948 | 2948 | Lemuel Sawyer S000089 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
2980 | 2980 | Daniel Turner T000418 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
3018 | 3018 | James Iredell I000028 | sen | NC | 1828-01-01 | 1831-03-03 | 3 | Jackson | |||||||||||||
3031 | 3031 | Willis Alston A000167 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3032 | 3032 | Willis Alston A000167 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3033 | 3033 | Willis Alston A000167 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3090 | 3090 | Edward Dudley D000512 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3129 | 3129 | Gabriel Holmes H000737 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
3130 | 3130 | Gabriel Holmes H000737 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3317 | 3317 | Lauchlin Bethune B000423 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3319 | 3319 | John Branch B000763 | sen | NC | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3320 | 3320 | John Branch B000763 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3327 | 3327 | Samuel Carson C000193 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
3328 | 3328 | Samuel Carson C000193 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 12 | |||||||||||||
3329 | 3329 | Samuel Carson C000193 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3330 | 3330 | Samuel Carson C000193 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 12 | |||||||||||||
3527 | 3527 | Robert Potter P000467 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3603 | 3603 | Daniel Barringer B000181 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
3604 | 3604 | Daniel Barringer B000181 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
3605 | 3605 | Daniel Barringer B000181 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3606 | 3606 | Daniel Barringer B000181 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3695 | 3695 | Thomas Hall H000072 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3696 | 3696 | Thomas Hall H000072 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3697 | 3697 | Thomas Hall H000072 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
3698 | 3698 | Thomas Hall H000072 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3853 | 3853 | Bedford Brown B000903 | sen | NC | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
4410 | 4410 | Jesse Bynum B001204 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4411 | 4411 | Jesse Bynum B001204 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4427 | 4427 | Henry Connor C000700 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 11 | |||||||||||||
4428 | 4428 | Henry Connor C000700 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
4429 | 4429 | Henry Connor C000700 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4430 | 4430 | Henry Connor C000700 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
4431 | 4431 | Henry Connor C000700 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
4432 | 4432 | Henry Connor C000700 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 11 | |||||||||||||
4505 | 4505 | Micajah Hawkins H000373 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
4506 | 4506 | Micajah Hawkins H000373 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
4507 | 4507 | Micajah Hawkins H000373 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
4561 | 4561 | William Montgomery M000874 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 8 | |||||||||||||
4955 | 4955 | Abraham Rencher R000162 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
4956 | 4956 | Abraham Rencher R000162 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
5284 | 5284 | Romulus Saunders S000078 | rep | NC | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
5524 | 5524 | Jesse Speight S000715 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
5525 | 5525 | Jesse Speight S000715 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
5526 | 5526 | Jesse Speight S000715 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
5527 | 5527 | Jesse Speight S000715 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 4 | |||||||||||||
5769 | 5769 | Willie Mangum M000096 | rep | NC | 1825-12-05 | 1826-03-18 | Jackson | 8 | |||||||||||||
5770 | 5770 | Willie Mangum M000096 | sen | NC | 1831-12-05 | 1836-11-26 | 3 | Jackson | |||||||||||||
5784 | 5784 | James McKay M000489 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
5785 | 5785 | James McKay M000489 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
5786 | 5786 | James McKay M000489 | rep | NC | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
6114 | 6114 | Augustine Shepperd S000338 | rep | NC | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
6115 | 6115 | Augustine Shepperd S000338 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
6116 | 6116 | Augustine Shepperd S000338 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 9 |
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);