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 1829-12-07 and state = "VA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3046 | 3046 | Philip Barbour B000131 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3215 | 3215 | Alexander Smyth S000646 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3243 | 3243 | Littleton Tazewell T000108 | sen | VA | 1829-12-07 | 1833-03-03 | 2 | Jackson | |||||||||||||
3249 | 3249 | James Trezvant T000365 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3291 | 3291 | Mark Alexander A000099 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3294 | 3294 | Robert Allen A000143 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3306 | 3306 | William Armstrong A000284 | rep | VA | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3312 | 3312 | John Barbour B000128 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3335 | 3335 | Richard Coke C000602 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3366 | 3366 | Philip Doddridge D000391 | rep | VA | 1829-12-07 | 1831-03-03 | 18 | ||||||||||||||
3368 | 3368 | Joseph Draper D000487 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 22 | |||||||||||||
3466 | 3466 | Lewis Maxwell M000269 | rep | VA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 21 | |||||||||||||
3478 | 3478 | William McCoy M000377 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 19 | |||||||||||||
3518 | 3518 | Thomas Newton N000078 | rep | VA | 1829-12-07 | 1831-03-03 | Republican | 1 | |||||||||||||
3626 | 3626 | Thomas Bouldin B000663 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3655 | 3655 | Thomas Davenport D000079 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3683 | 3683 | William Gordon G000319 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3800 | 3800 | Andrew Stevenson S000891 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3870 | 3870 | Nathaniel Claiborne C000405 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3997 | 3997 | George Loyall L000488 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4047 | 4047 | John Roane R000291 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
4312 | 4312 | John Patton P000140 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4438 | 4438 | Robert Craig C000859 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
4552 | 4552 | Charles Mercer M000642 | rep | VA | 1829-12-07 | 1831-03-03 | Whig | 14 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4972 | 4972 | William Rives R000285 | rep | VA | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
5025 | 5025 | John Taliaferro T000027 | rep | VA | 1829-12-07 | 1831-03-03 | Republican | 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);