legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
22 rows where "end" is on date 1819-03-03 and state = "MA"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1778 | 1778 | Eli Ashmun A000317 | sen | MA | 1816-01-01 | 1819-03-03 | 1 | Federalist | |||||||||||||
1843 | 1843 | Joshua Gage G000003 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 19 | |||||||||||||
1887 | 1887 | Benjamin Orr O000102 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 16 | |||||||||||||
1905 | 1905 | Thomas Rice R000204 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 18 | |||||||||||||
1915 | 1915 | Nathaniel Ruggles R000503 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 13 | |||||||||||||
1932 | 1932 | Solomon Strong S001017 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 12 | |||||||||||||
1952 | 1952 | John Wilson W000598 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 17 | |||||||||||||
1961 | 1961 | Benjamin Adams A000030 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 11 | |||||||||||||
2022 | 2022 | Walter Folger F000242 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2070 | 2070 | Jonathan Mason M000221 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 1 | |||||||||||||
2081 | 2081 | Marcus Morton M001019 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
2124 | 2124 | Zabdiel Sampson S000026 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
2128 | 2128 | Henry Shaw S000307 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2183 | 2183 | Elijah Mills M000774 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 5 | |||||||||||||
2347 | 2347 | Ezekiel Whitman W000421 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 15 | |||||||||||||
2415 | 2415 | Timothy Fuller F000413 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
2655 | 2655 | Enoch Lincoln L000314 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
2764 | 2764 | Samuel Allen A000146 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 6 | |||||||||||||
2929 | 2929 | Albion Parris P000079 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 20 | |||||||||||||
3132 | 3132 | John Holmes H000739 | rep | MA | 1817-12-01 | 1819-03-03 | Democratic Republican | 14 | |||||||||||||
3206 | 3206 | Nathaniel Silsbee S000411 | rep | MA | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
3498 | 3498 | Jeremiah Nelson N000036 | rep | MA | 1817-12-01 | 1819-03-03 | Federalist | 3 |
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);