legislator_terms

Table actions Table actions

481 rows where "end" is on date 1983-01-03

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, start, 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
31474 31474 B001209 sen VA 1977-01-04 1983-01-03 1 Independent       Democrat                  
31482 31482 C000120 sen NV 1977-01-04 1983-01-03 1 Democrat                          
31593 31593 H000384 sen CA 1977-01-04 1983-01-03 1 Republican                          
31792 31792 S000132 sen NM 1977-01-04 1983-01-03 1 Republican                          
32448 32448 A000220 rep OH 1981-01-05 1983-01-03   Republican 17                        
32459 32459 A000221 rep OH 1981-01-05 1983-01-03   Republican 17                        
32461 32461 A000329 rep PA 1981-01-05 1983-01-03   Republican 25                        
32466 32466 B000029 rep FL 1981-01-05 1983-01-03   Republican 10                        
32468 32468 B000037 rep PA 1981-01-05 1983-01-03   Democrat 21                        
32469 32469 B000047 rep MO 1981-01-05 1983-01-03   Republican 8                        
32474 32474 B000280 rep TN 1981-01-05 1983-01-03   Republican 6                        
32475 32475 B000358 rep WV 1981-01-05 1983-01-03   Republican 2                        
32478 32478 B000363 rep IN 1981-01-05 1983-01-03   Democrat 1                        
32487 32487 B000472 rep NY 1981-01-05 1983-01-03   Democrat 22                        
32491 32491 B000538 rep MI 1981-01-05 1983-01-03   Democrat 18                        
32508 32508 B000605 rep MO 1981-01-05 1983-01-03   Democrat 5                        
32513 32513 B000682 rep MS 1981-01-05 1983-01-03   Democrat 2                        
32521 32521 B000839 rep GA 1981-01-05 1983-01-03   Democrat 3                        
32525 32525 B000862 rep MI 1981-01-05 1983-01-03   Democrat 17                        
32534 32534 B000910 rep OH 1981-01-05 1983-01-03   Republican 7                        
32539 32539 B001080 rep CA 1981-01-05 1983-01-03   Republican 43                        
32544 32544 B001153 rep CA 1981-01-05 1983-01-03   Democrat 5                        
32550 32550 B001182 rep VA 1981-01-05 1983-01-03   Republican 6                        
32551 32551 C000158 rep NY 1981-01-05 1983-01-03   Republican 3                        
32558 32558 C000371 rep NY 1981-01-05 1983-01-03   Democrat 12                        
32568 32568 C000475 rep CA 1981-01-05 1983-01-03   Republican 2                        
32576 32576 C000638 rep TX 1981-01-05 1983-01-03   Republican 3                        
32582 32582 C000799 rep CT 1981-01-05 1983-01-03   Democrat 1                        
32583 32583 C000845 rep PA 1981-01-05 1983-01-03   Republican 8                        
32588 32588 D000037 rep VA 1981-01-05 1983-01-03   Republican 4                        
32594 32594 D000043 rep CA 1981-01-05 1983-01-03   Democrat 30                        
32595 32595 D000231 rep CT 1981-01-05 1983-01-03   Republican 3                        
32597 32597 D000183 rep IN 1981-01-05 1983-01-03   Republican 8                        
32610 32610 D000269 rep IL 1981-01-05 1983-01-03   Republican 4                        
32612 32612 D000446 rep PA 1981-01-05 1983-01-03   Republican 4                        
32613 32613 D000548 rep MI 1981-01-05 1983-01-03   Republican 6                        
32622 32622 E000175 rep ME 1981-01-05 1983-01-03   Republican 1                        
32624 32624 E000198 rep MN 1981-01-05 1983-01-03   Republican 1                        
32627 32627 E000208 rep PA 1981-01-05 1983-01-03   Democrat 17                        
32630 32630 E000233 rep GA 1981-01-05 1983-01-03   Democrat 8                        
32634 32634 E000239 rep IN 1981-01-05 1983-01-03   Democrat 6                        
32637 32637 E000258 rep DE 1981-01-05 1983-01-03   Republican 0                        
32641 32641 F000040 rep IL 1981-01-05 1983-01-03   Democrat 5                        
32645 32645 F000078 rep NJ 1981-01-05 1983-01-03   Republican 5                        
32656 32656 F000123 rep IL 1981-01-05 1983-01-03   Republican 20                        
32660 32660 F000161 rep IN 1981-01-05 1983-01-03   Democrat 2                        
32675 32675 F000319 rep NC 1981-01-05 1983-01-03   Democrat 2                        
32680 32680 G000226 rep GA 1981-01-05 1983-01-03   Democrat 1                        
32692 32692 G000268 rep CA 1981-01-05 1983-01-03   Republican 20                        
32694 32694 G000480 rep CA 1981-01-05 1983-01-03   Republican 33                        
32699 32699 G000537 rep OH 1981-01-05 1983-01-03   Republican 4                        
32703 32703 H000012 rep MN 1981-01-05 1983-01-03   Republican 2                        
32714 32714 H000440 rep MA 1981-01-05 1983-01-03   Republican 10                        
32716 32716 H000641 rep MS 1981-01-05 1983-01-03   Republican 4                        
32720 32720 H000719 rep SC 1981-01-05 1983-01-03   Democrat 5                        
32723 32723 H000722 rep NJ 1981-01-05 1983-01-03   Republican 9                        
32725 32725 J000074 rep KS 1981-01-05 1983-01-03   Republican 2                        
32726 32726 J000200 rep NC 1981-01-05 1983-01-03   Republican 6                        
32730 32730 L000547 rep NY 1981-01-05 1983-01-03   Republican 6                        
32733 32733 L000187 rep PA 1981-01-05 1983-01-03   Democrat 3                        
32735 32735 L000192 rep NY 1981-01-05 1983-01-03   Republican 33                        
32745 32745 M000136 rep PA 1981-01-05 1983-01-03   Republican 24                        
32756 32756 M000260 rep TX 1981-01-05 1983-01-03   Democrat 5                        
32766 32766 M000340 rep IL 1981-01-05 1983-01-03   Republican 13                        
32774 32774 M000343 rep CA 1981-01-05 1983-01-03   Republican 12                        
32779 32779 M000808 rep NY 1981-01-05 1983-01-03   Republican 31                        
32783 32783 M000839 rep CT 1981-01-05 1983-01-03   Democrat 6                        
32792 32792 M000845 rep WV 1981-01-05 1983-01-03   Democrat 1                        
32796 32796 M001044 rep OH 1981-01-05 1983-01-03   Democrat 23                        
32797 32797 N000005 rep SC 1981-01-05 1983-01-03   Republican 6                        
32798 32798 N000027 rep PA 1981-01-05 1983-01-03   Republican 11                        
32803 32803 P000280 rep NY 1981-01-05 1983-01-03   Democrat 23                        
32811 32811 R000012 rep IL 1981-01-05 1983-01-03   Republican 19                        
32825 32825 R000165 rep WI 1981-01-05 1983-01-03   Democrat 5                        
32840 32840 R000188 rep AZ 1981-01-05 1983-01-03   Republican 1                        
32844 32844 R000232 rep NY 1981-01-05 1983-01-03   Democrat 14                        
32845 32845 R000308 rep SD 1981-01-05 1983-01-03   Republican 2                        
32853 32853 R000469 rep CA 1981-01-05 1983-01-03   Republican 26                        
32857 32857 S000058 rep NV 1981-01-05 1983-01-03   Democrat 0                        
32858 32858 S000282 rep OH 1981-01-05 1983-01-03   Democrat 12                        
32859 32859 S000514 rep AL 1981-01-05 1983-01-03   Republican 6                        
32860 32860 S000579 rep PA 1981-01-05 1983-01-03   Democrat 3                        
32869 32869 S000804 rep OH 1981-01-05 1983-01-03   Republican 11                        
32870 32870 S000818 rep WV 1981-01-05 1983-01-03   Republican 3                        
32873 32873 S000935 rep MI 1981-01-05 1983-01-03   Republican 4                        
32882 32882 W000121 rep VA 1981-01-05 1983-01-03   Republican 9                        
32883 32883 W000235 rep OH 1981-01-05 1983-01-03   Republican 9                        
32892 32892 W000390 rep TX 1981-01-05 1983-01-03   Democrat 16                        
32896 32896 Z000002 rep NY 1981-01-05 1983-01-03   Democrat 15                        
32899 32899 A000076 rep MI 1981-01-05 1983-01-03   Democrat 10                        
32905 32905 A000207 rep NC 1981-01-05 1983-01-03   Democrat 4                        
32908 32908 B000422 rep AR 1981-01-05 1983-01-03   Republican 2                        
32920 32920 B001156 rep CA 1981-01-05 1983-01-03   Democrat 6                        
32923 32923 C000356 sen FL 1977-01-04 1983-01-03 1 Democrat                          
32933 32933 C000666 rep NY 1981-01-05 1983-01-03   Republican 35                        
32937 32937 C000773 rep IL 1981-01-05 1983-01-03   Republican 15                        
32941 32941 C000788 rep PR 1981-01-05 1983-01-03   New Progressive 0                        
32944 32944 C000871 rep IL 1981-01-05 1983-01-03   Republican 22                        
32949 32949 D000017 rep NH 1981-01-05 1983-01-03   Democrat 1                        
32959 32959 E000084 rep AL 1981-01-05 1983-01-03   Republican 1                        

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