legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
23 rows where party = "Whig" and state = "LA"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4424 | 4424 | Thomas Chinn C000363 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 2 | |||||||||||||
4481 | 4481 | Rice Garland G000070 | rep | LA | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4482 | 4482 | Rice Garland G000070 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4685 | 4685 | Alexander Barrow B000183 | sen | LA | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5060 | 5060 | Edward White W000365 | rep | LA | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
5061 | 5061 | Edward White W000365 | rep | LA | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
5062 | 5062 | Edward White W000365 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5063 | 5063 | Edward White W000365 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
5064 | 5064 | Edward White W000365 | rep | LA | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
5344 | 5344 | Henry Johnson J000137 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5345 | 5345 | Henry Johnson J000137 | rep | LA | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
5346 | 5346 | Henry Johnson J000137 | rep | LA | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
5347 | 5347 | Henry Johnson J000137 | sen | LA | 1844-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5840 | 5840 | Bannon Thibodeaux T000152 | rep | LA | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5841 | 5841 | Bannon Thibodeaux T000152 | rep | LA | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5919 | 5919 | Henry Bullard B001049 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5944 | 5944 | Charles Conrad C000703 | sen | LA | 1842-01-01 | 1843-03-03 | 3 | Whig | |||||||||||||
5945 | 5945 | Charles Conrad C000703 | rep | LA | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
6352 | 6352 | Joseph Landry L000055 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 2 | |||||||||||||
6369 | 6369 | John Moore M000903 | rep | LA | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
6370 | 6370 | John Moore M000903 | rep | LA | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
6371 | 6371 | John Moore M000903 | rep | LA | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
6623 | 6623 | Theodore Hunt H000977 | rep | LA | 1853-12-05 | 1855-03-03 | Whig | 2 |
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);