legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
16 rows where party = "Anti-Administration" sorted by state_rank
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, type, state, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Richard Bassett B000226 | sen | DE | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
9 | 9 | William Few F000100 | sen | GA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
12 | 12 | William Grayson G000403 | sen | VA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
19 | 19 | Richard Lee L000201 | sen | VA | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
20 | 20 | William Maclay M000031 | sen | PA | 1789-03-04 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
48 | 48 | Moses Robinson R000350 | sen | VT | 1791-10-24 | 1796-10-15 | 1 | Anti-Administration | |||||||||||||
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
87 | 87 | William Dawson D000157 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 8 | |||||||||||||
137 | 137 | Paine Wingate W000633 | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
266 | 266 | Carter Harrison H000266 | rep | VA | 1793-12-02 | 1795-03-03 | Anti-Administration | 10 | |||||||||||||
575 | 575 | James Gillespie G000196 | rep | NC | 1793-12-02 | 1795-03-03 | Anti-Administration | 6 | |||||||||||||
754 | 754 | Joseph Stanton S000805 | sen | RI | 1790-01-01 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
1553 | 1553 | William Findley F000124 | rep | PA | 1791-10-24 | 1793-03-03 | Anti-Administration | 8 | |||||||||||||
1554 | 1554 | William Findley F000124 | rep | PA | 1793-12-02 | 1795-03-03 | Anti-Administration | -1 | |||||||||||||
1791 | 1791 | James Monroe M000858 | sen | VA | 1790-11-09 | 1791-03-03 | 1 | Anti-Administration | |||||||||||||
1792 | 1792 | James Monroe M000858 | sen | VA | 1791-03-04 | 1794-05-27 | 1 | Anti-Administration |
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);