legislator_terms

Table actions

20 rows where end = "1817-03-03", party = "Federalist" and state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
1470 1470 George Bradbury B000733 rep MA 1815-12-04 1817-03-03   Federalist 15                        
1477 1477 Elijah Brigham B000833 rep MA 1815-12-04 1817-03-03   Federalist 11                        
1479 1479 Benjamin Brown B000904 rep MA 1815-12-04 1817-03-03   Federalist 16                        
1489 1489 James Carr C000176 rep MA 1815-12-04 1817-03-03   Federalist 17                        
1587 1587 Christopher Gore G000322 sen MA 1815-12-04 1817-03-03 1 Federalist                          
1612 1612 John Hulbert H000935 rep MA 1815-12-04 1817-03-03   Federalist 7                        
1634 1634 Cyrus King K000197 rep MA 1815-12-04 1817-03-03   Federalist 14                        
1690 1690 Timothy Pickering P000324 rep MA 1815-12-04 1817-03-03   Federalist 2                        
1722 1722 Asahel Stearns S000821 rep MA 1815-12-04 1817-03-03   Federalist 4                        
1737 1737 Samuel Taggart T000012 rep MA 1815-12-04 1817-03-03   Federalist 6                        
1758 1758 Artemas Ward W000128 rep MA 1815-12-04 1817-03-03   Federalist 1                        
1765 1765 Laban Wheaton W000329 rep MA 1815-12-04 1817-03-03   Federalist 10                        
1904 1904 Thomas Rice R000204 rep MA 1815-12-04 1817-03-03   Federalist 18                        
1914 1914 Nathaniel Ruggles R000503 rep MA 1815-12-04 1817-03-03   Federalist 13                        
1931 1931 Solomon Strong S001017 rep MA 1815-12-04 1817-03-03   Federalist 12                        
1960 1960 Benjamin Adams A000030 rep MA 1815-12-04 1817-03-03   Federalist 11                        
2182 2182 Elijah Mills M000774 rep MA 1815-12-04 1817-03-03   Federalist 5                        
3497 3497 Jeremiah Nelson N000036 rep MA 1815-12-04 1817-03-03   Federalist 3                        
3610 3610 William Baylies B000256 rep MA 1815-12-04 1817-03-03   Federalist 8                        
4585 4585 John Reed R000121 rep MA 1815-12-04 1817-03-03   Federalist 9                        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, [caucus] TEXT, [url] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);