legislator_terms

Table actions

Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette

30 rows where "end" is on date 1965-01-03 and start = "1959-01-07"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
26732 26732 James Beall B000271 sen MD 1959-01-07 1965-01-03 1 Republican                          
26780 26780 Harry Byrd B001208 sen VA 1959-01-07 1965-01-03 1 Democrat                          
26846 26846 Clair Engle E000181 sen CA 1959-01-07 1965-01-03 1 Democrat                          
26901 26901 Kenneth Keating K000036 sen NY 1959-01-07 1965-01-03 1 Republican                          
28416 28416 Thomas Dodd D000390 sen CT 1959-01-07 1965-01-03 1 Democrat                          
28433 28433 Albert Gore G000320 sen TN 1959-01-07 1965-01-03 1 Democrat                          
28472 28472 Spessard Holland H000720 sen FL 1959-01-07 1965-01-03 1 Democrat                          
28562 28562 Eugene McCarthy M000311 sen MN 1959-01-07 1965-01-03 1 Democrat                          
28613 28613 Winston Prouty P000552 sen VT 1959-01-07 1965-01-03 1 Republican                          
28741 28741 John Williams W000518 sen DE 1959-01-07 1965-01-03 1 Republican                          
28744 28744 Ralph Yarborough Y000006 sen TX 1959-01-07 1965-01-03 1 Democrat                          
28750 28750 Stephen Young Y000053 sen OH 1959-01-07 1965-01-03 1 Democrat                          
29773 29773 Hiram Fong F000245 sen HI 1959-01-07 1965-01-03 1 Republican                          
29836 29836 Philip Hart H000291 sen MI 1959-01-07 1965-01-03 1 Democrat                          
29839 29839 Rupert Hartke H000297 sen IN 1959-01-07 1965-01-03 1 Democrat                          
29845 29845 Roman Hruska H000875 sen NE 1959-01-07 1965-01-03 1 Republican                          
29908 29908 Michael Mansfield M000113 sen MT 1959-01-07 1965-01-03 1 Democrat                          
29927 29927 Gale McGee M000445 sen WY 1959-01-07 1965-01-03 1 Democrat                          
29987 29987 Frank Moss M001033 sen UT 1959-01-07 1965-01-03 1 Democrat                          
30007 30007 John Pastore P000100 sen RI 1959-01-07 1965-01-03 1 Democrat                          
30079 30079 Hugh Scott S000174 sen PA 1959-01-07 1965-01-03 1 Republican                          
30102 30102 William Symington S001136 sen MO 1959-01-07 1965-01-03 1 Democrat                          
31476 31476 Howard Cannon C000120 sen NV 1959-01-07 1965-01-03 1 Democrat                          
31688 31688 Edmund Muskie M001121 sen ME 1959-01-07 1965-01-03 1 Democrat                          
31895 31895 Harrison Williams W000502 sen NJ 1959-01-07 1965-01-03 1 Democrat                          
32679 32679 Barry Goldwater G000267 sen AZ 1959-01-07 1965-01-03 1 Republican                          
33006 33006 Henry Jackson J000013 sen WA 1959-01-07 1965-01-03 1 Democrat                          
33112 33112 William Proxmire P000553 sen WI 1959-01-07 1965-01-03 1 Democrat                          
33157 33157 John Stennis S000852 sen MS 1959-01-07 1965-01-03 1 Democrat                          
37954 37954 Robert Byrd B001210 sen WV 1959-01-07 1965-01-03 1 Democrat                          

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