legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
29 rows where party = "Federalist" and "start" is on date 1807-10-26
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
813 | 813 | James Broom B000888 | rep | DE | 1807-10-26 | 1809-03-03 | Federalist | 0 | |||||||||||||
834 | 834 | James Elliott E000122 | rep | VT | 1807-10-26 | 1809-03-03 | Federalist | 2 | |||||||||||||
844 | 844 | Chauncey Goodrich G000293 | sen | CT | 1807-10-26 | 1813-03-03 | 3 | Federalist | |||||||||||||
863 | 863 | James Kelly K000073 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 6 | |||||||||||||
956 | 956 | John Campbell C000091 | rep | MD | 1807-10-26 | 1809-03-03 | Federalist | 1 | |||||||||||||
970 | 970 | Barent Gardenier G000049 | rep | NY | 1807-10-26 | 1809-03-03 | Federalist | 7 | |||||||||||||
999 | 999 | Robert Jenkins J000087 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1018 | 1018 | Edward Livermore L000363 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1070 | 1070 | William Stedman S000828 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 11 | |||||||||||||
1076 | 1076 | Jabez Upham U000023 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 10 | |||||||||||||
1083 | 1083 | Killian Van Rensselaer V000054 | rep | NY | 1807-10-26 | 1809-03-03 | Federalist | 9 | |||||||||||||
1131 | 1131 | Martin Chittenden C000372 | rep | VT | 1807-10-26 | 1809-03-03 | Federalist | 4 | |||||||||||||
1183 | 1183 | Philip Key K000159 | rep | MD | 1807-10-26 | 1809-03-03 | Federalist | 3 | |||||||||||||
1209 | 1209 | Josiah Quincy Q000015 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 1 | |||||||||||||
1331 | 1331 | William Ely E000168 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 5 | |||||||||||||
1362 | 1362 | Richard Jackson J000025 | rep | RI | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1490 | 1490 | Epaphroditus Champion C000288 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1537 | 1537 | Samuel Dana D000024 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1545 | 1545 | John Davenport D000075 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1581 | 1581 | Charles Goldsborough G000261 | rep | MD | 1807-10-26 | 1809-03-03 | Federalist | 8 | |||||||||||||
1645 | 1645 | Joseph Lewis L000290 | rep | VA | 1807-10-26 | 1809-03-03 | Federalist | 7 | |||||||||||||
1726 | 1726 | Lewis Sturges S001048 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1733 | 1733 | Samuel Taggart T000012 | rep | MA | 1807-10-26 | 1809-03-03 | Federalist | 6 | |||||||||||||
1741 | 1741 | Benjamin Tallmadge T000029 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
1895 | 1895 | Timothy Pitkin P000368 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
2084 | 2084 | Jonathan Moseley M001023 | rep | CT | 1807-10-26 | 1809-03-03 | Federalist | -1 | |||||||||||||
2267 | 2267 | William Milnor M000786 | rep | PA | 1807-10-26 | 1809-03-03 | Federalist | 2 | |||||||||||||
2516 | 2516 | Nicholas Van Dyke V000037 | rep | DE | 1807-10-26 | 1809-03-03 | Federalist | 0 | |||||||||||||
2823 | 2823 | John Culpepper C000976 | rep | NC | 1807-10-26 | 1809-03-03 | Federalist | 7 |
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);