legislator_terms

105 rows where state = "TN" and type = "sen"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: class, party, url, address, phone, fax, contact_form, office, state_rank, rss_url, start (date), end (date)

Next page

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);