legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
27 rows where "start" is on date 1815-12-04 and state = "VA"
This data as json, copyable, CSV (advanced)
Suggested facets: end, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1474 | 1474 | James Breckinridge B000785 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1510 | 1510 | Matthew Clay C000487 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1522 | 1522 | John Clopton C000531 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 | |||||||||||||
1574 | 1574 | Thomas Gholson G000150 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1603 | 1603 | Aylett Hawes H000361 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 10 | |||||||||||||
1615 | 1615 | John Hungerford H000967 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1625 | 1625 | John Jackson J000021 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1630 | 1630 | John Kerr K000136 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
1649 | 1649 | Joseph Lewis L000290 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 8 | |||||||||||||
1708 | 1708 | Daniel Sheffey S000317 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 6 | |||||||||||||
1746 | 1746 | Magnus Tate T000047 | rep | VA | 1815-12-04 | 1817-03-03 | Federalist | 2 | |||||||||||||
1851 | 1851 | Peterson Goodwyn G000306 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 19 | |||||||||||||
1882 | 1882 | Thomas Nelson N000043 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 18 | |||||||||||||
1941 | 1941 | Henry Tucker T000398 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1986 | 1986 | William Burwell B001160 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 14 | |||||||||||||
2047 | 2047 | James Johnson J000142 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
2107 | 2107 | James Pleasants P000386 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 17 | |||||||||||||
2134 | 2134 | Ballard Smith S000516 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
2193 | 2193 | James Barbour B000127 | sen | VA | 1815-12-04 | 1821-03-03 | 1 | Republican | |||||||||||||
2282 | 2282 | Hugh Nelson N000035 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 22 | |||||||||||||
2785 | 2785 | Burwell Bassett B000224 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 13 | |||||||||||||
3040 | 3040 | Philip Barbour B000131 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 11 | |||||||||||||
3471 | 3471 | William McCoy M000377 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
3511 | 3511 | Thomas Newton N000078 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
3780 | 3780 | John Randolph R000047 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 16 | |||||||||||||
4334 | 4334 | William Roane R000293 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
4653 | 4653 | John Tyler T000450 | rep | VA | 1815-12-04 | 1817-03-03 | Republican | 23 |
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);