legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
770 rows where party = "Democrat" and state = "VA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, fax, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4116 | 4116 | Richard Parker P000069 | sen | VA | 1836-01-01 | 1837-12-31 | 2 | Democrat | |||||||||||||
4142 | 4142 | James Bouldin B000662 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4293 | 4293 | William Morgan M000960 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 21 | |||||||||||||
4316 | 4316 | John Patton P000140 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4335 | 4335 | William Roane R000293 | sen | VA | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4363 | 4363 | Archibald Stuart S001032 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4400 | 4400 | Andrew Beirne B000319 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4401 | 4401 | Andrew Beirne B000319 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4441 | 4441 | Robert Craig C000859 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4442 | 4442 | Robert Craig C000859 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4477 | 4477 | James Garland G000067 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 12 | |||||||||||||
4516 | 4516 | Joel Holleman H000721 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4599 | 4599 | Francis Rives R000284 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4600 | 4600 | Francis Rives R000284 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4607 | 4607 | Green Samuels S000028 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4682 | 4682 | Linn Banks B000115 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4683 | 4683 | Linn Banks B000115 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4684 | 4684 | Linn Banks B000115 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
4729 | 4729 | George Cary C000213 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
4823 | 4823 | William Harris H000257 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
4829 | 4829 | Samuel Hays H000407 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
4974 | 4974 | William Rives R000285 | sen | VA | 1836-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
5170 | 5170 | Walter Coles C000625 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
5171 | 5171 | Walter Coles C000625 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
5172 | 5172 | Walter Coles C000625 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5173 | 5173 | Walter Coles C000625 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5205 | 5205 | Thomas Gilmer G000218 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5234 | 5234 | John Jones J000240 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
5235 | 5235 | John Jones J000240 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 3 | |||||||||||||
5236 | 5236 | John Jones J000240 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
5237 | 5237 | John Jones J000240 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5245 | 5245 | William Lucas L000494 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 15 | |||||||||||||
5246 | 5246 | William Lucas L000494 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5301 | 5301 | Lewis Steenrod S000843 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 21 | |||||||||||||
5302 | 5302 | Lewis Steenrod S000843 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 21 | |||||||||||||
5303 | 5303 | Lewis Steenrod S000843 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 15 | |||||||||||||
5331 | 5331 | Henry Wise W000649 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5377 | 5377 | Augustus Chapman C000308 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 12 | |||||||||||||
5378 | 5378 | Augustus Chapman C000308 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 12 | |||||||||||||
5442 | 5442 | Edmund Hubard H000876 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5443 | 5443 | Edmund Hubard H000876 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5444 | 5444 | Edmund Hubard H000876 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5459 | 5459 | Joseph Johnson J000155 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 20 | |||||||||||||
5460 | 5460 | Joseph Johnson J000155 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
5461 | 5461 | Joseph Johnson J000155 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 14 | |||||||||||||
5497 | 5497 | Isaac Pennybacker P000216 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 16 | |||||||||||||
5498 | 5498 | Isaac Pennybacker P000216 | sen | VA | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
5538 | 5538 | William Taylor T000104 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5539 | 5539 | William Taylor T000104 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5549 | 5549 | William Tredway T000360 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5603 | 5603 | Archibald Atkinson A000328 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5604 | 5604 | Archibald Atkinson A000328 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5605 | 5605 | Archibald Atkinson A000328 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5611 | 5611 | Henry Bedinger B000302 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5612 | 5612 | Henry Bedinger B000302 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
5676 | 5676 | George Dromgoole D000504 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
5677 | 5677 | George Dromgoole D000504 | rep | VA | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5678 | 5678 | George Dromgoole D000504 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5679 | 5679 | George Dromgoole D000504 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5680 | 5680 | George Dromgoole D000504 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5844 | 5844 | Robert Thompson T000215 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 14 | |||||||||||||
6055 | 6055 | James McDowell M000419 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
6056 | 6056 | James McDowell M000419 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 11 | |||||||||||||
6057 | 6057 | James McDowell M000419 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 11 | |||||||||||||
6081 | 6081 | Alexander Newman N000070 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 15 | |||||||||||||
6088 | 6088 | Richard Parker P000068 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6112 | 6112 | James Seddon S000220 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
6113 | 6113 | James Seddon S000220 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6212 | 6212 | Thomas Averett A000343 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6213 | 6213 | Thomas Averett A000343 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6219 | 6219 | James Beale B000266 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 14 | |||||||||||||
6220 | 6220 | James Beale B000266 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 14 | |||||||||||||
6329 | 6329 | Alexander Holladay H000714 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
6330 | 6330 | Alexander Holladay H000714 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
6362 | 6362 | Richard Meade M000618 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6363 | 6363 | Richard Meade M000618 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6364 | 6364 | Richard Meade M000618 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6435 | 6435 | George Thompson T000201 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 15 | |||||||||||||
6640 | 6640 | Charles Lewis L000275 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6694 | 6694 | John Snodgrass S000656 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 11 | |||||||||||||
6762 | 6762 | Thomas Bayly B000259 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
6763 | 6763 | Thomas Bayly B000259 | rep | VA | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
6764 | 6764 | Thomas Bayly B000259 | rep | VA | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
6765 | 6765 | Thomas Bayly B000259 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6766 | 6766 | Thomas Bayly B000259 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6767 | 6767 | Thomas Bayly B000259 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6768 | 6768 | Thomas Bayly B000259 | rep | VA | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
6851 | 6851 | Zedekiah Kidwell K000165 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
6852 | 6852 | Zedekiah Kidwell K000165 | rep | VA | 1855-12-03 | 1857-03-03 | Democrat | 10 | |||||||||||||
6872 | 6872 | Fayette McMullen M000578 | rep | VA | 1849-12-03 | 1851-03-03 | Democrat | 13 | |||||||||||||
6873 | 6873 | Fayette McMullen M000578 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 13 | |||||||||||||
6874 | 6874 | Fayette McMullen M000578 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 13 | |||||||||||||
6875 | 6875 | Fayette McMullen M000578 | rep | VA | 1855-12-03 | 1857-03-03 | Democrat | 13 | |||||||||||||
7003 | 7003 | John Caskie C000231 | rep | VA | 1851-12-01 | 1853-03-03 | Democrat | 6 | |||||||||||||
7004 | 7004 | John Caskie C000231 | rep | VA | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
7005 | 7005 | John Caskie C000231 | rep | VA | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7006 | 7006 | John Caskie C000231 | rep | VA | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7091 | 7091 | George Hopkins H000774 | rep | VA | 1837-09-04 | 1839-03-03 | Democrat | 18 | |||||||||||||
7093 | 7093 | George Hopkins H000774 | rep | VA | 1841-05-31 | 1843-03-03 | Democrat | 18 | |||||||||||||
7094 | 7094 | George Hopkins H000774 | rep | VA | 1843-12-04 | 1845-03-03 | Democrat | 13 |
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);