legislator_terms

Table actions Table actions

482 rows where "end" is on date 1971-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, class, party, 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
28420 28420 D000390 sen CT 1965-01-04 1971-01-03 1 Democrat                          
28437 28437 G000320 sen TN 1965-01-04 1971-01-03 1 Democrat                          
28476 28476 H000720 sen FL 1965-01-04 1971-01-03 1 Democrat                          
28566 28566 M000311 sen MN 1965-01-04 1971-01-03 1 Democrat                          
28589 28589 M001092 sen CA 1965-01-04 1971-01-03 1 Republican                          
28617 28617 P000552 sen VT 1965-01-04 1971-01-03 1 Republican                          
28735 28735 T000445 sen MD 1965-01-04 1971-01-03 1 Democrat                          
28745 28745 W000518 sen DE 1965-01-04 1971-01-03 1 Republican                          
28748 28748 Y000006 sen TX 1965-01-04 1971-01-03 1 Democrat                          
28754 28754 Y000053 sen OH 1965-01-04 1971-01-03 1 Democrat                          
29105 29105 G000282 sen NY 1968-09-10 1971-01-03 1 Republican   appointment                      
29115 29115 A000024 rep IN 1969-01-03 1971-01-03   Republican 4                        
29131 29131 A000229 rep OH 1969-01-03 1971-01-03   Republican 14                        
29142 29142 B000239 rep MA 1969-01-03 1971-01-03   Republican 6                        
29147 29147 B000241 rep MT 1969-01-03 1971-01-03   Republican 2                        
29161 29161 B000416 rep SD 1969-01-03 1971-01-03   Republican 2                        
29169 29169 B001155 rep UT 1969-01-03 1971-01-03   Republican 1                        
29171 29171 B001201 rep NY 1969-01-03 1971-01-03   Republican 29                        
29177 29177 C000019 rep NJ 1969-01-03 1971-01-03   Republican 6                        
29183 29183 C000596 rep CA 1969-01-03 1971-01-03   Democrat 7                        
29185 29185 C000823 rep KY 1969-01-03 1971-01-03   Republican 3                        
29193 29193 C000869 rep FL 1969-01-03 1971-01-03   Republican 8                        
29200 29200 C000991 rep NE 1969-01-03 1971-01-03   Republican 2                        
29206 29206 D000001 rep CT 1969-01-03 1971-01-03   Democrat 1                        
29220 29220 D000158 rep IL 1969-01-03 1971-01-03   Democrat 1                        
29222 29222 D000239 rep NE 1969-01-03 1971-01-03   Republican 1                        
29237 29237 E000266 rep TN 1969-01-03 1971-01-03   Democrat 8                        
29250 29250 F000012 rep MD 1969-01-03 1971-01-03   Democrat 4                        
29257 29257 F000015 rep NY 1969-01-03 1971-01-03   Democrat 19                        
29271 29271 F000060 rep OH 1969-01-03 1971-01-03   Democrat 20                        
29273 29273 F000272 rep NM 1969-01-03 1971-01-03   Republican 2                        
29282 29282 F000384 rep MD 1969-01-03 1971-01-03   Democrat 7                        
29294 29294 G000175 rep NY 1969-01-03 1971-01-03   Democrat 22                        
29304 29304 J000108 rep NJ 1969-01-03 1971-01-03   Democrat 8                        
29321 29321 K000244 rep OH 1969-01-03 1971-01-03   Democrat 19                        
29323 29323 K000264 rep ND 1969-01-03 1971-01-03   Republican 2                        
29332 29332 L000024 rep WI 1969-01-03 1971-01-03   Republican 7                        
29338 29338 L000069 rep MN 1969-01-03 1971-01-03   Republican 7                        
29347 29347 L000344 rep CA 1969-01-03 1971-01-03   Republican 24                        
29348 29348 L000477 rep NY 1969-01-03 1971-01-03   Democrat 5                        
29353 29353 M000010 rep MN 1969-01-03 1971-01-03   Republican 3                        
29357 29357 M000148 rep VA 1969-01-03 1971-01-03   Democrat 7                        
29363 29363 M000273 rep WA 1969-01-03 1971-01-03   Republican 4                        
29366 29366 M000318 rep NY 1969-01-03 1971-01-03   Democrat 39                        
29388 29388 M000364 rep MA 1969-01-03 1971-01-03   Democrat 9                        
29389 29389 M000530 rep NY 1969-01-03 1971-01-03   Republican 27                        
29391 29391 M000667 rep CT 1969-01-03 1971-01-03   Republican 6                        
29394 29394 M000832 rep KS 1969-01-03 1971-01-03   Republican 2                        
29400 29400 M001104 rep IL 1969-01-03 1971-01-03   Democrat 3                        
29403 29403 O000090 rep GA 1969-01-03 1971-01-03   Democrat 2                        
29408 29408 O000083 rep MT 1969-01-03 1971-01-03   Democrat 1                        
29422 29422 P000303 rep MA 1969-01-03 1971-01-03   Democrat 3                        
29424 29424 P000415 rep AK 1969-01-03 1971-01-03   Republican 0                        
29437 29437 P000477 rep NY 1969-01-03 1971-01-03   Democrat 18                        
29442 29442 R000152 rep SD 1969-01-03 1971-01-03   Republican 1                        
29460 29460 R000280 rep SC 1969-01-03 1971-01-03   Democrat 1                        
29470 29470 R000389 rep CO 1969-01-03 1971-01-03   Democrat 1                        
29478 29478 R000464 rep IN 1969-01-03 1971-01-03   Republican 5                        
29482 29482 R000508 rep IL 1969-01-03 1971-01-03   Republican 13                        
29487 29487 S000108 rep WI 1969-01-03 1971-01-03   Republican 1                        
29488 29488 S000602 sen IL 1969-09-17 1971-01-03 3 Republican   appointment                      
29492 29492 S000769 rep CT 1969-01-03 1971-01-03   Democrat 2                        
29501 29501 U000034 rep CA 1969-01-03 1971-01-03   Republican 35                        
29504 29504 W000192 rep PA 1969-01-03 1971-01-03   Republican 9                        
29508 29508 W000197 rep SC 1969-01-03 1971-01-03   Republican 2                        
29509 29509 W000671 rep WY 1969-01-03 1971-01-03   Republican 0                        
29525 29525 A000002 rep VA 1969-01-03 1971-01-03   Democrat 4                        
29540 29540 A000016 rep MS 1969-01-03 1971-01-03   Democrat 1                        
29544 29544 A000203 rep TN 1969-01-03 1971-01-03   Democrat 6                        
29560 29560 A000206 rep AL 1969-01-03 1971-01-03   Democrat 3                        
29572 29572 A000225 rep CO 1969-01-03 1971-01-03   Democrat 4                        
29582 29582 B000141 rep NV 1969-01-03 1971-01-03   Democrat 0                        
29584 29584 B000272 rep MD 1969-01-03 1971-01-03   Republican 6                        
29596 29596 B000323 rep OK 1969-01-03 1971-01-03   Republican 1                        
29607 29607 B000426 rep OH 1969-01-03 1971-01-03   Republican 8                        
29610 29610 B000548 rep TN 1969-01-03 1971-01-03   Democrat 7                        
29624 29624 B000594 rep LA 1969-01-03 1971-01-03   Democrat 2                        
29635 29635 B000676 rep OH 1969-01-03 1971-01-03   Republican 16                        
29640 29640 B000851 rep TN 1969-01-03 1971-01-03   Republican 3                        
29651 29651 B001212 rep PA 1969-01-03 1971-01-03   Democrat 3                        
29665 29665 B001216 rep WI 1969-01-03 1971-01-03   Republican 8                        
29669 29669 C000002 rep TX 1969-01-03 1971-01-03   Democrat 5                        
29671 29671 C000017 rep LA 1969-01-03 1971-01-03   Democrat 3                        
29697 29697 C000264 rep NY 1969-01-03 1971-01-03   Democrat 10                        
29717 29717 C000645 rep MS 1969-01-03 1971-01-03   Democrat 5                        
29733 29733 C000772 rep PA 1969-01-03 1971-01-03   Republican 18                        
29736 29736 C000775 rep PR 1969-01-03 1971-01-03   New Progressive 0                        
29750 29750 D000467 rep TX 1969-01-03 1971-01-03   Democrat 2                        
29758 29758 D000587 rep NJ 1969-01-03 1971-01-03   Republican 12                        
29768 29768 E000054 rep OK 1969-01-03 1971-01-03   Democrat 2                        
29772 29772 E000067 rep LA 1969-01-03 1971-01-03   Democrat 7                        
29774 29774 F000013 sen AZ 1965-01-04 1971-01-03 1 Republican                          
29777 29777 F000245 sen HI 1965-01-04 1971-01-03 1 Republican                          
29791 29791 F000422 rep PA 1969-01-03 1971-01-03   Republican 27                        
29794 29794 G000015 rep NC 1969-01-03 1971-01-03   Democrat 4                        
29801 29801 G000016 rep NJ 1969-01-03 1971-01-03   Democrat 13                        
29815 29815 G000071 rep MD 1969-01-03 1971-01-03   Democrat 3                        
29818 29818 G000458 rep MS 1969-01-03 1971-01-03   Democrat 3                        
29824 29824 H000010 rep GA 1969-01-03 1971-01-03   Democrat 1                        
29830 29830 H000049 rep MO 1969-01-03 1971-01-03   Republican 7                        

Next page

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