legislator_terms

Table actions

14 rows where party = "Republican", start = "1961-01-03" and type = "sen"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: end, start (date), end (date)

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
25883 25883 Henry Bridges B000823 sen NH 1961-01-03 1961-11-26 2 Republican                          
27190 27190 Henry Dworshak D000585 sen ID 1961-01-03 1963-01-03 2 Republican                          
27504 27504 Leverett Saltonstall S000021 sen MA 1961-01-03 1967-01-03 2 Republican                          
27518 27518 Andrew Schoeppel S000138 sen KS 1961-01-03 1962-01-21 2 Republican                          
28754 28754 Gordon Allott A000161 sen CO 1961-01-03 1967-01-03 2 Republican                          
28784 28784 James Boggs B000593 sen DE 1961-01-03 1967-01-03 2 Republican                          
28804 28804 John Cooper C000758 sen KY 1961-01-03 1967-01-03 2 Republican                          
28963 28963 Jack Miller M000730 sen IA 1961-01-03 1967-01-03 2 Republican                          
28995 28995 Karl Mundt M001078 sen SD 1961-01-03 1967-01-03 2 Republican                          
29046 29046 Margaret Smith S000590 sen ME 1961-01-03 1967-01-03 2 Republican                          
30228 30228 Clifford Case C000220 sen NJ 1961-01-03 1967-01-03 2 Republican                          
30272 30272 Carl Curtis C001006 sen NE 1961-01-03 1967-01-03 2 Republican                          
32343 32343 John Tower T000322 sen TX 1961-01-03 1967-01-03 2 Republican                          
36418 36418 J. Thurmond T000254 sen SC 1961-01-03 1967-01-03 2 Republican     [{"start": "1961-01-03", "end": "1964-09-16", "party": "Democrat"}, {"start": "1964-09-16", "end": "1967-01-03", "party": "Republican"}]                    

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