legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
18 rows where "end" is on date 1823-03-03, party = "Republican" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: start, class, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1790 | 1790 | Montfort Stokes S000949 | sen | NC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
1880 | 1880 | David Morril M000966 | sen | NH | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
1949 | 1949 | John Williams W000516 | sen | TN | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2109 | 2109 | James Pleasants P000386 | sen | VA | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
2167 | 2167 | John Walker W000061 | sen | AL | 1819-12-06 | 1823-03-03 | 3 | Republican | |||||||||||||
2304 | 2304 | William Pinkney P000362 | sen | MD | 1821-12-03 | 1823-03-03 | 1 | Republican | |||||||||||||
2371 | 2371 | John Taylor T000086 | sen | VA | 1822-12-18 | 1823-03-03 | 2 | Republican | |||||||||||||
2392 | 2392 | John Chandler C000291 | sen | ME | 1820-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2500 | 2500 | Jesse Thomas T000171 | sen | IL | 1818-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2523 | 2523 | Nicholas Ware W000148 | sen | GA | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
2537 | 2537 | Thomas Williams W000540 | sen | MS | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2760 | 2760 | William Smith S000628 | sen | SC | 1817-03-04 | 1823-03-03 | 2 | Republican | |||||||||||||
3079 | 3079 | Mahlon Dickerson D000308 | sen | NJ | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
3961 | 3961 | Richard Johnson J000170 | sen | KY | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
3977 | 3977 | Nehemiah Knight K000287 | sen | RI | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
4613 | 4613 | Samuel Southard S000689 | sen | NJ | 1821-03-06 | 1823-03-03 | 1 | Republican | |||||||||||||
5342 | 5342 | Henry Johnson J000137 | sen | LA | 1818-01-01 | 1823-03-03 | 2 | Republican | |||||||||||||
5873 | 5873 | William King K000217 | sen | AL | 1819-12-14 | 1823-03-03 | 2 | Republican |
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);