legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
105 rows where party = "Jackson" and state = "VA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2583 | 2583 | George Crump C000956 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
2613 | 2613 | Robert Garnett G000077 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
2723 | 2723 | William Smith S000626 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 21 | |||||||||||||
2789 | 2789 | Burwell Bassett B000224 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
2790 | 2790 | Burwell Bassett B000224 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
2841 | 2841 | John Floyd F000221 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 20 | |||||||||||||
2842 | 2842 | John Floyd F000221 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 20 | |||||||||||||
3045 | 3045 | Philip Barbour B000131 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3214 | 3214 | Alexander Smyth S000646 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 22 | |||||||||||||
3215 | 3215 | Alexander Smyth S000646 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3242 | 3242 | Littleton Tazewell T000108 | sen | VA | 1824-01-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
3243 | 3243 | Littleton Tazewell T000108 | sen | VA | 1829-12-07 | 1833-03-03 | 2 | Jackson | |||||||||||||
3247 | 3247 | James Trezvant T000365 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3248 | 3248 | James Trezvant T000365 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3249 | 3249 | James Trezvant T000365 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3289 | 3289 | Mark Alexander A000099 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
3290 | 3290 | Mark Alexander A000099 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3292 | 3292 | Mark Alexander A000099 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
3293 | 3293 | Robert Allen A000143 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 17 | |||||||||||||
3294 | 3294 | Robert Allen A000143 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3295 | 3295 | Robert Allen A000143 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 17 | |||||||||||||
3310 | 3310 | John Barbour B000128 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 15 | |||||||||||||
3311 | 3311 | John Barbour B000128 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 15 | |||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3313 | 3313 | John Barbour B000128 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 15 | |||||||||||||
3335 | 3335 | Richard Coke C000602 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3336 | 3336 | Richard Coke C000602 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3368 | 3368 | Joseph Draper D000487 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3369 | 3369 | Joseph Draper D000487 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 22 | |||||||||||||
3436 | 3436 | Charles Johnston J000185 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 22 | |||||||||||||
3476 | 3476 | William McCoy M000377 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 19 | |||||||||||||
3477 | 3477 | William McCoy M000377 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 19 | |||||||||||||
3478 | 3478 | William McCoy M000377 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 19 | |||||||||||||
3479 | 3479 | William McCoy M000377 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 19 | |||||||||||||
3536 | 3536 | John Roane R000292 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 12 | |||||||||||||
3626 | 3626 | Thomas Bouldin B000663 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3627 | 3627 | Thomas Bouldin B000663 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
3628 | 3628 | Thomas Bouldin B000663 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3642 | 3642 | Joseph Chinn C000362 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 13 | |||||||||||||
3643 | 3643 | Joseph Chinn C000362 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 10 | |||||||||||||
3653 | 3653 | Thomas Davenport D000079 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
3654 | 3654 | Thomas Davenport D000079 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
3655 | 3655 | Thomas Davenport D000079 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3656 | 3656 | Thomas Davenport D000079 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
3678 | 3678 | John Fulton F000423 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 18 | |||||||||||||
3683 | 3683 | William Gordon G000319 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3684 | 3684 | William Gordon G000319 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
3685 | 3685 | William Gordon G000319 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 12 | |||||||||||||
3785 | 3785 | John Randolph R000047 | sen | VA | 1825-12-26 | 1827-03-03 | 1 | Jackson | |||||||||||||
3786 | 3786 | John Randolph R000047 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3798 | 3798 | Andrew Stevenson S000891 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
3799 | 3799 | Andrew Stevenson S000891 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
3800 | 3800 | Andrew Stevenson S000891 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3801 | 3801 | Andrew Stevenson S000891 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3802 | 3802 | Andrew Stevenson S000891 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
3868 | 3868 | Nathaniel Claiborne C000405 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 7 | |||||||||||||
3869 | 3869 | Nathaniel Claiborne C000405 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
3870 | 3870 | Nathaniel Claiborne C000405 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3871 | 3871 | Nathaniel Claiborne C000405 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3872 | 3872 | Nathaniel Claiborne C000405 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
3997 | 3997 | George Loyall L000488 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3998 | 3998 | George Loyall L000488 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3999 | 3999 | George Loyall L000488 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4000 | 4000 | Edward Lucas L000490 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 15 | |||||||||||||
4001 | 4001 | Edward Lucas L000490 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 15 | |||||||||||||
4006 | 4006 | John Mason M000220 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
4007 | 4007 | John Mason M000220 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4008 | 4008 | John Mason M000220 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4015 | 4015 | William McComas M000352 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 19 | |||||||||||||
4046 | 4046 | John Roane R000291 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 12 | |||||||||||||
4047 | 4047 | John Roane R000291 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
4048 | 4048 | John Roane R000291 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 9 | |||||||||||||
4140 | 4140 | James Bouldin B000662 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4141 | 4141 | James Bouldin B000662 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
4292 | 4292 | William Morgan M000960 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 21 | |||||||||||||
4312 | 4312 | John Patton P000140 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4313 | 4313 | John Patton P000140 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
4314 | 4314 | John Patton P000140 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
4315 | 4315 | John Patton P000140 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
4438 | 4438 | Robert Craig C000859 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
4439 | 4439 | Robert Craig C000859 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 20 | |||||||||||||
4440 | 4440 | Robert Craig C000859 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 17 | |||||||||||||
4476 | 4476 | James Garland G000067 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 12 | |||||||||||||
4656 | 4656 | John Tyler T000450 | sen | VA | 1827-12-03 | 1833-03-03 | 1 | Jackson | |||||||||||||
4670 | 4670 | William Archer A000275 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
4671 | 4671 | William Archer A000275 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4673 | 4673 | William Archer A000275 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4674 | 4674 | William Archer A000275 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
4970 | 4970 | William Rives R000285 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 10 | |||||||||||||
4971 | 4971 | William Rives R000285 | rep | VA | 1827-12-03 | 1829-03-03 | Jackson | 10 | |||||||||||||
4973 | 4973 | William Rives R000285 | sen | VA | 1832-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
5169 | 5169 | Walter Coles C000625 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
5233 | 5233 | John Jones J000240 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
5326 | 5326 | Henry Wise W000649 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
5327 | 5327 | Henry Wise W000649 | rep | VA | 1835-12-07 | 1837-03-03 | Jackson | 8 | |||||||||||||
5456 | 5456 | Joseph Johnson J000155 | rep | VA | 1825-12-05 | 1827-03-03 | Jackson | 18 | |||||||||||||
5457 | 5457 | Joseph Johnson J000155 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 18 |
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);